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_COMMON_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 1500: p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE)

1496: x_return_status := fnd_api.g_ret_sts_unexp_error;
1497: END calc_mtl_req_date;
1498:
1499: FUNCTION is_qty_below_capacity (
1500: p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE)
1501: RETURN BOOLEAN
1502: IS
1503: CURSOR cur_get_um_type (v_uom_code VARCHAR2)
1504: IS

Line 1680: FROM gme_batch_step_resources

1676: IS
1677: CURSOR cur_get_resources
1678: IS
1679: SELECT batchstep_resource_id
1680: FROM gme_batch_step_resources
1681: WHERE batch_id = p_batch_id;
1682:
1683: l_resource_ids gme_common_pvt.number_tab;
1684: l_batch_step_resources gme_batch_step_resources%ROWTYPE;

Line 1684: l_batch_step_resources gme_batch_step_resources%ROWTYPE;

1680: FROM gme_batch_step_resources
1681: WHERE batch_id = p_batch_id;
1682:
1683: l_resource_ids gme_common_pvt.number_tab;
1684: l_batch_step_resources gme_batch_step_resources%ROWTYPE;
1685: l_found NUMBER (5) DEFAULT 0;
1686: l_resources VARCHAR2 (2000);
1687: l_api_name CONSTANT VARCHAR2 (30) := 'resource_qty_below_capacity';
1688: BEGIN

Line 1704: IF gme_batch_step_resources_dbl.fetch_row

1700:
1701: FOR i IN 1 .. l_resource_ids.COUNT LOOP
1702: l_batch_step_resources.batchstep_resource_id := l_resource_ids (i);
1703:
1704: IF gme_batch_step_resources_dbl.fetch_row
1705: (p_batch_step_resources => l_batch_step_resources
1706: ,x_batch_step_resources => l_batch_step_resources) THEN
1707: IF is_qty_below_capacity
1708: (p_batch_step_resources_rec => l_batch_step_resources) THEN

Line 1720: /* IF GME_BATCH_STEP_RESOURCES_DBL.fetch_row (p_batch_step_resources => l_batch_step_resources */

1716: END IF; /* IF l_resources IS NULL */
1717: END IF;
1718: /* IF is_qty_below_capacity (p_batch_step_resources => l_batch_step_resources) */
1719: END IF;
1720: /* IF GME_BATCH_STEP_RESOURCES_DBL.fetch_row (p_batch_step_resources => l_batch_step_resources */
1721: END LOOP;
1722: /* FOR i IN 1..l_resource_ids.COUNT */
1723: /* If we have found atleast one resource falling below capacity then return true */
1724:

Line 3507: p_batchstep_rsrc_rec IN gme_batch_step_resources%ROWTYPE

3503: RETURN FALSE;
3504: END close_period_check_flexible;
3505:
3506: FUNCTION get_batchstep_rsrc (
3507: p_batchstep_rsrc_rec IN gme_batch_step_resources%ROWTYPE
3508: ,p_org_code IN VARCHAR2
3509: ,p_batch_no IN VARCHAR2
3510: ,p_batchstep_no IN NUMBER
3511: ,p_activity IN VARCHAR2

Line 3513: ,x_batchstep_rsrc_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE)

3509: ,p_batch_no IN VARCHAR2
3510: ,p_batchstep_no IN NUMBER
3511: ,p_activity IN VARCHAR2
3512: ,p_resource IN VARCHAR2
3513: ,x_batchstep_rsrc_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE)
3514: RETURN BOOLEAN
3515: IS
3516: CURSOR get_organization (l_org_code IN VARCHAR2)
3517: IS

Line 3534: /* Join of gme_batch_step_resources and

3530: SELECT batchstep_id
3531: FROM gme_batch_steps
3532: WHERE batch_id = l_batch_id AND batchstep_no = l_batchstep_no;
3533:
3534: /* Join of gme_batch_step_resources and
3535: gme_batch_step_activities to get unique BATCHSTEP_RESOURCE_ID */
3536: CURSOR gme_batchstep_resource_id (
3537: l_organization_id IN NUMBER
3538: ,l_batch_id IN NUMBER

Line 3544: FROM gme_batch_step_resources gbsr

3540: ,l_activity IN VARCHAR2
3541: ,l_resource IN VARCHAR2)
3542: IS
3543: SELECT gbsr.batchstep_resource_id
3544: FROM gme_batch_step_resources gbsr
3545: ,gme_batch_step_activities gbsa
3546: WHERE gbsr.organization_id = l_organization_id
3547: AND gbsr.batch_id = l_batch_id
3548: AND gbsr.batchstep_id = l_batchstep_id

Line 3558: FROM gme_batch_step_resources

3554:
3555: CURSOR c_gbsr (l_batchstep_resource_id IN NUMBER)
3556: IS
3557: SELECT *
3558: FROM gme_batch_step_resources
3559: WHERE batchstep_resource_id = l_batchstep_resource_id;
3560:
3561: l_api_name CONSTANT VARCHAR2 (30) := 'GET_BATCHSTEP_RSRC';
3562: l_organization_id NUMBER;