APPS.RRS_BULKLOAD_ENTITIES dependencies on RRS_LOCATION_UA_INTF

Line 594: INSERT INTO RRS_LOCATION_UA_INTF

590: -- AND SITE_ID = l_usr_attr_data_tbl(i).PK_ID;
591: Write_conclog('ATTR_ID: '||l_usr_attr_data_tbl(i).ATTR_GROUP_ID);
592: Write_conclog('Site_ID: '||l_usr_attr_data_tbl(i).PK_ID);
593: ELSIF p_entity_name = 'RRS_LOCATION' THEN
594: INSERT INTO RRS_LOCATION_UA_INTF
595: (
596: DATA_SET_ID ,
597: TRANSACTION_ID ,
598: LOCATION_ID ,

Line 739: select count(*) from RRS_LOCATION_UA_INTF

735: select count(*) from RRS_SITE_UA_INTF
736: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
737: AND DATA_SET_ID = p_data_set_id;
738: CURSOR c_rrs_loc_ua_intf is
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

Line 893: UPDATE RRS_LOCATION_UA_INTF

889: Open c_rrs_loc_ua_intf;
890: Fetch c_rrs_loc_ua_intf into l_cnt;
891: Close c_rrs_loc_ua_intf;
892: IF l_cnt > 0 THEN
893: UPDATE RRS_LOCATION_UA_INTF
894: SET PROCESS_STATUS = G_PS_IN_PROCESS
895: ,REQUEST_ID = G_REQUEST_ID
896: ,PROGRAM_APPLICATION_ID = G_PROGAM_APPLICATION_ID
897: ,PROGRAM_ID = G_PROGAM_ID

Line 916: ,p_interface_table_name => 'RRS_LOCATION_UA_INTF' --IN VARCHAR2

912: ,p_application_id => 718 --IN NUMBER
913: ,p_attr_group_type => 'RRS_LOCATION_GROUP' --IN VARCHAR2
914: ,p_object_name => 'RRS_LOCATION' --IN VARCHAR2
915: ,p_hz_party_id => G_HZ_PARTY_ID
916: ,p_interface_table_name => 'RRS_LOCATION_UA_INTF' --IN VARCHAR2
917: ,p_data_set_id => p_data_set_id --IN NUMBER
918: ,p_entity_id => G_ENTITY_ID --IN NUMBER
919: ,p_entity_index => l_entity_index_counter --IN NUMBER
920: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2

Line 949: DELETE FROM RRS_LOCATION_UA_INTF

945: -----------------------------------------------
946: -- Delete all successful rows from the table --
947: -- (they're the only rows still in process) --
948: -----------------------------------------------
949: DELETE FROM RRS_LOCATION_UA_INTF
950: WHERE DATA_SET_ID = p_data_set_id
951: AND PROCESS_STATUS = G_PS_IN_PROCESS;
952: ELSE
953: ----------------------------------------------

Line 957: UPDATE RRS_LOCATION_UA_INTF

953: ----------------------------------------------
954: -- Mark all rows we've processed as success --
955: -- if they weren't marked as failure above --
956: ----------------------------------------------
957: UPDATE RRS_LOCATION_UA_INTF
958: SET PROCESS_STATUS = G_PS_SUCCESS
959: WHERE DATA_SET_ID = p_data_set_id
960: AND PROCESS_STATUS = G_PS_IN_PROCESS;
961: END IF;

Line 1082: UPDATE RRS_LOCATION_UA_INTF

1078: Open c_rrs_loc_ua_intf;
1079: fetch c_rrs_loc_ua_intf into l_cnt;
1080: Close c_rrs_loc_ua_intf;
1081: IF l_cnt > 0 THEN
1082: UPDATE RRS_LOCATION_UA_INTF
1083: SET PROCESS_STATUS = G_PS_GENERIC_ERROR
1084: WHERE DATA_SET_ID = p_data_set_id
1085: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1086: END IF;