APPS.IGS_OR_FUNC_FLTR_PKG dependencies on IGS_OR_FUNC_FLTR

Line 1: PACKAGE BODY igs_or_func_fltr_pkg AS

1: PACKAGE BODY igs_or_func_fltr_pkg AS
2: /* $Header: IGSOI33B.pls 115.2 2002/11/29 01:45:13 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_func_fltr%ROWTYPE;

Line 5: old_references igs_or_func_fltr%ROWTYPE;

1: PACKAGE BODY igs_or_func_fltr_pkg AS
2: /* $Header: IGSOI33B.pls 115.2 2002/11/29 01:45:13 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_func_fltr%ROWTYPE;
6: new_references igs_or_func_fltr%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_or_func_fltr%ROWTYPE;

2: /* $Header: IGSOI33B.pls 115.2 2002/11/29 01:45:13 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_func_fltr%ROWTYPE;
6: new_references igs_or_func_fltr%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM igs_or_func_fltr

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

Line 174: FROM igs_or_func_fltr

170: || (reverse chronological order - newest change first)
171: */
172: CURSOR cur_rowid IS
173: SELECT rowid
174: FROM igs_or_func_fltr
175: WHERE func_fltr_id = x_func_fltr_id
176: FOR UPDATE NOWAIT;
177:
178: lv_rowid cur_rowid%RowType;

Line 211: FROM igs_or_func_fltr

207: || (reverse chronological order - newest change first)
208: */
209: CURSOR cur_rowid IS
210: SELECT rowid
211: FROM igs_or_func_fltr
212: WHERE func_code = x_func_code
213: AND attr_type = x_attr_type
214: AND attr_val = x_attr_val
215: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 241: FROM igs_or_func_fltr

237: ) AS
238:
239: CURSOR attr_type_cur IS
240: SELECT COUNT(DISTINCT attr_type)
241: FROM igs_or_func_fltr
242: WHERE func_code = new_references.func_code;
243:
244: l_count NUMBER(2);
245:

Line 412: INSERT INTO igs_or_func_fltr (

408: x_last_updated_by => x_last_updated_by,
409: x_last_update_login => x_last_update_login
410: );
411:
412: INSERT INTO igs_or_func_fltr (
413: func_fltr_id,
414: func_code,
415: attr_type,
416: attr_val,

Line 425: igs_or_func_fltr_s.NEXTVAL,

421: last_update_date,
422: last_updated_by,
423: last_update_login
424: ) VALUES (
425: igs_or_func_fltr_s.NEXTVAL,
426: new_references.func_code,
427: new_references.attr_type,
428: new_references.attr_val,
429: new_references.attr_val_desc,

Line 466: FROM igs_or_func_fltr

462: attr_type,
463: attr_val,
464: attr_val_desc,
465: inst_org_val
466: FROM igs_or_func_fltr
467: WHERE rowid = x_rowid
468: FOR UPDATE NOWAIT;
469:
470: tlinfo c1%ROWTYPE;

Line 564: UPDATE igs_or_func_fltr

560: x_last_updated_by => x_last_updated_by,
561: x_last_update_login => x_last_update_login
562: );
563:
564: UPDATE igs_or_func_fltr
565: SET
566: func_code = new_references.func_code,
567: attr_type = new_references.attr_type,
568: attr_val = new_references.attr_val,

Line 604: FROM igs_or_func_fltr

600: || (reverse chronological order - newest change first)
601: */
602: CURSOR c1 IS
603: SELECT rowid
604: FROM igs_or_func_fltr
605: WHERE func_fltr_id = x_func_fltr_id;
606:
607: BEGIN
608:

Line 661: DELETE FROM igs_or_func_fltr

657: p_action => 'DELETE',
658: x_rowid => x_rowid
659: );
660:
661: DELETE FROM igs_or_func_fltr
662: WHERE rowid = x_rowid;
663:
664: IF (SQL%NOTFOUND) THEN
665: RAISE NO_DATA_FOUND;

Line 671: END igs_or_func_fltr_pkg;

667:
668: END delete_row;
669:
670:
671: END igs_or_func_fltr_pkg;