APPS.OTA_INITIALIZATION_WF dependencies on PER_ALL_PEOPLE_F

Line 216: l_full_name per_all_people_f.full_name%TYPE;

212: line_id = p_line_id;
213:
214:
215: l_user_name varchar2(100);
216: l_full_name per_all_people_f.full_name%TYPE;
217: l_order_number oe_order_headers.order_number%type;
218: l_header_id oe_order_headers.header_id%type;
219: l_proc varchar2(72) := g_package||'initialize_cancel_event';
220: l_wf_date VARCHAR2(30);

Line 1313: l_creator_full_name per_all_people_f.full_name%TYPE;

1309: l_proc varchar2(72) := g_package||'set_wf_item_attr';
1310:
1311: l_creator_username varchar2(80):= fnd_profile.value('USERNAME');
1312: l_creator_user_Id number := fnd_profile.value('USER_ID');
1313: l_creator_full_name per_all_people_f.full_name%TYPE;
1314:
1315: l_current_username varchar2(80);
1316:
1317: l_current_user_Id number ;

Line 1318: l_current_full_name per_all_people_f.full_name%TYPE;

1314:
1315: l_current_username varchar2(80);
1316:
1317: l_current_user_Id number ;
1318: l_current_full_name per_all_people_f.full_name%TYPE;
1319:
1320: l_creator_person_id per_all_people_f.person_id%type;
1321:
1322: l_supervisor_id per_all_people_f.person_id%Type;

Line 1320: l_creator_person_id per_all_people_f.person_id%type;

1316:
1317: l_current_user_Id number ;
1318: l_current_full_name per_all_people_f.full_name%TYPE;
1319:
1320: l_creator_person_id per_all_people_f.person_id%type;
1321:
1322: l_supervisor_id per_all_people_f.person_id%Type;
1323: l_supervisor_username fnd_user.user_name%TYPE;
1324: l_supervisor_full_name per_all_people_f.full_name%TYPE;

Line 1322: l_supervisor_id per_all_people_f.person_id%Type;

1318: l_current_full_name per_all_people_f.full_name%TYPE;
1319:
1320: l_creator_person_id per_all_people_f.person_id%type;
1321:
1322: l_supervisor_id per_all_people_f.person_id%Type;
1323: l_supervisor_username fnd_user.user_name%TYPE;
1324: l_supervisor_full_name per_all_people_f.full_name%TYPE;
1325:
1326: l_role_name wf_roles.name%type;

Line 1324: l_supervisor_full_name per_all_people_f.full_name%TYPE;

1320: l_creator_person_id per_all_people_f.person_id%type;
1321:
1322: l_supervisor_id per_all_people_f.person_id%Type;
1323: l_supervisor_username fnd_user.user_name%TYPE;
1324: l_supervisor_full_name per_all_people_f.full_name%TYPE;
1325:
1326: l_role_name wf_roles.name%type;
1327: l_role_display_name wf_roles.display_name%type;
1328:

Line 1359: per_all_people_f per

1355: -- get supervisor name
1356: CURSOR csr_supervisor_id IS
1357: SELECT asg.supervisor_id, per.full_name
1358: FROM per_all_assignments_f asg,
1359: per_all_people_f per
1360: WHERE asg.person_id = p_person_id
1361: AND per.person_id = asg.supervisor_id
1362: AND asg.primary_flag = 'Y'
1363: AND trunc(sysdate)