APPS.IGS_AD_CRT_APPL_CFG_PKG dependencies on IGS_AD_CRT_APPL_CFG

Line 1: PACKAGE BODY igs_ad_crt_appl_cfg_pkg AS

1: PACKAGE BODY igs_ad_crt_appl_cfg_pkg AS
2: /* $Header: IGSAIH6B.pls 120.1 2005/09/08 15:13:33 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_crt_appl_cfg%ROWTYPE;

Line 5: old_references igs_ad_crt_appl_cfg%ROWTYPE;

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

Line 6: new_references igs_ad_crt_appl_cfg%ROWTYPE;

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

Line 34: FROM igs_ad_crt_appl_cfg

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

Line 91: FROM igs_ad_crt_appl_cfg

87: || (reverse chronological order - newest change first)
88: */
89: CURSOR cur_rowid IS
90: SELECT rowid
91: FROM igs_ad_crt_appl_cfg
92: WHERE responsibility = x_responsibility
93: AND component_code = x_component_code
94: FOR UPDATE NOWAIT;
95:

Line 221: fnd_message.set_token ('ROUTINE', 'IGS_AD_CRT_APPL_CFG_PKG.INSERT_ROW');

217: x_last_update_login := -1;
218: END IF;
219: ELSE
220: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
221: fnd_message.set_token ('ROUTINE', 'IGS_AD_CRT_APPL_CFG_PKG.INSERT_ROW');
222: igs_ge_msg_stack.add;
223: app_exception.raise_exception;
224: END IF;
225:

Line 243: INSERT INTO igs_ad_crt_appl_cfg (

239: x_last_updated_by => x_last_updated_by,
240: x_last_update_login => x_last_update_login
241: );
242:
243: INSERT INTO igs_ad_crt_appl_cfg (
244: responsibility,
245: component_code,
246: display_name,
247: included_flag,

Line 292: FROM igs_ad_crt_appl_cfg

288: SELECT
289: display_name,
290: included_flag,
291: required_flag
292: FROM igs_ad_crt_appl_cfg
293: WHERE rowid = x_rowid
294: FOR UPDATE NOWAIT;
295:
296: tlinfo c1%ROWTYPE;

Line 367: fnd_message.set_token ('ROUTINE', 'IGS_AD_CRT_APPL_CFG_PKG.UPDATE_ROW');

363: x_last_update_login := -1;
364: END IF;
365: ELSE
366: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
367: fnd_message.set_token ('ROUTINE', 'IGS_AD_CRT_APPL_CFG_PKG.UPDATE_ROW');
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END IF;
371:

Line 387: UPDATE igs_ad_crt_appl_cfg

383: x_last_updated_by => x_last_updated_by,
384: x_last_update_login => x_last_update_login
385: );
386:
387: UPDATE igs_ad_crt_appl_cfg
388: SET
389: display_name = new_references.display_name,
390: included_flag = new_references.included_flag,
391: required_flag = new_references.required_flag,

Line 424: FROM igs_ad_crt_appl_cfg

420: || (reverse chronological order - newest change first)
421: */
422: CURSOR c1 IS
423: SELECT rowid
424: FROM igs_ad_crt_appl_cfg
425: WHERE responsibility = x_responsibility
426: AND component_code = x_component_code;
427:
428: BEGIN

Line 480: DELETE FROM igs_ad_crt_appl_cfg

476: p_action => 'DELETE',
477: x_rowid => x_rowid
478: );
479:
480: DELETE FROM igs_ad_crt_appl_cfg
481: WHERE rowid = x_rowid;
482:
483: IF (SQL%NOTFOUND) THEN
484: RAISE NO_DATA_FOUND;

Line 490: END igs_ad_crt_appl_cfg_pkg;

486:
487: END delete_row;
488:
489:
490: END igs_ad_crt_appl_cfg_pkg;