APPS.RRS_SITE_UDA_BULKLOAD_INTF dependencies on RRS_TRADEAREA_UA_INTF

Line 278: SELECT count(*) FROM RRS_TRADEAREA_UA_INTF

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
279: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
280: AND data_set_id = p_data_set_id;
281: BEGIN
282:

Line 622: UPDATE RRS_TRADEAREA_UA_INTF

618: Open c_rrs_ta_ua_intf;
619: fetch c_rrs_ta_ua_intf into l_cnt;
620: Close c_rrs_ta_ua_intf;
621: IF l_cnt > 0 THEN
622: UPDATE RRS_TRADEAREA_UA_INTF
623: SET PROCESS_STATUS = G_PS_IN_PROCESS
624: ,REQUEST_ID = G_REQUEST_ID
625: ,PROGRAM_APPLICATION_ID = G_PROGAM_APPLICATION_ID
626: ,PROGRAM_ID = G_PROGAM_ID

Line 654: ,p_interface_table_name => 'RRS_TRADEAREA_UA_INTF' --IN VARCHAR2

650: ,p_application_id => 718 --IN NUMBER
651: ,p_attr_group_type => 'RRS_TRADE_AREA_GROUP' --IN VARCHAR2
652: ,p_object_name => 'RRS_TRADE_AREA' --IN VARCHAR2
653: ,p_hz_party_id => G_HZ_PARTY_ID
654: ,p_interface_table_name => 'RRS_TRADEAREA_UA_INTF' --IN VARCHAR2
655: ,p_data_set_id => p_data_set_id --IN NUMBER
656: ,p_entity_id => G_ENTITY_ID --IN NUMBER
657: ,p_entity_index => l_entity_index_counter --IN NUMBER
658: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2

Line 695: DELETE FROM RRS_TRADEAREA_UA_INTF

691: -----------------------------------------------
692: -- Delete all successful rows from the table --
693: -- (they're the only rows still in process) --
694: -----------------------------------------------
695: DELETE FROM RRS_TRADEAREA_UA_INTF
696: WHERE BATCH_ID = p_batch_id
697: AND PROCESS_STATUS = G_PS_IN_PROCESS;
698: ELSE
699: ----------------------------------------------

Line 703: UPDATE RRS_TRADEAREA_UA_INTF

699: ----------------------------------------------
700: -- Mark all rows we've processed as success --
701: -- if they weren't marked as failure above --
702: ----------------------------------------------
703: UPDATE RRS_TRADEAREA_UA_INTF
704: SET PROCESS_STATUS = G_PS_SUCCESS
705: WHERE batch_id = p_batch_id
706: AND PROCESS_STATUS = G_PS_IN_PROCESS;
707: END IF;