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_CODE_COMBINATIONS

Line 170: V_AUT_TYPE_SEGMENTS GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

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;
174: V_DETAIL_TEMPLATE GL_CODE_COMBINATIONS.TEMPLATE_ID%TYPE;

Line 173: V_ACCOUNT_SEGMENTS GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

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;
174: V_DETAIL_TEMPLATE GL_CODE_COMBINATIONS.TEMPLATE_ID%TYPE;
175: BEGIN
176: V_AUT_TYPE_SEGMENTS := NULL;
177: V_ACCOUNT_SEGMENTS := NULL;

Line 174: V_DETAIL_TEMPLATE GL_CODE_COMBINATIONS.TEMPLATE_ID%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;
174: V_DETAIL_TEMPLATE GL_CODE_COMBINATIONS.TEMPLATE_ID%TYPE;
175: BEGIN
176: V_AUT_TYPE_SEGMENTS := NULL;
177: V_ACCOUNT_SEGMENTS := NULL;
178: V_AUT_TYPE_SEGMENTS := FND_PROFILE.VALUE('JENO_GEI_AUT_TYPE');

Line 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,

180: ,'-'
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;

Line 222: T_INCOME_ACCOUNT GL_CODE_COMBINATIONS.SEGMENT1%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
226: SELECT

Line 223: T_EXPENSE_ACCOUNT GL_CODE_COMBINATIONS.SEGMENT1%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
226: SELECT
227: JUG.AUTHORITY_TYPE AUT_TYPE,