[Home] [Help]
PACKAGE: APPS.JAI_AR_IMPORT_POPU_PKG
Source
1 PACKAGE JAI_AR_IMPORT_POPU_PKG AUTHID CURRENT_USER AS
2 /* $Header: jai_ar_import_popu.pls 120.4.12020000.1 2013/03/12 07:18:19 appldev noship $ */
3
4 /*----------------------------------------------------------------------------------------
5 Change History
6 S.No. DATE Description
7 ------------------------------------------------------------------------------------------
8
9 1 14/06/2012 Copied from jai_ar_rctla_t.pls
10
11 ---------------------------------------------------------------------------------------- */
12
13
14 t_rec RA_CUSTOMER_TRX_LINES_ALL%rowtype ;
15 lc_modvat_tax CONSTANT varchar2(15) := 'Modvat Recovery';
16 PROCEDURE pop_jai_inv_and_suppl ( 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 ) ;
17 PROCEDURE pop_jai_rmacm ( 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 ) ;
18
19 cursor c_get_address_details(cp_cust_trx_id ra_customer_trx_lines_all.customer_trx_id%type)
20 is
21 select bill_to_customer_id,
22 bill_to_site_use_id,
23 ship_to_customer_id,
24 ship_to_site_use_id
25 from ra_customer_trx_all
26 where customer_trx_id = cp_cust_trx_id;
27
28 r_add c_get_address_details%rowtype;
29
30
31
32
33
34 procedure import_projects_taxes
35 ( r_new in ra_customer_trx_lines_all%rowtype
36 , r_old in ra_customer_trx_lines_all%rowtype
37 , pv_action in varchar2
38 , pv_err_msg OUT NOCOPY varchar2
39 , pv_err_flg OUT NOCOPY varchar2
40 );
41
42
43 function is_this_projects_context(
44 pv_context IN varchar2
45 ) return boolean ;
46
47 FUNCTION get_service_type(pn_party_id NUMBER,
48 pn_party_site_id NUMBER,
49 pv_party_type VARCHAR2) return VARCHAR2;
50 FUNCTION get_legal_entity_id(pn_customer_trx_id number) RETURN NUMBER;
51 END JAI_AR_IMPORT_POPU_PKG ;