APPS.EAM_TEXT_UTIL dependencies on EAM_TEXT_UTIL

Line 1: PACKAGE BODY eam_text_util AS

1: PACKAGE BODY eam_text_util AS
2: /* $Header: EAMVTIUB.pls 120.9 2006/09/20 15:00:19 sdandapa noship $*/
3:
4:
5: -- -----------------------------------------------------------------------------

Line 8: g_pkg_name CONSTANT VARCHAR2(30):= 'eam_text_util';

4:
5: -- -----------------------------------------------------------------------------
6: -- Private Globals
7: -- -----------------------------------------------------------------------------
8: g_pkg_name CONSTANT VARCHAR2(30):= 'eam_text_util';
9:
10: g_Prod_Short_Name CONSTANT VARCHAR2(30) := 'EAM';
11: g_Prod_Schema VARCHAR2(30);
12: g_Index_Owner VARCHAR2(30);

Line 357: --eam_text_util.Log_Error ('SQL_ERROR', SQLERRM);

353:
354: EXCEPTION
355:
356: WHEN others THEN
357: --eam_text_util.Log_Error ('SQL_ERROR', SQLERRM);
358: --IF (g_Debug) THEN Debug(l_item_id, l_org_id, l_item_code, '** 9: ' || SQLERRM); END IF;
359: RAISE;
360:
361: END Get_Asset_Text;

Line 732: ' eam_text_util.Sync_Index(''EAM_ASSET_TEXT_CTX1''); '||

728: AND status = l_status AND domidx_status = l_status AND domidx_opstatus = l_status;
729: IF (l_count > 0) THEN
730: EXECUTE IMMEDIATE
731: ' BEGIN '||
732: ' eam_text_util.Sync_Index(''EAM_ASSET_TEXT_CTX1''); '||
733: ' END;';
734: /* Calling sync_index would cause database commit. Should be called after commit */
735: END IF;
736: END IF;

Line 856: ' eam_text_util.Sync_Index(''EAM_WORK_ORDER_TEXT_CTX1''); '||

852: AND status = l_status AND domidx_status = l_status AND domidx_opstatus = l_status;
853: IF (l_count > 0) THEN
854: EXECUTE IMMEDIATE
855: ' BEGIN '||
856: ' eam_text_util.Sync_Index(''EAM_WORK_ORDER_TEXT_CTX1''); '||
857: ' END;';
858: END IF;
859: END IF;
860:

Line 926: ' eam_text_util.Sync_Index(''EAM_WORK_ORDER_TEXT_CTX1''); '||

922:
923: IF (l_count > 0) THEN
924: EXECUTE IMMEDIATE
925: ' BEGIN '||
926: ' eam_text_util.Sync_Index(''EAM_WORK_ORDER_TEXT_CTX1''); '||
927: ' END;';
928: END IF;
929:
930: END IF;

Line 1003: END eam_text_util;

999: WHERE PARAMETER = 'NLS_NUMERIC_CHARACTERS';
1000: g_DB_Version_Num := TO_NUMBER( REPLACE(l_DB_Version_Str, '.', l_DB_Numeric_Character) );
1001:
1002:
1003: END eam_text_util;
1004:
1005: