APPS.PQH_PTX_UTL dependencies on PQH_UTILITY

Line 82: l_warn_tab pqh_utility.warnings_tab;

78: -- ----------------------------------------------------------------------------
79: -- |--------------------------< log_warnings >------------------------------|
80: -- ----------------------------------------------------------------------------
81: procedure log_warnings(p_transaction_id number) is
82: l_warn_tab pqh_utility.warnings_tab;
83: l_warn_no number;
84: begin
85: --
86: pqh_utility.get_all_warnings(l_warn_tab, l_warn_no);

Line 86: pqh_utility.get_all_warnings(l_warn_tab, l_warn_no);

82: l_warn_tab pqh_utility.warnings_tab;
83: l_warn_no number;
84: begin
85: --
86: pqh_utility.get_all_warnings(l_warn_tab, l_warn_no);
87: --
88: if l_warn_no > 0 then
89: --
90: for l_rec_no in l_warn_tab.first .. l_warn_tab.last

Line 897: l_pte_context_desc := pqh_utility.get_pte_context_desc(l_ptx_extra_info_id);

893: v_poei_rec.POEI_ATTRIBUTE20,
894: l_object_version_number
895: );
896:
897: l_pte_context_desc := pqh_utility.get_pte_context_desc(l_ptx_extra_info_id);
898: append_if_not_present(p_populated, l_pte_context_desc);
899: END LOOP;
900:
901: end populate_pei;

Line 1023: l_tjr_classification := pqh_utility.get_tjr_classification(l_txn_job_requirement_id);

1019: r_jre.attribute20,
1020: r_jre.comments
1021: );
1022:
1023: l_tjr_classification := pqh_utility.get_tjr_classification(l_txn_job_requirement_id);
1024: append_if_not_present(p_populated, l_tjr_classification);
1025: END LOOP;
1026:
1027: end populate_job_requirements;

Line 3189: l_pf1_changed := pqh_utility.get_attribute_name('DF1','DEPLOYMENT_DF');

3185: p_tjr_changed => l_tjr_changed
3186: );
3187: --
3188: if l_pf1_items_changed is not null then
3189: l_pf1_changed := pqh_utility.get_attribute_name('DF1','DEPLOYMENT_DF');
3190: end if;
3191: --
3192: if l_pf1_changed is not null then
3193: if l_ptx_items_changed is null then

Line 3476: l_tjr_classification := pqh_utility.get_tjr_classification(r_tjr.txn_job_requirement_id);

3472: p_items_changed => l_tjr_items_changed
3473: );
3474: hr_utility.set_location('l_tjr_items_changed:'||nvl(l_tjr_items_changed,'NULL'), 1000);
3475: if l_tjr_items_changed is not null then
3476: l_tjr_classification := pqh_utility.get_tjr_classification(r_tjr.txn_job_requirement_id);
3477: hr_utility.set_location('l_tjr_classification:'||nvl(l_tjr_classification,'NULL'), 1000);
3478: append_if_not_present(l_tjr_changed, l_tjr_classification);
3479: end if;
3480: end loop;

Line 3486: l_tjr_classification := pqh_utility.get_tjr_classification(r_prs_tjr.txn_job_requirement_id);

3482: for r_prs_tjr in c_prs_tjr(p_position_transaction_id, l_position_id)
3483: loop
3484: --
3485: if r_prs_tjr.object_version_number = 1 then
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

Line 3554: l_pte_context_desc := pqh_utility.get_pte_context_desc(r_pte.ptx_extra_info_ID);

3550: p_items_changed => l_pte_items_changed
3551: );
3552: hr_utility.set_location('l_pte_items_changed:'||nvl(l_pte_items_changed,'NULL'), 1000);
3553: if l_pte_items_changed is not null then
3554: l_pte_context_desc := pqh_utility.get_pte_context_desc(r_pte.ptx_extra_info_ID);
3555: hr_utility.set_location('l_pte_context_desc:'||nvl(l_pte_context_desc,'NULL'), 1000);
3556: append_if_not_present(l_pei_changed, l_pte_context_desc);
3557: end if;
3558: end loop;

Line 3564: l_pte_context_desc := pqh_utility.get_pte_context_desc(r_pes_poe.ptx_extra_info_ID);

3560: for r_pes_poe in c_pes_poe(p_position_transaction_id, p_position_id)
3561: loop
3562: --
3563: if r_pes_poe.object_version_number = 1 then
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