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
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
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,
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
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
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