APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_AD_PANEL_DTLS

Line 1046: FROM igs_ad_panel_dtls pndt

1042: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1043: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nomINATED_COURSE_CD%TYPE,
1044: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
1045: SELECT pndt.*
1046: FROM igs_ad_panel_dtls pndt
1047: WHERE person_id = cp_person_id
1048: AND admission_appl_number = cp_admission_appl_number
1049: AND nominated_course_cd = cp_nominated_course_cd
1050: AND sequence_number = cp_sequence_number;

Line 1064: l_panel_dtls_id igs_ad_panel_dtls.panel_dtls_id%TYPE;

1060: ---- Variable declarations-----------------------------------------------------------------------------
1061: l_primary_key NUMBER(15);
1062: l_rowid VARCHAR2(30);
1063: l_last_error VARCHAR2(100);
1064: l_panel_dtls_id igs_ad_panel_dtls.panel_dtls_id%TYPE;
1065:
1066: ------End variable declarations------------------------------------------------------------------------
1067:
1068: BEGIN

Line 1283: igs_ad_panel_dtls_pkg.insert_row(

1279:
1280: FOR l_intvw_dtls_rec IN c_intvw_dtls(p_person_id, p_old_admission_appl_number, p_nominated_course_cd, p_old_sequence_number) LOOP
1281: l_last_error := 'IGS_AD_INTV_PNL_DTLS';
1282:
1283: igs_ad_panel_dtls_pkg.insert_row(
1284: x_rowid => l_rowid,
1285: x_panel_dtls_id => l_panel_dtls_id,
1286: x_person_id => l_intvw_dtls_rec.person_id,
1287: x_admission_appl_number => l_intvw_dtls_rec.admission_appl_number,