DBA Data[Home] [Help]

PACKAGE: APPS.JAI_OM_RMA_PKG

Source


1 PACKAGE jai_om_rma_pkg  AS
2 /* $Header: jai_om_rma.pls 120.2 2006/02/17 12:19:54 hjujjuru ship $ */
3 
4 procedure default_taxes_onto_line
5 (
6   p_header_id                       NUMBER,
7   p_line_id                         NUMBER,
8   p_inventory_item_id               NUMBER,
9   p_warehouse_id                    NUMBER,
10   --p_context                         VARCHAR2,
11   p_new_reference_line_id           NUMBER,
12   p_new_ref_customer_trx_line_id    NUMBER,
13   p_line_number                     NUMBER,
14   /* Commented for DFF Elimination by Ramananda */
15   -- p_old_attribute2                  VARCHAR2,
16   --p_old_attribute3                  VARCHAR2,
17   --p_old_attribute4                  VARCHAR2,
18   --p_old_attribute5                  VARCHAR2,
19   --p_old_attribute14                 VARCHAR2,
20   --p_attribute2                      VARCHAR2,
21   --p_attribute3                      VARCHAR2,
22   --p_attribute4                      VARCHAR2,
23   --p_attribute5                      VARCHAR2,
24   --p_attribute14                     VARCHAR2,
25   --p_attribute15                     VARCHAR2,
26   p_old_return_context                VARCHAR2,
27   pn_delivery_detail_id               number,
28   pv_allow_excise_flag                varchar2,
29   pv_allow_sales_flag                 varchar2,
30   pn_excise_duty_per_unit           number,
31   pn_excise_duty_rate               number,
32   p_old_reference_line_id           NUMBER,
33   p_old_ref_customer_trx_line_id     NUMBER,
34   p_old_ordered_quantity            NUMBER,
35   p_old_cancelled_quantity          NUMBER,
36   p_new_return_context              VARCHAR2,
37   p_new_ordered_quantity             NUMBER,
38   p_new_cancelled_quantity          NUMBER,
39   p_uom                             VARCHAR2,
40   p_old_selling_price               NUMBER,
41   p_new_selling_price               NUMBER, -- added by sriram Bug
42   p_item_type_code                  VARCHAR2,
43   p_serviced_quantity               NUMBER,
44   p_creation_date                   DATE,
45   p_created_by                      NUMBER,
46   p_last_update_date                DATE,
47   p_last_updated_by                 NUMBER,
48   p_last_update_login               NUMBER,
49   p_source_document_type_id         NUMBER,
50   p_line_category_code              OE_ORDER_LINES_ALL.LINE_CATEGORY_CODE%TYPE
51 );
52 
53 FUNCTION cal_excise_duty
54 ( p_rma_line_id  IN NUMBER,
55   p_transaction_quantity  IN NUMBER
56 ) RETURN NUMBER ;
57 
58 
59 END jai_om_rma_pkg;