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_FIN_LT_CHG dependencies on IGS_FI_F_TYP_CA_INST_ALL

Line 186: p_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

182: END IF;
183: END validate_plan_name;
184:
185: FUNCTION validate_ftci(p_cur_plan cur_plan%ROWTYPE,
186: p_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
187: p_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE)
188: RETURN BOOLEAN AS
189: /***********************************************************************************************
190:

Line 187: p_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE)

183: END validate_plan_name;
184:
185: FUNCTION validate_ftci(p_cur_plan cur_plan%ROWTYPE,
186: p_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
187: p_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE)
188: RETURN BOOLEAN AS
189: /***********************************************************************************************
190:
191: Created By : Sarakshi

Line 202: CURSOR cur_val(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

198: SYkrishn 30/APR/2002 Modified the cursor cur_val to compare fee type ci status
199: with system status of Fee Structure status Bug 2348883
200: Sarakshi 15-Jan-2002 Modifies the cursor cur_val to remove subaccount_id check ,bug:2175865
201: ********************************************************************************************** */
202: CURSOR cur_val(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
203: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
204: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
205: SELECT 'X'
206: FROM igs_fi_f_typ_ca_inst_all fcc,

Line 203: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

199: with system status of Fee Structure status Bug 2348883
200: Sarakshi 15-Jan-2002 Modifies the cursor cur_val to remove subaccount_id check ,bug:2175865
201: ********************************************************************************************** */
202: CURSOR cur_val(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
203: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
204: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
205: SELECT 'X'
206: FROM igs_fi_f_typ_ca_inst_all fcc,
207: -- bug 5018036: Changed igs_fi_f_typ_ca_inst_lkp_v to igs_fi_f_typ_ca_inst_all

Line 204: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS

200: Sarakshi 15-Jan-2002 Modifies the cursor cur_val to remove subaccount_id check ,bug:2175865
201: ********************************************************************************************** */
202: CURSOR cur_val(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
203: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
204: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
205: SELECT 'X'
206: FROM igs_fi_f_typ_ca_inst_all fcc,
207: -- bug 5018036: Changed igs_fi_f_typ_ca_inst_lkp_v to igs_fi_f_typ_ca_inst_all
208: igs_fi_fee_str_stat fss

Line 206: FROM igs_fi_f_typ_ca_inst_all fcc,

202: CURSOR cur_val(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
203: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
204: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
205: SELECT 'X'
206: FROM igs_fi_f_typ_ca_inst_all fcc,
207: -- bug 5018036: Changed igs_fi_f_typ_ca_inst_lkp_v to igs_fi_f_typ_ca_inst_all
208: igs_fi_fee_str_stat fss
209: WHERE fcc.fee_type = cp_fee_type
210: AND fcc.fee_cal_type = cp_fee_cal_type

Line 207: -- bug 5018036: Changed igs_fi_f_typ_ca_inst_lkp_v to igs_fi_f_typ_ca_inst_all

203: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
204: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
205: SELECT 'X'
206: FROM igs_fi_f_typ_ca_inst_all fcc,
207: -- bug 5018036: Changed igs_fi_f_typ_ca_inst_lkp_v to igs_fi_f_typ_ca_inst_all
208: igs_fi_fee_str_stat fss
209: WHERE fcc.fee_type = cp_fee_type
210: AND fcc.fee_cal_type = cp_fee_cal_type
211: AND fcc.fee_ci_sequence_number = cp_fee_ci_sequence_number

Line 1465: sapanigr 13-Feb-2006 Bug 5018036 - Modified cur_fee to reference base table igs_fi_f_typ_ca_inst_all and igs_ca_inst ci.

1461:
1462: Known limitations,enhancements,remarks:
1463: Change History
1464: Who When What
1465: sapanigr 13-Feb-2006 Bug 5018036 - Modified cur_fee to reference base table igs_fi_f_typ_ca_inst_all and igs_ca_inst ci.
1466: It was earlier using igs_fi_f_typ_ca_inst_lkp_v.
1467: pmarada 01-sep-04 bug 3687308 - Enforcing user to pass either person id or personid group
1468: pathipat 26-Apr-2004 Bug 3578249 - Modified cursor cur_yes_no - Replaced fnd_lookup_values
1469: with igs_lookup_values, changed lookup_type to YES_NO from SYS_YES_NO

Line 1490: CURSOR cur_fee(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

1486: l_cur_ref cur_ref;
1487:
1488: l_v_person_number igs_fi_parties_v.person_number%TYPE := NULL;
1489:
1490: CURSOR cur_fee(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
1491: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
1492: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
1493: SELECT ci.start_dt start_dt,ci.end_dt end_dt
1494: FROM igs_fi_f_typ_ca_inst_all ftci, igs_ca_inst ci

Line 1491: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

1487:
1488: l_v_person_number igs_fi_parties_v.person_number%TYPE := NULL;
1489:
1490: CURSOR cur_fee(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
1491: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
1492: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
1493: SELECT ci.start_dt start_dt,ci.end_dt end_dt
1494: FROM igs_fi_f_typ_ca_inst_all ftci, igs_ca_inst ci
1495: WHERE ftci.fee_type=cp_fee_type

Line 1492: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS

1488: l_v_person_number igs_fi_parties_v.person_number%TYPE := NULL;
1489:
1490: CURSOR cur_fee(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
1491: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
1492: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
1493: SELECT ci.start_dt start_dt,ci.end_dt end_dt
1494: FROM igs_fi_f_typ_ca_inst_all ftci, igs_ca_inst ci
1495: WHERE ftci.fee_type=cp_fee_type
1496: AND ftci.fee_cal_type=cp_fee_cal_type

Line 1494: FROM igs_fi_f_typ_ca_inst_all ftci, igs_ca_inst ci

1490: CURSOR cur_fee(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
1491: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
1492: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
1493: SELECT ci.start_dt start_dt,ci.end_dt end_dt
1494: FROM igs_fi_f_typ_ca_inst_all ftci, igs_ca_inst ci
1495: WHERE ftci.fee_type=cp_fee_type
1496: AND ftci.fee_cal_type=cp_fee_cal_type
1497: AND ftci.fee_ci_sequence_number=cp_fee_ci_sequence_number
1498: AND ci.cal_type = ftci.fee_cal_type