APPS.IGS_AD_PANEL_DTLS_PKG dependencies on IGS_AD_CODE_CLASSES

Line 254: ELSIF NOT igs_ad_code_classes_pkg.get_uk_For_validation (

250: (old_references.final_decision_type = new_references.final_decision_type)) OR
251: ((new_references.final_decision_code IS NULL) OR
252: (new_references.final_decision_type IS NULL))) THEN
253: NULL;
254: ELSIF NOT igs_ad_code_classes_pkg.get_uk_For_validation (
255: new_references.final_decision_code,
256: new_references.final_decision_type,
257: 'N'
258: ) THEN

Line 473: PROCEDURE get_ufk_igs_ad_code_classes (

469:
470: END get_fk_igs_ad_room;
471:
472:
473: PROCEDURE get_ufk_igs_ad_code_classes (
474: x_name IN VARCHAR2,
475: x_class IN VARCHAR2
476: ) AS
477: /*

Line 507: END get_ufk_igs_ad_code_classes;

503: RETURN;
504: END IF;
505: CLOSE cur_rowid;
506:
507: END get_ufk_igs_ad_code_classes;
508:
509: PROCEDURE beforerowinsertupdatedelete1 (
510: p_inserting BOOLEAN,
511: p_updating BOOLEAN,

Line 558: CURSOR cur_dflt_panl_cd(cp_dec_type igs_ad_code_classes.class%TYPE) IS

554: AND apcs.s_admission_step_type = 'SCRN_BEF_INTERVIEW' AND
555: apcs.step_group_type = 'APPL-VAL';
556:
557: -- Cursor to get the system defaulted Decisions mapped to 'PENDING'
558: CURSOR cur_dflt_panl_cd(cp_dec_type igs_ad_code_classes.class%TYPE) IS
559: SELECT *
560: FROM igs_ad_code_classes
561: WHERE system_status = 'PENDING'
562: AND class = cp_dec_type --'INTERVIEW', 'SCREENING', 'FINAL_SCREENING', 'FINAL_INTERVIEW'

Line 560: FROM igs_ad_code_classes

556:
557: -- Cursor to get the system defaulted Decisions mapped to 'PENDING'
558: CURSOR cur_dflt_panl_cd(cp_dec_type igs_ad_code_classes.class%TYPE) IS
559: SELECT *
560: FROM igs_ad_code_classes
561: WHERE system_status = 'PENDING'
562: AND class = cp_dec_type --'INTERVIEW', 'SCREENING', 'FINAL_SCREENING', 'FINAL_INTERVIEW'
563: AND NVL(system_default, 'N') = 'Y'
564: AND closed_ind = 'N'

Line 588: l_dec_type igs_ad_code_classes.class%TYPE;

584: l_panel_level_code igs_ad_intvw_pnls.panel_level_code%TYPE;
585:
586: l_panel_type_Code igs_ad_intvw_pnls.panel_type_Code%TYPE;
587: l_apcs_step_exist c_apcs_step_exist%ROWTYPE;
588: l_dec_type igs_ad_code_classes.class%TYPE;
589:
590: -- Cursor to Check closed flag associated to panel code.
591: CURSOR c_chk_final_decision IS
592: SELECT *

Line 602: igs_Ad_code_classes cdcls

598: CURSOR c_final_decison IS
599: SELECT 'X'
600: FROM
601: igs_ad_panel_dtls pdtls,
602: igs_Ad_code_classes cdcls
603: WHERE person_id = new_references.person_id
604: AND admission_appl_number = new_references.admission_Appl_number
605: AND nominated_course_cd = new_references.nominated_course_Cd
606: AND sequence_number = new_references.sequence_number

Line 617: igs_Ad_code_Classes cdcls

613: CURSOR c_mem_dec IS
614: SELECT 'X'
615: FROM
616: igs_ad_pnmembr_dtls pdtls,
617: igs_Ad_code_Classes cdcls
618: WHERE
619: pdtls.panel_Dtls_id = new_references.panel_Dtls_id
620: AND pdtls.member_decision_code = cdcls.name
621: AND pdtls.member_decision_type = cdcls.class

Line 655: FROM igs_ad_code_classes

651:
652: -- Cursor to check if member Decisions is mapped to the system defaulted Decisions of 'PENDING'
653: CURSOR cur_chk_dflt_panl_cd IS
654: SELECT *
655: FROM igs_ad_code_classes
656: WHERE system_status = 'PENDING'
657: AND name = new_references.final_decision_code
658: AND class = new_references.final_decision_type
659: AND closed_ind = 'N'

Line 932: FROM igs_ad_code_classes

928:
929: -- Cursor to get the system defaulted Decisions mapped to 'PENDING'
930: CURSOR cur_dflt_panl_cd(cp_panel_type_code igs_ad_intvw_pnls.panel_type_code%TYPE) IS
931: SELECT *
932: FROM igs_ad_code_classes
933: WHERE system_status = 'PENDING'
934: AND class = cp_panel_type_code --'INTERVIEW', 'SCREENING', 'FINAL_SCREENING', 'FINAL_INTERVIEW'
935: AND NVL(system_default, 'N') = 'Y'
936: AND closed_ind = 'N'

Line 967: l_new_sys_stat igs_ad_code_classes.system_status%TYPE;

963: FROM igs_ad_intvw_pnls
964: WHERE panel_code = new_references.panel_code;
965: l_panel_type igs_ad_intvw_pnls.panel_type_code%TYPE;
966:
967: l_new_sys_stat igs_ad_code_classes.system_status%TYPE;
968: l_old_sys_stat igs_ad_code_classes.system_status%TYPE;
969:
970: BEGIN
971: IF NVL(p_inserting,FALSE) THEN

Line 968: l_old_sys_stat igs_ad_code_classes.system_status%TYPE;

964: WHERE panel_code = new_references.panel_code;
965: l_panel_type igs_ad_intvw_pnls.panel_type_code%TYPE;
966:
967: l_new_sys_stat igs_ad_code_classes.system_status%TYPE;
968: l_old_sys_stat igs_ad_code_classes.system_status%TYPE;
969:
970: BEGIN
971: IF NVL(p_inserting,FALSE) THEN
972: -- Get the panel type of the panel code.