APPS.IGW_BUSINESS_RULE_LINES_PKG dependencies on IGW_BUSINESS_RULE_LINES

Line 1: package body IGW_BUSINESS_RULE_LINES_PKG as

1: package body IGW_BUSINESS_RULE_LINES_PKG as
2: /* $Header: igwstrlb.pls 115.3 2002/03/28 19:14:12 pkm ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out VARCHAR2,
5: X_RULE_ID in NUMBER,

Line 18: cursor C is select ROWID from IGW_BUSINESS_RULE_LINES

14: X_RBRACKETS in VARCHAR2,
15: X_LOGICAL_OPERATOR in VARCHAR2,
16: X_MODE in VARCHAR2 default 'R'
17: ) is
18: cursor C is select ROWID from IGW_BUSINESS_RULE_LINES
19: where RULE_ID = X_RULE_ID
20: and EXPRESSION_ID = X_EXPRESSION_ID;
21: X_LAST_UPDATE_DATE DATE;
22: X_LAST_UPDATED_BY NUMBER;

Line 42: insert into IGW_BUSINESS_RULE_LINES (

38: else
39: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
40: app_exception.raise_exception;
41: end if;
42: insert into IGW_BUSINESS_RULE_LINES (
43: RULE_ID,
44: EXPRESSION_ID,
45: EXPRESSION_SEQUENCE_NUMBER,
46: EXPRESSION_TYPE,

Line 103: from IGW_BUSINESS_RULE_LINES

99: X_RBRACKETS in VARCHAR2,
100: X_LOGICAL_OPERATOR in VARCHAR2
101: ) is
102: cursor c1 is select *
103: from IGW_BUSINESS_RULE_LINES
104: where ROWID = X_ROWID
105: for update of RULE_ID nowait;
106: tlinfo c1%rowtype;
107:

Line 184: update IGW_BUSINESS_RULE_LINES set

180: else
181: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
182: app_exception.raise_exception;
183: end if;
184: update IGW_BUSINESS_RULE_LINES set
185: RULE_ID = X_RULE_ID,
186: EXPRESSION_ID = X_EXPRESSION_ID,
187: EXPRESSION_SEQUENCE_NUMBER = X_EXPRESSION_SEQUENCE_NUMBER,
188: EXPRESSION_TYPE = X_EXPRESSION_TYPE,

Line 221: cursor c1 is select rowid from IGW_BUSINESS_RULE_LINES

217: X_RBRACKETS in VARCHAR2,
218: X_LOGICAL_OPERATOR in VARCHAR2,
219: X_MODE in VARCHAR2 default 'R'
220: ) is
221: cursor c1 is select rowid from IGW_BUSINESS_RULE_LINES
222: where RULE_ID = X_RULE_ID
223: and EXPRESSION_ID = X_EXPRESSION_ID
224: ;
225: dummy c1%rowtype;

Line 267: delete from IGW_BUSINESS_RULE_LINES

263: procedure DELETE_ROW (
264: X_ROWID in VARCHAR2
265: ) is
266: begin
267: delete from IGW_BUSINESS_RULE_LINES
268: where ROWID = X_ROWID;
269: if (sql%notfound) then
270: raise no_data_found;
271: end if;

Line 274: end IGW_BUSINESS_RULE_LINES_PKG;

270: raise no_data_found;
271: end if;
272: end DELETE_ROW;
273:
274: end IGW_BUSINESS_RULE_LINES_PKG;