DBA Data[Home] [Help]

APPS.GMF_GMFINVAL_XMLP_PKG dependencies on GMF_FISCAL_POLICIES

Line 4: L_BASE_CURRENCY_CODE GMF_FISCAL_POLICIES.BASE_CURRENCY_CODE%TYPE;

1: PACKAGE BODY GMF_GMFINVAL_XMLP_PKG AS
2: /* $Header: GMFINVALB.pls 120.0 2007/12/24 13:31:48 nchinnam noship $ */
3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4: L_BASE_CURRENCY_CODE GMF_FISCAL_POLICIES.BASE_CURRENCY_CODE%TYPE;
5: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS
6: SELECT
7: BASE_CURRENCY_CODE
8: FROM

Line 5: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS

1: PACKAGE BODY GMF_GMFINVAL_XMLP_PKG AS
2: /* $Header: GMFINVALB.pls 120.0 2007/12/24 13:31:48 nchinnam noship $ */
3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4: L_BASE_CURRENCY_CODE GMF_FISCAL_POLICIES.BASE_CURRENCY_CODE%TYPE;
5: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS
6: SELECT
7: BASE_CURRENCY_CODE
8: FROM
9: GMF_FISCAL_POLICIES

Line 9: GMF_FISCAL_POLICIES

5: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS
6: SELECT
7: BASE_CURRENCY_CODE
8: FROM
9: GMF_FISCAL_POLICIES
10: WHERE LEGAL_ENTITY_ID = CP_LEGAL_ENTITY_ID;
11: BEGIN
12: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
13: OPEN CUR_CURRENCY_CODE(P_LEGAL_ENTITY_ID);

Line 186: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS

182: RETURN (BALANCECP);
183: END BALANCECFFORMULA;
184: FUNCTION CF_BASE_CURRENCYFORMULA RETURN VARCHAR2 IS
185: L_BASE_CURRENCY_CODE GL_PLCY_MST.BASE_CURRENCY_CODE%TYPE;
186: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS
187: SELECT
188: BASE_CURRENCY_CODE
189: FROM
190: GMF_FISCAL_POLICIES

Line 190: GMF_FISCAL_POLICIES

186: CURSOR CUR_CURRENCY_CODE(CP_LEGAL_ENTITY_ID IN GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE) IS
187: SELECT
188: BASE_CURRENCY_CODE
189: FROM
190: GMF_FISCAL_POLICIES
191: WHERE LEGAL_ENTITY_ID = CP_LEGAL_ENTITY_ID;
192: BEGIN
193: OPEN CUR_CURRENCY_CODE(P_LEGAL_ENTITY_ID);
194: FETCH CUR_CURRENCY_CODE