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_EXTRACT_DLHE_FIELDS_PKG dependencies on IGS_HE_CODE_MAP_VAL

Line 36: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

32: Change History :
33: Who When What
34: ***************************************************************/
35:
36: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
37:
38: BEGIN
39: l_he_code_map_val.association_code := 'OSS_HESA_METHOD_ASSOC';
40: l_he_code_map_val.map2 := p_dlhe_method;

Line 79: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

75: Who When What
76: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
77: ***************************************************************/
78:
79: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
80:
81: BEGIN
82: -- if method is 8 or 9 or employment value not found then return Default value.
83: IF p_hesa_method IN ('8','9') OR p_dlhe_employment IS NULL THEN

Line 124: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

120: Who When What
121: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
122: ***************************************************************/
123:
124: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
125:
126: BEGIN
127:
128: -- if method is 8 or 9 or Further study value not found then return Default value.

Line 209: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

205: Change History :
206: Who When What
207: ***************************************************************/
208:
209: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
210:
211: BEGIN
212: IF ( p_hesa_method IN ('8','9') OR p_hesa_empcir IN ('06','07','08','09','10','11','12','13','14','XX' )) AND
213: p_hesa_empcir NOT IN ('01','02','03','04','05') THEN

Line 340: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

336: Change History :
337: Who When What
338: ***************************************************************/
339:
340: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
341:
342: BEGIN
343: IF ( p_hesa_method IN ('8','9') OR p_hesa_empcir IN ('06','07','08','09','10','11','12','13','14','XX' )) AND
344: p_hesa_empcir NOT IN ('01','02','03','04','05') THEN

Line 390: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

386: Who When What
387: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
388: ***************************************************************/
389:
390: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
391:
392: BEGIN
393:
394: -- if method is 8 or 9 or empcir between 06 to 14 or if employer_size is null then return default

Line 439: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

435: Who When What
436: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
437: ***************************************************************/
438:
439: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
440:
441: BEGIN
442:
443: -- if method is 9 or empcir between 06 to 14 or if job_duration is null then return default

Line 527: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

523: Who When What
524: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
525: ***************************************************************/
526:
527: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
528:
529: BEGIN
530:
531: -- if method is 9 or empcir between 06 to 14 or if qual_requirement is null then return default

Line 576: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

572: Who When What
573: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
574: ***************************************************************/
575:
576: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
577:
578: BEGIN
579:
580: -- if method is 9 or empcir between 06 to 14 or if qual_importance is null then return default

Line 658: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

654: Who When What
655: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
656: ***************************************************************/
657:
658: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
659:
660: BEGIN
661: -- if method is 8 or 9 or empcir between 06 to 14 or if Job_source is null then return default
662: IF ( p_hesa_method IN ('8','9') OR p_hesa_empcir IN ('06','07','08','09','10','11','12','13','14','XX' )

Line 706: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

702: Who When What
703: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
704: ***************************************************************/
705:
706: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
707:
708: BEGIN
709: -- if method is 8 or 9 or empcir between 06 to 14 or if Previous_job is null then return default
710: IF ( p_hesa_method IN ('8','9') OR p_hesa_empcir IN ('06','07','08','09','10','11','12','13','14','XX' )

Line 794: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

790: Who When What
791: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
792: ***************************************************************/
793:
794: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
795:
796: BEGIN
797:
798: -- if method is 8 or 9 or empcir between 06 to 14 or if Further_study_type is null then return default

Line 843: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

839: Change History :
840: Who When What
841: ***************************************************************/
842:
843: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
844:
845: BEGIN
846: IF ( p_hesa_method IN ('8','9') OR p_hesa_modstudy IN ('3','X' ) OR p_hesa_natstudy IN ('3','4') ) THEN
847: -- default value processing

Line 940: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

936: Who When What
937: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
938: smaddali 23-sep-03 Removed parameter p_hesa_natstudy for build HECR011 , bug#3051597
939: ***************************************************************/
940: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
941:
942: BEGIN
943: -- if method is 9 or mode study is 3 or if Further_study_qualaim is null then return default
944: IF ( p_hesa_method IN ('8','9') OR p_hesa_modstudy IN ('3','X' )

Line 1071: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

1067: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
1068: smaddali 23-sep-03 Removed parameter p_hesa_natstudy, p_hesa_emppaid for build HECR011 , bug#3051597
1069: ***************************************************************/
1070:
1071: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
1072:
1073: BEGIN
1074: -- if method is 9 or modestudy is 3 or nature of study is 3,4 or if Funding_source is null then return default
1075: IF ( p_hesa_method IN ('8','9') OR p_hesa_modstudy IN ('3','X' ) OR

Line 1166: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

1162: Who When What
1163: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
1164: ***************************************************************/
1165:
1166: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
1167:
1168: BEGIN
1169: -- if method is 9 or teaching employement in 1,2,9 or if Teaching_sector is null then return default
1170: IF ( p_hesa_method IN ('8','9') OR p_hesa_tchemp IN ('1','2','9','X' ) OR p_dlhe_teach_sector IS NULL

Line 1213: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

1209: Who When What
1210: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
1211: ***************************************************************/
1212:
1213: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
1214:
1215: BEGIN
1216: -- if method is 9 or teaching employement in 1,2,9 or if Teaching_level is null then return default
1217: IF ( p_hesa_method IN ('8','9') OR p_hesa_tchemp IN ('1','2','9','X' )

Line 1261: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

1257: Who When What
1258: smaddali 04-jul-03 modified default processing for bug#3036995 to add one more condition
1259: ***************************************************************/
1260:
1261: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
1262:
1263: BEGIN
1264: -- if method is 9 or PT_Study is N or if Reason_for_PTcourse is null then return default
1265: IF ( p_hesa_method IN ('8','9') OR p_dlhe_pt_study = 'N' OR p_dlhe_reason_ptcrse IS NULL ) THEN

Line 1345: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

1341: Change History :
1342: Who When What
1343: ***************************************************************/
1344:
1345: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
1346:
1347: BEGIN
1348: IF ( p_hesa_method IN ('3','4','8','9') OR p_hesa_empcrse IN ('0','X') OR p_dlhe_pt_study = 'N' ) THEN
1349: -- default value processing