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.BIC_SUMMARY_EXTRACT_PKG dependencies on BIC_CONSOLIDATE_CUST_DATA_PKG

Line 1239: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);

1235:
1236: extract_proc('SATISFACTION');
1237:
1238:
1239: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);
1240: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
1241:
1242:
1243: Commit;

Line 1240: bic_consolidate_cust_data_pkg.purge_customer_summary_data;

1236: extract_proc('SATISFACTION');
1237:
1238:
1239: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);
1240: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
1241:
1242:
1243: Commit;
1244:

Line 1280: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);

1276: end if;
1277: extract_proc('LOYALTY');
1278:
1279:
1280: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);
1281:
1282: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
1283:
1284:

Line 1282: bic_consolidate_cust_data_pkg.purge_customer_summary_data;

1278:
1279:
1280: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);
1281:
1282: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
1283:
1284:
1285: Commit;
1286: write_log('Loyalty extraction completed');

Line 1672: bic_consolidate_cust_data_pkg.purge_party_summary_data;

1668: write_log('Before Retention Extraction...');
1669: --write_log(' procedure '||g_proc_name || ' entered at : '||sysdate);
1670: bic_summary_extract_pkg.debug(' entered + : ');
1671:
1672: bic_consolidate_cust_data_pkg.purge_party_summary_data;
1673: g_measure_id_for_retn := get_measure_id('RETENTION');
1674: if g_measure_id_for_retn = 0 then
1675: raise measure_id_not_found;
1676: write_log('Error: Measure_id not found for RETENTION');

Line 1715: bic_consolidate_cust_data_pkg.populate_status_data (g_period_start_date,g_period_end_date);

1711: debug('calling retention churned In Extract_Retention...');
1712: retention_churned ;
1713:
1714:
1715: bic_consolidate_cust_data_pkg.populate_status_data (g_period_start_date,g_period_end_date);
1716:
1717: bic_consolidate_cust_data_pkg.purge_party_summary_data;
1718:
1719: Commit;

Line 1717: bic_consolidate_cust_data_pkg.purge_party_summary_data;

1713:
1714:
1715: bic_consolidate_cust_data_pkg.populate_status_data (g_period_start_date,g_period_end_date);
1716:
1717: bic_consolidate_cust_data_pkg.purge_party_summary_data;
1718:
1719: Commit;
1720:
1721: write_log('Total Records Added for retention:'||to_char(g_tot_recs_added) );

Line 1750: bic_consolidate_cust_data_pkg.purge_customer_summary_data;

1746: lf_flag := 'N';
1747: else
1748: lf_flag := p_lf_flag;
1749: end if;
1750: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
1751: g_proc_name_old := g_proc_name;
1752: g_proc_name := 'Extract_sales_data';
1753:
1754: bic_summary_extract_pkg.debug(g_proc_name||' entered + ');

Line 1838: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);

1834: write_log('transferring data to summary tables');
1835: rec_count := 0;
1836: rec_count := sql%rowcount;
1837: if lf_flag = 'N' then
1838: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);
1839:
1840: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
1841:
1842:

Line 1840: bic_consolidate_cust_data_pkg.purge_customer_summary_data;

1836: rec_count := sql%rowcount;
1837: if lf_flag = 'N' then
1838: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);
1839:
1840: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
1841:
1842:
1843: Commit;
1844: end if;

Line 1864: bic_consolidate_cust_data_pkg.purge_customer_summary_data;

1860: g_proc_name_old := g_proc_name;
1861: g_proc_name := 'Extract_cogs_data';
1862: --g_proc_name := 'Extract_Main';
1863: write_log('Before Cogs Extraction...');
1864: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
1865: bic_summary_extract_pkg.debug(g_proc_name||' entered + ');
1866: if( fnd_log.test(1,g_proc_name) = false ) then
1867: write_log('logging not enabled');
1868: end if;

Line 1944: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);

1940: hca.party_id,
1941: bdt.act_period_start_date,
1942: bma.org_id;
1943:
1944: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);
1945: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
1946: rec_count := sql%rowcount;
1947:
1948: Commit;

Line 1945: bic_consolidate_cust_data_pkg.purge_customer_summary_data;

1941: bdt.act_period_start_date,
1942: bma.org_id;
1943:
1944: bic_consolidate_cust_data_pkg.populate_party_data (g_period_start_date,g_period_end_date);
1945: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
1946: rec_count := sql%rowcount;
1947:
1948: Commit;
1949:

Line 1983: bic_consolidate_cust_data_pkg.purge_party_summary_data;

1979: g_tot_recs_added := 0;
1980: rec_count := 0;
1981:
1982: debug('entered +');
1983: bic_consolidate_cust_data_pkg.purge_party_summary_data;
1984:
1985: if (get_activation_period = false) then
1986: write_log('Error: activation_period for ACQUISITION not defined');
1987: RAISE activation_period_not_found;

Line 2147: bic_consolidate_cust_data_pkg.populate_status_data(g_period_start_date,g_period_end_date);

2143: write_log('Total Records Added for Activation:'||
2144: to_char(sql%rowcount));
2145: g_proc_name := g_proc_name_old;
2146:
2147: bic_consolidate_cust_data_pkg.populate_status_data(g_period_start_date,g_period_end_date);
2148: bic_consolidate_cust_data_pkg.purge_party_summary_data;
2149:
2150: commit;
2151: debug('exited -');

Line 2148: bic_consolidate_cust_data_pkg.purge_party_summary_data;

2144: to_char(sql%rowcount));
2145: g_proc_name := g_proc_name_old;
2146:
2147: bic_consolidate_cust_data_pkg.populate_status_data(g_period_start_date,g_period_end_date);
2148: bic_consolidate_cust_data_pkg.purge_party_summary_data;
2149:
2150: commit;
2151: debug('exited -');
2152:

Line 2295: bic_consolidate_cust_data_pkg.update_market_segment;

2291: );
2292: end if;
2293: end if;
2294: -- calling the update market segment procedure
2295: bic_consolidate_cust_data_pkg.update_market_segment;
2296: -- set profile value of BIC_SMRY_EXTRACTION_DATE iff start and end dates
2297: -- passed to the procedure are null.
2298: if p_start_date is null and p_end_date is null then
2299: fnd_profile.put('BIC_SMRY_EXTRACTION_DATE',