PACKAGE: APPS.PA_COMP_PROFILE_PVT

Source

1 PACKAGE PA_COMP_PROFILE_PVT AUTHID CURRENT_USER AS
2 -- $Header: PARPRFVS.pls 120.1 2005/08/19 16:59:07 mwasowic noship $
3 
4 g_noof_errors  NUMBER := 0;
5 PROCEDURE Add_competence_element
6 ( p_person_id	    IN per_competence_elements.person_id%TYPE,
7 p_competence_id	    IN per_competences.competence_id%TYPE,
8 p_rating_level_id   IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
9 p_effective_date_from   IN DATE,
10 p_commit	    IN VARCHAR2 := FND_API.G_MISS_CHAR,
11 p_validate_only	    IN VARCHAR2 := FND_API.G_MISS_CHAR,
12 p_init_msg_list	    IN VARCHAR2 := FND_API.G_FALSE,
13 x_return_status	    OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
14 
15 PROCEDURE Update_competence_element
16 (p_person_id       IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM ,
17  p_competence_id   IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18  p_element_id	   IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
19  p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20  p_effective_date_from   IN DATE,
21  p_commit	         IN VARCHAR2 := FND_API.G_MISS_CHAR,
22  p_validate_only         IN VARCHAR2 := FND_API.G_MISS_CHAR,
23  p_init_msg_list         IN VARCHAR2 := FND_API.G_FALSE,
24  p_object_version_number IN NUMBER,
25  x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
26  x_return_status         OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
27 
28 Procedure delete_competence_element
29           ( p_person_id             IN NUMBER,
30             p_competence_id         IN NUMBER,
31             p_element_id            IN NUMBER,
32             p_object_version_number IN NUMBER,
33             p_commit	            IN VARCHAR2 := FND_API.G_MISS_CHAR,
34             x_return_status        OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
35 
36 PROCEDURE Check_Object_version_number
37    (p_element_id  IN per_competence_elements.competence_element_id%TYPE,
38     p_object_version_number IN  NUMBER,
39     x_return_status         OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40     x_error_message_code    OUT NOCOPY VARCHAR2)  ; --File.Sql.39 bug 4440895
41 
42 Procedure Start_Approval_Process
43 (x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
44  x_msg_count     OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
45  x_msg_data      OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
46 
47 PROCEDURE Check_Error
48 (p_return_status      IN VARCHAR2,
49  p_error_message_code IN VARCHAR2);
50 
51 PROCEDURE Update_HR
52 (p_profile_id    IN  NUMBER,
53  x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
54  x_msg_count     OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
55  x_msg_data      OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
56 
57 Procedure Approval_Message_Body
58 (document_id   in varchar2,
59 display_type   in varchar2,
60 document       in out NOCOPY varchar2,  --File.Sql.39 bug 4440895
61 document_type  in out NOCOPY varchar2); --File.Sql.39 bug 4440895
62 
63 Procedure Clear_Temp_Table
64 (p_profile_id    IN NUMBER,
65 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
66 x_msg_count     OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
67 x_msg_data      OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
68 
69 end PA_COMP_PROFILE_PVT ;