DBA Data[Home] [Help]

APPS.JA_CN_GL_BANK_EXP_PKG dependencies on JA_CN_UTILITY

Line 330: JA_CN_UTILITY.Get_XML_Encoding || '"?>');

326:
327: --Step0: Generate XML header part
328: FND_FILE.put_line(FND_FILE.output,
329: ' 330: JA_CN_UTILITY.Get_XML_Encoding || '"?>');
331:
332: --added by jar.wang for bug 16655327
333: /* lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
334: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||

Line 333: /* lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||

329: ' 330: JA_CN_UTILITY.Get_XML_Encoding || '"?>');
331:
332: --added by jar.wang for bug 16655327
333: /* lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
334: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
335: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"'||
336: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
337: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||

Line 336: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||

332: --added by jar.wang for bug 16655327
333: /* lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
334: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
335: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"'||
336: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
337: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
338: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||'.xsd">';
339: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
340: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||

Line 338: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||'.xsd">';

334: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
335: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"'||
336: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
337: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
338: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||'.xsd">';
339: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
340: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
341: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
342: '.xsd" xmlns:' || Ja_Cn_Utility.Get_XML_Tag('BANK') ||

Line 339: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||

335: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"'||
336: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
337: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
338: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||'.xsd">';
339: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
340: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
341: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
342: '.xsd" xmlns:' || Ja_Cn_Utility.Get_XML_Tag('BANK') ||
343: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"' ||

Line 341: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||

337: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
338: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||'.xsd">';
339: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
340: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
341: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
342: '.xsd" xmlns:' || Ja_Cn_Utility.Get_XML_Tag('BANK') ||
343: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"' ||
344: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
345: */

Line 342: '.xsd" xmlns:' || Ja_Cn_Utility.Get_XML_Tag('BANK') ||

338: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||'.xsd">';
339: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
340: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
341: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
342: '.xsd" xmlns:' || Ja_Cn_Utility.Get_XML_Tag('BANK') ||
343: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"' ||
344: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
345: */
346:

Line 347: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||

343: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"' ||
344: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
345: */
346:
347: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
348: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
349: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||'.xsd"'||
350: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'
351: ||' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||

Line 349: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||'.xsd"'||

345: */
346:
347: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
348: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
349: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||'.xsd"'||
350: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'
351: ||' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
352: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">' ;
353:

Line 350: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'

346:
347: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||
348: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
349: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') ||'.xsd"'||
350: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'
351: ||' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
352: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">' ;
353:
354: FND_FILE.put_line(FND_FILE.output, lv_gl_element);

Line 357: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE_FLIE',Ja_Cn_Utility.GV_TAG_TYPE_START);

353:
354: FND_FILE.put_line(FND_FILE.output, lv_gl_element);
355:
356: FND_FILE.put_line(FND_FILE.log, 'Setup1:Add_GL_BALANCE');
357: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE_FLIE',Ja_Cn_Utility.GV_TAG_TYPE_START);
358: Recursion_BSV(pn_chart_of_account_id ,
359: pn_ledger_id ,
360: pn_legal_entity_id ,
361: pv_bsv ,

Line 367: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE_FLIE', Ja_Cn_Utility.GV_TAG_TYPE_END);

363: pv_period_from ,
364: pv_period_to ,
365: 1 );
366: Print_GL_BALANCE;
367: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE_FLIE', Ja_Cn_Utility.GV_TAG_TYPE_END);
368:
369: FND_FILE.put_line(FND_FILE.log, 'Setup2:Add_GL_AVG_BAL');
370: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_START);
371: Recursion_BSV(pn_chart_of_account_id ,

Line 370: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_START);

366: Print_GL_BALANCE;
367: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE_FLIE', Ja_Cn_Utility.GV_TAG_TYPE_END);
368:
369: FND_FILE.put_line(FND_FILE.log, 'Setup2:Add_GL_AVG_BAL');
370: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_START);
371: Recursion_BSV(pn_chart_of_account_id ,
372: pn_ledger_id ,
373: pn_legal_entity_id ,
374: pv_bsv ,

Line 380: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_END);

376: pv_period_from ,
377: pv_period_to ,
378: 2 );
379: Print_GL_AVG_BAL;
380: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_END);
381:
382:
383: FND_FILE.put_line(FND_FILE.log, 'Setup3:Add_GL_JOURNAL');
384: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_START);

Line 384: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_START);

380: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_END);
381:
382:
383: FND_FILE.put_line(FND_FILE.log, 'Setup3:Add_GL_JOURNAL');
384: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_START);
385: Recursion_BSV(pn_chart_of_account_id ,
386: pn_ledger_id ,
387: pn_legal_entity_id ,
388: pv_bsv ,

Line 393: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL_FILE', Ja_Cn_Utility.GV_TAG_TYPE_END);

389: pv_accounting_year ,
390: pv_period_from ,
391: pv_period_to ,
392: 3 );
393: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL_FILE', Ja_Cn_Utility.GV_TAG_TYPE_END);
394: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER',Ja_Cn_Utility.GV_TAG_TYPE_END));
395: COMMIT;
396: --logging for debug
397: IF (ln_proc_level >= ln_dbg_level) THEN

Line 394: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER',Ja_Cn_Utility.GV_TAG_TYPE_END));

