APPS.AS_SALES_LEAD_CONTACTS_PKG dependencies on FND_API

Line 63: If (px_LEAD_CONTACT_ID IS NULL) OR (px_LEAD_CONTACT_ID = FND_API.G_MISS_NUM) then

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;

Line 108: decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),

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

Line 109: decode( p_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_ID),

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

Line 110: decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,

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

Line 112: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),

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

Line 114: decode( p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),

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,

Line 115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(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),

Line 117: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

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,

Line 118: decode( p_LAST_UPDATE_LOGIN, 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),

Line 120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_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),

Line 121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, 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),

Line 123: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

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

Line 124: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),

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

Line 126: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),

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

Line 127: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),

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,

Line 128: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_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,
132: p_CONTACT_ROLE_CODE),

Line 129: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),

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,

Line 130: decode( p_PHONE_ID, FND_API.G_MISS_NUM, NULL, p_PHONE_ID),

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

Line 131: decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR, NULL,

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,

Line 133: decode( p_PRIMARY_CONTACT_FLAG, 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),

Line 135: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

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

Line 137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

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

Line 138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

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

Line 139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

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

Line 140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

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

Line 141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

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

Line 142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

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

Line 143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

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

Line 144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

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

Line 145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

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

Line 146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

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

Line 147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

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

Line 148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

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,

Line 149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

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

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

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;

Line 151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));

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:

Line 152: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,

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(

Line 207: SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM,

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,

Line 209: CONTACT_ID = decode( p_CONTACT_ID, FND_API.G_MISS_NUM, CONTACT_ID,

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,

Line 211: CONTACT_PARTY_ID = decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM,

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,

Line 213: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,

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,

Line 215: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,

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,

Line 217: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,

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,

Line 219: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,

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,

Line 221: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,

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,

Line 223: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_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,

Line 226: 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,
228: p_PROGRAM_APPLICATION_ID),
229: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
230: p_PROGRAM_ID),

Line 229: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, 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,

Line 231: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,

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

Line 233: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG,

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

Line 235: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),

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

Line 236: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_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),

Line 238: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_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),

Line 240: PHONE_ID = decode( p_PHONE_ID, FND_API.G_MISS_NUM, PHONE_ID, p_PHONE_ID),

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

Line 241: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,

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,

Line 243: PRIMARY_CONTACT_FLAG = decode(p_PRIMARY_CONTACT_FLAG,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,

Line 245: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,

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,

Line 247: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,

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,

Line 249: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,

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,

Line 251: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,

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,

Line 253: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,

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,

Line 255: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,

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,

Line 257: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,

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,

Line 259: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,

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,

Line 261: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,

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,

Line 263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,

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,

Line 265: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,

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,

Line 267: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,

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,

Line 269: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,

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,

Line 271: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,

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,

Line 273: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,

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)

Line 275: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,

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)

Line 278: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,

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;