[Home] [Help]
PACKAGE: APPS.IBE_MSITE_PRTY_ACCSS_MGR_PVT
Source
1 PACKAGE Ibe_Msite_Prty_Accss_Mgr_Pvt AUTHID CURRENT_USER AS
2 /* $Header: IBEVMPMS.pls 115.3 2003/05/05 23:25:23 jqu ship $ */
3
4 -- HISTORY
5 -- 12/13/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
6 -- 01/10/03 JQU Delete procedure Get_Party_Id_List for bug 2699536
7 -- 05/05/03 JQU Delete procedure Get_Party_Info_For_Lookup for performance bug 2935856
8 -- *********************************************************************************
9
10 -- Cursors with data for mini-site
11 TYPE MSITE_CSR IS REF CURSOR;
12 TYPE MSITE_PRTY_ACCSS_CSR IS REF CURSOR;
13 TYPE PARTY_CSR IS REF CURSOR;
14 TYPE PARTY_ACCESS_CODE_CSR IS REF CURSOR;
15 TYPE CUST_ACCOUNT_CSR IS REF CURSOR;
16
17 PROCEDURE Associate_Parties_To_MSite
18 (
19 p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
21 p_commit IN VARCHAR2 := FND_API.G_FALSE,
22 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23 p_msite_id IN NUMBER,
24 p_party_ids IN JTF_NUMBER_TABLE,
25 p_start_date_actives IN JTF_DATE_TABLE,
26 p_end_date_actives IN JTF_DATE_TABLE,
27 x_msite_prty_accss_ids OUT NOCOPY JTF_NUMBER_TABLE,
28 x_duplicate_association_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,
29 x_is_any_duplicate_status OUT NOCOPY VARCHAR2,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2
33 );
34
35 PROCEDURE Update_Delete_Msite_Prty
36 (
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39 p_commit IN VARCHAR2 := FND_API.G_FALSE,
40 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41 p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,
42 p_object_version_numbers IN JTF_NUMBER_TABLE,
43 p_msite_ids IN JTF_NUMBER_TABLE,
44 p_party_ids IN JTF_NUMBER_TABLE,
45 p_start_date_actives IN JTF_DATE_TABLE,
46 p_end_date_actives IN JTF_DATE_TABLE,
47 p_delete_flags IN JTF_VARCHAR2_TABLE_100,
48 p_msite_id IN NUMBER,
49 p_party_access_code IN VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2
53 );
54
55 PROCEDURE Load_MsiteParties_For_Msite
56 (
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59 p_commit IN VARCHAR2 := FND_API.G_FALSE,
60 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61 p_msite_id IN NUMBER,
62 x_party_access_code_csr OUT NOCOPY PARTY_ACCESS_CODE_CSR,
63 x_msite_csr OUT NOCOPY MSITE_CSR,
64 x_msite_prty_accss_csr OUT NOCOPY MSITE_PRTY_ACCSS_CSR,
65 x_cust_account_csr OUT NOCOPY CUST_ACCOUNT_CSR,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71 END Ibe_Msite_Prty_Accss_Mgr_Pvt;