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;
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),
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),
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 ),
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),
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),
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),
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 ),
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),
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),
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),
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,
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),
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,
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 ),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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
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: );
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:
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;
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;
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 ),
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),
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 ),
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),
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),
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),
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 ),
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 ),
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),
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),
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,
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),
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,
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 ),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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
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;
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:
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
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;