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.12010000.4 2010/04/28 11:48:17 vkaranam ship $ */
3:
4:
5: PROCEDURE validate_rg1_balances(

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

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

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

196:
197: v_transaction_id NUMBER := -1;
198:
199: /* Added by Ramananda for bug#4407165 */
200: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.get_rg1_transaction_id';
201:
202: BEGIN
203: IF p_called_from = 'MANUAL ENTRY' THEN
204: IF p_transaction_type = 'R' THEN

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

310: P_SH_CESS_AMOUNT IN NUMBER DEFAULT NULL/*Bug 5989740 bduvarag*/
311: ) IS
312:
313: /* Added by Ramananda for bug#4407165 */
314: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.create_rg1_entry';
315:
316: vMaxSlno NUMBER;
317: v_transaction_id JAI_CMN_RG_I_TRXS.TRANSACTION_SOURCE_NUM%TYPE;
318: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

Line 621: END jai_cmn_rg_i_trxs_pkg;

617: app_exception.raise_exception;
618:
619: END create_rg1_entry;
620:
621: END jai_cmn_rg_i_trxs_pkg;