1 PACKAGE OKE_PA_CHECKS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKEPPACS.pls 115.4 2002/11/20 20:37:34 who ship $ */
3
4 -- GLOBAL VARIABLES
5
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_PA_CHECKS_PUB';
7 G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
8
9 --
10 -- Name : Project_Used
11 -- Function : This function checks if a certain project is used by OKE
12 --
13 -- Parameters :
14 -- IN : Project_ID NUMBER
15 --
16 -- OUT : X_Result VARCHAR2 ( 'Y' 'N' )
17
18
19
20 PROCEDURE Project_Used
21 ( p_api_version IN NUMBER
22 , p_commit IN VARCHAR2 := FND_API.G_FALSE
23 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24 , x_msg_count OUT NOCOPY NUMBER
25 , x_msg_data OUT NOCOPY VARCHAR2
26 , x_return_status OUT NOCOPY VARCHAR2
27 , Project_ID IN NUMBER
28 , X_Result OUT NOCOPY VARCHAR2
29 );
30
31
32 --
33 -- Name : Task_Used
34 -- Function : This function checks if a certain task is used by OKE
35 --
36 -- Parameters :
37 -- IN : Task_ID NUMBER
38 --
39 -- OUT : X_Result VARCHAR2 ( 'Y' 'N' )
40
41
42 PROCEDURE Task_Used
43 ( p_api_version IN NUMBER
44 , p_commit IN VARCHAR2 := FND_API.G_FALSE
45 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
46 , x_msg_count OUT NOCOPY NUMBER
47 , x_msg_data OUT NOCOPY VARCHAR2
48 , x_return_status OUT NOCOPY VARCHAR2
49 , Task_ID IN NUMBER
50 , X_Result OUT NOCOPY VARCHAR2
51 );
52
53
54
55 --
56 -- Name : Disassociation_Allowed
57 -- Function : This function checks if a certain project(To_Project_ID)
58 -- can be disassociatied from
59 -- a task(From_Project_ID,From_Task_ID)
60 --
61 -- Parameters :
62 -- IN : From_Project_ID NUMBER
63 -- From_Task_ID NUMBER
64 -- To_Project_ID NUMBER
65 -- OUT : X_Result VARCHAR2 ( 'Y' 'N' )
66 --
67
68
69
70 PROCEDURE Disassociation_Allowed
71 ( p_api_version IN NUMBER
72 , p_commit IN VARCHAR2 := FND_API.G_FALSE
73 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
74 , x_msg_count OUT NOCOPY NUMBER
75 , x_msg_data OUT NOCOPY VARCHAR2
76 , x_return_status OUT NOCOPY VARCHAR2
77 , From_Project_ID IN NUMBER
78 , From_Task_ID IN NUMBER
79 , To_Project_ID IN NUMBER
80 , X_Result OUT NOCOPY VARCHAR2
81 );
82
83
84
85 END OKE_PA_CHECKS_PUB;