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_BATCH_STEP_ACTIVITIES

Line 27: l_gme_batch_step_activities gme_create_step_pvt.gme_batch_step_activities_tab

23: -- Local variables
24: l_gme_batch_steps gme_create_step_pvt.gme_batch_steps_tab
25: := gme_create_step_pvt.gme_batch_steps_tab
26: ();
27: l_gme_batch_step_activities gme_create_step_pvt.gme_batch_step_activities_tab
28: := gme_create_step_pvt.gme_batch_step_activities_tab
29: ();
30: l_gme_batch_step_resources gme_create_step_pvt.gme_batch_step_resources_tab
31: := gme_create_step_pvt.gme_batch_step_resources_tab

Line 28: := gme_create_step_pvt.gme_batch_step_activities_tab

24: l_gme_batch_steps gme_create_step_pvt.gme_batch_steps_tab
25: := gme_create_step_pvt.gme_batch_steps_tab
26: ();
27: l_gme_batch_step_activities gme_create_step_pvt.gme_batch_step_activities_tab
28: := gme_create_step_pvt.gme_batch_step_activities_tab
29: ();
30: l_gme_batch_step_resources gme_create_step_pvt.gme_batch_step_resources_tab
31: := gme_create_step_pvt.gme_batch_step_resources_tab
32: ();

Line 59: l_batchstep_activity_id gme_batch_step_activities.batchstep_activity_id%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;
63: l_total_scale_by_charge PLS_INTEGER;

Line 60: l_activity_factor gme_batch_step_activities.plan_activity_factor%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;
63: l_total_scale_by_charge PLS_INTEGER;
64: l_count_scale_by_charge PLS_INTEGER;

Line 115: FROM gme_batch_step_activities

111:
112: CURSOR cur_get_activities (v_batch_id NUMBER)
113: IS
114: SELECT batchstep_activity_id, plan_activity_factor
115: FROM gme_batch_step_activities
116: WHERE batch_id = v_batch_id;
117:
118: CURSOR cur_get_step_activities (
119: x_step_id gme_batch_step_activities.batchstep_id%TYPE

Line 119: x_step_id gme_batch_step_activities.batchstep_id%TYPE

115: FROM gme_batch_step_activities
116: WHERE batch_id = v_batch_id;
117:
118: CURSOR cur_get_step_activities (
119: x_step_id gme_batch_step_activities.batchstep_id%TYPE
120: ,x_batch_id NUMBER)
121: IS
122: SELECT batchstep_activity_id, plan_activity_factor
123: FROM gme_batch_step_activities

Line 123: FROM gme_batch_step_activities

119: x_step_id gme_batch_step_activities.batchstep_id%TYPE
120: ,x_batch_id NUMBER)
121: IS
122: SELECT batchstep_activity_id, plan_activity_factor
123: FROM gme_batch_step_activities
124: WHERE batchstep_id = x_step_id AND batch_id = x_batch_id;
125:
126: CURSOR cur_get_resources (v_batchstep_activity_id NUMBER)
127: IS

Line 351: gme_debug.put_line ('GME_BATCH_STEP_ACTIVITIES');

347: END LOOP; /* WHILE i IS NOT NULL; BATCH STEPS */
348:
349: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
350: gme_debug.put_line ('Completed batch steps');
351: gme_debug.put_line ('GME_BATCH_STEP_ACTIVITIES');
352: END IF;
353:
354: i := p_recipe_rout_act_tbl.FIRST;
355: j := 0;

Line 358: l_gme_batch_step_activities.EXTEND;

354: i := p_recipe_rout_act_tbl.FIRST;
355: j := 0;
356:
357: WHILE i IS NOT NULL LOOP
358: l_gme_batch_step_activities.EXTEND;
359:
360: IF (j = 0) THEN
361: j := l_gme_batch_step_activities.FIRST;
362: ELSE

Line 361: j := l_gme_batch_step_activities.FIRST;

357: WHILE i IS NOT NULL LOOP
358: l_gme_batch_step_activities.EXTEND;
359:
360: IF (j = 0) THEN
361: j := l_gme_batch_step_activities.FIRST;
362: ELSE
363: j := l_gme_batch_step_activities.NEXT (j);
364: END IF;
365:

Line 363: j := l_gme_batch_step_activities.NEXT (j);

359:
360: IF (j = 0) THEN
361: j := l_gme_batch_step_activities.FIRST;
362: ELSE
363: j := l_gme_batch_step_activities.NEXT (j);
364: END IF;
365:
366: l_gme_batch_step_activities (j).batch_id := l_batch_id;
367: l_gme_batch_step_activities (j).activity :=

Line 366: l_gme_batch_step_activities (j).batch_id := l_batch_id;

362: ELSE
363: j := l_gme_batch_step_activities.NEXT (j);
364: END IF;
365:
366: l_gme_batch_step_activities (j).batch_id := l_batch_id;
367: l_gme_batch_step_activities (j).activity :=
368: p_recipe_rout_act_tbl (i).activity;
369: l_gme_batch_step_activities (j).oprn_line_id :=
370: p_recipe_rout_act_tbl (i).oprn_line_id;

Line 367: l_gme_batch_step_activities (j).activity :=

363: j := l_gme_batch_step_activities.NEXT (j);
364: END IF;
365:
366: l_gme_batch_step_activities (j).batch_id := l_batch_id;
367: l_gme_batch_step_activities (j).activity :=
368: p_recipe_rout_act_tbl (i).activity;
369: l_gme_batch_step_activities (j).oprn_line_id :=
370: p_recipe_rout_act_tbl (i).oprn_line_id;
371: l_gme_batch_step_activities (j).offset_interval :=

Line 369: l_gme_batch_step_activities (j).oprn_line_id :=

365:
366: l_gme_batch_step_activities (j).batch_id := l_batch_id;
367: l_gme_batch_step_activities (j).activity :=
368: p_recipe_rout_act_tbl (i).activity;
369: l_gme_batch_step_activities (j).oprn_line_id :=
370: p_recipe_rout_act_tbl (i).oprn_line_id;
371: l_gme_batch_step_activities (j).offset_interval :=
372: p_recipe_rout_act_tbl (i).offset_interval;
373: l_gme_batch_step_activities (j).plan_activity_factor :=

Line 371: l_gme_batch_step_activities (j).offset_interval :=

367: l_gme_batch_step_activities (j).activity :=
368: p_recipe_rout_act_tbl (i).activity;
369: l_gme_batch_step_activities (j).oprn_line_id :=
370: p_recipe_rout_act_tbl (i).oprn_line_id;
371: l_gme_batch_step_activities (j).offset_interval :=
372: p_recipe_rout_act_tbl (i).offset_interval;
373: l_gme_batch_step_activities (j).plan_activity_factor :=
374: p_recipe_rout_act_tbl (i).activity_factor;
375: l_gme_batch_step_activities (j).sequence_dependent_ind :=

Line 373: l_gme_batch_step_activities (j).plan_activity_factor :=

369: l_gme_batch_step_activities (j).oprn_line_id :=
370: p_recipe_rout_act_tbl (i).oprn_line_id;
371: l_gme_batch_step_activities (j).offset_interval :=
372: p_recipe_rout_act_tbl (i).offset_interval;
373: l_gme_batch_step_activities (j).plan_activity_factor :=
374: p_recipe_rout_act_tbl (i).activity_factor;
375: l_gme_batch_step_activities (j).sequence_dependent_ind :=
376: p_recipe_rout_act_tbl (i).sequence_dependent_ind;
377: l_gme_batch_step_activities (j).material_ind :=

Line 375: l_gme_batch_step_activities (j).sequence_dependent_ind :=

371: l_gme_batch_step_activities (j).offset_interval :=
372: p_recipe_rout_act_tbl (i).offset_interval;
373: l_gme_batch_step_activities (j).plan_activity_factor :=
374: p_recipe_rout_act_tbl (i).activity_factor;
375: l_gme_batch_step_activities (j).sequence_dependent_ind :=
376: p_recipe_rout_act_tbl (i).sequence_dependent_ind;
377: l_gme_batch_step_activities (j).material_ind :=
378: p_recipe_rout_act_tbl (i).material_ind;
379: l_gme_batch_step_activities (j).delete_mark := 0;

Line 377: l_gme_batch_step_activities (j).material_ind :=

373: l_gme_batch_step_activities (j).plan_activity_factor :=
374: p_recipe_rout_act_tbl (i).activity_factor;
375: l_gme_batch_step_activities (j).sequence_dependent_ind :=
376: p_recipe_rout_act_tbl (i).sequence_dependent_ind;
377: l_gme_batch_step_activities (j).material_ind :=
378: p_recipe_rout_act_tbl (i).material_ind;
379: l_gme_batch_step_activities (j).delete_mark := 0;
380: l_gme_batch_step_activities (j).break_ind :=
381: p_recipe_rout_act_tbl (i).break_ind;

Line 379: l_gme_batch_step_activities (j).delete_mark := 0;

375: l_gme_batch_step_activities (j).sequence_dependent_ind :=
376: p_recipe_rout_act_tbl (i).sequence_dependent_ind;
377: l_gme_batch_step_activities (j).material_ind :=
378: p_recipe_rout_act_tbl (i).material_ind;
379: l_gme_batch_step_activities (j).delete_mark := 0;
380: l_gme_batch_step_activities (j).break_ind :=
381: p_recipe_rout_act_tbl (i).break_ind;
382: l_gme_batch_step_activities (j).max_break :=
383: p_recipe_rout_act_tbl (i).max_break;

Line 380: l_gme_batch_step_activities (j).break_ind :=

376: p_recipe_rout_act_tbl (i).sequence_dependent_ind;
377: l_gme_batch_step_activities (j).material_ind :=
378: p_recipe_rout_act_tbl (i).material_ind;
379: l_gme_batch_step_activities (j).delete_mark := 0;
380: l_gme_batch_step_activities (j).break_ind :=
381: p_recipe_rout_act_tbl (i).break_ind;
382: l_gme_batch_step_activities (j).max_break :=
383: p_recipe_rout_act_tbl (i).max_break;
384:

Line 382: l_gme_batch_step_activities (j).max_break :=

378: p_recipe_rout_act_tbl (i).material_ind;
379: l_gme_batch_step_activities (j).delete_mark := 0;
380: l_gme_batch_step_activities (j).break_ind :=
381: p_recipe_rout_act_tbl (i).break_ind;
382: l_gme_batch_step_activities (j).max_break :=
383: p_recipe_rout_act_tbl (i).max_break;
384:
385: -- Link this activity to the batch step it belongs to...
386: IF (p_recipe_rout_act_tbl (i).routingstep_id IS NOT NULL) THEN

Line 390: INTO l_gme_batch_step_activities (j).batchstep_id

386: IF (p_recipe_rout_act_tbl (i).routingstep_id IS NOT NULL) THEN
387: SELECT batchstep_id
388: ,plan_start_date
389: ,plan_cmplt_date
390: INTO l_gme_batch_step_activities (j).batchstep_id
391: ,l_gme_batch_step_activities (j).plan_start_date
392: ,l_gme_batch_step_activities (j).plan_cmplt_date
393: FROM gme_batch_steps
394: WHERE batch_id = l_batch_id

Line 391: ,l_gme_batch_step_activities (j).plan_start_date

387: SELECT batchstep_id
388: ,plan_start_date
389: ,plan_cmplt_date
390: INTO l_gme_batch_step_activities (j).batchstep_id
391: ,l_gme_batch_step_activities (j).plan_start_date
392: ,l_gme_batch_step_activities (j).plan_cmplt_date
393: FROM gme_batch_steps
394: WHERE batch_id = l_batch_id
395: AND routingstep_id = p_recipe_rout_act_tbl (i).routingstep_id;

Line 392: ,l_gme_batch_step_activities (j).plan_cmplt_date

388: ,plan_start_date
389: ,plan_cmplt_date
390: INTO l_gme_batch_step_activities (j).batchstep_id
391: ,l_gme_batch_step_activities (j).plan_start_date
392: ,l_gme_batch_step_activities (j).plan_cmplt_date
393: FROM gme_batch_steps
394: WHERE batch_id = l_batch_id
395: AND routingstep_id = p_recipe_rout_act_tbl (i).routingstep_id;
396: ELSE

Line 400: INTO l_gme_batch_step_activities (j).batchstep_id

396: ELSE
397: SELECT batchstep_id
398: ,plan_start_date
399: ,plan_cmplt_date
400: INTO l_gme_batch_step_activities (j).batchstep_id
401: ,l_gme_batch_step_activities (j).plan_start_date
402: ,l_gme_batch_step_activities (j).plan_cmplt_date
403: FROM gme_batch_steps
404: WHERE batch_id = l_batch_id

Line 401: ,l_gme_batch_step_activities (j).plan_start_date

397: SELECT batchstep_id
398: ,plan_start_date
399: ,plan_cmplt_date
400: INTO l_gme_batch_step_activities (j).batchstep_id
401: ,l_gme_batch_step_activities (j).plan_start_date
402: ,l_gme_batch_step_activities (j).plan_cmplt_date
403: FROM gme_batch_steps
404: WHERE batch_id = l_batch_id
405: AND batchstep_id = l_last_batchstep_id;

Line 402: ,l_gme_batch_step_activities (j).plan_cmplt_date

398: ,plan_start_date
399: ,plan_cmplt_date
400: INTO l_gme_batch_step_activities (j).batchstep_id
401: ,l_gme_batch_step_activities (j).plan_start_date
402: ,l_gme_batch_step_activities (j).plan_cmplt_date
403: FROM gme_batch_steps
404: WHERE batch_id = l_batch_id
405: AND batchstep_id = l_last_batchstep_id;
406: END IF;

Line 415: 'gme_batch_step_activities' || '|' || TO_CHAR (l_batch_id)

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: || '|';
417: l_text_string :=
418: l_text_string
419: || l_gme_batch_step_activities (j).batchstep_id

Line 419: || l_gme_batch_step_activities (j).batchstep_id

415: 'gme_batch_step_activities' || '|' || TO_CHAR (l_batch_id)
416: || '|';
417: l_text_string :=
418: l_text_string
419: || l_gme_batch_step_activities (j).batchstep_id
420: || '|';
421: l_text_string :=
422: l_text_string || p_recipe_rout_act_tbl (i).activity;
423:

Line 439: l_gme_batch_step_activities (j).text_code := l_gme_text_code;

435:
436: IF (l_return_status <> x_return_status) THEN
437: RAISE error_create_text;
438: ELSE
439: l_gme_batch_step_activities (j).text_code := l_gme_text_code;
440: END IF;
441: END IF;
442:
443: --FPBug#4395561 Start

