APPS.IGS_PS_SCH_PRG_CFIG_PKG dependencies on IGS_PS_SCH_PRG_CFIG

Line 1: PACKAGE BODY igs_ps_sch_prg_cfig_pkg AS

1: PACKAGE BODY igs_ps_sch_prg_cfig_pkg AS
2: /* $Header: IGSPI3PB.pls 120.1 2005/09/08 16:10:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_sch_prg_cfig%ROWTYPE;

Line 5: old_references igs_ps_sch_prg_cfig%ROWTYPE;

1: PACKAGE BODY igs_ps_sch_prg_cfig_pkg AS
2: /* $Header: IGSPI3PB.pls 120.1 2005/09/08 16:10:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_sch_prg_cfig%ROWTYPE;
6: new_references igs_ps_sch_prg_cfig%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_sch_prg_cfig%ROWTYPE;

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

Line 32: FROM igs_ps_sch_prg_cfig

28: */
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM igs_ps_sch_prg_cfig
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 111: FROM igs_ps_sch_prg_cfig

107: || (reverse chronological order - newest change first)
108: */
109: CURSOR cur_rowid IS
110: SELECT rowid
111: FROM igs_ps_sch_prg_cfig
112: WHERE prg_cfig_id = x_prg_cfig_id
113: FOR UPDATE NOWAIT;
114:
115: lv_rowid cur_rowid%RowType;

Line 147: FROM igs_ps_sch_prg_cfig

143: || (reverse chronological order - newest change first)
144: */
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM igs_ps_sch_prg_cfig
148: WHERE teaching_calendar_type = x_teaching_calendar_type
149: AND purge_type = x_purge_type
150: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
151:

Line 276: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_PRG_CFIG_PKG.INSERT_ROW');

272: x_last_update_login := -1;
273: END IF;
274: ELSE
275: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
276: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_PRG_CFIG_PKG.INSERT_ROW');
277: igs_ge_msg_stack.add;
278: app_exception.raise_exception;
279: END IF;
280:

Line 296: INSERT INTO igs_ps_sch_prg_cfig (

292: x_last_updated_by => x_last_updated_by,
293: x_last_update_login => x_last_update_login
294: );
295:
296: INSERT INTO igs_ps_sch_prg_cfig (
297: teaching_calendar_type,
298: purge_type,
299: prg_cfig_id,
300: creation_date,

Line 308: igs_ps_sch_prg_cfig_s.NEXTVAL,

304: last_update_login
305: ) VALUES (
306: new_references.teaching_calendar_type,
307: new_references.purge_type,
308: igs_ps_sch_prg_cfig_s.NEXTVAL,
309: x_last_update_date,
310: x_last_updated_by,
311: x_last_update_date,
312: x_last_updated_by,

Line 338: FROM igs_ps_sch_prg_cfig

334: CURSOR c1 IS
335: SELECT
336: teaching_calendar_type,
337: purge_type
338: FROM igs_ps_sch_prg_cfig
339: WHERE rowid = x_rowid
340: FOR UPDATE NOWAIT;
341:
342: tlinfo c1%ROWTYPE;

Line 410: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_PRG_CFIG_PKG.UPDATE_ROW');

406: x_last_update_login := -1;
407: END IF;
408: ELSE
409: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
410: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_PRG_CFIG_PKG.UPDATE_ROW');
411: igs_ge_msg_stack.add;
412: app_exception.raise_exception;
413: END IF;
414:

Line 428: UPDATE igs_ps_sch_prg_cfig

424: x_last_updated_by => x_last_updated_by,
425: x_last_update_login => x_last_update_login
426: );
427:
428: UPDATE igs_ps_sch_prg_cfig
429: SET
430: teaching_calendar_type = new_references.teaching_calendar_type,
431: purge_type = new_references.purge_type,
432: last_update_date = x_last_update_date,

Line 462: FROM igs_ps_sch_prg_cfig

458: || (reverse chronological order - newest change first)
459: */
460: CURSOR c1 IS
461: SELECT rowid
462: FROM igs_ps_sch_prg_cfig
463: WHERE prg_cfig_id = x_prg_cfig_id;
464:
465: BEGIN
466:

Line 513: DELETE FROM igs_ps_sch_prg_cfig

509: p_action => 'DELETE',
510: x_rowid => x_rowid
511: );
512:
513: DELETE FROM igs_ps_sch_prg_cfig
514: WHERE rowid = x_rowid;
515:
516: IF (SQL%NOTFOUND) THEN
517: RAISE NO_DATA_FOUND;

Line 523: END igs_ps_sch_prg_cfig_pkg;

519:
520: END delete_row;
521:
522:
523: END igs_ps_sch_prg_cfig_pkg;