APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on AR_REVENUE_ADJUSTMENTS

Line 4587: SELECT ar_revenue_adjustments_s1.NEXTVAL

4583: IS
4584: l_adjustment_number VARCHAR2(20);
4585:
4586: CURSOR c_adjustment_id IS
4587: SELECT ar_revenue_adjustments_s1.NEXTVAL
4588: FROM dual;
4589:
4590: CURSOR c_adjustment_number IS
4591: SELECT ar_revenue_adjustments_s2.NEXTVAL

Line 4591: SELECT ar_revenue_adjustments_s2.NEXTVAL

4587: SELECT ar_revenue_adjustments_s1.NEXTVAL
4588: FROM dual;
4589:
4590: CURSOR c_adjustment_number IS
4591: SELECT ar_revenue_adjustments_s2.NEXTVAL
4592: FROM dual;
4593:
4594: BEGIN
4595: IF PG_DEBUG in ('Y', 'C') THEN

Line 4607: INSERT INTO ar_revenue_adjustments

4603: OPEN c_adjustment_number;
4604: FETCH c_adjustment_number INTO x_adjustment_number;
4605: CLOSE c_adjustment_number;
4606:
4607: INSERT INTO ar_revenue_adjustments
4608: (revenue_adjustment_id
4609: ,revenue_adjustment_number
4610: ,customer_trx_id
4611: ,application_date

Line 5396: p_comments IN ar_revenue_adjustments.comments%TYPE,

5392: p_category_id IN mtl_categories.category_id%TYPE,
5393: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
5394: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
5395: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE,
5396: p_comments IN ar_revenue_adjustments.comments%TYPE,
5397: p_ram_desc_flexfield IN ar_revenue_management_pvt.desc_flexfield,
5398: x_scenario OUT NOCOPY NUMBER,
5399: x_first_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,
5400: x_last_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,

Line 5399: x_first_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,

5395: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE,
5396: p_comments IN ar_revenue_adjustments.comments%TYPE,
5397: p_ram_desc_flexfield IN ar_revenue_management_pvt.desc_flexfield,
5398: x_scenario OUT NOCOPY NUMBER,
5399: x_first_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,
5400: x_last_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,
5401: x_return_status OUT NOCOPY VARCHAR2,
5402: x_msg_count OUT NOCOPY NUMBER,
5403: x_msg_data OUT NOCOPY VARCHAR2)

Line 5400: x_last_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,

5396: p_comments IN ar_revenue_adjustments.comments%TYPE,
5397: p_ram_desc_flexfield IN ar_revenue_management_pvt.desc_flexfield,
5398: x_scenario OUT NOCOPY NUMBER,
5399: x_first_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,
5400: x_last_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,
5401: x_return_status OUT NOCOPY VARCHAR2,
5402: x_msg_count OUT NOCOPY NUMBER,
5403: x_msg_data OUT NOCOPY VARCHAR2)
5404: IS

Line 5470: FROM ar_revenue_adjustments

5466: END IF;
5467: IF (x_first_rev_adj_id IS NULL AND l_first_adj_num IS NOT NULL)
5468: THEN
5469: select revenue_adjustment_id into x_first_rev_adj_id
5470: FROM ar_revenue_adjustments
5471: WHERE revenue_adjustment_number = l_first_adj_num;
5472: END IF;
5473: IF l_last_adj_num IS NOT NULL
5474: THEN

Line 5494: FROM ar_revenue_adjustments

5490: END IF;
5491: IF l_real_last_adj_num IS NOT NULL
5492: THEN
5493: select revenue_adjustment_id into x_last_rev_adj_id
5494: FROM ar_revenue_adjustments
5495: WHERE revenue_adjustment_number = l_real_last_adj_num;
5496: ELSE
5497: x_last_rev_adj_id := x_first_rev_adj_id;
5498: END IF;

Line 5528: FROM ar_revenue_adjustments

5524:
5525: IF l_first_adj_num IS NOT NULL
5526: THEN
5527: select revenue_adjustment_id into x_first_rev_adj_id
5528: FROM ar_revenue_adjustments
5529: WHERE revenue_adjustment_number = l_first_adj_num;
5530: END IF;
5531: END IF;
5532: IF l_last_adj_num IS NOT NULL

Line 5535: FROM ar_revenue_adjustments

5531: END IF;
5532: IF l_last_adj_num IS NOT NULL
5533: THEN
5534: select revenue_adjustment_id into x_last_rev_adj_id
5535: FROM ar_revenue_adjustments
5536: WHERE revenue_adjustment_number = l_last_adj_num;
5537: END IF;
5538: IF PG_DEBUG in ('Y', 'C') THEN
5539: arp_util.debug('Record_Acceptance: ' || 'l_first_adj_num = '||l_first_adj_num);