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_DESIGN_TXNS_API dependencies on BEN_COPY_ENTITY_RESULTS

Line 19: update ben_copy_entity_results

15: begin
16: l_counter := nvl(ben_pd_copy_to_ben_one.g_pk_tbl.LAST, 0);
17: if l_counter > 0 then
18: for i in 1..l_counter loop
19: update ben_copy_entity_results
20: set information9 = ben_pd_copy_to_ben_one.g_pk_tbl(i).copy_reuse_type||'-'||ben_pd_copy_to_ben_one.g_pk_tbl(i).new_value
21: where copy_entity_txn_id = p_copy_entity_txn_id
22: and table_route_id = ben_pd_copy_to_ben_one.g_pk_tbl(i).table_route_id
23: and nvl(information1,-999) = nvl(ben_pd_copy_to_ben_one.g_pk_tbl(i).old_value,-999) ;

Line 33: update ben_copy_entity_results

29: */
30:
31: /*
32: forall i in ben_pd_copy_to_ben_one.g_pk_tbl.FIRST..ben_pd_copy_to_ben_one.g_pk_tbl.LAST
33: update ben_copy_entity_results
34: set information9 = ben_pd_copy_to_ben_one.g_pk_tbl(i).copy_reuse_type||'-'||ben_pd_copy_to_ben_one.g_pk_tbl(i).new_value
35: where copy_entity_txn_id = p_copy_entity_txn_id
36: and table_route_id = ben_pd_copy_to_ben_one.g_pk_tbl(i).table_route_id
37: and information1 = ben_pd_copy_to_ben_one.g_pk_tbl(i).old_value ;

Line 372: from ben_copy_entity_results

368: and copy_entity_txn_id = p_copy_entity_txn_id ;
369: --
370: cursor c_unmapped_rows is
371: select unique table_route_id
372: from ben_copy_entity_results
373: where copy_entity_txn_id = p_copy_entity_txn_id
374: -- Only take unmapped rows.
375: and (information176 is null or
376: (information180 is not null and information176 is null));

Line 477: update ben_copy_entity_results

473: fetch c_pln_tr into l_table_route_id ;
474: close c_pln_tr ;
475: --
476: /* No need to update all the rows
477: update ben_copy_entity_results
478: set information175 = null,
479: information176 = null,
480: information179 = null,
481: information180 = null

Line 485: update ben_copy_entity_results

481: information180 = null
482: where copy_entity_txn_id = p_copy_entity_txn_id
483: and table_route_id <> l_table_route_id ; */
484: --
485: update ben_copy_entity_results
486: set information175 = null,
487: information176 = null,
488: information179 = null,
489: information180 = null

Line 638: from ben_copy_entity_results cer

634: where copy_entity_txn_id = p_copy_entity_txn_id;
635: --
636: cursor c_cer is
637: select cer.*
638: from ben_copy_entity_results cer
639: where COPY_ENTITY_TXN_ID = p_COPY_ENTITY_TXN_ID;
640: --
641: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
642: l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;

Line 856: update ben_copy_entity_results

852: ,p_no_dup_rslt => p_no_dup_rslt
853: );
854: --
855: if p_pl_id is not null and p_plan_in_program = 'Y' then
856: update ben_copy_entity_results
857: set information8 = NULL
858: where information1 = p_pl_id
859: and copy_entity_txn_id = p_copy_entity_txn_id
860: and table_alias = 'PLN';

Line 877: select /+ INDEX ( cer, ben_copy_entity_results_fk1) /

873: ,p_copy_entity_txn_id in number
874: ,p_number_of_copies in number ) is
875:
876: cursor c_child_object is
877: select /*+ INDEX ( cer, ben_copy_entity_results_fk1) */
878: cer.copy_entity_result_id
879: ,cer.mirror_entity_result_id
880: from ben_copy_entity_results cer
881: where cer.mirror_src_entity_result_id = p_mirror_entity_result_id

Line 880: from ben_copy_entity_results cer

876: cursor c_child_object is
877: select /*+ INDEX ( cer, ben_copy_entity_results_fk1) */
878: cer.copy_entity_result_id
879: ,cer.mirror_entity_result_id
880: from ben_copy_entity_results cer
881: where cer.mirror_src_entity_result_id = p_mirror_entity_result_id
882: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
883:
884: begin

Line 888: update ben_copy_entity_results

884: begin
885: for l_child_object_rec in c_child_object
886: loop
887:
888: update ben_copy_entity_results
889: set number_of_copies = p_number_of_copies
890: where copy_entity_result_id = l_child_object_rec.copy_entity_result_id;
891:
892: update_child_object_selection(

Line 924: update ben_copy_entity_results

920:
921: if l_table_name = 'BEN_PLIP_F' then
922: if p_number_of_copies in (0,2) then -- If Plip is de-selected update Plip and child records
923:
924: update ben_copy_entity_results
925: set number_of_copies = p_number_of_copies
926: where copy_entity_result_id = p_copy_entity_result_id;
927:
928: update_child_object_selection(

Line 979: from ben_copy_entity_results cer,

975: l_pl_id number(15) default null;
976: --
977: cursor c_child_exists_for_pgm(c_pgm_id varchar2,c_copy_entity_txn_id number ) is
978: select null
979: from ben_copy_entity_results cer,
980: pqh_table_route trt
981: where cer.information1 = c_pgm_id
982: and cer.copy_entity_txn_id = c_copy_entity_txn_id
983: and cer.table_route_id = trt.table_route_id

Line 986: and exists ( select /+ INDEX ( cer1, ben_copy_entity_results_fk1) / null

982: and cer.copy_entity_txn_id = c_copy_entity_txn_id
983: and cer.table_route_id = trt.table_route_id
984: and trt.where_clause = 'BEN_PGM_F'
985: and trt.from_clause = 'OAB'
986: and exists ( select /*+ INDEX ( cer1, ben_copy_entity_results_fk1) */ null
987: from
988: ben_copy_entity_results cer1
989: where cer1.mirror_src_entity_result_id = cer.copy_entity_result_id
990: and cer1.copy_entity_txn_id = cer.copy_entity_txn_id ) ;

Line 988: ben_copy_entity_results cer1

984: and trt.where_clause = 'BEN_PGM_F'
985: and trt.from_clause = 'OAB'
986: and exists ( select /*+ INDEX ( cer1, ben_copy_entity_results_fk1) */ null
987: from
988: ben_copy_entity_results cer1
989: where cer1.mirror_src_entity_result_id = cer.copy_entity_result_id
990: and cer1.copy_entity_txn_id = cer.copy_entity_txn_id ) ;
991: --
992: cursor c_child_exists_for_pl(c_pl_id varchar2,c_copy_entity_txn_id number ) is

Line 994: from ben_copy_entity_results cer,

990: and cer1.copy_entity_txn_id = cer.copy_entity_txn_id ) ;
991: --
992: cursor c_child_exists_for_pl(c_pl_id varchar2,c_copy_entity_txn_id number ) is
993: select null
994: from ben_copy_entity_results cer,
995: pqh_table_route trt
996: where cer.information1 = c_pl_id
997: and cer.copy_entity_txn_id = c_copy_entity_txn_id
998: and cer.table_route_id = trt.table_route_id

Line 1001: and exists ( select /+ INDEX ( cer1, ben_copy_entity_results_fk1) / null from

997: and cer.copy_entity_txn_id = c_copy_entity_txn_id
998: and cer.table_route_id = trt.table_route_id
999: and trt.where_clause = 'BEN_PL_F'
1000: and trt.from_clause = 'OAB'
1001: and exists ( select /*+ INDEX ( cer1, ben_copy_entity_results_fk1) */ null from
1002: ben_copy_entity_results cer1
1003: where cer1.mirror_src_entity_result_id = cer.copy_entity_result_id
1004: and cer1.copy_entity_txn_id = cer.copy_entity_txn_id ) ;
1005:

Line 1002: ben_copy_entity_results cer1

998: and cer.table_route_id = trt.table_route_id
999: and trt.where_clause = 'BEN_PL_F'
1000: and trt.from_clause = 'OAB'
1001: and exists ( select /*+ INDEX ( cer1, ben_copy_entity_results_fk1) */ null from
1002: ben_copy_entity_results cer1
1003: where cer1.mirror_src_entity_result_id = cer.copy_entity_result_id
1004: and cer1.copy_entity_txn_id = cer.copy_entity_txn_id ) ;
1005:
1006: l_dummy varchar2(30) ;

Line 1011: from ben_copy_entity_results cer

1007: l_child_exists boolean default false;
1008:
1009: cursor c_object_version_number(c_copy_entity_result_id in number) is
1010: select cer.object_version_number
1011: from ben_copy_entity_results cer
1012: where cer.copy_entity_result_id = c_copy_entity_result_id;
1013:
1014: l_cer_object_version_number number(15);
1015:

Line 1020: from ben_copy_entity_results cer,

1016: cursor c_non_dsply_recs(c_information1 in varchar2,
1017: c_table_name in varchar2,
1018: c_copy_entity_txn_id in number) is
1019: select cer.copy_entity_result_id,cer.object_version_number
1020: from ben_copy_entity_results cer,
1021: pqh_table_route trt
1022: where cer.information1 = c_information1
1023: and trt.where_clause = c_table_name
1024: and cer.copy_entity_txn_id = c_copy_entity_txn_id

Line 1044: ben_copy_entity_results_api.update_copy_entity_results

1040: else
1041: l_cer_object_version_number := p_object_version_number;
1042: end if;
1043:
1044: ben_copy_entity_results_api.update_copy_entity_results
1045: ( p_validate => false
1046: ,p_copy_entity_result_id => p_copy_entity_result_id
1047: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1048: ,p_number_of_copies => l_number_of_copies

Line 1070: ben_copy_entity_results_api.update_copy_entity_results

1066: (p_information1,
1067: l_table_name,
1068: p_copy_entity_txn_id)
1069: loop
1070: ben_copy_entity_results_api.update_copy_entity_results
1071: ( p_validate => false
1072: ,p_copy_entity_result_id => r_non_dsply_recs.copy_entity_result_id
1073: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1074: ,p_number_of_copies => l_number_of_copies

Line 1157: from ben_copy_entity_results cpe

1153: --
1154: cursor c_cpe(c_copy_entity_txn_id number) is
1155: select copy_entity_result_id,
1156: object_version_number
1157: from ben_copy_entity_results cpe
1158: where cpe.copy_entity_txn_id = c_copy_entity_txn_id;
1159:
1160:
1161: cursor c_cer(c_copy_entity_txn_id number) is

Line 1188: -- delete from ben_copy_entity_results

1184: end loop ;
1185: --
1186:
1187: --
1188: -- delete from ben_copy_entity_results
1189: --
1190: for l_cpe in c_cpe(p_copy_entity_txn_id) loop
1191: --
1192: ben_copy_entity_results_api.delete_copy_entity_results

Line 1192: ben_copy_entity_results_api.delete_copy_entity_results

1188: -- delete from ben_copy_entity_results
1189: --
1190: for l_cpe in c_cpe(p_copy_entity_txn_id) loop
1191: --
1192: ben_copy_entity_results_api.delete_copy_entity_results
1193: (p_validate => false
1194: ,p_copy_entity_result_id => l_cpe.copy_entity_result_id
1195: ,p_object_version_number => l_cpe.object_version_number
1196: ,p_effective_date => p_effective_date

Line 1276: from ben_copy_entity_results

1272: information179,
1273: information180,
1274: information166,
1275: information306
1276: from ben_copy_entity_results
1277: where table_route_id = p_table_route_id
1278: and copy_entity_txn_id = p_copy_entity_txn_id
1279: -- Only take unmapped rows.
1280: and (information176 is null or

Line 2188: from ben_copy_entity_results

2184: ) is
2185: --
2186: cursor c_result_set(p_copy_entity_txn_id number, p_table_route_id number) is
2187: select COPY_ENTITY_RESULT_ID,object_version_number
2188: from ben_copy_entity_results
2189: where copy_entity_txn_id = p_copy_entity_txn_id
2190: and table_route_id = p_table_route_id;
2191: --
2192: l_object_version_number number;

Line 2214: update ben_copy_entity_results

2210: --
2211: end loop;
2212: */
2213:
2214: update ben_copy_entity_results
2215: set information175 = p_target_value1
2216: ,information176 = p_target_id1
2217: ,information179 = p_target_value2
2218: ,information180 = p_target_id2

Line 2235: from ben_copy_entity_results cer,

2231: l_ret varchar2(1000) := 'No';
2232: --
2233: cursor is_maping_completed(p_entity_txn_id number,p_table_route_id number) is
2234: select cer.information175
2235: from ben_copy_entity_results cer,
2236: pqh_copy_entity_txns cet
2237: where cer.copy_entity_txn_id = p_entity_txn_id
2238: and cer.copy_entity_txn_id = cet.copy_entity_txn_id
2239: and cer.information176 is null

Line 2481: from ben_copy_entity_results cer

2477:
2478: cursor c_cer(c_copy_entity_txn_id in number
2479: ,c_information8 in varchar2) is
2480: select information5 name
2481: from ben_copy_entity_results cer
2482: where cer.copy_entity_txn_id = c_copy_entity_txn_id
2483: and cer.number_of_copies = 1
2484: and cer.result_type_cd = 'DISPLAY'
2485: and cer.information8 = c_information8;

Line 2490: from ben_copy_entity_results cer

2486:
2487: cursor c_selection_count(c_copy_entity_txn_id in number) is
2488: select count(1) from (
2489: select distinct information1,information2,information3,table_route_id
2490: from ben_copy_entity_results cer
2491: where copy_entity_txn_id = c_copy_entity_txn_id
2492: and number_of_copies = 1);
2493:
2494: cursor c_copied_reused_count(c_copy_entity_txn_id in number

Line 2498: from ben_copy_entity_results

2494: cursor c_copied_reused_count(c_copy_entity_txn_id in number
2495: ,c_copied_reused_type in varchar2) is
2496: select count(1) from (
2497: select distinct information1,information2,information3,table_route_id
2498: from ben_copy_entity_results
2499: where copy_entity_txn_id = c_copy_entity_txn_id
2500: and number_of_copies = 1
2501: and information9 like c_copied_reused_type);
2502:

Line 2506: from ben_copy_entity_results

2502:
2503: cursor c_not_copied_count(c_copy_entity_txn_id in number) is
2504: select count(1) from (
2505: select distinct information1,information2,information3,table_route_id
2506: from ben_copy_entity_results
2507: where copy_entity_txn_id = c_copy_entity_txn_id
2508: and number_of_copies = 1
2509: and information9 is null);
2510:

Line 2514: from ben_copy_entity_results cer

2510:
2511: cursor c_items_to_ignore_count(c_copy_entity_txn_id in number) is
2512: select count(1) from (
2513: select distinct information1,information2,information3,cer.table_route_id
2514: from ben_copy_entity_results cer
2515: -- pqh_table_route tre
2516: where copy_entity_txn_id = c_copy_entity_txn_id
2517: and number_of_copies = 1
2518: and cer.table_alias = 'EAT'

Line 2597: -- Update target details to ben_copy_entity_results_table

2593:
2594: l_print_label boolean := true;
2595: begin
2596:
2597: -- Update target details to ben_copy_entity_results_table
2598: update_cer_with_target(p_copy_entity_txn_id);
2599:
2600: -- Bug 4317567
2601: fnd_profile.get( NAME => 'ICX_DATE_FORMAT_MASK',

Line 4833: from ben_copy_entity_results cer

4829: cursor c_chk_selection(c_copy_entity_txn_id in number
4830: ,c_number_of_copies in number)
4831: is
4832: select null
4833: from ben_copy_entity_results cer
4834: where copy_entity_txn_id = c_copy_entity_txn_id
4835: and information8 is not null
4836: and number_of_copies = c_number_of_copies
4837: and rownum = 1;

Line 4841: from ben_copy_entity_results cpe

4837: and rownum = 1;
4838: --
4839: cursor c_fff is
4840: select null
4841: from ben_copy_entity_results cpe
4842: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4843: and cpe.table_alias = 'FFF'
4844: and cpe.number_of_copies = 1
4845: and cpe.dml_operation in ('INSERT','UPDATE')

Line 5161: from ben_copy_entity_results

5157:
5158: required_mapping varchar2(10) :='true';
5159: cursor c_required_mapping_completed(p_copy_entity_txn_id number) is
5160: select table_route_id
5161: from ben_copy_entity_results
5162: where copy_entity_txn_id = p_copy_entity_txn_id
5163: and information174 is not null
5164: and table_route_id in (select table_route_id
5165: from pqh_table_route

Line 5364: and table_alias in ( select distinct table_alias from ben_copy_entity_results

5360: pragma AUTONOMOUS_TRANSACTION;
5361: cursor tr is select table_route_id,display_name,table_alias
5362: from pqh_table_route
5363: where from_clause ='OAB'
5364: and table_alias in ( select distinct table_alias from ben_copy_entity_results
5365: where copy_entity_txn_id = p_copy_entity_txn_id
5366: and table_route_id is null);
5367:
5368: begin

Line 5370: update ben_copy_entity_results

5366: and table_route_id is null);
5367:
5368: begin
5369: for i in tr loop
5370: update ben_copy_entity_results
5371: set table_route_id = i.table_route_id
5372: where copy_entity_txn_id = p_copy_entity_txn_id
5373: and table_alias = i.table_alias;
5374: end loop;