DBA Data[Home] [Help]

APPS.AS_SALES_CREDITS_PKG dependencies on FND_API

Line 72: If (px_SALES_CREDIT_ID IS NULL) OR (px_SALES_CREDIT_ID = FND_API.G_MISS_NUM) then

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;

Line 78: IF l_OPP_WORST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN

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

Line 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

Line 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(

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 149: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_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),

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

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

Line 151: decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_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),

Line 152: decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_LINE_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),

Line 153: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_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),

Line 154: decode( p_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_PERSON_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),

Line 155: decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALESGROUP_ID),

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

Line 156: decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_CUSTOMER_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),
160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),

Line 157: decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_PARTNER_ADDRESS_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),
161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),

Line 158: decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_REVENUE_AMOUNT),

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

Line 159: decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, NULL, p_REVENUE_PERCENT),

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

Line 160: decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_AMOUNT),

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

Line 161: decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_QUOTA_CREDIT_PERCENT),

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 178: decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANAGER_REVIEW_FLAG),

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

Line 179: decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_MANAGER_REVIEW_DATE),

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

Line 180: decode( p_ORIGINAL_SALES_CREDIT_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SALES_CREDIT_ID),

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

Line 181: -- decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, NULL, p_CREDIT_TYPE),

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

Line 182: decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, NULL, p_CREDIT_PERCENT),

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

Line 183: decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_CREDIT_AMOUNT),

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

Line 184: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID),

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

Line 185: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_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),
189: decode( P_DEFAULTED_FROM_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, P_DEFAULTED_FROM_OWNER_FLAG) -- Added for ASNB

Line 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(

Line 249: IF l_OPP_WORST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN

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

Line 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

Line 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

Line 263: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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

Line 264: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

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

Line 265: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

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

Line 266: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

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

Line 267: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

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

Line 268: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

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

Line 269: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_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),

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

Line 271: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

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

Line 272: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_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),

Line 273: LEAD_LINE_ID = decode( p_LEAD_LINE_ID, FND_API.G_MISS_NUM, LEAD_LINE_ID, p_LEAD_LINE_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),

Line 274: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_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),

Line 275: PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM, PERSON_ID, p_PERSON_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),

Line 276: SALESGROUP_ID = decode( p_SALESGROUP_ID, FND_API.G_MISS_NUM, SALESGROUP_ID, p_SALESGROUP_ID),

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

Line 277: PARTNER_CUSTOMER_ID = decode( p_PARTNER_CUSTOMER_ID, FND_API.G_MISS_NUM, PARTNER_CUSTOMER_ID, p_PARTNER_CUSTOMER_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),
281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),

Line 278: PARTNER_ADDRESS_ID = decode( p_PARTNER_ADDRESS_ID, FND_API.G_MISS_NUM, PARTNER_ADDRESS_ID, p_PARTNER_ADDRESS_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),
282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),

Line 279: REVENUE_AMOUNT = decode( p_REVENUE_AMOUNT, FND_API.G_MISS_NUM, REVENUE_AMOUNT, p_REVENUE_AMOUNT),

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

Line 280: REVENUE_PERCENT = decode( p_REVENUE_PERCENT, FND_API.G_MISS_NUM, REVENUE_PERCENT, p_REVENUE_PERCENT),

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

Line 281: QUOTA_CREDIT_AMOUNT = decode( p_QUOTA_CREDIT_AMOUNT, FND_API.G_MISS_NUM, QUOTA_CREDIT_AMOUNT, p_QUOTA_CREDIT_AMOUNT),

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

Line 282: QUOTA_CREDIT_PERCENT = decode( p_QUOTA_CREDIT_PERCENT, FND_API.G_MISS_NUM, QUOTA_CREDIT_PERCENT, p_QUOTA_CREDIT_PERCENT),

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

Line 283: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

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

Line 284: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

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

Line 285: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

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

Line 286: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

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

Line 287: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

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

Line 288: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

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

Line 289: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

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

Line 290: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

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

Line 291: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

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

Line 292: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

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

Line 293: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

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

Line 294: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

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

Line 295: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

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

Line 296: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

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

Line 297: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

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

Line 298: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

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

Line 299: MANAGER_REVIEW_FLAG = decode( p_MANAGER_REVIEW_FLAG, FND_API.G_MISS_CHAR, MANAGER_REVIEW_FLAG, p_MANAGER_REVIEW_FLAG),

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

Line 300: MANAGER_REVIEW_DATE = decode( p_MANAGER_REVIEW_DATE, FND_API.G_MISS_DATE, MANAGER_REVIEW_DATE, p_MANAGER_REVIEW_DATE),

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

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

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

Line 302: -- CREDIT_TYPE = decode( p_CREDIT_TYPE, FND_API.G_MISS_CHAR, CREDIT_TYPE, p_CREDIT_TYPE),

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

Line 303: CREDIT_PERCENT = decode( p_CREDIT_PERCENT, FND_API.G_MISS_NUM, CREDIT_PERCENT, p_CREDIT_PERCENT),

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

Line 304: CREDIT_AMOUNT = decode( p_CREDIT_AMOUNT, FND_API.G_MISS_NUM, CREDIT_AMOUNT, p_CREDIT_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),

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

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

Line 306: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_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),
310: DEFAULTED_FROM_OWNER_FLAG = NVL(P_DEFAULTED_FROM_OWNER_FLAG,DEFAULTED_FROM_OWNER_FLAG) -- Added for ASNB