DBA Data[Home] [Help]

APPS.MTL_SAFETY_STOCKS_PKG dependencies on MRP_CALENDAR

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

681: if pro_fdate <> pro_sdate then
682: ss_date := pro_sdate;
683: ss_qty := 0;
684: -- Changes for Bug 3146158
685: next_date := MRP_CALENDAR.NEXT_WORK_DAY(org_id, 1 , to_date(ss_date,'J'));
686: if (next_date = to_date(ss_date,'J')) then
687: Insert_Safety_Stocks(org_id, item_id, ss_code, forc_name,
688: ss_percent, srv_level, to_date(ss_date,'J'), ss_qty,
689: login_id, user_id);

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

718: if pro_fdate <> pro_sdate then
719: ss_date := pro_sdate;
720: ss_qty := 0;
721: -- Changes for Bug 3146158
722: next_date := MRP_CALENDAR.NEXT_WORK_DAY(org_id, 1 , to_date(ss_date,'J'));
723: if (next_date = to_date(ss_date,'J')) then
724: Insert_Safety_Stocks(org_id, item_id, ss_code, forc_name,
725: ss_percent, srv_level, to_date(ss_date,'J'), ss_qty,
726: login_id, user_id);

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

749: /********************************************************/
750: ss_date := pro_sdate;
751: ss_qty := 0;
752: -- Changes for Bug 3146158
753: next_date := MRP_CALENDAR.NEXT_WORK_DAY(org_id, 1 , to_date(ss_date,'J'));
754: if (next_date <> to_date(ss_date,'J')) then
755: ss_date := TO_NUMBER(TO_CHAR(next_date, 'J'));
756: end if;
757: Insert_Safety_Stocks(org_id, item_id, ss_code, forc_name,