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 AR_ADJUSTMENTS

Line 9: | This procedure inserts a row into AR_ADJUSTMENTS table |

5: | PROCEDURE |
6: | insert_p |
7: | |
8: | DESCRIPTION |
9: | This procedure inserts a row into AR_ADJUSTMENTS table |
10: | |
11: | SCOPE - PUBLIC |
12: | |
13: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 18: | p_adj_id - Adjustment Id of inserted ar_adjustments row|

14: | |
15: | ARGUMENTS : IN: |
16: | p_adj_rec - Adjustment Record structure |
17: | OUT: |
18: | p_adj_id - Adjustment Id of inserted ar_adjustments row|
19: | |
20: | RETURNS : NONE |
21: | |
22: | NOTES |

Line 43: PROCEDURE insert_p( p_adj_rec IN ar_adjustments%ROWTYPE,

39: | 03-MARCH-2006 Herve Yu
40: | Late Charge Project: new columns added for insert_row |
41: | interest_header_id, interest_line_id |
42: +===========================================================================*/
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' );

Line 44: p_adj_id OUT NOCOPY ar_adjustments.adjustment_id%TYPE ) IS

40: | Late Charge Project: new columns added for insert_row |
41: | interest_header_id, interest_line_id |
42: +===========================================================================*/
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: --

Line 45: l_adj_id ar_adjustments.adjustment_id%TYPE;

41: | interest_header_id, interest_line_id |
42: +===========================================================================*/
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

Line 49: SELECT ar_adjustments_s.nextval

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;
52: --
53: INSERT INTO ar_adjustments (

Line 53: INSERT INTO ar_adjustments (

49: SELECT ar_adjustments_s.nextval
50: INTO l_adj_id
51: FROM dual;
52: --
53: INSERT INTO ar_adjustments (
54: adjustment_id,
55: acctd_amount,
56: adjustment_type,
57: amount,

Line 206: -- p_table_name => 'AR_ADJUSTMENTS',

202: | into MRC tables |
203: +-------------------------------------------*/
204: --{BUG#4301323
205: -- ar_mrc_engine.maintain_mrc_data( p_event_mode => 'INSERT',
206: -- p_table_name => 'AR_ADJUSTMENTS',
207: -- p_mode => 'SINGLE',
208: -- p_key_value => l_adj_id);
209: --}
210: p_adj_id := l_adj_id;

Line 223: | This function updates a row into AR_ADJUSTMENTS table |

219: | PROCEDURE |
220: | update_p |
221: | |
222: | DESCRIPTION |
223: | This function updates a row into AR_ADJUSTMENTS table |
224: | |
225: | SCOPE - PUBLIC |
226: | |
227: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 248: PROCEDURE update_p( p_adj_rec IN AR_ADJUSTMENTS%ROWTYPE ) IS

244: | Bug 1243304 : Added columns |
245: | adj_tax_acct_rule and |
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

Line 252: UPDATE ar_adjustments SET

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,
255: amount = p_adj_rec.amount,
256: code_combination_id = p_adj_rec.code_combination_id,

Line 341: -- p_table_name => 'AR_ADJUSTMENTS',

337: +----------------------------------------------------*/
338: --{BUG4301323
339: -- ar_mrc_engine.maintain_mrc_data(
340: -- p_event_mode => 'UPDATE',
341: -- p_table_name => 'AR_ADJUSTMENTS',
342: -- p_mode => 'SINGLE',
343: -- p_key_value => p_adj_rec.adjustment_id
344: -- );
345: --}

Line 359: | This function deletes a row from AR_ADJUSTMENTS table |

355: | PROCEDURE |
356: | delete_p |
357: | |
358: | DESCRIPTION |
359: | This function deletes a row from AR_ADJUSTMENTS table |
360: | |
361: | SCOPE - PUBLIC |
362: | |
363: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 367: | AR_ADJUSTMENTS |

363: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
364: | |
365: | ARGUMENTS : IN: |
366: | p_adj_id - Adjustment Id to delete a row from |
367: | AR_ADJUSTMENTS |
368: | |
369: | RETURNS : NONE |
370: | |
371: | NOTES |

Line 376: PROCEDURE delete_p( p_adj_id IN AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE ) IS

372: | |
373: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
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

Line 380: DELETE FROM ar_adjustments

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:
383: /*---------------------------------+
384: | Calling central MRC library |

Line 390: -- p_table_name => 'AR_ADJUSTMENTS',

386: +---------------------------------*/
387: --{BUG4301323
388: -- ar_mrc_engine.maintain_mrc_data(
389: -- p_event_mode => 'DELETE',
390: -- p_table_name => 'AR_ADJUSTMENTS',
391: -- p_mode => 'SINGLE',
392: -- p_key_value => p_adj_id);
393: --}
394: --

Line 407: | This function locks a row in AR_ADJUSTMENTS table |

403: | PROCEDURE |
404: | lock_p |
405: | |
406: | DESCRIPTION |
407: | This function locks a row in AR_ADJUSTMENTS table |
408: | |
409: | SCOPE - PUBLIC |
410: | |
411: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 415: | AR_ADJUSTMENTS table |

411: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
412: | |
413: | ARGUMENTS : IN: |
414: | p_adj_id - Adjustment Id of row to be locked in |
415: | AR_ADJUSTMENTS table |
416: | |
417: | RETURNS : NONE |
418: | |
419: | NOTES |

Line 424: PROCEDURE lock_p( p_adj_id IN AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE ) IS

420: | |
421: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
422: | |
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: --

Line 425: l_adj_id AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;

421: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
422: | |
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

Line 431: FROM ar_adjustments

427: arp_standard.debug( '>>>>>>>> arp_adj_pkg.lock_p' );
428: --
429: SELECT adjustment_id
430: INTO l_adj_id
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' );

Line 447: | This function fetches a row from AR_ADJUSTMENTS table |

443: | PROCEDURE |
444: | fetch_p |
445: | |
446: | DESCRIPTION |
447: | This function fetches a row from AR_ADJUSTMENTS table |
448: | |
449: | SCOPE - PUBLIC |
450: | |
451: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 455: | AR_ADJUSTMENTS table |

451: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
452: | |
453: | ARGUMENTS : IN: |
454: | p_adj_id - Adjustment Id of row to be fetched from |
455: | AR_ADJUSTMENTS table |
456: | OUT: |
457: | p_adj_rec - Adjustment Record structure |
458: | |
459: | RETURNS : NONE |

Line 466: PROCEDURE fetch_p( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

462: | |
463: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
464: | |
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: --

Line 467: p_adj_rec OUT NOCOPY ar_adjustments%ROWTYPE ) IS

463: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
464: | |
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 *

Line 473: FROM ar_adjustments

469: arp_standard.debug( '>>>>>>>> arp_adj_pkg.fetch_p' );
470: --
471: SELECT *
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