[Home] [Help]
PACKAGE: APPS.AP_WEB_DB_PA_INT_PKG
Source
1 PACKAGE AP_WEB_DB_PA_INT_PKG AS
2 /* $Header: apwdbpas.pls 120.6 2005/11/04 19:16:11 skoukunt noship $ */
3
4 /*PA Projects */
5 ---------------------------------------------------------------------------------------------------
6 SUBTYPE proj_projNum IS PA_PROJECTS_EXPEND_V.project_number%TYPE;
7 SUBTYPE proj_projID IS PA_PROJECTS_EXPEND_V.project_id%TYPE;
8 SUBTYPE proj_projName IS PA_PROJECTS_EXPEND_V.project_name%TYPE;
9 ---------------------------------------------------------------------------------------------------
10
11 /*PA Tasks */
12 ---------------------------------------------------------------------------------------------------
13 SUBTYPE tasks_projID IS PA_TASKS_EXPEND_V.project_id%TYPE;
14 SUBTYPE tasks_taskID IS PA_TASKS_EXPEND_V.task_id%TYPE;
15 SUBTYPE tasks_taskNum IS PA_TASKS_EXPEND_V.task_number%TYPE;
16 SUBTYPE tasks_taskName IS PA_TASKS_EXPEND_V.task_name%TYPE;
17 ---------------------------------------------------------------------------------------------------
18
19 -------------------------------------------------------------------
20 FUNCTION GetProjectInfo(
21 p_project_number IN proj_projNum,
22 p_project_id OUT NOCOPY proj_projID,
23 p_project_name OUT NOCOPY proj_projName
24 ) RETURN BOOLEAN;
25
26 -------------------------------------------------------------------
27 FUNCTION GetTaskInfo(
28 p_task_num IN tasks_taskNum,
29 p_proj_id IN tasks_projID,
30 p_task_id OUT NOCOPY tasks_taskID,
31 p_task_name OUT NOCOPY tasks_taskName
32 ) RETURN BOOLEAN;
33
34 -------------------------------------------------------------------
35 FUNCTION GetProjectNumber(
36 p_project_id IN proj_projID,
37 p_project_number OUT NOCOPY proj_projNum
38 ) RETURN BOOLEAN;
39
40 -------------------------------------------------------------------
41 FUNCTION GetTaskIDByProjID(
42 p_project_id IN tasks_projID,
43 p_task_id OUT NOCOPY tasks_taskID
44 ) RETURN BOOLEAN;
45
46 --------------------------------------------------------------------------------
47 FUNCTION GetTaskId(
48 p_task_num IN tasks_taskNum,
49 p_proj_id IN tasks_projID,
50 p_task_id OUT NOCOPY tasks_taskID
51 ) RETURN BOOLEAN;
52
53 -------------------------------------------------------------------
54 FUNCTION GetProjectID(
55 p_project_number IN proj_projNum,
56 p_project_id OUT NOCOPY proj_projID
57 ) RETURN BOOLEAN;
58
59 -------------------------------------------------------------------
60 FUNCTION GetProjectNumber(
61 p_project_id IN proj_projID
62 ) RETURN VARCHAR2;
63
64 -------------------------------------------------------------------
65 FUNCTION GetProjectInfo(
66 p_project_id IN proj_projID,
67 p_project_number OUT NOCOPY proj_projNum,
68 p_project_name OUT NOCOPY proj_projName
69 ) RETURN BOOLEAN;
70
71 -------------------------------------------------------------------
72
73 END AP_WEB_DB_PA_INT_PKG;
74