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 |
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 |
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' );
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: --
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
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 (
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,
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;
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 |
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
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,
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: --}
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 |
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 |
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
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 |
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: --
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 |
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 |
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: --
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
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' );
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 |
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 |
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: --
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 *
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