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.HR_JOB_API dependencies on PER_JOBS

Line 314: l_job_id per_jobs.job_id%TYPE;

310: ) is
311: --
312: -- Declare cursors and local variables
313: --
314: l_job_id per_jobs.job_id%TYPE;
315: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
316: l_business_group_id per_jobs.business_group_id%TYPE;
317: l_name per_jobs.name%TYPE;
318: l_proc varchar2(72) := g_package||'create_job';

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

311: --
312: -- Declare cursors and local variables
313: --
314: l_job_id per_jobs.job_id%TYPE;
315: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
316: l_business_group_id per_jobs.business_group_id%TYPE;
317: l_name per_jobs.name%TYPE;
318: l_proc varchar2(72) := g_package||'create_job';
319: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 316: l_business_group_id per_jobs.business_group_id%TYPE;

312: -- Declare cursors and local variables
313: --
314: l_job_id per_jobs.job_id%TYPE;
315: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
316: l_business_group_id per_jobs.business_group_id%TYPE;
317: l_name per_jobs.name%TYPE;
318: l_proc varchar2(72) := g_package||'create_job';
319: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
320: l_object_version_number per_jobs.object_version_number%TYPE;

Line 317: l_name per_jobs.name%TYPE;

313: --
314: l_job_id per_jobs.job_id%TYPE;
315: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
316: l_business_group_id per_jobs.business_group_id%TYPE;
317: l_name per_jobs.name%TYPE;
318: l_proc varchar2(72) := g_package||'create_job';
319: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
320: l_object_version_number per_jobs.object_version_number%TYPE;
321: l_date_from per_jobs.date_from%TYPE;

Line 320: l_object_version_number per_jobs.object_version_number%TYPE;

316: l_business_group_id per_jobs.business_group_id%TYPE;
317: l_name per_jobs.name%TYPE;
318: l_proc varchar2(72) := g_package||'create_job';
319: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
320: l_object_version_number per_jobs.object_version_number%TYPE;
321: l_date_from per_jobs.date_from%TYPE;
322: l_date_to per_jobs.date_to%TYPE;
323: l_segment1 varchar2(150) := p_segment1;
324: l_segment2 varchar2(150) := p_segment2;

Line 321: l_date_from per_jobs.date_from%TYPE;

317: l_name per_jobs.name%TYPE;
318: l_proc varchar2(72) := g_package||'create_job';
319: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
320: l_object_version_number per_jobs.object_version_number%TYPE;
321: l_date_from per_jobs.date_from%TYPE;
322: l_date_to per_jobs.date_to%TYPE;
323: l_segment1 varchar2(150) := p_segment1;
324: l_segment2 varchar2(150) := p_segment2;
325: l_segment3 varchar2(150) := p_segment3;

Line 322: l_date_to per_jobs.date_to%TYPE;

318: l_proc varchar2(72) := g_package||'create_job';
319: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
320: l_object_version_number per_jobs.object_version_number%TYPE;
321: l_date_from per_jobs.date_from%TYPE;
322: l_date_to per_jobs.date_to%TYPE;
323: l_segment1 varchar2(150) := p_segment1;
324: l_segment2 varchar2(150) := p_segment2;
325: l_segment3 varchar2(150) := p_segment3;
326: l_segment4 varchar2(150) := p_segment4;

Line 987: l_job_id per_jobs.job_id%TYPE;

983: --
984: -- bug 2242339 initialize l_job_definition_id and segment variables with
985: -- values where these are passed into program.
986: --
987: l_job_id per_jobs.job_id%TYPE;
988: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
989: l_business_group_id per_jobs.business_group_id%TYPE;
990: l_name varchar2(700);
991: l_proc varchar2(72) := g_package||'update_job';

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

984: -- bug 2242339 initialize l_job_definition_id and segment variables with
985: -- values where these are passed into program.
986: --
987: l_job_id per_jobs.job_id%TYPE;
988: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
989: l_business_group_id per_jobs.business_group_id%TYPE;
990: l_name varchar2(700);
991: l_proc varchar2(72) := g_package||'update_job';
992: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 989: l_business_group_id per_jobs.business_group_id%TYPE;

