APPS.PQH_PTX_UTL dependencies on PQH_PTX_DPF_DF_S

Line 140: cursor c_pqh_ptx_dpf_df_s is

136: l_pei_populated varchar2(5000);
137: l_jtr_populated varchar2(5000);
138: l_ptx_deployment_factor_id number;
139: --
140: cursor c_pqh_ptx_dpf_df_s is
141: select pqh_ptx_dpf_df_s.nextval
142: from dual;
143: --
144: CURSOR c1 IS

Line 141: select pqh_ptx_dpf_df_s.nextval

137: l_jtr_populated varchar2(5000);
138: l_ptx_deployment_factor_id number;
139: --
140: cursor c_pqh_ptx_dpf_df_s is
141: select pqh_ptx_dpf_df_s.nextval
142: from dual;
143: --
144: CURSOR c1 IS
145: SELECT *

Line 328: open c_pqh_ptx_dpf_df_s;

324: pqh_workflow.get_txn_cat('POSITION_TRANSACTION',v_posn_rec.business_group_id)
325: );
326: if (v_posn_rec.position_id is not null) and (p_position_transaction_id is not null) then
327: --
328: open c_pqh_ptx_dpf_df_s;
329: fetch c_pqh_ptx_dpf_df_s into l_ptx_deployment_factor_id;
330: close c_pqh_ptx_dpf_df_s;
331: --
332: insert into pqh_ptx_dpf_df

Line 329: fetch c_pqh_ptx_dpf_df_s into l_ptx_deployment_factor_id;

325: );
326: if (v_posn_rec.position_id is not null) and (p_position_transaction_id is not null) then
327: --
328: open c_pqh_ptx_dpf_df_s;
329: fetch c_pqh_ptx_dpf_df_s into l_ptx_deployment_factor_id;
330: close c_pqh_ptx_dpf_df_s;
331: --
332: insert into pqh_ptx_dpf_df
333: (

Line 330: close c_pqh_ptx_dpf_df_s;

326: if (v_posn_rec.position_id is not null) and (p_position_transaction_id is not null) then
327: --
328: open c_pqh_ptx_dpf_df_s;
329: fetch c_pqh_ptx_dpf_df_s into l_ptx_deployment_factor_id;
330: close c_pqh_ptx_dpf_df_s;
331: --
332: insert into pqh_ptx_dpf_df
333: (
334: ptx_deployment_factor_id, deployment_factor_id, position_transaction_id,

Line 354: insert into pqh_ptx_dpf_df_shadow

350: 1
351: );
352: --
353: --
354: insert into pqh_ptx_dpf_df_shadow
355: (
356: ptx_deployment_factor_id, deployment_factor_id, position_transaction_id,
357: attribute_category,
358: attribute1, attribute2, attribute3, attribute4, attribute5,