[Home] [Help]
PACKAGE: APPS.JAI_AR_RCTLA_TRIGGER_PKG
Source
1 PACKAGE JAI_AR_RCTLA_TRIGGER_PKG AUTHID CURRENT_USER AS
2 /* $Header: jai_ar_rctla_t.pls 120.8 2011/03/17 13:13:47 abezgam ship $ */
3
4 /*----------------------------------------------------------------------------------------
5 Change History
6 S.No. DATE Description
7 ------------------------------------------------------------------------------------------
8
9 1 24/04/1005 cbabu for bug#6012570 (5876390) Version: 120.2
10 Projects Billing Enh.
11 forward ported from R11i to R12
12
13 2 27/04/2007 CSahoo for bug#5879769, File Version 120.3
14 Forward porting of 11i bug#5694855
15 Added a function get_service_type to get the service_type_code
16 added the cursor c_get_address_details to get the customer_id and Customer_site_id
17 5. 14/05/2007 bduvarag for Bug5879769 File Version 120.14
18 Removed the Project Billing Code
19
20 6. 18-Aug-2007 brathod, File Version 120.6
21 Reimplemented Project Billing code
22
23 7. 17-Mar-2011 abezgam for Bug 11880460
24 Added the procedure declaration of ARI_T4
25 ---------------------------------------------------------------------------------------- */
26
27
28 t_rec RA_CUSTOMER_TRX_LINES_ALL%rowtype ;
29 lc_modvat_tax CONSTANT varchar2(15) := 'Modvat Recovery';/*Bug 5684363 bduvarag*/
30 PROCEDURE ARD_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) ;
31 PROCEDURE ARI_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) ;
32 PROCEDURE ARI_T2 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) ;
33 PROCEDURE ARI_T3 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) ;
34 PROCEDURE ARIU_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) ;
35 PROCEDURE ARU_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) ;
36 PROCEDURE ARU_T2 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) ;
37 PROCEDURE ARI_T4 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) ;/*added by abezgam for bug 11880460*/
38 -- added by csahoo for bug#5879769
39 ---start
40 cursor c_get_address_details(cp_cust_trx_id ra_customer_trx_lines_all.customer_trx_id%type)
41 is
42 select bill_to_customer_id,
43 bill_to_site_use_id,
44 ship_to_customer_id,
45 ship_to_site_use_id
46 from ra_customer_trx_all
47 where customer_trx_id = cp_cust_trx_id;
48
49 r_add c_get_address_details%rowtype;
50
51 FUNCTION get_service_type(pn_party_id NUMBER,
52 pn_party_site_id NUMBER,
53 pv_party_type VARCHAR2) return VARCHAR2;
54
55 ---End
56
57 /*following function added for Projects Billing Implementation. bug#6012570 (5876390) */
58
59 procedure import_projects_taxes
60 ( r_new in ra_customer_trx_lines_all%rowtype
61 , r_old in ra_customer_trx_lines_all%rowtype
62 , pv_action in varchar2
63 , pv_err_msg OUT NOCOPY varchar2
64 , pv_err_flg OUT NOCOPY varchar2
65 );
66
67
68 function is_this_projects_context(
69 pv_context IN varchar2
70 ) return boolean ;
71
72
73 END JAI_AR_RCTLA_TRIGGER_PKG ;