[Home] [Help]
377: l_routing_class GMD_ROUTINGS_B.routing_class%TYPE;
378: l_routing_id GMD_ROUTINGS_B.routing_id%TYPE;
379: l_routingStep_id FM_ROUT_DTL.RoutingStep_id%TYPE;
380:
381: l_old_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
382: l_new_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
383: l_oprn_class GMD_OPERATIONS_B.oprn_class%TYPE;
384: l_old_resource GMD_OPERATION_RESOURCES.resources%TYPE;
385: l_new_resource GMD_OPERATION_RESOURCES.resources%TYPE;
378: l_routing_id GMD_ROUTINGS_B.routing_id%TYPE;
379: l_routingStep_id FM_ROUT_DTL.RoutingStep_id%TYPE;
380:
381: l_old_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
382: l_new_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
383: l_oprn_class GMD_OPERATIONS_B.oprn_class%TYPE;
384: l_old_resource GMD_OPERATION_RESOURCES.resources%TYPE;
385: l_new_resource GMD_OPERATION_RESOURCES.resources%TYPE;
386: l_oprn_id GMD_OPERATIONS_B.oprn_id%TYPE;
383: l_oprn_class GMD_OPERATIONS_B.oprn_class%TYPE;
384: l_old_resource GMD_OPERATION_RESOURCES.resources%TYPE;
385: l_new_resource GMD_OPERATION_RESOURCES.resources%TYPE;
386: l_oprn_id GMD_OPERATIONS_B.oprn_id%TYPE;
387: l_oprn_line_id GMD_OPERATION_ACTIVITIES.oprn_line_id%TYPE;
388:
389:
390: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;
391: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;
418: WHERE routing_id = cp_routing_id
419: AND oprn_id = cp_oprn_id;
420:
421: CURSOR c_Operation_line_id (cp_operation_id
422: gmd_operation_activities.oprn_id%TYPE,cp_resource_name gmd_operation_resources.resources%TYPE) is
423: SELECT r.oprn_line_id
424: FROM gmd_operation_resources r, gmd_operation_activities a
425: WHERE a.oprn_id = cp_operation_id
426: AND r.resources = cp_resource_name
420:
421: CURSOR c_Operation_line_id (cp_operation_id
422: gmd_operation_activities.oprn_id%TYPE,cp_resource_name gmd_operation_resources.resources%TYPE) is
423: SELECT r.oprn_line_id
424: FROM gmd_operation_resources r, gmd_operation_activities a
425: WHERE a.oprn_id = cp_operation_id
426: AND r.resources = cp_resource_name
427: AND a.oprn_line_id = r.oprn_line_id;
428:
430:
431: -- Define different table types
432: p_rout_update_table GMD_ROUTINGS_PUB.update_tbl_type;
433: p_oprn_update_table GMD_OPERATIONS_PUB.update_tbl_type;
434: p_oprn_activity_table GMD_OPERATION_ACTIVITIES_PUB.update_tbl_type;
435: p_oprn_resources_table GMD_OPERATION_RESOURCES_PUB.update_tbl_type;
436: p_validity_rules_table GMD_VALIDITY_RULES_PVT.update_tbl_type;
437:
438: CURSOR get_object_info IS
1624: -- Get the oprn_line_id based on the old oprn_id (object_id)
1625: -- and old activity (old_name).
1626: SELECT oprn_line_id
1627: INTO l_oprn_line_id
1628: FROM gmd_operation_activities
1629: WHERE oprn_id = get_object_rec.object_id
1630: AND activity = get_object_rec.old_name;
1631:
1632: p_oprn_activity_table(1).P_COL_TO_UPDATE := get_object_rec.replace_type;
1631:
1632: p_oprn_activity_table(1).P_COL_TO_UPDATE := get_object_rec.replace_type;
1633: p_oprn_activity_table(1).P_VALUE := get_object_rec.new_name;
1634:
1635: GMD_OPERATION_ACTIVITIES_PUB.update_operation_activity
1636: ( p_oprn_line_id => l_oprn_line_id
1637: , p_update_table => p_oprn_activity_table
1638: , X_RETURN_STATUS => l_return_status --Return Status
1639: , X_MESSAGE_COUNT => l_mesg_count --Message Count
2245: AND INVENTORY_ITEM_ID = ');
2246: fnd_dsql.add_bind(pOld_name);
2247: fnd_dsql.add_text(' ))');
2248: ELSIF (pReplace_type = 'ACTIVITY') THEN
2249: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2250: WHERE ACTIVITY = ');
2251: fnd_dsql.add_bind(pOld_name);
2252: fnd_dsql.add_text(' ))');
2253: ELSIF (pReplace_type = 'RESOURCES') THEN
2251: fnd_dsql.add_bind(pOld_name);
2252: fnd_dsql.add_text(' ))');
2253: ELSIF (pReplace_type = 'RESOURCES') THEN
2254: fnd_dsql.add_text(' SELECT OPRN_ID
2255: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2256: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID
2257: AND r.RESOURCES = ');
2258: fnd_dsql.add_bind(pOld_name);
2259: fnd_dsql.add_text(' ))');