DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_TIMEKEEPER_PROCESS

Line 54: p_timecard_index_info in out NOCOPY hxc_timekeeper_process.t_timecard_index_info);

50: p_changed in VARCHAR2,
51: p_comment_text in varchar2,
52: p_submit_flg in BOOLEAN,
53: p_application_set_id in hxc_time_building_blocks.application_set_id%type,
54: p_timecard_index_info in out NOCOPY hxc_timekeeper_process.t_timecard_index_info);
55:
56: -------------------------------------------------------------------------------
57: -- this procedure add a attribute in the attribute_table
58: -------------------------------------------------------------------------------

Line 74: p_attribute_index_info in out NOCOPY hxc_timekeeper_process.t_attribute_index_info

70: p_att_5 in varchar2 default NULL,
71: p_att_6 in VARCHAR2 default NULL,
72: p_att_7 in VARCHAR2 default NULL,
73: p_att_8 in varchar2 default NULL,
74: p_attribute_index_info in out NOCOPY hxc_timekeeper_process.t_attribute_index_info
75: );
76: ----------------------------------------------------------------------------
77: --gets attributes data from hxc_time_attributes table
78: ----------------------------------------------------------------------------

Line 87: p_attribute_index_info out NOCOPY hxc_timekeeper_process.t_attribute_index_info

83: p_start_period in date,
84: p_end_period in date,
85: p_attributes out NOCOPY HXC_ATTRIBUTE_TABLE_TYPE,
86: p_add_hours_type_id in number,
87: p_attribute_index_info out NOCOPY hxc_timekeeper_process.t_attribute_index_info
88: );
89: -------------------------------------------------------------------------------
90: --------------DEBUG PROCEDURE--------------------------------------------------
91: -------------------------------------------------------------------------------

Line 93: (p_timekeeper_data IN hxc_timekeeper_process.t_timekeeper_table);

89: -------------------------------------------------------------------------------
90: --------------DEBUG PROCEDURE--------------------------------------------------
91: -------------------------------------------------------------------------------
92: PROCEDURE dump_timkeeper_data
93: (p_timekeeper_data IN hxc_timekeeper_process.t_timekeeper_table);
94: PROCEDURE dump_buffer_table
95: (p_buffer_table hxc_timekeeper_process.t_buffer_table);
96: PROCEDURE dump_resource_tc_table
97: (l_resource_tc_table hxc_timekeeper_process.t_resource_tc_table);

Line 95: (p_buffer_table hxc_timekeeper_process.t_buffer_table);

91: -------------------------------------------------------------------------------
92: PROCEDURE dump_timkeeper_data
93: (p_timekeeper_data IN hxc_timekeeper_process.t_timekeeper_table);
94: PROCEDURE dump_buffer_table
95: (p_buffer_table hxc_timekeeper_process.t_buffer_table);
96: PROCEDURE dump_resource_tc_table
97: (l_resource_tc_table hxc_timekeeper_process.t_resource_tc_table);
98: PROCEDURE dump_timecard
99: (p_timecard in HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO);

Line 97: (l_resource_tc_table hxc_timekeeper_process.t_resource_tc_table);

93: (p_timekeeper_data IN hxc_timekeeper_process.t_timekeeper_table);
94: PROCEDURE dump_buffer_table
95: (p_buffer_table hxc_timekeeper_process.t_buffer_table);
96: PROCEDURE dump_resource_tc_table
97: (l_resource_tc_table hxc_timekeeper_process.t_resource_tc_table);
98: PROCEDURE dump_timecard
99: (p_timecard in HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO);
100: -------------------------------------------------------------------------------
101: --Used to get the attribute category for the detail dff saved in timecard

Line 140: p_attribute_index_info in out NOCOPY hxc_timekeeper_process.t_attribute_index_info);

136: p_att_27 in varchar2,
137: p_att_28 in varchar2,
138: p_att_29 in varchar2,
139: p_att_30 in varchar2 ,
140: p_attribute_index_info in out NOCOPY hxc_timekeeper_process.t_attribute_index_info);
141: PROCEDURE order_building_blocks
142: ( p_timecard in out NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO,
143: p_ord_timecard in out NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO);
144: -------------------------------------------------------------------------------

Line 149: p_insert_detail in hxc_timekeeper_process.t_time_info,

145: -- This procedure used to get which attribute in layout is used to decide the
146: -- attribute category.
147: -------------------------------------------------------------------------------
148: FUNCTION get_TK_dff_attrname(p_tkid number,
149: p_insert_detail in hxc_timekeeper_process.t_time_info,
150: p_base_dff in varchar2,
151: p_att_tab in hxc_alias_utility.t_alias_att_info)
152: return varchar2;
153: -------------------------------------------------------------------------------

Line 254: ,p_insert_data_details IN hxc_timekeeper_process.t_time_info

250: ------------------------------------------------------------------------------------------
251: -- These procedure are moved to make the timekeeper_process package in small program units
252: -----------------------------------------------------------------------------------------
253: Procedure manage_attributes ( p_attribute_number IN NUMBER
254: ,p_insert_data_details IN hxc_timekeeper_process.t_time_info
255: ,p_old_value IN OUT NOCOPY varchar2
256: ,p_new_value IN OUT NOCOPY varchar2
257: );
258: Procedure manage_timeinfo ( p_day_counter IN NUMBER

Line 259: ,p_insert_detail IN hxc_timekeeper_process.t_time_info

255: ,p_old_value IN OUT NOCOPY varchar2
256: ,p_new_value IN OUT NOCOPY varchar2
257: );
258: Procedure manage_timeinfo ( p_day_counter IN NUMBER
259: ,p_insert_detail IN hxc_timekeeper_process.t_time_info
260: ,p_measure IN OUT NOCOPY NUMBER
261: ,p_detail_id IN OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
262: ,p_detail_ovn IN OUT NOCOPY NUMBER
263: ,p_detail_time_in IN OUT NOCOPY DATE

Line 268: ,p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE

264: ,p_detail_time_out IN OUT NOCOPY DATE
265: );
266: Procedure manage_detaildffinfo ( p_detail_id IN hxc_time_building_blocks.time_building_block_id%TYPE
267: ,p_detail_ovn IN NUMBER
268: ,p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE
269: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
270: ,p_attribute_category IN VARCHAR2
271: ,p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference
272: ,p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info

Line 272: ,p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info

268: ,p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE
269: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
270: ,p_attribute_category IN VARCHAR2
271: ,p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference
272: ,p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info
273: ,p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info
274: );
275: PROCEDURE check_msg_set_process_flag
276: ( p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE

Line 273: ,p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info

269: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
270: ,p_attribute_category IN VARCHAR2
271: ,p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference
272: ,p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info
273: ,p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info
274: );
275: PROCEDURE check_msg_set_process_flag
276: ( p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
277: , p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE