APPS.IGS_EN_SPLACEMENTS_PKG dependencies on IGS_EN_SPLACEMENTS

Line 1: PACKAGE BODY igs_en_splacements_pkg AS

1: PACKAGE BODY igs_en_splacements_pkg AS
2: /* $Header: IGSEI73B.pls 120.1 2006/07/11 10:36:54 ckasu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_splacements%ROWTYPE;

Line 5: old_references igs_en_splacements%ROWTYPE;

1: PACKAGE BODY igs_en_splacements_pkg AS
2: /* $Header: IGSEI73B.pls 120.1 2006/07/11 10:36:54 ckasu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_splacements%ROWTYPE;
6: new_references igs_en_splacements%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_splacements%ROWTYPE;

2: /* $Header: IGSEI73B.pls 120.1 2006/07/11 10:36:54 ckasu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_splacements%ROWTYPE;
6: new_references igs_en_splacements%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 45: FROM igs_en_splacements

41: */
42:
43: CURSOR cur_old_ref_values IS
44: SELECT *
45: FROM igs_en_splacements
46: WHERE rowid = x_rowid;
47:
48: BEGIN
49:

Line 151: FROM igs_en_splacements

147: || (reverse chronological order - newest change first)
148: */
149: CURSOR cur_rowid IS
150: SELECT rowid
151: FROM igs_en_splacements
152: WHERE splacement_id = x_splacement_id
153: FOR UPDATE NOWAIT;
154:
155: lv_rowid cur_rowid%RowType;

Line 188: FROM igs_en_splacements

184: || (reverse chronological order - newest change first)
185: */
186: CURSOR cur_rowid IS
187: SELECT rowid
188: FROM igs_en_splacements
189: WHERE person_id = x_person_id
190: AND course_cd = x_course_cd
191: AND uoo_id = x_uoo_id
192: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 228: FROM igs_en_splacements

224: || (reverse chronological order - newest change first)
225: */
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM igs_en_splacements
229: WHERE person_id = x_person_id
230: AND institution_code = x_institution_code
231: AND title = x_title
232: AND start_date = x_start_date

Line 398: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPLACEMENTS_PKG.INSERT_ROW');

394: x_last_update_login := -1;
395: END IF;
396: ELSE
397: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
398: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPLACEMENTS_PKG.INSERT_ROW');
399: igs_ge_msg_stack.add;
400: app_exception.raise_exception;
401: END IF;
402:

Line 431: INSERT INTO igs_en_splacements (

427: x_last_updated_by => x_last_updated_by,
428: x_last_update_login => x_last_update_login
429: );
430:
431: INSERT INTO igs_en_splacements (
432: splacement_id,
433: person_id,
434: course_cd,
435: uoo_id,

Line 454: igs_en_splacements_s.NEXTVAL,

450: last_update_date,
451: last_updated_by,
452: last_update_login
453: ) VALUES (
454: igs_en_splacements_s.NEXTVAL,
455: new_references.person_id,
456: new_references.course_cd,
457: new_references.uoo_id,
458: new_references.start_date,

Line 525: FROM igs_en_splacements

521: compensation_flag,
522: attendance_type,
523: location,
524: notes
525: FROM igs_en_splacements
526: WHERE rowid = x_rowid
527: FOR UPDATE NOWAIT;
528:
529: tlinfo c1%ROWTYPE;

Line 623: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPLACEMENTS_PKG.UPDATE_ROW');

619: x_last_update_login := -1;
620: END IF;
621: ELSE
622: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
623: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPLACEMENTS_PKG.UPDATE_ROW');
624: igs_ge_msg_stack.add;
625: app_exception.raise_exception;
626: END IF;
627:

Line 654: UPDATE igs_en_splacements

650: x_last_updated_by => x_last_updated_by,
651: x_last_update_login => x_last_update_login
652: );
653:
654: UPDATE igs_en_splacements
655: SET
656: person_id = new_references.person_id,
657: course_cd = new_references.course_cd,
658: uoo_id = new_references.uoo_id,

Line 714: FROM igs_en_splacements

710: || (reverse chronological order - newest change first)
711: */
712: CURSOR c1 IS
713: SELECT rowid
714: FROM igs_en_splacements
715: WHERE splacement_id = x_splacement_id;
716:
717: BEGIN
718:

Line 791: DELETE FROM igs_en_splacements

787: p_action => 'DELETE',
788: x_rowid => x_rowid
789: );
790:
791: DELETE FROM igs_en_splacements
792: WHERE rowid = x_rowid;
793:
794: IF (SQL%NOTFOUND) THEN
795: RAISE NO_DATA_FOUND;

Line 801: END igs_en_splacements_pkg;

797:
798: END delete_row;
799:
800:
801: END igs_en_splacements_pkg;