APPS.IGS_HE_EN_SUSA_PKG dependencies on IGS_HE_EN_SUSA

Line 1: PACKAGE BODY igs_he_en_susa_pkg AS

1: PACKAGE BODY igs_he_en_susa_pkg AS
2: /* $Header: IGSWI21B.pls 120.2 2005/07/03 18:34:02 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_en_susa%ROWTYPE;

Line 5: old_references igs_he_en_susa%ROWTYPE;

1: PACKAGE BODY igs_he_en_susa_pkg AS
2: /* $Header: IGSWI21B.pls 120.2 2005/07/03 18:34:02 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_en_susa%ROWTYPE;
6: new_references igs_he_en_susa%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_en_susa%ROWTYPE;

2: /* $Header: IGSWI21B.pls 120.2 2005/07/03 18:34:02 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_en_susa%ROWTYPE;
6: new_references igs_he_en_susa%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 83: FROM IGS_HE_EN_SUSA

79: */
80:
81: CURSOR cur_old_ref_values IS
82: SELECT *
83: FROM IGS_HE_EN_SUSA
84: WHERE rowid = x_rowid;
85:
86: BEGIN
87:

Line 249: FROM igs_he_en_susa

245: || (reverse chronological order - newest change first)
246: */
247: CURSOR cur_rowid IS
248: SELECT rowid
249: FROM igs_he_en_susa
250: WHERE hesa_en_susa_id = x_hesa_en_susa_id
251: FOR UPDATE NOWAIT;
252:
253: lv_rowid cur_rowid%RowType;

Line 287: FROM igs_he_en_susa

283: || (reverse chronological order - newest change first)
284: */
285: CURSOR cur_rowid IS
286: SELECT rowid
287: FROM igs_he_en_susa
288: WHERE person_id = x_person_id
289: AND course_cd = x_course_cd
290: AND unit_set_cd = x_unit_set_cd
291: AND sequence_number = x_sequence_number

Line 328: FROM igs_he_en_susa

324: || (reverse chronological order - newest change first)
325: */
326: CURSOR cur_rowid IS
327: SELECT rowid
328: FROM igs_he_en_susa
329: WHERE ((course_cd = x_course_cd) AND
330: (person_id = x_person_id) AND
331: (sequence_number = x_sequence_number) AND
332: (unit_set_cd = x_unit_set_cd));

Line 592: FROM igs_he_en_susa

588: || (reverse chronological order - newest change first)
589: */
590: CURSOR c IS
591: SELECT rowid
592: FROM igs_he_en_susa
593: WHERE hesa_en_susa_id = x_hesa_en_susa_id;
594:
595: x_last_update_date DATE;
596: x_last_updated_by NUMBER;

Line 620: SELECT igs_he_en_susa_s.NEXTVAL

616: igs_ge_msg_stack.add;
617: app_exception.raise_exception;
618: END IF;
619:
620: SELECT igs_he_en_susa_s.NEXTVAL
621: INTO x_hesa_en_susa_id
622: FROM dual;
623:
624: before_dml(

Line 689: INSERT INTO igs_he_en_susa (

685:
686: IF (x_mode = 'S') THEN
687: igs_sc_gen_001.set_ctx('R');
688: END IF;
689: INSERT INTO igs_he_en_susa (
690: hesa_en_susa_id,
691: person_id,
692: course_cd,
693: unit_set_cd,

Line 955: FROM igs_he_en_susa

951: fte_intensity,
952: calculated_fte,
953: fte_calc_type,
954: type_of_year
955: FROM igs_he_en_susa
956: WHERE rowid = x_rowid
957: FOR UPDATE NOWAIT;
958:
959: tlinfo c1%ROWTYPE;

Line 1196: UPDATE igs_he_en_susa

1192:
1193: IF (x_mode = 'S') THEN
1194: igs_sc_gen_001.set_ctx('R');
1195: END IF;
1196: UPDATE igs_he_en_susa
1197: SET
1198: person_id = new_references.person_id,
1199: course_cd = new_references.course_cd,
1200: unit_set_cd = new_references.unit_set_cd,

Line 1349: FROM igs_he_en_susa

1345: || (reverse chronological order - newest change first)
1346: */
1347: CURSOR c1 IS
1348: SELECT rowid
1349: FROM igs_he_en_susa
1350: WHERE hesa_en_susa_id = x_hesa_en_susa_id;
1351:
1352: BEGIN
1353:

Line 1502: DELETE FROM igs_he_en_susa

1498:
1499: IF (x_mode = 'S') THEN
1500: igs_sc_gen_001.set_ctx('R');
1501: END IF;
1502: DELETE FROM igs_he_en_susa
1503: WHERE rowid = x_rowid;
1504:
1505: IF (SQL%NOTFOUND) THEN
1506: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 1519: END igs_he_en_susa_pkg;

1515:
1516: END delete_row;
1517:
1518:
1519: END igs_he_en_susa_pkg;