1 PACKAGE jai_rcv_deliver_rtr_pkg AS
2 /* $Header: jai_rcv_del_rtr.pls 120.1 2005/07/20 12:59:03 avallabh ship $ */
3
4 cenvat_costed_flag CONSTANT VARCHAR2(30) := 'CENVAT_COSTED_FLAG';
5
6 CURSOR c_base_trx(cp_transaction_id IN NUMBER) IS
7 SELECT source_document_code, -- attribute_category, attribute5 rma_type, Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
8 quantity, unit_of_measure, source_doc_unit_of_measure, source_doc_quantity
9 from rcv_transactions
10 where transaction_id = cp_transaction_id;
11
12 /* Procedure Declaration sections */
13 PROCEDURE process_transaction
14 (
15 p_transaction_id IN NUMBER,
16 p_simulate IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
17 p_codepath IN OUT NOCOPY VARCHAR2,
18 p_process_message OUT NOCOPY VARCHAR2,
19 p_process_status OUT NOCOPY VARCHAR2,
20 -- Vijay Shankar for Bug#4068823. RECEIPTS DELUG
21 p_process_special_source IN VARCHAR2 DEFAULT NULL,
22 p_process_special_amount IN NUMBER DEFAULT NULL
23 );
24
25
26 PROCEDURE deliver_rtr_reco_nonexcise
27 (
28 p_transaction_id IN NUMBER,
29 p_transaction_date IN DATE,
30 p_organization_id IN NUMBER,
31 p_transaction_type IN VARCHAR2,
32 p_parent_transaction_type IN VARCHAR2,
33 p_receipt_num IN VARCHAR2,
34 p_shipment_line_id IN NUMBER,
35 p_currency_conversion_rate IN NUMBER,
36 p_apportion_factor IN NUMBER,
37 p_receiving_account_id IN NUMBER,
38 p_accounting_type IN VARCHAR2,
39 p_simulate IN VARCHAR2,
40 p_process_message OUT NOCOPY VARCHAR2,
41 p_process_status OUT NOCOPY VARCHAR2,
42 p_codepath IN OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE get_tax_amount_breakup
46 (
47 p_shipment_line_id IN NUMBER,
48 p_transaction_id IN NUMBER,
49 p_curr_conv_rate IN NUMBER,
50 p_excise_amount OUT NOCOPY NUMBER,
51 p_non_modvat_amount OUT NOCOPY NUMBER,
52 p_other_modvat_amount OUT NOCOPY NUMBER,
53 p_process_message OUT NOCOPY VARCHAR2,
54 p_process_status OUT NOCOPY VARCHAR2,
55 p_codepath IN OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE opm_costing
59 (
60 p_transaction_id IN NUMBER,
61 p_transaction_date IN DATE,
62 p_organization_id IN NUMBER,
63 p_costing_amount IN NUMBER,
64 p_receiving_account_id IN NUMBER,
65 p_rcv_unit_of_measure IN VARCHAR2, /*Indicates UOM of RECEIVE Line */
66 p_rcv_source_unit_of_measure IN VARCHAR2, /*Indicates Source UOM of RECEIVE Line */
67 p_rcv_quantity IN NUMBER, /*Indicates Quantity of RECEIVE Line */
68 p_source_doc_quantity IN NUMBER, /*Indicates Source doc Quantity of RECEIVE Line */
69 p_source_document_code IN VARCHAR2,
70 p_po_distribution_id IN NUMBER,
71 p_subinventory_code IN VARCHAR2,
72 p_simulate IN VARCHAR2,
73 p_process_message OUT NOCOPY VARCHAR2,
74 p_process_status OUT NOCOPY VARCHAR2,
75 p_codepath IN OUT NOCOPY VARCHAR2,
76 p_process_special_source IN VARCHAR2,
77 p_currency_conversion_rate IN NUMBER /* added by Vijay Shankar for Bug#4229164 */
78 );
79
80 PROCEDURE expense_accounting
81 (
82 p_transaction_id IN NUMBER,
83 p_transaction_date IN DATE,
84 p_organization_id IN NUMBER,
85 p_transaction_type IN VARCHAR2,
86 p_parent_transaction_type IN VARCHAR2,
87 p_receipt_num IN VARCHAR2,
88 p_shipment_line_id IN NUMBER,
89 p_subinventory_code IN VARCHAR2,
90 p_accounted_amount IN NUMBER,
91 p_receiving_account_id IN NUMBER,
92 p_source_document_code IN VARCHAR2,
93 p_po_distribution_id IN NUMBER,
94 p_po_line_location_id IN NUMBER,
95 p_inventory_item_id IN NUMBER,
96 p_accounting_type IN VARCHAR2,
97 p_simulate IN VARCHAR2,
98 p_process_message OUT NOCOPY VARCHAR2,
99 p_process_status OUT NOCOPY VARCHAR2,
100 p_codepath IN OUT NOCOPY VARCHAR2,
101 p_process_special_source IN VARCHAR2
102 );
103
104 PROCEDURE average_costing
105 (
106 p_transaction_id IN NUMBER,
107 p_transaction_date IN DATE,
108 p_organization_id IN NUMBER,
109 p_parent_transaction_type IN VARCHAR2,
110 p_transaction_type IN VARCHAR2,
111 p_subinventory_code IN VARCHAR2,
112 p_costing_amount IN NUMBER,
113 p_receiving_account_id IN NUMBER,
114 p_source_document_code IN VARCHAR2,
115 p_po_distribution_id IN NUMBER,
116 p_unit_of_measure IN VARCHAR2,
117 p_inventory_item_id IN NUMBER,
118 p_accounting_type IN VARCHAR2,
119 p_simulate IN VARCHAR2,
120 p_process_message OUT NOCOPY VARCHAR2,
121 p_process_status OUT NOCOPY VARCHAR2,
122 p_codepath IN OUT NOCOPY VARCHAR2,
123 p_process_special_source IN VARCHAR2
124 );
125
126 PROCEDURE standard_costing
127 (
128 p_transaction_id IN NUMBER,
129 p_transaction_date IN DATE,
130 p_organization_id IN NUMBER,
131 p_parent_transaction_type IN VARCHAR2,
132 p_transaction_type IN VARCHAR2,
133 p_costing_amount IN NUMBER,
134 p_receiving_account_id IN NUMBER,
135 p_accounting_type IN VARCHAR2,
136 p_simulate IN VARCHAR2,
137 p_process_message OUT NOCOPY VARCHAR2,
138 p_process_status OUT NOCOPY VARCHAR2,
139 p_codepath IN OUT NOCOPY VARCHAR2,
140 p_process_special_source IN VARCHAR2
141 );
142
143 FUNCTION receiving_account
144 (
145 p_organization_id IN NUMBER,
146 p_process_message OUT NOCOPY VARCHAR2,
147 p_process_status OUT NOCOPY VARCHAR2,
148 p_codepath IN OUT NOCOPY VARCHAR2
149 )
150 RETURN NUMBER;
151
152 FUNCTION expense_account
153 (
154 p_transaction_id IN NUMBER,
155 p_organization_id IN NUMBER,
156 p_subinventory_code IN VARCHAR2,
157 p_po_distribution_id IN NUMBER,
158 p_po_line_location_id IN NUMBER,
159 p_item_id IN NUMBER,
160 p_process_message OUT NOCOPY VARCHAR2,
161 p_process_status OUT NOCOPY VARCHAR2,
162 p_codepath IN OUT NOCOPY VARCHAR2
163 )
164 RETURN NUMBER;
165
166 FUNCTION ppv_account
167 (
168 p_organization_id IN NUMBER,
169 p_process_message OUT NOCOPY VARCHAR2,
170 p_process_status OUT NOCOPY VARCHAR2,
171 p_codepath IN OUT NOCOPY VARCHAR2
172 )
173 RETURN NUMBER;
174
175 FUNCTION material_account
176 (
177 p_organization_id IN NUMBER,
178 p_source_document_code IN VARCHAR2,
179 p_po_distribution_id IN NUMBER,
180 p_subinventory IN VARCHAR2,
181 p_process_message OUT NOCOPY VARCHAR2,
182 p_process_status OUT NOCOPY VARCHAR2,
183 p_codepath IN OUT NOCOPY VARCHAR2
184 )
185 RETURN NUMBER;
186
187 FUNCTION include_cenvat_in_costing
188 (
189 p_transaction_id IN NUMBER,
190 p_process_message OUT NOCOPY VARCHAR2,
191 p_process_status OUT NOCOPY VARCHAR2,
192 p_codepath IN OUT NOCOPY VARCHAR2
193 )
194 RETURN VARCHAR2;
195
196 END jai_rcv_deliver_rtr_pkg;