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.JE_JENOGEIS_XMLP_PKG dependencies on GL_BALANCES

Line 169: V_ACTUAL_FLAG GL_BALANCES.ACTUAL_FLAG%TYPE;

165:
166: PROCEDURE P_GEI_VIEW IS
167: BEGIN
168: DECLARE
169: V_ACTUAL_FLAG GL_BALANCES.ACTUAL_FLAG%TYPE;
170: V_AUT_TYPE_SEGMENTS GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
171: V_STRENG VARCHAR2(900);
172: C_PEKER INTEGER;
173: V_ACCOUNT_SEGMENTS GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

Line 185: gl_balances gbs, gl_sets_of_books gso where gbs.code_combination_id = gcc.code_combination_id

181: ,'||');
182: V_DETAIL_TEMPLATE := FND_PROFILE.VALUE('JENO_GEI_DETAIL_TEMPL');
183: V_STRENG := 'create or replace view je_no_gei_sreport_v as select gcc.' || V_AUT_TYPE_SEGMENTS || ' authority_type ,gbs.period_name period,gbs.actual_flag,
184: ' || V_ACCOUNT_SEGMENTS || ' account_number,(gbs.period_net_dr - gbs.period_net_cr) balance,gbs.template_id, gbs.period_num, gbs.period_year from gl_code_combinations gcc,
185: gl_balances gbs, gl_sets_of_books gso where gbs.code_combination_id = gcc.code_combination_id
186: and gbs.ledger_id = gso.set_of_books_id and gso.currency_code = gbs.currency_code and gbs.template_id = ' || V_DETAIL_TEMPLATE;
187: EXECUTE IMMEDIATE
188: V_STRENG;
189: END;

Line 203: PROCEDURE P_INSERT_PERIOD_NAME(P_PERIOD_NAME IN GL_BALANCES.PERIOD_NAME%TYPE

199: WHEN OTHERS THEN
200: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
201: END P_INS_ASCII;
202:
203: PROCEDURE P_INSERT_PERIOD_NAME(P_PERIOD_NAME IN GL_BALANCES.PERIOD_NAME%TYPE
204: ,P_ACCOUNT_INCOME IN GL_BALANCES.PERIOD_NET_DR%TYPE
205: ,P_ACCOUNT_EXPENSE IN GL_BALANCES.PERIOD_NET_DR%TYPE) IS
206: TMP_PERIOD_NUM VARCHAR2(2);
207: TMP_PERIOD VARCHAR2(6);

Line 204: ,P_ACCOUNT_INCOME IN GL_BALANCES.PERIOD_NET_DR%TYPE

200: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
201: END P_INS_ASCII;
202:
203: PROCEDURE P_INSERT_PERIOD_NAME(P_PERIOD_NAME IN GL_BALANCES.PERIOD_NAME%TYPE
204: ,P_ACCOUNT_INCOME IN GL_BALANCES.PERIOD_NET_DR%TYPE
205: ,P_ACCOUNT_EXPENSE IN GL_BALANCES.PERIOD_NET_DR%TYPE) IS
206: TMP_PERIOD_NUM VARCHAR2(2);
207: TMP_PERIOD VARCHAR2(6);
208: TMP_TEXT VARCHAR2(34);

Line 205: ,P_ACCOUNT_EXPENSE IN GL_BALANCES.PERIOD_NET_DR%TYPE) IS

201: END P_INS_ASCII;
202:
203: PROCEDURE P_INSERT_PERIOD_NAME(P_PERIOD_NAME IN GL_BALANCES.PERIOD_NAME%TYPE
204: ,P_ACCOUNT_INCOME IN GL_BALANCES.PERIOD_NET_DR%TYPE
205: ,P_ACCOUNT_EXPENSE IN GL_BALANCES.PERIOD_NET_DR%TYPE) IS
206: TMP_PERIOD_NUM VARCHAR2(2);
207: TMP_PERIOD VARCHAR2(6);
208: TMP_TEXT VARCHAR2(34);
209: T_ORDER_NUMBER VARCHAR2(35);

Line 211: BALANCE_SUM GL_BALANCES.PERIOD_NET_DR%TYPE;

207: TMP_PERIOD VARCHAR2(6);
208: TMP_TEXT VARCHAR2(34);
209: T_ORDER_NUMBER VARCHAR2(35);
210: REF_NUM VARCHAR2(4);
211: BALANCE_SUM GL_BALANCES.PERIOD_NET_DR%TYPE;
212: T_CLOS GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE;
213: TMP_NUMBER NUMBER(34);
214: T_PERIOD_YEAR GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE;
215: T_PERIOD_NUM GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;

Line 216: T_SUM_INCOME GL_BALANCES.PERIOD_NET_DR%TYPE;

212: T_CLOS GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE;
213: TMP_NUMBER NUMBER(34);
214: T_PERIOD_YEAR GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE;
215: T_PERIOD_NUM GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
216: T_SUM_INCOME GL_BALANCES.PERIOD_NET_DR%TYPE;
217: T_SUM_EXPENSE GL_BALANCES.PERIOD_NET_DR%TYPE;
218: T_LINE_NUMBER JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE;
219: T_TEXT JE_NO_GEI_ASCIIS_T.TEXT%TYPE;
220: T_SET_OF_BOOKS GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

Line 217: T_SUM_EXPENSE GL_BALANCES.PERIOD_NET_DR%TYPE;

213: TMP_NUMBER NUMBER(34);
214: T_PERIOD_YEAR GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE;
215: T_PERIOD_NUM GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
216: T_SUM_INCOME GL_BALANCES.PERIOD_NET_DR%TYPE;
217: T_SUM_EXPENSE GL_BALANCES.PERIOD_NET_DR%TYPE;
218: T_LINE_NUMBER JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE;
219: T_TEXT JE_NO_GEI_ASCIIS_T.TEXT%TYPE;
220: T_SET_OF_BOOKS GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
221: T_DETAIL_TEMPL GL_BALANCES.TEMPLATE_ID%TYPE;

Line 221: T_DETAIL_TEMPL GL_BALANCES.TEMPLATE_ID%TYPE;

217: T_SUM_EXPENSE GL_BALANCES.PERIOD_NET_DR%TYPE;
218: T_LINE_NUMBER JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE;
219: T_TEXT JE_NO_GEI_ASCIIS_T.TEXT%TYPE;
220: T_SET_OF_BOOKS GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
221: T_DETAIL_TEMPL GL_BALANCES.TEMPLATE_ID%TYPE;
222: T_INCOME_ACCOUNT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
223: T_EXPENSE_ACCOUNT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
224: PERIOD_NOT_GUILTY EXCEPTION;
225: CURSOR PART_1_CUR IS