DBA Data[Home] [Help]

APPS.AMW_OBJECT_ASSESSMENTS_PVT dependencies on FND_GLOBAL

Line 4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1: PACKAGE BODY AMW_OBJECT_ASSESSMENTS_PVT AS
2: /* $Header: amwobassb.pls 120.0 2005/05/31 22:21:42 appldev noship $ */
3:
4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6:
7: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'AMW_OBJECT_ASSESSMENTS_PVT';
8: G_FILE_NAME CONSTANT VARCHAR2 (15) := 'amwobassb.pls';

Line 5: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1: PACKAGE BODY AMW_OBJECT_ASSESSMENTS_PVT AS
2: /* $Header: amwobassb.pls 120.0 2005/05/31 22:21:42 appldev noship $ */
3:
4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6:
7: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'AMW_OBJECT_ASSESSMENTS_PVT';
8: G_FILE_NAME CONSTANT VARCHAR2 (15) := 'amwobassb.pls';
9:

Line 112: fnd_global.user_id,

108: p_certification_id,
109: p_org_id,
110: p_process_id,
111: sysdate,
112: fnd_global.user_id,
113: sysdate,
114: fnd_global.user_id,
115: fnd_global.user_id,
116: 1

Line 114: fnd_global.user_id,

110: p_process_id,
111: sysdate,
112: fnd_global.user_id,
113: sysdate,
114: fnd_global.user_id,
115: fnd_global.user_id,
116: 1
117: FROM dual
118: WHERE NOT EXISTS

Line 115: fnd_global.user_id,

111: sysdate,
112: fnd_global.user_id,
113: sysdate,
114: fnd_global.user_id,
115: fnd_global.user_id,
116: 1
117: FROM dual
118: WHERE NOT EXISTS
119: (SELECT 'Y' FROM amw_object_assessments