[Home] [Help]
PACKAGE: APPS.ARP_CREDIT_MEMO_MODULE
Source
1 PACKAGE arp_credit_memo_module AS
2 /* $Header: ARTECMMS.pls 120.7.12010000.1 2008/07/24 16:55:38 appldev ship $ */
3
4 --
5 -- global error buffer
6 --
7 g_error_buffer VARCHAR2(1000);
8
9 --
10 -- Public user-defined exceptions
11 --
12 no_ccid EXCEPTION;
13
14
15 ----------------------------------------------------------------------------
16 --
17 -- PROCEDURE NAME: credit_transactions
18 --
19 -- DECSRIPTION:
20 -- Server-side entry point for the CM module.
21 --
22 -- ARGUMENTS:
23 -- IN:
24 -- customer_trx_id
25 -- customer_trx_line_id
26 -- prev_customer_trx_id
27 -- prev_cust_trx_line_id
28 -- request_id
29 -- process_mode (I)nsert or (U)pdate
30 --
31 -- IN/OUT:
32 -- failure_count
33 --
34 -- OUT:
35 --
36 -- NOTES:
37 -- Raises the exception arp_credit_memo_module.no_ccid if autoaccounting
38 -- could not derive a valid code combination. The public variable
39 -- g_error_buffer is populated for more information.
40 --
41 -- Raises the exception NO_DATA_FOUND if no rows were selected for
42 -- processing.
43 --
44 -- Exception raised if Oracle error.
45 -- App_exception is raised for all other fatal errors and a message
46 -- is put on the AOL stack. The public variable g_error_buffer is
47 -- populated for both types of errors.
48 --
49 --
50 -- HISTORY:
51 --
52 ----------------------------------------------------------------------------
53 PROCEDURE credit_transactions(
54 p_customer_trx_id IN NUMBER,
55 p_customer_trx_line_id IN NUMBER,
56 p_prev_customer_trx_id IN NUMBER,
57 p_prev_cust_trx_line_id IN NUMBER,
58 p_request_id IN NUMBER,
59 p_failure_count IN OUT NOCOPY NUMBER,
60 p_process_mode IN VARCHAR2 DEFAULT 'I'
61 );
62
63
64 ----------------------------------------------------------------------------
65 --
66 -- PROCEDURE NAME: credit_transactions
67 --
68 -- DECSRIPTION:
69 -- Server-side entry point for the CM module.
70 --
71 -- ARGUMENTS:
72 -- IN:
73 -- customer_trx_id
74 -- customer_trx_line_id
75 -- prev_customer_trx_id
76 -- prev_cust_trx_line_id
77 -- request_id
78 -- process_mode (I)nsert or (U)pdate
79 --
80 -- IN/OUT:
81 -- failure_count
82 -- rule_start_date
83 -- accounting_rule_duration
84 --
85 -- OUT:
86 --
87 -- NOTES:
88 -- Raises the exception arp_credit_memo_module.no_ccid if autoaccounting
89 -- could not derive a valid code combination. The public variable
90 -- g_error_buffer is populated for more information.
91 --
92 -- Raises the exception NO_DATA_FOUND if no rows were selected for
93 -- processing.
94 --
95 -- Exception raised if Oracle error.
96 -- App_exception is raised for all other fatal errors and a message
97 -- is put on the AOL stack. The public variable g_error_buffer is
98 -- populated for both types of errors.
99 --
100 --
101 -- HISTORY:
102 --
103 ----------------------------------------------------------------------------
104 PROCEDURE credit_transactions(
105 p_customer_trx_id IN NUMBER,
106 p_customer_trx_line_id IN NUMBER,
107 p_prev_customer_trx_id IN NUMBER,
108 p_prev_cust_trx_line_id IN NUMBER,
109 p_request_id IN NUMBER,
110 p_failure_count IN OUT NOCOPY NUMBER,
111 p_rule_start_date IN OUT NOCOPY DATE,
112 p_accounting_rule_duration IN OUT NOCOPY NUMBER,
113 p_process_mode IN VARCHAR2 DEFAULT 'I',
114 p_run_autoaccounting_flag IN BOOLEAN DEFAULT TRUE
115 );
116
117
118 PROCEDURE test_build_update_mode_sql;
119 PROCEDURE test_build_nonrule_sql;
120 PROCEDURE test_build_rule_sql;
121 PROCEDURE test_build_net_revenue_sql;
122 PROCEDURE test_load_net_revenue( p_prev_ctlid NUMBER );
123 PROCEDURE test_credit_nonrule_trxs(
124 p_customer_trx_id NUMBER,
125 p_customer_trx_line_id NUMBER,
126 p_request_id NUMBER );
127
128 PROCEDURE test_credit_rule_trxs(
129 p_customer_trx_id NUMBER,
130 p_prev_customer_trx_id NUMBER,
131 p_customer_trx_line_id NUMBER,
132 p_prev_cust_trx_line_id NUMBER,
133 p_request_id NUMBER );
134
135 /* 6129294 - added to support date overrides on RAM'd transactions */
136 FUNCTION get_valid_date(
137 p_gl_date IN DATE,
138 p_inv_rule_id IN NUMBER,
139 p_set_of_books_id IN NUMBER)
140 RETURN DATE;
141
142 PROCEDURE init;
143
144 END arp_credit_memo_module;