eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QH_ACTION dependencies on WF_NOTIFICATION

Line 835: l_nid:=wf_notification.send(p_role

831: begin
832: --
833: hr_utility.set_location('Entering:'||l_proc||'/'||p_wf_Name, 10);
834: --
835: l_nid:=wf_notification.send(p_role
836: ,p_wf_name
837: ,p_notification
838: ,null
839: ,null

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

842: );
843: --
844: hr_utility.set_location(l_proc, 20);
845: --
846: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
847: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
848: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
849: wf_notification.setAttrText(l_nid,'TITLE',p_title);
850: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);

Line 847: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);

843: --
844: hr_utility.set_location(l_proc, 20);
845: --
846: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
847: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
848: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
849: wf_notification.setAttrText(l_nid,'TITLE',p_title);
850: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
851: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);

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

844: hr_utility.set_location(l_proc, 20);
845: --
846: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
847: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
848: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
849: wf_notification.setAttrText(l_nid,'TITLE',p_title);
850: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
851: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
852: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);

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

845: --
846: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
847: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
848: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
849: wf_notification.setAttrText(l_nid,'TITLE',p_title);
850: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
851: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
852: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
853: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);

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

846: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
847: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
848: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
849: wf_notification.setAttrText(l_nid,'TITLE',p_title);
850: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
851: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
852: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
853: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
854: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);

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

847: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
848: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
849: wf_notification.setAttrText(l_nid,'TITLE',p_title);
850: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
851: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
852: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
853: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
854: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
855: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);

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

848: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
849: wf_notification.setAttrText(l_nid,'TITLE',p_title);
850: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
851: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
852: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
853: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
854: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
855: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
856: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);

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

849: wf_notification.setAttrText(l_nid,'TITLE',p_title);
850: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
851: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
852: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
853: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
854: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
855: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
856: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
857: wf_notification.setAttrText(l_nid,'GRADE',p_grade);

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

850: wf_notification.setAttrText(l_nid,'FIRST_NAME',p_first_name);
851: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
852: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
853: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
854: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
855: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
856: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
857: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
858: wf_notification.setAttrText(l_nid,'JOB',p_job);

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

851: wf_notification.setAttrText(l_nid,'LAST_NAME',p_last_name);
852: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
853: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
854: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
855: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
856: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
857: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
858: wf_notification.setAttrText(l_nid,'JOB',p_job);
859: wf_notification.setAttrText(l_nid,'POSITION',p_position);

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

852: wf_notification.setAttrText(l_nid,'EMPLOYEE_NUMBER',p_employee_number);
853: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
854: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
855: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
856: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
857: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
858: wf_notification.setAttrText(l_nid,'JOB',p_job);
859: wf_notification.setAttrText(l_nid,'POSITION',p_position);
860: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);

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

853: wf_notification.setAttrText(l_nid,'APPLICANT_NUMBER',p_applicant_number);
854: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
855: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
856: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
857: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
858: wf_notification.setAttrText(l_nid,'JOB',p_job);
859: wf_notification.setAttrText(l_nid,'POSITION',p_position);
860: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
861: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);

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

854: wf_notification.setAttrText(l_nid,'NATIONAL_IDENTIFIER',p_national_identifier);
855: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
856: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
857: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
858: wf_notification.setAttrText(l_nid,'JOB',p_job);
859: wf_notification.setAttrText(l_nid,'POSITION',p_position);
860: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
861: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
862: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);

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

855: wf_notification.setAttrDate(l_nid,'ASG_EFFECTIVE_START_DATE',p_asg_effective_start_date);
856: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
857: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
858: wf_notification.setAttrText(l_nid,'JOB',p_job);
859: wf_notification.setAttrText(l_nid,'POSITION',p_position);
860: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
861: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
862: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
863: wf_notification.setAttrText(l_nid,'LOCATION',p_location);

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

856: wf_notification.setAttrText(l_nid,'ORGANIZATION',p_organization);
857: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
858: wf_notification.setAttrText(l_nid,'JOB',p_job);
859: wf_notification.setAttrText(l_nid,'POSITION',p_position);
860: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
861: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
862: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
863: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
864: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);

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

857: wf_notification.setAttrText(l_nid,'GRADE',p_grade);
858: wf_notification.setAttrText(l_nid,'JOB',p_job);
859: wf_notification.setAttrText(l_nid,'POSITION',p_position);
860: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
861: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
862: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
863: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
864: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
865: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);

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

858: wf_notification.setAttrText(l_nid,'JOB',p_job);
859: wf_notification.setAttrText(l_nid,'POSITION',p_position);
860: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
861: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
862: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
863: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
864: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
865: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
866: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);

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

859: wf_notification.setAttrText(l_nid,'POSITION',p_position);
860: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
861: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
862: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
863: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
864: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
865: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
866: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
867: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);

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

860: wf_notification.setAttrText(l_nid,'PAYROLL',p_payroll);
861: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
862: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
863: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
864: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
865: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
866: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
867: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
868:

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

861: wf_notification.setAttrText(l_nid,'VACANCY',p_vacancy);
862: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
863: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
864: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
865: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
866: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
867: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
868:
869: IF p_wf_name <> 'PECWKNOT' THEN -- # 3295399

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

862: wf_notification.setAttrText(l_nid,'SUPERVISOR',p_supervisor);
863: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
864: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
865: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
866: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
867: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
868:
869: IF p_wf_name <> 'PECWKNOT' THEN -- # 3295399
870: wf_notification.setAttrText(l_nid,'GRADE_LADDER',p_grade_ladder);

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

863: wf_notification.setAttrText(l_nid,'LOCATION',p_location);
864: wf_notification.setAttrNumber(l_nid,'SALARY',p_salary);
865: wf_notification.setAttrText(l_nid,'SALARY_CURRENCY',p_salary_currency);
866: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
867: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
868:
869: IF p_wf_name <> 'PECWKNOT' THEN -- # 3295399
870: wf_notification.setAttrText(l_nid,'GRADE_LADDER',p_grade_ladder);
871: END IF; -- # 3295399

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

866: wf_notification.setAttrText(l_nid,'PAY_BASIS',p_pay_basis);
867: wf_notification.setAttrDate(l_nid,'DATE_PROBATION_END',p_date_probation_end);
868:
869: IF p_wf_name <> 'PECWKNOT' THEN -- # 3295399
870: wf_notification.setAttrText(l_nid,'GRADE_LADDER',p_grade_ladder);
871: END IF; -- # 3295399
872: --
873: -- Attributes for CWK seeded WORKFLOW.
874: --

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

875: IF p_wf_name = 'PECWKNOT' THEN
876: --
877: hr_utility.set_location(l_proc, 25);
878: --
879: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);
880: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);
881: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);
882: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);
883: -- # 3295399 Start

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

876: --
877: hr_utility.set_location(l_proc, 25);
878: --
879: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);
880: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);
881: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);
882: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);
883: -- # 3295399 Start
884: if p_notification ='NEW_CWK' then

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

877: hr_utility.set_location(l_proc, 25);
878: --
879: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);
880: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);
881: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);
882: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);
883: -- # 3295399 Start
884: if p_notification ='NEW_CWK' then
885: l_user_name := fnd_profile.value('USERNAME');

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

878: --
879: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);
880: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);
881: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);
882: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);
883: -- # 3295399 Start
884: if p_notification ='NEW_CWK' then
885: l_user_name := fnd_profile.value('USERNAME');
886: wf_notification.setAttrText(l_nid,'#FROM_ROLE',l_user_name);

Line 886: wf_notification.setAttrText(l_nid,'#FROM_ROLE',l_user_name);

882: wf_notification.setAttrDate(l_nid,'START_DATE',p_placement_date_start);
883: -- # 3295399 Start
884: if p_notification ='NEW_CWK' then
885: l_user_name := fnd_profile.value('USERNAME');
886: wf_notification.setAttrText(l_nid,'#FROM_ROLE',l_user_name);
887: End if;
888: -- # 3295399 End
889: --
890: END IF;

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

940: --
941: close csr_formula_id;
942: end if;
943: --
944: wf_notification.setAttrText(l_nid,'FF1',l_ff1);
945: wf_notification.setAttrText(l_nid,'FF2',l_ff2);
946: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
947: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
948: wf_notification.setAttrText(l_nid,'FF5',l_ff5);

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

941: close csr_formula_id;
942: end if;
943: --
944: wf_notification.setAttrText(l_nid,'FF1',l_ff1);
945: wf_notification.setAttrText(l_nid,'FF2',l_ff2);
946: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
947: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
948: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
949: --

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

942: end if;
943: --
944: wf_notification.setAttrText(l_nid,'FF1',l_ff1);
945: wf_notification.setAttrText(l_nid,'FF2',l_ff2);
946: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
947: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
948: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
949: --
950: hr_utility.set_location(l_proc, 80);

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

943: --
944: wf_notification.setAttrText(l_nid,'FF1',l_ff1);
945: wf_notification.setAttrText(l_nid,'FF2',l_ff2);
946: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
947: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
948: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
949: --
950: hr_utility.set_location(l_proc, 80);
951: --

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

944: wf_notification.setAttrText(l_nid,'FF1',l_ff1);
945: wf_notification.setAttrText(l_nid,'FF2',l_ff2);
946: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
947: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
948: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
949: --
950: hr_utility.set_location(l_proc, 80);
951: --
952: return l_nid;

Line 1043: WF_NOTIFICATION.Denormalize_Notification(l_nid);

1039: );
1040: hr_utility.set_location(l_proc, 20);
1041: --
1042: --Added for bug 5586890
1043: WF_NOTIFICATION.Denormalize_Notification(l_nid);
1044: commit;
1045: --
1046: hr_utility.set_location('Leaving:'|| l_proc, 30);
1047: --

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

1131: hr_utility.set_location(l_proc, 20);
1132: --
1133: if l_nid is not null then
1134: hr_utility.set_location(l_proc, 30);
1135: l_subject:=wf_notification.getSubject(l_nid);
1136: l_body:=wf_notification.getBody(l_nid);
1137: else
1138: hr_utility.set_location(l_proc, 40);
1139: l_subject:=null;

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

1132: --
1133: if l_nid is not null then
1134: hr_utility.set_location(l_proc, 30);
1135: l_subject:=wf_notification.getSubject(l_nid);
1136: l_body:=wf_notification.getBody(l_nid);
1137: else
1138: hr_utility.set_location(l_proc, 40);
1139: l_subject:=null;
1140: l_body:=null;