APPS.RRS_BULKLOAD_ENTITIES dependencies on RRS_TRADEAREA_UA_INTF

Line 623: INSERT INTO RRS_TRADEAREA_UA_INTF

619: G_RRS_LOCATION_DATA_LEVEL_ID,
620: G_RRS_LOCATION_DATA_LEVEL
621: );
622: ELSIF p_entity_name = 'RRS_TRADE_AREA' THEN
623: INSERT INTO RRS_TRADEAREA_UA_INTF
624: (
625: DATA_SET_ID ,
626: TRANSACTION_ID ,
627: TRADE_AREA_ID ,

Line 743: SELECT COUNT(*) FROM RRS_TRADEAREA_UA_INTF

739: select count(*) from RRS_LOCATION_UA_INTF
740: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
741: AND DATA_SET_ID = p_data_set_id;
742: CURSOR c_rrs_ta_ua_intf is
743: SELECT COUNT(*) FROM RRS_TRADEAREA_UA_INTF
744: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
745: AND DATA_SET_ID = p_data_set_id;
746:
747: -------------------------------------------------------------

Line 968: UPDATE RRS_TRADEAREA_UA_INTF

964: Open c_rrs_ta_ua_intf;
965: fetch c_rrs_ta_ua_intf into l_cnt;
966: Close c_rrs_ta_ua_intf;
967: IF l_cnt > 0 THEN
968: UPDATE RRS_TRADEAREA_UA_INTF
969: SET PROCESS_STATUS = G_PS_IN_PROCESS
970: ,REQUEST_ID = G_REQUEST_ID
971: ,PROGRAM_APPLICATION_ID = G_PROGAM_APPLICATION_ID
972: ,PROGRAM_ID = G_PROGAM_ID

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

989: ,p_application_id => 718 --IN NUMBER
990: ,p_attr_group_type => 'RRS_TRADE_AREA_GROUP' --IN VARCHAR2
991: ,p_object_name => 'RRS_TRADE_AREA' --IN VARCHAR2
992: ,p_hz_party_id => G_HZ_PARTY_ID
993: ,p_interface_table_name => 'RRS_TRADEAREA_UA_INTF' --IN VARCHAR2
994: ,p_data_set_id => p_data_set_id --IN NUMBER
995: ,p_entity_id => G_ENTITY_ID --IN NUMBER
996: ,p_entity_index => l_entity_index_counter --IN NUMBER
997: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2

Line 1026: DELETE FROM RRS_TRADEAREA_UA_INTF

1022: -----------------------------------------------
1023: -- Delete all successful rows from the table --
1024: -- (they're the only rows still in process) --
1025: -----------------------------------------------
1026: DELETE FROM RRS_TRADEAREA_UA_INTF
1027: WHERE DATA_SET_ID = p_data_set_id
1028: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1029: ELSE
1030: ----------------------------------------------

Line 1034: UPDATE RRS_TRADEAREA_UA_INTF

1030: ----------------------------------------------
1031: -- Mark all rows we've processed as success --
1032: -- if they weren't marked as failure above --
1033: ----------------------------------------------
1034: UPDATE RRS_TRADEAREA_UA_INTF
1035: SET PROCESS_STATUS = G_PS_SUCCESS
1036: WHERE DATA_SET_ID = p_data_set_id
1037: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1038: END IF;

Line 1092: UPDATE RRS_TRADEAREA_UA_INTF

1088: Open c_rrs_ta_ua_intf;
1089: fetch c_rrs_ta_ua_intf into l_cnt;
1090: Close c_rrs_ta_ua_intf;
1091: IF l_cnt > 0 THEN
1092: UPDATE RRS_TRADEAREA_UA_INTF
1093: SET PROCESS_STATUS = G_PS_GENERIC_ERROR
1094: WHERE DATA_SET_ID = p_data_set_id
1095: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1096: END IF;