APPS.IGS_AD_PANEL_DTLS_PKG dependencies on IGS_AD_INTVW_PNLS

Line 181: ELSIF NOT igs_ad_intvw_pnls_pkg.get_pk_for_validation (

177:
178: IF (((old_references.panel_code = new_references.panel_code)) OR
179: ((new_references.panel_code IS NULL))) THEN
180: NULL;
181: ELSIF NOT igs_ad_intvw_pnls_pkg.get_pk_for_validation (
182: new_references.panel_code
183: ) THEN
184: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
185: igs_ge_msg_stack.add;

Line 368: PROCEDURE get_fk_igs_ad_intvw_pnls (

364:
365: END get_uk_for_validation ;
366:
367:
368: PROCEDURE get_fk_igs_ad_intvw_pnls (
369: x_panel_code IN VARCHAR2
370: ) AS
371: /*
372: || Created By : Navin Sinha

Line 400: END get_fk_igs_ad_intvw_pnls;

396: RETURN;
397: END IF;
398: CLOSE cur_rowid;
399:
400: END get_fk_igs_ad_intvw_pnls;
401:
402:
403: PROCEDURE get_fk_igs_ad_location (
404: x_location_cd IN VARCHAR2

Line 542: FROM igs_ad_intvw_pnls

538: FOR UPDATE OF panel_dtls_id NOWAIT;
539:
540: CURSOR c_panel_type_code IS
541: SELECT panel_type_Code
542: FROM igs_ad_intvw_pnls
543: WHERE panel_code = NVL(new_references.panel_code,old_references.panel_code)
544: AND closed_flag = 'N';
545:
546: CURSOR c_apcs_step_exist IS

Line 582: FROM igs_ad_intvw_pnls

578:
579: -- Cursor to check for panel level.
580: CURSOR c_panel_level_code IS
581: SELECT panel_level_code
582: FROM igs_ad_intvw_pnls
583: WHERE panel_code = new_references.panel_code;
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;

Line 584: l_panel_level_code igs_ad_intvw_pnls.panel_level_code%TYPE;

580: CURSOR c_panel_level_code IS
581: SELECT panel_level_code
582: FROM igs_ad_intvw_pnls
583: WHERE panel_code = new_references.panel_code;
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;

Line 586: l_panel_type_Code igs_ad_intvw_pnls.panel_type_Code%TYPE;

582: FROM igs_ad_intvw_pnls
583: WHERE panel_code = new_references.panel_code;
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.

Line 632: FROM igs_ad_intvw_pnls pnls, igs_ad_panel_dtls pdtls

628: l_final_decison_rec c_final_decison%ROWTYPE;
629:
630: CURSOR c_intvw_pnl_exsts IS
631: SELECT 'X'
632: FROM igs_ad_intvw_pnls pnls, igs_ad_panel_dtls pdtls
633: WHERE pnls.panel_type_code='INTERVIEW'
634: AND pnls.panel_code = pdtls.panel_code
635: AND pdtls.person_id = NVL(old_references.person_id, new_references.person_id)
636: AND pdtls.admission_appl_number = NVL(old_references.admission_appl_number, new_references.admission_appl_number)

Line 924: FROM igs_ad_intvw_pnls

920:
921: -- Cursor to get the panel type of the panel code.
922: CURSOR cur_panel_type_code IS
923: SELECT panel_type_code
924: FROM igs_ad_intvw_pnls
925: WHERE panel_code = new_references.panel_code;
926:
927: l_panel_type_code igs_ad_intvw_pnls.panel_type_code%TYPE;
928:

Line 927: l_panel_type_code igs_ad_intvw_pnls.panel_type_code%TYPE;

923: SELECT panel_type_code
924: FROM igs_ad_intvw_pnls
925: WHERE panel_code = new_references.panel_code;
926:
927: l_panel_type_code igs_ad_intvw_pnls.panel_type_code%TYPE;
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 *

Line 930: CURSOR cur_dflt_panl_cd(cp_panel_type_code igs_ad_intvw_pnls.panel_type_code%TYPE) IS

926:
927: l_panel_type_code igs_ad_intvw_pnls.panel_type_code%TYPE;
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'

Line 963: FROM igs_ad_intvw_pnls

959: l_history_date igs_ad_pnl_his_dtls.history_date%TYPE;
960:
961: CURSOR c_panel_type IS
962: SELECT panel_type_code
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;

Line 965: l_panel_type igs_ad_intvw_pnls.panel_type_code%TYPE;

961: CURSOR c_panel_type IS
962: SELECT panel_type_code
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: