eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_RULE_DFF_PKG dependencies on DBMS_SQL

Line 42: source_cursor := dbms_sql.open_cursor;

38: g_is_use_instance := FUN_RULE_UTILITY_PKG.IS_USE_INSTANCE(X_RULE_OBJECT_ID);
39:
40: -- Prepare a cursor to select from the source table:
41:
42: source_cursor := dbms_sql.open_cursor;
43: DBMS_SQL.PARSE(source_cursor,
44: 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID' ,
45: DBMS_SQL.native);
46: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

Line 43: DBMS_SQL.PARSE(source_cursor,

39:
40: -- Prepare a cursor to select from the source table:
41:
42: source_cursor := dbms_sql.open_cursor;
43: DBMS_SQL.PARSE(source_cursor,
44: 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID' ,
45: DBMS_SQL.native);
46: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
47:

Line 45: DBMS_SQL.native);

41:
42: source_cursor := dbms_sql.open_cursor;
43: DBMS_SQL.PARSE(source_cursor,
44: 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID' ,
45: DBMS_SQL.native);
46: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
47:
48: if(g_is_use_instance) then
49: DBMS_SQL.PARSE(source_cursor,

Line 46: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

42: source_cursor := dbms_sql.open_cursor;
43: DBMS_SQL.PARSE(source_cursor,
44: 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID' ,
45: DBMS_SQL.native);
46: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
47:
48: if(g_is_use_instance) then
49: DBMS_SQL.PARSE(source_cursor,
50: 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID' ,

Line 49: DBMS_SQL.PARSE(source_cursor,

45: DBMS_SQL.native);
46: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
47:
48: if(g_is_use_instance) then
49: DBMS_SQL.PARSE(source_cursor,
50: 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID' ,
51: DBMS_SQL.native);
52: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
53: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

Line 51: DBMS_SQL.native);

47:
48: if(g_is_use_instance) then
49: DBMS_SQL.PARSE(source_cursor,
50: 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID' ,
51: DBMS_SQL.native);
52: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
53: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
54: end if;
55:

Line 52: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

48: if(g_is_use_instance) then
49: DBMS_SQL.PARSE(source_cursor,
50: 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID' ,
51: DBMS_SQL.native);
52: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
53: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
54: end if;
55:
56:

Line 53: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

49: DBMS_SQL.PARSE(source_cursor,
50: 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID' ,
51: DBMS_SQL.native);
52: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
53: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
54: end if;
55:
56:
57: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);

Line 57: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);

53: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
54: end if;
55:
56:
57: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
58: ignore := DBMS_SQL.EXECUTE(source_cursor);
59:
60: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
61: -- get column values of the row

Line 58: ignore := DBMS_SQL.EXECUTE(source_cursor);

54: end if;
55:
56:
57: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
58: ignore := DBMS_SQL.EXECUTE(source_cursor);
59:
60: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
61: -- get column values of the row
62: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

Line 60: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

56:
57: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
58: ignore := DBMS_SQL.EXECUTE(source_cursor);
59:
60: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
61: -- get column values of the row
62: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
63: END IF;
64:

Line 62: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

58: ignore := DBMS_SQL.EXECUTE(source_cursor);
59:
60: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
61: -- get column values of the row
62: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
63: END IF;
64:
65: IF (l_num = 0) THEN
66: FUN_RULE_DFF_PKG.Insert_Row (

Line 110: DBMS_SQL.CLOSE_CURSOR(source_cursor);

106: X_RULE_OBJECT_ID);
107:
108: END IF;
109: COMMIT;
110: DBMS_SQL.CLOSE_CURSOR(source_cursor);
111:
112: END;
113:
114: PROCEDURE Insert_Row (

Line 147: destination_cursor := DBMS_SQL.OPEN_CURSOR;

143: * Construct the dynamic SQL to use RULE_OBJECT_ID depending on if the Rule Object
144: * uses Instances or not.
145: */
146: -- Prepare a cursor to insert into the destination table:
147: destination_cursor := DBMS_SQL.OPEN_CURSOR;
148: if(g_is_use_instance) then
149: DBMS_SQL.PARSE(destination_cursor,
150: 'INSERT INTO ' || X_TABLE_NAME ||' ( '||
151: ' RULE_DETAIL_ID, '||

Line 149: DBMS_SQL.PARSE(destination_cursor,

145: */
146: -- Prepare a cursor to insert into the destination table:
147: destination_cursor := DBMS_SQL.OPEN_CURSOR;
148: if(g_is_use_instance) then
149: DBMS_SQL.PARSE(destination_cursor,
150: 'INSERT INTO ' || X_TABLE_NAME ||' ( '||
151: ' RULE_DETAIL_ID, '||
152: ' ATTRIBUTE_CATEGORY, '||
153: ' ATTRIBUTE1, '||

Line 199: DBMS_SQL.native);

195: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
196: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
197: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY, '||
198: ' :X_RULE_OBJECT_ID )',
199: DBMS_SQL.native);
200: else
201: DBMS_SQL.PARSE(destination_cursor,
202: 'INSERT INTO ' || X_TABLE_NAME ||' ( '||
203: ' RULE_DETAIL_ID, '||

Line 201: DBMS_SQL.PARSE(destination_cursor,

197: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY, '||
198: ' :X_RULE_OBJECT_ID )',
199: DBMS_SQL.native);
200: else
201: DBMS_SQL.PARSE(destination_cursor,
202: 'INSERT INTO ' || X_TABLE_NAME ||' ( '||
203: ' RULE_DETAIL_ID, '||
204: ' ATTRIBUTE_CATEGORY, '||
205: ' ATTRIBUTE1, '||

Line 249: DBMS_SQL.native);

245: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
246: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
247: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
248: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY )',
249: DBMS_SQL.native);
250: end if;
251:
252: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
253: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);

Line 252: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

248: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY )',
249: DBMS_SQL.native);
250: end if;
251:
252: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
253: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
254: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
255: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
256: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);

Line 253: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);

249: DBMS_SQL.native);
250: end if;
251:
252: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
253: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
254: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
255: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
256: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
257: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);

Line 254: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);

250: end if;
251:
252: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
253: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
254: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
255: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
256: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
257: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
258: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);

Line 255: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);

251:
252: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
253: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
254: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
255: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
256: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
257: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
258: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
259: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);

Line 256: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);

252: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
253: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
254: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
255: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
256: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
257: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
258: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
259: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
260: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);

Line 257: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);

253: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
254: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
255: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
256: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
257: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
258: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
259: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
260: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
261: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);

Line 258: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);

254: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
255: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
256: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
257: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
258: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
259: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
260: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
261: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
262: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);

Line 259: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);

255: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
256: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
257: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
258: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
259: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
260: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
261: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
262: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
263: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);

Line 260: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);

256: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
257: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
258: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
259: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
260: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
261: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
262: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
263: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
264: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);

Line 261: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);

257: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
258: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
259: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
260: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
261: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
262: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
263: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
264: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
265: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);

Line 262: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);

258: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
259: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
260: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
261: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
262: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
263: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
264: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
265: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
266: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);

Line 263: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);

259: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
260: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
261: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
262: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
263: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
264: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
265: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
266: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
267: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);

Line 264: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);

260: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
261: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
262: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
263: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
264: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
265: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
266: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
267: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
268: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);

Line 265: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);

261: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
262: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
263: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
264: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
265: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
266: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
267: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
268: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
269:

Line 266: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);

262: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
263: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
264: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
265: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
266: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
267: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
268: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
269:
270: if(g_is_use_instance) then

Line 267: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);

263: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
264: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
265: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
266: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
267: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
268: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
269:
270: if(g_is_use_instance) then
271: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

Line 268: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);

264: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
265: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
266: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
267: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
268: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
269:
270: if(g_is_use_instance) then
271: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
272: end if;

Line 271: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

267: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
268: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
269:
270: if(g_is_use_instance) then
271: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
272: end if;
273:
274: ignore := DBMS_SQL.EXECUTE(destination_cursor);
275: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

Line 274: ignore := DBMS_SQL.EXECUTE(destination_cursor);

270: if(g_is_use_instance) then
271: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
272: end if;
273:
274: ignore := DBMS_SQL.EXECUTE(destination_cursor);
275: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
276:
277:
278: EXCEPTION

Line 275: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

271: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
272: end if;
273:
274: ignore := DBMS_SQL.EXECUTE(destination_cursor);
275: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
276:
277:
278: EXCEPTION
279: WHEN OTHERS THEN

Line 280: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

276:
277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
281: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
282: END IF;
283: RAISE;
284:

Line 281: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
281: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
282: END IF;
283: RAISE;
284:
285: END Insert_Row;

Line 320: destination_cursor := DBMS_SQL.OPEN_CURSOR;

316: * uses Instances or not.
317: */
318:
319: -- Prepare a cursor to insert into the destination table:
320: destination_cursor := DBMS_SQL.OPEN_CURSOR;
321: if(g_is_use_instance) then
322: DBMS_SQL.PARSE(destination_cursor,
323: 'UPDATE ' || X_TABLE_NAME ||' SET '||
324: ' ATTRIBUTE_CATEGORY = :X_ATTRIBUTE_CATEGORY, '||

Line 322: DBMS_SQL.PARSE(destination_cursor,

318:
319: -- Prepare a cursor to insert into the destination table:
320: destination_cursor := DBMS_SQL.OPEN_CURSOR;
321: if(g_is_use_instance) then
322: DBMS_SQL.PARSE(destination_cursor,
323: 'UPDATE ' || X_TABLE_NAME ||' SET '||
324: ' ATTRIBUTE_CATEGORY = :X_ATTRIBUTE_CATEGORY, '||
325: ' ATTRIBUTE1 = :X_ATTRIBUTE1, '||
326: ' ATTRIBUTE2 = :X_ATTRIBUTE2, '||

Line 346: DBMS_SQL.native);

342: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
343: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
344: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
345: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
346: DBMS_SQL.native);
347: else
348: DBMS_SQL.PARSE(destination_cursor,
349: 'UPDATE ' || X_TABLE_NAME ||' SET '||
350: ' ATTRIBUTE_CATEGORY = :X_ATTRIBUTE_CATEGORY, '||

Line 348: DBMS_SQL.PARSE(destination_cursor,

344: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
345: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
346: DBMS_SQL.native);
347: else
348: DBMS_SQL.PARSE(destination_cursor,
349: 'UPDATE ' || X_TABLE_NAME ||' SET '||
350: ' ATTRIBUTE_CATEGORY = :X_ATTRIBUTE_CATEGORY, '||
351: ' ATTRIBUTE1 = :X_ATTRIBUTE1, '||
352: ' ATTRIBUTE2 = :X_ATTRIBUTE2, '||

Line 372: DBMS_SQL.native);

368: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
369: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
370: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
371: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
372: DBMS_SQL.native);
373: end if;
374:
375:
376: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);

Line 376: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);

372: DBMS_SQL.native);
373: end if;
374:
375:
376: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
377: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
378: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
379: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
380: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);

Line 377: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);

373: end if;
374:
375:
376: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
377: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
378: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
379: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
380: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
381: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);

Line 378: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);

374:
375:
376: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
377: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
378: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
379: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
380: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
381: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
382: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);

Line 379: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);

375:
376: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
377: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
378: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
379: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
380: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
381: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
382: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
383: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);

Line 380: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);

376: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE_CATEGORY', X_ATTRIBUTE_CATEGORY);
377: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
378: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
379: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
380: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
381: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
382: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
383: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
384: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);

Line 381: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);

377: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE1', X_ATTRIBUTE1);
378: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
379: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
380: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
381: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
382: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
383: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
384: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
385: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);

Line 382: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);

378: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE2', X_ATTRIBUTE2);
379: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
380: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
381: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
382: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
383: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
384: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
385: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
386: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);

Line 383: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);

379: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE3', X_ATTRIBUTE3);
380: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
381: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
382: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
383: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
384: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
385: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
386: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
387: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);

Line 384: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);

380: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE4', X_ATTRIBUTE4);
381: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
382: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
383: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
384: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
385: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
386: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
387: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
388: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);

Line 385: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);

381: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE5', X_ATTRIBUTE5);
382: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
383: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
384: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
385: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
386: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
387: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
388: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
389: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);

Line 386: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);

382: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE6', X_ATTRIBUTE6);
383: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
384: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
385: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
386: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
387: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
388: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
389: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
390: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);

Line 387: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);

383: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE7', X_ATTRIBUTE7);
384: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
385: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
386: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
387: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
388: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
389: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
390: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
391: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);

Line 388: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);

384: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE8', X_ATTRIBUTE8);
385: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
386: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
387: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
388: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
389: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
390: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
391: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
392: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

Line 389: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);

385: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE9', X_ATTRIBUTE9);
386: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
387: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
388: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
389: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
390: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
391: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
392: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
393:

Line 390: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);

386: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE10', X_ATTRIBUTE10);
387: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
388: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
389: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
390: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
391: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
392: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
393:
394: if(g_is_use_instance) then

Line 391: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);

387: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE11', X_ATTRIBUTE11);
388: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
389: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
390: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
391: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
392: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
393:
394: if(g_is_use_instance) then
395: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

Line 392: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

388: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE12', X_ATTRIBUTE12);
389: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE13', X_ATTRIBUTE13);
390: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE14', X_ATTRIBUTE14);
391: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
392: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
393:
394: if(g_is_use_instance) then
395: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
396: end if;

Line 395: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

391: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_ATTRIBUTE15', X_ATTRIBUTE15);
392: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
393:
394: if(g_is_use_instance) then
395: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
396: end if;
397:
398:
399: ignore := DBMS_SQL.EXECUTE(destination_cursor);

Line 399: ignore := DBMS_SQL.EXECUTE(destination_cursor);

395: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
396: end if;
397:
398:
399: ignore := DBMS_SQL.EXECUTE(destination_cursor);
400: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
401:
402: EXCEPTION
403: WHEN OTHERS THEN

Line 400: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

396: end if;
397:
398:
399: ignore := DBMS_SQL.EXECUTE(destination_cursor);
400: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

Line 404: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

400: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
405: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
406: END IF;
407: RAISE;
408:

Line 405: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
405: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
406: END IF;
407: RAISE;
408:
409: END Update_Row;

Line 593: source_cursor := dbms_sql.open_cursor;

589: BEGIN
590:
591: -- Prepare a cursor to select from the source table:
592:
593: source_cursor := dbms_sql.open_cursor;
594: if(g_is_use_instance) then
595: DBMS_SQL.PARSE(source_cursor,
596: 'SELECT * FROM '|| X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID FOR UPDATE NOWAIT',
597: DBMS_SQL.native);

Line 595: DBMS_SQL.PARSE(source_cursor,

591: -- Prepare a cursor to select from the source table:
592:
593: source_cursor := dbms_sql.open_cursor;
594: if(g_is_use_instance) then
595: DBMS_SQL.PARSE(source_cursor,
596: 'SELECT * FROM '|| X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID FOR UPDATE NOWAIT',
597: DBMS_SQL.native);
598: else
599: DBMS_SQL.PARSE(source_cursor,

Line 597: DBMS_SQL.native);

593: source_cursor := dbms_sql.open_cursor;
594: if(g_is_use_instance) then
595: DBMS_SQL.PARSE(source_cursor,
596: 'SELECT * FROM '|| X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID FOR UPDATE NOWAIT',
597: DBMS_SQL.native);
598: else
599: DBMS_SQL.PARSE(source_cursor,
600: 'SELECT * FROM '|| X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID FOR UPDATE NOWAIT',
601: DBMS_SQL.native);

Line 599: DBMS_SQL.PARSE(source_cursor,

595: DBMS_SQL.PARSE(source_cursor,
596: 'SELECT * FROM '|| X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID FOR UPDATE NOWAIT',
597: DBMS_SQL.native);
598: else
599: DBMS_SQL.PARSE(source_cursor,
600: 'SELECT * FROM '|| X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID FOR UPDATE NOWAIT',
601: DBMS_SQL.native);
602: end if;
603:

Line 601: DBMS_SQL.native);

597: DBMS_SQL.native);
598: else
599: DBMS_SQL.PARSE(source_cursor,
600: 'SELECT * FROM '|| X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID FOR UPDATE NOWAIT',
601: DBMS_SQL.native);
602: end if;
603:
604: if(g_is_use_instance) then
605: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

Line 605: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

601: DBMS_SQL.native);
602: end if;
603:
604: if(g_is_use_instance) then
605: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
606: end if;
607:
608: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
609:

Line 608: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

604: if(g_is_use_instance) then
605: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
606: end if;
607:
608: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
609:
610: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, RULE_DETAIL_ID);
611: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, ATTRIBUTE_CATEGORY, 150);
612: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, ATTRIBUTE1,150);

Line 610: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, RULE_DETAIL_ID);

606: end if;
607:
608: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
609:
610: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, RULE_DETAIL_ID);
611: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, ATTRIBUTE_CATEGORY, 150);
612: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, ATTRIBUTE1,150);
613: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, ATTRIBUTE2,150);
614: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, ATTRIBUTE3,150);

Line 611: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, ATTRIBUTE_CATEGORY, 150);

607:
608: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
609:
610: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, RULE_DETAIL_ID);
611: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, ATTRIBUTE_CATEGORY, 150);
612: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, ATTRIBUTE1,150);
613: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, ATTRIBUTE2,150);
614: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, ATTRIBUTE3,150);
615: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, ATTRIBUTE4,150);

Line 612: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, ATTRIBUTE1,150);

608: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
609:
610: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, RULE_DETAIL_ID);
611: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, ATTRIBUTE_CATEGORY, 150);
612: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, ATTRIBUTE1,150);
613: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, ATTRIBUTE2,150);
614: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, ATTRIBUTE3,150);
615: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, ATTRIBUTE4,150);
616: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, ATTRIBUTE5,150);

Line 613: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, ATTRIBUTE2,150);

609:
610: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, RULE_DETAIL_ID);
611: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, ATTRIBUTE_CATEGORY, 150);
612: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, ATTRIBUTE1,150);
613: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, ATTRIBUTE2,150);
614: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, ATTRIBUTE3,150);
615: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, ATTRIBUTE4,150);
616: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, ATTRIBUTE5,150);
617: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, ATTRIBUTE6,150);

Line 614: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, ATTRIBUTE3,150);

610: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, RULE_DETAIL_ID);
611: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, ATTRIBUTE_CATEGORY, 150);
612: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, ATTRIBUTE1,150);
613: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, ATTRIBUTE2,150);
614: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, ATTRIBUTE3,150);
615: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, ATTRIBUTE4,150);
616: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, ATTRIBUTE5,150);
617: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, ATTRIBUTE6,150);
618: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, ATTRIBUTE7,150);

Line 615: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, ATTRIBUTE4,150);

611: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, ATTRIBUTE_CATEGORY, 150);
612: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, ATTRIBUTE1,150);
613: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, ATTRIBUTE2,150);
614: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, ATTRIBUTE3,150);
615: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, ATTRIBUTE4,150);
616: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, ATTRIBUTE5,150);
617: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, ATTRIBUTE6,150);
618: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, ATTRIBUTE7,150);
619: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,ATTRIBUTE8,150);

Line 616: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, ATTRIBUTE5,150);

612: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, ATTRIBUTE1,150);
613: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, ATTRIBUTE2,150);
614: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, ATTRIBUTE3,150);
615: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, ATTRIBUTE4,150);
616: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, ATTRIBUTE5,150);
617: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, ATTRIBUTE6,150);
618: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, ATTRIBUTE7,150);
619: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,ATTRIBUTE8,150);
620: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,ATTRIBUTE9,150);

Line 617: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, ATTRIBUTE6,150);

613: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, ATTRIBUTE2,150);
614: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, ATTRIBUTE3,150);
615: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, ATTRIBUTE4,150);
616: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, ATTRIBUTE5,150);
617: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, ATTRIBUTE6,150);
618: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, ATTRIBUTE7,150);
619: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,ATTRIBUTE8,150);
620: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,ATTRIBUTE9,150);
621: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,ATTRIBUTE10,150);

Line 618: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, ATTRIBUTE7,150);

614: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, ATTRIBUTE3,150);
615: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, ATTRIBUTE4,150);
616: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, ATTRIBUTE5,150);
617: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, ATTRIBUTE6,150);
618: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, ATTRIBUTE7,150);
619: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,ATTRIBUTE8,150);
620: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,ATTRIBUTE9,150);
621: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,ATTRIBUTE10,150);
622: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,ATTRIBUTE11,150);

Line 619: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,ATTRIBUTE8,150);

615: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, ATTRIBUTE4,150);
616: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, ATTRIBUTE5,150);
617: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, ATTRIBUTE6,150);
618: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, ATTRIBUTE7,150);
619: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,ATTRIBUTE8,150);
620: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,ATTRIBUTE9,150);
621: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,ATTRIBUTE10,150);
622: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,ATTRIBUTE11,150);
623: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,ATTRIBUTE12,150);

Line 620: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,ATTRIBUTE9,150);

616: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, ATTRIBUTE5,150);
617: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, ATTRIBUTE6,150);
618: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, ATTRIBUTE7,150);
619: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,ATTRIBUTE8,150);
620: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,ATTRIBUTE9,150);
621: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,ATTRIBUTE10,150);
622: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,ATTRIBUTE11,150);
623: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,ATTRIBUTE12,150);
624: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,ATTRIBUTE13,150);

Line 621: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,ATTRIBUTE10,150);

617: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, ATTRIBUTE6,150);
618: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, ATTRIBUTE7,150);
619: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,ATTRIBUTE8,150);
620: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,ATTRIBUTE9,150);
621: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,ATTRIBUTE10,150);
622: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,ATTRIBUTE11,150);
623: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,ATTRIBUTE12,150);
624: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,ATTRIBUTE13,150);
625: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,ATTRIBUTE14,150);

Line 622: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,ATTRIBUTE11,150);

618: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, ATTRIBUTE7,150);
619: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,ATTRIBUTE8,150);
620: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,ATTRIBUTE9,150);
621: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,ATTRIBUTE10,150);
622: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,ATTRIBUTE11,150);
623: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,ATTRIBUTE12,150);
624: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,ATTRIBUTE13,150);
625: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,ATTRIBUTE14,150);
626: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,ATTRIBUTE15,150);

Line 623: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,ATTRIBUTE12,150);

619: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,ATTRIBUTE8,150);
620: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,ATTRIBUTE9,150);
621: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,ATTRIBUTE10,150);
622: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,ATTRIBUTE11,150);
623: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,ATTRIBUTE12,150);
624: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,ATTRIBUTE13,150);
625: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,ATTRIBUTE14,150);
626: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,ATTRIBUTE15,150);
627: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18,CREATED_BY);

Line 624: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,ATTRIBUTE13,150);

620: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,ATTRIBUTE9,150);
621: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,ATTRIBUTE10,150);
622: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,ATTRIBUTE11,150);
623: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,ATTRIBUTE12,150);
624: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,ATTRIBUTE13,150);
625: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,ATTRIBUTE14,150);
626: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,ATTRIBUTE15,150);
627: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18,CREATED_BY);
628: DBMS_SQL.DEFINE_COLUMN(source_cursor , 19,CREATION_DATE);

Line 625: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,ATTRIBUTE14,150);

621: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,ATTRIBUTE10,150);
622: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,ATTRIBUTE11,150);
623: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,ATTRIBUTE12,150);
624: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,ATTRIBUTE13,150);
625: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,ATTRIBUTE14,150);
626: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,ATTRIBUTE15,150);
627: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18,CREATED_BY);
628: DBMS_SQL.DEFINE_COLUMN(source_cursor , 19,CREATION_DATE);
629: DBMS_SQL.DEFINE_COLUMN(source_cursor , 20,LAST_UPDATE_LOGIN);

Line 626: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,ATTRIBUTE15,150);

622: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,ATTRIBUTE11,150);
623: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,ATTRIBUTE12,150);
624: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,ATTRIBUTE13,150);
625: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,ATTRIBUTE14,150);
626: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,ATTRIBUTE15,150);
627: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18,CREATED_BY);
628: DBMS_SQL.DEFINE_COLUMN(source_cursor , 19,CREATION_DATE);
629: DBMS_SQL.DEFINE_COLUMN(source_cursor , 20,LAST_UPDATE_LOGIN);
630: DBMS_SQL.DEFINE_COLUMN(source_cursor , 21,LAST_UPDATE_DATE);

Line 627: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18,CREATED_BY);

623: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,ATTRIBUTE12,150);
624: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,ATTRIBUTE13,150);
625: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,ATTRIBUTE14,150);
626: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,ATTRIBUTE15,150);
627: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18,CREATED_BY);
628: DBMS_SQL.DEFINE_COLUMN(source_cursor , 19,CREATION_DATE);
629: DBMS_SQL.DEFINE_COLUMN(source_cursor , 20,LAST_UPDATE_LOGIN);
630: DBMS_SQL.DEFINE_COLUMN(source_cursor , 21,LAST_UPDATE_DATE);
631: DBMS_SQL.DEFINE_COLUMN(source_cursor , 22,LAST_UPDATED_BY);

Line 628: DBMS_SQL.DEFINE_COLUMN(source_cursor , 19,CREATION_DATE);

624: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,ATTRIBUTE13,150);
625: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,ATTRIBUTE14,150);
626: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,ATTRIBUTE15,150);
627: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18,CREATED_BY);
628: DBMS_SQL.DEFINE_COLUMN(source_cursor , 19,CREATION_DATE);
629: DBMS_SQL.DEFINE_COLUMN(source_cursor , 20,LAST_UPDATE_LOGIN);
630: DBMS_SQL.DEFINE_COLUMN(source_cursor , 21,LAST_UPDATE_DATE);
631: DBMS_SQL.DEFINE_COLUMN(source_cursor , 22,LAST_UPDATED_BY);
632: if(g_is_use_instance) then

Line 629: DBMS_SQL.DEFINE_COLUMN(source_cursor , 20,LAST_UPDATE_LOGIN);

625: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,ATTRIBUTE14,150);
626: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,ATTRIBUTE15,150);
627: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18,CREATED_BY);
628: DBMS_SQL.DEFINE_COLUMN(source_cursor , 19,CREATION_DATE);
629: DBMS_SQL.DEFINE_COLUMN(source_cursor , 20,LAST_UPDATE_LOGIN);
630: DBMS_SQL.DEFINE_COLUMN(source_cursor , 21,LAST_UPDATE_DATE);
631: DBMS_SQL.DEFINE_COLUMN(source_cursor , 22,LAST_UPDATED_BY);
632: if(g_is_use_instance) then
633: DBMS_SQL.DEFINE_COLUMN(source_cursor , 23,RULE_OBJECT_ID);

Line 630: DBMS_SQL.DEFINE_COLUMN(source_cursor , 21,LAST_UPDATE_DATE);

626: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,ATTRIBUTE15,150);
627: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18,CREATED_BY);
628: DBMS_SQL.DEFINE_COLUMN(source_cursor , 19,CREATION_DATE);
629: DBMS_SQL.DEFINE_COLUMN(source_cursor , 20,LAST_UPDATE_LOGIN);
630: DBMS_SQL.DEFINE_COLUMN(source_cursor , 21,LAST_UPDATE_DATE);
631: DBMS_SQL.DEFINE_COLUMN(source_cursor , 22,LAST_UPDATED_BY);
632: if(g_is_use_instance) then
633: DBMS_SQL.DEFINE_COLUMN(source_cursor , 23,RULE_OBJECT_ID);
634: end if;

Line 631: DBMS_SQL.DEFINE_COLUMN(source_cursor , 22,LAST_UPDATED_BY);

627: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18,CREATED_BY);
628: DBMS_SQL.DEFINE_COLUMN(source_cursor , 19,CREATION_DATE);
629: DBMS_SQL.DEFINE_COLUMN(source_cursor , 20,LAST_UPDATE_LOGIN);
630: DBMS_SQL.DEFINE_COLUMN(source_cursor , 21,LAST_UPDATE_DATE);
631: DBMS_SQL.DEFINE_COLUMN(source_cursor , 22,LAST_UPDATED_BY);
632: if(g_is_use_instance) then
633: DBMS_SQL.DEFINE_COLUMN(source_cursor , 23,RULE_OBJECT_ID);
634: end if;
635:

Line 633: DBMS_SQL.DEFINE_COLUMN(source_cursor , 23,RULE_OBJECT_ID);

629: DBMS_SQL.DEFINE_COLUMN(source_cursor , 20,LAST_UPDATE_LOGIN);
630: DBMS_SQL.DEFINE_COLUMN(source_cursor , 21,LAST_UPDATE_DATE);
631: DBMS_SQL.DEFINE_COLUMN(source_cursor , 22,LAST_UPDATED_BY);
632: if(g_is_use_instance) then
633: DBMS_SQL.DEFINE_COLUMN(source_cursor , 23,RULE_OBJECT_ID);
634: end if;
635:
636:
637: ignore := DBMS_SQL.EXECUTE(source_cursor);

Line 637: ignore := DBMS_SQL.EXECUTE(source_cursor);

633: DBMS_SQL.DEFINE_COLUMN(source_cursor , 23,RULE_OBJECT_ID);
634: end if;
635:
636:
637: ignore := DBMS_SQL.EXECUTE(source_cursor);
638:
639: IF (
640: ( ( RULE_DETAIL_ID = X_RULE_DETAIL_ID )
641: OR ( ( RULE_DETAIL_ID IS NULL )

Line 715: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

711: END IF;
712:
713: EXCEPTION
714: WHEN OTHERS THEN
715: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
716: DBMS_SQL.CLOSE_CURSOR(source_cursor);
717: END IF;
718: RAISE;
719:

Line 716: DBMS_SQL.CLOSE_CURSOR(source_cursor);

712:
713: EXCEPTION
714: WHEN OTHERS THEN
715: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
716: DBMS_SQL.CLOSE_CURSOR(source_cursor);
717: END IF;
718: RAISE;
719:
720: END Lock_Row;

Line 757: source_cursor := dbms_sql.open_cursor;

753: * uses Instances or not.
754: */
755:
756: -- Prepare a cursor to select from the source table:
757: source_cursor := dbms_sql.open_cursor;
758:
759: if(g_is_use_instance) then
760: l_select_stmt :='SELECT '||
761: ' RULE_DETAIL_ID, '||

Line 804: DBMS_SQL.PARSE(source_cursor,l_select_stmt , DBMS_SQL.native);

800: ' FROM '|| X_TABLE_NAME ||
801: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID ' ||
802: ' AND ROWNUM = 1 ';
803: end if;
804: DBMS_SQL.PARSE(source_cursor,l_select_stmt , DBMS_SQL.native);
805:
806: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
807: if(g_is_use_instance) then
808: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

Line 806: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

802: ' AND ROWNUM = 1 ';
803: end if;
804: DBMS_SQL.PARSE(source_cursor,l_select_stmt , DBMS_SQL.native);
805:
806: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
807: if(g_is_use_instance) then
808: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
809: end if;
810:

Line 808: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

804: DBMS_SQL.PARSE(source_cursor,l_select_stmt , DBMS_SQL.native);
805:
806: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
807: if(g_is_use_instance) then
808: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
809: end if;
810:
811: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, X_RULE_DETAIL_ID);
812: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, X_ATTRIBUTE_CATEGORY, 150);

Line 811: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, X_RULE_DETAIL_ID);

807: if(g_is_use_instance) then
808: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
809: end if;
810:
811: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, X_RULE_DETAIL_ID);
812: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, X_ATTRIBUTE_CATEGORY, 150);
813: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, X_ATTRIBUTE1,150);
814: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, X_ATTRIBUTE2,150);
815: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, X_ATTRIBUTE3,150);

Line 812: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, X_ATTRIBUTE_CATEGORY, 150);

808: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
809: end if;
810:
811: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, X_RULE_DETAIL_ID);
812: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, X_ATTRIBUTE_CATEGORY, 150);
813: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, X_ATTRIBUTE1,150);
814: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, X_ATTRIBUTE2,150);
815: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, X_ATTRIBUTE3,150);
816: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, X_ATTRIBUTE4,150);

Line 813: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, X_ATTRIBUTE1,150);

809: end if;
810:
811: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, X_RULE_DETAIL_ID);
812: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, X_ATTRIBUTE_CATEGORY, 150);
813: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, X_ATTRIBUTE1,150);
814: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, X_ATTRIBUTE2,150);
815: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, X_ATTRIBUTE3,150);
816: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, X_ATTRIBUTE4,150);
817: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, X_ATTRIBUTE5,150);

Line 814: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, X_ATTRIBUTE2,150);

810:
811: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, X_RULE_DETAIL_ID);
812: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, X_ATTRIBUTE_CATEGORY, 150);
813: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, X_ATTRIBUTE1,150);
814: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, X_ATTRIBUTE2,150);
815: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, X_ATTRIBUTE3,150);
816: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, X_ATTRIBUTE4,150);
817: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, X_ATTRIBUTE5,150);
818: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, X_ATTRIBUTE6,150);

Line 815: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, X_ATTRIBUTE3,150);

811: DBMS_SQL.DEFINE_COLUMN(source_cursor , 1, X_RULE_DETAIL_ID);
812: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, X_ATTRIBUTE_CATEGORY, 150);
813: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, X_ATTRIBUTE1,150);
814: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, X_ATTRIBUTE2,150);
815: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, X_ATTRIBUTE3,150);
816: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, X_ATTRIBUTE4,150);
817: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, X_ATTRIBUTE5,150);
818: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, X_ATTRIBUTE6,150);
819: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, X_ATTRIBUTE7,150);

Line 816: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, X_ATTRIBUTE4,150);

812: DBMS_SQL.DEFINE_COLUMN(source_cursor , 2, X_ATTRIBUTE_CATEGORY, 150);
813: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, X_ATTRIBUTE1,150);
814: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, X_ATTRIBUTE2,150);
815: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, X_ATTRIBUTE3,150);
816: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, X_ATTRIBUTE4,150);
817: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, X_ATTRIBUTE5,150);
818: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, X_ATTRIBUTE6,150);
819: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, X_ATTRIBUTE7,150);
820: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,X_ATTRIBUTE8,150);

Line 817: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, X_ATTRIBUTE5,150);

813: DBMS_SQL.DEFINE_COLUMN(source_cursor , 3, X_ATTRIBUTE1,150);
814: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, X_ATTRIBUTE2,150);
815: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, X_ATTRIBUTE3,150);
816: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, X_ATTRIBUTE4,150);
817: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, X_ATTRIBUTE5,150);
818: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, X_ATTRIBUTE6,150);
819: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, X_ATTRIBUTE7,150);
820: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,X_ATTRIBUTE8,150);
821: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,X_ATTRIBUTE9,150);

Line 818: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, X_ATTRIBUTE6,150);

814: DBMS_SQL.DEFINE_COLUMN(source_cursor , 4, X_ATTRIBUTE2,150);
815: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, X_ATTRIBUTE3,150);
816: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, X_ATTRIBUTE4,150);
817: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, X_ATTRIBUTE5,150);
818: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, X_ATTRIBUTE6,150);
819: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, X_ATTRIBUTE7,150);
820: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,X_ATTRIBUTE8,150);
821: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,X_ATTRIBUTE9,150);
822: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,X_ATTRIBUTE10,150);

Line 819: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, X_ATTRIBUTE7,150);

815: DBMS_SQL.DEFINE_COLUMN(source_cursor , 5, X_ATTRIBUTE3,150);
816: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, X_ATTRIBUTE4,150);
817: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, X_ATTRIBUTE5,150);
818: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, X_ATTRIBUTE6,150);
819: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, X_ATTRIBUTE7,150);
820: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,X_ATTRIBUTE8,150);
821: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,X_ATTRIBUTE9,150);
822: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,X_ATTRIBUTE10,150);
823: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,X_ATTRIBUTE11,150);

Line 820: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,X_ATTRIBUTE8,150);

816: DBMS_SQL.DEFINE_COLUMN(source_cursor , 6, X_ATTRIBUTE4,150);
817: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, X_ATTRIBUTE5,150);
818: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, X_ATTRIBUTE6,150);
819: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, X_ATTRIBUTE7,150);
820: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,X_ATTRIBUTE8,150);
821: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,X_ATTRIBUTE9,150);
822: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,X_ATTRIBUTE10,150);
823: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,X_ATTRIBUTE11,150);
824: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,X_ATTRIBUTE12,150);

Line 821: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,X_ATTRIBUTE9,150);

817: DBMS_SQL.DEFINE_COLUMN(source_cursor , 7, X_ATTRIBUTE5,150);
818: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, X_ATTRIBUTE6,150);
819: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, X_ATTRIBUTE7,150);
820: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,X_ATTRIBUTE8,150);
821: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,X_ATTRIBUTE9,150);
822: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,X_ATTRIBUTE10,150);
823: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,X_ATTRIBUTE11,150);
824: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,X_ATTRIBUTE12,150);
825: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,X_ATTRIBUTE13,150);

Line 822: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,X_ATTRIBUTE10,150);

818: DBMS_SQL.DEFINE_COLUMN(source_cursor , 8, X_ATTRIBUTE6,150);
819: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, X_ATTRIBUTE7,150);
820: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,X_ATTRIBUTE8,150);
821: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,X_ATTRIBUTE9,150);
822: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,X_ATTRIBUTE10,150);
823: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,X_ATTRIBUTE11,150);
824: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,X_ATTRIBUTE12,150);
825: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,X_ATTRIBUTE13,150);
826: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,X_ATTRIBUTE14,150);

Line 823: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,X_ATTRIBUTE11,150);

819: DBMS_SQL.DEFINE_COLUMN(source_cursor , 9, X_ATTRIBUTE7,150);
820: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,X_ATTRIBUTE8,150);
821: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,X_ATTRIBUTE9,150);
822: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,X_ATTRIBUTE10,150);
823: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,X_ATTRIBUTE11,150);
824: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,X_ATTRIBUTE12,150);
825: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,X_ATTRIBUTE13,150);
826: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,X_ATTRIBUTE14,150);
827: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,X_ATTRIBUTE15,150);

Line 824: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,X_ATTRIBUTE12,150);

820: DBMS_SQL.DEFINE_COLUMN(source_cursor , 10,X_ATTRIBUTE8,150);
821: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,X_ATTRIBUTE9,150);
822: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,X_ATTRIBUTE10,150);
823: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,X_ATTRIBUTE11,150);
824: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,X_ATTRIBUTE12,150);
825: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,X_ATTRIBUTE13,150);
826: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,X_ATTRIBUTE14,150);
827: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,X_ATTRIBUTE15,150);
828: if(g_is_use_instance) then

Line 825: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,X_ATTRIBUTE13,150);

821: DBMS_SQL.DEFINE_COLUMN(source_cursor , 11,X_ATTRIBUTE9,150);
822: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,X_ATTRIBUTE10,150);
823: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,X_ATTRIBUTE11,150);
824: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,X_ATTRIBUTE12,150);
825: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,X_ATTRIBUTE13,150);
826: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,X_ATTRIBUTE14,150);
827: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,X_ATTRIBUTE15,150);
828: if(g_is_use_instance) then
829: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18, X_RULE_OBJECT_ID);

Line 826: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,X_ATTRIBUTE14,150);

822: DBMS_SQL.DEFINE_COLUMN(source_cursor , 12,X_ATTRIBUTE10,150);
823: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,X_ATTRIBUTE11,150);
824: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,X_ATTRIBUTE12,150);
825: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,X_ATTRIBUTE13,150);
826: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,X_ATTRIBUTE14,150);
827: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,X_ATTRIBUTE15,150);
828: if(g_is_use_instance) then
829: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18, X_RULE_OBJECT_ID);
830: end if;

Line 827: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,X_ATTRIBUTE15,150);

823: DBMS_SQL.DEFINE_COLUMN(source_cursor , 13,X_ATTRIBUTE11,150);
824: DBMS_SQL.DEFINE_COLUMN(source_cursor , 14,X_ATTRIBUTE12,150);
825: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,X_ATTRIBUTE13,150);
826: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,X_ATTRIBUTE14,150);
827: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,X_ATTRIBUTE15,150);
828: if(g_is_use_instance) then
829: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18, X_RULE_OBJECT_ID);
830: end if;
831: ignore := DBMS_SQL.EXECUTE(source_cursor);

Line 829: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18, X_RULE_OBJECT_ID);

825: DBMS_SQL.DEFINE_COLUMN(source_cursor , 15,X_ATTRIBUTE13,150);
826: DBMS_SQL.DEFINE_COLUMN(source_cursor , 16,X_ATTRIBUTE14,150);
827: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,X_ATTRIBUTE15,150);
828: if(g_is_use_instance) then
829: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18, X_RULE_OBJECT_ID);
830: end if;
831: ignore := DBMS_SQL.EXECUTE(source_cursor);
832:
833: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

Line 831: ignore := DBMS_SQL.EXECUTE(source_cursor);

827: DBMS_SQL.DEFINE_COLUMN(source_cursor , 17,X_ATTRIBUTE15,150);
828: if(g_is_use_instance) then
829: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18, X_RULE_OBJECT_ID);
830: end if;
831: ignore := DBMS_SQL.EXECUTE(source_cursor);
832:
833: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
834: -- get column values of the row
835: DBMS_SQL.COLUMN_VALUE(source_cursor , 1, X_RULE_DETAIL_ID);

Line 833: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

829: DBMS_SQL.DEFINE_COLUMN(source_cursor , 18, X_RULE_OBJECT_ID);
830: end if;
831: ignore := DBMS_SQL.EXECUTE(source_cursor);
832:
833: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
834: -- get column values of the row
835: DBMS_SQL.COLUMN_VALUE(source_cursor , 1, X_RULE_DETAIL_ID);
836: DBMS_SQL.COLUMN_VALUE(source_cursor , 2, X_ATTRIBUTE_CATEGORY);
837: DBMS_SQL.COLUMN_VALUE(source_cursor , 3, X_ATTRIBUTE1);

Line 835: DBMS_SQL.COLUMN_VALUE(source_cursor , 1, X_RULE_DETAIL_ID);

831: ignore := DBMS_SQL.EXECUTE(source_cursor);
832:
833: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
834: -- get column values of the row
835: DBMS_SQL.COLUMN_VALUE(source_cursor , 1, X_RULE_DETAIL_ID);
836: DBMS_SQL.COLUMN_VALUE(source_cursor , 2, X_ATTRIBUTE_CATEGORY);
837: DBMS_SQL.COLUMN_VALUE(source_cursor , 3, X_ATTRIBUTE1);
838: DBMS_SQL.COLUMN_VALUE(source_cursor , 4, X_ATTRIBUTE2);
839: DBMS_SQL.COLUMN_VALUE(source_cursor , 5, X_ATTRIBUTE3);

Line 836: DBMS_SQL.COLUMN_VALUE(source_cursor , 2, X_ATTRIBUTE_CATEGORY);

832:
833: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
834: -- get column values of the row
835: DBMS_SQL.COLUMN_VALUE(source_cursor , 1, X_RULE_DETAIL_ID);
836: DBMS_SQL.COLUMN_VALUE(source_cursor , 2, X_ATTRIBUTE_CATEGORY);
837: DBMS_SQL.COLUMN_VALUE(source_cursor , 3, X_ATTRIBUTE1);
838: DBMS_SQL.COLUMN_VALUE(source_cursor , 4, X_ATTRIBUTE2);
839: DBMS_SQL.COLUMN_VALUE(source_cursor , 5, X_ATTRIBUTE3);
840: DBMS_SQL.COLUMN_VALUE(source_cursor , 6, X_ATTRIBUTE4);

Line 837: DBMS_SQL.COLUMN_VALUE(source_cursor , 3, X_ATTRIBUTE1);

833: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
834: -- get column values of the row
835: DBMS_SQL.COLUMN_VALUE(source_cursor , 1, X_RULE_DETAIL_ID);
836: DBMS_SQL.COLUMN_VALUE(source_cursor , 2, X_ATTRIBUTE_CATEGORY);
837: DBMS_SQL.COLUMN_VALUE(source_cursor , 3, X_ATTRIBUTE1);
838: DBMS_SQL.COLUMN_VALUE(source_cursor , 4, X_ATTRIBUTE2);
839: DBMS_SQL.COLUMN_VALUE(source_cursor , 5, X_ATTRIBUTE3);
840: DBMS_SQL.COLUMN_VALUE(source_cursor , 6, X_ATTRIBUTE4);
841: DBMS_SQL.COLUMN_VALUE(source_cursor , 7, X_ATTRIBUTE5);

Line 838: DBMS_SQL.COLUMN_VALUE(source_cursor , 4, X_ATTRIBUTE2);

834: -- get column values of the row
835: DBMS_SQL.COLUMN_VALUE(source_cursor , 1, X_RULE_DETAIL_ID);
836: DBMS_SQL.COLUMN_VALUE(source_cursor , 2, X_ATTRIBUTE_CATEGORY);
837: DBMS_SQL.COLUMN_VALUE(source_cursor , 3, X_ATTRIBUTE1);
838: DBMS_SQL.COLUMN_VALUE(source_cursor , 4, X_ATTRIBUTE2);
839: DBMS_SQL.COLUMN_VALUE(source_cursor , 5, X_ATTRIBUTE3);
840: DBMS_SQL.COLUMN_VALUE(source_cursor , 6, X_ATTRIBUTE4);
841: DBMS_SQL.COLUMN_VALUE(source_cursor , 7, X_ATTRIBUTE5);
842: DBMS_SQL.COLUMN_VALUE(source_cursor , 8, X_ATTRIBUTE6);

Line 839: DBMS_SQL.COLUMN_VALUE(source_cursor , 5, X_ATTRIBUTE3);

835: DBMS_SQL.COLUMN_VALUE(source_cursor , 1, X_RULE_DETAIL_ID);
836: DBMS_SQL.COLUMN_VALUE(source_cursor , 2, X_ATTRIBUTE_CATEGORY);
837: DBMS_SQL.COLUMN_VALUE(source_cursor , 3, X_ATTRIBUTE1);
838: DBMS_SQL.COLUMN_VALUE(source_cursor , 4, X_ATTRIBUTE2);
839: DBMS_SQL.COLUMN_VALUE(source_cursor , 5, X_ATTRIBUTE3);
840: DBMS_SQL.COLUMN_VALUE(source_cursor , 6, X_ATTRIBUTE4);
841: DBMS_SQL.COLUMN_VALUE(source_cursor , 7, X_ATTRIBUTE5);
842: DBMS_SQL.COLUMN_VALUE(source_cursor , 8, X_ATTRIBUTE6);
843: DBMS_SQL.COLUMN_VALUE(source_cursor , 9, X_ATTRIBUTE7);

Line 840: DBMS_SQL.COLUMN_VALUE(source_cursor , 6, X_ATTRIBUTE4);

836: DBMS_SQL.COLUMN_VALUE(source_cursor , 2, X_ATTRIBUTE_CATEGORY);
837: DBMS_SQL.COLUMN_VALUE(source_cursor , 3, X_ATTRIBUTE1);
838: DBMS_SQL.COLUMN_VALUE(source_cursor , 4, X_ATTRIBUTE2);
839: DBMS_SQL.COLUMN_VALUE(source_cursor , 5, X_ATTRIBUTE3);
840: DBMS_SQL.COLUMN_VALUE(source_cursor , 6, X_ATTRIBUTE4);
841: DBMS_SQL.COLUMN_VALUE(source_cursor , 7, X_ATTRIBUTE5);
842: DBMS_SQL.COLUMN_VALUE(source_cursor , 8, X_ATTRIBUTE6);
843: DBMS_SQL.COLUMN_VALUE(source_cursor , 9, X_ATTRIBUTE7);
844: DBMS_SQL.COLUMN_VALUE(source_cursor , 10,X_ATTRIBUTE8);

Line 841: DBMS_SQL.COLUMN_VALUE(source_cursor , 7, X_ATTRIBUTE5);

837: DBMS_SQL.COLUMN_VALUE(source_cursor , 3, X_ATTRIBUTE1);
838: DBMS_SQL.COLUMN_VALUE(source_cursor , 4, X_ATTRIBUTE2);
839: DBMS_SQL.COLUMN_VALUE(source_cursor , 5, X_ATTRIBUTE3);
840: DBMS_SQL.COLUMN_VALUE(source_cursor , 6, X_ATTRIBUTE4);
841: DBMS_SQL.COLUMN_VALUE(source_cursor , 7, X_ATTRIBUTE5);
842: DBMS_SQL.COLUMN_VALUE(source_cursor , 8, X_ATTRIBUTE6);
843: DBMS_SQL.COLUMN_VALUE(source_cursor , 9, X_ATTRIBUTE7);
844: DBMS_SQL.COLUMN_VALUE(source_cursor , 10,X_ATTRIBUTE8);
845: DBMS_SQL.COLUMN_VALUE(source_cursor , 11,X_ATTRIBUTE9);

Line 842: DBMS_SQL.COLUMN_VALUE(source_cursor , 8, X_ATTRIBUTE6);

