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 PQH_PTX_EXTRA_INFO

Line 408: from pqh_ptx_extra_info

404: where position_id=p_position_id;
405:
406: cursor c3 is
407: select *
408: from pqh_ptx_extra_info
409: where position_transaction_id=p_position_transaction_id;
410:
411: rec1 c1%rowtype;
412: rec2 c2%rowtype;

Line 745: we will insert records in the pqh_ptx_extra_info table.

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: */
748:
749: -- declare variables

Line 750: l_ptx_extra_info_id pqh_ptx_extra_info.ptx_extra_info_id%TYPE;

746:
747: */
748:
749: -- declare variables
750: l_ptx_extra_info_id pqh_ptx_extra_info.ptx_extra_info_id%TYPE;
751: l_object_version_number pqh_ptx_extra_info.object_version_number%TYPE := 1;
752:
753: CURSOR c1 IS
754: select *

Line 751: l_object_version_number pqh_ptx_extra_info.object_version_number%TYPE := 1;

747: */
748:
749: -- declare variables
750: l_ptx_extra_info_id pqh_ptx_extra_info.ptx_extra_info_id%TYPE;
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

Line 769: -- select the sequence number for pqh_ptx_extra_info

765:
766: --
767:
768: FOR v_poei_rec in c1 loop
769: -- select the sequence number for pqh_ptx_extra_info
770: select pqh_ptx_extra_info_s.nextval
771: into l_ptx_extra_info_id
772: from dual;
773:

Line 770: select pqh_ptx_extra_info_s.nextval

766: --
767:
768: FOR v_poei_rec in c1 loop
769: -- select the sequence number for pqh_ptx_extra_info
770: select pqh_ptx_extra_info_s.nextval
771: into l_ptx_extra_info_id
772: from dual;
773:
774: -- insert record into pqh_ptx_extra_info

Line 774: -- insert record into pqh_ptx_extra_info

770: select pqh_ptx_extra_info_s.nextval
771: into l_ptx_extra_info_id
772: from dual;
773:
774: -- insert record into pqh_ptx_extra_info
775:
776: insert into pqh_ptx_extra_info
777: (
778: PTX_EXTRA_INFO_ID,

Line 776: insert into pqh_ptx_extra_info

772: from dual;
773:
774: -- insert record into pqh_ptx_extra_info
775:
776: insert into pqh_ptx_extra_info
777: (
778: PTX_EXTRA_INFO_ID,
779: INFORMATION_TYPE,
780: POSITION_TRANSACTION_ID,

Line 1095: l_pte_rec pqh_ptx_extra_info%ROWTYPE;

1091: l_pei_type varchar2(1);
1092: l_update_mode varchar2(20);
1093: l_dummy varchar2(10);
1094: l_ptx_rec pqh_position_transactions%ROWTYPE;
1095: l_pte_rec pqh_ptx_extra_info%ROWTYPE;
1096: l_position_id hr_all_positions_f.position_id%TYPE;
1097: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1098: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
1099: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;

Line 1141: from pqh_ptx_extra_info

1137: between effective_start_date and effective_end_date ;
1138:
1139: CURSOR c3 IS
1140: select *
1141: from pqh_ptx_extra_info
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

Line 1152: from pqh_ptx_extra_info ppei

1148: and position_transaction_id = p_transaction_id
1149: and pps.position_extra_info_id = pei.position_extra_info_id
1150: and not exists
1151: (select null
1152: from pqh_ptx_extra_info ppei
1153: where position_transaction_id = p_transaction_id
1154: and ppei.position_extra_info_id = pps.position_extra_info_id);
1155:
1156: cursor c4 (p_position_id in hr_all_positions_f.position_id%TYPE)is

Line 3051: from pqh_ptx_extra_info

3047: --------------------------------------------------------------------------------
3048: procedure create_pte_shadow(p_position_transaction_id number) is
3049: cursor c3 is
3050: select *
3051: from pqh_ptx_extra_info
3052: where position_transaction_id = p_position_transaction_id
3053: and position_extra_info_id is not null
3054: and ptx_extra_info_id not in
3055: (select ptx_extra_info_id

Line 3520: from pqh_ptx_extra_info

3516: l_pei_changed varchar2(10000);
3517: --
3518: cursor c_pte(p_position_transaction_id number, p_position_id number) is
3519: select ptx_extra_info_id
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

Line 3530: from pqh_ptx_extra_info tei, pqh_pte_shadow pps

3526: and information_type <> 'PQH_POS_ROLE_ID');
3527: --
3528: cursor c_pes_poe(p_position_transaction_id number, p_position_id number) is
3529: select tei.ptx_extra_info_id, tei.object_version_number
3530: from pqh_ptx_extra_info tei, pqh_pte_shadow pps
3531: where
3532: tei.information_type <> 'PQH_POS_ROLE_ID'
3533: and tei.ptx_extra_info_id = pps.ptx_extra_info_id
3534: and tei.position_transaction_id = pps.position_transaction_id

Line 3568: delete pqh_ptx_extra_info

3564: l_pte_context_desc := pqh_utility.get_pte_context_desc(r_pes_poe.ptx_extra_info_ID);
3565: hr_utility.set_location('l_pte_context_desc:'||nvl(l_pte_context_desc,'NULL'), 1000);
3566: append_if_not_present(l_pei_changed, l_pte_context_desc);
3567: --
3568: delete pqh_ptx_extra_info
3569: where ptx_extra_info_id = r_pes_poe.ptx_extra_info_id;
3570: --
3571: delete pqh_pte_shadow
3572: where ptx_extra_info_id = r_pes_poe.ptx_extra_info_id;