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

Line 1232: select nvl(fii_time_api.pwk_end(l_as_of_date-91) +1, l_start_date) into p_report_start from dual;

1228:
1229: CASE l_period_type
1230: WHEN 'FII_TIME_WEEK' THEN
1231: p_period_id := 16;
1232: select nvl(fii_time_api.pwk_end(l_as_of_date-91) +1, l_start_date) into p_report_start from dual;
1233: select nvl(fii_time_api.pwk_end(l_as_of_date) +1, l_start_date-1) into p_period_start from dual;
1234: select sequence into p_cur_effective_num
1235: from fii_time_week
1236: where l_as_of_date between start_date and end_date;

Line 1233: select nvl(fii_time_api.pwk_end(l_as_of_date) +1, l_start_date-1) into p_period_start from dual;

1229: CASE l_period_type
1230: WHEN 'FII_TIME_WEEK' THEN
1231: p_period_id := 16;
1232: select nvl(fii_time_api.pwk_end(l_as_of_date-91) +1, l_start_date) into p_report_start from dual;
1233: select nvl(fii_time_api.pwk_end(l_as_of_date) +1, l_start_date-1) into p_period_start from dual;
1234: select sequence into p_cur_effective_num
1235: from fii_time_week
1236: where l_as_of_date between start_date and end_date;
1237: WHEN 'FII_TIME_ENT_PERIOD' THEN

Line 1239: select nvl(fii_time_api.ent_lysper_end(l_as_of_date), l_start_date-1) into p_report_start from dual;

1235: from fii_time_week
1236: where l_as_of_date between start_date and end_date;
1237: WHEN 'FII_TIME_ENT_PERIOD' THEN
1238: p_period_id := 32;
1239: select nvl(fii_time_api.ent_lysper_end(l_as_of_date), l_start_date-1) into p_report_start from dual;
1240: select nvl(fii_time_api.ent_cper_start(l_as_of_date), l_start_date) into p_period_start from dual;
1241: select sequence into p_cur_effective_num
1242: from fii_time_ent_period
1243: where l_as_of_date between start_date and end_date;

Line 1240: select nvl(fii_time_api.ent_cper_start(l_as_of_date), l_start_date) into p_period_start from dual;

1236: where l_as_of_date between start_date and end_date;
1237: WHEN 'FII_TIME_ENT_PERIOD' THEN
1238: p_period_id := 32;
1239: select nvl(fii_time_api.ent_lysper_end(l_as_of_date), l_start_date-1) into p_report_start from dual;
1240: select nvl(fii_time_api.ent_cper_start(l_as_of_date), l_start_date) into p_period_start from dual;
1241: select sequence into p_cur_effective_num
1242: from fii_time_ent_period
1243: where l_as_of_date between start_date and end_date;
1244: WHEN 'FII_TIME_ENT_QTR' THEN

Line 1246: select nvl(fii_time_api.ent_lysqtr_end(l_as_of_date), l_start_date-1) into p_report_start from dual;

1242: from fii_time_ent_period
1243: where l_as_of_date between start_date and end_date;
1244: WHEN 'FII_TIME_ENT_QTR' THEN
1245: p_period_id := 64;
1246: select nvl(fii_time_api.ent_lysqtr_end(l_as_of_date), l_start_date-1) into p_report_start from dual;
1247: select nvl(fii_time_api.ent_cqtr_start(l_as_of_date), l_start_date) into p_period_start from dual;
1248:
1249: select sequence into p_cur_effective_num
1250: from fii_time_ent_qtr

Line 1247: select nvl(fii_time_api.ent_cqtr_start(l_as_of_date), l_start_date) into p_period_start from dual;

1243: where l_as_of_date between start_date and end_date;
1244: WHEN 'FII_TIME_ENT_QTR' THEN
1245: p_period_id := 64;
1246: select nvl(fii_time_api.ent_lysqtr_end(l_as_of_date), l_start_date-1) into p_report_start from dual;
1247: select nvl(fii_time_api.ent_cqtr_start(l_as_of_date), l_start_date) into p_period_start from dual;
1248:
1249: select sequence into p_cur_effective_num
1250: from fii_time_ent_qtr
1251: where l_as_of_date between start_date and end_date;

Line 1254: --p_report_start := fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_as_of_date))));

1250: from fii_time_ent_qtr
1251: where l_as_of_date between start_date and end_date;
1252: WHEN 'FII_TIME_ENT_YEAR' THEN
1253: p_period_id := 128;
1254: --p_report_start := fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_as_of_date))));
1255:
1256: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_as_of_date)))),l_start_date-1)
1257: into p_report_start from dual; /* Bug 3325387 */
1258:

Line 1256: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_as_of_date)))),l_start_date-1)

1252: WHEN 'FII_TIME_ENT_YEAR' THEN
1253: p_period_id := 128;
1254: --p_report_start := fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_as_of_date))));
1255:
1256: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_as_of_date)))),l_start_date-1)
1257: into p_report_start from dual; /* Bug 3325387 */
1258:
1259: select nvl(fii_time_api.ent_cyr_start(l_as_of_date), l_start_date) into p_period_start from dual;
1260: select sequence into p_cur_effective_num

Line 1259: select nvl(fii_time_api.ent_cyr_start(l_as_of_date), l_start_date) into p_period_start from dual;

1255:
1256: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_as_of_date)))),l_start_date-1)
1257: into p_report_start from dual; /* Bug 3325387 */
1258:
1259: select nvl(fii_time_api.ent_cyr_start(l_as_of_date), l_start_date) into p_period_start from dual;
1260: select sequence into p_cur_effective_num
1261: from fii_time_ent_year
1262: where l_as_of_date between start_date and end_date;
1263: END CASE;

Line 1369: -- l_date := 'fii_time_api.ent_cper_end(&BIS_CURRENT_ASOF_DATE)';

1365:
1366: -- WHEN 'FII_TIME_ENT_PERIOD' THEN
1367: -- l_url_1 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||tcur.end_date||''&pPeriod=FII_TIME_ENT_PERIOD&pParamIds=Y';
1368: -- l_url_2 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||&BIS_CURRENT_ASOF_DATE||''&pPeriod=FII_TIME_ENT_PERIOD&pParamIds=Y';
1369: -- l_date := 'fii_time_api.ent_cper_end(&BIS_CURRENT_ASOF_DATE)';
1370: -- WHEN 'FII_TIME_ENT_YEAR' THEN
1371: -- l_url_1 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||tcur.end_date||''&pPeriod=FII_TIME_ENT_YEAR&pParamIds=Y';
1372: -- l_url_2 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||&BIS_CURRENT_ASOF_DATE||''&pPeriod=FII_TIME_ENT_YEAR&pParamIds=Y';
1373: -- l_date :='fii_time_api.ent_cyr_end(&BIS_CURRENT_ASOF_DATE)';

Line 1373: -- l_date :='fii_time_api.ent_cyr_end(&BIS_CURRENT_ASOF_DATE)';

1369: -- l_date := 'fii_time_api.ent_cper_end(&BIS_CURRENT_ASOF_DATE)';
1370: -- WHEN 'FII_TIME_ENT_YEAR' THEN
1371: -- l_url_1 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||tcur.end_date||''&pPeriod=FII_TIME_ENT_YEAR&pParamIds=Y';
1372: -- l_url_2 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||&BIS_CURRENT_ASOF_DATE||''&pPeriod=FII_TIME_ENT_YEAR&pParamIds=Y';
1373: -- l_date :='fii_time_api.ent_cyr_end(&BIS_CURRENT_ASOF_DATE)';
1374: -- WHEN 'FII_TIME_ENT_QTR' THEN
1375: -- l_url_1 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||tcur.end_date||''&pPeriod=FII_TIME_ENT_QTR&pParamIds=Y';
1376: -- l_url_2 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||&BIS_CURRENT_ASOF_DATE||''&pPeriod=FII_TIME_ENT_QTR&pParamIds=Y';
1377: -- l_date :='fii_time_api.ent_cqtr_end(&BIS_CURRENT_ASOF_DATE)';

Line 1377: -- l_date :='fii_time_api.ent_cqtr_end(&BIS_CURRENT_ASOF_DATE)';

1373: -- l_date :='fii_time_api.ent_cyr_end(&BIS_CURRENT_ASOF_DATE)';
1374: -- WHEN 'FII_TIME_ENT_QTR' THEN
1375: -- l_url_1 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||tcur.end_date||''&pPeriod=FII_TIME_ENT_QTR&pParamIds=Y';
1376: -- l_url_2 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||&BIS_CURRENT_ASOF_DATE||''&pPeriod=FII_TIME_ENT_QTR&pParamIds=Y';
1377: -- l_date :='fii_time_api.ent_cqtr_end(&BIS_CURRENT_ASOF_DATE)';
1378: -- WHEN 'FII_TIME_WEEK' THEN
1379: -- l_url_1 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||enddate||''&pPeriod=FII_TIME_WEEK&pParamIds=Y';
1380: -- l_url_2 := 'pFunctionName=FII_AP_DRILL_ACROSS&pSource=FII_AP_E_INV_ENT_DTL&pOperatingUnit=FII_OPERATING_UNITS&pSupplier=POA_SUPPLIERS&pCurrency=FII_CURRENCIES&pAsOfDateValue=''||&BIS_CURRENT_ASOF_DATE||''&pPeriod=FII_TIME_WEEK&pParamIds=Y';
1381: -- END CASE;

Line 1385: g_date_string := fii_time_api.ent_cper_end(l_as_of_date_3);

1381: -- END CASE;
1382: -- ELSE
1383: -- l_url_1 := '';
1384: -- l_url_2 := '';
1385: g_date_string := fii_time_api.ent_cper_end(l_as_of_date_3);
1386: -- END IF;
1387:
1388: -- ELSE
1389:

Line 1399: g_date_string := fii_time_api.ent_cper_end(l_as_of_date_3);

1395:
1396: WHEN 'FII_TIME_ENT_PERIOD' THEN
1397: l_url_1 := 'AS_OF_DATE=''||drill_date||''&pFunctionName=FII_AP_E_INV_ENT_DTL&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
1398: l_url_2 := 'AS_OF_DATE='||l_as_of_date_2||'&pFunctionName=FII_AP_E_INV_ENT_DTL&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
1399: g_date_string := fii_time_api.ent_cper_end(l_as_of_date_3);
1400:
1401:
1402: WHEN 'FII_TIME_ENT_YEAR' THEN
1403: l_url_1 := 'AS_OF_DATE=''||drill_date||''&pFunctionName=FII_AP_E_INV_ENT_DTL&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';

Line 1405: g_date_string :=fii_time_api.ent_cyr_end(l_as_of_date_3);

1401:
1402: WHEN 'FII_TIME_ENT_YEAR' THEN
1403: l_url_1 := 'AS_OF_DATE=''||drill_date||''&pFunctionName=FII_AP_E_INV_ENT_DTL&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
1404: l_url_2 := 'AS_OF_DATE='||l_as_of_date_2||'&pFunctionName=FII_AP_E_INV_ENT_DTL&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
1405: g_date_string :=fii_time_api.ent_cyr_end(l_as_of_date_3);
1406:
1407:
1408: WHEN 'FII_TIME_ENT_QTR' THEN
1409: l_url_1 := 'AS_OF_DATE=''||drill_date||''&pFunctionName=FII_AP_E_INV_ENT_DTL&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';

Line 1411: g_date_string :=fii_time_api.ent_cqtr_end(l_as_of_date_3);

1407:
1408: WHEN 'FII_TIME_ENT_QTR' THEN
1409: l_url_1 := 'AS_OF_DATE=''||drill_date||''&pFunctionName=FII_AP_E_INV_ENT_DTL&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
1410: l_url_2 := 'AS_OF_DATE='||l_as_of_date_2||'&pFunctionName=FII_AP_E_INV_ENT_DTL&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
1411: g_date_string :=fii_time_api.ent_cqtr_end(l_as_of_date_3);
1412:
1413:
1414: WHEN 'FII_TIME_WEEK' THEN
1415:

Line 1418: g_date_string := fii_time_api.cwk_end(l_as_of_date_3);

1414: WHEN 'FII_TIME_WEEK' THEN
1415:
1416: l_url_1 := 'AS_OF_DATE=''||drill_date||''&pFunctionName=FII_AP_E_INV_ENT_DTL&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
1417: l_url_2 := 'AS_OF_DATE='||l_as_of_date_2||'&pFunctionName=FII_AP_E_INV_ENT_DTL&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
1418: g_date_string := fii_time_api.cwk_end(l_as_of_date_3);
1419:
1420: END CASE;
1421: ELSE
1422: l_url_1 := '';

Line 1424: g_date_string := fii_time_api.ent_cper_end(l_as_of_date_3);

1420: END CASE;
1421: ELSE
1422: l_url_1 := '';
1423: l_url_2 := '';
1424: g_date_string := fii_time_api.ent_cper_end(l_as_of_date_3);
1425: END IF;
1426:
1427:
1428: --END IF;

Line 1448: (case when FII_MEASURE1 = fii_time_api.cwk_end(&BIS_CURRENT_ASOF_DATE) then to_char(&BIS_CURRENT_ASOF_DATE) else FII_MEASURE1 end) FII_MEASURE1,

1444: WHEN 'FII_TIME_WEEK' then
1445:
1446: sqlstmt := '
1447: SELECT
1448: (case when FII_MEASURE1 = fii_time_api.cwk_end(&BIS_CURRENT_ASOF_DATE) then to_char(&BIS_CURRENT_ASOF_DATE) else FII_MEASURE1 end) FII_MEASURE1,
1449: FII_MEASURE2,
1450: FII_MEASURE3,
1451: FII_MEASURE5,
1452: (CASE WHEN (enddate-fii_time_api.cwk_end(&BIS_CURRENT_ASOF_DATE)) = 0 then '''||l_url_2||''' else '''||l_url_1||''' END ) FII_ATTRIBUTE1

Line 1452: (CASE WHEN (enddate-fii_time_api.cwk_end(&BIS_CURRENT_ASOF_DATE)) = 0 then '''||l_url_2||''' else '''||l_url_1||''' END ) FII_ATTRIBUTE1

1448: (case when FII_MEASURE1 = fii_time_api.cwk_end(&BIS_CURRENT_ASOF_DATE) then to_char(&BIS_CURRENT_ASOF_DATE) else FII_MEASURE1 end) FII_MEASURE1,
1449: FII_MEASURE2,
1450: FII_MEASURE3,
1451: FII_MEASURE5,
1452: (CASE WHEN (enddate-fii_time_api.cwk_end(&BIS_CURRENT_ASOF_DATE)) = 0 then '''||l_url_2||''' else '''||l_url_1||''' END ) FII_ATTRIBUTE1
1453:
1454: FROM(
1455: SELECT
1456: tcur.end_date enddate,