[Home] [Help]
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;
1011: l_resource_tbl gme_common_pvt.resource_transactions_tab;
1014: l_rsrc_count NUMBER;
1015: l_tot_usage NUMBER;
1016: l_completed NUMBER (5);
1017:
1018: x_batch_step gme_batch_steps%ROWTYPE;
1019:
1020: CURSOR cur_sum_usage (v_batchstep_resource_id NUMBER, v_completed NUMBER)
1021: IS
1022: SELECT NVL (SUM (resource_usage), 0)
1032: FROM cr_rsrc_mst
1033: WHERE resources = v_rsrc
1034: AND capacity_constraint = 1;
1035:
1036: CURSOR cur_get_charge_rsrc(v_step_id gme_batch_steps.batchstep_id%TYPE, v_rsrc cr_rsrc_mst.resources%TYPE)
1037: IS
1038: SELECT 1
1039: FROM DUAL
1040: WHERE EXISTS (SELECT 1
1068: x_return_status := fnd_api.g_ret_sts_success;
1069: x_step_resources_rec := p_step_resources_rec;
1070: l_batch_step.batchstep_id := x_step_resources_rec.batchstep_id;
1071:
1072: IF NOT gme_batch_steps_dbl.fetch_row (p_batch_step => l_batch_step
1073: ,x_batch_step => l_batch_step) THEN
1074: RAISE fnd_api.g_exc_error;
1075: END IF;
1076:
1391: History
1392: Bharati Satpute Bug 2165993 1/09/2002 Incomprehensible error message when inserting a resource
1393: =============================================================================================*/
1394: PROCEDURE validate_resource (
1395: p_batch_step_rec IN gme_batch_steps%ROWTYPE
1396: ,p_step_activity_rec IN gme_batch_step_activities%ROWTYPE
1397: ,p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1398: ,p_check_prim_rsrc IN BOOLEAN := FALSE
1399: ,x_return_status OUT NOCOPY VARCHAR2)
1591:
1592: CURSOR cur_get_batchstep_no (v_batchstep_id NUMBER)
1593: IS
1594: SELECT batchstep_no
1595: FROM gme_batch_steps
1596: WHERE batchstep_id = v_batchstep_id;
1597:
1598: l_activity gme_batch_step_activities.activity%TYPE;
1599: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
1595: FROM gme_batch_steps
1596: WHERE batchstep_id = v_batchstep_id;
1597:
1598: l_activity gme_batch_step_activities.activity%TYPE;
1599: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
1600: l_step_id gme_batch_steps.batchstep_id%TYPE;
1601: --Rishi 3446787/3020345 end
1602: l_count NUMBER (5);
1603: BEGIN
1596: WHERE batchstep_id = v_batchstep_id;
1597:
1598: l_activity gme_batch_step_activities.activity%TYPE;
1599: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
1600: l_step_id gme_batch_steps.batchstep_id%TYPE;
1601: --Rishi 3446787/3020345 end
1602: l_count NUMBER (5);
1603: BEGIN
1604: IF g_debug <= gme_debug.g_log_procedure THEN
1706: IS
1707: CURSOR cur_get_batch_steps
1708: IS
1709: SELECT batch_id, batchstep_no, batchstep_id
1710: FROM gme_batch_steps
1711: WHERE batch_id = p_batch_id
1712: AND batchstep_id = NVL (p_batchstep_id, batchstep_id);
1713:
1714: CURSOR cur_get_batchstep_activities (
1798:
1799: CURSOR cur_get_stat
1800: IS
1801: SELECT step_status
1802: FROM gme_batch_steps
1803: WHERE batchstep_id = p_step_resources_rec.batchstep_id;
1804:
1805: /* Bug 2651477 added delete_mark condition */
1806: CURSOR cur_get_usage (v_completed_ind NUMBER)
1941:
1942: CURSOR cur_get_batchstep_id (v_batch_id NUMBER, v_batchstep_no NUMBER)
1943: IS
1944: SELECT batchstep_id
1945: FROM gme_batch_steps
1946: WHERE batch_id = v_batch_id AND batchstep_no = v_batchstep_no;
1947:
1948: CURSOR cur_get_batch_details (v_resource_id NUMBER)
1949: IS
1972:
1973: CURSOR cur_get_step_status (v_line_id NUMBER)
1974: IS
1975: SELECT step_status
1976: FROM gme_batch_steps a, gme_batch_step_resources b
1977: WHERE a.batchstep_id = b.batchstep_id
1978: AND b.batchstep_resource_id = v_line_id;
1979:
1980: CURSOR cur_get_instance_id (v_instance_no NUMBER, v_resource VARCHAR2)