APPS.GME_BATCHSTEP_RSRC_PVT dependencies on GME_BATCH_HEADER

Line 74: FROM gme_batch_header bh, mtl_parameters mp

70: v_organization_code VARCHAR2
71: ,v_batch_no VARCHAR2)
72: IS
73: SELECT bh.organization_id, bh.batch_id, bh.batch_type
74: FROM gme_batch_header bh, mtl_parameters mp
75: WHERE mp.organization_code = v_organization_code
76: AND mp.organization_id = bh.organization_id
77: AND bh.batch_no = v_batch_no
78: AND batch_type = 0;

Line 371: FROM gme_batch_header

367:
368: CURSOR cur_get_batch_asqc (v_batch_id NUMBER)
369: IS
370: SELECT automatic_step_calculation
371: FROM gme_batch_header
372: WHERE batch_id = v_batch_id;
373:
374: CURSOR cur_get_cost_cmpnt (v_cost_cmpntcls_id NUMBER)
375: IS

Line 1631: l_batch_header gme_batch_header%ROWTYPE;

1627: IS
1628: l_api_name CONSTANT VARCHAR2 (30) := 'insert_batchstep_rsrc';
1629: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
1630: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;
1631: l_batch_header gme_batch_header%ROWTYPE;
1632: l_batch_header_out gme_batch_header%ROWTYPE;
1633: l_return_status VARCHAR2 (2);
1634: l_rsrc_trans_count NUMBER;
1635: l_capacity_constraint NUMBER;

Line 1632: l_batch_header_out gme_batch_header%ROWTYPE;

1628: l_api_name CONSTANT VARCHAR2 (30) := 'insert_batchstep_rsrc';
1629: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
1630: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;
1631: l_batch_header gme_batch_header%ROWTYPE;
1632: l_batch_header_out gme_batch_header%ROWTYPE;
1633: l_return_status VARCHAR2 (2);
1634: l_rsrc_trans_count NUMBER;
1635: l_capacity_constraint NUMBER;
1636: l_max_step_capacity NUMBER;

Line 1674: IF NOT gme_batch_header_dbl.fetch_row

1670: -- since we are inserting a new resource rsrc txn temp table would not have any data in it
1671: -- after inserting the resource we would have corresponding txn inserted
1672: l_batch_header.batch_id := l_batchstep_resource_rec.batch_id;
1673:
1674: IF NOT gme_batch_header_dbl.fetch_row
1675: (p_batch_header => l_batch_header
1676: ,x_batch_header => l_batch_header_out) THEN
1677: RAISE error_condition;
1678: END IF;

Line 1805: l_batch_header gme_batch_header%ROWTYPE;

1801: l_count_int NUMBER (10);
1802: l_flex_validate BOOLEAN := FALSE;
1803: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
1804: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;
1805: l_batch_header gme_batch_header%ROWTYPE;
1806:
1807: -- Bug 8335046 - Introduced following variable.
1808: l_update_capacity NUMBER;
1809:

Line 1841: FROM gme_batch_header a, gme_batch_step_resources b

1837:
1838: CURSOR cur_validate_batch_type (v_rsrc_id NUMBER)
1839: IS
1840: SELECT 1
1841: FROM gme_batch_header a, gme_batch_step_resources b
1842: WHERE a.batch_id = b.batch_id
1843: AND b.batchstep_resource_id = v_rsrc_id
1844: AND a.batch_type = 10;
1845:

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

1904:
1905: -- load temp table so that save_batch routine does resource txn consolidation
1906: l_batch_header.batch_id := p_batchstep_resource_rec.batch_id;
1907:
1908: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
1909: ,x_batch_header => l_batch_header) THEN
1910: RAISE error_condition;
1911: END IF;
1912:

Line 2027: l_batch_header gme_batch_header%ROWTYPE;

2023: ,x_return_status OUT NOCOPY VARCHAR2)
2024: IS
2025: l_api_name CONSTANT VARCHAR2 (30) := 'delete_batchstep_rsrc';
2026: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
2027: l_batch_header gme_batch_header%ROWTYPE;
2028: l_return_status VARCHAR2 (2);
2029: l_rsrc_trans_count NUMBER;
2030: error_deleting_rsrc EXCEPTION;
2031: error_condition EXCEPTION;

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

2039: x_return_status := fnd_api.g_ret_sts_success;
2040: -- load temp table so that save_batch routine does resource txn consolidation
2041: l_batch_header.batch_id := p_batchstep_resource_rec.batch_id;
2042:
2043: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
2044: ,x_batch_header => l_batch_header) THEN
2045: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
2046: RAISE error_condition;
2047: END IF;