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.JA_CN_JE_EXP_PKG dependencies on FND_GLOBAL

Line 610: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||

606:
607: FND_FILE.put_line(FND_FILE.output,
608: '"' || to_char(l_journal_lines_gbl_tmp_row.default_effective_date,
609: 'YYYYMMDD') --journal date
610: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
611: l_journal_lines_gbl_tmp_row.je_category --category
612: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
613: l_journal_number --journal number
614: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||

Line 612: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||

608: '"' || to_char(l_journal_lines_gbl_tmp_row.default_effective_date,
609: 'YYYYMMDD') --journal date
610: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
611: l_journal_lines_gbl_tmp_row.je_category --category
612: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
613: l_journal_number --journal number
614: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
615: l_journal_line_number --journal line number
616: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||

Line 614: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||

610: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
611: l_journal_lines_gbl_tmp_row.je_category --category
612: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
613: l_journal_number --journal number
614: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
615: l_journal_line_number --journal line number
616: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
617: l_journal_lines_gbl_tmp_row.description --description
618: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||

Line 616: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||

612: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
613: l_journal_number --journal number
614: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
615: l_journal_line_number --journal line number
616: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
617: l_journal_lines_gbl_tmp_row.description --description
618: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
619: l_journal_lines_gbl_tmp_row.account_segment_value --account
620: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||

Line 618: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||

614: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
615: l_journal_line_number --journal line number
616: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
617: l_journal_lines_gbl_tmp_row.description --description
618: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
619: l_journal_lines_gbl_tmp_row.account_segment_value --account
620: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
621: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.accounted_dr,
622: 0),

Line 620: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||

616: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
617: l_journal_lines_gbl_tmp_row.description --description
618: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
619: l_journal_lines_gbl_tmp_row.account_segment_value --account
620: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
621: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.accounted_dr,
622: 0),
623: '999999999999999990.99')) --debit
624: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

Line 624: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

620: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
621: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.accounted_dr,
622: 0),
623: '999999999999999990.99')) --debit
624: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
625: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.accounted_cr,
626: 0),
627: '999999999999999990.99')) --credit
628: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||

Line 628: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||

624: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
625: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.accounted_cr,
626: 0),
627: '999999999999999990.99')) --credit
628: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
629: l_journal_lines_gbl_tmp_row.currency_code --currency
630: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
631: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.entered_dr,
632: 0),

Line 630: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||

626: 0),
627: '999999999999999990.99')) --credit
628: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
629: l_journal_lines_gbl_tmp_row.currency_code --currency
630: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
631: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.entered_dr,
632: 0),
633: '999999999999999990.99')) --debit abount in foreign currency
634: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

Line 634: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

630: || '"' || FND_GLOBAL.Local_Chr(9) || '' ||
631: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.entered_dr,
632: 0),
633: '999999999999999990.99')) --debit abount in foreign currency
634: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
635: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.entered_cr,
636: 0),
637: '999999999999999990.99')) --credit abount in foreign currency
638: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

Line 638: || '' || FND_GLOBAL.Local_Chr(9) || '' ||

634: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
635: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.entered_cr,
636: 0),
637: '999999999999999990.99')) --credit abount in foreign currency
638: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
639: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.currency_conversion_rate,
640: 0),
641: '9999999999990.999999')) --exchange rate
642: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.0000' --quantity

Line 642: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.0000' --quantity

638: || '' || FND_GLOBAL.Local_Chr(9) || '' ||
639: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.currency_conversion_rate,
640: 0),
641: '9999999999990.999999')) --exchange rate
642: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.0000' --quantity
643: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.0000' --unit price
644: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
645: Get_Subsidiary_Desc(p_cost_center => l_journal_lines_gbl_tmp_row.cost_center,
646: p_third_party_number => l_journal_lines_gbl_tmp_row.third_party_number,

Line 643: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.0000' --unit price

639: TRIM(to_char(nvl(l_journal_lines_gbl_tmp_row.currency_conversion_rate,
640: 0),
641: '9999999999990.999999')) --exchange rate
642: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.0000' --quantity
643: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.0000' --unit price
644: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
645: Get_Subsidiary_Desc(p_cost_center => l_journal_lines_gbl_tmp_row.cost_center,
646: p_third_party_number => l_journal_lines_gbl_tmp_row.third_party_number,
647: p_personnel_number => l_journal_lines_gbl_tmp_row.personnel_number,

Line 644: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||

640: 0),
641: '9999999999990.999999')) --exchange rate
642: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.0000' --quantity
643: || '' || FND_GLOBAL.Local_Chr(9) || '' || '0.0000' --unit price
644: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
645: Get_Subsidiary_Desc(p_cost_center => l_journal_lines_gbl_tmp_row.cost_center,
646: p_third_party_number => l_journal_lines_gbl_tmp_row.third_party_number,
647: p_personnel_number => l_journal_lines_gbl_tmp_row.personnel_number,
648: p_project_number => l_journal_lines_gbl_tmp_row.project_number,

Line 653: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --settlement method

649: p_has_cost_center => l_journal_lines_gbl_tmp_row.has_cost_center,
650: p_has_third_party => l_journal_lines_gbl_tmp_row.has_third_party,
651: p_has_personnel => l_journal_lines_gbl_tmp_row.has_personnel,
652: p_has_project => l_journal_lines_gbl_tmp_row.has_project) --subsidiary account group
653: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --settlement method
654: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill type
655: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill number
656: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill date
657: || '"' || FND_GLOBAL.Local_Chr(9) || '' || '0' --attachment quantity

