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_EN_ELGBL_UNIT dependencies on FND_PROFILE

Line 136: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'));

132: WHERE uoo_id=p_uoo_id
133: AND no_assessment_ind = 'Y' -- For Audit TD Bug 2641864
134: AND (( p_calling_obj <> 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM') ) OR
135: (p_calling_obj = 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM','PLANNED') )
136: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'));
137:
138:
139:
140: TYPE step_rec IS RECORD(

Line 1217: IF (NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN

1213:
1214: l_rule_text := NULL;
1215: IF p_calling_obj NOT IN ('JOB','SCH_UPD') THEN
1216:
1217: IF (NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
1218: l_rule_text := igs_ru_gen_003.Rulp_Get_Rule(p_rule_seq_number);
1219: END IF;
1220: l_message_icon := substr(p_deny_warn,1,1);
1221: igs_en_drop_units_api.create_ss_warning (

Line 1646: OR (sua.unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))

1642: WHERE sua.person_id = p_person_id
1643: AND ( sua.cart IS NOT NULL AND ( p_calling_obj <> 'SWAP' OR (p_calling_obj = 'SWAP' AND sua.uoo_id <> p_uoo_id) ) )
1644: AND ((p_calling_obj <> 'PLAN' AND sua.unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM') )
1645: OR (p_calling_obj = 'PLAN' AND sua.unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM','PLANNED') )
1646: OR (sua.unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))
1647: AND sua.unit_cd = psv.unit_cd
1648: AND sua.version_number = psv.version_number
1649: AND ( ( sua.unit_cd = cp_unit_cd AND sua.version_number = cp_version_number)
1650: OR psv.rpt_fmly_id = ( SELECT psu.rpt_fmly_id

Line 1819: IF NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'BOTH'

1815:
1816:
1817: IF (l_repeat_allowed = 'N') THEN
1818:
1819: IF NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'BOTH'
1820: OR NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'REPEAT_EXTERNAL' THEN
1821: --
1822: -- Call User Hook.
1823: --

Line 1820: OR NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'REPEAT_EXTERNAL' THEN

1816:
1817: IF (l_repeat_allowed = 'N') THEN
1818:
1819: IF NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'BOTH'
1820: OR NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'REPEAT_EXTERNAL' THEN
1821: --
1822: -- Call User Hook.
1823: --
1824: l_user_hook_successful := NULL;

Line 1896: END IF; -- FND_PROFILE.VALUE

1892:
1893: RETURN FALSE;
1894: END IF; -- user hook successful
1895:
1896: END IF; -- FND_PROFILE.VALUE
1897:
1898: END IF; -- l_repeat_allowed
1899:
1900: -- If there is no student unit attempt then the Unit is not considered as repeat.

Line 2041: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))

2037: AND sua.version_number = cp_version_number
2038: AND sua.uoo_id = cps.uoo_id(+)
2039: AND ((p_calling_obj <> 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM') )
2040: OR (p_calling_obj = 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM','PLANNED') )
2041: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))
2042: AND ( sua.cart IS NOT NULL AND ( p_calling_obj <> 'SWAP' OR (p_calling_obj = 'SWAP' AND sua.uoo_id <> p_uoo_id) ) )
2043: UNION
2044: SELECT adv.unit_cd,
2045: adv.version_number,

Line 2183: IF NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'BOTH'

2179: CLOSE cur_reenroll_in_same_tp_usec;
2180:
2181: IF (l_reenroll_allowed = 'Y') THEN
2182:
2183: IF NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'BOTH'
2184: OR NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'REENROLL_EXTERNAL' THEN
2185: --
2186: -- Call User Hook.
2187: --

Line 2184: OR NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'REENROLL_EXTERNAL' THEN

2180:
2181: IF (l_reenroll_allowed = 'Y') THEN
2182:
2183: IF NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'BOTH'
2184: OR NVL(FND_PROFILE.VALUE('IGS_EN_REP_REN'),'NONE') = 'REENROLL_EXTERNAL' THEN
2185: --
2186: -- Call User Hook.
2187: --
2188: IF l_unit_mus = 'N' OR l_reenroll_in_same_tp = 'Y' THEN

Line 2264: END IF; -- FND_PROFILE.VALUE

2260: END IF;
2261: END IF; --IF p_calling_obj <> 'JOB'
2262: RETURN FALSE;
2263: END IF; -- user hook successful
2264: END IF; -- FND_PROFILE.VALUE
2265: END IF; -- l_reenroll_allowed
2266:
2267: -- There are no reenrolled unit attempts or advance standing for this unit
2268: -- So return TRUE.

Line 2538: ( NOT EXISTS(SELECT 'X' FROM IGS_EN_INST_WL_STPS ) AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y' )

2534: ( p_calling_obj <>'PLAN' AND
2535: ( ua.unit_attempt_status IN ( 'ENROLLED','INVALID') OR
2536: ( ua.unit_attempt_status = 'WAITLISTED' AND
2537: ( EXISTS(SELECT 'X' FROM IGS_EN_INST_WL_STPS WHERE TIME_CONFL_ALWD_WLST_FLAG = 'N' ) OR
2538: ( NOT EXISTS(SELECT 'X' FROM IGS_EN_INST_WL_STPS ) AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y' )
2539: )
2540: )
2541: )
2542: )

Line 2547: ( NOT EXISTS(SELECT 'X' FROM IGS_EN_INST_WL_STPS ) AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y' )

2543: OR
2544: ( p_calling_obj ='PLAN' AND
2545: (ua.unit_attempt_status IN ( 'ENROLLED','INVALID','PLANNED') OR
2546: (ua.unit_attempt_status = 'WAITLISTED' AND (EXISTS(SELECT 'X' FROM IGS_EN_INST_WL_STPS WHERE TIME_CONFL_ALWD_WLST_FLAG = 'N') ) OR
2547: ( NOT EXISTS(SELECT 'X' FROM IGS_EN_INST_WL_STPS ) AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y' )
2548: )
2549: )
2550: )
2551:

Line 2836: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN

2832: ) = 'true' THEN
2833: RETURN TRUE;
2834: END IF;
2835:
2836: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
2837: l_rule_text :=igs_ru_gen_003.Rulp_Get_Rule(l_rul_sequence_number);
2838: END IF;
2839: IF p_deny_warn = 'WARN' THEN
2840: IF p_calling_obj = 'JOB' THEN

Line 3006: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN

3002: ) = 'true' THEN
3003: RETURN TRUE;
3004: END IF;
3005:
3006: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
3007: l_rule_text :=igs_ru_gen_003.Rulp_Get_Rule(l_rul_sequence_number);
3008: END IF;
3009:
3010: IF p_deny_warn = 'WARN' THEN

Line 3182: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN

3178: END IF;
3179:
3180: IF p_calling_obj NOT IN ('JOB','SCH_UPD') THEN
3181:
3182: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
3183: l_rule_text := igs_ru_gen_003.Rulp_Get_Rule(l_rul_sequence_number);
3184: END IF;
3185: l_message_icon := substr(p_deny_warn,1,1);
3186: igs_en_drop_units_api.create_ss_warning (

Line 4456: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN

4452: END IF;
4453:
4454: IF p_calling_obj NOT IN ('JOB','SCH_UPD','JOB_FROM_WAITLIST') THEN
4455:
4456: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
4457: l_rule_text := igs_ru_gen_003.Rulp_Get_Rule(p_rule_seq_number);
4458: END IF;
4459: l_message_icon := substr(p_deny_warn,1,1);
4460: igs_en_drop_units_api.create_ss_warning (

Line 4626: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN

4622: l_rule_text := NULL;
4623:
4624: IF p_calling_obj NOT IN ('JOB','SCH_UPD','JOB_FROM_WAITLIST') THEN
4625:
4626: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
4627: l_rule_text := igs_ru_gen_003.Rulp_Get_Rule(p_rule_seq_number);
4628: END IF;
4629: l_message_icon := substr(p_deny_warn,1,1);
4630: igs_en_drop_units_api.create_ss_warning (

Line 4818: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))

4814: WHERE person_id = p_person_id
4815: AND no_assessment_ind = 'Y'
4816: AND ((p_calling_obj <> 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM') )
4817: OR (p_calling_obj = 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM','PLANNED') )
4818: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))
4819: AND (cal_type,ci_sequence_number) IN (SELECT teach_cal_type,teach_ci_sequence_number
4820: FROM igs_ca_load_to_teach_v
4821: WHERE load_cal_type = p_load_cal_type AND
4822: load_ci_sequence_number = p_load_sequence_number);