[Home] [Help]
398:
399: CURSOR cur_get_org_id (v_batch_id NUMBER)
400: IS
401: SELECT organization_id
402: FROM gme_batch_header
403: WHERE batch_id = v_batch_id;
404:
405:
406: insert_failure EXCEPTION;
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;
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;
1084: END IF;
1085:
1086: l_batch_header.batch_id := x_step_resources_rec.batch_id;
1087:
1088: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
1089: ,x_batch_header => l_batch_header) THEN
1090: RAISE fnd_api.g_exc_error;
1091: END IF;
1092:
1922: ,p_instance_id IN NUMBER
1923: ,p_instance_no IN NUMBER
1924: ,x_line_id OUT NOCOPY NUMBER
1925: ,x_step_status OUT NOCOPY NUMBER
1926: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1927: ,x_instance_id OUT NOCOPY NUMBER
1928: ,x_reason_id OUT NOCOPY NUMBER
1929: ,x_return_status OUT NOCOPY VARCHAR2
1930: ,
1933: IS
1934: CURSOR cur_get_batch_id (v_org_id VARCHAR2, v_batch_no VARCHAR2)
1935: IS
1936: SELECT batch_id
1937: FROM gme_batch_header
1938: WHERE organization_id = v_org_id
1939: AND batch_no = v_batch_no
1940: AND batch_type = 0;
1941:
2015: WHERE NVL (disable_date, SYSDATE + 1) > SYSDATE
2016: AND reason_name = v_reason_name;
2017:
2018: l_api_name CONSTANT VARCHAR2 (30) := 'validate_rsrc_txn_param';
2019: l_batch_header gme_batch_header%ROWTYPE;
2020: l_tran_rec gmi_trans_engine_pub.ictran_rec;
2021: l_step_status NUMBER;
2022: l_batch_id NUMBER;
2023: l_batchstep_id NUMBER;
2194: END IF;
2195:
2196: l_batch_header.batch_id := l_batch_step_rsrc_rec.batch_id;
2197:
2198: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
2199: ,x_batch_header => l_batch_header) THEN
2200: RAISE batch_hdr_fetch_err;
2201: END IF;
2202:
2504: ,x_return_status OUT NOCOPY VARCHAR2)
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;
2798: IS
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;
3051: IS
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;
3341: ,x_return_status OUT NOCOPY VARCHAR2)
3342: IS
3343: l_api_name CONSTANT VARCHAR2 (30) := 'start_cmplt_actual_rsrc_txn';
3344: l_resource_txns gme_resource_txns%ROWTYPE;
3345: l_batch_header gme_batch_header%ROWTYPE;
3346: l_line_id NUMBER;
3347: l_step_status NUMBER;
3348: l_return_status VARCHAR2 (2);
3349: l_resources VARCHAR2 (16);
3546: ,x_return_status OUT NOCOPY VARCHAR2)
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;