1 PACKAGE AR_MRC_ENGINE AS
2 /* $Header: ARMCENGS.pls 120.1 2004/12/03 01:45:53 orashid noship $ */
3
4 /*============================================================================+
5 | Declare PUBLIC Data Types and Variables |
6 +============================================================================*/
7
8 -- Init Record Type
9 TYPE ar_mrc_init_rec_type is RECORD (
10 p_table_name VARCHAR2(50), -- AR Base Table Name
11 p_mc_table_name VARCHAR2(50), -- Corresponsing MRC table name
12 p_application_id NUMBER, -- 222 for AR
13 p_mode VARCHAR2(11),
14 p_key_value NUMBER,
15 p_key_value_list gl_ca_utility_pkg.r_key_value_arr
16 );
17
18
19 /*=============================================================================
20 | PUBLIC PROCEDURE Maintain_MRC_Data
21 |
22 | DESCRIPTION:
23 | Initial Entry point for all AR code in order to maintain,
24 | create, and delete any MRC data
25 |
26 | This procedure will call the appropriate MRC api with the
27 | information required.
28 |
29 | PARAMETERS
30 | p_event_mode IN event to preform on MRC tables
31 | p_table_name IN Base Table Name.
32 | p_mode IN SINGLE /BATCH
33 | p_key_value IN primary key value
34 | p_key_value_list IN
35 |
36 | KNOWN ISSUES:
37 |
38 | NOTES:
39 |
40 | MODIFICATION HISTORY
41 | Date Author Description of Change
42 | 10/03/00 Debbie Sue Jancis Created
43 | 02/27/01 Debbie Sue Jancis Modified due to complete rewrite of
44 | MRC API's.
45 | 07/10/01 Debbie Sue Jancis Modified due to change in parameters
46 | for MRC API's which include changes
47 | implemented to AP implementation.
48 | 08/27/01 Debbie Sue Jancis Modified due to changes in parameters
49 | for MRC API's which include performance
50 | changes and removal of dynamic sql.
51 |
52 *============================================================================*/
53 PROCEDURE Maintain_MRC_Data(
54 p_event_mode IN VARCHAR2,
55 p_table_name IN VARCHAR2,
56 p_mode IN VARCHAR2,
57 p_key_value IN NUMBER default null,
58 p_key_value_list IN gl_ca_utility_pkg.r_key_value_arr default null
59 );
60
61 /*===========================================================================
62 | PROCEDURE init_struct
63 |
64 | DESCRIPTION:
65 | This procedure will initialize the global structure for MRC
66 | which will provide the values necessary to call the MRC
67 | api's for insert/update and delete into the MRC tables based
68 | upon the base table name passed in.
69 |
70 | PARAMETERS
71 | p_table_name IN AR Base table name
72 | p_mode IN SINGLE OR BATCH
73 | p_key_value IN
74 | p_key_value_list IN
75 |
76 | KNOWN ISSUES:
77 | At first attempt this is a prototype for the AR_ADJUSTMENTS and
78 | AR_RATE_ADJUSTMENTS tables. Once the prototype is complete, the
79 | other tables affected by MRC trigger logic will be incorporated.
80 |
81 | NOTES:
82 |
83 | MODIFICATION HISTORY
84 | Date Author Description of Change
85 | 10/9/00 Debbie Sue Jancis Created
86 | 02/27/01 Debbie Sue Jancis Modified due to complete redesign on MRC
87 | API's.
88 | 07/10/01 Debbie Sue Jancis Modified due to change in parameters
89 | for MRC API's which include changes
90 | implemented to AP implementation.
91 | 08/27/01 Debbie Sue Jancis Modified due to complete rewrite of
92 | MRC API's
93 |
94 *============================================================================*/
95 PROCEDURE init_struct(
96 p_table_name IN VARCHAR2,
97 p_mode IN VARCHAR2,
98 p_key_value IN NUMBER,
99 p_key_value_list IN gl_ca_utility_pkg.r_key_value_arr
100 );
101
102 /*===========================================================================
103 | PROCEDURE mrc_bulk_process
104 |
105 | DESCRIPTION:
106 | This procedure will be called by autoinvoice to insert
107 | records into MRC tables using BULK processing
108 |
109 | CALLS PROCEDURES / FUNCTIONS
110 |
111 | ar_mc_info.insert_mc_imp_adj (MRC bulk processing API
112 | called from AutoInvoice for
113 | ar_adjustments inserts)
114 | PARAMETERS
115 | p_request_id IN NUMBER
116 | p_tablename IN VARCHAR2 - AR BASE TABLE NAME
117 |
118 | KNOWN ISSUES:
119 |
120 | NOTES:
121 |
122 | For the initial coding, it was determined that this was required for
123 | the AR_ADJUSTMENTS table processing used in AUTOINVOICE to improve
124 | performance. Because a full analysis on the code has not been done
125 | for other tables, I am leaving in placeholders for those tables.
126 | if it is found that other calls will not be needed, those placeholders
127 | will be removed.
128 |
129 | MODIFICATION HISTORY
130 | Date Author Description of Change
131 | 07/18/01 Debbie Sue Jancis Created
132 *============================================================================*/
133 PROCEDURE mrc_bulk_process (
134 p_request_id IN VARCHAR2,
135 p_table_name IN VARCHAR2);
136
137 END AR_MRC_ENGINE;