1 PACKAGE Jtf_Msite_Prty_Accss_Mgr_Pvt AUTHID CURRENT_USER AS
2 /* $Header: JTFVMPMS.pls 115.2 2001/03/06 12:36:34 pkm ship $ */
3
4 -- Cursors with data for mini-site
5 TYPE MSITE_CSR IS REF CURSOR;
6 TYPE MSITE_PRTY_ACCSS_CSR IS REF CURSOR;
7 TYPE PARTY_CSR IS REF CURSOR;
8 TYPE PARTY_ACCESS_CODE_CSR IS REF CURSOR;
9 TYPE CUST_ACCOUNT_CSR IS REF CURSOR;
10
11 PROCEDURE Associate_Parties_To_MSite
12 (
13 p_api_version IN NUMBER,
14 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15 p_commit IN VARCHAR2 := FND_API.G_FALSE,
16 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17 p_msite_id IN NUMBER,
18 p_party_ids IN JTF_NUMBER_TABLE,
19 p_start_date_actives IN JTF_DATE_TABLE,
20 p_end_date_actives IN JTF_DATE_TABLE,
21 x_msite_prty_accss_ids OUT JTF_NUMBER_TABLE,
22 x_duplicate_association_status OUT JTF_VARCHAR2_TABLE_100,
23 x_is_any_duplicate_status OUT VARCHAR2,
24 x_return_status OUT VARCHAR2,
25 x_msg_count OUT NUMBER,
26 x_msg_data OUT VARCHAR2
27 );
28
29 PROCEDURE Update_Delete_Msite_Prty
30 (
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35 p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,
36 p_object_version_numbers IN JTF_NUMBER_TABLE,
37 p_msite_ids IN JTF_NUMBER_TABLE,
38 p_party_ids IN JTF_NUMBER_TABLE,
39 p_start_date_actives IN JTF_DATE_TABLE,
40 p_end_date_actives IN JTF_DATE_TABLE,
41 p_delete_flags IN JTF_VARCHAR2_TABLE_100,
42 p_msite_id IN NUMBER,
43 p_party_access_code IN VARCHAR2,
44 x_return_status OUT VARCHAR2,
45 x_msg_count OUT NUMBER,
46 x_msg_data OUT VARCHAR2
47 );
48
49 PROCEDURE Load_MsiteParties_For_Msite
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_id IN NUMBER,
56 x_party_access_code_csr OUT PARTY_ACCESS_CODE_CSR,
57 x_msite_csr OUT MSITE_CSR,
58 x_msite_prty_accss_csr OUT MSITE_PRTY_ACCSS_CSR,
59 x_cust_account_csr OUT CUST_ACCOUNT_CSR,
60 x_return_status OUT VARCHAR2,
61 x_msg_count OUT NUMBER,
62 x_msg_data OUT VARCHAR2
63 );
64
65 PROCEDURE Get_Party_Id_List
66 (
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69 p_commit IN VARCHAR2 := FND_API.G_FALSE,
70 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71 p_query_criteria IN VARCHAR2,
72 p_criteria_value_str IN VARCHAR2,
73 x_party_csr OUT PARTY_CSR,
74 x_return_status OUT VARCHAR2,
75 x_msg_count OUT NUMBER,
76 x_msg_data OUT VARCHAR2
77 );
78
79 PROCEDURE Get_Party_Info_For_Lookup
80 (
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83 p_commit IN VARCHAR2 := FND_API.G_FALSE,
84 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85 p_party_ids IN JTF_NUMBER_TABLE,
86 x_party_csr OUT PARTY_CSR,
87 x_cust_account_csr OUT CUST_ACCOUNT_CSR,
88 x_return_status OUT VARCHAR2,
89 x_msg_count OUT NUMBER,
90 x_msg_data OUT VARCHAR2
91 );
92
93 END Jtf_Msite_Prty_Accss_Mgr_Pvt;