[Home] [Help]
491: AND resp.responsibility_type = 'N'
492: AND bg.budget_group_id = resp.budget_group_id ;
493:
494: --
495: -- Create an itemtype in psb_workflow_processes, to be used by the
496: -- Workflow 'Submit Process'.
497: --
498: SELECT psb_workflow_processes_s.nextval INTO l_item_key
499: FROM dual ;
494: --
495: -- Create an itemtype in psb_workflow_processes, to be used by the
496: -- Workflow 'Submit Process'.
497: --
498: SELECT psb_workflow_processes_s.nextval INTO l_item_key
499: FROM dual ;
500:
501: INSERT INTO psb_workflow_processes
502: ( item_key ,
497: --
498: SELECT psb_workflow_processes_s.nextval INTO l_item_key
499: FROM dual ;
500:
501: INSERT INTO psb_workflow_processes
502: ( item_key ,
503: process_type ,
504: worksheet_id ,
505: process_date,
817:
818:
819: /*---3. WORKFLOW-----------------------------------------------*/
820: --
821: -- Create an itemtype in psb_workflow_processes, to be used by the
822: -- Workflow 'Distribute Process'.
823: --
824:
825: SELECT psb_workflow_processes_s.nextval INTO l_item_key
821: -- Create an itemtype in psb_workflow_processes, to be used by the
822: -- Workflow 'Distribute Process'.
823: --
824:
825: SELECT psb_workflow_processes_s.nextval INTO l_item_key
826: FROM dual ;
827:
828: INSERT INTO psb_workflow_processes
829: ( item_key ,
824:
825: SELECT psb_workflow_processes_s.nextval INTO l_item_key
826: FROM dual ;
827:
828: INSERT INTO psb_workflow_processes
829: ( item_key ,
830: process_type ,
831: worksheet_id ,
832: process_date,
1550:
1551:
1552: /*---3. WORKFLOW-----------------------------------------------*/
1553: --
1554: -- Create an itemtype in psb_workflow_processes, to be used by the
1555: -- Workflow 'Distribute Process'.
1556: --
1557:
1558: SELECT psb_workflow_processes_s.nextval INTO l_item_key
1554: -- Create an itemtype in psb_workflow_processes, to be used by the
1555: -- Workflow 'Distribute Process'.
1556: --
1557:
1558: SELECT psb_workflow_processes_s.nextval INTO l_item_key
1559: FROM dual ;
1560:
1561: INSERT INTO psb_workflow_processes
1562: ( item_key ,
1557:
1558: SELECT psb_workflow_processes_s.nextval INTO l_item_key
1559: FROM dual ;
1560:
1561: INSERT INTO psb_workflow_processes
1562: ( item_key ,
1563: process_type ,
1564: worksheet_id ,
1565: process_date ,
1694: AND resp.responsibility_type = 'N'
1695: AND bg.budget_group_id = resp.budget_group_id ;
1696:
1697: --
1698: -- Create an itemtype in psb_workflow_processes, to be used by the
1699: -- Workflow 'Submit Process'.
1700: --
1701: SELECT psb_workflow_processes_s.nextval INTO l_item_key
1702: FROM dual ;
1697: --
1698: -- Create an itemtype in psb_workflow_processes, to be used by the
1699: -- Workflow 'Submit Process'.
1700: --
1701: SELECT psb_workflow_processes_s.nextval INTO l_item_key
1702: FROM dual ;
1703:
1704:
1705: INSERT INTO psb_workflow_processes
1701: SELECT psb_workflow_processes_s.nextval INTO l_item_key
1702: FROM dual ;
1703:
1704:
1705: INSERT INTO psb_workflow_processes
1706: ( item_key ,
1707: process_type ,
1708: worksheet_id ,
1709: process_date,