DBA Data[Home] [Help]

APPS.MSC_ITEM_PKG dependencies on FND_GLOBAL

Line 57: l_user_id := fnd_global.user_id;

53: retcode :=0; -- this means successfully
54: errbuf :='';
55:
56:
57: l_user_id := fnd_global.user_id;
58: l_sysdate :=sysdate;
59: l_user_login_id :=fnd_global.login_id;
60: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
61: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 59: l_user_login_id :=fnd_global.login_id;

55:
56:
57: l_user_id := fnd_global.user_id;
58: l_sysdate :=sysdate;
59: l_user_login_id :=fnd_global.login_id;
60: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
61: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
62: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
63: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

Line 60: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;

56:
57: l_user_id := fnd_global.user_id;
58: l_sysdate :=sysdate;
59: l_user_login_id :=fnd_global.login_id;
60: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
61: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
62: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
63: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
64:

Line 61: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

57: l_user_id := fnd_global.user_id;
58: l_sysdate :=sysdate;
59: l_user_login_id :=fnd_global.login_id;
60: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
61: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
62: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
63: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
64:
65:

Line 62: l_appl_id := FND_GLOBAL.PROG_APPL_ID;

58: l_sysdate :=sysdate;
59: l_user_login_id :=fnd_global.login_id;
60: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
61: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
62: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
63: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
64:
65:
66: select min(bkt_start_date), max(bkt_end_date)

Line 63: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

59: l_user_login_id :=fnd_global.login_id;
60: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
61: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
62: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
63: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
64:
65:
66: select min(bkt_start_date), max(bkt_end_date)
67: into l_first_bkt_start_date, l_last_bkt_end_date

Line 2004: fnd_global.user_id, sysdate,

2000: sum(f.carrying_cost2),
2001: sum(f.gross_margin),
2002: sum(f.gross_margin2),
2003: sum(f.inv_build_target),
2004: fnd_global.user_id, sysdate,
2005: sysdate, fnd_global.user_id, fnd_global.login_id,
2006: fnd_global.conc_program_id, fnd_global.conc_login_id,
2007: fnd_global.prog_appl_id, fnd_global.conc_request_id
2008: from

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

2001: sum(f.gross_margin),
2002: sum(f.gross_margin2),
2003: sum(f.inv_build_target),
2004: fnd_global.user_id, sysdate,
2005: sysdate, fnd_global.user_id, fnd_global.login_id,
2006: fnd_global.conc_program_id, fnd_global.conc_login_id,
2007: fnd_global.prog_appl_id, fnd_global.conc_request_id
2008: from
2009: msc_item_inventory_f f,

Line 2006: fnd_global.conc_program_id, fnd_global.conc_login_id,

2002: sum(f.gross_margin2),
2003: sum(f.inv_build_target),
2004: fnd_global.user_id, sysdate,
2005: sysdate, fnd_global.user_id, fnd_global.login_id,
2006: fnd_global.conc_program_id, fnd_global.conc_login_id,
2007: fnd_global.prog_appl_id, fnd_global.conc_request_id
2008: from
2009: msc_item_inventory_f f,
2010: msc_phub_item_categories_mv q

Line 2007: fnd_global.prog_appl_id, fnd_global.conc_request_id

2003: sum(f.inv_build_target),
2004: fnd_global.user_id, sysdate,
2005: sysdate, fnd_global.user_id, fnd_global.login_id,
2006: fnd_global.conc_program_id, fnd_global.conc_login_id,
2007: fnd_global.prog_appl_id, fnd_global.conc_request_id
2008: from
2009: msc_item_inventory_f f,
2010: msc_phub_item_categories_mv q
2011: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 2085: fnd_global.user_id, sysdate,

2081: sum(f.avg_daily_demand),
2082: sum(f.onhand_qty),
2083: sum(f.scheduled_rept_qty),
2084: sum(f.forecast_qty),
2085: fnd_global.user_id, sysdate,
2086: sysdate, fnd_global.user_id, fnd_global.login_id,
2087: fnd_global.conc_program_id, fnd_global.conc_login_id,
2088: fnd_global.prog_appl_id, fnd_global.conc_request_id
2089: from

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

2082: sum(f.onhand_qty),
2083: sum(f.scheduled_rept_qty),
2084: sum(f.forecast_qty),
2085: fnd_global.user_id, sysdate,
2086: sysdate, fnd_global.user_id, fnd_global.login_id,
2087: fnd_global.conc_program_id, fnd_global.conc_login_id,
2088: fnd_global.prog_appl_id, fnd_global.conc_request_id
2089: from
2090: msc_item_orders_f f,

Line 2087: fnd_global.conc_program_id, fnd_global.conc_login_id,

2083: sum(f.scheduled_rept_qty),
2084: sum(f.forecast_qty),
2085: fnd_global.user_id, sysdate,
2086: sysdate, fnd_global.user_id, fnd_global.login_id,
2087: fnd_global.conc_program_id, fnd_global.conc_login_id,
2088: fnd_global.prog_appl_id, fnd_global.conc_request_id
2089: from
2090: msc_item_orders_f f,
2091: msc_phub_item_categories_mv q

Line 2088: fnd_global.prog_appl_id, fnd_global.conc_request_id

2084: sum(f.forecast_qty),
2085: fnd_global.user_id, sysdate,
2086: sysdate, fnd_global.user_id, fnd_global.login_id,
2087: fnd_global.conc_program_id, fnd_global.conc_login_id,
2088: fnd_global.prog_appl_id, fnd_global.conc_request_id
2089: from
2090: msc_item_orders_f f,
2091: msc_phub_item_categories_mv q
2092: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id