DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_PVT dependencies on AMS_DM_TARGET_PVT

Line 1: PACKAGE BODY AMS_DM_TARGET_PVT as

1: PACKAGE BODY AMS_DM_TARGET_PVT as
2: /* $Header: amsvdtgb.pls 120.0 2005/05/31 19:31:20 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_DM_TARGET_PVT

2: /* $Header: amsvdtgb.pls 120.0 2005/05/31 19:31:20 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_DM_TARGET_PVT
7: -- Purpose
8: --
9: -- History
10: -- 10-Apr-2002 nyostos Created.

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

16: -- End of Comments
17: -- ===============================================================
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_DM_TARGET_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvdtgb.pls';
22:
23: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 60: l_dm_target_rec AMS_DM_TARGET_PVT.dm_target_rec_type := p_dm_target_rec;

56: l_object_version_number NUMBER := 1;
57: l_org_id NUMBER := FND_API.G_MISS_NUM;
58: l_TARGET_ID NUMBER;
59: l_dummy NUMBER;
60: l_dm_target_rec AMS_DM_TARGET_PVT.dm_target_rec_type := p_dm_target_rec;
61:
62: CURSOR c_id IS
63: SELECT AMS_DM_TARGETS_B_s.NEXTVAL
64: FROM dual;

Line 283: l_tar_dm_target_rec AMS_DM_TARGET_PVT.dm_target_rec_type := P_dm_target_rec;

279: -- Local Variables
280: l_object_version_number NUMBER;
281: l_TARGET_ID NUMBER;
282: l_ref_dm_target_rec c_get_Dmtarget%ROWTYPE ;
283: l_tar_dm_target_rec AMS_DM_TARGET_PVT.dm_target_rec_type := P_dm_target_rec;
284: l_rowid ROWID;
285:
286:
287: BEGIN

Line 1311: l_dm_target_rec AMS_DM_TARGET_PVT.dm_target_rec_type;

1307: IS
1308: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Dmtarget';
1309: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1310: l_object_version_number NUMBER;
1311: l_dm_target_rec AMS_DM_TARGET_PVT.dm_target_rec_type;
1312:
1313: BEGIN
1314: -- Standard Start of API savepoint
1315: SAVEPOINT VALIDATE_Dmtarget_;

Line 1850: END AMS_DM_TARGET_PVT;

1846: END LOOP;
1847: RETURN l_table;
1848: END in_list;
1849:
1850: END AMS_DM_TARGET_PVT;