DBA Data[Home] [Help]

PACKAGE: APPS.AZW_HIER

Source


1 PACKAGE AZW_HIER AUTHID CURRENT_USER AS
2 /* $Header: AZWHIERS.pls 115.5 99/07/16 19:28:29 porting sh $ */
3 
4 --
5 -- Name:        get_hierarchy
6 -- Description: Retrieves grouping processes, wf processes, and
7 --              wf tasks after applying filters.
8 -- Parameters:
9 --   	All the selection criteria from Find window
10 --
11   PROCEDURE get_hierarchy (process_group      IN VARCHAR2,
12                            process_status     IN VARCHAR2,
13                            process_phase      IN NUMBER,
14                            assigned_user      IN VARCHAR2,
15                            task_status        IN VARCHAR2,
16                            task_total_days    IN NUMBER,
17                            task_total_days_op IN VARCHAR2,
18                            sort_by            IN VARCHAR2);
19 
20 END AZW_HIER;