APPS.GME_UPDATE_STEP_QTY_PVT dependencies on GME_RESOURCE_TXNS

Line 1181: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

1177: l_api_name CONSTANT VARCHAR2 (30) := 'update_resources';
1178: /* Collections for details etc */
1179: l_batchstep_resource_ids gme_common_pvt.number_tab;
1180: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;
1181: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1182: l_resource_tab gme_common_pvt.resource_transactions_tab;
1183: /* Local variables */
1184: l_sum_comp_usage NUMBER;
1185: l_override_usage NUMBER;

Line 1214: FROM gme_resource_txns

1210: ,v_doc_type VARCHAR2
1211: ,v_doc_id NUMBER)
1212: IS
1213: SELECT SUM (resource_usage)
1214: FROM gme_resource_txns
1215: WHERE line_id = v_batchstep_resource_id
1216: AND doc_type = v_doc_type
1217: AND doc_id = v_doc_id
1218: AND completed_ind = 1

Line 1897: l_ins_resource_row gme_resource_txns_gtmp%ROWTYPE;

1893: SELECT gem5_poc_trans_id_s.NEXTVAL
1894: FROM SYS.DUAL;
1895:
1896: /* Collections for details */
1897: l_ins_resource_row gme_resource_txns_gtmp%ROWTYPE;
1898: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;
1899: l_return_status VARCHAR2 (1);
1900: /* Exceptions */
1901: resource_trans_ins_err EXCEPTION;

Line 2009: IF NOT (gme_resource_txns_gtmp_dbl.insert_row (l_ins_resource_row

2005: IF (p_trans_date IS NOT NULL) THEN
2006: l_ins_resource_row.trans_date := p_trans_date;
2007: END IF;
2008:
2009: IF NOT (gme_resource_txns_gtmp_dbl.insert_row (l_ins_resource_row
2010: ,l_ins_resource_row) ) THEN
2011: RAISE resource_trans_ins_err;
2012: END IF;
2013:

Line 2056: FROM gme_resource_txns_gtmp

2052: IS
2053: CURSOR cur_sum_usage (v_batchstep_resource_id NUMBER)
2054: IS
2055: SELECT NVL (SUM (resource_usage), 0), COUNT (1)
2056: FROM gme_resource_txns_gtmp
2057: WHERE line_id = v_batchstep_resource_id AND completed_ind = 0;
2058:
2059: l_api_name CONSTANT VARCHAR2 (30) := 'adjust_pending_usage';
2060: /* Collections for details etc */

Line 2205: FROM gme_resource_txns_gtmp

2201:
2202: CURSOR cur_sum_comp_usage (v_batchstep_resource_id NUMBER)
2203: IS
2204: SELECT NVL (SUM (resource_usage), 0)
2205: FROM gme_resource_txns_gtmp
2206: WHERE line_id = v_batchstep_resource_id
2207: AND completed_ind = 1
2208: AND action_code <> 'DEL';
2209:

Line 2213: FROM gme_resource_txns_gtmp

2209:
2210: CURSOR cur_count_comp_usage (v_batchstep_resource_id NUMBER)
2211: IS
2212: SELECT COUNT (1)
2213: FROM gme_resource_txns_gtmp
2214: WHERE line_id = v_batchstep_resource_id
2215: AND completed_ind = 1
2216: AND NVL (overrided_protected_ind, 'N') <> 'Y'
2217: AND action_code <> 'DEL';

Line 2220: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

2216: AND NVL (overrided_protected_ind, 'N') <> 'Y'
2217: AND action_code <> 'DEL';
2218:
2219: /* Collections for details etc */
2220: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
2221: l_resource_tab gme_common_pvt.resource_transactions_tab;
2222: l_batch_hdr gme_batch_header%ROWTYPE;
2223: /* Local variables */
2224: l_sum_comp_usage NUMBER;

Line 2479: FROM gme_resource_txns_gtmp

2475:
2476: CURSOR cur_pend_count (v_batchstep_resource_id NUMBER)
2477: IS
2478: SELECT COUNT (1)
2479: FROM gme_resource_txns_gtmp
2480: WHERE line_id = v_batchstep_resource_id AND completed_ind = 0;
2481:
2482: /* Collections for details etc */
2483: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

Line 2483: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

2479: FROM gme_resource_txns_gtmp
2480: WHERE line_id = v_batchstep_resource_id AND completed_ind = 0;
2481:
2482: /* Collections for details etc */
2483: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
2484: l_resource_tab gme_common_pvt.resource_transactions_tab;
2485: /* Local variables */
2486: l_alloc_usage NUMBER;
2487: l_usage NUMBER;