DBA Data[Home] [Help]

APPS.PER_QH_ACTION dependencies on WF_NOTIFICATION

Line 810: l_nid:=wf_notification.send(p_role

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

Line 821: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);

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);

Line 822: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_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);

Line 823: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);

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);

Line 824: wf_notification.setAttrText(l_nid,'TITLE',p_title);

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);

Line 825: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);

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);

Line 826: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);

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);

Line 827: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);

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);

Line 828: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);

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);

Line 829: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);

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);

Line 830: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);

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);

Line 831: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);

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);

Line 832: wf_notification.setAttrText(l_nid,'GRADE',p_grade);

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);

Line 833: wf_notification.setAttrText(l_nid,'JOB',p_job);

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);

Line 834: wf_notification.setAttrText(l_nid,'POSITION',p_position);

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);

Line 835: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);

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);

Line 836: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);

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);

Line 837: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);

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);

Line 838: wf_notification.setAttrText(l_nid,'LOCATION',p_location);

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);

Line 839: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);

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:

Line 840: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);

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

Line 841: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);

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);

Line 842: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);

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

Line 845: wf_notification.setAttrText(l_nid,'GRADE_LADDER',p_grade_ladder);

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: --

Line 854: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);

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

Line 855: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);

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

Line 856: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);

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');

Line 857: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);

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);

Line 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;

Line 919: wf_notification.setAttrText(l_nid,'FF1',l_ff1);

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);

Line 920: wf_notification.setAttrText(l_nid,'FF2',l_ff2);

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: --

Line 921: wf_notification.setAttrText(l_nid,'FF3',l_ff3);

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);

Line 922: wf_notification.setAttrText(l_nid,'FF4',l_ff4);

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: --

Line 923: wf_notification.setAttrText(l_nid,'FF5',l_ff5);

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;

Line 1018: WF_NOTIFICATION.Denormalize_Notification(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: --

Line 1110: l_subject:=wf_notification.getSubject(l_nid);

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;

Line 1111: l_body:=wf_notification.getBody(l_nid);

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;