DBA Data[Home] [Help]

APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on HXC_SELF_SERVICE_TIME_DEPOSIT

Line 987: (p_blocks IN hxc_self_service_time_deposit.timecard_info)

983: END get_preferences;
984:
985:
986: FUNCTION blocks_to_string
987: (p_blocks IN hxc_self_service_time_deposit.timecard_info)
988: RETURN VARCHAR2 IS
989:
990: l_block_count NUMBER := 0;
991: l_block_string VARCHAR2(32767) := '';

Line 1113: RETURN hxc_self_service_time_deposit.timecard_info IS

1109: END blocks_to_string;
1110:
1111: FUNCTION string_to_blocks
1112: (p_block_string IN varchar2)
1113: RETURN hxc_self_service_time_deposit.timecard_info IS
1114:
1115: l_blocks hxc_self_service_time_deposit.timecard_info;
1116: l_blocks2 hxc_self_service_time_deposit.timecard_info;
1117: l_block_count NUMBER :=1;

Line 1115: l_blocks hxc_self_service_time_deposit.timecard_info;

1111: FUNCTION string_to_blocks
1112: (p_block_string IN varchar2)
1113: RETURN hxc_self_service_time_deposit.timecard_info IS
1114:
1115: l_blocks hxc_self_service_time_deposit.timecard_info;
1116: l_blocks2 hxc_self_service_time_deposit.timecard_info;
1117: l_block_count NUMBER :=1;
1118: l_value_index NUMBER :=1;
1119: l_proc VARCHAR2(30) := 'STRING_TO_BLOCKS';

Line 1116: l_blocks2 hxc_self_service_time_deposit.timecard_info;

1112: (p_block_string IN varchar2)
1113: RETURN hxc_self_service_time_deposit.timecard_info IS
1114:
1115: l_blocks hxc_self_service_time_deposit.timecard_info;
1116: l_blocks2 hxc_self_service_time_deposit.timecard_info;
1117: l_block_count NUMBER :=1;
1118: l_value_index NUMBER :=1;
1119: l_proc VARCHAR2(30) := 'STRING_TO_BLOCKS';
1120:

Line 1330: (p_attributes IN hxc_self_service_time_deposit.app_attributes_info)

1326:
1327: END string_to_blocks;
1328:
1329: FUNCTION attributes_to_string
1330: (p_attributes IN hxc_self_service_time_deposit.app_attributes_info)
1331: RETURN VARCHAR2 IS
1332:
1333: l_attribute_string VARCHAR2(32767);
1334: l_attribute_count NUMBER;

Line 1379: RETURN hxc_self_service_time_deposit.app_attributes_info IS

1375: END attributes_to_string;
1376:
1377: FUNCTION string_to_attributes
1378: (p_attribute_string IN varchar2)
1379: RETURN hxc_self_service_time_deposit.app_attributes_info IS
1380:
1381: l_attributes hxc_self_service_time_deposit.app_attributes_info;
1382: l_attributes2 hxc_self_service_time_deposit.app_attributes_info;
1383: l_value_index NUMBER :=1;

Line 1381: l_attributes hxc_self_service_time_deposit.app_attributes_info;

1377: FUNCTION string_to_attributes
1378: (p_attribute_string IN varchar2)
1379: RETURN hxc_self_service_time_deposit.app_attributes_info IS
1380:
1381: l_attributes hxc_self_service_time_deposit.app_attributes_info;
1382: l_attributes2 hxc_self_service_time_deposit.app_attributes_info;
1383: l_value_index NUMBER :=1;
1384: l_attribute_count NUMBER := 0;
1385: l_bad BOOLEAN :=FALSE;

Line 1382: l_attributes2 hxc_self_service_time_deposit.app_attributes_info;

1378: (p_attribute_string IN varchar2)
1379: RETURN hxc_self_service_time_deposit.app_attributes_info IS
1380:
1381: l_attributes hxc_self_service_time_deposit.app_attributes_info;
1382: l_attributes2 hxc_self_service_time_deposit.app_attributes_info;
1383: l_value_index NUMBER :=1;
1384: l_attribute_count NUMBER := 0;
1385: l_bad BOOLEAN :=FALSE;
1386:

Line 1499: RETURN hxc_self_service_time_deposit.building_block_attribute_info IS

1495: END string_to_attributes;
1496:
1497: FUNCTION string_to_bld_blk_attributes
1498: (p_attribute_string IN varchar2)
1499: RETURN hxc_self_service_time_deposit.building_block_attribute_info IS
1500:
1501: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
1502: l_attributes2 hxc_self_service_time_deposit.building_block_attribute_info;
1503: l_value_index NUMBER :=1;

Line 1501: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

1497: FUNCTION string_to_bld_blk_attributes
1498: (p_attribute_string IN varchar2)
1499: RETURN hxc_self_service_time_deposit.building_block_attribute_info IS
1500:
1501: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
1502: l_attributes2 hxc_self_service_time_deposit.building_block_attribute_info;
1503: l_value_index NUMBER :=1;
1504: l_attribute_count NUMBER := 0;
1505:

Line 1502: l_attributes2 hxc_self_service_time_deposit.building_block_attribute_info;

1498: (p_attribute_string IN varchar2)
1499: RETURN hxc_self_service_time_deposit.building_block_attribute_info IS
1500:
1501: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
1502: l_attributes2 hxc_self_service_time_deposit.building_block_attribute_info;
1503: l_value_index NUMBER :=1;
1504: l_attribute_count NUMBER := 0;
1505:
1506:

Line 1843: (p_messages IN hxc_self_service_time_deposit.message_table)

1839:
1840: END string_to_bld_blk_attributes;
1841:
1842: FUNCTION messages_to_string
1843: (p_messages IN hxc_self_service_time_deposit.message_table)
1844: RETURN VARCHAR2 IS
1845:
1846: l_message_string VARCHAR2(32767);
1847: l_message_count NUMBER;

Line 1896: RETURN hxc_self_service_time_deposit.message_table IS

1892: END messages_to_string;
1893:
1894: FUNCTION string_to_messages
1895: (p_message_string IN varchar2)
1896: RETURN hxc_self_service_time_deposit.message_table IS
1897:
1898: l_messages hxc_self_service_time_deposit.message_table;
1899: l_value_index NUMBER :=1;
1900: l_message_count NUMBER := 0;

Line 1898: l_messages hxc_self_service_time_deposit.message_table;

1894: FUNCTION string_to_messages
1895: (p_message_string IN varchar2)
1896: RETURN hxc_self_service_time_deposit.message_table IS
1897:
1898: l_messages hxc_self_service_time_deposit.message_table;
1899: l_value_index NUMBER :=1;
1900: l_message_count NUMBER := 0;
1901:
1902: BEGIN

Line 1960: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

1956:
1957: END string_to_messages;
1958:
1959: FUNCTION attributes_to_string(
1960: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
1961: )
1962: RETURN VARCHAR2
1963: IS
1964: l_attribute_string VARCHAR2(32767) := '';

Line 2649: RETURN hxc_self_service_time_deposit.building_block_attribute_info

2645: --
2646: FUNCTION array_to_attributes(
2647: p_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
2648: )
2649: RETURN hxc_self_service_time_deposit.building_block_attribute_info
2650: IS
2651: l_array_index NUMBER;
2652: l_attribute_count NUMBER := 1;
2653: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

Line 2653: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

2649: RETURN hxc_self_service_time_deposit.building_block_attribute_info
2650: IS
2651: l_array_index NUMBER;
2652: l_attribute_count NUMBER := 1;
2653: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
2654: BEGIN
2655: l_array_index := p_attribute_array.first;
2656: LOOP
2657: EXIT WHEN NOT p_attribute_array.exists(l_array_index);

Line 2706: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

2702: RETURN l_attributes;
2703: END array_to_attributes;
2704:
2705: FUNCTION attributes_to_array(
2706: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
2707: )
2708: RETURN HXC_ATTRIBUTE_TABLE_TYPE
2709: IS
2710: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;

Line 2789: RETURN hxc_self_service_time_deposit.timecard_info

2785: --
2786: FUNCTION array_to_blocks(
2787: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2788: )
2789: RETURN hxc_self_service_time_deposit.timecard_info
2790: IS
2791: l_array_index NUMBER;
2792: l_blocks hxc_self_service_time_deposit.timecard_info;
2793: BEGIN

Line 2792: l_blocks hxc_self_service_time_deposit.timecard_info;

2788: )
2789: RETURN hxc_self_service_time_deposit.timecard_info
2790: IS
2791: l_array_index NUMBER;
2792: l_blocks hxc_self_service_time_deposit.timecard_info;
2793: BEGIN
2794: l_array_index := p_block_array.first;
2795: LOOP
2796: EXIT WHEN NOT p_block_array.exists(l_array_index);

Line 2848: p_blocks IN hxc_self_service_time_deposit.timecard_info

2844:
2845: --
2846: --
2847: FUNCTION blocks_to_array(
2848: p_blocks IN hxc_self_service_time_deposit.timecard_info
2849: )
2850: RETURN HXC_BLOCK_TABLE_TYPE
2851: IS
2852: l_block_array HXC_BLOCK_TABLE_TYPE;

Line 2910: p_translated_bb_ids_tab hxc_self_service_time_deposit.translate_bb_ids_tab

2906: RETURN l_block_array;
2907: END blocks_to_array;
2908:
2909: PROCEDURE maintain_errors (
2910: p_translated_bb_ids_tab hxc_self_service_time_deposit.translate_bb_ids_tab
2911: , p_translated_ta_ids_tab hxc_self_service_time_deposit.translate_ta_ids_tab
2912: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
2913: , p_transactions IN OUT NOCOPY hxc_deposit_wrapper_utilities.t_transaction ) IS
2914:

Line 2911: , p_translated_ta_ids_tab hxc_self_service_time_deposit.translate_ta_ids_tab

2907: END blocks_to_array;
2908:
2909: PROCEDURE maintain_errors (
2910: p_translated_bb_ids_tab hxc_self_service_time_deposit.translate_bb_ids_tab
2911: , p_translated_ta_ids_tab hxc_self_service_time_deposit.translate_ta_ids_tab
2912: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
2913: , p_transactions IN OUT NOCOPY hxc_deposit_wrapper_utilities.t_transaction ) IS
2914:
2915: l_msg_ind BINARY_INTEGER;

Line 2912: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table

2908:
2909: PROCEDURE maintain_errors (
2910: p_translated_bb_ids_tab hxc_self_service_time_deposit.translate_bb_ids_tab
2911: , p_translated_ta_ids_tab hxc_self_service_time_deposit.translate_ta_ids_tab
2912: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
2913: , p_transactions IN OUT NOCOPY hxc_deposit_wrapper_utilities.t_transaction ) IS
2914:
2915: l_msg_ind BINARY_INTEGER;
2916: l_tbb_id NUMBER;