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.

[Home] [Help]

APPS.GME_BATCHSTEP_RSRC_PVT dependencies on GME_BATCH_HEADER

Line 66: FROM gme_batch_header bh, mtl_parameters mp

62: v_organization_code VARCHAR2
63: ,v_batch_no VARCHAR2)
64: IS
65: SELECT bh.organization_id, bh.batch_id, bh.batch_type
66: FROM gme_batch_header bh, mtl_parameters mp
67: WHERE mp.organization_code = v_organization_code
68: AND mp.organization_id = bh.organization_id
69: AND bh.batch_no = v_batch_no
70: AND batch_type = 0;

Line 359: FROM gme_batch_header

355:
356: CURSOR cur_get_batch_asqc (v_batch_id NUMBER)
357: IS
358: SELECT automatic_step_calculation
359: FROM gme_batch_header
360: WHERE batch_id = v_batch_id;
361:
362: CURSOR cur_get_cost_cmpnt (v_cost_cmpntcls_id NUMBER)
363: IS

Line 1606: l_batch_header gme_batch_header%ROWTYPE;

1602: IS
1603: l_api_name CONSTANT VARCHAR2 (30) := 'insert_batchstep_rsrc';
1604: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
1605: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;
1606: l_batch_header gme_batch_header%ROWTYPE;
1607: l_batch_header_out gme_batch_header%ROWTYPE;
1608: l_return_status VARCHAR2 (2);
1609: l_rsrc_trans_count NUMBER;
1610: l_capacity_constraint NUMBER;

Line 1607: l_batch_header_out gme_batch_header%ROWTYPE;

1603: l_api_name CONSTANT VARCHAR2 (30) := 'insert_batchstep_rsrc';
1604: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
1605: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;
1606: l_batch_header gme_batch_header%ROWTYPE;
1607: l_batch_header_out gme_batch_header%ROWTYPE;
1608: l_return_status VARCHAR2 (2);
1609: l_rsrc_trans_count NUMBER;
1610: l_capacity_constraint NUMBER;
1611: l_max_step_capacity NUMBER;

Line 1649: IF NOT gme_batch_header_dbl.fetch_row

1645: -- since we are inserting a new resource rsrc txn temp table would not have any data in it
1646: -- after inserting the resource we would have corresponding txn inserted
1647: l_batch_header.batch_id := l_batchstep_resource_rec.batch_id;
1648:
1649: IF NOT gme_batch_header_dbl.fetch_row
1650: (p_batch_header => l_batch_header
1651: ,x_batch_header => l_batch_header_out) THEN
1652: RAISE error_condition;
1653: END IF;

Line 1777: l_batch_header gme_batch_header%ROWTYPE;

1773: l_count_int NUMBER (10);
1774: l_flex_validate BOOLEAN := FALSE;
1775: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
1776: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;
1777: l_batch_header gme_batch_header%ROWTYPE;
1778:
1779: /* CURSOR DECLARATIONS
1780: ====================== */
1781: CURSOR cur_get_step_dtl (v_resource_id NUMBER)

Line 1810: FROM gme_batch_header a, gme_batch_step_resources b

1806:
1807: CURSOR cur_validate_batch_type (v_rsrc_id NUMBER)
1808: IS
1809: SELECT 1
1810: FROM gme_batch_header a, gme_batch_step_resources b
1811: WHERE a.batch_id = b.batch_id
1812: AND b.batchstep_resource_id = v_rsrc_id
1813: AND a.batch_type = 10;
1814:

Line 1877: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header

1873:
1874: -- load temp table so that save_batch routine does resource txn consolidation
1875: l_batch_header.batch_id := p_batchstep_resource_rec.batch_id;
1876:
1877: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
1878: ,x_batch_header => l_batch_header) THEN
1879: RAISE error_condition;
1880: END IF;
1881:

Line 1992: l_batch_header gme_batch_header%ROWTYPE;

1988: ,x_return_status OUT NOCOPY VARCHAR2)
1989: IS
1990: l_api_name CONSTANT VARCHAR2 (30) := 'delete_batchstep_rsrc';
1991: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
1992: l_batch_header gme_batch_header%ROWTYPE;
1993: l_return_status VARCHAR2 (2);
1994: l_rsrc_trans_count NUMBER;
1995: error_deleting_rsrc EXCEPTION;
1996: error_condition EXCEPTION;

Line 2008: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header

2004: x_return_status := fnd_api.g_ret_sts_success;
2005: -- load temp table so that save_batch routine does resource txn consolidation
2006: l_batch_header.batch_id := p_batchstep_resource_rec.batch_id;
2007:
2008: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
2009: ,x_batch_header => l_batch_header) THEN
2010: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
2011: RAISE error_condition;
2012: END IF;