DBA Data[Home] [Help]

APPS.MSC_ATP_DRP dependencies on FND_GLOBAL

Line 120: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.

116: l_null_num NUMBER;
117: l_null_char VARCHAR2(1);
118: l_null_date DATE; --bug3814584
119: l_sysdate DATE := sysdate;
120: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
121: BEGIN
122: IF PG_DEBUG in ('Y', 'C') THEN
123: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Dtls **********');
124: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_item_id ' || p_item_id);

Line 376: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.

372:
373: PROCEDURE LOAD_SD_FULL_DRP(p_plan_id IN NUMBER,
374: p_sys_date IN DATE)
375: IS
376: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
377: BEGIN
378:
379: msc_util.msc_log('******** LOAD_SD_FULL_DRP Begin ********');
380: msc_util.msc_log('LOAD_SD_FULL_DRP p_plan_id ' || p_plan_id);

Line 516: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.

512: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
513: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
514: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
515:
516: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
517: BEGIN
518:
519: msc_util.msc_log('******** LOAD_SD_NET_DRP Begin ********');
520: msc_util.msc_log('LOAD_SD_NET_DRP: ' || 'p_last_refresh_number - ' || p_last_refresh_number);