APPS.GME_API_GRP dependencies on GME_RESOURCE_TXNS_GTMP

Line 2736: PROCEDURE create_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,

2732: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2733: END IF;
2734: END delete_material_txn;
2735:
2736: PROCEDURE create_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,
2737: x_rsrc_txn_gtmp_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE,
2738: x_return_status OUT NOCOPY VARCHAR2) IS
2739: l_api_name CONSTANT VARCHAR2 (30) := 'create_resource_txn';
2740: l_return_status VARCHAR2(1);

Line 2737: x_rsrc_txn_gtmp_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE,

2733: END IF;
2734: END delete_material_txn;
2735:
2736: PROCEDURE create_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,
2737: x_rsrc_txn_gtmp_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE,
2738: x_return_status OUT NOCOPY VARCHAR2) IS
2739: l_api_name CONSTANT VARCHAR2 (30) := 'create_resource_txn';
2740: l_return_status VARCHAR2(1);
2741: l_hour_um VARCHAR2(3);

Line 2751: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;

2747: l_txn_usage NUMBER;
2748: l_rsrc_trans_count NUMBER;
2749: l_trans_date DATE;
2750: l_batch_header_rec gme_batch_header%ROWTYPE;
2751: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2752: l_step_resources gme_batch_step_resources%ROWTYPE;
2753: setup_failed EXCEPTION;
2754: create_txn_fail EXCEPTION;
2755: validate_txn_fail EXCEPTION;

Line 2863: PROCEDURE update_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,

2859: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2860: END IF;
2861: END create_resource_txn;
2862:
2863: PROCEDURE update_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,
2864: x_return_status OUT NOCOPY VARCHAR2) IS
2865: l_api_name CONSTANT VARCHAR2 (30) := 'update_resource_txn';
2866: l_return_status VARCHAR2(1);
2867: l_line_id NUMBER;

Line 2962: PROCEDURE delete_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,

2958: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2959: END IF;
2960: END update_resource_txn;
2961:
2962: PROCEDURE delete_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,
2963: x_return_status OUT NOCOPY VARCHAR2) IS
2964: l_api_name CONSTANT VARCHAR2 (30) := 'delete_resource_txn';
2965: l_asqc NUMBER;
2966: l_return_status VARCHAR2(1);

Line 2970: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;

2966: l_return_status VARCHAR2(1);
2967: l_step_status VARCHAR2(1);
2968: l_step_resources gme_batch_step_resources%ROWTYPE;
2969: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2970: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2971: CURSOR Cur_get_step(v_line_id NUMBER) IS
2972: SELECT s.step_status, h.automatic_step_calculation
2973: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_batch_header h
2974: WHERE r.batchstep_resource_id = v_line_id

Line 2998: IF NOT gme_resource_txns_gtmp_dbl.fetch_row(p_rsrc_txn_gtmp_rec, l_rsrc_txn_gtmp_rec) THEN

2994: RAISE setup_failed;
2995: END IF;
2996: END IF;
2997: gme_common_pvt.set_timestamp;
2998: IF NOT gme_resource_txns_gtmp_dbl.fetch_row(p_rsrc_txn_gtmp_rec, l_rsrc_txn_gtmp_rec) THEN
2999: RAISE fetch_txn_failed;
3000: END IF;
3001: OPEN Cur_get_step(l_rsrc_txn_gtmp_rec.line_id);
3002: FETCH Cur_get_step INTO l_step_status, l_asqc;