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_WAIVERS dependencies on IGS_CA_INST

Line 19: g_v_alternatecode igs_ca_inst.alternate_code%TYPE;

15: conditional check for waiver category "COMP_RULE" was removed.
16:
17: ***************************************************************** */
18:
19: g_v_alternatecode igs_ca_inst.alternate_code%TYPE;
20:
21: g_v_seperator CONSTANT VARCHAR2(1) := '-';
22:
23: -- Procedure for enabling statement level logging

Line 40: FUNCTION validate_params(p_v_fee_cal_type igs_ca_inst.cal_type%TYPE,

36: x_return_status OUT NOCOPY VARCHAR2
37: );
38:
39:
40: FUNCTION validate_params(p_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
41: p_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
42: p_v_fee_type igs_fi_fee_type.fee_type%TYPE,
43: p_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) RETURN BOOLEAN AS
44:

Line 41: p_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,

37: );
38:
39:
40: FUNCTION validate_params(p_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
41: p_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
42: p_v_fee_type igs_fi_fee_type.fee_type%TYPE,
43: p_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) RETURN BOOLEAN AS
44:
45: /******************************************************************

Line 59: CURSOR cur_wav_pgm(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,

55: "COMP_RULE" was removed.
56:
57: ***************************************************************** */
58:
59: CURSOR cur_wav_pgm(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
60: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
61: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
62: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
63: SELECT waiver_name

Line 60: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,

56:
57: ***************************************************************** */
58:
59: CURSOR cur_wav_pgm(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
60: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
61: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
62: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
63: SELECT waiver_name
64: FROM igs_fi_waiver_pgms

Line 588: CURSOR cur_wav_pgm(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,

584: CCR. Added check for the Error Account = 'Y'
585:
586: ***************************************************************** */
587:
588: CURSOR cur_wav_pgm(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
589: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
590: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
591: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
592: SELECT fwp.*

Line 589: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,

585:
586: ***************************************************************** */
587:
588: CURSOR cur_wav_pgm(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
589: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
590: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
591: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
592: SELECT fwp.*
593: FROM igs_fi_waiver_pgms fwp

Line 601: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,

597: AND ((fwp.waiver_name = cp_v_waiver_name) OR (cp_v_waiver_name IS NULL))
598: ORDER BY fwp.creation_date;
599:
600: CURSOR cur_wav_std_pgm(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
601: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
602: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
603: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
604: SELECT assignment_status_code
605: FROM igs_fi_wav_std_pgms

Line 602: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,

598: ORDER BY fwp.creation_date;
599:
600: CURSOR cur_wav_std_pgm(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
601: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
602: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
603: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
604: SELECT assignment_status_code
605: FROM igs_fi_wav_std_pgms
606: WHERE person_id = cp_n_person_id

Line 1194: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

1190: p_v_fee_cal IN VARCHAR2,
1191: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1192: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1193: p_d_gl_date IN VARCHAR2,
1194: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1195: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1196: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1197: p_n_ld_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1198: p_val_status OUT NOCOPY BOOLEAN) IS

Line 1195: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,

1191: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1192: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1193: p_d_gl_date IN VARCHAR2,
1194: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1195: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1196: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1197: p_n_ld_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1198: p_val_status OUT NOCOPY BOOLEAN) IS
1199: ------------------------------------------------------------------

Line 1196: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

1192: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1193: p_d_gl_date IN VARCHAR2,
1194: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1195: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1196: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1197: p_n_ld_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1198: p_val_status OUT NOCOPY BOOLEAN) IS
1199: ------------------------------------------------------------------
1200: --Created by :Gurpreet Singh , Oracle India (in)

Line 1197: p_n_ld_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,

1193: p_d_gl_date IN VARCHAR2,
1194: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1195: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1196: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1197: p_n_ld_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1198: p_val_status OUT NOCOPY BOOLEAN) IS
1199: ------------------------------------------------------------------
1200: --Created by :Gurpreet Singh , Oracle India (in)
1201: --Date created: 08-Aug, 2005

Line 1248: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;

1244: l_v_valid_person VARCHAR2(1);
1245: l_v_dummy VARCHAR2(1);
1246: l_b_parameter_val_status BOOLEAN;
1247:
1248: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
1249: l_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1250: l_v_message_name fnd_new_messages.message_name%TYPE;
1251:
1252: l_b_return_stat BOOLEAN;

Line 1249: l_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1245: l_v_dummy VARCHAR2(1);
1246: l_b_parameter_val_status BOOLEAN;
1247:
1248: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
1249: l_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1250: l_v_message_name fnd_new_messages.message_name%TYPE;
1251:
1252: l_b_return_stat BOOLEAN;
1253: l_v_closing_status igs_fi_gl_periods_v.closing_status%TYPE;

Line 1255: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;

1251:
1252: l_b_return_stat BOOLEAN;
1253: l_v_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
1254:
1255: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1256: l_n_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1257:
1258: BEGIN
1259: l_b_parameter_val_status := TRUE;

Line 1256: l_n_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1252: l_b_return_stat BOOLEAN;
1253: l_v_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
1254:
1255: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1256: l_n_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1257:
1258: BEGIN
1259: l_b_parameter_val_status := TRUE;
1260:

Line 1465: CURSOR c_get_alt_code(cp_v_cal_type igs_ca_inst.cal_type%TYPE,

1461: --Change History:
1462: --Who When What
1463: -------------------------------------------------------------------
1464: --Cursor For Getting The Alternate Code For The Fee Period.
1465: CURSOR c_get_alt_code(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1466: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1467: SELECT alternate_code
1468: FROM igs_ca_inst_all
1469: WHERE cal_type = cp_v_cal_type

Line 1466: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS

1462: --Who When What
1463: -------------------------------------------------------------------
1464: --Cursor For Getting The Alternate Code For The Fee Period.
1465: CURSOR c_get_alt_code(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1466: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1467: SELECT alternate_code
1468: FROM igs_ca_inst_all
1469: WHERE cal_type = cp_v_cal_type
1470: AND sequence_number = cp_n_sequence_number;

Line 1468: FROM igs_ca_inst_all

1464: --Cursor For Getting The Alternate Code For The Fee Period.
1465: CURSOR c_get_alt_code(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1466: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1467: SELECT alternate_code
1468: FROM igs_ca_inst_all
1469: WHERE cal_type = cp_v_cal_type
1470: AND sequence_number = cp_n_sequence_number;
1471:
1472: l_c_alt_code_desc c_get_alt_code%ROWTYPE;

Line 1562: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;

1558: -- Out Parameters from the Process_Waivers procedure.
1559: l_b_recs_found BOOLEAN;
1560: l_v_return_status VARCHAR2(1);
1561: l_b_validate_parm_status BOOLEAN;
1562: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1563: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1564: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1565: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1566:

Line 1563: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;

1559: l_b_recs_found BOOLEAN;
1560: l_v_return_status VARCHAR2(1);
1561: l_b_validate_parm_status BOOLEAN;
1562: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1563: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1564: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1565: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1566:
1567: l_conv_process_run_ind igs_fi_control.conv_process_run_ind%TYPE;

Line 1564: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;

1560: l_v_return_status VARCHAR2(1);
1561: l_b_validate_parm_status BOOLEAN;
1562: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1563: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1564: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1565: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1566:
1567: l_conv_process_run_ind igs_fi_control.conv_process_run_ind%TYPE;
1568: l_n_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;

Line 1565: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;

1561: l_b_validate_parm_status BOOLEAN;
1562: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1563: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1564: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1565: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1566:
1567: l_conv_process_run_ind igs_fi_control.conv_process_run_ind%TYPE;
1568: l_n_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
1569: l_d_last_conversion_date igs_fi_balance_rules.last_conversion_date%TYPE;

Line 1590: CURSOR c_get_alt_code(cp_v_cal_type igs_ca_inst.cal_type%TYPE,

1586: WHERE group_id = c_group_id;
1587: l_c_get_person_grp c_get_person_grp%ROWTYPE;
1588:
1589: --Cursor For Getting The Alternate Code For The Fee Period.
1590: CURSOR c_get_alt_code(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1591: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1592: SELECT alternate_code
1593: FROM igs_ca_inst_all
1594: WHERE cal_type = cp_v_cal_type

Line 1591: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS

1587: l_c_get_person_grp c_get_person_grp%ROWTYPE;
1588:
1589: --Cursor For Getting The Alternate Code For The Fee Period.
1590: CURSOR c_get_alt_code(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1591: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1592: SELECT alternate_code
1593: FROM igs_ca_inst_all
1594: WHERE cal_type = cp_v_cal_type
1595: AND sequence_number = cp_n_sequence_number;

Line 1593: FROM igs_ca_inst_all

1589: --Cursor For Getting The Alternate Code For The Fee Period.
1590: CURSOR c_get_alt_code(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1591: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1592: SELECT alternate_code
1593: FROM igs_ca_inst_all
1594: WHERE cal_type = cp_v_cal_type
1595: AND sequence_number = cp_n_sequence_number;
1596:
1597: l_c_alt_code_desc c_get_alt_code%ROWTYPE;