eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_COPY_LOADER dependencies on BEN_COPY_ENTITY_RESULTS

Line 40: from ben_copy_entity_results cer

36: where copy_entity_txn_id = p_copy_entity_txn_id;
37: --
38: cursor c_cer is
39: select cer.*
40: from ben_copy_entity_results cer
41: where COPY_ENTITY_TXN_ID = p_COPY_ENTITY_TXN_ID;
42: --
43: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
44: l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;

Line 82: DELETE FROM BEN_COPY_ENTITY_RESULTS

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;
84: --
85: DELETE FROM PQH_COPY_ENTITY_ATTRIBS
86: WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;

Line 1883: where table_name = 'BEN_COPY_ENTITY_RESULTS'

1879: --Bug : 4354708
1880: cursor c_trig_cpe is
1881: select null
1882: from all_triggers
1883: where table_name = 'BEN_COPY_ENTITY_RESULTS'
1884: and trigger_name = 'BEN_COPY_ENTITY_RESULTS_WHO'
1885: and table_owner = l_schema
1886: and status = 'ENABLED';
1887: --Bug : 4354708

Line 1884: and trigger_name = 'BEN_COPY_ENTITY_RESULTS_WHO'

1880: cursor c_trig_cpe is
1881: select null
1882: from all_triggers
1883: where table_name = 'BEN_COPY_ENTITY_RESULTS'
1884: and trigger_name = 'BEN_COPY_ENTITY_RESULTS_WHO'
1885: and table_owner = l_schema
1886: and status = 'ENABLED';
1887: --Bug : 4354708
1888: --

Line 2048: -- WHO Trigger is not defined on the table BEN_COPY_ENTITY_RESULTS

2044: open c_trig_cpe;
2045: fetch c_trig_cpe into l_dummy;
2046: if c_trig_cpe%notfound then
2047: --
2048: -- WHO Trigger is not defined on the table BEN_COPY_ENTITY_RESULTS
2049: -- Set WHO columns
2050: l_last_update_date := sysdate;
2051: l_last_updated_by := fnd_global.user_id;
2052: l_last_update_login := fnd_global.login_id;

Line 2086: insert into ben_copy_entity_results

2082: fetch c4 into l_table_route_id ;
2083: close c4;
2084: --
2085:
2086: insert into ben_copy_entity_results
2087: ( copy_entity_result_id
2088: ,copy_entity_txn_id
2089: ,src_copy_entity_result_id
2090: ,result_type_cd

Line 2464: ( ben_copy_entity_results_s.nextval

2460: ,created_by
2461: ,creation_date --Bug : 4354708
2462: )
2463: Values
2464: ( ben_copy_entity_results_s.nextval
2465: ,l_copy_entity_txn_id
2466: ,NULL -- g_src_copy_entity_result_id -- Start global variables
2467: ,g_result_type_cd
2468: ,to_number(g_number_of_copies)