APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_MESSAGE_TABLE_TYPE

Line 2219: l_messages HXC_MESSAGE_TABLE_TYPE;

2215: )
2216: IS
2217: -- l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
2218: -- l_blocks hxc_self_service_time_deposit.timecard_info;
2219: l_messages HXC_MESSAGE_TABLE_TYPE;
2220:
2221: BEGIN
2222:
2223: --temporary convertion

Line 3022: p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE )

3018: p_tp_stop_time IN DATE,
3019: p_attribute_string IN OUT NOCOPY VARCHAR2,
3020: p_block_string IN OUT NOCOPY VARCHAR2,
3021: p_message_string IN OUT NOCOPY VARCHAR2,
3022: p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE )
3023:
3024: IS
3025: l_dyn_template_sql VARCHAR2(2000);
3026:

Line 3086: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

3082: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3083: ,p_message_string OUT NOCOPY VARCHAR2
3084: ,p_overwrite IN VARCHAR2 DEFAULT 'Y'
3085: ,p_exclude_hours_template in VARCHAR2 DEFAULT 'N'
3086: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
3087: )
3088: IS
3089: l_template_type VARCHAR2(50) := '';
3090: l_template_handle VARCHAR2(500) := '';

Line 3908: l_messages_table HXC_MESSAGE_TABLE_TYPE;

3904: l_resource_id VARCHAR2(50) := NULL;
3905:
3906: l_proc VARCHAR2(50);
3907:
3908: l_messages_table HXC_MESSAGE_TABLE_TYPE;
3909:
3910: BEGIN
3911:
3912:

Line 4214: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

4210: ,p_resource_type IN VARCHAR2
4211: ,p_start_time IN VARCHAR2
4212: ,p_stop_time IN VARCHAR2
4213: ,p_timecard_id IN NUMBER
4214: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4215: ,p_lock_success OUT NOCOPY BOOLEAN
4216: ,p_lock_rowid IN OUT NOCOPY ROWID
4217: ,p_timecard_action in VARCHAR2
4218: ) is

Line 4232: p_messages := HXC_MESSAGE_TABLE_TYPE();

4228: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
4229:
4230: Begin
4231:
4232: p_messages := HXC_MESSAGE_TABLE_TYPE();
4233:
4234: if(p_timecard_id is not null) then
4235: open c_find_timecard_ovn(p_timecard_id);
4236: fetch c_find_timecard_ovn into l_timecard_ovn;

Line 4902: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

4898: ,p_approval_status IN VARCHAR2
4899: ,p_create_template IN VARCHAR2
4900: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4901: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4902: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4903: ,p_message_string OUT NOCOPY VARCHAR2
4904: ,p_overwrite IN VARCHAR2
4905: ,p_review IN VARCHAR2
4906: ,p_lock_rowid IN OUT NOCOPY ROWID

Line 4947: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

4943: ,p_approval_status IN VARCHAR2
4944: ,p_create_template IN VARCHAR2
4945: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4946: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4947: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4948: ,p_message_string OUT NOCOPY VARCHAR2
4949: ,p_overwrite IN VARCHAR2
4950: ,p_review IN VARCHAR2
4951: ,p_lock_rowid IN OUT NOCOPY ROWID

Line 4993: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

4989: ,p_approval_status IN VARCHAR2
4990: ,p_create_template IN VARCHAR2
4991: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4992: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4993: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4994: ,p_message_string OUT NOCOPY VARCHAR2
4995: ,p_overwrite IN VARCHAR2
4996: ,p_review IN VARCHAR2
4997: ,p_lock_rowid IN OUT NOCOPY ROWID

Line 5065: p_messages := hxc_message_table_type();

5061: ,p_timecard_action => p_timecard_action
5062: );
5063:
5064: else
5065: p_messages := hxc_message_table_type();
5066: end if;
5067:
5068: if(p_messages.count=0) then
5069: --

Line 5602: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

5598: ,p_resource_type IN VARCHAR2
5599: ,p_start_time IN VARCHAR2
5600: ,p_stop_time IN VARCHAR2
5601: ,p_template_code IN VARCHAR2
5602: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
5603: )
5604: IS
5605:
5606: l_template_handle VARCHAR2(500) := '';