APPS.CN_USER_ACCESS_PKG dependencies on FND_API

Line 83: user_id = decode(newrec.user_id, fnd_api.g_miss_num,

79: fetch c into oldrec;
80: close c;
81:
82: update cn_user_accesses set
83: user_id = decode(newrec.user_id, fnd_api.g_miss_num,
84: oldrec.user_id,
85: newrec.user_id),
86: comp_group_id = decode(newrec.comp_group_id, fnd_api.g_miss_num,
87: oldrec.comp_group_id,

Line 86: comp_group_id = decode(newrec.comp_group_id, fnd_api.g_miss_num,

82: update cn_user_accesses set
83: user_id = decode(newrec.user_id, fnd_api.g_miss_num,
84: oldrec.user_id,
85: newrec.user_id),
86: comp_group_id = decode(newrec.comp_group_id, fnd_api.g_miss_num,
87: oldrec.comp_group_id,
88: newrec.comp_group_id),
89: org_code = decode(newrec.org_code, fnd_api.g_miss_char,
90: oldrec.org_code,

Line 89: org_code = decode(newrec.org_code, fnd_api.g_miss_char,

85: newrec.user_id),
86: comp_group_id = decode(newrec.comp_group_id, fnd_api.g_miss_num,
87: oldrec.comp_group_id,
88: newrec.comp_group_id),
89: org_code = decode(newrec.org_code, fnd_api.g_miss_char,
90: oldrec.org_code,
91: newrec.org_code),
92: access_code = decode(newrec.access_code, fnd_api.g_miss_char,
93: oldrec.access_code,

Line 92: access_code = decode(newrec.access_code, fnd_api.g_miss_char,

88: newrec.comp_group_id),
89: org_code = decode(newrec.org_code, fnd_api.g_miss_char,
90: oldrec.org_code,
91: newrec.org_code),
92: access_code = decode(newrec.access_code, fnd_api.g_miss_char,
93: oldrec.access_code,
94: newrec.access_code),
95: attribute_category= decode(newrec.attribute_category, fnd_api.g_miss_char,
96: oldrec.attribute_category,

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

91: newrec.org_code),
92: access_code = decode(newrec.access_code, fnd_api.g_miss_char,
93: oldrec.access_code,
94: newrec.access_code),
95: attribute_category= decode(newrec.attribute_category, fnd_api.g_miss_char,
96: oldrec.attribute_category,
97: newrec.attribute_category),
98: attribute1 = decode(newrec.attribute1, fnd_api.g_miss_char,
99: oldrec.attribute1,

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

94: newrec.access_code),
95: attribute_category= decode(newrec.attribute_category, fnd_api.g_miss_char,
96: oldrec.attribute_category,
97: newrec.attribute_category),
98: attribute1 = decode(newrec.attribute1, fnd_api.g_miss_char,
99: oldrec.attribute1,
100: newrec.attribute1),
101: attribute2 = decode(newrec.attribute2, fnd_api.g_miss_char,
102: oldrec.attribute2,

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

97: newrec.attribute_category),
98: attribute1 = decode(newrec.attribute1, fnd_api.g_miss_char,
99: oldrec.attribute1,
100: newrec.attribute1),
101: attribute2 = decode(newrec.attribute2, fnd_api.g_miss_char,
102: oldrec.attribute2,
103: newrec.attribute2),
104: attribute3 = decode(newrec.attribute3, fnd_api.g_miss_char,
105: oldrec.attribute3,

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

100: newrec.attribute1),
101: attribute2 = decode(newrec.attribute2, fnd_api.g_miss_char,
102: oldrec.attribute2,
103: newrec.attribute2),
104: attribute3 = decode(newrec.attribute3, fnd_api.g_miss_char,
105: oldrec.attribute3,
106: newrec.attribute3),
107: attribute4 = decode(newrec.attribute4, fnd_api.g_miss_char,
108: oldrec.attribute4,

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

103: newrec.attribute2),
104: attribute3 = decode(newrec.attribute3, fnd_api.g_miss_char,
105: oldrec.attribute3,
106: newrec.attribute3),
107: attribute4 = decode(newrec.attribute4, fnd_api.g_miss_char,
108: oldrec.attribute4,
109: newrec.attribute4),
110: attribute5 = decode(newrec.attribute5, fnd_api.g_miss_char,
111: oldrec.attribute5,

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

106: newrec.attribute3),
107: attribute4 = decode(newrec.attribute4, fnd_api.g_miss_char,
108: oldrec.attribute4,
109: newrec.attribute4),
110: attribute5 = decode(newrec.attribute5, fnd_api.g_miss_char,
111: oldrec.attribute5,
112: newrec.attribute5),
113: attribute6 = decode(newrec.attribute6, fnd_api.g_miss_char,
114: oldrec.attribute6,

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

109: newrec.attribute4),
110: attribute5 = decode(newrec.attribute5, fnd_api.g_miss_char,
111: oldrec.attribute5,
112: newrec.attribute5),
113: attribute6 = decode(newrec.attribute6, fnd_api.g_miss_char,
114: oldrec.attribute6,
115: newrec.attribute6),
116: attribute7 = decode(newrec.attribute7, fnd_api.g_miss_char,
117: oldrec.attribute7,

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

112: newrec.attribute5),
113: attribute6 = decode(newrec.attribute6, fnd_api.g_miss_char,
114: oldrec.attribute6,
115: newrec.attribute6),
116: attribute7 = decode(newrec.attribute7, fnd_api.g_miss_char,
117: oldrec.attribute7,
118: newrec.attribute7),
119: attribute8 = decode(newrec.attribute8, fnd_api.g_miss_char,
120: oldrec.attribute8,

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

115: newrec.attribute6),
116: attribute7 = decode(newrec.attribute7, fnd_api.g_miss_char,
117: oldrec.attribute7,
118: newrec.attribute7),
119: attribute8 = decode(newrec.attribute8, fnd_api.g_miss_char,
120: oldrec.attribute8,
121: newrec.attribute8),
122: attribute9 = decode(newrec.attribute9, fnd_api.g_miss_char,
123: oldrec.attribute9,

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

118: newrec.attribute7),
119: attribute8 = decode(newrec.attribute8, fnd_api.g_miss_char,
120: oldrec.attribute8,
121: newrec.attribute8),
122: attribute9 = decode(newrec.attribute9, fnd_api.g_miss_char,
123: oldrec.attribute9,
124: newrec.attribute9),
125: attribute10 = decode(newrec.attribute10, fnd_api.g_miss_char,
126: oldrec.attribute10,

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

121: newrec.attribute8),
122: attribute9 = decode(newrec.attribute9, fnd_api.g_miss_char,
123: oldrec.attribute9,
124: newrec.attribute9),
125: attribute10 = decode(newrec.attribute10, fnd_api.g_miss_char,
126: oldrec.attribute10,
127: newrec.attribute10),
128: attribute11 = decode(newrec.attribute11, fnd_api.g_miss_char,
129: oldrec.attribute11,

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

124: newrec.attribute9),
125: attribute10 = decode(newrec.attribute10, fnd_api.g_miss_char,
126: oldrec.attribute10,
127: newrec.attribute10),
128: attribute11 = decode(newrec.attribute11, fnd_api.g_miss_char,
129: oldrec.attribute11,
130: newrec.attribute11),
131: attribute12 = decode(newrec.attribute12, fnd_api.g_miss_char,
132: oldrec.attribute12,

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

127: newrec.attribute10),
128: attribute11 = decode(newrec.attribute11, fnd_api.g_miss_char,
129: oldrec.attribute11,
130: newrec.attribute11),
131: attribute12 = decode(newrec.attribute12, fnd_api.g_miss_char,
132: oldrec.attribute12,
133: newrec.attribute12),
134: attribute13 = decode(newrec.attribute13, fnd_api.g_miss_char,
135: oldrec.attribute13,

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

130: newrec.attribute11),
131: attribute12 = decode(newrec.attribute12, fnd_api.g_miss_char,
132: oldrec.attribute12,
133: newrec.attribute12),
134: attribute13 = decode(newrec.attribute13, fnd_api.g_miss_char,
135: oldrec.attribute13,
136: newrec.attribute13),
137: attribute14 = decode(newrec.attribute14, fnd_api.g_miss_char,
138: oldrec.attribute14,

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

133: newrec.attribute12),
134: attribute13 = decode(newrec.attribute13, fnd_api.g_miss_char,
135: oldrec.attribute13,
136: newrec.attribute13),
137: attribute14 = decode(newrec.attribute14, fnd_api.g_miss_char,
138: oldrec.attribute14,
139: newrec.attribute14),
140: attribute15 = decode(newrec.attribute15, fnd_api.g_miss_char,
141: oldrec.attribute15,

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

136: newrec.attribute13),
137: attribute14 = decode(newrec.attribute14, fnd_api.g_miss_char,
138: oldrec.attribute14,
139: newrec.attribute14),
140: attribute15 = decode(newrec.attribute15, fnd_api.g_miss_char,
141: oldrec.attribute15,
142: newrec.attribute15),
143: last_update_login = fnd_global.login_id,
144: last_update_date = sysdate,

Line 165: raise fnd_api.g_exc_unexpected_error;

161: if (c%notfound) then
162: close c;
163: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
164: fnd_msg_pub.add;
165: raise fnd_api.g_exc_unexpected_error;
166: end if;
167: close c;
168:
169: if (tlinfo.object_version_number <> p_object_version_number) then

Line 172: raise fnd_api.g_exc_unexpected_error;

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