1 PACKAGE ast_colltrl_order_pkg AUTHID CURRENT_USER as
2 /* $Header: astclrqs.pls 115.18 2002/12/05 19:57:47 rramacha ship $ */
3 -- Start of comments
4 -- API name : open_order
5 -- Type : Private
6 -- Pre-reqs : None.
7 -- Function : initializes the order entry process for the current collateral registration flow
8
9 -- Parameters :
10 -- Version : Current version 1.0
11 -- Initial version 1.0
12
13 -- Extra Parameters
14 -- Collaterals are free orders. So there is not price information needed.
15 --, p_currency_code IN VARCHAR2
16 --, p_price_list_id IN NUMBER
17 --, p_invoice_party_id IN NUMBER
18 --, p_invoice_party_site_id IN NUMBER
19 -- End of comments
20
21 PROCEDURE open_order (
22 p_cust_party_id IN NUMBER
23 , p_cust_account_id IN NUMBER
24 , p_sold_to_contact_id IN NUMBER
25 , p_inv_party_id IN NUMBER
26 , p_inv_party_site_id IN NUMBER
27 , p_ship_party_site_id IN NUMBER
28 , p_source_code IN VARCHAR2
29 , p_order_type_id IN NUMBER
30 , p_employee_id IN NUMBER
31 , p_campaign_id IN NUMBER
32 , p_quote_header_id IN NUMBER DEFAULT NULL
33 ) ;
34 -- Start of comments
35 -- API name : add_order_line
36 -- Type : Private
37 -- Pre-reqs : None.
38 -- Function : adds a new line item to the current order entry process for the current collateral registration flow
39
40 -- Parameters :
41 -- Version : Current version 1.0
42 -- Initial version 1.0
43
44 -- Extra Parameters
45 -- Collaterals are free orders. So there is not price information needed.
46 --, p_line_list_price IN NUMBER
47 --, p_price_list_id IN NUMBER DEFAULT NULL
48 --, p_price_list_line_id IN NUMBER DEFAULT NULL
49 -- End of comments
50 PROCEDURE add_order_line (
51 p_ship_party_id IN NUMBER
52 , p_ship_party_site_id IN NUMBER
53 , p_inventory_item_id IN NUMBER
54 , p_quantity IN NUMBER
55 , p_ship_method_code IN VARCHAR2
56 , p_uom_code IN VARCHAR2
57 , p_line_category_code IN VARCHAR2
58 ) ;
59
60 -- Start of comments
61 -- API name : submit_order
62 -- Type : Private
63
64 -- Pre-reqs : None.
65 -- Function : submits the current order entry process for the current collateral
66 -- registration flow to the Oracle Order Entry module for validation,
67 -- processing and posting
68
69 -- Parameters :
70 -- Version : Current version 1.0
71 -- Initial version 1.0
72
73 -- Extra Parameters
74 -- Collaterals are free orders. So there is not price information needed.
75 -- p_payment_term_id IN NUMBER DEFAULT NULL
76 --, p_payment_amount IN NUMBER DEFAULT NULL
77 --, p_payment_type IN VARCHAR2 DEFAULT NULL
78 --, p_payment_option IN VARCHAR2 DEFAULT NULL
79 --, p_credit_card_code IN VARCHAR2 DEFAULT NULL
80 --, p_credit_card_holder_name IN VARCHAR2 DEFAULT NULL
81 --, p_payment_ref_number IN VARCHAR2 DEFAULT NULL
82 --, p_credit_card_approval IN VARCHAR2 DEFAULT NULL
83 --, p_credit_card_expiration IN DATE DEFAULT NULL
84 -- End of comments
85
86 PROCEDURE submit_order (
87 x_return_status OUT NOCOPY VARCHAR2
88 , x_order_header_rec OUT NOCOPY ASO_ORDER_INT.Order_Header_rec_type
89 , x_order_line_tbl OUT NOCOPY ASO_ORDER_INT.Order_Line_tbl_type
90 ) ;
91
92 -- Start of comments
93 -- API name : start_request
94 -- Type : Private
95
96 -- Pre-reqs : None.
97 -- Function : Starts a fulfilment request and returns the request id
98 -- to the client. This is a wrapper package procedure.
99 --
100
101 -- Parameters :
102 -- Version : Current version 1.0
103 -- Initial version 1.0
104
105 PROCEDURE start_request(l_request_id OUT NOCOPY NUMBER,
106 l_return_status OUT NOCOPY VARCHAR2,
107 l_msg_count OUT NOCOPY NUMBER,
108 l_msg_data OUT NOCOPY VARCHAR2);
109
110 -- Start of comments
111 -- API name : xml_request
112 -- Type : Private
113
114 -- Pre-reqs : None.
115 -- Function : This is a wrapper package procedure to call fulfillment
116 -- Get_Content_Xml. This inturn returns the xml generated
117 -- by the fulfillment API using the content id.
118
119 -- Parameters :
120 -- Version : Current version 1.0
121 -- Initial version 1.0
122
123 PROCEDURE xml_request(l_content_id IN NUMBER,
124 l_request_type IN VARCHAR2,
125 l_user_note IN VARCHAR2,
126 l_email IN VARCHAR2,
127 l_party_id IN NUMBER,
128 l_return_status OUT NOCOPY VARCHAR2,
129 l_content_xml OUT NOCOPY VARCHAR2,
130 l_msg_count OUT NOCOPY NUMBER,
131 l_msg_data OUT NOCOPY VARCHAR2,
132 l_request_id IN NUMBER);
133
134 -- Start of comments
135 -- API name : xml_request
136 -- Type : Private (Overloaded)
137
138 -- Pre-reqs : None.
139 -- Function : This is a wrapper package procedure to call fulfillment
140 -- Get_Content_Xml. This inturn returns the xml generated by
141 -- the fulfillment API using the content id with media type
142 -- and fax or printer or email information. This is over loaded.
143
144 -- Parameters :
145 -- Version : Current version 1.0
146 -- Initial version 1.0
147
148 PROCEDURE xml_request(p_content_id IN NUMBER,
149 p_request_type IN VARCHAR2,
150 p_media_type IN VARCHAR2 DEFAULT 'EMAIL',
151 p_user_note IN VARCHAR2,
152 p_email IN VARCHAR2,
153 p_fax IN VARCHAR2 DEFAULT NULL,
154 p_printer IN VARCHAR2 DEFAULT NULL,
155 p_party_id IN NUMBER DEFAULT NULL,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_content_xml OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_request_id IN NUMBER);
161
162 -- Start of comments
163 -- API name : submit_request
164 -- Type : Private
165
166 -- Pre-reqs : None.
167 -- Function : This is a wrapper package procedure to call fulfillment
168 -- submit request. This takes the final xml generated and
169 -- submitts the request to the fulfillment queue and returs
170 -- the status.
171
172 -- Parameters :
173 -- Version : Current version 1.0
174 -- Initial version 1.0
175
176 PROCEDURE submit_request(l_commit IN VARCHAR2,
177 l_return_status OUT NOCOPY VARCHAR2,
178 l_msg_count OUT NOCOPY NUMBER,
179 l_msg_data OUT NOCOPY VARCHAR2,
180 l_subject IN VARCHAR2,
181 l_source_code_id IN NUMBER,
182 l_party_id IN NUMBER,
183 l_user_id IN NUMBER,
184 l_extended_header IN VARCHAR2,
185 l_content_xml IN VARCHAR2,
186 l_request_id IN NUMBER);
187 END ast_colltrl_order_pkg;