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 1115: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE

1111: Bharati Satpute Bug2188136 21/03/2002 Added code for action_code 'INSERT'
1112:
1113: =============================================================================================*/
1114: PROCEDURE resource_dtl_process (
1115: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1116: ,p_action_code IN VARCHAR2
1117: ,p_check_prim_rsrc IN BOOLEAN := FALSE
1118: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1119: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1118: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

1114: PROCEDURE resource_dtl_process (
1115: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1116: ,p_action_code IN VARCHAR2
1117: ,p_check_prim_rsrc IN BOOLEAN := FALSE
1118: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1119: ,x_return_status OUT NOCOPY VARCHAR2)
1120: IS
1121: l_api_name CONSTANT VARCHAR2 (30) := 'resource_dtl_process';
1122: l_batch_header gme_batch_header%ROWTYPE;

Line 1125: l_step_resources gme_batch_step_resources%ROWTYPE;

1121: l_api_name CONSTANT VARCHAR2 (30) := 'resource_dtl_process';
1122: l_batch_header gme_batch_header%ROWTYPE;
1123: l_batch_step gme_batch_steps%ROWTYPE;
1124: l_step_activity gme_batch_step_activities%ROWTYPE;
1125: l_step_resources gme_batch_step_resources%ROWTYPE;
1126: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1127: l_resource_tbl gme_common_pvt.resource_transactions_tab;
1128: l_return_status VARCHAR2 (1);
1129: l_rsrc_usage NUMBER;

Line 1310: IF NOT (gme_batch_step_resources_dbl.insert_row

1306:
1307: -- Bug 12576806 - Initialize org id.
1308: x_step_resources_rec.organization_id := l_batch_header.organization_id;
1309:
1310: IF NOT (gme_batch_step_resources_dbl.insert_row
1311: (p_batch_step_resources => x_step_resources_rec
1312: ,x_batch_step_resources => x_step_resources_rec) ) THEN
1313: RAISE fnd_api.g_exc_error;
1314: END IF;

Line 1398: IF NOT (gme_batch_step_resources_dbl.update_row

1394: /* Update has to be done after updating the transactions as the adjust actual */
1395: /* usage logic depends on the previous actual usage to deduce the usage to be */
1396: /* deducted from the pending resource transactions */
1397: IF p_action_code = 'UPDATE' THEN
1398: IF NOT (gme_batch_step_resources_dbl.update_row
1399: (p_batch_step_resources => x_step_resources_rec) ) THEN
1400: RAISE fnd_api.g_exc_error;
1401: END IF;
1402:

Line 1517: ,p_step_resources_rec IN gme_batch_step_resources%ROWTYPE

1513: =============================================================================================*/
1514: PROCEDURE validate_resource (
1515: p_batch_step_rec IN gme_batch_steps%ROWTYPE
1516: ,p_step_activity_rec IN gme_batch_step_activities%ROWTYPE
1517: ,p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1518: ,p_check_prim_rsrc IN BOOLEAN := FALSE
1519: ,x_return_status OUT NOCOPY VARCHAR2)
1520: IS
1521: l_api_name CONSTANT VARCHAR2 (30) := 'validate_resource';

Line 1684: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE

1680: E - Error
1681: U - Unexpected error
1682: =============================================================================================*/
1683: PROCEDURE check_primary_resource (
1684: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1685: ,x_return_status OUT NOCOPY VARCHAR2)
1686: IS
1687: l_api_name CONSTANT VARCHAR2 (30) := 'check_primary_resource';
1688:

Line 1694: FROM gme_batch_step_resources

1690: v_batchstep_activity_id NUMBER
1691: ,v_batchstep_resource_id NUMBER)
1692: IS
1693: SELECT COUNT (1)
1694: FROM gme_batch_step_resources
1695: WHERE batchstep_resource_id <> NVL (v_batchstep_resource_id, -1)
1696: AND batchstep_activity_id = v_batchstep_activity_id
1697: AND prim_rsrc_ind = 1;
1698:

Line 1845: FROM gme_batch_step_resources

1841:
1842: CURSOR cur_get_prim_rsrc_count (v_batchstep_activity_id NUMBER)
1843: IS
1844: SELECT COUNT (1)
1845: FROM gme_batch_step_resources
1846: WHERE batchstep_activity_id = v_batchstep_activity_id
1847: AND prim_rsrc_ind = 1;
1848:
1849: l_count NUMBER (5);

Line 1913: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE

1909: U - Unexpected error
1910: Pawan kumar added code for bug 2294055
1911: =============================================================================================*/
1912: PROCEDURE get_resource_usage (
1913: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1914: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1915: ,x_return_status OUT NOCOPY VARCHAR2)
1916: IS
1917: l_api_name CONSTANT VARCHAR2 (30) := 'get_resource_usage';

Line 1914: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

1910: Pawan kumar added code for bug 2294055
1911: =============================================================================================*/
1912: PROCEDURE get_resource_usage (
1913: p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1914: ,x_step_resources_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
1915: ,x_return_status OUT NOCOPY VARCHAR2)
1916: IS
1917: l_api_name CONSTANT VARCHAR2 (30) := 'get_resource_usage';
1918:

Line 1949: IF NOT gme_batch_step_resources_dbl.fetch_row

1945: x_return_status := fnd_api.g_ret_sts_success;
1946: x_step_resources_rec.batchstep_resource_id :=
1947: p_step_resources_rec.batchstep_resource_id;
1948:
1949: IF NOT gme_batch_step_resources_dbl.fetch_row
1950: (p_batch_step_resources => x_step_resources_rec
1951: ,x_batch_step_resources => x_step_resources_rec) THEN
1952: RAISE fnd_api.g_exc_error;
1953: END IF;

Line 2071: FROM gme_batch_step_resources a

2067:
2068: CURSOR cur_get_batch_details (v_resource_id NUMBER)
2069: IS
2070: SELECT a.batch_id, a.resources
2071: FROM gme_batch_step_resources a
2072: WHERE a.batchstep_resource_id = v_resource_id;
2073:
2074: /* Bug 2685645 added batch_id param and used in where clause */
2075: CURSOR cur_get_activity_id (

Line 2089: FROM gme_batch_step_resources

2085:
2086: CURSOR cur_fetch_resource_dtl (v_activity_id NUMBER, v_resource VARCHAR2)
2087: IS
2088: SELECT batchstep_resource_id, resources
2089: FROM gme_batch_step_resources
2090: WHERE batchstep_activity_id = v_activity_id
2091: AND resources = v_resource;
2092:
2093: CURSOR cur_get_step_status (v_line_id NUMBER)

Line 2096: FROM gme_batch_steps a, gme_batch_step_resources b

2092:
2093: CURSOR cur_get_step_status (v_line_id NUMBER)
2094: IS
2095: SELECT step_status
2096: FROM gme_batch_steps a, gme_batch_step_resources b
2097: WHERE a.batchstep_id = b.batchstep_id
2098: AND b.batchstep_resource_id = v_line_id;
2099:
2100: CURSOR cur_get_instance_id (v_instance_no NUMBER, v_resource VARCHAR2)

Line 2121: FROM gme_batch_step_resources

2117:
2118: CURSOR cur_get_rsrc_actual_dates (v_line_id NUMBER)
2119: IS
2120: SELECT actual_start_date, actual_cmplt_date
2121: FROM gme_batch_step_resources
2122: WHERE batchstep_resource_id = v_line_id;
2123:
2124: CURSOR cur_validate_reason_id (v_reason_id NUMBER)
2125: IS

Line 2154: l_batch_step_rsrc_rec_in gme_batch_step_resources%ROWTYPE;

2150: l_return_status VARCHAR2 (2);
2151: l_line_id NUMBER;
2152: l_overrided_protected_ind VARCHAR2 (1);
2153: l_resource VARCHAR2 (16);
2154: l_batch_step_rsrc_rec_in gme_batch_step_resources%ROWTYPE;
2155: l_batch_step_rsrc_rec gme_batch_step_resources%ROWTYPE;
2156: --Rishi Varma 02-09-2004 B3856541
2157: /* start , Punit Kumar */
2158: /*

Line 2155: l_batch_step_rsrc_rec gme_batch_step_resources%ROWTYPE;

2151: l_line_id NUMBER;
2152: l_overrided_protected_ind VARCHAR2 (1);
2153: l_resource VARCHAR2 (16);
2154: l_batch_step_rsrc_rec_in gme_batch_step_resources%ROWTYPE;
2155: l_batch_step_rsrc_rec gme_batch_step_resources%ROWTYPE;
2156: --Rishi Varma 02-09-2004 B3856541
2157: /* start , Punit Kumar */
2158: /*
2159: p_tran_rec gmi_trans_engine_pub.ictran_rec;

Line 2632: l_step_resources gme_batch_step_resources%ROWTYPE;

2628: IS
2629: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ACTUAL_RSRC_USAGE';
2630: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
2631: l_batch_header gme_batch_header%ROWTYPE;
2632: l_step_resources gme_batch_step_resources%ROWTYPE;
2633: l_resource_tbl gme_common_pvt.resource_transactions_tab;
2634: l_line_id NUMBER;
2635: l_instance_id NUMBER;
2636: l_reason_id NUMBER;

Line 2651: FROM gme_batch_step_resources

2647:
2648: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
2649: IS
2650: SELECT resources, usage_um
2651: FROM gme_batch_step_resources
2652: WHERE batchstep_resource_id = v_line_id;
2653:
2654: validation_failure EXCEPTION;
2655: rsrc_fetch_err EXCEPTION;

Line 2845: IF NOT gme_batch_step_resources_dbl.fetch_row

2841: ,l_batch_header.batch_id);
2842: END IF;
2843:
2844: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
2845: IF NOT gme_batch_step_resources_dbl.fetch_row
2846: (p_batch_step_resources => l_step_resources
2847: ,x_batch_step_resources => l_step_resources) THEN
2848: RAISE rsrc_fetch_err;
2849: END IF;

Line 2854: IF NOT gme_batch_step_resources_dbl.update_row

2850:
2851: l_step_resources.actual_rsrc_count := 1;
2852: l_step_resources.actual_rsrc_usage := l_rsrc_txn_rec.resource_usage;
2853:
2854: IF NOT gme_batch_step_resources_dbl.update_row
2855: (p_batch_step_resources => l_step_resources) THEN
2856: RAISE rsrc_update_err;
2857: END IF;
2858:

Line 2930: l_step_resources gme_batch_step_resources%ROWTYPE;

2926: l_api_name CONSTANT VARCHAR2 (30)
2927: := 'insert_incr_actual_rsrc_txn';
2928: l_resource_txns gme_resource_txns%ROWTYPE;
2929: l_batch_header gme_batch_header%ROWTYPE;
2930: l_step_resources gme_batch_step_resources%ROWTYPE;
2931: l_resource_tbl gme_common_pvt.resource_transactions_tab;
2932: l_step_status NUMBER;
2933: l_activity_id NUMBER;
2934: l_inv_trans_count NUMBER;

Line 2954: FROM gme_batch_step_resources

2950: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
2951: IS
2952: ----SELECT resources,usage_uom
2953: SELECT resources, usage_um
2954: FROM gme_batch_step_resources
2955: WHERE batchstep_resource_id = v_line_id;
2956:
2957: validation_failure EXCEPTION;
2958: rsrc_fetch_err EXCEPTION;

Line 3111: IF NOT gme_batch_step_resources_dbl.fetch_row

3107: -- update resource actual count and usage
3108: -- l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
3109: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
3110:
3111: IF NOT gme_batch_step_resources_dbl.fetch_row
3112: (p_batch_step_resources => l_step_resources
3113: ,x_batch_step_resources => l_step_resources) THEN
3114: RAISE rsrc_fetch_err;
3115: END IF;

Line 3141: IF NOT gme_batch_step_resources_dbl.update_row

3137: RAISE reduce_pend_usage_err;
3138: END IF;
3139: END IF;
3140:
3141: IF NOT gme_batch_step_resources_dbl.update_row
3142: (p_batch_step_resources => l_step_resources) THEN
3143: RAISE rsrc_update_err;
3144: END IF;
3145:

Line 3219: l_step_resources gme_batch_step_resources%ROWTYPE;

3215: l_api_name CONSTANT VARCHAR2 (30)
3216: := 'insert_timed_actual_rsrc_txn';
3217: l_resource_txns gme_resource_txns%ROWTYPE;
3218: l_batch_header gme_batch_header%ROWTYPE;
3219: l_step_resources gme_batch_step_resources%ROWTYPE;
3220: l_resource_tbl gme_common_pvt.resource_transactions_tab;
3221: l_line_id NUMBER;
3222: l_inv_trans_count NUMBER;
3223: l_rsrc_trans_count NUMBER;

Line 3243: FROM gme_batch_step_resources

3239: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
3240: IS
3241: --- SELECT resources,usage_uom
3242: SELECT resources, usage_um
3243: FROM gme_batch_step_resources
3244: WHERE batchstep_resource_id = v_line_id;
3245:
3246: validation_failure EXCEPTION;
3247: uom_conversion_err EXCEPTION;

Line 3443: IF NOT gme_batch_step_resources_dbl.fetch_row

3439: -- update resource actual count and usage
3440: --l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
3441: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
3442:
3443: IF NOT gme_batch_step_resources_dbl.fetch_row
3444: (p_batch_step_resources => l_step_resources
3445: ,x_batch_step_resources => l_step_resources) THEN
3446: RAISE rsrc_fetch_err;
3447: END IF;

Line 3473: IF NOT gme_batch_step_resources_dbl.update_row

3469: RAISE reduce_pend_usage_err;
3470: END IF;
3471: END IF;
3472:
3473: IF NOT gme_batch_step_resources_dbl.update_row
3474: (p_batch_step_resources => l_step_resources) THEN
3475: RAISE rsrc_update_err;
3476: END IF;
3477:

Line 3555: FROM gme_batch_step_resources

3551: CURSOR cur_fetch_resource_dtl (v_line_id NUMBER)
3552: IS
3553: ---SELECT resources,usage_uom
3554: SELECT resources, usage_um
3555: FROM gme_batch_step_resources
3556: WHERE batchstep_resource_id = v_line_id;
3557:
3558: --Rishi Varma B3856541 02-09-2004 start
3559: l_trans_date DATE;

Line 3746: l_step_resources gme_batch_step_resources%ROWTYPE;

3742: IS
3743: l_api_name CONSTANT VARCHAR2 (30) := 'end_cmplt_actual_rsrc_txn';
3744: l_resource_txns gme_resource_txns%ROWTYPE;
3745: l_batch_header gme_batch_header%ROWTYPE;
3746: l_step_resources gme_batch_step_resources%ROWTYPE;
3747: l_resource_tbl gme_common_pvt.resource_transactions_tab;
3748: --Begin Bug# 3479669
3749: l_tran_rec gme_resource_txns%ROWTYPE;
3750: --End Bug# 3479669

Line 4040: IF NOT gme_batch_step_resources_dbl.fetch_row

4036: -- update resource actual count and usage
4037: ---l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
4038: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
4039:
4040: IF NOT gme_batch_step_resources_dbl.fetch_row
4041: (p_batch_step_resources => l_step_resources
4042: ,x_batch_step_resources => l_step_resources) THEN
4043: RAISE rsrc_fetch_err;
4044: END IF;

Line 4077: IF NOT gme_batch_step_resources_dbl.update_row

4073: RAISE reduce_pend_usage_err;
4074: END IF;
4075: END IF;
4076:
4077: IF NOT gme_batch_step_resources_dbl.update_row
4078: (p_batch_step_resources => l_step_resources) THEN
4079: RAISE rsrc_update_err;
4080: END IF;
4081: