APPS.JAI_CMN_RG_BALANCES_PKG dependencies on JAI_CMN_RG_BALANCES_PKG

Line 1: PACKAGE BODY jai_cmn_rg_balances_pkg AS

1: PACKAGE BODY jai_cmn_rg_balances_pkg AS
2: /* $Header: jai_cmn_rg_bals.plb 120.1 2005/07/20 12:57:15 avallabh ship $ */
3:
4: PROCEDURE insert_row(
5:

Line 26: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_balances_pkg.insert_row';

22: P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
23: ) IS
24:
25: /* Added by Ramananda for bug#4407165 */
26: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_balances_pkg.insert_row';
27:
28: BEGIN
29: /*----------------------------------------------------------------------------------------------------------------------------
30: CHANGE HISTORY for FILENAME: jai_cmn_rg_balances_pkg.sql

Line 30: CHANGE HISTORY for FILENAME: jai_cmn_rg_balances_pkg.sql

26: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_balances_pkg.insert_row';
27:
28: BEGIN
29: /*----------------------------------------------------------------------------------------------------------------------------
30: CHANGE HISTORY for FILENAME: jai_cmn_rg_balances_pkg.sql
31: S.No dd/mm/yyyy Author and Details
32: ------------------------------------------------------------------------------------------------------------------------------
33: 1 16/07/2002 Vijay Shankar for Bug# 3496408, Version:115.0
34: Table handler Package for JAI_CMN_RG_BALANCES table

Line 100: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_balances_pkg.update_row';

96: ln_rg23c_amount NUMBER := 0;
97: ln_pla_amount NUMBER := 0;
98:
99: /* Added by Ramananda for bug#4407165 */
100: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_balances_pkg.update_row';
101:
102:
103: BEGIN
104:

Line 113: P_PROCESS_MESSAGE := 'jai_cmn_rg_balances_pkg.update_row: Not able to find Register Type';

109: ELSIF p_register_type = 'PLA' THEN
110: ln_pla_amount := p_amount_to_be_added;
111: ELSE
112: P_PROCESS_STATUS := 'E';
113: P_PROCESS_MESSAGE := 'jai_cmn_rg_balances_pkg.update_row: Not able to find Register Type';
114: RETURN;
115: END IF;
116:
117: UPDATE JAI_CMN_RG_BALANCES SET

Line 182: END jai_cmn_rg_balances_pkg;

178: END IF;
179:
180: END get_balance;
181:
182: END jai_cmn_rg_balances_pkg;