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 1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;

1272:
1273: BEGIN
1274:
1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;

Line 1277: v_current_login:= FND_GLOBAL.LOGIN_ID;

1273: BEGIN
1274:
1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1281:

Line 1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;

1274:
1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1281:
1282: LOG_MESSAGE('--------------------------------------------------------');

Line 1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;

1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1281:
1282: LOG_MESSAGE('--------------------------------------------------------');
1283: LOG_MESSAGE(' Populating Available Resources.........................');

Line 1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;

1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1281:
1282: LOG_MESSAGE('--------------------------------------------------------');
1283: LOG_MESSAGE(' Populating Available Resources.........................');
1284: LOG_MESSAGE('--------------------------------------------------------');

Line 1638: ,FND_GLOBAL.USER_ID

1634: ,NULL /*STATUS*/
1635: ,NULL /*APPLIED*/
1636: ,2 /*UPDATED*/
1637: ,SYSDATE
1638: ,FND_GLOBAL.USER_ID
1639: ,SYSDATE
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */

Line 1640: ,FND_GLOBAL.USER_ID

1636: ,2 /*UPDATED*/
1637: ,SYSDATE
1638: ,FND_GLOBAL.USER_ID
1639: ,SYSDATE
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */

Line 1641: ,FND_GLOBAL.LOGIN_ID

1637: ,SYSDATE
1638: ,FND_GLOBAL.USER_ID
1639: ,SYSDATE
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1645: ,SYSDATE /* PROGRAM_UPDATE_DATE */

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

1638: ,FND_GLOBAL.USER_ID
1639: ,SYSDATE
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1645: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1646: ,arg_refresh_number

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

1639: ,SYSDATE
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1645: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1646: ,arg_refresh_number
1647: FROM msc_calendar_dates dates,

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

1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1645: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1646: ,arg_refresh_number
1647: FROM msc_calendar_dates dates,
1648: msc_department_resources line,

Line 1706: ,FND_GLOBAL.USER_ID

1702: ,NULL /*STATUS*/
1703: ,NULL /*APPLIED*/
1704: ,2 /*UPDATED*/
1705: ,SYSDATE
1706: ,FND_GLOBAL.USER_ID
1707: ,SYSDATE
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */

Line 1708: ,FND_GLOBAL.USER_ID

1704: ,2 /*UPDATED*/
1705: ,SYSDATE
1706: ,FND_GLOBAL.USER_ID
1707: ,SYSDATE
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1711: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1712: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */

Line 1709: ,FND_GLOBAL.LOGIN_ID

1705: ,SYSDATE
1706: ,FND_GLOBAL.USER_ID
1707: ,SYSDATE
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1711: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1712: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1713: ,SYSDATE /* PROGRAM_UPDATE_DATE */

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

1706: ,FND_GLOBAL.USER_ID
1707: ,SYSDATE
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1711: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1712: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1713: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1714: ,arg_refresh_number

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

1707: ,SYSDATE
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1711: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1712: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1713: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1714: ,arg_refresh_number
1715: FROM

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

1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1711: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1712: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1713: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1714: ,arg_refresh_number
1715: FROM
1716: msc_department_resources line,

Line 1779: FND_GLOBAL.USER_ID,

1775: SELECT
1776: APPS_VER,
1777: SYSDATE,
1778: SYSDATE,
1779: FND_GLOBAL.USER_ID,
1780: SYSDATE,
1781: FND_GLOBAL.USER_ID,
1782: UPPER(INSTANCE_CODE), /* Bug 2129155 */
1783: INSTANCE_TYPE, -- OPM

Line 1781: FND_GLOBAL.USER_ID,

1777: SYSDATE,
1778: SYSDATE,
1779: FND_GLOBAL.USER_ID,
1780: SYSDATE,
1781: FND_GLOBAL.USER_ID,
1782: UPPER(INSTANCE_CODE), /* Bug 2129155 */
1783: INSTANCE_TYPE, -- OPM
1784: nvl(LCID,0)
1785: INTO

Line 2732: v_current_user := FND_GLOBAL.USER_ID;

2728:
2729: BEGIN
2730:
2731: v_current_date := SYSDATE;
2732: v_current_user := FND_GLOBAL.USER_ID;
2733: v_current_login := FND_GLOBAL.LOGIN_ID;
2734: lv_plan_name := fnd_profile.VALUE ('AHL_MSC_RES_CPCTY_PLAN');
2735: LV_SOURCE_APPLICATION := 'MSC';
2736: lv_ahl_schema := MSC_UTIL.GET_SCHEMA_NAME(867);

Line 2733: v_current_login := FND_GLOBAL.LOGIN_ID;

2729: BEGIN
2730:
2731: v_current_date := SYSDATE;
2732: v_current_user := FND_GLOBAL.USER_ID;
2733: v_current_login := FND_GLOBAL.LOGIN_ID;
2734: lv_plan_name := fnd_profile.VALUE ('AHL_MSC_RES_CPCTY_PLAN');
2735: LV_SOURCE_APPLICATION := 'MSC';
2736: lv_ahl_schema := MSC_UTIL.GET_SCHEMA_NAME(867);
2737: