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_RESCHEDULE_BATCH_PVT dependencies on GME_RESOURCE_TXNS

Line 308: DELETE FROM gme_resource_txns

304: END IF;
305:
306: -- delete all the pending resource transactions
307: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN
308: DELETE FROM gme_resource_txns
309: WHERE doc_id = x_batch_header_rec.batch_id
310: AND doc_type = l_doc_type
311: AND line_id IN (
312: SELECT batchstep_resource_id

Line 321: DELETE FROM gme_resource_txns_gtmp

317: FROM gme_batch_steps
318: WHERE batch_id =
319: x_batch_header_rec.batch_id
320: AND step_status = 1) );
321: DELETE FROM gme_resource_txns_gtmp
322: WHERE doc_id = x_batch_header_rec.batch_id
323: AND doc_type = l_doc_type
324: AND line_id IN (
325: SELECT batchstep_resource_id

Line 1271: UPDATE gme_resource_txns

1267: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1268: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1269:
1270: -- update batch resources txns start date
1271: UPDATE gme_resource_txns
1272: SET start_date = p_batch_header_rec.plan_start_date
1273: ,last_updated_by = gme_common_pvt.g_user_ident
1274: ,last_update_date = gme_common_pvt.g_timestamp
1275: ,last_update_login = gme_common_pvt.g_login_id

Line 1281: UPDATE gme_resource_txns

1277: AND doc_type = l_doc_type
1278: AND start_date < p_batch_header_rec.plan_start_date;
1279:
1280: -- update batch resources txns end date
1281: UPDATE gme_resource_txns
1282: SET end_date = p_batch_header_rec.plan_start_date
1283: ,last_updated_by = gme_common_pvt.g_user_ident
1284: ,last_update_date = gme_common_pvt.g_timestamp
1285: ,last_update_login = gme_common_pvt.g_login_id

Line 1291: UPDATE gme_resource_txns

1287: AND doc_type = l_doc_type
1288: AND end_date < p_batch_header_rec.plan_start_date;
1289:
1290: -- update batch resources txns trans date
1291: UPDATE gme_resource_txns
1292: SET trans_date = p_batch_header_rec.plan_start_date
1293: ,last_updated_by = gme_common_pvt.g_user_ident
1294: ,last_update_date = gme_common_pvt.g_timestamp
1295: ,last_update_login = gme_common_pvt.g_login_id

Line 1402: UPDATE gme_resource_txns

1398: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1399: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1400:
1401: -- update batch resources txns start date
1402: UPDATE gme_resource_txns
1403: SET start_date = p_batch_header_rec.plan_cmplt_date
1404: ,last_updated_by = gme_common_pvt.g_user_ident
1405: ,last_update_date = gme_common_pvt.g_timestamp
1406: ,last_update_login = gme_common_pvt.g_login_id

Line 1412: UPDATE gme_resource_txns

1408: AND doc_type = l_doc_type
1409: AND start_date > p_batch_header_rec.plan_cmplt_date;
1410:
1411: -- update batch resources txns end date
1412: UPDATE gme_resource_txns
1413: SET end_date = p_batch_header_rec.plan_cmplt_date
1414: ,last_updated_by = gme_common_pvt.g_user_ident
1415: ,last_update_date = gme_common_pvt.g_timestamp
1416: ,last_update_login = gme_common_pvt.g_login_id

Line 1422: UPDATE gme_resource_txns

1418: AND doc_type = l_doc_type
1419: AND end_date > p_batch_header_rec.plan_cmplt_date;
1420:
1421: -- update batch resources txns trans date
1422: UPDATE gme_resource_txns
1423: SET trans_date = p_batch_header_rec.plan_cmplt_date
1424: ,last_updated_by = gme_common_pvt.g_user_ident
1425: ,last_update_date = gme_common_pvt.g_timestamp
1426: ,last_update_login = gme_common_pvt.g_login_id