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.ICX_CAT_R12_UPGRADE_PVT dependencies on ICX_CAT_R12_UPGRADE_JOBS

Line 7869: FROM icx_cat_r12_upgrade_jobs

7865: g_bpa_last_run_date,
7866: g_quote_last_run_date,
7867: g_reqtmplt_last_run_date,
7868: g_mi_last_run_date
7869: FROM icx_cat_r12_upgrade_jobs
7870: -- Check within jobs that are not data exception
7871: -- OR child data exception process ( which will be submitted from pre-upgrade program)
7872: WHERE job_type NOT IN (ICX_CAT_UTIL_PVT.g_data_exception_program,
7873: ICX_CAT_UTIL_PVT.g_child_data_excptn_program);

Line 8277: INSERT INTO icx_cat_r12_upgrade_jobs

8273: l_api_name CONSTANT VARCHAR2(30) := 'createR12UpgradeJob';
8274: l_err_loc PLS_INTEGER;
8275: BEGIN
8276: l_err_loc := 100;
8277: INSERT INTO icx_cat_r12_upgrade_jobs
8278: (job_type, job_number, status, run_date, audsid, pdoi_batch_id,
8279: last_update_login, last_updated_by, last_update_date,
8280: created_by, creation_date, internal_request_id, request_id,
8281: program_application_id, program_id, program_login_id)

Line 8293: WHERE NOT EXISTS (SELECT 'x' FROM icx_cat_r12_upgrade_jobs

8289: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
8290: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
8291: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
8292: FROM DUAL
8293: WHERE NOT EXISTS (SELECT 'x' FROM icx_cat_r12_upgrade_jobs
8294: WHERE job_type = ICX_CAT_UTIL_PVT.g_job_type
8295: AND job_number = ICX_CAT_UTIL_PVT.g_job_number );
8296:
8297: l_err_loc := 200;

Line 8320: UPDATE icx_cat_r12_upgrade_jobs

8316: l_row_count PLS_INTEGER;
8317: BEGIN
8318: l_err_loc := 100;
8319: IF ( p_job_status = ICX_CAT_UTIL_PVT.g_job_running_status) THEN
8320: UPDATE icx_cat_r12_upgrade_jobs
8321: SET status = p_job_status,
8322: audsid = g_audsid,
8323: pdoi_batch_id = g_PDOI_batch_id,
8324: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,

Line 8340: UPDATE icx_cat_r12_upgrade_jobs

8336: -- we need to update the pdoi_update_date and pdoi_complete_date
8337: -- because when the parent is re-started, it is re-started in a
8338: -- new session and these global varaibles are lost
8339: l_err_loc := 200;
8340: UPDATE icx_cat_r12_upgrade_jobs
8341: SET preupg_pdoi_update_date = ICX_CAT_UTIL_PVT.g_job_pdoi_update_date,
8342: preupg_pdoi_complete_date = ICX_CAT_UTIL_PVT.g_job_pdoi_complete_date
8343: WHERE job_type = ICX_CAT_UTIL_PVT.g_job_type
8344: AND job_number = ICX_CAT_UTIL_PVT.g_job_number;

Line 8348: UPDATE icx_cat_r12_upgrade_jobs

8344: AND job_number = ICX_CAT_UTIL_PVT.g_job_number;
8345: ELSE
8346: -- i.e. completed / failed status
8347: l_err_loc := 300;
8348: UPDATE icx_cat_r12_upgrade_jobs
8349: SET status = p_job_status,
8350: audsid2 = p_audsid2,
8351: preupg_complete_date = ICX_CAT_UTIL_PVT.g_job_complete_date,
8352: preupg_pdoi_update_date = NVL(ICX_CAT_UTIL_PVT.g_job_pdoi_update_date, preupg_pdoi_update_date),

Line 8369: '; No: of rows updated in icx_cat_r12_upgrade_jobs:' || l_row_count);

8365: l_err_loc := 500;
8366: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8367: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8368: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8369: '; No: of rows updated in icx_cat_r12_upgrade_jobs:' || l_row_count);
8370: END IF;
8371:
8372: l_err_loc := 600;
8373: COMMIT;