APPS.FLM_KANBAN_PLANNING_UTIL dependencies on MRP_KANBAN_PLANS

Line 753: from mrp_kanban_plans where kanban_plan_id = p_kanban_plan;

749: l_pullseq_id := p_pull_sequence_id;
750: l_kanban_plan := p_kanban_plan;
751: select nvl(trunc(plan_start_date),trunc(sysdate)), nvl(trunc(plan_cutoff_date),nvl(trunc(plan_start_date),trunc(sysdate))+30)
752: into l_start_date,l_end_date
753: from mrp_kanban_plans where kanban_plan_id = p_kanban_plan;
754: end if;
755:
756: if p_set_prmopts = 'Y' then
757: delete from FLM_EKB_HORIZONTAL_PLAN_TEMP where Kanban_Plan_id = l_kanban_plan;

Line 1399: from mrp_kanban_plans where kanban_plan_id = l_kanban_plan_id;

1395: else
1396: select mrp_calendar.NEXT_WORK_DAY(organization_id,1,nvl(greatest(trunc(plan_start_date),trunc(sysdate)),trunc(sysdate))),
1397: mrp_calendar.NEXT_WORK_DAY(organization_id,1,trunc(plan_cutoff_date))
1398: into l_start_date,l_end_date
1399: from mrp_kanban_plans where kanban_plan_id = l_kanban_plan_id;
1400: end if;
1401: v_exp_date.delete;
1402: v_exp_repl_qty.delete;
1403: v_repl_no_of_cards.delete;

Line 2664: UPDATE mrp_kanban_plans SET request_id = l_request_id WHERE kanban_plan_id = p_kanban_plan_id;

2660: to_char(p_start_date, l_date_format),
2661: to_char(p_cutoff_date, l_date_format),
2662: 2);
2663:
2664: UPDATE mrp_kanban_plans SET request_id = l_request_id WHERE kanban_plan_id = p_kanban_plan_id;
2665:
2666: COMMIT;
2667:
2668: END launch_request;