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

Line 86: if (X_Access_Id is NULL or x_access_id = fnd_api.g_miss_num) then

82: CURSOR C IS SELECT rowid FROM as_accesses_all
83: WHERE access_id = X_Access_Id;
84: CURSOR C2 IS SELECT as_accesses_s.nextval FROM sys.dual;
85: BEGIN
86: if (X_Access_Id is NULL or x_access_id = fnd_api.g_miss_num) then
87: OPEN C2;
88: FETCH C2 INTO X_Access_Id;
89: CLOSE C2;
90: end if;

Line 150: decode(X_Access_Type,FND_API.G_MISS_CHAR,NULL,X_Access_Type),

146: X_Last_Updated_By,
147: X_Creation_Date,
148: X_Created_By,
149: X_Last_Update_Login,
150: decode(X_Access_Type,FND_API.G_MISS_CHAR,NULL,X_Access_Type),
151: decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,'Y',X_Freeze_Flag),
152: decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,'N',X_Reassign_Flag),
153: decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,'N',X_Team_Leader_Flag),
154: decode(X_Person_Id, FND_API.G_MISS_NUM, NULL, X_person_id),

Line 151: decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,'Y',X_Freeze_Flag),

147: X_Creation_Date,
148: X_Created_By,
149: X_Last_Update_Login,
150: decode(X_Access_Type,FND_API.G_MISS_CHAR,NULL,X_Access_Type),
151: decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,'Y',X_Freeze_Flag),
152: decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,'N',X_Reassign_Flag),
153: decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,'N',X_Team_Leader_Flag),
154: decode(X_Person_Id, FND_API.G_MISS_NUM, NULL, X_person_id),
155: decode(X_Customer_Id,FND_API.G_MISS_NUM, NULL, X_customer_id),

Line 152: decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,'N',X_Reassign_Flag),

148: X_Created_By,
149: X_Last_Update_Login,
150: decode(X_Access_Type,FND_API.G_MISS_CHAR,NULL,X_Access_Type),
151: decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,'Y',X_Freeze_Flag),
152: decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,'N',X_Reassign_Flag),
153: decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,'N',X_Team_Leader_Flag),
154: decode(X_Person_Id, FND_API.G_MISS_NUM, NULL, X_person_id),
155: decode(X_Customer_Id,FND_API.G_MISS_NUM, NULL, X_customer_id),
156: decode(X_Address_Id,FND_API.G_MISS_NUM, NULL, X_address_id ),

Line 153: decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,'N',X_Team_Leader_Flag),

149: X_Last_Update_Login,
150: decode(X_Access_Type,FND_API.G_MISS_CHAR,NULL,X_Access_Type),
151: decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,'Y',X_Freeze_Flag),
152: decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,'N',X_Reassign_Flag),
153: decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,'N',X_Team_Leader_Flag),
154: decode(X_Person_Id, FND_API.G_MISS_NUM, NULL, X_person_id),
155: decode(X_Customer_Id,FND_API.G_MISS_NUM, NULL, X_customer_id),
156: decode(X_Address_Id,FND_API.G_MISS_NUM, NULL, X_address_id ),
157: decode(X_Salesforce_Id,FND_API.G_MISS_NUM, NULL, X_salesforce_id),

Line 154: decode(X_Person_Id, FND_API.G_MISS_NUM, NULL, X_person_id),

150: decode(X_Access_Type,FND_API.G_MISS_CHAR,NULL,X_Access_Type),
151: decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,'Y',X_Freeze_Flag),
152: decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,'N',X_Reassign_Flag),
153: decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,'N',X_Team_Leader_Flag),
154: decode(X_Person_Id, FND_API.G_MISS_NUM, NULL, X_person_id),
155: decode(X_Customer_Id,FND_API.G_MISS_NUM, NULL, X_customer_id),
156: decode(X_Address_Id,FND_API.G_MISS_NUM, NULL, X_address_id ),
157: decode(X_Salesforce_Id,FND_API.G_MISS_NUM, NULL, X_salesforce_id),
158: decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM, NULL, X_partner_customer_id),

Line 155: decode(X_Customer_Id,FND_API.G_MISS_NUM, NULL, X_customer_id),

151: decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,'Y',X_Freeze_Flag),
152: decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,'N',X_Reassign_Flag),
153: decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,'N',X_Team_Leader_Flag),
154: decode(X_Person_Id, FND_API.G_MISS_NUM, NULL, X_person_id),
155: decode(X_Customer_Id,FND_API.G_MISS_NUM, NULL, X_customer_id),
156: decode(X_Address_Id,FND_API.G_MISS_NUM, NULL, X_address_id ),
157: decode(X_Salesforce_Id,FND_API.G_MISS_NUM, NULL, X_salesforce_id),
158: decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM, NULL, X_partner_customer_id),
159: decode(X_Partner_Address_Id,FND_API.G_MISS_NUM, NULL, X_partner_address_id),

Line 156: decode(X_Address_Id,FND_API.G_MISS_NUM, NULL, X_address_id ),

152: decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,'N',X_Reassign_Flag),
153: decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,'N',X_Team_Leader_Flag),
154: decode(X_Person_Id, FND_API.G_MISS_NUM, NULL, X_person_id),
155: decode(X_Customer_Id,FND_API.G_MISS_NUM, NULL, X_customer_id),
156: decode(X_Address_Id,FND_API.G_MISS_NUM, NULL, X_address_id ),
157: decode(X_Salesforce_Id,FND_API.G_MISS_NUM, NULL, X_salesforce_id),
158: decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM, NULL, X_partner_customer_id),
159: decode(X_Partner_Address_Id,FND_API.G_MISS_NUM, NULL, X_partner_address_id),
160: decode(X_Created_Person_Id,FND_API.G_MISS_NUM, NULL, X_created_person_id ),

Line 157: decode(X_Salesforce_Id,FND_API.G_MISS_NUM, NULL, X_salesforce_id),

153: decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,'N',X_Team_Leader_Flag),
154: decode(X_Person_Id, FND_API.G_MISS_NUM, NULL, X_person_id),
155: decode(X_Customer_Id,FND_API.G_MISS_NUM, NULL, X_customer_id),
156: decode(X_Address_Id,FND_API.G_MISS_NUM, NULL, X_address_id ),
157: decode(X_Salesforce_Id,FND_API.G_MISS_NUM, NULL, X_salesforce_id),
158: decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM, NULL, X_partner_customer_id),
159: decode(X_Partner_Address_Id,FND_API.G_MISS_NUM, NULL, X_partner_address_id),
160: decode(X_Created_Person_Id,FND_API.G_MISS_NUM, NULL, X_created_person_id ),
161: decode(X_Lead_Id,FND_API.G_MISS_NUM, NULL, X_lead_id),

Line 158: decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM, NULL, X_partner_customer_id),

154: decode(X_Person_Id, FND_API.G_MISS_NUM, NULL, X_person_id),
155: decode(X_Customer_Id,FND_API.G_MISS_NUM, NULL, X_customer_id),
156: decode(X_Address_Id,FND_API.G_MISS_NUM, NULL, X_address_id ),
157: decode(X_Salesforce_Id,FND_API.G_MISS_NUM, NULL, X_salesforce_id),
158: decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM, NULL, X_partner_customer_id),
159: decode(X_Partner_Address_Id,FND_API.G_MISS_NUM, NULL, X_partner_address_id),
160: decode(X_Created_Person_Id,FND_API.G_MISS_NUM, NULL, X_created_person_id ),
161: decode(X_Lead_Id,FND_API.G_MISS_NUM, NULL, X_lead_id),
162: decode(X_Freeze_Date,FND_API.G_MISS_DATE, NULL,X_Freeze_Date),

Line 159: decode(X_Partner_Address_Id,FND_API.G_MISS_NUM, NULL, X_partner_address_id),

155: decode(X_Customer_Id,FND_API.G_MISS_NUM, NULL, X_customer_id),
156: decode(X_Address_Id,FND_API.G_MISS_NUM, NULL, X_address_id ),
157: decode(X_Salesforce_Id,FND_API.G_MISS_NUM, NULL, X_salesforce_id),
158: decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM, NULL, X_partner_customer_id),
159: decode(X_Partner_Address_Id,FND_API.G_MISS_NUM, NULL, X_partner_address_id),
160: decode(X_Created_Person_Id,FND_API.G_MISS_NUM, NULL, X_created_person_id ),
161: decode(X_Lead_Id,FND_API.G_MISS_NUM, NULL, X_lead_id),
162: decode(X_Freeze_Date,FND_API.G_MISS_DATE, NULL,X_Freeze_Date),
163: decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,NULL,X_Reassign_Reason),

Line 160: decode(X_Created_Person_Id,FND_API.G_MISS_NUM, NULL, X_created_person_id ),

156: decode(X_Address_Id,FND_API.G_MISS_NUM, NULL, X_address_id ),
157: decode(X_Salesforce_Id,FND_API.G_MISS_NUM, NULL, X_salesforce_id),
158: decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM, NULL, X_partner_customer_id),
159: decode(X_Partner_Address_Id,FND_API.G_MISS_NUM, NULL, X_partner_address_id),
160: decode(X_Created_Person_Id,FND_API.G_MISS_NUM, NULL, X_created_person_id ),
161: decode(X_Lead_Id,FND_API.G_MISS_NUM, NULL, X_lead_id),
162: decode(X_Freeze_Date,FND_API.G_MISS_DATE, NULL,X_Freeze_Date),
163: decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,NULL,X_Reassign_Reason),
164: decode(X_reassign_request_date,FND_API.G_MISS_DATE,

Line 161: decode(X_Lead_Id,FND_API.G_MISS_NUM, NULL, X_lead_id),

157: decode(X_Salesforce_Id,FND_API.G_MISS_NUM, NULL, X_salesforce_id),
158: decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM, NULL, X_partner_customer_id),
159: decode(X_Partner_Address_Id,FND_API.G_MISS_NUM, NULL, X_partner_address_id),
160: decode(X_Created_Person_Id,FND_API.G_MISS_NUM, NULL, X_created_person_id ),
161: decode(X_Lead_Id,FND_API.G_MISS_NUM, NULL, X_lead_id),
162: decode(X_Freeze_Date,FND_API.G_MISS_DATE, NULL,X_Freeze_Date),
163: decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,NULL,X_Reassign_Reason),
164: decode(X_reassign_request_date,FND_API.G_MISS_DATE,
165: NULL,X_reassign_request_date),

Line 162: decode(X_Freeze_Date,FND_API.G_MISS_DATE, NULL,X_Freeze_Date),

158: decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM, NULL, X_partner_customer_id),
159: decode(X_Partner_Address_Id,FND_API.G_MISS_NUM, NULL, X_partner_address_id),
160: decode(X_Created_Person_Id,FND_API.G_MISS_NUM, NULL, X_created_person_id ),
161: decode(X_Lead_Id,FND_API.G_MISS_NUM, NULL, X_lead_id),
162: decode(X_Freeze_Date,FND_API.G_MISS_DATE, NULL,X_Freeze_Date),
163: decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,NULL,X_Reassign_Reason),
164: decode(X_reassign_request_date,FND_API.G_MISS_DATE,
165: NULL,X_reassign_request_date),
166: decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,

Line 163: decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,NULL,X_Reassign_Reason),

159: decode(X_Partner_Address_Id,FND_API.G_MISS_NUM, NULL, X_partner_address_id),
160: decode(X_Created_Person_Id,FND_API.G_MISS_NUM, NULL, X_created_person_id ),
161: decode(X_Lead_Id,FND_API.G_MISS_NUM, NULL, X_lead_id),
162: decode(X_Freeze_Date,FND_API.G_MISS_DATE, NULL,X_Freeze_Date),
163: decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,NULL,X_Reassign_Reason),
164: decode(X_reassign_request_date,FND_API.G_MISS_DATE,
165: NULL,X_reassign_request_date),
166: decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
167: NULL,X_reassign_requested_person_id ),

Line 164: decode(X_reassign_request_date,FND_API.G_MISS_DATE,

160: decode(X_Created_Person_Id,FND_API.G_MISS_NUM, NULL, X_created_person_id ),
161: decode(X_Lead_Id,FND_API.G_MISS_NUM, NULL, X_lead_id),
162: decode(X_Freeze_Date,FND_API.G_MISS_DATE, NULL,X_Freeze_Date),
163: decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,NULL,X_Reassign_Reason),
164: decode(X_reassign_request_date,FND_API.G_MISS_DATE,
165: NULL,X_reassign_request_date),
166: decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
167: NULL,X_reassign_requested_person_id ),
168: decode(X_Attribute_Category,FND_API.G_MISS_CHAR,NULL,X_Attribute_Category),

Line 166: decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,

162: decode(X_Freeze_Date,FND_API.G_MISS_DATE, NULL,X_Freeze_Date),
163: decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,NULL,X_Reassign_Reason),
164: decode(X_reassign_request_date,FND_API.G_MISS_DATE,
165: NULL,X_reassign_request_date),
166: decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
167: NULL,X_reassign_requested_person_id ),
168: decode(X_Attribute_Category,FND_API.G_MISS_CHAR,NULL,X_Attribute_Category),
169: decode(X_Attribute1,FND_API.G_MISS_CHAR,NULL,X_Attribute1),
170: decode(X_Attribute2,FND_API.G_MISS_CHAR,NULL,X_Attribute2),

Line 168: decode(X_Attribute_Category,FND_API.G_MISS_CHAR,NULL,X_Attribute_Category),

164: decode(X_reassign_request_date,FND_API.G_MISS_DATE,
165: NULL,X_reassign_request_date),
166: decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
167: NULL,X_reassign_requested_person_id ),
168: decode(X_Attribute_Category,FND_API.G_MISS_CHAR,NULL,X_Attribute_Category),
169: decode(X_Attribute1,FND_API.G_MISS_CHAR,NULL,X_Attribute1),
170: decode(X_Attribute2,FND_API.G_MISS_CHAR,NULL,X_Attribute2),
171: decode(X_Attribute3,FND_API.G_MISS_CHAR,NULL,X_Attribute3),
172: decode(X_Attribute4,FND_API.G_MISS_CHAR,NULL,X_Attribute4),

Line 169: decode(X_Attribute1,FND_API.G_MISS_CHAR,NULL,X_Attribute1),

165: NULL,X_reassign_request_date),
166: decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
167: NULL,X_reassign_requested_person_id ),
168: decode(X_Attribute_Category,FND_API.G_MISS_CHAR,NULL,X_Attribute_Category),
169: decode(X_Attribute1,FND_API.G_MISS_CHAR,NULL,X_Attribute1),
170: decode(X_Attribute2,FND_API.G_MISS_CHAR,NULL,X_Attribute2),
171: decode(X_Attribute3,FND_API.G_MISS_CHAR,NULL,X_Attribute3),
172: decode(X_Attribute4,FND_API.G_MISS_CHAR,NULL,X_Attribute4),
173: decode(X_Attribute5,FND_API.G_MISS_CHAR,NULL,X_Attribute5),

Line 170: decode(X_Attribute2,FND_API.G_MISS_CHAR,NULL,X_Attribute2),

166: decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
167: NULL,X_reassign_requested_person_id ),
168: decode(X_Attribute_Category,FND_API.G_MISS_CHAR,NULL,X_Attribute_Category),
169: decode(X_Attribute1,FND_API.G_MISS_CHAR,NULL,X_Attribute1),
170: decode(X_Attribute2,FND_API.G_MISS_CHAR,NULL,X_Attribute2),
171: decode(X_Attribute3,FND_API.G_MISS_CHAR,NULL,X_Attribute3),
172: decode(X_Attribute4,FND_API.G_MISS_CHAR,NULL,X_Attribute4),
173: decode(X_Attribute5,FND_API.G_MISS_CHAR,NULL,X_Attribute5),
174: decode(X_Attribute6,FND_API.G_MISS_CHAR,NULL,X_Attribute6),

Line 171: decode(X_Attribute3,FND_API.G_MISS_CHAR,NULL,X_Attribute3),

167: NULL,X_reassign_requested_person_id ),
168: decode(X_Attribute_Category,FND_API.G_MISS_CHAR,NULL,X_Attribute_Category),
169: decode(X_Attribute1,FND_API.G_MISS_CHAR,NULL,X_Attribute1),
170: decode(X_Attribute2,FND_API.G_MISS_CHAR,NULL,X_Attribute2),
171: decode(X_Attribute3,FND_API.G_MISS_CHAR,NULL,X_Attribute3),
172: decode(X_Attribute4,FND_API.G_MISS_CHAR,NULL,X_Attribute4),
173: decode(X_Attribute5,FND_API.G_MISS_CHAR,NULL,X_Attribute5),
174: decode(X_Attribute6,FND_API.G_MISS_CHAR,NULL,X_Attribute6),
175: decode(X_Attribute7,FND_API.G_MISS_CHAR,NULL,X_Attribute7),

Line 172: decode(X_Attribute4,FND_API.G_MISS_CHAR,NULL,X_Attribute4),

168: decode(X_Attribute_Category,FND_API.G_MISS_CHAR,NULL,X_Attribute_Category),
169: decode(X_Attribute1,FND_API.G_MISS_CHAR,NULL,X_Attribute1),
170: decode(X_Attribute2,FND_API.G_MISS_CHAR,NULL,X_Attribute2),
171: decode(X_Attribute3,FND_API.G_MISS_CHAR,NULL,X_Attribute3),
172: decode(X_Attribute4,FND_API.G_MISS_CHAR,NULL,X_Attribute4),
173: decode(X_Attribute5,FND_API.G_MISS_CHAR,NULL,X_Attribute5),
174: decode(X_Attribute6,FND_API.G_MISS_CHAR,NULL,X_Attribute6),
175: decode(X_Attribute7,FND_API.G_MISS_CHAR,NULL,X_Attribute7),
176: decode(X_Attribute8,FND_API.G_MISS_CHAR,NULL,X_Attribute8),

Line 173: decode(X_Attribute5,FND_API.G_MISS_CHAR,NULL,X_Attribute5),

169: decode(X_Attribute1,FND_API.G_MISS_CHAR,NULL,X_Attribute1),
170: decode(X_Attribute2,FND_API.G_MISS_CHAR,NULL,X_Attribute2),
171: decode(X_Attribute3,FND_API.G_MISS_CHAR,NULL,X_Attribute3),
172: decode(X_Attribute4,FND_API.G_MISS_CHAR,NULL,X_Attribute4),
173: decode(X_Attribute5,FND_API.G_MISS_CHAR,NULL,X_Attribute5),
174: decode(X_Attribute6,FND_API.G_MISS_CHAR,NULL,X_Attribute6),
175: decode(X_Attribute7,FND_API.G_MISS_CHAR,NULL,X_Attribute7),
176: decode(X_Attribute8,FND_API.G_MISS_CHAR,NULL,X_Attribute8),
177: decode(X_Attribute9,FND_API.G_MISS_CHAR,NULL,X_Attribute9),

Line 174: decode(X_Attribute6,FND_API.G_MISS_CHAR,NULL,X_Attribute6),

170: decode(X_Attribute2,FND_API.G_MISS_CHAR,NULL,X_Attribute2),
171: decode(X_Attribute3,FND_API.G_MISS_CHAR,NULL,X_Attribute3),
172: decode(X_Attribute4,FND_API.G_MISS_CHAR,NULL,X_Attribute4),
173: decode(X_Attribute5,FND_API.G_MISS_CHAR,NULL,X_Attribute5),
174: decode(X_Attribute6,FND_API.G_MISS_CHAR,NULL,X_Attribute6),
175: decode(X_Attribute7,FND_API.G_MISS_CHAR,NULL,X_Attribute7),
176: decode(X_Attribute8,FND_API.G_MISS_CHAR,NULL,X_Attribute8),
177: decode(X_Attribute9,FND_API.G_MISS_CHAR,NULL,X_Attribute9),
178: decode(X_Attribute10,FND_API.G_MISS_CHAR,NULL,X_Attribute10),

Line 175: decode(X_Attribute7,FND_API.G_MISS_CHAR,NULL,X_Attribute7),

171: decode(X_Attribute3,FND_API.G_MISS_CHAR,NULL,X_Attribute3),
172: decode(X_Attribute4,FND_API.G_MISS_CHAR,NULL,X_Attribute4),
173: decode(X_Attribute5,FND_API.G_MISS_CHAR,NULL,X_Attribute5),
174: decode(X_Attribute6,FND_API.G_MISS_CHAR,NULL,X_Attribute6),
175: decode(X_Attribute7,FND_API.G_MISS_CHAR,NULL,X_Attribute7),
176: decode(X_Attribute8,FND_API.G_MISS_CHAR,NULL,X_Attribute8),
177: decode(X_Attribute9,FND_API.G_MISS_CHAR,NULL,X_Attribute9),
178: decode(X_Attribute10,FND_API.G_MISS_CHAR,NULL,X_Attribute10),
179: decode(X_Attribute11,FND_API.G_MISS_CHAR,NULL,X_Attribute11),

Line 176: decode(X_Attribute8,FND_API.G_MISS_CHAR,NULL,X_Attribute8),

172: decode(X_Attribute4,FND_API.G_MISS_CHAR,NULL,X_Attribute4),
173: decode(X_Attribute5,FND_API.G_MISS_CHAR,NULL,X_Attribute5),
174: decode(X_Attribute6,FND_API.G_MISS_CHAR,NULL,X_Attribute6),
175: decode(X_Attribute7,FND_API.G_MISS_CHAR,NULL,X_Attribute7),
176: decode(X_Attribute8,FND_API.G_MISS_CHAR,NULL,X_Attribute8),
177: decode(X_Attribute9,FND_API.G_MISS_CHAR,NULL,X_Attribute9),
178: decode(X_Attribute10,FND_API.G_MISS_CHAR,NULL,X_Attribute10),
179: decode(X_Attribute11,FND_API.G_MISS_CHAR,NULL,X_Attribute11),
180: decode(X_Attribute12,FND_API.G_MISS_CHAR,NULL,X_Attribute12),

Line 177: decode(X_Attribute9,FND_API.G_MISS_CHAR,NULL,X_Attribute9),

173: decode(X_Attribute5,FND_API.G_MISS_CHAR,NULL,X_Attribute5),
174: decode(X_Attribute6,FND_API.G_MISS_CHAR,NULL,X_Attribute6),
175: decode(X_Attribute7,FND_API.G_MISS_CHAR,NULL,X_Attribute7),
176: decode(X_Attribute8,FND_API.G_MISS_CHAR,NULL,X_Attribute8),
177: decode(X_Attribute9,FND_API.G_MISS_CHAR,NULL,X_Attribute9),
178: decode(X_Attribute10,FND_API.G_MISS_CHAR,NULL,X_Attribute10),
179: decode(X_Attribute11,FND_API.G_MISS_CHAR,NULL,X_Attribute11),
180: decode(X_Attribute12,FND_API.G_MISS_CHAR,NULL,X_Attribute12),
181: decode(X_Attribute13,FND_API.G_MISS_CHAR,NULL,X_Attribute13),

Line 178: decode(X_Attribute10,FND_API.G_MISS_CHAR,NULL,X_Attribute10),

174: decode(X_Attribute6,FND_API.G_MISS_CHAR,NULL,X_Attribute6),
175: decode(X_Attribute7,FND_API.G_MISS_CHAR,NULL,X_Attribute7),
176: decode(X_Attribute8,FND_API.G_MISS_CHAR,NULL,X_Attribute8),
177: decode(X_Attribute9,FND_API.G_MISS_CHAR,NULL,X_Attribute9),
178: decode(X_Attribute10,FND_API.G_MISS_CHAR,NULL,X_Attribute10),
179: decode(X_Attribute11,FND_API.G_MISS_CHAR,NULL,X_Attribute11),
180: decode(X_Attribute12,FND_API.G_MISS_CHAR,NULL,X_Attribute12),
181: decode(X_Attribute13,FND_API.G_MISS_CHAR,NULL,X_Attribute13),
182: decode(X_Attribute14,FND_API.G_MISS_CHAR,NULL,X_Attribute14),

Line 179: decode(X_Attribute11,FND_API.G_MISS_CHAR,NULL,X_Attribute11),

175: decode(X_Attribute7,FND_API.G_MISS_CHAR,NULL,X_Attribute7),
176: decode(X_Attribute8,FND_API.G_MISS_CHAR,NULL,X_Attribute8),
177: decode(X_Attribute9,FND_API.G_MISS_CHAR,NULL,X_Attribute9),
178: decode(X_Attribute10,FND_API.G_MISS_CHAR,NULL,X_Attribute10),
179: decode(X_Attribute11,FND_API.G_MISS_CHAR,NULL,X_Attribute11),
180: decode(X_Attribute12,FND_API.G_MISS_CHAR,NULL,X_Attribute12),
181: decode(X_Attribute13,FND_API.G_MISS_CHAR,NULL,X_Attribute13),
182: decode(X_Attribute14,FND_API.G_MISS_CHAR,NULL,X_Attribute14),
183: decode(X_Attribute15,FND_API.G_MISS_CHAR,NULL,X_Attribute15),

Line 180: decode(X_Attribute12,FND_API.G_MISS_CHAR,NULL,X_Attribute12),

176: decode(X_Attribute8,FND_API.G_MISS_CHAR,NULL,X_Attribute8),
177: decode(X_Attribute9,FND_API.G_MISS_CHAR,NULL,X_Attribute9),
178: decode(X_Attribute10,FND_API.G_MISS_CHAR,NULL,X_Attribute10),
179: decode(X_Attribute11,FND_API.G_MISS_CHAR,NULL,X_Attribute11),
180: decode(X_Attribute12,FND_API.G_MISS_CHAR,NULL,X_Attribute12),
181: decode(X_Attribute13,FND_API.G_MISS_CHAR,NULL,X_Attribute13),
182: decode(X_Attribute14,FND_API.G_MISS_CHAR,NULL,X_Attribute14),
183: decode(X_Attribute15,FND_API.G_MISS_CHAR,NULL,X_Attribute15),
184: decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Role_Code),

Line 181: decode(X_Attribute13,FND_API.G_MISS_CHAR,NULL,X_Attribute13),

177: decode(X_Attribute9,FND_API.G_MISS_CHAR,NULL,X_Attribute9),
178: decode(X_Attribute10,FND_API.G_MISS_CHAR,NULL,X_Attribute10),
179: decode(X_Attribute11,FND_API.G_MISS_CHAR,NULL,X_Attribute11),
180: decode(X_Attribute12,FND_API.G_MISS_CHAR,NULL,X_Attribute12),
181: decode(X_Attribute13,FND_API.G_MISS_CHAR,NULL,X_Attribute13),
182: decode(X_Attribute14,FND_API.G_MISS_CHAR,NULL,X_Attribute14),
183: decode(X_Attribute15,FND_API.G_MISS_CHAR,NULL,X_Attribute15),
184: decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Role_Code),
185: decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Relationship_Code),

Line 182: decode(X_Attribute14,FND_API.G_MISS_CHAR,NULL,X_Attribute14),

178: decode(X_Attribute10,FND_API.G_MISS_CHAR,NULL,X_Attribute10),
179: decode(X_Attribute11,FND_API.G_MISS_CHAR,NULL,X_Attribute11),
180: decode(X_Attribute12,FND_API.G_MISS_CHAR,NULL,X_Attribute12),
181: decode(X_Attribute13,FND_API.G_MISS_CHAR,NULL,X_Attribute13),
182: decode(X_Attribute14,FND_API.G_MISS_CHAR,NULL,X_Attribute14),
183: decode(X_Attribute15,FND_API.G_MISS_CHAR,NULL,X_Attribute15),
184: decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Role_Code),
185: decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Relationship_Code),
186: decode(X_Internal_update_access,FND_API.G_MISS_NUM,NULL,X_Internal_update_access),

Line 183: decode(X_Attribute15,FND_API.G_MISS_CHAR,NULL,X_Attribute15),

179: decode(X_Attribute11,FND_API.G_MISS_CHAR,NULL,X_Attribute11),
180: decode(X_Attribute12,FND_API.G_MISS_CHAR,NULL,X_Attribute12),
181: decode(X_Attribute13,FND_API.G_MISS_CHAR,NULL,X_Attribute13),
182: decode(X_Attribute14,FND_API.G_MISS_CHAR,NULL,X_Attribute14),
183: decode(X_Attribute15,FND_API.G_MISS_CHAR,NULL,X_Attribute15),
184: decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Role_Code),
185: decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Relationship_Code),
186: decode(X_Internal_update_access,FND_API.G_MISS_NUM,NULL,X_Internal_update_access),
187: decode(X_Sales_lead_id,FND_API.G_MISS_NUM,NULL,X_Sales_lead_id),

Line 184: decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Role_Code),

180: decode(X_Attribute12,FND_API.G_MISS_CHAR,NULL,X_Attribute12),
181: decode(X_Attribute13,FND_API.G_MISS_CHAR,NULL,X_Attribute13),
182: decode(X_Attribute14,FND_API.G_MISS_CHAR,NULL,X_Attribute14),
183: decode(X_Attribute15,FND_API.G_MISS_CHAR,NULL,X_Attribute15),
184: decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Role_Code),
185: decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Relationship_Code),
186: decode(X_Internal_update_access,FND_API.G_MISS_NUM,NULL,X_Internal_update_access),
187: decode(X_Sales_lead_id,FND_API.G_MISS_NUM,NULL,X_Sales_lead_id),
188: decode(X_Sales_group_id,FND_API.G_MISS_NUM,NULL,X_Sales_group_id),

Line 185: decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Relationship_Code),

181: decode(X_Attribute13,FND_API.G_MISS_CHAR,NULL,X_Attribute13),
182: decode(X_Attribute14,FND_API.G_MISS_CHAR,NULL,X_Attribute14),
183: decode(X_Attribute15,FND_API.G_MISS_CHAR,NULL,X_Attribute15),
184: decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Role_Code),
185: decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Relationship_Code),
186: decode(X_Internal_update_access,FND_API.G_MISS_NUM,NULL,X_Internal_update_access),
187: decode(X_Sales_lead_id,FND_API.G_MISS_NUM,NULL,X_Sales_lead_id),
188: decode(X_Sales_group_id,FND_API.G_MISS_NUM,NULL,X_Sales_group_id),
189: decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,NULL,X_Partner_Cont_Party_Id),

Line 186: decode(X_Internal_update_access,FND_API.G_MISS_NUM,NULL,X_Internal_update_access),

182: decode(X_Attribute14,FND_API.G_MISS_CHAR,NULL,X_Attribute14),
183: decode(X_Attribute15,FND_API.G_MISS_CHAR,NULL,X_Attribute15),
184: decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Role_Code),
185: decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Relationship_Code),
186: decode(X_Internal_update_access,FND_API.G_MISS_NUM,NULL,X_Internal_update_access),
187: decode(X_Sales_lead_id,FND_API.G_MISS_NUM,NULL,X_Sales_lead_id),
188: decode(X_Sales_group_id,FND_API.G_MISS_NUM,NULL,X_Sales_group_id),
189: decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,NULL,X_Partner_Cont_Party_Id),
190: decode(X_owner_flag,FND_API.G_MISS_CHAR,'N',X_owner_flag),

Line 187: decode(X_Sales_lead_id,FND_API.G_MISS_NUM,NULL,X_Sales_lead_id),

183: decode(X_Attribute15,FND_API.G_MISS_CHAR,NULL,X_Attribute15),
184: decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Role_Code),
185: decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Relationship_Code),
186: decode(X_Internal_update_access,FND_API.G_MISS_NUM,NULL,X_Internal_update_access),
187: decode(X_Sales_lead_id,FND_API.G_MISS_NUM,NULL,X_Sales_lead_id),
188: decode(X_Sales_group_id,FND_API.G_MISS_NUM,NULL,X_Sales_group_id),
189: decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,NULL,X_Partner_Cont_Party_Id),
190: decode(X_owner_flag,FND_API.G_MISS_CHAR,'N',X_owner_flag),
191: decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,NULL,X_created_by_tap_flag),

Line 188: decode(X_Sales_group_id,FND_API.G_MISS_NUM,NULL,X_Sales_group_id),

184: decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Role_Code),
185: decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Relationship_Code),
186: decode(X_Internal_update_access,FND_API.G_MISS_NUM,NULL,X_Internal_update_access),
187: decode(X_Sales_lead_id,FND_API.G_MISS_NUM,NULL,X_Sales_lead_id),
188: decode(X_Sales_group_id,FND_API.G_MISS_NUM,NULL,X_Sales_group_id),
189: decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,NULL,X_Partner_Cont_Party_Id),
190: decode(X_owner_flag,FND_API.G_MISS_CHAR,'N',X_owner_flag),
191: decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,NULL,X_created_by_tap_flag),
192: decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,NULL,X_prm_keep_flag),

Line 189: decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,NULL,X_Partner_Cont_Party_Id),

