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_TIME_ATTRIBUTES_API dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: hxctatapi.pkb 120.4 2005/10/23 02:14:30 gkrishna noship $ */
3:
4: g_package varchar2(33) := ' hxc_time_attributes_api.';
5:
6: g_debug boolean := hr_utility.debug_enabled;
7:
8: -- private procedure
9: -- extract_info_types
10: --

Line 39: --hr_utility.set_location('gaz: '|| l_proc, 50);

35:
36:
37: --if g_debug then
38: --l_proc := 'extract_info_types ';
39: --hr_utility.set_location('gaz: '|| l_proc, 50);
40: --end if;
41: -- initialize array. the maximum number of distinct information types
42: -- is equal to the number of attributes in the timecard
43: --l_gaz := to_char(p_timecard.count);

Line 45: --hr_utility.set_location('gaz count is '|| l_gaz, 60);

41: -- initialize array. the maximum number of distinct information types
42: -- is equal to the number of attributes in the timecard
43: --l_gaz := to_char(p_timecard.count);
44: --if g_debug then
45: --hr_utility.set_location('gaz count is '|| l_gaz, 60);
46: --end if;
47: for l_rownum in 1..p_timecard.count loop
48: --if g_debug then
49: --hr_utility.set_location('gaz: '|| l_proc, 60);

Line 49: --hr_utility.set_location('gaz: '|| l_proc, 60);

45: --hr_utility.set_location('gaz count is '|| l_gaz, 60);
46: --end if;
47: for l_rownum in 1..p_timecard.count loop
48: --if g_debug then
49: --hr_utility.set_location('gaz: '|| l_proc, 60);
50: --end if;
51: l_info_types(l_rownum):=null;
52: end loop;
53:

Line 57: --hr_utility.set_location('gaz: '|| l_proc, 70);

53:
54: -- identify distinct information types and store them by iterative
55: -- comparison of timecard and information type array
56: --if g_debug then
57: --hr_utility.set_location('gaz: '|| l_proc, 70);
58: --end if;
59: l_info_types(l_it_loop) := p_timecard(l_tc_loop).information_type;
60:
61: for l_tc_loop in 1..p_timecard.count loop

Line 63: --hr_utility.set_location('gaz: '|| l_proc, 80);

59: l_info_types(l_it_loop) := p_timecard(l_tc_loop).information_type;
60:
61: for l_tc_loop in 1..p_timecard.count loop
62: --if g_debug then
63: --hr_utility.set_location('gaz: '|| l_proc, 80);
64: --end if;
65: if p_timecard(l_tc_loop).information_type <> l_info_types(l_it_loop) then
66: loop
67: --if g_debug then

Line 68: --hr_utility.set_location('gaz: '|| l_proc, 90);

64: --end if;
65: if p_timecard(l_tc_loop).information_type <> l_info_types(l_it_loop) then
66: loop
67: --if g_debug then
68: --hr_utility.set_location('gaz: '|| l_proc, 90);
69: --end if;
70: l_it_loop:=l_it_loop+1;
71: if p_timecard(l_tc_loop).information_type = l_info_types(l_it_loop) then
72: --if g_debug then

Line 73: --hr_utility.set_location('gaz: '|| l_proc, 100);

69: --end if;
70: l_it_loop:=l_it_loop+1;
71: if p_timecard(l_tc_loop).information_type = l_info_types(l_it_loop) then
72: --if g_debug then
73: --hr_utility.set_location('gaz: '|| l_proc, 100);
74: --end if;
75: l_info_type_noted := true;
76: end if;
77: --if g_debug then

Line 78: --hr_utility.set_location('gaz: '|| l_proc, 150);

74: --end if;
75: l_info_type_noted := true;
76: end if;
77: --if g_debug then
78: --hr_utility.set_location('gaz: '|| l_proc, 150);
79: --end if;
80: exit when l_info_types(l_it_loop) is null;
81: end loop;
82: if not l_info_type_noted then

Line 84: --hr_utility.set_location('gaz: '|| l_proc, 160);

80: exit when l_info_types(l_it_loop) is null;
81: end loop;
82: if not l_info_type_noted then
83: --if g_debug then
84: --hr_utility.set_location('gaz: '|| l_proc, 160);
85: --end if;
86: l_info_types(l_it_loop) := p_timecard(l_tc_loop).information_type;
87: end if;
88: end if;

Line 91: --hr_utility.set_location('gaz: '|| l_proc, 170);

87: end if;
88: end if;
89: l_it_loop := 1;
90: --if g_debug then
91: --hr_utility.set_location('gaz: '|| l_proc, 170);
92: --end if;
93: l_info_type_noted := false;
94: end loop;
95: --if g_debug then

Line 96: --hr_utility.set_location('gaz: '|| l_proc, 180);

92: --end if;
93: l_info_type_noted := false;
94: end loop;
95: --if g_debug then
96: --hr_utility.set_location('gaz: '|| l_proc, 180);
97: --end if;
98:
99: -- delete empty cells from information type array
100: for l_it_loop in 1..p_timecard.count loop

Line 102: --hr_utility.set_location('gaz: '|| l_proc, 190);

98:
99: -- delete empty cells from information type array
100: for l_it_loop in 1..p_timecard.count loop
101: --if g_debug then
102: --hr_utility.set_location('gaz: '|| l_proc, 190);
103: --end if;
104: if l_info_types(l_it_loop) is null then
105: --if g_debug then
106: --hr_utility.set_location('gaz: '|| l_proc, 200);

Line 106: --hr_utility.set_location('gaz: '|| l_proc, 200);

102: --hr_utility.set_location('gaz: '|| l_proc, 190);
103: --end if;
104: if l_info_types(l_it_loop) is null then
105: --if g_debug then
106: --hr_utility.set_location('gaz: '|| l_proc, 200);
107: --end if;
108: l_info_types.delete(l_it_loop);
109: end if;
110: end loop;

Line 113: --hr_utility.set_location('gaz: '|| l_proc, 210);

109: end if;
110: end loop;
111:
112: --if g_debug then
113: --hr_utility.set_location('gaz: '|| l_proc, 210);
114: --end if;
115: -- assign out parameter
116: p_info_types := l_info_types;
117:

Line 192: --hr_utility.set_location('gaz: '|| l_proc, 10);

188:
189: -- initialize local attribute array
190: --if g_debug then
191: --l_proc := ' parse_Table';
192: --hr_utility.set_location('gaz: '|| l_proc, 10);
193: --end if;
194: for l_rownum in 1..30 loop
195: l_att_rec(l_rownum) := null;
196: end loop;

Line 199: --hr_utility.set_location('gaz: '|| l_proc, 20);

195: l_att_rec(l_rownum) := null;
196: end loop;
197:
198: --if g_debug then
199: --hr_utility.set_location('gaz: '|| l_proc, 20);
200: --end if;
201: -- load attribute values from table into mapped position in local array
202: for l_rownum in 1..p_timecard.count loop
203:

Line 205: --hr_utility.set_location('gaz: '|| l_proc, 30);

201: -- load attribute values from table into mapped position in local array
202: for l_rownum in 1..p_timecard.count loop
203:
204: --if g_debug then
205: --hr_utility.set_location('gaz: '|| l_proc, 30);
206: --end if;
207: -- check that a mapping exists for the named attribute in the current
208: -- deposit process
209: /*l_mapping_exists := hxc_mapping_utilities.attribute_column

Line 218: --hr_utility.set_location('gaz: '|| l_proc, 40);

214: ,l_information_type
215: );
216: */
217: --if g_debug then
218: --hr_utility.set_location('gaz: '|| l_proc, 40);
219: --end if;
220: -- if (l_mapping_exists) then
221: -- copy attribute value from timecard to local array
222: --if g_debug then

Line 223: -- hr_utility.set_location('gaz: '|| l_proc, 50);

219: --end if;
220: -- if (l_mapping_exists) then
221: -- copy attribute value from timecard to local array
222: --if g_debug then
223: -- hr_utility.set_location('gaz: '|| l_proc, 50);
224: --hr_utility.set_location('l info type is '|| l_information_type, 40);
225: --hr_utility.set_location('p info type is '|| p_information_type, 40);
226: -- hr_utility.set_location('l column name is '|| l_column_name, 40);
227: --end if;

Line 224: --hr_utility.set_location('l info type is '|| l_information_type, 40);

220: -- if (l_mapping_exists) then
221: -- copy attribute value from timecard to local array
222: --if g_debug then
223: -- hr_utility.set_location('gaz: '|| l_proc, 50);
224: --hr_utility.set_location('l info type is '|| l_information_type, 40);
225: --hr_utility.set_location('p info type is '|| p_information_type, 40);
226: -- hr_utility.set_location('l column name is '|| l_column_name, 40);
227: --end if;
228: l_column_name := p_timecard(l_rownum).column_name;

Line 225: --hr_utility.set_location('p info type is '|| p_information_type, 40);

221: -- copy attribute value from timecard to local array
222: --if g_debug then
223: -- hr_utility.set_location('gaz: '|| l_proc, 50);
224: --hr_utility.set_location('l info type is '|| l_information_type, 40);
225: --hr_utility.set_location('p info type is '|| p_information_type, 40);
226: -- hr_utility.set_location('l column name is '|| l_column_name, 40);
227: --end if;
228: l_column_name := p_timecard(l_rownum).column_name;
229: l_information_type := p_timecard(l_rownum).info_mapping_type;

Line 226: -- hr_utility.set_location('l column name is '|| l_column_name, 40);

222: --if g_debug then
223: -- hr_utility.set_location('gaz: '|| l_proc, 50);
224: --hr_utility.set_location('l info type is '|| l_information_type, 40);
225: --hr_utility.set_location('p info type is '|| p_information_type, 40);
226: -- hr_utility.set_location('l column name is '|| l_column_name, 40);
227: --end if;
228: l_column_name := p_timecard(l_rownum).column_name;
229: l_information_type := p_timecard(l_rownum).info_mapping_type;
230:

Line 266: --hr_utility.set_location('gaz: '|| l_proc, 70);

262: end if;
263:
264: -- copy local array to output parameters
265: --if g_debug then
266: --hr_utility.set_location('gaz: '|| l_proc, 70);
267: --end if;
268: p_attribute1 := l_att_rec(1);
269: p_attribute2 := l_att_rec(2);
270: p_attribute3 := l_att_rec(3);

Line 279: --hr_utility.set_location('gaz: '|| l_proc, 80);

275: p_attribute8 := l_att_rec(8);
276: p_attribute9 := l_att_rec(9);
277: p_attribute10 := l_att_rec(10);
278: --if g_debug then
279: --hr_utility.set_location('gaz: '|| l_proc, 80);
280: --end if;
281: p_attribute11 := l_att_rec(11);
282: p_attribute12 := l_att_rec(12);
283: p_attribute13 := l_att_rec(13);

Line 292: -- hr_utility.set_location('gaz: '|| l_proc, 90);

288: p_attribute18 := l_att_rec(18);
289: p_attribute19 := l_att_rec(19);
290: p_attribute20 := l_att_rec(20);
291: --if g_debug then
292: -- hr_utility.set_location('gaz: '|| l_proc, 90);
293: --end if;
294: p_attribute21 := l_att_rec(21);
295: p_attribute22 := l_att_rec(22);
296: p_attribute23 := l_att_rec(23);

Line 305: --hr_utility.set_location('gaz: '|| l_proc, 100);

301: p_attribute28 := l_att_rec(28);
302: p_attribute29 := l_att_rec(29);
303: p_attribute30 := l_att_rec(30);
304: --if g_debug then
305: --hr_utility.set_location('gaz: '|| l_proc, 100);
306: --end if;
307:
308: exception
309: when e_no_attribute_mapping then

Line 393: g_debug := hr_utility.debug_enabled;

