DBA Data[Home] [Help]

APPS.MTL_SAFETY_STOCKS_PKG dependencies on MRP_CALENDAR

Line 676: next_date := MRP_CALENDAR.NEXT_WORK_DAY(org_id, 1 , to_date(ss_date,'J'));

672: if pro_fdate <> pro_sdate then
673: ss_date := pro_sdate;
674: ss_qty := 0;
675: -- Changes for Bug 3146158
676: next_date := MRP_CALENDAR.NEXT_WORK_DAY(org_id, 1 , to_date(ss_date,'J'));
677: if (next_date = to_date(ss_date,'J')) then
678: Insert_Safety_Stocks(org_id, item_id, ss_code, forc_name,
679: ss_percent, srv_level, to_date(ss_date,'J'), ss_qty,
680: login_id, user_id);

Line 713: next_date := MRP_CALENDAR.NEXT_WORK_DAY(org_id, 1 , to_date(ss_date,'J'));

709: if pro_fdate <> pro_sdate then
710: ss_date := pro_sdate;
711: ss_qty := 0;
712: -- Changes for Bug 3146158
713: next_date := MRP_CALENDAR.NEXT_WORK_DAY(org_id, 1 , to_date(ss_date,'J'));
714: if (next_date = to_date(ss_date,'J')) then
715: Insert_Safety_Stocks(org_id, item_id, ss_code, forc_name,
716: ss_percent, srv_level, to_date(ss_date,'J'), ss_qty,
717: login_id, user_id);

Line 744: next_date := MRP_CALENDAR.NEXT_WORK_DAY(org_id, 1 , to_date(ss_date,'J'));

740: /********************************************************/
741: ss_date := pro_sdate;
742: ss_qty := 0;
743: -- Changes for Bug 3146158
744: next_date := MRP_CALENDAR.NEXT_WORK_DAY(org_id, 1 , to_date(ss_date,'J'));
745: if (next_date <> to_date(ss_date,'J')) then
746: ss_date := TO_NUMBER(TO_CHAR(next_date, 'J'));
747: end if;
748: Insert_Safety_Stocks(org_id, item_id, ss_code, forc_name,