[Home] [Help]
3277: p_acctd_amount IN NUMBER,
3278: p_gl_date IN DATE DEFAULT NULL,
3279: p_comments IN VARCHAR2 DEFAULT NULL,
3280: p_ram_desc_flexfield IN desc_flexfield,
3281: p_rev_adj_rec IN ar_revenue_adjustment_pvt.rev_adj_rec_type,
3282: p_delta_amount IN NUMBER DEFAULT 0,
3283: p_acctd_delta_amount IN NUMBER DEFAULT 0,
3284: x_adjustment_number OUT NOCOPY NUMBER,
3285: x_return_status OUT NOCOPY VARCHAR2,
3302: l_item_key wf_items.ITEM_KEY%TYPE;
3303: l_adjustment_id ar_adjustments.adjustment_id%TYPE;
3304: l_adjustment_number ar_adjustments.adjustment_number%TYPE;
3305:
3306: l_rev_adj_rec ar_revenue_adjustment_pvt.rev_adj_rec_type;
3307:
3308: BEGIN
3309:
3310: /*------------------------------------------------------------------------
5207: l_partially_recognized BOOLEAN;
5208: l_last_fetch BOOLEAN;
5209: l_line_status NUMBER;
5210: l_adjustment_number NUMBER;
5211: l_rev_adj_rec ar_revenue_adjustment_pvt.rev_adj_rec_type;
5212: l_ram_desc_flexfield desc_flexfield;
5213:
5214: l_customer_trx_id NUMBER;
5215: l_amount_due_original NUMBER;
5466: l_first_adjustment BOOLEAN DEFAULT TRUE;
5467: l_last_fetch BOOLEAN;
5468: l_line_status NUMBER;
5469: l_adjustment_number NUMBER;
5470: l_rev_adj_rec ar_revenue_adjustment_pvt.rev_adj_rec_type;
5471:
5472: l_return_status VARCHAR2(30);
5473: l_msg_count NUMBER;
5474: l_msg_data VARCHAR2(150);
5939: l_last_fetch BOOLEAN;
5940: l_line_status NUMBER;
5941: l_adjustment_number NUMBER;
5942:
5943: l_rev_adj_rec ar_revenue_adjustment_pvt.rev_adj_rec_type;
5944: l_ram_desc_flexfield desc_flexfield;
5945:
5946: lr_customer_trx_line_id_tbl number_table;
5947: lr_customer_trx_id_tbl number_table;
6479: l_acctd_amount_adjusted NUMBER;
6480: l_ram_amount NUMBER;
6481: l_acctd_ram_amount NUMBER;
6482: l_adjustment_number NUMBER;
6483: l_rev_adj_rec ar_revenue_adjustment_pvt.rev_adj_rec_type;
6484: l_ram_desc_flexfield desc_flexfield;
6485:
6486: ------------------------------
6487: -- columns from the rvmg table