578: END IF;
579: END IF;
580: --
581: g_url := g_owa2||'hr_offer_resume_web.setup?'||
582: hr_util_web.prepare_parameter
583: (p_name => 'p_effective_date'
584: ,p_value => hr_date.date_to_canonical(sysdate)
585: ,p_prefix => false)||
586: hr_util_web.prepare_parameter
582: hr_util_web.prepare_parameter
583: (p_name => 'p_effective_date'
584: ,p_value => hr_date.date_to_canonical(sysdate)
585: ,p_prefix => false)||
586: hr_util_web.prepare_parameter
587: (p_name => 'p_applicant_person_id'
588: ,p_value => l_candidate_person_id)||
589: hr_util_web.prepare_parameter
590: (p_name => 'p_assignment_id'
585: ,p_prefix => false)||
586: hr_util_web.prepare_parameter
587: (p_name => 'p_applicant_person_id'
588: ,p_value => l_candidate_person_id)||
589: hr_util_web.prepare_parameter
590: (p_name => 'p_assignment_id'
591: ,p_value => l_candidate_assignment_id)||
592: hr_util_web.prepare_parameter
593: (p_name => 'p_tab'
588: ,p_value => l_candidate_person_id)||
589: hr_util_web.prepare_parameter
590: (p_name => 'p_assignment_id'
591: ,p_value => l_candidate_assignment_id)||
592: hr_util_web.prepare_parameter
593: (p_name => 'p_tab'
594: ,p_value => 2);
595: --
596: -- 10/29/97 Change Ends
660: END IF;
661: -- 10/29/97 Change Ends
662: --
663: g_url := g_owa2||'hr_offer_form_web.setup?'||
664: hr_util_web.prepare_parameter
665: (p_name => 'p_effective_date'
666: ,p_value => hr_date.date_to_chardate(SYSDATE)
667: ,p_prefix => false)||
668: hr_util_web.prepare_parameter
664: hr_util_web.prepare_parameter
665: (p_name => 'p_effective_date'
666: ,p_value => hr_date.date_to_chardate(SYSDATE)
667: ,p_prefix => false)||
668: hr_util_web.prepare_parameter
669: (p_name => 'p_applicant_person_id'
670: ,p_value => l_candidate_person_id)||
671: hr_util_web.prepare_parameter
672: (p_name => 'p_assignment_id'
667: ,p_prefix => false)||
668: hr_util_web.prepare_parameter
669: (p_name => 'p_applicant_person_id'
670: ,p_value => l_candidate_person_id)||
671: hr_util_web.prepare_parameter
672: (p_name => 'p_assignment_id'
673: ,p_value => l_candidate_assignment_id);
674: --
675: wf_engine.SetItemAttrText( itemtype => itemtype,
737: END IF;
738: END IF;
739:
740: g_url := g_owa2||'hr_offer_resume_web.setup?'||
741: hr_util_web.prepare_parameter
742: (p_name => 'p_effective_date'
743: ,p_value => hr_date.date_to_canonical(sysdate)
744: ,p_prefix => false)||
745: hr_util_web.prepare_parameter
741: hr_util_web.prepare_parameter
742: (p_name => 'p_effective_date'
743: ,p_value => hr_date.date_to_canonical(sysdate)
744: ,p_prefix => false)||
745: hr_util_web.prepare_parameter
746: (p_name => 'p_applicant_person_id'
747: ,p_value => l_candidate_person_id)||
748: hr_util_web.prepare_parameter
749: (p_name => 'p_assignment_id'
744: ,p_prefix => false)||
745: hr_util_web.prepare_parameter
746: (p_name => 'p_applicant_person_id'
747: ,p_value => l_candidate_person_id)||
748: hr_util_web.prepare_parameter
749: (p_name => 'p_assignment_id'
750: ,p_value => l_candidate_assignment_id)||
751: hr_util_web.prepare_parameter
752: (p_name => 'p_tab'
747: ,p_value => l_candidate_person_id)||
748: hr_util_web.prepare_parameter
749: (p_name => 'p_assignment_id'
750: ,p_value => l_candidate_assignment_id)||
751: hr_util_web.prepare_parameter
752: (p_name => 'p_tab'
753: ,p_value => 3);
754: --
755: -- 10/29/97 Change Ends