[Home] [Help]
1966:
1967:
1968: CURSOR get_item_key IS
1969: SELECT MAX(pwp.item_key), max(pwp.item_type)
1970: from pa_wf_processes pwp, pa_project_statuses pps,
1971: pa_progress_report_vers pprv
1972: where pwp.item_type = pps.WORKFLOW_ITEM_TYPE
1973: and pps.status_type = 'PROGRESS_REPORT'
1974: and pps.project_status_code = 'PROGRESS_REPORT_SUBMITTED'
1989: CURSOR get_wf_status IS
1990: select 'Y' FROM dual
1991: WHERE exists
1992: (SELECT *
1993: from wf_item_activity_statuses wias, pa_project_statuses pps
1994: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
1995: AND wias.item_key = l_item_key
1996: AND wias.activity_status = 'ACTIVE'
1997: AND pps.status_type = 'PROGRESS_REPORT'
2194:
2195:
2196: CURSOR get_item_key IS
2197: SELECT MAX(pwp.item_key), max(pwp.item_type)
2198: from pa_wf_processes pwp, pa_project_statuses pps,
2199: pa_progress_report_vers pprv
2200: where pwp.item_type = pps.WORKFLOW_ITEM_TYPE
2201: and pps.status_type = 'PROGRESS_REPORT'
2202: and pps.project_status_code = 'PROGRESS_REPORT_SUBMITTED'
2218: CURSOR get_wf_status IS
2219: select 'Y' FROM dual
2220: WHERE exists
2221: (SELECT *
2222: from wf_item_activity_statuses wias, pa_project_statuses pps
2223: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
2224: AND wias.item_key = l_item_key
2225: AND wias.activity_status = 'ACTIVE'
2226: AND pps.status_type = 'PROGRESS_REPORT'
2742: CURSOR get_wf_process_name
2743: IS
2744: select
2745: WORKFLOW_ITEM_TYPE,
2746: workflow_process, enable_wf_flag from pa_project_statuses
2747: where status_type = 'PROGRESS_REPORT'
2748: AND project_status_code = 'PROGRESS_REPORT_SUBMITTED';
2749:
2750: BEGIN
2971:
2972: CURSOR get_wf_info is
2973: select enable_wf_flag, workflow_item_type,
2974: workflow_process,wf_success_status_code,
2975: wf_failure_status_code from pa_project_statuses
2976: where project_status_code = p_report_status;
2977:
2978:
2979: --like 'PROGRESS_REPORT%'