1 PACKAGE eam_text_util AUTHID DEFINER AS
2 /* $Header: EAMVTIUS.pls 120.2 2006/01/12 04:22:08 cboppana noship $*/
3
4
5 -- -----------------------------------------------------------------------------
6 -- Public Globals
7 -- -----------------------------------------------------------------------------
8
9 G_FILE_NAME CONSTANT VARCHAR2(12) := 'EAMVTIUS.pls';
10
11
12 -- -----------------------------------------------------------------------------
13 -- Procedures
14 -- -----------------------------------------------------------------------------
15
16 PROCEDURE Set_Context ( p_context IN VARCHAR2 );
17
18 /***
19 *** Procedure called when an asset is create/updated
20 **/
21 PROCEDURE Process_Asset_Update_Event
22 (
23 p_event IN VARCHAR2 DEFAULT NULL
24 , p_instance_id IN NUMBER
25 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
26 , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
27 , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
28 , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
29 );
30
31
32 /***
33 ***** Proedure called when a workorder is created/updated
34 ***/
35 PROCEDURE Process_Wo_Event
36 (
37 p_event IN VARCHAR2 DEFAULT NULL,
38 p_wip_entity_id IN NUMBER,
39 p_organization_id IN NUMBER DEFAULT NULL
40 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41 , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
42 , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
43 , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
44 );
45
46 /***
47 ***** Proedure called when a status code is updated from User Defined Statuses form
48 ***/
49 PROCEDURE Process_Status_Update_Event
50 (
51 p_event IN VARCHAR2 DEFAULT NULL,
52 p_status_id IN NUMBER
53 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
54 , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
55 , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
56 , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
57 , x_return_status IN OUT NOCOPY VARCHAR2
58 );
59
60 /*****
61 ***** Procedure called from the Intermedia index for asset to find the text on which index has to be created
62 *****/
63 PROCEDURE Get_Asset_Text
64 (
65 p_rowid IN ROWID
66 , p_output_type IN VARCHAR2
67 , x_tlob IN OUT NOCOPY CLOB
68 , x_tchar IN OUT NOCOPY VARCHAR2
69 );
70
71 /*****
72 ***** Procedure called from the Intermedia index for work ordersto find the text on which index has to be created
73 *****/
74 PROCEDURE Get_Wo_Text
75 (
76 p_rowid IN ROWID
77 , p_output_type IN VARCHAR2
78 , x_tlob IN OUT NOCOPY CLOB
79 , x_tchar IN OUT NOCOPY VARCHAR2
80 );
81
82 /****
83 **** Procedure called when the intermedia index has to be updated
84 ****/
85 PROCEDURE Sync_Index ( p_idx_name IN VARCHAR2);
86
87
88 -- -----------------------------------------------------------------------------
89 -- Functions
90 -- -----------------------------------------------------------------------------
91
92 FUNCTION get_Prod_Schema
93 RETURN VARCHAR2;
94
95 FUNCTION get_DB_Version_Num
96 RETURN NUMBER;
97
98 FUNCTION get_DB_Version_Str
99 RETURN VARCHAR2;
100
101 -- -----------------------------------------------------------------------------
102 -- End of Package Spec
103 -- -----------------------------------------------------------------------------
104
105 END eam_text_util;