eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RG_BALANCES_PKG dependencies on JAI_CMN_RG_BALANCES

Line 1: PACKAGE jai_cmn_rg_balances_pkg AS

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,

Line 5: P_ORG_UNIT_ID IN JAI_CMN_RG_BALANCES.org_unit_id%TYPE,

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,

Line 6: P_ORGANIZATION_ID IN JAI_CMN_RG_BALANCES.organization_id%TYPE,

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,

Line 7: P_LOCATION_ID IN JAI_CMN_RG_BALANCES.location_id%TYPE,

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,

Line 8: P_PLA_BALANCE IN JAI_CMN_RG_BALANCES.pla_balance%TYPE,

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,

Line 9: P_RG23A_BALANCE IN JAI_CMN_RG_BALANCES.rg23a_balance%TYPE,

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,

Line 10: P_RG23C_BALANCE IN JAI_CMN_RG_BALANCES.rg23c_balance%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,

Line 11: P_CREATION_DATE IN JAI_CMN_RG_BALANCES.creation_date%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,

Line 12: P_CREATED_BY IN JAI_CMN_RG_BALANCES.created_by%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,

Line 13: P_LAST_UPDATE_DATE IN JAI_CMN_RG_BALANCES.last_update_date%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,

Line 14: P_LAST_UPDATED_BY IN JAI_CMN_RG_BALANCES.last_updated_by%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,

Line 15: P_LAST_UPDATE_LOGIN IN JAI_CMN_RG_BALANCES.last_update_login%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

Line 16: P_BASIC_PLA_BALANCE IN JAI_CMN_RG_BALANCES.basic_pla_balance%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,

Line 17: P_ADDITIONAL_PLA_BALANCE IN JAI_CMN_RG_BALANCES.additional_pla_balance%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

Line 18: P_OTHER_PLA_BALANCE IN JAI_CMN_RG_BALANCES.other_pla_balance%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: );

Line 25: P_ORGANIZATION_ID IN JAI_CMN_RG_BALANCES.organization_id%TYPE,

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

Line 26: P_LOCATION_ID IN JAI_CMN_RG_BALANCES.location_id%TYPE,

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,

Line 35: P_ORGANIZATION_ID IN JAI_CMN_RG_BALANCES.organization_id%TYPE,

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,

Line 36: P_LOCATION_ID IN JAI_CMN_RG_BALANCES.location_id%TYPE,

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

Line 43: END jai_cmn_rg_balances_pkg;

39: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
40: P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
41: );
42:
43: END jai_cmn_rg_balances_pkg;