146:
147: -- Initialize API return status to success
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: PRINT_MESSAGE('Link_Content_to_Query called by ' || to_number(FND_GLOBAL.USER_ID));
151:
152:
153: OPEN VALIDATE_UNIQUE(p_query_id, p_content_id);
154: FETCH VALIDATE_UNIQUE INTO l_query_id, l_content_id;
196: ) values (
197: p_content_id,
198: p_query_id,
199: sysdate,
200: FND_GLOBAL.USER_ID,
201: FND_GLOBAL.LOGIN_ID,
202: sysdate,
203: FND_GLOBAL.USER_ID
204: );
197: p_content_id,
198: p_query_id,
199: sysdate,
200: FND_GLOBAL.USER_ID,
201: FND_GLOBAL.LOGIN_ID,
202: sysdate,
203: FND_GLOBAL.USER_ID
204: );
205:
199: sysdate,
200: FND_GLOBAL.USER_ID,
201: FND_GLOBAL.LOGIN_ID,
202: sysdate,
203: FND_GLOBAL.USER_ID
204: );
205:
206: ELSE
207: l_Error_Msg := 'A Link already exists between content_id ';
339:
340: -- Initialize API return status to success
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: PRINT_MESSAGE('Unlink_Content_to_query called by ' || to_number(FND_GLOBAL.USER_ID));
344:
345:
346: OPEN VALIDATE_UNIQUE(p_query_id, p_content_id);
347: FETCH VALIDATE_UNIQUE INTO l_query_id, l_content_id;