APPS.JE_JENOGEIS_XMLP_PKG dependencies on FND_PROFILE

Line 178: V_AUT_TYPE_SEGMENTS := FND_PROFILE.VALUE('JENO_GEI_AUT_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');
179: V_ACCOUNT_SEGMENTS := REPLACE(FND_PROFILE.VALUE('JENO_GEI_ACCOUNT_SEGMENT')
180: ,'-'
181: ,'||');
182: V_DETAIL_TEMPLATE := FND_PROFILE.VALUE('JENO_GEI_DETAIL_TEMPL');

Line 179: V_ACCOUNT_SEGMENTS := REPLACE(FND_PROFILE.VALUE('JENO_GEI_ACCOUNT_SEGMENT')

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');
179: V_ACCOUNT_SEGMENTS := REPLACE(FND_PROFILE.VALUE('JENO_GEI_ACCOUNT_SEGMENT')
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,

Line 182: V_DETAIL_TEMPLATE := FND_PROFILE.VALUE('JENO_GEI_DETAIL_TEMPL');

178: V_AUT_TYPE_SEGMENTS := FND_PROFILE.VALUE('JENO_GEI_AUT_TYPE');
179: V_ACCOUNT_SEGMENTS := REPLACE(FND_PROFILE.VALUE('JENO_GEI_ACCOUNT_SEGMENT')
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;

Line 262: T_DETAIL_TEMPL := FND_PROFILE.VALUE('JENO_GEI_DETAIL_TEMPL');

258: JUG.AUTHORITY_TYPE,
259: JUG.ACCOUNT_NUMBER;
260: PART_2_CUR_REC PART_2_CUR%ROWTYPE;
261: BEGIN
262: T_DETAIL_TEMPL := FND_PROFILE.VALUE('JENO_GEI_DETAIL_TEMPL');
263: T_LINE_NUMBER := 0;
264: REF_NUM := NULL;
265: BEGIN
266: T_SET_OF_BOOKS := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

Line 266: T_SET_OF_BOOKS := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

262: T_DETAIL_TEMPL := FND_PROFILE.VALUE('JENO_GEI_DETAIL_TEMPL');
263: T_LINE_NUMBER := 0;
264: REF_NUM := NULL;
265: BEGIN
266: T_SET_OF_BOOKS := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
267: SELECT
268: CLOSING_STATUS,
269: PERIOD_YEAR,
270: PERIOD_NUM

Line 317: T_TEXT := T_TEXT || LPAD(FND_PROFILE.VALUE('JENO_GEI_ACCOUNTANT_PROFILE')

313: ,'Unable to derive type of report')*/NULL;
314: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
315: END;
316: BEGIN
317: T_TEXT := T_TEXT || LPAD(FND_PROFILE.VALUE('JENO_GEI_ACCOUNTANT_PROFILE')
318: ,9
319: ,'0');
320: EXCEPTION
321: WHEN OTHERS THEN

Line 375: T_TEXT := T_TEXT || LPAD(FND_PROFILE.VALUE('JENO_GEI_ACC_CENT_PROFILE')

371: ,'Unable to derive order_number')*/NULL;
372: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
373: END;
374: BEGIN
375: T_TEXT := T_TEXT || LPAD(FND_PROFILE.VALUE('JENO_GEI_ACC_CENT_PROFILE')
376: ,9
377: ,'0');
378: P_INS_ASCII(T_LINE_NUMBER
379: ,T_TEXT);

Line 507: T_INCOME_ACCOUNT := FND_PROFILE.VALUE('JENO_GEI_INCOME_ACCOUNT');

503: ,'Unable to derive Income BANK')*/NULL;
504: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
505: END;
506: BEGIN
507: T_INCOME_ACCOUNT := FND_PROFILE.VALUE('JENO_GEI_INCOME_ACCOUNT');
508: T_TEXT := NULL;
509: SELECT
510: NVL(SUM(BALANCE)
511: ,0)

Line 562: T_EXPENSE_ACCOUNT := FND_PROFILE.VALUE('JENO_GEI_EXPENSE_ACCOUNT');

558: ,'Unable to derive Expense')*/NULL;
559: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
560: END;
561: BEGIN
562: T_EXPENSE_ACCOUNT := FND_PROFILE.VALUE('JENO_GEI_EXPENSE_ACCOUNT');
563: T_TEXT := NULL;
564: SELECT
565: NVL(SUM(BALANCE)
566: ,0)