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 FND_API

Line 38: DECODE(p_source_table, FND_API.G_MISS_CHAR, NULL, p_source_table),

34: last_update_login,
35: object_version_number
36: ) VALUES (
37: xle_histories_s.NEXTVAL,
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),

Line 39: DECODE(p_source_id, FND_API.G_MISS_NUM, NULL, p_source_id),

35: object_version_number
36: ) VALUES (
37: xle_histories_s.NEXTVAL,
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),

Line 40: DECODE(p_source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),

36: ) VALUES (
37: xle_histories_s.NEXTVAL,
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),

Line 41: DECODE(p_source_column_value, FND_API.G_MISS_CHAR, NULL, p_source_column_value),

37: xle_histories_s.NEXTVAL,
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,

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 43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),

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,
47: XLE_UTILITY_PUB.CREATION_DATE,

Line 44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),

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,
47: XLE_UTILITY_PUB.CREATION_DATE,
48: XLE_UTILITY_PUB.CREATED_BY,

Line 50: DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)

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
54: x_history_id;

Line 73: source_table = DECODE(p_source_table, NULL, source_table, FND_API.G_MISS_CHAR, NULL, p_source_table),

69: p_object_version_number IN NUMBER
70: ) IS
71: BEGIN
72: UPDATE xle_histories SET
73: source_table = DECODE(p_source_table, NULL, source_table, FND_API.G_MISS_CHAR, NULL, p_source_table),
74: source_id = DECODE(p_source_id, NULL, source_id, FND_API.G_MISS_NUM, NULL, p_source_id),
75: source_column_name = DECODE(p_source_column_name, NULL, source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),
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),

Line 74: source_id = DECODE(p_source_id, NULL, source_id, FND_API.G_MISS_NUM, NULL, p_source_id),

70: ) IS
71: BEGIN
72: UPDATE xle_histories SET
73: source_table = DECODE(p_source_table, NULL, source_table, FND_API.G_MISS_CHAR, NULL, p_source_table),
74: source_id = DECODE(p_source_id, NULL, source_id, FND_API.G_MISS_NUM, NULL, p_source_id),
75: source_column_name = DECODE(p_source_column_name, NULL, source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),
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),

Line 75: source_column_name = DECODE(p_source_column_name, NULL, source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),

71: BEGIN
72: UPDATE xle_histories SET
73: source_table = DECODE(p_source_table, NULL, source_table, FND_API.G_MISS_CHAR, NULL, p_source_table),
74: source_id = DECODE(p_source_id, NULL, source_id, FND_API.G_MISS_NUM, NULL, p_source_id),
75: source_column_name = DECODE(p_source_column_name, NULL, source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),
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),

Line 76: source_column_value = DECODE(p_source_column_value, NULL, source_column_value, FND_API.G_MISS_CHAR, NULL, p_source_column_value),

72: UPDATE xle_histories SET
73: source_table = DECODE(p_source_table, NULL, source_table, FND_API.G_MISS_CHAR, NULL, p_source_table),
74: source_id = DECODE(p_source_id, NULL, source_id, FND_API.G_MISS_NUM, NULL, p_source_id),
75: source_column_name = DECODE(p_source_column_name, NULL, source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),
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,

Line 77: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),

73: source_table = DECODE(p_source_table, NULL, source_table, FND_API.G_MISS_CHAR, NULL, p_source_table),
74: source_id = DECODE(p_source_id, NULL, source_id, FND_API.G_MISS_NUM, NULL, p_source_id),
75: source_column_name = DECODE(p_source_column_name, NULL, source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),
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,

Line 78: effective_to = DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),

74: source_id = DECODE(p_source_id, NULL, source_id, FND_API.G_MISS_NUM, NULL, p_source_id),
75: source_column_name = DECODE(p_source_column_name, NULL, source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),
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,

Line 79: comments = DECODE(p_comment, NULL, comments, FND_API.G_MISS_CHAR, NULL, p_comment),

75: source_column_name = DECODE(p_source_column_name, NULL, source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),
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)

Line 83: object_version_number= DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)

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
87: RAISE no_data_found;