APPS.GME_RESOURCE_ENGINE_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1008: l_step_activity gme_batch_step_activities%ROWTYPE;

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;
1012: l_return_status VARCHAR2 (1);

Line 1080: IF NOT gme_batch_step_activities_dbl.fetch_row

1076:
1077: l_step_activity.batchstep_activity_id :=
1078: p_step_resources_rec.batchstep_activity_id;
1079:
1080: IF NOT gme_batch_step_activities_dbl.fetch_row
1081: (p_batch_step_activities => l_step_activity
1082: ,x_batch_step_activities => l_step_activity) THEN
1083: RAISE fnd_api.g_exc_error;
1084: END IF;

Line 1396: ,p_step_activity_rec IN gme_batch_step_activities%ROWTYPE

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)
1400: IS

Line 1583: FROM gme_batch_step_activities

1579: --Rishi 3446787/3020345 start
1580: CURSOR cur_get_activity (v_batchstep_activity_id NUMBER)
1581: IS
1582: SELECT activity
1583: FROM gme_batch_step_activities
1584: WHERE batchstep_activity_id = v_batchstep_activity_id;
1585:
1586: CURSOR cur_get_step_id (v_batchstep_activity_id NUMBER)
1587: IS

Line 1589: FROM gme_batch_step_activities

1585:
1586: CURSOR cur_get_step_id (v_batchstep_activity_id NUMBER)
1587: IS
1588: SELECT batchstep_id
1589: FROM gme_batch_step_activities
1590: WHERE batchstep_activity_id = v_batchstep_activity_id;
1591:
1592: CURSOR cur_get_batchstep_no (v_batchstep_id NUMBER)
1593: IS

Line 1598: l_activity gme_batch_step_activities.activity%TYPE;

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;
1600: l_step_id gme_batch_steps.batchstep_id%TYPE;
1601: --Rishi 3446787/3020345 end
1602: l_count NUMBER (5);

Line 1719: FROM gme_batch_step_activities

1715: v_batch_id NUMBER
1716: ,v_batchstep_id NUMBER)
1717: IS
1718: SELECT activity, batchstep_activity_id
1719: FROM gme_batch_step_activities
1720: WHERE batch_id = v_batch_id AND batchstep_id = v_batchstep_id;
1721:
1722: CURSOR cur_get_prim_rsrc_count (v_batchstep_activity_id NUMBER)
1723: IS

Line 1961: FROM gme_batch_step_activities

1957: ,v_activity VARCHAR2
1958: ,v_batch_id NUMBER)
1959: IS
1960: SELECT batchstep_activity_id
1961: FROM gme_batch_step_activities
1962: WHERE batchstep_id = v_step_id
1963: AND batch_id = v_batch_id
1964: AND activity = v_activity;
1965: