APPS.CSF_REMOTE_VIEWS_PUB dependencies on FND_API

Line 11: -- p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE Optional

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

Line 18: -- x_query_correct will be FND_API.G_TRUE or FND_API.G_FALSE.

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

Line 26: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 43: -- p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE Optional

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

Line 44: -- p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE Optional

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

Line 71: -- p_queryrequest_id IN NUMBER DEFAULT FND_API.G_MISS_NUM Optional

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.

Line 84: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 85: , p_commit IN VARCHAR2 := FND_API.G_FALSE

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

Line 95: , p_queryrequest_id IN NUMBER := FND_API.G_MISS_NUM

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: