eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_QUERY_PUB dependencies on FND_API

Line 21: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

17: --Procedure to insert the new query
18: PROCEDURE INSERT_QUERY
19: (
20: p_API_VERSION IN NUMBER,
21: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
22: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
23: p_QUERY_ID IN NUMBER,
24: p_QUERY_NAME IN VARCHAR2,
25: P_QUERY_DESC IN VARCHAR2,

Line 22: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

18: PROCEDURE INSERT_QUERY
19: (
20: p_API_VERSION IN NUMBER,
21: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
22: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
23: p_QUERY_ID IN NUMBER,
24: p_QUERY_NAME IN VARCHAR2,
25: P_QUERY_DESC IN VARCHAR2,
26: P_QUERY_TYPE IN VARCHAR2,

Line 59: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

55: --Procedure to update the existing query
56: PROCEDURE UPDATE_QUERY
57: (
58: p_API_VERSION IN NUMBER,
59: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
60: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
61: p_QUERY_ID IN NUMBER,
62: p_QUERY_NAME IN VARCHAR2,
63: P_QUERY_DESC IN VARCHAR2,

Line 60: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

56: PROCEDURE UPDATE_QUERY
57: (
58: p_API_VERSION IN NUMBER,
59: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
60: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
61: p_QUERY_ID IN NUMBER,
62: p_QUERY_NAME IN VARCHAR2,
63: P_QUERY_DESC IN VARCHAR2,
64: P_QUERY_TYPE IN VARCHAR2,

Line 98: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

94: --Prodecure to delete a query that is wrongly added or that is no longer required
95: PROCEDURE DELETE_QUERY
96: (
97: p_API_VERSION IN NUMBER,
98: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
99: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
100: p_QUERY_ID IN NUMBER,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_error_message OUT NOCOPY VARCHAR2

Line 99: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

95: PROCEDURE DELETE_QUERY
96: (
97: p_API_VERSION IN NUMBER,
98: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
99: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
100: p_QUERY_ID IN NUMBER,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_error_message OUT NOCOPY VARCHAR2
103: );

Line 109: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

105: --Procedure to Execute a Given Query and store in the Result table
106: PROCEDURE EXECUTE_QUERY
107: (
108: p_API_VERSION IN NUMBER,
109: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
110: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
111: p_USER_ID IN NUMBER,
112: p_QUERY_ID IN NUMBER,
113: p_INSTANCE_ID IN NUMBER,

Line 110: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

106: PROCEDURE EXECUTE_QUERY
107: (
108: p_API_VERSION IN NUMBER,
109: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
110: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
111: p_USER_ID IN NUMBER,
112: p_QUERY_ID IN NUMBER,
113: p_INSTANCE_ID IN NUMBER,
114: x_return_status OUT NOCOPY VARCHAR2,

Line 123: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

119:
120: PROCEDURE INSERT_INSTANCE
121: (
122: p_API_VERSION IN NUMBER,
123: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
124: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
125: p_USER_ID IN NUMBER,
126: p_QUERY_ID IN NUMBER,
127: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,

Line 124: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

120: PROCEDURE INSERT_INSTANCE
121: (
122: p_API_VERSION IN NUMBER,
123: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
124: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
125: p_USER_ID IN NUMBER,
126: p_QUERY_ID IN NUMBER,
127: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,
128: p_INSTANCE_NAME IN VARCHAR2,

Line 141: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

137: --Procedure to Delete a Instance for a Given Query and store in the Acc table
138:
139: PROCEDURE DELETE_INSTANCE
140: ( p_API_VERSION IN NUMBER,
141: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
142: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
143: p_USER_ID IN NUMBER,
144: p_QUERY_ID IN NUMBER,
145: p_INSTANCE_ID IN NUMBER,

Line 142: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

138:
139: PROCEDURE DELETE_INSTANCE
140: ( p_API_VERSION IN NUMBER,
141: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
142: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
143: p_USER_ID IN NUMBER,
144: p_QUERY_ID IN NUMBER,
145: p_INSTANCE_ID IN NUMBER,
146: x_return_status OUT NOCOPY VARCHAR2,

Line 154: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

150: --Public Procedure to Insert a Result once a Given Query is executed by Custom code
151:
152: PROCEDURE INSERT_RESULT
153: ( p_API_VERSION IN NUMBER,
154: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
155: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
156: p_USER_ID IN NUMBER,
157: p_QUERY_ID IN NUMBER,
158: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,

Line 155: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

151:
152: PROCEDURE INSERT_RESULT
153: ( p_API_VERSION IN NUMBER,
154: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
155: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
156: p_USER_ID IN NUMBER,
157: p_QUERY_ID IN NUMBER,
158: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,
159: p_QUERY_RESULT IN BLOB,