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.AST_UWQ_MLIST_WORK_ACTION dependencies on FND_PROFILE

Line 39: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

35: ) IS
36:
37: l_creation_date DATE := SYSDATE;
38: l_last_update_date DATE := SYSDATE;
39: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
40: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
41: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
42:
43: BEGIN

Line 40: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

36:
37: l_creation_date DATE := SYSDATE;
38: l_last_update_date DATE := SYSDATE;
39: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
40: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
41: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
42:
43: BEGIN
44: BEGIN

Line 41: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW

37: l_creation_date DATE := SYSDATE;
38: l_last_update_date DATE := SYSDATE;
39: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
40: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
41: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
42:
43: BEGIN
44: BEGIN
45: SAVEPOINT lock_ams_list;

Line 131: IF NVL(FND_PROFILE.Value('AST_LAUNCH_OPP_LEAD'), 'N') = 'Y' THEN

127:
128: Log_Mesg('Node Refresh Second Action Set');
129: l_uwq_actions_list(2).uwq_action_key := 'UWQ_LAUNCH_APP';
130: l_uwq_actions_list(2).action_data := l_action_data;
131: IF NVL(FND_PROFILE.Value('AST_LAUNCH_OPP_LEAD'), 'N') = 'Y' THEN
132: l_uwq_actions_list(2).dialog_style := 1;
133: ELSE
134: l_uwq_actions_list(2).dialog_style := 3;
135: END IF;

Line 172: IF FND_PROFILE.Value('AST_DEBUG') = 'Y' THEN

168: l_msg_count NUMBER;
169: l_msg_data VARCHAR2(2000);
170: BEGIN
171:
172: IF FND_PROFILE.Value('AST_DEBUG') = 'Y' THEN
173: G_Debug := TRUE;
174: ELSE
175: G_Debug := FALSE;
176: END IF;

Line 275: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

271: l_list_header_id NUMBER;
272:
273: l_creation_date DATE := SYSDATE;
274: l_last_update_date DATE := SYSDATE;
275: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
276: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
277: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
278:
279: l_customer_id NUMBER;

Line 276: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

272:
273: l_creation_date DATE := SYSDATE;
274: l_last_update_date DATE := SYSDATE;
275: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
276: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
277: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
278:
279: l_customer_id NUMBER;
280: l_party_id NUMBER;

Line 277: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW

273: l_creation_date DATE := SYSDATE;
274: l_last_update_date DATE := SYSDATE;
275: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
276: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
277: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
278:
279: l_customer_id NUMBER;
280: l_party_id NUMBER;
281: l_source_object_type_code VARCHAR2(60);

Line 468: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

464: ) IS
465:
466: l_creation_date DATE := SYSDATE;
467: l_last_update_date DATE := SYSDATE;
468: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
469: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
470: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
471:
472: l_list_entry_id NUMBER; --W

Line 469: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

465:
466: l_creation_date DATE := SYSDATE;
467: l_last_update_date DATE := SYSDATE;
468: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
469: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
470: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
471:
472: l_list_entry_id NUMBER; --W
473: l_list_header_id NUMBER; --W

Line 470: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW

466: l_creation_date DATE := SYSDATE;
467: l_last_update_date DATE := SYSDATE;
468: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
469: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
470: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
471:
472: l_list_entry_id NUMBER; --W
473: l_list_header_id NUMBER; --W
474: l_list_source_type VARCHAR2(30); --W

Line 780: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

776: l_list_source_type VARCHAR2(30); --W
777:
778: l_creation_date DATE := SYSDATE;
779: l_last_update_date DATE := SYSDATE;
780: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
781: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
782: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
783:
784: l_admin_group_id NUMBER; --P From GLOBAL.AST_ADMIN_GROUP_ID

Line 781: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

777:
778: l_creation_date DATE := SYSDATE;
779: l_last_update_date DATE := SYSDATE;
780: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
781: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
782: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
783:
784: l_admin_group_id NUMBER; --P From GLOBAL.AST_ADMIN_GROUP_ID
785: l_identity_salesforce_id NUMBER; --P From GLOBAL.AST_RESOURCE_ID

Line 782: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW

778: l_creation_date DATE := SYSDATE;
779: l_last_update_date DATE := SYSDATE;
780: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
781: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
782: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
783:
784: l_admin_group_id NUMBER; --P From GLOBAL.AST_ADMIN_GROUP_ID
785: l_identity_salesforce_id NUMBER; --P From GLOBAL.AST_RESOURCE_ID
786: l_status_code VARCHAR2(30); --P

Line 1080: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

1076: l_list_source_type VARCHAR2(30); --W
1077:
1078: l_creation_date DATE := SYSDATE;
1079: l_last_update_date DATE := SYSDATE;
1080: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1081: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1082: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1083:
1084: l_admin_group_id NUMBER; --P

Line 1081: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

1077:
1078: l_creation_date DATE := SYSDATE;
1079: l_last_update_date DATE := SYSDATE;
1080: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1081: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1082: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1083:
1084: l_admin_group_id NUMBER; --P
1085: l_admin_flag VARCHAR2(1); --P

Line 1082: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW

1078: l_creation_date DATE := SYSDATE;
1079: l_last_update_date DATE := SYSDATE;
1080: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1081: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1082: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1083:
1084: l_admin_group_id NUMBER; --P
1085: l_admin_flag VARCHAR2(1); --P
1086: l_resource_id NUMBER; --P From GLOBAL.AST_RESOURCE_ID

Line 1249: NVL(FND_PROFILE.Value('AS_COMPETITOR_REQUIRED'), 'N') = 'Y' AND

1245:
1246: Log_Mesg('Start parameter validation');
1247: --code commented for R12 enhancement --Start
1248: /* IF l_name = 'KEY_COMPETITOR_ID' AND
1249: NVL(FND_PROFILE.Value('AS_COMPETITOR_REQUIRED'), 'N') = 'Y' AND
1250: l_close_competitor_id IS NULL THEN
1251: l_return_status := 'E';
1252: END IF;
1253:

Line 1423: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

1419: ) IS
1420:
1421: l_creation_date DATE := SYSDATE;
1422: l_last_update_date DATE := SYSDATE;
1423: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1424: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1425: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1426:
1427: l_list_entry_id NUMBER; --W

Line 1424: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW

1420:
1421: l_creation_date DATE := SYSDATE;
1422: l_last_update_date DATE := SYSDATE;
1423: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1424: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1425: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1426:
1427: l_list_entry_id NUMBER; --W
1428: l_list_header_id NUMBER; --W

Line 1425: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW

1421: l_creation_date DATE := SYSDATE;
1422: l_last_update_date DATE := SYSDATE;
1423: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1424: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1425: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1426:
1427: l_list_entry_id NUMBER; --W
1428: l_list_header_id NUMBER; --W
1429: l_list_source_type VARCHAR2(30); --W