1362: AND utct.closed_ind = 'N' ;
1363: l_tariff_calc_type_cd IGS_HE_UT_CALC_TYPE.tariff_calc_type_cd%TYPE ;
1364:
1365: -- To get the Default OSS Ward mapped to a HESA Tariff Level
1366: CURSOR cur_ut_award_map ( cp_calc_type IGS_HE_UT_LVL_AWARD.tariff_calc_type_cd%TYPE,
1367: cp_tariff_level_cd IGS_HE_UT_LVL_AWARD.tariff_level_cd%TYPE ) IS
1368: SELECT utla.award_cd
1369: FROM IGS_HE_UT_LVL_AWARD utla
1370: WHERE utla.tariff_calc_type_cd = cp_calc_type
1363: l_tariff_calc_type_cd IGS_HE_UT_CALC_TYPE.tariff_calc_type_cd%TYPE ;
1364:
1365: -- To get the Default OSS Ward mapped to a HESA Tariff Level
1366: CURSOR cur_ut_award_map ( cp_calc_type IGS_HE_UT_LVL_AWARD.tariff_calc_type_cd%TYPE,
1367: cp_tariff_level_cd IGS_HE_UT_LVL_AWARD.tariff_level_cd%TYPE ) IS
1368: SELECT utla.award_cd
1369: FROM IGS_HE_UT_LVL_AWARD utla
1370: WHERE utla.tariff_calc_type_cd = cp_calc_type
1371: AND utla.tariff_level_cd = cp_tariff_level_cd
1365: -- To get the Default OSS Ward mapped to a HESA Tariff Level
1366: CURSOR cur_ut_award_map ( cp_calc_type IGS_HE_UT_LVL_AWARD.tariff_calc_type_cd%TYPE,
1367: cp_tariff_level_cd IGS_HE_UT_LVL_AWARD.tariff_level_cd%TYPE ) IS
1368: SELECT utla.award_cd
1369: FROM IGS_HE_UT_LVL_AWARD utla
1370: WHERE utla.tariff_calc_type_cd = cp_calc_type
1371: AND utla.tariff_level_cd = cp_tariff_level_cd
1372: AND utla.default_award_ind = 'Y'
1373: AND utla.closed_ind = 'N' ;
1372: AND utla.default_award_ind = 'Y'
1373: AND utla.closed_ind = 'N' ;
1374:
1375: -- smaddali added these local variables to hold OSS Award code for each HESA UT qualification ,bug#2671022
1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1373: AND utla.closed_ind = 'N' ;
1374:
1375: -- smaddali added these local variables to hold OSS Award code for each HESA UT qualification ,bug#2671022
1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1374:
1375: -- smaddali added these local variables to hold OSS Award code for each HESA UT qualification ,bug#2671022
1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1375: -- smaddali added these local variables to hold OSS Award code for each HESA UT qualification ,bug#2671022
1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1388: l_call_pers_imp BOOLEAN ;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1388: l_call_pers_imp BOOLEAN ;
1389: l_return_status VARCHAR2(1);
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1388: l_call_pers_imp BOOLEAN ;
1389: l_return_status VARCHAR2(1);
1390: l_msg_data VARCHAR2(100);
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1388: l_call_pers_imp BOOLEAN ;
1389: l_return_status VARCHAR2(1);
1390: l_msg_data VARCHAR2(100);
1391: