[Home] [Help]
286:
287: -- Cursor Bug fix 3473802
288: CURSOR update_st_op
289: IS
290: SELECT standard_operation_id,
291: operation_sequence_id
292: FROM bom_operation_sequences
293: WHERE routing_sequence_id = to_sequence_id;
294: l_from_item_id NUMBER;
349: last_updated_by,
350: creation_date,
351: created_by,
352: last_update_login,
353: standard_operation_id,
354: department_id,
355: operation_lead_time_percent,
356: minimum_transfer_quantity,
357: count_point_type,
426: a.operation_sequence_id,
427: l_curr_date,
428: user_id,
429: user_id,
430: a.standard_operation_id,
431: c.department_id,
432: NULL,
433: a.minimum_transfer_quantity,
434: a.count_point_type,
958:
959: EXIT WHEN update_st_op%NOTFOUND;
960:
961: BEGIN
962: SELECT b.standard_operation_id,
963: b.minimum_transfer_quantity,
964: b.backflush_flag,
965: b.option_dependent_flag,
966: b.count_point_type,
970: back_flag,
971: opt_flag,
972: count_type,
973: opr_desc
974: FROM bom_standard_operations_v a, -- BUG 3936049
975: bom_standard_operations_v b -- BUG 3936049
976: WHERE a.standard_operation_id = p_st_op_id
977: AND a.operation_code = b.operation_code
978: AND a.organization_id = from_org_id
971: opt_flag,
972: count_type,
973: opr_desc
974: FROM bom_standard_operations_v a, -- BUG 3936049
975: bom_standard_operations_v b -- BUG 3936049
976: WHERE a.standard_operation_id = p_st_op_id
977: AND a.operation_code = b.operation_code
978: AND a.organization_id = from_org_id
979: AND b.organization_id = to_org_id
972: count_type,
973: opr_desc
974: FROM bom_standard_operations_v a, -- BUG 3936049
975: bom_standard_operations_v b -- BUG 3936049
976: WHERE a.standard_operation_id = p_st_op_id
977: AND a.operation_code = b.operation_code
978: AND a.organization_id = from_org_id
979: AND b.organization_id = to_org_id
980: AND NVL (a.line_code, '@@@') = NVL (b.line_code, '@@@')
982: AND NVL (a.operation_type, -99) = NVL (b.operation_type,
983: -99); -- BUG 3936049
984:
985: UPDATE bom_operation_sequences
986: SET standard_operation_id = new_st_op_id,
987: minimum_transfer_quantity = min_qty,
988: backflush_flag = back_flag,
989: option_dependent_flag = opt_flag,
990: count_point_type = count_type,
996: EXCEPTION
997: WHEN NO_DATA_FOUND
998: THEN
999: UPDATE bom_operation_sequences
1000: SET standard_operation_id = NULL
1001: WHERE routing_sequence_id = to_sequence_id
1002: AND operation_sequence_id = p_op_seq_id;
1003: END;
1004: END LOOP;
1010: insert into bom_operation_skills
1011: (LEVEL_ID,
1012: ORGANIZATION_ID,
1013: OPERATION_SEQUENCE_ID,
1014: STANDARD_OPERATION_ID,
1015: RESOURCE_ID,
1016: COMPETENCE_ID,
1017: RATING_LEVEL_ID,
1018: QUALIFICATION_TYPE_ID,
1025: select
1026: SKL.LEVEL_ID,
1027: to_org_id,
1028: SEQ2.OPERATION_SEQUENCE_ID,
1029: SKL.STANDARD_OPERATION_ID,
1030: SKL.RESOURCE_ID,
1031: SKL.COMPETENCE_ID,
1032: SKL.RATING_LEVEL_ID,
1033: SKL.QUALIFICATION_TYPE_ID,
1504: (operation_sequence_id,
1505: resource_seq_num,
1506: resource_id,
1507: activity_id,
1508: standard_rate_flag,
1509: assigned_units,
1510: usage_rate_or_amount,
1511: usage_rate_or_amount_inverse,
1512: basis_type,
1549: SELECT a.operation_sequence_id,
1550: b.resource_seq_num,
1551: d.resource_id,
1552: b.activity_id,
1553: b.standard_rate_flag,
1554: -- DECODE(E.AVAILABLE_24_HOURS_FLAG, 1, 1, B.ASSIGNED_UNITS), -- changed for bug 2661684
1555: b.assigned_units,
1556: b.usage_rate_or_amount,
1557: b.usage_rate_or_amount_inverse,
1751: resource_id,
1752: schedule_seq_num,
1753: replacement_group_num,
1754: activity_id,
1755: standard_rate_flag,
1756: assigned_units,
1757: usage_rate_or_amount,
1758: usage_rate_or_amount_inverse,
1759: basis_type,
1797: d.resource_id,
1798: b.schedule_seq_num,
1799: b.replacement_group_num,
1800: b.activity_id,
1801: b.standard_rate_flag,
1802: b.assigned_units,
1803: b.usage_rate_or_amount,
1804: b.usage_rate_or_amount_inverse,
1805: b.basis_type,
2400:
2401: -- Cursor Bug fix 3473802
2402: CURSOR update_st_op
2403: IS
2404: SELECT standard_operation_id,
2405: operation_sequence_id
2406: FROM bom_operation_sequences
2407: WHERE routing_sequence_id = to_sequence_id;
2408: l_from_item_id NUMBER;
2463: last_updated_by,
2464: creation_date,
2465: created_by,
2466: last_update_login,
2467: standard_operation_id,
2468: department_id,
2469: operation_lead_time_percent,
2470: minimum_transfer_quantity,
2471: count_point_type,
2540: a.operation_sequence_id,
2541: l_curr_date,
2542: user_id,
2543: user_id,
2544: a.standard_operation_id,
2545: c.department_id,
2546: NULL,
2547: a.minimum_transfer_quantity,
2548: a.count_point_type,
2898:
2899: EXIT WHEN update_st_op%NOTFOUND;
2900:
2901: BEGIN
2902: SELECT b.standard_operation_id,
2903: b.minimum_transfer_quantity,
2904: b.backflush_flag,
2905: b.option_dependent_flag,
2906: b.count_point_type,
2910: back_flag,
2911: opt_flag,
2912: count_type,
2913: opr_desc
2914: FROM bom_standard_operations_v a, -- BUG 3936049
2915: bom_standard_operations_v b -- BUG 3936049
2916: WHERE a.standard_operation_id = p_st_op_id
2917: AND a.operation_code = b.operation_code
2918: AND a.organization_id = from_org_id
2911: opt_flag,
2912: count_type,
2913: opr_desc
2914: FROM bom_standard_operations_v a, -- BUG 3936049
2915: bom_standard_operations_v b -- BUG 3936049
2916: WHERE a.standard_operation_id = p_st_op_id
2917: AND a.operation_code = b.operation_code
2918: AND a.organization_id = from_org_id
2919: AND b.organization_id = to_org_id
2912: count_type,
2913: opr_desc
2914: FROM bom_standard_operations_v a, -- BUG 3936049
2915: bom_standard_operations_v b -- BUG 3936049
2916: WHERE a.standard_operation_id = p_st_op_id
2917: AND a.operation_code = b.operation_code
2918: AND a.organization_id = from_org_id
2919: AND b.organization_id = to_org_id
2920: AND NVL (a.line_code, '@@@') = NVL (b.line_code, '@@@')
2922: AND NVL (a.operation_type, -99) = NVL (b.operation_type,
2923: -99); -- BUG 3936049
2924:
2925: UPDATE bom_operation_sequences
2926: SET standard_operation_id = new_st_op_id,
2927: minimum_transfer_quantity = min_qty,
2928: backflush_flag = back_flag,
2929: option_dependent_flag = opt_flag,
2930: count_point_type = count_type,
2936: EXCEPTION
2937: WHEN NO_DATA_FOUND
2938: THEN
2939: UPDATE bom_operation_sequences
2940: SET standard_operation_id = NULL
2941: WHERE routing_sequence_id = to_sequence_id
2942: AND operation_sequence_id = p_op_seq_id;
2943: END;
2944: END LOOP;
2950: insert into bom_operation_skills
2951: (LEVEL_ID,
2952: ORGANIZATION_ID,
2953: OPERATION_SEQUENCE_ID,
2954: STANDARD_OPERATION_ID,
2955: RESOURCE_ID,
2956: COMPETENCE_ID,
2957: RATING_LEVEL_ID,
2958: QUALIFICATION_TYPE_ID,
2965: select
2966: SKL.LEVEL_ID,
2967: to_org_id,
2968: SEQ2.OPERATION_SEQUENCE_ID,
2969: SKL.STANDARD_OPERATION_ID,
2970: SKL.RESOURCE_ID,
2971: SKL.COMPETENCE_ID,
2972: SKL.RATING_LEVEL_ID,
2973: SKL.QUALIFICATION_TYPE_ID,
3396: (operation_sequence_id,
3397: resource_seq_num,
3398: resource_id,
3399: activity_id,
3400: standard_rate_flag,
3401: assigned_units,
3402: usage_rate_or_amount,
3403: usage_rate_or_amount_inverse,
3404: basis_type,
3441: SELECT a.operation_sequence_id,
3442: b.resource_seq_num,
3443: d.resource_id,
3444: b.activity_id,
3445: b.standard_rate_flag,
3446: -- DECODE(E.AVAILABLE_24_HOURS_FLAG, 1, 1, B.ASSIGNED_UNITS), -- changed for bug 2661684
3447: b.assigned_units,
3448: b.usage_rate_or_amount,
3449: b.usage_rate_or_amount_inverse,
3649: resource_id,
3650: schedule_seq_num,
3651: replacement_group_num,
3652: activity_id,
3653: standard_rate_flag,
3654: assigned_units,
3655: usage_rate_or_amount,
3656: usage_rate_or_amount_inverse,
3657: basis_type,
3694: d.resource_id,
3695: b.schedule_seq_num,
3696: b.replacement_group_num,
3697: b.activity_id,
3698: b.standard_rate_flag,
3699: b.assigned_units,
3700: b.usage_rate_or_amount,
3701: b.usage_rate_or_amount_inverse,
3702: b.basis_type,