DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_SELF_SERVICE_TIME_DEPOSIT

Line 203: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info,

199:
200: --this function returns all the attributes associated with the detail blocks
201: PROCEDURE get_detail_attributes(
202: p_detail_blocks IN block_table,
203: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info,
204: p_new_detail_attributes IN OUT NOCOPY hxc_attribute_table_type
205: )
206:
207: IS

Line 210: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;

206:
207: IS
208: l_attribute_index PLS_INTEGER := 1;
209: l_new_attributes hxc_attribute_table_type := hxc_attribute_table_type ();
210: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;
211: l_block_index PLS_INTEGER;
212:
213: CURSOR c_block_attributes(
214: p_detail_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 451: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

447: END no_blocks;
448:
449: FUNCTION changed(
450: p_detail_blocks IN OUT NOCOPY block_table
451: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
452: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
453: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
454: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
455: )

Line 622: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

618:
619:
620: FUNCTION is_empty(
621: p_detail_blocks IN OUT NOCOPY block_table
622: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
623: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
624: )
625: RETURN BOOLEAN
626: IS

Line 665: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

661:
662:
663: PROCEDURE link_ap_details(
664: p_detail_blocks IN OUT NOCOPY block_table
665: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
666: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
667: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
668: )
669: IS

Line 1869: ,p_detail_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

1865: ,p_approval_comp IN approval_comp
1866: ,p_tc_resubmitted IN VARCHAR2
1867: -- ,p_first IN VARCHAR2
1868: ,p_detail_blocks IN OUT NOCOPY block_table
1869: ,p_detail_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
1870: )
1871: IS
1872:
1873: CURSOR c_app_period(

Line 2633: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;

2629: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.create_appl_period_info';
2630:
2631: --
2632: l_detail_blocks block_table;
2633: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;
2634:
2635: l_new_detail_blocks hxc_block_table_type := hxc_block_table_type ();
2636: l_new_detail_attributes hxc_attribute_table_type := hxc_attribute_table_type ();
2637:

Line 4074: ,p_error_table OUT NOCOPY hxc_self_service_time_deposit.message_table

4070: ,p_item_key IN varchar2
4071: ,p_tc_bb_id IN number
4072: ,p_tc_ovn IN number
4073: ,p_tc_resubmitted IN varchar2
4074: ,p_error_table OUT NOCOPY hxc_self_service_time_deposit.message_table
4075: ,p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
4076: ,p_time_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
4077: ,p_bb_new IN varchar2)
4078: is

Line 4075: ,p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info

4071: ,p_tc_bb_id IN number
4072: ,p_tc_ovn IN number
4073: ,p_tc_resubmitted IN varchar2
4074: ,p_error_table OUT NOCOPY hxc_self_service_time_deposit.message_table
4075: ,p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
4076: ,p_time_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
4077: ,p_bb_new IN varchar2)
4078: is
4079: --

Line 4076: ,p_time_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

4072: ,p_tc_ovn IN number
4073: ,p_tc_resubmitted IN varchar2
4074: ,p_error_table OUT NOCOPY hxc_self_service_time_deposit.message_table
4075: ,p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
4076: ,p_time_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
4077: ,p_bb_new IN varchar2)
4078: is
4079: --
4080: --

Line 4340: l_message_table hxc_self_service_time_deposit.message_table;

4336: l_time_recipient varchar2(150);
4337: l_ext_func1 varchar2(2000);
4338: l_auto_approval_flag varchar2(1);
4339: l_message varchar2(2000);
4340: l_message_table hxc_self_service_time_deposit.message_table;
4341: l_func_sql varchar2(2000);
4342: l_app_bld_blk_id number;
4343: l_app_ovn number;
4344: l_token_table hxc_deposit_wrapper_utilities.t_simple_table;

Line 4398: hxc_self_service_time_deposit.get_timecard_tables(

4394: end if;
4395: --
4396: -- Sets up global variables for timecard records.
4397: --
4398: hxc_self_service_time_deposit.get_timecard_tables(
4399: p_timecard_id => l_tc_bld_blk_id
4400: ,p_timecard_ovn => l_tc_ovn
4401: ,p_timecard_blocks => g_time_building_blocks
4402: ,p_timecard_app_attributes => g_time_app_attributes

Line 5142: l_error_table hxc_self_service_time_deposit.message_table;

5138: l_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype;
5139: l_outputs ff_exec.outputs_t;
5140: l_result varchar2(1000);
5141: --
5142: l_error_table hxc_self_service_time_deposit.message_table;
5143: l_mapping_changed boolean;
5144: l_bld_blk_changed boolean;
5145: l_changed varchar2(10);
5146: l_cnt number;