390: pv_period_from ,
391: pv_period_to ,
392: 3 );
393: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL_FILE', Ja_Cn_Utility.GV_TAG_TYPE_END);
394: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER',Ja_Cn_Utility.GV_TAG_TYPE_END));
395: COMMIT;
396: --logging for debug
397: IF (ln_proc_level >= ln_dbg_level) THEN
398: FND_LOG.STRING(ln_proc_level,

Line 497: SELECT Ja_Cn_Utility.GET_ACCOUNTING_SEGMENT(GBS.CODE_COMBINATION_ID) ACCOUNT_SEG,

493: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
494: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
495:
496: CURSOR CUR_GL_BAL(c_from date, c_to date) is
497: SELECT Ja_Cn_Utility.GET_ACCOUNTING_SEGMENT(GBS.CODE_COMBINATION_ID) ACCOUNT_SEG,
498: GBS.CURRENCY_CODE,
499: GBS.PERIOD_YEAR,
500: GBS.PERIOD_NUM,
501: --SUM( DECODE(GBS.CURRENCY_CODE,GLS.CURRENCY_CODE,GBS.BEGIN_BALANCE_DR_BEQ,GBS.BEGIN_BALANCE_DR) ) BEGIN_BALANCE_DR,

Line 545: AND Ja_Cn_Utility.get_balancing_segment(GBS.CODE_COMBINATION_ID)=pv_bsv

541: GBS.PERIOD_NET_DR_BEQ - GBS.PERIOD_NET_CR_BEQ)) YTD_BEQ
542: FROM GL_BALANCES GBS, GL_LEDGERS GLS
543: WHERE GBS.LEDGER_ID = GLS.LEDGER_ID
544: AND GBS.LEDGER_ID =pn_ledger_id
545: AND Ja_Cn_Utility.get_balancing_segment(GBS.CODE_COMBINATION_ID)=pv_bsv
546: AND PERIOD_NAME in
547: (SELECT period_name
548: FROM GL_PERIOD_STATUSES
549: WHERE ledger_id = pn_ledger_id

Line 553: GROUP BY Ja_Cn_Utility.GET_ACCOUNTING_SEGMENT(GBS.CODE_COMBINATION_ID),

549: WHERE ledger_id = pn_ledger_id
550: AND application_id = 101
551: AND ((start_date BETWEEN c_from AND c_to) AND
552: (end_date BETWEEN c_from AND c_to)))
553: GROUP BY Ja_Cn_Utility.GET_ACCOUNTING_SEGMENT(GBS.CODE_COMBINATION_ID),
554: GBS.CURRENCY_CODE,
555: GBS.PERIOD_YEAR,
556: GBS.PERIOD_NUM;
557: l_gl_bal CUR_GL_BAL%ROWTYPE;

Line 699: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);

695: FETCH CUR_GL_BAL INTO l_gl_bal;
696: EXIT WHEN CUR_GL_BAL%NOTFOUND;
697: l_row_count:=l_row_count+1;
698: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.2');
699: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
700: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_gl_bal.account_seg);
701: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_gl_bal.currency_code);
702: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_gl_bal.period_year);
703: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_gl_bal.period_num);

Line 700: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_gl_bal.account_seg);

696: EXIT WHEN CUR_GL_BAL%NOTFOUND;
697: l_row_count:=l_row_count+1;
698: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.2');
699: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
700: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_gl_bal.account_seg);
701: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_gl_bal.currency_code);
702: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_gl_bal.period_year);
703: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_gl_bal.period_num);
704: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE',nvl(l_gl_bal.begin_balance,0));

Line 701: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_gl_bal.currency_code);

697: l_row_count:=l_row_count+1;
698: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.2');
699: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
700: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_gl_bal.account_seg);
701: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_gl_bal.currency_code);
702: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_gl_bal.period_year);
703: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_gl_bal.period_num);
704: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE',nvl(l_gl_bal.begin_balance,0));
705: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE',nvl(l_gl_bal.begin_balance_beq,0));

Line 702: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_gl_bal.period_year);

698: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.2');
699: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
700: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_gl_bal.account_seg);
701: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_gl_bal.currency_code);
702: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_gl_bal.period_year);
703: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_gl_bal.period_num);
704: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE',nvl(l_gl_bal.begin_balance,0));
705: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE',nvl(l_gl_bal.begin_balance_beq,0));
706: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_dr,0));

Line 703: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_gl_bal.period_num);

699: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
700: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_gl_bal.account_seg);
701: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_gl_bal.currency_code);
702: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_gl_bal.period_year);
703: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_gl_bal.period_num);
704: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE',nvl(l_gl_bal.begin_balance,0));
705: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE',nvl(l_gl_bal.begin_balance_beq,0));
706: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_dr,0));
707: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_dr_beq,0));

Line 704: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE',nvl(l_gl_bal.begin_balance,0));

700: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_gl_bal.account_seg);
701: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_gl_bal.currency_code);
702: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_gl_bal.period_year);
703: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_gl_bal.period_num);
704: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE',nvl(l_gl_bal.begin_balance,0));
705: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE',nvl(l_gl_bal.begin_balance_beq,0));
706: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_dr,0));
707: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_dr_beq,0));
708: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_cr,0));

Line 705: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE',nvl(l_gl_bal.begin_balance_beq,0));

701: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_gl_bal.currency_code);
702: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_gl_bal.period_year);
703: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_gl_bal.period_num);
704: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE',nvl(l_gl_bal.begin_balance,0));
705: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE',nvl(l_gl_bal.begin_balance_beq,0));
706: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_dr,0));
707: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_dr_beq,0));
708: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_cr,0));
709: --Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_cr_beq,0));

Line 706: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_dr,0));

702: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_gl_bal.period_year);
703: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_gl_bal.period_num);
704: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE',nvl(l_gl_bal.begin_balance,0));
705: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE',nvl(l_gl_bal.begin_balance_beq,0));
706: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_dr,0));
707: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_dr_beq,0));
708: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_cr,0));
709: --Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_cr_beq,0));
710: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AM',nvl(l_gl_bal.period_net_cr_beq,0));

Line 707: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_dr_beq,0));

703: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_gl_bal.period_num);
704: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE',nvl(l_gl_bal.begin_balance,0));
705: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE',nvl(l_gl_bal.begin_balance_beq,0));
706: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_dr,0));
707: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_dr_beq,0));
708: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_cr,0));
709: --Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_cr_beq,0));
710: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AM',nvl(l_gl_bal.period_net_cr_beq,0));
711: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE',nvl(l_gl_bal.ytd,0));

