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 92: FROM gme_batch_step_resources

88:
89: CURSOR cur_fetch_resource_dtl (v_activity_id NUMBER, v_resource VARCHAR2)
90: IS
91: SELECT batchstep_resource_id
92: FROM gme_batch_step_resources
93: WHERE batchstep_activity_id = v_activity_id
94: AND resources = v_resource;
95:
96: batch_not_found EXCEPTION;

Line 303: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

299:
300: x_return_status reflects return status of the API
301: =============================================================================================*/
302: PROCEDURE validate_rsrc_param (
303: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
304: ,p_activity_id IN NUMBER
305: ,p_ignore_qty_below_cap IN VARCHAR2
306: DEFAULT fnd_api.g_false
307: ,p_validate_flexfield IN VARCHAR2

Line 310: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

306: DEFAULT fnd_api.g_false
307: ,p_validate_flexfield IN VARCHAR2
308: DEFAULT fnd_api.g_false
309: ,p_action IN VARCHAR2
310: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
311: ,x_step_status OUT NOCOPY NUMBER
312: ,x_return_status OUT NOCOPY VARCHAR2)
313: IS
314: l_api_name CONSTANT VARCHAR2 (30) := 'validate_rsrc_param';

Line 329: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

325: l_act_plan_cmplt_date DATE;
326: l_act_actual_start_date DATE;
327: l_act_actual_cmplt_date DATE;
328: l_step_qty_um VARCHAR2 (4);
329: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
330: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
331:
332: CURSOR cur_get_step_dtl_from_act (v_act_id NUMBER)
333: IS

Line 330: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;

326: l_act_actual_start_date DATE;
327: l_act_actual_cmplt_date DATE;
328: l_step_qty_um VARCHAR2 (4);
329: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
330: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
331:
332: CURSOR cur_get_step_dtl_from_act (v_act_id NUMBER)
333: IS
334: SELECT a.step_status, a.batch_id, a.step_qty_um

Line 959: IF NOT (gme_batch_step_resources_dbl.fetch_row

955: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
956: RAISE invalid_step_status;
957: END IF;
958:
959: IF NOT (gme_batch_step_resources_dbl.fetch_row
960: (p_batchstep_resource_rec
961: ,l_batchstep_resource_rec) ) THEN
962: RAISE rsrc_fetch_error;
963: END IF;

Line 1594: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES

1590: insert_batchstep_rsrc
1591: Description
1592: Procedure is used to insert rsrc for an activity
1593: Parameters
1594: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES
1595: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES
1596: x_return_status reflects return status of the API
1597: =============================================================================================*/
1598: PROCEDURE insert_batchstep_rsrc (

Line 1595: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES

1591: Description
1592: Procedure is used to insert rsrc for an activity
1593: Parameters
1594: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES
1595: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES
1596: x_return_status reflects return status of the API
1597: =============================================================================================*/
1598: PROCEDURE insert_batchstep_rsrc (
1599: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

Line 1599: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

1595: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES
1596: x_return_status reflects return status of the API
1597: =============================================================================================*/
1598: PROCEDURE insert_batchstep_rsrc (
1599: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
1600: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1601: ,x_return_status OUT NOCOPY VARCHAR2)
1602: IS
1603: l_api_name CONSTANT VARCHAR2 (30) := 'insert_batchstep_rsrc';

Line 1600: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

1596: x_return_status reflects return status of the API
1597: =============================================================================================*/
1598: PROCEDURE insert_batchstep_rsrc (
1599: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
1600: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1601: ,x_return_status OUT NOCOPY VARCHAR2)
1602: IS
1603: l_api_name CONSTANT VARCHAR2 (30) := 'insert_batchstep_rsrc';
1604: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

Line 1604: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

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

Line 1605: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;

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

Line 1744: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES

1740: update_batchstep_rsrc
1741: Description
1742: Procedure to update resource for an activity
1743: Parameters
1744: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES
1745: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES
1746: x_return_status reflects return status of the API
1747: History
1748: Inventory Convergence Project - March 2005

Line 1745: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES

1741: Description
1742: Procedure to update resource for an activity
1743: Parameters
1744: p_batchstep_resource_rec Input Row from GME_BATCH_STEP_RESOURCES
1745: x_batchstep_resource_rec Output Row from GME_BATCH_STEP_RESOURCES
1746: x_return_status reflects return status of the API
1747: History
1748: Inventory Convergence Project - March 2005
1749: =============================================================================================*/

Line 1751: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

1747: History
1748: Inventory Convergence Project - March 2005
1749: =============================================================================================*/
1750: PROCEDURE update_batchstep_rsrc (
1751: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
1752: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1753: ,x_return_status OUT NOCOPY VARCHAR2)
1754: IS
1755: l_api_name CONSTANT VARCHAR2 (30) := 'update_batchstep_rsrc';

Line 1752: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

1748: Inventory Convergence Project - March 2005
1749: =============================================================================================*/
1750: PROCEDURE update_batchstep_rsrc (
1751: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
1752: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1753: ,x_return_status OUT NOCOPY VARCHAR2)
1754: IS
1755: l_api_name CONSTANT VARCHAR2 (30) := 'update_batchstep_rsrc';
1756: l_dummy NUMBER;

Line 1775: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

1771: l_inv_trans_count NUMBER;
1772: l_rsrc_trans_count NUMBER;
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

Line 1776: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;

1772: l_rsrc_trans_count NUMBER;
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: ====================== */

Line 1785: FROM gme_batch_steps a, gme_batch_step_resources b

1781: CURSOR cur_get_step_dtl (v_resource_id NUMBER)
1782: IS
1783: SELECT a.batchstep_id, a.step_status, b.batchstep_activity_id
1784: ,a.batch_id, b.resources
1785: FROM gme_batch_steps a, gme_batch_step_resources b
1786: WHERE b.batchstep_resource_id = v_resource_id
1787: AND a.batch_id = b.batch_id
1788: AND a.batchstep_id = b.batchstep_id;
1789:

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

1983: p_batchstep_resource_rec batchstep resource row targetted for deletion
1984: x_return_status reflects return status of the API
1985: =============================================================================================*/
1986: PROCEDURE delete_batchstep_rsrc (
1987: p_batchstep_resource_rec IN gme_batch_step_resources%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;

Line 1991: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

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

Line 2180: p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

2176: x_batchstep_resource_rec Consolidation of the inputs above
2177: x_return_status Return status
2178: =============================================================================================*/
2179: PROCEDURE consolidate_flexfields (
2180: p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2181: ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2182: ,p_validate_flexfield IN VARCHAR2
2183: DEFAULT fnd_api.g_false
2184: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

Line 2181: ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

2177: x_return_status Return status
2178: =============================================================================================*/
2179: PROCEDURE consolidate_flexfields (
2180: p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2181: ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2182: ,p_validate_flexfield IN VARCHAR2
2183: DEFAULT fnd_api.g_false
2184: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2185: ,x_return_status OUT NOCOPY VARCHAR2)

Line 2184: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

2180: p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2181: ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2182: ,p_validate_flexfield IN VARCHAR2
2183: DEFAULT fnd_api.g_false
2184: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2185: ,x_return_status OUT NOCOPY VARCHAR2)
2186: IS
2187: l_api_name CONSTANT VARCHAR2 (30) := 'consolidate_flexfields';
2188: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

Line 2188: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

2184: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2185: ,x_return_status OUT NOCOPY VARCHAR2)
2186: IS
2187: l_api_name CONSTANT VARCHAR2 (30) := 'consolidate_flexfields';
2188: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
2189: l_return_status VARCHAR2 (2);
2190: error_condition EXCEPTION;
2191: BEGIN
2192: IF g_debug <= gme_debug.g_log_procedure THEN