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_BATCHSTEP_RSRC_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 100: FROM gme_batch_step_resources

96:
97: CURSOR cur_fetch_resource_dtl (v_activity_id NUMBER, v_resource VARCHAR2)
98: IS
99: SELECT batchstep_resource_id
100: FROM gme_batch_step_resources
101: WHERE batchstep_activity_id = v_activity_id
102: AND resources = v_resource;
103:
104: batch_not_found EXCEPTION;

Line 315: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

311: G. Muratore 16-MAY-2012 Bug 14037157
312: Initialize variables properly so that UPDATE action works correctly.
313: =============================================================================================*/
314: PROCEDURE validate_rsrc_param (
315: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
316: ,p_activity_id IN NUMBER
317: ,p_ignore_qty_below_cap IN VARCHAR2
318: DEFAULT fnd_api.g_false
319: ,p_validate_flexfield IN VARCHAR2

Line 322: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

318: DEFAULT fnd_api.g_false
319: ,p_validate_flexfield IN VARCHAR2
320: DEFAULT fnd_api.g_false
321: ,p_action IN VARCHAR2
322: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
323: ,x_step_status OUT NOCOPY NUMBER
324: ,x_return_status OUT NOCOPY VARCHAR2)
325: IS
326: l_api_name CONSTANT VARCHAR2 (30) := 'validate_rsrc_param';

Line 341: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

337: l_act_plan_cmplt_date DATE;
338: l_act_actual_start_date DATE;
339: l_act_actual_cmplt_date DATE;
340: l_step_qty_um VARCHAR2 (4);
341: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
342: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
343:
344: CURSOR cur_get_step_dtl_from_act (v_act_id NUMBER)
345: IS

Line 342: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;

338: l_act_actual_start_date DATE;
339: l_act_actual_cmplt_date DATE;
340: l_step_qty_um VARCHAR2 (4);
341: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
342: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
343:
344: CURSOR cur_get_step_dtl_from_act (v_act_id NUMBER)
345: IS
346: SELECT a.step_status, a.batch_id, a.step_qty_um

Line 984: IF NOT (gme_batch_step_resources_dbl.fetch_row

980: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
981: RAISE invalid_step_status;
982: END IF;
983:
984: IF NOT (gme_batch_step_resources_dbl.fetch_row
985: (p_batchstep_resource_rec
986: ,l_batchstep_resource_rec) ) THEN
987: RAISE rsrc_fetch_error;
988: END IF;

Line 1619: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES

1615: insert_batchstep_rsrc
1616: Description
1617: Procedure is used to insert rsrc for an activity
1618: Parameters
1619: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES
1620: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES
1621: x_return_status reflects return status of the API
1622: =============================================================================================*/
1623: PROCEDURE insert_batchstep_rsrc (

Line 1620: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES

1616: Description
1617: Procedure is used to insert rsrc for an activity
1618: Parameters
1619: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES
1620: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES
1621: x_return_status reflects return status of the API
1622: =============================================================================================*/
1623: PROCEDURE insert_batchstep_rsrc (
1624: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

Line 1624: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

1620: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES
1621: x_return_status reflects return status of the API
1622: =============================================================================================*/
1623: PROCEDURE insert_batchstep_rsrc (
1624: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
1625: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1626: ,x_return_status OUT NOCOPY VARCHAR2)
1627: IS
1628: l_api_name CONSTANT VARCHAR2 (30) := 'insert_batchstep_rsrc';

Line 1625: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

1621: x_return_status reflects return status of the API
1622: =============================================================================================*/
1623: PROCEDURE insert_batchstep_rsrc (
1624: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
1625: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1626: ,x_return_status OUT NOCOPY VARCHAR2)
1627: IS
1628: l_api_name CONSTANT VARCHAR2 (30) := 'insert_batchstep_rsrc';
1629: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

Line 1629: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

1625: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1626: ,x_return_status OUT NOCOPY VARCHAR2)
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);

Line 1630: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;

1626: ,x_return_status OUT NOCOPY VARCHAR2)
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;

Line 1769: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES

1765: update_batchstep_rsrc
1766: Description
1767: Procedure to update resource for an activity
1768: Parameters
1769: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES
1770: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES
1771: x_return_status reflects return status of the API
1772: History
1773: Inventory Convergence Project - March 2005

Line 1770: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES

1766: Description
1767: Procedure to update resource for an activity
1768: Parameters
1769: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES
1770: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES
1771: x_return_status reflects return status of the API
1772: History
1773: Inventory Convergence Project - March 2005
1774:

Line 1779: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

1775: G. Muratore 15-APR-2009 Bug 8335046
1776: Update the last_update_date for locking issues at the step level.
1777: =============================================================================================*/
1778: PROCEDURE update_batchstep_rsrc (
1779: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
1780: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1781: ,x_return_status OUT NOCOPY VARCHAR2)
1782: IS
1783: l_api_name CONSTANT VARCHAR2 (30) := 'update_batchstep_rsrc';

Line 1780: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

1776: Update the last_update_date for locking issues at the step level.
1777: =============================================================================================*/
1778: PROCEDURE update_batchstep_rsrc (
1779: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
1780: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1781: ,x_return_status OUT NOCOPY VARCHAR2)
1782: IS
1783: l_api_name CONSTANT VARCHAR2 (30) := 'update_batchstep_rsrc';
1784: l_dummy NUMBER;

Line 1803: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

1799: l_inv_trans_count NUMBER;
1800: l_rsrc_trans_count NUMBER;
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.

Line 1804: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;

1800: l_rsrc_trans_count NUMBER;
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;

Line 1816: FROM gme_batch_steps a, gme_batch_step_resources b

1812: CURSOR cur_get_step_dtl (v_resource_id NUMBER)
1813: IS
1814: SELECT a.batchstep_id, a.step_status, b.batchstep_activity_id
1815: ,a.batch_id, b.resources
1816: FROM gme_batch_steps a, gme_batch_step_resources b
1817: WHERE b.batchstep_resource_id = v_resource_id
1818: AND a.batch_id = b.batch_id
1819: AND a.batchstep_id = b.batchstep_id;
1820:

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 2022: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

2018: p_batchstep_resource_rec batchstep resource row targetted for deletion
2019: x_return_status reflects return status of the API
2020: =============================================================================================*/
2021: PROCEDURE delete_batchstep_rsrc (
2022: p_batchstep_resource_rec IN gme_batch_step_resources%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;

Line 2026: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

2022: p_batchstep_resource_rec IN gme_batch_step_resources%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;

Line 2215: p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

2211: x_batchstep_resource_rec Consolidation of the inputs above
2212: x_return_status Return status
2213: =============================================================================================*/
2214: PROCEDURE consolidate_flexfields (
2215: p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2216: ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2217: ,p_validate_flexfield IN VARCHAR2
2218: DEFAULT fnd_api.g_false
2219: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

Line 2216: ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

2212: x_return_status Return status
2213: =============================================================================================*/
2214: PROCEDURE consolidate_flexfields (
2215: p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2216: ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2217: ,p_validate_flexfield IN VARCHAR2
2218: DEFAULT fnd_api.g_false
2219: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2220: ,x_return_status OUT NOCOPY VARCHAR2)

Line 2219: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

2215: p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2216: ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2217: ,p_validate_flexfield IN VARCHAR2
2218: DEFAULT fnd_api.g_false
2219: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2220: ,x_return_status OUT NOCOPY VARCHAR2)
2221: IS
2222: l_api_name CONSTANT VARCHAR2 (30) := 'consolidate_flexfields';
2223: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

Line 2223: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

2219: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2220: ,x_return_status OUT NOCOPY VARCHAR2)
2221: IS
2222: l_api_name CONSTANT VARCHAR2 (30) := 'consolidate_flexfields';
2223: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
2224: l_return_status VARCHAR2 (2);
2225: error_condition EXCEPTION;
2226: BEGIN
2227: IF g_debug <= gme_debug.g_log_procedure THEN