PACKAGE: APPS.GML_RECV_TRANS_PKG

Source

1 PACKAGE GML_RECV_TRANS_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMLRTRNS.pls 115.5 2002/12/04 19:13:57 gmangari ship $ */
3 
4   PROCEDURE gml_insert_recv_interface(p_recv_id NUMBER, p_line_id NUMBER,
5                                       p_po_id NUMBER, p_poline_id NUMBER,
6                                 p_opm_item_id NUMBER, p_recv_qty1 NUMBER,
7                                 p_recv_um1 VARCHAR2,  p_dtl_recv_date DATE DEFAULT SYSDATE);
8 
9   PROCEDURE gml_adjust_recv_trans(p_recv_id IN NUMBER, p_line_id IN NUMBER,
10                                       p_po_id IN NUMBER, p_poline_id IN NUMBER,
11                                 p_opm_item_id IN NUMBER, p_recv_qty1 IN NUMBER,
12                                 p_old_recv_qty1 IN NUMBER,
13                                 p_recv_um1 IN VARCHAR2,
14                                 p_return_ind IN NUMBER,
15                                 p_recv_status IN NUMBER,
16                                 p_net_price IN NUMBER,
17 				p_rtrn_void_ind IN NUMBER);
18 
19   PROCEDURE gml_store_return_qty(p_return_qty1 IN NUMBER,
20                                  p_return_um1 IN VARCHAR2);
21 
22   PROCEDURE gml_insert_adjust_error(p_recv_id IN NUMBER, p_line_id IN NUMBER,
23                                     p_recv_qty1 IN NUMBER,
24                                     p_old_recv_qty1 IN NUMBER,
25                                     p_recv_um1 IN VARCHAR2,
26 				    p_return_ind IN NUMBER,
27 				    p_recv_status IN NUMBER,
28 				    p_rtrn_void_ind IN NUMBER);
29 
30   PROCEDURE gml_new_rcv_trans_insert(p_recv_id IN NUMBER, p_line_id IN NUMBER,
31 				    p_po_id IN NUMBER,p_poline_id IN NUMBER,
32                                     p_opm_item_id IN NUMBER,
33                                     p_recv_qty1 IN NUMBER,
34                                     p_old_recv_qty1 IN NUMBER,
35                                     p_recv_um1 IN VARCHAR2,
36 				    p_transaction_type IN VARCHAR2,
37 				    p_transaction_id IN NUMBER,
38 				    p_destination_type_code IN VARCHAR2,
39 				    p_header_interface_id IN NUMBER,
40 				    p_group_id IN NUMBER,
41 				    p_rcv_receipt_num IN po_recv_hdr.recv_no%TYPE,
42 				    p_header_flag IN NUMBER,
43 				    p_dtl_recv_date DATE DEFAULT SYSDATE);
44 
45   PROCEDURE gml_process_adjust_errors(retcode OUT NOCOPY NUMBER);
46 
47 
48 /* package variables */
49 G_header_interface_id      rcv_headers_interface.header_interface_id%TYPE;
50 G_group_id                 rcv_headers_interface.group_id%TYPE;
51 G_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
52 G_recv_id                  NUMBER DEFAULT 0;
53 G_ship_to_organization_id  po_line_locations_all.ship_to_organization_id%TYPE;
54 G_return_qty1              po_rtrn_dtl.return_qty1%TYPE;
55 G_return_um1               po_rtrn_dtl.return_um1%TYPE;
56 G_adjust_mode              VARCHAR2(6) DEFAULT 'NORMAL';
57 G_rows_inserted            NUMBER DEFAULT 0;
58 
59 END GML_RECV_TRANS_PKG;