[Home] [Help]
PACKAGE: APPS.IBE_MINISITERUNTIME_PVT
Source
1 PACKAGE IBE_MinisiteRuntime_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVMSRS.pls 120.2.12010000.2 2009/01/16 09:05:27 scnagara ship $ */
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 -- 01/16/09 scnagara bug 7676477, Added Get_Msite_Excluded_Items and Get_Msite_Excluded_Sections
8 -- *********************************************************************************
9
10 TYPE lang_cur_type IS REF CURSOR;
11 TYPE currency_cur_type IS REF CURSOR;
12 TYPE sections_cur_type IS REF CURSOR;
13 TYPE items_cur_type IS REF CURSOR;
14 TYPE minisite_cur_type IS REF CURSOR;
15 TYPE attr_cur_type IS REF CURSOR;
16 TYPE name_cur_type IS REF CURSOR;
17 TYPE master_msite_cur_type IS REF CURSOR;
18 TYPE msite_resp_cur_type IS REF CURSOR;
19 TYPE msite_prty_access_cur_type IS REF CURSOR;
20 TYPE pm_cc_sm_cur_type IS REF CURSOR;
21 TYPE ship_method_cur_type IS REF CURSOR;
22 TYPE payment_method_cur_type IS REF CURSOR;
23 TYPE quote_detail_cur_type IS REF CURSOR;
24
25 PROCEDURE Get_Msite_Excluded_Items -- bug 7676477, scnagara
26 (
27 p_api_version IN NUMBER,
28 p_msite_id IN NUMBER,
29 p_access_name IN VARCHAR2,
30 x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2
34 );
35
36 PROCEDURE Get_Msite_Excluded_Sections -- bug 7676477, scnagara
37 (
38 p_api_version IN NUMBER,
39 p_msite_id IN NUMBER,
40 p_access_name IN VARCHAR2,
41 x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE Get_Msite_Details
48 (
49 p_api_version IN NUMBER,
50 p_msite_id IN NUMBER,
51 p_access_name IN VARCHAR2,
52 x_master_msite_id OUT NOCOPY NUMBER,
53 x_minisite_cur OUT NOCOPY minisite_cur_type,
54 x_lang_cur OUT NOCOPY lang_cur_type,
55 x_currency_cur OUT NOCOPY currency_cur_type,
56 x_sections_cur OUT NOCOPY sections_cur_type,
57 x_items_cur OUT NOCOPY items_cur_type,
58 x_name_cur OUT NOCOPY name_cur_type ,
59 x_msite_resps_cur OUT NOCOPY msite_resp_cur_type ,
60 x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
61 x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE Get_Quote_Details
68 (
69 p_api_version IN NUMBER,
70 p_quote_id IN NUMBER,
71 x_ship_method_cur OUT NOCOPY ship_method_cur_type,
72 x_payment_method_cur OUT NOCOPY payment_method_cur_type,
73 x_quote_detail_cur OUT NOCOPY quote_detail_cur_type,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE Load_Msite_List_Details
80 (
81 p_api_version IN NUMBER,
82 p_msite_ids IN JTF_NUMBER_TABLE,
83 x_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
84 x_master_msite_id OUT NOCOPY NUMBER,
85 x_minisite_cur OUT NOCOPY minisite_cur_type,
86 x_name_cur OUT NOCOPY name_cur_type,
87 x_lang_cur OUT NOCOPY lang_cur_type,
88 x_currency_cur OUT NOCOPY currency_cur_type,
89 x_msite_resps_cur OUT NOCOPY msite_resp_cur_type,
90 x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
91 x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
92 x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
93 x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
94 x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
95 x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101 END IBE_MinisiteRuntime_PVT;