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.

[Home] [Help]

APPS.FII_AP_INV_ACTIVITY dependencies on FII_TIME_ENT_YEAR

Line 1220: IF p_page_parameter_tbl(i).parameter_name= 'TIME+FII_TIME_ENT_YEAR_FROM' THEN

1216: IF p_page_parameter_tbl(i).parameter_name= 'TIME+FII_TIME_ENT_QTR_FROM' THEN
1217: p_cur_period := p_page_parameter_tbl(i).parameter_id;
1218: p_id_column := 'ent_qtr_id';
1219: END IF;
1220: IF p_page_parameter_tbl(i).parameter_name= 'TIME+FII_TIME_ENT_YEAR_FROM' THEN
1221: p_cur_period := p_page_parameter_tbl(i).parameter_id;
1222: p_id_column := 'ent_year_id';
1223: END IF;
1224: END LOOP;

Line 1227: select nvl(min(start_date), trunc(sysdate)) into l_start_date from fii_time_ent_year;

1223: END IF;
1224: END LOOP;
1225: END IF;
1226:
1227: select nvl(min(start_date), trunc(sysdate)) into l_start_date from fii_time_ent_year;
1228:
1229: CASE l_period_type
1230: WHEN 'FII_TIME_WEEK' THEN
1231: p_period_id := 16;

Line 1252: WHEN 'FII_TIME_ENT_YEAR' THEN

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;
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)

Line 1261: from fii_time_ent_year

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;
1264:
1265: END get_period_details;

Line 1370: -- WHEN 'FII_TIME_ENT_YEAR' THEN

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)';
1374: -- WHEN 'FII_TIME_ENT_QTR' THEN

Line 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';

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)';
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';

Line 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';

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)';
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';

Line 1402: WHEN 'FII_TIME_ENT_YEAR' THEN

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';
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: