APPS.ONT_ITM_PKG dependencies on WSH_ITM_REQUEST_CONTROL

Line 447: FROM WSH_ITM_REQUEST_CONTROL

443:
444: SELECT request_control_id
445: BULK COLLECT
446: INTO l_request_control_id_list
447: FROM WSH_ITM_REQUEST_CONTROL
448: WHERE application_id = 660
449: AND original_system_line_reference = p_line_id
450: AND Process_flag <> 4;
451:

Line 803: -- Inserting Records in to wsh_itm_request_control

799: x_return_status := FND_API.G_RET_STS_ERROR;
800: RETURN;
801: END IF;
802:
803: -- Inserting Records in to wsh_itm_request_control
804:
805: -- If parent Country Check is needed we will insert one more record for
806: -- additional country check with country name
807:

Line 825: SELECT wsh_itm_request_control_s.NEXTVAL

821:
822:
823: FOR I in 1..l_rec_count LOOP
824:
825: SELECT wsh_itm_request_control_s.NEXTVAL
826: INTO l_request_control_id
827: FROM dual;
828:
829:

Line 890: INSERT INTO WSH_ITM_REQUEST_CONTROL (

886: Address_table(1).add_party_fax := NULL;
887: Address_table(1).add_party_url := NULL;
888: END IF;
889:
890: INSERT INTO WSH_ITM_REQUEST_CONTROL (
891: REQUEST_CONTROL_ID,
892: REQUEST_SET_ID,
893: APPLICATION_ID,
894: MASTER_ORGANIZATION_ID,

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

1042:
1043: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1044:
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1047: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1048: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1049: END IF;
1050:

Line 1308: FROM wsh_itm_request_control wrc

1304: IS
1305: SELECT request_control_id,response_header_id,organization_id,
1306: nvl(original_system_line_reference,0) line_id,
1307: nvl(original_system_reference,0) header_id --bug 4503620
1308: FROM wsh_itm_request_control wrc
1309: WHERE request_control_id = nvl(cp_request_control_id,0)
1310: AND wrc.application_id = 660
1311: UNION
1312: SELECT request_control_id,response_header_id,organization_id,

Line 1315: FROM wsh_itm_request_control wrc

1311: UNION
1312: SELECT request_control_id,response_header_id,organization_id,
1313: nvl(original_system_line_reference,0) line_id,
1314: nvl(original_system_reference,0) header_id --bug 4503620
1315: FROM wsh_itm_request_control wrc
1316: WHERE request_set_id = nvl(cp_request_set_id,0)
1317: AND wrc.application_id = 660;
1318:
1319: