[Home] [Help]
PACKAGE: APPS.PON_AUCTION_CREATE_PO_PKG
Source
1 PACKAGE PON_AUCTION_CREATE_PO_PKG as
2 /* $Header: PONCRPOS.pls 120.6 2007/06/22 12:15:47 tarkumar ship $ */
3
4 TYPE SumOfReqLineAllocQuantities is TABLE OF NUMBER
5 INDEX BY BINARY_INTEGER;
6
7 TYPE PDOIheader IS RECORD (
8 auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
9 document_number pon_auction_headers_all.document_number%TYPE,
10 org_id pon_auction_headers_all.org_id%TYPE,
11 contract_type pon_auction_headers_all.contract_type%TYPE,
12 language_code pon_auction_headers_all.language_code%TYPE,
13 po_start_date pon_auction_headers_all.po_start_date%TYPE,
14 po_end_date pon_auction_headers_all.po_end_date%TYPE,
15 currency_code pon_auction_headers_all.currency_code%TYPE,
16 fob_code pon_auction_headers_all.fob_code%TYPE,
17 freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
18 carrier_code pon_auction_headers_all.carrier_code%TYPE,
19 payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
20 ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
21 bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
22 auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
23 source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,
24 bid_number pon_bid_headers.bid_number%TYPE,
25 order_number pon_bid_headers.order_number%TYPE,
26 vendor_id pon_bid_headers.vendor_id%TYPE,
27 vendor_site_id pon_bid_headers.vendor_site_id%TYPE,
28 agent_id pon_bid_headers.agent_id%TYPE,
29 global_agreement_flag pon_auction_headers_all.global_agreement_flag%TYPE,
30 po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,
31 po_agreed_amount pon_bid_headers.po_agreed_amount%TYPE,
32 bid_currency_code pon_bid_headers.bid_currency_code%TYPE,
33 rate_type pon_auction_headers_all.rate_type%TYPE,
34 rate_date pon_auction_headers_all.rate_date%TYPE,
35 rate_dsp pon_bid_headers.rate_dsp%TYPE,
36 create_sourcing_rules pon_bid_headers.create_sourcing_rules%TYPE,
37 update_sourcing_rules pon_bid_headers.update_sourcing_rules%TYPE,
38 release_method pon_bid_headers.release_method%TYPE,
39 initiate_approval pon_bid_headers.initiate_approval%TYPE,
40 acceptance_required_flag pon_bid_headers.acceptance_required_flag%TYPE,
41 po_style_id pon_auction_headers_all.po_style_id%TYPE,
42 progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE,
43 supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE
44 );
45
46 TYPE PDOIline IS RECORD (
47 line_number pon_auction_item_prices_all.line_number%TYPE,
48 line_type_id pon_auction_item_prices_all.line_type_id%TYPE,
49 order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE,
50 line_origination_code pon_auction_item_prices_all.line_origination_code%TYPE,
51 item_id pon_auction_item_prices_all.item_id%TYPE,
52 item_revision pon_auction_item_prices_all.item_revision%TYPE,
53 category_id pon_auction_item_prices_all.category_id%TYPE,
54 item_description pon_auction_item_prices_all.item_description%TYPE,
55 unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE,
56 ship_to_location_id pon_auction_item_prices_all.ship_to_location_id%TYPE,
57 need_by_start_date pon_auction_item_prices_all.need_by_start_date%TYPE,
58 award_quantity pon_bid_item_prices.award_quantity%TYPE,
59 po_min_rel_amount pon_auction_item_prices_all.po_min_rel_amount%TYPE,
60 has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,
61 bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,
62 promised_date pon_bid_item_prices.promised_date%TYPE,
63 job_id pon_auction_item_prices_all.job_id%TYPE,
64 po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,
65 purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,
66 bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,
67 recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,
68 progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,
69 retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%TYPE,
70 bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
71 has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
72 award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE
73 );
74
75 procedure AUTO_ALLOC_AND_SPLIT_REQ(p_auction_header_id IN NUMBER, -- 1
76 p_user_name IN VARCHAR2, -- 2
77 p_user_id IN NUMBER, -- 3
78 p_formatted_name IN VARCHAR2, -- 4
79 p_auction_title IN VARCHAR2, -- 5
80 p_organization_name IN VARCHAR2,
81 p_resultout OUT NOCOPY VARCHAR2,
82 x_allocation_error OUT NOCOPY VARCHAR2,
83 x_line_number OUT NOCOPY NUMBER,
84 x_item_number OUT NOCOPY VARCHAR2,
85 x_item_description OUT NOCOPY VARCHAR2,
86 x_item_revision OUT NOCOPY VARCHAR2,
87 x_requisition_number OUT NOCOPY VARCHAR2,
88 x_job_name OUT NOCOPY VARCHAR2,
89 x_document_disp_line_number OUT NOCOPY VARCHAR2);
90
91
92 procedure ALLOC_ALL_UNALLOC_ITEMS(p_auction_header_id IN NUMBER,
93 p_allocation_result OUT NOCOPY VARCHAR2,
94 p_failure_reason OUT NOCOPY VARCHAR2,
95 p_item_line_number OUT NOCOPY NUMBER,
96 p_item_number OUT NOCOPY VARCHAR2,
97 p_item_description OUT NOCOPY VARCHAR2,
98 p_item_revision OUT NOCOPY VARCHAR2,
99 p_requisition_number OUT NOCOPY VARCHAR2,
100 p_job_name OUT NOCOPY VARCHAR2,
101 p_document_disp_line_number OUT NOCOPY VARCHAR2);
102
103 PROCEDURE SPLIT_REQ_LINES(p_auction_header_id IN NUMBER,
104 p_split_result OUT NOCOPY VARCHAR2,
105 p_split_failure_reason OUT NOCOPY VARCHAR2,
106 p_item_line_number OUT NOCOPY NUMBER,
107 p_item_number OUT NOCOPY VARCHAR2,
108 p_item_description OUT NOCOPY VARCHAR2,
109 p_item_revision OUT NOCOPY VARCHAR2,
110 p_requisition_number OUT NOCOPY VARCHAR2,
111 p_job_name OUT NOCOPY VARCHAR2);
112
113 PROCEDURE Auto_Req_Allocation(p_auctionID IN NUMBER,
114 p_line_number IN NUMBER,
115 p_result OUT NOCOPY VARCHAR2,
116 p_error_message OUT NOCOPY VARCHAR2);
117
118
119 PROCEDURE START_PO_WORKFLOW(p_auction_header_id IN NUMBER, -- 1
120 p_user_name IN VARCHAR2, -- 2
121 p_user_id IN NUMBER, -- 3
122 p_formatted_name IN VARCHAR2, -- 4
123 p_auction_title IN VARCHAR2, -- 5
124 p_organization_name IN VARCHAR2,
125 p_email_type IN VARCHAR2,
126 p_itemkey IN VARCHAR2,
127 x_allocation_error OUT NOCOPY VARCHAR2,
128 x_line_number OUT NOCOPY NUMBER,
129 x_item_number OUT NOCOPY VARCHAR2,
130 x_item_description OUT NOCOPY VARCHAR2,
131 x_item_revision OUT NOCOPY VARCHAR2,
132 x_requisition_number OUT NOCOPY VARCHAR2,
133 x_job_name OUT NOCOPY VARCHAR2,
134 x_document_disp_line_number OUT NOCOPY VARCHAR2);
135
136 PROCEDURE START_PO_CREATION(EFFBUF OUT NOCOPY VARCHAR2, -- std. out param for concurrent program
137 RETCODE OUT NOCOPY VARCHAR2, -- std. out param for concurrent program
138 p_auction_header_id IN NUMBER, -- 1
139 p_user_name IN VARCHAR2, -- 2
140 p_user_id IN NUMBER, -- 3
141 p_formatted_name IN VARCHAR2, -- 4
142 p_auction_title IN VARCHAR2, -- 5
143 p_organization_name IN VARCHAR2, -- 6
144 p_resultout OUT NOCOPY VARCHAR2); -- 7
145
146 procedure GENERATE_POS(p_auction_header_id IN NUMBER, -- 1
147 p_user_name IN VARCHAR2, -- 2
148 p_user_id IN NUMBER, -- 3
149 p_resultout OUT NOCOPY VARCHAR2);
150
151
152 PROCEDURE CREATE_PO_STRUCTURE(p_auction_header_id IN NUMBER,
153 p_bid_number IN NUMBER,
154 p_user_id IN NUMBER,
155 p_interface_header_id OUT NOCOPY NUMBER,
156 p_pdoi_header OUT NOCOPY PDOIheader,
157 p_error_code OUT NOCOPY VARCHAR2,
158 p_error_message OUT NOCOPY VARCHAR2);
159
160
161 PROCEDURE LAUNCH_PO_APPROVAL (p_po_header_id IN NUMBER,
162 p_pdoi_header IN PDOIheader,
163 p_user_id IN NUMBER
164 );
165
166 PROCEDURE CHECK_PO_STATUS(itemtype IN VARCHAR2,
167 itemkey IN VARCHAR2,
168 actid IN NUMBER,
169 uncmode IN VARCHAR2,
170 resultout OUT NOCOPY VARCHAR2);
171
172
173 PROCEDURE GENERATE_PO_SUCCESS_EMAIL(document_id IN VARCHAR2,
174 display_type IN VARCHAR2,
175 document IN OUT NOCOPY VARCHAR2,
176 document_type IN OUT NOCOPY VARCHAR2);
177
178 PROCEDURE GENERATE_PO_FAILURE_EMAIL(document_id IN VARCHAR2,
179 display_type IN VARCHAR2,
180 document IN OUT NOCOPY VARCHAR2,
181 document_type IN OUT NOCOPY VARCHAR2);
182
183
184 procedure CHECK_PO_EMAIL_TYPE (itemtype IN VARCHAR2,
185 itemkey IN VARCHAR2,
186 actid IN NUMBER,
187 uncmode IN VARCHAR2,
188 resultout OUT NOCOPY VARCHAR2);
189
190 PROCEDURE INSERT_IP_DESCRIPTORS(p_auction_header_id IN NUMBER,
191 p_bid_number IN NUMBER,
192 p_interface_header_id IN NUMBER,
193 p_user_id IN NUMBER,
194 p_login_id IN NUMBER,
195 p_batch_start IN NUMBER,
196 p_batch_end IN NUMBER);
197
198 END PON_AUCTION_CREATE_PO_PKG;