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_POST_MIGRATION dependencies on GME_BATCH_STEP_ITEMS

Line 1209: FROM gme_batch_step_items_mig

1205: PROCEDURE create_item_step_assoc(p_old_batch_id IN NUMBER,
1206: p_new_batch_id IN NUMBER) IS
1207: CURSOR Cur_item_assocs IS
1208: SELECT *
1209: FROM gme_batch_step_items_mig
1210: WHERE batch_id = p_old_batch_id;
1211: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1212: l_item_step_mig_tbl item_step_mig_tab;
1213: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;

Line 1211: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;

1207: CURSOR Cur_item_assocs IS
1208: SELECT *
1209: FROM gme_batch_step_items_mig
1210: WHERE batch_id = p_old_batch_id;
1211: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1212: l_item_step_mig_tbl item_step_mig_tab;
1213: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;
1214: l_item_step_tbl item_step_tab;
1215: l_api_name VARCHAR2(30) := 'create_item_step_assoc';

Line 1213: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;

1209: FROM gme_batch_step_items_mig
1210: WHERE batch_id = p_old_batch_id;
1211: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1212: l_item_step_mig_tbl item_step_mig_tab;
1213: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;
1214: l_item_step_tbl item_step_tab;
1215: l_api_name VARCHAR2(30) := 'create_item_step_assoc';
1216: BEGIN
1217: IF (g_debug <= gme_debug.g_log_procedure) THEN

Line 1238: INSERT INTO gme_batch_step_items VALUES l_item_step_tbl(a);

1234: l_item_step_tbl(i).minimum_delay := l_item_step_mig_tbl(i).minimum_delay;
1235: l_item_step_tbl(i).minimum_transfer_qty := l_item_step_mig_tbl(i).minimum_transfer_qty;
1236: END LOOP;
1237: FORALL a IN 1..l_item_step_tbl.count
1238: INSERT INTO gme_batch_step_items VALUES l_item_step_tbl(a);
1239: IF (g_debug <= gme_debug.g_log_procedure) THEN
1240: gme_debug.put_line('End procedure '||l_api_name);
1241: END IF;
1242: END create_item_step_assoc;

Line 3328: FROM gme_batch_step_items bsi, gme_material_details gmdn,

3324: AND s.step_status = gme_common_pvt.g_step_completed
3325: ORDER BY s.batch_id, s.batchstep_no;
3326: CURSOR Cur_verify_txns(v_batchstep_id NUMBER, v_old_batch_id NUMBER) IS
3327: SELECT 1
3328: FROM gme_batch_step_items bsi, gme_material_details gmdn,
3329: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp
3330: WHERE bsi.batchstep_id = v_batchstep_id
3331: AND gmdn.material_detail_id = bsi.material_detail_id
3332: AND gmdo.batch_id = v_old_batch_id