APPS.PQP_RIW_JOB_WRAPPER dependencies on PER_JOBS

Line 723: l_name per_jobs.name%TYPE;

719: ) is
720:
721: l_validate boolean := false;
722: l_obj_ver_num number(3);
723: l_name per_jobs.name%TYPE;
724: l_valid_grades_changed_warning boolean;
725: begin
726: hr_utility.trace('job id : ' || p_job_id);
727: select object_version_number into l_obj_ver_num from per_jobs

Line 727: select object_version_number into l_obj_ver_num from per_jobs

723: l_name per_jobs.name%TYPE;
724: l_valid_grades_changed_warning boolean;
725: begin
726: hr_utility.trace('job id : ' || p_job_id);
727: select object_version_number into l_obj_ver_num from per_jobs
728: where JOB_ID=p_job_id;
729: hr_job_api.update_job
730: (p_validate => l_validate
731: ,p_job_id => p_job_id

Line 859: l_name per_jobs.name%TYPE;

855: ,p_job_group_id in number
856: ) is
857:
858: l_proc varchar2(72) := g_package ||'.check_job_exists';
859: l_name per_jobs.name%TYPE;
860: l_flex_num number;
861: cursor idsel is
862: select pjg.ID_FLEX_NUM
863: from per_job_groups pjg

Line 921: from per_jobs

917: ,p_concat_segments_out => l_name
918: );
919:
920: select job_id into p_job_id
921: from per_jobs
922: where business_group_id = p_business_group_id
923: and name = l_name;
924:
925: Exception

Line 1023: l_job_id per_jobs.job_id%TYPE;

1019: ,p_interface_code in varchar2
1020: ) is
1021:
1022: l_validate boolean := false;
1023: l_job_id per_jobs.job_id%TYPE;
1024: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
1025: l_name per_jobs.name%TYPE;
1026: l_object_version_number per_jobs.object_version_number%TYPE;
1027: l_job_rec job_record;

Line 1024: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;

1020: ) is
1021:
1022: l_validate boolean := false;
1023: l_job_id per_jobs.job_id%TYPE;
1024: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
1025: l_name per_jobs.name%TYPE;
1026: l_object_version_number per_jobs.object_version_number%TYPE;
1027: l_job_rec job_record;
1028:

Line 1025: l_name per_jobs.name%TYPE;

1021:
1022: l_validate boolean := false;
1023: l_job_id per_jobs.job_id%TYPE;
1024: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
1025: l_name per_jobs.name%TYPE;
1026: l_object_version_number per_jobs.object_version_number%TYPE;
1027: l_job_rec job_record;
1028:
1029:

Line 1026: l_object_version_number per_jobs.object_version_number%TYPE;

1022: l_validate boolean := false;
1023: l_job_id per_jobs.job_id%TYPE;
1024: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
1025: l_name per_jobs.name%TYPE;
1026: l_object_version_number per_jobs.object_version_number%TYPE;
1027: l_job_rec job_record;
1028:
1029:
1030: l_proc varchar2(72) := g_package ||'.insupd_job';