APPS.BEN_PLAN_COPY_LOADER dependencies on PQH_COPY_ENTITY_RESULTS

Line 79: DELETE FROM PQH_COPY_ENTITY_RESULTS

75: CLOSE c_copy_entity_txn;
76: --
77: IF (l_object_version_number = p_cet_object_version_number) THEN
78: --
79: DELETE FROM PQH_COPY_ENTITY_RESULTS
80: WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
81: --
82: DELETE FROM BEN_COPY_ENTITY_RESULTS
83: WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;

Line 906: pqh_copy_entity_results cer

902: --
903: cursor c1(v_context_business_group_id number, v_transaction_category_id number) is
904: select null
905: from pqh_copy_entity_txns cet,
906: pqh_copy_entity_results cer
907: where cet.display_name = p_display_name
908: and cet.context_business_group_id = v_context_business_group_id
909: and cet.transaction_category_id = v_transaction_category_id
910: -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date

Line 935: where table_name = 'PQH_COPY_ENTITY_RESULTS'

931: --Bug : 4354708
932: cursor c_trig_cer is
933: select null
934: from all_triggers
935: where table_name = 'PQH_COPY_ENTITY_RESULTS'
936: and trigger_name = 'PQH_COPY_ENTITY_RESULTS_WHO'
937: and table_owner = l_schema
938: and status = 'ENABLED';
939: --Bug : 4354708

Line 936: and trigger_name = 'PQH_COPY_ENTITY_RESULTS_WHO'

932: cursor c_trig_cer is
933: select null
934: from all_triggers
935: where table_name = 'PQH_COPY_ENTITY_RESULTS'
936: and trigger_name = 'PQH_COPY_ENTITY_RESULTS_WHO'
937: and table_owner = l_schema
938: and status = 'ENABLED';
939: --Bug : 4354708
940:

Line 995: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_RESULTS

991: open c_trig_cer;
992: fetch c_trig_cer into l_dummy;
993: if c_trig_cer%notfound then
994: --
995: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_RESULTS
996: -- Set WHO columns
997: l_last_update_date := sysdate;
998: l_last_updated_by := fnd_global.user_id;
999: l_last_update_login := fnd_global.login_id;

Line 1033: select pqh_copy_entity_results_s.nextval into l_copy_entity_result_id

1029: fetch c4 into l_table_route_id ;
1030: close c4;
1031: --
1032: /*
1033: select pqh_copy_entity_results_s.nextval into l_copy_entity_result_id
1034: from dual ;
1035: */
1036: --
1037: insert into pqh_copy_entity_results

Line 1037: insert into pqh_copy_entity_results

1033: select pqh_copy_entity_results_s.nextval into l_copy_entity_result_id
1034: from dual ;
1035: */
1036: --
1037: insert into pqh_copy_entity_results
1038: ( copy_entity_result_id,
1039: copy_entity_txn_id,
1040: result_type_cd,
1041: number_of_copies,

Line 1248: ( pqh_copy_entity_results_s.nextval, -- l_copy_entity_result_id,

1244: created_by,
1245: creation_date --Bug : 4354708
1246: )
1247: Values
1248: ( pqh_copy_entity_results_s.nextval, -- l_copy_entity_result_id,
1249: l_copy_entity_txn_id,
1250: p_result_type_cd,
1251: to_number(p_number_of_copies),
1252: p_status,