DBA Data[Home] [Help]

APPS.ARP_BR_HOUSEKEEPER_PKG dependencies on AR_ADJUSTMENTS

Line 51: procedure approve_Adjustment(p_adjustment_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,

47:
48: procedure create_and_apply_Receipt(p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
49: p_receipt_date IN DATE);
50:
51: procedure approve_Adjustment(p_adjustment_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
52: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y');
53:
54: procedure apply_Receipt(p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
55: p_receipt_date IN DATE);

Line 634: from ar_adjustments adj

630: | Cursor to fetch last Endorsement adjustment |
631: +---------------------------------------------*/
632: CURSOR last_adjustment_cur IS
633: select adj.*
634: from ar_adjustments adj
635: where adj.customer_trx_id = pg_BR_rec.customer_trx_id
636: and adj.status = 'W'
637: order by adj.adjustment_id desc;
638:

Line 639: last_adjustment_rec ar_adjustments%ROWTYPE;

635: where adj.customer_trx_id = pg_BR_rec.customer_trx_id
636: and adj.status = 'W'
637: order by adj.adjustment_id desc;
638:
639: last_adjustment_rec ar_adjustments%ROWTYPE;
640:
641: l_move_deferred_tax VARCHAR2(1) := 'Y';
642: prev_trh_rec ar_transaction_history%ROWTYPE;
643:

Line 1091: PROCEDURE approve_Adjustment(p_adjustment_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,

1087: | MODIFICATION HISTORY |
1088: | 17-APR-2000 Jani Rautiainen Created |
1089: | |
1090: +===========================================================================*/
1091: PROCEDURE approve_Adjustment(p_adjustment_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
1092: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y') IS
1093:
1094: l_adj_rec ar_adjustments%rowtype;
1095: l_return_status VARCHAR2(1);

Line 1094: l_adj_rec ar_adjustments%rowtype;

1090: +===========================================================================*/
1091: PROCEDURE approve_Adjustment(p_adjustment_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
1092: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y') IS
1093:
1094: l_adj_rec ar_adjustments%rowtype;
1095: l_return_status VARCHAR2(1);
1096: l_msg_count NUMBER;
1097: l_msg_data VARCHAR2(2000);
1098: