1 PACKAGE IEU_CTRL_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEUVCTLS.pls 120.1 2005/07/14 15:20:54 appldev ship $ */
3 PROCEDURE SET_LANG_INFO
4 (
5 P_USER_LANG IN VARCHAR2
6 );
7
8 ----------------------------------------------------------------------------
9 -- Utility procedure to set language stuff and return the previous lang
10 -- settings
11 ----------------------------------------------------------------------------
12 PROCEDURE SET_LANG_INFO_X
13 (
14 P_USER_LANG IN VARCHAR2,
15 X_EXISTING_LANG OUT NOCOPY VARCHAR2
16 );
17
18 ----------------------------------------------------------------------------
19 -- Stored procedure to retrieve a ctrl message object from the db based on
20 -- filter criteria. It returns a nested table of message objects
21 -- dont think any xlation will play a part here
22 ----------------------------------------------------------------------------
23
24 PROCEDURE GET_CTRL_MESSAGES
25 (
26 P_RESOURCE_ID IN NUMBER,
27 P_STATUS_ID IN NUMBER,
28 P_AGE_FILTER IN NUMBER,
29 X_CTRL_MESSAGES_NST OUT NOCOPY SYSTEM.IEU_CTRL_MESSAGES_NST
30 );
31
32 ----------------------------------------------------------------------------
33 -- Stored procedure to retrieve a ctrl message object from the db based on
34 -- filter criteria( with a time range ).
35 ----------------------------------------------------------------------------
36
37 PROCEDURE GET_CTRL_MESSAGES_T
38 (
39 P_RESOURCE_ID IN NUMBER,
40 P_STATUS_ID IN NUMBER,
41 P_START_FILTER IN NUMBER,
42 P_END_FILTER IN NUMBER,
43 X_CTRL_MESSAGES_NST OUT NOCOPY SYSTEM.IEU_CTRL_MESSAGES_NST
44 );
45
46 ----------------------------------------------------------------------------
47 -- Stored Procedure to store modified ctrl message objects to the db
48 -- This automatically updates the last_update_date
49 -- It takes in a nested table of message objects
50 ----------------------------------------------------------------------------
51
52 PROCEDURE SAVE_CTRL_MESSAGES
53 (
54 P_CTRL_MESSAGES_NST IN SYSTEM.IEU_CTRL_MESSAGES_NST
55 );
56
57 ----------------------------------------------------------------------------
58 -- Stored procedure used to get the information of the plugins
59 -- which are to be loaded by the desktop agent
60 ----------------------------------------------------------------------------
61 PROCEDURE GET_CTRL_PLUGINS
62 (
63 P_RESOURCE_ID IN NUMBER
64 ,P_AGENT_EXTN IN NUMBER
65 ,P_USER_ID IN NUMBER
66 ,P_RESP_ID IN NUMBER
67 ,P_RESP_APPL_ID IN NUMBER
68 ,P_USER_LANG IN VARCHAR2
69 ,X_CTRL_PLUGINS_NST OUT NOCOPY SYSTEM.IEU_CTRL_PLUGINS_NST
70 );
71
72
73 ----------------------------------------------------------------------------
74 -- Used to get the FND Error Message text strings during Error Panel
75 -- initialization. The messages are obtained on the basis of
76 -- messages names passed to the procedure
77 --
78 -- The P_MESSAGE_NST parameter will contain the message names
79 -- and the X_MESSAGE_NST will contain the message name and the
80 -- text. Refer to IEU_CTRL_OD.sql for definitions
81 ----------------------------------------------------------------------------
82 PROCEDURE GET_FND_ERROR_MESSAGES
83 (
84 P_RESOURCE_ID IN NUMBER
85 ,P_FND_MESSAGES_NST IN SYSTEM.IEU_FND_MESSAGES_NST
86 ,P_USER_LANG IN VARCHAR2
87 ,X_FND_MESSAGES_NST OUT NOCOPY SYSTEM.IEU_FND_MESSAGES_NST
88 );
89
90 ----------------------------------------------------------------------------
91 -- Used to get FND Lookup Codes and values( meaning ) based on the
92 -- lookup type and application ID
93 ----------------------------------------------------------------------------
94 PROCEDURE GET_FND_LOOKUP_VALUES
95 (
96 P_RESOURCE_ID IN NUMBER
97 ,P_APP_ID IN NUMBER
98 ,P_LOOKUP_TYPE IN VARCHAR2
99 ,P_USER_LANG IN VARCHAR2
100 ,X_FND_MESSAGES_NST OUT NOCOPY SYSTEM.IEU_FND_MESSAGES_NST
101 );
102
103 ---------------------------------------------------------------------------
104 -- Used to get FND Lookup Codes and values( meaning ) based on the
105 -- lookup type and application ID and sorted on meaning
106 ----------------------------------------------------------------------------
107 PROCEDURE GET_FND_LOOKUP_VALUES_SRT
108 (
109 P_RESOURCE_ID IN NUMBER
110 ,P_APP_ID IN NUMBER
111 ,P_LOOKUP_TYPE IN VARCHAR2
112 ,P_USER_LANG IN VARCHAR2
113 ,X_FND_MESSAGES_NST OUT NOCOPY SYSTEM.IEU_FND_MESSAGES_NST
114 );
115
116 ----------------------------------------------------------------------------
117 -- Used to get FND Lookup Codes and values( meaning ) based on the
118 -- lookup type and application ID
119 ----------------------------------------------------------------------------
120 PROCEDURE GET_FND_LOOKUP_CODES
121 (
122 P_RESOURCE_ID IN NUMBER
123 ,P_APP_ID IN NUMBER
124 ,P_CTRL_STRING_NST IN SYSTEM.IEU_CTRL_STRING_NST
125 ,P_USER_LANG IN VARCHAR2
126 ,X_FND_CODES_NST OUT NOCOPY SYSTEM.IEU_FND_CODES_NST
127 );
128
129 END IEU_CTRL_PVT;