1 PACKAGE PA_PROJ_STRUC_MAPPING_UTILS AS
2 /* $Header: PAPSMPUS.pls 120.1 2005/08/19 16:46:29 mwasowic noship $ */
3
4 FUNCTION Check_Task_Has_Mapping
5 (
6 p_project_id IN NUMBER
7 , p_proj_element_id IN NUMBER
8 ) RETURN VARCHAR2;
9
10 PROCEDURE CHECK_CREATE_MAPPING_OK
11 (
12 p_api_version IN NUMBER := 1.0
13 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
14 , p_debug_mode IN VARCHAR2 := 'N'
15 , p_task_version_id_WP IN NUMBER
16 , p_task_version_id_FP IN NUMBER
17 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
18 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
19 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
20 , x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21 );
22
23 TYPE TASK_NAME_TABLE_TYPE IS TABLE OF PA_PROJ_ELEMENTS.NAME%TYPE INDEX BY BINARY_INTEGER;
24
25 FUNCTION PARSE_NAMES
26 (
27 p_wPlan IN VARCHAR2
28 , p_delim IN VARCHAR2
29 ) RETURN PA_PROJ_STRUC_MAPPING_UTILS.TASK_NAME_TABLE_TYPE;
30
31 FUNCTION GET_TASK_NAME_FROM_VERSION
32 ( p_task_version_id IN NUMBER
33 ) RETURN VARCHAR2;
34
35 FUNCTION GET_MAPPED_FIN_TASK_VERSION_ID
36 (p_element_version_id IN NUMBER
37 ,p_structure_sharing_code IN VARCHAR2) RETURN NUMBER;
38
39 FUNCTION GET_MAPPED_FIN_TASK_ID
40 (p_element_version_id IN NUMBER
41 ,p_structure_sharing_code IN VARCHAR2) RETURN NUMBER;
42
43 FUNCTION GET_MAPPED_FIN_TASK_NAME
44 (p_element_version_id IN NUMBER
45 ,p_structure_sharing_code IN VARCHAR2) RETURN VARCHAR2;
46
47 FUNCTION GET_MAPPED_STRUCT_VER_ID
48 (p_element_version_id IN NUMBER
49 ,p_structure_sharing_code IN VARCHAR2) RETURN NUMBER;
50
51 FUNCTION GET_MAPPED_FIN_TASK_NAME_AMG
52 (
53 p_mapped_wkp_task_version_id IN NUMBER
54 ,p_project_id IN NUMBER
55 ) RETURN VARCHAR2;
56
57 FUNCTION GET_MAPPED_FIN_TASK_ID_AMG
58 (
59 p_mapped_wkp_task_version_id IN NUMBER
60 ,p_project_id IN NUMBER
61 ) RETURN NUMBER;
62 FUNCTION GET_MAPPED_WKP_TASK_IDS
63 (
64 p_mapped_fin_task_version_id IN NUMBER
65 ,p_project_id IN NUMBER
66 ) RETURN VARCHAR2;
67 FUNCTION GET_MAPPED_WKP_TASK_NAMES
68 (
69 p_mapped_fin_task_version_id IN NUMBER
70 ,p_project_id IN NUMBER
71 ) RETURN VARCHAR2;
72
73
74 END PA_PROJ_STRUC_MAPPING_UTILS;
75