APPS.IGS_AD_SS_TERMS_PKG dependencies on IGS_AD_SS_TERMS

Line 1: PACKAGE BODY igs_ad_ss_terms_pkg AS

1: PACKAGE BODY igs_ad_ss_terms_pkg AS
2: /* $Header: IGSAIH8B.pls 120.1 2005/09/08 15:54:56 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_ss_terms%ROWTYPE;

Line 5: old_references igs_ad_ss_terms%ROWTYPE;

1: PACKAGE BODY igs_ad_ss_terms_pkg AS
2: /* $Header: IGSAIH8B.pls 120.1 2005/09/08 15:54:56 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_ss_terms%ROWTYPE;
6: new_references igs_ad_ss_terms%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_ss_terms%ROWTYPE;

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

Line 34: FROM igs_ad_ss_terms

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

Line 117: FROM igs_ad_ss_terms

113: || (reverse chronological order - newest change first)
114: */
115: CURSOR cur_rowid IS
116: SELECT rowid
117: FROM igs_ad_ss_terms
118: WHERE admission_application_type = x_admission_application_type
119: AND cond_id = x_cond_id
120: FOR UPDATE NOWAIT;
121:

Line 153: FROM igs_ad_ss_terms

149: || (reverse chronological order - newest change first)
150: */
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM igs_ad_ss_terms
154: WHERE ((admission_application_type = x_admission_application_type));
155:
156: lv_rowid cur_rowid%RowType;
157:

Line 286: fnd_message.set_token ('ROUTINE', 'IGS_AD_SS_TERMS_PKG.INSERT_ROW');

282: x_last_update_login := -1;
283: END IF;
284: ELSE
285: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
286: fnd_message.set_token ('ROUTINE', 'IGS_AD_SS_TERMS_PKG.INSERT_ROW');
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: END IF;
290:

Line 306: INSERT INTO igs_ad_ss_terms (

302: x_last_updated_by => x_last_updated_by,
303: x_last_update_login => x_last_update_login
304: );
305:
306: INSERT INTO igs_ad_ss_terms (
307: admission_application_type,
308: cond_id,
309: cond_disp_name,
310: cond_disp_text,

Line 359: FROM igs_ad_ss_terms

355: SELECT
356: cond_disp_name,
357: cond_disp_text,
358: include_flag
359: FROM igs_ad_ss_terms
360: WHERE rowid = x_rowid
361: FOR UPDATE NOWAIT;
362:
363: tlinfo c1%ROWTYPE;

Line 434: fnd_message.set_token ('ROUTINE', 'IGS_AD_SS_TERMS_PKG.UPDATE_ROW');

430: x_last_update_login := -1;
431: END IF;
432: ELSE
433: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
434: fnd_message.set_token ('ROUTINE', 'IGS_AD_SS_TERMS_PKG.UPDATE_ROW');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438:

Line 454: UPDATE igs_ad_ss_terms

450: x_last_updated_by => x_last_updated_by,
451: x_last_update_login => x_last_update_login
452: );
453:
454: UPDATE igs_ad_ss_terms
455: SET
456: cond_disp_name = new_references.cond_disp_name,
457: cond_disp_text = new_references.cond_disp_text,
458: include_flag = new_references.include_flag,

Line 491: FROM igs_ad_ss_terms

487: || (reverse chronological order - newest change first)
488: */
489: CURSOR c1 IS
490: SELECT rowid
491: FROM igs_ad_ss_terms
492: WHERE admission_application_type = x_admission_application_type
493: AND cond_id = x_cond_id;
494:
495: BEGIN

Line 547: DELETE FROM igs_ad_ss_terms

543: p_action => 'DELETE',
544: x_rowid => x_rowid
545: );
546:
547: DELETE FROM igs_ad_ss_terms
548: WHERE rowid = x_rowid;
549:
550: IF (SQL%NOTFOUND) THEN
551: RAISE NO_DATA_FOUND;

Line 557: END igs_ad_ss_terms_pkg;

553:
554: END delete_row;
555:
556:
557: END igs_ad_ss_terms_pkg;