[Home] [Help]
PACKAGE: APPS.EGO_ITEM_TEXT_UTIL
Source
1 PACKAGE EGO_ITEM_TEXT_UTIL AUTHID DEFINER AS
2 /* $Header: EGOUIMTS.pls 120.2 2005/07/20 23:56:50 vkeerthi noship $ */
3
4 -- -----------------------------------------------------------------------------
5 -- Public Globals
6 -- -----------------------------------------------------------------------------
7
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOUIMTS.pls';
9
10 g_Internal_Type CONSTANT VARCHAR2(30) := '$$INTERNAL$$';
11 g_Customer_Type CONSTANT VARCHAR2(30) := '$$CUSTOMER$$';
12
13 -- -----------------------------------------------------------------------------
14 -- Set_Context
15 -- -----------------------------------------------------------------------------
16
17 PROCEDURE Set_Context ( p_context IN VARCHAR2 );
18
19 -- -----------------------------------------------------------------------------
20 -- Get_Item_Text
21 -- -----------------------------------------------------------------------------
22
23 PROCEDURE Get_Item_Text
24 (
25 p_rowid IN ROWID
26 , p_output_type IN VARCHAR2
27 , x_tlob IN OUT NOCOPY CLOB
28 , x_tchar IN OUT NOCOPY VARCHAR2
29 );
30
31 -- -----------------------------------------------------------------------------
32 -- Print_Lob
33 -- -----------------------------------------------------------------------------
34
35 PROCEDURE Print_Lob ( p_tlob_loc IN CLOB );
36
37 -- -----------------------------------------------------------------------------
38 -- Sync_Index
39 -- -----------------------------------------------------------------------------
40
41 PROCEDURE Sync_Index ( p_idx_name IN VARCHAR2 DEFAULT NULL );
42
43 -- -----------------------------------------------------------------------------
44 -- Optimize_Index
45 -- -----------------------------------------------------------------------------
46
47 -- Start : Concurrent Program for Optimize iM index
48 PROCEDURE Optimize_Index
49 (
50 ERRBUF OUT NOCOPY VARCHAR2
51 , RETCODE OUT NOCOPY NUMBER
52 , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full
53 , p_dummy IN VARCHAR2 DEFAULT NULL
54 , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited
55 );
56 -- End : Concurrent Program for Optimize iM index
57
58 -- -----------------------------------------------------------------------------
59 -- Process_Source_Table_Event (wrapper)
60 -- -----------------------------------------------------------------------------
61
62 PROCEDURE Process_Source_Table_Event
63 (
64 p_table_name IN VARCHAR2
65 , p_event IN VARCHAR2
66 , p_scope IN VARCHAR2
67 , p_manufacturer_id IN NUMBER
68 , p_old_item_id IN NUMBER
69 , p_item_id IN NUMBER
70 , p_org_id IN NUMBER
71 , p_language IN VARCHAR2
72 , p_source_lang IN VARCHAR2
73 , p_last_update_date IN VARCHAR2
74 , p_last_updated_by IN VARCHAR2
75 , p_last_update_login IN VARCHAR2
76 , p_id_type IN VARCHAR2
77 , p_item_code IN VARCHAR2
78 , p_item_catalog_group_id IN VARCHAR2
79 );
80 -- -----------------------------------------------------------------------------
81 -- Process_Source_Table_Event
82 -- -----------------------------------------------------------------------------
83
84 PROCEDURE Process_Source_Table_Event
85 (
86 p_table_name IN VARCHAR2
87 , p_event IN VARCHAR2
88 , p_scope IN VARCHAR2
89 , p_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
90 , p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
91 , p_language IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
92 , p_source_lang IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
93 , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
94 , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
95 , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
96 , p_id_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
97 , p_item_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
98 , p_item_catalog_group_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
99 );
100
101
102 -- -----------------------------------------------------------------------------
103 -- get_Prod_Schema
104 -- -----------------------------------------------------------------------------
105
106 FUNCTION get_Prod_Schema
107 RETURN VARCHAR2;
108
109 -- -----------------------------------------------------------------------------
110 -- get_DB_Version_Num
111 -- -----------------------------------------------------------------------------
112
113 FUNCTION get_DB_Version_Num
114 RETURN NUMBER;
115
116 FUNCTION get_DB_Version_Str
117 RETURN VARCHAR2;
118 -- -----------------------------------------------------------------------------
119 -- get_DB_Version_Num
120 -- -----------------------------------------------------------------------------
121
122 END EGO_ITEM_TEXT_UTIL;