APPS.AMS_LIST_SRC_TYPE_ASSOCS_PKG dependencies on AMS_LIST_SRC_TYPE_ASSOCS

Line 1: PACKAGE BODY AMS_LIST_SRC_TYPE_ASSOCS_PKG as

1: PACKAGE BODY AMS_LIST_SRC_TYPE_ASSOCS_PKG as
2: /* $Header: amststab.pls 120.0 2005/05/31 20:47:13 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_LIST_SRC_TYPE_ASSOCS_PKG

2: /* $Header: amststab.pls 120.0 2005/05/31 20:47:13 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_LIST_SRC_TYPE_ASSOCS_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 67: INSERT INTO AMS_LIST_SRC_TYPE_ASSOCS(

63:
64: px_object_version_number := 1;
65:
66:
67: INSERT INTO AMS_LIST_SRC_TYPE_ASSOCS(
68: list_source_type_assoc_id,
69: last_update_date,
70: last_updated_by,
71: creation_date,

Line 131: Update AMS_LIST_SRC_TYPE_ASSOCS

127: p_master_source_type_pk_column VARCHAR2)
128:
129: IS
130: BEGIN
131: Update AMS_LIST_SRC_TYPE_ASSOCS
132: SET
133: list_source_type_assoc_id = DECODE( p_list_source_type_assoc_id, FND_API.g_miss_num, list_source_type_assoc_id, p_list_source_type_assoc_id),
134: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
135: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 175: DELETE FROM AMS_LIST_SRC_TYPE_ASSOCS

171: PROCEDURE Delete_Row(
172: p_LIST_SOURCE_TYPE_ASSOC_ID NUMBER)
173: IS
174: BEGIN
175: DELETE FROM AMS_LIST_SRC_TYPE_ASSOCS
176: WHERE LIST_SOURCE_TYPE_ASSOC_ID = p_LIST_SOURCE_TYPE_ASSOC_ID;
177: If (SQL%NOTFOUND) then
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: End If;

Line 218: FROM AMS_LIST_SRC_TYPE_ASSOCS

214:
215: IS
216: CURSOR C IS
217: SELECT *
218: FROM AMS_LIST_SRC_TYPE_ASSOCS
219: WHERE LIST_SOURCE_TYPE_ASSOC_ID = p_LIST_SOURCE_TYPE_ASSOC_ID
220: FOR UPDATE of LIST_SOURCE_TYPE_ASSOC_ID NOWAIT;
221: Recinfo C%ROWTYPE;
222: BEGIN

Line 298: FROM ams_list_src_type_assocs

294: l_last_updated_by number;
295:
296: CURSOR c_obj_verno IS
297: SELECT object_version_number, last_updated_by
298: FROM ams_list_src_type_assocs
299: WHERE list_source_type_assoc_id = x_list_source_type_assoc_id;
300:
301: CURSOR c_chk_exists is
302: SELECT 'x'

Line 303: FROM ams_list_src_type_assocs

299: WHERE list_source_type_assoc_id = x_list_source_type_assoc_id;
300:
301: CURSOR c_chk_exists is
302: SELECT 'x'
303: FROM ams_list_src_type_assocs
304: WHERE list_source_type_assoc_id = x_list_source_type_assoc_id;
305:
306: CURSOR c_get_id is
307: SELECT ams_list_src_type_assocs_s.NEXTVAL

Line 307: SELECT ams_list_src_type_assocs_s.NEXTVAL

303: FROM ams_list_src_type_assocs
304: WHERE list_source_type_assoc_id = x_list_source_type_assoc_id;
305:
306: CURSOR c_get_id is
307: SELECT ams_list_src_type_assocs_s.NEXTVAL
308: FROM DUAL;
309: BEGIN
310: if X_OWNER = 'SEED' then
311: l_user_id := 1;

Line 332: ams_list_src_type_assocs_pkg.insert_row (

328: l_list_source_type_assoc_id := x_list_source_type_assoc_id;
329: END IF;
330: l_obj_verno := 1;
331:
332: ams_list_src_type_assocs_pkg.insert_row (
333: --x_rowid => l_row_id,
334: px_list_source_type_assoc_id => l_list_source_type_assoc_id,
335: p_last_update_date => SYSDATE,
336: p_last_updated_by => l_user_id,

Line 360: ams_list_src_type_assocs_pkg.update_row (

356:
357: if (l_last_updated_by in (1,2,0) OR
358: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
359:
360: ams_list_src_type_assocs_pkg.update_row (
361: p_list_source_type_assoc_id => x_list_source_type_assoc_id,
362: p_last_update_date => SYSDATE,
363: p_last_updated_by => l_user_id,
364: p_creation_date => sysdate,

Line 380: END AMS_LIST_SRC_TYPE_ASSOCS_PKG;

376:
377: END IF;
378: END load_row;
379:
380: END AMS_LIST_SRC_TYPE_ASSOCS_PKG;