1 PACKAGE ast_event_order_pkg AUTHID CURRENT_USER as
2 /* $Header: astevoes.pls 115.6 2002/02/06 12:32:48 pkm ship $ */
3
4 -- Start of comments
5 -- API name : open_order
6 -- Type : Private
7 -- Pre-reqs : None.
8 -- Function : initializes the order entry process for the current event registration flow
9 -- Parameters :
10 -- Version : Current version 1.0
11 -- Initial version 1.0
12 -- End of comments
13 PROCEDURE open_order (
14 p_cust_party_id IN NUMBER
15 , p_cust_account_id IN NUMBER
16 , p_currency_code IN VARCHAR2
17 , p_source_code IN VARCHAR2 DEFAULT 'ASO'
18 , p_order_type_id IN NUMBER DEFAULT 1000 -- TBD How is it determined, its a FK to OE_TRANSACTION_TYPES_ALL
19 , p_price_list_id IN NUMBER
20 , p_employee_id IN NUMBER
21 , p_invoice_party_id IN NUMBER
22 , p_invoice_party_site_id IN NUMBER
23 , p_quote_header_id IN NUMBER DEFAULT NULL
24 ) ;
25 -- Start of comments
26 -- API name : add_order_line
27 -- Type : Private
28 -- Pre-reqs : None.
29 -- Function : adds a new line item to the current order entry process for the current event registration flow
30 -- Parameters :
31 -- Version : Current version 1.0
32 -- Initial version 1.0
33 -- End of comments
34 PROCEDURE add_order_line (
35 p_ship_party_id IN NUMBER
36 , p_ship_party_site_id IN NUMBER
37 , p_inventory_item_id IN NUMBER
38 , p_line_list_price IN NUMBER
39 , p_quantity IN NUMBER DEFAULT 1
40 , p_discount IN NUMBER DEFAULT NULL
41 , p_discount_uom IN VARCHAR2 DEFAULT NULL
42 , p_uom_code IN VARCHAR2 DEFAULT 'Ea'
43 , p_price_list_id IN NUMBER DEFAULT NULL
44 , p_price_list_line_id IN NUMBER DEFAULT NULL
45 ) ;
46 -- Start of comments
47 -- API name : submit_order
48 -- Type : Private
49 -- Pre-reqs : None.
50 -- Function : submits the current order entry process for the current event registration flow to the
51 -- Oracle Order Entry module for validation, processing and posting
52 -- Parameters :
53 -- Version : Current version 1.0
54 -- Initial version 1.0
55 -- End of comments
56 PROCEDURE submit_order (
57 p_payment_term_id IN NUMBER DEFAULT NULL
58 , p_payment_amount IN NUMBER DEFAULT NULL
59 , p_payment_type IN VARCHAR2 DEFAULT NULL
60 , p_payment_option IN VARCHAR2 DEFAULT NULL
61 , p_credit_card_code IN VARCHAR2 DEFAULT NULL
62 , p_credit_card_holder_name IN VARCHAR2 DEFAULT NULL
63 , p_payment_ref_number IN VARCHAR2 DEFAULT NULL
64 , p_credit_card_approval IN VARCHAR2 DEFAULT NULL
65 , p_credit_card_expiration IN DATE DEFAULT NULL
66 , p_total_discount IN NUMBER DEFAULT NULL
67 , p_total_discount_uom IN VARCHAR2 DEFAULT NULL
68 , x_return_status OUT VARCHAR2
69 , x_order_header_rec OUT ASO_ORDER_INT.Order_Header_rec_type
70 , x_order_line_tbl OUT ASO_ORDER_INT.Order_Line_tbl_type
71 ) ;
72 END ast_event_order_pkg;