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_PS_CNDCLSES_PVT dependencies on AMS_IBA_PS_CNDCLSES_B

Line 54: SELECT AMS_IBA_PS_CNDCLSES_B_s.NEXTVAL

50: l_temp_refcode VARCHAR2(30);
51: l_ref_code VARCHAR2(30);
52:
53: CURSOR c_id IS
54: SELECT AMS_IBA_PS_CNDCLSES_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_PS_CNDCLSES_B

55: FROM dual;
56:
57: CURSOR c_id_exists (l_id IN NUMBER) IS
58: SELECT 1
59: FROM AMS_IBA_PS_CNDCLSES_B
60: WHERE CND_CLAUSE_ID = l_id;
61:
62: BEGIN
63: -- Standard Start of API savepoint

Line 147: from ams_iba_ps_cndclses_b

143: AMS_UTILITY_PVT.debug_message('Private API: Calling create table handler');
144: END IF;
145:
146: select CND_CLAUSE_REF_CODE bulk collect into l_str_tab
147: from ams_iba_ps_cndclses_b
148: order by CND_CLAUSE_REF_CODE;
149:
150: if (SQL%NOTFOUND) then
151: l_ref_code := 'CV1';

Line 169: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Insert_Row)

165: end if;
166:
167: End If;
168:
169: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Insert_Row)
170: AMS_IBA_PS_CNDCLSES_B_PKG.Insert_Row(
171: p_created_by => FND_GLOBAL.USER_ID,
172: p_creation_date => SYSDATE,
173: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 170: AMS_IBA_PS_CNDCLSES_B_PKG.Insert_Row(

166:
167: End If;
168:
169: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Insert_Row)
170: AMS_IBA_PS_CNDCLSES_B_PKG.Insert_Row(
171: p_created_by => FND_GLOBAL.USER_ID,
172: p_creation_date => SYSDATE,
173: p_last_updated_by => FND_GLOBAL.USER_ID,
174: p_last_update_date => SYSDATE,

Line 271: FROM AMS_IBA_PS_CNDCLSES_B

267: IS
268:
269: CURSOR c_get_ps_cndclses(p_cnd_clause_id NUMBER) IS
270: SELECT *
271: FROM AMS_IBA_PS_CNDCLSES_B
272: WHERE cnd_clause_id = p_cnd_clause_id;
273: -- Hint: Developer need to provide Where clause
274:
275: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Ps_Cndclses';

Line 379: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Update_Row)

375:
376: -- Debug Message
377: -- 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;
378:
379: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Update_Row)
380: AMS_IBA_PS_CNDCLSES_B_PKG.Update_Row(
381: p_created_by => FND_GLOBAL.USER_ID,
382: p_creation_date => SYSDATE,
383: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 380: AMS_IBA_PS_CNDCLSES_B_PKG.Update_Row(

376: -- Debug Message
377: -- 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;
378:
379: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Update_Row)
380: AMS_IBA_PS_CNDCLSES_B_PKG.Update_Row(
381: p_created_by => FND_GLOBAL.USER_ID,
382: p_creation_date => SYSDATE,
383: p_last_updated_by => FND_GLOBAL.USER_ID,
384: p_last_update_date => SYSDATE,

Line 509: from ams_iba_ps_cndclses_b

505: -- Initialize API return status to SUCCESS
506: x_return_status := FND_API.G_RET_STS_SUCCESS;
507:
508: select cnd_clause_ref_code into l_cnd_rcode
509: from ams_iba_ps_cndclses_b
510: where cnd_clause_id = p_cnd_clause_id;
511:
512: select decode(l_cnd_rcode,'CV1', 'use_clause6',
513: 'CV2', 'use_clause7',

Line 543: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Delete_Row)

539: AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');
540:
541: END IF;
542:
543: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Delete_Row)
544: AMS_IBA_PS_CNDCLSES_B_PKG.Delete_Row(
545: p_CND_CLAUSE_ID => p_CND_CLAUSE_ID);
546: --
547: -- End of API body

Line 544: AMS_IBA_PS_CNDCLSES_B_PKG.Delete_Row(

540:
541: END IF;
542:
543: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Delete_Row)
544: AMS_IBA_PS_CNDCLSES_B_PKG.Delete_Row(
545: p_CND_CLAUSE_ID => p_CND_CLAUSE_ID);
546: --
547: -- End of API body
548: --

Line 631: FROM AMS_IBA_PS_CNDCLSES_B

627: l_CND_CLAUSE_ID NUMBER;
628:
629: CURSOR c_Ps_Cndclses IS
630: SELECT CND_CLAUSE_ID
631: FROM AMS_IBA_PS_CNDCLSES_B
632: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID
633: AND object_version_number = p_object_version
634: FOR UPDATE NOWAIT;
635:

Line 744: 'AMS_IBA_PS_CNDCLSES_B',

740: BEGIN
741: x_return_status := FND_API.g_ret_sts_success;
742: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
743: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
744: 'AMS_IBA_PS_CNDCLSES_B',
745: 'CND_CLAUSE_ID = ''' || p_ps_cndclses_rec.CND_CLAUSE_ID ||''''
746: );
747: ELSE
748: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 749: 'AMS_IBA_PS_CNDCLSES_B',

745: 'CND_CLAUSE_ID = ''' || p_ps_cndclses_rec.CND_CLAUSE_ID ||''''
746: );
747: ELSE
748: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
749: 'AMS_IBA_PS_CNDCLSES_B',
750: 'CND_CLAUSE_ID = ''' || p_ps_cndclses_rec.CND_CLAUSE_ID ||
751: ''' AND CND_CLAUSE_ID <> ' || p_ps_cndclses_rec.CND_CLAUSE_ID
752: );
753: END IF;

Line 933: FROM ams_iba_ps_cndclses_b

929: l_return_status VARCHAR2(1);
930:
931: CURSOR c_complete IS
932: SELECT *
933: FROM ams_iba_ps_cndclses_b
934: WHERE cnd_clause_id = p_ps_cndclses_rec.cnd_clause_id;
935: l_ps_cndclses_rec c_complete%ROWTYPE;
936: BEGIN
937: x_complete_rec := p_ps_cndclses_rec;