APPS.ZX_DETERMINING_FACTORS_PKG dependencies on ZX_DET_FACTORS_TL

Line 94: INSERT INTO ZX_DET_FACTORS_TL (DETERMINING_FACTOR_NAME,

90: X_LAST_UPDATED_BY,
91: X_LAST_UPDATE_LOGIN,
92: X_OBJECT_VERSION_NUMBER);
93:
94: INSERT INTO ZX_DET_FACTORS_TL (DETERMINING_FACTOR_NAME,
95: DETERMINING_FACTOR_DESC,
96: CREATION_DATE,
97: CREATED_BY,
98: LAST_UPDATE_DATE,

Line 117: FROM ZX_DET_FACTORS_TL T

113: userenv('LANG')
114: FROM FND_LANGUAGES L
115: WHERE L.INSTALLED_FLAG in ('I', 'B')
116: AND NOT EXISTS (SELECT NULL
117: FROM ZX_DET_FACTORS_TL T
118: WHERE T.DETERMINING_FACTOR_ID = X_DETERMINING_FACTOR_ID
119: AND T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: OPEN C;

Line 183: FROM ZX_DET_FACTORS_TL

179: CURSOR C1 IS
180: SELECT DETERMINING_FACTOR_NAME,
181: DETERMINING_FACTOR_DESC,
182: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
183: FROM ZX_DET_FACTORS_TL
184: WHERE DETERMINING_FACTOR_ID = X_DETERMINING_FACTOR_ID
185: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
186: FOR UPDATE OF DETERMINING_FACTOR_ID NOWAIT;
187:

Line 327: UPDATE ZX_DET_FACTORS_TL

323: IF (SQL%NOTFOUND) THEN
324: RAISE NO_DATA_FOUND;
325: END IF;
326:
327: UPDATE ZX_DET_FACTORS_TL
328: SET DETERMINING_FACTOR_NAME = X_DETERMINING_FACTOR_NAME,
329: DETERMINING_FACTOR_DESC = X_DETERMINING_FACTOR_DESC,
330: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
331: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 359: DELETE FROM ZX_DET_FACTORS_TL

355: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.DELETE_ROW.BEGIN',
356: 'ZX_DETERMINING_FACTORS_PKG.DELETE_ROW (+)');
357: END IF;
358:
359: DELETE FROM ZX_DET_FACTORS_TL
360: WHERE DETERMINING_FACTOR_ID = X_DETERMINING_FACTOR_ID;
361:
362: IF (sql%notfound) THEN
363: RAISE NO_DATA_FOUND;

Line 390: DELETE FROM ZX_DET_FACTORS_TL T

386: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE.BEGIN',
387: 'ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE (+)');
388: END IF;
389:
390: DELETE FROM ZX_DET_FACTORS_TL T
391: WHERE NOT EXISTS (SELECT NULL
392: FROM ZX_DETERMINING_FACTORS_B B
393: WHERE B.DETERMINING_FACTOR_ID = T.DETERMINING_FACTOR_ID);
394:

Line 395: UPDATE ZX_DET_FACTORS_TL T

391: WHERE NOT EXISTS (SELECT NULL
392: FROM ZX_DETERMINING_FACTORS_B B
393: WHERE B.DETERMINING_FACTOR_ID = T.DETERMINING_FACTOR_ID);
394:
395: UPDATE ZX_DET_FACTORS_TL T
396: SET (DETERMINING_FACTOR_NAME,
397: DETERMINING_FACTOR_DESC) = (SELECT B.DETERMINING_FACTOR_NAME,
398: B.DETERMINING_FACTOR_DESC
399: FROM ZX_DET_FACTORS_TL B

Line 399: FROM ZX_DET_FACTORS_TL B

395: UPDATE ZX_DET_FACTORS_TL T
396: SET (DETERMINING_FACTOR_NAME,
397: DETERMINING_FACTOR_DESC) = (SELECT B.DETERMINING_FACTOR_NAME,
398: B.DETERMINING_FACTOR_DESC
399: FROM ZX_DET_FACTORS_TL B
400: WHERE B.DETERMINING_FACTOR_ID = T.DETERMINING_FACTOR_ID
401: AND B.LANGUAGE = T.SOURCE_LANG)
402: WHERE (T.DETERMINING_FACTOR_ID,
403: T.LANGUAGE) IN (SELECT SUBT.DETERMINING_FACTOR_ID,

Line 405: FROM ZX_DET_FACTORS_TL SUBB,

401: AND B.LANGUAGE = T.SOURCE_LANG)
402: WHERE (T.DETERMINING_FACTOR_ID,
403: T.LANGUAGE) IN (SELECT SUBT.DETERMINING_FACTOR_ID,
404: SUBT.LANGUAGE
405: FROM ZX_DET_FACTORS_TL SUBB,
406: ZX_DET_FACTORS_TL SUBT
407: WHERE SUBB.DETERMINING_FACTOR_ID = SUBT.DETERMINING_FACTOR_ID
408: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
409: AND (SUBB.DETERMINING_FACTOR_NAME <> SUBT.DETERMINING_FACTOR_NAME OR

Line 406: ZX_DET_FACTORS_TL SUBT

402: WHERE (T.DETERMINING_FACTOR_ID,
403: T.LANGUAGE) IN (SELECT SUBT.DETERMINING_FACTOR_ID,
404: SUBT.LANGUAGE
405: FROM ZX_DET_FACTORS_TL SUBB,
406: ZX_DET_FACTORS_TL SUBT
407: WHERE SUBB.DETERMINING_FACTOR_ID = SUBT.DETERMINING_FACTOR_ID
408: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
409: AND (SUBB.DETERMINING_FACTOR_NAME <> SUBT.DETERMINING_FACTOR_NAME OR
410: SUBB.DETERMINING_FACTOR_DESC <> SUBT.DETERMINING_FACTOR_DESC OR

Line 416: INSERT INTO ZX_DET_FACTORS_TL (DETERMINING_FACTOR_NAME,

412: SUBT.DETERMINING_FACTOR_DESC IS NOT NULL) OR
413: (SUBB.DETERMINING_FACTOR_DESC IS NOT NULL AND
414: SUBT.DETERMINING_FACTOR_DESC IS NULL)));
415:
416: INSERT INTO ZX_DET_FACTORS_TL (DETERMINING_FACTOR_NAME,
417: DETERMINING_FACTOR_DESC,
418: CREATION_DATE,
419: CREATED_BY,
420: LAST_UPDATE_DATE,

Line 437: FROM ZX_DET_FACTORS_TL B,

433: B.LAST_UPDATE_LOGIN,
434: B.DETERMINING_FACTOR_ID,
435: L.LANGUAGE_CODE,
436: B.SOURCE_LANG
437: FROM ZX_DET_FACTORS_TL B,
438: FND_LANGUAGES L
439: WHERE L.INSTALLED_FLAG IN ('I', 'B')
440: AND B.LANGUAGE = USERENV('LANG')
441: AND NOT EXISTS (SELECT NULL

Line 442: FROM ZX_DET_FACTORS_TL T

438: FND_LANGUAGES L
439: WHERE L.INSTALLED_FLAG IN ('I', 'B')
440: AND B.LANGUAGE = USERENV('LANG')
441: AND NOT EXISTS (SELECT NULL
442: FROM ZX_DET_FACTORS_TL T
443: WHERE T.DETERMINING_FACTOR_ID = B.DETERMINING_FACTOR_ID
444: AND T.LANGUAGE = L.LANGUAGE_CODE);
445:
446: IF (g_level_procedure >= g_current_runtime_level ) THEN