APPS.IGS_AD_HZ_ACAD_HIST_PKG dependencies on IGS_AD_HZ_ACAD_HIST

Line 1: PACKAGE BODY igs_ad_hz_acad_hist_pkg AS

1: PACKAGE BODY igs_ad_hz_acad_hist_pkg AS
2: /* $Header: IGSAIB7B.pls 120.1 2005/06/28 04:24:21 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_hz_acad_hist%ROWTYPE;

Line 5: old_references igs_ad_hz_acad_hist%ROWTYPE;

1: PACKAGE BODY igs_ad_hz_acad_hist_pkg AS
2: /* $Header: IGSAIB7B.pls 120.1 2005/06/28 04:24:21 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_hz_acad_hist%ROWTYPE;
6: new_references igs_ad_hz_acad_hist%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_hz_acad_hist%ROWTYPE;

2: /* $Header: IGSAIB7B.pls 120.1 2005/06/28 04:24:21 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_hz_acad_hist%ROWTYPE;
6: new_references igs_ad_hz_acad_hist%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 76: FROM IGS_AD_HZ_ACAD_HIST

72: */
73:
74: CURSOR cur_old_ref_values IS
75: SELECT *
76: FROM IGS_AD_HZ_ACAD_HIST
77: WHERE rowid = x_rowid;
78:
79: BEGIN
80:

Line 245: FROM igs_ad_hz_acad_hist

241: || to the tbh calls
242: */
243: CURSOR cur_rowid IS
244: SELECT rowid
245: FROM igs_ad_hz_acad_hist
246: WHERE hz_acad_hist_id = x_hz_acad_hist_id
247: FOR UPDATE NOWAIT;
248:
249: lv_rowid cur_rowid%RowType;

Line 279: FROM igs_ad_hz_acad_hist

275: || (reverse chronological order - newest change first)
276: */
277: CURSOR cur_rowid IS
278: SELECT rowid
279: FROM igs_ad_hz_acad_hist
280: WHERE ((education_id = x_education_id));
281:
282: lv_rowid cur_rowid%RowType;
283:

Line 520: FROM igs_ad_hz_acad_hist

516: || to the tbh calls
517: */
518: CURSOR c IS
519: SELECT rowid
520: FROM igs_ad_hz_acad_hist
521: WHERE hz_acad_hist_id = x_hz_acad_hist_id;
522:
523: x_last_update_date DATE;
524: x_last_updated_by NUMBER;

Line 624: INSERT INTO igs_ad_hz_acad_hist (

620:
621: IF (x_mode = 'S') THEN
622: igs_sc_gen_001.set_ctx('R');
623: END IF;
624: INSERT INTO igs_ad_hz_acad_hist (
625: recalc_total_cp_attempted,
626: recalc_total_cp_earned,
627: recalc_total_unit_gp,
628: recalc_tot_gpa_uts_attempted,

Line 716: IGS_AD_HZ_ACAD_HIST_S.NEXTVAL,

712: new_references.attribute17,
713: new_references.attribute18,
714: new_references.attribute19,
715: new_references.attribute20,
716: IGS_AD_HZ_ACAD_HIST_S.NEXTVAL,
717: new_references.education_id,
718: new_references.current_inst,
719: new_references.degree_attempted,
720: new_references.comments,

Line 867: FROM igs_ad_hz_acad_hist

863: degree_attempted,
864: comments,
865: planned_completion_date,
866: transcript_required
867: FROM igs_ad_hz_acad_hist
868: WHERE rowid = x_rowid
869: FOR UPDATE NOWAIT;
870:
871: tlinfo c1%ROWTYPE;

Line 1103: UPDATE igs_ad_hz_acad_hist

1099:
1100: IF (x_mode = 'S') THEN
1101: igs_sc_gen_001.set_ctx('R');
1102: END IF;
1103: UPDATE igs_ad_hz_acad_hist
1104: SET
1105: recalc_total_cp_attempted = new_references.recalc_total_cp_attempted,
1106: recalc_total_cp_earned = new_references.recalc_total_cp_earned,
1107: recalc_total_unit_gp = new_references.recalc_total_unit_gp,

Line 1247: FROM igs_ad_hz_acad_hist

1243: || to the tbh calls
1244: */
1245: CURSOR c1 IS
1246: SELECT rowid
1247: FROM igs_ad_hz_acad_hist
1248: WHERE hz_acad_hist_id = x_hz_acad_hist_id;
1249: l_mode VARCHAR2(1);
1250: BEGIN
1251:

Line 1386: DELETE FROM igs_ad_hz_acad_hist

1382:
1383: IF (x_mode = 'S') THEN
1384: igs_sc_gen_001.set_ctx('R');
1385: END IF;
1386: DELETE FROM igs_ad_hz_acad_hist
1387: WHERE rowid = x_rowid;
1388:
1389: IF (SQL%NOTFOUND) THEN
1390: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 1403: END igs_ad_hz_acad_hist_pkg;

1399:
1400: END delete_row;
1401:
1402:
1403: END igs_ad_hz_acad_hist_pkg;