1 PACKAGE JTF_MinisiteRuntime_PVT AUTHID CURRENT_USER AS
2 /* $Header: JTFVMSRS.pls 115.7 2004/07/09 18:51:58 applrt ship $ */
3 g_pkg_name CONSTANT VARCHAR2(30):='JTF_MinisiteRuntime_PVT_TMP';
4 g_api_version CONSTANT NUMBER := 1.0;
5
6 TYPE lang_cur_type IS REF CURSOR;
7 TYPE currency_cur_type IS REF CURSOR;
8 TYPE sections_cur_type IS REF CURSOR;
9 TYPE items_cur_type IS REF CURSOR;
10 TYPE minisite_cur_type IS REF CURSOR;
11 TYPE attr_cur_type IS REF CURSOR;
12 TYPE name_cur_type IS REF CURSOR;
13 TYPE master_msite_cur_type IS REF CURSOR;
14 TYPE msite_resp_cur_type IS REF CURSOR;
15 TYPE msite_prty_access_cur_type IS REF CURSOR;
16
17 PROCEDURE Get_Msite_Details
18 (
19 p_api_version IN NUMBER,
20 p_msite_id IN NUMBER,
21 p_access_name IN VARCHAR2,
22 x_master_msite_id OUT NUMBER,
23 x_minisite_cur OUT minisite_cur_type,
24 x_lang_cur OUT lang_cur_type,
25 x_currency_cur OUT currency_cur_type,
26 x_sections_cur OUT sections_cur_type,
27 x_items_cur OUT items_cur_type,
28 x_name_cur OUT name_cur_type ,
29 x_msite_resps_cur OUT msite_resp_cur_type ,
30 x_party_access_cur OUT msite_prty_access_cur_type,
31 x_return_status OUT VARCHAR2,
32 x_msg_count OUT NUMBER,
33 x_msg_data OUT VARCHAR2
34 );
35
36 PROCEDURE Load_Msite_List_Details
37 (
38 p_api_version IN NUMBER,
39 p_msite_ids IN JTF_NUMBER_TABLE,
40 x_msite_ids OUT JTF_NUMBER_TABLE,
41 x_master_msite_id OUT NUMBER,
42 x_minisite_cur OUT MINISITE_CUR_TYPE,
43 x_name_cur OUT NAME_CUR_TYPE,
44 x_lang_cur OUT LANG_CUR_TYPE,
45 x_currency_cur OUT CURRENCY_CUR_TYPE,
46 x_msite_resps_cur OUT MSITE_RESP_CUR_TYPE,
47 x_party_access_cur OUT MSITE_PRTY_ACCESS_CUR_TYPE,
48 x_section_msite_ids OUT JTF_NUMBER_TABLE,
49 x_section_ids OUT JTF_NUMBER_TABLE,
50 x_item_msite_ids OUT JTF_NUMBER_TABLE,
51 x_item_ids OUT JTF_NUMBER_TABLE,
52 x_return_status OUT VARCHAR2,
53 x_msg_count OUT NUMBER,
54 x_msg_data OUT VARCHAR2
55 );
56
57 END JTF_MinisiteRuntime_PVT;