1 package PA_TASK_MANAGER as
2 /* $Header: PATMUPGS.pls 120.1 2005/08/19 17:04:34 mwasowic noship $ */
3
4 /* Function to get the profile option value */
5 function get_profile_value (p_name IN VARCHAR2) return VARCHAR2;
6
7 /* Procedure to check the break periods if the task manager is existing as a project member */
8 procedure validate_member_exists ( p_project_id IN NUMBER,
9 p_task_manager_person_id IN NUMBER,
10 p_proj_role_id IN NUMBER,
11 p_start_date_active IN DATE,
12 p_end_date_active IN DATE,
13 p_project_end_date IN DATE);
14
15 /* Main Procedure to upgrade the task managers as project members */
16 procedure upgrade_task_manager ( errbuf OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17 retcode OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
18 p_project_num_from IN VARCHAR2,
19 p_project_num_to IN VARCHAR2,
20 p_project_role IN VARCHAR2,
21 p_project_org IN NUMBER,
22 p_project_type IN VARCHAR2);
23
24 /* procedure to print the debug messages in the log file */
25 procedure tm_log ( p_message IN VARCHAR2 );
26
27 /* procedure to print the data in the output report for the concurrent process */
28 procedure tm_out ( p_project_id IN NUMBER,
29 p_task_manager_person_id IN NUMBER,
30 p_message IN VARCHAR2);
31
32 /* procedure to print the output report for the concurrent process */
33 procedure print_output (p_project_num_from IN VARCHAR2,
34 p_project_num_to IN VARCHAR2,
35 p_project_role IN VARCHAR2,
36 p_project_org IN NUMBER,
37 p_project_type IN VARCHAR2);
38 END PA_TASK_MANAGER;