APPS.RRS_BULKLOAD_ENTITIES dependencies on RRS_TRADEAREA_UA_INTF

Line 616: INSERT INTO RRS_TRADEAREA_UA_INTF

612: G_RRS_LOCATION_DATA_LEVEL_ID,
613: G_RRS_LOCATION_DATA_LEVEL
614: );
615: ELSIF p_entity_name = 'RRS_TRADE_AREA' THEN
616: INSERT INTO RRS_TRADEAREA_UA_INTF
617: (
618: DATA_SET_ID ,
619: TRANSACTION_ID ,
620: TRADE_AREA_ID ,

Line 684: SELECT COUNT(*) FROM RRS_TRADEAREA_UA_INTF

680: select count(*) from RRS_LOCATION_UA_INTF
681: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
682: AND DATA_SET_ID = p_data_set_id;
683: CURSOR c_rrs_ta_ua_intf is
684: SELECT COUNT(*) FROM RRS_TRADEAREA_UA_INTF
685: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
686: AND DATA_SET_ID = p_data_set_id;
687: BEGIN
688:

Line 865: UPDATE RRS_TRADEAREA_UA_INTF

861: Open c_rrs_ta_ua_intf;
862: fetch c_rrs_ta_ua_intf into l_cnt;
863: Close c_rrs_ta_ua_intf;
864: IF l_cnt > 0 THEN
865: UPDATE RRS_TRADEAREA_UA_INTF
866: SET PROCESS_STATUS = G_PS_IN_PROCESS
867: ,REQUEST_ID = G_REQUEST_ID
868: ,PROGRAM_APPLICATION_ID = G_PROGAM_APPLICATION_ID
869: ,PROGRAM_ID = G_PROGAM_ID

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

886: ,p_application_id => 718 --IN NUMBER
887: ,p_attr_group_type => 'RRS_TRADE_AREA_GROUP' --IN VARCHAR2
888: ,p_object_name => 'RRS_TRADE_AREA' --IN VARCHAR2
889: ,p_hz_party_id => G_HZ_PARTY_ID
890: ,p_interface_table_name => 'RRS_TRADEAREA_UA_INTF' --IN VARCHAR2
891: ,p_data_set_id => p_data_set_id --IN NUMBER
892: ,p_entity_id => G_ENTITY_ID --IN NUMBER
893: ,p_entity_index => l_entity_index_counter --IN NUMBER
894: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2

Line 923: DELETE FROM RRS_TRADEAREA_UA_INTF

919: -----------------------------------------------
920: -- Delete all successful rows from the table --
921: -- (they're the only rows still in process) --
922: -----------------------------------------------
923: DELETE FROM RRS_TRADEAREA_UA_INTF
924: WHERE DATA_SET_ID = p_data_set_id
925: AND PROCESS_STATUS = G_PS_IN_PROCESS;
926: ELSE
927: ----------------------------------------------

Line 931: UPDATE RRS_TRADEAREA_UA_INTF

927: ----------------------------------------------
928: -- Mark all rows we've processed as success --
929: -- if they weren't marked as failure above --
930: ----------------------------------------------
931: UPDATE RRS_TRADEAREA_UA_INTF
932: SET PROCESS_STATUS = G_PS_SUCCESS
933: WHERE DATA_SET_ID = p_data_set_id
934: AND PROCESS_STATUS = G_PS_IN_PROCESS;
935: END IF;

Line 989: UPDATE RRS_TRADEAREA_UA_INTF

985: Open c_rrs_ta_ua_intf;
986: fetch c_rrs_ta_ua_intf into l_cnt;
987: Close c_rrs_ta_ua_intf;
988: IF l_cnt > 0 THEN
989: UPDATE RRS_TRADEAREA_UA_INTF
990: SET PROCESS_STATUS = G_PS_GENERIC_ERROR
991: WHERE DATA_SET_ID = p_data_set_id
992: AND PROCESS_STATUS = G_PS_IN_PROCESS;
993: END IF;