35: ,ITERATION_NUMBER
36: ,ACTIVE_FLAG
37: ,CHANGE_WF_ROUTE_ID
38: FROM
39: ENG_LIFECYCLE_STATUSES
40: WHERE
41: ENTITY_NAME = 'ENG_CHANGE_TYPE'
42: AND ENTITY_ID1 = p_change_type_id;
43:
44: BEGIN
45: FOR l_status_rec IN l_status_csr
46: LOOP
47: -- Insert the Statuses data
48: INSERT INTO ENG_LIFECYCLE_STATUSES
49: (
50: CHANGE_LIFECYCLE_STATUS_ID
51: ,ENTITY_NAME
52: ,ENTITY_ID1
74: ,CHANGE_WF_ROUTE_TEMPLATE_ID
75: )
76: VALUES
77: (
78: ENG_LIFECYCLE_STATUSES_S.NEXTVAL
79: ,'ENG_CHANGE'
80: ,p_change_id
81: ,NULL -- l_status_rec.ENTITY_ID2
82: ,NULL -- l_status_rec.ENTITY_ID3