112: -- gets the timecard info for a given TCO passed from the SS timecard
113: -- (see r_timecard_info TYPE defined above for what timecard info is retrieved)
114:
115: PROCEDURE get_timecard_info (
116: p_time_building_blocks hxc_self_service_time_deposit.timecard_info
117: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
118: , p_timecard_rec IN OUT NOCOPY r_timecard_info );
119:
120: -- public procedure
113: -- (see r_timecard_info TYPE defined above for what timecard info is retrieved)
114:
115: PROCEDURE get_timecard_info (
116: p_time_building_blocks hxc_self_service_time_deposit.timecard_info
117: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
118: , p_timecard_rec IN OUT NOCOPY r_timecard_info );
119:
120: -- public procedure
121: -- get_timecard_info
124: -- overloaded version of above procedure which does not use
125: -- the time attributes table - in this case the bg_id will not be populated.
126:
127: PROCEDURE get_timecard_info (
128: p_time_building_blocks hxc_self_service_time_deposit.timecard_info
129: , p_timecard_rec IN OUT NOCOPY r_timecard_info );
130:
131:
132: -- public procedure
182: , p_periods_tab IN OUT NOCOPY t_period );
183:
184:
185: PROCEDURE add_error_to_table (
186: p_message_table in out nocopy HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
187: , p_message_name in FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
188: , p_message_token in VARCHAR2
189: , p_message_level in VARCHAR2
190: , p_message_field in VARCHAR2
226: --
227:
228: PROCEDURE execute_time_entry_rules (
229: p_operation VARCHAR2
230: , p_time_building_blocks hxc_self_service_time_deposit.timecard_info
231: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
232: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
233: , p_resubmit VARCHAR2
234: , p_blocks hxc_block_table_type
227:
228: PROCEDURE execute_time_entry_rules (
229: p_operation VARCHAR2
230: , p_time_building_blocks hxc_self_service_time_deposit.timecard_info
231: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
232: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
233: , p_resubmit VARCHAR2
234: , p_blocks hxc_block_table_type
235: , p_attributes hxc_attribute_table_type );
228: PROCEDURE execute_time_entry_rules (
229: p_operation VARCHAR2
230: , p_time_building_blocks hxc_self_service_time_deposit.timecard_info
231: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
232: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
233: , p_resubmit VARCHAR2
234: , p_blocks hxc_block_table_type
235: , p_attributes hxc_attribute_table_type );
236:
396:
397: FUNCTION calc_timecard_hrs (
398: p_hrs_period_start DATE
399: , p_hrs_period_end DATE
400: , p_tco_bb hxc_self_service_time_deposit.timecard_info
401: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info )
402: RETURN NUMBER;
403:
404: FUNCTION calc_timecard_hrs (
397: FUNCTION calc_timecard_hrs (
398: p_hrs_period_start DATE
399: , p_hrs_period_end DATE
400: , p_tco_bb hxc_self_service_time_deposit.timecard_info
401: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info )
402: RETURN NUMBER;
403:
404: FUNCTION calc_timecard_hrs (
405: p_hrs_period_start DATE
403:
404: FUNCTION calc_timecard_hrs (
405: p_hrs_period_start DATE
406: , p_hrs_period_end DATE
407: , p_tco_bb hxc_self_service_time_deposit.timecard_info
408: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info
409: , p_time_category_name VARCHAR2 )
410: RETURN NUMBER;
411:
404: FUNCTION calc_timecard_hrs (
405: p_hrs_period_start DATE
406: , p_hrs_period_end DATE
407: , p_tco_bb hxc_self_service_time_deposit.timecard_info
408: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info
409: , p_time_category_name VARCHAR2 )
410: RETURN NUMBER;
411:
412: FUNCTION calc_timecard_hrs (
411:
412: FUNCTION calc_timecard_hrs (
413: p_hrs_period_start DATE
414: , p_hrs_period_end DATE
415: , p_tco_bb hxc_self_service_time_deposit.timecard_info
416: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info
417: , p_time_category_id NUMBER )
418: RETURN NUMBER;
419:
412: FUNCTION calc_timecard_hrs (
413: p_hrs_period_start DATE
414: , p_hrs_period_end DATE
415: , p_tco_bb hxc_self_service_time_deposit.timecard_info
416: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info
417: , p_time_category_id NUMBER )
418: RETURN NUMBER;
419:
420: FUNCTION chk_pto_plan ( p_assignment_id NUMBER
423: RETURN NUMBER;
424:
425: PROCEDURE EXECUTE_ELP_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS HXC_BLOCK_TABLE_TYPE
426: ,P_TIME_ATTRIBUTES HXC_ATTRIBUTE_TABLE_TYPE
427: ,P_MESSAGES in out NOCOPY hxc_self_service_time_deposit.MESSAGE_TABLE
428: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER);
429:
430: PROCEDURE EXECUTE_CLA_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS hxc_self_service_time_deposit.timecard_info
431: ,P_TIME_ATTRIBUTES hxc_self_service_time_deposit.building_block_attribute_info
426: ,P_TIME_ATTRIBUTES HXC_ATTRIBUTE_TABLE_TYPE
427: ,P_MESSAGES in out NOCOPY hxc_self_service_time_deposit.MESSAGE_TABLE
428: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER);
429:
430: PROCEDURE EXECUTE_CLA_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS hxc_self_service_time_deposit.timecard_info
431: ,P_TIME_ATTRIBUTES hxc_self_service_time_deposit.building_block_attribute_info
432: ,P_MESSAGES in out NOCOPY hxc_self_service_time_deposit.MESSAGE_TABLE
433: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER);
434:
427: ,P_MESSAGES in out NOCOPY hxc_self_service_time_deposit.MESSAGE_TABLE
428: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER);
429:
430: PROCEDURE EXECUTE_CLA_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS hxc_self_service_time_deposit.timecard_info
431: ,P_TIME_ATTRIBUTES hxc_self_service_time_deposit.building_block_attribute_info
432: ,P_MESSAGES in out NOCOPY hxc_self_service_time_deposit.MESSAGE_TABLE
433: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER);
434:
435: Type t_change_att_rec is record
428: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER);
429:
430: PROCEDURE EXECUTE_CLA_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS hxc_self_service_time_deposit.timecard_info
431: ,P_TIME_ATTRIBUTES hxc_self_service_time_deposit.building_block_attribute_info
432: ,P_MESSAGES in out NOCOPY hxc_self_service_time_deposit.MESSAGE_TABLE
433: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER);
434:
435: Type t_change_att_rec is record
436: ( attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,