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 305: DELETE FROM gme_resource_txns

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

Line 318: DELETE FROM gme_resource_txns_gtmp

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

Line 1248: UPDATE gme_resource_txns

1244: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1245: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1246:
1247: -- update batch resources txns start date
1248: UPDATE gme_resource_txns
1249: SET start_date = p_batch_header_rec.plan_start_date
1250: ,last_updated_by = gme_common_pvt.g_user_ident
1251: ,last_update_date = gme_common_pvt.g_timestamp
1252: ,last_update_login = gme_common_pvt.g_login_id

Line 1258: UPDATE gme_resource_txns

1254: AND doc_type = l_doc_type
1255: AND start_date < p_batch_header_rec.plan_start_date;
1256:
1257: -- update batch resources txns end date
1258: UPDATE gme_resource_txns
1259: SET end_date = p_batch_header_rec.plan_start_date
1260: ,last_updated_by = gme_common_pvt.g_user_ident
1261: ,last_update_date = gme_common_pvt.g_timestamp
1262: ,last_update_login = gme_common_pvt.g_login_id

Line 1268: UPDATE gme_resource_txns

1264: AND doc_type = l_doc_type
1265: AND end_date < p_batch_header_rec.plan_start_date;
1266:
1267: -- update batch resources txns trans date
1268: UPDATE gme_resource_txns
1269: SET trans_date = p_batch_header_rec.plan_start_date
1270: ,last_updated_by = gme_common_pvt.g_user_ident
1271: ,last_update_date = gme_common_pvt.g_timestamp
1272: ,last_update_login = gme_common_pvt.g_login_id

Line 1379: UPDATE gme_resource_txns

1375: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1376: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1377:
1378: -- update batch resources txns start date
1379: UPDATE gme_resource_txns
1380: SET start_date = p_batch_header_rec.plan_cmplt_date
1381: ,last_updated_by = gme_common_pvt.g_user_ident
1382: ,last_update_date = gme_common_pvt.g_timestamp
1383: ,last_update_login = gme_common_pvt.g_login_id

Line 1389: UPDATE gme_resource_txns

1385: AND doc_type = l_doc_type
1386: AND start_date > p_batch_header_rec.plan_cmplt_date;
1387:
1388: -- update batch resources txns end date
1389: UPDATE gme_resource_txns
1390: SET end_date = p_batch_header_rec.plan_cmplt_date
1391: ,last_updated_by = gme_common_pvt.g_user_ident
1392: ,last_update_date = gme_common_pvt.g_timestamp
1393: ,last_update_login = gme_common_pvt.g_login_id

Line 1399: UPDATE gme_resource_txns

1395: AND doc_type = l_doc_type
1396: AND end_date > p_batch_header_rec.plan_cmplt_date;
1397:
1398: -- update batch resources txns trans date
1399: UPDATE gme_resource_txns
1400: SET trans_date = p_batch_header_rec.plan_cmplt_date
1401: ,last_updated_by = gme_common_pvt.g_user_ident
1402: ,last_update_date = gme_common_pvt.g_timestamp
1403: ,last_update_login = gme_common_pvt.g_login_id