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 2905: RETURN hxc_self_service_time_deposit.building_block_attribute_info

2901: --
2902: FUNCTION array_to_attributes(
2903: p_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
2904: )
2905: RETURN hxc_self_service_time_deposit.building_block_attribute_info
2906: IS
2907: l_array_index NUMBER;
2908: l_attribute_count NUMBER := 1;
2909: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

Line 2909: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

2905: RETURN hxc_self_service_time_deposit.building_block_attribute_info
2906: IS
2907: l_array_index NUMBER;
2908: l_attribute_count NUMBER := 1;
2909: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
2910: BEGIN
2911: l_array_index := p_attribute_array.first;
2912: LOOP
2913: EXIT WHEN NOT p_attribute_array.exists(l_array_index);

Line 2962: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info

2958: RETURN l_attributes;
2959: END array_to_attributes;
2960:
2961: FUNCTION attributes_to_array(
2962: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
2963: )
2964: RETURN HXC_ATTRIBUTE_TABLE_TYPE
2965: IS
2966: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;

Line 3045: RETURN hxc_self_service_time_deposit.timecard_info

3041: --
3042: FUNCTION array_to_blocks(
3043: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3044: )
3045: RETURN hxc_self_service_time_deposit.timecard_info
3046: IS
3047: l_array_index NUMBER;
3048: l_blocks hxc_self_service_time_deposit.timecard_info;
3049: BEGIN

Line 3048: l_blocks hxc_self_service_time_deposit.timecard_info;

3044: )
3045: RETURN hxc_self_service_time_deposit.timecard_info
3046: IS
3047: l_array_index NUMBER;
3048: l_blocks hxc_self_service_time_deposit.timecard_info;
3049: BEGIN
3050: l_array_index := p_block_array.first;
3051: LOOP
3052: EXIT WHEN NOT p_block_array.exists(l_array_index);

Line 3104: p_blocks IN hxc_self_service_time_deposit.timecard_info

3100:
3101: --
3102: --
3103: FUNCTION blocks_to_array(
3104: p_blocks IN hxc_self_service_time_deposit.timecard_info
3105: )
3106: RETURN HXC_BLOCK_TABLE_TYPE
3107: IS
3108: l_block_array HXC_BLOCK_TABLE_TYPE;

Line 3166: p_translated_bb_ids_tab hxc_self_service_time_deposit.translate_bb_ids_tab

3162: RETURN l_block_array;
3163: END blocks_to_array;
3164:
3165: PROCEDURE maintain_errors (
3166: p_translated_bb_ids_tab hxc_self_service_time_deposit.translate_bb_ids_tab
3167: , p_translated_ta_ids_tab hxc_self_service_time_deposit.translate_ta_ids_tab
3168: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
3169: , p_transactions IN OUT NOCOPY hxc_deposit_wrapper_utilities.t_transaction ) IS
3170:

Line 3167: , p_translated_ta_ids_tab hxc_self_service_time_deposit.translate_ta_ids_tab

3163: END blocks_to_array;
3164:
3165: PROCEDURE maintain_errors (
3166: p_translated_bb_ids_tab hxc_self_service_time_deposit.translate_bb_ids_tab
3167: , p_translated_ta_ids_tab hxc_self_service_time_deposit.translate_ta_ids_tab
3168: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
3169: , p_transactions IN OUT NOCOPY hxc_deposit_wrapper_utilities.t_transaction ) IS
3170:
3171: l_msg_ind BINARY_INTEGER;

Line 3168: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table

3164:
3165: PROCEDURE maintain_errors (
3166: p_translated_bb_ids_tab hxc_self_service_time_deposit.translate_bb_ids_tab
3167: , p_translated_ta_ids_tab hxc_self_service_time_deposit.translate_ta_ids_tab
3168: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
3169: , p_transactions IN OUT NOCOPY hxc_deposit_wrapper_utilities.t_transaction ) IS
3170:
3171: l_msg_ind BINARY_INTEGER;
3172: l_tbb_id NUMBER;