APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_RE_THS_PNL_MBR

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

123: WHERE person_id = cp_person_id
124: AND ca_sequence_number = cp_ca_sequence_number
125: AND the_sequence_number = cp_the_sequence_number;
126:
127: CURSOR c_get_thesis_panel_memb (cp_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
128: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
129: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
130: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
131: SELECT *

Line 128: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,

124: AND ca_sequence_number = cp_ca_sequence_number
125: AND the_sequence_number = cp_the_sequence_number;
126:
127: CURSOR c_get_thesis_panel_memb (cp_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
128: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
129: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
130: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
131: SELECT *
132: FROM igs_re_ths_pnl_mbr

Line 129: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,

125: AND the_sequence_number = cp_the_sequence_number;
126:
127: CURSOR c_get_thesis_panel_memb (cp_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
128: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
129: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
130: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
131: SELECT *
132: FROM igs_re_ths_pnl_mbr
133: WHERE ca_person_id = cp_ca_person_id

Line 130: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS

126:
127: CURSOR c_get_thesis_panel_memb (cp_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
128: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
129: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
130: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
131: SELECT *
132: FROM igs_re_ths_pnl_mbr
133: WHERE ca_person_id = cp_ca_person_id
134: AND ca_sequence_number = cp_ca_sequence_number

Line 132: FROM igs_re_ths_pnl_mbr

128: cp_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
129: cp_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
130: cp_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
131: SELECT *
132: FROM igs_re_ths_pnl_mbr
133: WHERE ca_person_id = cp_ca_person_id
134: AND ca_sequence_number = cp_ca_sequence_number
135: AND the_sequence_number = cp_the_sequence_number
136: AND creation_dt = cp_creation_dt;

Line 282: IGS_RE_THS_PNL_MBR_PKG.INSERT_ROW(

278: v_message_name:= 'IGS_AD_RSCH_EXAM_PNL_MEM';
279:
280: l_rowid_child3 := NULL;
281:
282: IGS_RE_THS_PNL_MBR_PKG.INSERT_ROW(
283: X_ROWID => l_rowid_child3,
284: X_CA_PERSON_ID => p_person_id,
285: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
286: X_THE_SEQUENCE_NUMBER => l_get_thesis_sequence,