DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_MESSAGE_TABLE_TYPE

Line 1921: l_messages HXC_MESSAGE_TABLE_TYPE;

1917: )
1918: IS
1919: -- l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
1920: -- l_blocks hxc_self_service_time_deposit.timecard_info;
1921: l_messages HXC_MESSAGE_TABLE_TYPE;
1922:
1923: BEGIN
1924:
1925: --temporary convertion

Line 2722: p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE )

2718: p_tp_stop_time IN DATE,
2719: p_attribute_string IN OUT NOCOPY VARCHAR2,
2720: p_block_string IN OUT NOCOPY VARCHAR2,
2721: p_message_string IN OUT NOCOPY VARCHAR2,
2722: p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE )
2723:
2724: IS
2725: l_dyn_template_sql VARCHAR2(2000);
2726:

Line 2786: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

2782: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2783: ,p_message_string OUT NOCOPY VARCHAR2
2784: ,p_overwrite IN VARCHAR2 DEFAULT 'Y'
2785: ,p_exclude_hours_template in VARCHAR2 DEFAULT 'N'
2786: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
2787: )
2788: IS
2789: l_template_type VARCHAR2(50) := '';
2790: l_template_handle VARCHAR2(500) := '';

Line 3572: l_messages_table HXC_MESSAGE_TABLE_TYPE;

3568: l_resource_id VARCHAR2(50) := NULL;
3569:
3570: l_proc VARCHAR2(50);
3571:
3572: l_messages_table HXC_MESSAGE_TABLE_TYPE;
3573:
3574: BEGIN
3575:
3576:

Line 3878: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

3874: ,p_resource_type IN VARCHAR2
3875: ,p_start_time IN VARCHAR2
3876: ,p_stop_time IN VARCHAR2
3877: ,p_timecard_id IN NUMBER
3878: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
3879: ,p_lock_success OUT NOCOPY BOOLEAN
3880: ,p_lock_rowid IN OUT NOCOPY ROWID
3881: ,p_timecard_action in VARCHAR2
3882: ) is

Line 3896: p_messages := HXC_MESSAGE_TABLE_TYPE();

3892: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
3893:
3894: Begin
3895:
3896: p_messages := HXC_MESSAGE_TABLE_TYPE();
3897:
3898: if(p_timecard_id is not null) then
3899: open c_find_timecard_ovn(p_timecard_id);
3900: fetch c_find_timecard_ovn into l_timecard_ovn;

Line 4566: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

4562: ,p_approval_status IN VARCHAR2
4563: ,p_create_template IN VARCHAR2
4564: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4565: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4566: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4567: ,p_message_string OUT NOCOPY VARCHAR2
4568: ,p_overwrite IN VARCHAR2
4569: ,p_review IN VARCHAR2
4570: ,p_lock_rowid IN OUT NOCOPY ROWID

Line 4611: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

4607: ,p_approval_status IN VARCHAR2
4608: ,p_create_template IN VARCHAR2
4609: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4610: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4611: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4612: ,p_message_string OUT NOCOPY VARCHAR2
4613: ,p_overwrite IN VARCHAR2
4614: ,p_review IN VARCHAR2
4615: ,p_lock_rowid IN OUT NOCOPY ROWID

Line 4657: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

4653: ,p_approval_status IN VARCHAR2
4654: ,p_create_template IN VARCHAR2
4655: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4656: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4657: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4658: ,p_message_string OUT NOCOPY VARCHAR2
4659: ,p_overwrite IN VARCHAR2
4660: ,p_review IN VARCHAR2
4661: ,p_lock_rowid IN OUT NOCOPY ROWID

Line 4729: p_messages := hxc_message_table_type();

4725: ,p_timecard_action => p_timecard_action
4726: );
4727:
4728: else
4729: p_messages := hxc_message_table_type();
4730: end if;
4731:
4732: if(p_messages.count=0) then
4733: --

Line 5183: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

5179: ,p_resource_type IN VARCHAR2
5180: ,p_start_time IN VARCHAR2
5181: ,p_stop_time IN VARCHAR2
5182: ,p_template_code IN VARCHAR2
5183: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
5184: )
5185: IS
5186:
5187: l_template_handle VARCHAR2(500) := '';