APPS.GME_RESOURCE_ENGINE_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1124: l_step_activity gme_batch_step_activities%ROWTYPE;

1120: IS
1121: l_api_name CONSTANT VARCHAR2 (30) := 'resource_dtl_process';
1122: l_batch_header gme_batch_header%ROWTYPE;
1123: l_batch_step gme_batch_steps%ROWTYPE;
1124: l_step_activity gme_batch_step_activities%ROWTYPE;
1125: l_step_resources gme_batch_step_resources%ROWTYPE;
1126: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1127: l_resource_tbl gme_common_pvt.resource_transactions_tab;
1128: l_return_status VARCHAR2 (1);

Line 1196: IF NOT gme_batch_step_activities_dbl.fetch_row

1192:
1193: l_step_activity.batchstep_activity_id :=
1194: p_step_resources_rec.batchstep_activity_id;
1195:
1196: IF NOT gme_batch_step_activities_dbl.fetch_row
1197: (p_batch_step_activities => l_step_activity
1198: ,x_batch_step_activities => l_step_activity) THEN
1199: RAISE fnd_api.g_exc_error;
1200: END IF;

Line 1516: ,p_step_activity_rec IN gme_batch_step_activities%ROWTYPE

1512: Bharati Satpute Bug 2165993 1/09/2002 Incomprehensible error message when inserting a resource
1513: =============================================================================================*/
1514: PROCEDURE validate_resource (
1515: p_batch_step_rec IN gme_batch_steps%ROWTYPE
1516: ,p_step_activity_rec IN gme_batch_step_activities%ROWTYPE
1517: ,p_step_resources_rec IN gme_batch_step_resources%ROWTYPE
1518: ,p_check_prim_rsrc IN BOOLEAN := FALSE
1519: ,x_return_status OUT NOCOPY VARCHAR2)
1520: IS

Line 1703: FROM gme_batch_step_activities

1699: --Rishi 3446787/3020345 start
1700: CURSOR cur_get_activity (v_batchstep_activity_id NUMBER)
1701: IS
1702: SELECT activity
1703: FROM gme_batch_step_activities
1704: WHERE batchstep_activity_id = v_batchstep_activity_id;
1705:
1706: CURSOR cur_get_step_id (v_batchstep_activity_id NUMBER)
1707: IS

Line 1709: FROM gme_batch_step_activities

1705:
1706: CURSOR cur_get_step_id (v_batchstep_activity_id NUMBER)
1707: IS
1708: SELECT batchstep_id
1709: FROM gme_batch_step_activities
1710: WHERE batchstep_activity_id = v_batchstep_activity_id;
1711:
1712: CURSOR cur_get_batchstep_no (v_batchstep_id NUMBER)
1713: IS

Line 1718: l_activity gme_batch_step_activities.activity%TYPE;

1714: SELECT batchstep_no
1715: FROM gme_batch_steps
1716: WHERE batchstep_id = v_batchstep_id;
1717:
1718: l_activity gme_batch_step_activities.activity%TYPE;
1719: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
1720: l_step_id gme_batch_steps.batchstep_id%TYPE;
1721: --Rishi 3446787/3020345 end
1722: l_count NUMBER (5);

Line 1839: FROM gme_batch_step_activities

1835: v_batch_id NUMBER
1836: ,v_batchstep_id NUMBER)
1837: IS
1838: SELECT activity, batchstep_activity_id
1839: FROM gme_batch_step_activities
1840: WHERE batch_id = v_batch_id AND batchstep_id = v_batchstep_id;
1841:
1842: CURSOR cur_get_prim_rsrc_count (v_batchstep_activity_id NUMBER)
1843: IS

Line 2081: FROM gme_batch_step_activities

2077: ,v_activity VARCHAR2
2078: ,v_batch_id NUMBER)
2079: IS
2080: SELECT batchstep_activity_id
2081: FROM gme_batch_step_activities
2082: WHERE batchstep_id = v_step_id
2083: AND batch_id = v_batch_id
2084: AND activity = v_activity;
2085: