1 PACKAGE PJM_INTEGRATION_PROJ_MFG AUTHID CURRENT_USER as
2 /* $Header: PJMVLDTS.pls 115.6 2002/10/29 20:14:30 alaw ship $ */
3
4 FUNCTION PJM_VALIDATE_DATE (P_SCHEDULE_DATE IN DATE
5 ,P_TIME_POINT IN VARCHAR2
6 ,P_PROJECT_ID IN NUMBER
7 ,P_TASK_ID IN NUMBER
8 ,P_TOLERANCE_DAYS IN NUMBER DEFAULT 0
9 ,P_ERROR_MSG OUT NOCOPY VARCHAR2
10 ) return number;
11
12 FUNCTION PJM_EXCEPTION_DAYS(pd_schedule_date IN date
13 ,pc_time_point IN varchar2
14 ,pn_tolerance_days IN number
15 ,pd_project_start_date IN date
16 ,pd_project_end_date IN date
17 ,pd_task_start_date IN date
18 ,pd_task_end_date IN date
19 ) return number;
20
21 FUNCTION PJM_SELECT_PROJECT_MANAGER(pn_project_id IN number
22 ) return varchar2;
23
24 FUNCTION PJM_SELECT_TASK_MANAGER(pn_task_id IN number
25 ) return varchar2;
26
27 PROCEDURE SELECT_DOCUMENT_TYPE(ITEMTYPE IN VARCHAR2
28 ,ITEMKEY IN VARCHAR2
29 ,ACTID IN NUMBER
30 ,FUNCMODE IN VARCHAR2
31 ,RESULTOUT OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE PJM_WF_SEEK_PROJECT_MGR( itemtype in varchar2,
35 itemkey in varchar2,
36 actid in number,
37 funcmode in varchar2,
38 resultout out nocopy varchar2
39 );
40
41 PROCEDURE PJM_WF_SEEK_TASK_MGR( itemtype in varchar2,
42 itemkey in varchar2,
43 actid in number,
44 funcmode in varchar2,
45 resultout out nocopy varchar2
46 );
47
48 END PJM_INTEGRATION_PROJ_MFG;