APPS.JAI_PO_HOOK_PKG dependencies on RCV_HEADERS_INTERFACE

Line 879: FROM rcv_headers_interface

875: WHERE rtxn.HEADER_INTERFACE_ID = cp_hdr_intf_id;
876:
877: CURSOR c_hdr_interface(cp_hdr_intf_id IN NUMBER) IS
878: SELECT shipment_num
879: FROM rcv_headers_interface
880: WHERE HEADER_INTERFACE_ID = cp_hdr_intf_id;
881:
882: CURSOR c_po_hdr_currency(cp_po_header_id IN NUMBER) IS
883: SELECT CURRENCY_CODE

Line 990: from rcv_headers_interface

986: retcode OUT NOCOPY VARCHAR2
987: ) IS
988: CURSOR c_hdr_intf(cp_grp_id IN NUMBER) IS
989: select shipment_num, asn_type, header_interface_id
990: from rcv_headers_interface
991: where group_id = cp_grp_id;
992:
993: lv_errbuf1 VARCHAR2(2000);
994: lv_retcode1 VARCHAR2(200);

Line 1593: FROM rcv_headers_interface

1589:
1590: BEGIN
1591: SELECT header_interface_id
1592: INTO lv_header_id
1593: FROM rcv_headers_interface
1594: WHERE shipment_num = p_shipment_num;
1595:
1596: IF (p_mode = 'PENDING') THEN
1597:

Line 1598: UPDATE rcv_headers_interface

1594: WHERE shipment_num = p_shipment_num;
1595:
1596: IF (p_mode = 'PENDING') THEN
1597:
1598: UPDATE rcv_headers_interface
1599: SET PROCESSING_STATUS_CODE = 'IL_PENDING'
1600: WHERE header_interface_id = lv_header_id
1601: AND PROCESSING_STATUS_CODE = 'PENDING';
1602:

Line 1610: UPDATE rcv_headers_interface

1606: AND PROCESSING_STATUS_CODE = 'PENDING';
1607:
1608: ELSIF p_mode = 'IL_PENDING' THEN
1609:
1610: UPDATE rcv_headers_interface
1611: SET PROCESSING_STATUS_CODE = 'PENDING'
1612: WHERE header_interface_id = lv_header_id
1613: AND PROCESSING_STATUS_CODE = 'IL_PENDING';
1614: