[Home] [Help]
PACKAGE: APPS.JAI_AR_TRX_LINES_PKG
Source
1 PACKAGE JAI_AR_TRX_LINES_PKG AS
2 /* $Header: jai_ar_trx_lines.pls 120.0.12020000.2 2013/03/19 00:29:44 vkaranam noship $ */
3 /*------------------------------------------------------------------------------------------------------------
4 CHANGE HISTORY
5 ------------------------------------------------------------------------------------------------------------
6 Sl.No. Date Developer BugNo Version Remarks
7 ------------------------------------------------------------------------------------------------------------
8 1. 13-June-2012 qinglei 14040855 115.1 Created the initial version
9
10 --------------------------------------------------------------------------------------------------------------*/
11
12 t_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;
13 lc_modvat_tax CONSTANT VARCHAR2(15) := 'Modvat Recovery';
14 t_jai_rec JAI_AR_TRX_LINES%ROWTYPE;
15
16 CURSOR c_get_address_details(cp_cust_trx_id ra_customer_trx_lines_all.customer_trx_id%TYPE) IS
17 SELECT bill_to_customer_id,
18 bill_to_site_use_id,
19 ship_to_customer_id,
20 ship_to_site_use_id
21 FROM ra_customer_trx_all
22 WHERE customer_trx_id = cp_cust_trx_id;
23
24 r_add c_get_address_details%ROWTYPE;
25
26 PROCEDURE POPULATE_JAI_AR_LINES(pr_new t_rec%TYPE,
27 pv_action VARCHAR2,
28 pv_return_code OUT NOCOPY VARCHAR2,
29 pv_return_message OUT NOCOPY VARCHAR2);
30
31 PROCEDURE DEFAULT_TAX(pr_old t_jai_rec%TYPE,
32 pr_new t_rec%TYPE,
33 pv_action VARCHAR2,
34 pv_return_code OUT NOCOPY VARCHAR2,
35 pv_return_message OUT NOCOPY VARCHAR2);
36
37 FUNCTION GET_SERVICE_TYPE(pn_party_id NUMBER,
38 pn_party_site_id NUMBER,
39 pv_party_type VARCHAR2) return VARCHAR2;
40
41 PROCEDURE RECALCULATE_TAX_FOR_DM(pr_old t_jai_rec%type,
42 pr_new t_rec%type,
43 pv_action varchar2,
44 pv_return_code out NOCOPY varchar2,
45 pv_return_message out NOCOPY varchar2);
46
47 PROCEDURE RECALCULATE_TAX_FOR_INV_CM(pr_old t_jai_rec%type,
48 pr_new t_rec%type,
49 pv_action varchar2,
50 pv_return_code out NOCOPY varchar2,
51 pv_return_message out NOCOPY varchar2);
52
53 PROCEDURE DELETE_AR_TRX_LINES(pr_old t_jai_rec%type,
54 pr_new t_rec%type,
55 pv_action varchar2,
56 pv_return_code out NOCOPY varchar2,
57 pv_return_message out NOCOPY varchar2);
58 END JAI_AR_TRX_LINES_PKG;