1 PACKAGE IBE_MinisiteRuntime_PVT AS
2 /* $Header: IBEVMSRS.pls 120.2 2005/10/03 16:25:14 htian noship $ */
3
4 -- HISTORY
5 -- 12/12/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
6 -- 07/20/02 JQU Added Get_Quote_Details procedure
7 -- *********************************************************************************
8
9 TYPE lang_cur_type IS REF CURSOR;
10 TYPE currency_cur_type IS REF CURSOR;
11 TYPE sections_cur_type IS REF CURSOR;
12 TYPE items_cur_type IS REF CURSOR;
13 TYPE minisite_cur_type IS REF CURSOR;
14 TYPE attr_cur_type IS REF CURSOR;
15 TYPE name_cur_type IS REF CURSOR;
16 TYPE master_msite_cur_type IS REF CURSOR;
17 TYPE msite_resp_cur_type IS REF CURSOR;
18 TYPE msite_prty_access_cur_type IS REF CURSOR;
19 TYPE pm_cc_sm_cur_type IS REF CURSOR;
20 TYPE ship_method_cur_type IS REF CURSOR;
21 TYPE payment_method_cur_type IS REF CURSOR;
22 TYPE quote_detail_cur_type IS REF CURSOR;
23
24 PROCEDURE Get_Msite_Details
25 (
26 p_api_version IN NUMBER,
27 p_msite_id IN NUMBER,
28 p_access_name IN VARCHAR2,
29 x_master_msite_id OUT NOCOPY NUMBER,
30 x_minisite_cur OUT NOCOPY minisite_cur_type,
31 x_lang_cur OUT NOCOPY lang_cur_type,
32 x_currency_cur OUT NOCOPY currency_cur_type,
33 x_sections_cur OUT NOCOPY sections_cur_type,
34 x_items_cur OUT NOCOPY items_cur_type,
35 x_name_cur OUT NOCOPY name_cur_type ,
36 x_msite_resps_cur OUT NOCOPY msite_resp_cur_type ,
37 x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
38 x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE Get_Quote_Details
45 (
46 p_api_version IN NUMBER,
47 p_quote_id IN NUMBER,
48 x_ship_method_cur OUT NOCOPY ship_method_cur_type,
49 x_payment_method_cur OUT NOCOPY payment_method_cur_type,
50 x_quote_detail_cur OUT NOCOPY quote_detail_cur_type,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE Load_Msite_List_Details
57 (
58 p_api_version IN NUMBER,
59 p_msite_ids IN JTF_NUMBER_TABLE,
60 x_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
61 x_master_msite_id OUT NOCOPY NUMBER,
62 x_minisite_cur OUT NOCOPY minisite_cur_type,
63 x_name_cur OUT NOCOPY name_cur_type,
64 x_lang_cur OUT NOCOPY lang_cur_type,
65 x_currency_cur OUT NOCOPY currency_cur_type,
66 x_msite_resps_cur OUT NOCOPY msite_resp_cur_type,
67 x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
68 x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
69 x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
70 x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
71 x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
72 x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2
76 );
77
78 END IBE_MinisiteRuntime_PVT;