APPS.IGS_AD_TEST_RESULTS_PKG dependencies on IGS_AD_TEST_TYPE

Line 71: FROM igs_ad_test_type

67: WHERE rowid = x_rowid;
68:
69: CURSOR score_type_cur(cp_admission_test_type VARCHAR2) IS
70: SELECT score_type
71: FROM igs_ad_test_type
72: WHERE admission_test_type = cp_admission_test_type;
73:
74: l_score_type igs_ad_test_type.score_type%TYPE;
75: BEGIN

Line 74: l_score_type igs_ad_test_type.score_type%TYPE;

70: SELECT score_type
71: FROM igs_ad_test_type
72: WHERE admission_test_type = cp_admission_test_type;
73:
74: l_score_type igs_ad_test_type.score_type%TYPE;
75: BEGIN
76:
77: l_rowid := x_rowid;
78:

Line 238: ELSIF NOT Igs_Ad_Test_Type_Pkg.Get_PK_For_Validation (

234:
235: IF (((old_references.admission_test_type = new_references.admission_test_type)) OR
236: ((new_references.admission_test_type IS NULL))) THEN
237: NULL;
238: ELSIF NOT Igs_Ad_Test_Type_Pkg.Get_PK_For_Validation (
239: new_references.admission_test_type,
240: 'N'
241: ) THEN
242: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

Line 529: PROCEDURE Get_FK_Igs_Ad_Test_Type (

525: END IF;
526: Close cur_rowid3;
527: END Get_FK_Igs_Ad_Code_Classes;
528:
529: PROCEDURE Get_FK_Igs_Ad_Test_Type (
530: x_admission_test_type IN VARCHAR2
531: ) AS
532:
533: /*************************************************************

Line 564: END Get_FK_Igs_Ad_Test_Type;

560: Return;
561: END IF;
562: Close cur_rowid;
563:
564: END Get_FK_Igs_Ad_Test_Type;
565:
566:
567: PROCEDURE Get_FK_Igs_Pe_Person (
568: x_person_id IN NUMBER