985: -- values where these are passed into program.
986: --
987: l_job_id per_jobs.job_id%TYPE;
988: l_job_definition_id per_jobs.job_definition_id%TYPE := p_job_definition_id;
989: l_business_group_id per_jobs.business_group_id%TYPE;
990: l_name varchar2(700);
991: l_proc varchar2(72) := g_package||'update_job';
992: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
993: l_object_version_number per_jobs.object_version_number%TYPE;

Line 993: l_object_version_number per_jobs.object_version_number%TYPE;

989: l_business_group_id per_jobs.business_group_id%TYPE;
990: l_name varchar2(700);
991: l_proc varchar2(72) := g_package||'update_job';
992: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
993: l_object_version_number per_jobs.object_version_number%TYPE;
994: l_valid_grades_changed1 boolean default FALSE;
995: l_valid_grades_changed2 boolean default FALSE;
996: l_api_updating boolean;
997: l_date_from per_jobs.date_from%TYPE;

Line 997: l_date_from per_jobs.date_from%TYPE;

993: l_object_version_number per_jobs.object_version_number%TYPE;
994: l_valid_grades_changed1 boolean default FALSE;
995: l_valid_grades_changed2 boolean default FALSE;
996: l_api_updating boolean;
997: l_date_from per_jobs.date_from%TYPE;
998: l_date_to per_jobs.date_to%TYPE;
999: l_segment1 varchar2(150) := p_segment1;
1000: l_segment2 varchar2(150) := p_segment2;
1001: l_segment3 varchar2(150) := p_segment3;

Line 998: l_date_to per_jobs.date_to%TYPE;

994: l_valid_grades_changed1 boolean default FALSE;
995: l_valid_grades_changed2 boolean default FALSE;
996: l_api_updating boolean;
997: l_date_from per_jobs.date_from%TYPE;
998: l_date_to per_jobs.date_to%TYPE;
999: l_segment1 varchar2(150) := p_segment1;
1000: l_segment2 varchar2(150) := p_segment2;
1001: l_segment3 varchar2(150) := p_segment3;
1002: l_segment4 varchar2(150) := p_segment4;

Line 1040: from per_jobs

1036: cursor idsel is
1037: select pjg.ID_FLEX_NUM
1038: from per_job_groups pjg
1039: where pjg.JOB_GROUP_ID = (select job_group_id
1040: from per_jobs
1041: where JOB_ID = p_job_id);
1042:
1043: --
1044: -- bug 2242339 get per_job_definition segment values where

Line 1275: -- explicitly lock the per_jobs row.

1271: --
1272: hr_utility.set_location('Entering:'|| l_proc, 30);
1273: --
1274: -- Because we may need to maintain the valid grade dates, need to
1275: -- explicitly lock the per_jobs row.
1276: --
1277: -- per_job_shd.lck(p_job_id => p_job_id
1278: -- ,p_object_version_number => l_object_version_number);
1279: --

Line 1348: -- explicitly lock the per_jobs row.

1344: --
1345: hr_utility.set_location(l_proc, 60);
1346: --
1347: -- Because we may need to maintain the valid grade dates, need to
1348: -- explicitly lock the per_jobs row.
1349: --
1350: -- per_job_shd.lck(p_job_id => p_job_id
1351: -- ,p_object_version_number => l_object_version_number);
1352: --

Line 1731: cursor c1 is select per_jobs_s.nextval

1727: -- |----------------------------< get_next_sequence >-------------------------|
1728: -- ----------------------------------------------------------------------------
1729: procedure get_next_sequence(p_job_id in out nocopy number) is
1730: --
1731: cursor c1 is select per_jobs_s.nextval
1732: from sys.dual;
1733: l_proc varchar2(72) := g_package||'get_next_sequence';
1734: --
1735: begin