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 447: p_batch_hdr_rec IN gme_batch_header%ROWTYPE

443: E - Error
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

Line 899: p_batch_hdr_rec IN gme_batch_header%ROWTYPE

895: E - Error
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

Line 1069: p_batch_hdr_rec IN gme_batch_header%ROWTYPE

1065: U - Unexpected error
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

Line 1778: p_batch_hdr_rec IN gme_batch_header%ROWTYPE

1774: E - Error
1775: U - Unexpected error
1776: =============================================================================================*/
1777: PROCEDURE build_insert_resource_txn (
1778: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1779: ,p_batchstep_resource IN gme_batch_step_resources%ROWTYPE
1780: ,p_usage IN NUMBER
1781: ,p_completed IN NUMBER DEFAULT 1
1782: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1951: l_batch_hdr gme_batch_header%ROWTYPE;

1947: WHERE line_id = v_batchstep_resource_id AND completed_ind = 0;
1948:
1949: l_api_name CONSTANT VARCHAR2 (30) := 'adjust_pending_usage';
1950: /* Collections for details etc */
1951: l_batch_hdr gme_batch_header%ROWTYPE;
1952: /* Local variables */
1953: l_alloc_usage NUMBER;
1954: l_tot_usage NUMBER;
1955: l_tran_count NUMBER;

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

2006: END IF;
2007:
2008: l_batch_hdr.batch_id := p_batch_step_resources_rec.batch_id;
2009:
2010: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_hdr
2011: ,x_batch_header => l_batch_hdr) THEN
2012: RAISE fnd_api.g_exc_error;
2013: END IF;
2014:

Line 2106: l_batch_hdr gme_batch_header%ROWTYPE;

2102:
2103: /* Collections for details etc */
2104: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
2105: l_resource_tab gme_common_pvt.resource_transactions_tab;
2106: l_batch_hdr gme_batch_header%ROWTYPE;
2107: /* Local variables */
2108: l_sum_comp_usage NUMBER;
2109: l_cnt_comp_usage NUMBER;
2110: l_override_usage NUMBER DEFAULT 0;

Line 2191: IF NOT gme_batch_header_dbl.fetch_row

2187: /* Step 2 : */
2188: IF l_sum_comp_usage <> p_batch_step_resources_rec.actual_rsrc_usage THEN
2189: l_batch_hdr.batch_id := p_batch_step_resources_rec.batch_id;
2190:
2191: IF NOT gme_batch_header_dbl.fetch_row
2192: (p_batch_header => l_batch_hdr
2193: ,x_batch_header => l_batch_hdr) THEN
2194: RAISE fnd_api.g_exc_error;
2195: END IF;

Line 2552: l_batch_header_rec gme_batch_header%ROWTYPE;

2548: WHERE batchstep_id = v_step_id;
2549:
2550: l_step_rec c_get_step_qty%ROWTYPE;
2551: l_resource gme_batch_step_resources.resources%TYPE;
2552: l_batch_header_rec gme_batch_header%ROWTYPE;
2553: l_in_step_qty NUMBER;
2554: l_step_qty NUMBER;
2555: l_charge NUMBER;
2556: l_mass_qty NUMBER;