1 PACKAGE jai_cmn_reverse_charge_pkg AS
2 /* $Header: jai_cmn_reverse_charge_pkg.pls 120.0.12020000.3 2013/01/09 09:05:18 qioliu noship $ */
3
4 g_debug VARCHAR2(1);
5 PROCEDURE process_reverse_payment(p_org_id IN NUMBER,
6 pn_batch_id IN NUMBER,
7 pn_regime_id IN NUMBER,
8 p_trx_from_date IN DATE,
9 p_trx_to_date IN DATE,
10 pn_organization_id IN NUMBER,
11 p_debug IN VARCHAR2,
12 p_process_flag OUT NOCOPY VARCHAR2,
13 p_process_message OUT NOCOPY VARCHAR2);
14 PROCEDURE process_charge_acct(pn_batch_id IN NUMBER,
15 pn_regime_id IN NUMBER,
16 pn_organization_id IN NUMBER,
17 pn_location_id IN NUMBER,
18 pv_payment_table_name IN VARCHAR2,
19 pn_invoice_id IN NUMBER,
20 pn_line_number IN NUMBER,
21 pn_distribution_id IN NUMBER,
22 pd_date IN DATE,
23 pn_invoice_payment_id IN NUMBER,
24 p_inv_accounting_chk_done IN VARCHAR2,
25 pn_payment_amount IN NUMBER,
26 p_process_flag OUT NOCOPY VARCHAR2,
27 p_process_message OUT NOCOPY VARCHAR2);
28 FUNCTION is_reverse_charge_dist(pn_distribution_id IN NUMBER)
29 RETURN VARCHAR2;
30 FUNCTION is_rvs_chrg_liablity_dist(pn_distribution_id IN NUMBER)
31 RETURN VARCHAR2;
32 PROCEDURE process_settlement_payment_acc
33 (
34 pn_regime_id IN NUMBER,
35 pn_settlement_id IN NUMBER,
36 pv_process_flag OUT NOCOPY VARCHAR2,
37 pv_process_message OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE post_accounting
41 (
42 p_regime_code IN VARCHAR2,
43 p_tax_type IN VARCHAR2,
44 p_organization_type IN VARCHAR2,
45 p_organization_id IN NUMBER,
46 p_source IN VARCHAR2,
47 p_source_trx_type IN VARCHAR2,
48 p_source_table_name IN VARCHAR2,
49 p_source_document_id IN NUMBER,
50 p_code_combination_id IN NUMBER,
51 p_entered_cr IN NUMBER,
52 p_entered_dr IN NUMBER,
53 p_accounted_cr IN NUMBER,
54 p_accounted_dr IN NUMBER,
55 p_accounting_date IN DATE,
56 p_transaction_date IN DATE,
57 p_calling_object IN VARCHAR2,
58 p_repository_name IN VARCHAR2 DEFAULT NULL,
59 p_invoice_id IN NUMBER,
60 p_reference_name IN VARCHAR2 DEFAULT NULL,
61 p_reference_id IN NUMBER DEFAULT NULL,
62 p_currency_code IN VARCHAR2 DEFAULT NULL,
63 p_curr_conv_date IN DATE DEFAULT NULL,
64 p_curr_conv_type IN VARCHAR2 DEFAULT NULL,
65 p_curr_conv_rate IN NUMBER DEFAULT NULL
66 );
67
68 PROCEDURE process_settlement_repository
69 (
70 p_batch_id IN NUMBER,
71 p_regime_id IN NUMBER,
72 p_organization_type IN VARCHAR2,
73 p_from_date IN DATE,
74 p_to_date IN DATE,
75 p_org_id IN NUMBER,
76 p_organization_id IN NUMBER,
77 p_process_flag OUT NOCOPY VARCHAR2,
78 p_process_message OUT NOCOPY VARCHAR2
79 );
80
81 END jai_cmn_reverse_charge_pkg;