DBA Data[Home] [Help]

APPS.ARP_PROCESS_ADJUSTMENT dependencies on AR_ADJUSTMENTS

Line 20: | Validates row that is going to be inserted into ar_adjustments |

16: | PROCEDURE |
17: | validate_insert_adjustment |
18: | |
19: | DESCRIPTION |
20: | Validates row that is going to be inserted into ar_adjustments |
21: | |
22: | SCOPE - PRIVATE |
23: | |
24: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 112: | Validates row that is going to be updateded in ar_adjustments |

108: | PROCEDURE |
109: | validate_update_adjustment |
110: | |
111: | DESCRIPTION |
112: | Validates row that is going to be updateded in ar_adjustments |
113: | |
114: | SCOPE - PRIVATE |
115: | |
116: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 308: p_adjustment_id IN ar_adjustments.adjustment_id%type,

304: | |
305: +===========================================================================*/
306:
307: PROCEDURE set_flags(
308: p_adjustment_id IN ar_adjustments.adjustment_id%type,
309: p_old_adj_rec IN ar_adjustments%rowtype,
310: p_new_adj_rec IN ar_adjustments%rowtype,
311: p_status_changed_flag OUT NOCOPY boolean)
312:

Line 309: p_old_adj_rec IN ar_adjustments%rowtype,

305: +===========================================================================*/
306:
307: PROCEDURE set_flags(
308: p_adjustment_id IN ar_adjustments.adjustment_id%type,
309: p_old_adj_rec IN ar_adjustments%rowtype,
310: p_new_adj_rec IN ar_adjustments%rowtype,
311: p_status_changed_flag OUT NOCOPY boolean)
312:
313: IS

Line 310: p_new_adj_rec IN ar_adjustments%rowtype,

306:
307: PROCEDURE set_flags(
308: p_adjustment_id IN ar_adjustments.adjustment_id%type,
309: p_old_adj_rec IN ar_adjustments%rowtype,
310: p_new_adj_rec IN ar_adjustments%rowtype,
311: p_status_changed_flag OUT NOCOPY boolean)
312:
313: IS
314:

Line 390: ar_adjustments%rowtype,

386: | ar_receivable_applications.
387: +===========================================================================*/
388:
389: PROCEDURE validate_inv_line_amount(p_adj_rec IN
390: ar_adjustments%rowtype,
391: p_ps_rec IN ar_payment_schedules%rowtype)
392: IS
393:
394:

Line 457: FROM ar_adjustments

453: END IF; /* 1909312 Code Added Ends */
454:
455: SELECT NVL(SUM(amount),0)
456: INTO l_sum_line_adj
457: FROM ar_adjustments
458: WHERE customer_trx_line_id = p_adj_rec.customer_trx_line_id
459: AND NVL(postable, 'Y') = 'Y'
460: AND customer_trx_id = p_adj_rec.customer_trx_id;
461:

Line 607: l_adj_rec ar_adjustments%rowtype;

603: p_customer_trx_id IN number,
604: p_payment_schedule_id IN number,
605: p_amount IN number) IS
606:
607: l_adj_rec ar_adjustments%rowtype;
608: l_ps_rec ar_payment_schedules%rowtype;
609:
610: BEGIN
611:

