[Home] [Help]
PACKAGE: APPS.HR_QUA_AWARDS_UTIL_SS
Source
1 PACKAGE hr_qua_awards_util_ss AUTHID CURRENT_USER AS
2 /* $Header: hrquawrs.pkh 115.14 2003/12/19 03:14:48 sgudeti noship $*/
3
4 FORMAT_RRRR_MM_DD varchar2(200) := 'RRRR-MM-DD';
5
6 G_PACKAGE varchar2(50) := 'HR_QUA_AWARDS_UTIL_SS.';
7
8 API_NAME VARCHAR(50) := 'HR_QUA_AWARDS_UTIL_SS.PROCESS_API';
9
10 EDUCATION VARCHAR2(10) := 'EDUCATION';
11
12 AWARDS VARCHAR2(10) := 'AWARDS';
13
14 EDUCATION_CHANGED VARCHAR2(30) := 'EDUCATION_CHANGED';
15
16 AWARD_CHANGED VARCHAR2(30) := 'AWARD_CHANGED';
17
18 PROCEDURE check_errors
19 (p_ignore_sub_date_boundaries in varchar2 default 'N'
20 ,p_mode in varchar2
21 ,p_qualifications in SSHR_QUA_TAB_TYP
22 ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
23 ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
24 ,p_error_message out nocopy varchar2
25 ,p_subjects_error_message out nocopy varchar2);
26
27 PROCEDURE process_api
28 (p_validate in boolean default FALSE
29 ,p_transaction_step_id in number
30 ,p_effective_date in varchar2 default null
31 );
32
33 procedure get_pending_transaction_ids
34 (p_item_type in varchar2
35 ,p_selected_person_id in varchar2
36 ,p_mode in varchar2
37 ,p_process_name in varchar2
38 ,p_activity_name in varchar2
39 ,p_qualifications out nocopy SSHR_QUA_TAB_TYP
40 ,p_qua_attendance out nocopy SSHR_QUA_ATTENDANCE_TAB_TYP
41 ,p_transaction_steps out nocopy SSHR_TRN_TAB_TYP
42 );
43
44 function is_qualification_in_pending
45
46 (
47 p_item_type in varchar2
48 ,p_selected_person_id in varchar2
49 ,p_mode in varchar2
50 ,p_process_name in varchar2
51 ,p_activity_name in varchar2
52 ,p_qualification_id in number
53 )
54 return varchar2;
55
56 PROCEDURE validate_api
57 (p_validate in boolean default TRUE
58 ,p_mode in varchar2
59 ,p_selected_person_id in number
60 ,p_qualifications in SSHR_QUA_TAB_TYP
61 ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
62 ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
63 );
64
65 function decode_value (p_expression in boolean,
66 p_true in varchar2,
67 p_false in varchar2) return varchar2 ;
68
69
70 PROCEDURE save_transaction_step
71 (p_item_type in varchar2 default null
72 ,p_item_key in varchar2 default null
73 ,p_actid in number default null
74 ,p_transaction_step_id in out nocopy number
75 ,p_mode in varchar2
76 ,p_creator_person_id in number
77 ,p_selected_person_id in number
78 ,p_qualifications in SSHR_QUA_TAB_TYP
79 ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
80 ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
81 ,p_proc_call in varchar2);
82
83
84 PROCEDURE validate_qualification
85 (p_validate in VARCHAR2 DEFAULT 'Y'
86 ,p_save_mode in varchar2 default null
87 ,p_mode in varchar2
88 ,p_creator_person_id in number
89 ,p_selected_person_id in number
90 ,p_item_type in varchar2 default null
91 ,p_item_key in varchar2 default null
92 ,p_act_id in varchar2 default null
93 ,p_proc_call in varchar2 default null
94 ,p_error_message in out nocopy varchar2
95 ,p_subjects_error_message in out nocopy varchar2
96 ,p_qualifications in SSHR_QUA_TAB_TYP
97 ,p_qua_subjects in SSHR_QUA_SUBJECT_TAB_TYP
98 ,p_qua_attendance in SSHR_QUA_ATTENDANCE_TAB_TYP
99 );
100
101 Procedure start_transaction(itemtype in varchar2
102 ,itemkey in varchar2
103 ,actid in number
104 ,funmode in varchar2
105 ,p_selected_person_id in number
106 ,p_creator_person_id in number
107 ,result out nocopy varchar2);
108
109 PROCEDURE get_pending_transaction_steps
110 (p_item_type in varchar2
111 ,p_selected_person_id in varchar2
112 ,p_mode in varchar2
113 ,p_process_name in varchar2
114 ,p_activity_name in varchar2
115 ,p_transaction_step_id out nocopy hr_util_misc_web.g_varchar2_tab_type);
116
117
118 PROCEDURE get_entire_qua
119 (p_transaction_step_id in varchar2
120 ,p_mode out nocopy varchar2
121 ,p_qualifications out nocopy SSHR_QUA_TAB_TYP
122 ,p_qua_subjects out nocopy SSHR_QUA_SUBJECT_TAB_TYP
123 ,p_qua_attendance out nocopy SSHR_QUA_ATTENDANCE_TAB_TYP
124 );
125
126 Procedure rollback_transaction_step
127 ( p_transaction_step_id varchar2
128 );
129
130 Function get_qualification_id ( p_transaction_step_id number )
131 return Number;
132
133 Procedure delete_transaction_step ( p_transaction_step_id in number,
134 p_creator_person_id in number );
135
136
137 END hr_qua_awards_util_ss;