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_ASS dependencies on IGS_FI_FAI_DTLS

Line 852: p_n_uoo_id igs_fi_fai_dtls.uoo_id%TYPE,

848: p_fee_type igs_fi_fee_as_all.fee_type%TYPE,
849: p_fee_cal_type igs_fi_fee_as_all.fee_cal_type%TYPE,
850: p_fee_ci_sequence_number igs_fi_fee_as_all.fee_ci_sequence_number%TYPE,
851: p_course_cd igs_fi_fee_as_all.course_cd%TYPE,
852: p_n_uoo_id igs_fi_fai_dtls.uoo_id%TYPE,
853: p_trace_on VARCHAR2,
854: p_d_gl_date igs_fi_invln_int_all.gl_date%TYPE,
855: p_n_diff_amount NUMBER,
856: p_v_retention_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,

Line 1564: l_v_inst_course_cd igs_fi_fai_dtls.course_cd%TYPE;

1560: v_derived_unit_version_num igs_fi_fee_as_rate.unit_version_number%TYPE;
1561: v_derived_unit_level igs_fi_fee_as_rate.unit_level%TYPE;
1562: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;
1563:
1564: l_v_inst_course_cd igs_fi_fai_dtls.course_cd%TYPE;
1565: l_v_inst_unit_att_status igs_fi_fai_dtls.unit_attempt_status%TYPE;
1566: l_v_inst_location_cd igs_fi_fai_dtls.location_cd%TYPE;
1567: l_v_inst_org_unit_cd igs_fi_fai_dtls.org_unit_cd%TYPE;
1568: l_b_derived BOOLEAN := FALSE;

Line 1565: l_v_inst_unit_att_status igs_fi_fai_dtls.unit_attempt_status%TYPE;

1561: v_derived_unit_level igs_fi_fee_as_rate.unit_level%TYPE;
1562: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;
1563:
1564: l_v_inst_course_cd igs_fi_fai_dtls.course_cd%TYPE;
1565: l_v_inst_unit_att_status igs_fi_fai_dtls.unit_attempt_status%TYPE;
1566: l_v_inst_location_cd igs_fi_fai_dtls.location_cd%TYPE;
1567: l_v_inst_org_unit_cd igs_fi_fai_dtls.org_unit_cd%TYPE;
1568: l_b_derived BOOLEAN := FALSE;
1569: l_n_called NUMBER;

Line 1566: l_v_inst_location_cd igs_fi_fai_dtls.location_cd%TYPE;

1562: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;
1563:
1564: l_v_inst_course_cd igs_fi_fai_dtls.course_cd%TYPE;
1565: l_v_inst_unit_att_status igs_fi_fai_dtls.unit_attempt_status%TYPE;
1566: l_v_inst_location_cd igs_fi_fai_dtls.location_cd%TYPE;
1567: l_v_inst_org_unit_cd igs_fi_fai_dtls.org_unit_cd%TYPE;
1568: l_b_derived BOOLEAN := FALSE;
1569: l_n_called NUMBER;
1570: l_n_count NUMBER;

Line 1567: l_v_inst_org_unit_cd igs_fi_fai_dtls.org_unit_cd%TYPE;

1563:
1564: l_v_inst_course_cd igs_fi_fai_dtls.course_cd%TYPE;
1565: l_v_inst_unit_att_status igs_fi_fai_dtls.unit_attempt_status%TYPE;
1566: l_v_inst_location_cd igs_fi_fai_dtls.location_cd%TYPE;
1567: l_v_inst_org_unit_cd igs_fi_fai_dtls.org_unit_cd%TYPE;
1568: l_b_derived BOOLEAN := FALSE;
1569: l_n_called NUMBER;
1570: l_n_count NUMBER;
1571: l_v_trace_on VARCHAR2(5);

Line 5041: CURSOR cur_fai_dtls (cp_n_fee_ass_item_id igs_fi_fai_dtls.fee_ass_item_id%TYPE) IS

5037: WHERE fee_type = cp_v_fee_type
5038: AND fee_cal_type = cp_v_fee_cal_type
5039: AND fee_ci_sequence_number = cp_n_fee_ci_seq_number;
5040:
5041: CURSOR cur_fai_dtls (cp_n_fee_ass_item_id igs_fi_fai_dtls.fee_ass_item_id%TYPE) IS
5042: SELECT fai.*
5043: FROM igs_fi_fai_dtls fai
5044: WHERE fee_ass_item_id = cp_n_fee_ass_item_id;
5045:

Line 5043: FROM igs_fi_fai_dtls fai

5039: AND fee_ci_sequence_number = cp_n_fee_ci_seq_number;
5040:
5041: CURSOR cur_fai_dtls (cp_n_fee_ass_item_id igs_fi_fai_dtls.fee_ass_item_id%TYPE) IS
5042: SELECT fai.*
5043: FROM igs_fi_fai_dtls fai
5044: WHERE fee_ass_item_id = cp_n_fee_ass_item_id;
5045:
5046: CURSOR cur_dropped_unit (cp_person_id hz_parties.party_id%TYPE,
5047: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

Line 6171: p_v_string => 'Inserting record in IGS_FI_FAI_DTLS with UOO_ID: '||tbl_fai_unit_dtls(j).uoo_id||

6167: LOOP
6168: l_v_fai_rowid := NULL;
6169: l_v_fee_as_item_dtl_id := NULL;
6170: log_to_fnd( p_v_module => 'finpl_ins_fee_ass',
6171: p_v_string => 'Inserting record in IGS_FI_FAI_DTLS with UOO_ID: '||tbl_fai_unit_dtls(j).uoo_id||
6172: ' for Fee Assessment Item ID: '||lv_fee_ass_item_id);
6173: igs_fi_fai_dtls_pkg.insert_row(
6174: x_rowid => l_v_fai_rowid,
6175: x_fee_as_item_dtl_id => l_v_fee_as_item_dtl_id,

Line 6173: igs_fi_fai_dtls_pkg.insert_row(

6169: l_v_fee_as_item_dtl_id := NULL;
6170: log_to_fnd( p_v_module => 'finpl_ins_fee_ass',
6171: p_v_string => 'Inserting record in IGS_FI_FAI_DTLS with UOO_ID: '||tbl_fai_unit_dtls(j).uoo_id||
6172: ' for Fee Assessment Item ID: '||lv_fee_ass_item_id);
6173: igs_fi_fai_dtls_pkg.insert_row(
6174: x_rowid => l_v_fai_rowid,
6175: x_fee_as_item_dtl_id => l_v_fee_as_item_dtl_id,
6176: x_fee_ass_item_id => lv_fee_ass_item_id,
6177: x_fee_cat => tbl_fai_unit_dtls(j).fee_cat,