APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_RE_THS_PNL_MBR

Line 105: CURSOR c_get_thesis_panel_memb (cp_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,

101: WHERE person_id = cp_person_id
102: AND ca_sequence_number = cp_ca_sequence_number
103: AND the_sequence_number = cp_the_sequence_number;
104:
105: CURSOR c_get_thesis_panel_memb (cp_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
106: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
107: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
108: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
109: SELECT *

Line 106: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,

102: AND ca_sequence_number = cp_ca_sequence_number
103: AND the_sequence_number = cp_the_sequence_number;
104:
105: CURSOR c_get_thesis_panel_memb (cp_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
106: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
107: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
108: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
109: SELECT *
110: FROM igs_re_ths_pnl_mbr

Line 107: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,

103: AND the_sequence_number = cp_the_sequence_number;
104:
105: CURSOR c_get_thesis_panel_memb (cp_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
106: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
107: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
108: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
109: SELECT *
110: FROM igs_re_ths_pnl_mbr
111: WHERE ca_person_id = cp_ca_person_id

Line 108: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS

104:
105: CURSOR c_get_thesis_panel_memb (cp_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
106: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
107: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
108: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
109: SELECT *
110: FROM igs_re_ths_pnl_mbr
111: WHERE ca_person_id = cp_ca_person_id
112: AND ca_sequence_number = cp_ca_sequence_number

Line 110: FROM igs_re_ths_pnl_mbr

106: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
107: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
108: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
109: SELECT *
110: FROM igs_re_ths_pnl_mbr
111: WHERE ca_person_id = cp_ca_person_id
112: AND ca_sequence_number = cp_ca_sequence_number
113: AND the_sequence_number = cp_the_sequence_number
114: AND creation_dt = cp_creation_dt;

Line 260: IGS_RE_THS_PNL_MBR_PKG.INSERT_ROW(

256: v_message_name:= 'IGS_AD_RSCH_EXAM_PNL_MEM';
257:
258: l_rowid_child3 := NULL;
259:
260: IGS_RE_THS_PNL_MBR_PKG.INSERT_ROW(
261: X_ROWID => l_rowid_child3,
262: X_CA_PERSON_ID => p_person_id,
263: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
264: X_THE_SEQUENCE_NUMBER => l_get_thesis_sequence,