APPS.BEN_PLAN_DESIGN_DELETE_API dependencies on PQH_COPY_ENTITY_TXNS

Line 2377: from pqh_copy_entity_txns cet

2373: ) is
2374:
2375: cursor c_copy_entity_txn is
2376: select cet.src_effective_date effective_date
2377: from pqh_copy_entity_txns cet
2378: where cet.copy_entity_txn_id = p_copy_entity_txn_id;
2379:
2380:
2381: cursor c_deleted_rows(p_effective_date date) is

Line 2389: l_effective_date pqh_copy_entity_txns.src_effective_date%type;

2385: and p_effective_date between nvl(information2,p_effective_date) and nvl(information3,p_effective_date)
2386: group by order_in_hierarchy,table_alias,order_in_group,information1,datetrack_mode,information2,information3,information5, information265
2387: order by order_in_hierarchy desc, order_in_group desc ;
2388:
2389: l_effective_date pqh_copy_entity_txns.src_effective_date%type;
2390: l_date_to_use pqh_copy_entity_txns.src_effective_date%type;
2391: l_proc varchar2(72) := g_package||'call_delete_apis';
2392: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type;
2393:

Line 2390: l_date_to_use pqh_copy_entity_txns.src_effective_date%type;

2386: group by order_in_hierarchy,table_alias,order_in_group,information1,datetrack_mode,information2,information3,information5, information265
2387: order by order_in_hierarchy desc, order_in_group desc ;
2388:
2389: l_effective_date pqh_copy_entity_txns.src_effective_date%type;
2390: l_date_to_use pqh_copy_entity_txns.src_effective_date%type;
2391: l_proc varchar2(72) := g_package||'call_delete_apis';
2392: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type;
2393:
2394: begin

Line 2438: from pqh_copy_entity_txns cet

2434: ,p_delete_failed out nocopy varchar2
2435: ) is
2436: cursor c_copy_entity_txn is
2437: select cet.src_effective_date effective_date
2438: from pqh_copy_entity_txns cet
2439: where cet.copy_entity_txn_id = p_copy_entity_txn_id;
2440:
2441: -- we need to call delete api for all the dependents and the parent row itself.
2442: cursor c_deleted_rows(p_effective_date date) is

Line 2457: l_effective_date pqh_copy_entity_txns.src_effective_date%type;

2453: cursor c_parent_entity_name is
2454: select information5 parent_entity_name from ben_copy_entity_results
2455: where copy_entity_result_id = p_parent_entity_result_id;
2456:
2457: l_effective_date pqh_copy_entity_txns.src_effective_date%type;
2458: l_date_to_use pqh_copy_entity_txns.src_effective_date%type;
2459: l_proc varchar2(72) := g_package||'call_delete_apis_for_hierarchy';
2460: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type;
2461: l_parent_entity_name ben_copy_entity_results.information5%type;

Line 2458: l_date_to_use pqh_copy_entity_txns.src_effective_date%type;

2454: select information5 parent_entity_name from ben_copy_entity_results
2455: where copy_entity_result_id = p_parent_entity_result_id;
2456:
2457: l_effective_date pqh_copy_entity_txns.src_effective_date%type;
2458: l_date_to_use pqh_copy_entity_txns.src_effective_date%type;
2459: l_proc varchar2(72) := g_package||'call_delete_apis_for_hierarchy';
2460: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type;
2461: l_parent_entity_name ben_copy_entity_results.information5%type;
2462: begin