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_INV_INT_PKG dependencies on IGS_FI_FEE_TYPE

Line 352: CURSOR c_igs_fi_fee_type(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS

348: */
349:
350:
351: --Cursor to fetch the value of Optional Payment Indicator value from Fee Type Setup.
352: CURSOR c_igs_fi_fee_type(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS
353: SELECT ft.optional_payment_ind
354: FROM igs_fi_fee_type ft
355: WHERE ft.fee_type = cp_v_fee_type;
356:

Line 354: FROM igs_fi_fee_type ft

350:
351: --Cursor to fetch the value of Optional Payment Indicator value from Fee Type Setup.
352: CURSOR c_igs_fi_fee_type(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS
353: SELECT ft.optional_payment_ind
354: FROM igs_fi_fee_type ft
355: WHERE ft.fee_type = cp_v_fee_type;
356:
357: l_v_optional_payment_ind igs_fi_fee_type.optional_payment_ind%TYPE;
358:

Line 357: l_v_optional_payment_ind igs_fi_fee_type.optional_payment_ind%TYPE;

353: SELECT ft.optional_payment_ind
354: FROM igs_fi_fee_type ft
355: WHERE ft.fee_type = cp_v_fee_type;
356:
357: l_v_optional_payment_ind igs_fi_fee_type.optional_payment_ind%TYPE;
358:
359: BEGIN
360:
361: IF (p_inserting) THEN

Line 370: OPEN c_igs_fi_fee_type(new_references.fee_type);

366: -- assigned as 'N'.For all charges created with an optional
367: -- fee type, the value of OPTIONAL_FEE_FLAG column in the charges table will be
368: -- assigned as 'O'.
369:
370: OPEN c_igs_fi_fee_type(new_references.fee_type);
371: FETCH c_igs_fi_fee_type INTO l_v_optional_payment_ind;
372: CLOSE c_igs_fi_fee_type;
373:
374: IF l_v_optional_payment_ind = 'N' THEN

Line 371: FETCH c_igs_fi_fee_type INTO l_v_optional_payment_ind;

367: -- fee type, the value of OPTIONAL_FEE_FLAG column in the charges table will be
368: -- assigned as 'O'.
369:
370: OPEN c_igs_fi_fee_type(new_references.fee_type);
371: FETCH c_igs_fi_fee_type INTO l_v_optional_payment_ind;
372: CLOSE c_igs_fi_fee_type;
373:
374: IF l_v_optional_payment_ind = 'N' THEN
375: new_references.optional_fee_flag := 'N';

Line 372: CLOSE c_igs_fi_fee_type;

368: -- assigned as 'O'.
369:
370: OPEN c_igs_fi_fee_type(new_references.fee_type);
371: FETCH c_igs_fi_fee_type INTO l_v_optional_payment_ind;
372: CLOSE c_igs_fi_fee_type;
373:
374: IF l_v_optional_payment_ind = 'N' THEN
375: new_references.optional_fee_flag := 'N';
376: ELSIF l_v_optional_payment_ind = 'Y' THEN