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_PRC_FEE_ROLLV dependencies on IGS_CA_DA_INST

Line 710: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;

706: v_tmp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE;
707: v_closed_ind IGS_FI_FEE_TYPE.closed_ind%TYPE;
708: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
709: v_valid_dai BOOLEAN;
710: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;
711: l_n_org_id IGS_FI_F_TYP_CA_INST.ORG_ID%type := igs_ge_gen_003.get_org_id;
712: l_rowid VARCHAR2(25);
713: l_b_records_found BOOLEAN;
714:

Line 778: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,

774: fcfl.fee_ci_sequence_number = p_source_sequence_number AND
775: fcfl.fee_type = cp_fee_type;
776:
777: CURSOR c_dai (
778: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
779: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
780: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
781: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
782: SELECT DT_ALIAS

Line 779: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,

775: fcfl.fee_type = cp_fee_type;
776:
777: CURSOR c_dai (
778: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
779: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
780: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
781: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
782: SELECT DT_ALIAS
783: FROM IGS_CA_DA_INST

Line 780: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,

776:
777: CURSOR c_dai (
778: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
779: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
780: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
781: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
782: SELECT DT_ALIAS
783: FROM IGS_CA_DA_INST
784: WHERE dt_alias = cp_dt_alias AND

Line 781: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS

777: CURSOR c_dai (
778: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
779: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
780: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
781: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
782: SELECT DT_ALIAS
783: FROM IGS_CA_DA_INST
784: WHERE dt_alias = cp_dt_alias AND
785: sequence_number = cp_sequence_number AND

Line 783: FROM IGS_CA_DA_INST

779: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
780: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
781: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
782: SELECT DT_ALIAS
783: FROM IGS_CA_DA_INST
784: WHERE dt_alias = cp_dt_alias AND
785: sequence_number = cp_sequence_number AND
786: cal_type = cp_cal_type AND
787: ci_sequence_number = cp_ci_sequence_number;

Line 1216: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;

1212: v_fee_cat IGS_FI_F_CAT_CA_INST.fee_cat%TYPE;
1213: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;
1214: v_fee_cat_ci_status IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE;
1215: v_valid_dai BOOLEAN;
1216: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;
1217: l_rowid VARCHAR2(25);
1218:
1219: CURSOR c_fcci_fss IS
1220: SELECT fcci.fee_cat,

Line 1255: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,

1251: fcfl.fee_cal_type = p_source_cal_type AND
1252: fcfl.fee_ci_sequence_number = p_source_sequence_number AND
1253: fcfl.fee_type = p_fee_type;
1254: CURSOR c_dai (
1255: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1256: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1257: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1258: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1259: SELECT dt_alias

Line 1256: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,

1252: fcfl.fee_ci_sequence_number = p_source_sequence_number AND
1253: fcfl.fee_type = p_fee_type;
1254: CURSOR c_dai (
1255: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1256: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1257: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1258: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1259: SELECT dt_alias
1260: FROM IGS_CA_DA_INST

Line 1257: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,

1253: fcfl.fee_type = p_fee_type;
1254: CURSOR c_dai (
1255: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1256: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1257: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1258: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1259: SELECT dt_alias
1260: FROM IGS_CA_DA_INST
1261: WHERE dt_alias = cp_dt_alias AND

Line 1258: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS

1254: CURSOR c_dai (
1255: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1256: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1257: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1258: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1259: SELECT dt_alias
1260: FROM IGS_CA_DA_INST
1261: WHERE dt_alias = cp_dt_alias AND
1262: sequence_number = cp_sequence_number AND

Line 1260: FROM IGS_CA_DA_INST

1256: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1257: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1258: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1259: SELECT dt_alias
1260: FROM IGS_CA_DA_INST
1261: WHERE dt_alias = cp_dt_alias AND
1262: sequence_number = cp_sequence_number AND
1263: cal_type = cp_cal_type AND
1264: ci_sequence_number = cp_ci_sequence_number;

Line 1500: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;

1496: v_sequence_number IGS_FI_FEE_RET_SCHD.sequence_number%TYPE;
1497: v_fee_type IGS_FI_FEE_RET_SCHD.fee_type%TYPE;
1498: v_fee_cat IGS_FI_FEE_RET_SCHD.fee_cat%TYPE;
1499: v_schedule_number IGS_FI_FEE_RET_SCHD.schedule_number%TYPE;
1500: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;
1501: l_rowid VARCHAR2(25);
1502: l_b_ftci_fcci_clash_ind BOOLEAN := TRUE;
1503:
1504: CURSOR c_frtns_source IS

Line 1543: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,

1539: NVL(frtns.fee_type, 'NULL') = NVL(cp_fee_type, 'NULL') AND
1540: NVL(frtns.fee_cat, 'NULL') = NVL(cp_fee_cat, 'NULL') AND
1541: frtns.schedule_number = cp_schedule_number;
1542: CURSOR c_dai (
1543: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1544: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1545: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1546: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1547: SELECT dt_alias

Line 1544: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,

1540: NVL(frtns.fee_cat, 'NULL') = NVL(cp_fee_cat, 'NULL') AND
1541: frtns.schedule_number = cp_schedule_number;
1542: CURSOR c_dai (
1543: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1544: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1545: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1546: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1547: SELECT dt_alias
1548: FROM IGS_CA_DA_INST

Line 1545: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,

1541: frtns.schedule_number = cp_schedule_number;
1542: CURSOR c_dai (
1543: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1544: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1545: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1546: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1547: SELECT dt_alias
1548: FROM IGS_CA_DA_INST
1549: WHERE dt_alias = cp_dt_alias AND

Line 1546: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS

1542: CURSOR c_dai (
1543: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1544: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1545: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1546: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1547: SELECT dt_alias
1548: FROM IGS_CA_DA_INST
1549: WHERE dt_alias = cp_dt_alias AND
1550: sequence_number = cp_sequence_number AND

Line 1548: FROM IGS_CA_DA_INST

1544: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1545: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1546: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1547: SELECT dt_alias
1548: FROM IGS_CA_DA_INST
1549: WHERE dt_alias = cp_dt_alias AND
1550: sequence_number = cp_sequence_number AND
1551: cal_type = cp_cal_type AND
1552: ci_sequence_number = cp_ci_sequence_number;

Line 1597: -- Check for the existence of the IGS_CA_DA_INST

1593: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET_STRING('IGS','IGS_FI_FEE_RETN_SCH_CLASHES'));
1594:
1595: ELSE
1596: CLOSE c_frtns_dest_u;
1597: -- Check for the existence of the IGS_CA_DA_INST
1598: -- record under the destination calendar
1599: OPEN c_dai( v_frtns_source_rec.dt_alias,
1600: v_frtns_source_rec.dai_sequence_number,
1601: p_dest_cal_type,

Line 1746: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;

1742: v_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE;
1743: v_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE;
1744: v_next_fcfl BOOLEAN;
1745: v_valid_dai BOOLEAN;
1746: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;
1747: l_n_org_id IGS_FI_F_CAT_FEE_LBL.ORG_ID%type := igs_ge_gen_003.get_org_id;
1748: l_rowid VARCHAR2(25);
1749: CURSOR c_fcfl_fss IS
1750: SELECT fcfl.fee_type,

Line 1783: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,

1779: WHERE ftci.fee_type = cp_fee_type AND
1780: ftci.fee_cal_type = p_dest_cal_type AND
1781: ftci.fee_ci_sequence_number = p_dest_sequence_number;
1782: CURSOR c_dai (
1783: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1784: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1785: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1786: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1787: SELECT dt_alias

Line 1784: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,

1780: ftci.fee_cal_type = p_dest_cal_type AND
1781: ftci.fee_ci_sequence_number = p_dest_sequence_number;
1782: CURSOR c_dai (
1783: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1784: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1785: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1786: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1787: SELECT dt_alias
1788: FROM IGS_CA_DA_INST

Line 1785: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,

1781: ftci.fee_ci_sequence_number = p_dest_sequence_number;
1782: CURSOR c_dai (
1783: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1784: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1785: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1786: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1787: SELECT dt_alias
1788: FROM IGS_CA_DA_INST
1789: WHERE dt_alias = cp_dt_alias AND

Line 1786: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS

1782: CURSOR c_dai (
1783: cp_dt_alias IGS_CA_DA_INST.dt_alias%TYPE,
1784: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1785: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1786: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1787: SELECT dt_alias
1788: FROM IGS_CA_DA_INST
1789: WHERE dt_alias = cp_dt_alias AND
1790: sequence_number = cp_sequence_number AND

Line 1788: FROM IGS_CA_DA_INST

1784: cp_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
1785: cp_cal_type IGS_CA_DA_INST.cal_type%TYPE,
1786: cp_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
1787: SELECT dt_alias
1788: FROM IGS_CA_DA_INST
1789: WHERE dt_alias = cp_dt_alias AND
1790: sequence_number = cp_sequence_number AND
1791: cal_type = cp_cal_type AND
1792: ci_sequence_number = cp_ci_sequence_number;

Line 4028: CURSOR cur_dai_exist(cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,

4024: AND teach_ci_sequence_number = cp_teach_seq_number;
4025:
4026: -- Cursor for validating IF the Date Alias Instance exists for the Rolled Over
4027: -- Teaching Period.
4028: CURSOR cur_dai_exist(cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,
4029: cp_dai_seq_num igs_ca_da_inst.sequence_number%TYPE,
4030: cp_teach_cal_type igs_ca_da_inst.cal_type%TYPE,
4031: cp_teach_seq_num igs_ca_da_inst.ci_sequence_number%TYPE) IS
4032: SELECT dt_alias,

Line 4029: cp_dai_seq_num igs_ca_da_inst.sequence_number%TYPE,

4025:
4026: -- Cursor for validating IF the Date Alias Instance exists for the Rolled Over
4027: -- Teaching Period.
4028: CURSOR cur_dai_exist(cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,
4029: cp_dai_seq_num igs_ca_da_inst.sequence_number%TYPE,
4030: cp_teach_cal_type igs_ca_da_inst.cal_type%TYPE,
4031: cp_teach_seq_num igs_ca_da_inst.ci_sequence_number%TYPE) IS
4032: SELECT dt_alias,
4033: sequence_number

Line 4030: cp_teach_cal_type igs_ca_da_inst.cal_type%TYPE,

4026: -- Cursor for validating IF the Date Alias Instance exists for the Rolled Over
4027: -- Teaching Period.
4028: CURSOR cur_dai_exist(cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,
4029: cp_dai_seq_num igs_ca_da_inst.sequence_number%TYPE,
4030: cp_teach_cal_type igs_ca_da_inst.cal_type%TYPE,
4031: cp_teach_seq_num igs_ca_da_inst.ci_sequence_number%TYPE) IS
4032: SELECT dt_alias,
4033: sequence_number
4034: FROM igs_ca_da_inst

Line 4031: cp_teach_seq_num igs_ca_da_inst.ci_sequence_number%TYPE) IS

4027: -- Teaching Period.
4028: CURSOR cur_dai_exist(cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,
4029: cp_dai_seq_num igs_ca_da_inst.sequence_number%TYPE,
4030: cp_teach_cal_type igs_ca_da_inst.cal_type%TYPE,
4031: cp_teach_seq_num igs_ca_da_inst.ci_sequence_number%TYPE) IS
4032: SELECT dt_alias,
4033: sequence_number
4034: FROM igs_ca_da_inst
4035: WHERE cal_type = cp_teach_cal_type

Line 4034: FROM igs_ca_da_inst

4030: cp_teach_cal_type igs_ca_da_inst.cal_type%TYPE,
4031: cp_teach_seq_num igs_ca_da_inst.ci_sequence_number%TYPE) IS
4032: SELECT dt_alias,
4033: sequence_number
4034: FROM igs_ca_da_inst
4035: WHERE cal_type = cp_teach_cal_type
4036: AND ci_sequence_number = cp_teach_seq_num
4037: AND dt_alias = cp_dt_alias
4038: AND sequence_number = cp_dai_seq_num;