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

Line 1: PACKAGE BODY HXC_TEMPLATE_SUMMARY_API AS

1: PACKAGE BODY HXC_TEMPLATE_SUMMARY_API AS
2: /* $Header: hxctempsumapi.pkb 120.2 2005/12/12 08:28:50 gkrishna noship $ */
3:
4: FUNCTION TEMPLATE_PRESENT
5: (p_template_id in hxc_template_summary.template_id%type)

Line 5: (p_template_id in hxc_template_summary.template_id%type)

1: PACKAGE BODY HXC_TEMPLATE_SUMMARY_API AS
2: /* $Header: hxctempsumapi.pkb 120.2 2005/12/12 08:28:50 gkrishna noship $ */
3:
4: FUNCTION TEMPLATE_PRESENT
5: (p_template_id in hxc_template_summary.template_id%type)
6: RETURN HXC_TEMPLATE_SUMMARY.RESOURCE_ID%TYPE IS
7:
8: l_resource_id hxc_template_summary.resource_id%type;
9:

Line 6: RETURN HXC_TEMPLATE_SUMMARY.RESOURCE_ID%TYPE IS

2: /* $Header: hxctempsumapi.pkb 120.2 2005/12/12 08:28:50 gkrishna noship $ */
3:
4: FUNCTION TEMPLATE_PRESENT
5: (p_template_id in hxc_template_summary.template_id%type)
6: RETURN HXC_TEMPLATE_SUMMARY.RESOURCE_ID%TYPE IS
7:
8: l_resource_id hxc_template_summary.resource_id%type;
9:
10: BEGIN

Line 8: l_resource_id hxc_template_summary.resource_id%type;

4: FUNCTION TEMPLATE_PRESENT
5: (p_template_id in hxc_template_summary.template_id%type)
6: RETURN HXC_TEMPLATE_SUMMARY.RESOURCE_ID%TYPE IS
7:
8: l_resource_id hxc_template_summary.resource_id%type;
9:
10: BEGIN
11:
12: select resource_id

Line 14: from hxc_template_summary

10: BEGIN
11:
12: select resource_id
13: into l_resource_id
14: from hxc_template_summary
15: where template_id = p_template_id;
16:
17: return l_resource_id;
18:

Line 30: l_resource_id hxc_template_summary.resource_id%type;

26: p_template_id in number
27: ) is
28:
29: l_index number;
30: l_resource_id hxc_template_summary.resource_id%type;
31: Begin
32:
33: -- Delete the existing template information in the summary.
34: --

Line 44: hxc_template_summary_pkg.delete_summary_row

40:
41:
42:
43: if( l_resource_id is not null) then
44: hxc_template_summary_pkg.delete_summary_row
45: (p_template_id => p_template_id);
46: end if;
47:
48: END DELETE_TEMPLATE;

Line 54: p_template_id in hxc_template_summary.template_id%type,

50: --Called during the template migration.
51:
52: PROCEDURE TEMPLATE_DEPOSIT
53: (
54: p_template_id in hxc_template_summary.template_id%type,
55: p_template_ovn in HXC_TEMPLATE_SUMMARY.TEMPLATE_OVN%type
56: )
57: is
58: cursor c_template_attributes(p_template_id hxc_template_summary.template_id%type,p_template_ovn in HXC_TEMPLATE_SUMMARY.TEMPLATE_OVN%type)

Line 55: p_template_ovn in HXC_TEMPLATE_SUMMARY.TEMPLATE_OVN%type

51:
52: PROCEDURE TEMPLATE_DEPOSIT
53: (
54: p_template_id in hxc_template_summary.template_id%type,
55: p_template_ovn in HXC_TEMPLATE_SUMMARY.TEMPLATE_OVN%type
56: )
57: is
58: cursor c_template_attributes(p_template_id hxc_template_summary.template_id%type,p_template_ovn in HXC_TEMPLATE_SUMMARY.TEMPLATE_OVN%type)
59: is SELECT

Line 58: cursor c_template_attributes(p_template_id hxc_template_summary.template_id%type,p_template_ovn in HXC_TEMPLATE_SUMMARY.TEMPLATE_OVN%type)

54: p_template_id in hxc_template_summary.template_id%type,
55: p_template_ovn in HXC_TEMPLATE_SUMMARY.TEMPLATE_OVN%type
56: )
57: is
58: cursor c_template_attributes(p_template_id hxc_template_summary.template_id%type,p_template_ovn in HXC_TEMPLATE_SUMMARY.TEMPLATE_OVN%type)
59: is SELECT
60: a.attribute_category
61: ,a.attribute1
62: ,a.attribute2

Line 86: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;

82: OR (a.attribute_category = 'SECURITY')
83: OR (a.attribute_category = 'LAYOUT'))
84: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id;
85:
86: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
87: l_layout_id hxc_template_summary.LAYOUT_ID%type;
88: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
89: l_description hxc_template_summary.DESCRIPTION%type ;
90: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;

Line 87: l_layout_id hxc_template_summary.LAYOUT_ID%type;

83: OR (a.attribute_category = 'LAYOUT'))
84: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id;
85:
86: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
87: l_layout_id hxc_template_summary.LAYOUT_ID%type;
88: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
89: l_description hxc_template_summary.DESCRIPTION%type ;
90: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
91: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;

Line 88: l_template_name hxc_template_summary.TEMPLATE_NAME%type;

84: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id;
85:
86: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
87: l_layout_id hxc_template_summary.LAYOUT_ID%type;
88: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
89: l_description hxc_template_summary.DESCRIPTION%type ;
90: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
91: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;
92: l_resource_id hxc_template_summary.resource_id%type;

Line 89: l_description hxc_template_summary.DESCRIPTION%type ;

85:
86: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
87: l_layout_id hxc_template_summary.LAYOUT_ID%type;
88: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
89: l_description hxc_template_summary.DESCRIPTION%type ;
90: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
91: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;
92: l_resource_id hxc_template_summary.resource_id%type;
93:

Line 90: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;

86: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
87: l_layout_id hxc_template_summary.LAYOUT_ID%type;
88: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
89: l_description hxc_template_summary.DESCRIPTION%type ;
90: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
91: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;
92: l_resource_id hxc_template_summary.resource_id%type;
93:
94: BEGIN

Line 91: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;

87: l_layout_id hxc_template_summary.LAYOUT_ID%type;
88: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
89: l_description hxc_template_summary.DESCRIPTION%type ;
90: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
91: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;
92: l_resource_id hxc_template_summary.resource_id%type;
93:
94: BEGIN
95:

Line 92: l_resource_id hxc_template_summary.resource_id%type;

88: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
89: l_description hxc_template_summary.DESCRIPTION%type ;
90: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
91: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;
92: l_resource_id hxc_template_summary.resource_id%type;
93:
94: BEGIN
95:
96: --

Line 102: hxc_template_summary_pkg.delete_summary_row

98: --
99: l_resource_id := template_present(p_template_id);
100:
101: if( l_resource_id is not null) then
102: hxc_template_summary_pkg.delete_summary_row
103: (p_template_id => p_template_id);
104: end if;
105:
106: for template_attribute_rec in c_template_attributes(p_template_id,p_template_ovn)

Line 127: hxc_template_summary_pkg.insert_summary_row

