1 PACKAGE Ibe_Msite_Resp_Mgr_Pvt AUTHID CURRENT_USER AS
2 /* $Header: IBEVMRMS.pls 115.5 2003/07/31 16:31:40 jqu 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 NOCOPY JTF_NUMBER_TABLE,
23 x_duplicate_association_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,
24 x_is_any_duplicate_status OUT NOCOPY VARCHAR2,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2
28 );
29
30
31 PROCEDURE Update_Delete_Msite_Resps
32 (
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37 p_msite_resp_ids IN JTF_NUMBER_TABLE,
38 p_object_version_numbers IN JTF_NUMBER_TABLE,
39 p_start_date_actives IN JTF_DATE_TABLE,
40 p_end_date_actives IN JTF_DATE_TABLE,
41 p_sort_orders IN JTF_NUMBER_TABLE,
42 p_display_names IN JTF_VARCHAR2_TABLE_300,
43 p_delete_flags IN JTF_VARCHAR2_TABLE_100,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE Update_Delete_Msite_Resps
50 (
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53 p_commit IN VARCHAR2 := FND_API.G_FALSE,
54 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55 p_msite_resp_ids IN JTF_NUMBER_TABLE,
56 p_msite_ids IN JTF_NUMBER_TABLE,
57 p_responsibility_ids IN JTF_NUMBER_TABLE,
58 p_application_ids IN JTF_NUMBER_TABLE,
59 p_object_version_numbers IN JTF_NUMBER_TABLE,
60 p_start_date_actives IN JTF_DATE_TABLE,
61 p_end_date_actives IN JTF_DATE_TABLE,
62 p_sort_orders IN JTF_NUMBER_TABLE,
63 p_display_names IN JTF_VARCHAR2_TABLE_300,
64 p_group_codes IN JTF_VARCHAR2_TABLE_300,
65 p_delete_flags IN JTF_VARCHAR2_TABLE_100,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71 PROCEDURE Load_MsiteResps_For_Msite
72 (
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE,
76 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77 p_msite_id IN NUMBER,
78 p_application_id IN NUMBER,
79 x_msite_csr OUT NOCOPY MSITE_CSR,
80 x_msite_resp_csr OUT NOCOPY MSITE_RESP_CSR,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2
84 );
85
86 PROCEDURE Update_Msite_Resps
87 (
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90 p_commit IN VARCHAR2 := FND_API.G_FALSE,
91 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92 p_msite_resp_ids IN JTF_NUMBER_TABLE,
93 p_object_version_numbers IN JTF_NUMBER_TABLE,
94 p_sort_orders IN JTF_NUMBER_TABLE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2
98 );
99
100 END Ibe_Msite_Resp_Mgr_Pvt;