APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_HE_UT_PRS_DTLS

Line 899: FROM igs_he_ut_prs_dtls upd

895: -- cursor to get the person tariff details records for deleting before calculation
896: CURSOR get_prsn_tariff_dtls_cur(cp_person_id igs_he_ut_prs_calcs.person_id%TYPE,
897: cp_calc_type igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE) IS
898: SELECT upd.rowid
899: FROM igs_he_ut_prs_dtls upd
900: WHERE person_id = cp_person_id
901: AND tariff_calc_type_cd = cp_calc_type;
902:
903: l_Int_calc_sql VARCHAR2(32767);

Line 1035: igs_he_ut_prs_dtls_pkg.delete_row(del_dtls_rec.rowid);

1031:
1032: -- delete all existing tariff records for the person and insert afresh
1033: FOR del_dtls_rec IN get_prsn_tariff_dtls_cur (l_person_id, p_tariff_calc_type)
1034: LOOP
1035: igs_he_ut_prs_dtls_pkg.delete_row(del_dtls_rec.rowid);
1036: END LOOP;
1037:
1038: -- set the flag to allow tariff calculation
1039: l_calc_prsn_tariff := 'Y';

Line 1122: igs_he_ut_prs_dtls_pkg.insert_row(

1118: END LOOP;
1119:
1120: -- create tariff details for the person
1121: l_rowid := NULL;
1122: igs_he_ut_prs_dtls_pkg.insert_row(
1123: x_rowid => l_rowid
1124: ,x_tariff_calc_type_cd => p_tariff_calc_type
1125: ,x_person_id => l_person_id
1126: ,x_award_cd => prsn_exam_level_rec.exam_level

Line 1210: FROM igs_he_ut_prs_dtls upd

1206: -- cursor to get the person tariff details records
1207: CURSOR prsn_tariff_dtls_cur(cp_person_id igs_he_ut_prs_calcs.person_id%TYPE,
1208: cp_calc_type igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE) IS
1209: SELECT upd.award_cd
1210: FROM igs_he_ut_prs_dtls upd
1211: WHERE person_id = cp_person_id
1212: AND tariff_calc_type_cd = cp_calc_type;
1213:
1214: CURSOR get_tariff_cur (cp_person_id Igs_uc_qual_dets.person_id%TYPE,