1 PACKAGE PA_MC_BORRLENT AS
2 /* $Header: PAMRCBLS.pls 120.0 2005/05/29 22:14:56 appldev noship $ */
3
4 ----------------------------------------------------------------------------------
5 -- Start of comments
6 --
7 -- API Name : pa_mc_borrlent.bl_mc_delete
8 --
9 -- Type : Public
10 --
11 -- Pre-reqs : None
12 --
13 -- Function : This procedure is called from the Distribute Borrowed and Lent
14 -- Amounts package during mass delete of cross charge
15 -- distributions. .
16 --
17 -- The procedure deletes the corresponding MRC records
18 -- of all the dist_line_ids passed in
19 --
20 -- Parameters : Please see specification below
21 --
22 -- Version : Initial version
23 --
24 -- End of comments
25 ----------------------------------------------------------------------------------
26
27
28 PROCEDURE bl_mc_delete
29 (
30 p_cc_dist_line_id IN PA_PLSQL_DATATYPES.IDTabTyp
31 ,p_debug_mode IN boolean
32 );
33
34 ----------------------------------------------------------------------------------
35 -- Start of comments
36 --
37 -- API Name : pa_mc_borrlent.bl_mc_update
38 --
39 -- Type : Public
40 --
41 -- Pre-reqs : None
42 --
43 -- Function : This procedure is called from the Distribute Borrowed and Lent
44 -- Amounts package during mass update of cross charge
45 -- distributions.
46 --
47 -- The procedure updates the corresponding MRC records
48 -- of all the dist_line_ids passed in by computing the
49 -- corresponding amounts for each reporting set of
50 -- books passed in. It calls get_mrc_values which
51 -- does all the calculations
52 --
53 -- Parameters : Please see specification below
54 --
55 -- Version : Initial version
56 --
57 -- End of comments
58 ----------------------------------------------------------------------------------
59
60 PROCEDURE bl_mc_update
61 (
62 p_primary_sob_id IN gl_sets_of_books.set_of_books_id%TYPE
63 ,p_prvdr_org_id IN PA_PLSQL_DATATYPES.IDTabTyp
64 ,p_rsob_id IN PA_PLSQL_DATATYPES.IDTabTyp
65 ,p_rcurrency_code IN PA_PLSQL_DATATYPES.Char15TabTyp
66 ,p_cc_dist_line_id IN PA_PLSQL_DATATYPES.IDTabTyp
67 ,p_line_type IN PA_PLSQL_DATATYPES.Char2TabTyp
68 ,p_upd_type IN PA_PLSQL_DATATYPES.Char1TabTyp
69 ,p_expenditure_item_date IN PA_PLSQL_DATATYPES.DateTabTyp
70 ,p_expenditure_item_id IN PA_PLSQL_DATATYPES.IDTabTyp
71 DEFAULT PA_PLSQL_DATATYPES.EmptyIDTab
72 ,p_denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp
73 ,p_acct_tp_rate_type IN PA_PLSQL_DATATYPES.Char30TabTyp
74 ,p_acct_tp_exchange_rate IN PA_PLSQL_DATATYPES.NumTabTyp
75 ,p_denom_transfer_price IN PA_PLSQL_DATATYPES.NumTabTyp
76 ,p_cdl_line_num IN PA_PLSQL_DATATYPES.NumTabTyp
77 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
78 ,p_prvdr_cost_reclass_code IN PA_PLSQL_DATATYPES.Char240TabTyp
79 DEFAULT PA_PLSQL_DATATYPES.EmptyChar240Tab
80 ,p_login_id IN NUMBER
81 ,p_program_id IN NUMBER
82 ,p_program_application_id IN NUMBER
83 ,p_request_id IN NUMBER
84 ,p_debug_mode IN boolean
85 );
86
87 ----------------------------------------------------------------------------------
88 -- Start of comments
89 --
90 -- API Name : pa_mc_borrlent.bl_mc_insert
91 --
92 -- Type : Public
93 --
94 -- Pre-reqs : None
95 --
96 -- Function : This procedure is called from the Distribute Borrowed and Lent
97 -- Amounts package during mass update of cross charge
98 -- distributions AND during the MRC upgrade (when a new
99 -- reporting set of books is added)
100 --
101 -- The procedure insrts the corresponding MRC records
102 -- of all the dist_line_ids passed in by computing the
103 -- corresponding amounts for each reporting set of
104 -- books passed in. It calls get_mrc_values which
105 -- does all the calculations
106 --
107 -- Parameters : Please see specification below
108 --
109 -- Version : Initial version
110 --
111 -- End of comments
112 ----------------------------------------------------------------------------------
113
114 PROCEDURE bl_mc_insert
115 (
116 p_primary_sob_id IN gl_sets_of_books.set_of_books_id%TYPE
117 ,p_prvdr_org_id IN PA_PLSQL_DATATYPES.IDTabTyp
118 ,p_rsob_id IN PA_PLSQL_DATATYPES.IDTabTyp
119 ,p_rcurrency_code IN PA_PLSQL_DATATYPES.Char15TabTyp
120 ,p_cc_dist_line_id IN PA_PLSQL_DATATYPES.IDTabTyp
121 ,p_line_type IN PA_PLSQL_DATATYPES.Char2TabTyp
122 ,p_expenditure_item_id IN PA_PLSQL_DATATYPES.IDTabTyp
123 ,p_line_num IN PA_PLSQL_DATATYPES.IDTabTyp
124 ,p_denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp
125 ,p_acct_tp_rate_type IN PA_PLSQL_DATATYPES.Char30TabTyp
126 ,p_expenditure_item_date IN PA_PLSQL_DATATYPES.DateTabTyp
127 ,p_acct_tp_exchange_rate IN PA_PLSQL_DATATYPES.NumTabTyp
128 ,p_denom_transfer_price IN PA_PLSQL_DATATYPES.NumTabTyp
129 ,p_dist_line_id_reversed IN PA_PLSQL_DATATYPES.IDTabTyp
130 DEFAULT PA_PLSQL_DATATYPES.EmptyIDTab
131 ,p_cdl_line_num IN PA_PLSQL_DATATYPES.NumTabTyp
132 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
133 ,p_prvdr_cost_reclass_code IN PA_PLSQL_DATATYPES.Char240TabTyp
134 DEFAULT PA_PLSQL_DATATYPES.EmptyChar240Tab
135 ,p_login_id IN NUMBER
136 ,p_program_id IN NUMBER
137 ,p_program_application_id IN NUMBER
138 ,p_request_id IN NUMBER
139 ,p_debug_mode IN BOOLEAN
140 );
141
142 END PA_MC_BORRLENT;