[Home] [Help]
PACKAGE: APPS.JAI_PA_BILLING_PKG
Source
1 package jai_pa_billing_pkg as
2 -- $Header: jai_pa_billing.pls 120.0.12000000.2 2007/10/25 02:22:44 rallamse noship $
3 /*----------------------------------------------------------------------------------------------------------------------------
4 CHANGE HISTORY for FILENAME: jai_pa_billing_pkg.pls
5 S.No dd/mm/yyyy Author and Details
6 ------------------------------------------------------------------------------------------------------------------------------
7 1 24/04/2007 Vijay Shankar for Bug#6012570 (5876390), Version:120.0 (115.2)
8 Forward ported to R12 from R11i
9 Package created for Projects Billing Implementation.
10
11 ------------------------------------------------------------------------------------------------------------------------------*/
12
13 gv_debug constant boolean := false;
14 file constant varchar2(30) := 'jai_pa_billing.log';
15
16 -- gv_tax_source_doc_type constant varchar2(30) := 'PROJECT_DRAFT_INVOICE';
17 gv_source_projects constant varchar2(30) := 'PROJECT_DRAFT_INVOICE';
18 gv_draft_invoice_release constant varchar2(30) := 'DRAFT_INVOICE_RELEASE';
19
20 gv_draft_invoice_table constant varchar2(30) := 'JAI_PA_DRAFT_INVOICES';
21 gv_trx_type_draft_invoice constant varchar2(30) := 'DRAFT_INVOICE';
22
23 gv_package_spec_version constant varchar2(30) := '120.0';
24
25 function get_spec_version return varchar2;
26
27 function get_body_version return varchar2;
28
29 cursor c_regime_id(cp_regime_code in varchar2) is
30 select regime_id
31 from JAI_RGM_DEFINITIONS
32 where regime_code = cp_regime_code;
33
34 TYPE gl_entry IS RECORD (
35 debit_amount NUMBER,
36 credit_amount NUMBER,
37 debit_ccid gl_interface.code_combination_id%TYPE,
38 credit_ccid gl_interface.code_combination_id%TYPE,
39 regime_code varchar2(30),
40 tax_type varchar2(30),
41 je_source gl_je_headers.je_source%type,
42 je_category gl_je_headers.je_category%type,
43 set_of_books_id gl_sets_of_books.set_of_books_id%type,
44 currency_code gl_currencies.currency_code%type,
45 currency_conv_rate number,
46 currency_conv_date date,
47 accounting_date date,
48 organization_code gl_interface.reference1%TYPE, -- p_params(i).organization_code,
49 description gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
50 called_from gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
51 reference_table gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
52 reference_column gl_interface.reference25%TYPE, -- p_transaction_temp_id,
56 source_table_name JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
53 reference_id gl_interface.reference26%TYPE, -- 'transaction_temp_id',
54 organization_id gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
55 source JAI_CMN_JOURNAL_ENTRIES.source%type,
57 source_document_id JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
58 );
59
60 procedure process_draft_invoice_release(
61 pr_draft_invoice IN PA_DRAFT_INVOICES_ALL%rowtype,
62 pv_called_from IN VARCHAR2,
63 pv_process_flag OUT NOCOPY VARCHAR2,
64 pv_process_message OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE process_excise (
68 pr_pa_draft_invoices_all IN pa_draft_invoices_all%rowtype ,
69 pv_called_from IN varchar2 ,
70 pv_process_flag OUT nocopy varchar2 ,
71 pv_process_message OUT nocopy varchar2
72 );
73
74 procedure process_vat(
75 pn_project_id IN NUMBER,
76 pn_draft_invoice_num IN NUMBER,
77 -- pn_draft_invoice_id IN NUMBER,
78 pv_called_from IN VARCHAR2,
79 pv_process_flag OUT nocopy varchar2,
80 pv_process_message OUT nocopy VARCHAR2
81 );
82
83 PROCEDURE check_excise_balance(
84 pn_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%type ,
85 pn_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%type ,
86 pn_basic_excise_amt IN number ,
90 pn_sh_excise_cess_amt IN number , /*budget07*/
87 pn_additional_excise_amt IN number ,
88 pn_other_excise_amt IN number ,
89 pn_excise_cess_amt IN number ,
91 pv_called_from IN varchar2 ,
92 pv_register OUT NOCOPY varchar2 ,
93 pv_process_flag OUT NOCOPY varchar2 ,
94 pv_process_message OUT NOCOPY varchar2
95 );
96
97 procedure insert_gl_entry(
98 pr_gl_entry IN JAI_PA_BILLING_PKG.GL_ENTRY,
99 pv_process_flag OUT NOCOPY VARCHAR2,
100 pv_process_message OUT NOCOPY VARCHAR2
101 );
102
103 procedure import_taxes_to_payables
104 ( errbuf OUT NOCOPY varchar2
105 , retcode OUT NOCOPY number
106 , pn_request_id in ap_invoice_distributions_all.request_id%type
107 , pn_invoice_id in ap_invoice_distributions_all.invoice_id%type
108 , pv_event in varchar2
109 );
110
111 end jai_pa_billing_pkg;