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_OPEN_PAY_SUM dependencies on FII_AP_OPEN_PAY_SUM

Line 1: PACKAGE BODY fii_ap_open_pay_sum AS

1: PACKAGE BODY fii_ap_open_pay_sum AS
2: /* $Header: FIIAPS1B.pls 120.2 2006/01/26 00:02:05 vkazhipu noship $ */
3:
4: -- For the Open Payables Summary report --
5: PROCEDURE get_pay_liability (

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

61: END IF;
62:
63: -- To implement the selective drill functionality
64: IF l_viewby_dim = 'ORGANIZATION+FII_OPERATING_UNITS' THEN
65: l_url_1 := 'pFunctionName=FII_AP_OPEN_PAY_SUM&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
66: l_url_2 := 'pFunctionName=FII_AP_OPEN_PAY_SUM&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
67: l_url_3 := 'pFunctionName=FII_AP_OPEN_PAY_SUM&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
68: ELSIF l_viewby_dim = 'SUPPLIER+POA_SUPPLIERS' THEN
69: l_url_1 := 'pFunctionName=FII_AP_UNPAID_INV_DETAIL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_UNPAID_INV_DETAIL';

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

62:
63: -- To implement the selective drill functionality
64: IF l_viewby_dim = 'ORGANIZATION+FII_OPERATING_UNITS' THEN
65: l_url_1 := 'pFunctionName=FII_AP_OPEN_PAY_SUM&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
66: l_url_2 := 'pFunctionName=FII_AP_OPEN_PAY_SUM&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
67: l_url_3 := 'pFunctionName=FII_AP_OPEN_PAY_SUM&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
68: ELSIF l_viewby_dim = 'SUPPLIER+POA_SUPPLIERS' THEN
69: l_url_1 := 'pFunctionName=FII_AP_UNPAID_INV_DETAIL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_UNPAID_INV_DETAIL';
70: l_url_2 := 'pFunctionName=FII_AP_UNPAID_INV_DUE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_UNPAID_INV_DUE';

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

63: -- To implement the selective drill functionality
64: IF l_viewby_dim = 'ORGANIZATION+FII_OPERATING_UNITS' THEN
65: l_url_1 := 'pFunctionName=FII_AP_OPEN_PAY_SUM&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
66: l_url_2 := 'pFunctionName=FII_AP_OPEN_PAY_SUM&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
67: l_url_3 := 'pFunctionName=FII_AP_OPEN_PAY_SUM&VIEW_BY=SUPPLIER+POA_SUPPLIERS&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y';
68: ELSIF l_viewby_dim = 'SUPPLIER+POA_SUPPLIERS' THEN
69: l_url_1 := 'pFunctionName=FII_AP_UNPAID_INV_DETAIL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_UNPAID_INV_DETAIL';
70: l_url_2 := 'pFunctionName=FII_AP_UNPAID_INV_DUE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_UNPAID_INV_DUE';
71: l_url_3 := 'pFunctionName=FII_AP_UNPAID_INV_PAST_DUE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_UNPAID_INV_PAST_DUE';

Line 779: END fii_ap_open_pay_sum;

775:
776: END get_inv_past_due_age;
777:
778:
779: END fii_ap_open_pay_sum;
780: -- End of Summary Reports package
781: