APPS.IGS_AS_SU_ATMPTOUT_H_PKG dependencies on IGS_AS_SU_ATMPTOUT_H_ALL

Line 4: old_references igs_as_su_atmptout_h_all%ROWTYPE;

1: PACKAGE BODY igs_as_su_atmptout_h_pkg AS
2: /* $Header: IGSDI05B.pls 115.8 2003/12/11 09:50:36 kdande ship $ */
3: l_rowid VARCHAR2 (25);
4: old_references igs_as_su_atmptout_h_all%ROWTYPE;
5: new_references igs_as_su_atmptout_h_all%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_as_su_atmptout_h_all%ROWTYPE;

1: PACKAGE BODY igs_as_su_atmptout_h_pkg AS
2: /* $Header: IGSDI05B.pls 115.8 2003/12/11 09:50:36 kdande ship $ */
3: l_rowid VARCHAR2 (25);
4: old_references igs_as_su_atmptout_h_all%ROWTYPE;
5: new_references igs_as_su_atmptout_h_all%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 44: FROM igs_as_su_atmptout_h_all

40: x_manual_override_flag IN VARCHAR2 DEFAULT NULL
41: ) AS
42: CURSOR cur_old_ref_values IS
43: SELECT *
44: FROM igs_as_su_atmptout_h_all
45: WHERE ROWID = x_rowid;
46: BEGIN
47: l_rowid := x_rowid;
48: -- Code for setting the Old and New Reference Values.

Line 119: FROM igs_as_su_atmptout_h_all

115: )
116: RETURN BOOLEAN AS
117: CURSOR cur_rowid IS
118: SELECT ROWID
119: FROM igs_as_su_atmptout_h_all
120: WHERE person_id = x_person_id
121: AND course_cd = x_course_cd
122: AND outcome_dt = x_outcome_dt
123: AND hist_start_dt = x_hist_start_dt

Line 280: FROM igs_as_su_atmptout_h_all

276: x_manual_override_flag IN VARCHAR2 DEFAULT 'N'
277: ) IS
278: CURSOR c IS
279: SELECT ROWID
280: FROM igs_as_su_atmptout_h_all
281: WHERE person_id = x_person_id
282: AND course_cd = x_course_cd
283: AND uoo_id = x_uoo_id
284: AND outcome_dt = x_outcome_dt

Line 350: INSERT INTO igs_as_su_atmptout_h_all

346: x_release_date => x_release_date,
347: x_manual_override_flag => x_manual_override_flag
348: );
349:
350: INSERT INTO igs_as_su_atmptout_h_all
351: (org_id, person_id, course_cd, unit_cd,
352: cal_type, ci_sequence_number, outcome_dt,
353: hist_start_dt, hist_end_dt, hist_who,
354: grading_schema_cd, version_number, grade,

Line 430: FROM igs_as_su_atmptout_h_all

426: mark_capped_flag,
427: show_on_academic_histry_flag,
428: release_date,
429: manual_override_flag
430: FROM igs_as_su_atmptout_h_all
431: WHERE ROWID = x_rowid
432: FOR UPDATE NOWAIT;
433:
434: tlinfo c1%ROWTYPE;

Line 628: UPDATE igs_as_su_atmptout_h_all

624: x_release_date => x_release_date,
625: x_manual_override_flag => x_manual_override_flag
626: );
627:
628: UPDATE igs_as_su_atmptout_h_all
629: SET hist_end_dt = new_references.hist_end_dt,
630: hist_who = new_references.hist_who,
631: grading_schema_cd = new_references.grading_schema_cd,
632: version_number = new_references.version_number,

Line 688: FROM igs_as_su_atmptout_h_all

684: x_manual_override_flag IN VARCHAR2 DEFAULT 'N'
685: ) IS
686: CURSOR c1 IS
687: SELECT ROWID
688: FROM igs_as_su_atmptout_h_all
689: WHERE person_id = x_person_id
690: AND course_cd = x_course_cd
691: AND uoo_id = x_uoo_id
692: AND outcome_dt = x_outcome_dt

Line 769: DELETE FROM igs_as_su_atmptout_h_all

765: PROCEDURE delete_row (x_rowid IN VARCHAR2) IS
766: BEGIN
767: before_dml (p_action => 'DELETE', x_rowid => x_rowid);
768:
769: DELETE FROM igs_as_su_atmptout_h_all
770: WHERE ROWID = x_rowid;
771:
772: IF (SQL%NOTFOUND) THEN
773: RAISE NO_DATA_FOUND;