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.XLE_HISTORIES_PKG dependencies on XLE_UTILITY_PUB

Line 42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),

38: DECODE(p_source_table, FND_API.G_MISS_CHAR, NULL, p_source_table),
39: DECODE(p_source_id, FND_API.G_MISS_NUM, NULL, p_source_id),
40: DECODE(p_source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),
41: DECODE(p_source_column_value, FND_API.G_MISS_CHAR, NULL, p_source_column_value),
42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),
43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),
45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,
46: XLE_UTILITY_PUB.LAST_UPDATED_BY,

Line 45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,

41: DECODE(p_source_column_value, FND_API.G_MISS_CHAR, NULL, p_source_column_value),
42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),
43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),
45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,
46: XLE_UTILITY_PUB.LAST_UPDATED_BY,
47: XLE_UTILITY_PUB.CREATION_DATE,
48: XLE_UTILITY_PUB.CREATED_BY,
49: XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,

Line 46: XLE_UTILITY_PUB.LAST_UPDATED_BY,

42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),
43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),
45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,
46: XLE_UTILITY_PUB.LAST_UPDATED_BY,
47: XLE_UTILITY_PUB.CREATION_DATE,
48: XLE_UTILITY_PUB.CREATED_BY,
49: XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
50: DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)

Line 47: XLE_UTILITY_PUB.CREATION_DATE,

43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),
45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,
46: XLE_UTILITY_PUB.LAST_UPDATED_BY,
47: XLE_UTILITY_PUB.CREATION_DATE,
48: XLE_UTILITY_PUB.CREATED_BY,
49: XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
50: DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
51: ) RETURNING

Line 48: XLE_UTILITY_PUB.CREATED_BY,

44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),
45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,
46: XLE_UTILITY_PUB.LAST_UPDATED_BY,
47: XLE_UTILITY_PUB.CREATION_DATE,
48: XLE_UTILITY_PUB.CREATED_BY,
49: XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
50: DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
51: ) RETURNING
52: history_id

Line 49: XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,

45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,
46: XLE_UTILITY_PUB.LAST_UPDATED_BY,
47: XLE_UTILITY_PUB.CREATION_DATE,
48: XLE_UTILITY_PUB.CREATED_BY,
49: XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
50: DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
51: ) RETURNING
52: history_id
53: INTO

Line 80: last_update_date = XLE_UTILITY_PUB.LAST_UPDATE_DATE,

76: source_column_value = DECODE(p_source_column_value, NULL, source_column_value, FND_API.G_MISS_CHAR, NULL, p_source_column_value),
77: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
78: effective_to = DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
79: comments = DECODE(p_comment, NULL, comments, FND_API.G_MISS_CHAR, NULL, p_comment),
80: last_update_date = XLE_UTILITY_PUB.LAST_UPDATE_DATE,
81: last_updated_by = XLE_UTILITY_PUB.LAST_UPDATED_BY,
82: last_update_login = XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
83: object_version_number= DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
84: WHERE history_id = p_history_id;

Line 81: last_updated_by = XLE_UTILITY_PUB.LAST_UPDATED_BY,

77: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
78: effective_to = DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
79: comments = DECODE(p_comment, NULL, comments, FND_API.G_MISS_CHAR, NULL, p_comment),
80: last_update_date = XLE_UTILITY_PUB.LAST_UPDATE_DATE,
81: last_updated_by = XLE_UTILITY_PUB.LAST_UPDATED_BY,
82: last_update_login = XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
83: object_version_number= DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
84: WHERE history_id = p_history_id;
85:

Line 82: last_update_login = XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,

78: effective_to = DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
79: comments = DECODE(p_comment, NULL, comments, FND_API.G_MISS_CHAR, NULL, p_comment),
80: last_update_date = XLE_UTILITY_PUB.LAST_UPDATE_DATE,
81: last_updated_by = XLE_UTILITY_PUB.LAST_UPDATED_BY,
82: last_update_login = XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
83: object_version_number= DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
84: WHERE history_id = p_history_id;
85:
86: IF (sql%notfound) THEN