DBA Data[Home] [Help]

APPS.JL_JLCOGLCM_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 109: T_SET_OF_BOOKS_NAME GL_SETS_OF_BOOKS.NAME%TYPE;

105: CHT_ID NUMBER;
106: INIT_FAILURE EXCEPTION;
107: T_SET_OF_BOOKS_ID NUMBER;
108: T_CHART_OF_ACCOUNTS_ID NUMBER;
109: T_SET_OF_BOOKS_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
110: T_FUNC_CURR GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
111: T_PERIOD_NAME GL_PERIODS.PERIOD_NAME%TYPE;
112: T_ERRORBUFFER VARCHAR2(132);
113: STRUCT_NUM VARCHAR2(1000);

Line 110: T_FUNC_CURR GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;

106: INIT_FAILURE EXCEPTION;
107: T_SET_OF_BOOKS_ID NUMBER;
108: T_CHART_OF_ACCOUNTS_ID NUMBER;
109: T_SET_OF_BOOKS_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
110: T_FUNC_CURR GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
111: T_PERIOD_NAME GL_PERIODS.PERIOD_NAME%TYPE;
112: T_ERRORBUFFER VARCHAR2(132);
113: STRUCT_NUM VARCHAR2(1000);
114: SET_OF_BOOKS_NAME VARCHAR2(25);

Line 127: GL_SETS_OF_BOOKS

123: CHART_OF_ACCOUNTS_ID,
124: CURRENCY_CODE
125: INTO T_SET_OF_BOOKS_NAME,T_CHART_OF_ACCOUNTS_ID,T_FUNC_CURR
126: FROM
127: GL_SETS_OF_BOOKS
128: WHERE SET_OF_BOOKS_ID = T_SET_OF_BOOKS_ID;
129: STRUCT_NUM := TO_CHAR(T_CHART_OF_ACCOUNTS_ID);
130: COMPANY_NAME := T_SET_OF_BOOKS_NAME;
131: FUNC_CURR := T_FUNC_CURR;

Line 163: L_CHART_OF_ACCOUNTS_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;

159: RETURN (TRUE);
160: END AFTERREPORT;
161:
162: FUNCTION GET_COMPANY_NAME RETURN BOOLEAN IS
163: L_CHART_OF_ACCOUNTS_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
164: L_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
165: L_SOB_ID NUMBER;
166: BEGIN
167: IF P_SET_OF_BOOKS_ID IS NOT NULL THEN

Line 164: L_NAME GL_SETS_OF_BOOKS.NAME%TYPE;

160: END AFTERREPORT;
161:
162: FUNCTION GET_COMPANY_NAME RETURN BOOLEAN IS
163: L_CHART_OF_ACCOUNTS_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
164: L_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
165: L_SOB_ID NUMBER;
166: BEGIN
167: IF P_SET_OF_BOOKS_ID IS NOT NULL THEN
168: L_SOB_ID := P_SET_OF_BOOKS_ID;

Line 174: GL_SETS_OF_BOOKS

170: NAME,
171: CHART_OF_ACCOUNTS_ID
172: INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
173: FROM
174: GL_SETS_OF_BOOKS
175: WHERE SET_OF_BOOKS_ID = L_SOB_ID;
176: COMPANY_NAME := L_NAME;
177: C_CHART_OF_ACCOUNTS_ID := L_CHART_OF_ACCOUNTS_ID;
178: END IF;