APPS.AS_SALES_LEAD_LINES_PKG dependencies on FND_API

Line 73: OR (px_SALES_LEAD_LINE_ID = FND_API.G_MISS_NUM)

69: IS
70: CURSOR C2 IS SELECT AS_SALES_LEAD_LINES_S.nextval FROM sys.dual;
71: BEGIN
72: If (px_sales_lead_line_id IS NULL)
73: OR (px_SALES_LEAD_LINE_ID = FND_API.G_MISS_NUM)
74: Then
75: OPEN C2;
76: FETCH C2 INTO px_sales_lead_line_id;
77: CLOSE C2;

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

119: OFFER_ID)
120: -- SECURITY_GROUP_ID)
121: VALUES (
122: px_SALES_LEAD_LINE_ID,
123: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,TO_DATE(NULL),p_LAST_UPDATE_DATE),
124: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
125: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
126: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
127: decode( p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),

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

120: -- SECURITY_GROUP_ID)
121: VALUES (
122: px_SALES_LEAD_LINE_ID,
123: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,TO_DATE(NULL),p_LAST_UPDATE_DATE),
124: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
125: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
126: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
127: decode( p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
128: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

Line 125: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

121: VALUES (
122: px_SALES_LEAD_LINE_ID,
123: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,TO_DATE(NULL),p_LAST_UPDATE_DATE),
124: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
125: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
126: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
127: decode( p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
128: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
129: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,

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

122: px_SALES_LEAD_LINE_ID,
123: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,TO_DATE(NULL),p_LAST_UPDATE_DATE),
124: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
125: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
126: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
127: decode( p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
128: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
129: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
130: p_PROGRAM_APPLICATION_ID),

Line 127: decode( p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),

123: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,TO_DATE(NULL),p_LAST_UPDATE_DATE),
124: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
125: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
126: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
127: decode( p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
128: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
129: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
130: p_PROGRAM_APPLICATION_ID),
131: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

Line 128: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

124: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
125: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
126: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
127: decode( p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
128: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
129: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
130: p_PROGRAM_APPLICATION_ID),
131: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
132: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),

Line 129: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,

125: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
126: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
127: decode( p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
128: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
129: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
130: p_PROGRAM_APPLICATION_ID),
131: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
132: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
133: p_PROGRAM_UPDATE_DATE),

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

127: decode( p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
128: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
129: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
130: p_PROGRAM_APPLICATION_ID),
131: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
132: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
133: p_PROGRAM_UPDATE_DATE),
134: decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),
135:

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

128: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
129: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
130: p_PROGRAM_APPLICATION_ID),
131: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
132: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
133: p_PROGRAM_UPDATE_DATE),
134: decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),
135:
136: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),

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

130: p_PROGRAM_APPLICATION_ID),
131: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
132: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
133: p_PROGRAM_UPDATE_DATE),
134: decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),
135:
136: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
137:
138: -- 11.5.10 rivendell product category changes

Line 136: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),

132: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
133: p_PROGRAM_UPDATE_DATE),
134: decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),
135:
136: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
137:
138: -- 11.5.10 rivendell product category changes
139:
140: --decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM,NULL, p_INTEREST_TYPE_ID),

Line 140: --decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM,NULL, p_INTEREST_TYPE_ID),

136: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
137:
138: -- 11.5.10 rivendell product category changes
139:
140: --decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM,NULL, p_INTEREST_TYPE_ID),
141: --decode( p_PRIMARY_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL,
142: -- p_PRIMARY_INTEREST_CODE_ID),
143: --decode( p_SECONDARY_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL,
144: -- p_SECONDARY_INTEREST_CODE_ID),

Line 141: --decode( p_PRIMARY_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL,

137:
138: -- 11.5.10 rivendell product category changes
139:
140: --decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM,NULL, p_INTEREST_TYPE_ID),
141: --decode( p_PRIMARY_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL,
142: -- p_PRIMARY_INTEREST_CODE_ID),
143: --decode( p_SECONDARY_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL,
144: -- p_SECONDARY_INTEREST_CODE_ID),
145: NULL,

Line 143: --decode( p_SECONDARY_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL,

139:
140: --decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM,NULL, p_INTEREST_TYPE_ID),
141: --decode( p_PRIMARY_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL,
142: -- p_PRIMARY_INTEREST_CODE_ID),
143: --decode( p_SECONDARY_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL,
144: -- p_SECONDARY_INTEREST_CODE_ID),
145: NULL,
146: NULL,
147: NULL,

Line 149: decode(p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),

145: NULL,
146: NULL,
147: NULL,
148:
149: decode(p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
150: decode(p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID),
151:
152:
153: decode( p_INVENTORY_ITEM_ID,FND_API.G_MISS_NUM,NULL,p_INVENTORY_ITEM_ID),

Line 150: decode(p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID),

146: NULL,
147: NULL,
148:
149: decode(p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
150: decode(p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID),
151:
152:
153: decode( p_INVENTORY_ITEM_ID,FND_API.G_MISS_NUM,NULL,p_INVENTORY_ITEM_ID),
154: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),

Line 153: decode( p_INVENTORY_ITEM_ID,FND_API.G_MISS_NUM,NULL,p_INVENTORY_ITEM_ID),

149: decode(p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
150: decode(p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID),
151:
152:
153: decode( p_INVENTORY_ITEM_ID,FND_API.G_MISS_NUM,NULL,p_INVENTORY_ITEM_ID),
154: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
155: decode( p_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE),
156: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
157: decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),

Line 154: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),

150: decode(p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID),
151:
152:
153: decode( p_INVENTORY_ITEM_ID,FND_API.G_MISS_NUM,NULL,p_INVENTORY_ITEM_ID),
154: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
155: decode( p_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE),
156: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
157: decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
158: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,

Line 155: decode( p_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE),

151:
152:
153: decode( p_INVENTORY_ITEM_ID,FND_API.G_MISS_NUM,NULL,p_INVENTORY_ITEM_ID),
154: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
155: decode( p_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE),
156: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
157: decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
158: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
159: p_SOURCE_PROMOTION_ID),

Line 156: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),

152:
153: decode( p_INVENTORY_ITEM_ID,FND_API.G_MISS_NUM,NULL,p_INVENTORY_ITEM_ID),
154: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
155: decode( p_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE),
156: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
157: decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
158: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
159: p_SOURCE_PROMOTION_ID),
160: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

Line 157: decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),

153: decode( p_INVENTORY_ITEM_ID,FND_API.G_MISS_NUM,NULL,p_INVENTORY_ITEM_ID),
154: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
155: decode( p_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE),
156: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
157: decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
158: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
159: p_SOURCE_PROMOTION_ID),
160: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
161: p_ATTRIBUTE_CATEGORY),

Line 158: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,

154: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
155: decode( p_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE),
156: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
157: decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
158: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
159: p_SOURCE_PROMOTION_ID),
160: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
161: p_ATTRIBUTE_CATEGORY),
162: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

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

156: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
157: decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
158: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
159: p_SOURCE_PROMOTION_ID),
160: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
161: p_ATTRIBUTE_CATEGORY),
162: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
163: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
164: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

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

158: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
159: p_SOURCE_PROMOTION_ID),
160: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
161: p_ATTRIBUTE_CATEGORY),
162: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
163: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
164: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
165: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
166: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

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

159: p_SOURCE_PROMOTION_ID),
160: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
161: p_ATTRIBUTE_CATEGORY),
162: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
163: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
164: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
165: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
166: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
167: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

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

160: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
161: p_ATTRIBUTE_CATEGORY),
162: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
163: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
164: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
165: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
166: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
167: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
168: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

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

161: p_ATTRIBUTE_CATEGORY),
162: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
163: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
164: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
165: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
166: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
167: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
168: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
169: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

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

162: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
163: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
164: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
165: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
166: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
167: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
168: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
169: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
170: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

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

163: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
164: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
165: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
166: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
167: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
168: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
169: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
170: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
171: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

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

164: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
165: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
166: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
167: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
168: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
169: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
170: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
171: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
172: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

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

165: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
166: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
167: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
168: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
169: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
170: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
171: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
172: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
173: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

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

166: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
167: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
168: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
169: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
170: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
171: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
172: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
173: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
174: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

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

167: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
168: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
169: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
170: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
171: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
172: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
173: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
174: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
175: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

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

168: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
169: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
170: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
171: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
172: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
173: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
174: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
175: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
176: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

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

169: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
170: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
171: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
172: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
173: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
174: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
175: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
176: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
177: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID));

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

170: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
171: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
172: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
173: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
174: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
175: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
176: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
177: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID));
178: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,

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

171: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
172: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
173: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
174: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
175: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
176: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
177: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID));
178: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
179: -- p_SECURITY_GROUP_ID));

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

172: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
173: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
174: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
175: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
176: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
177: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID));
178: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
179: -- p_SECURITY_GROUP_ID));
180: End Sales_Lead_Line_Insert_Row;

Line 177: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID));

173: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
174: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
175: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
176: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
177: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID));
178: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
179: -- p_SECURITY_GROUP_ID));
180: End Sales_Lead_Line_Insert_Row;
181:

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

174: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
175: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
176: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
177: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID));
178: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
179: -- p_SECURITY_GROUP_ID));
180: End Sales_Lead_Line_Insert_Row;
181:
182: PROCEDURE Sales_Lead_Line_Update_Row(

Line 240: SALES_LEAD_LINE_ID = decode( p_SALES_LEAD_LINE_ID, FND_API.G_MISS_NUM,

236: */
237: BEGIN
238: Update AS_SALES_LEAD_LINES
239: SET
240: SALES_LEAD_LINE_ID = decode( p_SALES_LEAD_LINE_ID, FND_API.G_MISS_NUM,
241: SALES_LEAD_LINE_ID, p_SALES_LEAD_LINE_ID),
242: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
243: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
244: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,

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

238: Update AS_SALES_LEAD_LINES
239: SET
240: SALES_LEAD_LINE_ID = decode( p_SALES_LEAD_LINE_ID, FND_API.G_MISS_NUM,
241: SALES_LEAD_LINE_ID, p_SALES_LEAD_LINE_ID),
242: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
243: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
244: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
245: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,

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

240: SALES_LEAD_LINE_ID = decode( p_SALES_LEAD_LINE_ID, FND_API.G_MISS_NUM,
241: SALES_LEAD_LINE_ID, p_SALES_LEAD_LINE_ID),
242: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
243: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
244: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
245: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
247: CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,

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

242: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
243: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
244: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
245: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
247: CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
249: p_CREATED_BY),
250: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,

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

244: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
245: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
247: CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
249: p_CREATED_BY),
250: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
251: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,

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

246: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
247: CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
249: p_CREATED_BY),
250: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
251: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
253: p_REQUEST_ID),
254: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,

Line 252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,

248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
249: p_CREATED_BY),
250: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
251: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
253: p_REQUEST_ID),
254: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
255: FND_API.G_MISS_NUM,
256: PROGRAM_APPLICATION_ID,

Line 255: FND_API.G_MISS_NUM,

251: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
253: p_REQUEST_ID),
254: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
255: FND_API.G_MISS_NUM,
256: PROGRAM_APPLICATION_ID,
257: p_PROGRAM_APPLICATION_ID),
258: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
259: p_PROGRAM_ID),

Line 258: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,

254: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
255: FND_API.G_MISS_NUM,
256: PROGRAM_APPLICATION_ID,
257: p_PROGRAM_APPLICATION_ID),
258: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
259: p_PROGRAM_ID),
260: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,
261: PROGRAM_UPDATE_DATE,p_PROGRAM_UPDATE_DATE),
262: SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM,

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

256: PROGRAM_APPLICATION_ID,
257: p_PROGRAM_APPLICATION_ID),
258: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
259: p_PROGRAM_ID),
260: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,
261: PROGRAM_UPDATE_DATE,p_PROGRAM_UPDATE_DATE),
262: SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM,
263: SALES_LEAD_ID, p_SALES_LEAD_ID),
264: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,

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

258: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
259: p_PROGRAM_ID),
260: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,
261: PROGRAM_UPDATE_DATE,p_PROGRAM_UPDATE_DATE),
262: SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM,
263: SALES_LEAD_ID, p_SALES_LEAD_ID),
264: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,
265: p_STATUS_CODE),
266:

Line 264: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,

260: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,
261: PROGRAM_UPDATE_DATE,p_PROGRAM_UPDATE_DATE),
262: SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM,
263: SALES_LEAD_ID, p_SALES_LEAD_ID),
264: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,
265: p_STATUS_CODE),
266:
267: -- 11.5.10 rivendell product category
268:

Line 269: --INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM,

265: p_STATUS_CODE),
266:
267: -- 11.5.10 rivendell product category
268:
269: --INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM,
270: -- INTEREST_TYPE_ID, p_INTEREST_TYPE_ID),
271: --PRIMARY_INTEREST_CODE_ID = decode( p_PRIMARY_INTEREST_CODE_ID,
272: -- FND_API.G_MISS_NUM,
273: -- PRIMARY_INTEREST_CODE_ID,

Line 272: -- FND_API.G_MISS_NUM,

268:
269: --INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM,
270: -- INTEREST_TYPE_ID, p_INTEREST_TYPE_ID),
271: --PRIMARY_INTEREST_CODE_ID = decode( p_PRIMARY_INTEREST_CODE_ID,
272: -- FND_API.G_MISS_NUM,
273: -- PRIMARY_INTEREST_CODE_ID,
274: -- p_PRIMARY_INTEREST_CODE_ID),
275: --SECONDARY_INTEREST_CODE_ID = decode( p_SECONDARY_INTEREST_CODE_ID,
276: -- FND_API.G_MISS_NUM,

Line 276: -- FND_API.G_MISS_NUM,

272: -- FND_API.G_MISS_NUM,
273: -- PRIMARY_INTEREST_CODE_ID,
274: -- p_PRIMARY_INTEREST_CODE_ID),
275: --SECONDARY_INTEREST_CODE_ID = decode( p_SECONDARY_INTEREST_CODE_ID,
276: -- FND_API.G_MISS_NUM,
277: -- SECONDARY_INTEREST_CODE_ID,
278: -- p_SECONDARY_INTEREST_CODE_ID),
279:
280: CATEGORY_ID = decode( p_CATEGORY_ID,

Line 281: FND_API.G_MISS_NUM,

277: -- SECONDARY_INTEREST_CODE_ID,
278: -- p_SECONDARY_INTEREST_CODE_ID),
279:
280: CATEGORY_ID = decode( p_CATEGORY_ID,
281: FND_API.G_MISS_NUM,
282: CATEGORY_ID,
283: p_CATEGORY_ID),
284:
285: CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID,

Line 286: FND_API.G_MISS_NUM,

282: CATEGORY_ID,
283: p_CATEGORY_ID),
284:
285: CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID,
286: FND_API.G_MISS_NUM,
287: CATEGORY_SET_ID,
288: p_CATEGORY_SET_ID),
289:
290:

Line 291: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM,

287: CATEGORY_SET_ID,
288: p_CATEGORY_SET_ID),
289:
290:
291: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM,
292: INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
293: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM,
294: ORGANIZATION_ID, p_ORGANIZATION_ID),
295: UOM_CODE = decode( p_UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE,p_UOM_CODE),

Line 293: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM,

289:
290:
291: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM,
292: INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
293: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM,
294: ORGANIZATION_ID, p_ORGANIZATION_ID),
295: UOM_CODE = decode( p_UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE,p_UOM_CODE),
296: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
297: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,

Line 295: UOM_CODE = decode( p_UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE,p_UOM_CODE),

291: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM,
292: INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
293: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM,
294: ORGANIZATION_ID, p_ORGANIZATION_ID),
295: UOM_CODE = decode( p_UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE,p_UOM_CODE),
296: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
297: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,
298: BUDGET_AMOUNT, p_BUDGET_AMOUNT),
299: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM,

Line 296: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),

292: INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
293: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM,
294: ORGANIZATION_ID, p_ORGANIZATION_ID),
295: UOM_CODE = decode( p_UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE,p_UOM_CODE),
296: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
297: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,
298: BUDGET_AMOUNT, p_BUDGET_AMOUNT),
299: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM,
300: SOURCE_PROMOTION_ID,

Line 297: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,

293: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM,
294: ORGANIZATION_ID, p_ORGANIZATION_ID),
295: UOM_CODE = decode( p_UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE,p_UOM_CODE),
296: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
297: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,
298: BUDGET_AMOUNT, p_BUDGET_AMOUNT),
299: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM,
300: SOURCE_PROMOTION_ID,
301: p_SOURCE_PROMOTION_ID),

Line 299: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM,

295: UOM_CODE = decode( p_UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE,p_UOM_CODE),
296: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
297: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,
298: BUDGET_AMOUNT, p_BUDGET_AMOUNT),
299: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM,
300: SOURCE_PROMOTION_ID,
301: p_SOURCE_PROMOTION_ID),
302: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
303: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

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

298: BUDGET_AMOUNT, p_BUDGET_AMOUNT),
299: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM,
300: SOURCE_PROMOTION_ID,
301: p_SOURCE_PROMOTION_ID),
302: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
303: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
304: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
305: p_ATTRIBUTE1),
306: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,

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

300: SOURCE_PROMOTION_ID,
301: p_SOURCE_PROMOTION_ID),
302: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
303: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
304: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
305: p_ATTRIBUTE1),
306: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
307: p_ATTRIBUTE2),
308: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,

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

302: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
303: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
304: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
305: p_ATTRIBUTE1),
306: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
307: p_ATTRIBUTE2),
308: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
309: p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,

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

304: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
305: p_ATTRIBUTE1),
306: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
307: p_ATTRIBUTE2),
308: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
309: p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
311: p_ATTRIBUTE4),
312: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,

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

306: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
307: p_ATTRIBUTE2),
308: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
309: p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
311: p_ATTRIBUTE4),
312: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
313: p_ATTRIBUTE5),
314: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,

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

308: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
309: p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
311: p_ATTRIBUTE4),
312: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
313: p_ATTRIBUTE5),
314: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
315: p_ATTRIBUTE6),
316: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,

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

310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
311: p_ATTRIBUTE4),
312: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
313: p_ATTRIBUTE5),
314: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
315: p_ATTRIBUTE6),
316: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
317: p_ATTRIBUTE7),
318: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,

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

312: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
313: p_ATTRIBUTE5),
314: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
315: p_ATTRIBUTE6),
316: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
317: p_ATTRIBUTE7),
318: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
319: p_ATTRIBUTE8),
320: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,

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

314: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
315: p_ATTRIBUTE6),
316: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
317: p_ATTRIBUTE7),
318: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
319: p_ATTRIBUTE8),
320: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
321: p_ATTRIBUTE9),
322: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,

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

316: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
317: p_ATTRIBUTE7),
318: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
319: p_ATTRIBUTE8),
320: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
321: p_ATTRIBUTE9),
322: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
323: p_ATTRIBUTE10),
324: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,

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

318: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
319: p_ATTRIBUTE8),
320: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
321: p_ATTRIBUTE9),
322: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
323: p_ATTRIBUTE10),
324: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
325: p_ATTRIBUTE11),
326: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,

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

320: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
321: p_ATTRIBUTE9),
322: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
323: p_ATTRIBUTE10),
324: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
325: p_ATTRIBUTE11),
326: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
327: p_ATTRIBUTE12),
328: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,

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

322: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
323: p_ATTRIBUTE10),
324: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
325: p_ATTRIBUTE11),
326: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
327: p_ATTRIBUTE12),
328: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
329: p_ATTRIBUTE13),
330: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,

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

324: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
325: p_ATTRIBUTE11),
326: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
327: p_ATTRIBUTE12),
328: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
329: p_ATTRIBUTE13),
330: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
331: p_ATTRIBUTE14),
332: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,

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

326: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
327: p_ATTRIBUTE12),
328: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
329: p_ATTRIBUTE13),
330: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
331: p_ATTRIBUTE14),
332: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
333: p_ATTRIBUTE15),
334: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),

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

328: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
329: p_ATTRIBUTE13),
330: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
331: p_ATTRIBUTE14),
332: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
333: p_ATTRIBUTE15),
334: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
335: object_version_number = decode(object_version_number, null, 1, object_version_number+1)
336: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,

Line 334: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),

330: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
331: p_ATTRIBUTE14),
332: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
333: p_ATTRIBUTE15),
334: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
335: object_version_number = decode(object_version_number, null, 1, object_version_number+1)
336: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
337: -- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
338: WHERE sales_lead_line_id = p_sales_lead_line_id;

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

332: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
333: p_ATTRIBUTE15),
334: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
335: object_version_number = decode(object_version_number, null, 1, object_version_number+1)
336: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
337: -- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
338: WHERE sales_lead_line_id = p_sales_lead_line_id;
339: /*
340: open c_obj_verno;