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_ADJ_PKG dependencies on STANDARD

Line 47: arp_standard.debug( '>>>>>>>> arp_adj_pkg.insert_p' );

43: PROCEDURE insert_p( p_adj_rec IN ar_adjustments%ROWTYPE,
44: p_adj_id OUT NOCOPY ar_adjustments.adjustment_id%TYPE ) IS
45: l_adj_id ar_adjustments.adjustment_id%TYPE;
46: BEGIN
47: arp_standard.debug( '>>>>>>>> arp_adj_pkg.insert_p' );
48: --
49: SELECT ar_adjustments_s.nextval
50: INTO l_adj_id
51: FROM dual;

Line 128: arp_standard.profile.user_id,

124: p_adj_rec.acctd_amount,
125: p_adj_rec.adjustment_type,
126: p_adj_rec.amount,
127: p_adj_rec.code_combination_id,
128: arp_standard.profile.user_id,
129: SYSDATE,
130: p_adj_rec.gl_date,
131: arp_standard.profile.user_id,
132: SYSDATE,

Line 131: arp_standard.profile.user_id,

127: p_adj_rec.code_combination_id,
128: arp_standard.profile.user_id,
129: SYSDATE,
130: p_adj_rec.gl_date,
131: arp_standard.profile.user_id,
132: SYSDATE,
133: p_adj_rec.set_of_books_id,
134: p_adj_rec.status,
135: p_adj_rec.type,

Line 150: NVL( arp_standard.profile.last_update_login,

146: p_adj_rec.customer_trx_line_id,
147: p_adj_rec.distribution_set_id,
148: p_adj_rec.freight_adjusted,
149: p_adj_rec.gl_posted_date,
150: NVL( arp_standard.profile.last_update_login,
151: p_adj_rec.last_update_login ),
152: p_adj_rec.line_adjusted,
153: p_adj_rec.payment_schedule_id,
154: p_adj_rec.postable,

Line 179: NVL( arp_standard.profile.request_id,

175: p_adj_rec.attribute14,
176: p_adj_rec.attribute15,
177: p_adj_rec.ussgl_transaction_code,
178: p_adj_rec.ussgl_transaction_code_context,
179: NVL( arp_standard.profile.request_id,
180: p_adj_rec.request_id ),
181: DECODE( arp_standard.profile.program_id,
182: NULL, NULL,
183: SYSDATE

Line 181: DECODE( arp_standard.profile.program_id,

177: p_adj_rec.ussgl_transaction_code,
178: p_adj_rec.ussgl_transaction_code_context,
179: NVL( arp_standard.profile.request_id,
180: p_adj_rec.request_id ),
181: DECODE( arp_standard.profile.program_id,
182: NULL, NULL,
183: SYSDATE
184: ),
185: NVL( arp_standard.profile.program_id, p_adj_rec.program_id ),

Line 185: NVL( arp_standard.profile.program_id, p_adj_rec.program_id ),

181: DECODE( arp_standard.profile.program_id,
182: NULL, NULL,
183: SYSDATE
184: ),
185: NVL( arp_standard.profile.program_id, p_adj_rec.program_id ),
186: NVL( arp_standard.profile.program_application_id,
187: p_adj_rec.program_application_id ),
188: p_adj_rec.doc_sequence_id,
189: p_adj_rec.doc_sequence_value,

Line 186: NVL( arp_standard.profile.program_application_id,

182: NULL, NULL,
183: SYSDATE
184: ),
185: NVL( arp_standard.profile.program_id, p_adj_rec.program_id ),
186: NVL( arp_standard.profile.program_application_id,
187: p_adj_rec.program_application_id ),
188: p_adj_rec.doc_sequence_id,
189: p_adj_rec.doc_sequence_value,
190: p_adj_rec.associated_application_id,

Line 194: ,arp_standard.sysparm.org_id /* SSA changes anuj */

190: p_adj_rec.associated_application_id,
191: p_adj_rec.link_to_trx_hist_id,
192: p_adj_rec.adj_tax_acct_rule,
193: p_adj_rec.cons_inv_id
194: ,arp_standard.sysparm.org_id /* SSA changes anuj */
195: --{Late Charge Project
196: ,p_adj_rec.interest_header_id
197: ,p_adj_rec.interest_line_id
198: );

Line 211: arp_standard.debug( '<<<<<<<< arp_adj_pkg.insert_p' );

207: -- p_mode => 'SINGLE',
208: -- p_key_value => l_adj_id);
209: --}
210: p_adj_id := l_adj_id;
211: arp_standard.debug( '<<<<<<<< arp_adj_pkg.insert_p' );
212: EXCEPTION
213: WHEN OTHERS THEN
214: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.insert_p' );
215: RAISE;

Line 214: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.insert_p' );

210: p_adj_id := l_adj_id;
211: arp_standard.debug( '<<<<<<<< arp_adj_pkg.insert_p' );
212: EXCEPTION
213: WHEN OTHERS THEN
214: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.insert_p' );
215: RAISE;
216: END;
217: --
218: /*===========================================================================+

Line 250: arp_standard.debug( '>>>>>>>> arp_adj_pkg.update_p' );

246: | cons_inv_id into the table handlers. |
247: +===========================================================================*/
248: PROCEDURE update_p( p_adj_rec IN AR_ADJUSTMENTS%ROWTYPE ) IS
249: BEGIN
250: arp_standard.debug( '>>>>>>>> arp_adj_pkg.update_p' );
251: --
252: UPDATE ar_adjustments SET
253: acctd_amount = p_adj_rec.acctd_amount,
254: adjustment_type = p_adj_rec.adjustment_type,

Line 258: last_updated_by = arp_standard.profile.user_id,

254: adjustment_type = p_adj_rec.adjustment_type,
255: amount = p_adj_rec.amount,
256: code_combination_id = p_adj_rec.code_combination_id,
257: gl_date = p_adj_rec.gl_date,
258: last_updated_by = arp_standard.profile.user_id,
259: last_update_date = SYSDATE,
260: set_of_books_id = p_adj_rec.set_of_books_id,
261: status = p_adj_rec.status,
262: type = p_adj_rec.type,

Line 279: last_update_login = NVL( arp_standard.profile.last_update_login,

275: customer_trx_line_id = p_adj_rec.customer_trx_line_id,
276: distribution_set_id = p_adj_rec.distribution_set_id,
277: freight_adjusted = p_adj_rec.freight_adjusted,
278: gl_posted_date = p_adj_rec.gl_posted_date,
279: last_update_login = NVL( arp_standard.profile.last_update_login,
280: p_adj_rec.last_update_login ),
281: line_adjusted = p_adj_rec.line_adjusted,
282: payment_schedule_id = p_adj_rec.payment_schedule_id,
283: postable = p_adj_rec.postable,

Line 311: request_id = NVL( arp_standard.profile.request_id,

307: ussgl_transaction_code =
308: p_adj_rec.ussgl_transaction_code,
309: ussgl_transaction_code_context =
310: p_adj_rec.ussgl_transaction_code_context,
311: request_id = NVL( arp_standard.profile.request_id,
312: p_adj_rec.request_id ),
313: program_update_date =
314: DECODE( arp_standard.profile.program_id,
315: NULL, NULL,

Line 314: DECODE( arp_standard.profile.program_id,

310: p_adj_rec.ussgl_transaction_code_context,
311: request_id = NVL( arp_standard.profile.request_id,
312: p_adj_rec.request_id ),
313: program_update_date =
314: DECODE( arp_standard.profile.program_id,
315: NULL, NULL,
316: SYSDATE
317: ),
318: program_id = NVL( arp_standard.profile.program_id,

Line 318: program_id = NVL( arp_standard.profile.program_id,

314: DECODE( arp_standard.profile.program_id,
315: NULL, NULL,
316: SYSDATE
317: ),
318: program_id = NVL( arp_standard.profile.program_id,
319: p_adj_rec.program_id ),
320: program_application_id =
321: NVL( arp_standard.profile.program_application_id,
322: p_adj_rec.program_application_id ),

Line 321: NVL( arp_standard.profile.program_application_id,

317: ),
318: program_id = NVL( arp_standard.profile.program_id,
319: p_adj_rec.program_id ),
320: program_application_id =
321: NVL( arp_standard.profile.program_application_id,
322: p_adj_rec.program_application_id ),
323: doc_sequence_id = p_adj_rec.doc_sequence_id,
324: doc_sequence_value = p_adj_rec.doc_sequence_value,
325: associated_application_id =

Line 347: arp_standard.debug( '<<<<<<<< arp_adj_pkg.update_p' );

343: -- p_key_value => p_adj_rec.adjustment_id
344: -- );
345: --}
346: --
347: arp_standard.debug( '<<<<<<<< arp_adj_pkg.update_p' );
348: EXCEPTION
349: WHEN OTHERS THEN
350: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.update_p' );
351: RAISE;

Line 350: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.update_p' );

346: --
347: arp_standard.debug( '<<<<<<<< arp_adj_pkg.update_p' );
348: EXCEPTION
349: WHEN OTHERS THEN
350: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.update_p' );
351: RAISE;
352: END;
353: --
354: /*===========================================================================+

Line 378: arp_standard.debug( '>>>>>>>> arp_adj_pkg.delete_p' );

374: | |
375: +===========================================================================*/
376: PROCEDURE delete_p( p_adj_id IN AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE ) IS
377: BEGIN
378: arp_standard.debug( '>>>>>>>> arp_adj_pkg.delete_p' );
379: --
380: DELETE FROM ar_adjustments
381: WHERE adjustment_id = p_adj_id;
382:

Line 395: arp_standard.debug( '<<<<<<<< arp_adj_pkg.delete_p' );

391: -- p_mode => 'SINGLE',
392: -- p_key_value => p_adj_id);
393: --}
394: --
395: arp_standard.debug( '<<<<<<<< arp_adj_pkg.delete_p' );
396: EXCEPTION
397: WHEN OTHERS THEN
398: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.delete_p' );
399: RAISE;

Line 398: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.delete_p' );

394: --
395: arp_standard.debug( '<<<<<<<< arp_adj_pkg.delete_p' );
396: EXCEPTION
397: WHEN OTHERS THEN
398: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.delete_p' );
399: RAISE;
400: END;
401: --
402: /*===========================================================================+

Line 427: arp_standard.debug( '>>>>>>>> arp_adj_pkg.lock_p' );

423: +===========================================================================*/
424: PROCEDURE lock_p( p_adj_id IN AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE ) IS
425: l_adj_id AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;
426: BEGIN
427: arp_standard.debug( '>>>>>>>> arp_adj_pkg.lock_p' );
428: --
429: SELECT adjustment_id
430: INTO l_adj_id
431: FROM ar_adjustments

Line 435: arp_standard.debug( '<<<<<<<< arp_adj_pkg.lock_p' );

431: FROM ar_adjustments
432: WHERE adjustment_id = p_adj_id
433: FOR UPDATE OF STATUS NOWAIT;
434: --
435: arp_standard.debug( '<<<<<<<< arp_adj_pkg.lock_p' );
436: EXCEPTION
437: WHEN OTHERS THEN
438: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.lock_p' );
439: RAISE;

Line 438: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.lock_p' );

434: --
435: arp_standard.debug( '<<<<<<<< arp_adj_pkg.lock_p' );
436: EXCEPTION
437: WHEN OTHERS THEN
438: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.lock_p' );
439: RAISE;
440: END;
441: --
442: /*===========================================================================+

Line 469: arp_standard.debug( '>>>>>>>> arp_adj_pkg.fetch_p' );

465: +===========================================================================*/
466: PROCEDURE fetch_p( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
467: p_adj_rec OUT NOCOPY ar_adjustments%ROWTYPE ) IS
468: BEGIN
469: arp_standard.debug( '>>>>>>>> arp_adj_pkg.fetch_p' );
470: --
471: SELECT *
472: INTO p_adj_rec
473: FROM ar_adjustments

Line 476: arp_standard.debug( '<<<<<<<< arp_adj_pkg.fetch_p' );

472: INTO p_adj_rec
473: FROM ar_adjustments
474: WHERE adjustment_id = p_adj_id;
475: --
476: arp_standard.debug( '<<<<<<<< arp_adj_pkg.fetch_p' );
477: EXCEPTION
478: WHEN OTHERS THEN
479: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.fetch_p' );
480: RAISE;

Line 479: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.fetch_p' );

475: --
476: arp_standard.debug( '<<<<<<<< arp_adj_pkg.fetch_p' );
477: EXCEPTION
478: WHEN OTHERS THEN
479: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.fetch_p' );
480: RAISE;
481: END;
482: --
483: END ARP_ADJ_PKG;