59:
60: IS
61: CURSOR C2 IS SELECT AS_SALES_LEAD_CONTACTS_S.nextval FROM sys.dual;
62: BEGIN
63: If (px_LEAD_CONTACT_ID IS NULL) OR (px_LEAD_CONTACT_ID = FND_API.G_MISS_NUM) then
64: OPEN C2;
65: FETCH C2 INTO px_LEAD_CONTACT_ID;
66: CLOSE C2;
67: End If;
104: ATTRIBUTE15
105: -- SECURITY_GROUP_ID
106: ) VALUES (
107: px_LEAD_CONTACT_ID,
108: decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),
109: decode( p_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_ID),
110: decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,
111: p_CONTACT_PARTY_ID),
112: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
105: -- SECURITY_GROUP_ID
106: ) VALUES (
107: px_LEAD_CONTACT_ID,
108: decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),
109: decode( p_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_ID),
110: decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,
111: p_CONTACT_PARTY_ID),
112: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
113: p_LAST_UPDATE_DATE),
106: ) VALUES (
107: px_LEAD_CONTACT_ID,
108: decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),
109: decode( p_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_ID),
110: decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,
111: p_CONTACT_PARTY_ID),
112: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
113: p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
108: decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),
109: decode( p_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_ID),
110: decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,
111: p_CONTACT_PARTY_ID),
112: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
113: p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
116: p_CREATION_DATE),
110: decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,
111: p_CONTACT_PARTY_ID),
112: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
113: p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
116: p_CREATION_DATE),
117: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
118: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,
111: p_CONTACT_PARTY_ID),
112: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
113: p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
116: p_CREATION_DATE),
117: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
118: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,
119: p_LAST_UPDATE_LOGIN),
113: p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
116: p_CREATION_DATE),
117: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
118: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,
119: p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
114: decode( p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
116: p_CREATION_DATE),
117: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
118: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,
119: p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
122: p_PROGRAM_APPLICATION_ID),
116: p_CREATION_DATE),
117: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
118: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,
119: p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
122: p_PROGRAM_APPLICATION_ID),
123: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
124: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
117: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
118: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,
119: p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
122: p_PROGRAM_APPLICATION_ID),
123: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
124: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
125: p_PROGRAM_UPDATE_DATE),
119: p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
122: p_PROGRAM_APPLICATION_ID),
123: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
124: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
125: p_PROGRAM_UPDATE_DATE),
126: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
127: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
122: p_PROGRAM_APPLICATION_ID),
123: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
124: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
125: p_PROGRAM_UPDATE_DATE),
126: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
127: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
128: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
122: p_PROGRAM_APPLICATION_ID),
123: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
124: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
125: p_PROGRAM_UPDATE_DATE),
126: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
127: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
128: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
129: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
130: decode( p_PHONE_ID, FND_API.G_MISS_NUM, NULL, p_PHONE_ID),
123: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
124: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
125: p_PROGRAM_UPDATE_DATE),
126: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
127: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
128: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
129: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
130: decode( p_PHONE_ID, FND_API.G_MISS_NUM, NULL, p_PHONE_ID),
131: decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR, NULL,
124: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
125: p_PROGRAM_UPDATE_DATE),
126: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
127: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
128: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
129: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
130: decode( p_PHONE_ID, FND_API.G_MISS_NUM, NULL, p_PHONE_ID),
131: decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR, NULL,
132: p_CONTACT_ROLE_CODE),
125: p_PROGRAM_UPDATE_DATE),
126: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
127: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
128: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
129: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
130: decode( p_PHONE_ID, FND_API.G_MISS_NUM, NULL, p_PHONE_ID),
131: decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR, NULL,
132: p_CONTACT_ROLE_CODE),
133: decode( p_PRIMARY_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL,
126: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
127: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
128: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
129: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
130: decode( p_PHONE_ID, FND_API.G_MISS_NUM, NULL, p_PHONE_ID),
131: decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR, NULL,
132: p_CONTACT_ROLE_CODE),
133: decode( p_PRIMARY_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL,
134: p_PRIMARY_CONTACT_FLAG),
127: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
128: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
129: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
130: decode( p_PHONE_ID, FND_API.G_MISS_NUM, NULL, p_PHONE_ID),
131: decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR, NULL,
132: p_CONTACT_ROLE_CODE),
133: decode( p_PRIMARY_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL,
134: p_PRIMARY_CONTACT_FLAG),
135: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
129: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
130: decode( p_PHONE_ID, FND_API.G_MISS_NUM, NULL, p_PHONE_ID),
131: decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR, NULL,
132: p_CONTACT_ROLE_CODE),
133: decode( p_PRIMARY_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL,
134: p_PRIMARY_CONTACT_FLAG),
135: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
136: p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
131: decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR, NULL,
132: p_CONTACT_ROLE_CODE),
133: decode( p_PRIMARY_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL,
134: p_PRIMARY_CONTACT_FLAG),
135: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
136: p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
133: decode( p_PRIMARY_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL,
134: p_PRIMARY_CONTACT_FLAG),
135: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
136: p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
134: p_PRIMARY_CONTACT_FLAG),
135: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
136: p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
135: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
136: p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
136: p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
152: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
152: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
153: -- p_SECURITY_GROUP_ID));
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
152: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
153: -- p_SECURITY_GROUP_ID));
154: End SALES_LEAD_CONTACTS_Insert_Row;
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
152: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
153: -- p_SECURITY_GROUP_ID));
154: End SALES_LEAD_CONTACTS_Insert_Row;
155:
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
152: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
153: -- p_SECURITY_GROUP_ID));
154: End SALES_LEAD_CONTACTS_Insert_Row;
155:
156: PROCEDURE SALES_LEAD_CONTACTS_Update_Row(
203: */
204: BEGIN
205: Update AS_SALES_LEAD_CONTACTS
206: SET
207: SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM,
208: SALES_LEAD_ID, p_SALES_LEAD_ID),
209: CONTACT_ID = decode( p_CONTACT_ID, FND_API.G_MISS_NUM, CONTACT_ID,
210: p_CONTACT_ID),
211: CONTACT_PARTY_ID = decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM,
205: Update AS_SALES_LEAD_CONTACTS
206: SET
207: SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM,
208: SALES_LEAD_ID, p_SALES_LEAD_ID),
209: CONTACT_ID = decode( p_CONTACT_ID, FND_API.G_MISS_NUM, CONTACT_ID,
210: p_CONTACT_ID),
211: CONTACT_PARTY_ID = decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM,
212: CONTACT_PARTY_ID, p_CONTACT_PARTY_ID),
213: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
207: SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM,
208: SALES_LEAD_ID, p_SALES_LEAD_ID),
209: CONTACT_ID = decode( p_CONTACT_ID, FND_API.G_MISS_NUM, CONTACT_ID,
210: p_CONTACT_ID),
211: CONTACT_PARTY_ID = decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM,
212: CONTACT_PARTY_ID, p_CONTACT_PARTY_ID),
213: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
214: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
215: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
209: CONTACT_ID = decode( p_CONTACT_ID, FND_API.G_MISS_NUM, CONTACT_ID,
210: p_CONTACT_ID),
211: CONTACT_PARTY_ID = decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM,
212: CONTACT_PARTY_ID, p_CONTACT_PARTY_ID),
213: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
214: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
215: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
216: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
217: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
211: CONTACT_PARTY_ID = decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM,
212: CONTACT_PARTY_ID, p_CONTACT_PARTY_ID),
213: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
214: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
215: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
216: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
217: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
218: CREATION_DATE, p_CREATION_DATE),
219: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
213: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
214: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
215: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
216: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
217: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
218: CREATION_DATE, p_CREATION_DATE),
219: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
220: p_CREATED_BY),
221: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
215: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
216: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
217: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
218: CREATION_DATE, p_CREATION_DATE),
219: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
220: p_CREATED_BY),
221: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
222: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
223: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
217: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
218: CREATION_DATE, p_CREATION_DATE),
219: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
220: p_CREATED_BY),
221: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
222: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
223: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
224: p_REQUEST_ID),
225: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
219: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
220: p_CREATED_BY),
221: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
222: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
223: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
224: p_REQUEST_ID),
225: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
226: FND_API.G_MISS_NUM,
227: PROGRAM_APPLICATION_ID,
222: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
223: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
224: p_REQUEST_ID),
225: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
226: FND_API.G_MISS_NUM,
227: PROGRAM_APPLICATION_ID,
228: p_PROGRAM_APPLICATION_ID),
229: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
230: p_PROGRAM_ID),
225: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
226: FND_API.G_MISS_NUM,
227: PROGRAM_APPLICATION_ID,
228: p_PROGRAM_APPLICATION_ID),
229: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
230: p_PROGRAM_ID),
231: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,
232: PROGRAM_UPDATE_DATE,p_PROGRAM_UPDATE_DATE),
233: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG,
227: PROGRAM_APPLICATION_ID,
228: p_PROGRAM_APPLICATION_ID),
229: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
230: p_PROGRAM_ID),
231: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,
232: PROGRAM_UPDATE_DATE,p_PROGRAM_UPDATE_DATE),
233: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG,
234: p_ENABLED_FLAG),
235: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
229: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
230: p_PROGRAM_ID),
231: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,
232: PROGRAM_UPDATE_DATE,p_PROGRAM_UPDATE_DATE),
233: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG,
234: p_ENABLED_FLAG),
235: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
236: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,
237: p_CUSTOMER_ID),
231: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,
232: PROGRAM_UPDATE_DATE,p_PROGRAM_UPDATE_DATE),
233: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG,
234: p_ENABLED_FLAG),
235: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
236: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,
237: p_CUSTOMER_ID),
238: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,
239: p_ADDRESS_ID),
232: PROGRAM_UPDATE_DATE,p_PROGRAM_UPDATE_DATE),
233: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG,
234: p_ENABLED_FLAG),
235: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
236: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,
237: p_CUSTOMER_ID),
238: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,
239: p_ADDRESS_ID),
240: PHONE_ID = decode( p_PHONE_ID, FND_API.G_MISS_NUM, PHONE_ID, p_PHONE_ID),
234: p_ENABLED_FLAG),
235: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
236: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,
237: p_CUSTOMER_ID),
238: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,
239: p_ADDRESS_ID),
240: PHONE_ID = decode( p_PHONE_ID, FND_API.G_MISS_NUM, PHONE_ID, p_PHONE_ID),
241: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,
242: CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),
236: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,
237: p_CUSTOMER_ID),
238: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,
239: p_ADDRESS_ID),
240: PHONE_ID = decode( p_PHONE_ID, FND_API.G_MISS_NUM, PHONE_ID, p_PHONE_ID),
241: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,
242: CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),
243: PRIMARY_CONTACT_FLAG = decode(p_PRIMARY_CONTACT_FLAG,FND_API.G_MISS_CHAR,
244: PRIMARY_CONTACT_FLAG,p_PRIMARY_CONTACT_FLAG),
237: p_CUSTOMER_ID),
238: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,
239: p_ADDRESS_ID),
240: PHONE_ID = decode( p_PHONE_ID, FND_API.G_MISS_NUM, PHONE_ID, p_PHONE_ID),
241: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,
242: CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),
243: PRIMARY_CONTACT_FLAG = decode(p_PRIMARY_CONTACT_FLAG,FND_API.G_MISS_CHAR,
244: PRIMARY_CONTACT_FLAG,p_PRIMARY_CONTACT_FLAG),
245: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
239: p_ADDRESS_ID),
240: PHONE_ID = decode( p_PHONE_ID, FND_API.G_MISS_NUM, PHONE_ID, p_PHONE_ID),
241: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,
242: CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),
243: PRIMARY_CONTACT_FLAG = decode(p_PRIMARY_CONTACT_FLAG,FND_API.G_MISS_CHAR,
244: PRIMARY_CONTACT_FLAG,p_PRIMARY_CONTACT_FLAG),
245: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
246: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
247: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
241: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,
242: CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),
243: PRIMARY_CONTACT_FLAG = decode(p_PRIMARY_CONTACT_FLAG,FND_API.G_MISS_CHAR,
244: PRIMARY_CONTACT_FLAG,p_PRIMARY_CONTACT_FLAG),
245: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
246: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
247: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
248: p_ATTRIBUTE1),
249: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
243: PRIMARY_CONTACT_FLAG = decode(p_PRIMARY_CONTACT_FLAG,FND_API.G_MISS_CHAR,
244: PRIMARY_CONTACT_FLAG,p_PRIMARY_CONTACT_FLAG),
245: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
246: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
247: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
248: p_ATTRIBUTE1),
249: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
250: p_ATTRIBUTE2),
251: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
245: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
246: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
247: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
248: p_ATTRIBUTE1),
249: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
250: p_ATTRIBUTE2),
251: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
252: p_ATTRIBUTE3),
253: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
247: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
248: p_ATTRIBUTE1),
249: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
250: p_ATTRIBUTE2),
251: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
252: p_ATTRIBUTE3),
253: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
254: p_ATTRIBUTE4),
255: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
249: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
250: p_ATTRIBUTE2),
251: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
252: p_ATTRIBUTE3),
253: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
254: p_ATTRIBUTE4),
255: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
256: p_ATTRIBUTE5),
257: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
251: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
252: p_ATTRIBUTE3),
253: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
254: p_ATTRIBUTE4),
255: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
256: p_ATTRIBUTE5),
257: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
258: p_ATTRIBUTE6),
259: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
253: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
254: p_ATTRIBUTE4),
255: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
256: p_ATTRIBUTE5),
257: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
258: p_ATTRIBUTE6),
259: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
260: p_ATTRIBUTE7),
261: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
255: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
256: p_ATTRIBUTE5),
257: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
258: p_ATTRIBUTE6),
259: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
260: p_ATTRIBUTE7),
261: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
262: p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
257: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
258: p_ATTRIBUTE6),
259: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
260: p_ATTRIBUTE7),
261: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
262: p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
264: p_ATTRIBUTE9),
265: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
259: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
260: p_ATTRIBUTE7),
261: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
262: p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
264: p_ATTRIBUTE9),
265: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
266: p_ATTRIBUTE10),
267: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
261: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
262: p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
264: p_ATTRIBUTE9),
265: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
266: p_ATTRIBUTE10),
267: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
268: p_ATTRIBUTE11),
269: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
264: p_ATTRIBUTE9),
265: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
266: p_ATTRIBUTE10),
267: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
268: p_ATTRIBUTE11),
269: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
270: p_ATTRIBUTE12),
271: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
265: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
266: p_ATTRIBUTE10),
267: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
268: p_ATTRIBUTE11),
269: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
270: p_ATTRIBUTE12),
271: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
272: p_ATTRIBUTE13),
273: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
267: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
268: p_ATTRIBUTE11),
269: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
270: p_ATTRIBUTE12),
271: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
272: p_ATTRIBUTE13),
273: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
274: p_ATTRIBUTE14),
275: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
269: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
270: p_ATTRIBUTE12),
271: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
272: p_ATTRIBUTE13),
273: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
274: p_ATTRIBUTE14),
275: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
276: p_ATTRIBUTE15),
277: object_version_number = decode(object_version_number, null, 1, object_version_number+1)
271: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
272: p_ATTRIBUTE13),
273: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
274: p_ATTRIBUTE14),
275: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
276: p_ATTRIBUTE15),
277: object_version_number = decode(object_version_number, null, 1, object_version_number+1)
278: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
279: -- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
274: p_ATTRIBUTE14),
275: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
276: p_ATTRIBUTE15),
277: object_version_number = decode(object_version_number, null, 1, object_version_number+1)
278: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
279: -- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
280: where LEAD_CONTACT_ID = p_LEAD_CONTACT_ID;
281: /*
282: open c_obj_verno;