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.CSE_GL_INTERFACE_PKG dependencies on XLA_AE_LINES

Line 341: CURSOR xla_ae_lines_cur( c_application_id IN NUMBER,

337: AND xlte.application_id = xlaeh.application_id
338: AND xlte.entity_id = xlaeh.entity_id
339: AND xlaeh.accounting_entry_status_code = 'F' ;
340:
341: CURSOR xla_ae_lines_cur( c_application_id IN NUMBER,
342: c_header_id IN NUMBER)
343: IS
344: SELECT xlael.code_combination_id ,
345: xlael.accounted_dr tot_accounted_dr,

Line 351: FROM xla_ae_lines xlael

347: xlael.entered_dr tot_entered_dr,
348: xlael.entered_cr tot_entered_cr,
349: xlael.currency_code ,
350: xlael.accounting_class_code
351: FROM xla_ae_lines xlael
352: WHERE xlael.application_id = c_application_id
353: AND xlael.ae_header_id = c_header_id ;
354: -- AND xlael.accounting_class_code = 'INVENTORY_VALUATION'
355: --GROUP BY xlael.accounting_class_code , xlael.code_combination_id, xlael.currency_code ;

Line 682: debug('Before Xla_Ae_Lines_Cur'

678:
679:
680: IF (l_debug = 'Y')
681: THEN
682: debug('Before Xla_Ae_Lines_Cur'
683: || ' XLA_APPN_ID: ' || to_char(xla_header_rec.application_id)
684: || ' XLA_HDR_ID: ' || to_char(xla_header_rec.ae_header_id)
685: ) ;
686: END IF;

Line 688: FOR xla_ae_lines_rec IN xla_ae_lines_cur (

684: || ' XLA_HDR_ID: ' || to_char(xla_header_rec.ae_header_id)
685: ) ;
686: END IF;
687:
688: FOR xla_ae_lines_rec IN xla_ae_lines_cur (
689: xla_header_rec.application_id ,
690: xla_header_rec.ae_header_id )
691: LOOP
692: l_gl_ccid := NULL;

Line 700: debug( 'Inside Xla_Ae_Lines_Cur '

696: l_gl_amount_entered_dr := 0;
697:
698: -- IF (l_debug = 'Y')
699: -- THEN
700: debug( 'Inside Xla_Ae_Lines_Cur '
701: || ' Gl_Idx: ' || to_char(gl_idx)
702: || ' I: ' || to_char(i) ) ;
703: -- END IF;
704:

Line 705: IF xla_ae_lines_rec.tot_accounted_dr > 0

701: || ' Gl_Idx: ' || to_char(gl_idx)
702: || ' I: ' || to_char(i) ) ;
703: -- END IF;
704:
705: IF xla_ae_lines_rec.tot_accounted_dr > 0
706: THEN
707: l_gl_ccid := xla_ae_lines_rec.code_combination_id;
708: l_gl_amount_cr := (xla_ae_lines_rec.tot_accounted_dr/l_total_txn_qty) * l_no_of_fa_items;
709: l_gl_amount_entered_cr := (xla_ae_lines_rec.tot_entered_dr/l_total_txn_qty) * l_no_of_fa_items;

Line 707: l_gl_ccid := xla_ae_lines_rec.code_combination_id;

703: -- END IF;
704:
705: IF xla_ae_lines_rec.tot_accounted_dr > 0
706: THEN
707: l_gl_ccid := xla_ae_lines_rec.code_combination_id;
708: l_gl_amount_cr := (xla_ae_lines_rec.tot_accounted_dr/l_total_txn_qty) * l_no_of_fa_items;
709: l_gl_amount_entered_cr := (xla_ae_lines_rec.tot_entered_dr/l_total_txn_qty) * l_no_of_fa_items;
710: --
711: -- IF (l_debug = 'Y')

Line 708: l_gl_amount_cr := (xla_ae_lines_rec.tot_accounted_dr/l_total_txn_qty) * l_no_of_fa_items;

704:
705: IF xla_ae_lines_rec.tot_accounted_dr > 0
706: THEN
707: l_gl_ccid := xla_ae_lines_rec.code_combination_id;
708: l_gl_amount_cr := (xla_ae_lines_rec.tot_accounted_dr/l_total_txn_qty) * l_no_of_fa_items;
709: l_gl_amount_entered_cr := (xla_ae_lines_rec.tot_entered_dr/l_total_txn_qty) * l_no_of_fa_items;
710: --
711: -- IF (l_debug = 'Y')
712: -- THEN

Line 709: l_gl_amount_entered_cr := (xla_ae_lines_rec.tot_entered_dr/l_total_txn_qty) * l_no_of_fa_items;

705: IF xla_ae_lines_rec.tot_accounted_dr > 0
706: THEN
707: l_gl_ccid := xla_ae_lines_rec.code_combination_id;
708: l_gl_amount_cr := (xla_ae_lines_rec.tot_accounted_dr/l_total_txn_qty) * l_no_of_fa_items;
709: l_gl_amount_entered_cr := (xla_ae_lines_rec.tot_entered_dr/l_total_txn_qty) * l_no_of_fa_items;
710: --
711: -- IF (l_debug = 'Y')
712: -- THEN
713: debug(' Credit Gl_Ccid :' || to_char(l_gl_ccid)

Line 718: ELSIF xla_ae_lines_rec.tot_accounted_cr > 0

714: || ' Amt: ' || to_char(l_gl_amount_cr)
715: || ' Ent_Amt: ' || to_char(l_gl_amount_entered_cr) );
716: -- END IF;
717:
718: ELSIF xla_ae_lines_rec.tot_accounted_cr > 0
719: THEN
720: l_gl_ccid := xla_ae_lines_rec.code_combination_id;
721: l_gl_amount_dr := (xla_ae_lines_rec.tot_accounted_cr/l_total_txn_qty) * l_no_of_fa_items;
722: l_gl_amount_entered_dr := (xla_ae_lines_rec.tot_entered_cr/l_total_txn_qty) * l_no_of_fa_items;

Line 720: l_gl_ccid := xla_ae_lines_rec.code_combination_id;

716: -- END IF;
717:
718: ELSIF xla_ae_lines_rec.tot_accounted_cr > 0
719: THEN
720: l_gl_ccid := xla_ae_lines_rec.code_combination_id;
721: l_gl_amount_dr := (xla_ae_lines_rec.tot_accounted_cr/l_total_txn_qty) * l_no_of_fa_items;
722: l_gl_amount_entered_dr := (xla_ae_lines_rec.tot_entered_cr/l_total_txn_qty) * l_no_of_fa_items;
723: --
724: -- IF (l_debug = 'Y')

Line 721: l_gl_amount_dr := (xla_ae_lines_rec.tot_accounted_cr/l_total_txn_qty) * l_no_of_fa_items;

717:
718: ELSIF xla_ae_lines_rec.tot_accounted_cr > 0
719: THEN
720: l_gl_ccid := xla_ae_lines_rec.code_combination_id;
721: l_gl_amount_dr := (xla_ae_lines_rec.tot_accounted_cr/l_total_txn_qty) * l_no_of_fa_items;
722: l_gl_amount_entered_dr := (xla_ae_lines_rec.tot_entered_cr/l_total_txn_qty) * l_no_of_fa_items;
723: --
724: -- IF (l_debug = 'Y')
725: -- THEN

Line 722: l_gl_amount_entered_dr := (xla_ae_lines_rec.tot_entered_cr/l_total_txn_qty) * l_no_of_fa_items;

718: ELSIF xla_ae_lines_rec.tot_accounted_cr > 0
719: THEN
720: l_gl_ccid := xla_ae_lines_rec.code_combination_id;
721: l_gl_amount_dr := (xla_ae_lines_rec.tot_accounted_cr/l_total_txn_qty) * l_no_of_fa_items;
722: l_gl_amount_entered_dr := (xla_ae_lines_rec.tot_entered_cr/l_total_txn_qty) * l_no_of_fa_items;
723: --
724: -- IF (l_debug = 'Y')
725: -- THEN
726: debug(' Debit Gl_Ccid: ' || to_char(l_gl_ccid)

Line 734: debug(' Currency: ' || xla_ae_lines_rec.currency_code ||

730: END IF;
731:
732: -- IF (l_debug = 'Y')
733: -- THEN
734: debug(' Currency: ' || xla_ae_lines_rec.currency_code ||
735: ' Actual: ' || l_mta_actual_flag ||
736: ' Encum_Type_Id: ' || l_mta_encumbrance_type_id ||
737: ' Category: ' || l_category_name ||
738: ' SOB: ' || to_char(xla_header_rec.ledger_id) ) ;

Line 754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;

750: l_gl_interface_tbl(gl_idx).USER_JE_SOURCE_NAME := 'Inventory' ;
751: l_gl_interface_tbl(gl_idx).ENCUMBRANCE_TYPE_ID := l_mta_encumbrance_type_id;
752: l_gl_interface_tbl(gl_idx).SET_OF_BOOKS_ID := xla_header_rec.ledger_id;
753: l_gl_interface_tbl(gl_idx).CODE_COMBINATION_ID := l_gl_ccid;
754: l_gl_interface_tbl(gl_idx).CURRENCY_CODE := xla_ae_lines_rec.currency_code;
755: l_gl_interface_tbl(gl_idx).ENTERED_DR := l_gl_amount_entered_dr;
756: l_gl_interface_tbl(gl_idx).ENTERED_CR := l_gl_amount_entered_cr;
757: l_gl_interface_tbl(gl_idx).ACCOUNTED_DR := l_gl_amount_dr;
758: l_gl_interface_tbl(gl_idx).ACCOUNTED_CR := l_gl_amount_cr;

Line 932: END LOOP; --- xla_ae_lines_curser

928: --
929: gl_idx := gl_idx + 1; --increment the gl index
930: i := i + 1;
931: --
932: END LOOP; --- xla_ae_lines_curser
933: END LOOP; --- xla_header_cur
934: END LOOP; --- cst_acct_info_cur
935:
936: IF l_gl_insrt_success THEN