PACKAGE: APPS.ARP_REVENUE_ASSIGNMENTS

Source

1 PACKAGE arp_revenue_assignments AS
2 /* $Header: ARREVUS.pls 120.2 2005/10/30 04:24:53 appldev noship $ */
3 
4 /* ==================================================================================
5  | PROCEDURE build_for_credit
6  |
7  | DESCRIPTION
8  |   This procedure populates ar_revenue_assignments_gt (a global temporary
9  |   table) with rows from ar_revenue_assignments (the view).  In 11i apps,
10  |   the CBO seems to have a lot of trouble with any sql containing this
11  |   view.  So this is an effort to offload that work to a separate
12  |   sql step.
13  |
14  | SCOPE - PUBLIC
15  |
16  | PARAMETERS
17  |      p_session_id         IN      session id from calling program
18  |      p_period_set_name    IN      Period set name
19  |      p_request_id         IN      request_id (if coming from RAXTRX)
20  |      p_customer_trx_id    IN      customer_trx_id
21  |      p_customer_trx_line_id IN    customer_trx_line_id
22  |
23  *===================================================================================*/
24    PROCEDURE build_for_credit(
25       p_session_id         IN     NUMBER,
26       p_period_set_name    IN     gl_periods.period_set_name%TYPE,
27       p_request_id         IN     ra_customer_trx_all.request_id%TYPE,
28       p_customer_trx_id    IN     ra_customer_trx_all.customer_trx_id%TYPE,
29       p_customer_trx_line_id  IN  ra_customer_trx_lines_all.customer_trx_line_id%TYPE
30       );
31 
32 END arp_revenue_assignments;