APPS.QPR_TRANSF_RULES_PKG dependencies on QPR_TRANSF_RULES_TL

Line 115: insert into QPR_TRANSF_RULES_TL (

111: X_LAST_UPDATED_BY,
112: X_LAST_UPDATE_LOGIN
113: );
114:
115: insert into QPR_TRANSF_RULES_TL (
116: TRANSF_RULE_ID,
117: NAME,
118: DESCRIPTION,
119: CREATION_DATE,

Line 149: from QPR_TRANSF_RULES_TL T

145: from FND_LANGUAGES L
146: where L.INSTALLED_FLAG in ('I', 'B')
147: and not exists
148: (select NULL
149: from QPR_TRANSF_RULES_TL T
150: where T.TRANSF_RULE_ID = X_TRANSF_RULE_ID
151: and T.LANGUAGE = L.LANGUAGE_CODE);
152:
153: open c;

Line 232: from QPR_TRANSF_RULES_TL

228: cursor c1 is select
229: NAME,
230: DESCRIPTION,
231: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
232: from QPR_TRANSF_RULES_TL
233: where TRANSF_RULE_ID = X_TRANSF_RULE_ID
234: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
235: for update of TRANSF_RULE_ID nowait;
236: begin

Line 394: update QPR_TRANSF_RULES_TL set

390: if (sql%notfound) then
391: raise no_data_found;
392: end if;
393:
394: update QPR_TRANSF_RULES_TL set
395: NAME = X_NAME,
396: DESCRIPTION = X_DESCRIPTION,
397: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
398: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 413: delete from QPR_TRANSF_RULES_TL

409: procedure DELETE_ROW (
410: X_TRANSF_RULE_ID in NUMBER
411: ) is
412: begin
413: delete from QPR_TRANSF_RULES_TL
414: where TRANSF_RULE_ID = X_TRANSF_RULE_ID;
415:
416: if (sql%notfound) then
417: raise no_data_found;

Line 431: delete from QPR_TRANSF_RULES_TL T

427:
428: procedure ADD_LANGUAGE
429: is
430: begin
431: delete from QPR_TRANSF_RULES_TL T
432: where not exists
433: (select NULL
434: from QPR_TRANSF_RULES_B B
435: where B.TRANSF_RULE_ID = T.TRANSF_RULE_ID

Line 438: update QPR_TRANSF_RULES_TL T set (

434: from QPR_TRANSF_RULES_B B
435: where B.TRANSF_RULE_ID = T.TRANSF_RULE_ID
436: );
437:
438: update QPR_TRANSF_RULES_TL T set (
439: NAME,
440: DESCRIPTION
441: ) = (select
442: B.NAME,

Line 444: from QPR_TRANSF_RULES_TL B

440: DESCRIPTION
441: ) = (select
442: B.NAME,
443: B.DESCRIPTION
444: from QPR_TRANSF_RULES_TL B
445: where B.TRANSF_RULE_ID = T.TRANSF_RULE_ID
446: and B.LANGUAGE = T.SOURCE_LANG)
447: where (
448: T.TRANSF_RULE_ID,

Line 453: from QPR_TRANSF_RULES_TL SUBB, QPR_TRANSF_RULES_TL SUBT

449: T.LANGUAGE
450: ) in (select
451: SUBT.TRANSF_RULE_ID,
452: SUBT.LANGUAGE
453: from QPR_TRANSF_RULES_TL SUBB, QPR_TRANSF_RULES_TL SUBT
454: where SUBB.TRANSF_RULE_ID = SUBT.TRANSF_RULE_ID
455: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
456: and (SUBB.NAME <> SUBT.NAME
457: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 462: insert into QPR_TRANSF_RULES_TL (

458: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
459: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
460: ));
461:
462: insert into QPR_TRANSF_RULES_TL (
463: TRANSF_RULE_ID,
464: NAME,
465: DESCRIPTION,
466: CREATION_DATE,

Line 492: from QPR_TRANSF_RULES_TL B, FND_LANGUAGES L

488: B.PROGRAM_APPLICATION_ID,
489: B.REQUEST_ID,
490: L.LANGUAGE_CODE,
491: B.SOURCE_LANG
492: from QPR_TRANSF_RULES_TL B, FND_LANGUAGES L
493: where L.INSTALLED_FLAG in ('I', 'B')
494: and B.LANGUAGE = userenv('LANG')
495: and not exists
496: (select NULL

Line 497: from QPR_TRANSF_RULES_TL T

493: where L.INSTALLED_FLAG in ('I', 'B')
494: and B.LANGUAGE = userenv('LANG')
495: and not exists
496: (select NULL
497: from QPR_TRANSF_RULES_TL T
498: where T.TRANSF_RULE_ID = B.TRANSF_RULE_ID
499: and T.LANGUAGE = L.LANGUAGE_CODE);
500: end ADD_LANGUAGE;
501: