eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_UPDATE_STEP_QTY_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 569: ,p_resources IN gme_batch_step_resources.resources%TYPE

565: Hisory
566: =============================================================================================*/
567: PROCEDURE calc_charge (
568: p_step_id IN gme_batch_steps.batchstep_id%TYPE
569: ,p_resources IN gme_batch_step_resources.resources%TYPE
570: DEFAULT NULL
571: ,p_mass_qty IN gme_batch_steps.plan_mass_qty%TYPE
572: ,p_vol_qty IN gme_batch_steps.plan_volume_qty%TYPE
573: ,p_step_qty IN NUMBER DEFAULT NULL --Bug#5231180

Line 609: FROM gme_batch_steps gbs, gme_batch_step_resources gbsr

605:
606: CURSOR cur_get_tolerance
607: IS
608: SELECT NVL (MIN (gbsr.capacity_tolerance), 0)
609: FROM gme_batch_steps gbs, gme_batch_step_resources gbsr
610: WHERE gbs.batchstep_id = gbsr.batchstep_id
611: AND gbsr.calculate_charges = 1
612: AND gbsr.batchstep_id = p_step_id;
613:

Line 616: ,v_resources gme_batch_step_resources.resources%TYPE)

612: AND gbsr.batchstep_id = p_step_id;
613:
614: CURSOR cur_get_resource_dates (
615: v_batchstep_id NUMBER
616: ,v_resources gme_batch_step_resources.resources%TYPE)
617: IS
618: SELECT plan_start_date, plan_cmplt_date
619: FROM gme_batch_step_resources
620: WHERE batchstep_id = v_batchstep_id AND resources = v_resources;

Line 619: FROM gme_batch_step_resources

615: v_batchstep_id NUMBER
616: ,v_resources gme_batch_step_resources.resources%TYPE)
617: IS
618: SELECT plan_start_date, plan_cmplt_date
619: FROM gme_batch_step_resources
620: WHERE batchstep_id = v_batchstep_id AND resources = v_resources;
621:
622: CURSOR cur_get_batch_id (v_batchstep_id NUMBER)
623: IS

Line 629: v_resources gme_batch_step_resources.resources%TYPE)

625: FROM gme_batch_steps
626: WHERE batchstep_id = v_batchstep_id;
627:
628: CURSOR cur_get_scale_type (
629: v_resources gme_batch_step_resources.resources%TYPE)
630: IS
631: SELECT 1
632: FROM DUAL
633: WHERE EXISTS (

Line 635: FROM gme_batch_step_resources

631: SELECT 1
632: FROM DUAL
633: WHERE EXISTS (
634: SELECT 1
635: FROM gme_batch_step_resources
636: WHERE batchstep_id = p_step_id
637: AND resources = v_resources
638: AND scale_type = 2);
639:

Line 640: l_scale_type gme_batch_step_resources.scale_type%TYPE;

636: WHERE batchstep_id = p_step_id
637: AND resources = v_resources
638: AND scale_type = 2);
639:
640: l_scale_type gme_batch_step_resources.scale_type%TYPE;
641: l_remaining_quantity NUMBER;
642: l_batch_step_charges_in gme_batch_step_charges%ROWTYPE;
643: l_return_status VARCHAR2 (1);
644: l_charge gme_batch_steps.plan_charges%TYPE;

Line 1081: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;

1077: IS
1078: l_api_name CONSTANT VARCHAR2 (30) := 'update_resources';
1079: /* Collections for details etc */
1080: l_batchstep_resource_ids gme_common_pvt.number_tab;
1081: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;
1082: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1083: l_resource_tab gme_common_pvt.resource_transactions_tab;
1084: /* Local variables */
1085: l_sum_comp_usage NUMBER;

Line 1106: FROM gme_batch_step_resources

