APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on BIC_PROFILE_VALUES_ALL

Line 32: g_attrition_period bic_profile_values_all.attrition_period % type;

28: --g_measure_code bic_measures_all.measure_code % type;
29: g_org_id bic_measures_all.org_id % type;
30:
31: -- Global value for Activation and attrition periods
32: g_attrition_period bic_profile_values_all.attrition_period % type;
33: g_activation_period bic_profile_values_all.activation_period % type;
34:
35: -- Global variables for measure codes
36: g_measure_id_for_retn bic_measures_all.measure_id % type;

Line 33: g_activation_period bic_profile_values_all.activation_period % type;

29: g_org_id bic_measures_all.org_id % type;
30:
31: -- Global value for Activation and attrition periods
32: g_attrition_period bic_profile_values_all.attrition_period % type;
33: g_activation_period bic_profile_values_all.activation_period % type;
34:
35: -- Global variables for measure codes
36: g_measure_id_for_retn bic_measures_all.measure_id % type;
37: g_measure_id_for_acqu bic_measures_all.measure_id % type;

Line 397: from bic_profile_values_all;

393:
394: function get_activation_period return boolean is
395: cursor profile_cur is
396: select nvl(activation_period,90)
397: from bic_profile_values_all;
398: begin
399: g_proc_name := 'Get_Profile_values';
400: open profile_cur;
401: fetch profile_cur into g_activation_period;

Line 403: --write_log('Bic_profile_values_all does not have any records.' ||

399: g_proc_name := 'Get_Profile_values';
400: open profile_cur;
401: fetch profile_cur into g_activation_period;
402: if profile_cur % notfound then
403: --write_log('Bic_profile_values_all does not have any records.' ||
404: -- 'Contact Your System Administrator.');
405: close profile_cur;
406: return(false);
407: end if;

Line 415: from bic_profile_values_all;

411:
412: function get_attrition_period return boolean is
413: cursor profile_cur is
414: select nvl(ATTRITION_PERIOD,2)
415: from bic_profile_values_all;
416: begin
417: g_proc_name_old := g_proc_name;
418: g_proc_name := 'Get_attrition_period';
419: write_log('get_attrition_period entered');

Line 423: -- write_log('Bic_profile_values_all does not have any records.' ||

419: write_log('get_attrition_period entered');
420: open profile_cur;
421: fetch profile_cur into g_attrition_period;
422: if profile_cur % notfound then
423: -- write_log('Bic_profile_values_all does not have any records.' ||
424: -- 'Contact Your System Administrator.');
425: close profile_cur;
426: g_proc_name := g_proc_name_old;
427: return(false);

Line 1732: generate_error(g_measure_code,'No records in BIC_PROFILE_VALUES_ALL');

1728: when measure_id_not_found then
1729: generate_error(g_measure_code,'Measure_id not found for RETENTION in the table BIC_MEASURES_ALL');
1730: Rollback;
1731: when attrition_period_not_found then
1732: generate_error(g_measure_code,'No records in BIC_PROFILE_VALUES_ALL');
1733: Rollback;
1734: when others then
1735: write_log(' Retention data is not extracted due to exception : '||sqlerrm);
1736: generate_error(g_measure_code,'Retention data is not extracted : '||sqlerrm);

Line 2155: generate_error('ACTIVATION','No records in BIC_PROFILE_VALUES_ALL');

2151: debug('exited -');
2152:
2153: EXCEPTION
2154: when activation_period_not_found then
2155: generate_error('ACTIVATION','No records in BIC_PROFILE_VALUES_ALL');
2156: rollback;
2157: when acquisition_not_found then
2158: generate_error('ACQUISITION','Measure_id not found for ACQUISITION in the table BIC_MEASURES_ALL');
2159: rollback;