1 package PA_PROJ_STRUCTURE_UTILS as
2 /* $Header: PAXSTRUS.pls 120.3 2007/02/06 10:23:59 dthakker ship $ */
3
4 -- Bug Fix 5611909. Creating global variables to cache the project id and budget version id.
5 -- These will be used in the program unit Get_All_Wbs_Rejns and these will be set by using
6 -- the set_budget_version_id_global procedure.
7 -- NOTE: PLEASE DO NOT MODIFY THESE ANYWHERE ELSE OR USING ANY OTHER MEANS.
8
9 G_PROJECT_ID NUMBER := NULL;
10 G_BUDGET_VERSION_ID NUMBER := NULL;
11
12 procedure CHECK_LOOPED_PROJECT(
13 p_api_version IN NUMBER := 1.0,
14 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
15 p_commit IN VARCHAR2 := FND_API.G_FALSE,
16 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
17 p_debug_mode IN VARCHAR2 := 'N',
18 p_task_id IN NUMBER,
19 p_project_id IN NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
21 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
22 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23 );
24
25 procedure CHECK_MERGED_PROJECT(
26 p_api_version IN NUMBER := 1.0,
27 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
28 p_commit IN VARCHAR2 := FND_API.G_FALSE,
29 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
30 p_debug_mode IN VARCHAR2 := 'N',
31 p_task_id IN NUMBER,
32 p_project_id IN NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
35 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
36 );
37
38 function CHECK_PROJECT_CONTRACT_EXISTS(
39 p_project_id IN NUMBER
40 )
41 return VARCHAR2;
42
43 function CHECK_TASK_CONTRACT_EXISTS(
44 p_task_id IN NUMBER
45 )
46 return VARCHAR2;
47
48 function IS_WF_ENABLED_FOR_STRUCTURE(
49 p_project_id IN NUMBER
50 ,p_structure_type IN VARCHAR2
51 )
52 return VARCHAR2;
53
54 function Get_All_Wbs_Rejns(
55 p_project_id IN Number,
56 p_calling_mode IN Varchar2 Default 'PROJ_STR_VER',
57 p_proj_str_version_id IN Number,
58 p_Task_str_version_id IN Number Default Null,
59 p_start_date IN Date Default Null,
60 p_end_date IN Date Default Null
61 )
62 return VARCHAR2;
63
64 function CHECK_STR_TEMP_TAB_POPULATED(p_project_id NUMBER) RETURN VARCHAR2;
65 function CHECK_PJI_TEMP_TAB_POPULATED(p_project_id NUMBER) RETURN VARCHAR2;
66
67 -- Bug Fix 5611909
68 -- Added a new procedure to set the globals in order to cache the budget
69 -- version id.
70
71 PROCEDURE set_budget_version_id_global(p_project_id IN NUMBER,
72 p_budget_version_id IN NUMBER);
73
74 end PA_PROJ_STRUCTURE_UTILS;