APPS.PA_ADVERTISEMENTS_PVT dependencies on FND_USER

Line 1218: l_ntf_recipient_user_name fnd_user.user_name%TYPE;

1214: l_err_stage VARCHAR2(2000);
1215: l_err_stack VARCHAR2(2000);
1216:
1217: i NUMBER;
1218: l_ntf_recipient_user_name fnd_user.user_name%TYPE;
1219: l_display_name VARCHAR2(240);
1220: l_save_threshold NUMBER;
1221: l_wf_item_type VARCHAR2(8);
1222:

Line 1415: --Getting recepients fnd user name

1411: IF l_ntf_recipient_person_id_tbl(i)=-999 THEN
1412: l_ntf_recipient_user_name := p_wf_user_name;
1413: ELSE
1414:
1415: --Getting recepients fnd user name
1416: wf_directory.getusername
1417: (p_orig_system => 'PER'
1418: ,p_orig_system_id => l_ntf_recipient_person_id_tbl(i)
1419: ,p_name => l_ntf_recipient_user_name