Line 444: /* call create flex procedure to insert the default values of the GME_BATCH_STEP_ACTIVITIES_FLEX

440: END IF;
441: END IF;
442:
443: --FPBug#4395561 Start
444: /* call create flex procedure to insert the default values of the GME_BATCH_STEP_ACTIVITIES_FLEX
445: DFF's segments if they are enabled */
446: l_return_status:=NULL;
447: gme_validate_flex_fld_pvt.create_flex_step_activities (
448: l_gme_batch_step_activities (j),

Line 448: l_gme_batch_step_activities (j),

444: /* call create flex procedure to insert the default values of the GME_BATCH_STEP_ACTIVITIES_FLEX
445: DFF's segments if they are enabled */
446: l_return_status:=NULL;
447: gme_validate_flex_fld_pvt.create_flex_step_activities (
448: l_gme_batch_step_activities (j),
449: l_gme_batch_step_activities (j),
450: l_return_status);
451: IF l_return_status <> FND_API.g_ret_sts_success THEN
452: RAISE create_flex_failure;

Line 449: l_gme_batch_step_activities (j),

445: DFF's segments if they are enabled */
446: l_return_status:=NULL;
447: gme_validate_flex_fld_pvt.create_flex_step_activities (
448: l_gme_batch_step_activities (j),
449: l_gme_batch_step_activities (j),
450: l_return_status);
451: IF l_return_status <> FND_API.g_ret_sts_success THEN
452: RAISE create_flex_failure;
453: END IF;

Line 456: IF (gme_batch_step_activities_dbl.insert_row

452: RAISE create_flex_failure;
453: END IF;
454: --FPBug#4395561 End
455:
456: IF (gme_batch_step_activities_dbl.insert_row
457: (p_batch_step_activities => l_gme_batch_step_activities
458: (j)
459: ,x_batch_step_activities => l_gme_batch_step_activities
460: (j) ) ) THEN

Line 457: (p_batch_step_activities => l_gme_batch_step_activities

453: END IF;
454: --FPBug#4395561 End
455:
456: IF (gme_batch_step_activities_dbl.insert_row
457: (p_batch_step_activities => l_gme_batch_step_activities
458: (j)
459: ,x_batch_step_activities => l_gme_batch_step_activities
460: (j) ) ) THEN
461: NULL;

Line 459: ,x_batch_step_activities => l_gme_batch_step_activities

455:
456: IF (gme_batch_step_activities_dbl.insert_row
457: (p_batch_step_activities => l_gme_batch_step_activities
458: (j)
459: ,x_batch_step_activities => l_gme_batch_step_activities
460: (j) ) ) THEN
461: NULL;
462: ELSE
463: RAISE error_insert_b_step_act;

Line 470: gme_debug.put_line ('Completed GME_BATCH_STEP_ACTIVITIES');

466: i := p_recipe_rout_act_tbl.NEXT (i);
467: END LOOP; /* WHILE i IS NOT NULL; STEP ACTIVITIES */
468:
469: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
470: gme_debug.put_line ('Completed GME_BATCH_STEP_ACTIVITIES');
471: -- Create data for GME_BATCH_STEP_RESOURCES and GME_RESOURCE_TXNS...
472: gme_debug.put_line ('GME_BATCH_STEP_RESOURCES');
473: END IF;
474:

Line 587: -- batchstep_id and then oprn_line_id, you will get a unique row from gme_batch_step_activities...

583:
584: -- Link this resource to the activity it belongs to...
585: -- Note: To go from resources upto activity, you key on batch_id, batchstep_id and
586: -- oprn_line_id -> because oprn can be repeated many times in different steps so, if you have
587: -- batchstep_id and then oprn_line_id, you will get a unique row from gme_batch_step_activities...
588: SELECT batchstep_activity_id
589: INTO l_gme_batch_step_resources (j).batchstep_activity_id
590: FROM gme_batch_step_activities
591: WHERE batch_id = l_batch_id

Line 590: FROM gme_batch_step_activities

586: -- oprn_line_id -> because oprn can be repeated many times in different steps so, if you have
587: -- batchstep_id and then oprn_line_id, you will get a unique row from gme_batch_step_activities...
588: SELECT batchstep_activity_id
589: INTO l_gme_batch_step_resources (j).batchstep_activity_id
590: FROM gme_batch_step_activities
591: WHERE batch_id = l_batch_id
592: AND batchstep_id = l_gme_batch_step_resources (j).batchstep_id
593: AND oprn_line_id = p_recipe_rout_resc_tbl (i).oprn_line_id;
594:

Line 699: FROM gme_batch_step_activities

695:
696: -- Link this process parameters to the activity it belongs to...
697: SELECT batchstep_activity_id
698: INTO l_gme_rsrc_parameters (m).batchstep_activity_id
699: FROM gme_batch_step_activities
700: WHERE batch_id = l_batch_id
701: AND batchstep_id = l_gme_rsrc_parameters (m).batchstep_id
702: AND oprn_line_id = p_resc_parameters_tbl (m).oprn_line_id;
703:

Line 1947: x_act_row gme_batch_step_activities%ROWTYPE;

1943: x_cur_row PLS_INTEGER;
1944: x_step_tbl step_tab;
1945: l_step_duration_tab step_duration_tab;
1946: x_act_tab activities_tab;
1947: x_act_row gme_batch_step_activities%ROWTYPE;
1948: x_rsrc_tab resources_tab;
1949: x_rsrc_row gme_batch_step_resources%ROWTYPE;
1950: x_rsrc_txns_tab rsrc_txns_tab;
1951: x_step_row gme_batch_steps%ROWTYPE;

Line 1976: FROM gme_batch_step_activities

1972:
1973: CURSOR cur_get_step_activities (v_step_id NUMBER, v_batch_id NUMBER)
1974: IS
1975: SELECT *
1976: FROM gme_batch_step_activities
1977: WHERE batch_id = v_batch_id AND batchstep_id = v_step_id;
1978:
1979: CURSOR cur_get_act_rsrcs (v_batchstep_activity_id NUMBER)
1980: IS

Line 2000: FROM gme_batch_step_activities

1996:
1997: CURSOR cur_get_activity (v_batchstep_activity_id NUMBER)
1998: IS
1999: SELECT activity
2000: FROM gme_batch_step_activities
2001: WHERE batchstep_activity_id = v_batchstep_activity_id;
2002:
2003: CURSOR cur_recipe_validity_rule (
2004: p_recipe_validity_rule_id gme_batch_header.recipe_validity_rule_id%TYPE)

Line 2549: UPDATE gme_batch_step_activities

2545: ,'DD-MON-YYYY HH24:MI:SS') );
2546: END IF;
2547:
2548: FOR k IN x_act_tab.FIRST .. x_act_tab.LAST LOOP
2549: UPDATE gme_batch_step_activities
2550: SET plan_start_date = x_act_tab (k).plan_start_date
2551: ,plan_cmplt_date = x_act_tab (k).plan_cmplt_date
2552: WHERE batchstep_activity_id = x_act_tab (k).batchstep_activity_id;
2553: END LOOP;

Line 3185: FROM gme_batch_step_activities

3181: CURSOR cur_get_activity (v_step_id NUMBER, v_batch_id NUMBER)
3182: IS
3183: SELECT batchstep_activity_id, offset_interval, batchstep_id
3184: ,batch_id
3185: FROM gme_batch_step_activities
3186: WHERE batchstep_id = v_step_id AND batch_id = v_batch_id;
3187:
3188: CURSOR cur_get_resource (
3189: v_step_id NUMBER