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_HEADER

Line 35: l_batch_header gme_batch_header%ROWTYPE;

31: ,p_material_step_id IN NUMBER DEFAULT NULL)
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;

Line 50: v_batch_id gme_batch_header.batch_id%TYPE

46: l_return_status VARCHAR2 (1);
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

Line 100: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN

96:
97: l_batch_header.batch_id := x_batch_step_rec.batch_id;
98:
99: /* Initialize local batch header */
100: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN
101: RAISE batch_header_fetch_error;
102: END IF;
103: /* Load resource transactions in temp table */
104: gme_trans_engine_util.load_rsrc_trans

Line 461: p_batch_hdr_rec IN gme_batch_header%ROWTYPE

457: G. Muratore 19-MAR-2010 Bug 10051993
458: Pass in the new step qty to calc_char so that charges are calculated properly.
459: =============================================================================================*/
460: PROCEDURE calculate_quantities (
461: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
462: ,p_batch_step_rec IN OUT NOCOPY gme_batch_steps%ROWTYPE
463: ,x_return_status OUT NOCOPY VARCHAR2
464: ,p_routing_scale_factor IN NUMBER DEFAULT NULL
465: ,p_backflush_factor IN NUMBER DEFAULT NULL

Line 998: p_batch_hdr_rec IN gme_batch_header%ROWTYPE

994: E - Error
995: U - Unexpected error
996: =============================================================================================*/
997: PROCEDURE update_activities (
998: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
999: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1000: ,x_return_status OUT NOCOPY VARCHAR2
1001: ,p_routing_scale_factor IN NUMBER DEFAULT NULL
1002: ,p_backflush_factor IN NUMBER DEFAULT NULL

Line 1168: p_batch_hdr_rec IN gme_batch_header%ROWTYPE

1164: U - Unexpected error
1165: History
1166: =============================================================================================*/
1167: PROCEDURE update_resources (
1168: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1169: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1170: ,p_batchstep_activities_rec IN gme_batch_step_activities%ROWTYPE
1171: ,x_return_status OUT NOCOPY VARCHAR2
1172: ,p_routing_scale_factor IN NUMBER DEFAULT NULL

Line 1880: p_batch_hdr_rec IN gme_batch_header%ROWTYPE

1876: G. Muratore 19-MAR-2010 Bug 8751983
1877: Stamp resource transaction with the trans_date if new p_trans_date parameter passed in.
1878: =============================================================================================*/
1879: PROCEDURE build_insert_resource_txn (
1880: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1881: ,p_batchstep_resource IN gme_batch_step_resources%ROWTYPE
1882: ,p_usage IN NUMBER
1883: ,p_completed IN NUMBER DEFAULT 1
1884: ,p_trans_date IN DATE DEFAULT NULL

Line 2061: l_batch_hdr gme_batch_header%ROWTYPE;

2057: WHERE line_id = v_batchstep_resource_id AND completed_ind = 0;
2058:
2059: l_api_name CONSTANT VARCHAR2 (30) := 'adjust_pending_usage';
2060: /* Collections for details etc */
2061: l_batch_hdr gme_batch_header%ROWTYPE;
2062: /* Local variables */
2063: l_alloc_usage NUMBER;
2064: l_tot_usage NUMBER;
2065: l_tran_count NUMBER;

Line 2120: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_hdr

2116: END IF;
2117:
2118: l_batch_hdr.batch_id := p_batch_step_resources_rec.batch_id;
2119:
2120: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_hdr
2121: ,x_batch_header => l_batch_hdr) THEN
2122: RAISE fnd_api.g_exc_error;
2123: END IF;
2124:

Line 2222: l_batch_hdr gme_batch_header%ROWTYPE;

2218:
2219: /* Collections for details etc */
2220: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
2221: l_resource_tab gme_common_pvt.resource_transactions_tab;
2222: l_batch_hdr gme_batch_header%ROWTYPE;
2223: /* Local variables */
2224: l_sum_comp_usage NUMBER;
2225: l_cnt_comp_usage NUMBER;
2226: l_override_usage NUMBER DEFAULT 0;

Line 2316: IF NOT gme_batch_header_dbl.fetch_row

2312: /* Step 2 : */
2313: IF l_sum_comp_usage <> p_batch_step_resources_rec.actual_rsrc_usage THEN
2314: l_batch_hdr.batch_id := p_batch_step_resources_rec.batch_id;
2315:
2316: IF NOT gme_batch_header_dbl.fetch_row
2317: (p_batch_header => l_batch_hdr
2318: ,x_batch_header => l_batch_hdr) THEN
2319: RAISE fnd_api.g_exc_error;
2320: END IF;

Line 2782: l_batch_header_rec gme_batch_header%ROWTYPE;

2778: WHERE batchstep_id = v_step_id;
2779:
2780: l_step_rec c_get_step_qty%ROWTYPE;
2781: l_resource gme_batch_step_resources.resources%TYPE;
2782: l_batch_header_rec gme_batch_header%ROWTYPE;
2783: l_in_step_qty NUMBER;
2784: l_step_qty NUMBER;
2785: l_charge NUMBER;
2786: l_mass_qty NUMBER;