APPS.OTA_CRT_BUS dependencies on OTA_GENERAL

Line 421: l_init_compl_date_changed := ota_general.value_changed(l_old_init_compl_date,

417: FETCH csr_old_cert into l_old_init_compl_date, l_old_init_compl_duration,
418: l_old_renew_duration, l_old_valid_duration, l_old_start_type, l_old_renew_flag;
419: CLOSE csr_old_cert;
420:
421: l_init_compl_date_changed := ota_general.value_changed(l_old_init_compl_date,
422: p_initial_completion_date);
423:
424: l_init_compl_dur_changed := ota_general.value_changed(l_old_init_compl_duration,
425: p_initial_completion_duration);

Line 424: l_init_compl_dur_changed := ota_general.value_changed(l_old_init_compl_duration,

420:
421: l_init_compl_date_changed := ota_general.value_changed(l_old_init_compl_date,
422: p_initial_completion_date);
423:
424: l_init_compl_dur_changed := ota_general.value_changed(l_old_init_compl_duration,
425: p_initial_completion_duration);
426:
427: l_renew_dur_changed := ota_general.value_changed(l_old_renew_duration,
428: p_renewal_duration);

Line 427: l_renew_dur_changed := ota_general.value_changed(l_old_renew_duration,

423:
424: l_init_compl_dur_changed := ota_general.value_changed(l_old_init_compl_duration,
425: p_initial_completion_duration);
426:
427: l_renew_dur_changed := ota_general.value_changed(l_old_renew_duration,
428: p_renewal_duration);
429:
430: l_valid_dur_changed := ota_general.value_changed(l_old_valid_duration,
431: p_validity_duration);

Line 430: l_valid_dur_changed := ota_general.value_changed(l_old_valid_duration,

426:
427: l_renew_dur_changed := ota_general.value_changed(l_old_renew_duration,
428: p_renewal_duration);
429:
430: l_valid_dur_changed := ota_general.value_changed(l_old_valid_duration,
431: p_validity_duration);
432:
433: l_start_type_changed := ota_general.value_changed(l_old_start_type,
434: p_validity_start_type);

Line 433: l_start_type_changed := ota_general.value_changed(l_old_start_type,

429:
430: l_valid_dur_changed := ota_general.value_changed(l_old_valid_duration,
431: p_validity_duration);
432:
433: l_start_type_changed := ota_general.value_changed(l_old_start_type,
434: p_validity_start_type);
435:
436: l_renew_flag_changed := ota_general.value_changed(l_old_renew_flag,
437: p_renewable_flag);

Line 436: l_renew_flag_changed := ota_general.value_changed(l_old_renew_flag,

432:
433: l_start_type_changed := ota_general.value_changed(l_old_start_type,
434: p_validity_start_type);
435:
436: l_renew_flag_changed := ota_general.value_changed(l_old_renew_flag,
437: p_renewable_flag);
438:
439: p_return_status := 'S';
440:

Line 1071: l_init_compl_date_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_date,

1067: FETCH csr_exis_subscr into l_subscr_exists;
1068: CLOSE csr_exis_subscr;
1069:
1070: if l_subscr_exists = 'Y' then
1071: l_init_compl_date_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_date,
1072: p_initial_completion_date);
1073:
1074: l_init_compl_dur_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_duration,
1075: p_initial_completion_duration);

Line 1074: l_init_compl_dur_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_duration,

1070: if l_subscr_exists = 'Y' then
1071: l_init_compl_date_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_date,
1072: p_initial_completion_date);
1073:
1074: l_init_compl_dur_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_duration,
1075: p_initial_completion_duration);
1076:
1077: l_renew_flag_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.renewable_flag,
1078: p_renewable_flag);

Line 1077: l_renew_flag_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.renewable_flag,

1073:
1074: l_init_compl_dur_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.initial_completion_duration,
1075: p_initial_completion_duration);
1076:
1077: l_renew_flag_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.renewable_flag,
1078: p_renewable_flag);
1079:
1080: l_notify_days_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.notify_days_before_expire,
1081: p_notify_days);

Line 1080: l_notify_days_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.notify_days_before_expire,

1076:
1077: l_renew_flag_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.renewable_flag,
1078: p_renewable_flag);
1079:
1080: l_notify_days_changed := ota_general.value_changed(ota_crt_shd.g_old_rec.notify_days_before_expire,
1081: p_notify_days);
1082:
1083: if l_init_compl_date_changed OR l_init_compl_dur_changed
1084: OR l_renew_flag_changed OR l_notify_days_changed