[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'
9311: -- Line Route: Exists
9312: CURSOR c_approved_line (p_change_id NUMBER )
9313: IS
9314: SELECT 'Non Approved Line Exists'
9315: FROM DUAL
9316: WHERE EXISTS ( SELECT null
9317: FROM ENG_CHANGE_LINES ecl
9318: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9319: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
13378: END IF ;
13379:
13380: END IF ;
13381:
13382: select ENG_CHANGE_ROUTE_PEOPLE_S.nextval into l_new_route_people_id from dual;
13383:
13384: Eng_Change_Route_People_Util.INSERT_ROW
13385: (
13386: X_ROWID => l_rowid,
13410: ) ;
13411:
13412: FOR assoc_rec in c_report_people_assocs(l_route_people_id)
13413: LOOP
13414: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.nextval into l_new_route_assoc_id from DUAL;
13415:
13416: insert into ENG_CHANGE_ROUTE_ASSOCS
13417: (
13418: ROUTE_ASSOCIATION_ID ,
13962:
13963: --
13964: -- 4. Execute Query for Change Subject by given change id and change line id
13965: -- and iterlate the fetched row.
13966: -- Call insdividual API to grant the objects to assignees.
13967: --
13968: -- Note: IN R12B, anyway we support only DOM_DOCUMENT_REVISION and OCS File
13969: --
13970:
14913:
14914: --
14915: -- 4. Execute Query for Change Subject by given change id and change line id
14916: -- and iterlate the fetched row.
14917: -- Call insdividual API to grant the objects to assignees.
14918: --
14919: -- Note: IN R12B, anyway we support only DOM_DOCUMENT_REVISION and OCS File
14920: --
14921: FOR c_chg_objects_rec IN c_chg_objects ( c_change_id => l_change_id