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.ENG_PROPAGATION_LOG_UTIL dependencies on ENG_CHANGE_PROPAGATION_MAPS

Line 173: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE

169: -- Validate Entity Map Record --
170: ----------------------------------------------------------
171: PROCEDURE Check_Entity_Map_Existance (
172: p_change_id IN NUMBER
173: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
174: , p_revised_item_sequence_id IN NUMBER := NULL
175: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
176: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
177: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL

Line 175: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL

171: PROCEDURE Check_Entity_Map_Existance (
172: p_change_id IN NUMBER
173: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
174: , p_revised_item_sequence_id IN NUMBER := NULL
175: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
176: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
177: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
178: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
179: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL

Line 176: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL

172: p_change_id IN NUMBER
173: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
174: , p_revised_item_sequence_id IN NUMBER := NULL
175: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
176: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
177: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
178: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
179: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
180: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL

Line 177: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL

173: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
174: , p_revised_item_sequence_id IN NUMBER := NULL
175: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
176: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
177: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
178: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
179: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
180: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
181: , p_local_organization_id IN NUMBER

Line 178: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL

174: , p_revised_item_sequence_id IN NUMBER := NULL
175: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
176: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
177: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
178: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
179: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
180: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
181: , p_local_organization_id IN NUMBER
182: , x_change_map_id OUT NOCOPY NUMBER

Line 179: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL

175: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
176: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
177: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
178: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
179: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
180: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
181: , p_local_organization_id IN NUMBER
182: , x_change_map_id OUT NOCOPY NUMBER
183: )

Line 180: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL

176: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
177: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
178: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
179: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
180: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
181: , p_local_organization_id IN NUMBER
182: , x_change_map_id OUT NOCOPY NUMBER
183: )
184: IS

Line 187: FROM eng_change_propagation_maps ecpm

183: )
184: IS
185: CURSOR c_check_entity_map IS
186: SELECT ecpm.change_propagation_map_id
187: FROM eng_change_propagation_maps ecpm
188: WHERE ecpm.change_id = p_change_id
189: AND ecpm.local_organization_id = p_local_organization_id
190: AND ecpm.entity_name = p_entity_name
191: AND nvl(ecpm.revised_item_sequence_id, -1) = nvl(p_revised_item_sequence_id, -1)

Line 240: UPDATE eng_change_propagation_maps

236: -- Insert a new map otherwise
237: --
238: IF p_entity_map_rec.change_propagation_map_id IS NOT NULL
239: THEN
240: UPDATE eng_change_propagation_maps
241: SET local_change_id = p_entity_map_rec.local_change_id
242: , local_revised_item_sequence_id = p_entity_map_rec.local_revised_item_seq_id
243: , local_revised_line_id1 = p_entity_map_rec.local_revised_line_id1
244: , local_revised_line_id2 = p_entity_map_rec.local_revised_line_id2

Line 260: SELECT eng_change_propagation_maps_s.nextval

256: , program_update_date = SYSDATE
257: , request_id = FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
258: WHERE change_propagation_map_id = p_entity_map_rec.change_propagation_map_id;
259: ELSE
260: SELECT eng_change_propagation_maps_s.nextval
261: INTO p_entity_map_rec.change_propagation_map_id
262: FROM DUAL;
263:
264: INSERT INTO eng_change_propagation_maps(

Line 264: INSERT INTO eng_change_propagation_maps(

260: SELECT eng_change_propagation_maps_s.nextval
261: INTO p_entity_map_rec.change_propagation_map_id
262: FROM DUAL;
263:
264: INSERT INTO eng_change_propagation_maps(
265: change_propagation_map_id
266: , change_id
267: , revised_item_sequence_id
268: , local_change_id

Line 546: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL

542:
543: PROCEDURE Add_Entity_Map (
544: p_change_id IN NUMBER
545: , p_revised_item_sequence_id IN NUMBER := NULL
546: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
547: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
548: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
549: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
550: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL

Line 547: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL

543: PROCEDURE Add_Entity_Map (
544: p_change_id IN NUMBER
545: , p_revised_item_sequence_id IN NUMBER := NULL
546: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
547: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
548: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
549: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
550: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
551: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL

Line 548: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL

544: p_change_id IN NUMBER
545: , p_revised_item_sequence_id IN NUMBER := NULL
546: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
547: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
548: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
549: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
550: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
551: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
552: , p_local_organization_id IN NUMBER

Line 549: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL

545: , p_revised_item_sequence_id IN NUMBER := NULL
546: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
547: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
548: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
549: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
550: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
551: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
552: , p_local_organization_id IN NUMBER
553: , p_local_change_id IN NUMBER := NULL

Line 550: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL

546: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
547: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
548: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
549: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
550: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
551: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
552: , p_local_organization_id IN NUMBER
553: , p_local_change_id IN NUMBER := NULL
554: , p_local_revised_item_seq_id IN NUMBER := NULL

Line 551: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL

547: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
548: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
549: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
550: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
551: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
552: , p_local_organization_id IN NUMBER
553: , p_local_change_id IN NUMBER := NULL
554: , p_local_revised_item_seq_id IN NUMBER := NULL
555: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL

Line 555: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL

551: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
552: , p_local_organization_id IN NUMBER
553: , p_local_change_id IN NUMBER := NULL
554: , p_local_revised_item_seq_id IN NUMBER := NULL
555: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
556: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
557: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
558: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
559: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL

Line 556: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL

552: , p_local_organization_id IN NUMBER
553: , p_local_change_id IN NUMBER := NULL
554: , p_local_revised_item_seq_id IN NUMBER := NULL
555: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
556: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
557: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
558: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
559: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
560: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE

Line 557: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL

553: , p_local_change_id IN NUMBER := NULL
554: , p_local_revised_item_seq_id IN NUMBER := NULL
555: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
556: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
557: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
558: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
559: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
560: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
561: , p_entity_action_status IN NUMBER

Line 558: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL

554: , p_local_revised_item_seq_id IN NUMBER := NULL
555: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
556: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
557: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
558: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
559: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
560: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
561: , p_entity_action_status IN NUMBER
562: , p_bo_entity_identifier IN VARCHAR2

Line 559: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL

555: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
556: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
557: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
558: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
559: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
560: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
561: , p_entity_action_status IN NUMBER
562: , p_bo_entity_identifier IN VARCHAR2
563: ) IS

Line 560: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE

556: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
557: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
558: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
559: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
560: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
561: , p_entity_action_status IN NUMBER
562: , p_bo_entity_identifier IN VARCHAR2
563: ) IS
564: l_Nxt_Idx NUMBER;

Line 771: FROM eng_change_propagation_maps new_ri_map

767: FROM eng_revised_items new_ri
768: WHERE new_ri.change_id= p_global_change_id -- global change id
769: AND NOT EXISTS (
770: SELECT 1
771: FROM eng_change_propagation_maps new_ri_map
772: WHERE new_ri_map.change_id = new_ri.change_id
773: AND new_ri_map.revised_item_sequence_id = new_ri.revised_item_sequence_id
774: AND new_ri_map.entity_name = 'ENG_REVISED_ITEM'
775: AND new_ri_map.local_organization_id = p_local_organization_id)