APPS.PQH_PTX_UTL dependencies on PQH_PTE_SHADOW

Line 696: insert into pqh_pte_shadow

692: rec1.WORK_TERM_END_MONTH_CD,
693: 1);
694: --
695: for rec3 in c3 loop
696: insert into pqh_pte_shadow
697: (ptx_extra_info_id, information_type, position_transaction_id, position_extra_info_id,
698: information_category, information1, information2, information3, information4, information5,
699: information6, information7, information8, information9, information10,
700: information11, information12, information13, information14, information15,

Line 759: (select null from pqh_pte_shadow pps where position_transaction_id = p_position_transaction_id

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
760: and pps.position_extra_info_id = pei.position_extra_info_id);
761: --
762: l_pte_context_desc varchar2(1000);
763:

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 1180: from pqh_pte_shadow

1176: */
1177: --
1178: cursor c_pes(p_ptx_extra_info_id number) is
1179: select *
1180: from pqh_pte_shadow
1181: where ptx_extra_info_id = p_ptx_extra_info_id;
1182: --
1183: cursor c_dpf_df(p_position_transaction_id number) is
1184: select *

Line 3056: from pqh_pte_shadow

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
3056: from pqh_pte_shadow
3057: where position_transaction_id = p_position_transaction_id);
3058: begin
3059: for rec3 in c3 loop
3060: insert into pqh_pte_shadow

Line 3060: insert into pqh_pte_shadow

3056: from pqh_pte_shadow
3057: where position_transaction_id = p_position_transaction_id);
3058: begin
3059: for rec3 in c3 loop
3060: insert into pqh_pte_shadow
3061: (ptx_extra_info_id, information_type, position_transaction_id, position_extra_info_id,
3062: information_category, information1, information2, information3, information4, information5,
3063: information6, information7, information8, information9, information10,
3064: information11, information12, information13, information14, information15,

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 3571: delete pqh_pte_shadow

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;
3573: end if;
3574: end loop;
3575: --