DBA Data[Home] [Help]

APPS.AML_MONITOR_WF dependencies on FND_USER

Line 721: user_name fnd_user.user_name%type

717: l_language varchar2(100);
718: l_territory varchar2(100);
719:
720: TYPE UserRecType IS RECORD (
721: user_name fnd_user.user_name%type
722: );
723: TYPE UserTableType IS TABLE OF UserRecType INDEX BY BINARY_INTEGER;
724:
725: l_user_table UserTableType;

Line 755: FROM as_sales_leads lead, fnd_user usr

751: WHERE sales_lead_id = c_sales_lead_id;
752:
753: CURSOR c_lead_owner (c_lead_id number) IS
754: SELECT usr.user_name
755: FROM as_sales_leads lead, fnd_user usr
756: WHERE lead.sales_lead_id = c_lead_id
757: and lead.assign_to_person_id = usr.employee_id;
758:
759:

Line 769: /* FROM pv_process_rules_b rule, fnd_user usr, jtf_rs_resource_extns res */

765:
766: /* */
767: /* CURSOR c_monitor_owner (c_process_rule_id number) IS */
768: /* SELECT usr.user_name */
769: /* FROM pv_process_rules_b rule, fnd_user usr, jtf_rs_resource_extns res */
770: /* WHERE rule.process_rule_id = c_process_rule_id */
771: /* AND rule.owner_resource_id = res.resource_id */
772: /* and res.user_id = usr.user_id; */
773:

Line 776: from jtf_rs_rep_managers mgr, fnd_user usr, jtf_rs_resource_extns res

772: /* and res.user_id = usr.user_id; */
773:
774: Cursor c_get_mgr_username (c_resource_id number, c_group_id number) is
775: select usr.user_name, res.resource_id
776: from jtf_rs_rep_managers mgr, fnd_user usr, jtf_rs_resource_extns res
777: where mgr.manager_person_id = res.source_id
778: and res.user_id = usr.user_id
779: and mgr.resource_id= c_resource_id
780: and mgr.group_id = c_group_id

Line 3217: FROM as_sales_leads lead, fnd_user usr

3213: WHERE sales_lead_id = c_sales_lead_id;
3214:
3215: CURSOR c_lead_owner (c_lead_id number) IS
3216: SELECT usr.user_name
3217: FROM as_sales_leads lead, fnd_user usr
3218: WHERE lead.sales_lead_id = c_lead_id
3219: and lead.assign_to_person_id = usr.employee_id;
3220:
3221:

Line 3229: from jtf_rs_rep_managers mgr, fnd_user usr, jtf_rs_resource_extns res

3225: where resource_id = c_assign_to_salesforce_id;
3226:
3227: Cursor c_get_mgr_username (c_resource_id number, c_group_id number) is
3228: select usr.user_name, res.resource_id
3229: from jtf_rs_rep_managers mgr, fnd_user usr, jtf_rs_resource_extns res
3230: where mgr.manager_person_id = res.source_id
3231: and res.user_id = usr.user_id
3232: and mgr.resource_id= c_resource_id
3233: and mgr.group_id = c_group_id

Line 3302: -- First check if there is an fnd_user entry

3298: avalue => l_lead_owner_fullname);
3299:
3300:
3301: -- Send Notifications as per following Logic
3302: -- First check if there is an fnd_user entry
3303: -- if yes, add the user_name to adhoc role
3304: -- if not, create adhoc user and add the addhoc user to adhoc role
3305: -- Also in this case a notification to go out to AS_DEFAULT_RESOURCE_ID
3306:

Line 3326: -- if no fnd_user record, then send email only

3322: avalue => l_lead_owner_username);
3323:
3324:
3325: else
3326: -- if no fnd_user record, then send email only
3327: -- need to create adhoc role. get per people info
3328: OPEN c_get_resource_info(l_resource_id);
3329: FETCH c_get_resource_info
3330: INTO l_own_source_id, l_own_source_name, l_own_source_email, l_lead_owner_username;

Line 3365: end if; -- if fnd user

3361: if l_source_username is not null then
3362: l_notify_role_list := l_notify_role_list||','||l_source_username;
3363: end if;
3364:
3365: end if; -- if fnd user
3366:
3367: IF (AS_DEBUG_LOW_ON) THEN
3368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, '1' || l_notify_role_list);
3369: END IF;