1102:
1103: CURSOR cur_step_resource_ids (v_batchstep_activity_id NUMBER)
1104: IS
1105: SELECT batchstep_resource_id
1106: FROM gme_batch_step_resources
1107: WHERE batchstep_activity_id = v_batchstep_activity_id;
1108:
1109: CURSOR cur_sum_override_resource (
1110: v_batchstep_resource_id NUMBER

Line 1175: IF NOT (gme_batch_step_resources_dbl.fetch_row

1171: FOR i IN 1 .. l_batchstep_resource_ids.COUNT LOOP
1172: l_gme_batchstep_resources.batchstep_resource_id :=
1173: l_batchstep_resource_ids (i);
1174:
1175: IF NOT (gme_batch_step_resources_dbl.fetch_row
1176: (l_gme_batchstep_resources
1177: ,l_gme_batchstep_resources) ) THEN
1178: RAISE activity_resource_fetch_error;
1179: END IF;

Line 1722: IF NOT (gme_batch_step_resources_dbl.update_row

1718: l_gme_batchstep_resources.actual_rsrc_usage :=
1719: ROUND (l_gme_batchstep_resources.actual_rsrc_usage, 32);
1720:
1721: /* Save the updated batch step resources row to the database */
1722: IF NOT (gme_batch_step_resources_dbl.update_row
1723: (l_gme_batchstep_resources) ) THEN
1724: RAISE step_resource_upd_err;
1725: END IF;
1726: END LOOP; /* FOR i IN 1..l_batchstep_resource_ids.COUNT LOOP */

Line 1779: ,p_batchstep_resource IN gme_batch_step_resources%ROWTYPE

1775: U - Unexpected error
1776: =============================================================================================*/
1777: PROCEDURE build_insert_resource_txn (
1778: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1779: ,p_batchstep_resource IN gme_batch_step_resources%ROWTYPE
1780: ,p_usage IN NUMBER
1781: ,p_completed IN NUMBER DEFAULT 1
1782: ,x_return_status OUT NOCOPY VARCHAR2)
1783: IS

Line 1795: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;

1791: FROM SYS.DUAL;
1792:
1793: /* Collections for details */
1794: l_ins_resource_row gme_resource_txns_gtmp%ROWTYPE;
1795: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;
1796: l_return_status VARCHAR2 (1);
1797: /* Exceptions */
1798: resource_trans_ins_err EXCEPTION;
1799: -- p_tran_rec gmi_trans_engine_pub.ictran_rec;

Line 1940: p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE

1936: E - Error
1937: U - Unexpected error
1938: =============================================================================================*/
1939: PROCEDURE adjust_pending_usage (
1940: p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1941: ,x_return_status OUT NOCOPY VARCHAR2)
1942: IS
1943: CURSOR cur_sum_usage (v_batchstep_resource_id NUMBER)
1944: IS

Line 2081: p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE

2077: E - Error
2078: U - Unexpected error
2079: =============================================================================================*/
2080: PROCEDURE adjust_actual_usage (
2081: p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
2082: ,x_return_status OUT NOCOPY VARCHAR2)
2083: IS
2084: l_api_name CONSTANT VARCHAR2 (30) := 'adjust_actual_usage';
2085:

Line 2301: p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE

2297: Pawan Kumar for bug 2393432 Modified procedure reduce_pending_usage
2298: Namit Singhi. Bug#5609683. Restructuring of code when calculating pending usage.
2299: =============================================================================================*/
2300: PROCEDURE reduce_pending_usage (
2301: p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
2302: ,x_return_status OUT NOCOPY VARCHAR2)
2303: IS
2304: l_api_name CONSTANT VARCHAR2 (30) := 'reduce_pending_usage';
2305:

Line 2316: FROM gme_batch_step_resources

2312: --nsinghi bug#5609683 Modified the cursor to also query resource plan start date and changed cursor name
2313: CURSOR cur_get_rsrc_dtl (v_batchstep_resource_id NUMBER)
2314: IS
2315: SELECT actual_rsrc_usage, plan_start_date
2316: FROM gme_batch_step_resources
2317: WHERE batchstep_resource_id = v_batchstep_resource_id;
2318:
2319: CURSOR cur_pend_count (v_batchstep_resource_id NUMBER)
2320: IS

Line 2547: FROM gme_batch_step_resources

2543: WHERE batchstep_id = v_step_id;
2544:
2545: CURSOR c_get_step_resources(v_step_id NUMBER) IS
2546: SELECT resources
2547: FROM gme_batch_step_resources
2548: WHERE batchstep_id = v_step_id;
2549:
2550: l_step_rec c_get_step_qty%ROWTYPE;
2551: l_resource gme_batch_step_resources.resources%TYPE;

Line 2551: l_resource gme_batch_step_resources.resources%TYPE;

2547: FROM gme_batch_step_resources
2548: WHERE batchstep_id = v_step_id;
2549:
2550: l_step_rec c_get_step_qty%ROWTYPE;
2551: l_resource gme_batch_step_resources.resources%TYPE;
2552: l_batch_header_rec gme_batch_header%ROWTYPE;
2553: l_in_step_qty NUMBER;
2554: l_step_qty NUMBER;
2555: l_charge NUMBER;