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_TEMPLATE_SUMMARY_PKG dependencies on HXC_TEMPLATE_SUMMARY

Line 1: PACKAGE BODY HXC_TEMPLATE_SUMMARY_PKG AS

1: PACKAGE BODY HXC_TEMPLATE_SUMMARY_PKG AS
2: /* $Header: hxctempsumpkg.pkb 120.1 2005/12/12 08:34:13 gkrishna noship $ */
3:
4: PROCEDURE INSERT_SUMMARY_ROW(p_template_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_template_ovn in hxc_time_building_blocks.OBJECT_VERSION_NUMBER%type,

Line 6: p_template_name in hxc_template_summary.TEMPLATE_NAME%type,

2: /* $Header: hxctempsumpkg.pkb 120.1 2005/12/12 08:34:13 gkrishna noship $ */
3:
4: PROCEDURE INSERT_SUMMARY_ROW(p_template_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_template_ovn in hxc_time_building_blocks.OBJECT_VERSION_NUMBER%type,
6: p_template_name in hxc_template_summary.TEMPLATE_NAME%type,
7: p_description in hxc_template_summary.DESCRIPTION%type,
8: p_template_type in hxc_template_summary.TEMPLATE_TYPE%type,
9: p_layout_id in hxc_template_summary.LAYOUT_ID%type,
10: p_recurring_period_id in hxc_template_summary.RECURRING_PERIOD_ID%type,

Line 7: p_description in hxc_template_summary.DESCRIPTION%type,

3:
4: PROCEDURE INSERT_SUMMARY_ROW(p_template_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_template_ovn in hxc_time_building_blocks.OBJECT_VERSION_NUMBER%type,
6: p_template_name in hxc_template_summary.TEMPLATE_NAME%type,
7: p_description in hxc_template_summary.DESCRIPTION%type,
8: p_template_type in hxc_template_summary.TEMPLATE_TYPE%type,
9: p_layout_id in hxc_template_summary.LAYOUT_ID%type,
10: p_recurring_period_id in hxc_template_summary.RECURRING_PERIOD_ID%type,
11: p_business_group_id in hxc_template_summary.BUSINESS_GROUP_ID%type,

Line 8: p_template_type in hxc_template_summary.TEMPLATE_TYPE%type,

4: PROCEDURE INSERT_SUMMARY_ROW(p_template_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_template_ovn in hxc_time_building_blocks.OBJECT_VERSION_NUMBER%type,
6: p_template_name in hxc_template_summary.TEMPLATE_NAME%type,
7: p_description in hxc_template_summary.DESCRIPTION%type,
8: p_template_type in hxc_template_summary.TEMPLATE_TYPE%type,
9: p_layout_id in hxc_template_summary.LAYOUT_ID%type,
10: p_recurring_period_id in hxc_template_summary.RECURRING_PERIOD_ID%type,
11: p_business_group_id in hxc_template_summary.BUSINESS_GROUP_ID%type,
12: p_resource_id in hxc_template_summary.RESOURCE_ID%type

Line 9: p_layout_id in hxc_template_summary.LAYOUT_ID%type,

5: p_template_ovn in hxc_time_building_blocks.OBJECT_VERSION_NUMBER%type,
6: p_template_name in hxc_template_summary.TEMPLATE_NAME%type,
7: p_description in hxc_template_summary.DESCRIPTION%type,
8: p_template_type in hxc_template_summary.TEMPLATE_TYPE%type,
9: p_layout_id in hxc_template_summary.LAYOUT_ID%type,
10: p_recurring_period_id in hxc_template_summary.RECURRING_PERIOD_ID%type,
11: p_business_group_id in hxc_template_summary.BUSINESS_GROUP_ID%type,
12: p_resource_id in hxc_template_summary.RESOURCE_ID%type
13: ) is

Line 10: p_recurring_period_id in hxc_template_summary.RECURRING_PERIOD_ID%type,

6: p_template_name in hxc_template_summary.TEMPLATE_NAME%type,
7: p_description in hxc_template_summary.DESCRIPTION%type,
8: p_template_type in hxc_template_summary.TEMPLATE_TYPE%type,
9: p_layout_id in hxc_template_summary.LAYOUT_ID%type,
10: p_recurring_period_id in hxc_template_summary.RECURRING_PERIOD_ID%type,
11: p_business_group_id in hxc_template_summary.BUSINESS_GROUP_ID%type,
12: p_resource_id in hxc_template_summary.RESOURCE_ID%type
13: ) is
14:

Line 11: p_business_group_id in hxc_template_summary.BUSINESS_GROUP_ID%type,

7: p_description in hxc_template_summary.DESCRIPTION%type,
8: p_template_type in hxc_template_summary.TEMPLATE_TYPE%type,
9: p_layout_id in hxc_template_summary.LAYOUT_ID%type,
10: p_recurring_period_id in hxc_template_summary.RECURRING_PERIOD_ID%type,
11: p_business_group_id in hxc_template_summary.BUSINESS_GROUP_ID%type,
12: p_resource_id in hxc_template_summary.RESOURCE_ID%type
13: ) is
14:
15: cursor c_template_info(p_template_id in hxc_time_building_blocks.time_building_block_id%type,p_template_ovn in hxc_time_building_blocks.object_version_number%type) is

Line 12: p_resource_id in hxc_template_summary.RESOURCE_ID%type

8: p_template_type in hxc_template_summary.TEMPLATE_TYPE%type,
9: p_layout_id in hxc_template_summary.LAYOUT_ID%type,
10: p_recurring_period_id in hxc_template_summary.RECURRING_PERIOD_ID%type,
11: p_business_group_id in hxc_template_summary.BUSINESS_GROUP_ID%type,
12: p_resource_id in hxc_template_summary.RESOURCE_ID%type
13: ) is
14:
15: cursor c_template_info(p_template_id in hxc_time_building_blocks.time_building_block_id%type,p_template_ovn in hxc_time_building_blocks.object_version_number%type) is
16: select RESOURCE_ID,

Line 26: l_recorded_hours hxc_template_summary.recorded_hours%type :=0;

22: and object_version_number = p_template_ovn
23: and scope = 'TIMECARD_TEMPLATE';
24:
25: l_updatedby_id hxc_time_building_blocks.resource_id%type;
26: l_recorded_hours hxc_template_summary.recorded_hours%type :=0;
27: l_details hxc_timecard_summary_pkg.details;
28: l_created_by hxc_time_building_blocks.resource_id%type;
29: l_start_time hxc_time_building_blocks.start_time%type;
30: l_stop_time hxc_time_building_blocks.stop_time%type;

Line 55: insert into hxc_template_summary

51: --
52: -- Insert Summary Row
53: --
54:
55: insert into hxc_template_summary
56: (TEMPLATE_ID,
57: TEMPLATE_OVN,
58: TEMPLATE_NAME,
59: DESCRIPTION,

Line 106: delete from hxc_template_summary where template_id = p_template_id;

102: PROCEDURE DELETE_SUMMARY_ROW(p_template_id in hxc_time_building_blocks.time_building_block_id%type) is
103:
104: Begin
105:
106: delete from hxc_template_summary where template_id = p_template_id;
107:
108: Exception
109: When others then
110: FND_MESSAGE.set_name('HXC','HXC_NO_TEMPLATE_ID');

Line 114: END HXC_TEMPLATE_SUMMARY_PKG;

110: FND_MESSAGE.set_name('HXC','HXC_NO_TEMPLATE_ID');
111: FND_MESSAGE.raise_error;
112:
113: END DELETE_SUMMARY_ROW;
114: END HXC_TEMPLATE_SUMMARY_PKG;