eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_MMM_CALCULATION dependencies on FND_GLOBAL

Line 791: fnd_global.user_id,

787: i_plan_id,
788: i_organization_id,
789: l_lines(l_index).line_id,
790: i_calculation_operation_type,
791: fnd_global.user_id,
792: sysdate,
793: fnd_global.user_id,
794: sysdate,
795: l_lines(l_index).line_takt,

Line 793: fnd_global.user_id,

789: l_lines(l_index).line_id,
790: i_calculation_operation_type,
791: fnd_global.user_id,
792: sysdate,
793: fnd_global.user_id,
794: sysdate,
795: l_lines(l_index).line_takt,
796: l_lines(l_index).hours_per_day
797: );

Line 888: fnd_global.user_id || ':'||

884: i_demand(l_index).assembly_item_id || ':'||
885: op_seq_rec.line_id || ':'||
886: op_seq_rec.operation_type || ':'||
887: op_seq_rec.standard_operation_id || ':'||
888: fnd_global.user_id || ':'||
889: sysdate || ':'||
890: fnd_global.user_id || ':'||
891: sysdate || ':'||
892: i_demand(l_index).average_daily_demand

Line 890: fnd_global.user_id || ':'||

886: op_seq_rec.operation_type || ':'||
887: op_seq_rec.standard_operation_id || ':'||
888: fnd_global.user_id || ':'||
889: sysdate || ':'||
890: fnd_global.user_id || ':'||
891: sysdate || ':'||
892: i_demand(l_index).average_daily_demand
893: * l_npp / 100
894: / l_rcy || ':'||

Line 923: fnd_global.user_id,

919: i_demand(l_index).assembly_item_id,
920: op_seq_rec.line_id,
921: op_seq_rec.operation_type,
922: op_seq_rec.standard_operation_id,
923: fnd_global.user_id,
924: sysdate,
925: fnd_global.user_id,
926: sysdate,
927: i_demand(l_index).average_daily_demand

Line 925: fnd_global.user_id,

921: op_seq_rec.operation_type,
922: op_seq_rec.standard_operation_id,
923: fnd_global.user_id,
924: sysdate,
925: fnd_global.user_id,
926: sysdate,
927: i_demand(l_index).average_daily_demand
928: * l_npp / 100
929: / l_rcy,

Line 1059: fnd_global.user_id,

