APPS.AMS_DM_TARGET_SOURCES_PKG dependencies on AMS_DM_TARGET_SOURCES_PKG

Line 1: PACKAGE BODY AMS_Dm_Target_Sources_PKG as

1: PACKAGE BODY AMS_Dm_Target_Sources_PKG as
2: /* $Header: amstdtsb.pls 115.6 2003/12/24 22:51:00 choang noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_Dm_Target_Sources_PKG

2: /* $Header: amstdtsb.pls 115.6 2003/12/24 22:51:00 choang noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_Dm_Target_Sources_PKG
7: -- Purpose
8: --
9: -- History
10: -- 17-Dec-2003 choang bug 3316903: fixed load_row logic

Line 22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Dm_Target_Sources_PKG';

18: -- End of Comments
19: -- ===============================================================
20:
21:
22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Dm_Target_Sources_PKG';
23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstdtsb.pls';
24:
25:
26:

Line 246: AMS_Dm_Target_Sources_PKG.Insert_Row(

242: l_obj_verno := 1;
243:
244: -- choang - 24-Dec-2003 - fixed 3338413: changed parameter for
245: -- target_source_id
246: AMS_Dm_Target_Sources_PKG.Insert_Row(
247: px_target_source_id => l_target_source_id,
248: p_last_update_date => SYSDATE,
249: p_last_updated_by => l_user_id,
250: p_creation_date => SYSDATE,

Line 262: AMS_Dm_Target_Sources_PKG.Update_Row(

258: else
259: l_target_source_id := x_target_source_id;
260:
261: if ( l_db_luby_id IN (1, 2, 0) OR NVL(x_custom_mode,'PRESERVE') = 'FORCE') THEN
262: AMS_Dm_Target_Sources_PKG.Update_Row(
263: p_target_source_id => l_target_source_id,
264: p_last_update_date => SYSDATE,
265: p_last_updated_by => l_user_id,
266: p_last_update_login => 0,

Line 276: END AMS_Dm_Target_Sources_PKG;

272: end if;
273: close c_chk_target_source_exists;
274: END load_row;
275:
276: END AMS_Dm_Target_Sources_PKG;