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_OPPTY_SUMRY_PKG dependencies on BIL_DO_L1_OPPTY_SUMRY

Line 1: PACKAGE BODY BIL_DO_L1_OPPTY_SUMRY_PKG AS

1: PACKAGE BODY BIL_DO_L1_OPPTY_SUMRY_PKG AS
2: /* $Header: bilopl1b.pls 115.18 2002/01/29 23:03:50 pkm ship $ */
3: -- Global Variables and Constants
4: -- G_Debug will be modified to TRUE programatically.
5: -- when the parameter passed for P_debug is Y

Line 71: from BIL_DO_L1_OPPTY_SUMRY;

67: l_collection_date_start := l_collection_date_end;
68: -- Look for first missing collection date in table;
69: select max(collection_date)+1
70: into l_collection_date_start
71: from BIL_DO_L1_OPPTY_SUMRY;
72: -- Just do for sysdate-1 if nothing exists or data already
73: -- exists for sysdate
74: if l_collection_date_start is null
75: or l_collection_date_start > l_collection_date_end then

Line 198: BIL_DO_UTIL_PKG.Write_Log('Analyze table BIL_DO_L1_OPPTY_SUMRY',p_debug => p_debug_mode);

194: end loop;
195: end if;
196:
197: /*Analyze the table after insertion*/
198: BIL_DO_UTIL_PKG.Write_Log('Analyze table BIL_DO_L1_OPPTY_SUMRY',p_debug => p_debug_mode);
199: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_OPPTY_SUMRY', cascade=>TRUE,
200: degree=>G_Degree, estimate_percent=>99, granularity=>'GLOBAL');
201:
202:

Line 199: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_OPPTY_SUMRY', cascade=>TRUE,

195: end if;
196:
197: /*Analyze the table after insertion*/
198: BIL_DO_UTIL_PKG.Write_Log('Analyze table BIL_DO_L1_OPPTY_SUMRY',p_debug => p_debug_mode);
199: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_OPPTY_SUMRY', cascade=>TRUE,
200: degree=>G_Degree, estimate_percent=>99, granularity=>'GLOBAL');
201:
202:
203: IF G_Trace THEN

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

203: IF G_Trace THEN
204: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=FALSE';
205: END IF;
206: Reset_Table_Usages;
207: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Alter bil_do_l1_OPPTY_SUMRY table to noparallel', p_debug=>p_debug_mode);
208:
209: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'End of Refresh_Date_Range for Opportunity to Quote Bin', p_debug=>p_debug_mode);
210:
211:

Line 312: l_insert_string := 'INSERT INTO BIL_DO_L1_OPPTY_SUMRY( COLLECTION_DATE';

308:
309: l_stime DATE := sysdate;
310: BEGIN
311: l_collection_date := p_collect_date;
312: l_insert_string := 'INSERT INTO BIL_DO_L1_OPPTY_SUMRY( COLLECTION_DATE';
313: l_insert_string := l_insert_string|| ', SALES_GROUP_ID, PERIOD_NAME, PERIOD_TYPE, WON_AMOUNT, OPEN_AMOUNT';
314: l_insert_string := l_insert_string|| ', WEIGHTED_OPEN_AMOUNT, FORECAST_AMOUNT, LAST_UPDATE_DATE, LAST_UPDATED_BY';
315: l_insert_string := l_insert_string|| ', CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID';
316: l_insert_string := l_insert_string||', PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ';

Line 392: *from BIL Table BIL_DO_L1_OPPTY_SUMRY for the collection_date.

388: end Insert_Data;
389:
390: /*************************************************************
391: *Delete_table is used to Delete existing records
392: *from BIL Table BIL_DO_L1_OPPTY_SUMRY for the collection_date.
393: **************************************************************/
394: PROCEDURE Delete_table( ERRBUF IN OUT VARCHAR2
395: ,RETCODE IN OUT VARCHAR2
396: ,p_date IN DATE) IS

Line 399: DELETE FROM BIL_DO_L1_OPPTY_SUMRY

