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 2850: x_uom_class mtl_units_of_measure.uom_class%TYPE;

2846: x_step_rows NUMBER;
2847: x_routing_id gme_batch_header.routing_id%TYPE;
2848: x_step_qty NUMBER;
2849: x_new_factor NUMBER;
2850: x_uom_class mtl_units_of_measure.uom_class%TYPE;
2851: x_scale_factor NUMBER;
2852: x_return_status VARCHAR2 (1);
2853: l_api_name CONSTANT VARCHAR2 (30) := 'Calc step qty';
2854:

Line 2858: FROM mtl_uom_conversions a, mtl_units_of_measure b

2854:
2855: CURSOR cur_get_std_factor (v_uom_code VARCHAR2)
2856: IS
2857: SELECT a.conversion_rate, b.uom_class
2858: FROM mtl_uom_conversions a, mtl_units_of_measure b
2859: WHERE a.uom_code = b.uom_code
2860: AND a.inventory_item_id = 0
2861: AND b.uom_code = v_uom_code;
2862:

Line 2866: FROM mtl_units_of_measure

2862:
2863: CURSOR cur_get_std_um (v_uom_class VARCHAR2)
2864: IS
2865: SELECT uom_code
2866: FROM mtl_units_of_measure
2867: WHERE uom_class = v_uom_class AND base_uom_flag = 'Y';
2868:
2869: load_steps_failed EXCEPTION;
2870: error_calculating_scale_factor EXCEPTION;

Line 3096: l_hour_um mtl_units_of_measure.uom_code%TYPE;

3092: ,p_usage_um IN gme_batch_step_resources.usage_um%TYPE
3093: ,x_usage_hrs OUT NOCOPY gme_batch_step_resources.plan_rsrc_usage%TYPE
3094: ,x_return_status OUT NOCOPY VARCHAR2)
3095: IS
3096: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3097: l_hour_uom_class mtl_units_of_measure.uom_class%TYPE;
3098: l_hour_std_factor NUMBER;
3099: l_usage_uom_class mtl_units_of_measure.uom_class%TYPE;
3100: l_usage_std_factor NUMBER;

Line 3097: l_hour_uom_class mtl_units_of_measure.uom_class%TYPE;

3093: ,x_usage_hrs OUT NOCOPY gme_batch_step_resources.plan_rsrc_usage%TYPE
3094: ,x_return_status OUT NOCOPY VARCHAR2)
3095: IS
3096: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3097: l_hour_uom_class mtl_units_of_measure.uom_class%TYPE;
3098: l_hour_std_factor NUMBER;
3099: l_usage_uom_class mtl_units_of_measure.uom_class%TYPE;
3100: l_usage_std_factor NUMBER;
3101: missing_profile_option EXCEPTION;

Line 3099: l_usage_uom_class mtl_units_of_measure.uom_class%TYPE;

3095: IS
3096: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3097: l_hour_uom_class mtl_units_of_measure.uom_class%TYPE;
3098: l_hour_std_factor NUMBER;
3099: l_usage_uom_class mtl_units_of_measure.uom_class%TYPE;
3100: l_usage_std_factor NUMBER;
3101: missing_profile_option EXCEPTION;
3102: l_api_name CONSTANT VARCHAR2 (30) := 'GET_USAGE_IN_HOURS';
3103:

Line 3107: FROM mtl_uom_conversions a, mtl_units_of_measure b

3103:
3104: CURSOR get_um_type_and_factor (v_uom_code VARCHAR2)
3105: IS
3106: SELECT b.uom_class, a.conversion_rate
3107: FROM mtl_uom_conversions a, mtl_units_of_measure b
3108: WHERE a.uom_code = b.uom_code
3109: AND a.inventory_item_id = 0
3110: AND b.uom_code = v_uom_code;
3111: BEGIN

Line 3200: l_hour_um mtl_units_of_measure.uom_code%TYPE;

3196: WHERE batchstep_id = v_step_id
3197: AND batch_id = v_batch_id
3198: AND batchstep_activity_id = v_activity_id;
3199:
3200: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3201: l_rsrc_duration NUMBER;
3202: l_act_duration NUMBER;
3203: l_max_rsrc_duration NUMBER;
3204: l_max_act_duration NUMBER;

Line 3297: l_hour_um mtl_units_of_measure.uom_code%TYPE;

3293: IS
3294: l_gme_resource_txns gme_resource_txns%ROWTYPE;
3295: l_txn_usage NUMBER;
3296: l_usage_time NUMBER;
3297: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3298: l_api_name CONSTANT VARCHAR2 (30) := 'insert_resource_txns';
3299: error_insert_res_txns EXCEPTION;
3300: missing_profile_option EXCEPTION;
3301: --FPBug#4395561