APPS.FLM_KANBAN_PLANNING_UTIL dependencies on DUAL

Line 357: select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL into l_pull_seq_id from dual;

353: x_pull_sequence_id out nocopy number )
354: is
355: l_pull_seq_id Number;
356: Begin
357: select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL into l_pull_seq_id from dual;
358:
359: INSERT INTO MTL_KANBAN_PULL_SEQUENCES
360: (Pull_sequence_id,
361: Inventory_item_id,

Line 1125: select mrp_kanban_demand_s.nextval into v_flm_kanban_demand(ins_counter).DEMAND_ID from dual;

1121: while l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE <=
1122: l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE
1123: loop
1124:
1125: select mrp_kanban_demand_s.nextval into v_flm_kanban_demand(ins_counter).DEMAND_ID from dual;
1126: v_flm_kanban_demand(ins_counter).kanban_plan_id := 0;
1127: v_flm_kanban_demand(ins_counter).organization_id := l_flm_kanban_demand_intf(l_counter).organization_id;
1128: v_flm_kanban_demand(ins_counter).inventory_item_id := l_flm_kanban_demand_intf(l_counter).inventory_item_id;
1129: v_flm_kanban_demand(ins_counter).subinventory := l_flm_kanban_demand_intf(l_counter).subinventory;

Line 1198: from dual;

1194: l_next_pull_seq_id Number;
1195: Begin
1196: select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL
1197: into l_next_pull_seq_id
1198: from dual;
1199:
1200: return l_next_pull_seq_id;
1201: End get_next_pull_seq_id;
1202:

Line 1499: select FLM_KANBAN_PLANNING_TEMP_S.nextval into v_flm_kanban_planning_temp(l_counter).Planning_temp_id from dual;

1495: l_first := l_counter+1;
1496: WHILE l_start_date <= l_end_date
1497: LOOP
1498: l_counter := l_counter+1;
1499: select FLM_KANBAN_PLANNING_TEMP_S.nextval into v_flm_kanban_planning_temp(l_counter).Planning_temp_id from dual;
1500: v_flm_kanban_planning_temp(l_counter).Kanban_Plan_Id := l_kanban_plan_id;
1501: v_flm_kanban_planning_temp(l_counter).Pull_Sequence_Id := v_plan_pull_seq_tbl(l_plan_pull_seq).Pull_Sequence_Id;
1502: v_flm_kanban_planning_temp(l_counter).Organization_Id := v_plan_pull_seq_tbl(l_plan_pull_seq).organization_id;
1503: v_flm_kanban_planning_temp(l_counter).Inventory_Item_Id := v_plan_pull_seq_tbl(l_plan_pull_seq).inventory_item_id;