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_QTR

Line 1216: IF p_page_parameter_tbl(i).parameter_name= 'TIME+FII_TIME_ENT_QTR_FROM' THEN

1212: IF p_page_parameter_tbl(i).parameter_name= 'TIME+FII_TIME_ENT_PERIOD_FROM' THEN
1213: p_cur_period := p_page_parameter_tbl(i).parameter_id;
1214: p_id_column := 'ent_period_id';
1215: END IF;
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

Line 1244: WHEN 'FII_TIME_ENT_QTR' THEN

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

Line 1250: from fii_time_ent_qtr

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

Line 1374: -- WHEN 'FII_TIME_ENT_QTR' THEN

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)';
1378: -- WHEN 'FII_TIME_WEEK' THEN

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

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

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

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

Line 1408: WHEN 'FII_TIME_ENT_QTR' THEN

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