Line 708: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_cr,0));

704: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE',nvl(l_gl_bal.begin_balance,0));
705: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE',nvl(l_gl_bal.begin_balance_beq,0));
706: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_dr,0));
707: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_dr_beq,0));
708: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_cr,0));
709: --Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_cr_beq,0));
710: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AM',nvl(l_gl_bal.period_net_cr_beq,0));
711: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE',nvl(l_gl_bal.ytd,0));
712: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE',nvl(l_gl_bal.ytd_beq,0));

Line 709: --Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_cr_beq,0));

705: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE',nvl(l_gl_bal.begin_balance_beq,0));
706: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_dr,0));
707: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_dr_beq,0));
708: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_cr,0));
709: --Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_cr_beq,0));
710: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AM',nvl(l_gl_bal.period_net_cr_beq,0));
711: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE',nvl(l_gl_bal.ytd,0));
712: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE',nvl(l_gl_bal.ytd_beq,0));
713: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);

Line 710: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AM',nvl(l_gl_bal.period_net_cr_beq,0));

706: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_dr,0));
707: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_dr_beq,0));
708: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_cr,0));
709: --Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_cr_beq,0));
710: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AM',nvl(l_gl_bal.period_net_cr_beq,0));
711: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE',nvl(l_gl_bal.ytd,0));
712: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE',nvl(l_gl_bal.ytd_beq,0));
713: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);
714: END LOOP;

Line 711: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE',nvl(l_gl_bal.ytd,0));

707: Ja_Cn_Utility.Add_Child_Node('PERIOD_DEBIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_dr_beq,0));
708: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_cr,0));
709: --Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_cr_beq,0));
710: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AM',nvl(l_gl_bal.period_net_cr_beq,0));
711: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE',nvl(l_gl_bal.ytd,0));
712: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE',nvl(l_gl_bal.ytd_beq,0));
713: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);
714: END LOOP;
715: CLOSE CUR_GL_BAL;

Line 712: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE',nvl(l_gl_bal.ytd_beq,0));

708: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_ENTERED_AMOUNT',nvl(l_gl_bal.period_net_cr,0));
709: --Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_cr_beq,0));
710: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AM',nvl(l_gl_bal.period_net_cr_beq,0));
711: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE',nvl(l_gl_bal.ytd,0));
712: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE',nvl(l_gl_bal.ytd_beq,0));
713: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);
714: END LOOP;
715: CLOSE CUR_GL_BAL;
716:

Line 713: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);

709: --Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AMOUNT',nvl(l_gl_bal.period_net_cr_beq,0));
710: Ja_Cn_Utility.Add_Child_Node('PERIOD_CREDIT_FUNCTIONAL_AM',nvl(l_gl_bal.period_net_cr_beq,0));
711: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE',nvl(l_gl_bal.ytd,0));
712: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE',nvl(l_gl_bal.ytd_beq,0));
713: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);
714: END LOOP;
715: CLOSE CUR_GL_BAL;
716:
717: --no data found

Line 719: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);

715: CLOSE CUR_GL_BAL;
716:
717: --no data found
718: IF l_row_count=0 THEN
719: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
720: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','');
721: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
722: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
723: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');

Line 720: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','');

716:
717: --no data found
718: IF l_row_count=0 THEN
719: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
720: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','');
721: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
722: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
723: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
724: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE','');

Line 721: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');

717: --no data found
718: IF l_row_count=0 THEN
719: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
720: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','');
721: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
722: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
723: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
724: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE','');
725: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE','');

Line 722: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');

718: IF l_row_count=0 THEN
719: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
720: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','');
721: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
722: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
723: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
724: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE','');
725: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE','');
726: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');

Line 723: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');

719: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
720: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','');
721: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
722: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
723: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
724: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE','');
725: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE','');
726: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
727: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');

Line 724: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE','');

720: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','');
721: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
722: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
723: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
724: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE','');
725: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE','');
726: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
727: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
728: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');

Line 725: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE','');

721: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
722: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
723: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
724: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE','');
725: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE','');
726: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
727: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
728: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
729: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');

Line 726: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');

722: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
723: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
724: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE','');
725: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE','');
726: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
727: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
728: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
729: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
730: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE','');

Line 727: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');

723: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
724: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE','');
725: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE','');
726: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
727: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
728: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
729: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
730: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE','');
731: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE','');

Line 728: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');

724: Ja_Cn_Utility.Add_Child_Node('BEGINNING_ENTERED_BALANCE','');
725: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE','');
726: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
727: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
728: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
729: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
730: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE','');
731: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE','');
732: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);

Line 729: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');

725: Ja_Cn_Utility.Add_Child_Node('BEGINNING_FUNCTIONAL_BALANCE','');
726: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
727: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
728: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
729: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
730: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE','');
731: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE','');
732: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);
733: END IF;

Line 730: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE','');

726: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
727: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
728: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
729: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
730: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE','');
731: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE','');
732: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);
733: END IF;
734:

Line 731: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE','');

727: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
728: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
729: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
730: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE','');
731: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE','');
732: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);
733: END IF;
734:
735: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.3');

Line 732: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);

728: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
729: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
730: Ja_Cn_Utility.Add_Child_Node('END_ENTERED_BALANCE','');
731: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE','');
732: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);
733: END IF;
734:
735: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.3');
736: --logging for debug

Line 771: SELECT JA_CN_UTILITY.GET_ACCOUNTING_SEGMENT(GJL.CODE_COMBINATION_ID) ACCOUNT_SEG,

