eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_DETERMINING_FACTORS_PKG dependencies on ZX_DETERMINING_FACTORS_PKG

Line 1: package body ZX_DETERMINING_FACTORS_PKG as

1: package body ZX_DETERMINING_FACTORS_PKG as
2: /* $Header: zxritrldetfactb.pls 120.14 2005/11/01 23:51:58 rsanthan ship $ */
3:
4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 45: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_ROW.BEGIN',

41:
42: BEGIN
43: IF (g_level_procedure >= g_current_runtime_level ) THEN
44: FND_LOG.STRING(g_level_procedure,
45: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_ROW.BEGIN',
46: 'ZX_DETERMINING_FACTORS_PKG.INSERT_ROW (+)');
47: END IF;
48:
49: INSERT INTO ZX_DETERMINING_FACTORS_B (DETERMINING_FACTOR_ID,

Line 46: 'ZX_DETERMINING_FACTORS_PKG.INSERT_ROW (+)');

42: BEGIN
43: IF (g_level_procedure >= g_current_runtime_level ) THEN
44: FND_LOG.STRING(g_level_procedure,
45: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_ROW.BEGIN',
46: 'ZX_DETERMINING_FACTORS_PKG.INSERT_ROW (+)');
47: END IF;
48:
49: INSERT INTO ZX_DETERMINING_FACTORS_B (DETERMINING_FACTOR_ID,
50: DETERMINING_FACTOR_CODE,

Line 131: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_ROW.END',

127: CLOSE C;
128:
129: IF (g_level_procedure >= g_current_runtime_level ) THEN
130: FND_LOG.STRING(g_level_procedure,
131: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_ROW.END',
132: 'ZX_DETERMINING_FACTORS_PKG.INSERT_ROW (-)');
133: END IF;
134: END INSERT_ROW;
135:

Line 132: 'ZX_DETERMINING_FACTORS_PKG.INSERT_ROW (-)');

128:
129: IF (g_level_procedure >= g_current_runtime_level ) THEN
130: FND_LOG.STRING(g_level_procedure,
131: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_ROW.END',
132: 'ZX_DETERMINING_FACTORS_PKG.INSERT_ROW (-)');
133: END IF;
134: END INSERT_ROW;
135:
136: PROCEDURE LOCK_ROW

Line 191: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.LOCK_ROW.BEGIN',

187:
188: BEGIN
189: IF (g_level_procedure >= g_current_runtime_level ) THEN
190: FND_LOG.STRING(g_level_procedure,
191: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.LOCK_ROW.BEGIN',
192: 'ZX_DETERMINING_FACTORS_PKG.LOCK_ROW (+)');
193: END IF;
194:
195: OPEN C;

Line 192: 'ZX_DETERMINING_FACTORS_PKG.LOCK_ROW (+)');

188: BEGIN
189: IF (g_level_procedure >= g_current_runtime_level ) THEN
190: FND_LOG.STRING(g_level_procedure,
191: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.LOCK_ROW.BEGIN',
192: 'ZX_DETERMINING_FACTORS_PKG.LOCK_ROW (+)');
193: END IF;
194:
195: OPEN C;
196: FETCH C INTO RECINFO;

Line 263: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.LOCK_ROW.END',

259: END LOOP;
260:
261: IF (g_level_procedure >= g_current_runtime_level ) THEN
262: FND_LOG.STRING(g_level_procedure,
263: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.LOCK_ROW.END',
264: 'ZX_DETERMINING_FACTORS_PKG.LOCK_ROW (-)');
265: END IF;
266:
267: RETURN;

Line 264: 'ZX_DETERMINING_FACTORS_PKG.LOCK_ROW (-)');

260:
261: IF (g_level_procedure >= g_current_runtime_level ) THEN
262: FND_LOG.STRING(g_level_procedure,
263: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.LOCK_ROW.END',
264: 'ZX_DETERMINING_FACTORS_PKG.LOCK_ROW (-)');
265: END IF;
266:
267: RETURN;
268: END LOCK_ROW;

Line 297: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW.BEGIN',

293:
294: BEGIN
295: IF (g_level_procedure >= g_current_runtime_level ) THEN
296: FND_LOG.STRING(g_level_procedure,
297: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW.BEGIN',
298: 'ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW (+)');
299: END IF;
300:
301: UPDATE ZX_DETERMINING_FACTORS_B

Line 298: 'ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW (+)');

294: BEGIN
295: IF (g_level_procedure >= g_current_runtime_level ) THEN
296: FND_LOG.STRING(g_level_procedure,
297: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW.BEGIN',
298: 'ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW (+)');
299: END IF;
300:
301: UPDATE ZX_DETERMINING_FACTORS_B
302: SET DETERMINING_FACTOR_CODE = X_DETERMINING_FACTOR_CODE,

Line 343: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW.END',

339: END IF;
340:
341: IF (g_level_procedure >= g_current_runtime_level ) THEN
342: FND_LOG.STRING(g_level_procedure,
343: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW.END',
344: 'ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW (-)');
345: END IF;
346:
347: END UPDATE_ROW;

Line 344: 'ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW (-)');

340:
341: IF (g_level_procedure >= g_current_runtime_level ) THEN
342: FND_LOG.STRING(g_level_procedure,
343: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW.END',
344: 'ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW (-)');
345: END IF;
346:
347: END UPDATE_ROW;
348:

Line 355: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.DELETE_ROW.BEGIN',

351:
352: BEGIN
353: IF (g_level_procedure >= g_current_runtime_level ) THEN
354: FND_LOG.STRING(g_level_procedure,
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

Line 356: 'ZX_DETERMINING_FACTORS_PKG.DELETE_ROW (+)');

352: BEGIN
353: IF (g_level_procedure >= g_current_runtime_level ) THEN
354: FND_LOG.STRING(g_level_procedure,
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;

Line 375: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.DELETE_ROW.END',

371: END IF;
372:
373: IF (g_level_procedure >= g_current_runtime_level ) THEN
374: FND_LOG.STRING(g_level_procedure,
375: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.DELETE_ROW.END',
376: 'ZX_DETERMINING_FACTORS_PKG.DELETE_ROW (-)');
377: END IF;
378:
379: END DELETE_ROW;

Line 376: 'ZX_DETERMINING_FACTORS_PKG.DELETE_ROW (-)');

372:
373: IF (g_level_procedure >= g_current_runtime_level ) THEN
374: FND_LOG.STRING(g_level_procedure,
375: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.DELETE_ROW.END',
376: 'ZX_DETERMINING_FACTORS_PKG.DELETE_ROW (-)');
377: END IF;
378:
379: END DELETE_ROW;
380:

Line 386: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE.BEGIN',

382:
383: BEGIN
384: IF (g_level_procedure >= g_current_runtime_level ) THEN
385: FND_LOG.STRING(g_level_procedure,
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

Line 387: 'ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE (+)');

383: BEGIN
384: IF (g_level_procedure >= g_current_runtime_level ) THEN
385: FND_LOG.STRING(g_level_procedure,
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

Line 448: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE.END',

444: AND T.LANGUAGE = L.LANGUAGE_CODE);
445:
446: IF (g_level_procedure >= g_current_runtime_level ) THEN
447: FND_LOG.STRING(g_level_procedure,
448: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE.END',
449: 'ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE (-)');
450: END IF;
451:
452: END ADD_LANGUAGE;

Line 449: 'ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE (-)');

445:
446: IF (g_level_procedure >= g_current_runtime_level ) THEN
447: FND_LOG.STRING(g_level_procedure,
448: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE.END',
449: 'ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE (-)');
450: END IF;
451:
452: END ADD_LANGUAGE;
453:

Line 469: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW.BEGIN',

465: AND DETERMINING_FACTOR_CODE = X_DETERMINING_FACTOR_CODE;
466: BEGIN
467: IF (g_level_procedure >= g_current_runtime_level ) THEN
468: FND_LOG.STRING(g_level_procedure,
469: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW.BEGIN',
470: 'ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW (+)');
471: END IF;
472:
473: OPEN C;

Line 470: 'ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW (+)');

466: BEGIN
467: IF (g_level_procedure >= g_current_runtime_level ) THEN
468: FND_LOG.STRING(g_level_procedure,
469: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW.BEGIN',
470: 'ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW (+)');
471: END IF;
472:
473: OPEN C;
474: FETCH C INTO X_ROWID;

Line 517: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW.END',

513: END IF;
514: CLOSE C;
515: IF (g_level_procedure >= g_current_runtime_level ) THEN
516: FND_LOG.STRING(g_level_procedure,
517: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW.END',
518: 'ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW (-)');
519: END IF;
520:
521: END INSERT_GEOGRAPHY_ROW;

Line 518: 'ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW (-)');

514: CLOSE C;
515: IF (g_level_procedure >= g_current_runtime_level ) THEN
516: FND_LOG.STRING(g_level_procedure,
517: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW.END',
518: 'ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW (-)');
519: END IF;
520:
521: END INSERT_GEOGRAPHY_ROW;
522:

Line 523: END ZX_DETERMINING_FACTORS_PKG;

519: END IF;
520:
521: END INSERT_GEOGRAPHY_ROW;
522:
523: END ZX_DETERMINING_FACTORS_PKG;