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_UPDATE_STEP_QTY_PVT dependencies on GME_BATCH_STEPS

Line 23: p_batch_step_rec IN gme_batch_steps%ROWTYPE

19: E - Error
20: U - Unexpected error
21: =============================================================================================*/
22: PROCEDURE update_step_qty (
23: p_batch_step_rec IN gme_batch_steps%ROWTYPE
24: ,x_message_count OUT NOCOPY NUMBER
25: ,x_message_list OUT NOCOPY VARCHAR2
26: ,x_return_status OUT NOCOPY VARCHAR2
27: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

Line 27: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

23: p_batch_step_rec IN gme_batch_steps%ROWTYPE
24: ,x_message_count OUT NOCOPY NUMBER
25: ,x_message_list OUT NOCOPY VARCHAR2
26: ,x_return_status OUT NOCOPY VARCHAR2
27: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
28: ,p_routing_scale_factor IN NUMBER DEFAULT NULL
29: ,p_backflush_factor IN NUMBER DEFAULT NULL
30: ,p_dependency_type IN NUMBER DEFAULT NULL
31: ,p_material_step_id IN NUMBER DEFAULT NULL)

Line 36: l_batch_step gme_batch_steps%ROWTYPE;

32: IS
33: l_api_name CONSTANT VARCHAR2 (30) := 'update_step_qty';
34: /* Buffers for database reads/writes */
35: l_batch_header gme_batch_header%ROWTYPE;
36: l_batch_step gme_batch_steps%ROWTYPE;
37: l_step_tbl gmd_auto_step_calc.step_rec_tbl;
38: /* Exception definitions */
39: batch_step_fetch_error EXCEPTION;
40: invalid_step_status EXCEPTION;

Line 51: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)

47: l_rec NUMBER;
48:
49: CURSOR dependent_steps (
50: v_batch_id gme_batch_header.batch_id%TYPE
51: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)
52: IS
53: SELECT d.batchstep_id
54: FROM gme_batch_step_dependencies d
55: WHERE d.batch_id = v_batch_id

Line 87: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

83: || l_api_name||'p_dependency_type ' || p_dependency_type);
84: END IF;
85:
86: /* Initialize output batch step row */
87: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
88: ,x_batch_step_rec) ) THEN
89: RAISE batch_step_fetch_error;
90: END IF;
91:

Line 252: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step

248: l_batch_step.batchstep_id := dep_steps.batchstep_id;
249: --Bug#5606089 Filtering out the null row.
250: IF l_batch_step.batchstep_id IS NOT NULL THEN
251: /* Initialize output batch step row */
252: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step
253: ,l_batch_step) ) THEN
254: RAISE batch_step_fetch_error;
255: END IF;
256:

Line 368: p_batch_step_rec IN OUT NOCOPY gme_batch_steps%ROWTYPE)

364: Parameters
365: p_batch_step_rec The batch step row to identify the step.
366: =============================================================================================*/
367: PROCEDURE calculate_mass_vol_qty (
368: p_batch_step_rec IN OUT NOCOPY gme_batch_steps%ROWTYPE)
369: IS
370: /* Cursor definition */
371: CURSOR cur_get_uom
372: IS

Line 448: ,p_batch_step_rec IN OUT NOCOPY gme_batch_steps%ROWTYPE

444: U - Unexpected error
445: =============================================================================================*/
446: PROCEDURE calculate_quantities (
447: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
448: ,p_batch_step_rec IN OUT NOCOPY gme_batch_steps%ROWTYPE
449: ,x_return_status OUT NOCOPY VARCHAR2
450: ,p_routing_scale_factor IN NUMBER DEFAULT NULL
451: ,p_backflush_factor IN NUMBER DEFAULT NULL
452: ,p_dependency_type IN NUMBER DEFAULT NULL)

Line 520: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step_rec) ) THEN

516: RAISE compute_resource_error;
517: END IF;
518:
519: /* Now update the batch step to the database */
520: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step_rec) ) THEN
521: RAISE batch_step_upd_err;
522: END IF;
523:
524: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

Line 524: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

520: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step_rec) ) THEN
521: RAISE batch_step_upd_err;
522: END IF;
523:
524: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
525: ,p_batch_step_rec) ) THEN
526: RAISE batch_step_fetch_err;
527: END IF;
528:

Line 568: p_step_id IN gme_batch_steps.batchstep_id%TYPE

564: U - Unexpected error
565: Hisory
566: =============================================================================================*/
567: PROCEDURE calc_charge (
568: p_step_id IN gme_batch_steps.batchstep_id%TYPE
569: ,p_resources IN gme_batch_step_resources.resources%TYPE
570: DEFAULT NULL
571: ,p_mass_qty IN gme_batch_steps.plan_mass_qty%TYPE
572: ,p_vol_qty IN gme_batch_steps.plan_volume_qty%TYPE

Line 571: ,p_mass_qty IN gme_batch_steps.plan_mass_qty%TYPE

567: PROCEDURE calc_charge (
568: p_step_id IN gme_batch_steps.batchstep_id%TYPE
569: ,p_resources IN gme_batch_step_resources.resources%TYPE
570: DEFAULT NULL
571: ,p_mass_qty IN gme_batch_steps.plan_mass_qty%TYPE
572: ,p_vol_qty IN gme_batch_steps.plan_volume_qty%TYPE
573: ,p_step_qty IN NUMBER DEFAULT NULL --Bug#5231180
574: ,p_max_capacity IN NUMBER DEFAULT NULL --Bug#5231180
575: ,x_charge OUT NOCOPY gme_batch_steps.plan_charges%TYPE

Line 572: ,p_vol_qty IN gme_batch_steps.plan_volume_qty%TYPE

568: p_step_id IN gme_batch_steps.batchstep_id%TYPE
569: ,p_resources IN gme_batch_step_resources.resources%TYPE
570: DEFAULT NULL
571: ,p_mass_qty IN gme_batch_steps.plan_mass_qty%TYPE
572: ,p_vol_qty IN gme_batch_steps.plan_volume_qty%TYPE
573: ,p_step_qty IN NUMBER DEFAULT NULL --Bug#5231180
574: ,p_max_capacity IN NUMBER DEFAULT NULL --Bug#5231180
575: ,x_charge OUT NOCOPY gme_batch_steps.plan_charges%TYPE
576: ,x_return_status OUT NOCOPY VARCHAR2)

Line 575: ,x_charge OUT NOCOPY gme_batch_steps.plan_charges%TYPE

571: ,p_mass_qty IN gme_batch_steps.plan_mass_qty%TYPE
572: ,p_vol_qty IN gme_batch_steps.plan_volume_qty%TYPE
573: ,p_step_qty IN NUMBER DEFAULT NULL --Bug#5231180
574: ,p_max_capacity IN NUMBER DEFAULT NULL --Bug#5231180
575: ,x_charge OUT NOCOPY gme_batch_steps.plan_charges%TYPE
576: ,x_return_status OUT NOCOPY VARCHAR2)
577: IS
578: x_step_no gme_batch_steps.batchstep_no%TYPE;
579: x_std_factor NUMBER;

Line 578: x_step_no gme_batch_steps.batchstep_no%TYPE;

574: ,p_max_capacity IN NUMBER DEFAULT NULL --Bug#5231180
575: ,x_charge OUT NOCOPY gme_batch_steps.plan_charges%TYPE
576: ,x_return_status OUT NOCOPY VARCHAR2)
577: IS
578: x_step_no gme_batch_steps.batchstep_no%TYPE;
579: x_std_factor NUMBER;
580: x_um_type mtl_units_of_measure.uom_class%TYPE;
581: x_std_capacity gme_batch_steps.max_step_capacity%TYPE;
582: x_max_cap gme_batch_steps.max_step_capacity%TYPE;

Line 581: x_std_capacity gme_batch_steps.max_step_capacity%TYPE;

577: IS
578: x_step_no gme_batch_steps.batchstep_no%TYPE;
579: x_std_factor NUMBER;
580: x_um_type mtl_units_of_measure.uom_class%TYPE;
581: x_std_capacity gme_batch_steps.max_step_capacity%TYPE;
582: x_max_cap gme_batch_steps.max_step_capacity%TYPE;
583: x_max_cap_uom gme_batch_steps.max_step_capacity_um%TYPE;
584: x_step_qty gme_batch_steps.plan_step_qty%TYPE;
585: x_step_qty_uom gme_batch_steps.step_qty_um%TYPE;