767: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
768:
769: CURSOR CUR_AVG_JOURNAL(c_from date, c_to date)
770: IS
771: SELECT JA_CN_UTILITY.GET_ACCOUNTING_SEGMENT(GJL.CODE_COMBINATION_ID) ACCOUNT_SEG,
772: GJH.CURRENCY_CODE,
773: TO_CHAR(GJH.DEFAULT_EFFECTIVE_DATE, 'YYYY') PERIOD_YEAR,
774: TO_CHAR(GJH.DEFAULT_EFFECTIVE_DATE, 'MM') PERIOD_NUM,
775: TO_CHAR(GJH.DEFAULT_EFFECTIVE_DATE, 'YYYYMMDD') JOURNAL_DATE,

Line 783: AND JA_CN_UTILITY.get_balancing_segment(GJL.CODE_COMBINATION_ID) = pv_bsv

779: SUM(GJL.ACCOUNTED_CR) ACCOUNTED_CR
780: FROM GL_JE_HEADERS GJH, GL_JE_LINES GJL
781: WHERE GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
782: AND gjh.status = 'P'
783: AND JA_CN_UTILITY.get_balancing_segment(GJL.CODE_COMBINATION_ID) = pv_bsv
784: AND GJH.LEDGER_ID = pn_ledger_id
785: AND GJH.PERIOD_NAME in
786: (SELECT period_name
787: FROM GL_PERIOD_STATUSES

Line 792: GROUP BY JA_CN_UTILITY.GET_ACCOUNTING_SEGMENT(GJL.CODE_COMBINATION_ID),GJH.DEFAULT_EFFECTIVE_DATE ,GJH.CURRENCY_CODE;

788: WHERE ledger_id = pn_ledger_id
789: AND application_id = 101
790: AND ((start_date BETWEEN c_from AND c_to) AND
791: (end_date BETWEEN c_from AND c_to)))
792: GROUP BY JA_CN_UTILITY.GET_ACCOUNTING_SEGMENT(GJL.CODE_COMBINATION_ID),GJH.DEFAULT_EFFECTIVE_DATE ,GJH.CURRENCY_CODE;
793: l_period_from DATE;
794: l_period_to DATE;
795: l_journal CUR_AVG_JOURNAL%ROWTYPE;
796: BEGIN

Line 902: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);

898: LOOP
899: FETCH CUR_AVG_JOURNAL INTO l_journal;
900: EXIT WHEN CUR_AVG_JOURNAL%NOTFOUND;
901: l_row_count :=l_row_count+1;
902: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);
903: FND_FILE.put_line(FND_FILE.log, 'AVG Setup1.2 ');
904: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG );
905: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE );
906: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR );

Line 904: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG );

900: EXIT WHEN CUR_AVG_JOURNAL%NOTFOUND;
901: l_row_count :=l_row_count+1;
902: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);
903: FND_FILE.put_line(FND_FILE.log, 'AVG Setup1.2 ');
904: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG );
905: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE );
906: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR );
907: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM );
908: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE',l_journal.JOURNAL_DATE );

Line 905: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE );

901: l_row_count :=l_row_count+1;
902: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);
903: FND_FILE.put_line(FND_FILE.log, 'AVG Setup1.2 ');
904: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG );
905: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE );
906: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR );
907: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM );
908: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE',l_journal.JOURNAL_DATE );
909: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));

Line 906: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR );

902: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);
903: FND_FILE.put_line(FND_FILE.log, 'AVG Setup1.2 ');
904: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG );
905: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE );
906: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR );
907: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM );
908: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE',l_journal.JOURNAL_DATE );
909: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
910: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));

Line 907: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM );

903: FND_FILE.put_line(FND_FILE.log, 'AVG Setup1.2 ');
904: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG );
905: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE );
906: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR );
907: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM );
908: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE',l_journal.JOURNAL_DATE );
909: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
910: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
911: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));

Line 908: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE',l_journal.JOURNAL_DATE );

904: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG );
905: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE );
906: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR );
907: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM );
908: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE',l_journal.JOURNAL_DATE );
909: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
910: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
911: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
912: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));

Line 909: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));

905: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE );
906: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR );
907: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM );
908: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE',l_journal.JOURNAL_DATE );
909: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
910: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
911: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
912: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
913:

Line 910: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));

906: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR );
907: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM );
908: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE',l_journal.JOURNAL_DATE );
909: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
910: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
911: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
912: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
913:
914: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_END);

Line 911: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));

907: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM );
908: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE',l_journal.JOURNAL_DATE );
909: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
910: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
911: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
912: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
913:
914: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_END);
915: END LOOP;

Line 912: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));

908: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE',l_journal.JOURNAL_DATE );
909: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
910: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
911: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
912: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
913:
914: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_END);
915: END LOOP;
916: CLOSE CUR_AVG_JOURNAL;

Line 914: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_END);

910: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
911: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
912: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
913:
914: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_END);
915: END LOOP;
916: CLOSE CUR_AVG_JOURNAL;
917: --no data found
918: IF l_row_count=0 THEN

Line 919: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);

915: END LOOP;
916: CLOSE CUR_AVG_JOURNAL;
917: --no data found
918: IF l_row_count=0 THEN
919: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);
920: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','' );
921: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','' );
922: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','' );
923: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');

Line 920: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','' );

916: CLOSE CUR_AVG_JOURNAL;
917: --no data found
918: IF l_row_count=0 THEN
919: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);
920: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','' );
921: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','' );
922: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','' );
923: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
924: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE','');

Line 921: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','' );

917: --no data found
918: IF l_row_count=0 THEN
919: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);
920: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','' );
921: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','' );
922: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','' );
923: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
924: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE','');
925: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');

Line 922: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','' );

918: IF l_row_count=0 THEN
919: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);
920: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','' );
921: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','' );
922: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','' );
923: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
924: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE','');
925: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
926: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');

Line 923: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');

919: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);
920: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','' );
921: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','' );
922: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','' );
923: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
924: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE','');
925: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
926: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
927: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');

Line 924: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE','');

920: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER','' );
921: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','' );
922: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','' );
923: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
924: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE','');
925: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
926: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
927: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
928: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');

Line 925: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');

921: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','' );
922: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','' );
923: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
924: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE','');
925: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
926: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
927: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
928: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
929:

Line 926: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');

922: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','' );
923: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
924: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE','');
925: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
926: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
927: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
928: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
929:
930: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_END);

Line 927: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');

923: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
924: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE','');
925: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
926: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
927: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
928: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
929:
930: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_END);
931: END IF;

Line 928: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');

924: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DATE','');
925: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
926: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
927: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
928: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
929:
930: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_END);
931: END IF;
932:

Line 930: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_END);

926: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
927: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
928: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
929:
930: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_END);
931: END IF;
932:
933: --logging for debug
934: IF (ln_proc_level >= ln_dbg_level) THEN

Line 996: JA_CN_UTILITY.GET_ACCOUNTING_SEGMENT(GJL.CODE_COMBINATION_ID) ACCOUNT_SEG,

992: IS
993: SELECT TO_CHAR(GJH.DEFAULT_EFFECTIVE_DATE, 'YYYYMMDD') JOURNAL_DATE,
994: GJH.DESCRIPTION,
995: GJL.JE_LINE_NUM,
996: JA_CN_UTILITY.GET_ACCOUNTING_SEGMENT(GJL.CODE_COMBINATION_ID) ACCOUNT_SEG,
997: GJH.CURRENCY_CODE,
998: GJL.ENTERED_DR,
999: GJL.ACCOUNTED_DR,
1000: GJL.ENTERED_CR,

Line 1018: AND JA_CN_UTILITY.get_balancing_segment(GJL.CODE_COMBINATION_ID) = pv_bsv

1014: WHERE GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
1015: AND gjh.status = 'P'
1016: AND FU.USER_ID = GJL.CREATED_BY
1017: AND FU2.USER_ID = GJL.LAST_UPDATED_BY
1018: AND JA_CN_UTILITY.get_balancing_segment(GJL.CODE_COMBINATION_ID) = pv_bsv
1019: AND GJH.LEDGER_ID = pn_ledger_id
1020: AND GJH.PERIOD_NAME in
1021: (SELECT period_name
1022: FROM GL_PERIOD_STATUSES

Line 1102: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);

1098: fnd_global.LOGIN_ID);
1099:
1100: END IF;
1101: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.4:'||l_vouchernum);
1102: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1103: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER',l_vouchernum);
1104: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE',l_journal.journal_date);
1105: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION',l_journal.DESCRIPTION);
1106: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER',l_journal.JE_LINE_NUM);

Line 1103: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER',l_vouchernum);

1099:
1100: END IF;
1101: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.4:'||l_vouchernum);
1102: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1103: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER',l_vouchernum);
1104: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE',l_journal.journal_date);
1105: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION',l_journal.DESCRIPTION);
1106: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER',l_journal.JE_LINE_NUM);
1107: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG);

Line 1104: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE',l_journal.journal_date);

1100: END IF;
1101: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.4:'||l_vouchernum);
1102: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1103: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER',l_vouchernum);
1104: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE',l_journal.journal_date);
1105: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION',l_journal.DESCRIPTION);
1106: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER',l_journal.JE_LINE_NUM);
1107: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG);
1108: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE);

Line 1105: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION',l_journal.DESCRIPTION);

1101: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.4:'||l_vouchernum);
1102: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1103: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER',l_vouchernum);
1104: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE',l_journal.journal_date);
1105: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION',l_journal.DESCRIPTION);
1106: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER',l_journal.JE_LINE_NUM);
1107: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG);
1108: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE);
1109: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));

Line 1106: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER',l_journal.JE_LINE_NUM);

1102: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1103: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER',l_vouchernum);
1104: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE',l_journal.journal_date);
1105: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION',l_journal.DESCRIPTION);
1106: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER',l_journal.JE_LINE_NUM);
1107: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG);
1108: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE);
1109: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
1110: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));

Line 1107: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG);

1103: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER',l_vouchernum);
1104: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE',l_journal.journal_date);
1105: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION',l_journal.DESCRIPTION);
1106: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER',l_journal.JE_LINE_NUM);
1107: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG);
1108: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE);
1109: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
1110: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
1111: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));

Line 1108: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE);

1104: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE',l_journal.journal_date);
1105: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION',l_journal.DESCRIPTION);
1106: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER',l_journal.JE_LINE_NUM);
1107: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG);
1108: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE);
1109: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
1110: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
1111: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
1112: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));

Line 1109: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));

1105: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION',l_journal.DESCRIPTION);
1106: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER',l_journal.JE_LINE_NUM);
1107: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG);
1108: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE);
1109: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
1110: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
1111: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
1112: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
1113: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY',l_journal.ATTACHMENT);

Line 1110: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));

1106: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER',l_journal.JE_LINE_NUM);
1107: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG);
1108: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE);
1109: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
1110: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
1111: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
1112: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
1113: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY',l_journal.ATTACHMENT);
1114: --Ja_Cn_Utility.Add_Child_Node('CREATOR',l_journal.CREATOR); --added by jar.wang for bug 16075191

Line 1111: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));

1107: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG);
1108: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE);
1109: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
1110: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
1111: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
1112: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
1113: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY',l_journal.ATTACHMENT);
1114: --Ja_Cn_Utility.Add_Child_Node('CREATOR',l_journal.CREATOR); --added by jar.wang for bug 16075191
1115: Ja_Cn_Utility.Add_Child_Node('CREATOR',Get_Fullname(l_journal.CREATOR));

Line 1112: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));

