APPS.IGS_EN_ELGBL_PERSON dependencies on FND_PROFILE

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

839:
840:
841: IF upper(l_return_val) <> 'TRUE' THEN
842: l_rule_text := null;
843: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
844: l_rule_text := igs_ru_gen_003.Rulp_Get_Rule(rec_vald_steps.rul_sequence_number );
845: END IF;
846:
847: IF l_notification_flag = 'DENY' THEN

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

906: END LOOP;
907:
908: IF upper(l_return_val) = 'TRUE' THEN
909: l_rule_text := null;
910: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
911: l_rule_text := igs_ru_gen_003.Rulp_Get_Rule(rec_vald_steps.rul_sequence_number );
912: END IF;
913:
914: IF l_notification_flag = 'DENY' THEN

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

960: p_message => l_message_text
961: );
962: IF upper(l_return_val) <> 'TRUE' THEN
963: l_rule_text := null;
964: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
965: l_rule_text := igs_ru_gen_003.Rulp_Get_Rule(rec_vald_steps.rul_sequence_number );
966: END IF;
967:
968: IF l_notification_flag = 'DENY' THEN

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

1033: END LOOP;
1034:
1035: IF upper(l_return_val) <> 'TRUE' THEN
1036: l_rule_text := null;
1037: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
1038: l_rule_text := igs_ru_gen_003.Rulp_Get_Rule(rec_vald_steps.rul_sequence_number );
1039: END IF;
1040:
1041: IF l_notification_flag = 'DENY' THEN

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

1104: END LOOP;
1105:
1106: IF upper(l_return_val) <> 'TRUE' THEN
1107: l_rule_text := null;
1108: IF(NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N')='Y') THEN
1109: l_rule_text := igs_ru_gen_003.Rulp_Get_Rule(rec_vald_steps.rul_sequence_number );
1110: END IF;
1111:
1112: IF l_notification_flag = 'DENY' THEN

Line 1479: lv_validate_timeslot CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('IGS_EN_VAL_TIMESLOT');

1475: FROM igs_ca_teach_to_load_v
1476: WHERE teach_cal_type = cp_teach_cal_type
1477: AND teach_ci_sequence_number = cp_teach_ci_seq_no;
1478: rec_load_cal c_load_cal%ROWTYPE;
1479: lv_validate_timeslot CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('IGS_EN_VAL_TIMESLOT');
1480: lv_timeslot_rec_found BOOLEAN ;
1481: BEGIN
1482: --
1483: -- get the cal type and seq number if p_uoo_id is not null