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.AMS_IBA_PLCMNT_PVT dependencies on AMS_IBA_PL_PLACEMENTS_B

Line 54: SELECT AMS_IBA_PL_PLACEMENTS_B_s.NEXTVAL

50: l_page_id NUMBER;
51:
52:
53: CURSOR c_id IS
54: SELECT AMS_IBA_PL_PLACEMENTS_B_s.NEXTVAL
55: FROM dual;
56:
57: CURSOR c_id_exists (l_id IN NUMBER) IS
58: SELECT 1

Line 59: FROM AMS_IBA_PL_PLACEMENTS_B

55: FROM dual;
56:
57: CURSOR c_id_exists (l_id IN NUMBER) IS
58: SELECT 1
59: FROM AMS_IBA_PL_PLACEMENTS_B
60: WHERE PLACEMENT_ID = l_id;
61:
62: CURSOR c_site_id (l_site_ref_code IN VARCHAR2) IS
63: SELECT site_id

Line 181: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Insert_Row)

177:
178: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
179: END IF;
180:
181: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Insert_Row)
182: AMS_IBA_PL_PLACEMENTS_B_PKG.Insert_Row(
183: px_placement_id => l_placement_id,
184: p_site_id => l_site_id,
185: p_site_ref_code => p_iba_plcmnt_rec.site_ref_code,

Line 182: AMS_IBA_PL_PLACEMENTS_B_PKG.Insert_Row(

178: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
179: END IF;
180:
181: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Insert_Row)
182: AMS_IBA_PL_PLACEMENTS_B_PKG.Insert_Row(
183: px_placement_id => l_placement_id,
184: p_site_id => l_site_id,
185: p_site_ref_code => p_iba_plcmnt_rec.site_ref_code,
186: p_page_id => l_page_id,

Line 292: FROM AMS_IBA_PL_PLACEMENTS_B;

288: IS
289: --/*
290: CURSOR c_get_iba_plcmnt(placement_id NUMBER) IS
291: SELECT *
292: FROM AMS_IBA_PL_PLACEMENTS_B;
293: -- Hint: Developer need to provide Where clause
294: --*/
295: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Iba_Plcmnt';
296: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 402: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Update_Row)

398:
399: -- Debug Message
400: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
401:
402: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Update_Row)
403: AMS_IBA_PL_PLACEMENTS_B_PKG.Update_Row(
404: p_placement_id => p_iba_plcmnt_rec.placement_id,
405: p_site_id => p_iba_plcmnt_rec.site_id,
406: p_site_ref_code => p_iba_plcmnt_rec.site_ref_code,

Line 403: AMS_IBA_PL_PLACEMENTS_B_PKG.Update_Row(

399: -- Debug Message
400: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
401:
402: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Update_Row)
403: AMS_IBA_PL_PLACEMENTS_B_PKG.Update_Row(
404: p_placement_id => p_iba_plcmnt_rec.placement_id,
405: p_site_id => p_iba_plcmnt_rec.site_id,
406: p_site_ref_code => p_iba_plcmnt_rec.site_ref_code,
407: p_page_id => p_iba_plcmnt_rec.page_id,

Line 547: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Delete_Row)

543:
544: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
545: END IF;
546:
547: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Delete_Row)
548: AMS_IBA_PL_PLACEMENTS_B_PKG.Delete_Row(
549: p_PLACEMENT_ID => p_PLACEMENT_ID);
550: --
551: -- End of API body

Line 548: AMS_IBA_PL_PLACEMENTS_B_PKG.Delete_Row(

544: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
545: END IF;
546:
547: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Delete_Row)
548: AMS_IBA_PL_PLACEMENTS_B_PKG.Delete_Row(
549: p_PLACEMENT_ID => p_PLACEMENT_ID);
550: --
551: -- End of API body
552: --

Line 636: FROM AMS_IBA_PL_PLACEMENTS_B

632: l_PLACEMENT_ID NUMBER;
633:
634: CURSOR c_Iba_Plcmnt IS
635: SELECT PLACEMENT_ID
636: FROM AMS_IBA_PL_PLACEMENTS_B
637: WHERE PLACEMENT_ID = p_PLACEMENT_ID
638: AND object_version_number = p_object_version
639: FOR UPDATE NOWAIT;
640:

Line 766: from ams_iba_pl_placements_b

762: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
763: if p_iba_plcmnt_rec.site_ref_code = 'ISTORE' then
764: if p_iba_plcmnt_rec.page_ref_code = 'SHOPPING_CART' then
765: select count(*) into l_plcmnt_count
766: from ams_iba_pl_placements_b
767: where site_ref_code = p_iba_plcmnt_rec.site_ref_code
768: and page_ref_code = p_iba_plcmnt_rec.page_ref_code
769: and location_code = p_iba_plcmnt_rec.location_code
770: and NVL(param1,'-1') = NVL(p_iba_plcmnt_rec.param1,'-1')

Line 776: from ams_iba_pl_placements_b

772:
773: p_situation := 1;
774: else
775: select count(*) into l_plcmnt_count
776: from ams_iba_pl_placements_b
777: where site_ref_code = p_iba_plcmnt_rec.site_ref_code
778: and page_ref_code = p_iba_plcmnt_rec.page_ref_code
779: and location_code = p_iba_plcmnt_rec.location_code
780: and NVL(param1,'-1') = NVL(p_iba_plcmnt_rec.param1,'-1')

Line 788: from ams_iba_pl_placements_b

784: p_situation := 2;
785: end if;
786: else
787: select count(*) into l_plcmnt_count
788: from ams_iba_pl_placements_b
789: where site_ref_code = p_iba_plcmnt_rec.site_ref_code
790: and page_ref_code = p_iba_plcmnt_rec.page_ref_code
791: and location_code = p_iba_plcmnt_rec.location_code
792: and placement_id <> p_iba_plcmnt_rec.placement_id;

Line 800: from ams_iba_pl_placements_b

796: else
797: if p_iba_plcmnt_rec.site_ref_code = 'ISTORE' then
798: if p_iba_plcmnt_rec.page_ref_code = 'SHOPPING_CART' then
799: select count(*) into l_plcmnt_count
800: from ams_iba_pl_placements_b
801: where site_ref_code = p_iba_plcmnt_rec.site_ref_code
802: and page_ref_code = p_iba_plcmnt_rec.page_ref_code
803: and location_code = p_iba_plcmnt_rec.location_code
804: and NVL(param1,'-1') = NVL(p_iba_plcmnt_rec.param1,'-1');

Line 809: from ams_iba_pl_placements_b

805:
806: p_situation := 1;
807: else
808: select count(*) into l_plcmnt_count
809: from ams_iba_pl_placements_b
810: where site_ref_code = p_iba_plcmnt_rec.site_ref_code
811: and page_ref_code = p_iba_plcmnt_rec.page_ref_code
812: and location_code = p_iba_plcmnt_rec.location_code
813: and NVL(param1,'-1') = NVL(p_iba_plcmnt_rec.param1,'-1')

Line 820: from ams_iba_pl_placements_b

816: p_situation := 2;
817: end if;
818: else
819: select count(*) into l_plcmnt_count
820: from ams_iba_pl_placements_b
821: where site_ref_code = p_iba_plcmnt_rec.site_ref_code
822: and page_ref_code = p_iba_plcmnt_rec.page_ref_code
823: and location_code = p_iba_plcmnt_rec.location_code;
824:

Line 1153: FROM ams_iba_pl_placements_b

1149: l_return_status VARCHAR2(1);
1150:
1151: CURSOR c_complete IS
1152: SELECT *
1153: FROM ams_iba_pl_placements_b
1154: WHERE placement_id = p_iba_plcmnt_rec.placement_id;
1155: l_iba_plcmnt_rec c_complete%ROWTYPE;
1156: BEGIN
1157: x_complete_rec := p_iba_plcmnt_rec;