Line 695: PROCEDURE validate_update_approve_adj( p_adj_rec IN ar_adjustments%rowtype,

691: | was added. |
692: | |
693: +===========================================================================*/
694:
695: PROCEDURE validate_update_approve_adj( p_adj_rec IN ar_adjustments%rowtype,
696: p_ps_rec IN ar_payment_schedules%rowtype,
697: p_adjustment_code IN ar_lookups.lookup_code%type,
698: p_chk_approval_limits IN varchar2
699: ) IS

Line 858: | Inserts a record into ar_adjustments |

854: | PROCEDURE |
855: | insert_adjustment |
856: | |
857: | DESCRIPTION |
858: | Inserts a record into ar_adjustments |
859: | |
860: | SCOPE - PUBLIC |
861: | |
862: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 915: ar_adjustments%rowtype,

911:
912: PROCEDURE insert_adjustment(p_form_name IN varchar2,
913: p_form_version IN number,
914: p_adj_rec IN OUT
915: ar_adjustments%rowtype,
916: p_adjustment_number OUT NOCOPY
917: ar_adjustments.adjustment_number%type,
918: p_adjustment_id OUT NOCOPY
919: ar_adjustments.adjustment_id%type,

Line 917: ar_adjustments.adjustment_number%type,

913: p_form_version IN number,
914: p_adj_rec IN OUT
915: ar_adjustments%rowtype,
916: p_adjustment_number OUT NOCOPY
917: ar_adjustments.adjustment_number%type,
918: p_adjustment_id OUT NOCOPY
919: ar_adjustments.adjustment_id%type,
920: p_check_amount IN varchar2 := FND_API.G_TRUE,
921: p_move_deferred_tax IN varchar2 := 'Y',

Line 919: ar_adjustments.adjustment_id%type,

915: ar_adjustments%rowtype,
916: p_adjustment_number OUT NOCOPY
917: ar_adjustments.adjustment_number%type,
918: p_adjustment_id OUT NOCOPY
919: ar_adjustments.adjustment_id%type,
920: p_check_amount IN varchar2 := FND_API.G_TRUE,
921: p_move_deferred_tax IN varchar2 := 'Y',
922: p_called_from IN varchar2 DEFAULT NULL,
923: p_old_adjust_id IN ar_adjustments.adjustment_id%type DEFAULT NULL,

Line 923: p_old_adjust_id IN ar_adjustments.adjustment_id%type DEFAULT NULL,

919: ar_adjustments.adjustment_id%type,
920: p_check_amount IN varchar2 := FND_API.G_TRUE,
921: p_move_deferred_tax IN varchar2 := 'Y',
922: p_called_from IN varchar2 DEFAULT NULL,
923: p_old_adjust_id IN ar_adjustments.adjustment_id%type DEFAULT NULL,
924: p_override_flag IN varchar2 DEFAULT NULL,
925: p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION')
926:
927:

Line 930: l_adjustment_id ar_adjustments.adjustment_id%type;

926:
927:
928: IS
929:
930: l_adjustment_id ar_adjustments.adjustment_id%type;
931: l_ps_rec ar_payment_schedules%rowtype;
932: l_acctd_amount ar_adjustments.acctd_amount%type;
933: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
934: l_aah_rec ar_approval_action_history%rowtype;

Line 932: l_acctd_amount ar_adjustments.acctd_amount%type;

928: IS
929:
930: l_adjustment_id ar_adjustments.adjustment_id%type;
931: l_ps_rec ar_payment_schedules%rowtype;
932: l_acctd_amount ar_adjustments.acctd_amount%type;
933: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
934: l_aah_rec ar_approval_action_history%rowtype;
935: l_approval_action_history_id
936: ar_approval_action_history.approval_action_history_id%type;

Line 942: l_adj_type ar_adjustments.type%type;

938: ln_acctd_adr_tmp NUMBER;
939: /* VAT changes */
940: l_ae_doc_rec ae_doc_rec_type;
941:
942: l_adj_type ar_adjustments.type%type;
943: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
944:
945: l_app_ps_status VARCHAR2(10);
946: --BUG#2750340

Line 1245: FROM ar_adjustments

1241: TAX_ADJUSTED
1242: INTO
1243: l_line_adjusted,
1244: l_tax_adjusted
1245: FROM ar_adjustments
1246: WHERE adjustment_id = l_adjustment_id;
1247:
1248: INSERT INTO AR_ACTIVITY_DETAILS (
1249: LINE_ID,

Line 1522: | Updates a record in ar_adjustments |

1518: | PROCEDURE |
1519: | update_adjustment |
1520: | |
1521: | DESCRIPTION |
1522: | Updates a record in ar_adjustments |
1523: | |
1524: | SCOPE - PUBLIC |
1525: | |
1526: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1567: p_adj_rec IN ar_adjustments%rowtype,

1563:
1564: PROCEDURE update_adjustment(
1565: p_form_name IN varchar2,
1566: p_form_version IN varchar2,
1567: p_adj_rec IN ar_adjustments%rowtype,
1568: p_move_deferred_tax IN varchar2 := 'Y',
1569: p_adjustment_id IN ar_adjustments.adjustment_id%type)
1570:
1571: IS

Line 1569: p_adjustment_id IN ar_adjustments.adjustment_id%type)

1565: p_form_name IN varchar2,
1566: p_form_version IN varchar2,
1567: p_adj_rec IN ar_adjustments%rowtype,
1568: p_move_deferred_tax IN varchar2 := 'Y',
1569: p_adjustment_id IN ar_adjustments.adjustment_id%type)
1570:
1571: IS
1572:
1573: l_adj_rec ar_adjustments%rowtype;

Line 1573: l_adj_rec ar_adjustments%rowtype;

1569: p_adjustment_id IN ar_adjustments.adjustment_id%type)
1570:
1571: IS
1572:
1573: l_adj_rec ar_adjustments%rowtype;
1574: l_aah_rec ar_approval_action_history%rowtype;
1575: l_ps_rec ar_payment_schedules%rowtype;
1576: l_approval_action_history_id
1577: ar_approval_action_history.approval_action_history_id%type;

Line 1579: l_old_adj_rec ar_adjustments%rowtype;

1575: l_ps_rec ar_payment_schedules%rowtype;
1576: l_approval_action_history_id
1577: ar_approval_action_history.approval_action_history_id%type;
1578: l_status_changed_flag boolean;
1579: l_old_adj_rec ar_adjustments%rowtype;
1580: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
1581: l_ae_doc_rec ae_doc_rec_type;
1582: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
1583: /* Bug fix 2377672

Line 1580: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;

1576: l_approval_action_history_id
1577: ar_approval_action_history.approval_action_history_id%type;
1578: l_status_changed_flag boolean;
1579: l_old_adj_rec ar_adjustments%rowtype;
1580: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
1581: l_ae_doc_rec ae_doc_rec_type;
1582: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
1583: /* Bug fix 2377672
1584: variables to decide whether the accounting needs to be re-created */

Line 1737: FROM ar_adjustments where payment_schedule_id=l_adj_rec.payment_schedule_id

1733: pending to be adjusted needs to be re-calculated*/
1734: BEGIN
1735: l_amount_adjusted_pending:=0;
1736: Select SUM(AMOUNT) into l_amount_adjusted_pending
1737: FROM ar_adjustments where payment_schedule_id=l_adj_rec.payment_schedule_id
1738: AND STATUS NOT IN ('A','R','U');
1739: UPDATE ar_payment_schedules set amount_adjusted_pending=
1740: DECODE(l_amount_adjusted_pending,0,NULL,l_amount_adjusted_pending)
1741: WHERE payment_schedule_id=l_adj_rec.payment_schedule_id;

Line 1796: ar_adjustments adj ,

1792: l_event_source_info.entity_type_code,
1793: l_event_source_info.source_id_int_1,
1794: l_event_source_info.application_id
1795: from
1796: ar_adjustments adj ,
1797: xla_transaction_entities_upg xet
1798: where adj.adjustment_id = p_adjustment_id
1799: and adj.adjustment_id = xet.source_id_int_1
1800: and xet.entity_code ='ADJUSTMENTS'

Line 1982: | Deletes a record from ar_adjustments |

1978: | PROCEDURE |
1979: | update_approve_adj |
1980: | |
1981: | DESCRIPTION |
1982: | Deletes a record from ar_adjustments |
1983: | |
1984: | SCOPE - PUBLIC |
1985: | |
1986: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2021: p_adj_rec IN ar_adjustments%rowtype,

2017: +===========================================================================*/
2018:
2019: PROCEDURE update_approve_adj(p_form_name IN varchar2,
2020: p_form_version IN number,
2021: p_adj_rec IN ar_adjustments%rowtype,
2022: p_adjustment_code ar_lookups.lookup_code%type,
2023: p_adjustment_id IN ar_adjustments.adjustment_id%type,
2024: p_chk_approval_limits IN varchar2,
2025: p_move_deferred_tax IN varchar2 := 'Y') IS

Line 2023: p_adjustment_id IN ar_adjustments.adjustment_id%type,

2019: PROCEDURE update_approve_adj(p_form_name IN varchar2,
2020: p_form_version IN number,
2021: p_adj_rec IN ar_adjustments%rowtype,
2022: p_adjustment_code ar_lookups.lookup_code%type,
2023: p_adjustment_id IN ar_adjustments.adjustment_id%type,
2024: p_chk_approval_limits IN varchar2,
2025: p_move_deferred_tax IN varchar2 := 'Y') IS
2026:
2027: l_ps_rec ar_payment_schedules%rowtype;

Line 2028: l_adj_rec ar_adjustments%rowtype;

2024: p_chk_approval_limits IN varchar2,
2025: p_move_deferred_tax IN varchar2 := 'Y') IS
2026:
2027: l_ps_rec ar_payment_schedules%rowtype;
2028: l_adj_rec ar_adjustments%rowtype;
2029: l_aah_rec ar_approval_action_history%rowtype;
2030: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2031:
2032: l_approval_action_history_id

Line 2030: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;

2026:
2027: l_ps_rec ar_payment_schedules%rowtype;
2028: l_adj_rec ar_adjustments%rowtype;
2029: l_aah_rec ar_approval_action_history%rowtype;
2030: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2031:
2032: l_approval_action_history_id
2033: ar_approval_action_history.approval_action_history_id%type;
2034: l_old_adj_rec ar_adjustments%rowtype;

Line 2034: l_old_adj_rec ar_adjustments%rowtype;

2030: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2031:
2032: l_approval_action_history_id
2033: ar_approval_action_history.approval_action_history_id%type;
2034: l_old_adj_rec ar_adjustments%rowtype;
2035: l_ae_doc_rec ae_doc_rec_type;
2036: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
2037: --BUG#2750340
2038: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 2225: | Update ar_adjustments |

2221:
2222: l_adj_rec.status := NVL( p_adjustment_code, l_adj_rec.status );
2223:
2224: /*--------------------------+
2225: | Update ar_adjustments |
2226: +--------------------------*/
2227:
2228: arp_adjustments_pkg.update_p( l_adj_rec,
2229: p_adjustment_id,

Line 2385: PROCEDURE test_adj( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

2381: | 12-SEP-95 Charlie Tomberg Created |
2382: | |
2383: +===========================================================================*/
2384:
2385: PROCEDURE test_adj( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
2386: p_result IN OUT NOCOPY varchar2,
2387: p_old_ps_rec IN OUT NOCOPY ar_payment_schedules%rowtype) IS
2388:
2389: l_new_ps_rec ar_payment_schedules%rowtype;

Line 2411: from ar_adjustments

2407: select decode(max(adjustment_id),
2408: NULL, 'A: Fail, ',
2409: 'A: Pass, ')
2410: into p_result
2411: from ar_adjustments
2412: where adjustment_id = p_adj_rec.adjustment_id
2413: and adjustment_number = p_adj_rec.adjustment_number
2414: and payment_schedule_id = p_adj_rec.payment_schedule_id
2415: and customer_trx_id = p_adj_rec.customer_trx_id

Line 2566: PROCEDURE validate_args_radj( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

2562: RAISE;
2563: END;
2564:
2565:
2566: PROCEDURE validate_args_radj( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
2567: p_reversal_gl_date IN DATE,
2568: p_reversal_date IN DATE );
2569: --
2570: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

Line 2570: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

2566: PROCEDURE validate_args_radj( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
2567: p_reversal_gl_date IN DATE,
2568: p_reversal_date IN DATE );
2569: --
2570: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
2571: p_reversal_gl_date IN DATE,
2572: p_reversal_date IN DATE );
2573: --
2574:

Line 2576: p_adj_id IN ar_adjustments.adjustment_id%TYPE );

2572: p_reversal_date IN DATE );
2573: --
2574:
2575: PROCEDURE val_insert_rev_actions(
2576: p_adj_id IN ar_adjustments.adjustment_id%TYPE );
2577: --
2578: /*===========================================================================+
2579: | PROCEDURE |
2580: | reverse_adjustment() |

Line 2584: | in the AR_ADJUSTMENTS table |

2580: | reverse_adjustment() |
2581: | |
2582: | DESCRIPTION |
2583: | This function reverses an adjustment by inserting an opposing entry |
2584: | in the AR_ADJUSTMENTS table |
2585: | |
2586: | SCOPE - PUBLIC |
2587: | |
2588: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2613: p_adj_id IN ar_adjustments.adjustment_id%TYPE,

2609: | Removed hard coded comment and replaced it
2610: | with message dictionary equivalent.
2611: +===========================================================================*/
2612: PROCEDURE reverse_adjustment(
2613: p_adj_id IN ar_adjustments.adjustment_id%TYPE,
2614: p_reversal_gl_date IN DATE,
2615: p_reversal_date IN DATE,
2616: p_module_name IN VARCHAR2,
2617: p_module_version IN VARCHAR2 ) IS

Line 2620: l_adj_rec ar_adjustments%ROWTYPE;

2616: p_module_name IN VARCHAR2,
2617: p_module_version IN VARCHAR2 ) IS
2618: l_aah_rec ar_approval_action_history%ROWTYPE;
2619: l_aah_id NUMBER;
2620: l_adj_rec ar_adjustments%ROWTYPE;
2621: l_ps_rec ar_payment_schedules%rowtype;
2622: --BUG#2750340
2623: l_xla_ev_rec arp_xla_events.xla_events_type;
2624:

Line 2637: -- Select from ar_adjustments to update status. This is just a

2633: THEN
2634: validate_args_radj( p_adj_id, p_reversal_gl_date, p_reversal_date );
2635: END IF;
2636:
2637: -- Select from ar_adjustments to update status. This is just a
2638: -- simple select statement, so not using a separate function. Also
2639: -- note that the WHERE clause is different than the fetch_p procedure
2640: -- in the table handler. Also locking the table
2641:

Line 2651: FROM ar_adjustments adj

2647: END IF;
2648: BEGIN
2649: SELECT *
2650: INTO l_adj_rec
2651: FROM ar_adjustments adj
2652: WHERE adj.adjustment_id = p_adj_id
2653: AND adj.status not in ('A', 'R')
2654: FOR UPDATE of adj.STATUS NOWAIT;
2655:

Line 2766: PROCEDURE validate_args_radj( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

2762: | |
2763: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
2764: | |
2765: +===========================================================================*/
2766: PROCEDURE validate_args_radj( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
2767: p_reversal_gl_date IN DATE,
2768: p_reversal_date IN DATE ) IS
2769: BEGIN
2770: IF PG_DEBUG in ('Y', 'C') THEN

Line 2819: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

2815: | |
2816: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
2817: | |
2818: +===========================================================================*/
2819: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
2820: p_reversal_gl_date IN DATE,
2821: p_reversal_date IN DATE ) IS
2822: l_adj_rec ar_adjustments%ROWTYPE;
2823: l_rev_gl_date DATE;

Line 2822: l_adj_rec ar_adjustments%ROWTYPE;

2818: +===========================================================================*/
2819: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
2820: p_reversal_gl_date IN DATE,
2821: p_reversal_date IN DATE ) IS
2822: l_adj_rec ar_adjustments%ROWTYPE;
2823: l_rev_gl_date DATE;
2824: l_error_message VARCHAR2(128);
2825: l_defaulting_rule_used VARCHAR2(100);
2826: l_default_gl_date DATE;

Line 2912: | arp_adj_pkg.insert_p - Insert a row into AR_ADJUSTMENTS table|

2908: | |
2909: | SCOPE - PUBLIC |
2910: | |
2911: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
2912: | arp_adj_pkg.insert_p - Insert a row into AR_ADJUSTMENTS table|
2913: | |
2914: | ARGUMENTS : IN OUT: |
2915: | p_adj_rec - Adjustment Record structure |
2916: | p_module_name _ Name of module that called this procedure|

Line 2936: p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,

2932: |10/16/1998 Sushama Borde Bug fix 741725: Used AOL API get_next_sequence
2933: | instead of get_seq_name.
2934: +===========================================================================*/
2935: PROCEDURE insert_reverse_actions (
2936: p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
2937: p_module_name IN VARCHAR2,
2938: p_module_version IN VARCHAR2 ) IS
2939: l_new_adj_id ar_adjustments.adjustment_id%TYPE;
2940: l_old_adj_id ar_adjustments.adjustment_id%TYPE;

Line 2939: l_new_adj_id ar_adjustments.adjustment_id%TYPE;

2935: PROCEDURE insert_reverse_actions (
2936: p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
2937: p_module_name IN VARCHAR2,
2938: p_module_version IN VARCHAR2 ) IS
2939: l_new_adj_id ar_adjustments.adjustment_id%TYPE;
2940: l_old_adj_id ar_adjustments.adjustment_id%TYPE;
2941:
2942: l_rec_name VARCHAR2(50);
2943: l_number NUMBER;

Line 2940: l_old_adj_id ar_adjustments.adjustment_id%TYPE;

2936: p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
2937: p_module_name IN VARCHAR2,
2938: p_module_version IN VARCHAR2 ) IS
2939: l_new_adj_id ar_adjustments.adjustment_id%TYPE;
2940: l_old_adj_id ar_adjustments.adjustment_id%TYPE;
2941:
2942: l_rec_name VARCHAR2(50);
2943: l_number NUMBER;
2944:

Line 3087: arp_standard.debug( 'before ar_adjustments_pkg.insert_p in app_delete' );

3083:
3084: -- Insert opposing adjustment
3085:
3086: IF PG_DEBUG in ('Y', 'C') THEN
3087: arp_standard.debug( 'before ar_adjustments_pkg.insert_p in app_delete' );
3088: END IF;
3089: arp_adj_pkg.insert_p( p_adj_rec, l_new_adj_id );
3090: IF PG_DEBUG in ('Y', 'C') THEN
3091: arp_standard.debug( 'after ar_adjustments_pkg.insert_p in app_delete' );

Line 3091: arp_standard.debug( 'after ar_adjustments_pkg.insert_p in app_delete' );

3087: arp_standard.debug( 'before ar_adjustments_pkg.insert_p in app_delete' );
3088: END IF;
3089: arp_adj_pkg.insert_p( p_adj_rec, l_new_adj_id );
3090: IF PG_DEBUG in ('Y', 'C') THEN
3091: arp_standard.debug( 'after ar_adjustments_pkg.insert_p in app_delete' );
3092: END IF;
3093:
3094: /* VAT changes: create acct entry */
3095:

Line 3178: p_adj_id IN ar_adjustments.adjustment_id%TYPE ) IS

3174: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
3175: | |
3176: +===========================================================================*/
3177: PROCEDURE val_insert_rev_actions(
3178: p_adj_id IN ar_adjustments.adjustment_id%TYPE ) IS
3179: BEGIN
3180: IF PG_DEBUG in ('Y', 'C') THEN
3181: arp_standard.debug( 'arp_process_adjustment.val_insert_rev_actions()+' );
3182: END IF;