APPS.IGS_EN_UNIT_SET_RULE_PKG dependencies on IGS_EN_UNIT_SET_RULE

Line 1: package body IGS_EN_UNIT_SET_RULE_PKG as

1: package body IGS_EN_UNIT_SET_RULE_PKG as
2: /* $Header: IGSEI12B.pls 115.4 2002/11/28 23:34:02 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_UNIT_SET_RULE%RowType;
5: new_references IGS_EN_UNIT_SET_RULE%RowType;

Line 4: old_references IGS_EN_UNIT_SET_RULE%RowType;

1: package body IGS_EN_UNIT_SET_RULE_PKG as
2: /* $Header: IGSEI12B.pls 115.4 2002/11/28 23:34:02 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_UNIT_SET_RULE%RowType;
5: new_references IGS_EN_UNIT_SET_RULE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_EN_UNIT_SET_RULE%RowType;

1: package body IGS_EN_UNIT_SET_RULE_PKG as
2: /* $Header: IGSEI12B.pls 115.4 2002/11/28 23:34:02 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_UNIT_SET_RULE%RowType;
5: new_references IGS_EN_UNIT_SET_RULE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_EN_UNIT_SET_RULE

19: )AS
20:
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_EN_UNIT_SET_RULE
24: WHERE rowid = x_rowid;
25:
26: BEGIN
27:

Line 64: -- ON IGS_EN_UNIT_SET_RULE

60:
61: -- Trigger description :-
62: -- "OSS_TST".trg_usr_br_iud
63: -- BEFORE INSERT OR DELETE OR UPDATE
64: -- ON IGS_EN_UNIT_SET_RULE
65: -- FOR EACH ROW
66:
67: PROCEDURE BeforeRowInsertUpdateDelete1(
68: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 218: FROM IGS_EN_UNIT_SET_RULE

214: ) RETURN BOOLEAN AS
215:
216: CURSOR cur_rowid IS
217: SELECT rowid
218: FROM IGS_EN_UNIT_SET_RULE
219: WHERE unit_set_cd = x_unit_set_cd
220: AND version_number = x_version_number
221: AND s_rule_call_cd = x_s_rule_call_cd
222: FOR UPDATE NOWAIT;

Line 246: FROM IGS_EN_UNIT_SET_RULE

242: ) AS
243:
244: CURSOR cur_rowid IS
245: SELECT rowid
246: FROM IGS_EN_UNIT_SET_RULE
247: WHERE rul_sequence_number = x_sequence_number ;
248:
249: lv_rowid cur_rowid%RowType;
250:

Line 272: FROM IGS_EN_UNIT_SET_RULE

268: ) AS
269:
270: CURSOR cur_rowid IS
271: SELECT rowid
272: FROM IGS_EN_UNIT_SET_RULE
273: WHERE s_rule_call_cd = x_s_rule_call_cd ;
274:
275: lv_rowid cur_rowid%RowType;
276:

Line 299: FROM IGS_EN_UNIT_SET_RULE

295: )AS
296:
297: CURSOR cur_rowid IS
298: SELECT rowid
299: FROM IGS_EN_UNIT_SET_RULE
300: WHERE unit_set_cd = x_unit_set_cd
301: AND version_number = x_version_number ;
302:
303: lv_rowid cur_rowid%RowType;

Line 419: cursor C is select ROWID from IGS_EN_UNIT_SET_RULE

415: X_S_RULE_CALL_CD in VARCHAR2,
416: X_RUL_SEQUENCE_NUMBER in NUMBER,
417: X_MODE in VARCHAR2 default 'R'
418: ) AS
419: cursor C is select ROWID from IGS_EN_UNIT_SET_RULE
420: where UNIT_SET_CD = X_UNIT_SET_CD
421: and VERSION_NUMBER = X_VERSION_NUMBER
422: and S_RULE_CALL_CD = X_S_RULE_CALL_CD;
423: X_LAST_UPDATE_DATE DATE;

Line 458: insert into IGS_EN_UNIT_SET_RULE (

454: x_last_update_date => X_LAST_UPDATE_DATE,
455: x_last_updated_by => X_LAST_UPDATED_BY,
456: x_last_update_login => X_LAST_UPDATE_LOGIN
457: );
458: insert into IGS_EN_UNIT_SET_RULE (
459: UNIT_SET_CD,
460: VERSION_NUMBER,
461: S_RULE_CALL_CD,
462: RUL_SEQUENCE_NUMBER,

Line 502: from IGS_EN_UNIT_SET_RULE

498: X_RUL_SEQUENCE_NUMBER in NUMBER
499: ) AS
500: cursor c1 is select
501: RUL_SEQUENCE_NUMBER
502: from IGS_EN_UNIT_SET_RULE
503: where ROWID = X_ROWID
504: for update nowait;
505: tlinfo c1%rowtype;
506:

Line 573: update IGS_EN_UNIT_SET_RULE set

569: x_last_update_date => X_LAST_UPDATE_DATE,
570: x_last_updated_by => X_LAST_UPDATED_BY,
571: x_last_update_login => X_LAST_UPDATE_LOGIN
572: );
573: update IGS_EN_UNIT_SET_RULE set
574: RUL_SEQUENCE_NUMBER = NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
575: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
576: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
577: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 597: cursor c1 is select rowid from IGS_EN_UNIT_SET_RULE

593: X_S_RULE_CALL_CD in VARCHAR2,
594: X_RUL_SEQUENCE_NUMBER in NUMBER,
595: X_MODE in VARCHAR2 default 'R'
596: ) AS
597: cursor c1 is select rowid from IGS_EN_UNIT_SET_RULE
598: where UNIT_SET_CD = X_UNIT_SET_CD
599: and VERSION_NUMBER = X_VERSION_NUMBER
600: and S_RULE_CALL_CD = X_S_RULE_CALL_CD
601: ;

Line 634: delete from IGS_EN_UNIT_SET_RULE

630: Before_DML (
631: p_action => 'DELETE',
632: x_rowid => X_ROWID
633: );
634: delete from IGS_EN_UNIT_SET_RULE
635: where ROWID = X_ROWID;
636: if (sql%notfound) then
637: raise no_data_found;
638: end if;

Line 645: end IGS_EN_UNIT_SET_RULE_PKG;

641: x_rowid => X_ROWID
642: );
643: end DELETE_ROW;
644:
645: end IGS_EN_UNIT_SET_RULE_PKG;