838: DBMS_SQL.COLUMN_VALUE(source_cursor , 4, X_ATTRIBUTE2);
839: DBMS_SQL.COLUMN_VALUE(source_cursor , 5, X_ATTRIBUTE3);
840: DBMS_SQL.COLUMN_VALUE(source_cursor , 6, X_ATTRIBUTE4);
841: DBMS_SQL.COLUMN_VALUE(source_cursor , 7, X_ATTRIBUTE5);
842: DBMS_SQL.COLUMN_VALUE(source_cursor , 8, X_ATTRIBUTE6);
843: DBMS_SQL.COLUMN_VALUE(source_cursor , 9, X_ATTRIBUTE7);
844: DBMS_SQL.COLUMN_VALUE(source_cursor , 10,X_ATTRIBUTE8);
845: DBMS_SQL.COLUMN_VALUE(source_cursor , 11,X_ATTRIBUTE9);
846: DBMS_SQL.COLUMN_VALUE(source_cursor , 12,X_ATTRIBUTE10);

Line 843: DBMS_SQL.COLUMN_VALUE(source_cursor , 9, X_ATTRIBUTE7);

839: DBMS_SQL.COLUMN_VALUE(source_cursor , 5, X_ATTRIBUTE3);
840: DBMS_SQL.COLUMN_VALUE(source_cursor , 6, X_ATTRIBUTE4);
841: DBMS_SQL.COLUMN_VALUE(source_cursor , 7, X_ATTRIBUTE5);
842: DBMS_SQL.COLUMN_VALUE(source_cursor , 8, X_ATTRIBUTE6);
843: DBMS_SQL.COLUMN_VALUE(source_cursor , 9, X_ATTRIBUTE7);
844: DBMS_SQL.COLUMN_VALUE(source_cursor , 10,X_ATTRIBUTE8);
845: DBMS_SQL.COLUMN_VALUE(source_cursor , 11,X_ATTRIBUTE9);
846: DBMS_SQL.COLUMN_VALUE(source_cursor , 12,X_ATTRIBUTE10);
847: DBMS_SQL.COLUMN_VALUE(source_cursor , 13,X_ATTRIBUTE11);

Line 844: DBMS_SQL.COLUMN_VALUE(source_cursor , 10,X_ATTRIBUTE8);

840: DBMS_SQL.COLUMN_VALUE(source_cursor , 6, X_ATTRIBUTE4);
841: DBMS_SQL.COLUMN_VALUE(source_cursor , 7, X_ATTRIBUTE5);
842: DBMS_SQL.COLUMN_VALUE(source_cursor , 8, X_ATTRIBUTE6);
843: DBMS_SQL.COLUMN_VALUE(source_cursor , 9, X_ATTRIBUTE7);
844: DBMS_SQL.COLUMN_VALUE(source_cursor , 10,X_ATTRIBUTE8);
845: DBMS_SQL.COLUMN_VALUE(source_cursor , 11,X_ATTRIBUTE9);
846: DBMS_SQL.COLUMN_VALUE(source_cursor , 12,X_ATTRIBUTE10);
847: DBMS_SQL.COLUMN_VALUE(source_cursor , 13,X_ATTRIBUTE11);
848: DBMS_SQL.COLUMN_VALUE(source_cursor , 14,X_ATTRIBUTE12);

Line 845: DBMS_SQL.COLUMN_VALUE(source_cursor , 11,X_ATTRIBUTE9);

841: DBMS_SQL.COLUMN_VALUE(source_cursor , 7, X_ATTRIBUTE5);
842: DBMS_SQL.COLUMN_VALUE(source_cursor , 8, X_ATTRIBUTE6);
843: DBMS_SQL.COLUMN_VALUE(source_cursor , 9, X_ATTRIBUTE7);
844: DBMS_SQL.COLUMN_VALUE(source_cursor , 10,X_ATTRIBUTE8);
845: DBMS_SQL.COLUMN_VALUE(source_cursor , 11,X_ATTRIBUTE9);
846: DBMS_SQL.COLUMN_VALUE(source_cursor , 12,X_ATTRIBUTE10);
847: DBMS_SQL.COLUMN_VALUE(source_cursor , 13,X_ATTRIBUTE11);
848: DBMS_SQL.COLUMN_VALUE(source_cursor , 14,X_ATTRIBUTE12);
849: DBMS_SQL.COLUMN_VALUE(source_cursor , 15,X_ATTRIBUTE13);

Line 846: DBMS_SQL.COLUMN_VALUE(source_cursor , 12,X_ATTRIBUTE10);

842: DBMS_SQL.COLUMN_VALUE(source_cursor , 8, X_ATTRIBUTE6);
843: DBMS_SQL.COLUMN_VALUE(source_cursor , 9, X_ATTRIBUTE7);
844: DBMS_SQL.COLUMN_VALUE(source_cursor , 10,X_ATTRIBUTE8);
845: DBMS_SQL.COLUMN_VALUE(source_cursor , 11,X_ATTRIBUTE9);
846: DBMS_SQL.COLUMN_VALUE(source_cursor , 12,X_ATTRIBUTE10);
847: DBMS_SQL.COLUMN_VALUE(source_cursor , 13,X_ATTRIBUTE11);
848: DBMS_SQL.COLUMN_VALUE(source_cursor , 14,X_ATTRIBUTE12);
849: DBMS_SQL.COLUMN_VALUE(source_cursor , 15,X_ATTRIBUTE13);
850: DBMS_SQL.COLUMN_VALUE(source_cursor , 16,X_ATTRIBUTE14);

Line 847: DBMS_SQL.COLUMN_VALUE(source_cursor , 13,X_ATTRIBUTE11);

843: DBMS_SQL.COLUMN_VALUE(source_cursor , 9, X_ATTRIBUTE7);
844: DBMS_SQL.COLUMN_VALUE(source_cursor , 10,X_ATTRIBUTE8);
845: DBMS_SQL.COLUMN_VALUE(source_cursor , 11,X_ATTRIBUTE9);
846: DBMS_SQL.COLUMN_VALUE(source_cursor , 12,X_ATTRIBUTE10);
847: DBMS_SQL.COLUMN_VALUE(source_cursor , 13,X_ATTRIBUTE11);
848: DBMS_SQL.COLUMN_VALUE(source_cursor , 14,X_ATTRIBUTE12);
849: DBMS_SQL.COLUMN_VALUE(source_cursor , 15,X_ATTRIBUTE13);
850: DBMS_SQL.COLUMN_VALUE(source_cursor , 16,X_ATTRIBUTE14);
851: DBMS_SQL.COLUMN_VALUE(source_cursor , 17,X_ATTRIBUTE15);

Line 848: DBMS_SQL.COLUMN_VALUE(source_cursor , 14,X_ATTRIBUTE12);

844: DBMS_SQL.COLUMN_VALUE(source_cursor , 10,X_ATTRIBUTE8);
845: DBMS_SQL.COLUMN_VALUE(source_cursor , 11,X_ATTRIBUTE9);
846: DBMS_SQL.COLUMN_VALUE(source_cursor , 12,X_ATTRIBUTE10);
847: DBMS_SQL.COLUMN_VALUE(source_cursor , 13,X_ATTRIBUTE11);
848: DBMS_SQL.COLUMN_VALUE(source_cursor , 14,X_ATTRIBUTE12);
849: DBMS_SQL.COLUMN_VALUE(source_cursor , 15,X_ATTRIBUTE13);
850: DBMS_SQL.COLUMN_VALUE(source_cursor , 16,X_ATTRIBUTE14);
851: DBMS_SQL.COLUMN_VALUE(source_cursor , 17,X_ATTRIBUTE15);
852: if(g_is_use_instance) then

Line 849: DBMS_SQL.COLUMN_VALUE(source_cursor , 15,X_ATTRIBUTE13);

845: DBMS_SQL.COLUMN_VALUE(source_cursor , 11,X_ATTRIBUTE9);
846: DBMS_SQL.COLUMN_VALUE(source_cursor , 12,X_ATTRIBUTE10);
847: DBMS_SQL.COLUMN_VALUE(source_cursor , 13,X_ATTRIBUTE11);
848: DBMS_SQL.COLUMN_VALUE(source_cursor , 14,X_ATTRIBUTE12);
849: DBMS_SQL.COLUMN_VALUE(source_cursor , 15,X_ATTRIBUTE13);
850: DBMS_SQL.COLUMN_VALUE(source_cursor , 16,X_ATTRIBUTE14);
851: DBMS_SQL.COLUMN_VALUE(source_cursor , 17,X_ATTRIBUTE15);
852: if(g_is_use_instance) then
853: DBMS_SQL.COLUMN_VALUE(source_cursor , 18, X_RULE_OBJECT_ID);

Line 850: DBMS_SQL.COLUMN_VALUE(source_cursor , 16,X_ATTRIBUTE14);

846: DBMS_SQL.COLUMN_VALUE(source_cursor , 12,X_ATTRIBUTE10);
847: DBMS_SQL.COLUMN_VALUE(source_cursor , 13,X_ATTRIBUTE11);
848: DBMS_SQL.COLUMN_VALUE(source_cursor , 14,X_ATTRIBUTE12);
849: DBMS_SQL.COLUMN_VALUE(source_cursor , 15,X_ATTRIBUTE13);
850: DBMS_SQL.COLUMN_VALUE(source_cursor , 16,X_ATTRIBUTE14);
851: DBMS_SQL.COLUMN_VALUE(source_cursor , 17,X_ATTRIBUTE15);
852: if(g_is_use_instance) then
853: DBMS_SQL.COLUMN_VALUE(source_cursor , 18, X_RULE_OBJECT_ID);
854: end if;

Line 851: DBMS_SQL.COLUMN_VALUE(source_cursor , 17,X_ATTRIBUTE15);

847: DBMS_SQL.COLUMN_VALUE(source_cursor , 13,X_ATTRIBUTE11);
848: DBMS_SQL.COLUMN_VALUE(source_cursor , 14,X_ATTRIBUTE12);
849: DBMS_SQL.COLUMN_VALUE(source_cursor , 15,X_ATTRIBUTE13);
850: DBMS_SQL.COLUMN_VALUE(source_cursor , 16,X_ATTRIBUTE14);
851: DBMS_SQL.COLUMN_VALUE(source_cursor , 17,X_ATTRIBUTE15);
852: if(g_is_use_instance) then
853: DBMS_SQL.COLUMN_VALUE(source_cursor , 18, X_RULE_OBJECT_ID);
854: end if;
855: END IF;

Line 853: DBMS_SQL.COLUMN_VALUE(source_cursor , 18, X_RULE_OBJECT_ID);

849: DBMS_SQL.COLUMN_VALUE(source_cursor , 15,X_ATTRIBUTE13);
850: DBMS_SQL.COLUMN_VALUE(source_cursor , 16,X_ATTRIBUTE14);
851: DBMS_SQL.COLUMN_VALUE(source_cursor , 17,X_ATTRIBUTE15);
852: if(g_is_use_instance) then
853: DBMS_SQL.COLUMN_VALUE(source_cursor , 18, X_RULE_OBJECT_ID);
854: end if;
855: END IF;
856:
857: DBMS_SQL.CLOSE_CURSOR(source_cursor);

Line 857: DBMS_SQL.CLOSE_CURSOR(source_cursor);

853: DBMS_SQL.COLUMN_VALUE(source_cursor , 18, X_RULE_OBJECT_ID);
854: end if;
855: END IF;
856:
857: DBMS_SQL.CLOSE_CURSOR(source_cursor);
858:
859: EXCEPTION
860: WHEN NO_DATA_FOUND THEN
861: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

Line 861: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

857: DBMS_SQL.CLOSE_CURSOR(source_cursor);
858:
859: EXCEPTION
860: WHEN NO_DATA_FOUND THEN
861: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
862: DBMS_SQL.CLOSE_CURSOR(source_cursor);
863: END IF;
864:
865: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );

Line 862: DBMS_SQL.CLOSE_CURSOR(source_cursor);

858:
859: EXCEPTION
860: WHEN NO_DATA_FOUND THEN
861: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
862: DBMS_SQL.CLOSE_CURSOR(source_cursor);
863: END IF;
864:
865: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );
866: FND_MESSAGE.SET_TOKEN( 'RECORD', 'FUN_RULE_DFF');

Line 872: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

868: FND_MSG_PUB.ADD;
869: RAISE FND_API.G_EXC_ERROR;
870:
871: WHEN OTHERS THEN
872: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
873: DBMS_SQL.CLOSE_CURSOR(source_cursor);
874: END IF;
875: RAISE;
876:

Line 873: DBMS_SQL.CLOSE_CURSOR(source_cursor);

869: RAISE FND_API.G_EXC_ERROR;
870:
871: WHEN OTHERS THEN
872: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
873: DBMS_SQL.CLOSE_CURSOR(source_cursor);
874: END IF;
875: RAISE;
876:
877:

Line 897: source_cursor := DBMS_SQL.OPEN_CURSOR;

893: * uses Instances or not.
894: */
895:
896: -- Prepare a cursor to select from the source table:
897: source_cursor := DBMS_SQL.OPEN_CURSOR;
898:
899: if(g_is_use_instance) then
900: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
901: DBMS_SQL.native);

Line 900: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',

896: -- Prepare a cursor to select from the source table:
897: source_cursor := DBMS_SQL.OPEN_CURSOR;
898:
899: if(g_is_use_instance) then
900: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
901: DBMS_SQL.native);
902: else
903: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
904: DBMS_SQL.native);

Line 901: DBMS_SQL.native);

897: source_cursor := DBMS_SQL.OPEN_CURSOR;
898:
899: if(g_is_use_instance) then
900: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
901: DBMS_SQL.native);
902: else
903: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
904: DBMS_SQL.native);
905: end if;

Line 903: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',

899: if(g_is_use_instance) then
900: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
901: DBMS_SQL.native);
902: else
903: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
904: DBMS_SQL.native);
905: end if;
906:
907: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

Line 904: DBMS_SQL.native);

900: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
901: DBMS_SQL.native);
902: else
903: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
904: DBMS_SQL.native);
905: end if;
906:
907: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
908: if(g_is_use_instance) then

Line 907: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

903: DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
904: DBMS_SQL.native);
905: end if;
906:
907: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
908: if(g_is_use_instance) then
909: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
910: end if;
911: ignore := DBMS_SQL.EXECUTE(source_cursor);

Line 909: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);

905: end if;
906:
907: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
908: if(g_is_use_instance) then
909: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
910: end if;
911: ignore := DBMS_SQL.EXECUTE(source_cursor);
912:
913: DBMS_SQL.CLOSE_CURSOR(source_cursor);

Line 911: ignore := DBMS_SQL.EXECUTE(source_cursor);

907: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);
908: if(g_is_use_instance) then
909: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
910: end if;
911: ignore := DBMS_SQL.EXECUTE(source_cursor);
912:
913: DBMS_SQL.CLOSE_CURSOR(source_cursor);
914: COMMIT;
915: EXCEPTION

Line 913: DBMS_SQL.CLOSE_CURSOR(source_cursor);

909: DBMS_SQL.BIND_VARIABLE(source_cursor, 'X_RULE_OBJECT_ID', X_RULE_OBJECT_ID);
910: end if;
911: ignore := DBMS_SQL.EXECUTE(source_cursor);
912:
913: DBMS_SQL.CLOSE_CURSOR(source_cursor);
914: COMMIT;
915: EXCEPTION
916: WHEN NO_DATA_FOUND THEN
917: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

Line 917: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

913: DBMS_SQL.CLOSE_CURSOR(source_cursor);
914: COMMIT;
915: EXCEPTION
916: WHEN NO_DATA_FOUND THEN
917: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
918: DBMS_SQL.CLOSE_CURSOR(source_cursor);
919: END IF;
920:
921: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );

Line 918: DBMS_SQL.CLOSE_CURSOR(source_cursor);

914: COMMIT;
915: EXCEPTION
916: WHEN NO_DATA_FOUND THEN
917: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
918: DBMS_SQL.CLOSE_CURSOR(source_cursor);
919: END IF;
920:
921: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );
922: FND_MESSAGE.SET_TOKEN( 'RECORD', 'FUN_RULE_DFF');

Line 928: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

924: FND_MSG_PUB.ADD;
925: RAISE FND_API.G_EXC_ERROR;
926:
927: WHEN OTHERS THEN
928: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
929: DBMS_SQL.CLOSE_CURSOR(source_cursor);
930: END IF;
931: RAISE;
932:

Line 929: DBMS_SQL.CLOSE_CURSOR(source_cursor);

925: RAISE FND_API.G_EXC_ERROR;
926:
927: WHEN OTHERS THEN
928: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
929: DBMS_SQL.CLOSE_CURSOR(source_cursor);
930: END IF;
931: RAISE;
932:
933: