DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_VALUES_B_PKG dependencies on AMS_DM_TARGET_VALUES_B

Line 1: PACKAGE BODY AMS_DM_TARGET_VALUES_B_PKG as

1: PACKAGE BODY AMS_DM_TARGET_VALUES_B_PKG as
2: /* $Header: amstdtvb.pls 115.5 2003/03/07 03:54:23 choang noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_DM_TARGET_VALUES_B_PKG

2: /* $Header: amstdtvb.pls 115.5 2003/03/07 03:54:23 choang noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_DM_TARGET_VALUES_B_PKG
7: -- Purpose
8: --
9: -- History
10: -- 08-Oct-2002 nyostos Added value_condition column

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_DM_TARGET_VALUES_B_PKG';

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

Line 63: INSERT INTO AMS_DM_TARGET_VALUES_B(

59: BEGIN
60: px_object_version_number := 1;
61:
62:
63: INSERT INTO AMS_DM_TARGET_VALUES_B(
64: target_value_id,
65: last_update_date,
66: last_updated_by,
67: creation_date,

Line 146: Update AMS_DM_TARGET_VALUES_B

142: p_range_value IN VARCHAR2,
143: p_description VARCHAR2)
144: IS
145: BEGIN
146: Update AMS_DM_TARGET_VALUES_B
147: SET
148: target_value_id = DECODE( p_target_value_id, FND_API.g_miss_num, target_value_id, p_target_value_id),
149: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
150: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 194: DELETE FROM AMS_DM_TARGET_VALUES_B

190: PROCEDURE Delete_Row(
191: p_TARGET_VALUE_ID NUMBER)
192: IS
193: BEGIN
194: DELETE FROM AMS_DM_TARGET_VALUES_B
195: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID;
196: If (SQL%NOTFOUND) then
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: End If;

Line 236: FROM AMS_DM_TARGET_VALUES_B

232: p_target_value VARCHAR2)
233: IS
234: CURSOR C IS
235: SELECT *
236: FROM AMS_DM_TARGET_VALUES_B
237: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID
238: FOR UPDATE of TARGET_VALUE_ID NOWAIT;
239: Recinfo C%ROWTYPE;
240: BEGIN

Line 270: from AMS_DM_TARGET_VALUES_B B

266:
267: delete from AMS_DM_TARGET_VALUES_TL T
268: where not exists
269: (select NULL
270: from AMS_DM_TARGET_VALUES_B B
271: where B.TARGET_VALUE_ID = T.TARGET_VALUE_ID
272: );
273:
274: update AMS_DM_TARGET_VALUES_TL T set (

Line 363: from ams_dm_target_values_b

359: l_target_value_id number;
360:
361: cursor c_chk_target_value_exists is
362: select last_updated_by, nvl(object_version_number, 1)
363: from ams_dm_target_values_b
364: where target_value_id = x_target_value_id;
365:
366: cursor c_get_target_value_id is
367: select ams_dm_target_values_b_s.nextval

Line 367: select ams_dm_target_values_b_s.nextval

363: from ams_dm_target_values_b
364: where target_value_id = x_target_value_id;
365:
366: cursor c_get_target_value_id is
367: select ams_dm_target_values_b_s.nextval
368: from dual;
369:
370: BEGIN
371:

Line 389: AMS_DM_TARGET_VALUES_B_PKG.INSERT_ROW (

385: end if;
386:
387: l_obj_verno := 1;
388:
389: AMS_DM_TARGET_VALUES_B_PKG.INSERT_ROW (
390: px_target_value_id => l_target_value_id,
391: p_last_update_date => SYSDATE,
392: p_last_updated_by => l_user_id,
393: p_creation_date => SYSDATE,

Line 405: AMS_DM_TARGET_VALUES_B_PKG.UPDATE_ROW (

401: p_description => x_description
402: );
403: else
404: if ( l_db_luby_id IN (1, 2, 0) OR NVL(x_custom_mode,'PRESERVE') = 'FORCE') THEN
405: AMS_DM_TARGET_VALUES_B_PKG.UPDATE_ROW (
406: p_target_value_id => x_target_value_id,
407: p_last_update_date => SYSDATE,
408: p_last_updated_by => l_user_id,
409: p_last_update_login => 0,

Line 422: END AMS_DM_TARGET_VALUES_B_PKG;

418: end if;
419: close c_chk_target_value_exists;
420: END load_row;
421:
422: END AMS_DM_TARGET_VALUES_B_PKG;