DBA Data[Home] [Help]

APPS.AST_UWQ_LLIST_WORK_ACTION dependencies on FND_PROFILE

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

72: IEU_UWQ_WORK_PANEL_PUB.SET_UWQ_ACTION_DATA(l_uwq_action_data_list, l_action_data);
73:
74: l_uwq_actions_list(2).uwq_action_key := 'UWQ_LAUNCH_APP';
75: l_uwq_actions_list(2).action_data := l_action_data;
76: IF NVL(FND_PROFILE.Value('AST_LAUNCH_OPP_LEAD'), 'N') = 'Y' THEN
77: l_uwq_actions_list(2).dialog_style := 1;
78: ELSE
79: l_uwq_actions_list(2).dialog_style := 3;
80: END IF;

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

118: l_msg_count NUMBER;
119: l_msg_data VARCHAR2(2000);
120: BEGIN
121:
122: IF FND_PROFILE.Value('AST_DEBUG') = 'Y' THEN
123: G_Debug := TRUE;
124: ELSE
125: G_Debug := FALSE;
126: END IF;

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

209: ) IS
210:
211: l_creation_date DATE := SYSDATE;
212: l_last_update_date DATE := SYSDATE;
213: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
214: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
215: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
216:
217: l_task_name VARCHAR2(80); --P

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

210:
211: l_creation_date DATE := SYSDATE;
212: l_last_update_date DATE := SYSDATE;
213: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
214: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
215: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
216:
217: l_task_name VARCHAR2(80); --P
218: l_task_type_id NUMBER; --P

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

211: l_creation_date DATE := SYSDATE;
212: l_last_update_date DATE := SYSDATE;
213: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
214: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
215: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
216:
217: l_task_name VARCHAR2(80); --P
218: l_task_type_id NUMBER; --P
219: l_description VARCHAR2(4000); --P

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

464: x_return_status OUT NOCOPY VARCHAR2
465: ) IS
466:
467: l_last_update_date DATE;
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_admin_group_id NUMBER; --P From GLOBAL.AST_ADMIN_GROUP_ID

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

465: ) IS
466:
467: l_last_update_date DATE;
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_admin_group_id NUMBER; --P From GLOBAL.AST_ADMIN_GROUP_ID
473: l_identity_salesforce_id NUMBER; --P From GLOBAL.AST_RESOURCE_ID

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

466:
467: l_last_update_date DATE;
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_admin_group_id NUMBER; --P From GLOBAL.AST_ADMIN_GROUP_ID
473: l_identity_salesforce_id NUMBER; --P From GLOBAL.AST_RESOURCE_ID
474: l_p_status_code VARCHAR2(30); --P

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

779: ) IS
780:
781: l_creation_date DATE := SYSDATE;
782: l_last_update_date DATE := SYSDATE;
783: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
784: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
785: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
786:
787: l_admin_flag VARCHAR2(1); --P From GLOBAL.AST_ADMIN_FLAG

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

780:
781: l_creation_date DATE := SYSDATE;
782: l_last_update_date DATE := SYSDATE;
783: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
784: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
785: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
786:
787: l_admin_flag VARCHAR2(1); --P From GLOBAL.AST_ADMIN_FLAG
788: l_admin_group_id NUMBER; --P From GLOBAL.AST_ADMIN_GROUP_ID

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

781: l_creation_date DATE := SYSDATE;
782: l_last_update_date DATE := SYSDATE;
783: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
784: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
785: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
786:
787: l_admin_flag VARCHAR2(1); --P From GLOBAL.AST_ADMIN_FLAG
788: l_admin_group_id NUMBER; --P From GLOBAL.AST_ADMIN_GROUP_ID
789: l_default_group_id NUMBER; --P

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

1021: --moved creation date as sysdate for created objects here. jraj 9/4/03
1022: -- last update date is now obtained as datetime from bali...fix for bug 2614503.
1023: -- used for update lead.
1024: l_last_update_date DATE;
1025: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1026: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1027: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1028:
1029: l_admin_flag VARCHAR2(1); --P From GLOBAL.AST_ADMIN_FLAG

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

1022: -- last update date is now obtained as datetime from bali...fix for bug 2614503.
1023: -- used for update lead.
1024: l_last_update_date DATE;
1025: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1026: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1027: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1028:
1029: l_admin_flag VARCHAR2(1); --P From GLOBAL.AST_ADMIN_FLAG
1030: l_sales_lead_id NUMBER;

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

1023: -- used for update lead.
1024: l_last_update_date DATE;
1025: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1026: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1027: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1028:
1029: l_admin_flag VARCHAR2(1); --P From GLOBAL.AST_ADMIN_FLAG
1030: l_sales_lead_id NUMBER;
1031: l_sales_group_id NUMBER; --W

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

1385: ) IS
1386:
1387: l_creation_date DATE := SYSDATE;
1388: l_last_update_date DATE := SYSDATE;
1389: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1390: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1391: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1392:
1393: l_customer_id NUMBER; --W

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

1386:
1387: l_creation_date DATE := SYSDATE;
1388: l_last_update_date DATE := SYSDATE;
1389: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1390: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1391: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1392:
1393: l_customer_id NUMBER; --W
1394: l_source_object_type_code VARCHAR2(60);

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

1387: l_creation_date DATE := SYSDATE;
1388: l_last_update_date DATE := SYSDATE;
1389: l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1390: l_created_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
1391: l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
1392:
1393: l_customer_id NUMBER; --W
1394: l_source_object_type_code VARCHAR2(60);
1395: l_source_object_id NUMBER; --P (Customer_party_id)