APPS.IGS_AD_SS_APPL_COMPS_PKG dependencies on IGS_AD_SS_APPL_COMPS

Line 1: PACKAGE BODY igs_ad_ss_appl_comps_pkg AS

1: PACKAGE BODY igs_ad_ss_appl_comps_pkg AS
2: /* $Header: IGSAIH7B.pls 120.1 2005/09/08 14:43:27 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_ss_appl_comps%ROWTYPE;

Line 5: old_references igs_ad_ss_appl_comps%ROWTYPE;

1: PACKAGE BODY igs_ad_ss_appl_comps_pkg AS
2: /* $Header: IGSAIH7B.pls 120.1 2005/09/08 14:43:27 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_ss_appl_comps%ROWTYPE;
6: new_references igs_ad_ss_appl_comps%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_ss_appl_comps%ROWTYPE;

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

Line 35: FROM igs_ad_ss_appl_comps

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

Line 123: FROM igs_ad_ss_appl_comps

119: || (reverse chronological order - newest change first)
120: */
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM igs_ad_ss_appl_comps
124: WHERE admission_application_type = x_admission_application_type
125: AND page_name = x_page_name
126: AND component_code = x_component_code
127: FOR UPDATE NOWAIT;

Line 161: FROM igs_ad_ss_appl_comps

157: || (reverse chronological order - newest change first)
158: */
159: CURSOR cur_rowid IS
160: SELECT rowid
161: FROM igs_ad_ss_appl_comps
162: WHERE ((admission_application_type = x_admission_application_type) AND
163: (page_name = x_page_name));
164:
165: lv_rowid cur_rowid%RowType;

Line 300: fnd_message.set_token ('ROUTINE', 'igs_ad_ss_appl_comps_PKG.INSERT_ROW');

296: x_last_update_login := -1;
297: END IF;
298: ELSE
299: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
300: fnd_message.set_token ('ROUTINE', 'igs_ad_ss_appl_comps_PKG.INSERT_ROW');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: END IF;
304:

Line 321: INSERT INTO igs_ad_ss_appl_comps (

317: x_last_updated_by => x_last_updated_by,
318: x_last_update_login => x_last_update_login
319: );
320:
321: INSERT INTO igs_ad_ss_appl_comps (
322: admission_application_type,
323: page_name,
324: component_code,
325: comp_disp_name,

Line 377: FROM igs_ad_ss_appl_comps

373: SELECT
374: comp_disp_name,
375: include_flag,
376: required_flag
377: FROM igs_ad_ss_appl_comps
378: WHERE rowid = x_rowid
379: FOR UPDATE NOWAIT;
380:
381: tlinfo c1%ROWTYPE;

Line 453: fnd_message.set_token ('ROUTINE', 'igs_ad_ss_appl_comps_PKG.UPDATE_ROW');

449: x_last_update_login := -1;
450: END IF;
451: ELSE
452: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
453: fnd_message.set_token ('ROUTINE', 'igs_ad_ss_appl_comps_PKG.UPDATE_ROW');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:

Line 474: UPDATE igs_ad_ss_appl_comps

470: x_last_updated_by => x_last_updated_by,
471: x_last_update_login => x_last_update_login
472: );
473:
474: UPDATE igs_ad_ss_appl_comps
475: SET
476: comp_disp_name = new_references.comp_disp_name,
477: include_flag = new_references.include_flag,
478: required_flag = new_references.required_flag,

Line 512: FROM igs_ad_ss_appl_comps

508: || (reverse chronological order - newest change first)
509: */
510: CURSOR c1 IS
511: SELECT rowid
512: FROM igs_ad_ss_appl_comps
513: WHERE admission_application_type = x_admission_application_type
514: AND page_name = x_page_name
515: AND component_code = x_component_code;
516:

Line 571: DELETE FROM igs_ad_ss_appl_comps

567: p_action => 'DELETE',
568: x_rowid => x_rowid
569: );
570:
571: DELETE FROM igs_ad_ss_appl_comps
572: WHERE rowid = x_rowid;
573:
574: IF (SQL%NOTFOUND) THEN
575: RAISE NO_DATA_FOUND;

Line 581: END igs_ad_ss_appl_comps_pkg;

577:
578: END delete_row;
579:
580:
581: END igs_ad_ss_appl_comps_pkg;