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_BI_PURGE_OBJ_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 79: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );

75: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');
76: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
77:
78: -- Delete references from BIS_REFRESH_LOG table
79: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );
80:
81: WHEN 'FST_DTL_F' THEN
82:
83: -- Truncate Forecast Summary Objects

Line 91: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );

87: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
88: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
89:
90: -- Delete references from BIS_REFRESH_LOG table
91: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );
92:
93: WHEN 'CURRENCY' THEN
94: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
95:

Line 106: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');

102: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
103: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');
104:
105: -- Delete references from BIS_REFRESH_LOG table
106: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');
107: -- asolaiy added for 8.0. New current fact table.
108: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPEC_F');
109:
110: WHEN 'ALL' THEN

Line 108: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPEC_F');

104:
105: -- Delete references from BIS_REFRESH_LOG table
106: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');
107: -- asolaiy added for 8.0. New current fact table.
108: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPEC_F');
109:
110: WHEN 'ALL' THEN
111:
112: -- Truncate Opportunity Detail Summary Objects

Line 116: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'OPDTL_F');

112: -- Truncate Opportunity Detail Summary Objects
113: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');
114: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');
115: -- Delete references from BIS_REFRESH_LOG table
116: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'OPDTL_F');
117:
118: -- Truncate Forecast Summary Objects
119: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
120: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');

Line 125: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'FST_DTL_F');

121: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
122: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
123:
124: -- Delete references from BIS_REFRESH_LOG table
125: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'FST_DTL_F');
126:
127: -- Truncate Pipeline Summary Objects
128: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
129: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');

Line 136: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');

132: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
133: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');
134:
135: -- Delete references from BIS_REFRESH_LOG table
136: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');
137: -- asolaiy added for 8.0. New current fact table.
138: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPEC_F');
139:
140: -- Truncate Currency Table

Line 138: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPEC_F');

134:
135: -- Delete references from BIS_REFRESH_LOG table
136: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');
137: -- asolaiy added for 8.0. New current fact table.
138: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPEC_F');
139:
140: -- Truncate Currency Table
141: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
142:

Line 808: g_debug := NVL(BIS_COLLECTION_UTILITIES.g_debug,FALSE);

804: END IF;
805:
806: g_errbuf := NULL;
807: g_retcode := 0;
808: g_debug := NVL(BIS_COLLECTION_UTILITIES.g_debug,FALSE);
809: g_row_num := 0;
810: g_status := FALSE;
811: --g_obj_name := p_obj_name;
812:

Line 814: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name || '_PURGE');

810: g_status := FALSE;
811: --g_obj_name := p_obj_name;
812:
813: -- Delete references from BIS_REFRESH_LOG table
814: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name || '_PURGE');
815:
816: -- Call generic Setup procedure
817: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'BIL_BI_'|| p_obj_name ||'_PURGE');
818:

Line 817: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'BIL_BI_'|| p_obj_name ||'_PURGE');

813: -- Delete references from BIS_REFRESH_LOG table
814: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name || '_PURGE');
815:
816: -- Call generic Setup procedure
817: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'BIL_BI_'|| p_obj_name ||'_PURGE');
818:
819: IF l_valid_setup THEN
820: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
821: bil_bi_util_collection_pkg.writeLog

Line 887: BIS_COLLECTION_UTILITIES.wrapup(p_status => TRUE,

883: );
884: END IF;
885: -- Wrap up the BIS set up
886: IF g_status THEN
887: BIS_COLLECTION_UTILITIES.wrapup(p_status => TRUE,
888: p_count => g_row_num,
889: p_message => NULL,
890: p_period_from => NULL,
891: p_period_to => g_end_date);

Line 893: BIS_COLLECTION_UTILITIES.wrapup(p_status => FALSE,

889: p_message => NULL,
890: p_period_from => NULL,
891: p_period_to => g_end_date);
892: ELSE
893: BIS_COLLECTION_UTILITIES.wrapup(p_status => FALSE,
894: p_count => 0,
895: p_message => NULL,
896: p_period_from => NULL,
897: p_period_to => g_end_date);