Line 654: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill type

650: p_has_third_party => l_journal_lines_gbl_tmp_row.has_third_party,
651: p_has_personnel => l_journal_lines_gbl_tmp_row.has_personnel,
652: p_has_project => l_journal_lines_gbl_tmp_row.has_project) --subsidiary account group
653: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --settlement method
654: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill type
655: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill number
656: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill date
657: || '"' || FND_GLOBAL.Local_Chr(9) || '' || '0' --attachment quantity
658: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||

Line 655: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill number

651: p_has_personnel => l_journal_lines_gbl_tmp_row.has_personnel,
652: p_has_project => l_journal_lines_gbl_tmp_row.has_project) --subsidiary account group
653: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --settlement method
654: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill type
655: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill number
656: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill date
657: || '"' || FND_GLOBAL.Local_Chr(9) || '' || '0' --attachment quantity
658: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
659: l_journal_lines_gbl_tmp_row.journal_preparer --preparer

Line 656: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill date

652: p_has_project => l_journal_lines_gbl_tmp_row.has_project) --subsidiary account group
653: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --settlement method
654: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill type
655: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill number
656: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill date
657: || '"' || FND_GLOBAL.Local_Chr(9) || '' || '0' --attachment quantity
658: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
659: l_journal_lines_gbl_tmp_row.journal_preparer --preparer
660: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||

Line 657: || '"' || FND_GLOBAL.Local_Chr(9) || '' || '0' --attachment quantity

653: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --settlement method
654: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill type
655: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill number
656: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill date
657: || '"' || FND_GLOBAL.Local_Chr(9) || '' || '0' --attachment quantity
658: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
659: l_journal_lines_gbl_tmp_row.journal_preparer --preparer
660: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
661: l_journal_lines_gbl_tmp_row.JOURNAL_APPROVER -- journal approver

Line 658: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||

654: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill type
655: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill number
656: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill date
657: || '"' || FND_GLOBAL.Local_Chr(9) || '' || '0' --attachment quantity
658: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
659: l_journal_lines_gbl_tmp_row.journal_preparer --preparer
660: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
661: l_journal_lines_gbl_tmp_row.JOURNAL_APPROVER -- journal approver
662: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||

Line 660: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||

656: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --bill date
657: || '"' || FND_GLOBAL.Local_Chr(9) || '' || '0' --attachment quantity
658: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
659: l_journal_lines_gbl_tmp_row.journal_preparer --preparer
660: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
661: l_journal_lines_gbl_tmp_row.JOURNAL_APPROVER -- journal approver
662: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
663: l_journal_lines_gbl_tmp_row.journal_poster --bookkeeper
664: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --cashier

Line 662: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||

658: || '' || FND_GLOBAL.Local_Chr(9) || '"' ||
659: l_journal_lines_gbl_tmp_row.journal_preparer --preparer
660: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
661: l_journal_lines_gbl_tmp_row.JOURNAL_APPROVER -- journal approver
662: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
663: l_journal_lines_gbl_tmp_row.journal_poster --bookkeeper
664: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --cashier
665: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '1' --closing flag
666: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '0' --cancel flag

Line 664: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --cashier

660: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
661: l_journal_lines_gbl_tmp_row.JOURNAL_APPROVER -- journal approver
662: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
663: l_journal_lines_gbl_tmp_row.journal_poster --bookkeeper
664: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --cashier
665: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '1' --closing flag
666: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '0' --cancel flag
667: || '"');
668:

Line 665: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '1' --closing flag

661: l_journal_lines_gbl_tmp_row.JOURNAL_APPROVER -- journal approver
662: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
663: l_journal_lines_gbl_tmp_row.journal_poster --bookkeeper
664: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --cashier
665: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '1' --closing flag
666: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '0' --cancel flag
667: || '"');
668:
669: END LOOP;

Line 666: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '0' --cancel flag

662: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
663: l_journal_lines_gbl_tmp_row.journal_poster --bookkeeper
664: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '' --cashier
665: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '1' --closing flag
666: || '"' || FND_GLOBAL.Local_Chr(9) || '"' || '0' --cancel flag
667: || '"');
668:
669: END LOOP;
670: CLOSE c_in_journal_lines_gbl_tmp;