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_JOB_TITLE_PKG dependencies on FND_API

Line 85: job_title_id = decode(newrec.job_title_id, fnd_api.g_miss_num,

81: fetch c into oldrec;
82: close c;
83:
84: update cn_job_roles set
85: job_title_id = decode(newrec.job_title_id, fnd_api.g_miss_num,
86: oldrec.job_title_id,
87: newrec.job_title_id),
88: role_id = decode(newrec.role_id, fnd_api.g_miss_char,
89: oldrec.role_id,

Line 88: role_id = decode(newrec.role_id, fnd_api.g_miss_char,

84: update cn_job_roles set
85: job_title_id = decode(newrec.job_title_id, fnd_api.g_miss_num,
86: oldrec.job_title_id,
87: newrec.job_title_id),
88: role_id = decode(newrec.role_id, fnd_api.g_miss_char,
89: oldrec.role_id,
90: newrec.role_id),
91: start_date = decode(newrec.start_date, fnd_api.g_miss_date,
92: oldrec.start_date,

Line 91: start_date = decode(newrec.start_date, fnd_api.g_miss_date,

87: newrec.job_title_id),
88: role_id = decode(newrec.role_id, fnd_api.g_miss_char,
89: oldrec.role_id,
90: newrec.role_id),
91: start_date = decode(newrec.start_date, fnd_api.g_miss_date,
92: oldrec.start_date,
93: newrec.start_date),
94: end_date = decode(newrec.end_date, fnd_api.g_miss_date,
95: oldrec.end_date,

Line 94: end_date = decode(newrec.end_date, fnd_api.g_miss_date,

90: newrec.role_id),
91: start_date = decode(newrec.start_date, fnd_api.g_miss_date,
92: oldrec.start_date,
93: newrec.start_date),
94: end_date = decode(newrec.end_date, fnd_api.g_miss_date,
95: oldrec.end_date,
96: newrec.end_date),
97: default_flag = decode(newrec.default_flag, fnd_api.g_miss_char,
98: oldrec.default_flag,

Line 97: default_flag = decode(newrec.default_flag, fnd_api.g_miss_char,

93: newrec.start_date),
94: end_date = decode(newrec.end_date, fnd_api.g_miss_date,
95: oldrec.end_date,
96: newrec.end_date),
97: default_flag = decode(newrec.default_flag, fnd_api.g_miss_char,
98: oldrec.default_flag,
99: newrec.default_flag),
100: attribute_category= decode(newrec.attribute_category, fnd_api.g_miss_char,
101: oldrec.attribute_category,

Line 100: attribute_category= decode(newrec.attribute_category, fnd_api.g_miss_char,

96: newrec.end_date),
97: default_flag = decode(newrec.default_flag, fnd_api.g_miss_char,
98: oldrec.default_flag,
99: newrec.default_flag),
100: attribute_category= decode(newrec.attribute_category, fnd_api.g_miss_char,
101: oldrec.attribute_category,
102: newrec.attribute_category),
103: attribute1 = decode(newrec.attribute1, fnd_api.g_miss_char,
104: oldrec.attribute1,

Line 103: attribute1 = decode(newrec.attribute1, fnd_api.g_miss_char,

99: newrec.default_flag),
100: attribute_category= decode(newrec.attribute_category, fnd_api.g_miss_char,
101: oldrec.attribute_category,
102: newrec.attribute_category),
103: attribute1 = decode(newrec.attribute1, fnd_api.g_miss_char,
104: oldrec.attribute1,
105: newrec.attribute1),
106: attribute2 = decode(newrec.attribute2, fnd_api.g_miss_char,
107: oldrec.attribute2,

Line 106: attribute2 = decode(newrec.attribute2, fnd_api.g_miss_char,

102: newrec.attribute_category),
103: attribute1 = decode(newrec.attribute1, fnd_api.g_miss_char,
104: oldrec.attribute1,
105: newrec.attribute1),
106: attribute2 = decode(newrec.attribute2, fnd_api.g_miss_char,
107: oldrec.attribute2,
108: newrec.attribute2),
109: attribute3 = decode(newrec.attribute3, fnd_api.g_miss_char,
110: oldrec.attribute3,

Line 109: attribute3 = decode(newrec.attribute3, fnd_api.g_miss_char,

105: newrec.attribute1),
106: attribute2 = decode(newrec.attribute2, fnd_api.g_miss_char,
107: oldrec.attribute2,
108: newrec.attribute2),
109: attribute3 = decode(newrec.attribute3, fnd_api.g_miss_char,
110: oldrec.attribute3,
111: newrec.attribute3),
112: attribute4 = decode(newrec.attribute4, fnd_api.g_miss_char,
113: oldrec.attribute4,

Line 112: attribute4 = decode(newrec.attribute4, fnd_api.g_miss_char,

108: newrec.attribute2),
109: attribute3 = decode(newrec.attribute3, fnd_api.g_miss_char,
110: oldrec.attribute3,
111: newrec.attribute3),
112: attribute4 = decode(newrec.attribute4, fnd_api.g_miss_char,
113: oldrec.attribute4,
114: newrec.attribute4),
115: attribute5 = decode(newrec.attribute5, fnd_api.g_miss_char,
116: oldrec.attribute5,

Line 115: attribute5 = decode(newrec.attribute5, fnd_api.g_miss_char,

111: newrec.attribute3),
112: attribute4 = decode(newrec.attribute4, fnd_api.g_miss_char,
113: oldrec.attribute4,
114: newrec.attribute4),
115: attribute5 = decode(newrec.attribute5, fnd_api.g_miss_char,
116: oldrec.attribute5,
117: newrec.attribute5),
118: attribute6 = decode(newrec.attribute6, fnd_api.g_miss_char,
119: oldrec.attribute6,

Line 118: attribute6 = decode(newrec.attribute6, fnd_api.g_miss_char,

114: newrec.attribute4),
115: attribute5 = decode(newrec.attribute5, fnd_api.g_miss_char,
116: oldrec.attribute5,
117: newrec.attribute5),
118: attribute6 = decode(newrec.attribute6, fnd_api.g_miss_char,
119: oldrec.attribute6,
120: newrec.attribute6),
121: attribute7 = decode(newrec.attribute7, fnd_api.g_miss_char,
122: oldrec.attribute7,

Line 121: attribute7 = decode(newrec.attribute7, fnd_api.g_miss_char,

117: newrec.attribute5),
118: attribute6 = decode(newrec.attribute6, fnd_api.g_miss_char,
119: oldrec.attribute6,
120: newrec.attribute6),
121: attribute7 = decode(newrec.attribute7, fnd_api.g_miss_char,
122: oldrec.attribute7,
123: newrec.attribute7),
124: attribute8 = decode(newrec.attribute8, fnd_api.g_miss_char,
125: oldrec.attribute8,

Line 124: attribute8 = decode(newrec.attribute8, fnd_api.g_miss_char,

120: newrec.attribute6),
121: attribute7 = decode(newrec.attribute7, fnd_api.g_miss_char,
122: oldrec.attribute7,
123: newrec.attribute7),
124: attribute8 = decode(newrec.attribute8, fnd_api.g_miss_char,
125: oldrec.attribute8,
126: newrec.attribute8),
127: attribute9 = decode(newrec.attribute9, fnd_api.g_miss_char,
128: oldrec.attribute9,

Line 127: attribute9 = decode(newrec.attribute9, fnd_api.g_miss_char,

123: newrec.attribute7),
124: attribute8 = decode(newrec.attribute8, fnd_api.g_miss_char,
125: oldrec.attribute8,
126: newrec.attribute8),
127: attribute9 = decode(newrec.attribute9, fnd_api.g_miss_char,
128: oldrec.attribute9,
129: newrec.attribute9),
130: attribute10 = decode(newrec.attribute10, fnd_api.g_miss_char,
131: oldrec.attribute10,

Line 130: attribute10 = decode(newrec.attribute10, fnd_api.g_miss_char,

126: newrec.attribute8),
127: attribute9 = decode(newrec.attribute9, fnd_api.g_miss_char,
128: oldrec.attribute9,
129: newrec.attribute9),
130: attribute10 = decode(newrec.attribute10, fnd_api.g_miss_char,
131: oldrec.attribute10,
132: newrec.attribute10),
133: attribute11 = decode(newrec.attribute11, fnd_api.g_miss_char,
134: oldrec.attribute11,

Line 133: attribute11 = decode(newrec.attribute11, fnd_api.g_miss_char,

129: newrec.attribute9),
130: attribute10 = decode(newrec.attribute10, fnd_api.g_miss_char,
131: oldrec.attribute10,
132: newrec.attribute10),
133: attribute11 = decode(newrec.attribute11, fnd_api.g_miss_char,
134: oldrec.attribute11,
135: newrec.attribute11),
136: attribute12 = decode(newrec.attribute12, fnd_api.g_miss_char,
137: oldrec.attribute12,

Line 136: attribute12 = decode(newrec.attribute12, fnd_api.g_miss_char,

132: newrec.attribute10),
133: attribute11 = decode(newrec.attribute11, fnd_api.g_miss_char,
134: oldrec.attribute11,
135: newrec.attribute11),
136: attribute12 = decode(newrec.attribute12, fnd_api.g_miss_char,
137: oldrec.attribute12,
138: newrec.attribute12),
139: attribute13 = decode(newrec.attribute13, fnd_api.g_miss_char,
140: oldrec.attribute13,

Line 139: attribute13 = decode(newrec.attribute13, fnd_api.g_miss_char,

135: newrec.attribute11),
136: attribute12 = decode(newrec.attribute12, fnd_api.g_miss_char,
137: oldrec.attribute12,
138: newrec.attribute12),
139: attribute13 = decode(newrec.attribute13, fnd_api.g_miss_char,
140: oldrec.attribute13,
141: newrec.attribute13),
142: attribute14 = decode(newrec.attribute14, fnd_api.g_miss_char,
143: oldrec.attribute14,

Line 142: attribute14 = decode(newrec.attribute14, fnd_api.g_miss_char,

138: newrec.attribute12),
139: attribute13 = decode(newrec.attribute13, fnd_api.g_miss_char,
140: oldrec.attribute13,
141: newrec.attribute13),
142: attribute14 = decode(newrec.attribute14, fnd_api.g_miss_char,
143: oldrec.attribute14,
144: newrec.attribute14),
145: attribute15 = decode(newrec.attribute15, fnd_api.g_miss_char,
146: oldrec.attribute15,

Line 145: attribute15 = decode(newrec.attribute15, fnd_api.g_miss_char,

141: newrec.attribute13),
142: attribute14 = decode(newrec.attribute14, fnd_api.g_miss_char,
143: oldrec.attribute14,
144: newrec.attribute14),
145: attribute15 = decode(newrec.attribute15, fnd_api.g_miss_char,
146: oldrec.attribute15,
147: newrec.attribute15),
148: last_update_login = fnd_global.login_id,
149: last_update_date = sysdate,

Line 172: raise fnd_api.g_exc_unexpected_error;

168: if (c%notfound) then
169: close c;
170: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
171: fnd_msg_pub.add;
172: raise fnd_api.g_exc_unexpected_error;
173: end if;
174: close c;
175:
176: if (tlinfo.object_version_number <> p_object_version_number) then

Line 179: raise fnd_api.g_exc_unexpected_error;

175:
176: if (tlinfo.object_version_number <> p_object_version_number) then
177: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
178: fnd_msg_pub.add;
179: raise fnd_api.g_exc_unexpected_error;
180: end if;
181:
182: END LOCK_ROW;
183: