APPS.IGS_AD_PANEL_MEMBRS_PKG dependencies on IGS_AD_PANEL_MEMBRS

Line 1: PACKAGE BODY igs_ad_panel_membrs_pkg AS

1: PACKAGE BODY igs_ad_panel_membrs_pkg AS
2: /* $Header: IGSAIG8B.pls 115.2 2003/06/23 06:59:30 akadam noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_panel_membrs%ROWTYPE;

Line 5: old_references igs_ad_panel_membrs%ROWTYPE;

1: PACKAGE BODY igs_ad_panel_membrs_pkg AS
2: /* $Header: IGSAIG8B.pls 115.2 2003/06/23 06:59:30 akadam noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_panel_membrs%ROWTYPE;
6: new_references igs_ad_panel_membrs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_panel_membrs%ROWTYPE;

2: /* $Header: IGSAIG8B.pls 115.2 2003/06/23 06:59:30 akadam noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_panel_membrs%ROWTYPE;
6: new_references igs_ad_panel_membrs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 54: FROM igs_ad_panel_membrs

50: */
51:
52: CURSOR cur_old_ref_values IS
53: SELECT *
54: FROM igs_ad_panel_membrs
55: WHERE rowid = x_rowid;
56:
57: BEGIN
58:

Line 157: FROM igs_ad_panel_membrs

153: || (reverse chronological order - newest change first)
154: */
155: CURSOR cur_rowid IS
156: SELECT rowid
157: FROM igs_ad_panel_membrs
158: WHERE panel_code = x_panel_code
159: AND member_person_id = x_member_person_id
160: FOR UPDATE NOWAIT;
161:

Line 193: FROM igs_ad_panel_membrs

189: || (reverse chronological order - newest change first)
190: */
191: CURSOR cur_rowid IS
192: SELECT rowid
193: FROM igs_ad_panel_membrs
194: WHERE ((panel_code = x_panel_code));
195:
196: lv_rowid cur_rowid%RowType;
197:

Line 386: fnd_message.set_token ('ROUTINE', 'IGS_AD_PANEL_MEMBRS_PKG.INSERT_ROW');

382: x_last_update_login := -1;
383: END IF;
384: ELSE
385: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
386: fnd_message.set_token ('ROUTINE', 'IGS_AD_PANEL_MEMBRS_PKG.INSERT_ROW');
387: igs_ge_msg_stack.add;
388: app_exception.raise_exception;
389: END IF;
390:

Line 426: INSERT INTO igs_ad_panel_membrs (

422: x_last_updated_by => x_last_updated_by,
423: x_last_update_login => x_last_update_login
424: );
425:
426: INSERT INTO igs_ad_panel_membrs (
427: panel_code,
428: member_person_id,
429: panel_seq_num,
430: role_type_code,

Line 555: FROM igs_ad_panel_membrs

551: attribute17,
552: attribute18,
553: attribute19,
554: attribute20
555: FROM igs_ad_panel_membrs
556: WHERE rowid = x_rowid
557: FOR UPDATE NOWAIT;
558:
559: tlinfo c1%ROWTYPE;

Line 670: fnd_message.set_token ('ROUTINE', 'IGS_AD_PANEL_MEMBRS_PKG.UPDATE_ROW');

666: x_last_update_login := -1;
667: END IF;
668: ELSE
669: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
670: fnd_message.set_token ('ROUTINE', 'IGS_AD_PANEL_MEMBRS_PKG.UPDATE_ROW');
671: igs_ge_msg_stack.add;
672: app_exception.raise_exception;
673: END IF;
674:

Line 710: UPDATE igs_ad_panel_membrs

706: x_last_updated_by => x_last_updated_by,
707: x_last_update_login => x_last_update_login
708: );
709:
710: UPDATE igs_ad_panel_membrs
711: SET
712: panel_seq_num = new_references.panel_seq_num,
713: role_type_code = new_references.role_type_code,
714: attribute_category = new_references.attribute_category,

Line 787: FROM igs_ad_panel_membrs

783: || (reverse chronological order - newest change first)
784: */
785: CURSOR c1 IS
786: SELECT rowid
787: FROM igs_ad_panel_membrs
788: WHERE panel_code = x_panel_code
789: AND member_person_id = x_member_person_id;
790:
791: BEGIN

Line 883: DELETE FROM igs_ad_panel_membrs

879: p_action => 'DELETE',
880: x_rowid => x_rowid
881: );
882:
883: DELETE FROM igs_ad_panel_membrs
884: WHERE rowid = x_rowid;
885:
886: IF (SQL%NOTFOUND) THEN
887: RAISE NO_DATA_FOUND;

Line 893: END igs_ad_panel_membrs_pkg;

889:
890: END delete_row;
891:
892:
893: END igs_ad_panel_membrs_pkg;