APPS.GME_CREATE_STEP_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 58: l_uom_class mtl_units_of_measure.uom_class%TYPE;

54: l_mass_qty gme_batch_steps.plan_mass_qty%TYPE;
55: l_volume_qty gme_batch_steps.plan_volume_qty%TYPE;
56: l_plan_charges gme_batch_steps.plan_charges%TYPE;
57: l_charge gme_batch_steps.plan_charges%TYPE;
58: l_uom_class mtl_units_of_measure.uom_class%TYPE;
59: l_batchstep_activity_id gme_batch_step_activities.batchstep_activity_id%TYPE;
60: l_activity_factor gme_batch_step_activities.plan_activity_factor%TYPE;
61: l_resources gme_batch_step_resources.resources%TYPE;
62: l_batchstep_ids_tab l_batchstep_ids;

Line 3351: x_uom_class mtl_units_of_measure.uom_class%TYPE;

3347: x_step_rows NUMBER;
3348: x_routing_id gme_batch_header.routing_id%TYPE;
3349: x_step_qty NUMBER;
3350: x_new_factor NUMBER;
3351: x_uom_class mtl_units_of_measure.uom_class%TYPE;
3352: x_scale_factor NUMBER;
3353: x_return_status VARCHAR2 (1);
3354: l_api_name CONSTANT VARCHAR2 (30) := 'Calc step qty';
3355:

Line 3359: FROM mtl_uom_conversions a, mtl_units_of_measure b

3355:
3356: CURSOR cur_get_std_factor (v_uom_code VARCHAR2)
3357: IS
3358: SELECT a.conversion_rate, b.uom_class
3359: FROM mtl_uom_conversions a, mtl_units_of_measure b
3360: WHERE a.uom_code = b.uom_code
3361: AND a.inventory_item_id = 0
3362: AND b.uom_code = v_uom_code;
3363:

Line 3367: FROM mtl_units_of_measure

3363:
3364: CURSOR cur_get_std_um (v_uom_class VARCHAR2)
3365: IS
3366: SELECT uom_code
3367: FROM mtl_units_of_measure
3368: WHERE uom_class = v_uom_class AND base_uom_flag = 'Y';
3369:
3370: load_steps_failed EXCEPTION;
3371: error_calculating_scale_factor EXCEPTION;

Line 3597: l_hour_um mtl_units_of_measure.uom_code%TYPE;

3593: ,p_usage_um IN gme_batch_step_resources.usage_um%TYPE
3594: ,x_usage_hrs OUT NOCOPY gme_batch_step_resources.plan_rsrc_usage%TYPE
3595: ,x_return_status OUT NOCOPY VARCHAR2)
3596: IS
3597: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3598: l_hour_uom_class mtl_units_of_measure.uom_class%TYPE;
3599: l_hour_std_factor NUMBER;
3600: l_usage_uom_class mtl_units_of_measure.uom_class%TYPE;
3601: l_usage_std_factor NUMBER;

Line 3598: l_hour_uom_class mtl_units_of_measure.uom_class%TYPE;

3594: ,x_usage_hrs OUT NOCOPY gme_batch_step_resources.plan_rsrc_usage%TYPE
3595: ,x_return_status OUT NOCOPY VARCHAR2)
3596: IS
3597: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3598: l_hour_uom_class mtl_units_of_measure.uom_class%TYPE;
3599: l_hour_std_factor NUMBER;
3600: l_usage_uom_class mtl_units_of_measure.uom_class%TYPE;
3601: l_usage_std_factor NUMBER;
3602: missing_profile_option EXCEPTION;

Line 3600: l_usage_uom_class mtl_units_of_measure.uom_class%TYPE;

3596: IS
3597: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3598: l_hour_uom_class mtl_units_of_measure.uom_class%TYPE;
3599: l_hour_std_factor NUMBER;
3600: l_usage_uom_class mtl_units_of_measure.uom_class%TYPE;
3601: l_usage_std_factor NUMBER;
3602: missing_profile_option EXCEPTION;
3603: l_api_name CONSTANT VARCHAR2 (30) := 'GET_USAGE_IN_HOURS';
3604:

Line 3608: FROM mtl_uom_conversions a, mtl_units_of_measure b

3604:
3605: CURSOR get_um_type_and_factor (v_uom_code VARCHAR2)
3606: IS
3607: SELECT b.uom_class, a.conversion_rate
3608: FROM mtl_uom_conversions a, mtl_units_of_measure b
3609: WHERE a.uom_code = b.uom_code
3610: AND a.inventory_item_id = 0
3611: AND b.uom_code = v_uom_code;
3612: BEGIN

Line 3707: l_hour_um mtl_units_of_measure.uom_code%TYPE;

3703: WHERE batchstep_id = v_step_id
3704: AND batch_id = v_batch_id
3705: AND batchstep_activity_id = v_activity_id;
3706:
3707: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3708: l_rsrc_duration NUMBER;
3709: l_act_duration NUMBER;
3710: l_max_rsrc_duration NUMBER;
3711: l_max_act_duration NUMBER;

Line 3805: l_hour_um mtl_units_of_measure.uom_code%TYPE;

3801: IS
3802: l_gme_resource_txns gme_resource_txns%ROWTYPE;
3803: l_txn_usage NUMBER;
3804: l_usage_time NUMBER;
3805: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3806: l_api_name CONSTANT VARCHAR2 (30) := 'insert_resource_txns';
3807: error_insert_res_txns EXCEPTION;
3808: missing_profile_option EXCEPTION;
3809: --FPBug#4395561