9: -- ----------------------------------------------------------------------------
10: -- |-------------------------< int_to_otl_timecard_info>----------------------|
11: -- ----------------------------------------------------------------------------
12: PROCEDURE int_to_otl_timecard_info(
13: p_building_blocks_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
14: ,p_building_blocks_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info)
15: IS
16:
17: l_index NUMBER;
79: -- ----------------------------------------------------------------------------
80: -- |-------------------------< otl_to_int_timecard_info>----------------------|
81: -- ----------------------------------------------------------------------------
82: PROCEDURE otl_to_int_timecard_info(
83: p_building_blocks_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
84: ,p_building_blocks_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info)
85: IS
86: l_index NUMBER;
87:
150: -- ----------------------------------------------------------------------------
151: -- |--------------------< int_to_otl_app_attributes_info>----------------------|
152: -- ----------------------------------------------------------------------------
153: PROCEDURE int_to_otl_app_attributes_info(
154: p_app_attributes_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
155: ,p_app_attributes_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info)
156: IS
157:
158: l_index NUMBER;
198: -- ----------------------------------------------------------------------------
199: -- |-------------------< otl_to_int_app_attributes_info>----------------------|
200: -- ----------------------------------------------------------------------------
201: PROCEDURE otl_to_int_app_attributes_info(
202: p_app_attributes_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
203: ,p_app_attributes_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info)
204: IS
205:
206: l_index NUMBER;
250: -- ----------------------------------------------------------------------------
251: -- |-------------------------< int_to_otl_message_table>----------------------|
252: -- ----------------------------------------------------------------------------
253: PROCEDURE int_to_otl_message_table(
254: p_messages_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table
255: ,p_messages_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
256: IS
257:
258: l_index NUMBER;
299: -- ----------------------------------------------------------------------------
300: -- |-------------------------< otl_to_int_message_table>----------------------|
301: -- ----------------------------------------------------------------------------
302: PROCEDURE otl_to_int_message_table(
303: p_messages_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table
304: ,p_messages_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
305: IS
306:
307: l_index NUMBER;
345: END otl_to_int_message_table;
346:
347:
348: --
349: -- HXC_SELF_SERVICE_TIME_DEPOSIT
350: --
351: -- ----------------------------------------------------------------------------
352: -- |---------------------------< get_app_hook_params >----------------------|
353: -- ----------------------------------------------------------------------------
356: ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
357: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
358: IS
359:
360: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
361: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
362: l_messages_otl HXC_SELF_SERVICE_TIME_DEPOSIT.message_table;
363:
364:
357: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
358: IS
359:
360: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
361: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
362: l_messages_otl HXC_SELF_SERVICE_TIME_DEPOSIT.message_table;
363:
364:
365: BEGIN
358: IS
359:
360: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
361: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
362: l_messages_otl HXC_SELF_SERVICE_TIME_DEPOSIT.message_table;
363:
364:
365: BEGIN
366:
366:
367: --
368: -- call of the OTL API
369: --
370: HXC_SELF_SERVICE_TIME_DEPOSIT.get_app_hook_params (
371: p_building_blocks => l_building_blocks_otl
372: ,p_app_attributes => l_app_attributes_otl
373: ,p_messages => l_messages_otl
374: );
400: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
401: IS
402:
403:
404: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
405: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
406: l_messages_otl HXC_SELF_SERVICE_TIME_DEPOSIT.message_table;
407:
408:
401: IS
402:
403:
404: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
405: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
406: l_messages_otl HXC_SELF_SERVICE_TIME_DEPOSIT.message_table;
407:
408:
409: BEGIN
402:
403:
404: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
405: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
406: l_messages_otl HXC_SELF_SERVICE_TIME_DEPOSIT.message_table;
407:
408:
409: BEGIN
410:
423: ,p_messages_int => p_messages);
424: --
425: -- call of the OTL API
426: --
427: HXC_SELF_SERVICE_TIME_DEPOSIT.set_app_hook_params (
428: p_building_blocks => l_building_blocks_otl
429: ,p_app_attributes => l_app_attributes_otl
430: ,p_messages => l_messages_otl
431: );
949: ,p_time_attribute_ovn in NUMBER default null
950: ,p_message_extent in VARCHAR2 default null)
951: IS
952:
953: l_messages_otl HXC_SELF_SERVICE_TIME_DEPOSIT.message_table;
954:
955: BEGIN
956:
957: -- transfer the data from the integration pl/sql table
1067: RETURN VARCHAR2
1068: IS
1069:
1070: l_return VARCHAR2(32767);
1071: l_messages_otl HXC_SELF_SERVICE_TIME_DEPOSIT.message_table;
1072:
1073: BEGIN
1074:
1075: -- transfer the data from the integration pl/sql table
1104: RETURN VARCHAR2
1105: IS
1106:
1107: l_return VARCHAR2(32767);
1108: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
1109:
1110:
1111: BEGIN
1112:
1141: RETURN VARCHAR2
1142: IS
1143:
1144: l_return VARCHAR2(32767);
1145: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
1146:
1147: BEGIN
1148: -- transfer the data from integration pl/sql table
1149: -- to otl pl/sql table
1208: RETURN HXC_USER_TYPE_DEFINITION_GRP.timecard_info
1209: IS
1210:
1211:
1212: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
1213: l_building_blocks_int HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
1214:
1215: BEGIN
1216:
1238: FUNCTION get_wf_g_time_app_attributes
1239: RETURN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
1240: IS
1241:
1242: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
1243: l_app_attributes_int HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
1244:
1245: BEGIN
1246: