APPS.PQH_PTX_UTL dependencies on PQH_PTX_DPF_DF

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 332: insert into pqh_ptx_dpf_df

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,
335: attribute_category,
336: attribute1, attribute2, attribute3, attribute4, attribute5,

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,

Line 1185: from pqh_ptx_dpf_df

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 *
1185: from pqh_ptx_dpf_df
1186: where position_transaction_id = p_position_transaction_id;
1187: --
1188: l_pes_rec c_pes%rowtype;
1189: l_items_changed varchar2(10000);

Line 3142: from pqh_ptx_dpf_df

3138: where position_transaction_id = p_position_transaction_id;
3139: --
3140: cursor c_dpf_df(p_position_transaction_id number) is
3141: select ptx_deployment_factor_id
3142: from pqh_ptx_dpf_df
3143: where position_transaction_id = p_position_transaction_id;
3144: --
3145: l_pf1_changed varchar2(10000);
3146: l_pei_changed varchar2(10000);