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 ??
