APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_AD_PNMEMBR_DTLS

Line 1052: CURSOR c_intvw_pnmem_dtls (cp_panel_dtls_id igs_ad_pnmembr_dtls.panel_dtls_id%TYPE) IS

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;
1051:
1052: CURSOR c_intvw_pnmem_dtls (cp_panel_dtls_id igs_ad_pnmembr_dtls.panel_dtls_id%TYPE) IS
1053: SELECT pnmdt.*
1054: FROM igs_ad_pnmembr_dtls pnmdt
1055: WHERE panel_dtls_id = cp_panel_dtls_id;
1056:

Line 1054: FROM igs_ad_pnmembr_dtls pnmdt

1050: AND sequence_number = cp_sequence_number;
1051:
1052: CURSOR c_intvw_pnmem_dtls (cp_panel_dtls_id igs_ad_pnmembr_dtls.panel_dtls_id%TYPE) IS
1053: SELECT pnmdt.*
1054: FROM igs_ad_pnmembr_dtls pnmdt
1055: WHERE panel_dtls_id = cp_panel_dtls_id;
1056:
1057:
1058: ---End cursor Declarations-----------------------------------------------------------------------------

Line 1327: igs_ad_pnmembr_dtls_pkg.insert_row(

1323:
1324: FOR l_intvw_pnmem_dtls_rec IN c_intvw_pnmem_dtls(l_intvw_dtls_rec.panel_dtls_id) LOOP
1325: l_last_error := 'IGS_AD_PNL_MEM_DTLS';
1326:
1327: igs_ad_pnmembr_dtls_pkg.insert_row(
1328: x_rowid => l_rowid,
1329: x_panel_dtls_id => l_intvw_pnmem_dtls_rec.panel_dtls_id,
1330: x_role_type_code => l_intvw_pnmem_dtls_rec.role_type_code,
1331: x_member_person_id => l_intvw_pnmem_dtls_rec.member_person_id,