DBA Data[Home] [Help]

APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on FND_USER

Line 104: p_user_id fnd_user.user_id%TYPE)

100: END check_if_notification_exists;
101:
102: --Bug 5337816
103: PROCEDURE INSERT_NOTIFICATIONS_ACC (p_notification_id wf_notifications.notification_id%TYPE,
104: p_user_id fnd_user.user_id%TYPE)
105: IS
106: l_sysdate DATE;
107: l_count NUMBER;
108: BEGIN

Line 133: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS

129: l_error_msg VARCHAR2(4000);
130: l_return_status VARCHAR2(2000);
131:
132: -- get all notifications in which user is a recipient
133: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS
134: SELECT DISTINCT wfn.notification_id
135: FROM wf_notifications wfn,
136: asg_user au
137: WHERE au.user_id=b_user_id

Line 149: CURSOR c_broadcast_notf(b_user_id fnd_user.user_id%TYPE) IS

145: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
146: AND ACC.USER_ID = AU.USER_ID);
147:
148: --12.1
149: CURSOR c_broadcast_notf(b_user_id fnd_user.user_id%TYPE) IS
150: SELECT DISTINCT wfn.notification_id
151: FROM WF_NOTIFICATIONS wfn,
152: ASG_USER au
153: WHERE au.user_id=b_user_id

Line 426: AND NOT EXISTS( SELECT 1 FROM FND_USER U

422: COMMIT;
423:
424: /*12.1.2 PURGE INACTIVE CSM WF ROLES*/
425: DELETE FROM WF_LOCAL_ROLES B WHERE NAME LIKE 'CSM%ROLE'
426: AND NOT EXISTS( SELECT 1 FROM FND_USER U
427: WHERE USER_NAME=substr(B.NAME,5,length(B.NAME)-9)
428: AND sysdate between nvl(start_date,sysdate-1) and nvl(end_date,sysdate+1));
429:
430:

Line 847: FROM FND_USER WHERE USER_NAME=b_user_name

843: AND au.user_name=b_user_name
844: AND au.enabled='Y';
845:
846: SELECT email_address INTO l_fnd_email
847: FROM FND_USER WHERE USER_NAME=b_user_name
848: AND sysdate between nvl(start_date,sysdate-1) and nvl(end_date,sysdate+1);
849:
850: IF(l_fnd_email is NULL) THEN
851: CSM_UTIL_PKG.LOG('No FND Email found for user CSM_'||b_user_name||'_ROLE in createMobileWFUser',

Line 878: FROM FND_USER fu, Asg_user au ,wf_local_roles wf

874: EXCEPTION
875: WHEN no_data_found THEN
876: SELECT 'CSM_'||fu.user_name||'_ROLE',wf.display_name,fu.email_address
877: INTO role_name,role_display_name,l_fnd_email
878: FROM FND_USER fu, Asg_user au ,wf_local_roles wf
879: WHERE fu.user_name=b_user_name
880: AND sysdate between nvl(fu.start_date,sysdate-1) and nvl(fu.end_date,sysdate+1)
881: AND wf.name=fu.USER_NAME AND au.USER_NAME=fu.USER_NAME AND au.ENABLED='Y' ;
882:

Line 1095: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr

1091: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1092: ) location_id
1093: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1094: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1095: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1096: WHERE au.RESOURCE_ID=b.RESOURCE_ID
1097: AND b.TASK_ASSIGNMENT_ID=b_task_ass_id
1098: AND b.TASK_ID=tsk.TASK_ID
1099: AND acc.TASK_ASSIGNMENT_ID=b.TASK_ASSIGNMENT_ID

Line 1123: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr

1119: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1120: ) location_id
1121: FROM ASG_USER AU, CSM_TASKS_ACC ACC,
1122: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1123: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1124: WHERE acc.TASK_ID=b_task_id
1125: AND acc.TASK_ID=tsk.TASK_ID
1126: AND au.USER_ID=acc.USER_ID
1127: AND tsk.TASK_ID=tsk_tl.TASK_ID

Line 1143: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr

1139: IS
1140: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, acc.TASK_ID,TASK_NAME,TASK_NUMBER,
1141: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id
1142: FROM ASG_USER AU, CSM_TASKS_ACC ACC,
1143: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr
1144: WHERE acc.TASK_ID=b_task_id
1145: AND acc.TASK_ID=tsk.TASK_ID
1146: AND au.USER_ID=acc.USER_ID
1147: AND tsk.TASK_ID=tsk_tl.TASK_ID

Line 1159: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr

1155: IS
1156: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, b.TASK_ID,TASK_NAME,TASK_NUMBER,
1157: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id
1158: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1159: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr
1160: WHERE au.RESOURCE_ID=b.RESOURCE_ID
1161: AND b.TASK_ASSIGNMENT_ID=b_task_ass_id
1162: AND b.TASK_ID=tsk.TASK_ID
1163: AND acc.TASK_ASSIGNMENT_ID=b.TASK_ASSIGNMENT_ID

Line 1180: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr

1176: 'HZ_LOCATION',
1177: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1178: ) location_id
1179: FROM ASG_USER AU, CSM_INCIDENTS_ALL_ACC ACC,cs_incidents_all_b INC,
1180: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1181: WHERE acc.incident_id=b_inc_id
1182: AND au.USER_ID=acc.USER_ID
1183: AND INC.incident_id=acc.incident_id
1184: AND INC.incident_id=INC_TL.incident_id

Line 1196: FND_USER usr,asg_user au

1192: IS
1193: SELECT acc.USER_ID,usr.USER_NAME,usr.email_address,
1194: qry.QUERY_NAME,acc.INSTANCE_NAME
1195: FROM csm_query_b qry,csm_query_instances_acc acc,
1196: FND_USER usr,asg_user au
1197: WHERE acc.QUERY_ID=qry.QUERY_ID
1198: AND acc.INSTANCE_ID=b_inst
1199: AND au.user_id=usr.USER_ID
1200: AND NVL(AU.multi_platform,'N')='N'

Line 1207: FROM mtl_system_items_b b, CSM_MTL_ONHAND_QTY_ACC acc,FND_USER usr ,asg_user au

1203: CURSOR c_parts(b_acc_id NUMBER)
1204: IS
1205: SELECT acc.USER_ID,usr.USER_NAME,usr.email_address,
1206: b.segment1 "ITEM_NAME",b.description,acc.SUBINVENTORY_CODE,acc.QUANTITY, b.primary_uom_code
1207: FROM mtl_system_items_b b, CSM_MTL_ONHAND_QTY_ACC acc,FND_USER usr ,asg_user au
1208: WHERE acc.access_id=b_acc_id
1209: AND b.inventory_item_id=acc.inventory_item_id
1210: AND b.organization_id=acc.organization_id
1211: AND usr.USER_ID=au.USER_ID

Line 1224: , fnd_user usr,asg_user au

1220: nvl(ol.actual_arrival_date,ol.schedule_arrival_date) arrival_date
1221: FROM csm_req_lines_acc acc
1222: , CSP_REQ_LINE_DETAILS crld
1223: , OE_ORDER_LINES_ALL ol, OE_ORDER_HEADERS_ALL oh
1224: , fnd_user usr,asg_user au
1225: WHERE acc.access_id=b_acc_id
1226: AND acc.USER_ID = usr.USER_ID
1227: AND acc.requirement_line_id = crld.requirement_line_id
1228: AND crld.source_id = ol.line_id