DBA Data[Home] [Help]

APPS.MSC_RESOURCE_AVAILABILITY dependencies on FND_GLOBAL

Line 40: IF fnd_global.conc_request_id > 0 THEN -- concurrent program

36: PROCEDURE LOG_MESSAGE( pBUFF IN VARCHAR2)
37: IS
38: BEGIN
39:
40: IF fnd_global.conc_request_id > 0 THEN -- concurrent program
41: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);
42: ELSE
43: --DBMS_OUTPUT.PUT_LINE( pBUFF);
44: NULL;

Line 1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;

1260:
1261: BEGIN
1262:
1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;

Line 1265: v_current_login:= FND_GLOBAL.LOGIN_ID;

1261: BEGIN
1262:
1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1269:

Line 1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;

1262:
1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1269:
1270: LOG_MESSAGE('--------------------------------------------------------');

Line 1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;

1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1269:
1270: LOG_MESSAGE('--------------------------------------------------------');
1271: LOG_MESSAGE(' Populating Available Resources.........................');

Line 1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;

1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1269:
1270: LOG_MESSAGE('--------------------------------------------------------');
1271: LOG_MESSAGE(' Populating Available Resources.........................');
1272: LOG_MESSAGE('--------------------------------------------------------');

Line 1626: ,FND_GLOBAL.USER_ID

1622: ,NULL /*STATUS*/
1623: ,NULL /*APPLIED*/
1624: ,2 /*UPDATED*/
1625: ,SYSDATE
1626: ,FND_GLOBAL.USER_ID
1627: ,SYSDATE
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */

Line 1628: ,FND_GLOBAL.USER_ID

1624: ,2 /*UPDATED*/
1625: ,SYSDATE
1626: ,FND_GLOBAL.USER_ID
1627: ,SYSDATE
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */

Line 1629: ,FND_GLOBAL.LOGIN_ID

1625: ,SYSDATE
1626: ,FND_GLOBAL.USER_ID
1627: ,SYSDATE
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1633: ,SYSDATE /* PROGRAM_UPDATE_DATE */

Line 1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */

1626: ,FND_GLOBAL.USER_ID
1627: ,SYSDATE
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1633: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1634: ,arg_refresh_number

Line 1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */

1627: ,SYSDATE
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1633: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1634: ,arg_refresh_number
1635: FROM msc_calendar_dates dates,

Line 1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */

1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1633: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1634: ,arg_refresh_number
1635: FROM msc_calendar_dates dates,
1636: msc_department_resources line,

Line 1694: ,FND_GLOBAL.USER_ID

1690: ,NULL /*STATUS*/
1691: ,NULL /*APPLIED*/
1692: ,2 /*UPDATED*/
1693: ,SYSDATE
1694: ,FND_GLOBAL.USER_ID
1695: ,SYSDATE
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */

Line 1696: ,FND_GLOBAL.USER_ID

1692: ,2 /*UPDATED*/
1693: ,SYSDATE
1694: ,FND_GLOBAL.USER_ID
1695: ,SYSDATE
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */

Line 1697: ,FND_GLOBAL.LOGIN_ID

1693: ,SYSDATE
1694: ,FND_GLOBAL.USER_ID
1695: ,SYSDATE
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1701: ,SYSDATE /* PROGRAM_UPDATE_DATE */

Line 1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */

1694: ,FND_GLOBAL.USER_ID
1695: ,SYSDATE
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1701: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1702: ,arg_refresh_number

Line 1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */

1695: ,SYSDATE
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1701: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1702: ,arg_refresh_number
1703: FROM

Line 1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */

1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1701: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1702: ,arg_refresh_number
1703: FROM
1704: msc_department_resources line,

Line 1767: FND_GLOBAL.USER_ID,

1763: SELECT
1764: APPS_VER,
1765: SYSDATE,
1766: SYSDATE,
1767: FND_GLOBAL.USER_ID,
1768: SYSDATE,
1769: FND_GLOBAL.USER_ID,
1770: UPPER(INSTANCE_CODE), /* Bug 2129155 */
1771: INSTANCE_TYPE, -- OPM

Line 1769: FND_GLOBAL.USER_ID,

1765: SYSDATE,
1766: SYSDATE,
1767: FND_GLOBAL.USER_ID,
1768: SYSDATE,
1769: FND_GLOBAL.USER_ID,
1770: UPPER(INSTANCE_CODE), /* Bug 2129155 */
1771: INSTANCE_TYPE, -- OPM
1772: nvl(LCID,0)
1773: INTO