1 PACKAGE Jtf_Msite_Resp_Mgr_Pvt AUTHID CURRENT_USER AS
2 /* $Header: JTFVMRMS.pls 115.1 2001/03/02 19:08:21 pkm ship $ */
3
4 -- Cursors with data for mini-site
5 TYPE MSITE_CSR IS REF CURSOR;
6 TYPE MSITE_RESP_CSR IS REF CURSOR;
7 TYPE RESPONSIBILITY_CSR IS REF CURSOR;
8
9 PROCEDURE Associate_Resps_To_MSite
10 (
11 p_api_version IN NUMBER,
12 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13 p_commit IN VARCHAR2 := FND_API.G_FALSE,
14 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15 p_msite_id IN NUMBER,
16 p_responsibility_ids IN JTF_NUMBER_TABLE,
17 p_application_ids IN JTF_NUMBER_TABLE,
18 p_start_date_actives IN JTF_DATE_TABLE,
19 p_end_date_actives IN JTF_DATE_TABLE,
20 p_sort_orders IN JTF_NUMBER_TABLE,
21 p_display_names IN JTF_VARCHAR2_TABLE_300,
22 x_msite_resp_ids OUT JTF_NUMBER_TABLE,
23 x_duplicate_association_status OUT JTF_VARCHAR2_TABLE_100,
24 x_is_any_duplicate_status OUT VARCHAR2,
25 x_return_status OUT VARCHAR2,
26 x_msg_count OUT NUMBER,
27 x_msg_data OUT VARCHAR2
28 );
29
30 PROCEDURE Update_Delete_Msite_Resps
31 (
32 p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34 p_commit IN VARCHAR2 := FND_API.G_FALSE,
35 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36 p_msite_resp_ids IN JTF_NUMBER_TABLE,
37 p_object_version_numbers IN JTF_NUMBER_TABLE,
38 p_start_date_actives IN JTF_DATE_TABLE,
39 p_end_date_actives IN JTF_DATE_TABLE,
40 p_sort_orders IN JTF_NUMBER_TABLE,
41 p_display_names IN JTF_VARCHAR2_TABLE_300,
42 p_delete_flags IN JTF_VARCHAR2_TABLE_100,
43 x_return_status OUT VARCHAR2,
44 x_msg_count OUT NUMBER,
45 x_msg_data OUT VARCHAR2
46 );
47
48 PROCEDURE Load_MsiteResps_For_Msite
49 (
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52 p_commit IN VARCHAR2 := FND_API.G_FALSE,
53 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54 p_msite_id IN NUMBER,
55 p_application_id IN NUMBER,
56 x_msite_csr OUT MSITE_CSR,
57 x_msite_resp_csr OUT MSITE_RESP_CSR,
58 x_return_status OUT VARCHAR2,
59 x_msg_count OUT NUMBER,
60 x_msg_data OUT VARCHAR2
61 );
62
63 PROCEDURE Get_Resp_Appl_Id_List
64 (
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67 p_commit IN VARCHAR2 := FND_API.G_FALSE,
68 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69 p_query_criteria IN VARCHAR2,
70 p_criteria_value_str IN VARCHAR2,
71 p_application_id IN NUMBER,
72 x_responsibility_csr OUT RESPONSIBILITY_CSR,
73 x_return_status OUT VARCHAR2,
74 x_msg_count OUT NUMBER,
75 x_msg_data OUT VARCHAR2
76 );
77
78 PROCEDURE Get_Resp_Appl_Info_For_Lookup
79 (
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82 p_commit IN VARCHAR2 := FND_API.G_FALSE,
83 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84 p_responsibility_ids IN JTF_NUMBER_TABLE,
85 p_application_ids IN JTF_NUMBER_TABLE,
86 x_responsibility_csr OUT RESPONSIBILITY_CSR,
87 x_return_status OUT VARCHAR2,
88 x_msg_count OUT NUMBER,
89 x_msg_data OUT VARCHAR2
90 );
91
92 END Jtf_Msite_Resp_Mgr_Pvt;