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.ASF_USER_PREFERENCE_PUB dependencies on ASF_USER_PREFERENCE

Line 1: PACKAGE BODY ASF_USER_PREFERENCE_PUB AS

1: PACKAGE BODY ASF_USER_PREFERENCE_PUB AS
2: /* $Header: asfuprfb.pls 115.4 2003/02/14 09:17:00 vjayamoh ship $ */
3: -- Start of Comments
4: -- Package name : ASF_USER_PREFERENCE_PUB
5: -- Purpose :

Line 4: -- Package name : ASF_USER_PREFERENCE_PUB

1: PACKAGE BODY ASF_USER_PREFERENCE_PUB AS
2: /* $Header: asfuprfb.pls 115.4 2003/02/14 09:17:00 vjayamoh ship $ */
3: -- Start of Comments
4: -- Package name : ASF_USER_PREFERENCE_PUB
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASF_USER_PREFERENCE_PUB';

5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASF_USER_PREFERENCE_PUB';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asfuprfb.pls';
11:
12: G_OWNER_TABLE_NAME CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
13:

Line 53: INSERT INTO ASF_USER_PREFERENCE(

49: -- Initialize API return status to SUCCESS
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51:
52: BEGIN
53: INSERT INTO ASF_USER_PREFERENCE(
54: preference_id,
55: user_id,
56: created_by,
57: creation_date,

Line 83: ASF_USER_PREFERENCE_S.NEXTVAL,

79: attribute13,
80: attribute14,
81: attribute15
82: ) VALUES (
83: ASF_USER_PREFERENCE_S.NEXTVAL,
84: decode( l_user_preference_rec.user_id, FND_API.G_MISS_NUM, NULL, l_user_preference_rec.user_id),
85:
86: decode( l_user_preference_rec.created_by, FND_API.G_MISS_NUM, NULL, l_user_preference_rec.created_by),
87: decode( l_user_preference_rec.creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), l_user_preference_rec.creation_date),

Line 238: FROM ASF_USER_PREFERENCE

234: --dbms_output.put_line('l_user_preference_rec.preference_id is null');
235: BEGIN
236: SELECT preference_id
237: INTO l_preference_id
238: FROM ASF_USER_PREFERENCE
239: WHERE USER_ID = l_user_preference_rec.user_id
240: AND OWNER_TABLE_NAME = G_OWNER_TABLE_NAME
241: AND PREFERENCE_CODE = l_user_preference_rec.preference_code
242: AND OWNER_TABLE_ID= l_user_preference_rec.owner_table_id;

Line 246: ASF_USER_PREFERENCE_PUB.CREATE_PREFERENCE(

242: AND OWNER_TABLE_ID= l_user_preference_rec.owner_table_id;
243: EXCEPTION
244: WHEN NO_DATA_FOUND THEN
245: BEGIN
246: ASF_USER_PREFERENCE_PUB.CREATE_PREFERENCE(
247: P_user_preference_rec => l_user_preference_rec ,
248: X_Return_Status => x_return_status,
249: X_Msg_Count => x_msg_count,
250: X_Msg_Data => x_msg_data);

Line 269: UPDATE ASF_USER_PREFERENCE

265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: END;
267: IF l_preference_id <> 0 THEN
268: BEGIN
269: UPDATE ASF_USER_PREFERENCE
270: SET
271: last_updated_by = decode( l_user_preference_rec.last_updated_by, FND_API.G_MISS_NUM, last_updated_by, l_user_preference_rec.last_updated_by),
272: last_update_date = decode( l_user_preference_rec.last_update_date, FND_API.G_MISS_DATE, SYSDATE, l_user_preference_rec.last_update_date),
273: last_update_login = decode( l_user_preference_rec.last_update_login, FND_API.G_MISS_NUM, last_update_login, l_user_preference_rec.last_update_login),

Line 308: UPDATE ASF_USER_PREFERENCE

304: END IF;
305: ELSIF NVL(l_user_preference_rec.preference_id,0) > 0 THEN
306: --dbms_output.put_line('l_user_preference_rec.preference_id is not null');
307: BEGIN
308: UPDATE ASF_USER_PREFERENCE
309: SET
310: last_updated_by = decode( l_user_preference_rec.last_updated_by, FND_API.G_MISS_NUM, last_updated_by, l_user_preference_rec.last_updated_by),
311: last_update_date = decode( l_user_preference_rec.last_update_date, FND_API.G_MISS_DATE, SYSDATE, l_user_preference_rec.last_update_date),
312: last_update_login = decode( l_user_preference_rec.last_update_login, FND_API.G_MISS_NUM, last_update_login, l_user_preference_rec.last_update_login),

Line 448: FROM ASF_USER_PREFERENCE

444: --dbms_output.put_line('l_user_preference_rec.preference_id is null');
445: BEGIN
446: SELECT preference_id
447: INTO l_preference_id
448: FROM ASF_USER_PREFERENCE
449: WHERE USER_ID = l_user_preference_rec.user_id
450: AND OWNER_TABLE_NAME = G_OWNER_TABLE_NAME
451: AND PREFERENCE_CODE = l_user_preference_rec.preference_code
452: AND OWNER_TABLE_ID= l_user_preference_rec.owner_table_id;

Line 461: DELETE FROM ASF_USER_PREFERENCE

457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: --APP_EXCEPTION.RAISE_EXCEPTION;
459: END;
460: IF NVL(l_preference_id,0) <> 0 THEN
461: DELETE FROM ASF_USER_PREFERENCE
462: WHERE PREFERENCE_ID = l_preference_id;
463: IF (SQL%NOTFOUND) THEN
464: RAISE NO_DATA_FOUND;
465: -- ELSE

Line 471: DELETE FROM ASF_USER_PREFERENCE

467: END IF;
468: END IF;
469: ELSIF NVL(l_user_preference_rec.preference_id,0) > 0 THEN
470: --dbms_output.put_line('l_user_preference_rec.preference_id is not null');
471: DELETE FROM ASF_USER_PREFERENCE
472: WHERE PREFERENCE_ID = l_user_preference_rec.preference_id;
473: IF (SQL%NOTFOUND) THEN
474: RAISE NO_DATA_FOUND;
475: -- ELSE

Line 539: End ASF_USER_PREFERENCE_PUB;

535:
536:
537: END DELETE_PREFERENCE;
538:
539: End ASF_USER_PREFERENCE_PUB;