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

Line 774: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F')));

770: p_msg => 'Start of Procedure '|| l_proc);
771: END IF;
772:
773: l_last_fact_run :=
774: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F')));
775:
776:
777: SELECT end_date+1
778: INTO l_curr_collect_start

Line 1110: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP('BIL_BI_PIPELINE_F');

1106: l_int_date_format1:='MM/DD/YYYY HH24:MI:SS';
1107: l_resume_flag:= 'N';
1108: l_sysdate := sysdate;
1109:
1110: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP('BIL_BI_PIPELINE_F');
1111:
1112:
1113:
1114:

Line 1122: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed'

1118: bil_bi_util_collection_pkg.writeLog
1119: (
1120: p_log_level => fnd_log.LEVEL_EVENT,
1121: p_module => g_pkg || l_proc ,
1122: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed'
1123: );
1124: END IF;
1125: RAISE G_BIS_SETUP_ERROR;
1126: END IF;

Line 1360: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPELINE_F');

1356: p_module => g_pkg || l_proc ,
1357: p_msg => 'Truncating'
1358: );
1359: END IF;
1360: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPELINE_F');
1361: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPEC_F');
1362: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1363: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');
1364: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');

Line 1361: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPEC_F');

1357: p_msg => 'Truncating'
1358: );
1359: END IF;
1360: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPELINE_F');
1361: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPEC_F');
1362: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1363: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');
1364: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');
1365: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');

Line 1681: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_PIPEC_F')));

1677:
1678: -- resume during gap fill is handled by reading l_last_run after resume
1679:
1680: l_last_run :=
1681: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_PIPEC_F')));
1682: l_last_fact_run :=
1683: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F')));
1684:
1685: l_date := l_last_fact_run; -- fact could be run on previous day or the same day

Line 1683: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F')));

1679:
1680: l_last_run :=
1681: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_PIPEC_F')));
1682: l_last_fact_run :=
1683: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F')));
1684:
1685: l_date := l_last_fact_run; -- fact could be run on previous day or the same day
1686:
1687:

Line 1705: BIS_COLLECTION_UTILITIES.wrapup(FALSE,

1701: p_msg => 'Load Sales Opportunity Base Summary program must be run before this program.'
1702: );
1703: END IF;
1704:
1705: BIS_COLLECTION_UTILITIES.wrapup(FALSE,
1706: g_row_num,
1707: 'Load Sales Opportunity Base Summary program not run.',
1708: l_date,
1709: l_date

Line 2715: -- BIS_COLLECTION_UTILITIES.wrapup(TRUE,

2711: );
2712: END IF;
2713:
2714: commit;
2715: -- BIS_COLLECTION_UTILITIES.wrapup(TRUE,
2716: -- g_row_num,
2717: -- 'Snapshot taken for ' || l_date,
2718: -- l_date,
2719: -- l_date );

Line 2810: BIS_COLLECTION_UTILITIES.wrapup(FALSE,

2806: retcode := -1;
2807:
2808: WHEN G_SETUP_VAL_ERROR THEN
2809: ROLLBACK;
2810: BIS_COLLECTION_UTILITIES.wrapup(FALSE,
2811: g_row_num,
2812: 'Setup issues detected.',
2813: l_date,
2814: l_date

Line 2823: BIS_COLLECTION_UTILITIES.wrapup(FALSE,

2819: -- no need to rollback or truncate, resume will take care this
2820: commit;
2821:
2822:
2823: BIS_COLLECTION_UTILITIES.wrapup(FALSE,
2824: g_row_num,
2825: 'Time/Currency dimension not setup.',
2826: l_failure_from,
2827: l_failure_to

Line 2839: BIS_COLLECTION_UTILITIES.wrapup(FALSE,

2835: --execute immediate 'Truncate table BIL_BI_DENLOG_STG';
2836: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
2837:
2838: commit;
2839: BIS_COLLECTION_UTILITIES.wrapup(FALSE,
2840: g_row_num,
2841: SQLERRM,
2842: l_date,
2843: l_date

Line 3486: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;

3482: p_module => g_pkg || l_proc || ' begin',
3483: p_msg => 'Start of Procedure '|| l_proc);
3484: END IF;
3485:
3486: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;
3487:
3488: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
3489: bil_bi_util_collection_pkg.writeLog(
3490: p_log_level => fnd_log.LEVEL_STATEMENT,

Line 3499: BIS_COLLECTION_UTILITIES.writemissingrate(

3495: FOR rate_record in MissingRate_p LOOP
3496:
3497: IF rate_record.prim_curr_type = 'P' THEN
3498:
3499: BIS_COLLECTION_UTILITIES.writemissingrate(
3500: g_prim_rate_type,
3501: rate_record.txn_currency,
3502: g_prim_currency,
3503: rate_record.txn_date);

Line 3509: BIS_COLLECTION_UTILITIES.writemissingrate(

3505: END IF;
3506:
3507: IF rate_record.sec_curr_type = 'S' THEN
3508:
3509: BIS_COLLECTION_UTILITIES.writemissingrate(
3510: g_sec_rate_type,
3511: rate_record.txn_currency,
3512: G_sec_Currency,
3513: rate_record.txn_date);