395: ,RETCODE IN OUT VARCHAR2
396: ,p_date IN DATE) IS
397: l_date DATE := p_date;
398: BEGIN
399: DELETE FROM BIL_DO_L1_OPPTY_SUMRY
400: WHERE collection_date = l_date;
401: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Deleted records from BIL Table BIL_DO_L1_OPPTY_SUMRY',p_debug=>G_Debug);
402: EXCEPTION
403: WHEN NO_DATA_FOUND THEN

Line 401: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Deleted records from BIL Table BIL_DO_L1_OPPTY_SUMRY',p_debug=>G_Debug);

397: l_date DATE := p_date;
398: BEGIN
399: DELETE FROM BIL_DO_L1_OPPTY_SUMRY
400: WHERE collection_date = l_date;
401: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Deleted records from BIL Table BIL_DO_L1_OPPTY_SUMRY',p_debug=>G_Debug);
402: EXCEPTION
403: WHEN NO_DATA_FOUND THEN
404: null;
405: WHEN OTHERS THEN

Line 415: EXECUTE IMMEDIATE 'ALTER TABLE BIL.BIL_DO_L1_OPPTY_SUMRY LOGGING';

411: *Alter tables to logging
412: *********/
413: PROCEDURE Reset_Table_Usages IS
414: BEGIN
415: EXECUTE IMMEDIATE 'ALTER TABLE BIL.BIL_DO_L1_OPPTY_SUMRY LOGGING';
416: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to logging',p_debug=>G_Debug);
417: END Reset_Table_Usages;
418:
419:

Line 416: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to logging',p_debug=>G_Debug);

412: *********/
413: PROCEDURE Reset_Table_Usages IS
414: BEGIN
415: EXECUTE IMMEDIATE 'ALTER TABLE BIL.BIL_DO_L1_OPPTY_SUMRY LOGGING';
416: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to logging',p_debug=>G_Debug);
417: END Reset_Table_Usages;
418:
419:
420: /*******************

Line 425: EXECUTE IMMEDIATE 'truncate table bil.bil_do_l1_oppty_sumry';

421: *Truncate the table
422: *******************/
423: PROCEDURE Truncate_table is
424: BEGIN
425: EXECUTE IMMEDIATE 'truncate table bil.bil_do_l1_oppty_sumry';
426: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_oppty_sumry is truncated',p_debug=>G_Debug);
427: END;
428:
429:

Line 426: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_oppty_sumry is truncated',p_debug=>G_Debug);

422: *******************/
423: PROCEDURE Truncate_table is
424: BEGIN
425: EXECUTE IMMEDIATE 'truncate table bil.bil_do_l1_oppty_sumry';
426: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_oppty_sumry is truncated',p_debug=>G_Debug);
427: END;
428:
429:
430: /*******

Line 435: EXECUTE IMMEDIATE 'ALTER TABLE BIL.BIL_DO_L1_OPPTY_SUMRY NOLOGGING';

431: *Alter all the tables used to nologging
432: *******/
433: PROCEDURE Set_Table_Usages IS
434: BEGIN
435: EXECUTE IMMEDIATE 'ALTER TABLE BIL.BIL_DO_L1_OPPTY_SUMRY NOLOGGING';
436: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to nologging',p_debug=>G_Debug);
437: END Set_Table_Usages;
438:
439: END BIL_DO_L1_OPPTY_SUMRY_PKG;

Line 436: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to nologging',p_debug=>G_Debug);

432: *******/
433: PROCEDURE Set_Table_Usages IS
434: BEGIN
435: EXECUTE IMMEDIATE 'ALTER TABLE BIL.BIL_DO_L1_OPPTY_SUMRY NOLOGGING';
436: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to nologging',p_debug=>G_Debug);
437: END Set_Table_Usages;
438:
439: END BIL_DO_L1_OPPTY_SUMRY_PKG;

Line 439: END BIL_DO_L1_OPPTY_SUMRY_PKG;

435: EXECUTE IMMEDIATE 'ALTER TABLE BIL.BIL_DO_L1_OPPTY_SUMRY NOLOGGING';
436: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to nologging',p_debug=>G_Debug);
437: END Set_Table_Usages;
438:
439: END BIL_DO_L1_OPPTY_SUMRY_PKG;