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.POA_DBI_PQC_PKG dependencies on FII_TIME_API

Line 93: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);

89: l_url := 'pFunctionName=POA_DBI_PQC_STATUS_RPT&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=SUPPLIER+POA_SUPPLIERS&pParamIds=Y';
90: end if;
91: end if;
92:
93: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
94: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
95:
96: l_query := get_status_sel_clause(
97: l_view_by,

Line 94: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);

90: end if;
91: end if;
92:
93: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
94: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
95:
96: l_query := get_status_sel_clause(
97: l_view_by,
98: l_view_by_col,

Line 186: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);

182: l_url := 'pFunctionName=POA_DBI_CC_PQC_STATUS_RPT&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=SUPPLIER+POA_SUPPLIERS&pParamIds=Y';
183: end if;
184: end if;
185:
186: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
187: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
188:
189: if(l_use_only_agg_mv = 'N') then
190: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();

Line 187: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);

183: end if;
184: end if;
185:
186: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
187: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
188:
189: if(l_use_only_agg_mv = 'N') then
190: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();
191: l_mv_tbl.extend;

Line 474: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);

470: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt','Y');
471:
472: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
473:
474: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
475: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
476:
477: begin
478: l_prev_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_prev_as_of_date);

Line 475: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);

471:
472: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
473:
474: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
475: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
476:
477: begin
478: l_prev_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_prev_as_of_date);
479: exception

Line 478: l_prev_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_prev_as_of_date);

474: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
475: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
476:
477: begin
478: l_prev_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_prev_as_of_date);
479: exception
480: when no_data_found then
481: l_prev_prev_asof_year := null;
482: end;

Line 532: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);

528: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'amt','Y');
529:
530: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
531:
532: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
533: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
534: l_prev_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_prev_as_of_date);
535:
536: /*check if we can get everything from aggregated mv*/

Line 533: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);

529:
530: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
531:
532: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
533: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
534: l_prev_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_prev_as_of_date);
535:
536: /*check if we can get everything from aggregated mv*/
537: l_use_only_agg_mv := 'Y';

Line 534: l_prev_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_prev_as_of_date);

530: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
531:
532: l_asof_year := fii_time_api.ent_cyr_start(l_as_of_date);
533: l_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_as_of_date);
534: l_prev_prev_asof_year := fii_time_api.ent_cyr_start(l_prev_prev_as_of_date);
535:
536: /*check if we can get everything from aggregated mv*/
537: l_use_only_agg_mv := 'Y';
538: for i in 1..l_in_join_tbl.count loop

Line 1087: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);

1083:
1084: IF l_xtd = 'YTD' THEN
1085: l_adjust1 := NULL;
1086: l_adjust2 := NULL;
1087: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);
1088: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);
1089: l_prior_start := fii_time_api.ent_cyr_start(l_prev_as_of_date);
1090: l_prior_end := fii_time_api.ent_cyr_end(l_prev_as_of_date);
1091: l_record_type1 := 119;

Line 1088: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);

1084: IF l_xtd = 'YTD' THEN
1085: l_adjust1 := NULL;
1086: l_adjust2 := NULL;
1087: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);
1088: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);
1089: l_prior_start := fii_time_api.ent_cyr_start(l_prev_as_of_date);
1090: l_prior_end := fii_time_api.ent_cyr_end(l_prev_as_of_date);
1091: l_record_type1 := 119;
1092: l_record_type2 := 23;

Line 1089: l_prior_start := fii_time_api.ent_cyr_start(l_prev_as_of_date);

1085: l_adjust1 := NULL;
1086: l_adjust2 := NULL;
1087: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);
1088: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);
1089: l_prior_start := fii_time_api.ent_cyr_start(l_prev_as_of_date);
1090: l_prior_end := fii_time_api.ent_cyr_end(l_prev_as_of_date);
1091: l_record_type1 := 119;
1092: l_record_type2 := 23;
1093: ELSIF l_xtd = 'QTD' THEN

Line 1090: l_prior_end := fii_time_api.ent_cyr_end(l_prev_as_of_date);

1086: l_adjust2 := NULL;
1087: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);
1088: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);
1089: l_prior_start := fii_time_api.ent_cyr_start(l_prev_as_of_date);
1090: l_prior_end := fii_time_api.ent_cyr_end(l_prev_as_of_date);
1091: l_record_type1 := 119;
1092: l_record_type2 := 23;
1093: ELSIF l_xtd = 'QTD' THEN
1094: l_adjust1 := ':POA_CURR_START-:POA_CURR_END';

Line 1096: l_curr_start := fii_time_api.ent_cqtr_start(l_as_of_date);

1092: l_record_type2 := 23;
1093: ELSIF l_xtd = 'QTD' THEN
1094: l_adjust1 := ':POA_CURR_START-:POA_CURR_END';
1095: l_adjust2 := ':POA_PRIOR_START-:POA_PRIOR_END';
1096: l_curr_start := fii_time_api.ent_cqtr_start(l_as_of_date);
1097: l_curr_end := fii_time_api.ent_cqtr_end(l_as_of_date);
1098: l_prior_start := fii_time_api.ent_cqtr_start(l_prev_as_of_date);
1099: l_prior_end := fii_time_api.ent_cqtr_end(l_prev_as_of_date);
1100: l_record_type1 := 11;

Line 1097: l_curr_end := fii_time_api.ent_cqtr_end(l_as_of_date);

1093: ELSIF l_xtd = 'QTD' THEN
1094: l_adjust1 := ':POA_CURR_START-:POA_CURR_END';
1095: l_adjust2 := ':POA_PRIOR_START-:POA_PRIOR_END';
1096: l_curr_start := fii_time_api.ent_cqtr_start(l_as_of_date);
1097: l_curr_end := fii_time_api.ent_cqtr_end(l_as_of_date);
1098: l_prior_start := fii_time_api.ent_cqtr_start(l_prev_as_of_date);
1099: l_prior_end := fii_time_api.ent_cqtr_end(l_prev_as_of_date);
1100: l_record_type1 := 11;
1101: l_record_type2 := 1;

Line 1098: l_prior_start := fii_time_api.ent_cqtr_start(l_prev_as_of_date);

1094: l_adjust1 := ':POA_CURR_START-:POA_CURR_END';
1095: l_adjust2 := ':POA_PRIOR_START-:POA_PRIOR_END';
1096: l_curr_start := fii_time_api.ent_cqtr_start(l_as_of_date);
1097: l_curr_end := fii_time_api.ent_cqtr_end(l_as_of_date);
1098: l_prior_start := fii_time_api.ent_cqtr_start(l_prev_as_of_date);
1099: l_prior_end := fii_time_api.ent_cqtr_end(l_prev_as_of_date);
1100: l_record_type1 := 11;
1101: l_record_type2 := 1;
1102: ELSIF l_xtd = 'MTD' THEN

Line 1099: l_prior_end := fii_time_api.ent_cqtr_end(l_prev_as_of_date);

1095: l_adjust2 := ':POA_PRIOR_START-:POA_PRIOR_END';
1096: l_curr_start := fii_time_api.ent_cqtr_start(l_as_of_date);
1097: l_curr_end := fii_time_api.ent_cqtr_end(l_as_of_date);
1098: l_prior_start := fii_time_api.ent_cqtr_start(l_prev_as_of_date);
1099: l_prior_end := fii_time_api.ent_cqtr_end(l_prev_as_of_date);
1100: l_record_type1 := 11;
1101: l_record_type2 := 1;
1102: ELSIF l_xtd = 'MTD' THEN
1103: l_adjust1 := '1';

Line 1105: l_curr_start := fii_time_api.ent_cper_start(l_as_of_date);

1101: l_record_type2 := 1;
1102: ELSIF l_xtd = 'MTD' THEN
1103: l_adjust1 := '1';
1104: l_adjust2 := '1';
1105: l_curr_start := fii_time_api.ent_cper_start(l_as_of_date);
1106: l_curr_end := fii_time_api.ent_cper_end(l_as_of_date);
1107: l_prior_start := fii_time_api.ent_cper_start(l_prev_as_of_date);
1108: l_prior_end := fii_time_api.ent_cper_end(l_prev_as_of_date);
1109: l_record_type1 := 11;

Line 1106: l_curr_end := fii_time_api.ent_cper_end(l_as_of_date);

1102: ELSIF l_xtd = 'MTD' THEN
1103: l_adjust1 := '1';
1104: l_adjust2 := '1';
1105: l_curr_start := fii_time_api.ent_cper_start(l_as_of_date);
1106: l_curr_end := fii_time_api.ent_cper_end(l_as_of_date);
1107: l_prior_start := fii_time_api.ent_cper_start(l_prev_as_of_date);
1108: l_prior_end := fii_time_api.ent_cper_end(l_prev_as_of_date);
1109: l_record_type1 := 11;
1110: l_record_type2 := 1;

Line 1107: l_prior_start := fii_time_api.ent_cper_start(l_prev_as_of_date);

1103: l_adjust1 := '1';
1104: l_adjust2 := '1';
1105: l_curr_start := fii_time_api.ent_cper_start(l_as_of_date);
1106: l_curr_end := fii_time_api.ent_cper_end(l_as_of_date);
1107: l_prior_start := fii_time_api.ent_cper_start(l_prev_as_of_date);
1108: l_prior_end := fii_time_api.ent_cper_end(l_prev_as_of_date);
1109: l_record_type1 := 11;
1110: l_record_type2 := 1;
1111: ELSE -- l_period_type = 'FII_TIME_WEEK'

Line 1108: l_prior_end := fii_time_api.ent_cper_end(l_prev_as_of_date);

1104: l_adjust2 := '1';
1105: l_curr_start := fii_time_api.ent_cper_start(l_as_of_date);
1106: l_curr_end := fii_time_api.ent_cper_end(l_as_of_date);
1107: l_prior_start := fii_time_api.ent_cper_start(l_prev_as_of_date);
1108: l_prior_end := fii_time_api.ent_cper_end(l_prev_as_of_date);
1109: l_record_type1 := 11;
1110: l_record_type2 := 1;
1111: ELSE -- l_period_type = 'FII_TIME_WEEK'
1112: l_adjust1 := '1';

Line 1114: l_curr_start := fii_time_api.cwk_start(l_as_of_date);

1110: l_record_type2 := 1;
1111: ELSE -- l_period_type = 'FII_TIME_WEEK'
1112: l_adjust1 := '1';
1113: l_adjust2 := '1';
1114: l_curr_start := fii_time_api.cwk_start(l_as_of_date);
1115: l_curr_end := fii_time_api.cwk_end(l_as_of_date);
1116: l_prior_start := fii_time_api.cwk_start(l_prev_as_of_date);
1117: l_prior_end := fii_time_api.cwk_end(l_prev_as_of_date);
1118: l_record_type1 := 11;

Line 1115: l_curr_end := fii_time_api.cwk_end(l_as_of_date);

1111: ELSE -- l_period_type = 'FII_TIME_WEEK'
1112: l_adjust1 := '1';
1113: l_adjust2 := '1';
1114: l_curr_start := fii_time_api.cwk_start(l_as_of_date);
1115: l_curr_end := fii_time_api.cwk_end(l_as_of_date);
1116: l_prior_start := fii_time_api.cwk_start(l_prev_as_of_date);
1117: l_prior_end := fii_time_api.cwk_end(l_prev_as_of_date);
1118: l_record_type1 := 11;
1119: l_record_type2 := 1;

Line 1116: l_prior_start := fii_time_api.cwk_start(l_prev_as_of_date);

1112: l_adjust1 := '1';
1113: l_adjust2 := '1';
1114: l_curr_start := fii_time_api.cwk_start(l_as_of_date);
1115: l_curr_end := fii_time_api.cwk_end(l_as_of_date);
1116: l_prior_start := fii_time_api.cwk_start(l_prev_as_of_date);
1117: l_prior_end := fii_time_api.cwk_end(l_prev_as_of_date);
1118: l_record_type1 := 11;
1119: l_record_type2 := 1;
1120: END IF;

Line 1117: l_prior_end := fii_time_api.cwk_end(l_prev_as_of_date);

1113: l_adjust2 := '1';
1114: l_curr_start := fii_time_api.cwk_start(l_as_of_date);
1115: l_curr_end := fii_time_api.cwk_end(l_as_of_date);
1116: l_prior_start := fii_time_api.cwk_start(l_prev_as_of_date);
1117: l_prior_end := fii_time_api.cwk_end(l_prev_as_of_date);
1118: l_record_type1 := 11;
1119: l_record_type2 := 1;
1120: END IF;
1121: