PACKAGE: APPS.JAI_PO_OSP_PKG

Source

1 PACKAGE jai_po_osp_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_po_osp.pls 120.2 2007/05/16 06:17:33 csahoo ship $ */
3 
4   PROCEDURE ja_in_57F4_process_header
5   (p_po_header_id    po_headers_all.po_header_id%type ,
6    p_po_release_id   po_releases_all.po_release_id%type,
7    p_vendor_id       po_vendors.vendor_id%type ,
8    p_vendor_site_id  po_vendor_sites_all.vendor_site_id%type,
9    p_called_from     varchar2
10    );
11 
12   PROCEDURE ja_in_57f4_lines_insert
13   (p_po_header_id    po_headers_all.po_header_id%type ,
14    p_po_line_id      po_lines_all.po_line_id%type ,
15    p_po_release_id   po_releases_all.po_release_id%type,
16    p_vendor_id       po_vendors.vendor_id%type ,
17    p_vendor_site_id  po_vendor_sites_all.vendor_site_id%type,
18    p_called_from     varchar2
19   );
20 
21   /* Start - Added by csahoo bug#5699863*/
22 	procedure cancel_osp
23 	(p_form_id         JAI_PO_OSP_HDRS.form_id%type
24 	);
25 	/* End - Added by csahoo for bug#5699863*/
26 
27   PROCEDURE create_rcv_57f4(
28     p_transaction_id                NUMBER,
29     p_process_status    OUT NOCOPY  VARCHAR2,
30     p_process_message   OUT NOCOPY  VARCHAR2
31   );
32 
33   PROCEDURE update_57f4_on_receiving
34   (
35     p_shipment_header_id	NUMBER,
36     p_shipment_line_id		NUMBER,
37     p_to_organization_id	NUMBER,
38     p_ship_to_location_id	NUMBER,
39     p_item_id				NUMBER,
40     p_tran_type						RCV_TRANSACTIONS.transaction_type%TYPE,
41     p_rcv_tran_qty					RCV_TRANSACTIONS.quantity%TYPE,
42     p_new_primary_unit_of_measure	RCV_SHIPMENT_LINES.primary_unit_of_measure%TYPE,
43     p_old_primary_unit_of_measure	RCV_SHIPMENT_LINES.primary_unit_of_measure%TYPE,
44     p_unit_of_measure				RCV_SHIPMENT_LINES.unit_of_measure%TYPE,
45     p_po_header_id			NUMBER,
46     p_po_release_id			NUMBER,
47     p_po_line_id			NUMBER,
48     p_po_line_location_id		NUMBER,
49     p_last_updated_by		NUMBER,
50     p_last_update_login		NUMBER,
51     p_creation_date			DATE
52   );
53 END jai_po_osp_pkg;