1 PACKAGE AR_MRC_ENGINE2 AS
2 /* $Header: ARMCEN2S.pls 120.1 2004/12/03 01:45:51 orashid noship $ */
3
4 /*============================================================================+
5 | Declare PUBLIC Data Types and Variables |
6 +============================================================================*/
7
8 /*=============================================================================
9 | PUBLIC PROCEDURE Maintain_MRC_Data2
10 |
11 | DESCRIPTION:
12 | Initial Entry point for all AR code in order to maintain,
13 | create, and delete any MRC data for the following Tables:
14 | AR_DISTRIBTIONS
15 | AR_RECEIVABLE_APPLICATIONS
16 | RA_CUST_TRX_LINE_GL_DIST
17 |
18 | This procedure will call the appropriate MRC api with the
19 | information required.
20 |
21 | PARAMETERS
22 | p_event_mode IN event to preform on MRC tables
23 | p_table_name IN Base Table Name.
24 | p_key_value IN primary key value
25 | p_row_info IN AR_DISTRIBTIONS%ROWTYPE
26 |
27 | KNOWN ISSUES:
28 |
29 | NOTES:
30 |
31 | MODIFICATION HISTORY
32 | Date Author Description of Change
33 | 04/25/02 Debbie Sue Jancis Created
34 |
35 *============================================================================*/
36 PROCEDURE Maintain_MRC_Data2(
37 p_event_mode IN VARCHAR2,
38 p_table_name IN VARCHAR2,
39 p_mode IN VARCHAR,
40 p_key_value IN NUMBER default NULL,
41 p_key_value_list IN gl_ca_utility_pkg.r_key_value_arr default NULL,
42 p_row_info IN AR_DISTRIBUTIONS%ROWTYPE DEFAULT NULL
43 );
44
45 /*===========================================================================
46 | PROCEDURE mrc_bulk_process
47 |
48 | DESCRIPTION:
49 | This procedure will be called by auto receipts to insert
50 | records into MRC tables using BULK processing
51 |
52 | CALLS PROCEDURES / FUNCTIONS
53 |
54 | ar_mc_info.rec_mrc_bulk_process (MRC bulk processing API
55 | called from Auto Receipts
56 | for ar_cash_Receipts,
57 | ar_cash_Receipt_history,
58 | and ar_payment_schedules inserts)
59 | PARAMETERS
60 | p_prog_name IN VARCHAR (AUTOREC)
61 | p_request_id IN VARCHAR2
62 | p_batch_id IN VARCHAR2
63 | p_confirmed_flag IN VARCHAR2
64 | p_history_status IN VARCHAR2
65 |
66 | KNOWN ISSUES:
67 |
68 | NOTES:
69 | MODIFICATION HISTORY
70 | Date Author Description of Change
71 | 07/24/02 Debbie Sue Jancis Created
72 *============================================================================*/
73 PROCEDURE mrc_bulk_process(
74 p_prog_name IN VARCHAR2,
75 p_created_from IN VARCHAR2,
76 p_request_id IN VARCHAR2,
77 p_batch_id IN VARCHAR2,
78 p_confirmed_flag IN VARCHAR2,
79 p_history_status IN VARCHAR2
80 );
81
82 /*===========================================================================
83 | PROCEDURE mrc_correct_rounding
84 |
85 | DESCRIPTION:
86 | This procedure will be called by the rounding package to
87 | handle rounding in the MRC table
88 |
89 | CALLS PROCEDURES / FUNCTIONS
90 |
91 | ar_mc_info.correct_receivables_header
92 | ar_mc_info.correct_nonrule_line_records
93 | ar_mc_info.correct_receivables_records
94 | ar_mc_info.correct_round_records
95 | ar_mc_info.correct_rul_records_by_line
96 |
97 | PARAMETERS
98 | rounding_prog_name IN VARCHAR2,
99 | p_request_id IN NUMBER,
100 | p_customer_trx_id IN NUMBER,
101 | p_customer_trx_line_id IN NUMBER,
102 | p_trx_class_to_process IN VARCHAR2,
103 | concat_segs IN VARCHAR2 default null,
104 | balanced_round_ccid IN NUMBER default null,
105 | p_check_rules_flag IN VARCHAR2 default null,
106 | p_period_set_name IN VARCHAR2 default null
107 |
108 | KNOWN ISSUES:
109 |
110 | NOTES:
111 | MODIFICATION HISTORY
112 | Date Author Description of Change
113 | 08/20/02 Debbie Sue Jancis Created
114 *============================================================================*/
115 PROCEDURE mrc_correct_rounding(
116 rounding_prog_name IN VARCHAR2,
117 p_request_id IN NUMBER,
118 p_customer_trx_id IN NUMBER,
119 p_customer_trx_line_id IN NUMBER,
120 p_trx_class_to_process IN VARCHAR2,
121 concat_segs IN VARCHAR2 default null,
122 balanced_round_ccid IN NUMBER default null,
123 p_check_rules_flag IN VARCHAR2 default null,
124 p_period_set_name IN VARCHAR2 default null
125 );
126
127 END AR_MRC_ENGINE2;