1 PACKAGE ARP_MISC_CASH_DIST AUTHID CURRENT_USER AS
2 /* $Header: ARREMCDS.pls 115.6 2003/10/29 10:00:33 rkader ship $ */
3 ----------------------- Data types -----------------------------
4
5
6 ------------------ Public functions/procedures -------------------
7
8 PROCEDURE delete_mcd_rec(
9 p_mcd_id IN
10 ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
11 p_form_name IN varchar2,
12 p_form_version IN varchar2
13 );
14
15 PROCEDURE insert_mcd_rec(
16 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
17 p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
18 p_percent IN ar_misc_cash_distributions.percent%TYPE,
19 p_amount IN ar_misc_cash_distributions.amount%TYPE,
20 p_comments IN ar_misc_cash_distributions.comments%TYPE,
21 p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
22 p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
23 p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
24 p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
25 p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
26 p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
27 p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
28 p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
29 p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
30 p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
31 p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
32 p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
33 p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
34 p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
35 p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
36 p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
37 p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
38 p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
39 p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
40 p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
41 p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
42 p_form_name IN varchar2,
43 p_form_version IN varchar2,
44 p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
45 p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
46 );
47
48
49 PROCEDURE update_mcd_rec(
50 p_misc_cash_distribution_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
51 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
52 p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53 p_percent IN ar_misc_cash_distributions.percent%TYPE,
54 p_amount IN ar_misc_cash_distributions.amount%TYPE,
55 p_comments IN ar_misc_cash_distributions.comments%TYPE,
56 p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
57 p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
58 p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
59 p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
60 p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
61 p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
62 p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
63 p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
64 p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
65 p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
66 p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
67 p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
68 p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
69 p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
70 p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
71 p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
72 p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
73 p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
74 p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
75 p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
76 p_form_name IN varchar2,
77 p_form_version IN varchar2,
78 p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
79 p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
80 );
81
82 PROCEDURE lock_mcd_rec(
83 p_misc_cash_distribution_id
84 IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
85 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
86 p_percent IN ar_misc_cash_distributions.percent%TYPE,
87 p_amount IN ar_misc_cash_distributions.amount%TYPE,
88 p_comments IN ar_misc_cash_distributions.comments%TYPE,
89 p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
90 p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
91 p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
92 p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
93 p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
94 p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
95 p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
96 p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
97 p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
98 p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
99 p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
100 p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
101 p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
102 p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
103 p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
104 p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
105 p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
106 p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
107 p_form_name IN varchar2,
108 p_form_version IN varchar2,
109 p_gl_posted_date IN ar_misc_cash_distributions.gl_posted_date%TYPE,
110 p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE /*Bug fix 3032059*/
111 );
112
113 PROCEDURE round_correction_mcd_rec(
114 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
115 p_flag OUT NOCOPY Number);
116
117 /* Bug fix 2300268 */
118 /* Function which returns the code combination id associated with the tax line of a MISC receipt */
119 FUNCTION misc_cash_tax_line_ccid_in_ard(
120 p_cash_receipt_id IN number) return NUMBER;
121 END ARP_MISC_CASH_DIST;