185: decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,NULL,X_Salesforce_Relationship_Code),
186: decode(X_Internal_update_access,FND_API.G_MISS_NUM,NULL,X_Internal_update_access),
187: decode(X_Sales_lead_id,FND_API.G_MISS_NUM,NULL,X_Sales_lead_id),
188: decode(X_Sales_group_id,FND_API.G_MISS_NUM,NULL,X_Sales_group_id),
189: decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,NULL,X_Partner_Cont_Party_Id),
190: decode(X_owner_flag,FND_API.G_MISS_CHAR,'N',X_owner_flag),
191: decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,NULL,X_created_by_tap_flag),
192: decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,NULL,X_prm_keep_flag),
193: decode(X_open_flag, FND_API.G_MISS_CHAR, 'N', X_open_flag),

Line 190: decode(X_owner_flag,FND_API.G_MISS_CHAR,'N',X_owner_flag),

186: decode(X_Internal_update_access,FND_API.G_MISS_NUM,NULL,X_Internal_update_access),
187: decode(X_Sales_lead_id,FND_API.G_MISS_NUM,NULL,X_Sales_lead_id),
188: decode(X_Sales_group_id,FND_API.G_MISS_NUM,NULL,X_Sales_group_id),
189: decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,NULL,X_Partner_Cont_Party_Id),
190: decode(X_owner_flag,FND_API.G_MISS_CHAR,'N',X_owner_flag),
191: decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,NULL,X_created_by_tap_flag),
192: decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,NULL,X_prm_keep_flag),
193: decode(X_open_flag, FND_API.G_MISS_CHAR, 'N', X_open_flag),
194: decode(X_lead_rank_score, FND_API.G_MISS_NUM, NULL, X_lead_rank_score),

Line 191: decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,NULL,X_created_by_tap_flag),

187: decode(X_Sales_lead_id,FND_API.G_MISS_NUM,NULL,X_Sales_lead_id),
188: decode(X_Sales_group_id,FND_API.G_MISS_NUM,NULL,X_Sales_group_id),
189: decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,NULL,X_Partner_Cont_Party_Id),
190: decode(X_owner_flag,FND_API.G_MISS_CHAR,'N',X_owner_flag),
191: decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,NULL,X_created_by_tap_flag),
192: decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,NULL,X_prm_keep_flag),
193: decode(X_open_flag, FND_API.G_MISS_CHAR, 'N', X_open_flag),
194: decode(X_lead_rank_score, FND_API.G_MISS_NUM, NULL, X_lead_rank_score),
195: decode(X_object_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), X_object_creation_date),

Line 192: decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,NULL,X_prm_keep_flag),

188: decode(X_Sales_group_id,FND_API.G_MISS_NUM,NULL,X_Sales_group_id),
189: decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,NULL,X_Partner_Cont_Party_Id),
190: decode(X_owner_flag,FND_API.G_MISS_CHAR,'N',X_owner_flag),
191: decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,NULL,X_created_by_tap_flag),
192: decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,NULL,X_prm_keep_flag),
193: decode(X_open_flag, FND_API.G_MISS_CHAR, 'N', X_open_flag),
194: decode(X_lead_rank_score, FND_API.G_MISS_NUM, NULL, X_lead_rank_score),
195: decode(X_object_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), X_object_creation_date),
196: decode(X_contributor_flag, FND_API.G_MISS_CHAR, 'N', X_contributor_flag) -- Added for ASNB

Line 193: decode(X_open_flag, FND_API.G_MISS_CHAR, 'N', X_open_flag),

189: decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,NULL,X_Partner_Cont_Party_Id),
190: decode(X_owner_flag,FND_API.G_MISS_CHAR,'N',X_owner_flag),
191: decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,NULL,X_created_by_tap_flag),
192: decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,NULL,X_prm_keep_flag),
193: decode(X_open_flag, FND_API.G_MISS_CHAR, 'N', X_open_flag),
194: decode(X_lead_rank_score, FND_API.G_MISS_NUM, NULL, X_lead_rank_score),
195: decode(X_object_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), X_object_creation_date),
196: decode(X_contributor_flag, FND_API.G_MISS_CHAR, 'N', X_contributor_flag) -- Added for ASNB
197: );

Line 194: decode(X_lead_rank_score, FND_API.G_MISS_NUM, NULL, X_lead_rank_score),

190: decode(X_owner_flag,FND_API.G_MISS_CHAR,'N',X_owner_flag),
191: decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,NULL,X_created_by_tap_flag),
192: decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,NULL,X_prm_keep_flag),
193: decode(X_open_flag, FND_API.G_MISS_CHAR, 'N', X_open_flag),
194: decode(X_lead_rank_score, FND_API.G_MISS_NUM, NULL, X_lead_rank_score),
195: decode(X_object_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), X_object_creation_date),
196: decode(X_contributor_flag, FND_API.G_MISS_CHAR, 'N', X_contributor_flag) -- Added for ASNB
197: );
198:

Line 195: decode(X_object_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), X_object_creation_date),

191: decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,NULL,X_created_by_tap_flag),
192: decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,NULL,X_prm_keep_flag),
193: decode(X_open_flag, FND_API.G_MISS_CHAR, 'N', X_open_flag),
194: decode(X_lead_rank_score, FND_API.G_MISS_NUM, NULL, X_lead_rank_score),
195: decode(X_object_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), X_object_creation_date),
196: decode(X_contributor_flag, FND_API.G_MISS_CHAR, 'N', X_contributor_flag) -- Added for ASNB
197: );
198:
199: OPEN C;

Line 196: decode(X_contributor_flag, FND_API.G_MISS_CHAR, 'N', X_contributor_flag) -- Added for ASNB

192: decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,NULL,X_prm_keep_flag),
193: decode(X_open_flag, FND_API.G_MISS_CHAR, 'N', X_open_flag),
194: decode(X_lead_rank_score, FND_API.G_MISS_NUM, NULL, X_lead_rank_score),
195: decode(X_object_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), X_object_creation_date),
196: decode(X_contributor_flag, FND_API.G_MISS_CHAR, 'N', X_contributor_flag) -- Added for ASNB
197: );
198:
199: OPEN C;
200: FETCH C INTO X_Rowid;

Line 458: access_type = decode(X_Access_Type,FND_API.G_MISS_CHAR,access_type,X_Access_Type),

454: access_id = X_Access_Id,
455: last_update_date = X_Last_Update_Date,
456: last_updated_by = X_Last_Updated_By,
457: last_update_login = X_Last_Update_Login,
458: access_type = decode(X_Access_Type,FND_API.G_MISS_CHAR,access_type,X_Access_Type),
459: freeze_flag = decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,freeze_flag,X_Freeze_Flag),
460: reassign_flag = decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,reassign_flag,X_Reassign_Flag),
461: team_leader_flag = decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,team_leader_flag,X_Team_Leader_Flag),
462: person_id = decode(X_Person_Id,FND_API.G_MISS_NUM, person_id,X_Person_Id ),

Line 459: freeze_flag = decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,freeze_flag,X_Freeze_Flag),

455: last_update_date = X_Last_Update_Date,
456: last_updated_by = X_Last_Updated_By,
457: last_update_login = X_Last_Update_Login,
458: access_type = decode(X_Access_Type,FND_API.G_MISS_CHAR,access_type,X_Access_Type),
459: freeze_flag = decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,freeze_flag,X_Freeze_Flag),
460: reassign_flag = decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,reassign_flag,X_Reassign_Flag),
461: team_leader_flag = decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,team_leader_flag,X_Team_Leader_Flag),
462: person_id = decode(X_Person_Id,FND_API.G_MISS_NUM, person_id,X_Person_Id ),
463: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),

Line 460: reassign_flag = decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,reassign_flag,X_Reassign_Flag),

456: last_updated_by = X_Last_Updated_By,
457: last_update_login = X_Last_Update_Login,
458: access_type = decode(X_Access_Type,FND_API.G_MISS_CHAR,access_type,X_Access_Type),
459: freeze_flag = decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,freeze_flag,X_Freeze_Flag),
460: reassign_flag = decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,reassign_flag,X_Reassign_Flag),
461: team_leader_flag = decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,team_leader_flag,X_Team_Leader_Flag),
462: person_id = decode(X_Person_Id,FND_API.G_MISS_NUM, person_id,X_Person_Id ),
463: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
464: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM,address_id,X_Address_Id ),

Line 461: team_leader_flag = decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,team_leader_flag,X_Team_Leader_Flag),

457: last_update_login = X_Last_Update_Login,
458: access_type = decode(X_Access_Type,FND_API.G_MISS_CHAR,access_type,X_Access_Type),
459: freeze_flag = decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,freeze_flag,X_Freeze_Flag),
460: reassign_flag = decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,reassign_flag,X_Reassign_Flag),
461: team_leader_flag = decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,team_leader_flag,X_Team_Leader_Flag),
462: person_id = decode(X_Person_Id,FND_API.G_MISS_NUM, person_id,X_Person_Id ),
463: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
464: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM,address_id,X_Address_Id ),
465: salesforce_id = decode(X_Salesforce_Id,FND_API.G_MISS_NUM,salesforce_id,X_Salesforce_Id),

Line 462: person_id = decode(X_Person_Id,FND_API.G_MISS_NUM, person_id,X_Person_Id ),

458: access_type = decode(X_Access_Type,FND_API.G_MISS_CHAR,access_type,X_Access_Type),
459: freeze_flag = decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,freeze_flag,X_Freeze_Flag),
460: reassign_flag = decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,reassign_flag,X_Reassign_Flag),
461: team_leader_flag = decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,team_leader_flag,X_Team_Leader_Flag),
462: person_id = decode(X_Person_Id,FND_API.G_MISS_NUM, person_id,X_Person_Id ),
463: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
464: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM,address_id,X_Address_Id ),
465: salesforce_id = decode(X_Salesforce_Id,FND_API.G_MISS_NUM,salesforce_id,X_Salesforce_Id),
466: partner_customer_id =decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM,partner_customer_id,X_Partner_Customer_Id),

Line 463: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),

459: freeze_flag = decode(X_Freeze_Flag,FND_API.G_MISS_CHAR,freeze_flag,X_Freeze_Flag),
460: reassign_flag = decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,reassign_flag,X_Reassign_Flag),
461: team_leader_flag = decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,team_leader_flag,X_Team_Leader_Flag),
462: person_id = decode(X_Person_Id,FND_API.G_MISS_NUM, person_id,X_Person_Id ),
463: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
464: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM,address_id,X_Address_Id ),
465: salesforce_id = decode(X_Salesforce_Id,FND_API.G_MISS_NUM,salesforce_id,X_Salesforce_Id),
466: partner_customer_id =decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM,partner_customer_id,X_Partner_Customer_Id),
467: partner_address_id = decode(X_Partner_Address_Id,FND_API.G_MISS_NUM,partner_address_id,X_Partner_Address_Id),

Line 464: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM,address_id,X_Address_Id ),

460: reassign_flag = decode(X_Reassign_Flag,FND_API.G_MISS_CHAR,reassign_flag,X_Reassign_Flag),
461: team_leader_flag = decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,team_leader_flag,X_Team_Leader_Flag),
462: person_id = decode(X_Person_Id,FND_API.G_MISS_NUM, person_id,X_Person_Id ),
463: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
464: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM,address_id,X_Address_Id ),
465: salesforce_id = decode(X_Salesforce_Id,FND_API.G_MISS_NUM,salesforce_id,X_Salesforce_Id),
466: partner_customer_id =decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM,partner_customer_id,X_Partner_Customer_Id),
467: partner_address_id = decode(X_Partner_Address_Id,FND_API.G_MISS_NUM,partner_address_id,X_Partner_Address_Id),
468: created_person_id = decode(X_Created_Person_Id,FND_API.G_MISS_NUM,created_person_id,X_Created_Person_Id ),

Line 465: salesforce_id = decode(X_Salesforce_Id,FND_API.G_MISS_NUM,salesforce_id,X_Salesforce_Id),

461: team_leader_flag = decode(X_Team_Leader_Flag,FND_API.G_MISS_CHAR,team_leader_flag,X_Team_Leader_Flag),
462: person_id = decode(X_Person_Id,FND_API.G_MISS_NUM, person_id,X_Person_Id ),
463: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
464: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM,address_id,X_Address_Id ),
465: salesforce_id = decode(X_Salesforce_Id,FND_API.G_MISS_NUM,salesforce_id,X_Salesforce_Id),
466: partner_customer_id =decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM,partner_customer_id,X_Partner_Customer_Id),
467: partner_address_id = decode(X_Partner_Address_Id,FND_API.G_MISS_NUM,partner_address_id,X_Partner_Address_Id),
468: created_person_id = decode(X_Created_Person_Id,FND_API.G_MISS_NUM,created_person_id,X_Created_Person_Id ),
469: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM,lead_id,X_Lead_Id ),

Line 466: partner_customer_id =decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM,partner_customer_id,X_Partner_Customer_Id),

462: person_id = decode(X_Person_Id,FND_API.G_MISS_NUM, person_id,X_Person_Id ),
463: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
464: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM,address_id,X_Address_Id ),
465: salesforce_id = decode(X_Salesforce_Id,FND_API.G_MISS_NUM,salesforce_id,X_Salesforce_Id),
466: partner_customer_id =decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM,partner_customer_id,X_Partner_Customer_Id),
467: partner_address_id = decode(X_Partner_Address_Id,FND_API.G_MISS_NUM,partner_address_id,X_Partner_Address_Id),
468: created_person_id = decode(X_Created_Person_Id,FND_API.G_MISS_NUM,created_person_id,X_Created_Person_Id ),
469: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM,lead_id,X_Lead_Id ),
470: freeze_date = decode(X_Freeze_Date,FND_API.G_MISS_DATE, freeze_date,X_Freeze_Date),

Line 467: partner_address_id = decode(X_Partner_Address_Id,FND_API.G_MISS_NUM,partner_address_id,X_Partner_Address_Id),

463: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
464: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM,address_id,X_Address_Id ),
465: salesforce_id = decode(X_Salesforce_Id,FND_API.G_MISS_NUM,salesforce_id,X_Salesforce_Id),
466: partner_customer_id =decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM,partner_customer_id,X_Partner_Customer_Id),
467: partner_address_id = decode(X_Partner_Address_Id,FND_API.G_MISS_NUM,partner_address_id,X_Partner_Address_Id),
468: created_person_id = decode(X_Created_Person_Id,FND_API.G_MISS_NUM,created_person_id,X_Created_Person_Id ),
469: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM,lead_id,X_Lead_Id ),
470: freeze_date = decode(X_Freeze_Date,FND_API.G_MISS_DATE, freeze_date,X_Freeze_Date),
471: reassign_reason = decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,reassign_reason,X_Reassign_Reason),

Line 468: created_person_id = decode(X_Created_Person_Id,FND_API.G_MISS_NUM,created_person_id,X_Created_Person_Id ),

464: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM,address_id,X_Address_Id ),
465: salesforce_id = decode(X_Salesforce_Id,FND_API.G_MISS_NUM,salesforce_id,X_Salesforce_Id),
466: partner_customer_id =decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM,partner_customer_id,X_Partner_Customer_Id),
467: partner_address_id = decode(X_Partner_Address_Id,FND_API.G_MISS_NUM,partner_address_id,X_Partner_Address_Id),
468: created_person_id = decode(X_Created_Person_Id,FND_API.G_MISS_NUM,created_person_id,X_Created_Person_Id ),
469: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM,lead_id,X_Lead_Id ),
470: freeze_date = decode(X_Freeze_Date,FND_API.G_MISS_DATE, freeze_date,X_Freeze_Date),
471: reassign_reason = decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,reassign_reason,X_Reassign_Reason),
472: reassign_request_date = decode(X_reassign_request_date,FND_API.G_MISS_DATE,

Line 469: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM,lead_id,X_Lead_Id ),

465: salesforce_id = decode(X_Salesforce_Id,FND_API.G_MISS_NUM,salesforce_id,X_Salesforce_Id),
466: partner_customer_id =decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM,partner_customer_id,X_Partner_Customer_Id),
467: partner_address_id = decode(X_Partner_Address_Id,FND_API.G_MISS_NUM,partner_address_id,X_Partner_Address_Id),
468: created_person_id = decode(X_Created_Person_Id,FND_API.G_MISS_NUM,created_person_id,X_Created_Person_Id ),
469: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM,lead_id,X_Lead_Id ),
470: freeze_date = decode(X_Freeze_Date,FND_API.G_MISS_DATE, freeze_date,X_Freeze_Date),
471: reassign_reason = decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,reassign_reason,X_Reassign_Reason),
472: reassign_request_date = decode(X_reassign_request_date,FND_API.G_MISS_DATE,
473: reassign_request_date,X_reassign_request_date),

Line 470: freeze_date = decode(X_Freeze_Date,FND_API.G_MISS_DATE, freeze_date,X_Freeze_Date),