389: l_data_set_id hxc_time_attributes.data_set_id%type;
390: e_usage_data_missing exception;
391: begin
392:
393: g_debug := hr_utility.debug_enabled;
394:
395: if g_debug then
396: l_proc := g_package||'create_attributes';
397: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 397: hr_utility.set_location('Entering:'|| l_proc, 10);

393: g_debug := hr_utility.debug_enabled;
394:
395: if g_debug then
396: l_proc := g_package||'create_attributes';
397: hr_utility.set_location('Entering:'|| l_proc, 10);
398: end if;
399:
400: -- break down the timecard into its component attributes
401:

Line 408: hr_utility.set_location('gaz: '|| l_proc, 50);

404: ,p_info_types => l_info_type_table
405: );
406:
407: if g_debug then
408: hr_utility.set_location('gaz: '|| l_proc, 50);
409: end if;
410:
411: for l_rownum in 1..l_info_type_table.count loop
412:

Line 416: hr_utility.set_location('gaz: '|| l_proc, 60);

412:
413: l_information_type := l_info_type_table(l_rownum);
414:
415: if g_debug then
416: hr_utility.set_location('gaz: '|| l_proc, 60);
417: end if;
418:
419: parse_table
420: (p_process_id => p_process_id

Line 467: hr_utility.set_location('gaz: '|| l_proc, 70);

463:
464: -- get the information type id (bld_blk_info_type_id)
465: -- MS added attribute category
466: if g_debug then
467: hr_utility.set_location('gaz: '|| l_proc, 70);
468: end if;
469: open c_bld_blk_info_type_id(l_info_type_table(l_rownum));
470: fetch c_bld_blk_info_type_id into l_bld_blk_info_type_id;
471: close c_bld_blk_info_type_id;

Line 473: hr_utility.set_location('gaz: '|| l_proc, 80);

469: open c_bld_blk_info_type_id(l_info_type_table(l_rownum));
470: fetch c_bld_blk_info_type_id into l_bld_blk_info_type_id;
471: close c_bld_blk_info_type_id;
472: if g_debug then
473: hr_utility.set_location('gaz: '|| l_proc, 80);
474: end if;
475:
476: /* open c_get_data_set(p_time_building_block_id,p_tbb_ovn);
477: fetch c_get_data_set into l_data_set_id;

Line 523: hr_utility.set_location('gaz: '|| l_proc, 90);

519:
520: -- insert row into hxc_time_attribute_usages to associate attributes
521: -- with a building block
522: if g_debug then
523: hr_utility.set_location('gaz: '|| l_proc, 90);
524: end if;
525:
526: -- open c_attribute_usage_sequence; -- refer Bug#3062133
527: -- fetch c_attribute_usage_sequence into l_time_attribute_usage_id;

Line 531: hr_utility.set_location('gaz: '|| l_proc, 100);

527: -- fetch c_attribute_usage_sequence into l_time_attribute_usage_id;
528: -- close c_attribute_usage_sequence;
529:
530: if g_debug then
531: hr_utility.set_location('gaz: '|| l_proc, 100);
532: end if;
533:
534: if ((p_time_building_block_id IS NULL) OR (l_time_attribute_id is NULL)) then
535: raise e_usage_data_missing;

Line 761: g_debug := hr_utility.debug_enabled;

757: l_object_version_number hxc_time_attributes.object_version_number%type;
758:
759: begin
760:
761: g_debug := hr_utility.debug_enabled;
762:
763: if g_debug then
764: l_proc := g_package||'update_attributes';
765: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 765: hr_utility.set_location('Entering:'|| l_proc, 10);

761: g_debug := hr_utility.debug_enabled;
762:
763: if g_debug then
764: l_proc := g_package||'update_attributes';
765: hr_utility.set_location('Entering:'|| l_proc, 10);
766: end if;
767:
768: -- issue a savepoint
769: savepoint update_building_block;

Line 787: hr_utility.set_location(' Leaving:'|| l_proc, 20);

783: -- set out parameters
784: p_object_version_number := l_object_version_number;
785:
786: if g_debug then
787: hr_utility.set_location(' Leaving:'|| l_proc, 20);
788: end if;
789:
790: exception
791: when hr_api.validate_enabled then