APPS.FII_AP_INV_ACTIVITY dependencies on FII_TIME_ENT_PERIOD

Line 1212: IF p_page_parameter_tbl(i).parameter_name= 'TIME+FII_TIME_ENT_PERIOD_FROM' THEN

1208: IF p_page_parameter_tbl(i).parameter_name= 'TIME+FII_TIME_WEEK_FROM' THEN
1209: p_cur_period := p_page_parameter_tbl(i).parameter_id;
1210: p_id_column := 'week_id';
1211: END IF;
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

Line 1237: WHEN 'FII_TIME_ENT_PERIOD' THEN

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

Line 1242: from fii_time_ent_period

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

Line 1366: -- WHEN 'FII_TIME_ENT_PERIOD' THEN

1362: -- IF l_organization <> 'All' and l_supplier <> 'All' then
1363: -- l_url_1 := 'pFunctionName=FII_AP_E_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
1364: -- CASE l_period_type
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

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

1363: -- l_url_1 := 'pFunctionName=FII_AP_E_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
1364: -- CASE l_period_type
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';

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

1364: -- CASE l_period_type
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';

Line 1396: WHEN 'FII_TIME_ENT_PERIOD' THEN

1392: IF l_organization <> 'All' and l_supplier <> 'All' then
1393:
1394: CASE l_period_type
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: