APPS.AMS_DM_TARGET_VALUE_PVT dependencies on AMS_DM_TARGET_VALUE_PVT

Line 1: PACKAGE BODY AMS_Dm_Target_Value_PVT as

1: PACKAGE BODY AMS_Dm_Target_Value_PVT as
2: /* $Header: amsvdtvb.pls 115.9 2003/03/19 06:08:40 rosharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_Dm_Target_Value_PVT

2: /* $Header: amsvdtvb.pls 115.9 2003/03/19 06:08:40 rosharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_Dm_Target_Value_PVT
7: -- Purpose
8: --
9: -- History
10: -- 08-Oct-2002 nyostos Added value_condition column

Line 23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Dm_Target_Value_PVT';

19: -- End of Comments
20: -- ===============================================================
21:
22:
23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Dm_Target_Value_PVT';
24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvdtvb.pls';
25:
26: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 64: l_dm_target_value_rec AMS_Dm_Target_Value_PVT.dm_target_value_rec_type := p_dm_target_value_rec;

60: l_object_version_number NUMBER := 1;
61: l_org_id NUMBER := FND_API.G_MISS_NUM;
62: l_TARGET_VALUE_ID NUMBER;
63: l_dummy NUMBER;
64: l_dm_target_value_rec AMS_Dm_Target_Value_PVT.dm_target_value_rec_type := p_dm_target_value_rec;
65: l_datasource_id NUMBER;
66:
67: CURSOR c_id IS
68: SELECT AMS_DM_TARGET_VALUES_B_s.NEXTVAL

Line 310: l_tar_dm_target_value_rec AMS_Dm_Target_Value_PVT.dm_target_value_rec_type := P_dm_target_value_rec;

306: -- Local Variables
307: l_object_version_number NUMBER;
308: l_TARGET_VALUE_ID NUMBER;
309: l_ref_dm_target_value_rec c_get_Dm_Target_Value%ROWTYPE ;
310: l_tar_dm_target_value_rec AMS_Dm_Target_Value_PVT.dm_target_value_rec_type := P_dm_target_value_rec;
311: l_rowid ROWID;
312:
313: BEGIN
314: -- Standard Start of API savepoint

Line 1246: -- l_dm_target_value_rec AMS_Dm_Target_Value_PVT.dm_target_value_rec_type;

1242: IS
1243: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Dm_Target_Value';
1244: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1245: l_object_version_number NUMBER;
1246: -- l_dm_target_value_rec AMS_Dm_Target_Value_PVT.dm_target_value_rec_type;
1247:
1248: BEGIN
1249: -- Standard Start of API savepoint
1250: SAVEPOINT VALIDATE_Dm_Target_Value_;

Line 1464: END AMS_Dm_Target_Value_PVT;

1460: p_data => x_msg_data
1461: );
1462: END Validate_dm_target_value_Rec;
1463:
1464: END AMS_Dm_Target_Value_PVT;