DBA Data[Home] [Help]

APPS.AMW_PROCESS_CERT_SUMMARY dependencies on FND_GLOBAL

Line 4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1: PACKAGE BODY AMW_PROCESS_CERT_SUMMARY as
2: /* $Header: amwpcesb.pls 120.5.12000000.6 2007/03/28 21:21:09 npanandi ship $ */
3:
4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6:
7:
8:

Line 5: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1: PACKAGE BODY AMW_PROCESS_CERT_SUMMARY as
2: /* $Header: amwpcesb.pls 120.5.12000000.6 2007/03/28 21:21:09 npanandi ship $ */
3:
4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6:
7:
8:
9: PROCEDURE populate_assoc_opinion (

Line 1339: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1335: ORGS_IN_SCOPE = l_orgs_in_scope,
1336: ORGS_PENDING_IN_SCOPE = l_orgs_pending_in_scope,
1337: PERIOD_START_DATE = p_start_date,
1338: LAST_UPDATE_DATE = sysdate,
1339: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1340: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,
1341: ORGS_PENDING_CERTIFICATION = l_orgs_pending_cert
1342: WHERE certification_id = p_certification_id;
1343:

Line 1340: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,

1336: ORGS_PENDING_IN_SCOPE = l_orgs_pending_in_scope,
1337: PERIOD_START_DATE = p_start_date,
1338: LAST_UPDATE_DATE = sysdate,
1339: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1340: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,
1341: ORGS_PENDING_CERTIFICATION = l_orgs_pending_cert
1342: WHERE certification_id = p_certification_id;
1343:
1344: IF (SQL%NOTFOUND) THEN

Line 1380: FND_GLOBAL.USER_ID,

1376: l_ineffective_controls,
1377: l_orgs_in_scope,
1378: l_orgs_pending_in_scope,
1379: p_start_date,
1380: FND_GLOBAL.USER_ID,
1381: SYSDATE,
1382: SYSDATE,
1383: FND_GLOBAL.USER_ID,
1384: FND_GLOBAL.USER_ID,

Line 1383: FND_GLOBAL.USER_ID,

1379: p_start_date,
1380: FND_GLOBAL.USER_ID,
1381: SYSDATE,
1382: SYSDATE,
1383: FND_GLOBAL.USER_ID,
1384: FND_GLOBAL.USER_ID,
1385: l_orgs_pending_cert
1386: FROM DUAL;
1387: END IF;

Line 1384: FND_GLOBAL.USER_ID,

1380: FND_GLOBAL.USER_ID,
1381: SYSDATE,
1382: SYSDATE,
1383: FND_GLOBAL.USER_ID,
1384: FND_GLOBAL.USER_ID,
1385: l_orgs_pending_cert
1386: FROM DUAL;
1387: END IF;
1388: commit;