eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TIMECARD dependencies on FND_ATTACHED_DOCUMENTS

Line 1850: fnd_attached_documents fad

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
1854: and regexp_replace(fnd_date.date_to_canonical(trunc(hts.start_time)),' .*') = fad.pk2_value

Line 1859: l_pk1_value fnd_attached_documents.pk1_value%type;

1855: and regexp_replace(fnd_date.date_to_canonical(trunc(hts.stop_time)),' .*') = fad.pk3_value
1856: ;
1857:
1858: --l_timecard_attachment_exists varchar2(5) := 'N';
1859: l_pk1_value fnd_attached_documents.pk1_value%type;
1860: l_pk2_value fnd_attached_documents.pk2_value%type;
1861: l_pk3_value fnd_attached_documents.pk3_value%type;
1862:
1863: l_blocks hxc_block_table_type := hxc_block_table_type();

Line 1860: l_pk2_value fnd_attached_documents.pk2_value%type;

1856: ;
1857:
1858: --l_timecard_attachment_exists varchar2(5) := 'N';
1859: l_pk1_value fnd_attached_documents.pk1_value%type;
1860: l_pk2_value fnd_attached_documents.pk2_value%type;
1861: l_pk3_value fnd_attached_documents.pk3_value%type;
1862:
1863: l_blocks hxc_block_table_type := hxc_block_table_type();
1864: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();

Line 1861: l_pk3_value fnd_attached_documents.pk3_value%type;

1857:
1858: --l_timecard_attachment_exists varchar2(5) := 'N';
1859: l_pk1_value fnd_attached_documents.pk1_value%type;
1860: l_pk2_value fnd_attached_documents.pk2_value%type;
1861: l_pk3_value fnd_attached_documents.pk3_value%type;
1862:
1863: l_blocks hxc_block_table_type := hxc_block_table_type();
1864: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
1865: l_messages hxc_message_table_type := hxc_message_table_type();

Line 2043: hr_utility.trace('call to delete attachments...fnd_attached_documents2_pkg.delete_attachments');

2039: END IF;
2040:
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

Line 2044: fnd_attached_documents2_pkg.delete_attachments

2040:
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