APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_INVLN_INT_ALL

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 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