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_NIR_UTIL_PKG dependencies on ENG_CHANGE_ROUTE_ASSOCS

Line 402: FROM ENG_CHANGE_ROUTE_ASSOCS WHERE ASSOC_OBJ_PK1_VALUE = p_parent_icc_id;

398: l_parent_attr_group_id NUMBER;
399:
400: CURSOR cur_child_icc_assocs IS
401: SELECT assoc_obj_pk1_value, route_people_id, object_id1, To_Char(CREATION_DATE, 'DD-MON-YYYY HH24:MI:SS') creation_date
402: FROM ENG_CHANGE_ROUTE_ASSOCS WHERE ASSOC_OBJ_PK1_VALUE = p_parent_icc_id;
403:
404: BEGIN
405: IF p_parent_icc_id IS NOT NULL THEN
406: -- Following code will be called when the AG association is deleted from the ICC directly

Line 416: SELECT To_Char(CREATION_DATE, 'DD-MON-YYYY HH24:MI:SS') INTO l_parent_assoc_creation_date FROM ENG_CHANGE_ROUTE_ASSOCS

412:
413: -- We need to check whether the same AG is not associated for the Child ICC directly
414: -- If AG is associated directly to the Child ICC then the creation date will be different as parent's
415: -- else creation date will be same as parent's
416: SELECT To_Char(CREATION_DATE, 'DD-MON-YYYY HH24:MI:SS') INTO l_parent_assoc_creation_date FROM ENG_CHANGE_ROUTE_ASSOCS
417: WHERE ASSOC_OBJ_PK1_VALUE = p_parent_icc_id
418: AND ROUTE_PEOPLE_ID = p_route_people_id
419: AND OBJECT_ID1 = p_attribute_group_id;
420:

Line 421: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS

417: WHERE ASSOC_OBJ_PK1_VALUE = p_parent_icc_id
418: AND ROUTE_PEOPLE_ID = p_route_people_id
419: AND OBJECT_ID1 = p_attribute_group_id;
420:
421: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS
422: WHERE ASSOC_OBJ_PK1_VALUE = l_child_item_catalog_group_id
423: AND ASSOC_OBJ_PK1_VALUE <> p_parent_icc_id
424: AND ROUTE_PEOPLE_ID = p_route_people_id
425: AND OBJECT_ID1 = p_attribute_group_id

Line 437: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS WHERE ROUTE_ASSOCIATION_ID IN (

433: ELSE
434: -- Following code will be called from API when the ICC NIR setp is changed
435: FOR rec IN cur_child_icc_assocs
436: LOOP
437: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS WHERE ROUTE_ASSOCIATION_ID IN (
438: SELECT ROUTE_ASSOCIATION_ID FROM (
439: SELECT a.route_association_id,
440: b.item_catalog_group_id,
441: b.parent_catalog_group_id,

Line 443: FROM eng_change_route_assocs a, mtl_item_catalog_groups_v b

439: SELECT a.route_association_id,
440: b.item_catalog_group_id,
441: b.parent_catalog_group_id,
442: b.NEW_ITEM_REQUEST_REQD
443: FROM eng_change_route_assocs a, mtl_item_catalog_groups_v b
444: WHERE a.assoc_obj_pk1_value = b.item_catalog_group_id
445: AND a.object_id1= rec.object_id1
446: AND To_Char(a.CREATION_DATE, 'DD-MON-YYYY HH24:MI:SS') = rec.creation_date
447: ) CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id AND NEW_ITEM_REQUEST_REQD = 'I'

Line 490: l_route_association_id ENG_CHANGE_ROUTE_ASSOCS.ROUTE_ASSOCIATION_ID%TYPE;

486: l_create_assocs_stmt VARCHAR2(32767);
487: l_child_item_catalog_group_id VARCHAR2(1000);
488: i NUMBER;
489: k NUMBER;
490: l_route_association_id ENG_CHANGE_ROUTE_ASSOCS.ROUTE_ASSOCIATION_ID%TYPE;
491: l_source_icc_id VARCHAR2(1000);
492: l_child_icc_ids VARCHAR2(32767);
493:
494: CURSOR cur_parent_icc_ag_associations IS

Line 500: FROM ENG_CHANGE_ROUTE_ASSOCS

496: ROUTE_PEOPLE_ID, ASSOC_OBJECT_NAME, ASSOC_OBJ_PK1_VALUE, ASSOC_OBJ_PK2_VALUE, ASSOC_OBJ_PK3_VALUE, ASSOC_OBJ_PK4_VALUE,
497: ASSOC_OBJ_PK5_VALUE, ADHOC_ASSOC_FLAG, OBJECT_NAME, OBJECT_ID1, OBJECT_ID2, OBJECT_ID3, OBJECT_ID4, OBJECT_ID5, CREATION_DATE,
498: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID,
499: PROGRAM_UPDATE_DATE, ORIGINAL_SYSTEM_REFERENCE
500: FROM ENG_CHANGE_ROUTE_ASSOCS
501: WHERE ASSOC_OBJ_PK1_VALUE = l_source_icc_id;
502:
503: BEGIN
504: IF p_source_item_catalog_group_id IS NOT NULL THEN

Line 538: FROM ENG_CHANGE_ROUTE_ASSOCS

534: IF ag_association.object_id1 IS NOT NULL THEN
535: -- First check if there is already an association for this AG at the Child ICC.
536: -- Association Unique combination (ASSOC_OBJ_PK1_VALUE, ROUTE_PEOPLE_ID, OBJECT_ID1)
537: SELECT count(route_association_id) INTO k
538: FROM ENG_CHANGE_ROUTE_ASSOCS
539: WHERE ASSOC_OBJ_PK1_VALUE = l_child_item_catalog_group_id
540: AND ROUTE_PEOPLE_ID = ag_association.route_people_id
541: AND OBJECT_ID1 = ag_association.object_id1;
542: IF k = 0 OR k IS NULL THEN -- Create association only if it already does not exist

Line 544: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.NEXTVAL INTO l_route_association_id FROM DUAL;

540: AND ROUTE_PEOPLE_ID = ag_association.route_people_id
541: AND OBJECT_ID1 = ag_association.object_id1;
542: IF k = 0 OR k IS NULL THEN -- Create association only if it already does not exist
543: -- Get the Association Id from Sequence.
544: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.NEXTVAL INTO l_route_association_id FROM DUAL;
545: -- For each Parent ICC's association, create an association in the Child ICC.
546: INSERT INTO ENG_CHANGE_ROUTE_ASSOCS (ROUTE_ASSOCIATION_ID, ROUTE_PEOPLE_ID, ASSOC_OBJECT_NAME, ASSOC_OBJ_PK1_VALUE,
547: ASSOC_OBJ_PK2_VALUE, ASSOC_OBJ_PK3_VALUE, ASSOC_OBJ_PK4_VALUE, ASSOC_OBJ_PK5_VALUE, ADHOC_ASSOC_FLAG,
548: OBJECT_NAME, OBJECT_ID1, OBJECT_ID2, OBJECT_ID3, OBJECT_ID4, OBJECT_ID5, CREATION_DATE, CREATED_BY,

Line 546: INSERT INTO ENG_CHANGE_ROUTE_ASSOCS (ROUTE_ASSOCIATION_ID, ROUTE_PEOPLE_ID, ASSOC_OBJECT_NAME, ASSOC_OBJ_PK1_VALUE,

542: IF k = 0 OR k IS NULL THEN -- Create association only if it already does not exist
543: -- Get the Association Id from Sequence.
544: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.NEXTVAL INTO l_route_association_id FROM DUAL;
545: -- For each Parent ICC's association, create an association in the Child ICC.
546: INSERT INTO ENG_CHANGE_ROUTE_ASSOCS (ROUTE_ASSOCIATION_ID, ROUTE_PEOPLE_ID, ASSOC_OBJECT_NAME, ASSOC_OBJ_PK1_VALUE,
547: ASSOC_OBJ_PK2_VALUE, ASSOC_OBJ_PK3_VALUE, ASSOC_OBJ_PK4_VALUE, ASSOC_OBJ_PK5_VALUE, ADHOC_ASSOC_FLAG,
548: OBJECT_NAME, OBJECT_ID1, OBJECT_ID2, OBJECT_ID3, OBJECT_ID4, OBJECT_ID5, CREATION_DATE, CREATED_BY,
549: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID,
550: PROGRAM_UPDATE_DATE, ORIGINAL_SYSTEM_REFERENCE)

Line 577: FROM ENG_CHANGE_ROUTE_ASSOCS

573: EXIT WHEN l_child_item_catalog_group_id IS NULL ;
574: -- First check if there is already an association for this AG at the Child ICC.
575: -- Association Unique combination (ASSOC_OBJ_PK1_VALUE, ROUTE_PEOPLE_ID, OBJECT_ID1)
576: SELECT count(route_association_id) INTO k
577: FROM ENG_CHANGE_ROUTE_ASSOCS
578: WHERE ASSOC_OBJ_PK1_VALUE = l_child_item_catalog_group_id
579: AND ROUTE_PEOPLE_ID = p_route_people_id
580: AND OBJECT_ID1 = p_attribute_group_id;
581: IF (k = 0 OR k IS NULL) AND p_parent_item_catalog_group_id <> l_child_item_catalog_group_id THEN -- Create association only if it already does not exist

Line 582: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.NEXTVAL INTO l_route_association_id FROM DUAL;

578: WHERE ASSOC_OBJ_PK1_VALUE = l_child_item_catalog_group_id
579: AND ROUTE_PEOPLE_ID = p_route_people_id
580: AND OBJECT_ID1 = p_attribute_group_id;
581: IF (k = 0 OR k IS NULL) AND p_parent_item_catalog_group_id <> l_child_item_catalog_group_id THEN -- Create association only if it already does not exist
582: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.NEXTVAL INTO l_route_association_id FROM DUAL;
583: -- For each Parent ICC's association, create an association in the Child ICC.
584: INSERT INTO ENG_CHANGE_ROUTE_ASSOCS (ROUTE_ASSOCIATION_ID, ROUTE_PEOPLE_ID, ASSOC_OBJECT_NAME, ASSOC_OBJ_PK1_VALUE,
585: ADHOC_ASSOC_FLAG, OBJECT_NAME, OBJECT_ID1, OBJECT_ID2, OBJECT_ID3, OBJECT_ID4, OBJECT_ID5,
586: CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE,

Line 584: INSERT INTO ENG_CHANGE_ROUTE_ASSOCS (ROUTE_ASSOCIATION_ID, ROUTE_PEOPLE_ID, ASSOC_OBJECT_NAME, ASSOC_OBJ_PK1_VALUE,

580: AND OBJECT_ID1 = p_attribute_group_id;
581: IF (k = 0 OR k IS NULL) AND p_parent_item_catalog_group_id <> l_child_item_catalog_group_id THEN -- Create association only if it already does not exist
582: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.NEXTVAL INTO l_route_association_id FROM DUAL;
583: -- For each Parent ICC's association, create an association in the Child ICC.
584: INSERT INTO ENG_CHANGE_ROUTE_ASSOCS (ROUTE_ASSOCIATION_ID, ROUTE_PEOPLE_ID, ASSOC_OBJECT_NAME, ASSOC_OBJ_PK1_VALUE,
585: ADHOC_ASSOC_FLAG, OBJECT_NAME, OBJECT_ID1, OBJECT_ID2, OBJECT_ID3, OBJECT_ID4, OBJECT_ID5,
586: CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE,
587: LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
588: VALUES (l_route_association_id, p_route_people_id, 'EGO_CATALOG_GROUP', l_child_item_catalog_group_id, 'N',

Line 616: SELECT object_id1 INTO l_old_attr_group_id FROM ENG_CHANGE_ROUTE_ASSOCS WHERE route_association_id = p_route_association_id;

612: i NUMBER;
613: l_child_item_catalog_group_id VARCHAR2(1000);
614: BEGIN
615: -- Get the old attribute groups associated
616: SELECT object_id1 INTO l_old_attr_group_id FROM ENG_CHANGE_ROUTE_ASSOCS WHERE route_association_id = p_route_association_id;
617: i := 1;
618: LOOP
619: l_child_item_catalog_group_id := Tokenize( p_child_item_catalog_group_ids, i , ',') ;
620: EXIT WHEN l_child_item_catalog_group_id IS NULL ;

Line 623: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS

619: l_child_item_catalog_group_id := Tokenize( p_child_item_catalog_group_ids, i , ',') ;
620: EXIT WHEN l_child_item_catalog_group_id IS NULL ;
621:
622: IF p_attribute_group_id IS NULL THEN -- When attribute group association lov field is cleared
623: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS
624: WHERE ASSOC_OBJ_PK1_VALUE = l_child_item_catalog_group_id
625: AND ASSOC_OBJ_PK1_VALUE <> p_parent_item_catalog_group_id
626: AND ROUTE_PEOPLE_ID = p_route_people_id
627: AND OBJECT_ID1 = l_old_attr_group_id;

Line 629: UPDATE ENG_CHANGE_ROUTE_ASSOCS

625: AND ASSOC_OBJ_PK1_VALUE <> p_parent_item_catalog_group_id
626: AND ROUTE_PEOPLE_ID = p_route_people_id
627: AND OBJECT_ID1 = l_old_attr_group_id;
628: ELSE
629: UPDATE ENG_CHANGE_ROUTE_ASSOCS
630: SET OBJECT_ID1 = p_attribute_group_id
631: WHERE ASSOC_OBJ_PK1_VALUE = l_child_item_catalog_group_id
632: AND ASSOC_OBJ_PK1_VALUE <> p_parent_item_catalog_group_id
633: AND ROUTE_PEOPLE_ID = p_route_people_id;