DBA Data[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;