APPS.IGS_AD_TST_RSLT_DTLS_PKG dependencies on IGS_AD_TEST_SEGMENTS

Line 303: ELSIF NOT Igs_Ad_Test_Segments_Pkg.Get_PK_For_Validation (

299:
300: IF (((old_references.test_segment_id = new_references.test_segment_id)) OR
301: ((new_references.test_segment_id IS NULL))) THEN
302: NULL;
303: ELSIF NOT Igs_Ad_Test_Segments_Pkg.Get_PK_For_Validation (
304: new_references.test_segment_id,
305: 'N'
306: ) THEN
307: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

Line 463: PROCEDURE Get_FK_Igs_Ad_Test_Segments (

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
466:
467: /*************************************************************

Line 498: END Get_FK_Igs_Ad_Test_Segments;

494: Return;
495: END IF;
496: Close cur_rowid;
497:
498: END Get_FK_Igs_Ad_Test_Segments;
499:
500: PROCEDURE Check_Child_Existance AS
501: BEGIN
502: -- Next part of code has been added as per bug# 2401170

Line 519: IGS_AD_TEST_SEGMENTS B

515:
516: CURSOR c_calc_comp_score(cp_test_results_id IN NUMBER) IS
517: SELECT SUM(test_score)
518: FROM IGS_AD_TST_RSLT_DTLS A,
519: IGS_AD_TEST_SEGMENTS B
520: WHERE A.TEST_results_ID = cp_test_results_id
521: AND A.TEST_SEGMENT_ID = B.test_segment_id
522: AND B.INCLUDE_IN_COMP_SCORE = 'Y';
523:

Line 603: CURSOR c_test_ind_cur(cp_test_segment_id igs_ad_test_segments.test_segment_id%TYPE) IS

599: p_entity1 OUT NOCOPY VARCHAR2,
600: p_entity2 OUT NOCOPY VARCHAR2,
601: p_entity3 OUT NOCOPY VARCHAR2)
602: IS
603: CURSOR c_test_ind_cur(cp_test_segment_id igs_ad_test_segments.test_segment_id%TYPE) IS
604: SELECT
605: include_in_comp_score,
606: score_ind,
607: percentile_ind,

Line 615: IGS_AD_TEST_SEGMENTS

611: state_percentile_ind,
612: score_band_upper_ind,
613: score_band_lower_ind
614: FROM
615: IGS_AD_TEST_SEGMENTS
616: WHERE
617: test_segment_id = cp_test_segment_id ;
618:
619:

Line 628: igs_ad_test_segments

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
630: test_segment_id = new_references.test_segment_id
631: AND ADMISSION_TEST_TYPE = cp_admission_test_type
632: AND closed_ind = 'N';

Line 642: igs_ad_test_segments

638: min_score,
639: max_score,
640: description
641: FROM
642: igs_ad_test_segments
643: WHERE
644: TEST_SEGMENT_ID = new_references.test_segment_id ;
645:
646: c_test_ind_rec c_test_ind_cur%ROWTYPE;

Line 1005: CURSOR test_comb_score_cur(cp_test_segment_id igs_ad_test_segments.test_segment_id%TYPE) 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
1007: FROM igs_ad_test_segments
1008: WHERE test_segment_id = cp_test_segment_id;
1009:

Line 1007: FROM igs_ad_test_segments

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
1007: FROM igs_ad_test_segments
1008: WHERE test_segment_id = cp_test_segment_id;
1009:
1010: test_comb_score_rec test_comb_score_cur%ROWTYPE;
1011: