68: l_OPP_WORST_FORECAST_AMOUNT NUMBER := p_OPP_WORST_FORECAST_AMOUNT;
69: l_OPP_FORECAST_AMOUNT NUMBER := p_OPP_FORECAST_AMOUNT;
70: l_OPP_BEST_FORECAST_AMOUNT NUMBER := p_OPP_BEST_FORECAST_AMOUNT;
71: BEGIN
72: If (px_SALES_CREDIT_ID IS NULL) OR (px_SALES_CREDIT_ID = FND_API.G_MISS_NUM) then
73: OPEN C2;
74: FETCH C2 INTO px_SALES_CREDIT_ID;
75: CLOSE C2;
76: End If;
74: FETCH C2 INTO px_SALES_CREDIT_ID;
75: CLOSE C2;
76: End If;
77:
78: IF l_OPP_WORST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
79: l_OPP_WORST_FORECAST_AMOUNT := 0;
80: END IF;
81:
82: IF l_OPP_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
78: IF l_OPP_WORST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
79: l_OPP_WORST_FORECAST_AMOUNT := 0;
80: END IF;
81:
82: IF l_OPP_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
83: l_OPP_FORECAST_AMOUNT := 0;
84: END IF;
85:
86: IF l_OPP_BEST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
82: IF l_OPP_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
83: l_OPP_FORECAST_AMOUNT := 0;
84: END IF;
85:
86: IF l_OPP_BEST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
87: l_OPP_BEST_FORECAST_AMOUNT := 0;
88: END IF;
89:
90: INSERT INTO AS_SALES_CREDITS(
138: OPP_BEST_FORECAST_AMOUNT,
139: DEFAULTED_FROM_OWNER_FLAG -- Added for ASNB
140: ) VALUES (
141: px_SALES_CREDIT_ID,
142: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
143: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
144: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
145: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
146: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
139: DEFAULTED_FROM_OWNER_FLAG -- Added for ASNB
140: ) VALUES (
141: px_SALES_CREDIT_ID,
142: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
143: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
144: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
145: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
146: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
147: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
140: ) VALUES (
141: px_SALES_CREDIT_ID,
142: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
143: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
144: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
145: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
146: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
147: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
148: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
141: px_SALES_CREDIT_ID,
142: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
143: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
144: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
145: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
146: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
147: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
148: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
149: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
142: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
143: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
144: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
145: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
146: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
147: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
148: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
149: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
150: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
143: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
144: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
145: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
146: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
147: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
148: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
149: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
150: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
151: decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_ID),
144: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
145: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
146: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
147: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
148: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
149: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
150: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
151: decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_ID),
152: decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_LINE_ID),
145: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
146: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
147: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
148: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
149: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
150: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
151: decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_ID),
152: decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_LINE_ID),
153: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
146: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
147: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
148: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
149: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
150: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
151: decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_ID),
152: decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_LINE_ID),
153: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
154: decode( p_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_PERSON_ID),
147: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
148: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
149: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
150: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
151: decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_ID),
152: decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_LINE_ID),
153: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
154: decode( p_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_PERSON_ID),
155: decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALESGROUP_ID),
148: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
149: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
150: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
151: decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_ID),
152: decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_LINE_ID),
153: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
154: decode( p_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_PERSON_ID),
155: decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALESGROUP_ID),
156: decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_CUSTOMER_ID),
149: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
150: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
151: decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_ID),
152: decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_LINE_ID),
153: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
154: decode( p_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_PERSON_ID),
155: decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALESGROUP_ID),
156: decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_CUSTOMER_ID),
157: decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_ADDRESS_ID),
150: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
151: decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_ID),
152: decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_LINE_ID),
153: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
154: decode( p_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_PERSON_ID),
155: decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALESGROUP_ID),
156: decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_CUSTOMER_ID),
157: decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_ADDRESS_ID),
158: decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_REVENUE_AMOUNT),
151: decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_ID),
152: decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_LINE_ID),
153: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
154: decode( p_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_PERSON_ID),
155: decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALESGROUP_ID),
156: decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_CUSTOMER_ID),
157: decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_ADDRESS_ID),
158: decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_REVENUE_AMOUNT),
159: decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, NULL, p_REVENUE_PERCENT),
152: decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_LINE_ID),
153: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
154: decode( p_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_PERSON_ID),
155: decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALESGROUP_ID),
156: decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_CUSTOMER_ID),
157: decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_ADDRESS_ID),
158: decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_REVENUE_AMOUNT),
159: decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, NULL, p_REVENUE_PERCENT),
160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),
153: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
154: decode( p_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_PERSON_ID),
155: decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALESGROUP_ID),
156: decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_CUSTOMER_ID),
157: decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_ADDRESS_ID),
158: decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_REVENUE_AMOUNT),
159: decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, NULL, p_REVENUE_PERCENT),
160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),
161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),
154: decode( p_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_PERSON_ID),
155: decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALESGROUP_ID),
156: decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_CUSTOMER_ID),
157: decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_ADDRESS_ID),
158: decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_REVENUE_AMOUNT),
159: decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, NULL, p_REVENUE_PERCENT),
160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),
161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),
162: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
155: decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALESGROUP_ID),
156: decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_CUSTOMER_ID),
157: decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_ADDRESS_ID),
158: decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_REVENUE_AMOUNT),
159: decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, NULL, p_REVENUE_PERCENT),
160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),
161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),
162: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
163: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
156: decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_CUSTOMER_ID),
157: decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_ADDRESS_ID),
158: decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_REVENUE_AMOUNT),
159: decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, NULL, p_REVENUE_PERCENT),
160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),
161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),
162: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
163: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
164: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
157: decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_ADDRESS_ID),
158: decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_REVENUE_AMOUNT),
159: decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, NULL, p_REVENUE_PERCENT),
160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),
161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),
162: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
163: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
164: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
165: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
158: decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_REVENUE_AMOUNT),
159: decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, NULL, p_REVENUE_PERCENT),
160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),
161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),
162: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
163: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
164: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
165: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
166: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
159: decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, NULL, p_REVENUE_PERCENT),
160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),
161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),
162: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
163: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
164: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
165: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
166: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
167: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),
161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),
162: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
163: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
164: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
165: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
166: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
167: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
168: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),
162: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
163: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
164: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
165: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
166: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
167: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
168: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
169: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
162: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
163: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
164: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
165: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
166: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
167: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
168: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
169: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
170: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
163: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
164: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
165: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
166: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
167: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
168: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
169: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
170: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
171: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
164: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
165: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
166: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
167: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
168: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
169: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
170: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
171: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
172: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
165: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
166: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
167: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
168: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
169: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
170: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
171: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
172: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
173: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
166: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
167: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
168: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
169: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
170: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
171: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
172: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
173: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
174: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
167: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
168: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
169: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
170: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
171: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
172: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
173: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
174: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
175: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
168: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
169: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
170: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
171: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
172: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
173: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
174: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
175: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
176: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
169: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
170: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
171: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
172: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
173: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
174: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
175: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
176: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
177: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
170: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
171: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
172: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
173: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
174: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
175: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
176: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
177: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
178: decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANAGER_REVIEW_FLAG),
171: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
172: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
173: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
174: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
175: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
176: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
177: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
178: decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANAGER_REVIEW_FLAG),
179: decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_MANAGER_REVIEW_DATE),
172: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
173: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
174: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
175: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
176: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
177: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
178: decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANAGER_REVIEW_FLAG),
179: decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_MANAGER_REVIEW_DATE),
180: decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SALES_CREDIT_ID),
173: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
174: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
175: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
176: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
177: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
178: decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANAGER_REVIEW_FLAG),
179: decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_MANAGER_REVIEW_DATE),
180: decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SALES_CREDIT_ID),
181: -- decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, NULL, p_CREDIT_TYPE),
174: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
175: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
176: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
177: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
178: decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANAGER_REVIEW_FLAG),
179: decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_MANAGER_REVIEW_DATE),
180: decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SALES_CREDIT_ID),
181: -- decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, NULL, p_CREDIT_TYPE),
182: decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_CREDIT_PERCENT),
175: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
176: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
177: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
178: decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANAGER_REVIEW_FLAG),
179: decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_MANAGER_REVIEW_DATE),
180: decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SALES_CREDIT_ID),
181: -- decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, NULL, p_CREDIT_TYPE),
182: decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_CREDIT_PERCENT),
183: decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_CREDIT_AMOUNT),
176: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
177: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
178: decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANAGER_REVIEW_FLAG),
179: decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_MANAGER_REVIEW_DATE),
180: decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SALES_CREDIT_ID),
181: -- decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, NULL, p_CREDIT_TYPE),
182: decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_CREDIT_PERCENT),
183: decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_CREDIT_AMOUNT),
184: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID),
177: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
178: decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANAGER_REVIEW_FLAG),
179: decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_MANAGER_REVIEW_DATE),
180: decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SALES_CREDIT_ID),
181: -- decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, NULL, p_CREDIT_TYPE),
182: decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_CREDIT_PERCENT),
183: decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_CREDIT_AMOUNT),
184: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID),
185: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
178: decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANAGER_REVIEW_FLAG),
179: decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_MANAGER_REVIEW_DATE),
180: decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SALES_CREDIT_ID),
181: -- decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, NULL, p_CREDIT_TYPE),
182: decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_CREDIT_PERCENT),
183: decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_CREDIT_AMOUNT),
184: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID),
185: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
186: nvl(l_OPP_WORST_FORECAST_AMOUNT, 0),
179: decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_MANAGER_REVIEW_DATE),
180: decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SALES_CREDIT_ID),
181: -- decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, NULL, p_CREDIT_TYPE),
182: decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_CREDIT_PERCENT),
183: decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_CREDIT_AMOUNT),
184: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID),
185: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
186: nvl(l_OPP_WORST_FORECAST_AMOUNT, 0),
187: nvl(l_OPP_FORECAST_AMOUNT, 0),
180: decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SALES_CREDIT_ID),
181: -- decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, NULL, p_CREDIT_TYPE),
182: decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_CREDIT_PERCENT),
183: decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_CREDIT_AMOUNT),
184: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID),
185: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
186: nvl(l_OPP_WORST_FORECAST_AMOUNT, 0),
187: nvl(l_OPP_FORECAST_AMOUNT, 0),
188: nvl(l_OPP_BEST_FORECAST_AMOUNT, 0),
181: -- decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, NULL, p_CREDIT_TYPE),
182: decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_CREDIT_PERCENT),
183: decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_CREDIT_AMOUNT),
184: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID),
185: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
186: nvl(l_OPP_WORST_FORECAST_AMOUNT, 0),
187: nvl(l_OPP_FORECAST_AMOUNT, 0),
188: nvl(l_OPP_BEST_FORECAST_AMOUNT, 0),
189: decode( P_DEFAULTED_FROM_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, P_DEFAULTED_FROM_OWNER_FLAG) -- Added for ASNB
185: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
186: nvl(l_OPP_WORST_FORECAST_AMOUNT, 0),
187: nvl(l_OPP_FORECAST_AMOUNT, 0),
188: nvl(l_OPP_BEST_FORECAST_AMOUNT, 0),
189: decode( P_DEFAULTED_FROM_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, P_DEFAULTED_FROM_OWNER_FLAG) -- Added for ASNB
190: );
191: End Insert_Row;
192:
193: PROCEDURE Update_Row(
245: l_OPP_WORST_FORECAST_AMOUNT NUMBER := p_OPP_WORST_FORECAST_AMOUNT;
246: l_OPP_FORECAST_AMOUNT NUMBER := p_OPP_FORECAST_AMOUNT;
247: l_OPP_BEST_FORECAST_AMOUNT NUMBER := p_OPP_BEST_FORECAST_AMOUNT;
248: BEGIN
249: IF l_OPP_WORST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
250: l_OPP_WORST_FORECAST_AMOUNT := NULL;
251: END IF;
252:
253: IF l_OPP_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
249: IF l_OPP_WORST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
250: l_OPP_WORST_FORECAST_AMOUNT := NULL;
251: END IF;
252:
253: IF l_OPP_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
254: l_OPP_FORECAST_AMOUNT := NULL;
255: END IF;
256:
257: IF l_OPP_BEST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
253: IF l_OPP_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
254: l_OPP_FORECAST_AMOUNT := NULL;
255: END IF;
256:
257: IF l_OPP_BEST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
258: l_OPP_BEST_FORECAST_AMOUNT := NULL;
259: END IF;
260:
261: Update AS_SALES_CREDITS
259: END IF;
260:
261: Update AS_SALES_CREDITS
262: SET object_version_number = nvl(object_version_number,0) + 1,
263: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
264: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
265: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
266: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
267: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
260:
261: Update AS_SALES_CREDITS
262: SET object_version_number = nvl(object_version_number,0) + 1,
263: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
264: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
265: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
266: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
267: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
268: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
261: Update AS_SALES_CREDITS
262: SET object_version_number = nvl(object_version_number,0) + 1,
263: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
264: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
265: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
266: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
267: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
268: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
269: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
262: SET object_version_number = nvl(object_version_number,0) + 1,
263: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
264: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
265: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
266: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
267: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
268: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
269: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
270: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
263: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
264: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
265: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
266: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
267: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
268: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
269: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
270: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
271: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
264: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
265: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
266: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
267: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
268: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
269: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
270: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
271: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
272: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
265: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
266: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
267: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
268: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
269: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
270: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
271: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
272: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
273: LEAD_LINE_ID = decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, LEAD_LINE_ID, p_LEAD_LINE_ID),
266: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
267: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
268: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
269: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
270: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
271: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
272: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
273: LEAD_LINE_ID = decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, LEAD_LINE_ID, p_LEAD_LINE_ID),
274: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
267: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
268: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
269: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
270: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
271: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
272: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
273: LEAD_LINE_ID = decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, LEAD_LINE_ID, p_LEAD_LINE_ID),
274: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
275: PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM, PERSON_ID, p_PERSON_ID),
268: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
269: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
270: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
271: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
272: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
273: LEAD_LINE_ID = decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, LEAD_LINE_ID, p_LEAD_LINE_ID),
274: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
275: PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM, PERSON_ID, p_PERSON_ID),
276: SALESGROUP_ID = decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, SALESGROUP_ID, p_SALESGROUP_ID),
269: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
270: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
271: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
272: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
273: LEAD_LINE_ID = decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, LEAD_LINE_ID, p_LEAD_LINE_ID),
274: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
275: PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM, PERSON_ID, p_PERSON_ID),
276: SALESGROUP_ID = decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, SALESGROUP_ID, p_SALESGROUP_ID),
277: PARTNER_CUSTOMER_ID = decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, PARTNER_CUSTOMER_ID, p_PARTNER_CUSTOMER_ID),
270: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
271: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
272: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
273: LEAD_LINE_ID = decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, LEAD_LINE_ID, p_LEAD_LINE_ID),
274: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
275: PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM, PERSON_ID, p_PERSON_ID),
276: SALESGROUP_ID = decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, SALESGROUP_ID, p_SALESGROUP_ID),
277: PARTNER_CUSTOMER_ID = decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, PARTNER_CUSTOMER_ID, p_PARTNER_CUSTOMER_ID),
278: PARTNER_ADDRESS_ID = decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, PARTNER_ADDRESS_ID, p_PARTNER_ADDRESS_ID),
271: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
272: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
273: LEAD_LINE_ID = decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, LEAD_LINE_ID, p_LEAD_LINE_ID),
274: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
275: PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM, PERSON_ID, p_PERSON_ID),
276: SALESGROUP_ID = decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, SALESGROUP_ID, p_SALESGROUP_ID),
277: PARTNER_CUSTOMER_ID = decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, PARTNER_CUSTOMER_ID, p_PARTNER_CUSTOMER_ID),
278: PARTNER_ADDRESS_ID = decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, PARTNER_ADDRESS_ID, p_PARTNER_ADDRESS_ID),
279: REVENUE_AMOUNT = decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, REVENUE_AMOUNT, p_REVENUE_AMOUNT),
272: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
273: LEAD_LINE_ID = decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, LEAD_LINE_ID, p_LEAD_LINE_ID),
274: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
275: PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM, PERSON_ID, p_PERSON_ID),
276: SALESGROUP_ID = decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, SALESGROUP_ID, p_SALESGROUP_ID),
277: PARTNER_CUSTOMER_ID = decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, PARTNER_CUSTOMER_ID, p_PARTNER_CUSTOMER_ID),
278: PARTNER_ADDRESS_ID = decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, PARTNER_ADDRESS_ID, p_PARTNER_ADDRESS_ID),
279: REVENUE_AMOUNT = decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, REVENUE_AMOUNT, p_REVENUE_AMOUNT),
280: REVENUE_PERCENT = decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, REVENUE_PERCENT, p_REVENUE_PERCENT),
273: LEAD_LINE_ID = decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, LEAD_LINE_ID, p_LEAD_LINE_ID),
274: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
275: PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM, PERSON_ID, p_PERSON_ID),
276: SALESGROUP_ID = decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, SALESGROUP_ID, p_SALESGROUP_ID),
277: PARTNER_CUSTOMER_ID = decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, PARTNER_CUSTOMER_ID, p_PARTNER_CUSTOMER_ID),
278: PARTNER_ADDRESS_ID = decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, PARTNER_ADDRESS_ID, p_PARTNER_ADDRESS_ID),
279: REVENUE_AMOUNT = decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, REVENUE_AMOUNT, p_REVENUE_AMOUNT),
280: REVENUE_PERCENT = decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, REVENUE_PERCENT, p_REVENUE_PERCENT),
281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),
274: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
275: PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM, PERSON_ID, p_PERSON_ID),
276: SALESGROUP_ID = decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, SALESGROUP_ID, p_SALESGROUP_ID),
277: PARTNER_CUSTOMER_ID = decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, PARTNER_CUSTOMER_ID, p_PARTNER_CUSTOMER_ID),
278: PARTNER_ADDRESS_ID = decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, PARTNER_ADDRESS_ID, p_PARTNER_ADDRESS_ID),
279: REVENUE_AMOUNT = decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, REVENUE_AMOUNT, p_REVENUE_AMOUNT),
280: REVENUE_PERCENT = decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, REVENUE_PERCENT, p_REVENUE_PERCENT),
281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),
282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),
275: PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM, PERSON_ID, p_PERSON_ID),
276: SALESGROUP_ID = decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, SALESGROUP_ID, p_SALESGROUP_ID),
277: PARTNER_CUSTOMER_ID = decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, PARTNER_CUSTOMER_ID, p_PARTNER_CUSTOMER_ID),
278: PARTNER_ADDRESS_ID = decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, PARTNER_ADDRESS_ID, p_PARTNER_ADDRESS_ID),
279: REVENUE_AMOUNT = decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, REVENUE_AMOUNT, p_REVENUE_AMOUNT),
280: REVENUE_PERCENT = decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, REVENUE_PERCENT, p_REVENUE_PERCENT),
281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),
282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),
283: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
276: SALESGROUP_ID = decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, SALESGROUP_ID, p_SALESGROUP_ID),
277: PARTNER_CUSTOMER_ID = decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, PARTNER_CUSTOMER_ID, p_PARTNER_CUSTOMER_ID),
278: PARTNER_ADDRESS_ID = decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, PARTNER_ADDRESS_ID, p_PARTNER_ADDRESS_ID),
279: REVENUE_AMOUNT = decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, REVENUE_AMOUNT, p_REVENUE_AMOUNT),
280: REVENUE_PERCENT = decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, REVENUE_PERCENT, p_REVENUE_PERCENT),
281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),
282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),
283: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
284: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
277: PARTNER_CUSTOMER_ID = decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, PARTNER_CUSTOMER_ID, p_PARTNER_CUSTOMER_ID),
278: PARTNER_ADDRESS_ID = decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, PARTNER_ADDRESS_ID, p_PARTNER_ADDRESS_ID),
279: REVENUE_AMOUNT = decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, REVENUE_AMOUNT, p_REVENUE_AMOUNT),
280: REVENUE_PERCENT = decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, REVENUE_PERCENT, p_REVENUE_PERCENT),
281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),
282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),
283: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
284: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
285: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
278: PARTNER_ADDRESS_ID = decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, PARTNER_ADDRESS_ID, p_PARTNER_ADDRESS_ID),
279: REVENUE_AMOUNT = decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, REVENUE_AMOUNT, p_REVENUE_AMOUNT),
280: REVENUE_PERCENT = decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, REVENUE_PERCENT, p_REVENUE_PERCENT),
281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),
282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),
283: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
284: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
285: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
286: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
279: REVENUE_AMOUNT = decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, REVENUE_AMOUNT, p_REVENUE_AMOUNT),
280: REVENUE_PERCENT = decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, REVENUE_PERCENT, p_REVENUE_PERCENT),
281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),
282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),
283: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
284: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
285: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
286: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
287: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
280: REVENUE_PERCENT = decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, REVENUE_PERCENT, p_REVENUE_PERCENT),
281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),
282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),
283: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
284: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
285: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
286: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
287: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
288: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),
282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),
283: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
284: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
285: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
286: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
287: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
288: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
289: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),
283: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
284: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
285: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
286: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
287: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
288: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
289: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
290: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
283: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
284: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
285: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
286: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
287: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
288: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
289: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
290: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
291: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
284: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
285: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
286: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
287: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
288: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
289: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
290: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
291: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
292: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
285: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
286: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
287: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
288: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
289: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
290: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
291: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
292: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
293: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
286: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
287: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
288: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
289: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
290: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
291: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
292: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
293: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
294: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
287: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
288: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
289: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
290: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
291: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
292: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
293: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
294: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
295: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
288: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
289: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
290: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
291: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
292: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
293: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
294: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
295: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
296: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
289: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
290: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
291: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
292: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
293: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
294: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
295: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
296: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
297: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
290: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
291: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
292: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
293: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
294: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
295: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
296: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
297: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
298: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
291: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
292: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
293: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
294: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
295: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
296: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
297: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
298: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
299: MANAGER_REVIEW_FLAG = decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, MANAGER_REVIEW_FLAG, p_MANAGER_REVIEW_FLAG),
292: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
293: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
294: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
295: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
296: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
297: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
298: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
299: MANAGER_REVIEW_FLAG = decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, MANAGER_REVIEW_FLAG, p_MANAGER_REVIEW_FLAG),
300: MANAGER_REVIEW_DATE = decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, MANAGER_REVIEW_DATE, p_MANAGER_REVIEW_DATE),
293: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
294: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
295: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
296: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
297: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
298: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
299: MANAGER_REVIEW_FLAG = decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, MANAGER_REVIEW_FLAG, p_MANAGER_REVIEW_FLAG),
300: MANAGER_REVIEW_DATE = decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, MANAGER_REVIEW_DATE, p_MANAGER_REVIEW_DATE),
301: ORIGINAL_SALES_CREDIT_ID = decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, ORIGINAL_SALES_CREDIT_ID, p_ORIGINAL_SALES_CREDIT_ID),
294: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
295: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
296: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
297: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
298: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
299: MANAGER_REVIEW_FLAG = decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, MANAGER_REVIEW_FLAG, p_MANAGER_REVIEW_FLAG),
300: MANAGER_REVIEW_DATE = decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, MANAGER_REVIEW_DATE, p_MANAGER_REVIEW_DATE),
301: ORIGINAL_SALES_CREDIT_ID = decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, ORIGINAL_SALES_CREDIT_ID, p_ORIGINAL_SALES_CREDIT_ID),
302: -- CREDIT_TYPE = decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, CREDIT_TYPE, p_CREDIT_TYPE),
295: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
296: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
297: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
298: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
299: MANAGER_REVIEW_FLAG = decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, MANAGER_REVIEW_FLAG, p_MANAGER_REVIEW_FLAG),
300: MANAGER_REVIEW_DATE = decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, MANAGER_REVIEW_DATE, p_MANAGER_REVIEW_DATE),
301: ORIGINAL_SALES_CREDIT_ID = decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, ORIGINAL_SALES_CREDIT_ID, p_ORIGINAL_SALES_CREDIT_ID),
302: -- CREDIT_TYPE = decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, CREDIT_TYPE, p_CREDIT_TYPE),
303: CREDIT_PERCENT = decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, CREDIT_PERCENT, p_CREDIT_PERCENT),
296: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
297: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
298: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
299: MANAGER_REVIEW_FLAG = decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, MANAGER_REVIEW_FLAG, p_MANAGER_REVIEW_FLAG),
300: MANAGER_REVIEW_DATE = decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, MANAGER_REVIEW_DATE, p_MANAGER_REVIEW_DATE),
301: ORIGINAL_SALES_CREDIT_ID = decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, ORIGINAL_SALES_CREDIT_ID, p_ORIGINAL_SALES_CREDIT_ID),
302: -- CREDIT_TYPE = decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, CREDIT_TYPE, p_CREDIT_TYPE),
303: CREDIT_PERCENT = decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, CREDIT_PERCENT, p_CREDIT_PERCENT),
304: CREDIT_AMOUNT = decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, CREDIT_AMOUNT, p_CREDIT_AMOUNT),
297: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
298: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
299: MANAGER_REVIEW_FLAG = decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, MANAGER_REVIEW_FLAG, p_MANAGER_REVIEW_FLAG),
300: MANAGER_REVIEW_DATE = decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, MANAGER_REVIEW_DATE, p_MANAGER_REVIEW_DATE),
301: ORIGINAL_SALES_CREDIT_ID = decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, ORIGINAL_SALES_CREDIT_ID, p_ORIGINAL_SALES_CREDIT_ID),
302: -- CREDIT_TYPE = decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, CREDIT_TYPE, p_CREDIT_TYPE),
303: CREDIT_PERCENT = decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, CREDIT_PERCENT, p_CREDIT_PERCENT),
304: CREDIT_AMOUNT = decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, CREDIT_AMOUNT, p_CREDIT_AMOUNT),
305: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
298: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
299: MANAGER_REVIEW_FLAG = decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, MANAGER_REVIEW_FLAG, p_MANAGER_REVIEW_FLAG),
300: MANAGER_REVIEW_DATE = decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, MANAGER_REVIEW_DATE, p_MANAGER_REVIEW_DATE),
301: ORIGINAL_SALES_CREDIT_ID = decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, ORIGINAL_SALES_CREDIT_ID, p_ORIGINAL_SALES_CREDIT_ID),
302: -- CREDIT_TYPE = decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, CREDIT_TYPE, p_CREDIT_TYPE),
303: CREDIT_PERCENT = decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, CREDIT_PERCENT, p_CREDIT_PERCENT),
304: CREDIT_AMOUNT = decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, CREDIT_AMOUNT, p_CREDIT_AMOUNT),
305: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
306: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
299: MANAGER_REVIEW_FLAG = decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, MANAGER_REVIEW_FLAG, p_MANAGER_REVIEW_FLAG),
300: MANAGER_REVIEW_DATE = decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, MANAGER_REVIEW_DATE, p_MANAGER_REVIEW_DATE),
301: ORIGINAL_SALES_CREDIT_ID = decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, ORIGINAL_SALES_CREDIT_ID, p_ORIGINAL_SALES_CREDIT_ID),
302: -- CREDIT_TYPE = decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, CREDIT_TYPE, p_CREDIT_TYPE),
303: CREDIT_PERCENT = decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, CREDIT_PERCENT, p_CREDIT_PERCENT),
304: CREDIT_AMOUNT = decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, CREDIT_AMOUNT, p_CREDIT_AMOUNT),
305: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
306: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
307: OPP_WORST_FORECAST_AMOUNT = nvl(l_OPP_WORST_FORECAST_AMOUNT, OPP_WORST_FORECAST_AMOUNT),
300: MANAGER_REVIEW_DATE = decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, MANAGER_REVIEW_DATE, p_MANAGER_REVIEW_DATE),
301: ORIGINAL_SALES_CREDIT_ID = decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, ORIGINAL_SALES_CREDIT_ID, p_ORIGINAL_SALES_CREDIT_ID),
302: -- CREDIT_TYPE = decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, CREDIT_TYPE, p_CREDIT_TYPE),
303: CREDIT_PERCENT = decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, CREDIT_PERCENT, p_CREDIT_PERCENT),
304: CREDIT_AMOUNT = decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, CREDIT_AMOUNT, p_CREDIT_AMOUNT),
305: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
306: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
307: OPP_WORST_FORECAST_AMOUNT = nvl(l_OPP_WORST_FORECAST_AMOUNT, OPP_WORST_FORECAST_AMOUNT),
308: OPP_FORECAST_AMOUNT = nvl(l_OPP_FORECAST_AMOUNT, OPP_FORECAST_AMOUNT),
301: ORIGINAL_SALES_CREDIT_ID = decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, ORIGINAL_SALES_CREDIT_ID, p_ORIGINAL_SALES_CREDIT_ID),
302: -- CREDIT_TYPE = decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, CREDIT_TYPE, p_CREDIT_TYPE),
303: CREDIT_PERCENT = decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, CREDIT_PERCENT, p_CREDIT_PERCENT),
304: CREDIT_AMOUNT = decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, CREDIT_AMOUNT, p_CREDIT_AMOUNT),
305: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
306: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
307: OPP_WORST_FORECAST_AMOUNT = nvl(l_OPP_WORST_FORECAST_AMOUNT, OPP_WORST_FORECAST_AMOUNT),
308: OPP_FORECAST_AMOUNT = nvl(l_OPP_FORECAST_AMOUNT, OPP_FORECAST_AMOUNT),
309: OPP_BEST_FORECAST_AMOUNT = nvl(l_OPP_BEST_FORECAST_AMOUNT, OPP_BEST_FORECAST_AMOUNT),
302: -- CREDIT_TYPE = decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, CREDIT_TYPE, p_CREDIT_TYPE),
303: CREDIT_PERCENT = decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, CREDIT_PERCENT, p_CREDIT_PERCENT),
304: CREDIT_AMOUNT = decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, CREDIT_AMOUNT, p_CREDIT_AMOUNT),
305: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
306: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
307: OPP_WORST_FORECAST_AMOUNT = nvl(l_OPP_WORST_FORECAST_AMOUNT, OPP_WORST_FORECAST_AMOUNT),
308: OPP_FORECAST_AMOUNT = nvl(l_OPP_FORECAST_AMOUNT, OPP_FORECAST_AMOUNT),
309: OPP_BEST_FORECAST_AMOUNT = nvl(l_OPP_BEST_FORECAST_AMOUNT, OPP_BEST_FORECAST_AMOUNT),
310: DEFAULTED_FROM_OWNER_FLAG = NVL(P_DEFAULTED_FROM_OWNER_FLAG,DEFAULTED_FROM_OWNER_FLAG) -- Added for ASNB