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_THLDACT_PVT dependencies on AMS_TRIGGER_ACTIONS

Line 44: -- This procedure is to create a row in ams_trigger_actions table that

40: -- NAME
41: -- Create_Thldact
42: --
43: -- PURPOSE
44: -- This procedure is to create a row in ams_trigger_actions table that
45: -- satisfy caller needs
46: --
47: -- NOTES
48: --

Line 81: SELECT ams_trigger_actions_s.NEXTVAL

77: l_thldact_rec thldact_rec_type := p_thldact_rec;
78: l_thldact_count NUMBER ;
79:
80: CURSOR c_trig_act_seq IS
81: SELECT ams_trigger_actions_s.NEXTVAL
82: FROM DUAL;
83:
84: CURSOR c_action_seq(l_my_act_id VARCHAR2) IS
85: SELECT COUNT(*)

Line 86: FROM ams_trigger_actions

82: FROM DUAL;
83:
84: CURSOR c_action_seq(l_my_act_id VARCHAR2) IS
85: SELECT COUNT(*)
86: FROM ams_trigger_actions
87: WHERE trigger_action_id = l_my_act_id;
88: BEGIN
89: -- Standard Start of API savepoint
90: SAVEPOINT Create_Thldact_PVT;

Line 234: INSERT INTO ams_trigger_actions

