APPS.PA_ADVERTISEMENTS_PVT dependencies on FND_USER

Line 1217: l_ntf_recipient_user_name fnd_user.user_name%TYPE;

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

Line 1414: --Getting recepients fnd user name

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