[Home] [Help]
PACKAGE: APPS.JAI_CMN_RG_OTHERS_PKG
Source
1 package jai_cmn_rg_others_pkg
2 /* $Header: jai_cmn_rg_oth.pls 120.2 2007/05/04 13:41:51 csahoo ship $ */
3 AUTHID CURRENT_USER AS
4
5 /***************************************************************************************************
6 CREATED BY : ssumaith
7 CREATED DATE : 11-JAN-2005
8 ENHANCEMENT BUG : 4136981
9 PURPOSE : To pass cess register entries
10 CALLED FROM : ja_in_rg_pkg.ja_in_rg23_part_ii_entry , ja_in_rg_pkg.pla_emtry , ja_in_rg_pkg.ja_in23d_entry
11
12 ***************************************************************************************************/
13
14 procedure insert_row (p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
15 p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
16 p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
17 p_tax_type JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE ,
18 debit_amt JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
19 credit_amt JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
20 p_process_flag OUT NOCOPY VARCHAR2 ,
21 p_process_msg OUT NOCOPY VARCHAR2 ,
22 p_attribute1 VARCHAR2 DEFAULT NULL ,
23 p_attribute2 VARCHAR2 DEFAULT NULL ,
24 p_attribute3 VARCHAR2 DEFAULT NULL ,
25 p_attribute4 VARCHAR2 DEFAULT NULL ,
26 p_attribute5 VARCHAR2 DEFAULT NULL
27 );
28
29 procedure check_balances(p_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE ,
30 p_location_id HR_LOCATIONS.LOCATION_ID%TYPE ,
31 p_register_type JAI_CMN_RG_OTH_BALANCES.REGISTER_TYPE%TYPE ,
32 p_trx_amount NUMBER ,
33 p_process_flag OUT NOCOPY VARCHAR2 ,
34 p_process_message OUT NOCOPY VARCHAR2
35 );
36 /*added the following procedure by vkaranam for bug #5989740*/
37 procedure check_sh_balances(p_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE ,
38 p_location_id HR_LOCATIONS.LOCATION_ID%TYPE ,
39 p_register_type JAI_CMN_RG_OTH_BALANCES.REGISTER_TYPE%TYPE ,
40 p_trx_amount NUMBER ,
41 p_process_flag OUT NOCOPY VARCHAR2 ,
42 p_process_message OUT NOCOPY VARCHAR2
43 );
44
45 end jai_cmn_rg_others_pkg;