APPS.ONT_ITM_PKG dependencies on WSH_ITM_REQUEST_CONTROL

Line 563: FROM WSH_ITM_REQUEST_CONTROL

559:
560: SELECT request_control_id
561: BULK COLLECT
562: INTO l_request_control_id_list
563: FROM WSH_ITM_REQUEST_CONTROL
564: WHERE application_id = 660
565: AND original_system_line_reference = p_line_id
566: AND original_system_reference = p_header_id -- Bug 11797031
567: AND Process_flag <> 4;

Line 983: -- Inserting Records in to wsh_itm_request_control

979: x_return_status := FND_API.G_RET_STS_ERROR;
980: RETURN;
981: END IF;
982:
983: -- Inserting Records in to wsh_itm_request_control
984:
985: -- If parent Country Check is needed we will insert one more record for
986: -- additional country check with country name
987:

Line 1005: SELECT wsh_itm_request_control_s.NEXTVAL

1001:
1002:
1003: FOR I in 1..l_rec_count LOOP
1004:
1005: SELECT wsh_itm_request_control_s.NEXTVAL
1006: INTO l_request_control_id
1007: FROM dual;
1008:
1009:

Line 1076: INSERT INTO WSH_ITM_REQUEST_CONTROL (

1072: Address_Table(1).add_contact_hz_party_id := NULL;
1073: Address_Table(1).add_contact_hz_party_number := NULL;
1074: END IF;
1075:
1076: INSERT INTO WSH_ITM_REQUEST_CONTROL (
1077: REQUEST_CONTROL_ID,
1078: REQUEST_SET_ID,
1079: APPLICATION_ID,
1080: MASTER_ORGANIZATION_ID,

Line 1238: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;

1234:
1235: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1236:
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1239: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1240: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1241: END IF;
1242:

Line 1512: FROM wsh_itm_request_control wrc

1508: IS
1509: SELECT request_control_id,response_header_id,organization_id,
1510: nvl(original_system_line_reference,0) line_id,
1511: nvl(original_system_reference,0) header_id --bug 4503620
1512: FROM wsh_itm_request_control wrc
1513: WHERE request_control_id = nvl(cp_request_control_id,0)
1514: AND wrc.application_id = 660
1515: UNION
1516: SELECT request_control_id,response_header_id,organization_id,

Line 1519: FROM wsh_itm_request_control wrc

1515: UNION
1516: SELECT request_control_id,response_header_id,organization_id,
1517: nvl(original_system_line_reference,0) line_id,
1518: nvl(original_system_reference,0) header_id --bug 4503620
1519: FROM wsh_itm_request_control wrc
1520: WHERE request_set_id = nvl(cp_request_set_id,0)
1521: AND wrc.application_id = 660;
1522:
1523: