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.

[Home] [Help]

APPS.HXC_BLOCK_ATTRIBUTE_UPDATE dependencies on HXC_TIMECARD

Line 42: l_template_index := hxc_timecard_block_utils.find_active_timecard_index

38: --
39: IF(p_duplicate_template = TRUE) THEN
40: l_replace := true;
41: ELSE
42: l_template_index := hxc_timecard_block_utils.find_active_timecard_index
43: (p_blocks);
44:
45:
46: open c_template_is_a_timecard

Line 55: if(l_dummy_scope = hxc_timecard.c_timecard_scope) then

51: fetch c_template_is_a_timecard into l_dummy_scope;
52: if(c_template_is_a_timecard%NOTFOUND) then
53: l_replace := true;
54: else
55: if(l_dummy_scope = hxc_timecard.c_timecard_scope) then
56: l_replace := true;
57: else
58: l_replace := false;
59: end if;

Line 74: p_blocks(l_block_index).changed := hxc_timecard.c_yes;

70: Exit When Not p_blocks.exists(l_block_index);
71: l_block_replacement_ids(p_blocks(l_block_index).time_building_block_id) := l_block_start;
72: p_blocks(l_block_index).time_building_block_id := l_block_start;
73: p_blocks(l_block_index).object_version_number := 1;
74: p_blocks(l_block_index).changed := hxc_timecard.c_yes;
75: p_blocks(l_block_index).new := hxc_timecard.c_yes;
76: p_blocks(l_block_index).process := hxc_timecard.c_yes;
77: p_blocks(l_block_index).parent_is_new := hxc_timecard.c_yes;
78:

Line 75: p_blocks(l_block_index).new := hxc_timecard.c_yes;

71: l_block_replacement_ids(p_blocks(l_block_index).time_building_block_id) := l_block_start;
72: p_blocks(l_block_index).time_building_block_id := l_block_start;
73: p_blocks(l_block_index).object_version_number := 1;
74: p_blocks(l_block_index).changed := hxc_timecard.c_yes;
75: p_blocks(l_block_index).new := hxc_timecard.c_yes;
76: p_blocks(l_block_index).process := hxc_timecard.c_yes;
77: p_blocks(l_block_index).parent_is_new := hxc_timecard.c_yes;
78:
79: l_block_start := l_block_start -1;

Line 76: p_blocks(l_block_index).process := hxc_timecard.c_yes;

72: p_blocks(l_block_index).time_building_block_id := l_block_start;
73: p_blocks(l_block_index).object_version_number := 1;
74: p_blocks(l_block_index).changed := hxc_timecard.c_yes;
75: p_blocks(l_block_index).new := hxc_timecard.c_yes;
76: p_blocks(l_block_index).process := hxc_timecard.c_yes;
77: p_blocks(l_block_index).parent_is_new := hxc_timecard.c_yes;
78:
79: l_block_start := l_block_start -1;
80: l_block_index := p_blocks.next(l_block_index);

Line 77: p_blocks(l_block_index).parent_is_new := hxc_timecard.c_yes;

73: p_blocks(l_block_index).object_version_number := 1;
74: p_blocks(l_block_index).changed := hxc_timecard.c_yes;
75: p_blocks(l_block_index).new := hxc_timecard.c_yes;
76: p_blocks(l_block_index).process := hxc_timecard.c_yes;
77: p_blocks(l_block_index).parent_is_new := hxc_timecard.c_yes;
78:
79: l_block_start := l_block_start -1;
80: l_block_index := p_blocks.next(l_block_index);
81: End Loop;

Line 107: p_attributes(l_attribute_index).changed := hxc_timecard.c_yes;

103: p_attributes(l_attribute_index).object_version_number := 1;
104: p_attributes(l_attribute_index).building_block_ovn :=1;
105: p_attributes(l_attribute_index).building_block_id :=
106: l_block_replacement_ids(p_attributes(l_attribute_index).building_block_id);
107: p_attributes(l_attribute_index).changed := hxc_timecard.c_yes;
108: p_attributes(l_attribute_index).new := hxc_timecard.c_yes;
109: p_attributes(l_attribute_index).process := hxc_timecard.c_yes;
110: l_attribute_start := l_attribute_start -1;
111: l_attribute_index := p_attributes.next(l_attribute_index);

Line 108: p_attributes(l_attribute_index).new := hxc_timecard.c_yes;

104: p_attributes(l_attribute_index).building_block_ovn :=1;
105: p_attributes(l_attribute_index).building_block_id :=
106: l_block_replacement_ids(p_attributes(l_attribute_index).building_block_id);
107: p_attributes(l_attribute_index).changed := hxc_timecard.c_yes;
108: p_attributes(l_attribute_index).new := hxc_timecard.c_yes;
109: p_attributes(l_attribute_index).process := hxc_timecard.c_yes;
110: l_attribute_start := l_attribute_start -1;
111: l_attribute_index := p_attributes.next(l_attribute_index);
112: End Loop;

Line 109: p_attributes(l_attribute_index).process := hxc_timecard.c_yes;

105: p_attributes(l_attribute_index).building_block_id :=
106: l_block_replacement_ids(p_attributes(l_attribute_index).building_block_id);
107: p_attributes(l_attribute_index).changed := hxc_timecard.c_yes;
108: p_attributes(l_attribute_index).new := hxc_timecard.c_yes;
109: p_attributes(l_attribute_index).process := hxc_timecard.c_yes;
110: l_attribute_start := l_attribute_start -1;
111: l_attribute_index := p_attributes.next(l_attribute_index);
112: End Loop;
113:

