APPS.AMS_DM_TARGETS_B_PKG dependencies on AMS_DM_TARGETS_B

Line 1: PACKAGE BODY AMS_DM_TARGETS_B_PKG as

1: PACKAGE BODY AMS_DM_TARGETS_B_PKG as
2: /* $Header: amstdtgb.pls 115.4 2003/09/15 12:44:47 rosharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_DM_TARGETS_B_PKG

2: /* $Header: amstdtgb.pls 115.4 2003/09/15 12:44:47 rosharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_DM_TARGETS_B_PKG
7: -- Purpose
8: --
9: -- History
10: -- 10-Apr-2002 nyostos Created.

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DM_TARGETS_B_PKG';

15: -- End of Comments
16: -- ===============================================================
17:
18:
19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DM_TARGETS_B_PKG';
20: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstdtgb.pls';
21:
22:
23: ----------------------------------------------------------

Line 69: INSERT INTO AMS_DM_TARGETS_B(

65:
66: px_object_version_number := 1;
67:
68:
69: INSERT INTO AMS_DM_TARGETS_B(
70: target_id,
71: last_update_date,
72: last_updated_by,
73: creation_date,

Line 164: AMS_UTILITY_PVT.debug_message('Table Handler Update going to Update AMS_DM_TARGETS_B' );

160: IS
161: BEGIN
162: IF (AMS_DEBUG_HIGH_ON) THEN
163:
164: AMS_UTILITY_PVT.debug_message('Table Handler Update going to Update AMS_DM_TARGETS_B' );
165: END IF;
166: IF (AMS_DEBUG_HIGH_ON) THEN
167:
168: AMS_UTILITY_PVT.debug_message(p_target_id || ' ' || p_last_update_date || ' ' || p_last_updated_by);

Line 182: Update AMS_DM_TARGETS_B

178: IF (AMS_DEBUG_HIGH_ON) THEN
179:
180: AMS_UTILITY_PVT.debug_message(p_data_source_id || ' ' || p_source_field_id);
181: END IF;
182: Update AMS_DM_TARGETS_B
183: SET
184: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
185: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
186: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 243: DELETE FROM AMS_DM_TARGETS_B

239: p_TARGET_ID NUMBER)
240: IS
241: BEGIN
242:
243: DELETE FROM AMS_DM_TARGETS_B
244: WHERE TARGET_ID = p_TARGET_ID;
245: If (SQL%NOTFOUND) then
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: End If;

Line 287: FROM AMS_DM_TARGETS_B

283:
284: IS
285: CURSOR C IS
286: SELECT *
287: FROM AMS_DM_TARGETS_B
288: WHERE TARGET_ID = p_TARGET_ID
289: FOR UPDATE of TARGET_ID NOWAIT;
290: Recinfo C%ROWTYPE;
291: BEGIN

Line 350: from AMS_DM_TARGETS_B B

346: BEGIN
347: delete from AMS_DM_TARGETS_TL T
348: where not exists
349: (select NULL
350: from AMS_DM_TARGETS_B B
351: where B.TARGET_ID = T.TARGET_ID
352: );
353:
354: update AMS_DM_TARGETS_TL T set (

Line 451: from ams_dm_targets_b

447: l_target_id number;
448:
449: cursor c_chk_target_exists is
450: select last_updated_by, nvl(object_version_number, 1)
451: from ams_dm_targets_b
452: where target_id = x_target_id;
453:
454: cursor c_get_target_id is
455: select ams_dm_targets_b_s.nextval

Line 455: select ams_dm_targets_b_s.nextval

451: from ams_dm_targets_b
452: where target_id = x_target_id;
453:
454: cursor c_get_target_id is
455: select ams_dm_targets_b_s.nextval
456: from dual;
457: BEGIN
458:
459: if x_owner = 'SEED' then

Line 475: AMS_DM_TARGETS_B_PKG.INSERT_ROW (

471: l_target_id := x_target_id;
472: end if;
473: l_obj_verno := 1;
474:
475: AMS_DM_TARGETS_B_PKG.INSERT_ROW (
476: px_target_id => l_target_id,
477: p_last_update_date => SYSDATE,
478: p_last_updated_by => l_user_id,
479: p_creation_date => SYSDATE,

Line 493: AMS_DM_TARGETS_B_PKG.UPDATE_ROW (

489: p_target_source_id => x_target_source_id
490: );
491: else
492: if ( l_db_luby_id IN (1, 2, 0) OR NVL(x_custom_mode,'PRESERVE') = 'FORCE') THEN
493: AMS_DM_TARGETS_B_PKG.UPDATE_ROW (
494: p_target_id => x_target_id,
495: p_last_update_date => SYSDATE,
496: p_last_updated_by => l_user_id,
497: p_creation_date => SYSDATE,

Line 516: END AMS_DM_TARGETS_B_PKG;

512: END load_row;
513:
514:
515:
516: END AMS_DM_TARGETS_B_PKG;