1 PACKAGE jai_rcv_accounting_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_rcv_accnt.pls 120.1 2005/07/20 12:59:01 avallabh ship $ */
3
4 /* Cursor Definitions */
5 cursor c_trx(cp_transaction_id in number) IS
6 select *
7 from JAI_RCV_TRANSACTIONS
8 where transaction_id = cp_transaction_id;
9
10 cursor c_base_trx(cp_transaction_id in number) IS
11 select *
12 from rcv_transactions
13 where transaction_id = cp_transaction_id;
14
15 PROCEDURE process_transaction
16 (
17 p_transaction_id in number,
18 p_acct_type in varchar2,
19 p_acct_nature in varchar2,
20 p_source_name in varchar2,
21 p_category_name in varchar2,
22 p_code_combination_id in number,
23 p_entered_dr in number,
24 p_entered_cr in number,
25 p_currency_code in varchar2,
26 p_accounting_date in date,
27 p_reference_10 in varchar2,
28 p_reference_23 in varchar2,
29 p_reference_24 in varchar2,
30 p_reference_25 in varchar2,
31 p_reference_26 in varchar2,
32 p_destination in varchar2,
33 p_simulate_flag in varchar2,
34 p_codepath in OUT NOCOPY varchar2,
35 p_process_message OUT NOCOPY varchar2,
36 p_process_status OUT NOCOPY varchar2,
37 /* two parameters added by Vijay Shankar for Bug#4250236(4245089). VAT Implementation */
38 p_reference_name in varchar2 DEFAULT NULL,
39 p_reference_id in number DEFAULT NULL
40 );
41
42 PROCEDURE gl_entry
43 (
44 p_organization_id in number,
45 p_organization_code in varchar2,
46 p_set_of_books_id in number,
47 p_credit_amount in number,
48 p_debit_amount in number,
49 p_cc_id in number,
50 p_je_source_name in varchar2,
51 p_je_category_name in varchar2,
52 p_created_by in number,
53 p_accounting_date in date default null,
54 p_currency_code in varchar2,
55 p_currency_conversion_date in date default null,
56 p_currency_conversion_type in varchar2 default null,
57 p_currency_conversion_rate in number default null,
58 p_reference_10 in varchar2 default null,
59 p_reference_23 in varchar2 default null,
60 p_reference_24 in varchar2 default null,
61 p_reference_25 in varchar2 default null,
62 p_reference_26 in varchar2 default null ,
63 p_process_message OUT NOCOPY varchar2,
64 p_process_status OUT NOCOPY varchar2,
65 p_codepath in OUT NOCOPY varchar2
66 );
67
68 PROCEDURE average_costing
69 (
70 p_receiving_account_id in number,
71 p_new_cost in number,
72 p_organization_id in number,
73 p_item_id in number,
74 p_shipment_line_id in number,
75 p_transaction_uom in varchar2,
76 p_transaction_date in date,
77 p_subinventory in varchar2,
78 p_func_currency in varchar2,
79 p_transaction_id in number default null,
80 p_process_message OUT NOCOPY varchar2,
81 p_process_status OUT NOCOPY varchar2,
82 p_codepath in OUT NOCOPY varchar2
83 );
84
85 PROCEDURE rcv_receiving_sub_ledger_entry
86 (
87 p_transaction_id in number,
88 p_organization_id in number,
89 p_set_of_books_id in number,
90 p_currency_code in varchar2,
91 p_credit_amount in number,
92 p_debit_amount in number,
93 p_cc_id in number,
94 p_shipment_line_id in number,
95 p_item_id in number,
96 p_source_document_code in varchar2,
97 p_po_line_location_id in number,
98 p_requisition_line_id in number,
99 p_accounting_date in date default null,
100 p_currency_conversion_date in date default null,
101 p_currency_conversion_type in varchar2 default null,
102 p_currency_conversion_rate in number default null,
103 p_process_message OUT NOCOPY varchar2,
104 p_process_status OUT NOCOPY varchar2,
105 p_codepath in OUT NOCOPY varchar2
106 );
107
108 PROCEDURE mta_entry
109 (
110 p_transaction_id in number,
111 p_reference_account in number,
112 p_debit_credit_flag in varchar2,
113 p_tax_amount in number,
114 p_transaction_date in date default null,
115 p_currency_code in varchar2 default null,
116 p_currency_conversion_date in date default null,
117 p_currency_conversion_type in varchar2 default null,
118 p_currency_conversion_rate in number default null,
119 p_source_name in varchar2 default null, /*rchandan for bug#4473022 start*/
120 p_category_name in VARCHAR2 default null,
121 p_accounting_date in DATE default null,
122 p_reference_23 in varchar2 default null,
123 p_reference_24 in varchar2 default null,
124 p_reference_26 in varchar2 default null,/*rchandan for bug#4473022 end*/
125 p_process_message OUT NOCOPY varchar2,
126 p_process_status OUT NOCOPY varchar2,
127 p_codepath in OUT NOCOPY varchar2
128 );
129
130 PROCEDURE rcv_transactions_update
131 (
132 p_transaction_id in number,
133 p_costing_amount in number,
134 p_process_message OUT NOCOPY varchar2,
135 p_process_status OUT NOCOPY varchar2,
136 p_codepath in OUT NOCOPY varchar2
137 );
138
139 end jai_rcv_accounting_pkg;