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.PQH_PTX_UTL dependencies on PER_JOB_REQUIREMENTS

Line 918: we will fetch corresponding records from per_job_requirements table.

914: /*
915:
916: This procedure will be called from the Position Transaction Form.
917: In the case of update template, the user selects an existing position.
918: we will fetch corresponding records from per_job_requirements table.
919: With the position_transaction_id and the position_id of current position,
920: we will insert records in the pqh_txn_job_requirements table.
921:
922: */

Line 930: from per_job_requirements pjr

926: l_object_version_number pqh_txn_job_requirements.object_version_number%TYPE := 1;
927:
928: CURSOR c1 IS
929: select *
930: from per_job_requirements pjr
931: where pjr.position_id = p_position_id
932: and not exists
933: (select null from pqh_tjr_shadow pts
934: where pts.position_transaction_id = p_position_transaction_id

Line 3221: l_sit_job_requirement_id per_job_requirements.job_requirement_id%type;

3217: procedure apply_sit(p_position_transaction_id number, p_position_id number, p_txn_type varchar2) is
3218: l_proc varchar2(72) := g_package||'apply_sit';
3219: l_tjr_rec pqh_txn_job_requirements%ROWTYPE;
3220: l_sit_type varchar2(1);
3221: l_sit_job_requirement_id per_job_requirements.job_requirement_id%type;
3222: l_sit_object_version_number per_job_requirements.object_version_number%type;
3223: l_position_id number;
3224: l_position_extra_info_id number;
3225: l_object_version_number number;

Line 3222: l_sit_object_version_number per_job_requirements.object_version_number%type;

3218: l_proc varchar2(72) := g_package||'apply_sit';
3219: l_tjr_rec pqh_txn_job_requirements%ROWTYPE;
3220: l_sit_type varchar2(1);
3221: l_sit_job_requirement_id per_job_requirements.job_requirement_id%type;
3222: l_sit_object_version_number per_job_requirements.object_version_number%type;
3223: l_position_id number;
3224: l_position_extra_info_id number;
3225: l_object_version_number number;
3226:

Line 3229: from per_job_requirements jreq,pqh_tjr_shadow pts

3225: l_object_version_number number;
3226:
3227: CURSOR c_del_tjr(p_transaction_id number, p_position_id number) IS
3228: select jreq.job_requirement_id, jreq.object_version_number
3229: from per_job_requirements jreq,pqh_tjr_shadow pts
3230: where position_id = p_position_id
3231: and jreq.job_requirement_id = pts.job_requirement_id
3232: and pts.position_transaction_id = p_transaction_id
3233: and not exists (

Line 3250: per_job_requirements.job_requirement_id%type) IS

3246: where txn_job_requirement_id = p_txn_job_requirement_id;
3247: CURSOR c5 (p_position_id in hr_all_positions_f.position_id%TYPE,
3248: -- p_information_type in per_position_extra_info.information_type%type,
3249: p_job_requirement_id in
3250: per_job_requirements.job_requirement_id%type) IS
3251: select job_requirement_id,object_version_number
3252: from per_job_requirements
3253: where position_id = p_position_id
3254: -- and information_type = p_information_type

Line 3252: from per_job_requirements

3248: -- p_information_type in per_position_extra_info.information_type%type,
3249: p_job_requirement_id in
3250: per_job_requirements.job_requirement_id%type) IS
3251: select job_requirement_id,object_version_number
3252: from per_job_requirements
3253: where position_id = p_position_id
3254: -- and information_type = p_information_type
3255: and job_requirement_id = p_job_requirement_id;
3256: --

Line 3261: -- TABLE : per_job_requirements

3257: l_pes_rec c_pes%rowtype;
3258: begin
3259:
3260: --
3261: -- TABLE : per_job_requirements
3262: --
3263: -- For update transaction delete the per_job_requirements if deleted from per_job_requirements
3264: if p_position_id is not null and p_txn_type = 'U' then
3265: for r_del_tjr in c_del_tjr(p_position_transaction_id , p_position_id) loop

Line 3263: -- For update transaction delete the per_job_requirements if deleted from per_job_requirements

3259:
3260: --
3261: -- TABLE : per_job_requirements
3262: --
3263: -- For update transaction delete the per_job_requirements if deleted from per_job_requirements
3264: if p_position_id is not null and p_txn_type = 'U' then
3265: for r_del_tjr in c_del_tjr(p_position_transaction_id , p_position_id) loop
3266: delete per_job_requirements
3267: where job_requirement_id = r_del_tjr.job_requirement_id;

Line 3266: delete per_job_requirements

3262: --
3263: -- For update transaction delete the per_job_requirements if deleted from per_job_requirements
3264: if p_position_id is not null and p_txn_type = 'U' then
3265: for r_del_tjr in c_del_tjr(p_position_transaction_id , p_position_id) loop
3266: delete per_job_requirements
3267: where job_requirement_id = r_del_tjr.job_requirement_id;
3268: end loop;
3269: end if;
3270:

Line 3272: -- create/update the per_job_requirements

3268: end loop;
3269: end if;
3270:
3271: --
3272: -- create/update the per_job_requirements
3273: --
3274: OPEN c3;
3275: LOOP
3276: FETCH c3 INTO l_tjr_rec;

Line 3306: insert into per_job_requirements

3302: IF l_sit_type = 'I' THEN
3303: --
3304: hr_utility.set_location('Insert for sit_id '|| l_sit_job_requirement_id
3305: ||l_proc, 20);
3306: insert into per_job_requirements
3307: (
3308: job_requirement_id, business_group_id, analysis_criteria_id,
3309: comments, date_from, date_to, essential, job_id,
3310: position_id,

Line 3340: hr_utility.set_location('Calling create PER_JOB_REQUIREMENTS '

3336: --
3337: hr_utility.set_location('After Insert for sit_id '|| l_sit_job_requirement_id
3338: ||l_proc, 25);
3339: ELSIF l_sit_type = 'C' THEN
3340: hr_utility.set_location('Calling create PER_JOB_REQUIREMENTS '
3341: ||l_proc, 30);
3342: --
3343: -- call create API
3344: --

Line 3348: select per_job_requirements_s.nextval into l_job_requirement_id

3344: --
3345: declare
3346: l_job_requirement_id number;
3347: begin
3348: select per_job_requirements_s.nextval into l_job_requirement_id
3349: from dual;
3350: --
3351: insert into per_job_requirements
3352: (

Line 3351: insert into per_job_requirements

3347: begin
3348: select per_job_requirements_s.nextval into l_job_requirement_id
3349: from dual;
3350: --
3351: insert into per_job_requirements
3352: (
3353: job_requirement_id, business_group_id, analysis_criteria_id,
3354: comments, date_from, date_to, essential, job_id,
3355: position_id,

Line 3383: hr_utility.set_location('Calling update PER_JOB_REQUIREMENTS '

3379: 1
3380: );
3381: end;
3382: ELSIF l_sit_type = 'U' then
3383: hr_utility.set_location('Calling update PER_JOB_REQUIREMENTS '
3384: ||l_proc, 35);
3385: --
3386: -- call update API
3387: --

Line 3391: update per_job_requirements

3387: --
3388: declare
3389: l_job_requirement_id number;
3390: begin
3391: update per_job_requirements
3392: set
3393: business_group_id = l_tjr_rec.business_group_id,
3394: analysis_criteria_id = l_tjr_rec.analysis_criteria_id,
3395: comments = l_tjr_rec.comments,

Line 3425: END IF; -- api call per_job_requirements

3421: attribute20 = l_tjr_rec.attribute20,
3422: object_version_number = object_version_number+1
3423: where job_requirement_id = l_tjr_rec.job_requirement_id;
3424: end; --
3425: END IF; -- api call per_job_requirements
3426: --
3427: END LOOP; -- for c3
3428: CLOSE c3;
3429: --

Line 3443: from per_job_requirements

3439: from pqh_txn_job_requirements
3440: where position_transaction_id = p_position_transaction_id
3441: and job_requirement_id in
3442: (select job_requirement_id
3443: from per_job_requirements
3444: where position_id = p_position_id
3445: );
3446: --
3447: cursor c_prs_tjr(p_position_transaction_id number, p_position_id number) is

Line 3455: from per_job_requirements pjr

3451: and tjr.position_transaction_id = pts.position_transaction_id
3452: and tjr.position_transaction_id = p_position_transaction_id
3453: and not exists
3454: (select null
3455: from per_job_requirements pjr
3456: where position_id = p_position_id
3457: and pjr.job_requirement_id = pts.job_requirement_id);
3458: --
3459: l_tjr_classification varchar2(100);