[Home] [Help]
427:
428: CURSOR cur_get_org_id (v_batch_id NUMBER)
429: IS
430: SELECT organization_id
431: FROM gme_batch_header
432: WHERE batch_id = v_batch_id;
433:
434:
435: insert_failure EXCEPTION;
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;
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;
1200: END IF;
1201:
1202: l_batch_header.batch_id := x_step_resources_rec.batch_id;
1203:
1204: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
1205: ,x_batch_header => l_batch_header) THEN
1206: RAISE fnd_api.g_exc_error;
1207: END IF;
1208:
2042: ,p_instance_id IN NUMBER
2043: ,p_instance_no IN NUMBER
2044: ,x_line_id OUT NOCOPY NUMBER
2045: ,x_step_status OUT NOCOPY NUMBER
2046: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
2047: ,x_instance_id OUT NOCOPY NUMBER
2048: ,x_reason_id OUT NOCOPY NUMBER
2049: ,x_return_status OUT NOCOPY VARCHAR2
2050: ,
2053: IS
2054: CURSOR cur_get_batch_id (v_org_id VARCHAR2, v_batch_no VARCHAR2)
2055: IS
2056: SELECT batch_id
2057: FROM gme_batch_header
2058: WHERE organization_id = v_org_id
2059: AND batch_no = v_batch_no
2060: AND batch_type = 0;
2061:
2135: WHERE NVL (disable_date, SYSDATE + 1) > SYSDATE
2136: AND reason_name = v_reason_name;
2137:
2138: l_api_name CONSTANT VARCHAR2 (30) := 'validate_rsrc_txn_param';
2139: l_batch_header gme_batch_header%ROWTYPE;
2140: l_tran_rec gmi_trans_engine_pub.ictran_rec;
2141: l_step_status NUMBER;
2142: l_batch_id NUMBER;
2143: l_batchstep_id NUMBER;
2314: END IF;
2315:
2316: l_batch_header.batch_id := l_batch_step_rsrc_rec.batch_id;
2317:
2318: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
2319: ,x_batch_header => l_batch_header) THEN
2320: RAISE batch_hdr_fetch_err;
2321: END IF;
2322:
2627: ,x_return_status OUT NOCOPY VARCHAR2)
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;
2925: IS
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;
3214: IS
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;
3536: ,x_return_status OUT NOCOPY VARCHAR2)
3537: IS
3538: l_api_name CONSTANT VARCHAR2 (30) := 'start_cmplt_actual_rsrc_txn';
3539: l_resource_txns gme_resource_txns%ROWTYPE;
3540: l_batch_header gme_batch_header%ROWTYPE;
3541: l_line_id NUMBER;
3542: l_step_status NUMBER;
3543: l_return_status VARCHAR2 (2);
3544: l_resources VARCHAR2 (16);
3741: ,x_return_status OUT NOCOPY VARCHAR2)
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;