APPS.IGS_AS_SUA_SES_ATTS_PKG dependencies on IGS_AS_SUA_SES_ATTS

Line 1: PACKAGE BODY igs_as_sua_ses_atts_pkg AS

1: PACKAGE BODY igs_as_sua_ses_atts_pkg AS
2: /* $Header: IGSDI80B.pls 120.0 2005/07/05 11:54:59 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_sua_ses_atts%ROWTYPE;

Line 5: old_references igs_as_sua_ses_atts%ROWTYPE;

1: PACKAGE BODY igs_as_sua_ses_atts_pkg AS
2: /* $Header: IGSDI80B.pls 120.0 2005/07/05 11:54:59 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_sua_ses_atts%ROWTYPE;
6: new_references igs_as_sua_ses_atts%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_sua_ses_atts%ROWTYPE;

2: /* $Header: IGSDI80B.pls 120.0 2005/07/05 11:54:59 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_sua_ses_atts%ROWTYPE;
6: new_references igs_as_sua_ses_atts%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_as_sua_ses_atts

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM igs_as_sua_ses_atts
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 125: FROM igs_as_sua_ses_atts

121: || (reverse chronological order - newest change first)
122: */
123: CURSOR cur_rowid IS
124: SELECT rowid
125: FROM igs_as_sua_ses_atts
126: WHERE person_id = x_person_id
127: AND course_cd = x_course_cd
128: AND uoo_id = x_uoo_id
129: AND session_name = x_session_name

Line 268: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.INSERT_ROW');

264: x_last_update_login := -1;
265: END IF;
266: ELSE
267: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
268: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.INSERT_ROW');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: END IF;
272:

Line 291: INSERT INTO igs_as_sua_ses_atts (

287:
288: IF (x_mode = 'S') THEN
289: igs_sc_gen_001.set_ctx('R');
290: END IF;
291: INSERT INTO igs_as_sua_ses_atts (
292: person_id,
293: course_cd,
294: uoo_id,
295: session_name,

Line 392: FROM igs_as_sua_ses_atts

388: */
389: CURSOR c1 IS
390: SELECT
391: attendance_flag
392: FROM igs_as_sua_ses_atts
393: WHERE rowid = x_rowid
394: FOR UPDATE NOWAIT;
395:
396: tlinfo c1%ROWTYPE;

Line 504: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.UPDATE_ROW');

500: x_last_update_login := -1;
501: END IF;
502: ELSE
503: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
504: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.UPDATE_ROW');
505: igs_ge_msg_stack.add;
506: app_exception.raise_exception;
507: END IF;
508:

Line 527: UPDATE igs_as_sua_ses_atts

523:
524: IF (x_mode = 'S') THEN
525: igs_sc_gen_001.set_ctx('R');
526: END IF;
527: UPDATE igs_as_sua_ses_atts
528: SET
529: attendance_flag = new_references.attendance_flag,
530: last_update_date = x_last_update_date,
531: last_updated_by = x_last_updated_by,

Line 618: FROM igs_as_sua_ses_atts

614: || (reverse chronological order - newest change first)
615: */
616: CURSOR c1 IS
617: SELECT rowid
618: FROM igs_as_sua_ses_atts
619: WHERE person_id = x_person_id
620: AND course_cd = x_course_cd
621: AND uoo_id = x_uoo_id
622: AND session_name = x_session_name;

Line 727: DELETE FROM igs_as_sua_ses_atts

723:
724: IF (x_mode = 'S') THEN
725: igs_sc_gen_001.set_ctx('R');
726: END IF;
727: DELETE FROM igs_as_sua_ses_atts
728: WHERE rowid = x_rowid;
729:
730: IF (SQL%NOTFOUND) THEN
731: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 794: FROM igs_as_sua_ses_atts

790: || (reverse chronological order - newest change first)
791: */
792: CURSOR cur_rowid IS
793: SELECT rowid
794: FROM igs_as_sua_ses_atts
795: WHERE session_name = x_session_name
796: AND uoo_id = x_uoo_id;
797: lv_rowid cur_rowid%ROWTYPE;
798:

Line 831: FROM igs_as_sua_ses_atts

827: || (reverse chronological order - newest change first)
828: */
829: CURSOR cur_rowid IS
830: SELECT rowid
831: FROM igs_as_sua_ses_atts
832: WHERE person_id = x_person_id
833: AND course_cd = x_course_cd
834: AND uoo_id = x_uoo_id;
835:

Line 853: END igs_as_sua_ses_atts_pkg;

849: CLOSE cur_rowid;
850:
851: END get_fk_igs_en_su_Attempt;
852:
853: END igs_as_sua_ses_atts_pkg;