[Home] [Help]
PACKAGE: APPS.JAI_PA_BILLING_PKG
Source
1 package jai_pa_billing_pkg AUTHID CURRENT_USER as
2 -- $Header: jai_pa_billing.pls 120.2 2011/06/05 11:45:48 mbremkum ship $
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,
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,
56 source_table_name JAI_CMN_JOURNAL_ENTRIES.source_table_name%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 pr_pa_draft_invoices_all IN pa_draft_invoices_all%rowtype, /*Bug 12611009*/
78 -- pn_draft_invoice_id IN NUMBER,
79 pv_called_from IN VARCHAR2,
80 pv_process_flag OUT nocopy varchar2,
81 pv_process_message OUT nocopy VARCHAR2
82 );
83
84 PROCEDURE check_excise_balance(
85 pn_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%type ,
86 pn_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%type ,
87 pn_basic_excise_amt IN number ,
88 pn_additional_excise_amt IN number ,
89 pn_other_excise_amt IN number ,
90 pn_excise_cess_amt IN number ,
91 pn_sh_excise_cess_amt IN number , /*budget07*/
92 pv_called_from IN varchar2 ,
93 pv_register OUT NOCOPY varchar2 ,
94 pv_process_flag OUT NOCOPY varchar2 ,
95 pv_process_message OUT NOCOPY varchar2
96 );
97
98 procedure insert_gl_entry(
99 pr_gl_entry IN JAI_PA_BILLING_PKG.GL_ENTRY,
100 pv_process_flag OUT NOCOPY VARCHAR2,
101 pv_process_message OUT NOCOPY VARCHAR2
102 );
103
104 procedure import_taxes_to_payables
105 ( errbuf OUT NOCOPY varchar2
106 , retcode OUT NOCOPY number
107 , pn_request_id in ap_invoice_distributions_all.request_id%type
108 , pn_invoice_id in ap_invoice_distributions_all.invoice_id%type
109 , pv_event in varchar2
110 );
111
112 end jai_pa_billing_pkg;