APPS.JAI_PO_HOOK_PKG dependencies on RCV_HEADERS_INTERFACE

Line 971: FROM rcv_headers_interface

967: WHERE rtxn.HEADER_INTERFACE_ID = cp_hdr_intf_id;
968:
969: CURSOR c_hdr_interface(cp_hdr_intf_id IN NUMBER) IS
970: SELECT shipment_num
971: FROM rcv_headers_interface
972: WHERE HEADER_INTERFACE_ID = cp_hdr_intf_id;
973:
974: CURSOR c_po_hdr_currency(cp_po_header_id IN NUMBER) IS
975: SELECT CURRENCY_CODE

Line 1105: from rcv_headers_interface

1101: retcode OUT NOCOPY VARCHAR2
1102: ) IS
1103: CURSOR c_hdr_intf(cp_grp_id IN NUMBER) IS
1104: select shipment_num, asn_type, header_interface_id
1105: from rcv_headers_interface
1106: where group_id = cp_grp_id;
1107:
1108: lv_errbuf1 VARCHAR2(2000);
1109: lv_retcode1 VARCHAR2(200);

Line 1728: FROM rcv_headers_interface

1724: IF p_header_interface_id IS NULL
1725: THEN
1726: SELECT header_interface_id
1727: INTO lv_header_id
1728: FROM rcv_headers_interface
1729: WHERE shipment_num = p_shipment_num;
1730: END IF;
1731: /*bug 8400813*/
1732:

Line 1735: UPDATE rcv_headers_interface

1731: /*bug 8400813*/
1732:
1733: IF (p_mode = 'PENDING') THEN
1734:
1735: UPDATE rcv_headers_interface
1736: SET PROCESSING_STATUS_CODE = 'IL_PENDING'
1737: WHERE header_interface_id = lv_header_id
1738: AND PROCESSING_STATUS_CODE = 'PENDING';
1739:

Line 1747: UPDATE rcv_headers_interface

1743: AND PROCESSING_STATUS_CODE = 'PENDING';
1744:
1745: ELSIF p_mode = 'IL_PENDING' THEN
1746:
1747: UPDATE rcv_headers_interface
1748: SET PROCESSING_STATUS_CODE = 'PENDING'
1749: WHERE header_interface_id = lv_header_id
1750: AND PROCESSING_STATUS_CODE = 'IL_PENDING';
1751: