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.ARP_ADJUSTMENTS_PKG dependencies on DBMS_SQL

Line 52: | dbms_sql.bind_variable |

48: | |
49: | SCOPE - PRIVATE |
50: | |
51: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
52: | dbms_sql.bind_variable |
53: | arp_util.debug |
54: | |
55: | ARGUMENTS : IN: |
56: | p_update_cursor - ID of the update cursor |

Line 113: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',

109: 9/18/96 H.Kaukovuo
110: Commented out NOCOPY because calculating accounted amount cannot be done
111: at this level!
112:
113: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
114: p_exchange_rate);
115:
116: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
117: p_currency_code);

Line 116: dbms_sql.bind_variable(p_update_cursor, ':currency_code',

112:
113: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
114: p_exchange_rate);
115:
116: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
117: p_currency_code);
118:
119: dbms_sql.bind_variable(p_update_cursor, ':precision',
120: p_precision);

Line 119: dbms_sql.bind_variable(p_update_cursor, ':precision',

115:
116: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
117: p_currency_code);
118:
119: dbms_sql.bind_variable(p_update_cursor, ':precision',
120: p_precision);
121:
122: dbms_sql.bind_variable(p_update_cursor, ':mau',
123: p_mau);

Line 122: dbms_sql.bind_variable(p_update_cursor, ':mau',

118:
119: dbms_sql.bind_variable(p_update_cursor, ':precision',
120: p_precision);
121:
122: dbms_sql.bind_variable(p_update_cursor, ':mau',
123: p_mau);
124: */
125:
126:

Line 154: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',

150: /*------------------+
151: | Dummy constants |
152: +------------------*/
153:
154: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
155: AR_TEXT_DUMMY);
156:
157: dbms_sql.bind_variable(p_update_cursor, ':ar_text3_dummy',
158: AR_TEXT3_DUMMY);

Line 157: dbms_sql.bind_variable(p_update_cursor, ':ar_text3_dummy',

153:
154: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
155: AR_TEXT_DUMMY);
156:
157: dbms_sql.bind_variable(p_update_cursor, ':ar_text3_dummy',
158: AR_TEXT3_DUMMY);
159:
160: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
161: AR_FLAG_DUMMY);

Line 160: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',

156:
157: dbms_sql.bind_variable(p_update_cursor, ':ar_text3_dummy',
158: AR_TEXT3_DUMMY);
159:
160: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
161: AR_FLAG_DUMMY);
162:
163: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
164: AR_NUMBER_DUMMY);

Line 163: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',

159:
160: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
161: AR_FLAG_DUMMY);
162:
163: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
164: AR_NUMBER_DUMMY);
165:
166: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
167: AR_DATE_DUMMY);

Line 166: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',

162:
163: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
164: AR_NUMBER_DUMMY);
165:
166: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
167: AR_DATE_DUMMY);
168:
169: /*------------------+
170: | WHO variables |

Line 173: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',

169: /*------------------+
170: | WHO variables |
171: +------------------*/
172:
173: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
174: pg_user_id);
175:
176: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
177: pg_login_id);

Line 176: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',

172:
173: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
174: pg_user_id);
175:
176: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
177: pg_login_id);
178:
179: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
180: pg_conc_login_id);

Line 179: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',

175:
176: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
177: pg_login_id);
178:
179: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
180: pg_conc_login_id);
181:
182: /*----------------------------------------------+
183: | Bind variables for all columns in the table |

Line 192: dbms_sql.bind_variable(p_update_cursor, ':accounting_affect_flag',

188: | Change made for BR/BOE project |
189: | Bind accounting_affect_flag. |
190: +---------------------------------------------*/
191:
192: dbms_sql.bind_variable(p_update_cursor, ':accounting_affect_flag',
193: l_accounting_affect_flag);
194:
195: dbms_sql.bind_variable(p_update_cursor, ':adjustment_id',
196: p_adj_rec.adjustment_id);

Line 195: dbms_sql.bind_variable(p_update_cursor, ':adjustment_id',

191:
192: dbms_sql.bind_variable(p_update_cursor, ':accounting_affect_flag',
193: l_accounting_affect_flag);
194:
195: dbms_sql.bind_variable(p_update_cursor, ':adjustment_id',
196: p_adj_rec.adjustment_id);
197:
198: dbms_sql.bind_variable(p_update_cursor, ':amount',
199: p_adj_rec.amount);

Line 198: dbms_sql.bind_variable(p_update_cursor, ':amount',

194:
195: dbms_sql.bind_variable(p_update_cursor, ':adjustment_id',
196: p_adj_rec.adjustment_id);
197:
198: dbms_sql.bind_variable(p_update_cursor, ':amount',
199: p_adj_rec.amount);
200:
201: -- 9/18/96 H.Kaukovuo Added for bug fix 403019
202: dbms_sql.bind_variable(p_update_cursor, ':acctd_amount',

Line 202: dbms_sql.bind_variable(p_update_cursor, ':acctd_amount',

198: dbms_sql.bind_variable(p_update_cursor, ':amount',
199: p_adj_rec.amount);
200:
201: -- 9/18/96 H.Kaukovuo Added for bug fix 403019
202: dbms_sql.bind_variable(p_update_cursor, ':acctd_amount',
203: p_adj_rec.acctd_amount);
204:
205: dbms_sql.bind_variable(p_update_cursor, ':apply_date',
206: p_adj_rec.apply_date);

Line 205: dbms_sql.bind_variable(p_update_cursor, ':apply_date',

201: -- 9/18/96 H.Kaukovuo Added for bug fix 403019
202: dbms_sql.bind_variable(p_update_cursor, ':acctd_amount',
203: p_adj_rec.acctd_amount);
204:
205: dbms_sql.bind_variable(p_update_cursor, ':apply_date',
206: p_adj_rec.apply_date);
207:
208: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
209: p_adj_rec.gl_date);

Line 208: dbms_sql.bind_variable(p_update_cursor, ':gl_date',

204:
205: dbms_sql.bind_variable(p_update_cursor, ':apply_date',
206: p_adj_rec.apply_date);
207:
208: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
209: p_adj_rec.gl_date);
210:
211: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
212: p_adj_rec.gl_posted_date);

Line 211: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',

207:
208: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
209: p_adj_rec.gl_date);
210:
211: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
212: p_adj_rec.gl_posted_date);
213:
214: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
215: p_adj_rec.set_of_books_id);

Line 214: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',

210:
211: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
212: p_adj_rec.gl_posted_date);
213:
214: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
215: p_adj_rec.set_of_books_id);
216:
217: dbms_sql.bind_variable(p_update_cursor, ':code_combination_id',
218: p_adj_rec.code_combination_id);

Line 217: dbms_sql.bind_variable(p_update_cursor, ':code_combination_id',

213:
214: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
215: p_adj_rec.set_of_books_id);
216:
217: dbms_sql.bind_variable(p_update_cursor, ':code_combination_id',
218: p_adj_rec.code_combination_id);
219:
220: dbms_sql.bind_variable(p_update_cursor, ':type',
221: p_adj_rec.type);

Line 220: dbms_sql.bind_variable(p_update_cursor, ':type',

216:
217: dbms_sql.bind_variable(p_update_cursor, ':code_combination_id',
218: p_adj_rec.code_combination_id);
219:
220: dbms_sql.bind_variable(p_update_cursor, ':type',
221: p_adj_rec.type);
222:
223: dbms_sql.bind_variable(p_update_cursor, ':adjustment_type',
224: p_adj_rec.adjustment_type);

Line 223: dbms_sql.bind_variable(p_update_cursor, ':adjustment_type',

219:
220: dbms_sql.bind_variable(p_update_cursor, ':type',
221: p_adj_rec.type);
222:
223: dbms_sql.bind_variable(p_update_cursor, ':adjustment_type',
224: p_adj_rec.adjustment_type);
225:
226: dbms_sql.bind_variable(p_update_cursor, ':status',
227: p_adj_rec.status);

Line 226: dbms_sql.bind_variable(p_update_cursor, ':status',

222:
223: dbms_sql.bind_variable(p_update_cursor, ':adjustment_type',
224: p_adj_rec.adjustment_type);
225:
226: dbms_sql.bind_variable(p_update_cursor, ':status',
227: p_adj_rec.status);
228:
229: dbms_sql.bind_variable(p_update_cursor, ':line_adjusted',
230: p_adj_rec.line_adjusted);

Line 229: dbms_sql.bind_variable(p_update_cursor, ':line_adjusted',

225:
226: dbms_sql.bind_variable(p_update_cursor, ':status',
227: p_adj_rec.status);
228:
229: dbms_sql.bind_variable(p_update_cursor, ':line_adjusted',
230: p_adj_rec.line_adjusted);
231:
232: dbms_sql.bind_variable(p_update_cursor, ':freight_adjusted',
233: p_adj_rec.freight_adjusted);

Line 232: dbms_sql.bind_variable(p_update_cursor, ':freight_adjusted',

228:
229: dbms_sql.bind_variable(p_update_cursor, ':line_adjusted',
230: p_adj_rec.line_adjusted);
231:
232: dbms_sql.bind_variable(p_update_cursor, ':freight_adjusted',
233: p_adj_rec.freight_adjusted);
234:
235: dbms_sql.bind_variable(p_update_cursor, ':tax_adjusted',
236: p_adj_rec.tax_adjusted);

Line 235: dbms_sql.bind_variable(p_update_cursor, ':tax_adjusted',

231:
232: dbms_sql.bind_variable(p_update_cursor, ':freight_adjusted',
233: p_adj_rec.freight_adjusted);
234:
235: dbms_sql.bind_variable(p_update_cursor, ':tax_adjusted',
236: p_adj_rec.tax_adjusted);
237:
238: dbms_sql.bind_variable(p_update_cursor, ':receivables_charges_adjusted',
239: p_adj_rec.receivables_charges_adjusted);

Line 238: dbms_sql.bind_variable(p_update_cursor, ':receivables_charges_adjusted',

234:
235: dbms_sql.bind_variable(p_update_cursor, ':tax_adjusted',
236: p_adj_rec.tax_adjusted);
237:
238: dbms_sql.bind_variable(p_update_cursor, ':receivables_charges_adjusted',
239: p_adj_rec.receivables_charges_adjusted);
240:
241: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
242: p_adj_rec.batch_id);

Line 241: dbms_sql.bind_variable(p_update_cursor, ':batch_id',

237:
238: dbms_sql.bind_variable(p_update_cursor, ':receivables_charges_adjusted',
239: p_adj_rec.receivables_charges_adjusted);
240:
241: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
242: p_adj_rec.batch_id);
243:
244: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
245: p_adj_rec.customer_trx_id);

Line 244: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',

240:
241: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
242: p_adj_rec.batch_id);
243:
244: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
245: p_adj_rec.customer_trx_id);
246:
247: dbms_sql.bind_variable(p_update_cursor, ':subsequent_trx_id',
248: p_adj_rec.subsequent_trx_id);

Line 247: dbms_sql.bind_variable(p_update_cursor, ':subsequent_trx_id',

243:
244: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
245: p_adj_rec.customer_trx_id);
246:
247: dbms_sql.bind_variable(p_update_cursor, ':subsequent_trx_id',
248: p_adj_rec.subsequent_trx_id);
249:
250: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
251: p_adj_rec.customer_trx_line_id);

Line 250: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',

246:
247: dbms_sql.bind_variable(p_update_cursor, ':subsequent_trx_id',
248: p_adj_rec.subsequent_trx_id);
249:
250: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
251: p_adj_rec.customer_trx_line_id);
252:
253: dbms_sql.bind_variable(p_update_cursor, ':associated_cash_receipt_id',
254: p_adj_rec.associated_cash_receipt_id);

Line 253: dbms_sql.bind_variable(p_update_cursor, ':associated_cash_receipt_id',

249:
250: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
251: p_adj_rec.customer_trx_line_id);
252:
253: dbms_sql.bind_variable(p_update_cursor, ':associated_cash_receipt_id',
254: p_adj_rec.associated_cash_receipt_id);
255:
256: dbms_sql.bind_variable(p_update_cursor, ':chargeback_customer_trx_id',
257: p_adj_rec.chargeback_customer_trx_id);

Line 256: dbms_sql.bind_variable(p_update_cursor, ':chargeback_customer_trx_id',

252:
253: dbms_sql.bind_variable(p_update_cursor, ':associated_cash_receipt_id',
254: p_adj_rec.associated_cash_receipt_id);
255:
256: dbms_sql.bind_variable(p_update_cursor, ':chargeback_customer_trx_id',
257: p_adj_rec.chargeback_customer_trx_id);
258:
259: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
260: p_adj_rec.payment_schedule_id);

Line 259: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',

255:
256: dbms_sql.bind_variable(p_update_cursor, ':chargeback_customer_trx_id',
257: p_adj_rec.chargeback_customer_trx_id);
258:
259: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
260: p_adj_rec.payment_schedule_id);
261:
262: dbms_sql.bind_variable(p_update_cursor, ':receivables_trx_id',
263: p_adj_rec.receivables_trx_id);

