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.CN_REASON_HISTORY_PKG dependencies on FND_API

Line 55: DECODE(p_reason_history_all_rec.REASON_HISTORY_ID, FND_API.G_MISS_NUM, NULL,

51: LAST_UPDATED_BY,
52: LAST_UPDATE_LOGIN,
53: OBJECT_VERSION_NUMBER)
54: select
55: DECODE(p_reason_history_all_rec.REASON_HISTORY_ID, FND_API.G_MISS_NUM, NULL,
56: p_reason_history_all_rec.REASON_HISTORY_ID),
57: DECODE(p_reason_history_all_rec.REASON_ID, FND_API.G_MISS_NUM, NULL,
58: p_reason_history_all_rec.REASON_ID),
59: DECODE(p_reason_history_all_rec.UPDATED_TABLE, FND_API.G_MISS_CHAR, NULL,

Line 57: DECODE(p_reason_history_all_rec.REASON_ID, FND_API.G_MISS_NUM, NULL,

53: OBJECT_VERSION_NUMBER)
54: select
55: DECODE(p_reason_history_all_rec.REASON_HISTORY_ID, FND_API.G_MISS_NUM, NULL,
56: p_reason_history_all_rec.REASON_HISTORY_ID),
57: DECODE(p_reason_history_all_rec.REASON_ID, FND_API.G_MISS_NUM, NULL,
58: p_reason_history_all_rec.REASON_ID),
59: DECODE(p_reason_history_all_rec.UPDATED_TABLE, FND_API.G_MISS_CHAR, NULL,
60: p_reason_history_all_rec.UPDATED_TABLE),
61: DECODE(p_reason_history_all_rec.UPD_TABLE_ID, FND_API.G_MISS_NUM, NULL,

Line 59: DECODE(p_reason_history_all_rec.UPDATED_TABLE, FND_API.G_MISS_CHAR, NULL,

55: DECODE(p_reason_history_all_rec.REASON_HISTORY_ID, FND_API.G_MISS_NUM, NULL,
56: p_reason_history_all_rec.REASON_HISTORY_ID),
57: DECODE(p_reason_history_all_rec.REASON_ID, FND_API.G_MISS_NUM, NULL,
58: p_reason_history_all_rec.REASON_ID),
59: DECODE(p_reason_history_all_rec.UPDATED_TABLE, FND_API.G_MISS_CHAR, NULL,
60: p_reason_history_all_rec.UPDATED_TABLE),
61: DECODE(p_reason_history_all_rec.UPD_TABLE_ID, FND_API.G_MISS_NUM, NULL,
62: p_reason_history_all_rec.UPD_TABLE_ID),
63: l_reason,

Line 61: DECODE(p_reason_history_all_rec.UPD_TABLE_ID, FND_API.G_MISS_NUM, NULL,

57: DECODE(p_reason_history_all_rec.REASON_ID, FND_API.G_MISS_NUM, NULL,
58: p_reason_history_all_rec.REASON_ID),
59: DECODE(p_reason_history_all_rec.UPDATED_TABLE, FND_API.G_MISS_CHAR, NULL,
60: p_reason_history_all_rec.UPDATED_TABLE),
61: DECODE(p_reason_history_all_rec.UPD_TABLE_ID, FND_API.G_MISS_NUM, NULL,
62: p_reason_history_all_rec.UPD_TABLE_ID),
63: l_reason,
64: DECODE(p_reason_history_all_rec.REASON_CODE, FND_API.G_MISS_CHAR, NULL,
65: p_reason_history_all_rec.REASON_CODE),

Line 64: DECODE(p_reason_history_all_rec.REASON_CODE, FND_API.G_MISS_CHAR, NULL,

60: p_reason_history_all_rec.UPDATED_TABLE),
61: DECODE(p_reason_history_all_rec.UPD_TABLE_ID, FND_API.G_MISS_NUM, NULL,
62: p_reason_history_all_rec.UPD_TABLE_ID),
63: l_reason,
64: DECODE(p_reason_history_all_rec.REASON_CODE, FND_API.G_MISS_CHAR, NULL,
65: p_reason_history_all_rec.REASON_CODE),
66: DECODE(p_reason_history_all_rec.DML_FLAG, FND_API.G_MISS_CHAR, NULL,
67: p_reason_history_all_rec.DML_FLAG),
68: DECODE(p_reason_history_all_rec.LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,

Line 66: DECODE(p_reason_history_all_rec.DML_FLAG, FND_API.G_MISS_CHAR, NULL,

62: p_reason_history_all_rec.UPD_TABLE_ID),
63: l_reason,
64: DECODE(p_reason_history_all_rec.REASON_CODE, FND_API.G_MISS_CHAR, NULL,
65: p_reason_history_all_rec.REASON_CODE),
66: DECODE(p_reason_history_all_rec.DML_FLAG, FND_API.G_MISS_CHAR, NULL,
67: p_reason_history_all_rec.DML_FLAG),
68: DECODE(p_reason_history_all_rec.LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,
69: p_reason_history_all_rec.LOOKUP_TYPE),
70: DECODE(p_reason_history_all_rec.UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL,

Line 68: DECODE(p_reason_history_all_rec.LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,

64: DECODE(p_reason_history_all_rec.REASON_CODE, FND_API.G_MISS_CHAR, NULL,
65: p_reason_history_all_rec.REASON_CODE),
66: DECODE(p_reason_history_all_rec.DML_FLAG, FND_API.G_MISS_CHAR, NULL,
67: p_reason_history_all_rec.DML_FLAG),
68: DECODE(p_reason_history_all_rec.LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,
69: p_reason_history_all_rec.LOOKUP_TYPE),
70: DECODE(p_reason_history_all_rec.UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL,
71: p_reason_history_all_rec.UPDATE_FLAG),
72: DECODE(p_reason_history_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

Line 70: DECODE(p_reason_history_all_rec.UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL,

66: DECODE(p_reason_history_all_rec.DML_FLAG, FND_API.G_MISS_CHAR, NULL,
67: p_reason_history_all_rec.DML_FLAG),
68: DECODE(p_reason_history_all_rec.LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,
69: p_reason_history_all_rec.LOOKUP_TYPE),
70: DECODE(p_reason_history_all_rec.UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL,
71: p_reason_history_all_rec.UPDATE_FLAG),
72: DECODE(p_reason_history_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
73: p_reason_history_all_rec.ATTRIBUTE_CATEGORY),
74: DECODE(p_reason_history_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,

Line 72: DECODE(p_reason_history_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

68: DECODE(p_reason_history_all_rec.LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,
69: p_reason_history_all_rec.LOOKUP_TYPE),
70: DECODE(p_reason_history_all_rec.UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL,
71: p_reason_history_all_rec.UPDATE_FLAG),
72: DECODE(p_reason_history_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
73: p_reason_history_all_rec.ATTRIBUTE_CATEGORY),
74: DECODE(p_reason_history_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
75: p_reason_history_all_rec.ATTRIBUTE1),
76: DECODE(p_reason_history_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,

Line 74: DECODE(p_reason_history_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,

70: DECODE(p_reason_history_all_rec.UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL,
71: p_reason_history_all_rec.UPDATE_FLAG),
72: DECODE(p_reason_history_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
73: p_reason_history_all_rec.ATTRIBUTE_CATEGORY),
74: DECODE(p_reason_history_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
75: p_reason_history_all_rec.ATTRIBUTE1),
76: DECODE(p_reason_history_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
77: p_reason_history_all_rec.ATTRIBUTE2),
78: DECODE(p_reason_history_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

Line 76: DECODE(p_reason_history_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,

72: DECODE(p_reason_history_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
73: p_reason_history_all_rec.ATTRIBUTE_CATEGORY),
74: DECODE(p_reason_history_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
75: p_reason_history_all_rec.ATTRIBUTE1),
76: DECODE(p_reason_history_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
77: p_reason_history_all_rec.ATTRIBUTE2),
78: DECODE(p_reason_history_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
79: p_reason_history_all_rec.ATTRIBUTE3),
80: DECODE(p_reason_history_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,

Line 78: DECODE(p_reason_history_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

74: DECODE(p_reason_history_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
75: p_reason_history_all_rec.ATTRIBUTE1),
76: DECODE(p_reason_history_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
77: p_reason_history_all_rec.ATTRIBUTE2),
78: DECODE(p_reason_history_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
79: p_reason_history_all_rec.ATTRIBUTE3),
80: DECODE(p_reason_history_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
81: p_reason_history_all_rec.ATTRIBUTE4),
82: DECODE(p_reason_history_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,

Line 80: DECODE(p_reason_history_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,

76: DECODE(p_reason_history_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
77: p_reason_history_all_rec.ATTRIBUTE2),
78: DECODE(p_reason_history_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
79: p_reason_history_all_rec.ATTRIBUTE3),
80: DECODE(p_reason_history_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
81: p_reason_history_all_rec.ATTRIBUTE4),
82: DECODE(p_reason_history_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
83: p_reason_history_all_rec.ATTRIBUTE5),
84: DECODE(p_reason_history_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,

Line 82: DECODE(p_reason_history_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,

78: DECODE(p_reason_history_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
79: p_reason_history_all_rec.ATTRIBUTE3),
80: DECODE(p_reason_history_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
81: p_reason_history_all_rec.ATTRIBUTE4),
82: DECODE(p_reason_history_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
83: p_reason_history_all_rec.ATTRIBUTE5),
84: DECODE(p_reason_history_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
85: p_reason_history_all_rec.ATTRIBUTE6),
86: DECODE(p_reason_history_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,

Line 84: DECODE(p_reason_history_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,

80: DECODE(p_reason_history_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
81: p_reason_history_all_rec.ATTRIBUTE4),
82: DECODE(p_reason_history_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
83: p_reason_history_all_rec.ATTRIBUTE5),
84: DECODE(p_reason_history_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
85: p_reason_history_all_rec.ATTRIBUTE6),
86: DECODE(p_reason_history_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
87: p_reason_history_all_rec.ATTRIBUTE7),
88: DECODE(p_reason_history_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

Line 86: DECODE(p_reason_history_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,

82: DECODE(p_reason_history_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
83: p_reason_history_all_rec.ATTRIBUTE5),
84: DECODE(p_reason_history_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
85: p_reason_history_all_rec.ATTRIBUTE6),
86: DECODE(p_reason_history_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
87: p_reason_history_all_rec.ATTRIBUTE7),
88: DECODE(p_reason_history_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
89: p_reason_history_all_rec.ATTRIBUTE8),
90: DECODE(p_reason_history_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,

Line 88: DECODE(p_reason_history_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

84: DECODE(p_reason_history_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
85: p_reason_history_all_rec.ATTRIBUTE6),
86: DECODE(p_reason_history_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
87: p_reason_history_all_rec.ATTRIBUTE7),
88: DECODE(p_reason_history_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
89: p_reason_history_all_rec.ATTRIBUTE8),
90: DECODE(p_reason_history_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
91: p_reason_history_all_rec.ATTRIBUTE9),
92: DECODE(p_reason_history_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,

Line 90: DECODE(p_reason_history_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,

86: DECODE(p_reason_history_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
87: p_reason_history_all_rec.ATTRIBUTE7),
88: DECODE(p_reason_history_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
89: p_reason_history_all_rec.ATTRIBUTE8),
90: DECODE(p_reason_history_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
91: p_reason_history_all_rec.ATTRIBUTE9),
92: DECODE(p_reason_history_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
93: p_reason_history_all_rec.ATTRIBUTE10),
94: DECODE(p_reason_history_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,

Line 92: DECODE(p_reason_history_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,

88: DECODE(p_reason_history_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
89: p_reason_history_all_rec.ATTRIBUTE8),
90: DECODE(p_reason_history_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
91: p_reason_history_all_rec.ATTRIBUTE9),
92: DECODE(p_reason_history_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
93: p_reason_history_all_rec.ATTRIBUTE10),
94: DECODE(p_reason_history_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
95: p_reason_history_all_rec.ATTRIBUTE11),
96: DECODE(p_reason_history_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,

Line 94: DECODE(p_reason_history_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,

90: DECODE(p_reason_history_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
91: p_reason_history_all_rec.ATTRIBUTE9),
92: DECODE(p_reason_history_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
93: p_reason_history_all_rec.ATTRIBUTE10),
94: DECODE(p_reason_history_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
95: p_reason_history_all_rec.ATTRIBUTE11),
96: DECODE(p_reason_history_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
97: p_reason_history_all_rec.ATTRIBUTE12),
98: DECODE(p_reason_history_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,

Line 96: DECODE(p_reason_history_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,

92: DECODE(p_reason_history_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
93: p_reason_history_all_rec.ATTRIBUTE10),
94: DECODE(p_reason_history_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
95: p_reason_history_all_rec.ATTRIBUTE11),
96: DECODE(p_reason_history_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
97: p_reason_history_all_rec.ATTRIBUTE12),
98: DECODE(p_reason_history_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
99: p_reason_history_all_rec.ATTRIBUTE13),
100: DECODE(p_reason_history_all_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,

Line 98: DECODE(p_reason_history_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,

94: DECODE(p_reason_history_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
95: p_reason_history_all_rec.ATTRIBUTE11),
96: DECODE(p_reason_history_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
97: p_reason_history_all_rec.ATTRIBUTE12),
98: DECODE(p_reason_history_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
99: p_reason_history_all_rec.ATTRIBUTE13),
100: DECODE(p_reason_history_all_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
101: p_reason_history_all_rec.ATTRIBUTE14),
102: DECODE(p_reason_history_all_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,

Line 100: DECODE(p_reason_history_all_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,

96: DECODE(p_reason_history_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
97: p_reason_history_all_rec.ATTRIBUTE12),
98: DECODE(p_reason_history_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
99: p_reason_history_all_rec.ATTRIBUTE13),
100: DECODE(p_reason_history_all_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
101: p_reason_history_all_rec.ATTRIBUTE14),
102: DECODE(p_reason_history_all_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
103: p_reason_history_all_rec.ATTRIBUTE15),
104: fnd_global.user_id,

Line 102: DECODE(p_reason_history_all_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,

98: DECODE(p_reason_history_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
99: p_reason_history_all_rec.ATTRIBUTE13),
100: DECODE(p_reason_history_all_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
101: p_reason_history_all_rec.ATTRIBUTE14),
102: DECODE(p_reason_history_all_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
103: p_reason_history_all_rec.ATTRIBUTE15),
104: fnd_global.user_id,
105: Sysdate,
106: Sysdate,