APPS.IGS_EN_SS_DISP_STPS_PKG dependencies on IGS_EN_SS_DISP_STPS

Line 1: PACKAGE BODY igs_en_ss_disp_stps_pkg AS

1: PACKAGE BODY igs_en_ss_disp_stps_pkg AS
2: /* $Header: IGSEI77B.pls 120.2 2005/06/15 05:06:15 appldev $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_ss_disp_stps%ROWTYPE;

Line 5: old_references igs_en_ss_disp_stps%ROWTYPE;

1: PACKAGE BODY igs_en_ss_disp_stps_pkg AS
2: /* $Header: IGSEI77B.pls 120.2 2005/06/15 05:06:15 appldev $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_ss_disp_stps%ROWTYPE;
6: new_references igs_en_ss_disp_stps%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_ss_disp_stps%ROWTYPE;

2: /* $Header: IGSEI77B.pls 120.2 2005/06/15 05:06:15 appldev $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_ss_disp_stps%ROWTYPE;
6: new_references igs_en_ss_disp_stps%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igs_en_ss_disp_stps

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

Line 88: FROM igs_en_ss_disp_stps

84:
85: */
86: CURSOR cur_rowid IS
87: SELECT rowid
88: FROM igs_en_ss_disp_stps
89: WHERE ss_display_id = x_ss_display_id
90: FOR UPDATE NOWAIT;
91:
92: lv_rowid cur_rowid%RowType;

Line 211: fnd_message.set_token ('ROUTINE', 'IGS_EN_SS_DISP_STPS_PKG.INSERT_ROW');

207: x_last_update_login := -1;
208: END IF;
209: ELSE
210: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
211: fnd_message.set_token ('ROUTINE', 'IGS_EN_SS_DISP_STPS_PKG.INSERT_ROW');
212: igs_ge_msg_stack.add;
213: app_exception.raise_exception;
214: END IF;
215:

Line 229: INSERT INTO igs_en_ss_disp_stps (

225: x_last_updated_by => x_last_updated_by,
226: x_last_update_login => x_last_update_login
227: );
228:
229: INSERT INTO igs_en_ss_disp_stps (
230: ss_display_id,
231: academic_year_flag,
232: CORE_REQ_IND,
233: creation_date,

Line 272: FROM igs_en_ss_disp_stps

268: */
269: CURSOR c1 IS
270: SELECT
271: academic_year_flag,core_req_ind
272: FROM igs_en_ss_disp_stps
273: WHERE rowid = x_rowid
274: FOR UPDATE NOWAIT;
275:
276: tlinfo c1%ROWTYPE;

Line 348: fnd_message.set_token ('ROUTINE', 'IGS_EN_SS_DISP_STPS_PKG.UPDATE_ROW');

344: x_last_update_login := -1;
345: END IF;
346: ELSE
347: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
348: fnd_message.set_token ('ROUTINE', 'IGS_EN_SS_DISP_STPS_PKG.UPDATE_ROW');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352:

Line 366: UPDATE igs_en_ss_disp_stps

362: x_last_updated_by => x_last_updated_by,
363: x_last_update_login => x_last_update_login
364: );
365:
366: UPDATE igs_en_ss_disp_stps
367: SET
368: academic_year_flag = new_references.academic_year_flag,
369: CORE_REQ_IND = new_references.CORE_REQ_IND,
370: last_update_date = x_last_update_date,

Line 401: FROM igs_en_ss_disp_stps

397: || ctyagi 18-May-2005 Add the parameter x_core_req_ind
398: */
399: CURSOR c1 IS
400: SELECT rowid
401: FROM igs_en_ss_disp_stps
402: WHERE ss_display_id = x_ss_display_id;
403:
404: BEGIN
405:

Line 452: DELETE FROM igs_en_ss_disp_stps

448: p_action => 'DELETE',
449: x_rowid => x_rowid
450: );
451:
452: DELETE FROM igs_en_ss_disp_stps
453: WHERE rowid = x_rowid;
454:
455: IF (SQL%NOTFOUND) THEN
456: RAISE NO_DATA_FOUND;

Line 462: END igs_en_ss_disp_stps_pkg;

458:
459: END delete_row;
460:
461:
462: END igs_en_ss_disp_stps_pkg;