APPS.FLM_KANBAN_PLANNING_UTIL dependencies on FLM_EKB_HORIZONTAL_PLAN_TEMP

Line 533: from FLM_EKB_HORIZONTAL_PLAN_TEMP HP,MTL_KANBAN_PULL_SEQUENCES PS

529: where UPDATED_FLAG = p_request_id;
530:
531: select min(HP.plan_date),max(HP.plan_date), min(HP.organization_id)
532: into l_plan_start_date,l_plan_end_date, l_org_id
533: from FLM_EKB_HORIZONTAL_PLAN_TEMP HP,MTL_KANBAN_PULL_SEQUENCES PS
534: where HP.PULL_SEQUENCE_ID = PS.PULL_SEQUENCE_ID
535: and PS.UPDATED_FLAG = p_request_id;
536:
537: v_exp_date.delete;

Line 597: from FLM_EKB_HORIZONTAL_PLAN_TEMP HP,

593: PS.SAFETY_STOCK_DAYS,PS.AVG_DEPENDENT_DEMAND ,HP.SAFETY_STOCK_TARGET,HP.ADJUSTED_SAFETY_STOCK_DAYS,
594: nvl(ceil(PS.REPLENISHMENT_LEAD_TIME),0) REPLENISHMENT_LEAD_TIME,decode( nvl(PS.KANBAN_SIZE,0),0,1,PS.KANBAN_SIZE),
595: trunc(HP.PLAN_DATE),0 CARDS_REPLENISHED
596: bulk collect into v_planning_temp_tbl
597: from FLM_EKB_HORIZONTAL_PLAN_TEMP HP,
598: MTL_KANBAN_PULL_SEQUENCES PS
599: where HP.PULL_SEQUENCE_ID = PS.PULL_SEQUENCE_ID
600: and PS.UPDATED_FLAG = p_request_id
601: order by HP.PULL_SEQUENCE_ID,HP.plan_date;

Line 701: update FLM_EKB_HORIZONTAL_PLAN_TEMP

697: l_prev_pull_seq := v_planning_temp_tbl(l_counter).PULL_SEQUENCE_ID;
698: l_counter := v_planning_temp_tbl.next(l_counter);
699: end loop;
700: forall cntr in v_planning_temp_tbl.first..v_planning_temp_tbl.last
701: update FLM_EKB_HORIZONTAL_PLAN_TEMP
702: set BEGINNING_ONHAND = v_planning_temp_tbl(cntr).BEGINNING_ONHAND,
703: AVAILABLE_ONHAND = v_planning_temp_tbl(cntr).AVAILABLE_ONHAND,
704: INVENTORY_VALUE = v_planning_temp_tbl(cntr).INVENTORY_VALUE,
705: CARDS_ONHAND = v_planning_temp_tbl(cntr).CARDS_ONHAND,

Line 757: delete from FLM_EKB_HORIZONTAL_PLAN_TEMP where Kanban_Plan_id = l_kanban_plan;

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;
758: set_flexfields_prompt;
759: end if;
760: /*
761: generate_plan_data( p_pull_sequence_id => l_pullseq_id,

Line 1278: type t_flm_kanban_planning_temp is table of flm_ekb_horizontal_plan_temp%rowtype index by binary_integer;

1274: g_user_login_id number;
1275: l_plan_pull_seq number;
1276: l_item_unit_cost number;
1277:
1278: type t_flm_kanban_planning_temp is table of flm_ekb_horizontal_plan_temp%rowtype index by binary_integer;
1279: v_flm_kanban_planning_temp t_flm_kanban_planning_temp;
1280:
1281: type t_exp_date is table of date index by binary_integer;
1282: type t_exp_repl_qty is table of number index by binary_integer;

Line 1620: delete from FLM_EKB_HORIZONTAL_PLAN_TEMP where kanban_plan_id = l_kanban_plan_id;

1616: END LOOP;
1617: l_plan_pull_seq := v_plan_pull_seq_tbl.next(l_plan_pull_seq);
1618: end loop;
1619: end if;
1620: delete from FLM_EKB_HORIZONTAL_PLAN_TEMP where kanban_plan_id = l_kanban_plan_id;
1621: forall cntr in v_flm_kanban_planning_temp.first..v_flm_kanban_planning_temp.last
1622: INSERT into FLM_EKB_HORIZONTAL_PLAN_TEMP values v_flm_kanban_planning_temp(cntr);
1623: commit;
1624: p_request_id := l_value;

Line 1622: INSERT into FLM_EKB_HORIZONTAL_PLAN_TEMP values v_flm_kanban_planning_temp(cntr);

1618: end loop;
1619: end if;
1620: delete from FLM_EKB_HORIZONTAL_PLAN_TEMP where kanban_plan_id = l_kanban_plan_id;
1621: forall cntr in v_flm_kanban_planning_temp.first..v_flm_kanban_planning_temp.last
1622: INSERT into FLM_EKB_HORIZONTAL_PLAN_TEMP values v_flm_kanban_planning_temp(cntr);
1623: commit;
1624: p_request_id := l_value;
1625: Exception
1626: When others then