APPS.IGS_AD_PNMEMBR_DTLS_PKG dependencies on IGS_AD_CODE_CLASSES

Line 157: ELSIF NOT igs_ad_code_classes_pkg.get_uk_For_validation (

153: (old_references.member_decision_type = new_references.member_decision_type)) OR
154: ((new_references.member_decision_code IS NULL) OR
155: (new_references.member_decision_type IS NULL))) THEN
156: NULL;
157: ELSIF NOT igs_ad_code_classes_pkg.get_uk_For_validation (
158: new_references.member_decision_code,
159: new_references.member_decision_type ,
160: 'N'
161: ) THEN

Line 299: PROCEDURE get_ufk_igs_ad_code_classes (

295:
296: END get_fk_igs_ad_panel_dtls;
297:
298:
299: PROCEDURE get_ufk_igs_ad_code_classes (
300: x_name IN VARCHAR2,
301: x_class IN VARCHAR2
302: ) AS
303: /*

Line 333: END get_ufk_igs_ad_code_classes;

329: RETURN;
330: END IF;
331: CLOSE cur_rowid;
332:
333: END get_ufk_igs_ad_code_classes;
334:
335:
336: PROCEDURE get_fk_igs_ad_location (
337: x_location_cd IN VARCHAR2

Line 452: l_final_decision igs_ad_code_classes.system_status%TYPE;

448: FROM igs_ad_panel_dtls
449: WHERE panel_dtls_id = cp_panel_dtls_id;
450:
451: rec_chk_final_decision c_chk_final_decision%ROWTYPE;
452: l_final_decision igs_ad_code_classes.system_status%TYPE;
453:
454: l_member_decision igs_ad_code_classes.system_status%TYPE;
455: l_old_member_decision igs_ad_code_classes.system_status%TYPE;
456:

Line 454: l_member_decision igs_ad_code_classes.system_status%TYPE;

450:
451: rec_chk_final_decision c_chk_final_decision%ROWTYPE;
452: l_final_decision igs_ad_code_classes.system_status%TYPE;
453:
454: l_member_decision igs_ad_code_classes.system_status%TYPE;
455: l_old_member_decision igs_ad_code_classes.system_status%TYPE;
456:
457: -- Cursor to check if member Decisions is mapped to the system defaulted Decisions of 'PENDING'
458: CURSOR cur_dflt_panl_cd IS

Line 455: l_old_member_decision igs_ad_code_classes.system_status%TYPE;

451: rec_chk_final_decision c_chk_final_decision%ROWTYPE;
452: l_final_decision igs_ad_code_classes.system_status%TYPE;
453:
454: l_member_decision igs_ad_code_classes.system_status%TYPE;
455: l_old_member_decision igs_ad_code_classes.system_status%TYPE;
456:
457: -- Cursor to check if member Decisions is mapped to the system defaulted Decisions of 'PENDING'
458: CURSOR cur_dflt_panl_cd IS
459: SELECT *

Line 460: FROM igs_ad_code_classes

456:
457: -- Cursor to check if member Decisions is mapped to the system defaulted Decisions of 'PENDING'
458: CURSOR cur_dflt_panl_cd IS
459: SELECT *
460: FROM igs_ad_code_classes
461: WHERE system_status = 'PENDING'
462: AND name = new_references.member_decision_code
463: AND class = new_references.member_decision_type
464: AND closed_ind = 'N'

Line 494: FROM igs_ad_code_classes

490:
491: -- Cursor to get the system defaulted Decisions mapped to 'PENDING'
492: CURSOR cur_dflt_panlm_cd(cp_panel_type_code igs_ad_intvw_pnls.panel_type_code%TYPE) IS
493: SELECT *
494: FROM igs_ad_code_classes
495: WHERE system_status = 'PENDING'
496: AND class = cp_panel_type_code --'INTERVIEW', 'SCREENING', 'FINAL_SCREENING', 'FINAL_INTERVIEW'
497: AND NVL(system_default, 'N') = 'Y'
498: AND closed_ind = 'N'

Line 522: l_dec_type igs_ad_code_classes.class%TYPE;

518: AND lookup_code = cp_lookup_code;
519:
520: l_class_meaning igs_lookups_view.meaning%TYPE;
521: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;
522: l_dec_type igs_ad_code_classes.class%TYPE;
523:
524: BEGIN
525: IF NVL(p_inserting,FALSE) THEN
526: -- A Person added to a panel must have the system person type of Interviewer. Else raise an error message.