Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HALT THE PROCESS OF SAVE INTERACTIVE GRID DATA

koushikreddy chinthalapaniOct 7 2024 — edited Oct 8 2024

I have IG and lets say I added two new rows

Step1: Created a Process Check Duplicates with Type Interactive Grid - Automatic Row Processing (DML)

DECLARE
l_response VARCHAR2(4000) := '';
BEGIN

CASE :APEX$ROW_STATUS
WHEN 'C' THEN
-- insert_debug_data(p1 => 1, p2 => :COUNTRY);
l_response := l_response || fnc_check_duplicate_party(
p_type => 'E',
p_str1 => :P2150_ENTITY_NAME,
p_str2 => :P2150_COUNTRY,
p_country => :COUNTRY
) || '; ';

   WHEN 'U' THEN  -- Updated  
     --  insert\_debug\_data(p1 => 2, p2 => :COUNTRY);  
       l\_response := l\_response || fnc\_check\_duplicate\_party(  
                         p\_type    => 'E',    
                         p\_str1    => :P2150\_ENTITY\_NAME,    
                         p\_str2    => :P2150\_COUNTRY,  
                         p\_country => :COUNTRY  
                     ) || '; ';    
                       
     --  APEX\_DEBUG.MESSAGE('l\_response: ' || l\_response);  

END CASE;

END;

This code captures Updated and Added rows in the IG
and i call a function which returns L_RESPONSE

STEP2 : Show the user this L_RESPONSE Message and ask a confirmation(Yes/No) for Saving the Grid

STEP3 : If Yes then Save the Grid Data

But the Problem is both these Processes runs on the Grid SAVE Button
How to HALT THE Actual Save Grid process which is not in our control

Any idea ??

Comments
Post Details
Added on Oct 7 2024
3 comments
430 views