1 PACKAGE CSF_REMOTE_VIEWS_PUB AUTHID CURRENT_USER AS
2 /* $Header: CSFPRVWS.pls 115.4.11510.1 2004/06/24 13:35:29 appldev ship $ */
3
4 -- Start of comments
5 -- API name : Parse_Query
6 -- Type : Public
7 -- Function : Parse a SQL-Query to check if it is correctly executable.
8 -- Pre-reqs : None
9 -- Parameters :
10 -- p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE Optional
12 -- x_return_status OUT NOCOPY VARCHAR2
13 -- x_msg_count OUT NOCOPY NUMBER
14 -- x_msg_data OUT NOCOPY VARCHAR2
15 -- p_sql_query IN VARCHAR2 Required
16 -- Standard SQL-query, ready to be executed when correct.
17 -- x_query_correct OUT NOCOPY VARCHAR2
18 -- x_query_correct will be FND_API.G_TRUE or FND_API.G_FALSE.
19 -- Version : 1.0
20 -- Notes : -
21 --
22 -- End of comments
23
24 procedure Parse_Query
25 ( p_api_version IN NUMBER
26 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
27 , x_return_status OUT NOCOPY VARCHAR2
28 , x_msg_count OUT NOCOPY NUMBER
29 , x_msg_data OUT NOCOPY VARCHAR2
30 , p_sql_query IN VARCHAR2
31 , x_query_correct OUT NOCOPY VARCHAR2
32 );
33
34 -- Start of comments
35 -- API name : Execute_Remote_Views
36 -- Type : Public
37 -- Function : Execute predefined remote views. A succesful execution will be sent
38 -- to the requester by use of notifications and a record will be added
39 -- to table csf_l_queryrequests.
40 -- Pre-reqs : Query to execute is defined in csf_l_queries.
41 -- Parameters :
42 -- p_api_version IN NUMBER Required
43 -- p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE Optional
44 -- p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE Optional
45 -- x_return_status OUT NOCOPY VARCHAR2
46 -- x_msg_count OUT NOCOPY NUMBER
47 -- x_msg_data OUT NOCOPY VARCHAR2
48 -- p_sqlstring IN VARCHAR2 Required
49 -- The SQL-string to be executed is either the standard parameterless format or
50 -- has the following special syntax for parameters in the where-clause(s):
51 -- For text : [$Question]
52 -- For number: [&Question]
53 -- For date : [#Question]
54 -- Example: select distinct msi.description
55 -- from mtl_system_items msi
56 -- where description like [$Please enter the pattern of the name:]
57 -- p_parameter_string IN VARCHAR2 Required
58 -- Parameters for p_sqlstring have the following format:
59 -- <String>, followed by Chr(2).
60 -- For a text parameter quotes around the parameter are not allowed and
61 -- the '*'-char is allowed with the meaning of the '%'-char.
62 -- The [...] patterns in t p_sqlstring are replaced with the supplied
63 -- parameters starting with the first [...] (by textual search) and
64 -- the first supplied parameter, followed by the second etc.
65 -- Example: A% || Chr(2) || B* || Chr(2) || 1 || Chr(2)
66 -- p_sqltitle IN VARCHAR2 Required
67 -- p_role IN VARCHAR2 Required
68 -- p_requestdate IN DATE Required
69 -- p_query_id IN NUMBER Required
70 -- corresponds to existing csf_queries.queries_id.
71 -- p_queryrequest_id IN NUMBER DEFAULT FND_API.G_MISS_NUM Optional
72 -- Primary Key for insertered record. If a primary key is given it
73 -- is used, otherwise one is generated automatically.
74 -- x_notification_id OUT NUMBER
75 -- corresponds to new wf_notifications.notification_id.
76 -- Version : 1.0
77 -- Notes : If execution fails the results of the execution will not
78 -- be send to the requester.
79 --
80 -- End of comments
81
82 procedure Execute_Remote_View
83 ( p_api_version IN NUMBER
84 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
85 , p_commit IN VARCHAR2 := FND_API.G_FALSE
86 , x_return_status OUT NOCOPY VARCHAR2
87 , x_msg_count OUT NOCOPY NUMBER
88 , x_msg_data OUT NOCOPY VARCHAR2
89 , p_sqlstring IN VARCHAR2
90 , p_parameter_string IN VARCHAR2
91 , p_sqltitle IN VARCHAR2
92 , p_role IN VARCHAR2
93 , p_requestdate IN DATE
94 , p_query_id IN NUMBER
95 , p_queryrequest_id IN NUMBER := FND_API.G_MISS_NUM
96 , x_queryrequest_id OUT NOCOPY NUMBER
97 , x_notification_id OUT NOCOPY NUMBER
98 );
99
100 end CSF_REMOTE_VIEWS_PUB;