APPS.HXC_TIMECARD dependencies on HXC_TIMECARD_SUMMARY

Line 359: hxc_timecard_summary_api.timecard_deposit

355: */
356: --
357: -- Maintain summary table
358: --
359: hxc_timecard_summary_api.timecard_deposit
360: (p_blocks => p_blocks
361: ,p_approval_item_type => NULL
362: ,p_approval_process_name => NULL
363: ,p_approval_item_key => NULL

Line 1145: hxc_timecard_summary_api.timecard_deposit

1141:
1142:
1143: -- Maintain summary table
1144:
1145: hxc_timecard_summary_api.timecard_deposit
1146: (p_blocks => g_deposit_blocks
1147: ,p_approval_item_type => NULL
1148: ,p_approval_process_name => NULL
1149: ,p_approval_item_key => NULL

Line 1270: hxc_timecard_summary_pkg.update_summary_row

1266:
1267: hxc_timecard_message_helper.processerrors
1268: (p_messages => p_messages);
1269:
1270: hxc_timecard_summary_pkg.update_summary_row
1271: (p_timecard_id => p_timecard_id
1272: ,p_approval_item_type => p_item_type
1273: ,p_approval_process_name => p_approval_prc
1274: ,p_approval_item_key => l_item_key

Line 1849: from hxc_timecard_summary hts,

1845: --
1846: cursor c_timecard_attachment_exists
1847: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
1848: select distinct fad.pk1_value,fad.pk2_value ,fad.pk3_value
1849: from hxc_timecard_summary hts,
1850: fnd_attached_documents fad
1851: where fad.entity_name = 'HXC_TIMECARD_SUMMARY'
1852: and hts.timecard_id = p_timecard_id
1853: and hts.resource_id = fad.pk1_value

Line 1851: where fad.entity_name = 'HXC_TIMECARD_SUMMARY'

1847: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
1848: select distinct fad.pk1_value,fad.pk2_value ,fad.pk3_value
1849: from hxc_timecard_summary hts,
1850: fnd_attached_documents fad
1851: where fad.entity_name = 'HXC_TIMECARD_SUMMARY'
1852: and hts.timecard_id = p_timecard_id
1853: and hts.resource_id = fad.pk1_value
1854: and regexp_replace(fnd_date.date_to_canonical(trunc(hts.start_time)),' .*') = fad.pk2_value
1855: and regexp_replace(fnd_date.date_to_canonical(trunc(hts.stop_time)),' .*') = fad.pk3_value

Line 2045: ( X_entity_name => 'HXC_TIMECARD_SUMMARY'

2041: IF l_pk1_value is not null
2042: THEN
2043: hr_utility.trace('call to delete attachments...fnd_attached_documents2_pkg.delete_attachments');
2044: fnd_attached_documents2_pkg.delete_attachments
2045: ( X_entity_name => 'HXC_TIMECARD_SUMMARY'
2046: , X_pk1_value => l_pk1_value
2047: , X_pk2_value => l_pk2_value
2048: , X_pk3_value => l_pk3_value
2049: , X_delete_document_flag => 'Y');

Line 2055: hxc_timecard_summary_api.delete_timecard

2051: hr_utility.trace('End of delete attachments');
2052: -- End of Delete Attachments
2053:
2054:
2055: hxc_timecard_summary_api.delete_timecard
2056: (p_blocks => l_blocks
2057: ,p_timecard_id => p_timecard_id
2058: );
2059: