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.MIGRATE_BATCH dependencies on GME_BATCH_STEPS

Line 355: p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE

351: RAISE;
352: END get_planned_usage;
353:
354: FUNCTION get_actual_activity_factor (
355: p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
356: )
357: RETURN gme_batch_step_activities.actual_activity_factor%TYPE IS
358: l_step_status gme_batch_steps.step_status%TYPE;
359: l_pos NUMBER := 0;

Line 358: l_step_status gme_batch_steps.step_status%TYPE;

354: FUNCTION get_actual_activity_factor (
355: p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
356: )
357: RETURN gme_batch_step_activities.actual_activity_factor%TYPE IS
358: l_step_status gme_batch_steps.step_status%TYPE;
359: l_pos NUMBER := 0;
360: BEGIN
361: l_pos := 1;
362: SELECT step_status

Line 364: FROM gme_batch_steps

360: BEGIN
361: l_pos := 1;
362: SELECT step_status
363: INTO l_step_status
364: FROM gme_batch_steps
365: WHERE batchstep_id = p_batchstep_id;
366: l_pos := 2;
367:
368: IF l_step_status IN (1, 5) THEN

Line 378: p_table_name => 'gme_batch_steps',

374: END IF;
375: EXCEPTION
376: WHEN OTHERS THEN
377: insert_message (
378: p_table_name => 'gme_batch_steps',
379: p_procedure_name => 'get_actual_activity_factor',
380: p_parameters => p_batchstep_id,
381: p_message => SQLERRM || ' with pos = ' || l_pos,
382: p_error_type => 'D'

Line 421: FROM gme_batch_steps

417: BEGIN
418: l_pos := 1;
419: SELECT oprn_id
420: INTO v_oprn_id
421: FROM gme_batch_steps
422: WHERE batch_id = p_batch_id AND
423: batchstep_no = p_batchstep_no;
424: l_pos := 2;
425: RETURN v_oprn_id;

Line 429: p_table_name => 'gme_batch_steps',

425: RETURN v_oprn_id;
426: EXCEPTION
427: WHEN OTHERS THEN
428: insert_message (
429: p_table_name => 'gme_batch_steps',
430: p_procedure_name => 'get_oprn_id',
431: p_parameters => 'batch_id = '
432: || p_batch_id
433: || ' batchstep_no = '

Line 602: FROM gme_batch_steps

598: BEGIN
599: l_pos := 1;
600: SELECT batchstep_id
601: INTO v_batchstep_id
602: FROM gme_batch_steps
603: WHERE batch_id = p_batch_id AND
604: batchstep_no = p_batchstep_no;
605: l_pos := 2;
606: RETURN v_batchstep_id;

Line 610: p_table_name => 'gme_batch_steps',

606: RETURN v_batchstep_id;
607: EXCEPTION
608: WHEN OTHERS THEN
609: insert_message (
610: p_table_name => 'gme_batch_steps',
611: p_procedure_name => 'get_batchstep_id',
612: p_parameters => 'batch_id = '
613: || p_batch_id
614: || ' batchstep_no = '

Line 635: FROM gme_batch_steps

631: BEGIN
632: l_pos := 1;
633: SELECT batchstep_id
634: INTO v_step_id
635: FROM gme_batch_steps
636: WHERE batch_id = p_batch_id AND
637: batchstep_no = p_batchstep_no;
638: l_pos := 2;
639: SELECT batchstep_activity_id

Line 650: p_table_name => 'gme_batch_steps, gme_batch_step_activities',

646: RETURN v_activity_id;
647: EXCEPTION
648: WHEN OTHERS THEN
649: insert_message (
650: p_table_name => 'gme_batch_steps, gme_batch_step_activities',
651: p_procedure_name => 'get_activity_id',
652: p_parameters => 'batch_id = '
653: || p_batch_id
654: || ' batchstep_no = '

Line 681: FROM gme_batch_steps

677: FROM gme_batch_step_activities
678: WHERE activity = p_activity AND
679: batch_id = p_batch_id AND
680: batchstep_id = (SELECT batchstep_id
681: FROM gme_batch_steps
682: WHERE batch_id = p_batch_id AND
683: batchstep_no = p_batchstep_no);
684: l_pos := 2;
685: RETURN p_offset - l_act_offset;

Line 2855: INSERT INTO gme_batch_steps

2851: l_return_status VARCHAR2 (1);
2852: BEGIN
2853: x_return_status := FND_API.G_RET_STS_SUCCESS;
2854:
2855: INSERT INTO gme_batch_steps
2856: (batch_id,
2857: batchstep_id,
2858: routingstep_id,
2859: batchstep_no,

Line 3012: p_table_name => 'gme_batch_steps',

3008: WHERE in_use < 100 AND
3009: delete_mark <> 1;
3010:
3011: insert_message (
3012: p_table_name => 'gme_batch_steps',
3013: p_procedure_name => 'insert_batch_steps',
3014: p_parameters => 'none',
3015: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
3016: p_error_type => 'P'

Line 3027: p_table_name => 'GME_BATCH_STEPS',

3023: EXCEPTION
3024: WHEN OTHERS THEN
3025: x_return_status := 'D';
3026: insert_message (
3027: p_table_name => 'GME_BATCH_STEPS',
3028: p_procedure_name => 'INSERT_BATCH_STEPS',
3029: p_parameters => '',
3030: p_message => SQLERRM,
3031: p_error_type => x_return_status

Line 3391: FROM gme_batch_steps step

3387: FROM gme_batch_step_items
3388: WHERE material_detail_id = pm.batchline_id)
3389: AND
3390: EXISTS ( SELECT 1
3391: FROM gme_batch_steps step
3392: WHERE step.batch_id = pm.batch_id AND
3393: step.batchstep_no = pm.batchstep_no)
3394: AND
3395: EXISTS ( SELECT 1

Line 3431: FROM gme_batch_steps step

3427: WHERE material_detail_id = pm.batchline_id)
3428: AND
3429: (
3430: NOT EXISTS ( SELECT 1
3431: FROM gme_batch_steps step
3432: WHERE step.batch_id = pm.batch_id AND
3433: step.batchstep_no = pm.batchstep_no) OR
3434: NOT EXISTS ( SELECT 1
3435: FROM gme_material_details matl

Line 3617: FROM gme_batch_steps step

3613: -- the record was marked for delete in the steps table, and, the old code
3614: -- did not delete the dependency.
3615: AND
3616: EXISTS ( SELECT 1
3617: FROM gme_batch_steps step
3618: WHERE step.batch_id = dep.batch_id AND
3619: step.batchstep_no = dep.batchstep_no) AND
3620: EXISTS ( SELECT 1
3621: FROM gme_batch_steps step

Line 3621: FROM gme_batch_steps step

3617: FROM gme_batch_steps step
3618: WHERE step.batch_id = dep.batch_id AND
3619: step.batchstep_no = dep.batchstep_no) AND
3620: EXISTS ( SELECT 1
3621: FROM gme_batch_steps step
3622: WHERE step.batch_id = dep.batch_id AND
3623: step.batchstep_no = dep.dep_step_no);
3624:
3625: insert_message (

Line 3655: FROM gme_batch_steps step

3651: SELECT batch_id, batchstep_no, dep_step_no
3652: FROM pm_rout_dep dep
3653: WHERE dep_type < 100 AND
3654: (NOT EXISTS ( SELECT 1
3655: FROM gme_batch_steps step
3656: WHERE step.batch_id = dep.batch_id AND
3657: step.batchstep_no = dep.batchstep_no) OR
3658: NOT EXISTS ( SELECT 1
3659: FROM gme_batch_steps step

Line 3659: FROM gme_batch_steps step

3655: FROM gme_batch_steps step
3656: WHERE step.batch_id = dep.batch_id AND
3657: step.batchstep_no = dep.batchstep_no) OR
3658: NOT EXISTS ( SELECT 1
3659: FROM gme_batch_steps step
3660: WHERE step.batch_id = dep.batch_id AND
3661: step.batchstep_no = dep.dep_step_no));
3662:
3663: