DBA Data[Home] [Help]

APPS.AMS_ADHOC_PARAM_PVT dependencies on AMS_ADHOC_PARAM_PVT

Line 1: PACKAGE BODY AMS_Adhoc_Param_PVT as

1: PACKAGE BODY AMS_Adhoc_Param_PVT as
2: /* $Header: amsvapvb.pls 120.0 2005/07/01 03:54:13 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_Adhoc_Param_PVT

2: /* $Header: amsvapvb.pls 120.0 2005/07/01 03:54:13 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_Adhoc_Param_PVT
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Adhoc_Param_PVT';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Adhoc_Param_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvapvb.pls';
19:
20: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
21: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 234: l_tar_adhoc_param_rec AMS_Adhoc_Param_PVT.adhoc_param_rec_type := P_adhoc_param_rec;

230: -- Local Variables
231: l_object_version_number NUMBER;
232: l_ADHOC_PARAM_ID NUMBER;
233: l_ref_adhoc_param_rec c_get_Adhoc_Param%ROWTYPE ;
234: l_tar_adhoc_param_rec AMS_Adhoc_Param_PVT.adhoc_param_rec_type := P_adhoc_param_rec;
235: l_rowid ROWID;
236:
237: BEGIN
238: -- Standard Start of API savepoint

Line 942: l_adhoc_param_rec AMS_Adhoc_Param_PVT.adhoc_param_rec_type;

938: IS
939: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Adhoc_Param';
940: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
941: l_object_version_number NUMBER;
942: l_adhoc_param_rec AMS_Adhoc_Param_PVT.adhoc_param_rec_type;
943:
944: BEGIN
945: -- Standard Start of API savepoint
946: SAVEPOINT VALIDATE_Adhoc_Param_;

Line 1089: END AMS_Adhoc_Param_PVT;

1085: p_data => x_msg_data
1086: );
1087: END Validate_adhoc_param_Rec;
1088:
1089: END AMS_Adhoc_Param_PVT;