[Home] [Help]
PACKAGE: APPS.PA_COMP_PROFILE_PUB
Source
1 PACKAGE PA_COMP_PROFILE_PUB AUTHID CURRENT_USER AS
2 -- $Header: PARPRFPS.pls 120.1 2005/08/19 16:59:02 mwasowic noship $
3
4 PROCEDURE Add_competence_element
5 (
6 p_person_id IN per_competence_elements.person_id%TYPE,
7 p_competence_id IN per_competences.competence_id%TYPE,
8 p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
9 p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
10 p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
11 p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
12 p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
13 p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
14 p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
15 p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
16 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
18 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
19
20 PROCEDURE Update_competence_element
21 (
22 p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
23 p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
24 p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25 p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26 p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27 p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28 p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29 p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
30 p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
31 p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
32 p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
33 p_object_version_number IN NUMBER,
34 x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
35 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
37 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
38
39 Procedure Start_Approval_Process
40 (x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
41 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
42 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
43
44 PROCEDURE delete_competence_element
45 (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
46 p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
47 p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
51 p_object_version_number IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
53 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
54 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
55
56 PROCEDURE Update_HR(
57 itemtype in varchar2,
58 itemkey in varchar2,
59 actid in number,
60 funcmode in varchar2,
61 resultout in out NOCOPY varchar2); --File.Sql.39 bug 4440895
62
63 PROCEDURE Clear_Temp_Table(
64 itemtype in varchar2,
65 itemkey in varchar2,
66 actid in number,
67 funcmode in varchar2,
68 resultout in out NOCOPY varchar2); --File.Sql.39 bug 4440895
69
70 PROCEDURE approval_message_body (
71 document_id in varchar2,
72 display_type in varchar2,
73 document in out NOCOPY varchar2, --File.Sql.39 bug 4440895
74 document_type in out NOCOPY varchar2) ; --File.Sql.39 bug 4440895
75
76 g_person_id NUMBER := 0;
77 g_assignment_id NUMBER := 0;
78
79 Procedure Set_Person(p_person_id IN NUMBER);
80 Procedure Set_Assignment(p_assignment_id IN NUMBER);
81
82 Function Get_Select_Flag(p_competence_id IN NUMBER)
83 RETURN VARCHAR2;
84
85 Procedure get_user_info(p_user_id IN VARCHAR2,
86 x_Person_id OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
87 x_Resource_id OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88 x_resource_name OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
89
90 Procedure get_user_info(p_user_id IN VARCHAR2,
91 x_Person_id OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
92 x_Resource_id OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
93
94 FUNCTION Get_person_business_group
95 (P_Person_id IN NUMBER
96 )
97 RETURN NUMBER;
98
99 end PA_COMP_PROFILE_PUB ;