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_AD_HOC_WAV dependencies on IGS_FI_INV_WAV_DET

Line 237: l_start_dt igs_fi_inv_wav_det.start_dt%TYPE ;

233: -- through cursor c_per_chg as part of #2144600.
234: -------------------------------------------------------------------
235:
236:
237: l_start_dt igs_fi_inv_wav_det.start_dt%TYPE ;
238: l_end_dt igs_fi_inv_wav_det.end_dt%TYPE ;
239: l_release_dt igs_fi_inv_wav_det.end_dt%TYPE ;
240: l_rowid igs_fi_inv_wav_det_v.row_id%TYPE ;
241: l_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ;

Line 238: l_end_dt igs_fi_inv_wav_det.end_dt%TYPE ;

234: -------------------------------------------------------------------
235:
236:
237: l_start_dt igs_fi_inv_wav_det.start_dt%TYPE ;
238: l_end_dt igs_fi_inv_wav_det.end_dt%TYPE ;
239: l_release_dt igs_fi_inv_wav_det.end_dt%TYPE ;
240: l_rowid igs_fi_inv_wav_det_v.row_id%TYPE ;
241: l_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ;
242: l_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ;

Line 239: l_release_dt igs_fi_inv_wav_det.end_dt%TYPE ;

235:
236:
237: l_start_dt igs_fi_inv_wav_det.start_dt%TYPE ;
238: l_end_dt igs_fi_inv_wav_det.end_dt%TYPE ;
239: l_release_dt igs_fi_inv_wav_det.end_dt%TYPE ;
240: l_rowid igs_fi_inv_wav_det_v.row_id%TYPE ;
241: l_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ;
242: l_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ;
243: l_per_num igs_pe_person_v.person_number%TYPE ;

Line 240: l_rowid igs_fi_inv_wav_det_v.row_id%TYPE ;

236:
237: l_start_dt igs_fi_inv_wav_det.start_dt%TYPE ;
238: l_end_dt igs_fi_inv_wav_det.end_dt%TYPE ;
239: l_release_dt igs_fi_inv_wav_det.end_dt%TYPE ;
240: l_rowid igs_fi_inv_wav_det_v.row_id%TYPE ;
241: l_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ;
242: l_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ;
243: l_per_num igs_pe_person_v.person_number%TYPE ;
244: l_msg_str VARCHAR2(1000) ;

Line 318: CURSOR c_chg_wav (cp_inv_id igs_fi_inv_wav_det.invoice_id%TYPE ,

314: (cp_fee_type2 IS NOT NULL AND fee_type = cp_fee_type2) OR
315: (cp_fee_type3 IS NOT NULL AND fee_type = cp_fee_type3)
316: );
317:
318: CURSOR c_chg_wav (cp_inv_id igs_fi_inv_wav_det.invoice_id%TYPE ,
319: cp_bal_type igs_fi_inv_wav_det.balance_type%TYPE ,
320: cp_rel_dt igs_fi_inv_wav_det.end_dt%TYPE) IS
321: SELECT *
322: FROM igs_fi_inv_wav_det_v

Line 319: cp_bal_type igs_fi_inv_wav_det.balance_type%TYPE ,

315: (cp_fee_type3 IS NOT NULL AND fee_type = cp_fee_type3)
316: );
317:
318: CURSOR c_chg_wav (cp_inv_id igs_fi_inv_wav_det.invoice_id%TYPE ,
319: cp_bal_type igs_fi_inv_wav_det.balance_type%TYPE ,
320: cp_rel_dt igs_fi_inv_wav_det.end_dt%TYPE) IS
321: SELECT *
322: FROM igs_fi_inv_wav_det_v
323: WHERE invoice_id = cp_inv_id

Line 320: cp_rel_dt igs_fi_inv_wav_det.end_dt%TYPE) IS

316: );
317:
318: CURSOR c_chg_wav (cp_inv_id igs_fi_inv_wav_det.invoice_id%TYPE ,
319: cp_bal_type igs_fi_inv_wav_det.balance_type%TYPE ,
320: cp_rel_dt igs_fi_inv_wav_det.end_dt%TYPE) IS
321: SELECT *
322: FROM igs_fi_inv_wav_det_v
323: WHERE invoice_id = cp_inv_id
324: AND balance_type = cp_bal_type

Line 322: FROM igs_fi_inv_wav_det_v

318: CURSOR c_chg_wav (cp_inv_id igs_fi_inv_wav_det.invoice_id%TYPE ,
319: cp_bal_type igs_fi_inv_wav_det.balance_type%TYPE ,
320: cp_rel_dt igs_fi_inv_wav_det.end_dt%TYPE) IS
321: SELECT *
322: FROM igs_fi_inv_wav_det_v
323: WHERE invoice_id = cp_inv_id
324: AND balance_type = cp_bal_type
325: AND ((end_dt IS NOT NULL AND end_dt > cp_rel_dt) OR (end_dt IS NULL));
326:

Line 624: igs_fi_inv_wav_det if Test Mode is NO.

620:
621: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str);
622:
623: /** For every charge found for a person , inserting a waiver record in the table
624: igs_fi_inv_wav_det if Test Mode is NO.
625: This record is created for an identified charge and the balance type passed in
626: the parameter p_c_bal_type **/
627:
628: IF p_c_test_flag = 'Y' THEN

Line 630: igs_fi_inv_wav_det_pkg.before_dml

626: the parameter p_c_bal_type **/
627:
628: IF p_c_test_flag = 'Y' THEN
629:
630: igs_fi_inv_wav_det_pkg.before_dml
631: (p_action => 'INSERT',
632: x_rowid => l_rowid,
633: x_invoice_id => l_rec_per_chg.invoice_id,
634: x_balance_type => p_c_bal_type,

Line 642: igs_fi_inv_wav_det_pkg.insert_row

638:
639: ELSIF p_c_test_flag = 'N' THEN
640:
641:
642: igs_fi_inv_wav_det_pkg.insert_row
643: (x_rowid => l_rowid,
644: x_invoice_id => l_rec_per_chg.invoice_id,
645: x_balance_type => p_c_bal_type,
646: x_start_dt => l_start_dt,

Line 662: If waiver record found in the table igs_fi_inv_wav_det, release the waiver **/

658: ELSIF p_c_action = 'RELEASE' THEN
659:
660: /** For every charge found for a person , checking whether waiver exists for this
661: charge and the balance type passed in the parameter p_c_bal_type .
662: If waiver record found in the table igs_fi_inv_wav_det, release the waiver **/
663:
664: /** Release functionality is as follows :
665: If start date of the waiver record is greater than release date then delete the
666: waiver record.

Line 690: igs_fi_inv_wav_det_pkg.delete_row

686: IF p_c_test_flag = 'N' THEN
687:
688: IF l_chg_wav.start_dt > l_release_dt THEN
689:
690: igs_fi_inv_wav_det_pkg.delete_row
691: (x_rowid => l_chg_wav.row_id
692: );
693:
694: ELSE

Line 696: igs_fi_inv_wav_det_pkg.update_row

692: );
693:
694: ELSE
695:
696: igs_fi_inv_wav_det_pkg.update_row
697: (x_rowid => l_chg_wav.row_id,
698: x_invoice_id => l_chg_wav.invoice_id,
699: x_balance_type => l_chg_wav.balance_type,
700: x_start_dt => l_chg_wav.start_dt,