APPS.IBE_MSITE_PRTY_ACCSS_PVT dependencies on IBE_MSITE_PRTY_ACCSS

Line 1: PACKAGE BODY Ibe_Msite_Prty_Accss_Pvt AS

1: PACKAGE BODY Ibe_Msite_Prty_Accss_Pvt AS
2: /* $Header: IBEVMPRB.pls 120.0 2005/05/30 02:17:13 appldev noship $ */
3:
4: -- HISTORY
5: -- 12/13/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBE_MSITE_PRTY_ACCSS_PVT';

4: -- HISTORY
5: -- 12/13/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
6: -- *********************************************************************************
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBE_MSITE_PRTY_ACCSS_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12):= 'IBEVMPRB.pls';
10:
11: PROCEDURE Validate_Msite_Id_Exists
12: (

Line 152: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss

148: l_api_version CONSTANT NUMBER := 1.0;
149: l_tmp_id NUMBER;
150:
151: CURSOR c1(l_c_msite_prty_accss_id IN NUMBER)
152: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss
153: WHERE msite_prty_accss_id = l_c_msite_prty_accss_id;
154:
155: CURSOR c2(l_c_msite_id IN NUMBER, l_c_party_id IN NUMBER)
156: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss

Line 156: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss

152: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss
153: WHERE msite_prty_accss_id = l_c_msite_prty_accss_id;
154:
155: CURSOR c2(l_c_msite_id IN NUMBER, l_c_party_id IN NUMBER)
156: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss
157: WHERE msite_id = l_c_msite_id
158: AND party_id = l_c_party_id;
159:
160: BEGIN

Line 166: -- in ibe_msite_prty_accss

162: -- Initialize status to SUCCESS
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: -- Check if msite_prty_accss_id or combination of msite_id and party_id
166: -- in ibe_msite_prty_accss
167: IF ((p_msite_prty_accss_id IS NOT NULL) AND
168: (p_msite_prty_accss_id <> FND_API.G_MISS_NUM))
169: THEN
170:

Line 587: Ibe_Msite_Prty_Accss_Pkg.insert_row

583: --
584: -- 2. Insert row
585: --
586: BEGIN
587: Ibe_Msite_Prty_Accss_Pkg.insert_row
588: (
589: p_msite_prty_accss_id => FND_API.G_MISS_NUM,
590: p_object_version_number => l_object_version_number,
591: p_msite_id => p_msite_id,

Line 682: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss

678:
679: l_msite_prty_accss_id NUMBER;
680:
681: CURSOR c1(l_c_msite_id IN NUMBER, l_c_party_id IN NUMBER)
682: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss
683: WHERE msite_id = l_c_msite_id
684: AND party_id = l_c_party_id;
685:
686: BEGIN

Line 775: Ibe_Msite_Prty_Accss_Pkg.update_row

771: END IF;
772:
773: -- 2. update row with section data into section table
774: BEGIN
775: Ibe_Msite_Prty_Accss_Pkg.update_row
776: (
777: p_msite_prty_accss_id => l_msite_prty_accss_id,
778: p_object_version_number => p_object_version_number,
779: p_start_date_active => p_start_date_active,

Line 861: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss

857:
858: l_msite_prty_accss_id NUMBER;
859:
860: CURSOR c1(l_c_msite_id IN NUMBER, l_c_party_id IN NUMBER)
861: IS SELECT msite_prty_accss_id FROM ibe_msite_prty_accss
862: WHERE msite_id = l_c_msite_id
863: AND party_id = l_c_party_id;
864:
865: BEGIN

Line 923: -- delete for ibe_msite_prty_accss

919: FND_MSG_PUB.Add;
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922:
923: -- delete for ibe_msite_prty_accss
924: BEGIN
925: Ibe_Msite_Prty_Accss_Pkg.delete_row(l_msite_prty_accss_id);
926: EXCEPTION
927: WHEN NO_DATA_FOUND THEN

Line 925: Ibe_Msite_Prty_Accss_Pkg.delete_row(l_msite_prty_accss_id);

921: END IF;
922:
923: -- delete for ibe_msite_prty_accss
924: BEGIN
925: Ibe_Msite_Prty_Accss_Pkg.delete_row(l_msite_prty_accss_id);
926: EXCEPTION
927: WHEN NO_DATA_FOUND THEN
928: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_PRTY_DELETE_FL');
929: FND_MSG_PUB.Add;

Line 968: END Ibe_Msite_Prty_Accss_Pvt;

964: p_encoded => 'F');
965:
966: END Delete_Msite_Prty_Accss;
967:
968: END Ibe_Msite_Prty_Accss_Pvt;