APPS.AMS_DM_TARGET_SOURCES_PKG dependencies on AMS_DM_TARGET_SOURCES

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 61: INSERT INTO ams_dm_target_sources(

57:
58: px_object_version_number := nvl(px_object_version_number, 1);
59:
60:
61: INSERT INTO ams_dm_target_sources(
62: target_source_id,
63: last_update_date,
64: last_updated_by,
65: creation_date,

Line 111: Update ams_dm_target_sources

107: p_data_source_id NUMBER)
108:
109: IS
110: BEGIN
111: Update ams_dm_target_sources
112: SET
113: target_source_id = DECODE( p_target_source_id, null, target_source_id, FND_API.G_MISS_NUM, null, p_target_source_id),
114: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 150: DELETE FROM ams_dm_target_sources

146: p_target_source_id NUMBER,
147: p_object_version_number NUMBER)
148: IS
149: BEGIN
150: DELETE FROM ams_dm_target_sources
151: WHERE target_source_id = p_target_source_id
152: AND object_version_number = p_object_version_number;
153: If (SQL%NOTFOUND) then
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 180: FROM ams_dm_target_sources

176: p_object_version_number NUMBER)
177: IS
178: CURSOR C IS
179: SELECT *
180: FROM ams_dm_target_sources
181: WHERE target_source_id = p_target_source_id
182: AND object_version_number = p_object_version_number
183: FOR UPDATE OF target_source_id NOWAIT;
184: Recinfo C%ROWTYPE;

Line 213: from ams_dm_target_sources

209: l_target_source_id number := x_target_source_id;
210:
211: cursor c_chk_target_source_exists is
212: select last_updated_by, nvl(object_version_number, 1)
213: from ams_dm_target_sources
214: where target_source_id = x_target_source_id;
215:
216: cursor c_get_target_source_id is
217: select ams_dm_target_sources_s.nextval

Line 217: select ams_dm_target_sources_s.nextval

213: from ams_dm_target_sources
214: where target_source_id = x_target_source_id;
215:
216: cursor c_get_target_source_id is
217: select ams_dm_target_sources_s.nextval
218: from dual;
219:
220: BEGIN
221:

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;