Line 142: (hxc_timecard_block_utils.date_value(p_blocks(l_block_index).stop_time)

138: IF (p_mode = 'ADD') THEN
139:
140: IF(p_blocks(l_block_index).type = 'RANGE' ) THEN
141: p_blocks(l_block_index).measure:=
142: (hxc_timecard_block_utils.date_value(p_blocks(l_block_index).stop_time)
143: -hxc_timecard_block_utils.date_value(p_blocks(l_block_index).start_time)
144: )*24;
145: p_blocks(l_block_index).unit_of_measure:= 'HOURS';
146: END IF;

Line 143: -hxc_timecard_block_utils.date_value(p_blocks(l_block_index).start_time)

139:
140: IF(p_blocks(l_block_index).type = 'RANGE' ) THEN
141: p_blocks(l_block_index).measure:=
142: (hxc_timecard_block_utils.date_value(p_blocks(l_block_index).stop_time)
143: -hxc_timecard_block_utils.date_value(p_blocks(l_block_index).start_time)
144: )*24;
145: p_blocks(l_block_index).unit_of_measure:= 'HOURS';
146: END IF;
147:

Line 181: if(hxc_timecard_block_utils.is_new_block(l_block)) then

177: EXIT WHEN NOT p_blocks.exists(l_index);
178:
179: l_block := p_blocks(l_index);
180:
181: if(hxc_timecard_block_utils.is_new_block(l_block)) then
182:
183: if(hxc_timecard_block_utils.is_active_block(l_block)) then
184: p_blocks(l_index).process := 'Y';
185: else

Line 183: if(hxc_timecard_block_utils.is_active_block(l_block)) then

179: l_block := p_blocks(l_index);
180:
181: if(hxc_timecard_block_utils.is_new_block(l_block)) then
182:
183: if(hxc_timecard_block_utils.is_active_block(l_block)) then
184: p_blocks(l_index).process := 'Y';
185: else
186: p_blocks(l_index).process := 'N';
187: end if;

Line 191: l_old_block := hxc_timecard_block_utils.build_block

187: end if;
188:
189: else
190: begin
191: l_old_block := hxc_timecard_block_utils.build_block
192: (p_time_building_block_id => l_block.time_building_block_id
193: ,p_time_building_block_ovn => l_block.object_version_number
194: );
195:

Line 196: if(hxc_timecard_block_utils.blocks_are_different

192: (p_time_building_block_id => l_block.time_building_block_id
193: ,p_time_building_block_ovn => l_block.object_version_number
194: );
195:
196: if(hxc_timecard_block_utils.blocks_are_different
197: (p_block1 => l_block
198: ,p_block2 => l_old_block
199: )
200: ) then

Line 214: if(hxc_timecard_block_utils.parent_has_changed(p_blocks,p_blocks(l_index).parent_building_block_id)) then

210: p_blocks(l_index).process := 'N';
211:
212: end;
213:
214: if(hxc_timecard_block_utils.parent_has_changed(p_blocks,p_blocks(l_index).parent_building_block_id)) then
215: p_blocks(l_index).process := 'Y';
216: end if;
217:
218: end if;

Line 250: if(NOT hxc_timecard_attribute_utils.is_system_context(l_attribute)) then

246:
247: p_attributes(l_index).process := 'Y';
248:
249: else
250: if(NOT hxc_timecard_attribute_utils.is_system_context(l_attribute)) then
251: begin
252: l_old_attribute := hxc_timecard_attribute_utils.build_attribute
253: (p_time_attribute_id => l_attribute.time_attribute_id
254: ,p_object_version_number => l_attribute.object_version_number

Line 252: l_old_attribute := hxc_timecard_attribute_utils.build_attribute

248:
249: else
250: if(NOT hxc_timecard_attribute_utils.is_system_context(l_attribute)) then
251: begin
252: l_old_attribute := hxc_timecard_attribute_utils.build_attribute
253: (p_time_attribute_id => l_attribute.time_attribute_id
254: ,p_object_version_number => l_attribute.object_version_number
255: ,p_time_building_block_id => l_attribute.building_block_id
256: ,p_time_building_block_ovn => l_attribute.building_block_ovn

Line 259: if(hxc_timecard_attribute_utils.attributes_are_different

255: ,p_time_building_block_id => l_attribute.building_block_id
256: ,p_time_building_block_ovn => l_attribute.building_block_ovn
257: );
258:
259: if(hxc_timecard_attribute_utils.attributes_are_different
260: (p_attribute1 => l_attribute
261: ,p_attribute2 => l_old_attribute
262: )
263: ) then

Line 337: if(p_blocks(l_block_index).process = hxc_timecard.c_yes) then

333: l_block_index := p_blocks.first;
334: Loop
335: Exit when not p_blocks.exists(l_block_index);
336:
337: if(p_blocks(l_block_index).process = hxc_timecard.c_yes) then
338: l_process_blocks(p_blocks(l_block_index).time_building_block_id) := l_block_index;
339: end if;
340:
341: l_block_index := p_blocks.next(l_block_index);

Line 360: if(p_attributes(l_attribute_index).process = hxc_timecard.c_yes) then

356: l_attribute_index := p_attributes.first;
357: Loop
358: Exit when not p_attributes.exists(l_attribute_index);
359:
360: if(p_attributes(l_attribute_index).process = hxc_timecard.c_yes) then
361: l_process_blocks(p_attributes(l_attribute_index).building_block_id):= l_attribute_index;
362: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; -- SHIV
363: else
364: if(l_process_blocks.exists(p_attributes(l_attribute_index).building_block_id))then

Line 362: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; -- SHIV

358: Exit when not p_attributes.exists(l_attribute_index);
359:
360: if(p_attributes(l_attribute_index).process = hxc_timecard.c_yes) then
361: l_process_blocks(p_attributes(l_attribute_index).building_block_id):= l_attribute_index;
362: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; -- SHIV
363: else
364: if(l_process_blocks.exists(p_attributes(l_attribute_index).building_block_id))then
365: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; --Doubt
366: p_attributes(l_attribute_index).process := hxc_timecard.c_yes; --Doubt

Line 365: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; --Doubt

361: l_process_blocks(p_attributes(l_attribute_index).building_block_id):= l_attribute_index;
362: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; -- SHIV
363: else
364: if(l_process_blocks.exists(p_attributes(l_attribute_index).building_block_id))then
365: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; --Doubt
366: p_attributes(l_attribute_index).process := hxc_timecard.c_yes; --Doubt
367: else
368: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_no;
369: p_attributes(l_attribute_index).process := hxc_timecard.c_no;

Line 366: p_attributes(l_attribute_index).process := hxc_timecard.c_yes; --Doubt

362: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; -- SHIV
363: else
364: if(l_process_blocks.exists(p_attributes(l_attribute_index).building_block_id))then
365: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; --Doubt
366: p_attributes(l_attribute_index).process := hxc_timecard.c_yes; --Doubt
367: else
368: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_no;
369: p_attributes(l_attribute_index).process := hxc_timecard.c_no;
370: end if;

Line 368: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_no;

364: if(l_process_blocks.exists(p_attributes(l_attribute_index).building_block_id))then
365: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; --Doubt
366: p_attributes(l_attribute_index).process := hxc_timecard.c_yes; --Doubt
367: else
368: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_no;
369: p_attributes(l_attribute_index).process := hxc_timecard.c_no;
370: end if;
371: end if;
372: l_attribute_index := p_attributes.next(l_attribute_index);

Line 369: p_attributes(l_attribute_index).process := hxc_timecard.c_no;

365: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_yes; --Doubt
366: p_attributes(l_attribute_index).process := hxc_timecard.c_yes; --Doubt
367: else
368: -- p_attributes(l_attribute_index).changed := hxc_timecard.c_no;
369: p_attributes(l_attribute_index).process := hxc_timecard.c_no;
370: end if;
371: end if;
372: l_attribute_index := p_attributes.next(l_attribute_index);
373: End Loop;

Line 384: p_blocks(l_block_index).process := hxc_timecard.c_yes;

380: l_block_index := p_blocks.first;
381: Loop
382: Exit when not p_blocks.exists(l_block_index);
383: if(l_process_blocks.exists(p_blocks(l_block_index).time_building_block_id)) then
384: p_blocks(l_block_index).process := hxc_timecard.c_yes;
385: else
386: p_blocks(l_block_index).process := hxc_timecard.c_no;
387: end if;
388:

Line 386: p_blocks(l_block_index).process := hxc_timecard.c_no;

382: Exit when not p_blocks.exists(l_block_index);
383: if(l_process_blocks.exists(p_blocks(l_block_index).time_building_block_id)) then
384: p_blocks(l_block_index).process := hxc_timecard.c_yes;
385: else
386: p_blocks(l_block_index).process := hxc_timecard.c_no;
387: end if;
388:
389: -- This is for PA validation
390: --SHIV

Line 391: -- if(hxc_timecard_block_utils.parent_has_changed(p_blocks,p_blocks(l_block_index).parent_building_block_id)) then

387: end if;
388:
389: -- This is for PA validation
390: --SHIV
391: -- if(hxc_timecard_block_utils.parent_has_changed(p_blocks,p_blocks(l_block_index).parent_building_block_id)) then
392: -- p_blocks(l_block_index).changed := hxc_timecard.c_yes;
393: -- end if;
394:
395: l_block_index := p_blocks.next(l_block_index);

Line 392: -- p_blocks(l_block_index).changed := hxc_timecard.c_yes;

388:
389: -- This is for PA validation
390: --SHIV
391: -- if(hxc_timecard_block_utils.parent_has_changed(p_blocks,p_blocks(l_block_index).parent_building_block_id)) then
392: -- p_blocks(l_block_index).changed := hxc_timecard.c_yes;
393: -- end if;
394:
395: l_block_index := p_blocks.next(l_block_index);
396: End Loop;