APPS.BIC_CONSOLIDATE_CUST_DATA_PKG dependencies on BIC_CUSTOMER_SUMMARY_ALL

Line 11: -- which have any data in bic_customer_summary_all

7:
8: procedure populate_party_data (p_start_date date,
9: p_end_date date) is
10: -- For a given date range, This cursor gets all parties,orgs and period,
11: -- which have any data in bic_customer_summary_all
12: cursor c_parties is
13: select distinct customer_id, org_id, period_start_date
14: from bic_customer_summary_all
15: where period_start_date between p_start_date and p_end_date;

Line 14: from bic_customer_summary_all

10: -- For a given date range, This cursor gets all parties,orgs and period,
11: -- which have any data in bic_customer_summary_all
12: cursor c_parties is
13: select distinct customer_id, org_id, period_start_date
14: from bic_customer_summary_all
15: where period_start_date between p_start_date and p_end_date;
16:
17: -- This cursor gets measure_code and its value for a party, org and period
18: cursor c_measure_values is

Line 20: from bic_customer_summary_all

16:
17: -- This cursor gets measure_code and its value for a party, org and period
18: cursor c_measure_values is
19: select measure_code, value
20: from bic_customer_summary_all
21: where period_start_date = g_date
22: and customer_id = g_party_id
23: and nvl(org_id,-99) = nvl(g_org_id,-99);
24:

Line 115: l_measure_value bic_customer_summary_all.value % type;

111: l_TOTAL_SR_RESPONSE_TIME number;
112:
113:
114: l_measure_code bic_measure_attribs.measure_code % type;
115: l_measure_value bic_customer_summary_all.value % type;
116: begin
117: g_date := to_date('01-01-1999','dd-mm-yyyy') ;
118: open c_parties;
119: loop

Line 658: -- which have any data in bic_customer_summary_all

654: ----
655: procedure populate_status_data (p_start_date date,
656: p_end_date date, p_measure_code varchar2) is
657: -- For a given date range, This cursor gets all parties and period,
658: -- which have any data in bic_customer_summary_all
659: cursor c_parties is
660: select distinct party_id, period_start_date
661: from bic_party_summary
662: where period_start_date between p_start_date and p_end_date;

Line 684: l_measure_value bic_customer_summary_all.value % type;

680: l_RETENTION number;
681: l_LIFE_CYCLE number;
682:
683: l_measure_code bic_measure_attribs.measure_code % type;
684: l_measure_value bic_customer_summary_all.value % type;
685: x_err varchar2(2000);
686: begin
687: g_date := to_date('01-01-1999','dd-mm-yyyy') ;
688: open c_parties;

Line 807: -- delete records from bic_customer_summary_all

803: end main_proc;
804: procedure purge_summary_data (p_start_date date,
805: p_end_date date) is
806: begin
807: -- delete records from bic_customer_summary_all
808: delete from bic_customer_summary_all
809: where period_start_date between p_start_date and p_end_date;
810: commit;
811:

Line 808: delete from bic_customer_summary_all

804: procedure purge_summary_data (p_start_date date,
805: p_end_date date) is
806: begin
807: -- delete records from bic_customer_summary_all
808: delete from bic_customer_summary_all
809: where period_start_date between p_start_date and p_end_date;
810: commit;
811:
812: -- delete records from bic_party_summary

Line 830: -- delete records from bic_customer_summary_all

826:
827: procedure purge_customer_summary_data is
828: begin
829:
830: -- delete records from bic_customer_summary_all
831: delete
832: from bic_customer_summary_all;
833: -- commit;
834:

Line 832: from bic_customer_summary_all;

828: begin
829:
830: -- delete records from bic_customer_summary_all
831: delete
832: from bic_customer_summary_all;
833: -- commit;
834:
835: end purge_customer_summary_data;
836: -- End of packqage body