Line 582: x_max_cap gme_batch_steps.max_step_capacity%TYPE;

578: x_step_no gme_batch_steps.batchstep_no%TYPE;
579: x_std_factor NUMBER;
580: x_um_type mtl_units_of_measure.uom_class%TYPE;
581: x_std_capacity gme_batch_steps.max_step_capacity%TYPE;
582: x_max_cap gme_batch_steps.max_step_capacity%TYPE;
583: x_max_cap_uom gme_batch_steps.max_step_capacity_um%TYPE;
584: x_step_qty gme_batch_steps.plan_step_qty%TYPE;
585: x_step_qty_uom gme_batch_steps.step_qty_um%TYPE;
586: x_temp_qty NUMBER;

Line 583: x_max_cap_uom gme_batch_steps.max_step_capacity_um%TYPE;

579: x_std_factor NUMBER;
580: x_um_type mtl_units_of_measure.uom_class%TYPE;
581: x_std_capacity gme_batch_steps.max_step_capacity%TYPE;
582: x_max_cap gme_batch_steps.max_step_capacity%TYPE;
583: x_max_cap_uom gme_batch_steps.max_step_capacity_um%TYPE;
584: x_step_qty gme_batch_steps.plan_step_qty%TYPE;
585: x_step_qty_uom gme_batch_steps.step_qty_um%TYPE;
586: x_temp_qty NUMBER;
587: x_tolerance NUMBER;

Line 584: x_step_qty gme_batch_steps.plan_step_qty%TYPE;

580: x_um_type mtl_units_of_measure.uom_class%TYPE;
581: x_std_capacity gme_batch_steps.max_step_capacity%TYPE;
582: x_max_cap gme_batch_steps.max_step_capacity%TYPE;
583: x_max_cap_uom gme_batch_steps.max_step_capacity_um%TYPE;
584: x_step_qty gme_batch_steps.plan_step_qty%TYPE;
585: x_step_qty_uom gme_batch_steps.step_qty_um%TYPE;
586: x_temp_qty NUMBER;
587: x_tolerance NUMBER;
588: x_stdum_tolerance NUMBER;

Line 585: x_step_qty_uom gme_batch_steps.step_qty_um%TYPE;

581: x_std_capacity gme_batch_steps.max_step_capacity%TYPE;
582: x_max_cap gme_batch_steps.max_step_capacity%TYPE;
583: x_max_cap_uom gme_batch_steps.max_step_capacity_um%TYPE;
584: x_step_qty gme_batch_steps.plan_step_qty%TYPE;
585: x_step_qty_uom gme_batch_steps.step_qty_um%TYPE;
586: x_temp_qty NUMBER;
587: x_tolerance NUMBER;
588: x_stdum_tolerance NUMBER;
589: pmass_qty_std NUMBER;

Line 597: FROM gme_batch_steps

593: CURSOR cur_get_max_capacity
594: IS
595: SELECT max_step_capacity, max_step_capacity_um, batchstep_no
596: ,plan_step_qty, step_qty_um
597: FROM gme_batch_steps
598: WHERE batchstep_id = p_step_id;
599:
600: CURSOR cur_get_std_factor (v_um_code VARCHAR2)
601: IS

Line 609: FROM gme_batch_steps gbs, gme_batch_step_resources gbsr

605:
606: CURSOR cur_get_tolerance
607: IS
608: SELECT NVL (MIN (gbsr.capacity_tolerance), 0)
609: FROM gme_batch_steps gbs, gme_batch_step_resources gbsr
610: WHERE gbs.batchstep_id = gbsr.batchstep_id
611: AND gbsr.calculate_charges = 1
612: AND gbsr.batchstep_id = p_step_id;
613:

Line 625: FROM gme_batch_steps

621:
622: CURSOR cur_get_batch_id (v_batchstep_id NUMBER)
623: IS
624: SELECT batch_id
625: FROM gme_batch_steps
626: WHERE batchstep_id = v_batchstep_id;
627:
628: CURSOR cur_get_scale_type (
629: v_resources gme_batch_step_resources.resources%TYPE)

Line 644: l_charge gme_batch_steps.plan_charges%TYPE;

640: l_scale_type gme_batch_step_resources.scale_type%TYPE;
641: l_remaining_quantity NUMBER;
642: l_batch_step_charges_in gme_batch_step_charges%ROWTYPE;
643: l_return_status VARCHAR2 (1);
644: l_charge gme_batch_steps.plan_charges%TYPE;
645: l_batch_id NUMBER;
646: l_rsrc_plan_start_date DATE;
647: l_rsrc_plan_cmplt_date DATE;
648: error_charge_insert EXCEPTION;

Line 900: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

896: U - Unexpected error
897: =============================================================================================*/
898: PROCEDURE update_activities (
899: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
900: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
901: ,x_return_status OUT NOCOPY VARCHAR2
902: ,p_routing_scale_factor IN NUMBER DEFAULT NULL
903: ,p_backflush_factor IN NUMBER DEFAULT NULL
904: ,p_charge_diff IN NUMBER

Line 1070: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

1066: History
1067: =============================================================================================*/
1068: PROCEDURE update_resources (
1069: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1070: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1071: ,p_batchstep_activities_rec IN gme_batch_step_activities%ROWTYPE
1072: ,x_return_status OUT NOCOPY VARCHAR2
1073: ,p_routing_scale_factor IN NUMBER DEFAULT NULL
1074: ,p_backflush_factor IN NUMBER DEFAULT NULL

Line 1131: FROM gme_batch_steps

1127:
1128: CURSOR cur_prev_plan_charge
1129: IS
1130: SELECT plan_charges
1131: FROM gme_batch_steps
1132: WHERE batchstep_id = p_batch_step_rec.batchstep_id;
1133:
1134: /* Exceptions */
1135: activity_resource_fetch_error EXCEPTION;

Line 2309: FROM gme_batch_steps

2305:
2306: CURSOR cur_get_step_status (v_batchstep_id NUMBER)
2307: IS
2308: SELECT step_status
2309: FROM gme_batch_steps
2310: WHERE batchstep_id = v_batchstep_id;
2311:
2312: --nsinghi bug#5609683 Modified the cursor to also query resource plan start date and changed cursor name
2313: CURSOR cur_get_rsrc_dtl (v_batchstep_resource_id NUMBER)

Line 2532: PROCEDURE recalculate_charges( p_batchstep_rec IN gme_batch_steps%ROWTYPE

2528: HISTORY
2529: SivakumarG Bug#5231180
2530: Procedure Created
2531: =============================================================================================*/
2532: PROCEDURE recalculate_charges( p_batchstep_rec IN gme_batch_steps%ROWTYPE
2533: ,p_cal_type IN VARCHAR2
2534: ,x_batchstep_rec OUT NOCOPY gme_batch_steps%ROWTYPE
2535: ,x_return_status OUT NOCOPY VARCHAR2 )
2536: IS

Line 2534: ,x_batchstep_rec OUT NOCOPY gme_batch_steps%ROWTYPE

2530: Procedure Created
2531: =============================================================================================*/
2532: PROCEDURE recalculate_charges( p_batchstep_rec IN gme_batch_steps%ROWTYPE
2533: ,p_cal_type IN VARCHAR2
2534: ,x_batchstep_rec OUT NOCOPY gme_batch_steps%ROWTYPE
2535: ,x_return_status OUT NOCOPY VARCHAR2 )
2536: IS
2537: l_api_name VARCHAR2(30) := 'RECALCULATE_CHARGES';
2538:

Line 2542: FROM gme_batch_steps

2538:
2539: CURSOR c_get_step_qty(v_step_id NUMBER) IS
2540: SELECT batchstep_id, step_status, plan_step_qty, actual_step_qty,
2541: max_step_capacity, max_step_capacity_um, step_qty_um
2542: FROM gme_batch_steps
2543: WHERE batchstep_id = v_step_id;
2544:
2545: CURSOR c_get_step_resources(v_step_id NUMBER) IS
2546: SELECT resources

Line 2716: IF NOT gme_batch_steps_dbl.update_row(p_batch_step => x_batchstep_rec) THEN

2712: x_batchstep_rec.plan_charges := l_charge;
2713: END IF;
2714: END IF; /*l_calc_step_qty */
2715: /* update the batch step record */
2716: IF NOT gme_batch_steps_dbl.update_row(p_batch_step => x_batchstep_rec) THEN
2717: RAISE error_in_update_step;
2718: END IF;
2719:
2720: IF g_debug <= gme_debug.g_log_procedure THEN