APPS.IGS_EN_INS_CA_TRNSFR dependencies on IGS_RE_CDT_ATT_HIST

Line 107: --This module inserts research IGS_RE_CDT_ATT_HIST details as a result of

103: p_message_name OUT NOCOPY VARCHAR2)
104: RETURN BOOLEAN AS
105:
106: BEGIN -- enrp_ins_cah_trnsfr
107: --This module inserts research IGS_RE_CDT_ATT_HIST details as a result of
108: --course transfer. All Candidature research supervisor details
109: --(p_person_id/p_transfer_ca_sequence_number) are to be copied to the new
110: --Candidature (p_person_id/p_ca_sequence_number).
111: DECLARE

Line 116: FROM IGS_RE_CDT_ATT_HIST cah

112: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
113: v_cah_exists VARCHAR2(1);
114: CURSOR c_cah IS
115: SELECT 'x'
116: FROM IGS_RE_CDT_ATT_HIST cah
117: WHERE cah.person_id = p_person_id AND
118: cah.sequence_number = p_ca_sequence_number;
119: CURSOR c_cah1 IS
120: SELECT cah.sequence_number,

Line 125: FROM IGS_RE_CDT_ATT_HIST cah

121: cah.hist_start_dt,
122: cah.hist_end_dt,
123: cah.attendance_type,
124: cah.attendance_percentage
125: FROM IGS_RE_CDT_ATT_HIST cah
126: WHERE cah.person_id = p_person_id AND
127: cah.ca_sequence_number = p_transfer_ca_sequence_number;
128: BEGIN
129: -- Set the default message number

Line 156: IGS_RE_CDT_ATT_HIST_PKG.INSERT_ROW(

152: DECLARE
153: l_rowid VARCHAR2(25);
154: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
155: BEGIN
156: IGS_RE_CDT_ATT_HIST_PKG.INSERT_ROW(
157: X_ROWID => l_rowid,
158: X_org_id => l_org_id,
159: X_person_id => p_person_id,
160: X_ca_sequence_number => p_ca_sequence_number,

Line 174: END LOOP; --(IGS_RE_CDT_ATT_HIST)

170: ROLLBACK TO sp_candidature_att_hist;
171: p_message_name := 'IGS_RE_CANT_INS_CAND_ATTN_HIS';
172: RETURN FALSE;
173: END;
174: END LOOP; --(IGS_RE_CDT_ATT_HIST)
175: -- Return the default value
176: RETURN TRUE;
177: EXCEPTION
178: WHEN OTHERS THEN