[Home] [Help]
PACKAGE: APPS.JAI_CMN_RG_BALANCES_PKG
Source
1 PACKAGE jai_cmn_rg_balances_pkg AS
2 /* $Header: jai_cmn_rg_bals.pls 120.1 2005/07/20 12:57:16 avallabh ship $ */
3
4 PROCEDURE insert_row(
5 P_ORG_UNIT_ID IN JAI_CMN_RG_BALANCES.org_unit_id%TYPE,
6 P_ORGANIZATION_ID IN JAI_CMN_RG_BALANCES.organization_id%TYPE,
7 P_LOCATION_ID IN JAI_CMN_RG_BALANCES.location_id%TYPE,
8 P_PLA_BALANCE IN JAI_CMN_RG_BALANCES.pla_balance%TYPE,
9 P_RG23A_BALANCE IN JAI_CMN_RG_BALANCES.rg23a_balance%TYPE,
10 P_RG23C_BALANCE IN JAI_CMN_RG_BALANCES.rg23c_balance%TYPE,
11 P_CREATION_DATE IN JAI_CMN_RG_BALANCES.creation_date%TYPE,
12 P_CREATED_BY IN JAI_CMN_RG_BALANCES.created_by%TYPE,
13 P_LAST_UPDATE_DATE IN JAI_CMN_RG_BALANCES.last_update_date%TYPE,
14 P_LAST_UPDATED_BY IN JAI_CMN_RG_BALANCES.last_updated_by%TYPE,
15 P_LAST_UPDATE_LOGIN IN JAI_CMN_RG_BALANCES.last_update_login%TYPE,
16 P_BASIC_PLA_BALANCE IN JAI_CMN_RG_BALANCES.basic_pla_balance%TYPE,
17 P_ADDITIONAL_PLA_BALANCE IN JAI_CMN_RG_BALANCES.additional_pla_balance%TYPE,
18 P_OTHER_PLA_BALANCE IN JAI_CMN_RG_BALANCES.other_pla_balance%TYPE,
19 P_SIMULATE_FLAG IN VARCHAR2, -- DEFAULT 'N' File.Sql.35 by Brathod
20 P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
21 P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
22 );
23
24 PROCEDURE update_row(
25 P_ORGANIZATION_ID IN JAI_CMN_RG_BALANCES.organization_id%TYPE,
26 P_LOCATION_ID IN JAI_CMN_RG_BALANCES.location_id%TYPE,
27 p_register_type IN VARCHAR2,
28 p_amount_to_be_added IN NUMBER,
29 P_SIMULATE_FLAG IN VARCHAR2, -- DEFAULT 'N' File.Sql.35 by Brathod
30 P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
31 P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
32 ) ;
33
34 PROCEDURE get_balance(
35 P_ORGANIZATION_ID IN JAI_CMN_RG_BALANCES.organization_id%TYPE,
36 P_LOCATION_ID IN JAI_CMN_RG_BALANCES.location_id%TYPE,
37 P_REGISTER_TYPE IN VARCHAR2,
38 P_OPENING_BALANCE OUT NOCOPY VARCHAR2,
39 P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
40 P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
41 );
42
43 END jai_cmn_rg_balances_pkg;