APPS.PV_PROCESS_RULES_PKG dependencies on PV_PROCESS_RULES_TL

Line 146: INSERT INTO PV_PROCESS_RULES_TL (

142: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
143: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
144: );
145:
146: INSERT INTO PV_PROCESS_RULES_TL (
147: PROCESS_RULE_ID,
148: LAST_UPDATE_DATE,
149: LAST_UPDATED_BY,
150: CREATION_DATE,

Line 172: FROM PV_PROCESS_RULES_TL T

168: FROM FND_LANGUAGES L
169: WHERE L.INSTALLED_FLAG IN ('I', 'B')
170: AND NOT EXISTS
171: (SELECT NULL
172: FROM PV_PROCESS_RULES_TL T
173: WHERE T.PROCESS_RULE_ID = PX_PROCESS_RULE_ID
174: AND T.LANGUAGE = L.LANGUAGE_CODE);
175: End Insert_Row;
176:

Line 262: Update PV_PROCESS_RULES_TL

258: If (SQL%NOTFOUND) then
259: RAISE NO_DATA_FOUND;
260: End If;
261:
262: Update PV_PROCESS_RULES_TL
263: SET
264: PROCESS_RULE_NAME = decode( p_PROCESS_RULE_NAME, FND_API.G_MISS_CHAR, PROCESS_RULE_NAME, p_PROCESS_RULE_NAME)
265: ,DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION)
266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

Line 290: DELETE FROM PV_PROCESS_RULES_TL

286: If (SQL%NOTFOUND) then
287: RAISE NO_DATA_FOUND;
288: End If;
289:
290: DELETE FROM PV_PROCESS_RULES_TL
291: WHERE PROCESS_RULE_ID = p_PROCESS_RULE_ID;
292: If (SQL%NOTFOUND) then
293: RAISE NO_DATA_FOUND;
294: End If;

Line 349: FROM PV_PROCESS_RULES_TL

345: CURSOR c1 IS
346: SELECT PROCESS_RULE_NAME,
347: DESCRIPTION,
348: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
349: FROM PV_PROCESS_RULES_TL
350: WHERE PROCESS_RULE_ID = P_PROCESS_RULE_ID
351: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
352: FOR UPDATE OF PROCESS_RULE_ID NOWAIT;
353: BEGIN

Line 494: DELETE FROM PV_PROCESS_RULES_TL T

490:
491: PROCEDURE Add_Language
492: IS
493: BEGIN
494: DELETE FROM PV_PROCESS_RULES_TL T
495: WHERE NOT EXISTS
496: (SELECT NULL
497: FROM PV_PROCESS_RULES_B B
498: WHERE B.PROCESS_RULE_ID = T.PROCESS_RULE_ID

Line 501: UPDATE PV_PROCESS_RULES_TL T SET (

497: FROM PV_PROCESS_RULES_B B
498: WHERE B.PROCESS_RULE_ID = T.PROCESS_RULE_ID
499: );
500:
501: UPDATE PV_PROCESS_RULES_TL T SET (
502: PROCESS_RULE_NAME,
503: DESCRIPTION
504: ) = (SELECT
505: B.PROCESS_RULE_NAME

Line 507: FROM PV_PROCESS_RULES_TL B

503: DESCRIPTION
504: ) = (SELECT
505: B.PROCESS_RULE_NAME
506: ,B.DESCRIPTION
507: FROM PV_PROCESS_RULES_TL B
508: WHERE B.PROCESS_RULE_ID = T.PROCESS_RULE_ID
509: AND B.LANGUAGE = T.SOURCE_LANG)
510: WHERE (
511: T.PROCESS_RULE_ID

Line 516: FROM PV_PROCESS_RULES_TL SUBB, PV_PROCESS_RULES_TL SUBT

512: ,T.LANGUAGE
513: ) IN (SELECT
514: SUBT.PROCESS_RULE_ID
515: ,SUBT.LANGUAGE
516: FROM PV_PROCESS_RULES_TL SUBB, PV_PROCESS_RULES_TL SUBT
517: WHERE SUBB.PROCESS_RULE_ID = SUBT.PROCESS_RULE_ID
518: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
519: AND (SUBB.PROCESS_RULE_NAME <> SUBT.PROCESS_RULE_NAME
520: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 526: INSERT INTO PV_PROCESS_RULES_TL (

522: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
523: )
524: );
525:
526: INSERT INTO PV_PROCESS_RULES_TL (
527: PROCESS_RULE_ID
528: ,LAST_UPDATE_DATE
529: ,LAST_UPDATED_BY
530: ,CREATION_DATE

Line 548: FROM PV_PROCESS_RULES_TL B, FND_LANGUAGES L

544: ,L.LANGUAGE_CODE
545: ,B.SOURCE_LANG
546: ,B.PROCESS_RULE_NAME
547: ,B.DESCRIPTION
548: FROM PV_PROCESS_RULES_TL B, FND_LANGUAGES L
549: WHERE L.INSTALLED_FLAG IN ('I', 'B')
550: AND B.LANGUAGE = USERENV('LANG')
551: AND NOT EXISTS
552: (SELECT NULL

Line 553: FROM PV_PROCESS_RULES_TL T

549: WHERE L.INSTALLED_FLAG IN ('I', 'B')
550: AND B.LANGUAGE = USERENV('LANG')
551: AND NOT EXISTS
552: (SELECT NULL
553: FROM PV_PROCESS_RULES_TL T
554: WHERE T.PROCESS_RULE_ID = B.PROCESS_RULE_ID
555: AND T.LANGUAGE = L.LANGUAGE_CODE);
556:
557: END Add_Language;

Line 693: UPDATE PV_PROCESS_RULES_TL SET

689:
690: IS
691:
692: BEGIN
693: UPDATE PV_PROCESS_RULES_TL SET
694: PROCESS_RULE_NAME = NVL(p_PROCESS_RULE_NAME, PROCESS_RULE_NAME)
695: ,DESCRIPTION = NVL(p_DESCRIPTION, DESCRIPTION)
696: ,SOURCE_LANG = USERENV('LANG')
697: ,LAST_UPDATE_DATE = SYSDATE