1 PACKAGE GML_PO_RECV2_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMLRCMVS.pls 115.4 1999/11/23 13:36:06 pkm ship $ */
3
4 PROCEDURE get_oracle_id
5 ( v_po_id IN po_ordr_hdr.po_id%TYPE,
6 v_line_id IN po_ordr_dtl.line_id%TYPE,
7 v_po_header_id OUT cpg_oragems_mapping.po_header_id%TYPE,
8 v_po_line_id OUT cpg_oragems_mapping.po_line_id%TYPE,
9 v_line_location_id OUT cpg_oragems_mapping.po_line_location_id%TYPE,
10 v_po_release_id OUT cpg_oragems_mapping.po_release_id%TYPE);
11
12 PROCEDURE update_header_status
13 ( v_po_header_id IN NUMBER,
14 v_org_id IN NUMBER,
15 v_last_updated_by IN NUMBER,
16 v_last_update_date IN DATE );
17 PROCEDURE update_line_status
18 ( v_po_header_id IN NUMBER,
19 v_po_line_id IN NUMBER,
20 v_org_id IN NUMBER,
21 v_last_updated_by IN NUMBER,
22 v_last_update_date IN DATE );
23
24 PROCEDURE update_release_status
25 ( v_po_header_id IN NUMBER,
26 v_po_release_id IN NUMBER,
27 v_org_id IN NUMBER,
28 v_last_updated_by IN NUMBER,
29 v_last_update_date IN DATE );
30
31 PROCEDURE update_line_locations
32 ( v_po_header_id IN cpg_oragems_mapping.po_header_id%TYPE,
33 v_po_line_id IN cpg_oragems_mapping.po_line_id%TYPE,
34 v_line_location_id IN cpg_oragems_mapping.po_line_location_id%TYPE,
35 v_po_release_id IN cpg_oragems_mapping.po_release_id%TYPE,
36 v_org_id IN gl_plcy_mst.org_id%TYPE,
37 v_po_status IN po_ordr_dtl.po_status%TYPE,
38 v_received_qty IN po_recv_dtl.recv_qty1%TYPE,
39 v_returned_qty IN po_rtrn_dtl.return_qty1%TYPE,
40 v_created_by IN po_recv_dtl.created_by%TYPE,
41 v_timestamp IN cpg_oragems_mapping.time_stamp%TYPE);
42
43
44
45 END GML_PO_RECV2_PKG;