Line 262: dbms_sql.bind_variable(p_update_cursor, ':receivables_trx_id',

258:
259: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
260: p_adj_rec.payment_schedule_id);
261:
262: dbms_sql.bind_variable(p_update_cursor, ':receivables_trx_id',
263: p_adj_rec.receivables_trx_id);
264:
265: dbms_sql.bind_variable(p_update_cursor, ':distribution_set_id',
266: p_adj_rec.distribution_set_id);

Line 265: dbms_sql.bind_variable(p_update_cursor, ':distribution_set_id',

261:
262: dbms_sql.bind_variable(p_update_cursor, ':receivables_trx_id',
263: p_adj_rec.receivables_trx_id);
264:
265: dbms_sql.bind_variable(p_update_cursor, ':distribution_set_id',
266: p_adj_rec.distribution_set_id);
267:
268: dbms_sql.bind_variable(p_update_cursor, ':associated_application_id',
269: p_adj_rec.associated_application_id);

Line 268: dbms_sql.bind_variable(p_update_cursor, ':associated_application_id',

264:
265: dbms_sql.bind_variable(p_update_cursor, ':distribution_set_id',
266: p_adj_rec.distribution_set_id);
267:
268: dbms_sql.bind_variable(p_update_cursor, ':associated_application_id',
269: p_adj_rec.associated_application_id);
270:
271: dbms_sql.bind_variable(p_update_cursor, ':comments',
272: p_adj_rec.comments);

Line 271: dbms_sql.bind_variable(p_update_cursor, ':comments',

267:
268: dbms_sql.bind_variable(p_update_cursor, ':associated_application_id',
269: p_adj_rec.associated_application_id);
270:
271: dbms_sql.bind_variable(p_update_cursor, ':comments',
272: p_adj_rec.comments);
273:
274: dbms_sql.bind_variable(p_update_cursor, ':automatically_generated',
275: p_adj_rec.automatically_generated);

Line 274: dbms_sql.bind_variable(p_update_cursor, ':automatically_generated',

270:
271: dbms_sql.bind_variable(p_update_cursor, ':comments',
272: p_adj_rec.comments);
273:
274: dbms_sql.bind_variable(p_update_cursor, ':automatically_generated',
275: p_adj_rec.automatically_generated);
276:
277: dbms_sql.bind_variable(p_update_cursor, ':created_from',
278: p_adj_rec.created_from);

Line 277: dbms_sql.bind_variable(p_update_cursor, ':created_from',

273:
274: dbms_sql.bind_variable(p_update_cursor, ':automatically_generated',
275: p_adj_rec.automatically_generated);
276:
277: dbms_sql.bind_variable(p_update_cursor, ':created_from',
278: p_adj_rec.created_from);
279:
280: dbms_sql.bind_variable(p_update_cursor, ':reason_code',
281: p_adj_rec.reason_code);

Line 280: dbms_sql.bind_variable(p_update_cursor, ':reason_code',

276:
277: dbms_sql.bind_variable(p_update_cursor, ':created_from',
278: p_adj_rec.created_from);
279:
280: dbms_sql.bind_variable(p_update_cursor, ':reason_code',
281: p_adj_rec.reason_code);
282:
283: dbms_sql.bind_variable(p_update_cursor, ':adjustment_number',
284: p_adj_rec.adjustment_number);

Line 283: dbms_sql.bind_variable(p_update_cursor, ':adjustment_number',

279:
280: dbms_sql.bind_variable(p_update_cursor, ':reason_code',
281: p_adj_rec.reason_code);
282:
283: dbms_sql.bind_variable(p_update_cursor, ':adjustment_number',
284: p_adj_rec.adjustment_number);
285:
286: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
287: p_adj_rec.doc_sequence_value);

Line 286: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',

282:
283: dbms_sql.bind_variable(p_update_cursor, ':adjustment_number',
284: p_adj_rec.adjustment_number);
285:
286: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
287: p_adj_rec.doc_sequence_value);
288:
289: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
290: p_adj_rec.doc_sequence_id);

Line 289: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',

285:
286: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
287: p_adj_rec.doc_sequence_value);
288:
289: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
290: p_adj_rec.doc_sequence_id);
291:
292: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
293: p_adj_rec.ussgl_transaction_code);

Line 292: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',

288:
289: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
290: p_adj_rec.doc_sequence_id);
291:
292: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
293: p_adj_rec.ussgl_transaction_code);
294:
295: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
296: p_adj_rec.ussgl_transaction_code_context);

Line 295: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',

291:
292: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
293: p_adj_rec.ussgl_transaction_code);
294:
295: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
296: p_adj_rec.ussgl_transaction_code_context);
297:
298: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
299: p_adj_rec.attribute_category);

Line 298: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',

294:
295: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
296: p_adj_rec.ussgl_transaction_code_context);
297:
298: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
299: p_adj_rec.attribute_category);
300:
301: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
302: p_adj_rec.attribute1);

Line 301: dbms_sql.bind_variable(p_update_cursor, ':attribute1',

297:
298: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
299: p_adj_rec.attribute_category);
300:
301: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
302: p_adj_rec.attribute1);
303:
304: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
305: p_adj_rec.attribute2);

Line 304: dbms_sql.bind_variable(p_update_cursor, ':attribute2',

300:
301: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
302: p_adj_rec.attribute1);
303:
304: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
305: p_adj_rec.attribute2);
306:
307: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
308: p_adj_rec.attribute3);

Line 307: dbms_sql.bind_variable(p_update_cursor, ':attribute3',

303:
304: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
305: p_adj_rec.attribute2);
306:
307: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
308: p_adj_rec.attribute3);
309:
310: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
311: p_adj_rec.attribute4);

Line 310: dbms_sql.bind_variable(p_update_cursor, ':attribute4',

306:
307: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
308: p_adj_rec.attribute3);
309:
310: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
311: p_adj_rec.attribute4);
312:
313: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
314: p_adj_rec.attribute5);

Line 313: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

309:
310: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
311: p_adj_rec.attribute4);
312:
313: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
314: p_adj_rec.attribute5);
315:
316: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
317: p_adj_rec.attribute6);

Line 316: dbms_sql.bind_variable(p_update_cursor, ':attribute6',

312:
313: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
314: p_adj_rec.attribute5);
315:
316: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
317: p_adj_rec.attribute6);
318:
319: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
320: p_adj_rec.attribute7);

Line 319: dbms_sql.bind_variable(p_update_cursor, ':attribute7',

315:
316: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
317: p_adj_rec.attribute6);
318:
319: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
320: p_adj_rec.attribute7);
321:
322: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
323: p_adj_rec.attribute8);

Line 322: dbms_sql.bind_variable(p_update_cursor, ':attribute8',

318:
319: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
320: p_adj_rec.attribute7);
321:
322: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
323: p_adj_rec.attribute8);
324:
325: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
326: p_adj_rec.attribute9);

Line 325: dbms_sql.bind_variable(p_update_cursor, ':attribute9',

321:
322: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
323: p_adj_rec.attribute8);
324:
325: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
326: p_adj_rec.attribute9);
327:
328: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
329: p_adj_rec.attribute10);

Line 328: dbms_sql.bind_variable(p_update_cursor, ':attribute10',

324:
325: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
326: p_adj_rec.attribute9);
327:
328: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
329: p_adj_rec.attribute10);
330:
331: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
332: p_adj_rec.attribute11);

Line 331: dbms_sql.bind_variable(p_update_cursor, ':attribute11',

327:
328: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
329: p_adj_rec.attribute10);
330:
331: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
332: p_adj_rec.attribute11);
333:
334: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
335: p_adj_rec.attribute12);

Line 334: dbms_sql.bind_variable(p_update_cursor, ':attribute12',

330:
331: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
332: p_adj_rec.attribute11);
333:
334: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
335: p_adj_rec.attribute12);
336:
337: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
338: p_adj_rec.attribute13);

Line 337: dbms_sql.bind_variable(p_update_cursor, ':attribute13',

333:
334: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
335: p_adj_rec.attribute12);
336:
337: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
338: p_adj_rec.attribute13);
339:
340: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
341: p_adj_rec.attribute14);

Line 340: dbms_sql.bind_variable(p_update_cursor, ':attribute14',

336:
337: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
338: p_adj_rec.attribute13);
339:
340: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
341: p_adj_rec.attribute14);
342:
343: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
344: p_adj_rec.attribute15);

Line 343: dbms_sql.bind_variable(p_update_cursor, ':attribute15',

339:
340: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
341: p_adj_rec.attribute14);
342:
343: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
344: p_adj_rec.attribute15);
345:
346: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',
347: p_adj_rec.posting_control_id);

Line 346: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',

342:
343: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
344: p_adj_rec.attribute15);
345:
346: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',
347: p_adj_rec.posting_control_id);
348:
349: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
350: p_adj_rec.last_update_login);

Line 349: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',

345:
346: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',
347: p_adj_rec.posting_control_id);
348:
349: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
350: p_adj_rec.last_update_login);
351:
352: dbms_sql.bind_variable(p_update_cursor, ':created_by',
353: p_adj_rec.created_by);

Line 352: dbms_sql.bind_variable(p_update_cursor, ':created_by',

348:
349: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
350: p_adj_rec.last_update_login);
351:
352: dbms_sql.bind_variable(p_update_cursor, ':created_by',
353: p_adj_rec.created_by);
354:
355: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
356: p_adj_rec.creation_date);

Line 355: dbms_sql.bind_variable(p_update_cursor, ':creation_date',

351:
352: dbms_sql.bind_variable(p_update_cursor, ':created_by',
353: p_adj_rec.created_by);
354:
355: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
356: p_adj_rec.creation_date);
357:
358: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
359: p_adj_rec.program_application_id);

Line 358: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',

354:
355: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
356: p_adj_rec.creation_date);
357:
358: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
359: p_adj_rec.program_application_id);
360:
361: dbms_sql.bind_variable(p_update_cursor, ':program_id',
362: p_adj_rec.program_id);

Line 361: dbms_sql.bind_variable(p_update_cursor, ':program_id',

357:
358: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
359: p_adj_rec.program_application_id);
360:
361: dbms_sql.bind_variable(p_update_cursor, ':program_id',
362: p_adj_rec.program_id);
363:
364: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
365: p_adj_rec.program_update_date);

Line 364: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',

360:
361: dbms_sql.bind_variable(p_update_cursor, ':program_id',
362: p_adj_rec.program_id);
363:
364: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
365: p_adj_rec.program_update_date);
366:
367: dbms_sql.bind_variable(p_update_cursor, ':request_id',
368: p_adj_rec.request_id);

Line 367: dbms_sql.bind_variable(p_update_cursor, ':request_id',

363:
364: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
365: p_adj_rec.program_update_date);
366:
367: dbms_sql.bind_variable(p_update_cursor, ':request_id',
368: p_adj_rec.request_id);
369:
370: arp_util.debug('arp_adjustments_pkg.bind_adj_variables()-');
371:

Line 723: | dbms_sql.open_cursor |

719: | SCOPE - PRIVATE |
720: | |
721: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
722: | arp_util.debug |
723: | dbms_sql.open_cursor |
724: | dbms_sql.parse |
725: | dbms_sql.execute |
726: | dbms_sql.close_cursor |
727: | |

Line 724: | dbms_sql.parse |

720: | |
721: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
722: | arp_util.debug |
723: | dbms_sql.open_cursor |
724: | dbms_sql.parse |
725: | dbms_sql.execute |
726: | dbms_sql.close_cursor |
727: | |
728: | ARGUMENTS : IN: |

Line 725: | dbms_sql.execute |

721: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
722: | arp_util.debug |
723: | dbms_sql.open_cursor |
724: | dbms_sql.parse |
725: | dbms_sql.execute |
726: | dbms_sql.close_cursor |
727: | |
728: | ARGUMENTS : IN: |
729: | p_update_cursor - identifies the cursor to use |

Line 726: | dbms_sql.close_cursor |

722: | arp_util.debug |
723: | dbms_sql.open_cursor |
724: | dbms_sql.parse |
725: | dbms_sql.execute |
726: | dbms_sql.close_cursor |
727: | |
728: | ARGUMENTS : IN: |
729: | p_update_cursor - identifies the cursor to use |
730: | p_where_clause - identifies which rows to update |

Line 757: adj_array dbms_sql.number_table;

753:
754: l_count number;
755: l_update_statement varchar2(25000);
756: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
757: adj_array dbms_sql.number_table;
758:
759: BEGIN
760: arp_util.debug('arp_adjustments_pkg.generic_update()+');
761:

Line 782: p_update_cursor := dbms_sql.open_cursor;

778:
779: IF (p_update_cursor IS NULL)
780: THEN
781:
782: p_update_cursor := dbms_sql.open_cursor;
783:
784: /*---------------------------------+
785: | Construct the update statement |
786: +---------------------------------*/

Line 800: dbms_sql.parse(p_update_cursor,

796: /*-----------------------------------------------+
797: | Parse, bind, execute and close the statement |
798: +-----------------------------------------------*/
799:
800: dbms_sql.parse(p_update_cursor,
801: l_update_statement,
802: dbms_sql.v7);
803:
804: END IF;

Line 802: dbms_sql.v7);

798: +-----------------------------------------------*/
799:
800: dbms_sql.parse(p_update_cursor,
801: l_update_statement,
802: dbms_sql.v7);
803:
804: END IF;
805:
806: arp_adjustments_pkg.bind_adj_variables(p_update_cursor,

Line 816: dbms_sql.bind_array(p_update_cursor,':adj_key_value',

812:
813: /*---------------------------+
814: | Bind output variable |
815: +---------------------------*/
816: dbms_sql.bind_array(p_update_cursor,':adj_key_value',
817: adj_array);
818:
819: /*-----------------------------------------+
820: | Bind the variables in the where clause |

Line 823: dbms_sql.bind_variable(p_update_cursor, ':where_1',

819: /*-----------------------------------------+
820: | Bind the variables in the where clause |
821: +-----------------------------------------*/
822:
823: dbms_sql.bind_variable(p_update_cursor, ':where_1',
824: p_where1);
825:
826: l_count := dbms_sql.execute(p_update_cursor);
827:

Line 826: l_count := dbms_sql.execute(p_update_cursor);

822:
823: dbms_sql.bind_variable(p_update_cursor, ':where_1',
824: p_where1);
825:
826: l_count := dbms_sql.execute(p_update_cursor);
827:
828: arp_util.debug( to_char(l_count) || ' rows updated');
829:
830: /*------------------------------------------+

Line 834: dbms_sql.variable_value( p_update_cursor, ':adj_key_value', adj_array);

830: /*------------------------------------------+
831: | get RETURNING COLUMN into OUT NOCOPY bind array |
832: +------------------------------------------*/
833:
834: dbms_sql.variable_value( p_update_cursor, ':adj_key_value', adj_array);
835:
836:
837: /*------------------------------------------------------------+
838: | Raise the NO_DATA_FOUND exception if no rows were updated |

Line 874: to_char(dbms_sql.last_error_position));

870: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
871:
872: arp_util.debug(l_update_statement);
873: arp_util.debug('Error at character: ' ||
874: to_char(dbms_sql.last_error_position));
875: RAISE;
876: END;
877:
878: /*===========================================================================+