DBA Data[Home] [Help]

APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on FND_GLOBAL

Line 7838: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;

7834: createR12UpgradeJob(g_audsid, g_pdoi_batch_id);
7835: ELSE
7836: l_err_loc := 1200;
7837: -- Pre-upgrade / Data-exceptions call.
7838: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;
7839: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;
7840: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;
7841: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;
7842: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;

Line 7839: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;

7835: ELSE
7836: l_err_loc := 1200;
7837: -- Pre-upgrade / Data-exceptions call.
7838: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;
7839: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;
7840: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;
7841: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;
7842: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;
7843:

Line 7840: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;

7836: l_err_loc := 1200;
7837: -- Pre-upgrade / Data-exceptions call.
7838: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;
7839: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;
7840: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;
7841: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;
7842: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;
7843:
7844: l_err_loc := 1300;

Line 7841: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;

7837: -- Pre-upgrade / Data-exceptions call.
7838: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;
7839: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;
7840: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;
7841: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;
7842: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;
7843:
7844: l_err_loc := 1300;
7845: IF (p_current_program = ICX_CAT_UTIL_PVT.g_pre_upgrade_program) THEN

Line 7842: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;

7838: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;
7839: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;
7840: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;
7841: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;
7842: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;
7843:
7844: l_err_loc := 1300;
7845: IF (p_current_program = ICX_CAT_UTIL_PVT.g_pre_upgrade_program) THEN
7846: ICX_CAT_UTIL_PVT.g_job_type := ICX_CAT_UTIL_PVT.g_pre_upgrade_program;

Line 7847: ICX_CAT_UTIL_PVT.g_job_number := fnd_global.conc_request_id;

7843:
7844: l_err_loc := 1300;
7845: IF (p_current_program = ICX_CAT_UTIL_PVT.g_pre_upgrade_program) THEN
7846: ICX_CAT_UTIL_PVT.g_job_type := ICX_CAT_UTIL_PVT.g_pre_upgrade_program;
7847: ICX_CAT_UTIL_PVT.g_job_number := fnd_global.conc_request_id;
7848: ELSIF (p_current_program = ICX_CAT_UTIL_PVT.g_data_exception_program) THEN
7849: l_err_loc := 1400;
7850: ICX_CAT_UTIL_PVT.g_job_type := ICX_CAT_UTIL_PVT.g_data_exception_program;
7851: ICX_CAT_UTIL_PVT.g_job_number := fnd_global.conc_request_id;

Line 7851: ICX_CAT_UTIL_PVT.g_job_number := fnd_global.conc_request_id;

7847: ICX_CAT_UTIL_PVT.g_job_number := fnd_global.conc_request_id;
7848: ELSIF (p_current_program = ICX_CAT_UTIL_PVT.g_data_exception_program) THEN
7849: l_err_loc := 1400;
7850: ICX_CAT_UTIL_PVT.g_job_type := ICX_CAT_UTIL_PVT.g_data_exception_program;
7851: ICX_CAT_UTIL_PVT.g_job_number := fnd_global.conc_request_id;
7852: END IF;
7853: END IF;
7854:
7855: l_err_loc := 1500;

Line 8051: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,

8047: -- insert only if row doesn't exist
8048: INSERT INTO fnd_profile_option_values
8049: (application_id, profile_option_id, level_id, level_value, last_update_date,
8050: last_updated_by, creation_date, created_by, last_update_login, profile_option_value)
8051: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,
8052: sysdate, fnd_global.user_id, fnd_global.login_id, 'Relevance'
8053: FROM dual
8054: WHERE NOT EXISTS (SELECT 1
8055: FROM fnd_profile_option_values

Line 8052: sysdate, fnd_global.user_id, fnd_global.login_id, 'Relevance'

8048: INSERT INTO fnd_profile_option_values
8049: (application_id, profile_option_id, level_id, level_value, last_update_date,
8050: last_updated_by, creation_date, created_by, last_update_login, profile_option_value)
8051: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,
8052: sysdate, fnd_global.user_id, fnd_global.login_id, 'Relevance'
8053: FROM dual
8054: WHERE NOT EXISTS (SELECT 1
8055: FROM fnd_profile_option_values
8056: WHERE application_id = l_application_id

Line 8072: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,

8068: -- insert only if row doesn't exist
8069: INSERT INTO fnd_profile_option_values
8070: (application_id, profile_option_id, level_id, level_value, last_update_date,
8071: last_updated_by, creation_date, created_by, last_update_login, profile_option_value)
8072: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,
8073: sysdate, fnd_global.user_id, fnd_global.login_id, 'DESC'
8074: FROM dual
8075: WHERE NOT EXISTS (SELECT 1
8076: FROM fnd_profile_option_values

Line 8073: sysdate, fnd_global.user_id, fnd_global.login_id, 'DESC'

8069: INSERT INTO fnd_profile_option_values
8070: (application_id, profile_option_id, level_id, level_value, last_update_date,
8071: last_updated_by, creation_date, created_by, last_update_login, profile_option_value)
8072: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,
8073: sysdate, fnd_global.user_id, fnd_global.login_id, 'DESC'
8074: FROM dual
8075: WHERE NOT EXISTS (SELECT 1
8076: FROM fnd_profile_option_values
8077: WHERE application_id = l_application_id

Line 8209: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;

8205:
8206: l_err_loc := 300;
8207: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id := ICX_CAT_UTIL_PVT.g_upgrade_user;
8208: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := p_parent_int_req_id;
8209: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;
8210: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;
8211: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;
8212: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;
8213: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;

Line 8210: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;

8206: l_err_loc := 300;
8207: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id := ICX_CAT_UTIL_PVT.g_upgrade_user;
8208: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := p_parent_int_req_id;
8209: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;
8210: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;
8211: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;
8212: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;
8213: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;
8214:

Line 8211: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;

8207: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id := ICX_CAT_UTIL_PVT.g_upgrade_user;
8208: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := p_parent_int_req_id;
8209: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;
8210: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;
8211: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;
8212: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;
8213: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;
8214:
8215: l_err_loc := 400;

Line 8212: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;

8208: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := p_parent_int_req_id;
8209: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;
8210: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;
8211: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;
8212: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;
8213: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;
8214:
8215: l_err_loc := 400;
8216: -- Set the global commit parameter

Line 8213: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;

8209: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := fnd_global.login_id;
8210: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := fnd_global.conc_request_id;
8211: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := fnd_global.prog_appl_id;
8212: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := fnd_global.conc_program_id;
8213: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := fnd_global.conc_login_id;
8214:
8215: l_err_loc := 400;
8216: -- Set the global commit parameter
8217: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);