[Home] [Help]
1: package body PER_ABSENCE_ATTENDANCES_PKG2 as
2: /* $Header: peaba02t.pkb 115.3 2002/12/11 12:17:33 raranjan ship $ */
3:
4: --this procedure was written as a workaround. For some reason the
5: --hr_entry_api procedure cannot be directly called from the form
6: --therefore requiring that this server side procedure be written as
7: --an interface between the two. The problem seems to be the interfacing
8: --between forms and the server side code. It could be the differing
9: --versions of PLSQL in use between forms and the server, the large number of
49: open c_get_element_type;
50: fetch c_get_element_type into l_element_type_id;
51: close c_get_element_type;
52:
53: l_element_link_id := hr_entry_api.get_link
54: (p_assignment_id => p_assignment_id
55: ,p_element_type_id => l_element_type_id
56: ,p_session_date => l_eff_start_date);
57:
54: (p_assignment_id => p_assignment_id
55: ,p_element_type_id => l_element_type_id
56: ,p_session_date => l_eff_start_date);
57:
58: hr_entry_api.insert_element_entry(p_effective_start_date => l_eff_start_date,
59: p_effective_end_date => l_eff_end_date,
60: p_element_entry_id => p_element_entry_id,
61: p_assignment_id => p_assignment_id,
62: p_element_link_id => l_element_link_id,
69:
70:
71:
72: --this procedure was written as a workaround. For some reason the
73: --hr_entry_api procedure cannot be directly called from the form
74: --therefore requiring that this server side procedure be written as
75: --an interface between the two. The problem seems to be the interfacing
76: --between forms and the server side code. It could be the differing
77: --versions of PLSQL in use between forms and the server, the large number of
85: p_input_value_id1 IN NUMBER,
86: p_entry_value1 IN VARCHAR2) is
87:
88: begin
89: hr_entry_api.update_element_entry(p_dt_update_mode => p_dt_update_mode,
90: p_session_date => p_session_date,
91: p_element_entry_id =>
92: p_element_entry_id,
93: p_creator_id => p_creator_id,