DBA Data[Home] [Help]

APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on FND_GLOBAL

Line 461: || replace(p_posting_details_tab(counter).name,'<',fnd_global.local_chr(38)||'lt;')

457: || l_function_name
458: || '&p_svid='||to_char(p_posting_details_tab(counter).object_id)
459: || '&p_spid='||to_char(p_posting_details_tab(counter).posting_content_id)
460: || '">'
461: || replace(p_posting_details_tab(counter).name,'<',fnd_global.local_chr(38)||'lt;')
462: || ' ' || l_break
463: || fnd_global.local_chr(38)||'nbsp; '
464: || fnd_global.local_chr(38)||'nbsp;'
465: || fnd_global.local_chr(38)||'nbsp;'

Line 463: || fnd_global.local_chr(38)||'nbsp; '

459: || '&p_spid='||to_char(p_posting_details_tab(counter).posting_content_id)
460: || '">'
461: || replace(p_posting_details_tab(counter).name,'<',fnd_global.local_chr(38)||'lt;')
462: || ' ' || l_break
463: || fnd_global.local_chr(38)||'nbsp; '
464: || fnd_global.local_chr(38)||'nbsp;'
465: || fnd_global.local_chr(38)||'nbsp;'
466: || fnd_global.local_chr(38)||'nbsp;'
467: || l_brief_description_v || l_break ;

Line 464: || fnd_global.local_chr(38)||'nbsp;'

460: || '">'
461: || replace(p_posting_details_tab(counter).name,'<',fnd_global.local_chr(38)||'lt;')
462: || ' ' || l_break
463: || fnd_global.local_chr(38)||'nbsp; '
464: || fnd_global.local_chr(38)||'nbsp;'
465: || fnd_global.local_chr(38)||'nbsp;'
466: || fnd_global.local_chr(38)||'nbsp;'
467: || l_brief_description_v || l_break ;
468: --

Line 465: || fnd_global.local_chr(38)||'nbsp;'

461: || replace(p_posting_details_tab(counter).name,'<',fnd_global.local_chr(38)||'lt;')
462: || ' ' || l_break
463: || fnd_global.local_chr(38)||'nbsp; '
464: || fnd_global.local_chr(38)||'nbsp;'
465: || fnd_global.local_chr(38)||'nbsp;'
466: || fnd_global.local_chr(38)||'nbsp;'
467: || l_brief_description_v || l_break ;
468: --
469: IF (l_available_size > 0 ) THEN

Line 466: || fnd_global.local_chr(38)||'nbsp;'

462: || ' ' || l_break
463: || fnd_global.local_chr(38)||'nbsp; '
464: || fnd_global.local_chr(38)||'nbsp;'
465: || fnd_global.local_chr(38)||'nbsp;'
466: || fnd_global.local_chr(38)||'nbsp;'
467: || l_brief_description_v || l_break ;
468: --
469: IF (l_available_size > 0 ) THEN
470: l_available_size := l_available_size - length(l_job_html);

Line 554: l_brief_description_v := replace(l_brief_description_v,fnd_global.local_chr(38)||'nbsp;',' ');

550: AND language = userenv('LANG');
551: --
552: IF (l_length > 0) THEN
553: l_brief_description_v := remove_html_tags (l_brief_description_v) || ' ...';
554: l_brief_description_v := replace(l_brief_description_v,fnd_global.local_chr(38)||'nbsp;',' ');
555: ELSE
556: l_brief_description_v := '';
557: END IF;
558: --

Line 618: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';

614: else
615: l_url:=l_url||'OA_HTML/';
616: end if;
617: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
618: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
619: -- Loop through the suitable jobs and and list them.
620: l_seeker_html := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
621: || '
';
622: --

Line 626: || replace(ltrim(p_seeker_details_tab(counter).full_name,chr(0)),'<',fnd_global.local_chr(38)||'lt;')

622: --
623: l_max_length:=30000-(length(l_seeker_html)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));
624: FOR counter IN 1 .. p_seeker_details_tab.count LOOP
625: l_new_html:= '
'
626: || replace(ltrim(p_seeker_details_tab(counter).full_name,chr(0)),'<',fnd_global.local_chr(38)||'lt;')
627: || '
'
628: || '
';
629: if(length(l_seeker_html)+length(l_new_html)<=l_max_length) then
630: l_seeker_html := l_seeker_html||l_new_html;

Line 666: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';

662: else
663: l_url:=l_url||'OA_HTML/';
664: end if;
665: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
666: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
667: -- Loop through the suitable jobs and and list them.
668: l_seeker_text := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
669: || '\n';
670: --

Line 824: if fnd_global.conc_request_id <> -1 then

820: IS
821: BEGIN
822: fnd_file.put_line(which => fnd_file.log,
823: buff => p_message);
824: if fnd_global.conc_request_id <> -1 then
825: -- log is additionally written out via FND_FILE,
826: -- for visibility from view SRS window.
827: fnd_file.put_line(which => fnd_file.output,
828: buff => 'REQ'||p_message);