[Home] [Help]
PACKAGE: APPS.ARP_ROUNDING
Source
1 PACKAGE ARP_ROUNDING AUTHID CURRENT_USER AS
2 /* $Header: ARPLCRES.pls 120.5 2008/04/21 19:08:05 mraymond ship $ */
3
4
5 /*-------------------------------------------------------------------------+
6 | PUBLIC FUNCTION |
7 | correct_dist_rounding_errors() |
8 | |
9 | DESCRIPTION |
10 | This function corrects all rounding errors in the |
11 | ra_cust_trx_line_gl_dist table. |
12 | |
13 | REQUIRES |
14 | P_REQUEST_ID, P_CUSTOMER_TRX_ID or P_CUSTOMER_TRX_LINE_ID |
15 | |
16 | RETURNS |
17 | TRUE if no errors occur |
18 | FALSE otherwise. |
19 | |
20 | NOTES |
21 | |
22 | EXAMPLE |
23 | |
24 | MODIFICATION HISTORY |
25 | 03-AUG-02 M Raymond Bug 2497841 - Added parameter p_fix_rec_offset
26 | to control call to set_rec_offset_flag routine.
27 |
28 +-------------------------------------------------------------------------*/
29
30
31 FUNCTION correct_dist_rounding_errors
32 ( P_REQUEST_ID IN NUMBER,
33 P_CUSTOMER_TRX_ID IN NUMBER,
34 P_CUSTOMER_TRX_LINE_ID IN NUMBER,
35 P_ROWS_PROCESSED IN OUT NOCOPY NUMBER,
36 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2,
37 P_BASE_PRECISION IN NUMBER,
38 P_BASE_MIN_ACCOUNTABLE_UNIT IN VARCHAR2,
39 P_TRX_CLASS_TO_PROCESS IN VARCHAR2 DEFAULT 'ALL',
40 P_CHECK_RULES_FLAG IN VARCHAR2 DEFAULT 'N',
41 P_DEBUG_MODE IN VARCHAR2,
42 P_TRX_HEADER_LEVEL_ROUNDING IN VARCHAR2 DEFAULT 'N',
43 P_ACTIVITY_FLAG IN VARCHAR2 DEFAULT 'N',
44 P_FIX_REC_OFFSET IN VARCHAR2 DEFAULT 'Y'
45 ) RETURN NUMBER;
46
47
48 /*-------------------------------------------------------------------------+
49 | PUBLIC PROCEDURE |
50 | correct_scredit_rounding_errors() |
51 | |
52 | DESCRIPTION |
53 | This function corrects all rounding errors in the |
54 | ra_cust_trx_line_salesreps table. |
55 | |
56 | REQUIRES |
57 | P_CUSTOMER_TRX_ID |
58 | |
59 | NOTES |
60 | |
61 | EXAMPLE |
62 | |
63 | MODIFICATION HISTORY |
64 | 30-AUG-95 Charlie Tomberg Created |
65 +-------------------------------------------------------------------------*/
66
67 PROCEDURE correct_scredit_rounding_errs( p_customer_trx_id IN NUMBER,
68 p_rows_processed OUT NOCOPY NUMBER
69 );
70
71
72 /*-------------------------------------------------------------------------+
73 | PUBLIC PROCEDURE |
74 | set_rec_offset_flag() |
75 | |
76 | DESCRIPTION |
77 | This function attempts to set the rec_offset_flag on UNEARN lines
78 | for the specified transaction. |
79 | |
80 | REQUIRES |
81 | P_CUSTOMER_TRX_ID |
82 | P_REQUEST_ID
83 | |
84 | NOTES |
85 | |
86 | EXAMPLE |
87 | |
88 | MODIFICATION HISTORY |
89 | 28-AUG-02 Michael Raymond Created |
90 | 28-AUG-02 Michael Raymond Added request_id parameter
91 | 27-MAR-08 M Raymond 6782405 - Added p_result parameter
92 | -1 = No rows updated
93 | 0 = No action required
94 | 1 = Rows updated
95 +-------------------------------------------------------------------------*/
96
97 PROCEDURE set_rec_offset_flag( p_customer_trx_id IN
98 ra_customer_trx.customer_trx_id%type,
99 p_request_id IN ra_customer_trx.request_id%type,
100 p_result OUT NOCOPY NUMBER);
101
102 /*-------------------------------------------------------------------------+
103 | PUBLIC PROCEDURE |
104 | insert_round_records() |
105 | |
106 | DESCRIPTION |
107 | This function inserts ROUND class rows in gl_dist table when/if
108 | they do not already exist.
109 | |
110 | REQUIRES |
111 | P_CUSTOMER_TRX_ID |
112 | P_REQUEST_ID
113 | P_BASE_PRECISION
114 | P_BASE_MAU
115 | P_TRX_CLASS_TO_PROCESS
116 | P_TRX_HEADER_ROUND_CCID
117 | |
118 | NOTES |
119 | |
120 | EXAMPLE |
121 | |
122 | MODIFICATION HISTORY |
123 | 01-OCT-03 Michael Raymond Made public for bug 2975417/3067588 |
124 +-------------------------------------------------------------------------*/
125 FUNCTION insert_round_records( P_REQUEST_ID IN NUMBER,
126 P_CUSTOMER_TRX_ID IN NUMBER,
127 P_ROWS_PROCESSED IN OUT NOCOPY NUMBER,
128 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2,
129 P_BASE_PRECISION IN NUMBER,
130 P_BASE_MAU IN NUMBER,
131 P_TRX_CLASS_TO_PROCESS IN VARCHAR2,
132 P_TRX_HEADER_ROUND_CCID IN NUMBER)
133 RETURN NUMBER;
134
135
136 FUNCTION get_line_round_acctd_amount(P_CUSTOMER_TRX_ID IN NUMBER)
137 RETURN NUMBER;
138
139 /* Bug 3879222 - new function for rounding revenue adjustments */
140 FUNCTION correct_rev_adj_by_line
141 RETURN NUMBER;
142
143
144 /************************************************
145 FUNCTION get_dist_round_acctd_amount is obsolete
146 *************************************************/
147 FUNCTION get_dist_round_acctd_amount(P_CUSTOMER_TRX_ID IN NUMBER)
148 RETURN NUMBER;
149
150 END ARP_ROUNDING;