APPS.IGS_PS_SCH_OCR_CFIG_PKG dependencies on IGS_PS_SCH_OCR_CFIG

Line 1: PACKAGE BODY igs_ps_sch_ocr_cfig_pkg AS

1: PACKAGE BODY igs_ps_sch_ocr_cfig_pkg AS
2: /* $Header: IGSPI3QB.pls 120.1 2005/09/08 14:46:34 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_sch_ocr_cfig%ROWTYPE;

Line 5: old_references igs_ps_sch_ocr_cfig%ROWTYPE;

1: PACKAGE BODY igs_ps_sch_ocr_cfig_pkg AS
2: /* $Header: IGSPI3QB.pls 120.1 2005/09/08 14:46:34 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_sch_ocr_cfig%ROWTYPE;
6: new_references igs_ps_sch_ocr_cfig%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_sch_ocr_cfig%ROWTYPE;

2: /* $Header: IGSPI3QB.pls 120.1 2005/09/08 14:46:34 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_sch_ocr_cfig%ROWTYPE;
6: new_references igs_ps_sch_ocr_cfig%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 52: FROM igs_ps_sch_ocr_cfig

48: */
49:
50: CURSOR cur_old_ref_values IS
51: SELECT *
52: FROM igs_ps_sch_ocr_cfig
53: WHERE rowid = x_rowid;
54:
55: BEGIN
56:

Line 126: FROM igs_ps_sch_ocr_cfig

122: || (reverse chronological order - newest change first)
123: */
124: CURSOR cur_rowid IS
125: SELECT rowid
126: FROM igs_ps_sch_ocr_cfig
127: WHERE ocr_cfig_id = x_ocr_cfig_id
128: FOR UPDATE NOWAIT;
129:
130: lv_rowid cur_rowid%RowType;

Line 307: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_OCR_CFIG_PKG.INSERT_ROW');

303: x_last_update_login := -1;
304: END IF;
305: ELSE
306: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
307: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_OCR_CFIG_PKG.INSERT_ROW');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
311:

Line 347: INSERT INTO igs_ps_sch_ocr_cfig (

343: x_last_updated_by => x_last_updated_by,
344: x_last_update_login => x_last_update_login
345: );
346:
347: INSERT INTO igs_ps_sch_ocr_cfig (
348: ocr_cfig_id,
349: to_be_announced_roll_flag,
350: day_roll_flag,
351: time_roll_flag,

Line 377: igs_ps_sch_ocr_cfig_s.NEXTVAL,

373: last_update_date,
374: last_updated_by,
375: last_update_login
376: ) VALUES (
377: igs_ps_sch_ocr_cfig_s.NEXTVAL,
378: new_references.to_be_announced_roll_flag,
379: new_references.day_roll_flag,
380: new_references.time_roll_flag,
381: new_references.instructor_roll_flag,

Line 469: FROM igs_ps_sch_ocr_cfig

465: time_ovrd_flag,
466: instructor_ovrd_flag,
467: scheduled_bld_ovrd_flag,
468: scheduled_room_ovrd_flag
469: FROM igs_ps_sch_ocr_cfig
470: WHERE rowid = x_rowid
471: FOR UPDATE NOWAIT;
472:
473: tlinfo c1%ROWTYPE;

Line 581: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_OCR_CFIG_PKG.UPDATE_ROW');

577: x_last_update_login := -1;
578: END IF;
579: ELSE
580: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
581: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_OCR_CFIG_PKG.UPDATE_ROW');
582: igs_ge_msg_stack.add;
583: app_exception.raise_exception;
584: END IF;
585:

Line 619: UPDATE igs_ps_sch_ocr_cfig

615: x_last_updated_by => x_last_updated_by,
616: x_last_update_login => x_last_update_login
617: );
618:
619: UPDATE igs_ps_sch_ocr_cfig
620: SET
621: to_be_announced_roll_flag = new_references.to_be_announced_roll_flag,
622: day_roll_flag = new_references.day_roll_flag,
623: time_roll_flag = new_references.time_roll_flag,

Line 693: FROM igs_ps_sch_ocr_cfig

689: || (reverse chronological order - newest change first)
690: */
691: CURSOR c1 IS
692: SELECT rowid
693: FROM igs_ps_sch_ocr_cfig
694: WHERE ocr_cfig_id = x_ocr_cfig_id;
695:
696: BEGIN
697:

Line 784: DELETE FROM igs_ps_sch_ocr_cfig

780: p_action => 'DELETE',
781: x_rowid => x_rowid
782: );
783:
784: DELETE FROM igs_ps_sch_ocr_cfig
785: WHERE rowid = x_rowid;
786:
787: IF (SQL%NOTFOUND) THEN
788: RAISE NO_DATA_FOUND;

Line 794: END igs_ps_sch_ocr_cfig_pkg;

790:
791: END delete_row;
792:
793:
794: END igs_ps_sch_ocr_cfig_pkg;