APPS.IGS_PR_STDNT_PR_OU_PKG dependencies on IGS_PR_OU_TYPE

Line 183: IF NOT IGS_PR_OU_TYPE_PKG.Get_PK_For_Validation (

179: new_references.progression_outcome_type)) OR
180: ((new_references.progression_outcome_type IS NULL))) THEN
181: NULL;
182: ELSE
183: IF NOT IGS_PR_OU_TYPE_PKG.Get_PK_For_Validation (
184: new_references.progression_outcome_type
185: )THEN
186: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
187: IGS_GE_MSG_STACK.ADD;

Line 374: PROCEDURE GET_FK_IGS_PR_OU_TYPE (

370: Close cur_rowid;
371:
372: END GET_FK_IGS_OR_UNIT;
373:
374: PROCEDURE GET_FK_IGS_PR_OU_TYPE (
375: x_progression_outcome_type IN VARCHAR2
376: ) AS
377:
378: CURSOR cur_rowid IS

Line 398: END GET_FK_IGS_PR_OU_TYPE;

394: Return;
395: END IF;
396: Close cur_rowid;
397:
398: END GET_FK_IGS_PR_OU_TYPE;
399:
400: PROCEDURE GET_FK_IGS_PR_RU_OU (
401: x_progression_rule_cat IN VARCHAR2,
402: x_pra_sequence_number IN NUMBER,

Line 564: FROM igs_pr_ou_type

560: ) AS
561:
562: CURSOR c_sysout_type IS
563: SELECT s_progression_outcome_type
564: FROM igs_pr_ou_type
565: WHERE progression_outcome_type = x_progression_outcome_type;
566: lvSystem_Outcome_Type IGS_PR_ou_type.S_PROGRESSION_OUTCOME_TYPE%TYPE;
567:
568: BEGIN

Line 566: lvSystem_Outcome_Type IGS_PR_ou_type.S_PROGRESSION_OUTCOME_TYPE%TYPE;

562: CURSOR c_sysout_type IS
563: SELECT s_progression_outcome_type
564: FROM igs_pr_ou_type
565: WHERE progression_outcome_type = x_progression_outcome_type;
566: lvSystem_Outcome_Type IGS_PR_ou_type.S_PROGRESSION_OUTCOME_TYPE%TYPE;
567:
568: BEGIN
569:
570: Set_Column_Values (

Line 1625: FROM igs_pr_ou_type pot

1621: -- cancelling it, waiving the approved outcomes
1622: -- and the outcome with showcause and appeal dates
1623: CURSOR cur_positive IS
1624: SELECT positive_outcome_ind, description
1625: FROM igs_pr_ou_type pot
1626: WHERE pot.progression_outcome_type =
1627: new_references.progression_outcome_type;
1628: lcur_positive cur_positive%ROWTYPE;
1629: BEGIN