APPS.GME_UPDATE_STEP_QTY_PVT dependencies on GME_RESOURCE_TXNS

Line 1082: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

1078: l_api_name CONSTANT VARCHAR2 (30) := 'update_resources';
1079: /* Collections for details etc */
1080: l_batchstep_resource_ids gme_common_pvt.number_tab;
1081: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;
1082: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1083: l_resource_tab gme_common_pvt.resource_transactions_tab;
1084: /* Local variables */
1085: l_sum_comp_usage NUMBER;
1086: l_override_usage NUMBER;

Line 1115: FROM gme_resource_txns

1111: ,v_doc_type VARCHAR2
1112: ,v_doc_id NUMBER)
1113: IS
1114: SELECT SUM (resource_usage)
1115: FROM gme_resource_txns
1116: WHERE line_id = v_batchstep_resource_id
1117: AND doc_type = v_doc_type
1118: AND doc_id = v_doc_id
1119: AND completed_ind = 1

Line 1794: l_ins_resource_row gme_resource_txns_gtmp%ROWTYPE;

1790: SELECT gem5_poc_trans_id_s.NEXTVAL
1791: FROM SYS.DUAL;
1792:
1793: /* Collections for details */
1794: l_ins_resource_row gme_resource_txns_gtmp%ROWTYPE;
1795: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;
1796: l_return_status VARCHAR2 (1);
1797: /* Exceptions */
1798: resource_trans_ins_err EXCEPTION;

Line 1899: IF NOT (gme_resource_txns_gtmp_dbl.insert_row (l_ins_resource_row

1895: RAISE FND_API.g_exc_error;
1896: END IF;
1897: l_ins_resource_row.trans_date := l_tran_rec_out.trans_date;
1898: */
1899: IF NOT (gme_resource_txns_gtmp_dbl.insert_row (l_ins_resource_row
1900: ,l_ins_resource_row) ) THEN
1901: RAISE resource_trans_ins_err;
1902: END IF;
1903:

Line 1946: FROM gme_resource_txns_gtmp

1942: IS
1943: CURSOR cur_sum_usage (v_batchstep_resource_id NUMBER)
1944: IS
1945: SELECT NVL (SUM (resource_usage), 0), COUNT (1)
1946: FROM gme_resource_txns_gtmp
1947: WHERE line_id = v_batchstep_resource_id AND completed_ind = 0;
1948:
1949: l_api_name CONSTANT VARCHAR2 (30) := 'adjust_pending_usage';
1950: /* Collections for details etc */

Line 2089: FROM gme_resource_txns_gtmp

2085:
2086: CURSOR cur_sum_comp_usage (v_batchstep_resource_id NUMBER)
2087: IS
2088: SELECT NVL (SUM (resource_usage), 0)
2089: FROM gme_resource_txns_gtmp
2090: WHERE line_id = v_batchstep_resource_id
2091: AND completed_ind = 1
2092: AND action_code <> 'DEL';
2093:

Line 2097: FROM gme_resource_txns_gtmp

2093:
2094: CURSOR cur_count_comp_usage (v_batchstep_resource_id NUMBER)
2095: IS
2096: SELECT COUNT (1)
2097: FROM gme_resource_txns_gtmp
2098: WHERE line_id = v_batchstep_resource_id
2099: AND completed_ind = 1
2100: AND NVL (overrided_protected_ind, 'N') <> 'Y'
2101: AND action_code <> 'DEL';

Line 2104: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

2100: AND NVL (overrided_protected_ind, 'N') <> 'Y'
2101: AND action_code <> 'DEL';
2102:
2103: /* Collections for details etc */
2104: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
2105: l_resource_tab gme_common_pvt.resource_transactions_tab;
2106: l_batch_hdr gme_batch_header%ROWTYPE;
2107: /* Local variables */
2108: l_sum_comp_usage NUMBER;

Line 2322: FROM gme_resource_txns_gtmp

2318:
2319: CURSOR cur_pend_count (v_batchstep_resource_id NUMBER)
2320: IS
2321: SELECT COUNT (1)
2322: FROM gme_resource_txns_gtmp
2323: WHERE line_id = v_batchstep_resource_id AND completed_ind = 0;
2324:
2325: /* Collections for details etc */
2326: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

Line 2326: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

2322: FROM gme_resource_txns_gtmp
2323: WHERE line_id = v_batchstep_resource_id AND completed_ind = 0;
2324:
2325: /* Collections for details etc */
2326: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
2327: l_resource_tab gme_common_pvt.resource_transactions_tab;
2328: /* Local variables */
2329: l_alloc_usage NUMBER;
2330: l_usage NUMBER;