123: end if;
124: if ((l_template_name is NOT null) and (l_business_group_id is not null) and
125: (l_layout_id is not null) and (l_template_type is not null)) then
126:
127: hxc_template_summary_pkg.insert_summary_row
128: (p_template_id => p_template_id,
129: p_template_ovn => p_template_ovn,
130: p_template_name =>l_template_name,
131: p_description =>l_description,

Line 148: p_template_id in hxc_template_summary.TEMPLATE_ID%type

144:
145: PROCEDURE TEMPLATE_DEPOSIT
146: (p_blocks in hxc_block_table_type,
147: p_attributes in HXC_ATTRIBUTE_TABLE_TYPE,
148: p_template_id in hxc_template_summary.TEMPLATE_ID%type
149: ) is
150:
151: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
152: l_layout_id hxc_template_summary.LAYOUT_ID%type;

Line 151: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;

147: p_attributes in HXC_ATTRIBUTE_TABLE_TYPE,
148: p_template_id in hxc_template_summary.TEMPLATE_ID%type
149: ) is
150:
151: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
152: l_layout_id hxc_template_summary.LAYOUT_ID%type;
153: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
154: l_description hxc_template_summary.DESCRIPTION%type ;
155: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;

Line 152: l_layout_id hxc_template_summary.LAYOUT_ID%type;

148: p_template_id in hxc_template_summary.TEMPLATE_ID%type
149: ) is
150:
151: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
152: l_layout_id hxc_template_summary.LAYOUT_ID%type;
153: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
154: l_description hxc_template_summary.DESCRIPTION%type ;
155: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
156: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;

Line 153: l_template_name hxc_template_summary.TEMPLATE_NAME%type;

149: ) is
150:
151: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
152: l_layout_id hxc_template_summary.LAYOUT_ID%type;
153: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
154: l_description hxc_template_summary.DESCRIPTION%type ;
155: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
156: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;
157: l_resource_id hxc_template_summary.resource_id%type;

Line 154: l_description hxc_template_summary.DESCRIPTION%type ;

150:
151: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
152: l_layout_id hxc_template_summary.LAYOUT_ID%type;
153: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
154: l_description hxc_template_summary.DESCRIPTION%type ;
155: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
156: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;
157: l_resource_id hxc_template_summary.resource_id%type;
158: l_timecard_index number;

Line 155: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;

151: l_recurring_period hxc_template_summary.RECURRING_PERIOD_ID%type ;
152: l_layout_id hxc_template_summary.LAYOUT_ID%type;
153: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
154: l_description hxc_template_summary.DESCRIPTION%type ;
155: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
156: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;
157: l_resource_id hxc_template_summary.resource_id%type;
158: l_timecard_index number;
159: l_index number;

Line 156: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;

152: l_layout_id hxc_template_summary.LAYOUT_ID%type;
153: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
154: l_description hxc_template_summary.DESCRIPTION%type ;
155: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
156: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;
157: l_resource_id hxc_template_summary.resource_id%type;
158: l_timecard_index number;
159: l_index number;
160:

Line 157: l_resource_id hxc_template_summary.resource_id%type;

153: l_template_name hxc_template_summary.TEMPLATE_NAME%type;
154: l_description hxc_template_summary.DESCRIPTION%type ;
155: l_template_type hxc_template_summary.TEMPLATE_TYPE%type;
156: l_business_group_id hxc_template_summary.BUSINESS_GROUP_ID%type;
157: l_resource_id hxc_template_summary.resource_id%type;
158: l_timecard_index number;
159: l_index number;
160:
161: BEGIN

Line 173: hxc_template_summary_pkg.delete_summary_row

169: --
170: l_resource_id := template_present(p_template_id);
171:
172: if( l_resource_id is not null) then
173: hxc_template_summary_pkg.delete_summary_row
174: (p_template_id => p_template_id);
175: end if;
176:
177: --

Line 206: hxc_template_summary_pkg.insert_summary_row

202: l_index := p_attributes.next(l_index);
203: End Loop;
204:
205:
206: hxc_template_summary_pkg.insert_summary_row
207: (p_template_id => p_blocks(l_timecard_index).time_building_block_id,
208: p_template_ovn => p_blocks(l_timecard_index).OBJECT_VERSION_NUMBER,
209: p_template_name =>l_template_name,
210: p_description =>l_description,

Line 220: END HXC_TEMPLATE_SUMMARY_API;

216: );
217:
218: END TEMPLATE_DEPOSIT;
219:
220: END HXC_TEMPLATE_SUMMARY_API;