APPS.IBE_MSITE_PRTY_ACCSS_MGR_PVT dependencies on IBE_MSITE_PRTY_ACCSS

Line 1: PACKAGE BODY Ibe_Msite_Prty_Accss_Mgr_Pvt AS

1: PACKAGE BODY Ibe_Msite_Prty_Accss_Mgr_Pvt AS
2: /* $Header: IBEVMPMB.pls 120.0 2005/05/30 02:55:43 appldev noship $ */
3:
4: --
5: --

Line 9: -- Ibe_Msite_Prty_Accss_Mgr_Pvt

5: --
6: -- Start of Comments
7: --
8: -- NAME
9: -- Ibe_Msite_Prty_Accss_Mgr_Pvt
10: --
11: -- PURPOSE
12: --
13: --

Line 23: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBE_MSITE_PRTY_ACCSS_MGR_PVT';

19: -- 01/10/03 JQU Delete procedure Get_Party_Id_List for bug 2699536
20: -- 05/05/03 JQU Delete procedure Get_Party_Info_For_Lookup for performance bug 2935856
21: -- ********************************************************************************
22:
23: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBE_MSITE_PRTY_ACCSS_MGR_PVT';
24: G_FILE_NAME CONSTANT VARCHAR2(12):= 'IBEVMPMB.pls';
25:
26: --
27: -- Associate (p_party_ids) with p_msite_id.

Line 56: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss

52: l_api_version CONSTANT NUMBER := 1.0;
53: l_tmp_id NUMBER;
54:
55: CURSOR c1(l_c_msite_id IN NUMBER, l_c_party_id IN NUMBER)
56: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss
57: WHERE msite_id = l_c_msite_id
58: AND party_id = l_c_party_id;
59:
60: BEGIN

Line 106: Ibe_Msite_Prty_Accss_Pvt.Create_Msite_Prty_Accss

102: CLOSE c1;
103: -- no duplicate exists, create new entry
104: x_duplicate_association_status(i) := FND_API.G_RET_STS_SUCCESS;
105:
106: Ibe_Msite_Prty_Accss_Pvt.Create_Msite_Prty_Accss
107: (
108: p_api_version => p_api_version,
109: p_init_msg_list => FND_API.G_FALSE,
110: p_commit => FND_API.G_FALSE,

Line 241: Ibe_Msite_Prty_Accss_Pvt.Delete_Msite_Prty_Accss

237: FOR i IN 1..p_msite_prty_accss_ids.COUNT LOOP
238:
239: IF (p_delete_flags(i) = 'Y') THEN
240:
241: Ibe_Msite_Prty_Accss_Pvt.Delete_Msite_Prty_Accss
242: (
243: p_api_version => p_api_version,
244: p_init_msg_list => FND_API.G_FALSE,
245: p_commit => FND_API.G_FALSE,

Line 267: Ibe_Msite_Prty_Accss_Pvt.Update_Msite_Prty_Accss

263: END IF;
264:
265: ELSE
266:
267: Ibe_Msite_Prty_Accss_Pvt.Update_Msite_Prty_Accss
268: (
269: p_api_version => p_api_version,
270: p_init_msg_list => FND_API.G_FALSE,
271: p_commit => FND_API.G_FALSE,

Line 322: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ACCSS_CODE_FAIL');

318: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
319: FND_MESSAGE.Set_Token('REASON', SQLERRM);
320: FND_MSG_PUB.Add;
321:
322: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ACCSS_CODE_FAIL');
323: FND_MESSAGE.Set_Token('PARTY_ACCESS_CODE', p_party_access_code);
324: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
325: FND_MSG_PUB.Add;
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 421: FROM ibe_msite_prty_accss MP, hz_parties P, ar_lookups L

417: OPEN x_msite_prty_accss_csr FOR SELECT MP.msite_prty_accss_id,
418: MP.object_version_number, MP.msite_id, MP.party_id,
419: P.party_name, P.party_type, L.meaning, MP.start_date_active,
420: MP.end_date_active
421: FROM ibe_msite_prty_accss MP, hz_parties P, ar_lookups L
422: WHERE MP.msite_id = p_msite_id
423: AND MP.party_id = P.party_id
424: AND P.party_type = 'ORGANIZATION'
425: AND L.lookup_type = 'PARTY_TYPE'

Line 432: (SELECT party_id FROM ibe_msite_prty_accss

428: -- Get the party account data
429: OPEN x_cust_account_csr FOR SELECT party_id, account_number
430: FROM hz_cust_accounts_all
431: WHERE status = 'A' and party_id IN
432: (SELECT party_id FROM ibe_msite_prty_accss
433: WHERE msite_id = p_msite_id)
434: ORDER BY party_id, account_number;
435:
436: EXCEPTION

Line 464: END Ibe_Msite_Prty_Accss_Mgr_Pvt;

460: p_encoded => 'F');
461:
462: END Load_MsiteParties_For_Msite;
463:
464: END Ibe_Msite_Prty_Accss_Mgr_Pvt;