DBA Data[Home] [Help]

APPS.FII_AP_INV_ACTIVITY dependencies on FII_AP_INV_ACTIVITY

Line 1: PACKAGE BODY FII_AP_INV_ACTIVITY AS

1: PACKAGE BODY FII_AP_INV_ACTIVITY AS
2: /* $Header: FIIAPS4B.pls 120.7 2006/03/24 23:11:16 vkazhipu noship $ */
3:
4: --vkazhipu added for performance repository tuning
5: --bug 4997442

Line 55: l_url_1 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';

51: l_supplier_WHERE
52: );
53:
54: IF l_viewby_dim = 'ORGANIZATION+FII_OPERATING_UNITS' THEN
55: l_url_1 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
56: l_url_2 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
57: l_url_3 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
58: ELSIF l_viewby_dim = 'SUPPLIER+POA_SUPPLIERS' THEN
59: l_url_1 := 'pFunctionName=FII_AP_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&FII_CURRENCIES=FII_CURRENCIES&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_INV_ENT_DTL';

Line 56: l_url_2 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';

52: );
53:
54: IF l_viewby_dim = 'ORGANIZATION+FII_OPERATING_UNITS' THEN
55: l_url_1 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
56: l_url_2 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
57: l_url_3 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
58: ELSIF l_viewby_dim = 'SUPPLIER+POA_SUPPLIERS' THEN
59: l_url_1 := 'pFunctionName=FII_AP_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&FII_CURRENCIES=FII_CURRENCIES&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_INV_ENT_DTL';
60: l_url_2 := 'pFunctionName=FII_AP_E_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&FII_CURRENCIES=FII_CURRENCIES&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';

Line 57: l_url_3 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';

53:
54: IF l_viewby_dim = 'ORGANIZATION+FII_OPERATING_UNITS' THEN
55: l_url_1 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
56: l_url_2 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
57: l_url_3 := 'pFunctionName=FII_AP_INV_ACTIVITY&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
58: ELSIF l_viewby_dim = 'SUPPLIER+POA_SUPPLIERS' THEN
59: l_url_1 := 'pFunctionName=FII_AP_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&FII_CURRENCIES=FII_CURRENCIES&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_INV_ENT_DTL';
60: l_url_2 := 'pFunctionName=FII_AP_E_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&FII_CURRENCIES=FII_CURRENCIES&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_E_INV_ENT_DTL';
61: l_url_3 := 'pFunctionName=FII_AP_MANUAL_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&FII_CURRENCIES=FII_CURRENCIES&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_MANUAL_INV_ENT_DTL';

Line 1596: END fii_ap_inv_activity;

1592: p_period_id => l_period_id
1593: );
1594: END get_electronic_inv_trend;
1595:
1596: END fii_ap_inv_activity;