[Home] [Help]
427: -- Generate Item Key from ENG_WORKFLOW_REVISION_S.NEXTVAL
428: -- and return the value
429: SELECT ENG_WORKFLOW_REVISION_S.NEXTVAL
430: INTO l_rev_seq
431: FROM DUAL;
432:
433: l_new_item_key := TO_CHAR(l_rev_seq) ;
434:
435: RETURN l_new_item_key ;
652:
653: CURSOR c_role (p_role_name VARCHAR2 )
654: IS
655: SELECT 'Role Exists'
656: FROM DUAL
657: WHERE EXISTS ( SELECT null
658: from WF_LOCAL_ROLES
659: WHERE NAME = p_role_name
660: AND ORIG_SYSTEM = 'WF_LOCAL_ROLES'
9387: -- Line Route: Exists
9388: CURSOR c_approved_line (p_change_id NUMBER )
9389: IS
9390: SELECT 'Non Approved Line Exists'
9391: FROM DUAL
9392: WHERE EXISTS ( SELECT null
9393: FROM ENG_CHANGE_LINES ecl
9394: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9395: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
13523: END IF ;
13524:
13525: END IF ;
13526:
13527: select ENG_CHANGE_ROUTE_PEOPLE_S.nextval into l_new_route_people_id from dual;
13528:
13529: Eng_Change_Route_People_Util.INSERT_ROW
13530: (
13531: X_ROWID => l_rowid,
13555: ) ;
13556:
13557: FOR assoc_rec in c_report_people_assocs(l_route_people_id)
13558: LOOP
13559: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.nextval into l_new_route_assoc_id from DUAL;
13560:
13561: insert into ENG_CHANGE_ROUTE_ASSOCS
13562: (
13563: ROUTE_ASSOCIATION_ID ,
14107:
14108: --
14109: -- 4. Execute Query for Change Subject by given change id and change line id
14110: -- and iterlate the fetched row.
14111: -- Call insdividual API to grant the objects to assignees.
14112: --
14113: -- Note: IN R12B, anyway we support only DOM_DOCUMENT_REVISION and OCS File
14114: --
14115:
15058:
15059: --
15060: -- 4. Execute Query for Change Subject by given change id and change line id
15061: -- and iterlate the fetched row.
15062: -- Call insdividual API to grant the objects to assignees.
15063: --
15064: -- Note: IN R12B, anyway we support only DOM_DOCUMENT_REVISION and OCS File
15065: --
15066: FOR c_chg_objects_rec IN c_chg_objects ( c_change_id => l_change_id