[Home] [Help]
PACKAGE: APPS.PO_FTE_INTEGRATION_GRP
Source
1 PACKAGE PO_FTE_INTEGRATION_GRP AS
2 /* $Header: POXGFTES.pls 120.0 2005/06/02 03:07:35 appldev noship $ */
3
4 TYPE po_release_rec_type IS RECORD (
5 source_blanket_reference_id NUMBER,
6 source_blanket_reference_num NUMBER,
7 release_revision NUMBER,
8 header_id NUMBER,
9 vendor_id NUMBER,
10 ship_from_site_id NUMBER,
11 hold_code VARCHAR2(1),
12 freight_terms_code VARCHAR2(30),
13 fob_point_code VARCHAR2(30),
14 source_header_number VARCHAR2(150),
15 source_header_type_id NUMBER,
16 source_header_type_name VARCHAR2(240),
17 org_id NUMBER,
18 currency_code VARCHAR2(15),
19 shipping_control VARCHAR2(30),
20 po_revision NUMBER,
21 line_id NUMBER,
22 inventory_item_id NUMBER,
23 item_description VARCHAR2(250),
24 hazard_class_id NUMBER,
25 revision VARCHAR2(3),
26 supplier_item_num VARCHAR2(30),
27 source_line_number VARCHAR2(150),
28 source_line_type_code VARCHAR2(30),
29 po_shipment_line_id NUMBER,
30 country_of_origin VARCHAR2(50),
31 ship_to_location_id NUMBER,
32 ship_tolerance_above NUMBER,
33 ship_tolerance_below NUMBER,
34 shipped_quantity NUMBER,
35 request_date DATE,
36 schedule_ship_date DATE,
37 organization_id NUMBER,
38 ordered_quantity NUMBER,
39 order_quantity_uom VARCHAR2(3),
40 cancelled_quantity NUMBER,
41 unit_list_price NUMBER,
42 preferred_grade VARCHAR2(150),-- INVCONV increased length to 150
43 ordered_quantity2 NUMBER,
44 ordered_quantity_uom2 VARCHAR2(3),
45 requested_quantity2 NUMBER,
46 cancelled_quantity2 NUMBER,
47 requested_quantity_uom2 VARCHAR2(3),
48 po_shipment_line_number NUMBER,
49 days_early_receipt_allowed NUMBER,
50 days_late_receipt_allowed NUMBER,
51 drop_ship_flag VARCHAR2(1),
52 qty_rcv_exception_code VARCHAR2(30),
53 closed_flag VARCHAR2(1),
54 closed_code VARCHAR2(30),
55 cancelled_flag VARCHAR2(1),
56 receipt_days_exception_code VARCHAR2(25),
57 enforce_ship_to_location_code VARCHAR2(25),
58 shipping_details_updated_on DATE,
59 carrier_id NUMBER,
60 net_weight NUMBER,
61 weight_uom_code VARCHAR2(3),
62 volume NUMBER,
63 volume_uom_code VARCHAR2(3)
64 );
65
66 -------------------------------------------------------------------------------
67 --Start of Comments
68 --Name: get_po_release_attributes
69 --Pre-reqs:
70 -- None.
71 --Modifies:
72 -- None.
73 --Locks:
74 -- None.
75 --Function:
76 -- Get attributes of Standard Purchase Order and Blanket Release for
77 -- Transportation delivery record.
78 --Parameters:
79 --IN:
80 --p_api_version
81 -- Specifies API version.
82 --p_line_location_id
83 -- Corresponding to po_line_location_id
84 --OUT:
85 --x_return_status
86 -- Indicates API return status as 'S', 'E' or 'U'.
87 --x_msg_count
88 -- Error messages number.
89 --x_msg_data
90 -- Error messages body.
91 --x_po_release_attributes
92 --Testing:
93 -- Call this API when only line_location_id exists.
94 --End of Comments
95 -------------------------------------------------------------------------------
96
97
98 PROCEDURE get_po_release_attributes
99 (
100 p_api_version IN NUMBER,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_line_location_id IN NUMBER,
105 x_po_releases_attributes OUT NOCOPY po_release_rec_type
106 );
107
108 -- Following wrappers for FTE Team to po_status_check API added in DropShip FPJ project
109
110 -- Detailed comments are in PVT Package Body PO_DOCUMENT_CHECKS_PVT.po_status_check
111 PROCEDURE po_status_check (
112 p_api_version IN NUMBER,
113 p_header_id IN PO_TBL_NUMBER,
114 p_release_id IN PO_TBL_NUMBER,
115 p_document_type IN PO_TBL_VARCHAR30,
116 p_document_subtype IN PO_TBL_VARCHAR30,
117 p_document_num IN PO_TBL_VARCHAR30,
118 p_vendor_order_num IN PO_TBL_VARCHAR30,
119 p_line_id IN PO_TBL_NUMBER,
120 p_line_location_id IN PO_TBL_NUMBER,
121 p_distribution_id IN PO_TBL_NUMBER,
122 p_mode IN VARCHAR2,
123 p_lock_flag IN VARCHAR2 := 'N',
124 x_po_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
125 x_return_status OUT NOCOPY VARCHAR2
126 );
127
128 -- Detailed comments are in PVT Package Body PO_DOCUMENT_CHECKS_PVT.po_status_check
129 PROCEDURE po_status_check (
130 p_api_version IN NUMBER,
131 p_header_id IN NUMBER := NULL,
132 p_release_id IN NUMBER := NULL,
133 p_document_type IN VARCHAR2 := NULL,
134 p_document_subtype IN VARCHAR2 := NULL,
135 p_document_num IN VARCHAR2 := NULL,
136 p_vendor_order_num IN VARCHAR2 := NULL,
137 p_line_id IN NUMBER := NULL,
138 p_line_location_id IN NUMBER := NULL,
139 p_distribution_id IN NUMBER := NULL,
140 p_mode IN VARCHAR2,
141 p_lock_flag IN VARCHAR2 := 'N',
142 x_po_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
143 x_return_status OUT NOCOPY VARCHAR2
144 );
145
146
147 END PO_FTE_INTEGRATION_GRP;