APPS.AMS_DLG_IDENTIFY_ITEMS_PKG dependencies on AMS_DLG_IDENTIFY_ITEMS

Line 1: PACKAGE BODY AMS_DLG_IDENTIFY_ITEMS_PKG as

1: PACKAGE BODY AMS_DLG_IDENTIFY_ITEMS_PKG as
2: /* $Header: amstdiib.pls 115.0 2002/04/28 20:28:13 pkm ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_DLG_IDENTIFY_ITEMS_PKG

2: /* $Header: amstdiib.pls 115.0 2002/04/28 20:28:13 pkm ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_DLG_IDENTIFY_ITEMS_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 45: INSERT INTO AMS_DLG_IDENTIFY_ITEMS(

41:
42: px_object_version_number := 1;
43:
44:
45: INSERT INTO AMS_DLG_IDENTIFY_ITEMS(
46: item_id,
47: list_source_type_id,
48: list_source_field_id,
49: source_type_code,

Line 88: Update AMS_DLG_IDENTIFY_ITEMS

84: p_rule_id NUMBER)
85:
86: IS
87: BEGIN
88: Update AMS_DLG_IDENTIFY_ITEMS
89: SET
90: item_id = DECODE( p_item_id, FND_API.g_miss_num, item_id, p_item_id),
91: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
92: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),

Line 113: DELETE FROM AMS_DLG_IDENTIFY_ITEMS

109: PROCEDURE Delete_Row(
110: p_ITEM_ID NUMBER)
111: IS
112: BEGIN
113: DELETE FROM AMS_DLG_IDENTIFY_ITEMS
114: WHERE ITEM_ID = p_ITEM_ID;
115: If (SQL%NOTFOUND) then
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: End If;

Line 137: from ams_dlg_identify_items

133: l_item_id number;
134:
135: cursor c_obj_verno is
136: select object_version_number
137: from ams_dlg_identify_items
138: where item_id = p_item_id;
139:
140: cursor c_chk_identify_item_exists is
141: select 'x'

Line 142: from ams_dlg_identify_items

138: where item_id = p_item_id;
139:
140: cursor c_chk_identify_item_exists is
141: select 'x'
142: from ams_dlg_identify_items
143: where item_id = p_item_id;
144:
145: BEGIN
146:

Line 159: AMS_DLG_IDENTIFY_ITEMS_PKG.Insert_Row(

155: fetch c_chk_identify_item_exists into l_dummy_char;
156:
157: if (c_chk_identify_item_exists%notfound ) then
158:
159: AMS_DLG_IDENTIFY_ITEMS_PKG.Insert_Row(
160: px_item_id => l_item_id,
161: p_list_source_type_id => p_list_source_type_id,
162: p_list_source_field_id => p_list_source_field_id,
163: p_source_type_code => p_source_type_code,

Line 179: AMS_DLG_IDENTIFY_ITEMS_PKG.Update_Row(

175: open c_obj_verno;
176: fetch c_obj_verno into l_obj_verno;
177: close c_obj_verno;
178:
179: AMS_DLG_IDENTIFY_ITEMS_PKG.Update_Row(
180: p_item_id => p_item_id,
181: p_list_source_type_id => p_list_source_type_id,
182: p_list_source_field_id => p_list_source_field_id,
183: p_source_type_code => p_source_type_code,

Line 198: END AMS_DLG_IDENTIFY_ITEMS_PKG;

194: END load_row;
195:
196: -- ========================================================
197:
198: END AMS_DLG_IDENTIFY_ITEMS_PKG;