APPS.IGS_PS_GEN_005 dependencies on IGS_PS_TCH_RSOV_HIST

Line 23: FROM IGS_PS_TCH_RSOV_HIST troh

19: -- IGS_PS_TCH_RESP_OVRD record.
20: DECLARE
21: CURSOR c_troh IS
22: SELECT Rowid,unit_cd
23: FROM IGS_PS_TCH_RSOV_HIST troh
24: WHERE troh.unit_cd = p_unit_cd AND
25: troh.version_number = p_version_number AND
26: troh.cal_type = p_cal_type AND
27: troh.ci_sequence_number = p_ci_sequence_number AND

Line 39: IGS_PS_TCH_RSOV_HIST_PKG.Delete_Row(X_ROWID => v_troh_rec.Rowid);

35:
36: FOR v_troh_rec IN c_troh LOOP
37: -- Delete the current record.
38:
39: IGS_PS_TCH_RSOV_HIST_PKG.Delete_Row(X_ROWID => v_troh_rec.Rowid);
40:
41: END LOOP;
42:
43: -- If processing successful then

Line 183: v_hist_start_dt IGS_PS_TCH_RSOV_HIST.hist_start_dt%TYPE;

179: AS
180: BEGIN -- crsp_ins_tro_hist
181: -- Insert a teaching_responsibility_ovrd_hist record.
182: DECLARE
183: v_hist_start_dt IGS_PS_TCH_RSOV_HIST.hist_start_dt%TYPE;
184: v_hist_end_dt IGS_PS_TCH_RSOV_HIST.hist_end_dt%TYPE;
185: v_hist_who IGS_PS_TCH_RSOV_HIST.hist_who%TYPE;
186: l_org_id NUMBER(15);
187: x_rowid Varchar2(25);

Line 184: v_hist_end_dt IGS_PS_TCH_RSOV_HIST.hist_end_dt%TYPE;

180: BEGIN -- crsp_ins_tro_hist
181: -- Insert a teaching_responsibility_ovrd_hist record.
182: DECLARE
183: v_hist_start_dt IGS_PS_TCH_RSOV_HIST.hist_start_dt%TYPE;
184: v_hist_end_dt IGS_PS_TCH_RSOV_HIST.hist_end_dt%TYPE;
185: v_hist_who IGS_PS_TCH_RSOV_HIST.hist_who%TYPE;
186: l_org_id NUMBER(15);
187: x_rowid Varchar2(25);
188: BEGIN

Line 185: v_hist_who IGS_PS_TCH_RSOV_HIST.hist_who%TYPE;

181: -- Insert a teaching_responsibility_ovrd_hist record.
182: DECLARE
183: v_hist_start_dt IGS_PS_TCH_RSOV_HIST.hist_start_dt%TYPE;
184: v_hist_end_dt IGS_PS_TCH_RSOV_HIST.hist_end_dt%TYPE;
185: v_hist_who IGS_PS_TCH_RSOV_HIST.hist_who%TYPE;
186: l_org_id NUMBER(15);
187: x_rowid Varchar2(25);
188: BEGIN
189: IF p_new_percentage <> p_old_percentage THEN

Line 194: IGS_PS_TCH_RSOV_HIST_PKG.Insert_Row(

190: v_hist_start_dt := p_old_update_on;
191: v_hist_end_dt := p_new_update_on;
192: v_hist_who := p_old_update_who;
193: l_org_id := IGS_GE_GEN_003.GET_ORG_ID;
194: IGS_PS_TCH_RSOV_HIST_PKG.Insert_Row(
195: X_ROWID => x_rowid,
196: X_UNIT_CD => p_unit_cd,
197: X_CAL_TYPE => p_cal_type,
198: X_CI_SEQUENCE_NUMBER => p_ci_sequence_number,