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.GME_CREATE_STEP_PVT dependencies on GME_COMMON_PVT

Line 191: IF (p_gme_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_batch) THEN

187:
188: x_return_status := fnd_api.g_ret_sts_success;
189: l_batch_id := p_gme_batch_header_rec.batch_id;
190:
191: IF (p_gme_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_batch) THEN
192: l_doc_type := 'PROD';
193: ELSE
194: l_doc_type := 'FPO';
195: END IF;

Line 214: gme_debug.put_line ('copy_routing_text_ind = '||gme_common_pvt.g_copy_routing_text_ind);

210: l_step_charge_rsrc_tab.DELETE ();
211:
212: --Bug#5112133
213: IF (NVL(g_debug, -1) = gme_debug.g_log_statement) THEN
214: gme_debug.put_line ('copy_routing_text_ind = '||gme_common_pvt.g_copy_routing_text_ind);
215: END IF;
216: WHILE i IS NOT NULL LOOP
217: l_gme_batch_steps.EXTEND;
218:

Line 231: l_gme_batch_steps (j).step_status := gme_common_pvt.g_step_pending;

227: p_recipe_rout_step_tbl (i).routingstep_id;
228: l_gme_batch_steps (j).batchstep_no :=
229: p_recipe_rout_step_tbl (i).routingstep_no;
230: l_gme_batch_steps (j).oprn_id := p_recipe_rout_step_tbl (i).oprn_id;
231: l_gme_batch_steps (j).step_status := gme_common_pvt.g_step_pending;
232: l_gme_batch_steps (j).quality_status := 1;
233: l_gme_batch_steps (j).delete_mark := 0;
234: l_gme_batch_steps (j).step_qty_um :=
235: p_recipe_rout_step_tbl (i).process_qty_uom;

Line 244: l_gme_batch_steps (j).plan_start_date := gme_common_pvt.g_timestamp;

240: l_gme_batch_steps (j).minimum_transfer_qty :=
241: p_recipe_rout_step_tbl (i).minimum_transfer_qty;
242: l_gme_batch_steps (j).plan_step_qty :=
243: p_recipe_rout_step_tbl (i).step_qty;
244: l_gme_batch_steps (j).plan_start_date := gme_common_pvt.g_timestamp;
245: l_gme_batch_steps (j).plan_cmplt_date := gme_common_pvt.g_timestamp;
246: l_gme_batch_steps (j).plan_charges := 0;
247:
248: IF p_gme_batch_header_rec.enforce_step_dependency = 1 THEN

Line 245: l_gme_batch_steps (j).plan_cmplt_date := gme_common_pvt.g_timestamp;

241: p_recipe_rout_step_tbl (i).minimum_transfer_qty;
242: l_gme_batch_steps (j).plan_step_qty :=
243: p_recipe_rout_step_tbl (i).step_qty;
244: l_gme_batch_steps (j).plan_start_date := gme_common_pvt.g_timestamp;
245: l_gme_batch_steps (j).plan_cmplt_date := gme_common_pvt.g_timestamp;
246: l_gme_batch_steps (j).plan_charges := 0;
247:
248: IF p_gme_batch_header_rec.enforce_step_dependency = 1 THEN
249: l_gme_batch_steps (j).steprelease_type := 1;

Line 275: AND (gme_common_pvt.g_copy_routing_text_ind = 1) THEN

271: -- Insert text if copy text is on and there is text on the step passed in...
272: -- Note... this should also work for insert step because an operation can have text
273: -- and so as long as gmd passes it back in the fetch... this will work (and copy_routing_text = '1')
274: IF (p_recipe_rout_step_tbl (i).text_code IS NOT NULL)
275: AND (gme_common_pvt.g_copy_routing_text_ind = 1) THEN
276: l_gmd_text_code := p_recipe_rout_step_tbl (i).text_code;
277: l_text_string :=
278: 'gme_batch_steps' || '|' || TO_CHAR (l_batch_id)
279: || '|';

Line 412: AND (gme_common_pvt.g_copy_routing_text_ind = 1) THEN

408: -- Insert text if copy text is on and there is text on the activity passed in...
409: -- Note... this should also work for insert step because an operation can have text
410: -- and so as long as gmd passes it back in the fetch... this will work (and copy_routing_text = '1')
411: IF (p_recipe_rout_act_tbl (i).text_code IS NOT NULL)
412: AND (gme_common_pvt.g_copy_routing_text_ind = 1) THEN
413: l_gmd_text_code := p_recipe_rout_act_tbl (i).text_code;
414: l_text_string :=
415: 'gme_batch_step_activities' || '|' || TO_CHAR (l_batch_id)
416: || '|';

Line 542: gme_common_pvt.log_message

538:
539: IF l_gme_batch_step_resources (j).scale_type <> 0 THEN
540: IF l_gme_batch_step_resources (j).plan_rsrc_qty = 0
541: AND l_gme_batch_step_resources (j).plan_rsrc_usage <> 0 THEN
542: gme_common_pvt.log_message
543: ('gme_rsrc_qty_usage_oprn'
544: ,'RESOURCE'
545: ,p_recipe_rout_resc_tbl (i).resources
546: ,'ACTIVITY'

Line 599: AND (gme_common_pvt.g_copy_routing_text_ind = '1') THEN

595: -- Insert text if copy text is on and there is text on the resource passed in...
596: -- Note... this should also work for insert step because an operation can have text
597: -- and so as long as gmd passes it back in the fetch... this will work (and copy_routing_text = '1')
598: IF (p_recipe_rout_resc_tbl (i).text_code IS NOT NULL)
599: AND (gme_common_pvt.g_copy_routing_text_ind = '1') THEN
600: l_gmd_text_code := p_recipe_rout_resc_tbl (i).text_code;
601: l_text_string :=
602: 'gme_batch_step_resources' || '|' || TO_CHAR (l_batch_id)
603: || '|';

Line 960: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables

956:
957: l_mass_qty := NULL;
958: l_volume_qty := NULL;
959:
960: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables
961: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
962: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
963: --multiply the step qty with standard factor to get mass qty
964: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;

Line 961: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN

957: l_mass_qty := NULL;
958: l_volume_qty := NULL;
959:
960: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables
961: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
962: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
963: --multiply the step qty with standard factor to get mass qty
964: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
965: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN

Line 962: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN

958: l_volume_qty := NULL;
959:
960: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables
961: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
962: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
963: --multiply the step qty with standard factor to get mass qty
964: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
965: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
966: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN

Line 965: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN

961: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
962: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
963: --multiply the step qty with standard factor to get mass qty
964: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
965: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
966: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN
967: --multiply the step qty with standard factor to get vol qty
968: l_volume_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
969: END IF;

Line 966: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN

962: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
963: --multiply the step qty with standard factor to get mass qty
964: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
965: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
966: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN
967: --multiply the step qty with standard factor to get vol qty
968: l_volume_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
969: END IF;
970:

Line 1212: IF gme_common_pvt.resource_qty_below_capacity

1208: END IF;
1209:
1210: /* Lets check if any of the resource quantities are falling below the min capacity */
1211: IF (p_ignore_qty_below_cap = fnd_api.g_false) THEN
1212: IF gme_common_pvt.resource_qty_below_capacity
1213: (p_batch_id => l_batch_id) THEN
1214: RAISE process_qty_below_cap;
1215: END IF;
1216: END IF; /* IF NOT (p_ignore_qty_below_cap) */

Line 1302: ,last_updated_by = gme_common_pvt.g_user_ident

1298:
1299: IF (p_step_cmplt_date > l_step_plan_cmplt_date) THEN
1300: UPDATE gme_batch_steps
1301: SET plan_cmplt_date = p_step_cmplt_date
1302: ,last_updated_by = gme_common_pvt.g_user_ident
1303: ,last_update_date = gme_common_pvt.g_timestamp
1304: ,last_update_login = gme_common_pvt.g_login_id
1305: WHERE batch_id = p_gme_batch_header_rec.batch_id
1306: AND batchstep_id = l_last_batchstep_id;

Line 1303: ,last_update_date = gme_common_pvt.g_timestamp

1299: IF (p_step_cmplt_date > l_step_plan_cmplt_date) THEN
1300: UPDATE gme_batch_steps
1301: SET plan_cmplt_date = p_step_cmplt_date
1302: ,last_updated_by = gme_common_pvt.g_user_ident
1303: ,last_update_date = gme_common_pvt.g_timestamp
1304: ,last_update_login = gme_common_pvt.g_login_id
1305: WHERE batch_id = p_gme_batch_header_rec.batch_id
1306: AND batchstep_id = l_last_batchstep_id;
1307: ELSIF (p_step_cmplt_date < l_step_plan_cmplt_date) THEN

Line 1304: ,last_update_login = gme_common_pvt.g_login_id

1300: UPDATE gme_batch_steps
1301: SET plan_cmplt_date = p_step_cmplt_date
1302: ,last_updated_by = gme_common_pvt.g_user_ident
1303: ,last_update_date = gme_common_pvt.g_timestamp
1304: ,last_update_login = gme_common_pvt.g_login_id
1305: WHERE batch_id = p_gme_batch_header_rec.batch_id
1306: AND batchstep_id = l_last_batchstep_id;
1307: ELSIF (p_step_cmplt_date < l_step_plan_cmplt_date) THEN
1308: l_gme_batch_header.batch_id := p_gme_batch_header_rec.batch_id;

Line 1426: wf_event.RAISE (p_event_name => gme_common_pvt.G_BATCHSTEP_CREATED

1422: END LOOP;
1423:
1424: IF ( p_recipe_rout_step_tbl.COUNT = 1
1425: AND p_recipe_rout_step_tbl (1).routingstep_id IS NULL) THEN
1426: wf_event.RAISE (p_event_name => gme_common_pvt.G_BATCHSTEP_CREATED
1427: ,p_event_key => l_gme_batch_steps (1).batchstep_id);
1428: END IF;
1429:
1430: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 2046: l_calendar_code := gme_common_pvt.g_calendar_code;

2042: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2043: gme_debug.put_line ('batch_id=' || l_batch_id);
2044: END IF;
2045:
2046: l_calendar_code := gme_common_pvt.g_calendar_code;
2047:
2048: IF l_calendar_code IS NULL THEN
2049: l_use_workday_cal := fnd_api.g_false;
2050: ELSE

Line 2294: ,p_start_date => gme_common_pvt.g_timestamp

2290:
2291: gmp_calendar_api.get_contiguous_periods
2292: (p_api_version => 1
2293: ,p_init_msg_list => TRUE
2294: ,p_start_date => gme_common_pvt.g_timestamp
2295: ,p_end_date => NULL
2296: ,p_calendar_code => l_calendar_code
2297: ,p_duration => x_batch_duration
2298: ,p_output_tbl => l_contig_period_tbl

Line 2314: x_batch_start_date := gme_common_pvt.g_timestamp;

2310: END IF;
2311: END IF;
2312: END IF;
2313:
2314: x_batch_start_date := gme_common_pvt.g_timestamp;
2315: END IF;
2316: END IF;
2317:
2318: /* Calculate the dates for all the rows in X_step_tbl */

Line 2580: ,last_updated_by = gme_common_pvt.g_user_ident

2576: -- Pawan Kumar made following changes for bug 5015873
2577: -- min_start_date := p_gme_batch_header_rec.plan_start_date;
2578: UPDATE gme_batch_header
2579: SET plan_cmplt_date = max_cmplt_date
2580: ,last_updated_by = gme_common_pvt.g_user_ident
2581: ,last_update_date = gme_common_pvt.g_timestamp
2582: ,last_update_login = gme_common_pvt.g_login_id
2583: WHERE batch_id = l_batch_id;
2584: ELSE

Line 2581: ,last_update_date = gme_common_pvt.g_timestamp

2577: -- min_start_date := p_gme_batch_header_rec.plan_start_date;
2578: UPDATE gme_batch_header
2579: SET plan_cmplt_date = max_cmplt_date
2580: ,last_updated_by = gme_common_pvt.g_user_ident
2581: ,last_update_date = gme_common_pvt.g_timestamp
2582: ,last_update_login = gme_common_pvt.g_login_id
2583: WHERE batch_id = l_batch_id;
2584: ELSE
2585: UPDATE gme_batch_header

Line 2582: ,last_update_login = gme_common_pvt.g_login_id

2578: UPDATE gme_batch_header
2579: SET plan_cmplt_date = max_cmplt_date
2580: ,last_updated_by = gme_common_pvt.g_user_ident
2581: ,last_update_date = gme_common_pvt.g_timestamp
2582: ,last_update_login = gme_common_pvt.g_login_id
2583: WHERE batch_id = l_batch_id;
2584: ELSE
2585: UPDATE gme_batch_header
2586: SET plan_start_date = min_start_date

Line 2588: ,last_updated_by = gme_common_pvt.g_user_ident

2584: ELSE
2585: UPDATE gme_batch_header
2586: SET plan_start_date = min_start_date
2587: ,plan_cmplt_date = max_cmplt_date
2588: ,last_updated_by = gme_common_pvt.g_user_ident
2589: ,last_update_date = gme_common_pvt.g_timestamp
2590: ,last_update_login = gme_common_pvt.g_login_id
2591: WHERE batch_id = l_batch_id;
2592: END IF;

Line 2589: ,last_update_date = gme_common_pvt.g_timestamp

2585: UPDATE gme_batch_header
2586: SET plan_start_date = min_start_date
2587: ,plan_cmplt_date = max_cmplt_date
2588: ,last_updated_by = gme_common_pvt.g_user_ident
2589: ,last_update_date = gme_common_pvt.g_timestamp
2590: ,last_update_login = gme_common_pvt.g_login_id
2591: WHERE batch_id = l_batch_id;
2592: END IF;
2593:

Line 2590: ,last_update_login = gme_common_pvt.g_login_id

2586: SET plan_start_date = min_start_date
2587: ,plan_cmplt_date = max_cmplt_date
2588: ,last_updated_by = gme_common_pvt.g_user_ident
2589: ,last_update_date = gme_common_pvt.g_timestamp
2590: ,last_update_login = gme_common_pvt.g_login_id
2591: WHERE batch_id = l_batch_id;
2592: END IF;
2593:
2594: /* UPDATE gme_batch_header

Line 2597: ,last_updated_by = gme_common_pvt.g_user_ident

2593:
2594: /* UPDATE gme_batch_header
2595: SET plan_start_date = min_start_date
2596: ,plan_cmplt_date = max_cmplt_date
2597: ,last_updated_by = gme_common_pvt.g_user_ident
2598: ,last_update_date = gme_common_pvt.g_timestamp
2599: ,last_update_login = gme_common_pvt.g_login_id
2600: WHERE batch_id = l_batch_id;*/
2601:

Line 2598: ,last_update_date = gme_common_pvt.g_timestamp

2594: /* UPDATE gme_batch_header
2595: SET plan_start_date = min_start_date
2596: ,plan_cmplt_date = max_cmplt_date
2597: ,last_updated_by = gme_common_pvt.g_user_ident
2598: ,last_update_date = gme_common_pvt.g_timestamp
2599: ,last_update_login = gme_common_pvt.g_login_id
2600: WHERE batch_id = l_batch_id;*/
2601:
2602: UPDATE gme_batch_header

Line 2599: ,last_update_login = gme_common_pvt.g_login_id

2595: SET plan_start_date = min_start_date
2596: ,plan_cmplt_date = max_cmplt_date
2597: ,last_updated_by = gme_common_pvt.g_user_ident
2598: ,last_update_date = gme_common_pvt.g_timestamp
2599: ,last_update_login = gme_common_pvt.g_login_id
2600: WHERE batch_id = l_batch_id;*/
2601:
2602: UPDATE gme_batch_header
2603: SET due_date = max_cmplt_date

Line 2604: ,last_updated_by = gme_common_pvt.g_user_ident

2600: WHERE batch_id = l_batch_id;*/
2601:
2602: UPDATE gme_batch_header
2603: SET due_date = max_cmplt_date
2604: ,last_updated_by = gme_common_pvt.g_user_ident
2605: ,last_update_date = gme_common_pvt.g_timestamp
2606: ,last_update_login = gme_common_pvt.g_login_id
2607: WHERE batch_id = l_batch_id
2608: AND due_date = gme_common_pvt.g_timestamp;

Line 2605: ,last_update_date = gme_common_pvt.g_timestamp

2601:
2602: UPDATE gme_batch_header
2603: SET due_date = max_cmplt_date
2604: ,last_updated_by = gme_common_pvt.g_user_ident
2605: ,last_update_date = gme_common_pvt.g_timestamp
2606: ,last_update_login = gme_common_pvt.g_login_id
2607: WHERE batch_id = l_batch_id
2608: AND due_date = gme_common_pvt.g_timestamp;
2609: END IF;

Line 2606: ,last_update_login = gme_common_pvt.g_login_id

2602: UPDATE gme_batch_header
2603: SET due_date = max_cmplt_date
2604: ,last_updated_by = gme_common_pvt.g_user_ident
2605: ,last_update_date = gme_common_pvt.g_timestamp
2606: ,last_update_login = gme_common_pvt.g_login_id
2607: WHERE batch_id = l_batch_id
2608: AND due_date = gme_common_pvt.g_timestamp;
2609: END IF;
2610:

Line 2608: AND due_date = gme_common_pvt.g_timestamp;

2604: ,last_updated_by = gme_common_pvt.g_user_ident
2605: ,last_update_date = gme_common_pvt.g_timestamp
2606: ,last_update_login = gme_common_pvt.g_login_id
2607: WHERE batch_id = l_batch_id
2608: AND due_date = gme_common_pvt.g_timestamp;
2609: END IF;
2610:
2611: IF g_debug <= gme_debug.g_log_procedure THEN
2612: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

Line 2632: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');

2628: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2629: gme_debug.put_line ('Contiguity period ... not found');
2630: END IF;
2631:
2632: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
2633: p_return_status := 'C';
2634: WHEN no_activities THEN
2635: p_return_status := fnd_api.g_ret_sts_error;
2636:

Line 2644: gme_common_pvt.log_message ('GME_NO_ACTIVITIES', 'STEPNO'

2640: INTO x_step_no;
2641:
2642: CLOSE cur_get_step;
2643:
2644: gme_common_pvt.log_message ('GME_NO_ACTIVITIES', 'STEPNO'
2645: ,x_step_no);
2646: WHEN no_resources THEN
2647: p_return_status := fnd_api.g_ret_sts_error;
2648:

Line 2656: gme_common_pvt.log_message ('GME_NO_RESOURCES'

2652: INTO l_activity;
2653:
2654: CLOSE cur_get_activity;
2655:
2656: gme_common_pvt.log_message ('GME_NO_RESOURCES'
2657: ,'ACTIVITY'
2658: ,l_activity);
2659: WHEN OTHERS THEN
2660: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 2890: IF (gme_common_pvt.g_mass_um_type IS NOT NULL) THEN

2886: IF x_return_status <> p_return_status THEN
2887: RAISE load_steps_failed;
2888: END IF;
2889:
2890: IF (gme_common_pvt.g_mass_um_type IS NOT NULL) THEN
2891: OPEN cur_get_std_um (gme_common_pvt.g_mass_um_type);
2892:
2893: FETCH cur_get_std_um
2894: INTO gmd_auto_step_calc.g_mass_std_um;

Line 2891: OPEN cur_get_std_um (gme_common_pvt.g_mass_um_type);

2887: RAISE load_steps_failed;
2888: END IF;
2889:
2890: IF (gme_common_pvt.g_mass_um_type IS NOT NULL) THEN
2891: OPEN cur_get_std_um (gme_common_pvt.g_mass_um_type);
2892:
2893: FETCH cur_get_std_um
2894: INTO gmd_auto_step_calc.g_mass_std_um;
2895:

Line 2899: IF (gme_common_pvt.g_volume_um_type IS NOT NULL) THEN

2895:
2896: CLOSE cur_get_std_um;
2897: END IF;
2898:
2899: IF (gme_common_pvt.g_volume_um_type IS NOT NULL) THEN
2900: OPEN cur_get_std_um (gme_common_pvt.g_volume_um_type);
2901:
2902: FETCH cur_get_std_um
2903: INTO gmd_auto_step_calc.g_vol_std_um;

Line 2900: OPEN cur_get_std_um (gme_common_pvt.g_volume_um_type);

2896: CLOSE cur_get_std_um;
2897: END IF;
2898:
2899: IF (gme_common_pvt.g_volume_um_type IS NOT NULL) THEN
2900: OPEN cur_get_std_um (gme_common_pvt.g_volume_um_type);
2901:
2902: FETCH cur_get_std_um
2903: INTO gmd_auto_step_calc.g_vol_std_um;
2904:

Line 2908: x_scale_factor := gme_common_pvt.g_routing_scale_factor;

2904:
2905: CLOSE cur_get_std_um;
2906: END IF;
2907:
2908: x_scale_factor := gme_common_pvt.g_routing_scale_factor;
2909: x_step_rows := p_step_tbl.COUNT;
2910:
2911: /* Calculate the step quantities for all the rows in X_step_tbl */
2912: FOR i IN 1 .. x_step_rows LOOP

Line 2930: IF x_uom_class = gme_common_pvt.g_mass_um_type THEN

2926: INTO x_new_factor, x_uom_class;
2927:
2928: CLOSE cur_get_std_factor;
2929:
2930: IF x_uom_class = gme_common_pvt.g_mass_um_type THEN
2931: p_step_tbl (i).step_mass_qty := x_step_qty * x_new_factor;
2932: p_step_tbl (i).step_mass_uom := gmd_auto_step_calc.g_mass_std_um;
2933: ELSIF x_uom_class = gme_common_pvt.g_volume_um_type THEN
2934: p_step_tbl (i).step_vol_qty := x_step_qty * x_new_factor;

Line 2933: ELSIF x_uom_class = gme_common_pvt.g_volume_um_type THEN

2929:
2930: IF x_uom_class = gme_common_pvt.g_mass_um_type THEN
2931: p_step_tbl (i).step_mass_qty := x_step_qty * x_new_factor;
2932: p_step_tbl (i).step_mass_uom := gmd_auto_step_calc.g_mass_std_um;
2933: ELSIF x_uom_class = gme_common_pvt.g_volume_um_type THEN
2934: p_step_tbl (i).step_vol_qty := x_step_qty * x_new_factor;
2935: p_step_tbl (i).step_vol_uom := gmd_auto_step_calc.g_vol_std_um;
2936: END IF;
2937: END LOOP; /*FOR i IN 1..X_step_rows*/

Line 2979: l_text_table gme_common_pvt.text_tab;

2975: IS
2976: l_number_of_text_lines NUMBER;
2977: l_return BOOLEAN;
2978: l_text_header gme_text_header%ROWTYPE;
2979: l_text_table gme_common_pvt.text_tab;
2980: l_api_name CONSTANT VARCHAR2 (30) := 'copy and create text';
2981: unexpected_error EXCEPTION;
2982:
2983: CURSOR fm_text_tbl_cursor (p_text_code fm_text_tbl.text_code%TYPE)

Line 3119: l_hour_um := gme_common_pvt.g_hour_uom_code;

3115: END IF;
3116:
3117: x_return_status := fnd_api.g_ret_sts_success;
3118: x_usage_hrs := 0;
3119: l_hour_um := gme_common_pvt.g_hour_uom_code;
3120:
3121: IF l_hour_um = p_usage_um THEN
3122: x_usage_hrs := p_plan_rsrc_usage;
3123: ELSE /* we have to calculate the usage in hours... */

Line 3216: l_hour_um := gme_common_pvt.g_hour_uom_code;

3212: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3213: || l_api_name);
3214: END IF;
3215:
3216: l_hour_um := gme_common_pvt.g_hour_uom_code;
3217:
3218: FOR step_activity IN cur_get_activity (v_step_id, v_batch_id) LOOP
3219: l_max_rsrc_duration := 0;
3220:

Line 3314: l_hour_um := gme_common_pvt.g_hour_uom_code;

3310: l_usage_time :=
3311: ( p_batch_step_resources_rec.plan_cmplt_date
3312: - p_batch_step_resources_rec.plan_start_date)
3313: * 24;
3314: l_hour_um := gme_common_pvt.g_hour_uom_code;
3315: l_txn_usage :=
3316: inv_convert.inv_um_convert
3317: (item_id => 0
3318: ,PRECISION => 5