APPS.PQH_PTX_UTL dependencies on PQH_REFRESH_DATA

Line 3154: pqh_refresh_data.refresh_data

3150: open c_ptx(p_position_transaction_id);
3151: fetch c_ptx into l_position_id;
3152: close c_ptx;
3153: -- call the refresh_data pkg for txn table alias PTX
3154: pqh_refresh_data.refresh_data
3155: (p_txn_category_id => p_transaction_category_id,
3156: p_txn_id => p_position_transaction_ID,
3157: p_refresh_criteria => 'PTX',
3158: p_items_changed => l_ptx_items_changed

Line 3166: pqh_refresh_data.refresh_data

3162: fetch c_dpf_df into p_ptx_deployment_factor_id;
3163: close c_dpf_df;
3164: if p_ptx_deployment_factor_id is not null then
3165: -- call the refresh_data pkg for txn table alias PF1
3166: pqh_refresh_data.refresh_data
3167: (p_txn_category_id => p_transaction_category_id,
3168: p_txn_id => p_ptx_deployment_factor_ID,
3169: p_refresh_criteria => 'PF1',
3170: p_items_changed => l_pf1_items_changed

Line 3468: pqh_refresh_data.refresh_data

3464: l_position_id := p_position_id;
3465: --
3466: for r_tjr in c_tjr(p_position_transaction_id, l_position_id)
3467: loop
3468: pqh_refresh_data.refresh_data
3469: (p_txn_category_id => p_transaction_category_id,
3470: p_txn_id => r_tjr.txn_job_requirement_id,
3471: p_refresh_criteria => 'TJR',
3472: p_items_changed => l_tjr_items_changed

Line 3546: pqh_refresh_data.refresh_data

3542: begin
3543: --
3544: for r_pte in c_pte(p_position_transaction_id, p_position_id)
3545: loop
3546: pqh_refresh_data.refresh_data
3547: (p_txn_category_id => p_transaction_category_id,
3548: p_txn_id => r_pte.ptx_extra_info_ID,
3549: p_refresh_criteria => 'PTE',
3550: p_items_changed => l_pte_items_changed