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