APPS.INV_CACHE dependencies on INV_CACHE

Line 1: PACKAGE BODY inv_cache AS

1: PACKAGE BODY inv_cache AS
2: /* $Header: INVCACHB.pls 120.8 2010/08/25 15:52:14 hjogleka ship $ */
3:
4: g_om_installed VARCHAR2(10);
5: g_wms_installed_org NUMBER;

Line 657: inv_log_util.TRACE('p_pxn_type:' || p_transaction_type_id || ' l_txn_type:' || l_txn_type,'INV_CACHE',9);

653: l_txn_type := p_transaction_type_id;
654: END IF;
655:
656: IF l_debug = 1 THEN
657: inv_log_util.TRACE('p_pxn_type:' || p_transaction_type_id || ' l_txn_type:' || l_txn_type,'INV_CACHE',9);
658: END IF;
659:
660:
661: l_hash_value := DBMS_UTILITY.get_hash_value

Line 670: inv_log_util.TRACE('found in cache','INV_CACHE',9);

666:
667: IF serial_tag_table.exists(l_hash_value) THEN
668: x_serial_tag := serial_tag_table(l_hash_value);
669: IF l_debug = 1 THEN
670: inv_log_util.TRACE('found in cache','INV_CACHE',9);
671: END IF;
672: ELSE
673: IF set_org_rec(p_organization_id) THEN
674: IF org_rec.WSM_ENABLED_FLAG = 'N' -- OSFM

Line 681: inv_log_util.TRACE('In branch 1','INV_CACHE',9);

677: AND org_rec.EAM_ENABLED_FLAG = 'N' -- EAM
678: AND org_rec.PROJECT_REFERENCE_ENABLED = 2 -- PJM
679: THEN
680: IF l_debug = 1 THEN
681: inv_log_util.TRACE('In branch 1','INV_CACHE',9);
682: END IF;
683: BEGIN
684: SELECT 2 INTO x_serial_tag
685: FROM DUAL

Line 698: inv_log_util.TRACE('x_serial_tag:' || x_serial_tag,'INV_CACHE',9);

694: END;
695: END IF;
696: END IF;
697: IF l_debug = 1 THEN
698: inv_log_util.TRACE('x_serial_tag:' || x_serial_tag,'INV_CACHE',9);
699: END IF;
700: serial_tag_table(l_hash_value) := x_serial_tag;
701:
702: END IF;

Line 713: END inv_cache;

709: WHEN OTHERS THEN
710: RETURN x_serial_tag;
711: END get_serial_tagged;
712:
713: END inv_cache;