DBA Data[Home] [Help]

PACKAGE: APPS.PA_SEARCH_PVT

Source


1 PACKAGE PA_SEARCH_PVT AS
2 --$Header: PARISPVS.pls 120.1 2005/08/19 16:54:54 mwasowic noship $
3 --
4 
5   PROCEDURE Run_Search             ( p_search_mode          IN  VARCHAR2
6                                    , p_search_criteria      IN  PA_SEARCH_GLOB.Search_Criteria_Rec_Type
7                                    , p_competence_criteria  IN  PA_SEARCH_GLOB.Competence_Criteria_Tbl_Type
8                                    , p_commit               IN  VARCHAR2
9                                    , p_validate_only        IN  VARCHAR2
10                                    , x_return_status        OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11                                    );
12 
13   PROCEDURE Run_Auto_Search(errbuf                 OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
14                             retcode                OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
15                             p_auto_search_mode      IN VARCHAR2,
16                             p_project_id            IN NUMBER,
17                             p_project_number_from   IN VARCHAR2,
18                             p_project_number_to     IN VARCHAR2,
19                             p_proj_start_date_days  IN NUMBER,
20                             p_req_start_date_days   IN NUMBER,
21                             p_project_status_code   IN VARCHAR2,
22                             p_debug_mode            IN VARCHAR2
23                             );
24 
25 
26   FUNCTION Show_Req_In_Search(p_assignment_id pa_project_assignments.assignment_id%TYPE,
27                               p_status_code   pa_project_statuses.project_status_code%TYPE)
28       RETURN VARCHAR2;
29 
30 
31 END PA_SEARCH_PVT;