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_LISTACTION_PVT dependencies on AMS_LIST_SELECT_ACTIONS

Line 79: FROM ams_list_select_actions

75: --is not included more than once in the set of list actions.
76:
77: Cursor C_Is_Source_Unique IS
78: SELECT count(*)
79: FROM ams_list_select_actions
80: WHERE action_used_by_id = p_action_rec.action_used_by_id
81: AND arc_action_used_by = p_action_rec.arc_action_used_by
82: AND list_select_action_id <> p_action_rec.list_select_action_id
83: AND incl_object_id = p_action_rec.incl_object_id

Line 92: FROM ams_list_select_actions

88:
89: --Checking that the same order number does not exist among the set of list actions for the list.
90: Cursor C_Is_Ord_No_Unique Is
91: SELECT Count(*)
92: FROM ams_list_select_actions
93: WHERE action_used_by_id = p_action_rec.action_used_by_id
94: AND arc_action_used_by = p_action_rec.arc_action_used_by
95: AND list_select_action_id <> p_action_rec.list_select_action_id
96: AND order_number = p_action_rec.order_number;

Line 105: FROM ams_list_select_actions

101:
102: --Getting The Count of Actions excluding the current one for this list.
103: Cursor C_Actions_Exist IS
104: SELECT count(*)
105: FROM ams_list_select_actions
106: WHERE action_used_by_id = p_action_rec.action_used_by_id
107: AND arc_action_used_by = p_action_rec.arc_action_used_by
108: AND list_select_action_id <> p_action_rec.list_select_action_id;
109:

Line 114: FROM ams_list_select_actions

110:
111: l_min_Order number;
112: cursor c_min_order is
113: SELECT nvl(Min(order_number),-1)
114: FROM ams_list_select_actions
115: WHERE action_used_by_id = p_action_rec.action_used_by_id
116: AND arc_action_used_by = p_action_rec.arc_action_used_by
117: AND list_select_action_id <> p_action_rec.list_select_action_id;
118:

Line 122: FROM ams_list_select_actions

118:
119: --Getting list select action type where order num is min .
120: Cursor C_Min_List_Selection_Type IS
121: SELECT list_action_type
122: FROM ams_list_select_actions
123: WHERE action_used_by_id = p_action_rec.action_used_by_id
124: AND arc_action_used_by = p_action_rec.arc_action_used_by
125: and order_number = l_min_order;
126: l_action_type varchar2(30);

Line 277: 'ams_list_select_actions',

273: IF p_validation_mode = JTF_PLSQL_API.g_create
274: AND p_action_rec.list_select_action_id IS NOT NULL
275: THEN
276: IF AMS_Utility_PVT.check_uniqueness(
277: 'ams_list_select_actions',
278: 'list_select_action_id = ' || p_action_rec.list_select_action_id
279: ) = FND_API.g_false
280: THEN
281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 294: 'ams_list_select_actions',

290: IF p_validation_mode = JTF_PLSQL_API.g_create
291: AND p_action_rec.order_number IS NOT NULL
292: THEN
293: IF AMS_Utility_PVT.check_uniqueness(
294: 'ams_list_select_actions',
295: 'order_number = ' || p_action_rec.order_number||
296: ' and action_used_by_id = '||p_action_rec.action_used_by_id
297: ||' and arc_action_used_by = '||p_action_rec.arc_action_used_by
298: ) = FND_API.g_false

Line 313: 'ams_list_select_actions',

309: IF p_validation_mode = JTF_PLSQL_API.g_create
310: AND p_action_rec.rank IS NOT NULL
311: THEN
312: IF AMS_Utility_PVT.check_uniqueness(
313: 'ams_list_select_actions',
314: 'rank = ' || p_action_rec.rank||
315: ' and action_used_by_id = '||
316: p_action_rec.action_used_by_id
317: ||' and arc_action_used_by = '||

Line 1003: l_list_select_action_id AMS_LIST_SELECT_ACTIONS.list_select_action_id%TYPE;

999: -- Status Local Variables
1000: l_return_status VARCHAR2(1); -- Return value from procedures
1001: l_action_rec action_rec_type := p_action_rec;
1002:
1003: l_list_select_action_id AMS_LIST_SELECT_ACTIONS.list_select_action_id%TYPE;
1004: l_action_count number;
1005:
1006: l_sqlerrm varchar2(600);
1007: l_sqlcode varchar2(100);

Line 1010: SELECT ams_list_select_actions_s.NEXTVAL

1006: l_sqlerrm varchar2(600);
1007: l_sqlcode varchar2(100);
1008:
1009: CURSOR c_action_seq IS
1010: SELECT ams_list_select_actions_s.NEXTVAL
1011: FROM DUAL;
1012:
1013: CURSOR c_action_count(action_id IN NUMBER) IS
1014: SELECT COUNT(*)

Line 1015: FROM ams_list_select_actions

1011: FROM DUAL;
1012:
1013: CURSOR c_action_count(action_id IN NUMBER) IS
1014: SELECT COUNT(*)
1015: FROM ams_list_select_actions
1016: WHERE list_select_action_id = action_id;
1017:
1018: BEGIN
1019:

Line 1095: INSERT into AMS_LIST_SELECT_ACTIONS

1091:
1092:
1093:
1094:
1095: INSERT into AMS_LIST_SELECT_ACTIONS
1096: (LIST_SELECT_ACTION_ID
1097: ,LAST_UPDATE_DATE
1098: ,LAST_UPDATED_BY
1099: ,CREATION_DATE

Line 1387: UPDATE ams_list_select_actions

1383: l_rec_changed := 'N';
1384: check_list_action_changes(l_action_rec, l_rec_changed);
1385: END IF;
1386:
1387: UPDATE ams_list_select_actions
1388: SET
1389: last_update_date = sysdate
1390: ,last_updated_by = FND_GLOBAL.User_Id
1391: ,last_update_login = FND_GLOBAL.Conc_Login_Id

Line 1611: --dbms_output.put_line('AMS_List_SelectAction_PVT - DELETE FROM ams_list_select_actions');

1607:
1608: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1609: THEN
1610: NULL;
1611: --dbms_output.put_line('AMS_List_SelectAction_PVT - DELETE FROM ams_list_select_actions');
1612: END IF;
1613:
1614: /* Delete from ams_list_entries
1615: where list_select_action_id = p_action_id;

Line 1643: DELETE FROM ams_list_select_actions

1639: (l_complete_list_header_rec.status_code='DRAFT') OR
1640: (l_complete_list_header_rec.status_code='AVAILABLE')OR
1641: (l_complete_list_header_rec.status_code='SCHEDULED')
1642: THEN
1643: DELETE FROM ams_list_select_actions
1644: WHERE list_select_action_id = p_action_id;
1645:
1646: -- AMS_ListHeader_PVT.Reset_Status(l_complete_list_header_rec.action_used_by_id,)
1647:

Line 1667: DELETE FROM ams_list_select_actions

1663:
1664: ELSIF (l_complete_action_rec.arc_action_used_by='MODL')
1665: THEN
1666:
1667: DELETE FROM ams_list_select_actions
1668: WHERE list_select_action_id = p_action_id;
1669:
1670: -- Added on Oct 14, 2002 by nyostos
1671: -- call the plugin to update the model status

Line 1677: DELETE FROM ams_list_select_actions

1673:
1674: ELSIF (l_complete_action_rec.arc_action_used_by='SCOR')
1675: THEN
1676: /* call the plugin to update the model status ??*/
1677: DELETE FROM ams_list_select_actions
1678: WHERE list_select_action_id = p_action_id;
1679:
1680: -- Added on Oct 14, 2002 by nyostos
1681: -- call the plugin to update the model status

Line 1803: FROM ams_list_select_actions

1799: l_return_status VARCHAR2(1); -- Return value from procedures
1800:
1801: CURSOR c_list_actions IS
1802: SELECT list_select_action_id
1803: FROM ams_list_select_actions
1804: WHERE list_select_action_id = p_action_id
1805: AND object_version_number = p_object_version
1806: FOR UPDATE OF list_select_action_id NOWAIT;
1807:

Line 1999: FROM ams_list_select_actions

1995: IS
1996:
1997: CURSOR c_action IS
1998: SELECT *
1999: FROM ams_list_select_actions
2000: WHERE list_select_action_id = p_action_rec.list_select_action_id;
2001:
2002: l_action_rec c_action%ROWTYPE;
2003:

Line 2147: FROM ams_list_select_actions

2143: )
2144: IS
2145: CURSOR c_action IS
2146: SELECT *
2147: FROM ams_list_select_actions
2148: WHERE list_select_action_id = p_action_rec.list_select_action_id;
2149:
2150: l_ref_action c_action%ROWTYPE;
2151: