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.CSD_MIGRATE_FROM_115X_PKG3 dependencies on CSD_REPAIR_JOB_XREF

Line 2253: /* procedure name: CSD_REPAIR_JOB_XREF_MIG3 */

2249: END csd_acttoest_charge_line_mig3;
2250:
2251: /*-------------------------------------------------------------------------------*/
2252:
2253: /* procedure name: CSD_REPAIR_JOB_XREF_MIG3 */
2254:
2255: /* description : procedure for migrating CSD_REPAIR_JOB_XREF table data */
2256:
2257: /* from 11.5.9 to 11.5.10 */

Line 2255: /* description : procedure for migrating CSD_REPAIR_JOB_XREF table data */

2251: /*-------------------------------------------------------------------------------*/
2252:
2253: /* procedure name: CSD_REPAIR_JOB_XREF_MIG3 */
2254:
2255: /* description : procedure for migrating CSD_REPAIR_JOB_XREF table data */
2256:
2257: /* from 11.5.9 to 11.5.10 */
2258:
2259: /* */

Line 2263: PROCEDURE csd_repair_job_xref_mig3(p_slab_number IN NUMBER)

2259: /* */
2260:
2261: /*-------------------------------------------------------------------------------*/
2262:
2263: PROCEDURE csd_repair_job_xref_mig3(p_slab_number IN NUMBER)
2264: IS
2265:
2266: TYPE NumTabType IS VARRAY(1000) OF NUMBER;
2267: repair_job_xref_id_mig NumTabType;

Line 2284: FROM csd_repair_job_xref

2280:
2281: CURSOR get_job_name_id_rows_cursor (p_start number, p_end number)
2282: IS
2283: SELECT repair_job_xref_id, rowid
2284: FROM csd_repair_job_xref
2285: WHERE wip_entity_id = group_id AND repair_job_xref_id >= p_start
2286: AND repair_job_xref_id <= p_end;
2287:
2288:

Line 2294: FROM csd_repair_job_xref

2290:
2291: CURSOR get_source_type_rows_cursor (p_start number, p_end number)
2292: IS
2293: SELECT repair_job_xref_id, rowid
2294: FROM csd_repair_job_xref
2295: WHERE source_type_code IS NULL AND repair_job_xref_id >= p_start
2296: AND repair_job_xref_id <= p_end;
2297:
2298: BEGIN

Line 2303: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIR_JOB_XREF',

2299:
2300: -- Get the Slab Number for the table
2301:
2302: BEGIN
2303: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIR_JOB_XREF',
2304: 'CSD',
2305: p_slab_number,
2306: v_min,
2307: v_max);

Line 2316: -- Migration code for Job_name and WIP_entity_id in CSD_REPAIR_JOB_XREF

2312: END IF;
2313:
2314: END;
2315:
2316: -- Migration code for Job_name and WIP_entity_id in CSD_REPAIR_JOB_XREF
2317:
2318: OPEN get_job_name_id_rows_cursor (v_min, v_max);
2319:
2320: LOOP

Line 2329: SAVEPOINT CSD_REPAIR_JOB_XREF;

2325: FETCH get_job_name_id_rows_cursor BULK COLLECT INTO repair_job_xref_id_mig,
2326: rowid_mig LIMIT MAX_BUFFER_SIZE;
2327: FOR j IN 1..repair_job_xref_id_mig.COUNT
2328: LOOP
2329: SAVEPOINT CSD_REPAIR_JOB_XREF;
2330:
2331: BEGIN
2332:
2333: -- Update wip_entity_id to NULL and

Line 2336: UPDATE csd_repair_job_xref

2332:
2333: -- Update wip_entity_id to NULL and
2334: -- job name to CSD||group_id
2335:
2336: UPDATE csd_repair_job_xref
2337: SET wip_entity_id = NULL,
2338: job_name = 'CSD' || group_id
2339: WHERE rowid = rowid_mig(j);
2340:

Line 2348: ROLLBACK TO CSD_REPAIR_JOB_XREF;

2344: END IF;
2345:
2346: EXCEPTION
2347: WHEN error_process THEN
2348: ROLLBACK TO CSD_REPAIR_JOB_XREF;
2349: v_error_text := substr(sqlerrm, 1, 1000)
2350: || 'Repair Job Xref Id:'
2351: || repair_job_xref_id_mig(j);
2352:

Line 2360: VALUES ('CSD_REPAIR_JOB_XREF',

2356: ORIG_SYSTEM_REFERENCE_ID,
2357: UPGRADE_DATETIME,
2358: ERROR_MESSAGE,
2359: MIGRATION_PHASE)
2360: VALUES ('CSD_REPAIR_JOB_XREF',
2361: 'CSD_REPAIR_JOB_XREF',
2362: repair_job_xref_id_mig(j),
2363: sysdate,
2364: v_error_text,

Line 2361: 'CSD_REPAIR_JOB_XREF',

2357: UPGRADE_DATETIME,
2358: ERROR_MESSAGE,
2359: MIGRATION_PHASE)
2360: VALUES ('CSD_REPAIR_JOB_XREF',
2361: 'CSD_REPAIR_JOB_XREF',
2362: repair_job_xref_id_mig(j),
2363: sysdate,
2364: v_error_text,
2365: '11.5.10');

Line 2369: raise_application_error( -20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data: Error while updating csd_repair_job_xref. '|| v_error_text);

2365: '11.5.10');
2366:
2367: commit;
2368:
2369: raise_application_error( -20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data: Error while updating csd_repair_job_xref. '|| v_error_text);
2370:
2371: END;
2372: END LOOP;
2373: COMMIT;

Line 2382: -- Migration code for SOURCE_TYPE_CODE in CSD_REPAIR_JOB_XREF

2378: THEN
2379: CLOSE get_job_name_id_rows_cursor;
2380: END IF;
2381:
2382: -- Migration code for SOURCE_TYPE_CODE in CSD_REPAIR_JOB_XREF
2383:
2384: OPEN get_source_type_rows_cursor (v_min, v_max);
2385:
2386: LOOP

Line 2394: SAVEPOINT CSD_REPAIR_JOB_XREF;

2390: FETCH get_source_type_rows_cursor BULK COLLECT INTO repair_job_xref_id_mig,
2391: rowid_mig LIMIT MAX_BUFFER_SIZE;
2392: FOR j IN 1..repair_job_xref_id_mig.COUNT
2393: LOOP
2394: SAVEPOINT CSD_REPAIR_JOB_XREF;
2395:
2396: BEGIN
2397:
2398: -- Update source_type_code to MANUAL

Line 2400: UPDATE csd_repair_job_xref

2396: BEGIN
2397:
2398: -- Update source_type_code to MANUAL
2399:
2400: UPDATE csd_repair_job_xref
2401: SET source_type_code = 'MANUAL'
2402: WHERE rowid = rowid_mig(j);
2403:
2404: IF SQL%NOTFOUND

Line 2411: ROLLBACK TO CSD_REPAIR_JOB_XREF;

2407: END IF;
2408:
2409: EXCEPTION
2410: WHEN error_process THEN
2411: ROLLBACK TO CSD_REPAIR_JOB_XREF;
2412: v_error_text := substr(sqlerrm, 1, 1000)
2413: || 'Repair Job Xref Id:'
2414: || repair_job_xref_id_mig(j);
2415:

Line 2423: VALUES ('CSD_REPAIR_JOB_XREF',

2419: ORIG_SYSTEM_REFERENCE_ID,
2420: UPGRADE_DATETIME,
2421: ERROR_MESSAGE,
2422: MIGRATION_PHASE)
2423: VALUES ('CSD_REPAIR_JOB_XREF',
2424: 'CSD_REPAIR_JOB_XREF',
2425: repair_job_xref_id_mig(j),
2426: sysdate,
2427: v_error_text,

Line 2424: 'CSD_REPAIR_JOB_XREF',

2420: UPGRADE_DATETIME,
2421: ERROR_MESSAGE,
2422: MIGRATION_PHASE)
2423: VALUES ('CSD_REPAIR_JOB_XREF',
2424: 'CSD_REPAIR_JOB_XREF',
2425: repair_job_xref_id_mig(j),
2426: sysdate,
2427: v_error_text,
2428: '11.5.10');

Line 2432: raise_application_error( -20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data: Error while updating csd_repair_job_xref. '|| v_error_text);

2428: '11.5.10');
2429:
2430: commit;
2431:
2432: raise_application_error( -20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data: Error while updating csd_repair_job_xref. '|| v_error_text);
2433:
2434: END;
2435: END LOOP;
2436: COMMIT;

Line 2445: END csd_repair_job_xref_mig3;

2441: THEN
2442: CLOSE get_source_type_rows_cursor;
2443: END IF;
2444: COMMIT;
2445: END csd_repair_job_xref_mig3;
2446:
2447:
2448: /*-------------------------------------------------------------------------------*/
2449: /* procedure name: CSD_REPAIR_TYPE_MIG3 */