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.BIL_DO_L1_LD_OPPTY_DLY_PKG dependencies on BIL_DO_L1_LD_OPPTY_DLY

Line 1: PACKAGE BODY BIL_DO_L1_LD_OPPTY_DLY_PKG AS

1: PACKAGE BODY BIL_DO_L1_LD_OPPTY_DLY_PKG AS
2: /* $Header: billdl1b.pls 115.19 2002/01/29 13:56:05 pkm ship $ */
3:
4: -- Global Variables and Constants
5: -- G_Debug will be modified to 'Y' programatically.

Line 103: FROM bil_do_l1_ld_oppty_dly;

99: Set_table_Usages;
100:
101: SELECT MAX(collection_date)+1
102: INTO l_collection_date_start
103: FROM bil_do_l1_ld_oppty_dly;
104:
105: l_collection_date_loop := l_collection_date_start;
106: WHILE (l_collection_date_loop <=l_collect_for_date) LOOP
107: Refresh_Data_Day

Line 135: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Analyze table bil_do_l1_ld_oppty_dly', p_debug=> p_debug_mode);

131: );
132: END IF;
133:
134:
135: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Analyze table bil_do_l1_ld_oppty_dly', p_debug=> p_debug_mode);
136:
137: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_LD_OPPTY_DLY', cascade=>TRUE,
138: degree=>l_Degree, estimate_percent=>99, granularity=>'GLOBAL');
139:

Line 137: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_LD_OPPTY_DLY', cascade=>TRUE,

133:
134:
135: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Analyze table bil_do_l1_ld_oppty_dly', p_debug=> p_debug_mode);
136:
137: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_LD_OPPTY_DLY', cascade=>TRUE,
138: degree=>l_Degree, estimate_percent=>99, granularity=>'GLOBAL');
139:
140:
141:

Line 146: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Alter bil_do_l1_ld_oppty_dly table to noparallel', p_debug=>p_debug_mode);

142: IF G_Trace = 'Y' THEN
143: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=FALSE';
144: END IF;
145:
146: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Alter bil_do_l1_ld_oppty_dly table to noparallel', p_debug=>p_debug_mode);
147: Reset_Table_Usages;
148:
149: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'End of Refresh Data for Lead to Opportunity Bin', p_debug=>p_debug_mode);
150:

Line 212: EXECUTE IMMEDIATE 'TRUNCATE TABLE BIL.BIL_DO_L1_LD_OPPTY_DLY';

208:
209: Set_table_Usages;
210:
211: IF p_truncate_flag = 'Y' THEN
212: EXECUTE IMMEDIATE 'TRUNCATE TABLE BIL.BIL_DO_L1_LD_OPPTY_DLY';
213: WHILE l_start_date <= l_end_date LOOP
214: Refresh_Data_Day
215: (
216: ERRBUF => ERRBUF

Line 243: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Analyze table bil_do_l1_ld_oppty_dly', p_debug=> p_debug_mode);

239: l_start_date := l_start_date + 1;
240: END LOOP;
241: END IF;
242:
243: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Analyze table bil_do_l1_ld_oppty_dly', p_debug=> p_debug_mode);
244:
245: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_LD_OPPTY_DLY', cascade=>TRUE,
246: degree=>l_Degree, estimate_percent=>99, granularity=>'GLOBAL');
247:

Line 245: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_LD_OPPTY_DLY', cascade=>TRUE,

241: END IF;
242:
243: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Analyze table bil_do_l1_ld_oppty_dly', p_debug=> p_debug_mode);
244:
245: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_LD_OPPTY_DLY', cascade=>TRUE,
246: degree=>l_Degree, estimate_percent=>99, granularity=>'GLOBAL');
247:
248: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'End of initial load of bil_do_l1_ld_oppty_dly', p_debug=> p_debug_mode);
249:

Line 248: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'End of initial load of bil_do_l1_ld_oppty_dly', p_debug=> p_debug_mode);

244:
245: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_LD_OPPTY_DLY', cascade=>TRUE,
246: degree=>l_Degree, estimate_percent=>99, granularity=>'GLOBAL');
247:
248: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'End of initial load of bil_do_l1_ld_oppty_dly', p_debug=> p_debug_mode);
249:
250: IF G_Trace = 'Y' THEN
251: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=FALSE';
252: END IF;

Line 254: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Alter bil_do_l1_ld_oppty_dly table to noparallel', p_debug=>p_debug_mode);

250: IF G_Trace = 'Y' THEN
251: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=FALSE';
252: END IF;
253:
254: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Alter bil_do_l1_ld_oppty_dly table to noparallel', p_debug=>p_debug_mode);
255: Reset_Table_Usages;
256:
257: EXCEPTION
258: WHEN OTHERS THEN

Line 286: DELETE FROM bil_do_l1_ld_oppty_dly

282: ) IS
283:
284: BEGIN
285:
286: DELETE FROM bil_do_l1_ld_oppty_dly
287: WHERE collection_date = p_date;
288:
289: COMMIT;
290:

Line 337: l_insert_stmnt := 'INSERT INTO /+ APPEND PARALLEL(bld, ' || p_degree || ') / bil_do_l1_ld_oppty_dly bld';

333:
334:
335: BEGIN
336:
337: l_insert_stmnt := 'INSERT INTO /*+ APPEND PARALLEL(bld, ' || p_degree || ') */ bil_do_l1_ld_oppty_dly bld';
338: l_insert_stmnt := l_insert_stmnt || '(';
339: l_insert_stmnt := l_insert_stmnt || ' collection_date';
340: l_insert_stmnt := l_insert_stmnt || ', sales_group_id';
341: l_insert_stmnt := l_insert_stmnt || ', total_leads_all';

Line 595: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_ld_oppty_dly LOGGING';

591: PROCEDURE Reset_Table_Usages IS
592: BEGIN
593:
594:
595: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_ld_oppty_dly LOGGING';
596:
597: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_ld_oppty_dly altered to logging', p_debug=>G_Debug);
598: END Reset_Table_Usages;
599:

Line 597: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_ld_oppty_dly altered to logging', p_debug=>G_Debug);

593:
594:
595: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_ld_oppty_dly LOGGING';
596:
597: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_ld_oppty_dly altered to logging', p_debug=>G_Debug);
598: END Reset_Table_Usages;
599:
600: /*******
601: Alter all the tables used to nologging, drop the indexes

Line 606: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_ld_oppty_dly NOLOGGING';

602: *******/
603: PROCEDURE Set_Table_Usages IS
604: BEGIN
605:
606: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_ld_oppty_dly NOLOGGING';
607:
608: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_ld_oppty_dly altered to nologging', p_debug=>G_Debug);
609:
610:

Line 608: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_ld_oppty_dly altered to nologging', p_debug=>G_Debug);

604: BEGIN
605:
606: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_ld_oppty_dly NOLOGGING';
607:
608: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_ld_oppty_dly altered to nologging', p_debug=>G_Debug);
609:
610:
611: END Set_Table_Usages;
612:

Line 613: END BIL_DO_L1_LD_OPPTY_DLY_PKG;

609:
610:
611: END Set_Table_Usages;
612:
613: END BIL_DO_L1_LD_OPPTY_DLY_PKG;