806: begin
807: --
808: hr_utility.set_location('Entering:'||l_proc||'/'||p_wf_Name, 10);
809: --
810: l_nid:=wf_notification.send(p_role
811: ,p_wf_name
812: ,p_notification
813: ,null
814: ,null
817: );
818: --
819: hr_utility.set_location(l_proc, 20);
820: --
821: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
822: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
823: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
824: wf_notification.setAttrText(l_nid,'TITLE',p_title);
825: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
818: --
819: hr_utility.set_location(l_proc, 20);
820: --
821: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
822: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
823: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
824: wf_notification.setAttrText(l_nid,'TITLE',p_title);
825: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
826: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
819: hr_utility.set_location(l_proc, 20);
820: --
821: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
822: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
823: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
824: wf_notification.setAttrText(l_nid,'TITLE',p_title);
825: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
826: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
827: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
820: --
821: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
822: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
823: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
824: wf_notification.setAttrText(l_nid,'TITLE',p_title);
825: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
826: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
827: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
828: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
821: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
822: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
823: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
824: wf_notification.setAttrText(l_nid,'TITLE',p_title);
825: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
826: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
827: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
828: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
829: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
822: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
823: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
824: wf_notification.setAttrText(l_nid,'TITLE',p_title);
825: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
826: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
827: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
828: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
829: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
830: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
823: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
824: wf_notification.setAttrText(l_nid,'TITLE',p_title);
825: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
826: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
827: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
828: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
829: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
830: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
831: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
824: wf_notification.setAttrText(l_nid,'TITLE',p_title);
825: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
826: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
827: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
828: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
829: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
830: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
831: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
832: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
825: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
826: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
827: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
828: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
829: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
830: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
831: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
832: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
833: wf_notification.setAttrText(l_nid,'JOB',p_job);
826: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
827: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
828: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
829: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
830: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
831: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
832: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
833: wf_notification.setAttrText(l_nid,'JOB',p_job);
834: wf_notification.setAttrText(l_nid,'POSITION',p_position);
827: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
828: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
829: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
830: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
831: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
832: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
833: wf_notification.setAttrText(l_nid,'JOB',p_job);
834: wf_notification.setAttrText(l_nid,'POSITION',p_position);
835: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
828: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
829: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
830: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
831: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
832: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
833: wf_notification.setAttrText(l_nid,'JOB',p_job);
834: wf_notification.setAttrText(l_nid,'POSITION',p_position);
835: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
836: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
829: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
830: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
831: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
832: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
833: wf_notification.setAttrText(l_nid,'JOB',p_job);
834: wf_notification.setAttrText(l_nid,'POSITION',p_position);
835: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
836: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
837: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
830: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
831: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
832: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
833: wf_notification.setAttrText(l_nid,'JOB',p_job);
834: wf_notification.setAttrText(l_nid,'POSITION',p_position);
835: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
836: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
837: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
838: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
831: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
832: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
833: wf_notification.setAttrText(l_nid,'JOB',p_job);
834: wf_notification.setAttrText(l_nid,'POSITION',p_position);
835: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
836: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
837: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
838: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
839: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
832: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
833: wf_notification.setAttrText(l_nid,'JOB',p_job);
834: wf_notification.setAttrText(l_nid,'POSITION',p_position);
835: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
836: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
837: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
838: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
839: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
840: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
833: wf_notification.setAttrText(l_nid,'JOB',p_job);
834: wf_notification.setAttrText(l_nid,'POSITION',p_position);
835: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
836: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
837: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
838: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
839: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
840: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
841: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
834: wf_notification.setAttrText(l_nid,'POSITION',p_position);
835: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
836: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
837: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
838: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
839: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
840: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
841: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
842: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
835: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
836: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
837: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
838: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
839: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
840: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
841: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
842: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
843:
836: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
837: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
838: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
839: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
840: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
841: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
842: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
843:
844: IF p_wf_name <> 'PECWKNOT' THEN -- # 3295399
837: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
838: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
839: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
840: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
841: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
842: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
843:
844: IF p_wf_name <> 'PECWKNOT' THEN -- # 3295399
845: wf_notification.setAttrText(l_nid,'GRADE_LADDER',p_grade_ladder);
838: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
839: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
840: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
841: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
842: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
843:
844: IF p_wf_name <> 'PECWKNOT' THEN -- # 3295399
845: wf_notification.setAttrText(l_nid,'GRADE_LADDER',p_grade_ladder);
846: END IF; -- # 3295399
841: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
842: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
843:
844: IF p_wf_name <> 'PECWKNOT' THEN -- # 3295399
845: wf_notification.setAttrText(l_nid,'GRADE_LADDER',p_grade_ladder);
846: END IF; -- # 3295399
847: --
848: -- Attributes for CWK seeded WORKFLOW.
849: --
850: IF p_wf_name = 'PECWKNOT' THEN
851: --
852: hr_utility.set_location(l_proc, 25);
853: --
854: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);
855: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);
856: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);
857: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);
858: -- # 3295399 Start
851: --
852: hr_utility.set_location(l_proc, 25);
853: --
854: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);
855: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);
856: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);
857: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);
858: -- # 3295399 Start
859: if p_notification ='NEW_CWK' then
852: hr_utility.set_location(l_proc, 25);
853: --
854: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);
855: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);
856: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);
857: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);
858: -- # 3295399 Start
859: if p_notification ='NEW_CWK' then
860: l_user_name := fnd_profile.value('USERNAME');
853: --
854: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);
855: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);
856: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);
857: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);
858: -- # 3295399 Start
859: if p_notification ='NEW_CWK' then
860: l_user_name := fnd_profile.value('USERNAME');
861: wf_notification.setAttrText(l_nid,'#FROM_ROLE',l_user_name);
857: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);
858: -- # 3295399 Start
859: if p_notification ='NEW_CWK' then
860: l_user_name := fnd_profile.value('USERNAME');
861: wf_notification.setAttrText(l_nid,'#FROM_ROLE',l_user_name);
862: End if;
863: -- # 3295399 End
864: --
865: END IF;
915: --
916: close csr_formula_id;
917: end if;
918: --
919: wf_notification.setAttrText(l_nid,'FF1',l_ff1);
920: wf_notification.setAttrText(l_nid,'FF2',l_ff2);
921: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
922: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
923: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
916: close csr_formula_id;
917: end if;
918: --
919: wf_notification.setAttrText(l_nid,'FF1',l_ff1);
920: wf_notification.setAttrText(l_nid,'FF2',l_ff2);
921: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
922: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
923: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
924: --
917: end if;
918: --
919: wf_notification.setAttrText(l_nid,'FF1',l_ff1);
920: wf_notification.setAttrText(l_nid,'FF2',l_ff2);
921: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
922: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
923: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
924: --
925: hr_utility.set_location(l_proc, 80);
918: --
919: wf_notification.setAttrText(l_nid,'FF1',l_ff1);
920: wf_notification.setAttrText(l_nid,'FF2',l_ff2);
921: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
922: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
923: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
924: --
925: hr_utility.set_location(l_proc, 80);
926: --
919: wf_notification.setAttrText(l_nid,'FF1',l_ff1);
920: wf_notification.setAttrText(l_nid,'FF2',l_ff2);
921: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
922: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
923: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
924: --
925: hr_utility.set_location(l_proc, 80);
926: --
927: return l_nid;
1014: );
1015: hr_utility.set_location(l_proc, 20);
1016: --
1017: --Added for bug 5586890
1018: WF_NOTIFICATION.Denormalize_Notification(l_nid);
1019: commit;
1020: --
1021: hr_utility.set_location('Leaving:'|| l_proc, 30);
1022: --
1106: hr_utility.set_location(l_proc, 20);
1107: --
1108: if l_nid is not null then
1109: hr_utility.set_location(l_proc, 30);
1110: l_subject:=wf_notification.getSubject(l_nid);
1111: l_body:=wf_notification.getBody(l_nid);
1112: else
1113: hr_utility.set_location(l_proc, 40);
1114: l_subject:=null;
1107: --
1108: if l_nid is not null then
1109: hr_utility.set_location(l_proc, 30);
1110: l_subject:=wf_notification.getSubject(l_nid);
1111: l_body:=wf_notification.getBody(l_nid);
1112: else
1113: hr_utility.set_location(l_proc, 40);
1114: l_subject:=null;
1115: l_body:=null;