APPS.HZ_CREDIT_USAGE_RULE_SETS_PKG dependencies on HZ_CREDIT_USAGE_RULE_SETS_B

Line 11: -- COMMENT : Procedure inserts record into the table HZ_CREDIT_USAGE_RULE_SETS_B

7: ---------------------------
8:
9: --========================================================================
10: -- PROCEDURE : Insert_row PUBLIC
11: -- COMMENT : Procedure inserts record into the table HZ_CREDIT_USAGE_RULE_SETS_B
12: -- and HZ_CREDIT_USAGE_RULE_SETS_TL
13: --========================================================================
14: procedure INSERT_ROW (
15: X_ROWID in out NOCOPY VARCHAR2,

Line 42: cursor C is select ROWID from HZ_CREDIT_USAGE_RULE_SETS_B

38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER,
40: X_GLOBAL_EXPOSURE_FLAG IN VARCHAR2
41: ) is
42: cursor C is select ROWID from HZ_CREDIT_USAGE_RULE_SETS_B
43: where CREDIT_USAGE_RULE_SET_ID = X_CREDIT_USAGE_RULE_SET_ID
44: ;
45: begin
46: insert into HZ_CREDIT_USAGE_RULE_SETS_B (

Line 46: insert into HZ_CREDIT_USAGE_RULE_SETS_B (

42: cursor C is select ROWID from HZ_CREDIT_USAGE_RULE_SETS_B
43: where CREDIT_USAGE_RULE_SET_ID = X_CREDIT_USAGE_RULE_SET_ID
44: ;
45: begin
46: insert into HZ_CREDIT_USAGE_RULE_SETS_B (
47: ATTRIBUTE_CATEGORY,
48: ATTRIBUTE1,
49: ATTRIBUTE2,
50: ATTRIBUTE3,

Line 149: -- COMMENT : Procedure locks record in the table HZ_CREDIT_USAGE_RULE_SETS_B

145: -- PROCEDURE : Lock_row PUBLIC
146: -- PARAMETERS: p_credit_usage_rule_set_id credit_usage_rule_set_id
147: -- p_rule_set_name rule set name
148: -- p_last_update_date
149: -- COMMENT : Procedure locks record in the table HZ_CREDIT_USAGE_RULE_SETS_B
150: -- and HZ_CREDIT_USAGE_RULE_SETS_TL
151: --========================================================================
152: procedure LOCK_ROW (
153: X_CREDIT_USAGE_RULE_SET_ID in NUMBER,

Line 191: from HZ_CREDIT_USAGE_RULE_SETS_B

187: ATTRIBUTE13,
188: ATTRIBUTE14,
189: ATTRIBUTE15,
190: REQUEST_ID
191: from HZ_CREDIT_USAGE_RULE_SETS_B
192: where CREDIT_USAGE_RULE_SET_ID = X_CREDIT_USAGE_RULE_SET_ID
193: for update of CREDIT_USAGE_RULE_SET_ID nowait;
194: recinfo c%rowtype;
195:

Line 269: -- COMMENT : Procedure updates record in the table HZ_CREDIT_USAGE_RULE_SETS_B

265: end LOCK_ROW;
266:
267: --========================================================================
268: -- PROCEDURE : Update_row PUBLIC
269: -- COMMENT : Procedure updates record in the table HZ_CREDIT_USAGE_RULE_SETS_B
270: -- and HZ_CREDIT_USAGE_RULE_SETS_TL
271: --========================================================================
272: procedure UPDATE_ROW (
273: X_CREDIT_USAGE_RULE_SET_ID in NUMBER,

Line 298: update HZ_CREDIT_USAGE_RULE_SETS_B set

294: X_LAST_UPDATE_LOGIN in NUMBER,
295: X_GLOBAL_EXPOSURE_FLAG IN VARCHAR2
296: ) is
297: begin
298: update HZ_CREDIT_USAGE_RULE_SETS_B set
299: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
300: ATTRIBUTE1 = X_ATTRIBUTE1,
301: ATTRIBUTE2 = X_ATTRIBUTE2,
302: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 352: -- table HZ_CREDIT_USAGE_RULE_SETS_B

348:
349: --========================================================================
350: -- PROCEDURE : Delete_row PUBLIC
351: -- COMMENT : Procedure deletes record from the
352: -- table HZ_CREDIT_USAGE_RULE_SETS_B
353: -- and HZ_CREDIT_USAGE_RULE_SETS_TL
354: --========================================================================
355: procedure DELETE_ROW (
356: X_CREDIT_USAGE_RULE_SET_ID in NUMBER

Line 366: delete from HZ_CREDIT_USAGE_RULE_SETS_B

362: if (sql%notfound) then
363: raise no_data_found;
364: end if;
365:
366: delete from HZ_CREDIT_USAGE_RULE_SETS_B
367: where CREDIT_USAGE_RULE_SET_ID = X_CREDIT_USAGE_RULE_SET_ID;
368:
369: if (sql%notfound) then
370: raise no_data_found;

Line 409: from HZ_CREDIT_USAGE_RULE_SETS_B B

405: begin
406: delete from HZ_CREDIT_USAGE_RULE_SETS_TL T
407: where not exists
408: (select NULL
409: from HZ_CREDIT_USAGE_RULE_SETS_B B
410: where B.CREDIT_USAGE_RULE_SET_ID = T.CREDIT_USAGE_RULE_SET_ID
411: );
412:
413: update HZ_CREDIT_USAGE_RULE_SETS_TL T set (