466: partner_customer_id =decode(X_Partner_Customer_Id,FND_API.G_MISS_NUM,partner_customer_id,X_Partner_Customer_Id),
467: partner_address_id = decode(X_Partner_Address_Id,FND_API.G_MISS_NUM,partner_address_id,X_Partner_Address_Id),
468: created_person_id = decode(X_Created_Person_Id,FND_API.G_MISS_NUM,created_person_id,X_Created_Person_Id ),
469: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM,lead_id,X_Lead_Id ),
470: freeze_date = decode(X_Freeze_Date,FND_API.G_MISS_DATE, freeze_date,X_Freeze_Date),
471: reassign_reason = decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,reassign_reason,X_Reassign_Reason),
472: reassign_request_date = decode(X_reassign_request_date,FND_API.G_MISS_DATE,
473: reassign_request_date,X_reassign_request_date),
474: reassign_requested_person_id = decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,

Line 471: reassign_reason = decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,reassign_reason,X_Reassign_Reason),

467: partner_address_id = decode(X_Partner_Address_Id,FND_API.G_MISS_NUM,partner_address_id,X_Partner_Address_Id),
468: created_person_id = decode(X_Created_Person_Id,FND_API.G_MISS_NUM,created_person_id,X_Created_Person_Id ),
469: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM,lead_id,X_Lead_Id ),
470: freeze_date = decode(X_Freeze_Date,FND_API.G_MISS_DATE, freeze_date,X_Freeze_Date),
471: reassign_reason = decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,reassign_reason,X_Reassign_Reason),
472: reassign_request_date = decode(X_reassign_request_date,FND_API.G_MISS_DATE,
473: reassign_request_date,X_reassign_request_date),
474: reassign_requested_person_id = decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
475: reassign_requested_person_id ,X_reassign_requested_person_id ),

Line 472: reassign_request_date = decode(X_reassign_request_date,FND_API.G_MISS_DATE,

468: created_person_id = decode(X_Created_Person_Id,FND_API.G_MISS_NUM,created_person_id,X_Created_Person_Id ),
469: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM,lead_id,X_Lead_Id ),
470: freeze_date = decode(X_Freeze_Date,FND_API.G_MISS_DATE, freeze_date,X_Freeze_Date),
471: reassign_reason = decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,reassign_reason,X_Reassign_Reason),
472: reassign_request_date = decode(X_reassign_request_date,FND_API.G_MISS_DATE,
473: reassign_request_date,X_reassign_request_date),
474: reassign_requested_person_id = decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
475: reassign_requested_person_id ,X_reassign_requested_person_id ),
476: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),

Line 474: reassign_requested_person_id = decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,

470: freeze_date = decode(X_Freeze_Date,FND_API.G_MISS_DATE, freeze_date,X_Freeze_Date),
471: reassign_reason = decode(X_Reassign_Reason,FND_API.G_MISS_CHAR,reassign_reason,X_Reassign_Reason),
472: reassign_request_date = decode(X_reassign_request_date,FND_API.G_MISS_DATE,
473: reassign_request_date,X_reassign_request_date),
474: reassign_requested_person_id = decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
475: reassign_requested_person_id ,X_reassign_requested_person_id ),
476: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
477: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
478: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),

Line 476: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),

472: reassign_request_date = decode(X_reassign_request_date,FND_API.G_MISS_DATE,
473: reassign_request_date,X_reassign_request_date),
474: reassign_requested_person_id = decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
475: reassign_requested_person_id ,X_reassign_requested_person_id ),
476: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
477: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
478: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
479: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
480: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),

Line 477: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),

473: reassign_request_date,X_reassign_request_date),
474: reassign_requested_person_id = decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
475: reassign_requested_person_id ,X_reassign_requested_person_id ),
476: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
477: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
478: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
479: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
480: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
481: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),

Line 478: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),

474: reassign_requested_person_id = decode(X_reassign_requested_person_id ,FND_API.G_MISS_NUM,
475: reassign_requested_person_id ,X_reassign_requested_person_id ),
476: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
477: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
478: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
479: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
480: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
481: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
482: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),

Line 479: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),

475: reassign_requested_person_id ,X_reassign_requested_person_id ),
476: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
477: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
478: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
479: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
480: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
481: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
482: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
483: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),

Line 480: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),

476: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
477: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
478: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
479: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
480: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
481: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
482: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
483: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
484: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),

Line 481: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),

477: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
478: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
479: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
480: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
481: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
482: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
483: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
484: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
485: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),

Line 482: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),

478: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
479: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
480: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
481: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
482: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
483: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
484: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
485: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
486: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),

Line 483: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),

479: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
480: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
481: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
482: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
483: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
484: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
485: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
486: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
487: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),

Line 484: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),

480: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
481: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
482: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
483: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
484: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
485: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
486: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
487: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
488: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),

Line 485: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),

481: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
482: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
483: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
484: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
485: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
486: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
487: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
488: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
489: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),

Line 486: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),

482: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
483: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
484: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
485: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
486: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
487: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
488: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
489: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
490: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),

Line 487: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),

483: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
484: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
485: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
486: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
487: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
488: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
489: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
490: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
491: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),

Line 488: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),

484: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
485: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
486: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
487: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
488: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
489: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
490: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
491: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
492: salesforce_role_code = decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,salesforce_role_code,X_Salesforce_Role_Code),

Line 489: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),

485: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
486: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
487: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
488: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
489: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
490: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
491: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
492: salesforce_role_code = decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,salesforce_role_code,X_Salesforce_Role_Code),
493: salesforce_relationship_code = decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,salesforce_relationship_code,X_Salesforce_Relationship_Code),

Line 490: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),

486: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
487: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
488: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
489: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
490: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
491: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
492: salesforce_role_code = decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,salesforce_role_code,X_Salesforce_Role_Code),
493: salesforce_relationship_code = decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,salesforce_relationship_code,X_Salesforce_Relationship_Code),
494: internal_update_access = decode(X_Internal_update_access,FND_API.G_MISS_NUM,internal_update_access,X_Internal_update_access),

Line 491: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),

487: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
488: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
489: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
490: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
491: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
492: salesforce_role_code = decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,salesforce_role_code,X_Salesforce_Role_Code),
493: salesforce_relationship_code = decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,salesforce_relationship_code,X_Salesforce_Relationship_Code),
494: internal_update_access = decode(X_Internal_update_access,FND_API.G_MISS_NUM,internal_update_access,X_Internal_update_access),
495: sales_lead_id = decode(X_Sales_lead_id,FND_API.G_MISS_NUM,sales_lead_id,X_Sales_lead_id),

Line 492: salesforce_role_code = decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,salesforce_role_code,X_Salesforce_Role_Code),

488: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
489: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
490: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
491: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
492: salesforce_role_code = decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,salesforce_role_code,X_Salesforce_Role_Code),
493: salesforce_relationship_code = decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,salesforce_relationship_code,X_Salesforce_Relationship_Code),
494: internal_update_access = decode(X_Internal_update_access,FND_API.G_MISS_NUM,internal_update_access,X_Internal_update_access),
495: sales_lead_id = decode(X_Sales_lead_id,FND_API.G_MISS_NUM,sales_lead_id,X_Sales_lead_id),
496: sales_group_id = decode(X_Sales_group_id,FND_API.G_MISS_NUM,sales_group_id,X_Sales_group_id),

Line 493: salesforce_relationship_code = decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,salesforce_relationship_code,X_Salesforce_Relationship_Code),

489: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
490: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
491: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
492: salesforce_role_code = decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,salesforce_role_code,X_Salesforce_Role_Code),
493: salesforce_relationship_code = decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,salesforce_relationship_code,X_Salesforce_Relationship_Code),
494: internal_update_access = decode(X_Internal_update_access,FND_API.G_MISS_NUM,internal_update_access,X_Internal_update_access),
495: sales_lead_id = decode(X_Sales_lead_id,FND_API.G_MISS_NUM,sales_lead_id,X_Sales_lead_id),
496: sales_group_id = decode(X_Sales_group_id,FND_API.G_MISS_NUM,sales_group_id,X_Sales_group_id),
497: partner_cont_party_id =decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,partner_cont_party_id,X_Partner_Cont_Party_Id),

Line 494: internal_update_access = decode(X_Internal_update_access,FND_API.G_MISS_NUM,internal_update_access,X_Internal_update_access),

