APPS.PQH_PTX_UTL dependencies on PQH_TXN_JOB_REQUIREMENTS

Line 920: we will insert records in the pqh_txn_job_requirements table.

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: */
923:
924: -- declare variables

Line 925: l_txn_job_requirement_id pqh_txn_job_requirements.txn_job_requirement_id%TYPE;

921:
922: */
923:
924: -- declare variables
925: l_txn_job_requirement_id pqh_txn_job_requirements.txn_job_requirement_id%TYPE;
926: l_object_version_number pqh_txn_job_requirements.object_version_number%TYPE := 1;
927:
928: CURSOR c1 IS
929: select *

Line 926: l_object_version_number pqh_txn_job_requirements.object_version_number%TYPE := 1;

922: */
923:
924: -- declare variables
925: l_txn_job_requirement_id pqh_txn_job_requirements.txn_job_requirement_id%TYPE;
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

Line 945: -- select the sequence number for pqh_txn_job_requirements

941:
942: --
943:
944: FOR r_jre in c1 loop
945: -- select the sequence number for pqh_txn_job_requirements
946: select pqh_txn_job_requirements_s.nextval
947: into l_txn_job_requirement_id
948: from dual;
949:

Line 946: select pqh_txn_job_requirements_s.nextval

942: --
943:
944: FOR r_jre in c1 loop
945: -- select the sequence number for pqh_txn_job_requirements
946: select pqh_txn_job_requirements_s.nextval
947: into l_txn_job_requirement_id
948: from dual;
949:
950: -- insert record into pqh_txn_job_requirements

Line 950: -- insert record into pqh_txn_job_requirements

946: select pqh_txn_job_requirements_s.nextval
947: into l_txn_job_requirement_id
948: from dual;
949:
950: -- insert record into pqh_txn_job_requirements
951:
952: insert into pqh_txn_job_requirements
953: (
954: txn_job_requirement_id,

Line 952: insert into pqh_txn_job_requirements

948: from dual;
949:
950: -- insert record into pqh_txn_job_requirements
951:
952: insert into pqh_txn_job_requirements
953: (
954: txn_job_requirement_id,
955: position_transaction_id,
956: job_requirement_id,

Line 3094: from pqh_txn_job_requirements

3090: --------------------------------------------------------------------------------
3091: procedure create_tjr_shadow(p_position_transaction_id number) is
3092: cursor c3 is
3093: select *
3094: from pqh_txn_job_requirements
3095: where position_transaction_id = p_position_transaction_id
3096: and job_requirement_id is not null
3097: and txn_job_requirement_id not in
3098: (select txn_job_requirement_id

Line 3219: l_tjr_rec pqh_txn_job_requirements%ROWTYPE;

3215: end;
3216: --
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;

Line 3235: from pqh_txn_job_requirements ptjr

3231: and jreq.job_requirement_id = pts.job_requirement_id
3232: and pts.position_transaction_id = p_transaction_id
3233: and not exists (
3234: select null
3235: from pqh_txn_job_requirements ptjr
3236: where position_transaction_id = p_transaction_id
3237: and ptjr.job_requirement_id = pts.job_requirement_id);
3238:
3239: CURSOR c3 IS

Line 3241: from pqh_txn_job_requirements

3237: and ptjr.job_requirement_id = pts.job_requirement_id);
3238:
3239: CURSOR c3 IS
3240: select *
3241: from pqh_txn_job_requirements
3242: where position_transaction_id = p_position_transaction_id;
3243: cursor c_pes(p_txn_job_requirement_id number) is
3244: select *
3245: from pqh_tjr_shadow

Line 3439: from pqh_txn_job_requirements

3435: l_tjr_items_changed varchar2(8000);
3436: --
3437: cursor c_tjr(p_position_transaction_id number, p_position_id number) is
3438: select txn_job_requirement_id
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

Line 3449: from pqh_txn_job_requirements tjr, pqh_tjr_shadow pts

3445: );
3446: --
3447: cursor c_prs_tjr(p_position_transaction_id number, p_position_id number) is
3448: select tjr.txn_job_requirement_id, tjr.object_version_number
3449: from pqh_txn_job_requirements tjr, pqh_tjr_shadow pts
3450: where tjr.txn_job_requirement_id = pts.txn_job_requirement_id
3451: and tjr.position_transaction_id = pts.position_transaction_id
3452: and tjr.position_transaction_id = p_position_transaction_id
3453: and not exists

Line 3490: delete pqh_txn_job_requirements

3486: l_tjr_classification := pqh_utility.get_tjr_classification(r_prs_tjr.txn_job_requirement_id);
3487: hr_utility.set_location('l_tjr_classification:'||nvl(l_tjr_classification,'NULL'), 1000);
3488: append_if_not_present(l_tjr_changed, l_tjr_classification);
3489: --
3490: delete pqh_txn_job_requirements
3491: where txn_job_requirement_id = r_prs_tjr.txn_job_requirement_id;
3492: --
3493: delete pqh_tjr_shadow
3494: where txn_job_requirement_id = r_prs_tjr.txn_job_requirement_id;