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.EC_CODE_CONVERSION_PVT dependencies on ECE_XREF_DATA

Line 35: l_Int_val ece_xref_data.xref_int_value%TYPE := NULL;

31:
32: /* bug 5865153
33: l_Int_val varchar2(80) := NULL; */
34:
35: l_Int_val ece_xref_data.xref_int_value%TYPE := NULL;
36:
37:
38: CURSOR match_5 IS
39: SELECT XREF_INT_VALUE

Line 40: FROM ECE_XREF_DATA

36:
37:
38: CURSOR match_5 IS
39: SELECT XREF_INT_VALUE
40: FROM ECE_XREF_DATA
41: WHERE XREF_KEY1 IS NOT NULL AND
42: XREF_KEY2 IS NOT NULL AND
43: XREF_KEY3 IS NOT NULL AND
44: XREF_KEY4 IS NOT NULL AND

Line 61: FROM ECE_XREF_DATA

57: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
58:
59: CURSOR match_4 IS
60: SELECT XREF_INT_VALUE
61: FROM ECE_XREF_DATA
62: WHERE XREF_KEY1 IS NOT NULL AND
63: XREF_KEY2 IS NOT NULL AND
64: XREF_KEY3 IS NOT NULL AND
65: XREF_KEY4 IS NOT NULL AND

Line 81: FROM ECE_XREF_DATA

77: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
78:
79: CURSOR match_3 IS
80: SELECT XREF_INT_VALUE
81: FROM ECE_XREF_DATA
82: WHERE XREF_KEY1 IS NOT NULL AND
83: XREF_KEY2 IS NOT NULL AND
84: XREF_KEY3 IS NOT NULL AND
85: XREF_KEY4 IS NULL AND

Line 100: FROM ECE_XREF_DATA

96: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
97:
98: CURSOR match_2 IS
99: SELECT XREF_INT_VALUE
100: FROM ECE_XREF_DATA
101: WHERE XREF_KEY1 IS NOT NULL AND
102: XREF_KEY2 IS NOT NULL AND
103: XREF_KEY3 IS NULL AND
104: XREF_KEY4 IS NULL AND

Line 118: FROM ECE_XREF_DATA

114: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
115:
116: CURSOR match_1 IS
117: SELECT XREF_INT_VALUE
118: FROM ECE_XREF_DATA
119: WHERE XREF_KEY1 IS NOT NULL AND
120: XREF_KEY2 IS NULL AND
121: XREF_KEY3 IS NULL AND
122: XREF_KEY4 IS NULL AND

Line 135: FROM ECE_XREF_DATA

131: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
132:
133: CURSOR match_global IS
134: SELECT XREF_INT_VALUE
135: FROM ECE_XREF_DATA
136: WHERE XREF_KEY1 IS NULL AND
137: XREF_KEY2 IS NULL AND
138: XREF_KEY3 IS NULL AND
139: XREF_KEY4 IS NULL AND

Line 440: l_Ext_val1 ece_xref_data.xref_ext_value1%TYPE := NULL;

436: l_Ext_val3 varchar2(500) := NULL;
437: l_Ext_val4 varchar2(500) := NULL;
438: l_Ext_val5 varchar2(500) := NULL; */
439:
440: l_Ext_val1 ece_xref_data.xref_ext_value1%TYPE := NULL;
441: l_Ext_val2 ece_xref_data.xref_ext_value2%TYPE := NULL;
442: l_Ext_val3 ece_xref_data.xref_ext_value3%TYPE := NULL;
443: l_Ext_val4 ece_xref_data.xref_ext_value4%TYPE := NULL;
444: l_Ext_val5 ece_xref_data.xref_ext_value5%TYPE := NULL;

Line 441: l_Ext_val2 ece_xref_data.xref_ext_value2%TYPE := NULL;

437: l_Ext_val4 varchar2(500) := NULL;
438: l_Ext_val5 varchar2(500) := NULL; */
439:
440: l_Ext_val1 ece_xref_data.xref_ext_value1%TYPE := NULL;
441: l_Ext_val2 ece_xref_data.xref_ext_value2%TYPE := NULL;
442: l_Ext_val3 ece_xref_data.xref_ext_value3%TYPE := NULL;
443: l_Ext_val4 ece_xref_data.xref_ext_value4%TYPE := NULL;
444: l_Ext_val5 ece_xref_data.xref_ext_value5%TYPE := NULL;
445:

Line 442: l_Ext_val3 ece_xref_data.xref_ext_value3%TYPE := NULL;

438: l_Ext_val5 varchar2(500) := NULL; */
439:
440: l_Ext_val1 ece_xref_data.xref_ext_value1%TYPE := NULL;
441: l_Ext_val2 ece_xref_data.xref_ext_value2%TYPE := NULL;
442: l_Ext_val3 ece_xref_data.xref_ext_value3%TYPE := NULL;
443: l_Ext_val4 ece_xref_data.xref_ext_value4%TYPE := NULL;
444: l_Ext_val5 ece_xref_data.xref_ext_value5%TYPE := NULL;
445:
446:

Line 443: l_Ext_val4 ece_xref_data.xref_ext_value4%TYPE := NULL;

439:
440: l_Ext_val1 ece_xref_data.xref_ext_value1%TYPE := NULL;
441: l_Ext_val2 ece_xref_data.xref_ext_value2%TYPE := NULL;
442: l_Ext_val3 ece_xref_data.xref_ext_value3%TYPE := NULL;
443: l_Ext_val4 ece_xref_data.xref_ext_value4%TYPE := NULL;
444: l_Ext_val5 ece_xref_data.xref_ext_value5%TYPE := NULL;
445:
446:
447: CURSOR match_5 IS

Line 444: l_Ext_val5 ece_xref_data.xref_ext_value5%TYPE := NULL;

440: l_Ext_val1 ece_xref_data.xref_ext_value1%TYPE := NULL;
441: l_Ext_val2 ece_xref_data.xref_ext_value2%TYPE := NULL;
442: l_Ext_val3 ece_xref_data.xref_ext_value3%TYPE := NULL;
443: l_Ext_val4 ece_xref_data.xref_ext_value4%TYPE := NULL;
444: l_Ext_val5 ece_xref_data.xref_ext_value5%TYPE := NULL;
445:
446:
447: CURSOR match_5 IS
448: SELECT XREF_EXT_VALUE1,

Line 453: FROM ECE_XREF_DATA

449: XREF_EXT_VALUE2,
450: XREF_EXT_VALUE3,
451: XREF_EXT_VALUE4,
452: XREF_EXT_VALUE5
453: FROM ECE_XREF_DATA
454: WHERE XREF_KEY1 IS NOT NULL AND
455: XREF_KEY2 IS NOT NULL AND
456: XREF_KEY3 IS NOT NULL AND
457: XREF_KEY4 IS NOT NULL AND

Line 474: FROM ECE_XREF_DATA

470: XREF_EXT_VALUE2,
471: XREF_EXT_VALUE3,
472: XREF_EXT_VALUE4,
473: XREF_EXT_VALUE5
474: FROM ECE_XREF_DATA
475: WHERE XREF_KEY1 IS NOT NULL AND
476: XREF_KEY2 IS NOT NULL AND
477: XREF_KEY3 IS NOT NULL AND
478: XREF_KEY4 IS NOT NULL AND

Line 494: FROM ECE_XREF_DATA

490: XREF_EXT_VALUE2,
491: XREF_EXT_VALUE3,
492: XREF_EXT_VALUE4,
493: XREF_EXT_VALUE5
494: FROM ECE_XREF_DATA
495: WHERE XREF_KEY1 IS NOT NULL AND
496: XREF_KEY2 IS NOT NULL AND
497: XREF_KEY3 IS NOT NULL AND
498: XREF_KEY4 IS NULL AND

Line 513: FROM ECE_XREF_DATA

509: XREF_EXT_VALUE2,
510: XREF_EXT_VALUE3,
511: XREF_EXT_VALUE4,
512: XREF_EXT_VALUE5
513: FROM ECE_XREF_DATA
514: WHERE XREF_KEY1 IS NOT NULL AND
515: XREF_KEY2 IS NOT NULL AND
516: XREF_KEY3 IS NULL AND
517: XREF_KEY4 IS NULL AND

Line 531: FROM ECE_XREF_DATA

527: XREF_EXT_VALUE2,
528: XREF_EXT_VALUE3,
529: XREF_EXT_VALUE4,
530: XREF_EXT_VALUE5
531: FROM ECE_XREF_DATA
532: WHERE XREF_KEY1 IS NOT NULL AND
533: XREF_KEY2 IS NULL AND
534: XREF_KEY3 IS NULL AND
535: XREF_KEY4 IS NULL AND

Line 548: FROM ECE_XREF_DATA

544: XREF_EXT_VALUE2,
545: XREF_EXT_VALUE3,
546: XREF_EXT_VALUE4,
547: XREF_EXT_VALUE5
548: FROM ECE_XREF_DATA
549: WHERE XREF_KEY1 IS NULL AND
550: XREF_KEY2 IS NULL AND
551: XREF_KEY3 IS NULL AND
552: XREF_KEY4 IS NULL AND