APPS.IGS_AD_PNMEMBR_DTLS_PKG dependencies on IGS_AD_PANEL_DTLS

Line 144: ELSIF NOT igs_ad_panel_dtls_pkg.get_pk_for_validation (

140:
141: IF (((old_references.panel_dtls_id = new_references.panel_dtls_id)) OR
142: ((new_references.panel_dtls_id IS NULL))) THEN
143: NULL;
144: ELSIF NOT igs_ad_panel_dtls_pkg.get_pk_for_validation (
145: new_references.panel_dtls_id
146: ) THEN
147: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
148: igs_ge_msg_stack.add;

Line 264: PROCEDURE get_fk_igs_ad_panel_dtls (

260:
261: END get_pk_for_validation;
262:
263:
264: PROCEDURE get_fk_igs_ad_panel_dtls (
265: x_panel_dtls_id IN NUMBER
266: ) AS
267: /*
268: || Created By : Navin Sinha

Line 296: END get_fk_igs_ad_panel_dtls;

292: RETURN;
293: END IF;
294: CLOSE cur_rowid;
295:
296: END get_fk_igs_ad_panel_dtls;
297:
298:
299: PROCEDURE get_ufk_igs_ad_code_classes (
300: x_name IN VARCHAR2,

Line 437: FROM igs_ad_panel_dtls pd,

433:
434: -- Cursor to check the application date of the application
435: CURSOR c_appl_dt IS
436: SELECT appl_dt
437: FROM igs_ad_panel_dtls pd,
438: igs_ad_appl aa
439: WHERE pd.panel_dtls_id = new_references.panel_dtls_id
440: AND pd.admission_appl_number = aa.admission_appl_number
441: AND pd.person_id = aa.person_id;

Line 446: CURSOR c_chk_final_decision (cp_panel_dtls_id igs_ad_panel_dtls.panel_dtls_id%TYPE) IS

442:
443: l_appl_dt igs_ad_appl.appl_dt%TYPE;
444:
445: -- Cursor to check final decision associated to panel code.
446: CURSOR c_chk_final_decision (cp_panel_dtls_id igs_ad_panel_dtls.panel_dtls_id%TYPE) IS
447: SELECT *
448: FROM igs_ad_panel_dtls
449: WHERE panel_dtls_id = cp_panel_dtls_id;
450:

Line 448: FROM igs_ad_panel_dtls

444:
445: -- Cursor to check final decision associated to panel code.
446: CURSOR c_chk_final_decision (cp_panel_dtls_id igs_ad_panel_dtls.panel_dtls_id%TYPE) IS
447: SELECT *
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;

Line 471: FROM igs_ad_panel_dtls pdtls,

467: rec_dflt_panl_cd cur_dflt_panl_cd%ROWTYPE;
468:
469: CURSOR c_instance_dets IS
470: SELECT person_id,admission_appl_number,nominated_course_Cd,sequence_number
471: FROM igs_ad_panel_dtls pdtls,
472: igs_Ad_pnmembr_Dtls pmbr
473: WHERE pdtls.panel_Dtls_id = pmbr.panel_dtls_id
474: AND pmbr.panel_dtls_id = NVL(old_references.panel_dtls_id, new_references.panel_dtls_id);
475:

Line 481: igs_ad_panel_dtls pdtls

477:
478: CURSOR c_intvw_pnl_exsts (cp_instance_rec c_instance_dets%ROWTYPE ) IS
479: SELECT 'X'
480: FROM igs_ad_intvw_pnls pnls,
481: igs_ad_panel_dtls pdtls
482: WHERE pnls.panel_type_code='INTERVIEW'
483: AND pnls.panel_code = pdtls.panel_code
484: AND pdtls.person_id = cp_instance_rec.person_id
485: AND pdtls.admission_appl_number = cp_instance_rec.admission_appl_number

Line 507: igs_ad_panel_dtls pd

503: --get the panel type code
504: CURSOR c_panel_type_code IS
505: SELECT ip.panel_type_Code
506: FROM igs_ad_intvw_pnls ip,
507: igs_ad_panel_dtls pd
508: WHERE ip.panel_code = pd.panel_code
509: AND pd.panel_dtls_id = new_references.panel_dtls_id;
510:
511: l_panel_type_Code igs_ad_intvw_pnls.panel_type_Code%TYPE;