DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_SELF_SERVICE_TIME_DEPOSIT

Line 326: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info,

322:
323: --this function returns all the attributes associated with the detail blocks
324: PROCEDURE get_detail_attributes(
325: p_detail_blocks IN block_table,
326: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info,
327: p_new_detail_attributes IN OUT NOCOPY hxc_attribute_table_type
328: )
329:
330: IS

Line 333: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;

329:
330: IS
331: l_attribute_index PLS_INTEGER := 1;
332: l_new_attributes hxc_attribute_table_type := hxc_attribute_table_type ();
333: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;
334: l_block_index PLS_INTEGER;
335:
336: CURSOR c_block_attributes(
337: p_detail_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 603: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

599: END no_blocks;
600:
601: FUNCTION changed(
602: p_detail_blocks IN OUT NOCOPY block_table
603: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
604: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
605: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
606: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
607: )

Line 774: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

770:
771:
772: FUNCTION is_empty(
773: p_detail_blocks IN OUT NOCOPY block_table
774: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
775: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
776: )
777: RETURN BOOLEAN
778: IS

Line 817: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

813:
814:
815: PROCEDURE link_ap_details(
816: p_detail_blocks IN OUT NOCOPY block_table
817: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
818: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
819: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
820: )
821: IS

Line 2048: ,p_detail_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

2044: ,p_approval_comp IN approval_comp
2045: ,p_tc_resubmitted IN VARCHAR2
2046: -- ,p_first IN VARCHAR2
2047: ,p_detail_blocks IN OUT NOCOPY block_table
2048: ,p_detail_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
2049: )
2050: IS
2051:
2052: CURSOR c_app_period(

Line 2981: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;

2977: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.create_appl_period_info';
2978:
2979: --
2980: l_detail_blocks block_table;
2981: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;
2982:
2983: l_new_detail_blocks hxc_block_table_type := hxc_block_table_type ();
2984: l_new_detail_attributes hxc_attribute_table_type := hxc_attribute_table_type ();
2985:

Line 4726: ,p_error_table OUT NOCOPY hxc_self_service_time_deposit.message_table

4722: ,p_item_key IN varchar2
4723: ,p_tc_bb_id IN number
4724: ,p_tc_ovn IN number
4725: ,p_tc_resubmitted IN varchar2
4726: ,p_error_table OUT NOCOPY hxc_self_service_time_deposit.message_table
4727: ,p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
4728: ,p_time_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
4729: ,p_bb_new IN varchar2)
4730: is

Line 4727: ,p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info

4723: ,p_tc_bb_id IN number
4724: ,p_tc_ovn IN number
4725: ,p_tc_resubmitted IN varchar2
4726: ,p_error_table OUT NOCOPY hxc_self_service_time_deposit.message_table
4727: ,p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
4728: ,p_time_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
4729: ,p_bb_new IN varchar2)
4730: is
4731: --

Line 4728: ,p_time_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

4724: ,p_tc_ovn IN number
4725: ,p_tc_resubmitted IN varchar2
4726: ,p_error_table OUT NOCOPY hxc_self_service_time_deposit.message_table
4727: ,p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
4728: ,p_time_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
4729: ,p_bb_new IN varchar2)
4730: is
4731: --
4732: --

Line 5027: l_message_table hxc_self_service_time_deposit.message_table;

5023: l_time_recipient varchar2(150);
5024: l_ext_func1 varchar2(2000);
5025: l_auto_approval_flag varchar2(1);
5026: l_message varchar2(2000);
5027: l_message_table hxc_self_service_time_deposit.message_table;
5028: l_func_sql varchar2(2000);
5029: l_app_bld_blk_id number;
5030: l_app_ovn number;
5031: l_token_table hxc_deposit_wrapper_utilities.t_simple_table;

Line 5085: hxc_self_service_time_deposit.get_timecard_tables(

5081: end if;
5082: --
5083: -- Sets up global variables for timecard records.
5084: --
5085: hxc_self_service_time_deposit.get_timecard_tables(
5086: p_timecard_id => l_tc_bld_blk_id
5087: ,p_timecard_ovn => l_tc_ovn
5088: ,p_timecard_blocks => g_time_building_blocks
5089: ,p_timecard_app_attributes => g_time_app_attributes

Line 5829: l_error_table hxc_self_service_time_deposit.message_table;

5825: l_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype;
5826: l_outputs ff_exec.outputs_t;
5827: l_result varchar2(1000);
5828: --
5829: l_error_table hxc_self_service_time_deposit.message_table;
5830: l_mapping_changed boolean;
5831: l_bld_blk_changed boolean;
5832: l_changed varchar2(10);
5833: l_cnt number;