1 PACKAGE HR_COMP_OUTCOME_PROFILE_SS AS
2 /* $Header: hrcorwrs.pkh 120.0 2005/05/30 23:23:14 appldev noship $ */
3 --
4 API_NAME CONSTANT VARCHAR(50) := 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API';
5
6 OUTCOME_CHANGED constant VARCHAR2(30) := 'OUTCOME_CHANGED';
7 NEXT constant VARCHAR2(10) := 'NEXT';
8
9
10 TYPE transaction_row IS RECORD
11 (param_name VARCHAR2(200)
12 ,param_value LONG
13 ,param_data_type VARCHAR2(200));
14
15 TYPE transaction_table1 IS TABLE OF transaction_row INDEX BY BINARY_INTEGER;
16
17 g_api_name constant varchar2(50) := 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API';
18 g_date_format CONSTANT varchar2(15) := 'RRRR-MM-DD';
19
20 g_upd_mode constant varchar2(30) := 'CORRECT';
21
22 -- Exceptions
23 g_fatal_error exception;
24 g_data_err exception;
25 g_access_violation_err exception;
26
27 -- ---------------------------------------------------------------------------
28 -- ---------------------------- < process_api > ------------------------------
29 -- ---------------------------------------------------------------------------
30 -- Purpose: This procedure reads the data from transaction table and saves it
31 -- to the database.
32 -- This procedure is called after Workflow Approval or the user
33 -- chooses "Update" without approval in workflow. from
34 -- hr_comp_profile_ss.process_api
35 -- ---------------------------------------------------------------------------
36 Procedure process_api(
37 p_validate in boolean default false
38 ,p_transaction_step_id in number
39 ,p_competence_element_id in number
40 ,p_effective_date in varchar2 default null);
41
42 Procedure call_process_api (
43 p_validate in boolean default false
44 ,p_competence_element_id IN number
45 ,p_new_competence_element_id IN number
46 ,p_competence_id IN number
47 ,p_item_type IN hr_api_transaction_steps.item_type%type
48 ,p_item_key IN hr_api_transaction_steps.item_key%type
49 ,p_activity_id IN hr_api_transaction_steps.ACTIVITY_ID%TYPE
50 ,p_person_id IN NUMBER
51 ,p_effective_date IN date DEFAULT trunc(sysdate));
52
53 Procedure api_validate_com_out_rec_ss (
54 p_item_type in varchar2
55 ,p_item_key in varchar2
56 ,p_activity_id in varchar2
57 ,p_validate in varchar2
58 ,p_change_mode in varchar2 default null
59 ,p_comp_element_outcome_id in varchar2 default null
60 ,p_competence_element_id in varchar2 default null
61 ,p_competence_id in varchar2 default null
62 ,p_preupd_obj_vers_num in number default null
63 ,p_outcome_id in number default null
64 ,p_date_from in varchar2 default null
65 ,p_date_to in varchar2 default null
66 ,p_transaction_step_id in out nocopy varchar2
67 ,p_comp_from_date IN VARCHAR2 DEFAULT null
68 ,p_comp_to_date IN VARCHAR2 DEFAULT null
69 ,p_person_id IN VARCHAR2 DEFAULT null
70 ,p_error_message out nocopy long);
71
72
73 PROCEDURE save_transaction_step
74 (p_item_type IN VARCHAR2
75 ,p_item_key IN VARCHAR2
76 ,p_actid IN NUMBER
77 ,p_login_person_id IN NUMBER
78 ,p_transaction_step_id IN OUT NOCOPY NUMBER
79 ,p_api_name IN VARCHAR2 default null
80 ,p_api_display_name IN VARCHAR2 DEFAULT NULL
81 ,p_transaction_data IN TRANSACTION_TABLE1);
82
83 --
84 PROCEDURE delete_transaction_step_id
85 (p_transaction_step_id IN number);
86
87 --
88
89 PROCEDURE delete_all_ids
90 (p_item_type in varchar2
91 ,p_item_key in varchar2);
92
93 --
94
95
96 --
97 Procedure delete_add_page
98 (p_transaction_step_id in number);
99 --
100
101
102 PROCEDURE mark_for_delete
103 (p_item_type in varchar2
104 ,p_item_key in varchar2
105 ,p_activity_id in varchar2
106 ,p_comp_element_outcome_id in number
107 ,p_transaction_step_id in varchar2 default null
108 ,p_error_message OUT NOCOPY long);
109
110 Procedure check_if_cmptnce_rec_changed
111 (p_item_type IN varchar2
112 ,p_item_key IN varchar2
113 ,p_activity_id IN varchar2
114 ,p_pid in number
115 ,p_competence_element_id in number
116 ,p_competence_id in number
117 ,p_rec_changed out nocopy boolean);
118
119 Procedure delete(p_validate in boolean default false
120 ,p_transaction_step_id in number
121 ,p_effective_date in varchar2 default null);
122
123 Procedure process_api(
124 p_validate in boolean default false
125 ,p_transaction_step_id in number
126 ,p_effective_date in varchar2 default null);
127
128 Procedure del_correct_rec(
129 p_item_type IN varchar2
130 ,p_item_key IN varchar2
131 ,p_activity_id IN varchar2
132 ,p_competence_element_id in number);
133
134 End hr_comp_outcome_profile_ss;