eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_MSITE_INFORMATION_PVT dependencies on IBE_MSITE_INFORMATION

Line 1: PACKAGE BODY Ibe_Msite_Information_Pvt AS

1: PACKAGE BODY Ibe_Msite_Information_Pvt AS
2: /* $Header: IBEVMINB.pls 120.1 2005/08/10 07:03:32 appldev ship $ */
3:
4: -- HISTORY
5: -- 12/13/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBE_MSITE_INFORMATION_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_INFORMATION_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12):= 'IBEVMINB.pls';
10:
11: --
12: --

Line 345: IS SELECT 1 FROM ibe_msite_information

341: l_api_version CONSTANT NUMBER := 1.0;
342: l_tmp_id NUMBER;
343:
344: CURSOR c1(l_c_msite_id IN NUMBER, l_c_msite_information1 IN VARCHAR2)
345: IS SELECT 1 FROM ibe_msite_information
346: WHERE msite_information_context = 'PMT_MTHD'
347: AND msite_information1 = l_c_msite_information1
348: AND msite_id = l_c_msite_id;
349:

Line 351: IS SELECT 1 FROM ibe_msite_information

347: AND msite_information1 = l_c_msite_information1
348: AND msite_id = l_c_msite_id;
349:
350: CURSOR c2(l_c_msite_id IN NUMBER, l_c_msite_information1 IN VARCHAR2)
351: IS SELECT 1 FROM ibe_msite_information
352: WHERE msite_information_context = 'CC_TYPE'
353: AND msite_information1 = l_c_msite_information1
354: AND msite_id = l_c_msite_id;
355:

Line 357: IS SELECT 1 FROM ibe_msite_information

353: AND msite_information1 = l_c_msite_information1
354: AND msite_id = l_c_msite_id;
355:
356: CURSOR c3(l_c_msite_id IN NUMBER, l_c_msite_information1 IN VARCHAR2)
357: IS SELECT 1 FROM ibe_msite_information
358: WHERE msite_information_context = 'SHPMT_MTHD'
359: AND msite_information1 = l_c_msite_information1
360: AND msite_id = l_c_msite_id;
361:

Line 375: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');

371: OPEN c1(p_msite_id, p_msite_information1);
372: FETCH c1 INTO l_tmp_id;
373: IF (c1%FOUND) THEN -- found duplicate
374: CLOSE c1;
375: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');
376: FND_MESSAGE.Set_Token('VALUE', p_msite_information1);
377: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
378: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);
379: FND_MSG_PUB.Add;

Line 391: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');

387: OPEN c2(p_msite_id, p_msite_information1);
388: FETCH c2 INTO l_tmp_id;
389: IF (c2%FOUND) THEN -- found duplicate
390: CLOSE c2;
391: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');
392: FND_MESSAGE.Set_Token('VALUE', p_msite_information1);
393: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
394: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);
395: FND_MSG_PUB.Add;

Line 407: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');

403: OPEN c3(p_msite_id, p_msite_information1);
404: FETCH c3 INTO l_tmp_id;
405: IF (c3%FOUND) THEN -- found duplicate
406: CLOSE c3;
407: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');
408: FND_MESSAGE.Set_Token('VALUE', p_msite_information1);
409: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
410: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);
411: FND_MSG_PUB.Add;

Line 778: SELECT msite_information_context, msite_id FROM ibe_msite_information

774: l_msite_id NUMBER;
775: l_msite_information_context VARCHAR2(40);
776:
777: CURSOR c1(l_c_msite_information_id IN NUMBER) IS
778: SELECT msite_information_context, msite_id FROM ibe_msite_information
779: WHERE msite_information_id = l_c_msite_information_id;
780:
781: BEGIN
782:

Line 1093: Ibe_Msite_Information_Pkg.insert_row

1089: --
1090: -- 2. Insert row
1091: --
1092: BEGIN
1093: Ibe_Msite_Information_Pkg.insert_row
1094: (
1095: p_msite_information_id => FND_API.G_MISS_NUM,
1096: p_object_version_number => l_object_version_number,
1097: p_msite_id => p_msite_id,

Line 1351: Ibe_Msite_Information_Pkg.update_row

1347: END IF;
1348:
1349: -- 2. update row with section data into section table
1350: BEGIN
1351: Ibe_Msite_Information_Pkg.update_row
1352: (
1353: p_msite_information_id => p_msite_information_id,
1354: p_object_version_number => p_object_version_number,
1355: p_msite_information1 => p_msite_information1,

Line 1512: -- delete for ibe_msite_information

1508: FND_MSG_PUB.Add;
1509: RAISE FND_API.G_EXC_ERROR;
1510: END IF;
1511:
1512: -- delete for ibe_msite_information
1513: BEGIN
1514: Ibe_Msite_Information_Pkg.delete_row(p_msite_information_id);
1515: EXCEPTION
1516: WHEN NO_DATA_FOUND THEN

Line 1514: Ibe_Msite_Information_Pkg.delete_row(p_msite_information_id);

1510: END IF;
1511:
1512: -- delete for ibe_msite_information
1513: BEGIN
1514: Ibe_Msite_Information_Pkg.delete_row(p_msite_information_id);
1515: EXCEPTION
1516: WHEN NO_DATA_FOUND THEN
1517: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_DELETE_FL');
1518: FND_MSG_PUB.Add;

Line 1582: END Ibe_Msite_Information_Pvt;

1578: p_encoded => 'F');
1579:
1580: END Delete_Msite_Information;
1581:
1582: END Ibe_Msite_Information_Pvt;