APPS.FLM_MMM_CALCULATION dependencies on FLM_MMM_LINES

Line 629: * saves it in FLM_MMM_LINES. *

625:
626: /************************************************************************
627: * PROCEDURE calculate_line_takt *
628: * Calculates the Line TAKT for each relevant lines and *
629: * saves it in FLM_MMM_LINES. *
630: ************************************************************************/
631: PROCEDURE calculate_line_takt(
632: i_plan_id IN NUMBER,
633: i_organization_id IN NUMBER,

Line 652: FROM flm_mmm_lines

648:
649: CURSOR all_lines IS
650: SELECT line_id,
651: hours_per_day
652: FROM flm_mmm_lines
653: WHERE plan_id = i_plan_id
654: AND organization_id = i_organization_id
655: AND calculation_operation_type = i_calculation_operation_type;
656:

Line 676: DELETE FROM flm_mmm_lines

672: l_old_lines(line_rec.line_id).line_id := line_rec.line_id;
673: l_old_lines(line_rec.line_id).hours_per_day := line_rec.hours_per_day;
674: END LOOP;
675:
676: DELETE FROM flm_mmm_lines
677: WHERE plan_id = i_plan_id
678: AND organization_id = i_organization_id
679: AND calculation_operation_type = i_calculation_operation_type;
680:

Line 775: INSERT INTO flm_mmm_lines (

771: l_index := l_lines.first;
772: LOOP l_lines(l_index).line_takt :=
773: l_lines(l_index).hours_per_day/l_lines(l_index).total_demand;
774:
775: INSERT INTO flm_mmm_lines (
776: plan_id,
777: organization_id,
778: line_id,
779: calculation_operation_type,

Line 975: FROM flm_mmm_lines line,

971: it.line_id,
972: it.operation_type,
973: nvl(line.hours_per_day,1)/
974: nvl(sum(it.process_volume), 1) operation_takt
975: FROM flm_mmm_lines line,
976: flm_mmm_op_items it
977: WHERE line.plan_id = i_plan_id
978: AND line.organization_id = i_organization_id
979: AND line.calculation_operation_type = it.operation_type --bug 5725595

Line 1166: flm_mmm_lines fml

1162: fmo.line_id,
1163: fmo.operation_takt,
1164: fml.hours_per_day
1165: FROM flm_mmm_operations fmo,
1166: flm_mmm_lines fml
1167: WHERE fmo.plan_id = i_plan_id
1168: AND fmo.organization_id = i_organization_id
1169: AND fmo.operation_type = i_calc_op_type
1170: AND fml.plan_id = i_plan_id

Line 1448: flm_mmm_lines fml

1444: fmo.operation_takt,
1445: fmo.ipk_assigned,
1446: fml.hours_per_day
1447: FROM flm_mmm_operations fmo,
1448: flm_mmm_lines fml
1449: WHERE fmo.plan_id = i_plan_id
1450: AND fmo.organization_id = i_organization_id
1451: AND fml.plan_id = i_plan_id
1452: AND fml.organization_id = i_organization_id

Line 1670: flm_mmm_lines fml

1666: SELECT fmo.operation_takt,
1667: fmo.ipk_assigned,
1668: fml.hours_per_day
1669: FROM flm_mmm_operations fmo,
1670: flm_mmm_lines fml
1671: WHERE fmo.plan_id = i_plan_id
1672: AND fmo.organization_id = i_organization_id
1673: AND fmo.standard_operation_id = i_standard_operation_id
1674: AND fml.plan_id = i_plan_id

Line 1826: FROM flm_mmm_lines

1822: l_count NUMBER;
1823:
1824: CURSOR lines IS
1825: SELECT line_id
1826: FROM flm_mmm_lines
1827: WHERE plan_id = i_plan_id
1828: AND organization_id = i_organization_id
1829: AND calculation_operation_type = i_calc_op_type;
1830:

Line 1921: UPDATE flm_mmm_lines

1917: IF l_takt_assigned IS NULL THEN -- No Operation?
1918: l_takt_assigned := 0;
1919: END IF;
1920:
1921: UPDATE flm_mmm_lines
1922: SET line_takt_as_assigned = l_takt_assigned * line_takt,
1923: last_updated_by = fnd_global.user_id,
1924: last_update_date = sysdate,
1925: last_update_login = fnd_global.user_id

Line 1933: UPDATE flm_mmm_lines

1929: AND calculation_operation_type = i_calc_op_type;
1930:
1931: ELSE
1932:
1933: UPDATE flm_mmm_lines
1934: SET line_takt_as_assigned = NULL,
1935: last_updated_by = fnd_global.user_id,
1936: last_update_date = sysdate,
1937: last_update_login = fnd_global.user_id

Line 1965: FROM flm_mmm_lines

1961: l_count NUMBER;
1962:
1963: CURSOR lines IS
1964: SELECT line_id
1965: FROM flm_mmm_lines
1966: WHERE plan_id = i_plan_id
1967: AND organization_id = i_organization_id
1968: AND calculation_operation_type = i_calc_op_type;
1969:

Line 2093: UPDATE flm_mmm_lines

2089: l_ipk_over_pct := 0;
2090: END IF;
2091:
2092: -- Update
2093: UPDATE flm_mmm_lines
2094: SET bottleneck_resource_percent = l_res_over_pct,
2095: bottleneck_ipk_percent = l_ipk_over_pct,
2096: last_updated_by = fnd_global.user_id,
2097: last_update_date = sysdate,

Line 2106: UPDATE flm_mmm_lines

2102: AND calculation_operation_type = i_calc_op_type;
2103:
2104: ELSE
2105: -- Update
2106: UPDATE flm_mmm_lines
2107: SET bottleneck_resource_percent = l_res_over_pct,
2108: bottleneck_ipk_percent = NULL,
2109: last_updated_by = fnd_global.user_id,
2110: last_update_date = sysdate,

Line 2140: FROM flm_mmm_lines

2136: l_temp NUMBER;
2137:
2138: CURSOR lines IS
2139: SELECT line_id
2140: FROM flm_mmm_lines
2141: WHERE plan_id = i_plan_id
2142: AND organization_id = i_organization_id
2143: AND calculation_operation_type = i_calc_op_type;
2144:

Line 2244: UPDATE flm_mmm_lines

2240: END IF;
2241: END LOOP;
2242:
2243: -- Update
2244: UPDATE flm_mmm_lines
2245: SET resource_undercapacity = l_res_under_pct,
2246: ipk_undercapacity = l_ipk_under_pct,
2247: last_updated_by = fnd_global.user_id,
2248: last_update_date = sysdate,

Line 2328: -- FLM_MMM_LINES delete if not re-plan

2324: i_calc_op_type IN NUMBER,
2325: i_replan_flag IN VARCHAR2) IS
2326:
2327: BEGIN
2328: -- FLM_MMM_LINES delete if not re-plan
2329: -- if re-plan, the records will be changed(delete, then insert)
2330: -- later (when calculating line takt).
2331: -- this is because we might need to use its line hours
2332: IF NOT (i_replan_flag = C_REPLAN_FLAG_YES) THEN

Line 2333: DELETE FROM flm_mmm_lines

2329: -- if re-plan, the records will be changed(delete, then insert)
2330: -- later (when calculating line takt).
2331: -- this is because we might need to use its line hours
2332: IF NOT (i_replan_flag = C_REPLAN_FLAG_YES) THEN
2333: DELETE FROM flm_mmm_lines
2334: WHERE plan_id = i_plan_id
2335: AND organization_id = i_organization_id
2336: AND calculation_operation_type = i_calc_op_type;
2337: END IF;