APPS.IGS_AD_TST_RSLT_DTLS_PKG dependencies on IGS_AD_TEST_RESULTS

Line 291: ELSIF NOT Igs_Ad_Test_Results_Pkg.Get_PK_For_Validation (

287:
288: IF (((old_references.test_results_id = new_references.test_results_id)) OR
289: ((new_references.test_results_id IS NULL))) THEN
290: NULL;
291: ELSIF NOT Igs_Ad_Test_Results_Pkg.Get_PK_For_Validation (
292: new_references.test_results_id
293: ) THEN
294: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
295: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TEST_RESULT'));

Line 426: PROCEDURE Get_FK_Igs_Ad_Test_Results (

422: Close cur_rowid;
423:
424: END Get_FK_Igs_Ad_Code_Classes;
425:
426: PROCEDURE Get_FK_Igs_Ad_Test_Results (
427: x_test_results_id IN NUMBER
428: ) AS
429:
430: /*************************************************************

Line 461: END Get_FK_Igs_Ad_Test_Results;

457: Return;
458: END IF;
459: Close cur_rowid;
460:
461: END Get_FK_Igs_Ad_Test_Results;
462:
463: PROCEDURE Get_FK_Igs_Ad_Test_Segments (
464: x_test_segment_id IN NUMBER
465: ) AS

Line 529: FROM IGS_AD_TEST_RESULTS A

525: l_test_result_id NUMBER(15);
526:
527: CURSOR c_get_test_score_record(cp_test_results_id IN NUMBER) IS
528: SELECT rowid,A.*
529: FROM IGS_AD_TEST_RESULTS A
530: WHERE test_results_id = cp_test_results_id
531: FOR UPDATE NOWAIT;
532:
533: l_test_result c_get_test_score_record%ROWTYPE;

Line 547: Igs_Ad_Test_Results_Pkg.Update_Row (

543: OPEN c_get_test_score_record(p_test_results_id);
544: FETCH c_get_test_score_record INTO l_test_result;
545: CLOSE c_get_test_score_record;
546:
547: Igs_Ad_Test_Results_Pkg.Update_Row (
548: X_Mode => 'R',
549: X_RowId => l_test_result.ROWID,
550: X_Test_Results_Id => l_test_result.Test_Results_Id,
551: X_Person_Id => l_test_result.Person_Id,

Line 622: FROM igs_ad_test_results

618:
619:
620: CURSOR c_admission_test_type IS
621: SELECT admission_test_type
622: FROM igs_ad_test_results
623: WHERE test_results_id = new_references.test_results_id;
624:
625: CURSOR c_val_test_seg_cur (cp_admission_test_type igs_ad_test_results.admission_test_type%TYPE)IS
626: SELECT 'x'

Line 625: CURSOR c_val_test_seg_cur (cp_admission_test_type igs_ad_test_results.admission_test_type%TYPE)IS

621: SELECT admission_test_type
622: FROM igs_ad_test_results
623: WHERE test_results_id = new_references.test_results_id;
624:
625: CURSOR c_val_test_seg_cur (cp_admission_test_type igs_ad_test_results.admission_test_type%TYPE)IS
626: SELECT 'x'
627: FROM
628: igs_ad_test_segments
629: WHERE

Line 648: l_admission_test_type igs_ad_test_results.admission_test_type%TYPE;

644: TEST_SEGMENT_ID = new_references.test_segment_id ;
645:
646: c_test_ind_rec c_test_ind_cur%ROWTYPE;
647: c_val_test_seg_rec c_val_test_seg_cur%ROWTYPE;
648: l_admission_test_type igs_ad_test_results.admission_test_type%TYPE;
649:
650: BEGIN
651:
652: l_admission_test_type := NULL;

Line 1002: FROM IGS_AD_TEST_RESULTS

998: (reverse chronological order - newest change first)
999: ***************************************************************/
1000: CURSOR c_person_id IS
1001: SELECT person_id
1002: FROM IGS_AD_TEST_RESULTS
1003: WHERE TEST_RESULTS_ID = new_references.test_results_id;
1004:
1005: CURSOR test_comb_score_cur(cp_test_segment_id igs_ad_test_segments.test_segment_id%TYPE) IS
1006: SELECT include_in_comp_score