490: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
491: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
492: salesforce_role_code = decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,salesforce_role_code,X_Salesforce_Role_Code),
493: salesforce_relationship_code = decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,salesforce_relationship_code,X_Salesforce_Relationship_Code),
494: internal_update_access = decode(X_Internal_update_access,FND_API.G_MISS_NUM,internal_update_access,X_Internal_update_access),
495: sales_lead_id = decode(X_Sales_lead_id,FND_API.G_MISS_NUM,sales_lead_id,X_Sales_lead_id),
496: sales_group_id = decode(X_Sales_group_id,FND_API.G_MISS_NUM,sales_group_id,X_Sales_group_id),
497: partner_cont_party_id =decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,partner_cont_party_id,X_Partner_Cont_Party_Id),
498: owner_flag = decode(X_owner_flag,FND_API.G_MISS_CHAR,owner_flag,X_owner_flag),

Line 495: sales_lead_id = decode(X_Sales_lead_id,FND_API.G_MISS_NUM,sales_lead_id,X_Sales_lead_id),

491: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
492: salesforce_role_code = decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,salesforce_role_code,X_Salesforce_Role_Code),
493: salesforce_relationship_code = decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,salesforce_relationship_code,X_Salesforce_Relationship_Code),
494: internal_update_access = decode(X_Internal_update_access,FND_API.G_MISS_NUM,internal_update_access,X_Internal_update_access),
495: sales_lead_id = decode(X_Sales_lead_id,FND_API.G_MISS_NUM,sales_lead_id,X_Sales_lead_id),
496: sales_group_id = decode(X_Sales_group_id,FND_API.G_MISS_NUM,sales_group_id,X_Sales_group_id),
497: partner_cont_party_id =decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,partner_cont_party_id,X_Partner_Cont_Party_Id),
498: owner_flag = decode(X_owner_flag,FND_API.G_MISS_CHAR,owner_flag,X_owner_flag),
499: created_by_tap_flag = decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,created_by_tap_flag,X_created_by_tap_flag),

Line 496: sales_group_id = decode(X_Sales_group_id,FND_API.G_MISS_NUM,sales_group_id,X_Sales_group_id),

492: salesforce_role_code = decode(X_Salesforce_Role_Code,FND_API.G_MISS_CHAR,salesforce_role_code,X_Salesforce_Role_Code),
493: salesforce_relationship_code = decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,salesforce_relationship_code,X_Salesforce_Relationship_Code),
494: internal_update_access = decode(X_Internal_update_access,FND_API.G_MISS_NUM,internal_update_access,X_Internal_update_access),
495: sales_lead_id = decode(X_Sales_lead_id,FND_API.G_MISS_NUM,sales_lead_id,X_Sales_lead_id),
496: sales_group_id = decode(X_Sales_group_id,FND_API.G_MISS_NUM,sales_group_id,X_Sales_group_id),
497: partner_cont_party_id =decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,partner_cont_party_id,X_Partner_Cont_Party_Id),
498: owner_flag = decode(X_owner_flag,FND_API.G_MISS_CHAR,owner_flag,X_owner_flag),
499: created_by_tap_flag = decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,created_by_tap_flag,X_created_by_tap_flag),
500: prm_keep_flag = decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,prm_keep_flag,X_prm_keep_flag),

Line 497: partner_cont_party_id =decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,partner_cont_party_id,X_Partner_Cont_Party_Id),

493: salesforce_relationship_code = decode(X_Salesforce_Relationship_Code,FND_API.G_MISS_CHAR,salesforce_relationship_code,X_Salesforce_Relationship_Code),
494: internal_update_access = decode(X_Internal_update_access,FND_API.G_MISS_NUM,internal_update_access,X_Internal_update_access),
495: sales_lead_id = decode(X_Sales_lead_id,FND_API.G_MISS_NUM,sales_lead_id,X_Sales_lead_id),
496: sales_group_id = decode(X_Sales_group_id,FND_API.G_MISS_NUM,sales_group_id,X_Sales_group_id),
497: partner_cont_party_id =decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,partner_cont_party_id,X_Partner_Cont_Party_Id),
498: owner_flag = decode(X_owner_flag,FND_API.G_MISS_CHAR,owner_flag,X_owner_flag),
499: created_by_tap_flag = decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,created_by_tap_flag,X_created_by_tap_flag),
500: prm_keep_flag = decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,prm_keep_flag,X_prm_keep_flag),
501: contributor_flag = decode(X_contributor_flag,FND_API.G_MISS_CHAR,contributor_flag,X_contributor_flag) -- Added for ASNB

Line 498: owner_flag = decode(X_owner_flag,FND_API.G_MISS_CHAR,owner_flag,X_owner_flag),

494: internal_update_access = decode(X_Internal_update_access,FND_API.G_MISS_NUM,internal_update_access,X_Internal_update_access),
495: sales_lead_id = decode(X_Sales_lead_id,FND_API.G_MISS_NUM,sales_lead_id,X_Sales_lead_id),
496: sales_group_id = decode(X_Sales_group_id,FND_API.G_MISS_NUM,sales_group_id,X_Sales_group_id),
497: partner_cont_party_id =decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,partner_cont_party_id,X_Partner_Cont_Party_Id),
498: owner_flag = decode(X_owner_flag,FND_API.G_MISS_CHAR,owner_flag,X_owner_flag),
499: created_by_tap_flag = decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,created_by_tap_flag,X_created_by_tap_flag),
500: prm_keep_flag = decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,prm_keep_flag,X_prm_keep_flag),
501: contributor_flag = decode(X_contributor_flag,FND_API.G_MISS_CHAR,contributor_flag,X_contributor_flag) -- Added for ASNB
502: WHERE rowid = X_rowid;

Line 499: created_by_tap_flag = decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,created_by_tap_flag,X_created_by_tap_flag),

495: sales_lead_id = decode(X_Sales_lead_id,FND_API.G_MISS_NUM,sales_lead_id,X_Sales_lead_id),
496: sales_group_id = decode(X_Sales_group_id,FND_API.G_MISS_NUM,sales_group_id,X_Sales_group_id),
497: partner_cont_party_id =decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,partner_cont_party_id,X_Partner_Cont_Party_Id),
498: owner_flag = decode(X_owner_flag,FND_API.G_MISS_CHAR,owner_flag,X_owner_flag),
499: created_by_tap_flag = decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,created_by_tap_flag,X_created_by_tap_flag),
500: prm_keep_flag = decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,prm_keep_flag,X_prm_keep_flag),
501: contributor_flag = decode(X_contributor_flag,FND_API.G_MISS_CHAR,contributor_flag,X_contributor_flag) -- Added for ASNB
502: WHERE rowid = X_rowid;
503:

Line 500: prm_keep_flag = decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,prm_keep_flag,X_prm_keep_flag),

496: sales_group_id = decode(X_Sales_group_id,FND_API.G_MISS_NUM,sales_group_id,X_Sales_group_id),
497: partner_cont_party_id =decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,partner_cont_party_id,X_Partner_Cont_Party_Id),
498: owner_flag = decode(X_owner_flag,FND_API.G_MISS_CHAR,owner_flag,X_owner_flag),
499: created_by_tap_flag = decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,created_by_tap_flag,X_created_by_tap_flag),
500: prm_keep_flag = decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,prm_keep_flag,X_prm_keep_flag),
501: contributor_flag = decode(X_contributor_flag,FND_API.G_MISS_CHAR,contributor_flag,X_contributor_flag) -- Added for ASNB
502: WHERE rowid = X_rowid;
503:
504: if (SQL%NOTFOUND) then

Line 501: contributor_flag = decode(X_contributor_flag,FND_API.G_MISS_CHAR,contributor_flag,X_contributor_flag) -- Added for ASNB

497: partner_cont_party_id =decode(X_Partner_Cont_Party_id,FND_API.G_MISS_NUM,partner_cont_party_id,X_Partner_Cont_Party_Id),
498: owner_flag = decode(X_owner_flag,FND_API.G_MISS_CHAR,owner_flag,X_owner_flag),
499: created_by_tap_flag = decode(X_created_by_tap_flag,FND_API.G_MISS_CHAR,created_by_tap_flag,X_created_by_tap_flag),
500: prm_keep_flag = decode(X_prm_keep_flag,FND_API.G_MISS_CHAR,prm_keep_flag,X_prm_keep_flag),
501: contributor_flag = decode(X_contributor_flag,FND_API.G_MISS_CHAR,contributor_flag,X_contributor_flag) -- Added for ASNB
502: WHERE rowid = X_rowid;
503:
504: if (SQL%NOTFOUND) then
505: RAISE NO_DATA_FOUND;