APPS.AMS_LIST_SELECT_ACTIONS_PKG dependencies on AMS_LIST_SELECT_ACTIONS

Line 1: PACKAGE BODY AMS_LIST_SELECT_ACTIONS_PKG as

1: PACKAGE BODY AMS_LIST_SELECT_ACTIONS_PKG as
2: /* $Header: amstlsab.pls 120.0 2005/05/31 23:05:25 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_LIST_SELECT_ACTIONS_PKG

2: /* $Header: amstlsab.pls 120.0 2005/05/31 23:05:25 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_LIST_SELECT_ACTIONS_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_LIST_SELECT_ACTIONS_PKG';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_LIST_SELECT_ACTIONS_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstlsab.pls';
19:
20:
21: ----------------------------------------------------------

Line 80: INSERT INTO AMS_LIST_SELECT_ACTIONS(

76:
77: px_object_version_number := 1;
78:
79:
80: INSERT INTO AMS_LIST_SELECT_ACTIONS(
81: list_select_action_id,
82: last_update_date,
83: last_updated_by,
84: creation_date,

Line 186: Update AMS_LIST_SELECT_ACTIONS

182: p_no_of_rows_targeted NUMBER)
183:
184: IS
185: BEGIN
186: Update AMS_LIST_SELECT_ACTIONS
187: SET
188: list_select_action_id = DECODE( p_list_select_action_id, FND_API.g_miss_num, list_select_action_id, p_list_select_action_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 244: DELETE FROM AMS_LIST_SELECT_ACTIONS

240: PROCEDURE Delete_Row(
241: p_LIST_SELECT_ACTION_ID NUMBER)
242: IS
243: BEGIN
244: DELETE FROM AMS_LIST_SELECT_ACTIONS
245: WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID;
246: If (SQL%NOTFOUND) then
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: End If;

Line 301: FROM AMS_LIST_SELECT_ACTIONS

297:
298: IS
299: CURSOR C IS
300: SELECT *
301: FROM AMS_LIST_SELECT_ACTIONS
302: WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID
303: FOR UPDATE of LIST_SELECT_ACTION_ID NOWAIT;
304: Recinfo C%ROWTYPE;
305: BEGIN

Line 445: from ams_list_select_actions

441: l_object_version_number NUMBER := p_object_version_number ;
442: l_list_select_action_id NUMBER := p_list_select_action_id ;
443: cursor c_chk_col_exists is
444: select 'x'
445: from ams_list_select_actions
446: where list_select_action_id = p_list_select_action_id;
447:
448: CURSOR c_obj_verno IS
449: SELECT object_version_number, last_updated_by

Line 450: FROM ams_list_select_actions

446: where list_select_action_id = p_list_select_action_id;
447:
448: CURSOR c_obj_verno IS
449: SELECT object_version_number, last_updated_by
450: FROM ams_list_select_actions
451: WHERE list_select_action_id = p_list_select_action_id;
452:
453: begin
454: if p_OWNER = 'SEED' then

Line 467: AMS_LIST_SELECT_ACTIONS_PKG.Insert_Row(

463: fetch c_chk_col_exists into l_dummy_char;
464: if c_chk_col_exists%notfound then
465: close c_chk_col_exists;
466:
467: AMS_LIST_SELECT_ACTIONS_PKG.Insert_Row(
468: px_list_select_action_id => l_list_select_action_id,
469: p_last_update_date => SYSDATE,
470: p_last_updated_by => nvl(l_user_id,p_last_updated_by),
471: p_creation_date => SYSDATE,

Line 511: -- Invoke table handler(AMS_LIST_SELECT_ACTIONS_PKG.Update_Row)

507: NVL(p_custom_mode,'PRESERVE')='FORCE') THEN
508:
509:
510:
511: -- Invoke table handler(AMS_LIST_SELECT_ACTIONS_PKG.Update_Row)
512: AMS_LIST_SELECT_ACTIONS_PKG.Update_Row(
513: p_list_select_action_id => l_list_select_action_id,
514: p_last_update_date => SYSDATE,
515: p_last_updated_by => nvl(l_user_id,p_last_updated_by),

Line 512: AMS_LIST_SELECT_ACTIONS_PKG.Update_Row(

508:
509:
510:
511: -- Invoke table handler(AMS_LIST_SELECT_ACTIONS_PKG.Update_Row)
512: AMS_LIST_SELECT_ACTIONS_PKG.Update_Row(
513: p_list_select_action_id => l_list_select_action_id,
514: p_last_update_date => SYSDATE,
515: p_last_updated_by => nvl(l_user_id,p_last_updated_by),
516: p_creation_date => SYSDATE,

Line 547: END AMS_LIST_SELECT_ACTIONS_PKG;

543: end if;
544: end;
545:
546:
547: END AMS_LIST_SELECT_ACTIONS_PKG;