105: p_QUERY_ID IN NUMBER,
106: p_INSTANCE_ID IN NUMBER,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_error_message OUT NOCOPY VARCHAR2,
109: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,
110: p_source_module IN VARCHAR2 DEFAULT 'MOBILEADMIN'
111: );
112:
113: --Procedure to Create a Instance for a Given Query and store in the Acc table
119: p_INSTANCE_NAME IN VARCHAR2,
120: p_VARIABLE_ID IN CSM_INTEGER_LIST,
121: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
122: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
123: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,
124: x_INSTANCE_ID OUT NOCOPY NUMBER,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_error_message OUT NOCOPY VARCHAR2
127: );
131: PROCEDURE DELETE_INSTANCE
132: ( p_USER_ID IN NUMBER,
133: p_QUERY_ID IN NUMBER,
134: p_INSTANCE_ID IN NUMBER,
135: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_error_message OUT NOCOPY VARCHAR2
138: );
139:
170: ( p_USER_ID IN NUMBER,
171: p_QUERY_ID IN NUMBER,
172: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,
173: p_QUERY_RESULT IN BLOB,
174: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_error_message OUT NOCOPY VARCHAR2
177: );
178: