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.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_INVLN_INT

Line 30: | igs_fi_invln_int_all |

26: | posting_interface |
27: | svuppala 30-MAY-2005 Enh 3442712 - Done the TBH |
28: | modifications by adding new columns |
29: | Unit_Type_Id, Unit_Level in |
30: | igs_fi_invln_int_all |
31: | |
32: | vvutukur 09-Oct-03 Bug#3160036. Modified procedure |
33: | transfer_ad_appl_fee_txns. |
34: | pathipat 14-Jun-2003 Enh 2831587 - CC Fund Transfer build |

Line 112: Removed the source_transaction_id column from the IGS_FI_INVLN_INT_PKG.update_row

108: | orig_appl_fee_ref to comments field of RA_INTERFACE_LINES_ALL when
109: | source_transaction_type is APPLFEE.Also added column orig_appl_fee_ref to
110: | the IGS_FI_POSTING_INT_PKG.insert_row ,IGS_FI_POSTING_INT_PKG.update_row
111: | jbegum 20 Feb 02 As part of Enh bug #2228910
112: Removed the source_transaction_id column from the IGS_FI_INVLN_INT_PKG.update_row
113: jbegum 16 Feb 02 As part of Enh bug #2222272
114: Set org id of transactions created
115: in the Receivables Invoice Interface tables
116: to the org id value obtained from control table

Line 665: || and igs_fi_invln_int is now rounded off to currency precision

661: || Known limitations, enhancements or remarks :
662: || Change History :
663: || Who When What
664: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
665: || and igs_fi_invln_int is now rounded off to currency precision
666: || svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding
667: || new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
668: || Sykrishn 01-NOV/2002 Gl Interface TD modifications...
669: || The below history is nt valid as the local procedure is revamped completely

Line 667: || new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all

663: || Who When What
664: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
665: || and igs_fi_invln_int is now rounded off to currency precision
666: || svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding
667: || new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
668: || Sykrishn 01-NOV/2002 Gl Interface TD modifications...
669: || The below history is nt valid as the local procedure is revamped completely
670: || agairola 21 Apr 2002 Initialised the lrec_posting_int
671: || for bugs 2326595, 2309929, 2310806

Line 686: FROM igs_fi_invln_int_all invln,

682:
683: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
684: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
685: SELECT invln.rowid row_id, inv.invoice_creation_date, inv.currency_cd, invln.*
686: FROM igs_fi_invln_int_all invln,
687: igs_fi_inv_int_all inv
688: WHERE invln.gl_date IS NOT NULL
689: AND TRUNC(invln.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
690: AND invln.posting_id IS NULL

Line 701: l_v_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;

697:
698:
699: l_b_exception_flag BOOLEAN := FALSE;
700:
701: l_v_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
702: l_v_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
703: l_n_amount igs_fi_invln_int_all.amount%TYPE;
704: l_v_posting_rowid ROWID;
705: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;

Line 702: l_v_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;

698:
699: l_b_exception_flag BOOLEAN := FALSE;
700:
701: l_v_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
702: l_v_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
703: l_n_amount igs_fi_invln_int_all.amount%TYPE;
704: l_v_posting_rowid ROWID;
705: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
706:

Line 703: l_n_amount igs_fi_invln_int_all.amount%TYPE;

699: l_b_exception_flag BOOLEAN := FALSE;
700:
701: l_v_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
702: l_v_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
703: l_n_amount igs_fi_invln_int_all.amount%TYPE;
704: l_v_posting_rowid ROWID;
705: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
706:
707: BEGIN

Line 770: igs_fi_invln_int_pkg.update_row(

766: p_src_txn_type => g_charge);
767:
768: BEGIN
769: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
770: igs_fi_invln_int_pkg.update_row(
771: x_rowid => inv_rec.row_id,
772: x_invoice_lines_id => inv_rec.invoice_lines_id,
773: x_invoice_id => inv_rec.invoice_id,
774: x_line_number => inv_rec.line_number,

Line 1022: FROM igs_fi_inv_int inv, igs_fi_invln_int invln

1018:
1019: --Cursor to fetch the invoice number for the passed invoice_id
1020: CURSOR cur_charge (cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1021: SELECT inv.invoice_number
1022: FROM igs_fi_inv_int inv, igs_fi_invln_int invln
1023: WHERE invln.invoice_lines_id = cp_transaction_id
1024: AND inv.invoice_id = invln.invoice_id;
1025:
1026: --Cursor to fetch the credit number for the passed credit_id