APPS.IGS_AD_DSCP_ATTR_PKG dependencies on IGS_AD_DSCP_ATTR

Line 1: PACKAGE BODY igs_ad_dscp_attr_pkg AS

1: PACKAGE BODY igs_ad_dscp_attr_pkg AS
2: /* $Header: IGSAIE1B.pls 115.5 2003/01/23 04:44:38 knag ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_dscp_attr%ROWTYPE;

Line 5: old_references igs_ad_dscp_attr%ROWTYPE;

1: PACKAGE BODY igs_ad_dscp_attr_pkg AS
2: /* $Header: IGSAIE1B.pls 115.5 2003/01/23 04:44:38 knag ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_dscp_attr%ROWTYPE;
6: new_references igs_ad_dscp_attr%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_dscp_attr%ROWTYPE;

2: /* $Header: IGSAIE1B.pls 115.5 2003/01/23 04:44:38 knag ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_dscp_attr%ROWTYPE;
6: new_references igs_ad_dscp_attr%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_AD_DSCP_ATTR

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

Line 139: FROM igs_ad_dscp_attr

135: || (reverse chronological order - newest change first)
136: */
137: CURSOR cur_rowid IS
138: SELECT rowid
139: FROM igs_ad_dscp_attr
140: WHERE discrepancy_attr_id = x_discrepancy_attr_id
141: FOR UPDATE NOWAIT;
142:
143: lv_rowid cur_rowid%RowType;

Line 175: FROM igs_ad_dscp_attr

171: || (reverse chronological order - newest change first)
172: */
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM igs_ad_dscp_attr
176: WHERE src_cat_id = x_src_cat_id
177: AND attribute_name = x_attribute_name
178: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
179:

Line 211: FROM igs_ad_dscp_attr

207: || (reverse chronological order - newest change first)
208: */
209: CURSOR cur_rowid IS
210: SELECT rowid
211: FROM igs_ad_dscp_attr
212: WHERE ((src_cat_id = x_src_cat_id));
213:
214: lv_rowid cur_rowid%RowType;
215:

Line 324: FROM igs_ad_dscp_attr

320: || (reverse chronological order - newest change first)
321: */
322: CURSOR c IS
323: SELECT rowid
324: FROM igs_ad_dscp_attr
325: WHERE discrepancy_attr_id = x_discrepancy_attr_id;
326:
327: x_last_update_date DATE;
328: x_last_updated_by NUMBER;

Line 367: INSERT INTO igs_ad_dscp_attr (

363: x_last_updated_by => x_last_updated_by,
364: x_last_update_login => x_last_update_login
365: );
366:
367: INSERT INTO igs_ad_dscp_attr (
368: discrepancy_attr_id,
369: src_cat_id,
370: attribute_name,
371: discrepancy_rule_cd,

Line 378: IGS_AD_DSCP_ATTR_S.NEXTVAL,

374: last_update_date,
375: last_updated_by,
376: last_update_login
377: ) VALUES (
378: IGS_AD_DSCP_ATTR_S.NEXTVAL,
379: new_references.src_cat_id,
380: new_references.attribute_name,
381: new_references.discrepancy_rule_cd,
382: x_last_update_date,

Line 421: FROM igs_ad_dscp_attr

417: SELECT
418: src_cat_id,
419: attribute_name,
420: discrepancy_rule_cd
421: FROM igs_ad_dscp_attr
422: WHERE rowid = x_rowid
423: FOR UPDATE NOWAIT;
424:
425: tlinfo c1%ROWTYPE;

Line 513: UPDATE igs_ad_dscp_attr

509: x_last_updated_by => x_last_updated_by,
510: x_last_update_login => x_last_update_login
511: );
512:
513: UPDATE igs_ad_dscp_attr
514: SET
515: src_cat_id = new_references.src_cat_id,
516: attribute_name = new_references.attribute_name,
517: discrepancy_rule_cd = new_references.discrepancy_rule_cd,

Line 549: FROM igs_ad_dscp_attr

545: || (reverse chronological order - newest change first)
546: */
547: CURSOR c1 IS
548: SELECT rowid
549: FROM igs_ad_dscp_attr
550: WHERE discrepancy_attr_id = x_discrepancy_attr_id;
551:
552: BEGIN
553:

Line 602: DELETE FROM igs_ad_dscp_attr

598: p_action => 'DELETE',
599: x_rowid => x_rowid
600: );
601:
602: DELETE FROM igs_ad_dscp_attr
603: WHERE rowid = x_rowid;
604:
605: IF (SQL%NOTFOUND) THEN
606: RAISE NO_DATA_FOUND;

Line 612: END igs_ad_dscp_attr_pkg;

608:
609: END delete_row;
610:
611:
612: END igs_ad_dscp_attr_pkg;