eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_BANKRUPTCIES_PKG dependencies on FND_API

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

166: ,FILE_CONTACT_ID
167: ,CASE_NUMBER
168: ) VALUES (
169: p_BANKRUPTCY_ID,
170: decode( p_CAS_ID, FND_API.G_MISS_NUM, NULL, p_CAS_ID),
171: decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, NULL, p_DELINQUENCY_ID),
172: p_PARTY_ID,
173: p_ACTIVE_FLAG,
174: decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_TRUSTEE_CONTACT_ID),

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

167: ,CASE_NUMBER
168: ) VALUES (
169: p_BANKRUPTCY_ID,
170: decode( p_CAS_ID, FND_API.G_MISS_NUM, NULL, p_CAS_ID),
171: decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, NULL, p_DELINQUENCY_ID),
172: p_PARTY_ID,
173: p_ACTIVE_FLAG,
174: decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_TRUSTEE_CONTACT_ID),
175: decode( p_COURT_ID, FND_API.G_MISS_NUM, NULL, p_COURT_ID),

Line 174: decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_TRUSTEE_CONTACT_ID),

170: decode( p_CAS_ID, FND_API.G_MISS_NUM, NULL, p_CAS_ID),
171: decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, NULL, p_DELINQUENCY_ID),
172: p_PARTY_ID,
173: p_ACTIVE_FLAG,
174: decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_TRUSTEE_CONTACT_ID),
175: decode( p_COURT_ID, FND_API.G_MISS_NUM, NULL, p_COURT_ID),
176: decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FIRM_CONTACT_ID),
177: decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_COUNSEL_CONTACT_ID),
178: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),

Line 175: decode( p_COURT_ID, FND_API.G_MISS_NUM, NULL, p_COURT_ID),

171: decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, NULL, p_DELINQUENCY_ID),
172: p_PARTY_ID,
173: p_ACTIVE_FLAG,
174: decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_TRUSTEE_CONTACT_ID),
175: decode( p_COURT_ID, FND_API.G_MISS_NUM, NULL, p_COURT_ID),
176: decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FIRM_CONTACT_ID),
177: decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_COUNSEL_CONTACT_ID),
178: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
179: decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, NULL, p_CHAPTER_CODE),

Line 176: decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FIRM_CONTACT_ID),

172: p_PARTY_ID,
173: p_ACTIVE_FLAG,
174: decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_TRUSTEE_CONTACT_ID),
175: decode( p_COURT_ID, FND_API.G_MISS_NUM, NULL, p_COURT_ID),
176: decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FIRM_CONTACT_ID),
177: decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_COUNSEL_CONTACT_ID),
178: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
179: decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, NULL, p_CHAPTER_CODE),
180: decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ASSET_AMOUNT),

Line 177: decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_COUNSEL_CONTACT_ID),

173: p_ACTIVE_FLAG,
174: decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_TRUSTEE_CONTACT_ID),
175: decode( p_COURT_ID, FND_API.G_MISS_NUM, NULL, p_COURT_ID),
176: decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FIRM_CONTACT_ID),
177: decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_COUNSEL_CONTACT_ID),
178: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
179: decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, NULL, p_CHAPTER_CODE),
180: decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ASSET_AMOUNT),
181: decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CURRENCY_CODE),

Line 178: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),

174: decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_TRUSTEE_CONTACT_ID),
175: decode( p_COURT_ID, FND_API.G_MISS_NUM, NULL, p_COURT_ID),
176: decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FIRM_CONTACT_ID),
177: decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_COUNSEL_CONTACT_ID),
178: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
179: decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, NULL, p_CHAPTER_CODE),
180: decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ASSET_AMOUNT),
181: decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CURRENCY_CODE),
182: decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYOFF_AMOUNT),

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

175: decode( p_COURT_ID, FND_API.G_MISS_NUM, NULL, p_COURT_ID),
176: decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FIRM_CONTACT_ID),
177: decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_COUNSEL_CONTACT_ID),
178: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
179: decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, NULL, p_CHAPTER_CODE),
180: decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ASSET_AMOUNT),
181: decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CURRENCY_CODE),
182: decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYOFF_AMOUNT),
183: decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYOFF_CURRENCY_CODE),

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

176: decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FIRM_CONTACT_ID),
177: decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_COUNSEL_CONTACT_ID),
178: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
179: decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, NULL, p_CHAPTER_CODE),
180: decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ASSET_AMOUNT),
181: decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CURRENCY_CODE),
182: decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYOFF_AMOUNT),
183: decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYOFF_CURRENCY_CODE),
184: decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BANKRUPTCY_FILE_DATE),

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

177: decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_COUNSEL_CONTACT_ID),
178: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
179: decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, NULL, p_CHAPTER_CODE),
180: decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ASSET_AMOUNT),
181: decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CURRENCY_CODE),
182: decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYOFF_AMOUNT),
183: decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYOFF_CURRENCY_CODE),
184: decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BANKRUPTCY_FILE_DATE),
185: decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COURT_ORDER_DATE),

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

178: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
179: decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, NULL, p_CHAPTER_CODE),
180: decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ASSET_AMOUNT),
181: decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CURRENCY_CODE),
182: decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYOFF_AMOUNT),
183: decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYOFF_CURRENCY_CODE),
184: decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BANKRUPTCY_FILE_DATE),
185: decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COURT_ORDER_DATE),
186: decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FUNDING_DATE),

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

179: decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, NULL, p_CHAPTER_CODE),
180: decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ASSET_AMOUNT),
181: decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CURRENCY_CODE),
182: decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYOFF_AMOUNT),
183: decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYOFF_CURRENCY_CODE),
184: decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BANKRUPTCY_FILE_DATE),
185: decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COURT_ORDER_DATE),
186: decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FUNDING_DATE),
187: decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OBJECT_BAR_DATE),

Line 184: decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BANKRUPTCY_FILE_DATE),

180: decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ASSET_AMOUNT),
181: decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CURRENCY_CODE),
182: decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYOFF_AMOUNT),
183: decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYOFF_CURRENCY_CODE),
184: decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BANKRUPTCY_FILE_DATE),
185: decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COURT_ORDER_DATE),
186: decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FUNDING_DATE),
187: decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OBJECT_BAR_DATE),
188: decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSESSION_DATE),

Line 185: decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COURT_ORDER_DATE),

181: decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CURRENCY_CODE),
182: decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYOFF_AMOUNT),
183: decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYOFF_CURRENCY_CODE),
184: decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BANKRUPTCY_FILE_DATE),
185: decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COURT_ORDER_DATE),
186: decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FUNDING_DATE),
187: decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OBJECT_BAR_DATE),
188: decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSESSION_DATE),
189: decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISMISSAL_DATE),

Line 186: decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FUNDING_DATE),

182: decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYOFF_AMOUNT),
183: decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYOFF_CURRENCY_CODE),
184: decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BANKRUPTCY_FILE_DATE),
185: decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COURT_ORDER_DATE),
186: decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FUNDING_DATE),
187: decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OBJECT_BAR_DATE),
188: decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSESSION_DATE),
189: decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISMISSAL_DATE),
190: decode( p_DATE_341A, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_341A),

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

183: decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYOFF_CURRENCY_CODE),
184: decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BANKRUPTCY_FILE_DATE),
185: decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COURT_ORDER_DATE),
186: decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FUNDING_DATE),
187: decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OBJECT_BAR_DATE),
188: decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSESSION_DATE),
189: decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISMISSAL_DATE),
190: decode( p_DATE_341A, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_341A),
191: decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISCHARGE_DATE),

Line 188: decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSESSION_DATE),

184: decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BANKRUPTCY_FILE_DATE),
185: decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COURT_ORDER_DATE),
186: decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FUNDING_DATE),
187: decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OBJECT_BAR_DATE),
188: decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSESSION_DATE),
189: decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISMISSAL_DATE),
190: decode( p_DATE_341A, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_341A),
191: decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISCHARGE_DATE),
192: decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WITHDRAW_DATE),

Line 189: decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISMISSAL_DATE),

185: decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_COURT_ORDER_DATE),
186: decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FUNDING_DATE),
187: decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OBJECT_BAR_DATE),
188: decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSESSION_DATE),
189: decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISMISSAL_DATE),
190: decode( p_DATE_341A, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_341A),
191: decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISCHARGE_DATE),
192: decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WITHDRAW_DATE),
193: decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CLOSE_DATE),

Line 190: decode( p_DATE_341A, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_341A),

186: decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FUNDING_DATE),
187: decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OBJECT_BAR_DATE),
188: decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSESSION_DATE),
189: decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISMISSAL_DATE),
190: decode( p_DATE_341A, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_341A),
191: decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISCHARGE_DATE),
192: decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WITHDRAW_DATE),
193: decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CLOSE_DATE),
194: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),

Line 191: decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISCHARGE_DATE),

187: decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OBJECT_BAR_DATE),
188: decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSESSION_DATE),
189: decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISMISSAL_DATE),
190: decode( p_DATE_341A, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_341A),
191: decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISCHARGE_DATE),
192: decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WITHDRAW_DATE),
193: decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CLOSE_DATE),
194: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
195: decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, NULL, p_MOTION_CODE),

Line 192: decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WITHDRAW_DATE),

188: decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSESSION_DATE),
189: decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISMISSAL_DATE),
190: decode( p_DATE_341A, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_341A),
191: decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISCHARGE_DATE),
192: decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WITHDRAW_DATE),
193: decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CLOSE_DATE),
194: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
195: decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, NULL, p_MOTION_CODE),
196: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),

Line 193: decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CLOSE_DATE),

189: decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISMISSAL_DATE),
190: decode( p_DATE_341A, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_341A),
191: decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISCHARGE_DATE),
192: decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WITHDRAW_DATE),
193: decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CLOSE_DATE),
194: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
195: decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, NULL, p_MOTION_CODE),
196: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
197: decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, NULL, p_CEASE_COLLECTIONS_YN),

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

190: decode( p_DATE_341A, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_341A),
191: decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISCHARGE_DATE),
192: decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WITHDRAW_DATE),
193: decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CLOSE_DATE),
194: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
195: decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, NULL, p_MOTION_CODE),
196: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
197: decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, NULL, p_CEASE_COLLECTIONS_YN),
198: decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICING_YN),

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

191: decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DISCHARGE_DATE),
192: decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WITHDRAW_DATE),
193: decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CLOSE_DATE),
194: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
195: decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, NULL, p_MOTION_CODE),
196: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
197: decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, NULL, p_CEASE_COLLECTIONS_YN),
198: decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICING_YN),
199: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

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

192: decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WITHDRAW_DATE),
193: decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CLOSE_DATE),
194: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
195: decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, NULL, p_MOTION_CODE),
196: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
197: decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, NULL, p_CEASE_COLLECTIONS_YN),
198: decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICING_YN),
199: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
200: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

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

193: decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CLOSE_DATE),
194: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
195: decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, NULL, p_MOTION_CODE),
196: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
197: decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, NULL, p_CEASE_COLLECTIONS_YN),
198: decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICING_YN),
199: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
200: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
201: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

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

194: decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
195: decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, NULL, p_MOTION_CODE),
196: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
197: decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, NULL, p_CEASE_COLLECTIONS_YN),
198: decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICING_YN),
199: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
200: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
201: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
202: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),

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

195: decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, NULL, p_MOTION_CODE),
196: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
197: decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, NULL, p_CEASE_COLLECTIONS_YN),
198: decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICING_YN),
199: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
200: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
201: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
202: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
203: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

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

196: decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
197: decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, NULL, p_CEASE_COLLECTIONS_YN),
198: decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICING_YN),
199: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
200: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
201: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
202: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
203: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
204: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

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

197: decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, NULL, p_CEASE_COLLECTIONS_YN),
198: decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICING_YN),
199: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
200: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
201: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
202: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
203: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
204: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
205: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

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

198: decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICING_YN),
199: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
200: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
201: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
202: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
203: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
204: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
205: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
206: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

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

199: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
200: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
201: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
202: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
203: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
204: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
205: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
206: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
207: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

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

200: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
201: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
202: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
203: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
204: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
205: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
206: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
207: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
208: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

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

201: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
202: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
203: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
204: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
205: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
206: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
207: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
208: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
209: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

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

202: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
203: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
204: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
205: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
206: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
207: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
208: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
209: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
210: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

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

203: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
204: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
205: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
206: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
207: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
208: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
209: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
210: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
211: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

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

204: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
205: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
206: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
207: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
208: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
209: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
210: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
211: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
212: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

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

205: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
206: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
207: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
208: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
209: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
210: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
211: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
212: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
213: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

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

206: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
207: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
208: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
209: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
210: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
211: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
212: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
213: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
214: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

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

207: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
208: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
209: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
210: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
211: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
212: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
213: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
214: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
215: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

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

208: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
209: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
210: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
211: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
212: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
213: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
214: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
215: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
216: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

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

209: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
210: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
211: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
212: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
213: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
214: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
215: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
216: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
217: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

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

210: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
211: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
212: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
213: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
214: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
215: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
216: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
217: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
218: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

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

211: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
212: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
213: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
214: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
215: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
216: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
217: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
218: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
219: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

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

212: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
213: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
214: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
215: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
216: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
217: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
218: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
219: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
220: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

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

213: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
214: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
215: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
216: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
217: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
218: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
219: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
220: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
221: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

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

214: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
215: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
216: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
217: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
218: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
219: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
220: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
221: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
222: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

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

215: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
216: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
217: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
218: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
219: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
220: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
221: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
222: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
223: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

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

216: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
217: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
218: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
219: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
220: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
221: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
222: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
223: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
224: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)

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

217: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
218: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
219: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
220: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
221: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
222: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
223: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
224: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
225: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)

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

218: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
219: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
220: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
221: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
222: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
223: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
224: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
225: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
226: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)

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

219: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
220: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
221: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
222: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
223: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
224: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
225: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
226: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
227: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)

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

220: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
221: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
222: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
223: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
224: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
225: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
226: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
227: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
228: ,decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE)

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

221: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
222: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
223: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
224: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
225: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
226: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
227: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
228: ,decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE)
229: ,decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICE_YN)

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

222: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
223: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
224: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
225: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
226: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
227: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
228: ,decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE)
229: ,decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICE_YN)
230: ,decode( p_NOTICE_ASSIGNMENT_YN, FND_API.G_MISS_CHAR, NULL, p_NOTICE_ASSIGNMENT_YN)

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

223: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
224: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
225: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
226: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
227: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
228: ,decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE)
229: ,decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICE_YN)
230: ,decode( p_NOTICE_ASSIGNMENT_YN, FND_API.G_MISS_CHAR, NULL, p_NOTICE_ASSIGNMENT_YN)
231: ,decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR, NULL, p_FILE_PROOF_CLAIM_YN)

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

224: ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
225: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
226: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
227: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
228: ,decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE)
229: ,decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICE_YN)
230: ,decode( p_NOTICE_ASSIGNMENT_YN, FND_API.G_MISS_CHAR, NULL, p_NOTICE_ASSIGNMENT_YN)
231: ,decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR, NULL, p_FILE_PROOF_CLAIM_YN)
232: ,decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR, NULL, p_REQUEST_REPURCHASE_YN)

Line 229: ,decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICE_YN)

225: ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
226: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
227: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
228: ,decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE)
229: ,decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICE_YN)
230: ,decode( p_NOTICE_ASSIGNMENT_YN, FND_API.G_MISS_CHAR, NULL, p_NOTICE_ASSIGNMENT_YN)
231: ,decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR, NULL, p_FILE_PROOF_CLAIM_YN)
232: ,decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR, NULL, p_REQUEST_REPURCHASE_YN)
233: ,decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FEE_PAID_DATE)

Line 230: ,decode( p_NOTICE_ASSIGNMENT_YN, FND_API.G_MISS_CHAR, NULL, p_NOTICE_ASSIGNMENT_YN)

226: ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
227: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
228: ,decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE)
229: ,decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICE_YN)
230: ,decode( p_NOTICE_ASSIGNMENT_YN, FND_API.G_MISS_CHAR, NULL, p_NOTICE_ASSIGNMENT_YN)
231: ,decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR, NULL, p_FILE_PROOF_CLAIM_YN)
232: ,decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR, NULL, p_REQUEST_REPURCHASE_YN)
233: ,decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FEE_PAID_DATE)
234: ,decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REAFFIRMATION_DATE)

Line 231: ,decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR, NULL, p_FILE_PROOF_CLAIM_YN)

227: ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
228: ,decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE)
229: ,decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICE_YN)
230: ,decode( p_NOTICE_ASSIGNMENT_YN, FND_API.G_MISS_CHAR, NULL, p_NOTICE_ASSIGNMENT_YN)
231: ,decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR, NULL, p_FILE_PROOF_CLAIM_YN)
232: ,decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR, NULL, p_REQUEST_REPURCHASE_YN)
233: ,decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FEE_PAID_DATE)
234: ,decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REAFFIRMATION_DATE)
235: ,decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RELIEF_STAY_DATE)

Line 232: ,decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR, NULL, p_REQUEST_REPURCHASE_YN)

228: ,decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE)
229: ,decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICE_YN)
230: ,decode( p_NOTICE_ASSIGNMENT_YN, FND_API.G_MISS_CHAR, NULL, p_NOTICE_ASSIGNMENT_YN)
231: ,decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR, NULL, p_FILE_PROOF_CLAIM_YN)
232: ,decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR, NULL, p_REQUEST_REPURCHASE_YN)
233: ,decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FEE_PAID_DATE)
234: ,decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REAFFIRMATION_DATE)
235: ,decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RELIEF_STAY_DATE)
236: ,decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FILE_CONTACT_ID)

Line 233: ,decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FEE_PAID_DATE)

229: ,decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR, NULL, p_TURN_OFF_INVOICE_YN)
230: ,decode( p_NOTICE_ASSIGNMENT_YN, FND_API.G_MISS_CHAR, NULL, p_NOTICE_ASSIGNMENT_YN)
231: ,decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR, NULL, p_FILE_PROOF_CLAIM_YN)
232: ,decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR, NULL, p_REQUEST_REPURCHASE_YN)
233: ,decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FEE_PAID_DATE)
234: ,decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REAFFIRMATION_DATE)
235: ,decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RELIEF_STAY_DATE)
236: ,decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FILE_CONTACT_ID)
237: ,decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CASE_NUMBER)

Line 234: ,decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REAFFIRMATION_DATE)

230: ,decode( p_NOTICE_ASSIGNMENT_YN, FND_API.G_MISS_CHAR, NULL, p_NOTICE_ASSIGNMENT_YN)
231: ,decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR, NULL, p_FILE_PROOF_CLAIM_YN)
232: ,decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR, NULL, p_REQUEST_REPURCHASE_YN)
233: ,decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FEE_PAID_DATE)
234: ,decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REAFFIRMATION_DATE)
235: ,decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RELIEF_STAY_DATE)
236: ,decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FILE_CONTACT_ID)
237: ,decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CASE_NUMBER)
238: );

Line 235: ,decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RELIEF_STAY_DATE)

231: ,decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR, NULL, p_FILE_PROOF_CLAIM_YN)
232: ,decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR, NULL, p_REQUEST_REPURCHASE_YN)
233: ,decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FEE_PAID_DATE)
234: ,decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REAFFIRMATION_DATE)
235: ,decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RELIEF_STAY_DATE)
236: ,decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FILE_CONTACT_ID)
237: ,decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CASE_NUMBER)
238: );
239: open c;

Line 236: ,decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FILE_CONTACT_ID)

232: ,decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR, NULL, p_REQUEST_REPURCHASE_YN)
233: ,decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FEE_PAID_DATE)
234: ,decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REAFFIRMATION_DATE)
235: ,decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RELIEF_STAY_DATE)
236: ,decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FILE_CONTACT_ID)
237: ,decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CASE_NUMBER)
238: );
239: open c;
240: fetch c into X_ROWID;

Line 237: ,decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CASE_NUMBER)

233: ,decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_FEE_PAID_DATE)
234: ,decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REAFFIRMATION_DATE)
235: ,decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RELIEF_STAY_DATE)
236: ,decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_FILE_CONTACT_ID)
237: ,decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CASE_NUMBER)
238: );
239: open c;
240: fetch c into X_ROWID;
241: -- IF PG_DEBUG < 10 THEN

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

332: IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_BANKRUPTCIES_PKG.UPDATE_ROW ******** ');
333: END IF;
334: Update IEX_BANKRUPTCIES
335: SET
336: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
337: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
338: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
339: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
340: TRUSTEE_CONTACT_ID = decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, TRUSTEE_CONTACT_ID, p_TRUSTEE_CONTACT_ID),

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

333: END IF;
334: Update IEX_BANKRUPTCIES
335: SET
336: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
337: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
338: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
339: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
340: TRUSTEE_CONTACT_ID = decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, TRUSTEE_CONTACT_ID, p_TRUSTEE_CONTACT_ID),
341: COURT_ID = decode( p_COURT_ID, FND_API.G_MISS_NUM, COURT_ID, p_COURT_ID),

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

334: Update IEX_BANKRUPTCIES
335: SET
336: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
337: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
338: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
339: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
340: TRUSTEE_CONTACT_ID = decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, TRUSTEE_CONTACT_ID, p_TRUSTEE_CONTACT_ID),
341: COURT_ID = decode( p_COURT_ID, FND_API.G_MISS_NUM, COURT_ID, p_COURT_ID),
342: FIRM_CONTACT_ID = decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, FIRM_CONTACT_ID, p_FIRM_CONTACT_ID),

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

335: SET
336: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
337: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
338: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
339: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
340: TRUSTEE_CONTACT_ID = decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, TRUSTEE_CONTACT_ID, p_TRUSTEE_CONTACT_ID),
341: COURT_ID = decode( p_COURT_ID, FND_API.G_MISS_NUM, COURT_ID, p_COURT_ID),
342: FIRM_CONTACT_ID = decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, FIRM_CONTACT_ID, p_FIRM_CONTACT_ID),
343: COUNSEL_CONTACT_ID = decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, COUNSEL_CONTACT_ID, p_COUNSEL_CONTACT_ID),

Line 340: TRUSTEE_CONTACT_ID = decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, TRUSTEE_CONTACT_ID, p_TRUSTEE_CONTACT_ID),

336: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
337: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
338: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
339: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
340: TRUSTEE_CONTACT_ID = decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, TRUSTEE_CONTACT_ID, p_TRUSTEE_CONTACT_ID),
341: COURT_ID = decode( p_COURT_ID, FND_API.G_MISS_NUM, COURT_ID, p_COURT_ID),
342: FIRM_CONTACT_ID = decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, FIRM_CONTACT_ID, p_FIRM_CONTACT_ID),
343: COUNSEL_CONTACT_ID = decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, COUNSEL_CONTACT_ID, p_COUNSEL_CONTACT_ID),
344: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),

Line 341: COURT_ID = decode( p_COURT_ID, FND_API.G_MISS_NUM, COURT_ID, p_COURT_ID),

337: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
338: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
339: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
340: TRUSTEE_CONTACT_ID = decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, TRUSTEE_CONTACT_ID, p_TRUSTEE_CONTACT_ID),
341: COURT_ID = decode( p_COURT_ID, FND_API.G_MISS_NUM, COURT_ID, p_COURT_ID),
342: FIRM_CONTACT_ID = decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, FIRM_CONTACT_ID, p_FIRM_CONTACT_ID),
343: COUNSEL_CONTACT_ID = decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, COUNSEL_CONTACT_ID, p_COUNSEL_CONTACT_ID),
344: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
345: CHAPTER_CODE= decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, CHAPTER_CODE, p_CHAPTER_CODE),

Line 342: FIRM_CONTACT_ID = decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, FIRM_CONTACT_ID, p_FIRM_CONTACT_ID),

338: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
339: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
340: TRUSTEE_CONTACT_ID = decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, TRUSTEE_CONTACT_ID, p_TRUSTEE_CONTACT_ID),
341: COURT_ID = decode( p_COURT_ID, FND_API.G_MISS_NUM, COURT_ID, p_COURT_ID),
342: FIRM_CONTACT_ID = decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, FIRM_CONTACT_ID, p_FIRM_CONTACT_ID),
343: COUNSEL_CONTACT_ID = decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, COUNSEL_CONTACT_ID, p_COUNSEL_CONTACT_ID),
344: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
345: CHAPTER_CODE= decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, CHAPTER_CODE, p_CHAPTER_CODE),
346: ASSET_AMOUNT = decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, ASSET_AMOUNT, p_ASSET_AMOUNT),

Line 343: COUNSEL_CONTACT_ID = decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, COUNSEL_CONTACT_ID, p_COUNSEL_CONTACT_ID),

339: ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
340: TRUSTEE_CONTACT_ID = decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, TRUSTEE_CONTACT_ID, p_TRUSTEE_CONTACT_ID),
341: COURT_ID = decode( p_COURT_ID, FND_API.G_MISS_NUM, COURT_ID, p_COURT_ID),
342: FIRM_CONTACT_ID = decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, FIRM_CONTACT_ID, p_FIRM_CONTACT_ID),
343: COUNSEL_CONTACT_ID = decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, COUNSEL_CONTACT_ID, p_COUNSEL_CONTACT_ID),
344: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
345: CHAPTER_CODE= decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, CHAPTER_CODE, p_CHAPTER_CODE),
346: ASSET_AMOUNT = decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, ASSET_AMOUNT, p_ASSET_AMOUNT),
347: ASSET_CURRENCY_CODE = decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, ASSET_CURRENCY_CODE, p_ASSET_CURRENCY_CODE),

Line 344: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),

340: TRUSTEE_CONTACT_ID = decode( p_TRUSTEE_CONTACT_ID, FND_API.G_MISS_NUM, TRUSTEE_CONTACT_ID, p_TRUSTEE_CONTACT_ID),
341: COURT_ID = decode( p_COURT_ID, FND_API.G_MISS_NUM, COURT_ID, p_COURT_ID),
342: FIRM_CONTACT_ID = decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, FIRM_CONTACT_ID, p_FIRM_CONTACT_ID),
343: COUNSEL_CONTACT_ID = decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, COUNSEL_CONTACT_ID, p_COUNSEL_CONTACT_ID),
344: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
345: CHAPTER_CODE= decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, CHAPTER_CODE, p_CHAPTER_CODE),
346: ASSET_AMOUNT = decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, ASSET_AMOUNT, p_ASSET_AMOUNT),
347: ASSET_CURRENCY_CODE = decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, ASSET_CURRENCY_CODE, p_ASSET_CURRENCY_CODE),
348: PAYOFF_AMOUNT = decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, PAYOFF_AMOUNT, p_PAYOFF_AMOUNT),

Line 345: CHAPTER_CODE= decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, CHAPTER_CODE, p_CHAPTER_CODE),

341: COURT_ID = decode( p_COURT_ID, FND_API.G_MISS_NUM, COURT_ID, p_COURT_ID),
342: FIRM_CONTACT_ID = decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, FIRM_CONTACT_ID, p_FIRM_CONTACT_ID),
343: COUNSEL_CONTACT_ID = decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, COUNSEL_CONTACT_ID, p_COUNSEL_CONTACT_ID),
344: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
345: CHAPTER_CODE= decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, CHAPTER_CODE, p_CHAPTER_CODE),
346: ASSET_AMOUNT = decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, ASSET_AMOUNT, p_ASSET_AMOUNT),
347: ASSET_CURRENCY_CODE = decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, ASSET_CURRENCY_CODE, p_ASSET_CURRENCY_CODE),
348: PAYOFF_AMOUNT = decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, PAYOFF_AMOUNT, p_PAYOFF_AMOUNT),
349: PAYOFF_CURRENCY_CODE = decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYOFF_CURRENCY_CODE, p_PAYOFF_CURRENCY_CODE),

Line 346: ASSET_AMOUNT = decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, ASSET_AMOUNT, p_ASSET_AMOUNT),

342: FIRM_CONTACT_ID = decode( p_FIRM_CONTACT_ID, FND_API.G_MISS_NUM, FIRM_CONTACT_ID, p_FIRM_CONTACT_ID),
343: COUNSEL_CONTACT_ID = decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, COUNSEL_CONTACT_ID, p_COUNSEL_CONTACT_ID),
344: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
345: CHAPTER_CODE= decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, CHAPTER_CODE, p_CHAPTER_CODE),
346: ASSET_AMOUNT = decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, ASSET_AMOUNT, p_ASSET_AMOUNT),
347: ASSET_CURRENCY_CODE = decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, ASSET_CURRENCY_CODE, p_ASSET_CURRENCY_CODE),
348: PAYOFF_AMOUNT = decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, PAYOFF_AMOUNT, p_PAYOFF_AMOUNT),
349: PAYOFF_CURRENCY_CODE = decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYOFF_CURRENCY_CODE, p_PAYOFF_CURRENCY_CODE),
350: BANKRUPTCY_FILE_DATE = decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, BANKRUPTCY_FILE_DATE, p_BANKRUPTCY_FILE_DATE),

Line 347: ASSET_CURRENCY_CODE = decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, ASSET_CURRENCY_CODE, p_ASSET_CURRENCY_CODE),

343: COUNSEL_CONTACT_ID = decode( p_COUNSEL_CONTACT_ID, FND_API.G_MISS_NUM, COUNSEL_CONTACT_ID, p_COUNSEL_CONTACT_ID),
344: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
345: CHAPTER_CODE= decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, CHAPTER_CODE, p_CHAPTER_CODE),
346: ASSET_AMOUNT = decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, ASSET_AMOUNT, p_ASSET_AMOUNT),
347: ASSET_CURRENCY_CODE = decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, ASSET_CURRENCY_CODE, p_ASSET_CURRENCY_CODE),
348: PAYOFF_AMOUNT = decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, PAYOFF_AMOUNT, p_PAYOFF_AMOUNT),
349: PAYOFF_CURRENCY_CODE = decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYOFF_CURRENCY_CODE, p_PAYOFF_CURRENCY_CODE),
350: BANKRUPTCY_FILE_DATE = decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, BANKRUPTCY_FILE_DATE, p_BANKRUPTCY_FILE_DATE),
351: COURT_ORDER_DATE = decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, COURT_ORDER_DATE, p_COURT_ORDER_DATE),

Line 348: PAYOFF_AMOUNT = decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, PAYOFF_AMOUNT, p_PAYOFF_AMOUNT),

344: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
345: CHAPTER_CODE= decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, CHAPTER_CODE, p_CHAPTER_CODE),
346: ASSET_AMOUNT = decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, ASSET_AMOUNT, p_ASSET_AMOUNT),
347: ASSET_CURRENCY_CODE = decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, ASSET_CURRENCY_CODE, p_ASSET_CURRENCY_CODE),
348: PAYOFF_AMOUNT = decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, PAYOFF_AMOUNT, p_PAYOFF_AMOUNT),
349: PAYOFF_CURRENCY_CODE = decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYOFF_CURRENCY_CODE, p_PAYOFF_CURRENCY_CODE),
350: BANKRUPTCY_FILE_DATE = decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, BANKRUPTCY_FILE_DATE, p_BANKRUPTCY_FILE_DATE),
351: COURT_ORDER_DATE = decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, COURT_ORDER_DATE, p_COURT_ORDER_DATE),
352: FUNDING_DATE = decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, FUNDING_DATE, p_FUNDING_DATE),

Line 349: PAYOFF_CURRENCY_CODE = decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYOFF_CURRENCY_CODE, p_PAYOFF_CURRENCY_CODE),

345: CHAPTER_CODE= decode( p_CHAPTER_CODE, FND_API.G_MISS_CHAR, CHAPTER_CODE, p_CHAPTER_CODE),
346: ASSET_AMOUNT = decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, ASSET_AMOUNT, p_ASSET_AMOUNT),
347: ASSET_CURRENCY_CODE = decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, ASSET_CURRENCY_CODE, p_ASSET_CURRENCY_CODE),
348: PAYOFF_AMOUNT = decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, PAYOFF_AMOUNT, p_PAYOFF_AMOUNT),
349: PAYOFF_CURRENCY_CODE = decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYOFF_CURRENCY_CODE, p_PAYOFF_CURRENCY_CODE),
350: BANKRUPTCY_FILE_DATE = decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, BANKRUPTCY_FILE_DATE, p_BANKRUPTCY_FILE_DATE),
351: COURT_ORDER_DATE = decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, COURT_ORDER_DATE, p_COURT_ORDER_DATE),
352: FUNDING_DATE = decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, FUNDING_DATE, p_FUNDING_DATE),
353: OBJECT_BAR_DATE = decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, OBJECT_BAR_DATE, p_OBJECT_BAR_DATE),

Line 350: BANKRUPTCY_FILE_DATE = decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, BANKRUPTCY_FILE_DATE, p_BANKRUPTCY_FILE_DATE),

346: ASSET_AMOUNT = decode( p_ASSET_AMOUNT, FND_API.G_MISS_NUM, ASSET_AMOUNT, p_ASSET_AMOUNT),
347: ASSET_CURRENCY_CODE = decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, ASSET_CURRENCY_CODE, p_ASSET_CURRENCY_CODE),
348: PAYOFF_AMOUNT = decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, PAYOFF_AMOUNT, p_PAYOFF_AMOUNT),
349: PAYOFF_CURRENCY_CODE = decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYOFF_CURRENCY_CODE, p_PAYOFF_CURRENCY_CODE),
350: BANKRUPTCY_FILE_DATE = decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, BANKRUPTCY_FILE_DATE, p_BANKRUPTCY_FILE_DATE),
351: COURT_ORDER_DATE = decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, COURT_ORDER_DATE, p_COURT_ORDER_DATE),
352: FUNDING_DATE = decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, FUNDING_DATE, p_FUNDING_DATE),
353: OBJECT_BAR_DATE = decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, OBJECT_BAR_DATE, p_OBJECT_BAR_DATE),
354: REPOSSESSION_DATE = decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, REPOSSESSION_DATE, p_REPOSSESSION_DATE),

Line 351: COURT_ORDER_DATE = decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, COURT_ORDER_DATE, p_COURT_ORDER_DATE),

347: ASSET_CURRENCY_CODE = decode( p_ASSET_CURRENCY_CODE, FND_API.G_MISS_CHAR, ASSET_CURRENCY_CODE, p_ASSET_CURRENCY_CODE),
348: PAYOFF_AMOUNT = decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, PAYOFF_AMOUNT, p_PAYOFF_AMOUNT),
349: PAYOFF_CURRENCY_CODE = decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYOFF_CURRENCY_CODE, p_PAYOFF_CURRENCY_CODE),
350: BANKRUPTCY_FILE_DATE = decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, BANKRUPTCY_FILE_DATE, p_BANKRUPTCY_FILE_DATE),
351: COURT_ORDER_DATE = decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, COURT_ORDER_DATE, p_COURT_ORDER_DATE),
352: FUNDING_DATE = decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, FUNDING_DATE, p_FUNDING_DATE),
353: OBJECT_BAR_DATE = decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, OBJECT_BAR_DATE, p_OBJECT_BAR_DATE),
354: REPOSSESSION_DATE = decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, REPOSSESSION_DATE, p_REPOSSESSION_DATE),
355: DISMISSAL_DATE = decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, DISMISSAL_DATE, p_DISMISSAL_DATE),

Line 352: FUNDING_DATE = decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, FUNDING_DATE, p_FUNDING_DATE),

348: PAYOFF_AMOUNT = decode( p_PAYOFF_AMOUNT, FND_API.G_MISS_NUM, PAYOFF_AMOUNT, p_PAYOFF_AMOUNT),
349: PAYOFF_CURRENCY_CODE = decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYOFF_CURRENCY_CODE, p_PAYOFF_CURRENCY_CODE),
350: BANKRUPTCY_FILE_DATE = decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, BANKRUPTCY_FILE_DATE, p_BANKRUPTCY_FILE_DATE),
351: COURT_ORDER_DATE = decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, COURT_ORDER_DATE, p_COURT_ORDER_DATE),
352: FUNDING_DATE = decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, FUNDING_DATE, p_FUNDING_DATE),
353: OBJECT_BAR_DATE = decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, OBJECT_BAR_DATE, p_OBJECT_BAR_DATE),
354: REPOSSESSION_DATE = decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, REPOSSESSION_DATE, p_REPOSSESSION_DATE),
355: DISMISSAL_DATE = decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, DISMISSAL_DATE, p_DISMISSAL_DATE),
356: DATE_341A = decode( p_DATE_341A, FND_API.G_MISS_DATE, DATE_341A, p_DATE_341A),

Line 353: OBJECT_BAR_DATE = decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, OBJECT_BAR_DATE, p_OBJECT_BAR_DATE),

349: PAYOFF_CURRENCY_CODE = decode( p_PAYOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYOFF_CURRENCY_CODE, p_PAYOFF_CURRENCY_CODE),
350: BANKRUPTCY_FILE_DATE = decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, BANKRUPTCY_FILE_DATE, p_BANKRUPTCY_FILE_DATE),
351: COURT_ORDER_DATE = decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, COURT_ORDER_DATE, p_COURT_ORDER_DATE),
352: FUNDING_DATE = decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, FUNDING_DATE, p_FUNDING_DATE),
353: OBJECT_BAR_DATE = decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, OBJECT_BAR_DATE, p_OBJECT_BAR_DATE),
354: REPOSSESSION_DATE = decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, REPOSSESSION_DATE, p_REPOSSESSION_DATE),
355: DISMISSAL_DATE = decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, DISMISSAL_DATE, p_DISMISSAL_DATE),
356: DATE_341A = decode( p_DATE_341A, FND_API.G_MISS_DATE, DATE_341A, p_DATE_341A),
357: DISCHARGE_DATE = decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, DISCHARGE_DATE, p_DISCHARGE_DATE),

Line 354: REPOSSESSION_DATE = decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, REPOSSESSION_DATE, p_REPOSSESSION_DATE),

350: BANKRUPTCY_FILE_DATE = decode( p_BANKRUPTCY_FILE_DATE, FND_API.G_MISS_DATE, BANKRUPTCY_FILE_DATE, p_BANKRUPTCY_FILE_DATE),
351: COURT_ORDER_DATE = decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, COURT_ORDER_DATE, p_COURT_ORDER_DATE),
352: FUNDING_DATE = decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, FUNDING_DATE, p_FUNDING_DATE),
353: OBJECT_BAR_DATE = decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, OBJECT_BAR_DATE, p_OBJECT_BAR_DATE),
354: REPOSSESSION_DATE = decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, REPOSSESSION_DATE, p_REPOSSESSION_DATE),
355: DISMISSAL_DATE = decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, DISMISSAL_DATE, p_DISMISSAL_DATE),
356: DATE_341A = decode( p_DATE_341A, FND_API.G_MISS_DATE, DATE_341A, p_DATE_341A),
357: DISCHARGE_DATE = decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, DISCHARGE_DATE, p_DISCHARGE_DATE),
358: WITHDRAW_DATE = decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, WITHDRAW_DATE, p_WITHDRAW_DATE),

Line 355: DISMISSAL_DATE = decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, DISMISSAL_DATE, p_DISMISSAL_DATE),

351: COURT_ORDER_DATE = decode( p_COURT_ORDER_DATE, FND_API.G_MISS_DATE, COURT_ORDER_DATE, p_COURT_ORDER_DATE),
352: FUNDING_DATE = decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, FUNDING_DATE, p_FUNDING_DATE),
353: OBJECT_BAR_DATE = decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, OBJECT_BAR_DATE, p_OBJECT_BAR_DATE),
354: REPOSSESSION_DATE = decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, REPOSSESSION_DATE, p_REPOSSESSION_DATE),
355: DISMISSAL_DATE = decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, DISMISSAL_DATE, p_DISMISSAL_DATE),
356: DATE_341A = decode( p_DATE_341A, FND_API.G_MISS_DATE, DATE_341A, p_DATE_341A),
357: DISCHARGE_DATE = decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, DISCHARGE_DATE, p_DISCHARGE_DATE),
358: WITHDRAW_DATE = decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, WITHDRAW_DATE, p_WITHDRAW_DATE),
359: CLOSE_DATE = decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, CLOSE_DATE, p_CLOSE_DATE),

Line 356: DATE_341A = decode( p_DATE_341A, FND_API.G_MISS_DATE, DATE_341A, p_DATE_341A),

352: FUNDING_DATE = decode( p_FUNDING_DATE, FND_API.G_MISS_DATE, FUNDING_DATE, p_FUNDING_DATE),
353: OBJECT_BAR_DATE = decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, OBJECT_BAR_DATE, p_OBJECT_BAR_DATE),
354: REPOSSESSION_DATE = decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, REPOSSESSION_DATE, p_REPOSSESSION_DATE),
355: DISMISSAL_DATE = decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, DISMISSAL_DATE, p_DISMISSAL_DATE),
356: DATE_341A = decode( p_DATE_341A, FND_API.G_MISS_DATE, DATE_341A, p_DATE_341A),
357: DISCHARGE_DATE = decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, DISCHARGE_DATE, p_DISCHARGE_DATE),
358: WITHDRAW_DATE = decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, WITHDRAW_DATE, p_WITHDRAW_DATE),
359: CLOSE_DATE = decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, CLOSE_DATE, p_CLOSE_DATE),
360: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),

Line 357: DISCHARGE_DATE = decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, DISCHARGE_DATE, p_DISCHARGE_DATE),

353: OBJECT_BAR_DATE = decode( p_OBJECT_BAR_DATE, FND_API.G_MISS_DATE, OBJECT_BAR_DATE, p_OBJECT_BAR_DATE),
354: REPOSSESSION_DATE = decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, REPOSSESSION_DATE, p_REPOSSESSION_DATE),
355: DISMISSAL_DATE = decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, DISMISSAL_DATE, p_DISMISSAL_DATE),
356: DATE_341A = decode( p_DATE_341A, FND_API.G_MISS_DATE, DATE_341A, p_DATE_341A),
357: DISCHARGE_DATE = decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, DISCHARGE_DATE, p_DISCHARGE_DATE),
358: WITHDRAW_DATE = decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, WITHDRAW_DATE, p_WITHDRAW_DATE),
359: CLOSE_DATE = decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, CLOSE_DATE, p_CLOSE_DATE),
360: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
361: MOTION_CODE = decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, MOTION_CODE, p_MOTION_CODE),

Line 358: WITHDRAW_DATE = decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, WITHDRAW_DATE, p_WITHDRAW_DATE),

354: REPOSSESSION_DATE = decode( p_REPOSSESSION_DATE, FND_API.G_MISS_DATE, REPOSSESSION_DATE, p_REPOSSESSION_DATE),
355: DISMISSAL_DATE = decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, DISMISSAL_DATE, p_DISMISSAL_DATE),
356: DATE_341A = decode( p_DATE_341A, FND_API.G_MISS_DATE, DATE_341A, p_DATE_341A),
357: DISCHARGE_DATE = decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, DISCHARGE_DATE, p_DISCHARGE_DATE),
358: WITHDRAW_DATE = decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, WITHDRAW_DATE, p_WITHDRAW_DATE),
359: CLOSE_DATE = decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, CLOSE_DATE, p_CLOSE_DATE),
360: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
361: MOTION_CODE = decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, MOTION_CODE, p_MOTION_CODE),
362: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),

Line 359: CLOSE_DATE = decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, CLOSE_DATE, p_CLOSE_DATE),

355: DISMISSAL_DATE = decode( p_DISMISSAL_DATE, FND_API.G_MISS_DATE, DISMISSAL_DATE, p_DISMISSAL_DATE),
356: DATE_341A = decode( p_DATE_341A, FND_API.G_MISS_DATE, DATE_341A, p_DATE_341A),
357: DISCHARGE_DATE = decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, DISCHARGE_DATE, p_DISCHARGE_DATE),
358: WITHDRAW_DATE = decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, WITHDRAW_DATE, p_WITHDRAW_DATE),
359: CLOSE_DATE = decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, CLOSE_DATE, p_CLOSE_DATE),
360: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
361: MOTION_CODE = decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, MOTION_CODE, p_MOTION_CODE),
362: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
363: CEASE_COLLECTIONS_YN = decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, CEASE_COLLECTIONS_YN, p_CEASE_COLLECTIONS_YN),

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

356: DATE_341A = decode( p_DATE_341A, FND_API.G_MISS_DATE, DATE_341A, p_DATE_341A),
357: DISCHARGE_DATE = decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, DISCHARGE_DATE, p_DISCHARGE_DATE),
358: WITHDRAW_DATE = decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, WITHDRAW_DATE, p_WITHDRAW_DATE),
359: CLOSE_DATE = decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, CLOSE_DATE, p_CLOSE_DATE),
360: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
361: MOTION_CODE = decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, MOTION_CODE, p_MOTION_CODE),
362: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
363: CEASE_COLLECTIONS_YN = decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, CEASE_COLLECTIONS_YN, p_CEASE_COLLECTIONS_YN),
364: TURN_OFF_INVOICING_YN = decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, TURN_OFF_INVOICING_YN, p_TURN_OFF_INVOICING_YN),

Line 361: MOTION_CODE = decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, MOTION_CODE, p_MOTION_CODE),

357: DISCHARGE_DATE = decode( p_DISCHARGE_DATE, FND_API.G_MISS_DATE, DISCHARGE_DATE, p_DISCHARGE_DATE),
358: WITHDRAW_DATE = decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, WITHDRAW_DATE, p_WITHDRAW_DATE),
359: CLOSE_DATE = decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, CLOSE_DATE, p_CLOSE_DATE),
360: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
361: MOTION_CODE = decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, MOTION_CODE, p_MOTION_CODE),
362: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
363: CEASE_COLLECTIONS_YN = decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, CEASE_COLLECTIONS_YN, p_CEASE_COLLECTIONS_YN),
364: TURN_OFF_INVOICING_YN = decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, TURN_OFF_INVOICING_YN, p_TURN_OFF_INVOICING_YN),
365: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

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

358: WITHDRAW_DATE = decode( p_WITHDRAW_DATE, FND_API.G_MISS_DATE, WITHDRAW_DATE, p_WITHDRAW_DATE),
359: CLOSE_DATE = decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, CLOSE_DATE, p_CLOSE_DATE),
360: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
361: MOTION_CODE = decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, MOTION_CODE, p_MOTION_CODE),
362: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
363: CEASE_COLLECTIONS_YN = decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, CEASE_COLLECTIONS_YN, p_CEASE_COLLECTIONS_YN),
364: TURN_OFF_INVOICING_YN = decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, TURN_OFF_INVOICING_YN, p_TURN_OFF_INVOICING_YN),
365: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
366: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

Line 363: CEASE_COLLECTIONS_YN = decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, CEASE_COLLECTIONS_YN, p_CEASE_COLLECTIONS_YN),

359: CLOSE_DATE = decode( p_CLOSE_DATE, FND_API.G_MISS_DATE, CLOSE_DATE, p_CLOSE_DATE),
360: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
361: MOTION_CODE = decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, MOTION_CODE, p_MOTION_CODE),
362: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
363: CEASE_COLLECTIONS_YN = decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, CEASE_COLLECTIONS_YN, p_CEASE_COLLECTIONS_YN),
364: TURN_OFF_INVOICING_YN = decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, TURN_OFF_INVOICING_YN, p_TURN_OFF_INVOICING_YN),
365: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
366: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
367: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

Line 364: TURN_OFF_INVOICING_YN = decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, TURN_OFF_INVOICING_YN, p_TURN_OFF_INVOICING_YN),

360: PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
361: MOTION_CODE = decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, MOTION_CODE, p_MOTION_CODE),
362: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
363: CEASE_COLLECTIONS_YN = decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, CEASE_COLLECTIONS_YN, p_CEASE_COLLECTIONS_YN),
364: TURN_OFF_INVOICING_YN = decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, TURN_OFF_INVOICING_YN, p_TURN_OFF_INVOICING_YN),
365: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
366: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
367: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
368: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

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

361: MOTION_CODE = decode( p_MOTION_CODE, FND_API.G_MISS_CHAR, MOTION_CODE, p_MOTION_CODE),
362: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
363: CEASE_COLLECTIONS_YN = decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, CEASE_COLLECTIONS_YN, p_CEASE_COLLECTIONS_YN),
364: TURN_OFF_INVOICING_YN = decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, TURN_OFF_INVOICING_YN, p_TURN_OFF_INVOICING_YN),
365: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
366: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
367: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
368: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
369: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

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

362: CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
363: CEASE_COLLECTIONS_YN = decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, CEASE_COLLECTIONS_YN, p_CEASE_COLLECTIONS_YN),
364: TURN_OFF_INVOICING_YN = decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, TURN_OFF_INVOICING_YN, p_TURN_OFF_INVOICING_YN),
365: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
366: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
367: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
368: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
369: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
370: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

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

363: CEASE_COLLECTIONS_YN = decode( p_CEASE_COLLECTIONS_YN, FND_API.G_MISS_CHAR, CEASE_COLLECTIONS_YN, p_CEASE_COLLECTIONS_YN),
364: TURN_OFF_INVOICING_YN = decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, TURN_OFF_INVOICING_YN, p_TURN_OFF_INVOICING_YN),
365: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
366: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
367: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
368: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
369: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
370: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
371: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

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

364: TURN_OFF_INVOICING_YN = decode( p_TURN_OFF_INVOICING_YN, FND_API.G_MISS_CHAR, TURN_OFF_INVOICING_YN, p_TURN_OFF_INVOICING_YN),
365: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
366: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
367: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
368: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
369: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
370: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
371: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
372: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

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

365: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
366: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
367: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
368: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
369: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
370: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
371: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
372: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
373: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

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

366: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
367: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
368: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
369: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
370: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
371: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
372: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
373: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
374: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

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

367: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
368: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
369: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
370: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
371: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
372: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
373: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
374: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
375: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

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

368: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
369: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
370: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
371: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
372: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
373: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
374: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
375: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
376: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

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

369: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
370: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
371: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
372: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
373: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
374: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
375: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
376: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
377: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

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

370: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
371: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
372: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
373: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
374: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
375: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
376: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
377: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
378: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

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

371: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
372: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
373: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
374: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
375: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
376: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
377: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
378: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
379: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

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

372: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
373: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
374: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
375: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
376: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
377: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
378: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
379: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
380: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

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

373: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
374: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
375: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
376: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
377: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
378: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
379: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
380: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
381: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

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

374: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
375: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
376: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
377: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
378: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
379: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
380: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
381: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
382: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

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

375: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
376: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
377: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
378: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
379: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
380: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
381: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
382: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
383: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

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

376: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
377: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
378: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
379: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
380: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
381: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
382: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
383: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
384: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

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

377: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
378: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
379: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
380: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
381: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
382: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
383: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
384: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
385: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

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

378: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
379: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
380: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
381: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
382: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
383: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
384: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
385: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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

379: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
380: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
381: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
382: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
383: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
384: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
385: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
387: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

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

380: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
381: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
382: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
383: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
384: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
385: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
387: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
388: ,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 385: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

381: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
382: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
383: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
384: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
385: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
387: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
388: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
389: ,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 386: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

382: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
383: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
384: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
385: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
387: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
388: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
389: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
390: ,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 387: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

383: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
384: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
385: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
387: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
388: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
389: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
390: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
391: ,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 388: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)

384: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
385: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
387: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
388: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
389: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
390: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
391: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
392: ,DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, p_DISPOSITION_CODE)

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

385: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
387: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
388: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
389: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
390: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
391: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
392: ,DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, p_DISPOSITION_CODE)
393: ,TURN_OFF_INVOICE_YN = decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR,TURN_OFF_INVOICE_YN,p_TURN_OFF_INVOICE_YN)

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

386: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
387: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
388: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
389: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
390: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
391: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
392: ,DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, p_DISPOSITION_CODE)
393: ,TURN_OFF_INVOICE_YN = decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR,TURN_OFF_INVOICE_YN,p_TURN_OFF_INVOICE_YN)
394: ,NOTICE_ASSIGNMENT_YN = decode( p_NOTICE_ASSIGNMENT_YN,FND_API.G_MISS_CHAR,NOTICE_ASSIGNMENT_YN,p_NOTICE_ASSIGNMENT_YN)

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

387: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
388: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
389: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
390: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
391: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
392: ,DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, p_DISPOSITION_CODE)
393: ,TURN_OFF_INVOICE_YN = decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR,TURN_OFF_INVOICE_YN,p_TURN_OFF_INVOICE_YN)
394: ,NOTICE_ASSIGNMENT_YN = decode( p_NOTICE_ASSIGNMENT_YN,FND_API.G_MISS_CHAR,NOTICE_ASSIGNMENT_YN,p_NOTICE_ASSIGNMENT_YN)
395: ,FILE_PROOF_CLAIM_YN = decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR,FILE_PROOF_CLAIM_YN, p_FILE_PROOF_CLAIM_YN)

Line 392: ,DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, p_DISPOSITION_CODE)

388: ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
389: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
390: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
391: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
392: ,DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, p_DISPOSITION_CODE)
393: ,TURN_OFF_INVOICE_YN = decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR,TURN_OFF_INVOICE_YN,p_TURN_OFF_INVOICE_YN)
394: ,NOTICE_ASSIGNMENT_YN = decode( p_NOTICE_ASSIGNMENT_YN,FND_API.G_MISS_CHAR,NOTICE_ASSIGNMENT_YN,p_NOTICE_ASSIGNMENT_YN)
395: ,FILE_PROOF_CLAIM_YN = decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR,FILE_PROOF_CLAIM_YN, p_FILE_PROOF_CLAIM_YN)
396: ,REQUEST_REPURCHASE_YN = decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR,REQUEST_REPURCHASE_YN, p_REQUEST_REPURCHASE_YN)

Line 393: ,TURN_OFF_INVOICE_YN = decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR,TURN_OFF_INVOICE_YN,p_TURN_OFF_INVOICE_YN)

389: ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
390: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
391: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
392: ,DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, p_DISPOSITION_CODE)
393: ,TURN_OFF_INVOICE_YN = decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR,TURN_OFF_INVOICE_YN,p_TURN_OFF_INVOICE_YN)
394: ,NOTICE_ASSIGNMENT_YN = decode( p_NOTICE_ASSIGNMENT_YN,FND_API.G_MISS_CHAR,NOTICE_ASSIGNMENT_YN,p_NOTICE_ASSIGNMENT_YN)
395: ,FILE_PROOF_CLAIM_YN = decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR,FILE_PROOF_CLAIM_YN, p_FILE_PROOF_CLAIM_YN)
396: ,REQUEST_REPURCHASE_YN = decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR,REQUEST_REPURCHASE_YN, p_REQUEST_REPURCHASE_YN)
397: ,FEE_PAID_DATE = decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE,FEE_PAID_DATE, p_FEE_PAID_DATE)

Line 394: ,NOTICE_ASSIGNMENT_YN = decode( p_NOTICE_ASSIGNMENT_YN,FND_API.G_MISS_CHAR,NOTICE_ASSIGNMENT_YN,p_NOTICE_ASSIGNMENT_YN)

390: ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
391: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
392: ,DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, p_DISPOSITION_CODE)
393: ,TURN_OFF_INVOICE_YN = decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR,TURN_OFF_INVOICE_YN,p_TURN_OFF_INVOICE_YN)
394: ,NOTICE_ASSIGNMENT_YN = decode( p_NOTICE_ASSIGNMENT_YN,FND_API.G_MISS_CHAR,NOTICE_ASSIGNMENT_YN,p_NOTICE_ASSIGNMENT_YN)
395: ,FILE_PROOF_CLAIM_YN = decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR,FILE_PROOF_CLAIM_YN, p_FILE_PROOF_CLAIM_YN)
396: ,REQUEST_REPURCHASE_YN = decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR,REQUEST_REPURCHASE_YN, p_REQUEST_REPURCHASE_YN)
397: ,FEE_PAID_DATE = decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE,FEE_PAID_DATE, p_FEE_PAID_DATE)
398: ,REAFFIRMATION_DATE = decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE,REAFFIRMATION_DATE, p_REAFFIRMATION_DATE)

Line 395: ,FILE_PROOF_CLAIM_YN = decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR,FILE_PROOF_CLAIM_YN, p_FILE_PROOF_CLAIM_YN)

391: ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
392: ,DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, p_DISPOSITION_CODE)
393: ,TURN_OFF_INVOICE_YN = decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR,TURN_OFF_INVOICE_YN,p_TURN_OFF_INVOICE_YN)
394: ,NOTICE_ASSIGNMENT_YN = decode( p_NOTICE_ASSIGNMENT_YN,FND_API.G_MISS_CHAR,NOTICE_ASSIGNMENT_YN,p_NOTICE_ASSIGNMENT_YN)
395: ,FILE_PROOF_CLAIM_YN = decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR,FILE_PROOF_CLAIM_YN, p_FILE_PROOF_CLAIM_YN)
396: ,REQUEST_REPURCHASE_YN = decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR,REQUEST_REPURCHASE_YN, p_REQUEST_REPURCHASE_YN)
397: ,FEE_PAID_DATE = decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE,FEE_PAID_DATE, p_FEE_PAID_DATE)
398: ,REAFFIRMATION_DATE = decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE,REAFFIRMATION_DATE, p_REAFFIRMATION_DATE)
399: ,RELIEF_STAY_DATE = decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, RELIEF_STAY_DATE, p_RELIEF_STAY_DATE)

Line 396: ,REQUEST_REPURCHASE_YN = decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR,REQUEST_REPURCHASE_YN, p_REQUEST_REPURCHASE_YN)

392: ,DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, p_DISPOSITION_CODE)
393: ,TURN_OFF_INVOICE_YN = decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR,TURN_OFF_INVOICE_YN,p_TURN_OFF_INVOICE_YN)
394: ,NOTICE_ASSIGNMENT_YN = decode( p_NOTICE_ASSIGNMENT_YN,FND_API.G_MISS_CHAR,NOTICE_ASSIGNMENT_YN,p_NOTICE_ASSIGNMENT_YN)
395: ,FILE_PROOF_CLAIM_YN = decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR,FILE_PROOF_CLAIM_YN, p_FILE_PROOF_CLAIM_YN)
396: ,REQUEST_REPURCHASE_YN = decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR,REQUEST_REPURCHASE_YN, p_REQUEST_REPURCHASE_YN)
397: ,FEE_PAID_DATE = decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE,FEE_PAID_DATE, p_FEE_PAID_DATE)
398: ,REAFFIRMATION_DATE = decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE,REAFFIRMATION_DATE, p_REAFFIRMATION_DATE)
399: ,RELIEF_STAY_DATE = decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, RELIEF_STAY_DATE, p_RELIEF_STAY_DATE)
400: ,FILE_CONTACT_ID = decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM,FILE_CONTACT_ID, p_FILE_CONTACT_ID)

Line 397: ,FEE_PAID_DATE = decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE,FEE_PAID_DATE, p_FEE_PAID_DATE)

393: ,TURN_OFF_INVOICE_YN = decode( p_TURN_OFF_INVOICE_YN, FND_API.G_MISS_CHAR,TURN_OFF_INVOICE_YN,p_TURN_OFF_INVOICE_YN)
394: ,NOTICE_ASSIGNMENT_YN = decode( p_NOTICE_ASSIGNMENT_YN,FND_API.G_MISS_CHAR,NOTICE_ASSIGNMENT_YN,p_NOTICE_ASSIGNMENT_YN)
395: ,FILE_PROOF_CLAIM_YN = decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR,FILE_PROOF_CLAIM_YN, p_FILE_PROOF_CLAIM_YN)
396: ,REQUEST_REPURCHASE_YN = decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR,REQUEST_REPURCHASE_YN, p_REQUEST_REPURCHASE_YN)
397: ,FEE_PAID_DATE = decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE,FEE_PAID_DATE, p_FEE_PAID_DATE)
398: ,REAFFIRMATION_DATE = decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE,REAFFIRMATION_DATE, p_REAFFIRMATION_DATE)
399: ,RELIEF_STAY_DATE = decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, RELIEF_STAY_DATE, p_RELIEF_STAY_DATE)
400: ,FILE_CONTACT_ID = decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM,FILE_CONTACT_ID, p_FILE_CONTACT_ID)
401: ,CASE_NUMBER = decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR,CASE_NUMBER, p_CASE_NUMBER)

Line 398: ,REAFFIRMATION_DATE = decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE,REAFFIRMATION_DATE, p_REAFFIRMATION_DATE)

394: ,NOTICE_ASSIGNMENT_YN = decode( p_NOTICE_ASSIGNMENT_YN,FND_API.G_MISS_CHAR,NOTICE_ASSIGNMENT_YN,p_NOTICE_ASSIGNMENT_YN)
395: ,FILE_PROOF_CLAIM_YN = decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR,FILE_PROOF_CLAIM_YN, p_FILE_PROOF_CLAIM_YN)
396: ,REQUEST_REPURCHASE_YN = decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR,REQUEST_REPURCHASE_YN, p_REQUEST_REPURCHASE_YN)
397: ,FEE_PAID_DATE = decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE,FEE_PAID_DATE, p_FEE_PAID_DATE)
398: ,REAFFIRMATION_DATE = decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE,REAFFIRMATION_DATE, p_REAFFIRMATION_DATE)
399: ,RELIEF_STAY_DATE = decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, RELIEF_STAY_DATE, p_RELIEF_STAY_DATE)
400: ,FILE_CONTACT_ID = decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM,FILE_CONTACT_ID, p_FILE_CONTACT_ID)
401: ,CASE_NUMBER = decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR,CASE_NUMBER, p_CASE_NUMBER)
402:

Line 399: ,RELIEF_STAY_DATE = decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, RELIEF_STAY_DATE, p_RELIEF_STAY_DATE)

395: ,FILE_PROOF_CLAIM_YN = decode( p_FILE_PROOF_CLAIM_YN, FND_API.G_MISS_CHAR,FILE_PROOF_CLAIM_YN, p_FILE_PROOF_CLAIM_YN)
396: ,REQUEST_REPURCHASE_YN = decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR,REQUEST_REPURCHASE_YN, p_REQUEST_REPURCHASE_YN)
397: ,FEE_PAID_DATE = decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE,FEE_PAID_DATE, p_FEE_PAID_DATE)
398: ,REAFFIRMATION_DATE = decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE,REAFFIRMATION_DATE, p_REAFFIRMATION_DATE)
399: ,RELIEF_STAY_DATE = decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, RELIEF_STAY_DATE, p_RELIEF_STAY_DATE)
400: ,FILE_CONTACT_ID = decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM,FILE_CONTACT_ID, p_FILE_CONTACT_ID)
401: ,CASE_NUMBER = decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR,CASE_NUMBER, p_CASE_NUMBER)
402:
403: where BANKRUPTCY_ID = p_BANKRUPTCY_ID;

Line 400: ,FILE_CONTACT_ID = decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM,FILE_CONTACT_ID, p_FILE_CONTACT_ID)

396: ,REQUEST_REPURCHASE_YN = decode( p_REQUEST_REPURCHASE_YN, FND_API.G_MISS_CHAR,REQUEST_REPURCHASE_YN, p_REQUEST_REPURCHASE_YN)
397: ,FEE_PAID_DATE = decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE,FEE_PAID_DATE, p_FEE_PAID_DATE)
398: ,REAFFIRMATION_DATE = decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE,REAFFIRMATION_DATE, p_REAFFIRMATION_DATE)
399: ,RELIEF_STAY_DATE = decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, RELIEF_STAY_DATE, p_RELIEF_STAY_DATE)
400: ,FILE_CONTACT_ID = decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM,FILE_CONTACT_ID, p_FILE_CONTACT_ID)
401: ,CASE_NUMBER = decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR,CASE_NUMBER, p_CASE_NUMBER)
402:
403: where BANKRUPTCY_ID = p_BANKRUPTCY_ID;
404:

Line 401: ,CASE_NUMBER = decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR,CASE_NUMBER, p_CASE_NUMBER)

397: ,FEE_PAID_DATE = decode( p_FEE_PAID_DATE, FND_API.G_MISS_DATE,FEE_PAID_DATE, p_FEE_PAID_DATE)
398: ,REAFFIRMATION_DATE = decode( p_REAFFIRMATION_DATE, FND_API.G_MISS_DATE,REAFFIRMATION_DATE, p_REAFFIRMATION_DATE)
399: ,RELIEF_STAY_DATE = decode( p_RELIEF_STAY_DATE, FND_API.G_MISS_DATE, RELIEF_STAY_DATE, p_RELIEF_STAY_DATE)
400: ,FILE_CONTACT_ID = decode( p_FILE_CONTACT_ID, FND_API.G_MISS_NUM,FILE_CONTACT_ID, p_FILE_CONTACT_ID)
401: ,CASE_NUMBER = decode( p_CASE_NUMBER, FND_API.G_MISS_CHAR,CASE_NUMBER, p_CASE_NUMBER)
402:
403: where BANKRUPTCY_ID = p_BANKRUPTCY_ID;
404:
405: If (SQL%NOTFOUND) then