APPS.IGS_PR_PROUT_LGCY_PUB dependencies on IGS_PR_OU_TYPE

Line 106: igs_pr_ou_type ou

102: --
103: CURSOR cur_hold_effect_type IS
104: SELECT s_encmb_effect_type, s_progression_outcome_type
105: FROM igs_fi_enc_dflt_eft dft,
106: igs_pr_ou_type ou
107: WHERE dft.encumbrance_type = ou.encumbrance_type
108: AND ou.progression_outcome_type = p_lgcy_prout_rec.progression_outcome_type;
109: --
110: l_return_status VARCHAR2(10);

Line 114: l_s_progression_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;

110: l_return_status VARCHAR2(10);
111: l_start_dt DATE;
112: l_end_dt DATE;
113: l_hold_effect_type VARCHAR2(10);
114: l_s_progression_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;
115: --
116: BEGIN
117: --
118: -- Initialise the return value

Line 288: IF (NOT igs_pr_ou_type_pkg.get_pk_for_validation (

284: -- x_return_value to FALSE when the Progression Outcome Type is not
285: -- already defined in the system.
286: --
287: IF (p_lgcy_prout_rec.progression_outcome_type IS NOT NULL) THEN
288: IF (NOT igs_pr_ou_type_pkg.get_pk_for_validation (
289: p_lgcy_prout_rec.progression_outcome_type
290: )) THEN
291: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_OU_TYPE_FK');
292: FND_MSG_PUB.ADD;

Line 291: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_OU_TYPE_FK');

287: IF (p_lgcy_prout_rec.progression_outcome_type IS NOT NULL) THEN
288: IF (NOT igs_pr_ou_type_pkg.get_pk_for_validation (
289: p_lgcy_prout_rec.progression_outcome_type
290: )) THEN
291: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_OU_TYPE_FK');
292: FND_MSG_PUB.ADD;
293: x_return_value := FALSE;
294: END IF;
295: END IF;

Line 445: FROM igs_pr_ou_type pot

441: AND course_attempt_status = 'UNCONFIRM';
442: --
443: CURSOR cur_pot IS
444: SELECT s_progression_outcome_type
445: FROM igs_pr_ou_type pot
446: WHERE pot.progression_outcome_type = p_lgcy_prout_rec.progression_outcome_type;
447: --
448: rec_sca cur_sca%ROWTYPE;
449: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);

Line 451: v_s_progression_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;

447: --
448: rec_sca cur_sca%ROWTYPE;
449: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
450: x_message_name fnd_new_messages.message_name%TYPE;
451: v_s_progression_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;
452: l_where_clause VARCHAR2(2000);
453: TYPE ref_cur IS REF CURSOR;
454: l_ref_cur ref_cur;
455: l_record_found VARCHAR2(1) := 'N';

Line 1306: FROM igs_pr_ou_type

1302: WHERE award_cd = p_lgcy_prout_rec.award_cd;
1303: --
1304: CURSOR cur_positive_otcm IS
1305: SELECT positive_outcome_ind
1306: FROM igs_pr_ou_type
1307: WHERE progression_outcome_type = p_lgcy_prout_rec.progression_outcome_type;
1308: --
1309: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
1310: rec_award cur_award%ROWTYPE;