APPS.JTF_MSITE_PRTY_ACCSS_MGR_PVT dependencies on JTF_MSITE_PRTY_ACCSS

Line 1: PACKAGE BODY Jtf_Msite_Prty_Accss_Mgr_Pvt AS

1: PACKAGE BODY Jtf_Msite_Prty_Accss_Mgr_Pvt AS
2: /* $Header: JTFVMPMB.pls 115.2 2001/03/06 12:36:33 pkm ship $ */
3:
4: --
5: --

Line 9: -- Jtf_Msite_Prty_Accss_Mgr_Pvt

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

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_MSITE_PRTY_ACCSS_MGR_PVT';

16: -- HISTORY
17: -- 01/24/01 VPALAIYA Created
18: -- **************************************************************************
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_MSITE_PRTY_ACCSS_MGR_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12):= 'JTFVMPMB.pls';
22:
23: --
24: -- Associate (p_party_ids) with p_msite_id.

Line 53: IS SELECT msite_prty_accss_id FROM jtf_msite_prty_accss

49: l_api_version CONSTANT NUMBER := 1.0;
50: l_tmp_id NUMBER;
51:
52: CURSOR c1(l_c_msite_id IN NUMBER, l_c_party_id IN NUMBER)
53: IS SELECT msite_prty_accss_id FROM jtf_msite_prty_accss
54: WHERE msite_id = l_c_msite_id
55: AND party_id = l_c_party_id;
56:
57: BEGIN

Line 103: Jtf_Msite_Prty_Accss_Pvt.Create_Msite_Prty_Accss

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

Line 238: Jtf_Msite_Prty_Accss_Pvt.Delete_Msite_Prty_Accss

234: FOR i IN 1..p_msite_prty_accss_ids.COUNT LOOP
235:
236: IF (p_delete_flags(i) = 'Y') THEN
237:
238: Jtf_Msite_Prty_Accss_Pvt.Delete_Msite_Prty_Accss
239: (
240: p_api_version => p_api_version,
241: p_init_msg_list => FND_API.G_FALSE,
242: p_commit => FND_API.G_FALSE,

Line 264: Jtf_Msite_Prty_Accss_Pvt.Update_Msite_Prty_Accss

260: END IF;
261:
262: ELSE
263:
264: Jtf_Msite_Prty_Accss_Pvt.Update_Msite_Prty_Accss
265: (
266: p_api_version => p_api_version,
267: p_init_msg_list => FND_API.G_FALSE,
268: p_commit => FND_API.G_FALSE,

Line 319: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_PRTY_ACCSS_CODE_FAIL');

315: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
316: FND_MESSAGE.Set_Token('REASON', SQLERRM);
317: FND_MSG_PUB.Add;
318:
319: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_PRTY_ACCSS_CODE_FAIL');
320: FND_MESSAGE.Set_Token('PARTY_ACCESS_CODE', p_party_access_code);
321: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
322: FND_MSG_PUB.Add;
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 418: FROM jtf_msite_prty_accss MP, hz_parties P, ar_lookups L

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

Line 429: (SELECT party_id FROM jtf_msite_prty_accss

425: -- Get the party account data
426: OPEN x_cust_account_csr FOR SELECT party_id, account_number
427: FROM hz_cust_accounts_all
428: WHERE party_id IN
429: (SELECT party_id FROM jtf_msite_prty_accss
430: WHERE msite_id = p_msite_id)
431: ORDER BY party_id, account_number;
432:
433: EXCEPTION

Line 748: END Jtf_Msite_Prty_Accss_Mgr_Pvt;

744: p_encoded => 'F');
745:
746: END Get_Party_Info_For_Lookup;
747:
748: END Jtf_Msite_Prty_Accss_Mgr_Pvt;