DBA Data[Home] [Help]

APPS.IEX_WRITEOFFS_PKG dependencies on FND_API

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

155: ,CONTRACT_NUMBER
156: ) VALUES (
157: p_WRITEOFF_ID,
158: p_PARTY_ID,
159: decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, NULL, p_DELINQUENCY_ID),
160: decode( p_CAS_ID, FND_API.G_MISS_NUM, NULL, p_CAS_ID),
161: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
162: decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE),
163: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),

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

156: ) VALUES (
157: p_WRITEOFF_ID,
158: p_PARTY_ID,
159: decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, NULL, p_DELINQUENCY_ID),
160: decode( p_CAS_ID, FND_API.G_MISS_NUM, NULL, p_CAS_ID),
161: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
162: decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE),
163: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
164: decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_CODE),

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

157: p_WRITEOFF_ID,
158: p_PARTY_ID,
159: decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, NULL, p_DELINQUENCY_ID),
160: decode( p_CAS_ID, FND_API.G_MISS_NUM, NULL, p_CAS_ID),
161: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
162: decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE),
163: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
164: decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_CODE),
165: p_WRITEOFF_TYPE,

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

158: p_PARTY_ID,
159: decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, NULL, p_DELINQUENCY_ID),
160: decode( p_CAS_ID, FND_API.G_MISS_NUM, NULL, p_CAS_ID),
161: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
162: decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE),
163: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
164: decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_CODE),
165: p_WRITEOFF_TYPE,
166: p_ACTIVE_FLAG,

Line 163: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),

159: decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, NULL, p_DELINQUENCY_ID),
160: decode( p_CAS_ID, FND_API.G_MISS_NUM, NULL, p_CAS_ID),
161: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
162: decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE),
163: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
164: decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_CODE),
165: p_WRITEOFF_TYPE,
166: p_ACTIVE_FLAG,
167: p_OBJECT_VERSION_NUMBER,

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

160: decode( p_CAS_ID, FND_API.G_MISS_NUM, NULL, p_CAS_ID),
161: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
162: decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE),
163: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
164: decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_CODE),
165: p_WRITEOFF_TYPE,
166: p_ACTIVE_FLAG,
167: p_OBJECT_VERSION_NUMBER,
168: p_WRITEOFF_REASON,

Line 169: decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WRITEOFF_AMOUNT),

165: p_WRITEOFF_TYPE,
166: p_ACTIVE_FLAG,
167: p_OBJECT_VERSION_NUMBER,
168: p_WRITEOFF_REASON,
169: decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WRITEOFF_AMOUNT),
170: decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_CURRENCY_CODE),
171: decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_DATE),
172: decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_REQUEST_DATE),
173: decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_PROCESS),

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

166: p_ACTIVE_FLAG,
167: p_OBJECT_VERSION_NUMBER,
168: p_WRITEOFF_REASON,
169: decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WRITEOFF_AMOUNT),
170: decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_CURRENCY_CODE),
171: decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_DATE),
172: decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_REQUEST_DATE),
173: decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_PROCESS),
174: decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_SCORE),

Line 171: decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_DATE),

167: p_OBJECT_VERSION_NUMBER,
168: p_WRITEOFF_REASON,
169: decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WRITEOFF_AMOUNT),
170: decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_CURRENCY_CODE),
171: decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_DATE),
172: decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_REQUEST_DATE),
173: decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_PROCESS),
174: decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_SCORE),
175: decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, NULL, p_BAD_DEBT_REASON),

Line 172: decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_REQUEST_DATE),

168: p_WRITEOFF_REASON,
169: decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WRITEOFF_AMOUNT),
170: decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_CURRENCY_CODE),
171: decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_DATE),
172: decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_REQUEST_DATE),
173: decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_PROCESS),
174: decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_SCORE),
175: decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, NULL, p_BAD_DEBT_REASON),
176: decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, NULL, p_LEASING_CODE),

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

169: decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WRITEOFF_AMOUNT),
170: decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_CURRENCY_CODE),
171: decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_DATE),
172: decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_REQUEST_DATE),
173: decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_PROCESS),
174: decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_SCORE),
175: decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, NULL, p_BAD_DEBT_REASON),
176: decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, NULL, p_LEASING_CODE),
177: decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),

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

170: decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_CURRENCY_CODE),
171: decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_DATE),
172: decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_REQUEST_DATE),
173: decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_PROCESS),
174: decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_SCORE),
175: decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, NULL, p_BAD_DEBT_REASON),
176: decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, NULL, p_LEASING_CODE),
177: decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),
178: decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),

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

171: decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_DATE),
172: decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_REQUEST_DATE),
173: decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_PROCESS),
174: decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_SCORE),
175: decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, NULL, p_BAD_DEBT_REASON),
176: decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, NULL, p_LEASING_CODE),
177: decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),
178: decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),
179: decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),

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

172: decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_REQUEST_DATE),
173: decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_PROCESS),
174: decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_SCORE),
175: decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, NULL, p_BAD_DEBT_REASON),
176: decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, NULL, p_LEASING_CODE),
177: decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),
178: decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),
179: decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),
180: decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),

Line 177: decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),

173: decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_PROCESS),
174: decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_SCORE),
175: decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, NULL, p_BAD_DEBT_REASON),
176: decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, NULL, p_LEASING_CODE),
177: decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),
178: decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),
179: decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),
180: decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),
181: decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),

Line 178: decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),

174: decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_SCORE),
175: decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, NULL, p_BAD_DEBT_REASON),
176: decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, NULL, p_LEASING_CODE),
177: decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),
178: decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),
179: decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),
180: decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),
181: decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),
182: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),

Line 179: decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),

175: decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, NULL, p_BAD_DEBT_REASON),
176: decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, NULL, p_LEASING_CODE),
177: decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),
178: decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),
179: decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),
180: decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),
181: decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),
182: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
183: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),

Line 180: decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),

176: decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, NULL, p_LEASING_CODE),
177: decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),
178: decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),
179: decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),
180: decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),
181: decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),
182: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
183: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
184: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

Line 181: decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),

177: decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),
178: decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),
179: decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),
180: decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),
181: decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),
182: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
183: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
184: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
185: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

Line 182: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),

178: decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),
179: decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),
180: decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),
181: decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),
182: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
183: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
184: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
185: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
186: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

Line 183: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),

179: decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),
180: decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),
181: decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),
182: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
183: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
184: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
185: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
186: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
187: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),

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

180: decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),
181: decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),
182: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
183: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
184: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
185: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
186: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
187: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
188: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

Line 185: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

181: decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),
182: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
183: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
184: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
185: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
186: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
187: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
188: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
189: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

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

182: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
183: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
184: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
185: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
186: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
187: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
188: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
189: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
190: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

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

183: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
184: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
185: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
186: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
187: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
188: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
189: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
190: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
191: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

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

184: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
185: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
186: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
187: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
188: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
189: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
190: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
191: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
192: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

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

185: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
186: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
187: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
188: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
189: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
190: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
191: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
192: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
193: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

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

186: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
187: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
188: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
189: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
190: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
191: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
192: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
193: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
194: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

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

187: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
188: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
189: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
190: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
191: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
192: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
193: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
194: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
195: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

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

188: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
189: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
190: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
191: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
192: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
193: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
194: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
195: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
196: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

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

189: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
190: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
191: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
192: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
193: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
194: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
195: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
196: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
197: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

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

190: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
191: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
192: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
193: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
194: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
195: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
196: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
197: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
198: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

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

191: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
192: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
193: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
194: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
195: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
196: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
197: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
198: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
199: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

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

192: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
193: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
194: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
195: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
196: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
197: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
198: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
199: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
200: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

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

193: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
194: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
195: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
196: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
197: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
198: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
199: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
200: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
201: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

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

194: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
195: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
196: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
197: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
198: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
199: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
200: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
201: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
202: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

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

195: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
196: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
197: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
198: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
199: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
200: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
201: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
202: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
203: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

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

196: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
197: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
198: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
199: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
200: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
201: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
202: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
203: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
204: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

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

197: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
198: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
199: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
200: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
201: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
202: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
203: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
204: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
205: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

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

198: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
199: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
200: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
201: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
202: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
203: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
204: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
205: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
206: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

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

199: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
200: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
201: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
202: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
203: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
204: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
205: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
206: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
207: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

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

200: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
201: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
202: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
203: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
204: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
205: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
206: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
207: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
208: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

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

201: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
202: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
203: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
204: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
205: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
206: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
207: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
208: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
209: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)

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

202: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
203: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
204: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
205: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
206: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
207: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
208: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
209: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
210: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)

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

203: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
204: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
205: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
206: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
207: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
208: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
209: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
210: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
211: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)

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

204: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
205: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
206: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
207: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
208: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
209: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
210: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
211: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
212: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)

Line 209: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)

205: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
206: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
207: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
208: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
209: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
210: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
211: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
212: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
213: ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)

Line 210: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)

206: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
207: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
208: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
209: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
210: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
211: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
212: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
213: ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)
214: ,decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SITE_USE_ID)

Line 211: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)

207: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
208: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
209: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
210: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
211: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
212: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
213: ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)
214: ,decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SITE_USE_ID)
215: ,decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID)

Line 212: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)

208: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
209: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
210: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
211: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
212: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
213: ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)
214: ,decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SITE_USE_ID)
215: ,decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID)
216: ,decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_ID)

Line 213: ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)

209: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
210: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
211: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
212: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
213: ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)
214: ,decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SITE_USE_ID)
215: ,decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID)
216: ,decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_ID)
217: ,decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CONTRACT_NUMBER));

Line 214: ,decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SITE_USE_ID)

210: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
211: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
212: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
213: ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)
214: ,decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SITE_USE_ID)
215: ,decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID)
216: ,decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_ID)
217: ,decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CONTRACT_NUMBER));
218:

Line 215: ,decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID)

211: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
212: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
213: ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)
214: ,decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SITE_USE_ID)
215: ,decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID)
216: ,decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_ID)
217: ,decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CONTRACT_NUMBER));
218:
219:

Line 216: ,decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_ID)

212: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
213: ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)
214: ,decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SITE_USE_ID)
215: ,decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID)
216: ,decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_ID)
217: ,decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CONTRACT_NUMBER));
218:
219:
220: open c;

Line 217: ,decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CONTRACT_NUMBER));

213: ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)
214: ,decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SITE_USE_ID)
215: ,decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID)
216: ,decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_ID)
217: ,decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CONTRACT_NUMBER));
218:
219:
220: open c;
221: fetch c into X_ROWID;

Line 308: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),

304: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.UPDATE_ROW ******** ');
305: END IF;
306: Update IEX_WRITEOFFS
307: SET
308: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
309: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
310: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
311: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM,
312: CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),

Line 309: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),

305: END IF;
306: Update IEX_WRITEOFFS
307: SET
308: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
309: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
310: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
311: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM,
312: CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
313: DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR,

Line 310: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),

306: Update IEX_WRITEOFFS
307: SET
308: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
309: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
310: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
311: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM,
312: CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
313: DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR,
314: DISPOSITION_CODE, p_DISPOSITION_CODE),

Line 311: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM,

307: SET
308: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
309: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
310: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
311: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM,
312: CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
313: DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR,
314: DISPOSITION_CODE, p_DISPOSITION_CODE),
315: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),

Line 313: DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR,

309: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
310: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
311: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM,
312: CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
313: DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR,
314: DISPOSITION_CODE, p_DISPOSITION_CODE),
315: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
316: OBJECT_CODE = decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, OBJECT_CODE, p_OBJECT_CODE),
317: WRITEOFF_TYPE = decode( p_WRITEOFF_TYPE, FND_API.G_MISS_CHAR, WRITEOFF_TYPE, p_WRITEOFF_TYPE),

Line 315: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),

311: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM,
312: CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
313: DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR,
314: DISPOSITION_CODE, p_DISPOSITION_CODE),
315: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
316: OBJECT_CODE = decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, OBJECT_CODE, p_OBJECT_CODE),
317: WRITEOFF_TYPE = decode( p_WRITEOFF_TYPE, FND_API.G_MISS_CHAR, WRITEOFF_TYPE, p_WRITEOFF_TYPE),
318: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
319: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

Line 316: OBJECT_CODE = decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, OBJECT_CODE, p_OBJECT_CODE),

312: CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
313: DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR,
314: DISPOSITION_CODE, p_DISPOSITION_CODE),
315: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
316: OBJECT_CODE = decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, OBJECT_CODE, p_OBJECT_CODE),
317: WRITEOFF_TYPE = decode( p_WRITEOFF_TYPE, FND_API.G_MISS_CHAR, WRITEOFF_TYPE, p_WRITEOFF_TYPE),
318: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
319: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
320: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),

Line 317: WRITEOFF_TYPE = decode( p_WRITEOFF_TYPE, FND_API.G_MISS_CHAR, WRITEOFF_TYPE, p_WRITEOFF_TYPE),

313: DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR,
314: DISPOSITION_CODE, p_DISPOSITION_CODE),
315: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
316: OBJECT_CODE = decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, OBJECT_CODE, p_OBJECT_CODE),
317: WRITEOFF_TYPE = decode( p_WRITEOFF_TYPE, FND_API.G_MISS_CHAR, WRITEOFF_TYPE, p_WRITEOFF_TYPE),
318: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
319: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
320: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
321: WRITEOFF_REASON = decode( p_WRITEOFF_REASON, FND_API.G_MISS_CHAR, WRITEOFF_REASON, p_WRITEOFF_REASON),

Line 318: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),

314: DISPOSITION_CODE, p_DISPOSITION_CODE),
315: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
316: OBJECT_CODE = decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, OBJECT_CODE, p_OBJECT_CODE),
317: WRITEOFF_TYPE = decode( p_WRITEOFF_TYPE, FND_API.G_MISS_CHAR, WRITEOFF_TYPE, p_WRITEOFF_TYPE),
318: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
319: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
320: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
321: WRITEOFF_REASON = decode( p_WRITEOFF_REASON, FND_API.G_MISS_CHAR, WRITEOFF_REASON, p_WRITEOFF_REASON),
322: WRITEOFF_AMOUNT = decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, WRITEOFF_AMOUNT, p_WRITEOFF_AMOUNT),

Line 319: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

315: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
316: OBJECT_CODE = decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, OBJECT_CODE, p_OBJECT_CODE),
317: WRITEOFF_TYPE = decode( p_WRITEOFF_TYPE, FND_API.G_MISS_CHAR, WRITEOFF_TYPE, p_WRITEOFF_TYPE),
318: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
319: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
320: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
321: WRITEOFF_REASON = decode( p_WRITEOFF_REASON, FND_API.G_MISS_CHAR, WRITEOFF_REASON, p_WRITEOFF_REASON),
322: WRITEOFF_AMOUNT = decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, WRITEOFF_AMOUNT, p_WRITEOFF_AMOUNT),
323: WRITEOFF_CURRENCY_CODE = decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, WRITEOFF_CURRENCY_CODE, p_WRITEOFF_CURRENCY_CODE),

Line 321: WRITEOFF_REASON = decode( p_WRITEOFF_REASON, FND_API.G_MISS_CHAR, WRITEOFF_REASON, p_WRITEOFF_REASON),

317: WRITEOFF_TYPE = decode( p_WRITEOFF_TYPE, FND_API.G_MISS_CHAR, WRITEOFF_TYPE, p_WRITEOFF_TYPE),
318: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
319: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
320: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
321: WRITEOFF_REASON = decode( p_WRITEOFF_REASON, FND_API.G_MISS_CHAR, WRITEOFF_REASON, p_WRITEOFF_REASON),
322: WRITEOFF_AMOUNT = decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, WRITEOFF_AMOUNT, p_WRITEOFF_AMOUNT),
323: WRITEOFF_CURRENCY_CODE = decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, WRITEOFF_CURRENCY_CODE, p_WRITEOFF_CURRENCY_CODE),
324: WRITEOFF_DATE = decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, WRITEOFF_DATE, p_WRITEOFF_DATE),
325: WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),

Line 322: WRITEOFF_AMOUNT = decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, WRITEOFF_AMOUNT, p_WRITEOFF_AMOUNT),

318: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
319: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
320: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
321: WRITEOFF_REASON = decode( p_WRITEOFF_REASON, FND_API.G_MISS_CHAR, WRITEOFF_REASON, p_WRITEOFF_REASON),
322: WRITEOFF_AMOUNT = decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, WRITEOFF_AMOUNT, p_WRITEOFF_AMOUNT),
323: WRITEOFF_CURRENCY_CODE = decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, WRITEOFF_CURRENCY_CODE, p_WRITEOFF_CURRENCY_CODE),
324: WRITEOFF_DATE = decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, WRITEOFF_DATE, p_WRITEOFF_DATE),
325: WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),
326: WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),

Line 323: WRITEOFF_CURRENCY_CODE = decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, WRITEOFF_CURRENCY_CODE, p_WRITEOFF_CURRENCY_CODE),

319: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
320: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
321: WRITEOFF_REASON = decode( p_WRITEOFF_REASON, FND_API.G_MISS_CHAR, WRITEOFF_REASON, p_WRITEOFF_REASON),
322: WRITEOFF_AMOUNT = decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, WRITEOFF_AMOUNT, p_WRITEOFF_AMOUNT),
323: WRITEOFF_CURRENCY_CODE = decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, WRITEOFF_CURRENCY_CODE, p_WRITEOFF_CURRENCY_CODE),
324: WRITEOFF_DATE = decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, WRITEOFF_DATE, p_WRITEOFF_DATE),
325: WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),
326: WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),
327: WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),

Line 324: WRITEOFF_DATE = decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, WRITEOFF_DATE, p_WRITEOFF_DATE),

320: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
321: WRITEOFF_REASON = decode( p_WRITEOFF_REASON, FND_API.G_MISS_CHAR, WRITEOFF_REASON, p_WRITEOFF_REASON),
322: WRITEOFF_AMOUNT = decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, WRITEOFF_AMOUNT, p_WRITEOFF_AMOUNT),
323: WRITEOFF_CURRENCY_CODE = decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, WRITEOFF_CURRENCY_CODE, p_WRITEOFF_CURRENCY_CODE),
324: WRITEOFF_DATE = decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, WRITEOFF_DATE, p_WRITEOFF_DATE),
325: WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),
326: WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),
327: WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),
328: BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),

Line 325: WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),

321: WRITEOFF_REASON = decode( p_WRITEOFF_REASON, FND_API.G_MISS_CHAR, WRITEOFF_REASON, p_WRITEOFF_REASON),
322: WRITEOFF_AMOUNT = decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, WRITEOFF_AMOUNT, p_WRITEOFF_AMOUNT),
323: WRITEOFF_CURRENCY_CODE = decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, WRITEOFF_CURRENCY_CODE, p_WRITEOFF_CURRENCY_CODE),
324: WRITEOFF_DATE = decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, WRITEOFF_DATE, p_WRITEOFF_DATE),
325: WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),
326: WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),
327: WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),
328: BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),
329: LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),

Line 326: WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),

322: WRITEOFF_AMOUNT = decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, WRITEOFF_AMOUNT, p_WRITEOFF_AMOUNT),
323: WRITEOFF_CURRENCY_CODE = decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, WRITEOFF_CURRENCY_CODE, p_WRITEOFF_CURRENCY_CODE),
324: WRITEOFF_DATE = decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, WRITEOFF_DATE, p_WRITEOFF_DATE),
325: WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),
326: WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),
327: WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),
328: BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),
329: LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),
330: REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),

Line 327: WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),

323: WRITEOFF_CURRENCY_CODE = decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, WRITEOFF_CURRENCY_CODE, p_WRITEOFF_CURRENCY_CODE),
324: WRITEOFF_DATE = decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, WRITEOFF_DATE, p_WRITEOFF_DATE),
325: WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),
326: WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),
327: WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),
328: BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),
329: LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),
330: REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),
331: REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),

Line 328: BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),

324: WRITEOFF_DATE = decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, WRITEOFF_DATE, p_WRITEOFF_DATE),
325: WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),
326: WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),
327: WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),
328: BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),
329: LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),
330: REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),
331: REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),
332: CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),

Line 329: LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),

325: WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),
326: WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),
327: WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),
328: BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),
329: LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),
330: REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),
331: REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),
332: CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),
333: APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),

Line 330: REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),

326: WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),
327: WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),
328: BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),
329: LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),
330: REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),
331: REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),
332: CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),
333: APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),
334: EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),

Line 331: REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),

327: WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),
328: BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),
329: LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),
330: REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),
331: REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),
332: CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),
333: APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),
334: EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),
335: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),

Line 332: CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),

328: BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),
329: LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),
330: REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),
331: REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),
332: CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),
333: APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),
334: EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),
335: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
336: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),

Line 333: APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),

329: LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),
330: REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),
331: REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),
332: CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),
333: APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),
334: EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),
335: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
336: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
337: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

Line 334: EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),

330: REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),
331: REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),
332: CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),
333: APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),
334: EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),
335: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
336: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
337: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

Line 335: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),

331: REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),
332: CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),
333: APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),
334: EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),
335: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
336: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
337: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

Line 336: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),

332: CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),
333: APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),
334: EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),
335: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
336: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
337: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

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

333: APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),
334: EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),
335: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
336: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
337: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
341: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

Line 338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

334: EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),
335: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
336: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
337: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
341: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
342: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

Line 339: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

335: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
336: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
337: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
341: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
342: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
343: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

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

336: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
337: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
341: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
342: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
343: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
344: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

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

337: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
341: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
342: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
343: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
344: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
345: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

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

338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
341: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
342: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
343: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
344: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
345: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
346: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

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

339: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
341: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
342: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
343: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
344: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
345: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
346: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
347: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

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

340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
341: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
342: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
343: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
344: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
345: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
346: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
347: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
348: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

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

341: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
342: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
343: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
344: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
345: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
346: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
347: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
348: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
349: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

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

342: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
343: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
344: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
345: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
346: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
347: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
348: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
349: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
350: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

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

343: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
344: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
345: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
346: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
347: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
348: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
349: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
350: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
351: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

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

344: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
345: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
346: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
347: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
348: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
349: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
350: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
351: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
352: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

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

345: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
346: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
347: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
348: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
349: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
350: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
351: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
352: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
353: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

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

346: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
347: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
348: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
349: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
350: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
351: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
352: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
353: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
354: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

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

347: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
348: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
349: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
350: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
351: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
352: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
353: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
354: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
355: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

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

348: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
349: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
350: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
351: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
352: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
353: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
354: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
355: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
356: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

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

349: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
350: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
351: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
352: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
353: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
354: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
355: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
356: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
357: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

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

350: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
351: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
352: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
353: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
354: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
355: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
356: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
357: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
358: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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

351: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
352: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
353: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
354: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
355: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
356: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
357: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
358: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
359: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

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

352: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
353: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
354: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
355: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
356: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
357: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
358: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
359: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
360: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)

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

353: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
354: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
355: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
356: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
357: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
358: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
359: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
360: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
361: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)

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

354: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
355: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
356: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
357: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
358: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
359: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
360: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
361: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
362: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)

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

355: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
356: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
357: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
358: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
359: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
360: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
361: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
362: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
363: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)

Line 360: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)

356: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
357: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
358: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
359: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
360: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
361: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
362: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
363: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
364: ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)

Line 361: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)

357: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
358: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
359: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
360: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
361: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
362: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
363: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
364: ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)
365: ,CUSTOMER_SITE_USE_ID = decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, CUSTOMER_SITE_USE_ID, p_CUSTOMER_SITE_USE_ID)

Line 362: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)

358: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
359: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
360: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
361: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
362: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
363: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
364: ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)
365: ,CUSTOMER_SITE_USE_ID = decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, CUSTOMER_SITE_USE_ID, p_CUSTOMER_SITE_USE_ID)
366: ,ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)

Line 363: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)

359: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
360: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
361: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
362: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
363: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
364: ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)
365: ,CUSTOMER_SITE_USE_ID = decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, CUSTOMER_SITE_USE_ID, p_CUSTOMER_SITE_USE_ID)
366: ,ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
367: ,CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID)

Line 364: ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)

360: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
361: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
362: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
363: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
364: ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)
365: ,CUSTOMER_SITE_USE_ID = decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, CUSTOMER_SITE_USE_ID, p_CUSTOMER_SITE_USE_ID)
366: ,ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
367: ,CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID)
368: ,CONTRACT_NUMBER = decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, CONTRACT_NUMBER, p_CONTRACT_NUMBER)

Line 365: ,CUSTOMER_SITE_USE_ID = decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, CUSTOMER_SITE_USE_ID, p_CUSTOMER_SITE_USE_ID)

361: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
362: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
363: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
364: ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)
365: ,CUSTOMER_SITE_USE_ID = decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, CUSTOMER_SITE_USE_ID, p_CUSTOMER_SITE_USE_ID)
366: ,ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
367: ,CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID)
368: ,CONTRACT_NUMBER = decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, CONTRACT_NUMBER, p_CONTRACT_NUMBER)
369: where WRITEOFF_ID = p_WRITEOFF_ID;

Line 366: ,ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)

362: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
363: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
364: ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)
365: ,CUSTOMER_SITE_USE_ID = decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, CUSTOMER_SITE_USE_ID, p_CUSTOMER_SITE_USE_ID)
366: ,ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
367: ,CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID)
368: ,CONTRACT_NUMBER = decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, CONTRACT_NUMBER, p_CONTRACT_NUMBER)
369: where WRITEOFF_ID = p_WRITEOFF_ID;
370:

Line 367: ,CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID)

363: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
364: ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)
365: ,CUSTOMER_SITE_USE_ID = decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, CUSTOMER_SITE_USE_ID, p_CUSTOMER_SITE_USE_ID)
366: ,ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
367: ,CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID)
368: ,CONTRACT_NUMBER = decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, CONTRACT_NUMBER, p_CONTRACT_NUMBER)
369: where WRITEOFF_ID = p_WRITEOFF_ID;
370:
371: If (SQL%NOTFOUND) then

Line 368: ,CONTRACT_NUMBER = decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, CONTRACT_NUMBER, p_CONTRACT_NUMBER)

364: ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)
365: ,CUSTOMER_SITE_USE_ID = decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, CUSTOMER_SITE_USE_ID, p_CUSTOMER_SITE_USE_ID)
366: ,ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
367: ,CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID)
368: ,CONTRACT_NUMBER = decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, CONTRACT_NUMBER, p_CONTRACT_NUMBER)
369: where WRITEOFF_ID = p_WRITEOFF_ID;
370:
371: If (SQL%NOTFOUND) then
372: RAISE NO_DATA_FOUND;