[Home] [Help]
PACKAGE: APPS.JAI_RGM_GST_ACCOUNTING_PKG
Source
1 PACKAGE jai_rgm_gst_accounting_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_gst_acct_pkg.pls 120.1 2010/09/07 07:54:13 boboli noship $ */
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| jai_gst_acct_pkg.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package is API for generate accounting entry and insert |
13 --| repository table |
14 --| |
15 --| TDD REFERENCE |
16 --| Take reference TDD_12_2_FIN_JAI_Enhanced_GST.doc |
17 --| |
18 --| |
19 --| PURPOSE |
20 --| PROCEDURE create_repository_entry |
21 --| FUNCTION create_gl_entry |
22 --| |
23 --| HISTORY |
24 --| 02-Sep-2010 Created by Bo Li for bug#10043656 |
25 --| GST Enhancement for R12.1.3 |
26 --| |
27 --+======================================================================*/
28
29 PROCEDURE create_repository_entry(
30 pn_repository_id OUT NOCOPY NUMBER,
31 pn_regime_id IN NUMBER,
32 pv_tax_type IN VARCHAR2,
33 pv_organization_type IN VARCHAR2,
34 pn_organization_id IN NUMBER,
35 pn_location_id IN NUMBER,
36 pv_source IN VARCHAR2,
37 pv_source_trx_type IN VARCHAR2,
38 pv_source_table_name IN VARCHAR2,
39 pn_source_document_id IN NUMBER,
40 pd_transaction_date IN DATE,
41 pv_account_name IN VARCHAR2,
42 pn_charge_account_id IN NUMBER,
43 pn_balancing_account_id IN NUMBER,
44 pn_amount IN NUMBER,
45 pn_assessable_value IN NUMBER,
46 pn_tax_rate IN NUMBER,
47 pn_reference_id IN NUMBER,
48 pn_batch_id IN NUMBER,
49 pv_called_from IN VARCHAR2,
50 pn_inv_organization_id IN NUMBER DEFAULT NULL,
51 pn_settlement_id IN NUMBER DEFAULT NULL,
52 pv_balancing_orgn_type IN VARCHAR2 DEFAULT NULL,
53 pn_balancing_orgn_id IN NUMBER DEFAULT NULL,
54 pn_balancing_location_id IN NUMBER DEFAULT NULL,
55 pv_balancing_tax_type IN VARCHAR2 DEFAULT NULL,
56 pv_balancing_accnt_name IN VARCHAR2 DEFAULT NULL,
57 pv_currency_code IN VARCHAR2 DEFAULT jai_constants.func_curr,
58 pd_curr_conv_date IN DATE DEFAULT NULL,
59 pv_curr_conv_type IN VARCHAR2 DEFAULT NULL,
60 pn_curr_conv_rate IN VARCHAR2 DEFAULT NULL,
61 pn_trx_amount IN NUMBER DEFAULT NULL,
62 pv_trx_reference_context IN VARCHAR2 DEFAULT NULL,
63 pv_trx_reference1 IN VARCHAR2 DEFAULT NULL,
64 pv_trx_reference2 IN VARCHAR2 DEFAULT NULL,
65 pv_trx_reference3 IN VARCHAR2 DEFAULT NULL,
66 pv_trx_reference4 IN VARCHAR2 DEFAULT NULL,
67 pv_trx_reference5 IN VARCHAR2 DEFAULT NULL,
68 pv_service_type_code IN VARCHAR2 DEFAULT NULL,
69 pv_distribution_type IN VARCHAR2 DEFAULT NULL,
70 pv_process_flag OUT NOCOPY VARCHAR2,
71 pv_process_message OUT NOCOPY VARCHAR2
72 /* Would need to include invoice no, invoice date, assessable value -- Shyam */
73 ) ;
74
75
76 PROCEDURE create_gl_entry
77 (pn_organization_id NUMBER,
78 pn_credit_amount NUMBER,
79 pn_debit_amount NUMBER,
80 pn_cc_id NUMBER,
81 pv_je_source_name VARCHAR2,
82 pv_je_category_name VARCHAR2,
83 pd_accounting_date DATE DEFAULT NULL,
84 pd_currency_conversion_date DATE DEFAULT NULL,
85 pv_currency_conversion_type VARCHAR2 DEFAULT NULL,
86 pn_currency_conversion_rate NUMBER DEFAULT NULL,
87 pv_reference_10 VARCHAR2 DEFAULT NULL,
88 pv_reference_23 VARCHAR2 DEFAULT NULL,
89 pv_reference_24 VARCHAR2 DEFAULT NULL,
90 pv_reference_25 VARCHAR2 DEFAULT NULL,
91 pv_reference_26 VARCHAR2 DEFAULT NULL
92 );
93
94
95 gv_debug VARCHAR2(1) := 'Y';
96
97 END jai_rgm_gst_accounting_pkg;