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_HE_UCAS_TARIFF_PKG dependencies on IGS_HE_UT_PRS_CALCS

Line 886: CURSOR check_prsn_tariff_exists_cur (cp_person_id igs_he_ut_prs_calcs.person_id%TYPE,

882:
883: l_person_number igs_pe_person.person_number%TYPE ;
884:
885: -- check whether person + calculation type already exists.
886: CURSOR check_prsn_tariff_exists_cur (cp_person_id igs_he_ut_prs_calcs.person_id%TYPE,
887: cp_calc_type igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE) IS
888: SELECT rowid
889: FROM igs_he_ut_prs_calcs
890: WHERE person_id = cp_person_id

Line 887: cp_calc_type igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE) IS

883: l_person_number igs_pe_person.person_number%TYPE ;
884:
885: -- check whether person + calculation type already exists.
886: CURSOR check_prsn_tariff_exists_cur (cp_person_id igs_he_ut_prs_calcs.person_id%TYPE,
887: cp_calc_type igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE) IS
888: SELECT rowid
889: FROM igs_he_ut_prs_calcs
890: WHERE person_id = cp_person_id
891: AND tariff_calc_type_cd = cp_calc_type;

Line 889: FROM igs_he_ut_prs_calcs

885: -- check whether person + calculation type already exists.
886: CURSOR check_prsn_tariff_exists_cur (cp_person_id igs_he_ut_prs_calcs.person_id%TYPE,
887: cp_calc_type igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE) IS
888: SELECT rowid
889: FROM igs_he_ut_prs_calcs
890: WHERE person_id = cp_person_id
891: AND tariff_calc_type_cd = cp_calc_type;
892:
893: check_prsn_tariff_exists_rec check_prsn_tariff_exists_cur%ROWTYPE;

Line 896: CURSOR get_prsn_tariff_dtls_cur(cp_person_id igs_he_ut_prs_calcs.person_id%TYPE,

892:
893: check_prsn_tariff_exists_rec check_prsn_tariff_exists_cur%ROWTYPE;
894:
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

Line 897: cp_calc_type igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE) IS

893: check_prsn_tariff_exists_rec check_prsn_tariff_exists_cur%ROWTYPE;
894:
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;

Line 1002: -- igs_he_ut_prs_calcs table. If no, then insert a new record irrespective of the

998: FETCH person_number_cur INTO l_person_number;
999: CLOSE person_number_cur ;
1000:
1001: -- check whether the person + Tariff Calculation type record already exists in the
1002: -- igs_he_ut_prs_calcs table. If no, then insert a new record irrespective of the
1003: -- recalculate parameter as in either case, a new record has to be created.
1004: OPEN check_prsn_tariff_exists_cur(l_person_id, p_tariff_calc_type);
1005: FETCH check_prsn_tariff_exists_cur INTO check_prsn_tariff_exists_rec;
1006: CLOSE check_prsn_tariff_exists_cur ;

Line 1011: igs_he_ut_prs_calcs_pkg.insert_row(

1007:
1008: IF check_prsn_tariff_exists_rec.rowid IS NULL THEN
1009:
1010: -- insert a new record
1011: igs_he_ut_prs_calcs_pkg.insert_row(
1012: x_rowid => check_prsn_tariff_exists_rec.rowid
1013: ,x_tariff_calc_type_cd => p_tariff_calc_type
1014: ,x_person_id => l_person_id
1015: ,x_calc_date => TRUNC(SYSDATE)

Line 1025: igs_he_ut_prs_calcs_pkg.update_row(

1021: ELSE
1022: IF p_recalculate = 'Y' THEN
1023:
1024: -- update the corresponding record's calc date
1025: igs_he_ut_prs_calcs_pkg.update_row(
1026: x_rowid => check_prsn_tariff_exists_rec.rowid
1027: ,x_tariff_calc_type_cd => p_tariff_calc_type
1028: ,x_person_id => l_person_id
1029: ,x_calc_date => TRUNC(SYSDATE)

Line 1190: p_tariff_calc_type_cd IN igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE,

1186:
1187: END internal_tariff_calc;
1188:
1189: FUNCTION total_internal_tariff (
1190: p_tariff_calc_type_cd IN igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE,
1191: p_person_id IN igs_he_ut_prs_calcs.person_id%TYPE)
1192: RETURN NUMBER AS
1193: /*------------------------------------------------------------------
1194: --Created by : AYEDUBAT, Oracle IDC

Line 1191: p_person_id IN igs_he_ut_prs_calcs.person_id%TYPE)

1187: END internal_tariff_calc;
1188:
1189: FUNCTION total_internal_tariff (
1190: p_tariff_calc_type_cd IN igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE,
1191: p_person_id IN igs_he_ut_prs_calcs.person_id%TYPE)
1192: RETURN NUMBER AS
1193: /*------------------------------------------------------------------
1194: --Created by : AYEDUBAT, Oracle IDC
1195: --Date created: 05-05-2004

Line 1198: -- Used in the view definition, IGS_HE_UT_PRS_CALCS_V

1194: --Created by : AYEDUBAT, Oracle IDC
1195: --Date created: 05-05-2004
1196: --
1197: --Purpose: To calculate the Total Tariff for a person for an internal tariff calculation type
1198: -- Used in the view definition, IGS_HE_UT_PRS_CALCS_V
1199: --Known limitations/enhancements and/or remarks:
1200: --
1201: -- Change History:
1202: WHO WHEN WHAT

Line 1207: CURSOR prsn_tariff_dtls_cur(cp_person_id igs_he_ut_prs_calcs.person_id%TYPE,

1203: AYEDUBAT 05-05-04 Created as part of the bug # 3589897
1204: --------------------------------------------------------------------------*/
1205:
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

Line 1208: cp_calc_type igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE) IS

1204: --------------------------------------------------------------------------*/
1205:
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;