1108: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE);
1109: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
1110: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
1111: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
1112: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
1113: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY',l_journal.ATTACHMENT);
1114: --Ja_Cn_Utility.Add_Child_Node('CREATOR',l_journal.CREATOR); --added by jar.wang for bug 16075191
1115: Ja_Cn_Utility.Add_Child_Node('CREATOR',Get_Fullname(l_journal.CREATOR));
1116: --Ja_Cn_Utility.Add_Child_Node('REVIEWER',l_journal.REVIEWER); --added by jar.wang for bug 16075191

Line 1113: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY',l_journal.ATTACHMENT);

1109: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_DR,0));
1110: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
1111: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
1112: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
1113: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY',l_journal.ATTACHMENT);
1114: --Ja_Cn_Utility.Add_Child_Node('CREATOR',l_journal.CREATOR); --added by jar.wang for bug 16075191
1115: Ja_Cn_Utility.Add_Child_Node('CREATOR',Get_Fullname(l_journal.CREATOR));
1116: --Ja_Cn_Utility.Add_Child_Node('REVIEWER',l_journal.REVIEWER); --added by jar.wang for bug 16075191
1117: l_approver := Get_Approver(l_journal.je_header_id,l_journal.CREATOR);

Line 1114: --Ja_Cn_Utility.Add_Child_Node('CREATOR',l_journal.CREATOR); --added by jar.wang for bug 16075191

1110: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_DR,0));
1111: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
1112: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
1113: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY',l_journal.ATTACHMENT);
1114: --Ja_Cn_Utility.Add_Child_Node('CREATOR',l_journal.CREATOR); --added by jar.wang for bug 16075191
1115: Ja_Cn_Utility.Add_Child_Node('CREATOR',Get_Fullname(l_journal.CREATOR));
1116: --Ja_Cn_Utility.Add_Child_Node('REVIEWER',l_journal.REVIEWER); --added by jar.wang for bug 16075191
1117: l_approver := Get_Approver(l_journal.je_header_id,l_journal.CREATOR);
1118: Ja_Cn_Utility.Add_Child_Node('REVIEWER',Get_Fullname(l_approver));

Line 1115: Ja_Cn_Utility.Add_Child_Node('CREATOR',Get_Fullname(l_journal.CREATOR));

1111: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT',nvl(l_journal.ENTERED_CR,0));
1112: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
1113: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY',l_journal.ATTACHMENT);
1114: --Ja_Cn_Utility.Add_Child_Node('CREATOR',l_journal.CREATOR); --added by jar.wang for bug 16075191
1115: Ja_Cn_Utility.Add_Child_Node('CREATOR',Get_Fullname(l_journal.CREATOR));
1116: --Ja_Cn_Utility.Add_Child_Node('REVIEWER',l_journal.REVIEWER); --added by jar.wang for bug 16075191
1117: l_approver := Get_Approver(l_journal.je_header_id,l_journal.CREATOR);
1118: Ja_Cn_Utility.Add_Child_Node('REVIEWER',Get_Fullname(l_approver));
1119: --Ja_Cn_Utility.Add_Child_Node('POSTER',l_journal.POSTER);

Line 1116: --Ja_Cn_Utility.Add_Child_Node('REVIEWER',l_journal.REVIEWER); --added by jar.wang for bug 16075191

1112: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT',nvl(l_journal.ACCOUNTED_CR,0));
1113: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY',l_journal.ATTACHMENT);
1114: --Ja_Cn_Utility.Add_Child_Node('CREATOR',l_journal.CREATOR); --added by jar.wang for bug 16075191
1115: Ja_Cn_Utility.Add_Child_Node('CREATOR',Get_Fullname(l_journal.CREATOR));
1116: --Ja_Cn_Utility.Add_Child_Node('REVIEWER',l_journal.REVIEWER); --added by jar.wang for bug 16075191
1117: l_approver := Get_Approver(l_journal.je_header_id,l_journal.CREATOR);
1118: Ja_Cn_Utility.Add_Child_Node('REVIEWER',Get_Fullname(l_approver));
1119: --Ja_Cn_Utility.Add_Child_Node('POSTER',l_journal.POSTER);
1120: select fu.user_name

Line 1118: Ja_Cn_Utility.Add_Child_Node('REVIEWER',Get_Fullname(l_approver));

1114: --Ja_Cn_Utility.Add_Child_Node('CREATOR',l_journal.CREATOR); --added by jar.wang for bug 16075191
1115: Ja_Cn_Utility.Add_Child_Node('CREATOR',Get_Fullname(l_journal.CREATOR));
1116: --Ja_Cn_Utility.Add_Child_Node('REVIEWER',l_journal.REVIEWER); --added by jar.wang for bug 16075191
1117: l_approver := Get_Approver(l_journal.je_header_id,l_journal.CREATOR);
1118: Ja_Cn_Utility.Add_Child_Node('REVIEWER',Get_Fullname(l_approver));
1119: --Ja_Cn_Utility.Add_Child_Node('POSTER',l_journal.POSTER);
1120: select fu.user_name
1121: into l_poster from gl_je_batches gjb, fnd_user fu
1122: where gjb.posted_by = fu.user_id

Line 1119: --Ja_Cn_Utility.Add_Child_Node('POSTER',l_journal.POSTER);

1115: Ja_Cn_Utility.Add_Child_Node('CREATOR',Get_Fullname(l_journal.CREATOR));
1116: --Ja_Cn_Utility.Add_Child_Node('REVIEWER',l_journal.REVIEWER); --added by jar.wang for bug 16075191
1117: l_approver := Get_Approver(l_journal.je_header_id,l_journal.CREATOR);
1118: Ja_Cn_Utility.Add_Child_Node('REVIEWER',Get_Fullname(l_approver));
1119: --Ja_Cn_Utility.Add_Child_Node('POSTER',l_journal.POSTER);
1120: select fu.user_name
1121: into l_poster from gl_je_batches gjb, fnd_user fu
1122: where gjb.posted_by = fu.user_id
1123: and gjb.je_batch_id = l_journal.je_batch_id;

