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_THLDCHK_PVT dependencies on AMS_TRIGGER_CHECKS

Line 49: -- This procedure is to create a row in ams_trigger_checks table that

45: -- NAME
46: -- Create_Thldchk
47: --
48: -- PURPOSE
49: -- This procedure is to create a row in ams_trigger_checks table that
50: -- satisfy caller needs
51: --
52: -- NOTES
53: --

Line 89: SELECT ams_trigger_checks_s.NEXTVAL

85: l_thldchk_rec thldchk_rec_type := p_thldchk_Rec;
86: l_thldchk_count NUMBER ;
87:
88: CURSOR c_trig_chk_seq IS
89: SELECT ams_trigger_checks_s.NEXTVAL
90: FROM DUAL;
91:
92: CURSOR c_check_seq(l_my_chk_id VARCHAR2) IS
93: SELECT COUNT(*)

Line 94: FROM ams_trigger_checks

90: FROM DUAL;
91:
92: CURSOR c_check_seq(l_my_chk_id VARCHAR2) IS
93: SELECT COUNT(*)
94: FROM ams_trigger_checks
95: WHERE trigger_check_id = l_my_chk_id;
96:
97: BEGIN
98:

Line 187: INSERT INTO ams_trigger_checks

183: END LOOP;
184: END IF;
185:
186:
187: INSERT INTO ams_trigger_checks
188: (trigger_check_id
189:
190: -- standard who columns
191: ,last_update_date

Line 339: -- This procedure is to delete a ams_trigger_checks table that satisfy caller needs

335: -- NAME
336: -- Delete_Thldchk
337: --
338: -- PURPOSE
339: -- This procedure is to delete a ams_trigger_checks table that satisfy caller needs
340: --
341: -- NOTES
342: -- This procedure won't be used from Hornet release as triggers will have to have
343: -- check associated with it.

Line 421: DELETE FROM ams_trigger_checks

417: --
418:
419: -- Call Private API to cascade delete any children data if necessary
420:
421: DELETE FROM ams_trigger_checks
422: WHERE trigger_check_id = p_trigger_check_id
423: AND object_version_number = p_object_version_number ;
424:
425: IF (SQL%NOTFOUND) THEN

Line 500: -- This procedure is to lock a ams_trigger_checks table that satisfy caller needs

496: -- NAME
497: -- Lock_Thldchk
498: --
499: -- PURPOSE
500: -- This procedure is to lock a ams_trigger_checks table that satisfy caller needs
501: --
502: -- NOTES
503: --
504: --

Line 531: CURSOR C_ams_trigger_checks IS

527:
528: -- Status Local Variables
529: l_check_id NUMBER; -- Return value from procedures
530:
531: CURSOR C_ams_trigger_checks IS
532: SELECT trigger_check_id
533: FROM ams_trigger_checks
534: WHERE trigger_check_id = p_trigger_check_id
535: AND object_version_number = p_object_version_number

Line 533: FROM ams_trigger_checks

529: l_check_id NUMBER; -- Return value from procedures
530:
531: CURSOR C_ams_trigger_checks IS
532: SELECT trigger_check_id
533: FROM ams_trigger_checks
534: WHERE trigger_check_id = p_trigger_check_id
535: AND object_version_number = p_object_version_number
536: FOR UPDATE of trigger_check_id NOWAIT;
537:

Line 581: OPEN c_ams_trigger_checks;

577: AMS_Utility_PVT.debug_message(l_full_name||': lock');
578: END IF;
579:
580: -- Perform the database operation
581: OPEN c_ams_trigger_checks;
582: FETCH c_ams_trigger_checks INTO l_check_id;
583: IF (c_ams_trigger_checks%NOTFOUND) THEN
584: CLOSE c_ams_trigger_checks;
585: -- Error, check the msg level and added an error message to the

Line 582: FETCH c_ams_trigger_checks INTO l_check_id;

578: END IF;
579:
580: -- Perform the database operation
581: OPEN c_ams_trigger_checks;
582: FETCH c_ams_trigger_checks INTO l_check_id;
583: IF (c_ams_trigger_checks%NOTFOUND) THEN
584: CLOSE c_ams_trigger_checks;
585: -- Error, check the msg level and added an error message to the
586: -- API message list

Line 583: IF (c_ams_trigger_checks%NOTFOUND) THEN

579:
580: -- Perform the database operation
581: OPEN c_ams_trigger_checks;
582: FETCH c_ams_trigger_checks INTO l_check_id;
583: IF (c_ams_trigger_checks%NOTFOUND) THEN
584: CLOSE c_ams_trigger_checks;
585: -- Error, check the msg level and added an error message to the
586: -- API message list
587: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 584: CLOSE c_ams_trigger_checks;

580: -- Perform the database operation
581: OPEN c_ams_trigger_checks;
582: FETCH c_ams_trigger_checks INTO l_check_id;
583: IF (c_ams_trigger_checks%NOTFOUND) THEN
584: CLOSE c_ams_trigger_checks;
585: -- Error, check the msg level and added an error message to the
586: -- API message list
587: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
588: THEN -- MMSG

Line 596: CLOSE C_ams_trigger_checks;

592:
593: RAISE FND_API.G_EXC_ERROR;
594: END IF;
595:
596: CLOSE C_ams_trigger_checks;
597:
598: --
599: -- END of API body.
600: --

Line 674: -- This procedure is to update a ams_trigger_checks table that satisfy caller needs

670: -- NAME
671: -- Update_Thldchk
672: --
673: -- PURPOSE
674: -- This procedure is to update a ams_trigger_checks table that satisfy caller needs
675: --
676: -- NOTES
677: --
678: --

Line 788: UPDATE ams_trigger_checks

784: END IF;
785: END IF;
786:
787:
788: UPDATE ams_trigger_checks
789: SET
790: last_update_date = SYSDATE
791: ,last_updated_by = FND_GLOBAL.User_Id
792: ,last_update_login = FND_GLOBAL.Conc_Login_Id

Line 902: -- This procedure is to validate a ams_trigger_checks table that satisfy caller needs

898: -- NAME
899: -- Validate_ThldChk
900: --
901: -- PURPOSE
902: -- This procedure is to validate a ams_trigger_checks table that satisfy caller needs
903: --
904: -- NOTES
905: --
906: --

Line 1156: -- This procedure is to validate Unique Key in AMS_TRIGGER_CHECKs

1152: -- NAME
1153: -- Check_ThldChk_uk_Items
1154: --
1155: -- PURPOSE
1156: -- This procedure is to validate Unique Key in AMS_TRIGGER_CHECKs
1157: --
1158: -- NOTES
1159: --
1160: --

Line 1183: 'ams_trigger_checks',

1179: IF p_validation_mode = JTF_PLSQL_API.g_create
1180: AND p_thldchk_rec.trigger_check_id IS NOT NULL
1181: THEN
1182: IF AMS_Utility_PVT.check_uniqueness(
1183: 'ams_trigger_checks',
1184: 'trigger_check_id = ' || p_thldchk_rec.trigger_check_id
1185: ) = FND_API.g_false
1186: THEN
1187: AMS_Utility_PVT.Error_Message('AMS_TRIG_DUPLICATE_CHECK');

Line 1205: p_table_name => 'ams_trigger_checks',

1201: l_where_clause := l_where_clause || ' AND trigger_check_id <> ' || p_thldchk_rec.trigger_check_id;
1202: END IF;
1203:
1204: IF AMS_Utility_PVT.Check_Uniqueness(
1205: p_table_name => 'ams_trigger_checks',
1206: p_where_clause => l_where_clause
1207: ) = FND_API.g_false
1208: THEN
1209: AMS_Utility_PVT.Error_Message('AMS_TRIG_DUP_TRIG_ID');

Line 1222: -- This procedure is to validate ams_trigger_checks Foreign Key items

1218: -- NAME
1219: -- Check_ThldChk_FK_Items
1220: --
1221: -- PURPOSE
1222: -- This procedure is to validate ams_trigger_checks Foreign Key items
1223: --
1224: -- NOTES
1225: --
1226: --

Line 1281: -- This procedure is to validate ams_trigger_checks Lookup items

1277: -- NAME
1278: -- Check_ThldChk_Lookup_Items
1279: --
1280: -- PURPOSE
1281: -- This procedure is to validate ams_trigger_checks Lookup items
1282: --
1283: -- NOTES
1284: --
1285: --

Line 1349: -- This procedure is to validate ams_trigger_checks items

1345: -- NAME
1346: -- Check_ThldChk_Items
1347: --
1348: -- PURPOSE
1349: -- This procedure is to validate ams_trigger_checks items
1350: --
1351: -- NOTES
1352: --
1353: --

Line 1411: -- This procedure is to validate ams_trigger_checks table.

1407: -- NAME
1408: -- Validate_Thldchk_Record
1409: --
1410: -- PURPOSE
1411: -- This procedure is to validate ams_trigger_checks table.
1412: -- This is an example if you need to call validation procedure from the UI site.
1413: --
1414: -- NOTES
1415: --

Line 2015: FROM ams_trigger_checks

2011: IS
2012:
2013: CURSOR c_thldchk IS
2014: SELECT *
2015: FROM ams_trigger_checks
2016: WHERE trigger_check_id = p_thldchk_rec.trigger_check_id;
2017:
2018: l_thldchk_rec c_thldchk%ROWTYPE;
2019: