1 PACKAGE ARP_AUTO_RULE AS
2 /* $Header: ARPLARLS.pls 120.2.12010000.2 2008/11/13 20:11:20 mraymond ship $ */
3
4 /*-------------------------------------------------------------------------+
5 | PUBLIC FUNCTION |
6 | |
7 | create_distributions |
8 | |
9 | DESCRIPTION |
10 | This function will generate General Ledger distributions for all |
11 | transaction lines that have model accounts and have incomplete |
12 | autorule expansions against them. |
13 | |
14 | REQUIRES |
15 | user_id AOL who information |
16 | request_id |
17 | program_application_id |
18 | program_id |
19 | |
20 | RETURNS |
21 | n Count of number of rows inserted |
22 | |
23 | NOTES |
24 | |
25 | EXAMPLE |
26 | |
27 | MODIFICATION HISTORY |
28 | 22-Jan-93 Nigel Smith Created. |
29 | 21-Feb-93 Nigel Smith Updated to interface with PL/SQL 1 |
30 | 15-MAY-02 Michael Raymond Bug 2150541 - added p_suppress_round
31 | to create_distributions for diagnostic
32 | purposes. During normal execution, this
33 | parameter will always be null.
34 | 08-JUL-02 Michael Raymond Bug 2399504 - Added p_continue_on_error
35 | parameter to create_distributions for
36 | diagnostic purposes. During normal
37 | execution, this parameter will always
38 | be null. When this parameter is not
39 | null, Revenue Recognition will rollback
40 | each bad transaction - but it will
41 | process all good ones to completion.
42 +-------------------------------------------------------------------------*/
43
44
45 FUNCTION create_distributions(p_commit IN VARCHAR2,
46 p_debug IN VARCHAR2,
47 p_trx_id IN NUMBER DEFAULT NULL,
48 p_suppress_round IN VARCHAR2 DEFAULT NULL,
49 p_continue_on_error IN VARCHAR2 DEFAULT NULL)
50 RETURN NUMBER;
51
52 PROCEDURE refresh (Errbuf OUT NOCOPY VARCHAR2,
53 Retcode OUT NOCOPY VARCHAR2);
54
55 FUNCTION assign_gl_date(p_gl_date IN DATE)
56
57 RETURN DATE;
58
59
60 FUNCTION assign_gl_rec(p_gl_date IN DATE)
61
62 RETURN DATE;
63
64 /* 7131147 - needed in AREBTSRB.pls */
65 FUNCTION create_other_tax(p_trx_id IN NUMBER,
66 p_base_precision IN NUMBER,
67 p_bmau IN NUMBER,
68 p_ignore_rule_flag IN VARCHAR2 DEFAULT NULL)
69 RETURN NUMBER;
70
71 END ARP_AUTO_RULE;