1055: ) VALUES (
1056: i_plan_id,
1057: i_organization_id,
1058: op_takt_rec.standard_operation_id,
1059: fnd_global.user_id,
1060: sysdate,
1061: fnd_global.user_id,
1062: sysdate,
1063: op_takt_rec.line_id,

Line 1061: fnd_global.user_id,

1057: i_organization_id,
1058: op_takt_rec.standard_operation_id,
1059: fnd_global.user_id,
1060: sysdate,
1061: fnd_global.user_id,
1062: sysdate,
1063: op_takt_rec.line_id,
1064: op_takt_rec.operation_type,
1065: op_takt_rec.operation_takt,

Line 1326: fnd_global.user_id,

1322: i_plan_id,
1323: i_organization_id,
1324: l_res_id,
1325: op_rec.standard_operation_id,
1326: fnd_global.user_id,
1327: sysdate,
1328: fnd_global.user_id,
1329: sysdate,
1330: op_rec.line_id,

Line 1328: fnd_global.user_id,

1324: l_res_id,
1325: op_rec.standard_operation_id,
1326: fnd_global.user_id,
1327: sysdate,
1328: fnd_global.user_id,
1329: sysdate,
1330: op_rec.line_id,
1331: op_rec.operation_type,
1332: l_total_rs / l_total_pv,

Line 1381: fnd_global.user_id,

1377: i_plan_id,
1378: i_organization_id,
1379: l_res_id,
1380: op_rec.standard_operation_id,
1381: fnd_global.user_id,
1382: sysdate,
1383: fnd_global.user_id,
1384: sysdate,
1385: op_rec.line_id,

Line 1383: fnd_global.user_id,

1379: l_res_id,
1380: op_rec.standard_operation_id,
1381: fnd_global.user_id,
1382: sysdate,
1383: fnd_global.user_id,
1384: sysdate,
1385: op_rec.line_id,
1386: op_rec.operation_type,
1387: l_total_rs / l_total_pv,

Line 1879: last_updated_by = fnd_global.user_id,

1875: END IF;
1876:
1877: UPDATE flm_mmm_operations
1878: SET op_takt_as_assigned = l_takt_assigned,
1879: last_updated_by = fnd_global.user_id,
1880: last_update_date = sysdate,
1881: last_update_login = fnd_global.user_id
1882: WHERE plan_id = i_plan_id
1883: AND organization_id = i_organization_id

Line 1881: last_update_login = fnd_global.user_id

1877: UPDATE flm_mmm_operations
1878: SET op_takt_as_assigned = l_takt_assigned,
1879: last_updated_by = fnd_global.user_id,
1880: last_update_date = sysdate,
1881: last_update_login = fnd_global.user_id
1882: WHERE plan_id = i_plan_id
1883: AND organization_id = i_organization_id
1884: AND standard_operation_id = op_rec.standard_operation_id;
1885:

Line 1889: last_updated_by = fnd_global.user_id,

1885:
1886: ELSE
1887: UPDATE flm_mmm_operations
1888: SET op_takt_as_assigned = NULL,
1889: last_updated_by = fnd_global.user_id,
1890: last_update_date = sysdate,
1891: last_update_login = fnd_global.user_id
1892: WHERE plan_id = i_plan_id
1893: AND organization_id = i_organization_id

Line 1891: last_update_login = fnd_global.user_id

1887: UPDATE flm_mmm_operations
1888: SET op_takt_as_assigned = NULL,
1889: last_updated_by = fnd_global.user_id,
1890: last_update_date = sysdate,
1891: last_update_login = fnd_global.user_id
1892: WHERE plan_id = i_plan_id
1893: AND organization_id = i_organization_id
1894: AND standard_operation_id = op_rec.standard_operation_id;
1895:

Line 1923: last_updated_by = fnd_global.user_id,

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
1926: WHERE plan_id = i_plan_id
1927: AND organization_id = i_organization_id

Line 1925: last_update_login = fnd_global.user_id

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
1926: WHERE plan_id = i_plan_id
1927: AND organization_id = i_organization_id
1928: AND line_id = line_rec.line_id
1929: AND calculation_operation_type = i_calc_op_type;

Line 1935: last_updated_by = fnd_global.user_id,

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
1938: WHERE plan_id = i_plan_id
1939: AND organization_id = i_organization_id

Line 1937: last_update_login = fnd_global.user_id

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
1938: WHERE plan_id = i_plan_id
1939: AND organization_id = i_organization_id
1940: AND line_id = line_rec.line_id
1941: AND calculation_operation_type = i_calc_op_type;

Line 2027: last_updated_by = fnd_global.user_id,

2023: END IF;
2024:
2025: UPDATE flm_mmm_operations
2026: SET bottleneck_resource_percent = l_res_over_pct,
2027: last_updated_by = fnd_global.user_id,
2028: last_update_date = sysdate,
2029: last_update_login = fnd_global.user_id
2030: WHERE plan_id = i_plan_id
2031: AND organization_id = i_organization_id

Line 2029: last_update_login = fnd_global.user_id

2025: UPDATE flm_mmm_operations
2026: SET bottleneck_resource_percent = l_res_over_pct,
2027: last_updated_by = fnd_global.user_id,
2028: last_update_date = sysdate,
2029: last_update_login = fnd_global.user_id
2030: WHERE plan_id = i_plan_id
2031: AND organization_id = i_organization_id
2032: AND standard_operation_id = op_rec.standard_operation_id;
2033:

Line 2037: last_updated_by = fnd_global.user_id,

2033:
2034: ELSE
2035: UPDATE flm_mmm_operations
2036: SET bottleneck_resource_percent = NULL,
2037: last_updated_by = fnd_global.user_id,
2038: last_update_date = sysdate,
2039: last_update_login = fnd_global.user_id
2040: WHERE plan_id = i_plan_id
2041: AND organization_id = i_organization_id

Line 2039: last_update_login = fnd_global.user_id

2035: UPDATE flm_mmm_operations
2036: SET bottleneck_resource_percent = NULL,
2037: last_updated_by = fnd_global.user_id,
2038: last_update_date = sysdate,
2039: last_update_login = fnd_global.user_id
2040: WHERE plan_id = i_plan_id
2041: AND organization_id = i_organization_id
2042: AND standard_operation_id = op_rec.standard_operation_id;
2043:

Line 2096: last_updated_by = fnd_global.user_id,

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,
2098: last_update_login = fnd_global.user_id
2099: WHERE plan_id = i_plan_id
2100: AND organization_id = i_organization_id

Line 2098: last_update_login = fnd_global.user_id

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,
2098: last_update_login = fnd_global.user_id
2099: WHERE plan_id = i_plan_id
2100: AND organization_id = i_organization_id
2101: AND line_id = line_rec.line_id
2102: AND calculation_operation_type = i_calc_op_type;

Line 2109: last_updated_by = fnd_global.user_id,

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,
2111: last_update_login = fnd_global.user_id
2112: WHERE plan_id = i_plan_id
2113: AND organization_id = i_organization_id

Line 2111: last_update_login = fnd_global.user_id

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,
2111: last_update_login = fnd_global.user_id
2112: WHERE plan_id = i_plan_id
2113: AND organization_id = i_organization_id
2114: AND line_id = line_rec.line_id
2115: AND calculation_operation_type = i_calc_op_type;

Line 2204: last_updated_by = fnd_global.user_id,

2200: END LOOP;
2201:
2202: UPDATE flm_mmm_operations
2203: SET resource_undercapacity = l_res_under_pct,
2204: last_updated_by = fnd_global.user_id,
2205: last_update_date = sysdate,
2206: last_update_login = fnd_global.user_id
2207: WHERE plan_id = i_plan_id
2208: AND organization_id = i_organization_id

Line 2206: last_update_login = fnd_global.user_id

2202: UPDATE flm_mmm_operations
2203: SET resource_undercapacity = l_res_under_pct,
2204: last_updated_by = fnd_global.user_id,
2205: last_update_date = sysdate,
2206: last_update_login = fnd_global.user_id
2207: WHERE plan_id = i_plan_id
2208: AND organization_id = i_organization_id
2209: AND standard_operation_id = op_rec.standard_operation_id;
2210:

Line 2247: last_updated_by = fnd_global.user_id,

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,
2249: last_update_login = fnd_global.user_id
2250: WHERE plan_id = i_plan_id
2251: AND organization_id = i_organization_id

Line 2249: last_update_login = fnd_global.user_id

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,
2249: last_update_login = fnd_global.user_id
2250: WHERE plan_id = i_plan_id
2251: AND organization_id = i_organization_id
2252: AND line_id = line_rec.line_id
2253: AND calculation_operation_type = i_calc_op_type;

Line 2722: last_updated_by = fnd_global.user_id,

2718:
2719: -- update records
2720: UPDATE flm_mmm_op_resources
2721: SET resource_assigned = resource_needed,
2722: last_updated_by = fnd_global.user_id,
2723: last_update_date = sysdate,
2724: last_update_login = fnd_global.user_id
2725: WHERE plan_id = i_plan_id
2726: AND organization_id = i_organization_id

Line 2724: last_update_login = fnd_global.user_id

2720: UPDATE flm_mmm_op_resources
2721: SET resource_assigned = resource_needed,
2722: last_updated_by = fnd_global.user_id,
2723: last_update_date = sysdate,
2724: last_update_login = fnd_global.user_id
2725: WHERE plan_id = i_plan_id
2726: AND organization_id = i_organization_id
2727: AND operation_type = i_calc_op_type;
2728:

Line 2731: last_updated_by = fnd_global.user_id,

2727: AND operation_type = i_calc_op_type;
2728:
2729: UPDATE flm_mmm_operations
2730: SET ipk_assigned = ipk_needed,
2731: last_updated_by = fnd_global.user_id,
2732: last_update_date = sysdate,
2733: last_update_login = fnd_global.user_id
2734: WHERE plan_id = i_plan_id
2735: AND organization_id = i_organization_id

Line 2733: last_update_login = fnd_global.user_id

2729: UPDATE flm_mmm_operations
2730: SET ipk_assigned = ipk_needed,
2731: last_updated_by = fnd_global.user_id,
2732: last_update_date = sysdate,
2733: last_update_login = fnd_global.user_id
2734: WHERE plan_id = i_plan_id
2735: AND organization_id = i_organization_id
2736: AND operation_type = i_calc_op_type;
2737:

Line 2747: last_updated_by = fnd_global.user_id,

2743:
2744: -- update records
2745: UPDATE flm_mmm_op_resources
2746: SET resource_assigned = resource_needed,
2747: last_updated_by = fnd_global.user_id,
2748: last_update_date = sysdate,
2749: last_update_login = fnd_global.user_id
2750: WHERE plan_id = i_plan_id
2751: AND organization_id = i_organization_id

Line 2749: last_update_login = fnd_global.user_id

2745: UPDATE flm_mmm_op_resources
2746: SET resource_assigned = resource_needed,
2747: last_updated_by = fnd_global.user_id,
2748: last_update_date = sysdate,
2749: last_update_login = fnd_global.user_id
2750: WHERE plan_id = i_plan_id
2751: AND organization_id = i_organization_id
2752: AND operation_type = i_calc_op_type
2753: AND resource_id = i_resource_id;

Line 2769: last_updated_by = fnd_global.user_id,

2765:
2766: -- update records
2767: UPDATE flm_mmm_op_resources
2768: SET resource_assigned = resource_needed,
2769: last_updated_by = fnd_global.user_id,
2770: last_update_date = sysdate,
2771: last_update_login = fnd_global.user_id
2772: WHERE plan_id = i_plan_id
2773: AND organization_id = i_organization_id

Line 2771: last_update_login = fnd_global.user_id

2767: UPDATE flm_mmm_op_resources
2768: SET resource_assigned = resource_needed,
2769: last_updated_by = fnd_global.user_id,
2770: last_update_date = sysdate,
2771: last_update_login = fnd_global.user_id
2772: WHERE plan_id = i_plan_id
2773: AND organization_id = i_organization_id
2774: AND operation_type = i_calc_op_type
2775: AND line_id = i_line_id;

Line 2779: last_updated_by = fnd_global.user_id,

2775: AND line_id = i_line_id;
2776:
2777: UPDATE flm_mmm_operations
2778: SET ipk_assigned = ipk_needed,
2779: last_updated_by = fnd_global.user_id,
2780: last_update_date = sysdate,
2781: last_update_login = fnd_global.user_id
2782: WHERE plan_id = i_plan_id
2783: AND organization_id = i_organization_id

Line 2781: last_update_login = fnd_global.user_id

2777: UPDATE flm_mmm_operations
2778: SET ipk_assigned = ipk_needed,
2779: last_updated_by = fnd_global.user_id,
2780: last_update_date = sysdate,
2781: last_update_login = fnd_global.user_id
2782: WHERE plan_id = i_plan_id
2783: AND organization_id = i_organization_id
2784: AND operation_type = i_calc_op_type
2785: AND line_id = i_line_id;

Line 2800: last_updated_by = fnd_global.user_id,

2796:
2797: -- update records
2798: UPDATE flm_mmm_op_resources
2799: SET resource_assigned = resource_needed,
2800: last_updated_by = fnd_global.user_id,
2801: last_update_date = sysdate,
2802: last_update_login = fnd_global.user_id
2803: WHERE plan_id = i_plan_id
2804: AND organization_id = i_organization_id

Line 2802: last_update_login = fnd_global.user_id

2798: UPDATE flm_mmm_op_resources
2799: SET resource_assigned = resource_needed,
2800: last_updated_by = fnd_global.user_id,
2801: last_update_date = sysdate,
2802: last_update_login = fnd_global.user_id
2803: WHERE plan_id = i_plan_id
2804: AND organization_id = i_organization_id
2805: AND operation_type = i_calc_op_type
2806: AND standard_operation_id = i_standard_operation_id;

Line 2810: last_updated_by = fnd_global.user_id,

2806: AND standard_operation_id = i_standard_operation_id;
2807:
2808: UPDATE flm_mmm_operations
2809: SET ipk_assigned = ipk_needed,
2810: last_updated_by = fnd_global.user_id,
2811: last_update_date = sysdate,
2812: last_update_login = fnd_global.user_id
2813: WHERE plan_id = i_plan_id
2814: AND organization_id = i_organization_id

Line 2812: last_update_login = fnd_global.user_id

2808: UPDATE flm_mmm_operations
2809: SET ipk_assigned = ipk_needed,
2810: last_updated_by = fnd_global.user_id,
2811: last_update_date = sysdate,
2812: last_update_login = fnd_global.user_id
2813: WHERE plan_id = i_plan_id
2814: AND organization_id = i_organization_id
2815: AND operation_type = i_calc_op_type
2816: AND standard_operation_id = i_standard_operation_id;

Line 2890: last_updated_by = fnd_global.user_id,

2886:
2887: IF l_count > 0 THEN
2888: UPDATE flm_mmm_operations
2889: SET ipk_assigned = op_rec.ipk_assigned,
2890: last_updated_by = fnd_global.user_id,
2891: last_update_date = sysdate,
2892: last_update_login = fnd_global.user_id
2893: WHERE organization_id = i_organization_id
2894: AND plan_id = -1

Line 2892: last_update_login = fnd_global.user_id

2888: UPDATE flm_mmm_operations
2889: SET ipk_assigned = op_rec.ipk_assigned,
2890: last_updated_by = fnd_global.user_id,
2891: last_update_date = sysdate,
2892: last_update_login = fnd_global.user_id
2893: WHERE organization_id = i_organization_id
2894: AND plan_id = -1
2895: AND standard_operation_id = op_rec.operation_id;
2896:

Line 2915: fnd_global.user_id,

2911: -1,
2912: i_organization_id,
2913: op_rec.operation_id,
2914: sysdate,
2915: fnd_global.user_id,
2916: sysdate,
2917: fnd_global.user_id,
2918: fnd_global.user_id,
2919: i_operation_type,

Line 2917: fnd_global.user_id,

2913: op_rec.operation_id,
2914: sysdate,
2915: fnd_global.user_id,
2916: sysdate,
2917: fnd_global.user_id,
2918: fnd_global.user_id,
2919: i_operation_type,
2920: op_rec.LINE_ID,
2921: op_rec.ipk_assigned

Line 2918: fnd_global.user_id,

2914: sysdate,
2915: fnd_global.user_id,
2916: sysdate,
2917: fnd_global.user_id,
2918: fnd_global.user_id,
2919: i_operation_type,
2920: op_rec.LINE_ID,
2921: op_rec.ipk_assigned
2922: );

Line 2940: last_updated_by = fnd_global.user_id,

2936:
2937: IF l_count > 0 THEN
2938: UPDATE flm_mmm_op_resources
2939: SET resource_assigned = res_rec.resource_assigned,
2940: last_updated_by = fnd_global.user_id,
2941: last_update_date = sysdate,
2942: last_update_login = fnd_global.user_id
2943: WHERE organization_id = i_organization_id
2944: AND plan_id = -1

Line 2942: last_update_login = fnd_global.user_id

2938: UPDATE flm_mmm_op_resources
2939: SET resource_assigned = res_rec.resource_assigned,
2940: last_updated_by = fnd_global.user_id,
2941: last_update_date = sysdate,
2942: last_update_login = fnd_global.user_id
2943: WHERE organization_id = i_organization_id
2944: AND plan_id = -1
2945: AND resource_id = res_rec.resource_id
2946: AND standard_operation_id = res_rec.operation_id;

Line 2968: fnd_global.user_id,

2964: i_organization_id,
2965: res_rec.resource_id,
2966: res_rec.operation_id,
2967: sysdate,
2968: fnd_global.user_id,
2969: sysdate,
2970: fnd_global.user_id,
2971: fnd_global.user_id,
2972: i_operation_type,

Line 2970: fnd_global.user_id,

2966: res_rec.operation_id,
2967: sysdate,
2968: fnd_global.user_id,
2969: sysdate,
2970: fnd_global.user_id,
2971: fnd_global.user_id,
2972: i_operation_type,
2973: res_rec.line_id,
2974: res_rec.resource_assigned

Line 2971: fnd_global.user_id,

2967: sysdate,
2968: fnd_global.user_id,
2969: sysdate,
2970: fnd_global.user_id,
2971: fnd_global.user_id,
2972: i_operation_type,
2973: res_rec.line_id,
2974: res_rec.resource_assigned
2975: );