230: l_thldact_rec.action_need_approval_flag := NULL;
231: END IF;
232: --end soagrawa
233:
234: INSERT INTO ams_trigger_actions
235: (trigger_action_id
236: -- standard who columns
237: ,last_update_date
238: ,last_updated_by

Line 365: -- This procedure is to delete a ams_trigger_actions table that satisfy caller needs

361: -- NAME
362: -- Delete_Thldact
363: --
364: -- PURPOSE
365: -- This procedure is to delete a ams_trigger_actions table that satisfy caller needs
366: --
367: -- NOTES
368: --
369: --

Line 445: DELETE FROM ams_trigger_actions

441: --
442:
443: -- Call Private API to cascade delete any children data if necessary
444:
445: DELETE FROM ams_trigger_actions
446: WHERE trigger_action_id = p_trigger_action_id
447: AND object_version_number = p_object_version_number ;
448:
449: IF (SQL%NOTFOUND) THEN

Line 525: -- This procedure is to lock a ams_trigger_actions table that satisfy caller needs

521: -- NAME
522: -- Lock_Thldact
523: --
524: -- PURPOSE
525: -- This procedure is to lock a ams_trigger_actions table that satisfy caller needs
526: --
527: -- NOTES
528: --
529: --

Line 555: CURSOR C_ams_trigger_actions IS

551:
552: -- Status Local Variables
553: l_action_id NUMBER; -- Return value from procedures
554:
555: CURSOR C_ams_trigger_actions IS
556: SELECT trigger_action_id
557: FROM ams_trigger_actions
558: WHERE trigger_action_id = p_trigger_action_id
559: AND object_version_number = p_object_version_number

Line 557: FROM ams_trigger_actions

553: l_action_id NUMBER; -- Return value from procedures
554:
555: CURSOR C_ams_trigger_actions IS
556: SELECT trigger_action_id
557: FROM ams_trigger_actions
558: WHERE trigger_action_id = p_trigger_action_id
559: AND object_version_number = p_object_version_number
560: FOR UPDATE of trigger_action_id NOWAIT;
561:

Line 605: OPEN C_ams_trigger_actions;

601: AMS_Utility_PVT.debug_message(l_full_name||': lock');
602: END IF;
603:
604: -- Perform the database operation
605: OPEN C_ams_trigger_actions;
606: FETCH C_ams_trigger_actions INTO l_action_id;
607: IF (C_ams_trigger_actions%NOTFOUND) THEN
608: CLOSE C_ams_trigger_actions;
609: -- Error, check the msg level and added an error message to the

Line 606: FETCH C_ams_trigger_actions INTO l_action_id;

602: END IF;
603:
604: -- Perform the database operation
605: OPEN C_ams_trigger_actions;
606: FETCH C_ams_trigger_actions INTO l_action_id;
607: IF (C_ams_trigger_actions%NOTFOUND) THEN
608: CLOSE C_ams_trigger_actions;
609: -- Error, check the msg level and added an error message to the
610: -- API message list

Line 607: IF (C_ams_trigger_actions%NOTFOUND) THEN

603:
604: -- Perform the database operation
605: OPEN C_ams_trigger_actions;
606: FETCH C_ams_trigger_actions INTO l_action_id;
607: IF (C_ams_trigger_actions%NOTFOUND) THEN
608: CLOSE C_ams_trigger_actions;
609: -- Error, check the msg level and added an error message to the
610: -- API message list
611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 608: CLOSE C_ams_trigger_actions;

604: -- Perform the database operation
605: OPEN C_ams_trigger_actions;
606: FETCH C_ams_trigger_actions INTO l_action_id;
607: IF (C_ams_trigger_actions%NOTFOUND) THEN
608: CLOSE C_ams_trigger_actions;
609: -- Error, check the msg level and added an error message to the
610: -- API message list
611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
612: THEN -- MMSG

Line 620: CLOSE C_ams_trigger_actions;

616:
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:
620: CLOSE C_ams_trigger_actions;
621:
622: --
623: -- END of API body.
624: --

Line 696: -- This procedure is to update a ams_trigger_actions table that satisfy caller needs

692: -- NAME
693: -- Update_Thldact
694: --
695: -- PURPOSE
696: -- This procedure is to update a ams_trigger_actions table that satisfy caller needs
697: --
698: -- NOTES
699: --
700: --

Line 809: UPDATE ams_trigger_actions

805: END IF;
806: END IF;
807:
808:
809: UPDATE ams_trigger_actions
810: SET last_update_date = sysdate
811: ,last_updated_by = FND_GLOBAL.User_Id
812: ,last_update_login = FND_GLOBAL.Conc_Login_Id
813: ,object_version_number = l_thldact_rec.object_version_number + 1

Line 922: -- This procedure is to validate a ams_trigger_actions table that satisfy caller needs

918: -- NAME
919: -- Validate_Thldact
920: --
921: -- PURPOSE
922: -- This procedure is to validate a ams_trigger_actions table that satisfy caller needs
923: --
924: -- NOTES
925: --
926: --

Line 1144: -- This procedure is to validate Unique Key in AMS_TRIGGER_ACTIONS

1140: -- NAME
1141: -- Check_Thldact_uk_Items
1142: --
1143: -- PURPOSE
1144: -- This procedure is to validate Unique Key in AMS_TRIGGER_ACTIONS
1145: --
1146: -- NOTES
1147: --
1148: --

Line 1171: 'ams_trigger_actions',

1167: IF p_validation_mode = JTF_PLSQL_API.g_create
1168: AND p_thldact_rec.trigger_action_id IS NOT NULL
1169: THEN
1170: IF AMS_Utility_PVT.check_uniqueness(
1171: 'ams_trigger_actions',
1172: 'trigger_action_id = ' || p_thldact_rec.trigger_action_id
1173: ) = FND_API.g_false
1174: THEN
1175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1201: p_table_name => 'ams_trigger_actions',

1197: l_where_clause := l_where_clause || ' AND execute_action_type <> ' || p_thldact_rec.execute_action_type;
1198: -- END IF;
1199:
1200: IF AMS_Utility_PVT.Check_Uniqueness(
1201: p_table_name => 'ams_trigger_actions',
1202: p_where_clause => l_where_clause
1203: ) = FND_API.g_false
1204: THEN
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1225: -- This procedure is to validate ams_trigger_actions Foreign Key items

1221: -- NAME
1222: -- Check_ThldAct_FK_Items
1223: --
1224: -- PURPOSE
1225: -- This procedure is to validate ams_trigger_actions Foreign Key items
1226: --
1227: -- NOTES
1228: --
1229: --

Line 1472: -- This procedure is to validate ams_trigger_actions Lookup items

1468: -- NAME
1469: -- Check_ThldAct_Lookup_Items
1470: --
1471: -- PURPOSE
1472: -- This procedure is to validate ams_trigger_actions Lookup items
1473: --
1474: -- NOTES
1475: --
1476: --

Line 1530: -- This procedure is to validate ams_trigger_actions Flags

1526: -- NAME
1527: -- Check_ThldAct_Flag_Items
1528: --
1529: -- PURPOSE
1530: -- This procedure is to validate ams_trigger_actions Flags
1531: --
1532: -- NOTES
1533: --
1534: --

Line 1618: -- This procedure is to validate ams_trigger_actions items

1614: -- NAME
1615: -- Check_ThldAct_Items
1616: --
1617: -- PURPOSE
1618: -- This procedure is to validate ams_trigger_actions items
1619: --
1620: -- NOTES
1621: --
1622: --

Line 1689: -- This procedure is to validate ams_trigger_Actions table.

1685: -- NAME
1686: -- Validate_thldact_record
1687: --
1688: -- PURPOSE
1689: -- This procedure is to validate ams_trigger_Actions table.
1690: -- This is an example if you need to call validation procedure from the UI site.
1691: --
1692: -- NOTES
1693: --

Line 1943: FROM ams_trigger_actions

1939: IS
1940:
1941: CURSOR c_thldact IS
1942: SELECT *
1943: FROM ams_trigger_actions
1944: WHERE trigger_action_id = p_thldact_rec.trigger_action_id;
1945:
1946: l_thldact_rec c_thldact%ROWTYPE;
1947: