100: X_LAST_UPDATE_LOGIN in NUMBER )
101: IS
102: CURSOR status_properties IS
103: SELECT *
104: FROM ENG_STATUS_PROPERTIES
105: WHERE CHANGE_LIFECYCLE_STATUS_ID = X_LIFECYCLE_PARENT_ID;
106: BEGIN
107: FOR sp in status_properties
108: LOOP
105: WHERE CHANGE_LIFECYCLE_STATUS_ID = X_LIFECYCLE_PARENT_ID;
106: BEGIN
107: FOR sp in status_properties
108: LOOP
109: INSERT INTO ENG_STATUS_PROPERTIES (
110: CHANGE_LIFECYCLE_STATUS_ID,
111: STATUS_CODE,
112: PROMOTION_STATUS_FLAG,
113: CREATION_DATE,