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

Line 999: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE

995: Bharati Satpute Bug2188136 21/03/2002 Added code for action_code 'INSERT'
996:
997: =============================================================================================*/
998: PROCEDURE resource_dtl_process (
999: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1000: ,p_action_code IN VARCHAR2
1001: ,p_check_prim_rsrc IN BOOLEAN := FALSE
1002: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1003: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1002: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

998: PROCEDURE resource_dtl_process (
999: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1000: ,p_action_code IN VARCHAR2
1001: ,p_check_prim_rsrc IN BOOLEAN := FALSE
1002: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1003: ,x_return_status OUT NOCOPY VARCHAR2)
1004: IS
1005: l_api_name CONSTANT VARCHAR2 (30) := 'resource_dtl_process';
1006: l_batch_header gme_batch_header%ROWTYPE;

Line 1009: l_step_resources gme_batch_step_resources%ROWTYPE;

1005: l_api_name CONSTANT VARCHAR2 (30) := 'resource_dtl_process';
1006: l_batch_header gme_batch_header%ROWTYPE;
1007: l_batch_step gme_batch_steps%ROWTYPE;
1008: l_step_activity gme_batch_step_activities%ROWTYPE;
1009: l_step_resources gme_batch_step_resources%ROWTYPE;
1010: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1011: l_resource_tbl gme_common_pvt.resource_transactions_tab;
1012: l_return_status VARCHAR2 (1);
1013: l_rsrc_usage NUMBER;

Line 1190: IF NOT (gme_batch_step_resources_dbl.insert_row

1186: IF l_return_status <> x_return_status THEN
1187: RAISE FND_API.g_exc_error;
1188: END IF;
1189: */
1190: IF NOT (gme_batch_step_resources_dbl.insert_row
1191: (p_batch_step_resources => x_step_resources_rec
1192: ,x_batch_step_resources => x_step_resources_rec) ) THEN
1193: RAISE fnd_api.g_exc_error;
1194: END IF;

Line 1278: IF NOT (gme_batch_step_resources_dbl.update_row

1274: /* Update has to be done after updating the transactions as the adjust actual */
1275: /* usage logic depends on the previous actual usage to deduce the usage to be */
1276: /* deducted from the pending resource transactions */
1277: IF p_action_code = 'UPDATE' THEN
1278: IF NOT (gme_batch_step_resources_dbl.update_row
1279: (p_batch_step_resources => x_step_resources_rec) ) THEN
1280: RAISE fnd_api.g_exc_error;
1281: END IF;
1282:

Line 1397: ,p_step_resources_rec IN gme_batch_step_resources%ROWTYPE

1393: =============================================================================================*/
1394: PROCEDURE validate_resource (
1395: p_batch_step_rec IN gme_batch_steps%ROWTYPE
1396: ,p_step_activity_rec IN gme_batch_step_activities%ROWTYPE
1397: ,p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1398: ,p_check_prim_rsrc IN BOOLEAN := FALSE
1399: ,x_return_status OUT NOCOPY VARCHAR2)
1400: IS
1401: l_api_name CONSTANT VARCHAR2 (30) := 'validate_resource';

Line 1564: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE

1560: E - Error
1561: U - Unexpected error
1562: =============================================================================================*/
1563: PROCEDURE check_primary_resource (
1564: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1565: ,x_return_status OUT NOCOPY VARCHAR2)
1566: IS
1567: l_api_name CONSTANT VARCHAR2 (30) := 'check_primary_resource';
1568:

Line 1574: FROM gme_batch_step_resources

1570: v_batchstep_activity_id NUMBER
1571: ,v_batchstep_resource_id NUMBER)
1572: IS
1573: SELECT COUNT (1)
1574: FROM gme_batch_step_resources
1575: WHERE batchstep_resource_id <> NVL (v_batchstep_resource_id, -1)
1576: AND batchstep_activity_id = v_batchstep_activity_id
1577: AND prim_rsrc_ind = 1;
1578:

Line 1725: FROM gme_batch_step_resources

1721:
1722: CURSOR cur_get_prim_rsrc_count (v_batchstep_activity_id NUMBER)
1723: IS
1724: SELECT COUNT (1)
1725: FROM gme_batch_step_resources
1726: WHERE batchstep_activity_id = v_batchstep_activity_id
1727: AND prim_rsrc_ind = 1;
1728:
1729: l_count NUMBER (5);

Line 1793: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE

1789: U - Unexpected error
1790: Pawan kumar added code for bug 2294055
1791: =============================================================================================*/
1792: PROCEDURE get_resource_usage (
1793: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1794: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1795: ,x_return_status OUT NOCOPY VARCHAR2)
1796: IS
1797: l_api_name CONSTANT VARCHAR2 (30) := 'get_resource_usage';

Line 1794: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

1790: Pawan kumar added code for bug 2294055
1791: =============================================================================================*/
1792: PROCEDURE get_resource_usage (
1793: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1794: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1795: ,x_return_status OUT NOCOPY VARCHAR2)
1796: IS
1797: l_api_name CONSTANT VARCHAR2 (30) := 'get_resource_usage';
1798:

Line 1829: IF NOT gme_batch_step_resources_dbl.fetch_row

1825: x_return_status := fnd_api.g_ret_sts_success;
1826: x_step_resources_rec.batchstep_resource_id :=
1827: p_step_resources_rec.batchstep_resource_id;
1828:
1829: IF NOT gme_batch_step_resources_dbl.fetch_row
1830: (p_batch_step_resources => x_step_resources_rec
1831: ,x_batch_step_resources => x_step_resources_rec) THEN
1832: RAISE fnd_api.g_exc_error;
1833: END IF;

Line 1951: FROM gme_batch_step_resources a

1947:
1948: CURSOR cur_get_batch_details (v_resource_id NUMBER)
1949: IS
1950: SELECT a.batch_id, a.resources
1951: FROM gme_batch_step_resources a
1952: WHERE a.batchstep_resource_id = v_resource_id;
1953:
1954: /* Bug 2685645 added batch_id param and used in where clause */
1955: CURSOR cur_get_activity_id (

Line 1969: FROM gme_batch_step_resources

1965:
1966: CURSOR cur_fetch_resource_dtl (v_activity_id NUMBER, v_resource VARCHAR2)
1967: IS
1968: SELECT batchstep_resource_id, resources
1969: FROM gme_batch_step_resources
1970: WHERE batchstep_activity_id = v_activity_id
1971: AND resources = v_resource;
1972:
1973: CURSOR cur_get_step_status (v_line_id NUMBER)

Line 1976: FROM gme_batch_steps a, gme_batch_step_resources b

1972:
1973: CURSOR cur_get_step_status (v_line_id NUMBER)
1974: IS
1975: SELECT step_status
1976: FROM gme_batch_steps a, gme_batch_step_resources b
1977: WHERE a.batchstep_id = b.batchstep_id
1978: AND b.batchstep_resource_id = v_line_id;
1979:
1980: CURSOR cur_get_instance_id (v_instance_no NUMBER, v_resource VARCHAR2)

Line 2001: FROM gme_batch_step_resources

1997:
1998: CURSOR cur_get_rsrc_actual_dates (v_line_id NUMBER)
1999: IS
2000: SELECT actual_start_date, actual_cmplt_date
2001: FROM gme_batch_step_resources
2002: WHERE batchstep_resource_id = v_line_id;
2003:
2004: CURSOR cur_validate_reason_id (v_reason_id NUMBER)
2005: IS

Line 2034: l_batch_step_rsrc_rec_in gme_batch_step_resources%ROWTYPE;

2030: l_return_status VARCHAR2 (2);
2031: l_line_id NUMBER;
2032: l_overrided_protected_ind VARCHAR2 (1);
2033: l_resource VARCHAR2 (16);
2034: l_batch_step_rsrc_rec_in gme_batch_step_resources%ROWTYPE;
2035: l_batch_step_rsrc_rec gme_batch_step_resources%ROWTYPE;
2036: --Rishi Varma 02-09-2004 B3856541
2037: /* start , Punit Kumar */
2038: /*

Line 2035: l_batch_step_rsrc_rec gme_batch_step_resources%ROWTYPE;

2031: l_line_id NUMBER;
2032: l_overrided_protected_ind VARCHAR2 (1);
2033: l_resource VARCHAR2 (16);
2034: l_batch_step_rsrc_rec_in gme_batch_step_resources%ROWTYPE;
2035: l_batch_step_rsrc_rec gme_batch_step_resources%ROWTYPE;
2036: --Rishi Varma 02-09-2004 B3856541
2037: /* start , Punit Kumar */
2038: /*
2039: p_tran_rec gmi_trans_engine_pub.ictran_rec;

Line 2509: l_step_resources gme_batch_step_resources%ROWTYPE;

2505: IS
2506: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ACTUAL_RSRC_USAGE';
2507: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
2508: l_batch_header gme_batch_header%ROWTYPE;
2509: l_step_resources gme_batch_step_resources%ROWTYPE;
2510: l_resource_tbl gme_common_pvt.resource_transactions_tab;
2511: l_line_id NUMBER;
2512: l_instance_id NUMBER;
2513: l_reason_id NUMBER;

Line 2528: FROM gme_batch_step_resources

2524:
2525: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
2526: IS
2527: SELECT resources, usage_um
2528: FROM gme_batch_step_resources
2529: WHERE batchstep_resource_id = v_line_id;
2530:
2531: validation_failure EXCEPTION;
2532: rsrc_fetch_err EXCEPTION;

Line 2722: IF NOT gme_batch_step_resources_dbl.fetch_row

2718: ,l_batch_header.batch_id);
2719: END IF;
2720:
2721: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
2722: IF NOT gme_batch_step_resources_dbl.fetch_row
2723: (p_batch_step_resources => l_step_resources
2724: ,x_batch_step_resources => l_step_resources) THEN
2725: RAISE rsrc_fetch_err;
2726: END IF;

Line 2731: IF NOT gme_batch_step_resources_dbl.update_row

2727:
2728: l_step_resources.actual_rsrc_count := 1;
2729: l_step_resources.actual_rsrc_usage := l_rsrc_txn_rec.resource_usage;
2730:
2731: IF NOT gme_batch_step_resources_dbl.update_row
2732: (p_batch_step_resources => l_step_resources) THEN
2733: RAISE rsrc_update_err;
2734: END IF;
2735:

Line 2803: l_step_resources gme_batch_step_resources%ROWTYPE;

2799: l_api_name CONSTANT VARCHAR2 (30)
2800: := 'insert_incr_actual_rsrc_txn';
2801: l_resource_txns gme_resource_txns%ROWTYPE;
2802: l_batch_header gme_batch_header%ROWTYPE;
2803: l_step_resources gme_batch_step_resources%ROWTYPE;
2804: l_resource_tbl gme_common_pvt.resource_transactions_tab;
2805: l_step_status NUMBER;
2806: l_activity_id NUMBER;
2807: l_inv_trans_count NUMBER;

Line 2827: FROM gme_batch_step_resources

2823: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
2824: IS
2825: ----SELECT resources,usage_uom
2826: SELECT resources, usage_um
2827: FROM gme_batch_step_resources
2828: WHERE batchstep_resource_id = v_line_id;
2829:
2830: validation_failure EXCEPTION;
2831: rsrc_fetch_err EXCEPTION;

Line 2955: IF NOT gme_batch_step_resources_dbl.fetch_row

2951: -- update resource actual count and usage
2952: ---- l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
2953: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
2954:
2955: IF NOT gme_batch_step_resources_dbl.fetch_row
2956: (p_batch_step_resources => l_step_resources
2957: ,x_batch_step_resources => l_step_resources) THEN
2958: RAISE rsrc_fetch_err;
2959: END IF;

Line 2985: IF NOT gme_batch_step_resources_dbl.update_row

2981: RAISE reduce_pend_usage_err;
2982: END IF;
2983: END IF;
2984:
2985: IF NOT gme_batch_step_resources_dbl.update_row
2986: (p_batch_step_resources => l_step_resources) THEN
2987: RAISE rsrc_update_err;
2988: END IF;
2989:

Line 3056: l_step_resources gme_batch_step_resources%ROWTYPE;

3052: l_api_name CONSTANT VARCHAR2 (30)
3053: := 'insert_timed_actual_rsrc_txn';
3054: l_resource_txns gme_resource_txns%ROWTYPE;
3055: l_batch_header gme_batch_header%ROWTYPE;
3056: l_step_resources gme_batch_step_resources%ROWTYPE;
3057: l_resource_tbl gme_common_pvt.resource_transactions_tab;
3058: l_line_id NUMBER;
3059: l_inv_trans_count NUMBER;
3060: l_rsrc_trans_count NUMBER;

Line 3080: FROM gme_batch_step_resources

3076: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
3077: IS
3078: --- SELECT resources,usage_uom
3079: SELECT resources, usage_um
3080: FROM gme_batch_step_resources
3081: WHERE batchstep_resource_id = v_line_id;
3082:
3083: validation_failure EXCEPTION;
3084: uom_conversion_err EXCEPTION;

Line 3251: IF NOT gme_batch_step_resources_dbl.fetch_row

3247: -- update resource actual count and usage
3248: --l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
3249: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
3250:
3251: IF NOT gme_batch_step_resources_dbl.fetch_row
3252: (p_batch_step_resources => l_step_resources
3253: ,x_batch_step_resources => l_step_resources) THEN
3254: RAISE rsrc_fetch_err;
3255: END IF;

Line 3281: IF NOT gme_batch_step_resources_dbl.update_row

3277: RAISE reduce_pend_usage_err;
3278: END IF;
3279: END IF;
3280:
3281: IF NOT gme_batch_step_resources_dbl.update_row
3282: (p_batch_step_resources => l_step_resources) THEN
3283: RAISE rsrc_update_err;
3284: END IF;
3285:

Line 3360: FROM gme_batch_step_resources

3356: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
3357: IS
3358: ---SELECT resources,usage_uom
3359: SELECT resources, usage_um
3360: FROM gme_batch_step_resources
3361: WHERE batchstep_resource_id = v_line_id;
3362:
3363: --Rishi Varma B3856541 02-09-2004 start
3364: l_trans_date DATE;

Line 3551: l_step_resources gme_batch_step_resources%ROWTYPE;

3547: IS
3548: l_api_name CONSTANT VARCHAR2 (30) := 'end_cmplt_actual_rsrc_txn';
3549: l_resource_txns gme_resource_txns%ROWTYPE;
3550: l_batch_header gme_batch_header%ROWTYPE;
3551: l_step_resources gme_batch_step_resources%ROWTYPE;
3552: l_resource_tbl gme_common_pvt.resource_transactions_tab;
3553: --Begin Bug# 3479669
3554: l_tran_rec gme_resource_txns%ROWTYPE;
3555: --End Bug# 3479669

Line 3845: IF NOT gme_batch_step_resources_dbl.fetch_row

3841: -- update resource actual count and usage
3842: ---l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
3843: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
3844:
3845: IF NOT gme_batch_step_resources_dbl.fetch_row
3846: (p_batch_step_resources => l_step_resources
3847: ,x_batch_step_resources => l_step_resources) THEN
3848: RAISE rsrc_fetch_err;
3849: END IF;

Line 3882: IF NOT gme_batch_step_resources_dbl.update_row

3878: RAISE reduce_pend_usage_err;
3879: END IF;
3880: END IF;
3881:
3882: IF NOT gme_batch_step_resources_dbl.update_row
3883: (p_batch_step_resources => l_step_resources) THEN
3884: RAISE rsrc_update_err;
3885: END IF;
3886: