eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_DEMAND_PKG dependencies on FND_GLOBAL

Line 68: l_user_id := fnd_global.user_id;

64: -- initial there is no error message
65: l_api_name := 'msc_demand_f_pkg.populate_details';
66: l_stmt_id :=1;
67:
68: l_user_id := fnd_global.user_id;
69: l_sysdate :=sysdate;
70: l_user_login_id :=fnd_global.login_id;
71: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
72: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 70: l_user_login_id :=fnd_global.login_id;

66: l_stmt_id :=1;
67:
68: l_user_id := fnd_global.user_id;
69: l_sysdate :=sysdate;
70: l_user_login_id :=fnd_global.login_id;
71: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
72: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
73: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
74: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

Line 71: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;

67:
68: l_user_id := fnd_global.user_id;
69: l_sysdate :=sysdate;
70: l_user_login_id :=fnd_global.login_id;
71: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
72: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
73: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
74: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
75:

Line 72: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

68: l_user_id := fnd_global.user_id;
69: l_sysdate :=sysdate;
70: l_user_login_id :=fnd_global.login_id;
71: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
72: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
73: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
74: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
75:
76: l_stmt_id :=5;

Line 73: l_appl_id := FND_GLOBAL.PROG_APPL_ID;

69: l_sysdate :=sysdate;
70: l_user_login_id :=fnd_global.login_id;
71: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
72: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
73: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
74: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
75:
76: l_stmt_id :=5;
77: select trunc(mp.curr_start_date),trunc(mp.curr_cutoff_date)

Line 74: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

70: l_user_login_id :=fnd_global.login_id;
71: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
72: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
73: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
74: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
75:
76: l_stmt_id :=5;
77: select trunc(mp.curr_start_date),trunc(mp.curr_cutoff_date)
78: into l_curr_start_date,l_curr_cutoff_date

Line 1482: fnd_global.user_id, sysdate,

1478: sum(f.late_order_count),
1479: sum(f.late_order_value),
1480: sum(f.late_order_value2),
1481: min(service_level),
1482: fnd_global.user_id, sysdate,
1483: sysdate, fnd_global.user_id, fnd_global.login_id,
1484: fnd_global.conc_program_id, fnd_global.conc_login_id,
1485: fnd_global.prog_appl_id, fnd_global.conc_request_id
1486: from

Line 1483: sysdate, fnd_global.user_id, fnd_global.login_id,

1479: sum(f.late_order_value),
1480: sum(f.late_order_value2),
1481: min(service_level),
1482: fnd_global.user_id, sysdate,
1483: sysdate, fnd_global.user_id, fnd_global.login_id,
1484: fnd_global.conc_program_id, fnd_global.conc_login_id,
1485: fnd_global.prog_appl_id, fnd_global.conc_request_id
1486: from
1487: msc_demands_f f,

Line 1484: fnd_global.conc_program_id, fnd_global.conc_login_id,

1480: sum(f.late_order_value2),
1481: min(service_level),
1482: fnd_global.user_id, sysdate,
1483: sysdate, fnd_global.user_id, fnd_global.login_id,
1484: fnd_global.conc_program_id, fnd_global.conc_login_id,
1485: fnd_global.prog_appl_id, fnd_global.conc_request_id
1486: from
1487: msc_demands_f f,
1488: msc_phub_item_categories_mv q

Line 1485: fnd_global.prog_appl_id, fnd_global.conc_request_id

1481: min(service_level),
1482: fnd_global.user_id, sysdate,
1483: sysdate, fnd_global.user_id, fnd_global.login_id,
1484: fnd_global.conc_program_id, fnd_global.conc_login_id,
1485: fnd_global.prog_appl_id, fnd_global.conc_request_id
1486: from
1487: msc_demands_f f,
1488: msc_phub_item_categories_mv q
1489: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 1550: fnd_global.user_id, sysdate,

1546: sum(f.cum_forecast_qty),
1547: sum(f.cum_constrained_fcst),
1548: sum(f.cum_constrained_fcst_value),
1549: sum(f.cum_constrained_fcst_value2),
1550: fnd_global.user_id, sysdate,
1551: sysdate, fnd_global.user_id, fnd_global.login_id,
1552: fnd_global.conc_program_id, fnd_global.conc_login_id,
1553: fnd_global.prog_appl_id, fnd_global.conc_request_id
1554: from

Line 1551: sysdate, fnd_global.user_id, fnd_global.login_id,

1547: sum(f.cum_constrained_fcst),
1548: sum(f.cum_constrained_fcst_value),
1549: sum(f.cum_constrained_fcst_value2),
1550: fnd_global.user_id, sysdate,
1551: sysdate, fnd_global.user_id, fnd_global.login_id,
1552: fnd_global.conc_program_id, fnd_global.conc_login_id,
1553: fnd_global.prog_appl_id, fnd_global.conc_request_id
1554: from
1555: msc_demands_cum_f f,

Line 1552: fnd_global.conc_program_id, fnd_global.conc_login_id,

1548: sum(f.cum_constrained_fcst_value),
1549: sum(f.cum_constrained_fcst_value2),
1550: fnd_global.user_id, sysdate,
1551: sysdate, fnd_global.user_id, fnd_global.login_id,
1552: fnd_global.conc_program_id, fnd_global.conc_login_id,
1553: fnd_global.prog_appl_id, fnd_global.conc_request_id
1554: from
1555: msc_demands_cum_f f,
1556: msc_phub_item_categories_mv q

Line 1553: fnd_global.prog_appl_id, fnd_global.conc_request_id

1549: sum(f.cum_constrained_fcst_value2),
1550: fnd_global.user_id, sysdate,
1551: sysdate, fnd_global.user_id, fnd_global.login_id,
1552: fnd_global.conc_program_id, fnd_global.conc_login_id,
1553: fnd_global.prog_appl_id, fnd_global.conc_request_id
1554: from
1555: msc_demands_cum_f f,
1556: msc_phub_item_categories_mv q
1557: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 1650: fnd_global.user_id, sysdate,

1646: sum(f.late_order_count),
1647: sum(f.late_order_value),
1648: sum(f.late_order_value2),
1649: min(f.service_level),
1650: fnd_global.user_id, sysdate,
1651: sysdate, fnd_global.user_id, fnd_global.login_id,
1652: fnd_global.conc_program_id, fnd_global.conc_login_id,
1653: fnd_global.prog_appl_id, fnd_global.conc_request_id
1654: from

Line 1651: sysdate, fnd_global.user_id, fnd_global.login_id,

1647: sum(f.late_order_value),
1648: sum(f.late_order_value2),
1649: min(f.service_level),
1650: fnd_global.user_id, sysdate,
1651: sysdate, fnd_global.user_id, fnd_global.login_id,
1652: fnd_global.conc_program_id, fnd_global.conc_login_id,
1653: fnd_global.prog_appl_id, fnd_global.conc_request_id
1654: from
1655: msc_demands_f f,

Line 1652: fnd_global.conc_program_id, fnd_global.conc_login_id,

1648: sum(f.late_order_value2),
1649: min(f.service_level),
1650: fnd_global.user_id, sysdate,
1651: sysdate, fnd_global.user_id, fnd_global.login_id,
1652: fnd_global.conc_program_id, fnd_global.conc_login_id,
1653: fnd_global.prog_appl_id, fnd_global.conc_request_id
1654: from
1655: msc_demands_f f,
1656: msc_phub_mfg_cal_periods_mv mp

Line 1653: fnd_global.prog_appl_id, fnd_global.conc_request_id

1649: min(f.service_level),
1650: fnd_global.user_id, sysdate,
1651: sysdate, fnd_global.user_id, fnd_global.login_id,
1652: fnd_global.conc_program_id, fnd_global.conc_login_id,
1653: fnd_global.prog_appl_id, fnd_global.conc_request_id
1654: from
1655: msc_demands_f f,
1656: msc_phub_mfg_cal_periods_mv mp
1657: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 1707: fnd_global.user_id, sysdate,

1703: sum(f.late_order_count),
1704: sum(f.late_order_value),
1705: sum(f.late_order_value2),
1706: min(f.service_level),
1707: fnd_global.user_id, sysdate,
1708: sysdate, fnd_global.user_id, fnd_global.login_id,
1709: fnd_global.conc_program_id, fnd_global.conc_login_id,
1710: fnd_global.prog_appl_id, fnd_global.conc_request_id
1711: from

Line 1708: sysdate, fnd_global.user_id, fnd_global.login_id,

1704: sum(f.late_order_value),
1705: sum(f.late_order_value2),
1706: min(f.service_level),
1707: fnd_global.user_id, sysdate,
1708: sysdate, fnd_global.user_id, fnd_global.login_id,
1709: fnd_global.conc_program_id, fnd_global.conc_login_id,
1710: fnd_global.prog_appl_id, fnd_global.conc_request_id
1711: from
1712: msc_demands_f f,

Line 1709: fnd_global.conc_program_id, fnd_global.conc_login_id,

1705: sum(f.late_order_value2),
1706: min(f.service_level),
1707: fnd_global.user_id, sysdate,
1708: sysdate, fnd_global.user_id, fnd_global.login_id,
1709: fnd_global.conc_program_id, fnd_global.conc_login_id,
1710: fnd_global.prog_appl_id, fnd_global.conc_request_id
1711: from
1712: msc_demands_f f,
1713: msc_phub_fiscal_periods_mv fp

Line 1710: fnd_global.prog_appl_id, fnd_global.conc_request_id

1706: min(f.service_level),
1707: fnd_global.user_id, sysdate,
1708: sysdate, fnd_global.user_id, fnd_global.login_id,
1709: fnd_global.conc_program_id, fnd_global.conc_login_id,
1710: fnd_global.prog_appl_id, fnd_global.conc_request_id
1711: from
1712: msc_demands_f f,
1713: msc_phub_fiscal_periods_mv fp
1714: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id