DBA Data[Home] [Help]

APPS.JAI_CMN_RG_I_TRXS_PKG dependencies on JAI_CMN_RG_I_TRXS_PKG

Line 1: PACKAGE BODY jai_cmn_rg_i_trxs_pkg AS

1: PACKAGE BODY jai_cmn_rg_i_trxs_pkg AS
2: /* $Header: jai_cmn_rg_i.plb 120.3 2007/08/16 11:20:30 vkaranam ship $ */
3:
4: PROCEDURE validate_rg1_balances(
5: P_ORGANIZATION_ID IN NUMBER,

Line 16: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.validate_rg1_balances';

12: P_ERR_BUF OUT NOCOPY VARCHAR2
13: ) IS
14:
15: /* Added by Ramananda for bug#4407165 */
16: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.validate_rg1_balances';
17:
18: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
19: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
20: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS

Line 158: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.get_rg1_transaction_id';

154:
155: v_transaction_id NUMBER := -1;
156:
157: /* Added by Ramananda for bug#4407165 */
158: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.get_rg1_transaction_id';
159:
160: BEGIN
161: IF p_called_from = 'MANUAL ENTRY' THEN
162: IF p_transaction_type = 'R' THEN

Line 272: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.create_rg1_entry';

268: P_SH_CESS_AMOUNT IN NUMBER DEFAULT NULL/*Bug 5989740 bduvarag*/
269: ) IS
270:
271: /* Added by Ramananda for bug#4407165 */
272: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.create_rg1_entry';
273:
274: vMaxSlno NUMBER;
275: v_transaction_id JAI_CMN_RG_I_TRXS.TRANSACTION_SOURCE_NUM%TYPE;
276: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

Line 548: END jai_cmn_rg_i_trxs_pkg;

544: app_exception.raise_exception;
545:
546: END create_rg1_entry;
547:
548: END jai_cmn_rg_i_trxs_pkg;