1 PACKAGE eam_execution_jsp AUTHID CURRENT_USER AS
2 /* $Header: EAMEXUJS.pls 115.5 2002/11/18 18:14:18 aan ship $
3 $Author: aan $ */
4
5 -- Standard who
6 g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
7 g_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8 g_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9 g_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
10 g_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
11 g_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
12
13 -- This function accepts as input an organization name and returns as output
14 -- the organization's organization ID. If there is no organization record
15 -- for the given organization name, then this function returns NULL.
16 FUNCTION GetOrgId ( X_org_name IN VARCHAR2 ) RETURN NUMBER;
17 pragma RESTRICT_REFERENCES ( GetOrgId, WNDS, WNPS );
18
19 -- This function accepts as input an organization ID and returns as output
20 -- the organization's name. If there is no organization record for the
21 -- given organization ID, then this function returns NULL.
22 FUNCTION GetOrgName ( X_org_id IN NUMBER ) RETURN VARCHAR2;
23 pragma RESTRICT_REFERENCES ( GetOrgName, WNDS, WNPS );
24
25 -- get time string, temporary
26 FUNCTION to_time_string( date1 IN DATE) RETURN VARCHAR2;
27
28 ---------------------------------------------------------------
29 -- Procedure : Get_Encoded_Msg
30 -- This procedure serves as a wrapper to the function
31 -- FND_MSG_PUB.Get. It is needed to access the call from
32 -- client FORMS.
33 ---------------------------------------------------------------
34 Procedure Get_Encoded_Msg
35 (
36 p_index IN NUMBER,
37 p_msg_out IN OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE Get_Messages
41 (
42 p_encoded IN VARCHAR2 := FND_API.G_FALSE,
43 p_msg_index IN NUMBER := NULL,
44 p_msg_count IN NUMBER := 0,
45 p_msg_data IN VARCHAR2 := NULL,
46 p_data OUT NOCOPY VARCHAR2,
47 p_msg_index_out OUT NOCOPY NUMBER
48 );
49
50
51 ---------------------------------------------------------------
52 -- Procedure : Add_Message
53 -- This procedure serves as a wrapper to the FND_MEG_PUB
54 -- procedures to add the specified message onto the message
55 -- stack.
56 ---------------------------------------------------------------
57 Procedure Add_Message( p_app_short_name IN VARCHAR2,
58 p_msg_name IN VARCHAR2,
59 p_token1 IN VARCHAR2 DEFAULT NULL,
60 p_value1 IN VARCHAR2 DEFAULT NULL,
61 p_token2 IN VARCHAR2 DEFAULT NULL,
62 p_value2 IN VARCHAR2 DEFAULT NULL,
63 p_token3 IN VARCHAR2 DEFAULT NULL,
64 p_value3 IN VARCHAR2 DEFAULT NULL,
65 p_token4 IN VARCHAR2 DEFAULT NULL,
66 p_value4 IN VARCHAR2 DEFAULT NULL,
67 p_token5 IN VARCHAR2 DEFAULT NULL,
68 p_value5 IN VARCHAR2 DEFAULT NULL
69 );
70
71 END eam_execution_jsp;