APPS.IGS_FI_COM_REC_INTERFACE dependencies on IGS_FI_INVLN_INT

Line 21: | igs_fi_invln_int_all |

17: |abshriva 4-May-2006 Bug 5178077: Modification in procedure Transfer |
18: | svuppala 30-MAY-2005 Enh 3442712 - Done the TBH |
19: | modifications by adding new columns |
20: | Unit_Type_Id, Unit_Level in |
21: | igs_fi_invln_int_all |
22: | pathipat 22-Apr-2004 Enh 3558549 - Comm Rec Enh build |
23: | Added 2 new cols to igs_fi_com_recs_int
24: | Modified transfer() for the above |
25: |uudayapr 16-oct-2003 Enh #3117341 Modified the cur_charges in |

Line 147: -- new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all

143: --Change History:
144: --Who When What
145: --abshriva 4-May-2006 Bug 5178077: Introduced igs_ge_gen_003.set_org_id
146: --svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding
147: -- new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
148: --pathipat 22-Apr-2004 Enh 3558549 - Comm Rec Enh build
149: -- Added code w.r.t new columns student_party_id and
150: -- source_invoice_id in igs_fi_com_recs_int
151: --uudayapr 16-oct-2003 Enh#3117341 Modified cur_charges cursor as a part

Line 175: igs_fi_invln_int invln,

171: ft.s_fee_type,
172: invln.row_id invln_rowid,
173: invln.*
174: FROM igs_fi_inv_int inv,
175: igs_fi_invln_int invln,
176: igs_fi_fee_type ft
177: WHERE inv.invoice_id = invln.invoice_id
178: AND inv.fee_type = ft.fee_type
179: AND ft.s_fee_type IN (g_v_tutnfee,g_v_other,g_v_external,

Line 386: -- update the record in IGS_FI_INVLN_INT - set gl_posted_date to sysdate

382: x_source_invoice_id => NULL
383: );
384:
385: -- Step 5: For every record inserted into the Receivables interface table,
386: -- update the record in IGS_FI_INVLN_INT - set gl_posted_date to sysdate
387: igs_fi_invln_int_pkg.update_row( x_rowid => l_rec_charges.invln_rowid,
388: x_invoice_id => l_rec_charges.invoice_id,
389: x_line_number => l_rec_charges.line_number,
390: x_invoice_lines_id => l_rec_charges.invoice_lines_id,

Line 387: igs_fi_invln_int_pkg.update_row( x_rowid => l_rec_charges.invln_rowid,

383: );
384:
385: -- Step 5: For every record inserted into the Receivables interface table,
386: -- update the record in IGS_FI_INVLN_INT - set gl_posted_date to sysdate
387: igs_fi_invln_int_pkg.update_row( x_rowid => l_rec_charges.invln_rowid,
388: x_invoice_id => l_rec_charges.invoice_id,
389: x_line_number => l_rec_charges.line_number,
390: x_invoice_lines_id => l_rec_charges.invoice_lines_id,
391: x_attribute2 => l_rec_charges.attribute2,