5:
6: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Ctd_PVT';
7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvctdb.pls';
8:
9: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
11:
12: -- ===============================================================
13: -- Start of Comments
6: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Ctd_PVT';
7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvctdb.pls';
8:
9: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
11:
12: -- ===============================================================
13: -- Start of Comments
14: -- Package name
284: null,
285: null,
286: 1,
287: sysdate,
288: FND_GLOBAL.USER_ID,
289: FND_GLOBAL.USER_ID,
290: sysdate,
291: FND_GLOBAL.USER_ID,
292: null
285: null,
286: 1,
287: sysdate,
288: FND_GLOBAL.USER_ID,
289: FND_GLOBAL.USER_ID,
290: sysdate,
291: FND_GLOBAL.USER_ID,
292: null
293:
287: sysdate,
288: FND_GLOBAL.USER_ID,
289: FND_GLOBAL.USER_ID,
290: sysdate,
291: FND_GLOBAL.USER_ID,
292: null
293:
294: );
295:
496: -- =========================================================================
497: -- Validate Environment
498: -- =========================================================================
499:
500: IF FND_GLOBAL.User_Id IS NULL
501: THEN
502: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;