APPS.IGS_AD_SS_LOOKUPS_PKG dependencies on IGS_AD_SS_LOOKUPS

Line 1: PACKAGE BODY igs_ad_ss_lookups_pkg AS

1: PACKAGE BODY igs_ad_ss_lookups_pkg AS
2: /* $Header: IGSAIH9B.pls 120.1 2005/09/08 15:55:55 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_ss_lookups%ROWTYPE;

Line 5: old_references igs_ad_ss_lookups%ROWTYPE;

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

Line 6: new_references igs_ad_ss_lookups%ROWTYPE;

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

Line 33: FROM igs_ad_ss_lookups

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

Line 116: FROM igs_ad_ss_lookups

112: || (reverse chronological order - newest change first)
113: */
114: CURSOR cur_rowid IS
115: SELECT rowid
116: FROM igs_ad_ss_lookups
117: WHERE admission_application_type = x_admission_application_type
118: AND ss_lookup_type = x_ss_lookup_type
119: AND ss_lookup_code = x_ss_lookup_code
120: FOR UPDATE NOWAIT;

Line 153: FROM igs_ad_ss_lookups

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

Line 285: fnd_message.set_token ('ROUTINE', 'IGS_AD_SS_LOOKUPS_PKG.INSERT_ROW');

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

Line 304: INSERT INTO igs_ad_ss_lookups (

300: x_last_updated_by => x_last_updated_by,
301: x_last_update_login => x_last_update_login
302: );
303:
304: INSERT INTO igs_ad_ss_lookups (
305: admission_application_type,
306: ss_lookup_type,
307: ss_lookup_code,
308: closed_flag,

Line 352: FROM igs_ad_ss_lookups

348: */
349: CURSOR c1 IS
350: SELECT
351: closed_flag
352: FROM igs_ad_ss_lookups
353: WHERE rowid = x_rowid
354: FOR UPDATE NOWAIT;
355:
356: tlinfo c1%ROWTYPE;

Line 424: fnd_message.set_token ('ROUTINE', 'IGS_AD_SS_LOOKUPS_PKG.UPDATE_ROW');

420: x_last_update_login := -1;
421: END IF;
422: ELSE
423: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
424: fnd_message.set_token ('ROUTINE', 'IGS_AD_SS_LOOKUPS_PKG.UPDATE_ROW');
425: igs_ge_msg_stack.add;
426: app_exception.raise_exception;
427: END IF;
428:

Line 443: UPDATE igs_ad_ss_lookups

439: x_last_updated_by => x_last_updated_by,
440: x_last_update_login => x_last_update_login
441: );
442:
443: UPDATE igs_ad_ss_lookups
444: SET
445: closed_flag = new_references.closed_flag,
446: last_update_date = x_last_update_date,
447: last_updated_by = x_last_updated_by,

Line 477: FROM igs_ad_ss_lookups

473: || (reverse chronological order - newest change first)
474: */
475: CURSOR c1 IS
476: SELECT rowid
477: FROM igs_ad_ss_lookups
478: WHERE admission_application_type = x_admission_application_type
479: AND ss_lookup_type = x_ss_lookup_type
480: AND ss_lookup_code = x_ss_lookup_code;
481:

Line 532: DELETE FROM igs_ad_ss_lookups

528: p_action => 'DELETE',
529: x_rowid => x_rowid
530: );
531:
532: DELETE FROM igs_ad_ss_lookups
533: WHERE rowid = x_rowid;
534:
535: IF (SQL%NOTFOUND) THEN
536: RAISE NO_DATA_FOUND;

Line 542: END igs_ad_ss_lookups_pkg;

538:
539: END delete_row;
540:
541:
542: END igs_ad_ss_lookups_pkg;