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_POSITION_EXTRA_INFO

Line 743: we will fetch corresponding records from per_position_extra_info table.

739: /*
740:
741: This procedure will be called from the Position Transaction Form.
742: In the case of update template, the user selects an existing position.
743: we will fetch corresponding records from per_position_extra_info table.
744: With the position_transaction_id id and the position_id of current position,
745: we will insert records in the pqh_ptx_extra_info table.
746:
747: */

Line 755: from per_position_extra_info pei

751: l_object_version_number pqh_ptx_extra_info.object_version_number%TYPE := 1;
752:
753: CURSOR c1 IS
754: select *
755: from per_position_extra_info pei
756: where information_type <> 'PQH_POS_ROLE_ID'
757: and position_id = p_position_id
758: and not exists
759: (select null from pqh_pte_shadow pps where position_transaction_id = p_position_transaction_id

Line 1080: per_position_extra_info

1076: underlying master tables.
1077: It will poppulate the following tables
1078: hr_all_positions_f
1079: per_positions
1080: per_position_extra_info
1081: per_deployment_factors
1082:
1083: */
1084:

Line 1106: l_position_extra_info_id per_position_extra_info.position_extra_info_id%TYPE;

1102: l_dpf_deployment_factor_id per_deployment_factors.deployment_factor_id%type;
1103: l_dpf_object_version_number per_deployment_factors.object_version_number%type;
1104: l_warning boolean;
1105: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
1106: l_position_extra_info_id per_position_extra_info.position_extra_info_id%TYPE;
1107: p_position_id hr_all_positions_f.position_id%TYPE;
1108: p_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1109: l_pei_position_extra_info_id per_position_extra_info.position_extra_info_id%type;
1110: l_pei_object_version_number per_position_extra_info.object_version_number%type;

Line 1109: l_pei_position_extra_info_id per_position_extra_info.position_extra_info_id%type;

1105: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
1106: l_position_extra_info_id per_position_extra_info.position_extra_info_id%TYPE;
1107: p_position_id hr_all_positions_f.position_id%TYPE;
1108: p_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1109: l_pei_position_extra_info_id per_position_extra_info.position_extra_info_id%type;
1110: l_pei_object_version_number per_position_extra_info.object_version_number%type;
1111: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
1112: l_return varchar2(30) := 'SUCCESS';
1113: l_seasonal_dates_present boolean := false;

Line 1110: l_pei_object_version_number per_position_extra_info.object_version_number%type;

1106: l_position_extra_info_id per_position_extra_info.position_extra_info_id%TYPE;
1107: p_position_id hr_all_positions_f.position_id%TYPE;
1108: p_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1109: l_pei_position_extra_info_id per_position_extra_info.position_extra_info_id%type;
1110: l_pei_object_version_number per_position_extra_info.object_version_number%type;
1111: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
1112: l_return varchar2(30) := 'SUCCESS';
1113: l_seasonal_dates_present boolean := false;
1114: l_overlap_dates_present boolean := false;

Line 1146: from per_position_extra_info pei, pqh_pte_shadow pps

1142: where position_transaction_id = p_transaction_id;
1143:
1144: CURSOR c_del_pte(p_transaction_id number, p_position_id number) IS
1145: select pei.position_extra_info_id, pei.object_version_number
1146: from per_position_extra_info pei, pqh_pte_shadow pps
1147: where position_id = p_position_id
1148: and position_transaction_id = p_transaction_id
1149: and pps.position_extra_info_id = pei.position_extra_info_id
1150: and not exists

Line 1162: p_information_type in per_position_extra_info.information_type%type,

1158: from per_deployment_factors
1159: where position_id = p_position_id;
1160:
1161: CURSOR c5 (p_position_id in hr_all_positions_f.position_id%TYPE,
1162: p_information_type in per_position_extra_info.information_type%type,
1163: p_position_extra_info_id in
1164: per_position_extra_info.position_extra_info_id%type) IS
1165: select position_extra_info_id,object_version_number
1166: from per_position_extra_info

Line 1164: per_position_extra_info.position_extra_info_id%type) IS

1160:
1161: CURSOR c5 (p_position_id in hr_all_positions_f.position_id%TYPE,
1162: p_information_type in per_position_extra_info.information_type%type,
1163: p_position_extra_info_id in
1164: per_position_extra_info.position_extra_info_id%type) IS
1165: select position_extra_info_id,object_version_number
1166: from per_position_extra_info
1167: where position_id = p_position_id
1168: and information_type = p_information_type

Line 1166: from per_position_extra_info

1162: p_information_type in per_position_extra_info.information_type%type,
1163: p_position_extra_info_id in
1164: per_position_extra_info.position_extra_info_id%type) IS
1165: select position_extra_info_id,object_version_number
1166: from per_position_extra_info
1167: where position_id = p_position_id
1168: and information_type = p_information_type
1169: and position_extra_info_id = p_position_extra_info_id;
1170:

Line 1272: -- TABLE : per_position_extra_info

1268:
1269: IF l_txn_type = 'U' THEN
1270:
1271: --
1272: -- TABLE : per_position_extra_info
1273: --
1274: -- For update transaction delete the position extra info if deleted from ptx extra info
1275: if l_position_id is not null then
1276: for r_del_pte in c_del_pte(p_transaction_id , l_position_id) loop

Line 1934: -- create/update the per_position_extra_info

1930: END IF; -- api call per_deployment_factors
1931:
1932:
1933: --
1934: -- create/update the per_position_extra_info
1935: --
1936: OPEN c3;
1937: LOOP
1938: FETCH c3 INTO l_pte_rec;

Line 1968: insert into per_position_extra_info

1964: IF l_pei_type = 'I' THEN
1965: --
1966: hr_utility.set_location('Insert for pei_id '|| l_pei_position_extra_info_id
1967: ||l_proc, 20);
1968: insert into per_position_extra_info
1969: (
1970: position_extra_info_id, position_id, information_type,
1971: poei_attribute_category,
1972: poei_attribute1, poei_attribute2, poei_attribute3, poei_attribute4, poei_attribute5,

Line 2146: END IF; -- api call per_position_extra_info

2142: ,p_poei_information29 => l_pte_rec.information29
2143: ,p_poei_information30 => l_pte_rec.information30
2144: );
2145: --
2146: END IF; -- api call per_position_extra_info
2147: --
2148: -- if l_ptx_rec.seasonal_flag = 'Y' then
2149: --
2150: if l_pte_rec.information_type = 'PER_SEASONAL' then

Line 3248: -- p_information_type in per_position_extra_info.information_type%type,

3244: select *
3245: from pqh_tjr_shadow
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

Line 3524: from per_position_extra_info

3520: from pqh_ptx_extra_info
3521: where position_transaction_id = p_position_transaction_id
3522: and position_extra_info_id in
3523: (select position_extra_info_id
3524: from per_position_extra_info
3525: where position_id = p_position_id
3526: and information_type <> 'PQH_POS_ROLE_ID');
3527: --
3528: cursor c_pes_poe(p_position_transaction_id number, p_position_id number) is

Line 3538: from per_position_extra_info ppei

3534: and tei.position_transaction_id = pps.position_transaction_id
3535: and tei.position_transaction_id = p_position_transaction_id
3536: and not exists (
3537: select null
3538: from per_position_extra_info ppei
3539: where position_id = p_position_id
3540: and ppei.position_extra_info_id = pps.position_extra_info_id);
3541: --
3542: begin

Line 3607: from per_position_extra_info

3603: l_rsv_fte number;
3604:
3605: cursor csr_valid_fte(p_position_id number, p_effective_date date) is
3606: select sum(poei_information6) fte
3607: from per_position_extra_info
3608: where position_id = p_position_id
3609: and information_type= 'PER_RESERVED'
3610: and p_effective_date
3611: between fnd_date.canonical_to_date(poei_information3)

Line 3620: from per_position_extra_info

3616: from dual
3617: union
3618: select start_date
3619: from (select fnd_date.canonical_to_date(poei_information3) start_date
3620: from per_position_extra_info
3621: where position_id = p_position_id
3622: and information_type = 'PER_RESERVED') a
3623: where a.start_date between p_validation_start_date and p_validation_end_date;
3624: Begin