[Home] [Help]
PACKAGE: APPS.PO_OM_INTEGRATION_GRP
Source
1 PACKAGE PO_OM_INTEGRATION_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGOMIS.pls 120.1 2005/08/26 13:51:28 dreddy noship $*/
3
4 -- Detailed comments maintained in the Package Body PO_OM_INTEGRATION_GRP.update_req_po
5 PROCEDURE update_req_po
6 (
7 p_api_version IN NUMBER,
8 p_req_header_id IN PO_TBL_NUMBER,
9 p_req_line_id IN PO_TBL_NUMBER,
10 p_po_header_id IN PO_TBL_NUMBER := NULL,
11 p_po_release_id IN PO_TBL_NUMBER := NULL,
12 p_po_line_id IN PO_TBL_NUMBER := NULL,
13 p_po_line_location_id IN PO_TBL_NUMBER := NULL,
14 p_quantity IN PO_TBL_NUMBER := NULL,
15 p_secondary_quantity IN PO_TBL_NUMBER := NULL,
16 p_need_by_date IN PO_TBL_DATE := NULL,
17 p_ship_to_location_id IN PO_TBL_NUMBER := NULL,
18 p_sales_order_update_date IN PO_TBL_DATE := NULL,
19 p_preferred_grade IN PO_TBL_VARCHAR240 := NULL, /* INVCONV SSCHINCH 09/07/04*/
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2
23 )
24 ;
25
26
27 -- Detailed comments maintained in the Package Body PO_OM_INTEGRATION_GRP.cancel_req_po
28 PROCEDURE cancel_req_po
29 (
30 p_api_version IN NUMBER,
31 p_req_header_id IN PO_TBL_NUMBER,
32 p_req_line_id IN PO_TBL_NUMBER,
33 p_po_header_id IN PO_TBL_NUMBER := NULL,
34 p_po_release_id IN PO_TBL_NUMBER := NULL,
35 p_po_line_id IN PO_TBL_NUMBER := NULL,
36 p_po_line_location_id IN PO_TBL_NUMBER := NULL,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2
40 )
41 ;
42
43 -- <VM_DP FPJ START>
44
45 PROCEDURE Purge
46 ( p_api_version IN NUMBER
47 ,p_init_msg_list IN VARCHAR2
48 ,p_commit IN VARCHAR2
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 ,p_entity IN VARCHAR2
53 ,p_entity_id_tbl IN PO_TBL_NUMBER
54 );
55
56 PROCEDURE Validate_Purge
57 ( p_api_version IN NUMBER
58 ,p_init_msg_list IN VARCHAR2
59 ,p_commit IN VARCHAR2
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 ,p_entity IN VARCHAR2
64 ,p_entity_id_tbl IN PO_TBL_NUMBER
65 ,x_purge_allowed_tbl OUT NOCOPY PO_TBL_VARCHAR1
66 );
67
68 -- <VM_DP FPJ END>
69 PROCEDURE get_drop_ship_details(p_api_version IN NUMBER,
70 p_line_location_id IN NUMBER,
71 x_customer_name OUT NOCOPY VARCHAR2,
72 x_customer_contact OUT NOCOPY VARCHAR2,
73 x_shipping_method OUT NOCOPY VARCHAR2,
74 x_shipping_instructions OUT NOCOPY VARCHAR2,
75 x_packing_instructions OUT NOCOPY VARCHAR2,
76 x_so_num OUT NOCOPY VARCHAR2,
77 x_so_line_num OUT NOCOPY VARCHAR2,
78 x_so_status OUT NOCOPY VARCHAR2,
79 x_ordered_qty OUT NOCOPY NUMBER,
80 x_shipped_qty OUT NOCOPY NUMBER,
81 x_customer_po_number OUT NOCOPY VARCHAR2,
82 x_customer_po_line_num OUT NOCOPY VARCHAR2,
83 x_customer_po_shipment_num OUT NOCOPY VARCHAR2,
84 x_customer_item_desc OUT NOCOPY VARCHAR2,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_return_status OUT NOCOPY VARCHAR2 );
88
89
90 END PO_OM_INTEGRATION_GRP;