Line 1125: Ja_Cn_Utility.Add_Child_Node('POSTER',Get_Fullname(l_poster));

1121: into l_poster from gl_je_batches gjb, fnd_user fu
1122: where gjb.posted_by = fu.user_id
1123: and gjb.je_batch_id = l_journal.je_batch_id;
1124:
1125: Ja_Cn_Utility.Add_Child_Node('POSTER',Get_Fullname(l_poster));
1126:
1127: Ja_Cn_Utility.Add_Child_Node('POSTED',l_journal.POSTED_FLAG);
1128: Ja_Cn_Utility.Add_Child_Node('CANCELLED',l_journal.CANCEL_FLAG);
1129: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM);

Line 1127: Ja_Cn_Utility.Add_Child_Node('POSTED',l_journal.POSTED_FLAG);

1123: and gjb.je_batch_id = l_journal.je_batch_id;
1124:
1125: Ja_Cn_Utility.Add_Child_Node('POSTER',Get_Fullname(l_poster));
1126:
1127: Ja_Cn_Utility.Add_Child_Node('POSTED',l_journal.POSTED_FLAG);
1128: Ja_Cn_Utility.Add_Child_Node('CANCELLED',l_journal.CANCEL_FLAG);
1129: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM);
1130: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR);
1131:

Line 1128: Ja_Cn_Utility.Add_Child_Node('CANCELLED',l_journal.CANCEL_FLAG);

1124:
1125: Ja_Cn_Utility.Add_Child_Node('POSTER',Get_Fullname(l_poster));
1126:
1127: Ja_Cn_Utility.Add_Child_Node('POSTED',l_journal.POSTED_FLAG);
1128: Ja_Cn_Utility.Add_Child_Node('CANCELLED',l_journal.CANCEL_FLAG);
1129: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM);
1130: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR);
1131:
1132: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);

Line 1129: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM);

1125: Ja_Cn_Utility.Add_Child_Node('POSTER',Get_Fullname(l_poster));
1126:
1127: Ja_Cn_Utility.Add_Child_Node('POSTED',l_journal.POSTED_FLAG);
1128: Ja_Cn_Utility.Add_Child_Node('CANCELLED',l_journal.CANCEL_FLAG);
1129: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM);
1130: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR);
1131:
1132: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);
1133: l_journal_header := l_journal.je_header_id;

Line 1130: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR);

1126:
1127: Ja_Cn_Utility.Add_Child_Node('POSTED',l_journal.POSTED_FLAG);
1128: Ja_Cn_Utility.Add_Child_Node('CANCELLED',l_journal.CANCEL_FLAG);
1129: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM);
1130: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR);
1131:
1132: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);
1133: l_journal_header := l_journal.je_header_id;
1134: END LOOP;

Line 1132: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);

1128: Ja_Cn_Utility.Add_Child_Node('CANCELLED',l_journal.CANCEL_FLAG);
1129: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM);
1130: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR);
1131:
1132: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);
1133: l_journal_header := l_journal.je_header_id;
1134: END LOOP;
1135: CLOSE CUR_JOURNAL;
1136:

Line 1142: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);

1138: FND_MESSAGE.SET_NAME('JA','JA_CN_NO_DATA_FOUND') ;
1139: l_mes := FND_MESSAGE.GET;
1140: FND_FILE.put_line(FND_FILE.log,'Warning:'||pv_bsv||','||l_mes);
1141:
1142: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1143: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER','');
1144: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE','');
1145: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION','');
1146: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER','');

Line 1143: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER','');

1139: l_mes := FND_MESSAGE.GET;
1140: FND_FILE.put_line(FND_FILE.log,'Warning:'||pv_bsv||','||l_mes);
1141:
1142: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1143: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER','');
1144: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE','');
1145: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION','');
1146: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER','');
1147: Ja_Cn_Utility.Add_Child_Node('CHART_OF_ACCOUNT','');

Line 1144: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE','');

1140: FND_FILE.put_line(FND_FILE.log,'Warning:'||pv_bsv||','||l_mes);
1141:
1142: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1143: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER','');
1144: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE','');
1145: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION','');
1146: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER','');
1147: Ja_Cn_Utility.Add_Child_Node('CHART_OF_ACCOUNT','');
1148: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');

Line 1145: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION','');

1141:
1142: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1143: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER','');
1144: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE','');
1145: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION','');
1146: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER','');
1147: Ja_Cn_Utility.Add_Child_Node('CHART_OF_ACCOUNT','');
1148: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
1149: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');

Line 1146: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER','');

1142: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1143: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER','');
1144: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE','');
1145: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION','');
1146: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER','');
1147: Ja_Cn_Utility.Add_Child_Node('CHART_OF_ACCOUNT','');
1148: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
1149: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
1150: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');

Line 1147: Ja_Cn_Utility.Add_Child_Node('CHART_OF_ACCOUNT','');

1143: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER','');
1144: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE','');
1145: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION','');
1146: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER','');
1147: Ja_Cn_Utility.Add_Child_Node('CHART_OF_ACCOUNT','');
1148: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
1149: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
1150: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
1151: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');

Line 1148: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');

1144: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE','');
1145: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION','');
1146: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER','');
1147: Ja_Cn_Utility.Add_Child_Node('CHART_OF_ACCOUNT','');
1148: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
1149: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
1150: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
1151: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
1152: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');

Line 1149: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');

1145: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION','');
1146: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER','');
1147: Ja_Cn_Utility.Add_Child_Node('CHART_OF_ACCOUNT','');
1148: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
1149: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
1150: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
1151: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
1152: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
1153: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY','');

Line 1150: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');

1146: Ja_Cn_Utility.Add_Child_Node('JOURNAL_LINE_NUMBER','');
1147: Ja_Cn_Utility.Add_Child_Node('CHART_OF_ACCOUNT','');
1148: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
1149: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
1150: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
1151: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
1152: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
1153: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY','');
1154: Ja_Cn_Utility.Add_Child_Node('CREATOR','');

Line 1151: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');

1147: Ja_Cn_Utility.Add_Child_Node('CHART_OF_ACCOUNT','');
1148: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
1149: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
1150: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
1151: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
1152: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
1153: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY','');
1154: Ja_Cn_Utility.Add_Child_Node('CREATOR','');
1155: Ja_Cn_Utility.Add_Child_Node('REVIEWER','');

Line 1152: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');

1148: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE','');
1149: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
1150: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
1151: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
1152: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
1153: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY','');
1154: Ja_Cn_Utility.Add_Child_Node('CREATOR','');
1155: Ja_Cn_Utility.Add_Child_Node('REVIEWER','');
1156: Ja_Cn_Utility.Add_Child_Node('POSTER','');

Line 1153: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY','');

1149: Ja_Cn_Utility.Add_Child_Node('DEBIT_ENTERED_AMOUNT','');
1150: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
1151: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
1152: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
1153: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY','');
1154: Ja_Cn_Utility.Add_Child_Node('CREATOR','');
1155: Ja_Cn_Utility.Add_Child_Node('REVIEWER','');
1156: Ja_Cn_Utility.Add_Child_Node('POSTER','');
1157: Ja_Cn_Utility.Add_Child_Node('POSTED','');

Line 1154: Ja_Cn_Utility.Add_Child_Node('CREATOR','');

1150: Ja_Cn_Utility.Add_Child_Node('DEBIT_FUNCTIONAL_AMOUNT','');
1151: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
1152: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
1153: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY','');
1154: Ja_Cn_Utility.Add_Child_Node('CREATOR','');
1155: Ja_Cn_Utility.Add_Child_Node('REVIEWER','');
1156: Ja_Cn_Utility.Add_Child_Node('POSTER','');
1157: Ja_Cn_Utility.Add_Child_Node('POSTED','');
1158: Ja_Cn_Utility.Add_Child_Node('CANCELLED','');

Line 1155: Ja_Cn_Utility.Add_Child_Node('REVIEWER','');

1151: Ja_Cn_Utility.Add_Child_Node('CREDIT_ENTERED_AMOUNT','');
1152: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
1153: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY','');
1154: Ja_Cn_Utility.Add_Child_Node('CREATOR','');
1155: Ja_Cn_Utility.Add_Child_Node('REVIEWER','');
1156: Ja_Cn_Utility.Add_Child_Node('POSTER','');
1157: Ja_Cn_Utility.Add_Child_Node('POSTED','');
1158: Ja_Cn_Utility.Add_Child_Node('CANCELLED','');
1159: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');

Line 1156: Ja_Cn_Utility.Add_Child_Node('POSTER','');

1152: Ja_Cn_Utility.Add_Child_Node('CREDIT_FUNCTIONAL_AMOUNT','');
1153: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY','');
1154: Ja_Cn_Utility.Add_Child_Node('CREATOR','');
1155: Ja_Cn_Utility.Add_Child_Node('REVIEWER','');
1156: Ja_Cn_Utility.Add_Child_Node('POSTER','');
1157: Ja_Cn_Utility.Add_Child_Node('POSTED','');
1158: Ja_Cn_Utility.Add_Child_Node('CANCELLED','');
1159: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
1160: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');

Line 1157: Ja_Cn_Utility.Add_Child_Node('POSTED','');

1153: Ja_Cn_Utility.Add_Child_Node('ATTACHMENT_QUANTITY','');
1154: Ja_Cn_Utility.Add_Child_Node('CREATOR','');
1155: Ja_Cn_Utility.Add_Child_Node('REVIEWER','');
1156: Ja_Cn_Utility.Add_Child_Node('POSTER','');
1157: Ja_Cn_Utility.Add_Child_Node('POSTED','');
1158: Ja_Cn_Utility.Add_Child_Node('CANCELLED','');
1159: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
1160: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
1161:

Line 1158: Ja_Cn_Utility.Add_Child_Node('CANCELLED','');

1154: Ja_Cn_Utility.Add_Child_Node('CREATOR','');
1155: Ja_Cn_Utility.Add_Child_Node('REVIEWER','');
1156: Ja_Cn_Utility.Add_Child_Node('POSTER','');
1157: Ja_Cn_Utility.Add_Child_Node('POSTED','');
1158: Ja_Cn_Utility.Add_Child_Node('CANCELLED','');
1159: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
1160: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
1161:
1162: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);

Line 1159: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');

1155: Ja_Cn_Utility.Add_Child_Node('REVIEWER','');
1156: Ja_Cn_Utility.Add_Child_Node('POSTER','');
1157: Ja_Cn_Utility.Add_Child_Node('POSTED','');
1158: Ja_Cn_Utility.Add_Child_Node('CANCELLED','');
1159: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
1160: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
1161:
1162: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);
1163: END IF;

Line 1160: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');

1156: Ja_Cn_Utility.Add_Child_Node('POSTER','');
1157: Ja_Cn_Utility.Add_Child_Node('POSTED','');
1158: Ja_Cn_Utility.Add_Child_Node('CANCELLED','');
1159: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
1160: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
1161:
1162: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);
1163: END IF;
1164:

Line 1162: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);

1158: Ja_Cn_Utility.Add_Child_Node('CANCELLED','');
1159: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER','');
1160: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR','');
1161:
1162: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);
1163: END IF;
1164:
1165: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.5');
1166: --logging for debug