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 406: FROM ENG_CHANGE_ROUTE_ASSOCS WHERE ASSOC_OBJ_PK1_VALUE = p_parent_icc_id;

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

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

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

Line 425: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS

421: WHERE ASSOC_OBJ_PK1_VALUE = p_parent_icc_id
422: AND ROUTE_PEOPLE_ID = p_route_people_id
423: AND OBJECT_ID1 = p_attribute_group_id;
424:
425: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS
426: WHERE ASSOC_OBJ_PK1_VALUE = l_child_item_catalog_group_id
427: AND ASSOC_OBJ_PK1_VALUE <> p_parent_icc_id
428: AND ROUTE_PEOPLE_ID = p_route_people_id
429: AND OBJECT_ID1 = p_attribute_group_id

Line 441: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS WHERE ROUTE_ASSOCIATION_ID IN (

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

Line 447: FROM eng_change_route_assocs a, mtl_item_catalog_groups_v b

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

Line 494: l_route_association_id ENG_CHANGE_ROUTE_ASSOCS.ROUTE_ASSOCIATION_ID%TYPE;

490: l_create_assocs_stmt VARCHAR2(32767);
491: l_child_item_catalog_group_id VARCHAR2(1000);
492: i NUMBER;
493: k NUMBER;
494: l_route_association_id ENG_CHANGE_ROUTE_ASSOCS.ROUTE_ASSOCIATION_ID%TYPE;
495: l_source_icc_id VARCHAR2(1000);
496: l_child_icc_ids VARCHAR2(32767);
497:
498: CURSOR cur_parent_icc_ag_associations IS

Line 504: FROM ENG_CHANGE_ROUTE_ASSOCS

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

Line 542: FROM ENG_CHANGE_ROUTE_ASSOCS

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

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

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

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

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

Line 581: FROM ENG_CHANGE_ROUTE_ASSOCS

577: EXIT WHEN l_child_item_catalog_group_id IS NULL ;
578: -- First check if there is already an association for this AG at the Child ICC.
579: -- Association Unique combination (ASSOC_OBJ_PK1_VALUE, ROUTE_PEOPLE_ID, OBJECT_ID1)
580: SELECT count(route_association_id) INTO k
581: FROM ENG_CHANGE_ROUTE_ASSOCS
582: WHERE ASSOC_OBJ_PK1_VALUE = l_child_item_catalog_group_id
583: AND ROUTE_PEOPLE_ID = p_route_people_id
584: AND OBJECT_ID1 = p_attribute_group_id;
585: 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 586: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.NEXTVAL INTO l_route_association_id FROM DUAL;

582: WHERE ASSOC_OBJ_PK1_VALUE = l_child_item_catalog_group_id
583: AND ROUTE_PEOPLE_ID = p_route_people_id
584: AND OBJECT_ID1 = p_attribute_group_id;
585: 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
586: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.NEXTVAL INTO l_route_association_id FROM DUAL;
587: -- For each Parent ICC's association, create an association in the Child ICC.
588: INSERT INTO ENG_CHANGE_ROUTE_ASSOCS (ROUTE_ASSOCIATION_ID, ROUTE_PEOPLE_ID, ASSOC_OBJECT_NAME, ASSOC_OBJ_PK1_VALUE,
589: ADHOC_ASSOC_FLAG, OBJECT_NAME, OBJECT_ID1, OBJECT_ID2, OBJECT_ID3, OBJECT_ID4, OBJECT_ID5,
590: CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE,

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

584: AND OBJECT_ID1 = p_attribute_group_id;
585: 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
586: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.NEXTVAL INTO l_route_association_id FROM DUAL;
587: -- For each Parent ICC's association, create an association in the Child ICC.
588: INSERT INTO ENG_CHANGE_ROUTE_ASSOCS (ROUTE_ASSOCIATION_ID, ROUTE_PEOPLE_ID, ASSOC_OBJECT_NAME, ASSOC_OBJ_PK1_VALUE,
589: ADHOC_ASSOC_FLAG, OBJECT_NAME, OBJECT_ID1, OBJECT_ID2, OBJECT_ID3, OBJECT_ID4, OBJECT_ID5,
590: CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE,
591: LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
592: VALUES (l_route_association_id, p_route_people_id, 'EGO_CATALOG_GROUP', l_child_item_catalog_group_id, 'N',

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

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

Line 627: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS

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

Line 633: UPDATE ENG_CHANGE_ROUTE_ASSOCS

629: AND ASSOC_OBJ_PK1_VALUE <> p_parent_item_catalog_group_id
630: AND ROUTE_PEOPLE_ID = p_route_people_id
631: AND OBJECT_ID1 = l_old_attr_group_id;
632: ELSE
633: UPDATE ENG_CHANGE_ROUTE_ASSOCS
634: SET OBJECT_ID1 = p_attribute_group_id
635: WHERE ASSOC_OBJ_PK1_VALUE = l_child_item_catalog_group_id
636: AND ASSOC_OBJ_PK1_VALUE <> p_parent_item_catalog_group_id
637: AND ROUTE_PEOPLE_ID = p_route_people_id;