PACKAGE: APPS.JAI_OM_TAX_PROCESSING_PKG

Source

1 PACKAGE JAI_OM_TAX_PROCESSING_PKG AS
2   /* $Header: jai_om_tax_p.pls 120.0.12020000.2 2013/03/19 00:31:12 vkaranam noship $ */
3 
4   CURSOR get_copy_order_line(p_header_Id NUMBER, p_Line_Id NUMBER) IS
5   SELECT inventory_item_id,
6          unit_code,
7          quantity,
8          tax_category_id,
9          selling_price,
10          line_amount,
11          assessable_value,
12          tax_amount,
13          line_tot_amount,
14          shipment_line_number,
15          excise_exempt_type,
16          excise_exempt_refno,
17          excise_exempt_date,
18          vat_exemption_flag,
19          vat_exemption_type,
20          vat_exemption_date,
21          vat_exemption_refno,
22          vat_assessable_value,
23          vat_reversal_price,
24          service_type_code
25     FROM JAI_OM_OE_SO_LINES
26    WHERE header_id = p_header_Id
27      AND line_id = p_Line_Id;
28 
29   CURSOR get_header_info(p_header_id NUMBER) IS
30   SELECT rowid                             row_id,
31          nvl(org_id, 0)                    org_id,
32          sold_to_org_id                    customer_id,
33          source_document_id                source_header_id,
34          order_number                      order_number,
35          price_list_id                     price_list_id,
36          order_category_code               order_category,
37          orig_sys_document_ref             original_system_reference,
38          transactional_curr_code           currency_code,
39          conversion_type_code              conv_type_code,
40          conversion_rate                   conv_rate,
41          conversion_rate_date              conv_date,
42          nvl(ordered_date, creation_date)  date_ordered
43     FROM oe_order_headers_all
44    WHERE header_id = p_header_id;
45 
46   t_rec OE_ORDER_LINES_ALL%rowtype;
47 
48   PROCEDURE ORDER_LINE_VALIDATION (p_rec_old t_rec%type,
49                                    p_rec_new t_rec%type,
50                                    p_action varchar2,
51                                    px_return_code out nocopy varchar2,
52                                    px_return_message out nocopy varchar2);
53 
54   PROCEDURE POPULATE_TAX(pr_old            t_rec%type,
55                          pr_new            t_rec%type,
56                          pv_action         varchar2,
57                          pv_return_code    out nocopy varchar2,
58                          pv_return_message out nocopy varchar2);
59   PROCEDURE UPDATE_TAX(pr_old            t_rec%type,
60                        pr_new            t_rec%type,
61                        pv_action         varchar2,
62                        pv_return_code    out nocopy varchar2,
63                        pv_return_message out nocopy varchar2);
64   PROCEDURE DEFAULT_TAX(pr_old            t_rec%type,
65                         pr_new            t_rec%type,
66                         pv_action         varchar2,
67                         pv_return_code    out nocopy varchar2,
68                         pv_return_message out nocopy varchar2);
69 
70 END JAI_OM_TAX_PROCESSING_PKG;