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 HXC_TIME_BUILDING_BLOCKS

Line 140: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type

136: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
137: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
138: ,p_timecard_props in HXC_TIMECARD_PROP_TABLE_TYPE
139: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
140: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
141: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
142: ,p_resubmit in varchar2
143: ) is
144:

Line 141: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type

137: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
138: ,p_timecard_props in HXC_TIMECARD_PROP_TABLE_TYPE
139: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
140: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
141: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
142: ,p_resubmit in varchar2
143: ) is
144:
145: l_timecard_blocks hxc_timecard.block_list;

Line 458: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type

454: ,p_template in VARCHAR2
455: ,p_item_type in VARCHAR2
456: ,p_approval_prc in VARCHAR2
457: ,p_cla_save in varchar2 default 'NO'
458: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
459: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
460: ) IS
461:
462: l_timecard_blocks hxc_timecard.block_list;

Line 459: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type

455: ,p_item_type in VARCHAR2
456: ,p_approval_prc in VARCHAR2
457: ,p_cla_save in varchar2 default 'NO'
458: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
459: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
460: ) IS
461:
462: l_timecard_blocks hxc_timecard.block_list;
463: l_day_blocks hxc_timecard.block_list;

Line 474: l_tbb_id hxc_time_building_blocks.time_building_block_id%type; -- declare two variables for ID and OVN

470: l_can_deposit boolean := true;
471: l_resubmit varchar2(10) := c_no;
472: l_timecard_index number;
473: l_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
474: l_tbb_id hxc_time_building_blocks.time_building_block_id%type; -- declare two variables for ID and OVN
475: l_tbb_ovn hxc_time_building_blocks.object_version_number%type;
476: l_attribute_index number;
477: l_audit_layout number;
478:

Line 475: l_tbb_ovn hxc_time_building_blocks.object_version_number%type;

471: l_resubmit varchar2(10) := c_no;
472: l_timecard_index number;
473: l_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
474: l_tbb_id hxc_time_building_blocks.time_building_block_id%type; -- declare two variables for ID and OVN
475: l_tbb_ovn hxc_time_building_blocks.object_version_number%type;
476: l_attribute_index number;
477: l_audit_layout number;
478:
479: l_restrict_blank_rows_on_save varchar2(10) := 'Y';

Line 1345: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type

1341: ,p_item_type in wf_items.item_type%type
1342: ,p_approval_prc in wf_process_activities.process_name%type
1343: ,p_lock_rowid in rowid
1344: ,p_cla_save in varchar2 default 'NO'
1345: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
1346: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
1347: ,p_messages out nocopy hxc_message_table_type
1348: ) is
1349:

Line 1346: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type

1342: ,p_approval_prc in wf_process_activities.process_name%type
1343: ,p_lock_rowid in rowid
1344: ,p_cla_save in varchar2 default 'NO'
1345: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
1346: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
1347: ,p_messages out nocopy hxc_message_table_type
1348: ) is
1349:
1350: l_proc varchar2(30) := g_package||'.CREATE_TIMECARD';

Line 1359: l_resource_id hxc_time_building_blocks.resource_id%type;

1355: l_valid_lock boolean := false;
1356: l_lock_rowid rowid;
1357: l_timecard_index number;
1358:
1359: l_resource_id hxc_time_building_blocks.resource_id%type;
1360: l_timecard_start_time hxc_time_building_blocks.start_time%type;
1361: l_timecard_stop_time hxc_time_building_blocks.stop_time%type;
1362:
1363: d_lock_rowid varchar2(100);

Line 1360: l_timecard_start_time hxc_time_building_blocks.start_time%type;

1356: l_lock_rowid rowid;
1357: l_timecard_index number;
1358:
1359: l_resource_id hxc_time_building_blocks.resource_id%type;
1360: l_timecard_start_time hxc_time_building_blocks.start_time%type;
1361: l_timecard_stop_time hxc_time_building_blocks.stop_time%type;
1362:
1363: d_lock_rowid varchar2(100);
1364:

Line 1361: l_timecard_stop_time hxc_time_building_blocks.stop_time%type;

1357: l_timecard_index number;
1358:
1359: l_resource_id hxc_time_building_blocks.resource_id%type;
1360: l_timecard_start_time hxc_time_building_blocks.start_time%type;
1361: l_timecard_stop_time hxc_time_building_blocks.stop_time%type;
1362:
1363: d_lock_rowid varchar2(100);
1364:
1365: -- Bug 10196997

Line 1669: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

1665:
1666: End create_timecard;
1667:
1668: Function load_blocks
1669: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
1670: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
1671: ,p_load_mode in varchar2 default c_nondelete
1672: ) return hxc_block_table_type is
1673:

Line 1670: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type

1666: End create_timecard;
1667:
1668: Function load_blocks
1669: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
1670: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
1671: ,p_load_mode in varchar2 default c_nondelete
1672: ) return hxc_block_table_type is
1673:
1674: cursor c_blocks

Line 1675: (p_tc_id in hxc_time_building_blocks.time_building_block_id%type

1671: ,p_load_mode in varchar2 default c_nondelete
1672: ) return hxc_block_table_type is
1673:
1674: cursor c_blocks
1675: (p_tc_id in hxc_time_building_blocks.time_building_block_id%type
1676: ) is
1677: select tbb.time_building_block_id
1678: ,tbb.object_version_number
1679: from hxc_time_building_blocks tbb

Line 1679: from hxc_time_building_blocks tbb

1675: (p_tc_id in hxc_time_building_blocks.time_building_block_id%type
1676: ) is
1677: select tbb.time_building_block_id
1678: ,tbb.object_version_number
1679: from hxc_time_building_blocks tbb
1680: where tbb.date_to = hr_general.end_of_time
1681: start with (tbb.time_building_block_id = p_tc_id)
1682: connect by prior tbb.time_building_block_id = tbb.parent_building_block_id
1683: and prior tbb.object_version_number = tbb.parent_building_block_ovn;

Line 1716: (p_building_block_id in hxc_time_building_blocks.time_building_block_id%type

1712: (p_blocks in hxc_block_table_type)
1713: return hxc_attribute_table_type is
1714:
1715: cursor c_attributes
1716: (p_building_block_id in hxc_time_building_blocks.time_building_block_id%type
1717: ,p_building_block_ovn in hxc_time_building_blocks.object_version_number%type
1718: ) is
1719: select ta.time_attribute_id
1720: ,ta.attribute_category

Line 1717: ,p_building_block_ovn in hxc_time_building_blocks.object_version_number%type

1713: return hxc_attribute_table_type is
1714:
1715: cursor c_attributes
1716: (p_building_block_id in hxc_time_building_blocks.time_building_block_id%type
1717: ,p_building_block_ovn in hxc_time_building_blocks.object_version_number%type
1718: ) is
1719: select ta.time_attribute_id
1720: ,ta.attribute_category
1721: ,ta.attribute1

Line 1832: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

1828:
1829: Procedure delete_timecard
1830: (p_mode in varchar2
1831: ,p_template in varchar2
1832: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
1833: ,p_timecard_ok in out nocopy varchar2
1834: ) is
1835:
1836: cursor c_timecard_ovn

Line 1837: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

1833: ,p_timecard_ok in out nocopy varchar2
1834: ) is
1835:
1836: cursor c_timecard_ovn
1837: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
1838: select tbb.object_version_number, tbb.resource_id, tbb.start_time, tbb.stop_time
1839: from hxc_time_building_blocks tbb
1840: where tbb.time_building_block_id = p_timecard_id
1841: and tbb.date_to = hr_general.end_of_time;

Line 1839: from hxc_time_building_blocks tbb

1835:
1836: cursor c_timecard_ovn
1837: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
1838: select tbb.object_version_number, tbb.resource_id, tbb.start_time, tbb.stop_time
1839: from hxc_time_building_blocks tbb
1840: where tbb.time_building_block_id = p_timecard_id
1841: and tbb.date_to = hr_general.end_of_time;
1842:
1843:

Line 1847: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

1843:
1844: -- Bug 13416941
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'

Line 1876: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;

1872: l_timecard_props hxc_timecard_prop_table_type;
1873:
1874: l_dummy boolean := true;
1875:
1876: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1877: l_resource_id hxc_time_building_blocks.resource_id%type;
1878: l_start_time hxc_time_building_blocks.start_time%type;
1879: l_stop_time hxc_time_building_blocks.stop_time%type;
1880: l_timecard_index number;

Line 1877: l_resource_id hxc_time_building_blocks.resource_id%type;

1873:
1874: l_dummy boolean := true;
1875:
1876: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1877: l_resource_id hxc_time_building_blocks.resource_id%type;
1878: l_start_time hxc_time_building_blocks.start_time%type;
1879: l_stop_time hxc_time_building_blocks.stop_time%type;
1880: l_timecard_index number;
1881: l_lock_rowid rowid;

Line 1878: l_start_time hxc_time_building_blocks.start_time%type;

1874: l_dummy boolean := true;
1875:
1876: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1877: l_resource_id hxc_time_building_blocks.resource_id%type;
1878: l_start_time hxc_time_building_blocks.start_time%type;
1879: l_stop_time hxc_time_building_blocks.stop_time%type;
1880: l_timecard_index number;
1881: l_lock_rowid rowid;
1882: l_lock_success boolean;

Line 1879: l_stop_time hxc_time_building_blocks.stop_time%type;

1875:
1876: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1877: l_resource_id hxc_time_building_blocks.resource_id%type;
1878: l_start_time hxc_time_building_blocks.start_time%type;
1879: l_stop_time hxc_time_building_blocks.stop_time%type;
1880: l_timecard_index number;
1881: l_lock_rowid rowid;
1882: l_lock_success boolean;
1883:

Line 2141: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

2137: End delete_timecard;
2138:
2139: -- Added for DA Enhancement
2140: Procedure delete_null_entries
2141: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
2142: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
2143: )is
2144:
2145: cursor c_null_blocks

Line 2142: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type

2138:
2139: -- Added for DA Enhancement
2140: Procedure delete_null_entries
2141: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
2142: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
2143: )is
2144:
2145: cursor c_null_blocks
2146: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

Line 2146: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

2142: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
2143: )is
2144:
2145: cursor c_null_blocks
2146: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
2147: ) is
2148:
2149: SELECT det.time_building_block_id ,
2150: det.object_version_number

Line 2151: FROM hxc_time_building_blocks DET,

2147: ) is
2148:
2149: SELECT det.time_building_block_id ,
2150: det.object_version_number
2151: FROM hxc_time_building_blocks DET,
2152: HXC_TIME_BUILDING_BLOCKS DAY
2153: WHERE day.parent_building_block_id = p_timecard_id
2154: AND det.parent_building_block_ovn = day.object_version_number
2155: AND det.parent_building_block_id = day.time_building_block_id

Line 2152: HXC_TIME_BUILDING_BLOCKS DAY

2148:
2149: SELECT det.time_building_block_id ,
2150: det.object_version_number
2151: FROM hxc_time_building_blocks DET,
2152: HXC_TIME_BUILDING_BLOCKS DAY
2153: WHERE day.parent_building_block_id = p_timecard_id
2154: AND det.parent_building_block_ovn = day.object_version_number
2155: AND det.parent_building_block_id = day.time_building_block_id
2156: AND det.scope = 'DETAIL'

Line 2179: FROM hxc_time_building_blocks

2175:
2176: FORALL i IN bb_id_tab.FIRST..bb_id_tab.LAST
2177:
2178: DELETE
2179: FROM hxc_time_building_blocks
2180: WHERE time_building_block_id = bb_id_tab(i)
2181: AND object_version_number = bb_ovn_tab(i);
2182:
2183: