[Home] [Help]
270: select count(*) from RRS_SITE_UA_INTF
271: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
272: AND data_set_id = p_data_set_id;
273: CURSOR c_rrs_loc_ua_intf is
274: select count(*) from RRS_LOCATION_UA_INTF
275: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
276: AND data_set_id = p_data_set_id;
277: CURSOR c_rrs_ta_ua_intf is
278: SELECT count(*) FROM RRS_TRADEAREA_UA_INTF
524: Open c_rrs_loc_ua_intf;
525: Fetch c_rrs_loc_ua_intf into l_cnt;
526: Close c_rrs_loc_ua_intf;
527: IF l_cnt > 0 THEN
528: UPDATE RRS_LOCATION_UA_INTF
529: SET PROCESS_STATUS = G_PS_IN_PROCESS
530: ,REQUEST_ID = G_REQUEST_ID
531: ,PROGRAM_APPLICATION_ID = G_PROGAM_APPLICATION_ID
532: ,PROGRAM_ID = G_PROGAM_ID
555: ,p_application_id => 718 --IN NUMBER
556: ,p_attr_group_type => 'RRS_LOCATION_GROUP' --IN VARCHAR2
557: ,p_object_name => 'RRS_LOCATION' --IN VARCHAR2
558: ,p_hz_party_id => G_HZ_PARTY_ID
559: ,p_interface_table_name => 'RRS_LOCATION_UA_INTF' --IN VARCHAR2
560: ,p_data_set_id => p_data_set_id --IN NUMBER
561: ,p_entity_id => G_ENTITY_ID --IN NUMBER
562: ,p_entity_index => l_entity_index_counter --IN NUMBER
563: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
597: -----------------------------------------------
598: -- Delete all successful rows from the table --
599: -- (they're the only rows still in process) --
600: -----------------------------------------------
601: DELETE FROM RRS_LOCATION_UA_INTF
602: WHERE BATCH_ID = p_batch_id
603: AND PROCESS_STATUS = G_PS_IN_PROCESS;
604: ELSE
605: ----------------------------------------------
605: ----------------------------------------------
606: -- Mark all rows we've processed as success --
607: -- if they weren't marked as failure above --
608: ----------------------------------------------
609: UPDATE RRS_LOCATION_UA_INTF
610: SET PROCESS_STATUS = G_PS_SUCCESS
611: WHERE batch_id = p_batch_id
612: AND PROCESS_STATUS = G_PS_IN_PROCESS;
613: END IF;