APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_AD_APP_REQ

Line 854: || vvutukur 09-Oct-2003 Bug#3160036.Replaced call to igs_ad_app_req.update_row with

850: || Change History :
851: || Who When What
852: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
853: || is now rounded off to currency precision
854: || vvutukur 09-Oct-2003 Bug#3160036.Replaced call to igs_ad_app_req.update_row with
855: || call to igs_ad_gen_015.update_igs_ad_app_req.
856: || pathipat 14-Jun-2003 Enh 2831587 Credit Card Fund Transfer build
857: || Modified call to igs_ad_app_req_pkg.update_row()
858: || Sykrishn 01-NOV/2002 Created this procedure - as part of Gl Interface TD modifications (NEW)

Line 855: || call to igs_ad_gen_015.update_igs_ad_app_req.

851: || Who When What
852: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
853: || is now rounded off to currency precision
854: || vvutukur 09-Oct-2003 Bug#3160036.Replaced call to igs_ad_app_req.update_row with
855: || call to igs_ad_gen_015.update_igs_ad_app_req.
856: || pathipat 14-Jun-2003 Enh 2831587 Credit Card Fund Transfer build
857: || Modified call to igs_ad_app_req_pkg.update_row()
858: || Sykrishn 01-NOV/2002 Created this procedure - as part of Gl Interface TD modifications (NEW)
859: || (reverse chronological order - newest change first)

Line 857: || Modified call to igs_ad_app_req_pkg.update_row()

853: || is now rounded off to currency precision
854: || vvutukur 09-Oct-2003 Bug#3160036.Replaced call to igs_ad_app_req.update_row with
855: || call to igs_ad_gen_015.update_igs_ad_app_req.
856: || pathipat 14-Jun-2003 Enh 2831587 Credit Card Fund Transfer build
857: || Modified call to igs_ad_app_req_pkg.update_row()
858: || Sykrishn 01-NOV/2002 Created this procedure - as part of Gl Interface TD modifications (NEW)
859: || (reverse chronological order - newest change first)
860: */
861:

Line 870: FROM igs_ad_app_req adm

866:
867: CURSOR cur_adm_fee (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
868: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
869: SELECT adm.rowid row_id,adm.*
870: FROM igs_ad_app_req adm
871: WHERE adm.gl_date IS NOT NULL
872: AND TRUNC(adm.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
873: AND adm.posting_control_id IS NULL
874: ORDER BY gl_date

Line 880: cp_admission_appl_number IN igs_ad_app_req.admission_appl_number%TYPE) IS

876:
877:
878: -- Cursor to get admission application id
879: CURSOR cur_app_id (cp_person_id IN igs_fi_parties_v.person_id%TYPE,
880: cp_admission_appl_number IN igs_ad_app_req.admission_appl_number%TYPE) IS
881: SELECT application_id
882: FROM igs_ad_appl
883: WHERE person_id = cp_person_id
884: AND admission_appl_number = cp_admission_appl_number;

Line 936: -- Update the igs_ad_app_req table - posting_control_id and also the log file

932: WHEN OTHERS THEN
933: l_b_exception_flag := TRUE;
934: END;
935:
936: -- Update the igs_ad_app_req table - posting_control_id and also the log file
937:
938: IF NOT l_b_exception_flag THEN
939:
940: update_log_file

Line 950: igs_ad_gen_015.update_igs_ad_app_req(

946: p_src_txn_type => g_applfee);
947:
948: BEGIN
949:
950: igs_ad_gen_015.update_igs_ad_app_req(
951: p_rowid => ad_app_rec.row_id,
952: p_app_req_id => ad_app_rec.app_req_id,
953: p_person_id => ad_app_rec.person_id,
954: p_admission_appl_number => ad_app_rec.admission_appl_number,