DBA Data[Home] [Help]

APPS.JTF_FM_QUERY_LINK_PKG dependencies on FND_GLOBAL

Line 150: PRINT_MESSAGE('Link_Content_to_Query called by ' || to_number(FND_GLOBAL.USER_ID));

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;

Line 200: FND_GLOBAL.USER_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: );

Line 201: FND_GLOBAL.LOGIN_ID,

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:

Line 203: FND_GLOBAL.USER_ID

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 ';

Line 343: PRINT_MESSAGE('Unlink_Content_to_query called by ' || to_number(FND_GLOBAL.USER_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;