[Home] [Help]
PACKAGE: APPS.JAI_GST_TAX_DEFAULTATION_PKG
Source
1 PACKAGE jai_gst_tax_defaultation_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_gst_tax_dflt.pls 120.2 2010/09/26 08:44:31 pezheng noship $ */
3
4 /*----------------------------------------------------------------------------------------------------------------------
5 CHANGE HISTORY: FILENAME: jai_gst_tax_dflt.pls
6 S.No Date Author and Details
7 ------------------------------------------------------------------------------------------------------------------------
8 1 09/01/2010 Peng Zheng for bug 10043656
9 New Tax Category Default logic for GST
10
11
12 ----------------------------------------------------------------------------------------------------------------------------------------------------
13 Current Version Current Bug Dependent Files Version Author Date Remarks
14 Of File On Bug/Patchset Dependent On
15
16 ----------------------------------------------------------------------------------------------------------------------------------------------------
17 10043656
18
19
20 -----------------------------------------------------------------------------------------------------------------------*/
21
22
23 --==========================================================================
24 -- PROCEDURE NAME:
25 -- jai_gst_cust_default_taxes Public
26 --
27 -- DESCRIPTION:
28 -- To get a customer/site's tax default category
29 --
30 -- ER NAME/BUG#
31 -- GST Enhancement/ bug 10043656
32 --
33 -- PARAMETERS:
34 -- In: pn_organization_id 1st Party Organization ID
35 -- pn_location_id 1st Party Location ID
36 -- pn_customer_id Customer ID
37 -- pn_ship_to_site_use_id Ship to site use id
38 -- pn_inventory_item_id Inventory Item
39 -- pd_transaction_date Transaction date, used to compare with the tax category's start date and end date.
40 -- In/Out: pn_tax_category_id The default tax category ID
41 --
42 --
43 -- DESIGN REFERENCES:
44 -- <<TDD_12_2_FIN_JAI_Enhanced_GST.doc>>
45 --
46 -- CALL FROM
47 -- JAI_AR_RCTLA_TRIGGER_PKG
48 -- JAI_AR_RCTA_TRIGGER_PKG
49 -- JAI_MTL_TRXS_PKG
50 -- JAI_OE_OLA_TRIGGER_PKG
51 --
52 --
53 -- CHANGE HISTORY:
54 -- 20-Sep-2010 Created by peng.zheng
55 --==========================================================================
56
57 PROCEDURE jai_gst_cust_default_taxes(pn_organization_id IN NUMBER,
58 pn_location_id IN NUMBER,
59 pn_customer_id IN NUMBER,
60 pn_ship_to_site_use_id IN NUMBER,
61 pn_inventory_item_id IN NUMBER,
62 pd_transaction_date IN DATE,
63 pn_tax_category_id IN OUT NOCOPY NUMBER);
64
65 --==========================================================================
66 -- PROCEDURE NAME:
67 -- jai_gst_vendor_default_taxes Public
68 --
69 -- DESCRIPTION:
70 -- To get a venodr/site's tax category
71 --
72 -- ER NAME/BUG#
73 -- GST Enhancement/ bug 10043656
74 --
75 -- PARAMETERS:
76 -- In: pn_organization_id 1st Party Organization ID
77 -- pn_location_id 1st Party Location ID
78 -- pn_vendor_id Vendor ID
79 -- pn_vendor_site_id Vendor Site ID
80 -- pn_inventory_item_id Inventory Item
81 -- pd_transaction_date Transaction date, used to compare with the tax category's start date and end date.
82 -- In/Out: pn_tax_category_id The default tax category ID
83 --
84 --
85 -- DESIGN REFERENCES:
86 -- <<TDD_12_2_FIN_JAI_Enhanced_GST.doc>>
87 --
88 -- CALL FROM
89 -- JAI_PO_RLA_TRIGGER_PKG
90 -- jai_po_tax_pkg
91 -- JAI_MTL_TRXS_PKG
92 --
93 --
94 -- CHANGE HISTORY:
95 -- 20-Sep-2010 Created by peng.zheng
96 --==========================================================================
97 PROCEDURE jai_gst_vendor_default_taxes(pn_organization_id IN NUMBER,
98 pn_location_id IN NUMBER,
99 pn_vendor_id IN NUMBER,
100 pn_vendor_site_id IN NUMBER,
101 pn_inventory_item_id IN NUMBER,
102 pd_transaction_date IN DATE,
103 pn_tax_category_id IN OUT NOCOPY NUMBER);
104
105 --==========================================================================
106 -- PROCEDURE NAME:
107 -- jai_gst_org_default_taxes Public
108 --
109 -- DESCRIPTION:
110 -- If not get category from customer or vendor's setup, this procedure will using tax classification to fetch tax category
111 --
112 -- ER NAME/BUG#
113 -- GST Enhancement/ bug 10043656
114 --
115 -- PARAMETERS:
116 -- In: pn_organization_id Organization ID
117 -- pn_location_id Location ID
118 -- pn_party_id Customer_id/vendor_id
119 -- pn_party_site_id ship_to_site_use_id when SO(NOT customer_site_id)/vendor_site_id when PO
120 -- pv_party_type C:Customer/V:Vendor
121 -- pn_inventory_item_id Inventory Item
122 -- pd_transaction_date Transaction date, used to compare with the tax category's start date and end date.
123 -- In/Out: pn_tax_category_id The default tax category ID
124 --
125 --
126 -- DESIGN REFERENCES:
127 -- <<TDD_12_2_FIN_JAI_Enhanced_GST.doc>>
128 --
129 -- CALL FROM
130 -- JAI_PO_RLA_TRIGGER_PKG
131 -- JAI_AR_RCTLA_TRIGGER_PKG
132 -- JAI_AR_RCTA_TRIGGER_PKG
133 -- JAI_OE_OLA_TRIGGER_PKG
134 --
135 --
136 -- CHANGE HISTORY:
137 -- 20-Sep-2010 Created by peng.zheng
138 --==========================================================================
139 PROCEDURE jai_gst_org_default_taxes(pn_organization_id IN NUMBER,
140 pn_location_id IN NUMBER,
141 pn_party_id IN NUMBER,
142 pn_party_site_id IN NUMBER,
143 pv_party_type IN VARCHAR2,
144 pn_inventory_item_id IN NUMBER,
145 pd_transaction_date IN DATE,
146 pn_tax_category_id IN OUT NOCOPY NUMBER);
147
148 END jai_gst_tax_defaultation_pkg;