APPS.HZ_CREDIT_USAGE_RULE_SETS_PKG dependencies on HZ_CREDIT_USAGE_RULE_SETS_TL

Line 12: -- and HZ_CREDIT_USAGE_RULE_SETS_TL

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,
16: X_CREDIT_USAGE_RULE_SET_ID in NUMBER,

Line 98: insert into HZ_CREDIT_USAGE_RULE_SETS_TL (

94: X_LAST_UPDATE_LOGIN,
95: X_GLOBAL_EXPOSURE_FLAG
96: );
97:
98: insert into HZ_CREDIT_USAGE_RULE_SETS_TL (
99: CREDIT_USAGE_RULE_SET_ID,
100: NAME,
101: CREATION_DATE,
102: CREATED_BY,

Line 122: from HZ_CREDIT_USAGE_RULE_SETS_TL T

118: from FND_LANGUAGES L
119: where L.INSTALLED_FLAG in ('I', 'B')
120: and not exists
121: (select NULL
122: from HZ_CREDIT_USAGE_RULE_SETS_TL T
123: where T.CREDIT_USAGE_RULE_SET_ID = X_CREDIT_USAGE_RULE_SET_ID
124: and T.LANGUAGE = L.LANGUAGE_CODE);
125:
126: open c;

Line 150: -- and HZ_CREDIT_USAGE_RULE_SETS_TL

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,
154: X_ATTRIBUTE_CATEGORY in VARCHAR2,

Line 199: from HZ_CREDIT_USAGE_RULE_SETS_TL

195:
196: cursor c1 is select
197: NAME,
198: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
199: from HZ_CREDIT_USAGE_RULE_SETS_TL
200: where CREDIT_USAGE_RULE_SET_ID = X_CREDIT_USAGE_RULE_SET_ID
201: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
202: for update of CREDIT_USAGE_RULE_SET_ID nowait;
203: begin

Line 270: -- and HZ_CREDIT_USAGE_RULE_SETS_TL

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,
274: X_ATTRIBUTE_CATEGORY in VARCHAR2,

Line 326: update HZ_CREDIT_USAGE_RULE_SETS_TL set

322: if (sql%notfound) then
323: raise no_data_found;
324: end if;
325:
326: update HZ_CREDIT_USAGE_RULE_SETS_TL set
327: NAME = X_NAME,
328: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
329: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
330: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 353: -- and HZ_CREDIT_USAGE_RULE_SETS_TL

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
357: ) is

Line 359: delete from HZ_CREDIT_USAGE_RULE_SETS_TL

355: procedure DELETE_ROW (
356: X_CREDIT_USAGE_RULE_SET_ID in NUMBER
357: ) is
358: begin
359: delete from HZ_CREDIT_USAGE_RULE_SETS_TL
360: where CREDIT_USAGE_RULE_SET_ID = X_CREDIT_USAGE_RULE_SET_ID;
361:
362: if (sql%notfound) then
363: raise no_data_found;

Line 406: delete from HZ_CREDIT_USAGE_RULE_SETS_TL T

402: --========================================================================
403: procedure ADD_LANGUAGE
404: is
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

Line 413: update HZ_CREDIT_USAGE_RULE_SETS_TL T set (

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 (
414: NAME
415: ) = (select
416: B.NAME
417: from HZ_CREDIT_USAGE_RULE_SETS_TL B

Line 417: from HZ_CREDIT_USAGE_RULE_SETS_TL B

413: update HZ_CREDIT_USAGE_RULE_SETS_TL T set (
414: NAME
415: ) = (select
416: B.NAME
417: from HZ_CREDIT_USAGE_RULE_SETS_TL B
418: where B.CREDIT_USAGE_RULE_SET_ID = T.CREDIT_USAGE_RULE_SET_ID
419: and B.LANGUAGE = T.SOURCE_LANG)
420: where (
421: T.CREDIT_USAGE_RULE_SET_ID,

Line 426: from HZ_CREDIT_USAGE_RULE_SETS_TL SUBB, HZ_CREDIT_USAGE_RULE_SETS_TL SUBT

422: T.LANGUAGE
423: ) in (select
424: SUBT.CREDIT_USAGE_RULE_SET_ID,
425: SUBT.LANGUAGE
426: from HZ_CREDIT_USAGE_RULE_SETS_TL SUBB, HZ_CREDIT_USAGE_RULE_SETS_TL SUBT
427: where SUBB.CREDIT_USAGE_RULE_SET_ID = SUBT.CREDIT_USAGE_RULE_SET_ID
428: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
429: and (SUBB.NAME <> SUBT.NAME
430: ));

Line 432: insert into HZ_CREDIT_USAGE_RULE_SETS_TL (

428: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
429: and (SUBB.NAME <> SUBT.NAME
430: ));
431:
432: insert into HZ_CREDIT_USAGE_RULE_SETS_TL (
433: CREDIT_USAGE_RULE_SET_ID,
434: NAME,
435: CREATION_DATE,
436: CREATED_BY,

Line 452: from HZ_CREDIT_USAGE_RULE_SETS_TL B, FND_LANGUAGES L

448: B.LAST_UPDATED_BY,
449: B.LAST_UPDATE_LOGIN,
450: L.LANGUAGE_CODE,
451: B.SOURCE_LANG
452: from HZ_CREDIT_USAGE_RULE_SETS_TL B, FND_LANGUAGES L
453: where L.INSTALLED_FLAG in ('I', 'B')
454: and B.LANGUAGE = userenv('LANG')
455: and not exists
456: (select NULL

Line 457: from HZ_CREDIT_USAGE_RULE_SETS_TL T

453: where L.INSTALLED_FLAG in ('I', 'B')
454: and B.LANGUAGE = userenv('LANG')
455: and not exists
456: (select NULL
457: from HZ_CREDIT_USAGE_RULE_SETS_TL T
458: where T.CREDIT_USAGE_RULE_SET_ID = B.CREDIT_USAGE_RULE_SET_ID
459: and T.LANGUAGE = L.LANGUAGE_CODE);
460: end ADD_LANGUAGE;
461: