[Home] [Help]
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,
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,