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_SUMMARY_API dependencies on HXC_TIMECARD_SUMMARY

Line 1: package body hxc_timecard_summary_api as

1: package body hxc_timecard_summary_api as
2: /* $Header: hxctcsumapi.pkb 120.0.12010000.3 2008/08/05 12:06:35 ubhat ship $ */
3: Procedure delete_timecard
4: (p_blocks in hxc_block_table_type
5: ,p_timecard_id in number

Line 6: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

2: /* $Header: hxctcsumapi.pkb 120.0.12010000.3 2008/08/05 12:06:35 ubhat ship $ */
3: Procedure delete_timecard
4: (p_blocks in hxc_block_table_type
5: ,p_timecard_id in number
6: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
7: ) is
8:
9: l_index number;
10: l_previous_status hxc_timecard_summary.approval_status%type;

Line 10: l_previous_status hxc_timecard_summary.approval_status%type;

6: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
7: ) is
8:
9: l_index number;
10: l_previous_status hxc_timecard_summary.approval_status%type;
11:
12: l_item_key hxc_timecard_summary.approval_item_key%type;
13: l_dummy varchar2(1);
14:

Line 12: l_item_key hxc_timecard_summary.approval_item_key%type;

8:
9: l_index number;
10: l_previous_status hxc_timecard_summary.approval_status%type;
11:
12: l_item_key hxc_timecard_summary.approval_item_key%type;
13: l_dummy varchar2(1);
14:
15: cursor c_previously_submitted(
16: p_timecard_id in hxc_timecard_summary.timecard_id%type) is

Line 16: p_timecard_id in hxc_timecard_summary.timecard_id%type) is

12: l_item_key hxc_timecard_summary.approval_item_key%type;
13: l_dummy varchar2(1);
14:
15: cursor c_previously_submitted(
16: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
17: select ts.approval_status
18: from hxc_timecard_summary ts
19: where timecard_id = p_timecard_id
20: and exists(

Line 18: from hxc_timecard_summary ts

14:
15: cursor c_previously_submitted(
16: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
17: select ts.approval_status
18: from hxc_timecard_summary ts
19: where timecard_id = p_timecard_id
20: and exists(
21: select 1
22: from hxc_tc_ap_links tcl,

Line 33: from hxc_timecard_summary

29:
30: cursor c_get_item_key(p_timecard_id in number)
31: is
32: select approval_item_key
33: from hxc_timecard_summary
34: where timecard_id = p_timecard_id;
35:
36: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)
37: is

Line 36: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)

32: select approval_item_key
33: from hxc_timecard_summary
34: where timecard_id = p_timecard_id;
35:
36: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)
37: is
38: select 'Y'
39: from wf_item_activity_statuses wias
40: where item_type = 'HXCEMP'

Line 54: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then

50: -- indicating that there might still be an open notification
51: -- that requires cancellation.
52:
53: --
54: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then
55: open c_previously_submitted(p_timecard_id);
56: fetch c_previously_submitted into l_previous_status;
57: if (c_previously_submitted%found) then
58: /*

Line 101: hxc_timecard_summary_pkg.delete_summary_row

97:
98: -- 2. Delete the existing timecard information in the summary
99: --
100:
101: hxc_timecard_summary_pkg.delete_summary_row
102: (p_timecard_id => p_timecard_id);
103:
104: End delete_timecard;
105:

Line 107: (p_timecard_id in hxc_timecard_summary.timecard_id%type

103:
104: End delete_timecard;
105:
106: Procedure delete_timecard
107: (p_timecard_id in hxc_timecard_summary.timecard_id%type
108: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
109: ) is
110:
111: l_index number;

Line 108: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

104: End delete_timecard;
105:
106: Procedure delete_timecard
107: (p_timecard_id in hxc_timecard_summary.timecard_id%type
108: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
109: ) is
110:
111: l_index number;
112:

Line 115: l_item_key hxc_timecard_summary.approval_item_key%type;

111: l_index number;
112:
113: l_dummy varchar(1);
114:
115: l_item_key hxc_timecard_summary.approval_item_key%type;
116: l_dummy_ik varchar2(1);
117:
118: cursor c_previously_submitted(
119: p_timecard_id in hxc_timecard_summary.timecard_id%type) is

Line 119: p_timecard_id in hxc_timecard_summary.timecard_id%type) is

115: l_item_key hxc_timecard_summary.approval_item_key%type;
116: l_dummy_ik varchar2(1);
117:
118: cursor c_previously_submitted(
119: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
120: select '1'
121: from hxc_timecard_summary
122: where timecard_id = p_timecard_id;
123:

Line 121: from hxc_timecard_summary

117:
118: cursor c_previously_submitted(
119: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
120: select '1'
121: from hxc_timecard_summary
122: where timecard_id = p_timecard_id;
123:
124:
125: cursor c_get_item_key(p_timecard_id in number)

Line 128: from hxc_timecard_summary

124:
125: cursor c_get_item_key(p_timecard_id in number)
126: is
127: select approval_item_key
128: from hxc_timecard_summary
129: where timecard_id = p_timecard_id;
130:
131: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)
132: is

Line 131: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)

127: select approval_item_key
128: from hxc_timecard_summary
129: where timecard_id = p_timecard_id;
130:
131: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)
132: is
133: select 'Y'
134: from wf_item_activity_statuses wias
135: where item_type = 'HXCEMP'

Line 145: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then

141: --
142: -- 0. Close all nofications associated with this timecard, only
143: -- if we're not migrating.
144: --
145: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then
146:
147:
148: open c_previously_submitted(p_timecard_id);
149: fetch c_previously_submitted into l_dummy;

Line 192: hxc_timecard_summary_pkg.delete_summary_row

188: end if;
189:
190: -- 2. Delete the existing timecard information in the summary
191:
192: hxc_timecard_summary_pkg.delete_summary_row
193: (p_timecard_id => p_timecard_id);
194:
195: End delete_timecard;
196:

Line 199: (p_timecard_id in hxc_timecard_summary.timecard_id%type) return boolean is

195: End delete_timecard;
196:
197:
198: Function timecard_present
199: (p_timecard_id in hxc_timecard_summary.timecard_id%type) return boolean is
200:
201: l_dummy hxc_timecard_summary.timecard_id%type;
202:
203: begin

Line 201: l_dummy hxc_timecard_summary.timecard_id%type;

197:
198: Function timecard_present
199: (p_timecard_id in hxc_timecard_summary.timecard_id%type) return boolean is
200:
201: l_dummy hxc_timecard_summary.timecard_id%type;
202:
203: begin
204:
205: select timecard_id

Line 207: from hxc_timecard_summary

203: begin
204:
205: select timecard_id
206: into l_dummy
207: from hxc_timecard_summary
208: where timecard_id = p_timecard_id;
209:
210: return true;
211:

Line 242: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

238: End cleanup_timecards;
239:
240: procedure timecard_deposit
241: (p_blocks in hxc_block_table_type
242: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
243: ,p_approval_item_type in varchar2
244: ,p_approval_process_name in varchar2
245: ,p_approval_item_key in varchar2
246: ,p_tk_audit_item_type in varchar2

Line 265: hxc_timecard_summary_pkg.insert_summary_row

261: cleanup_timecards(p_blocks);
262: --
263: -- 3. Create timecard summary info
264: --
265: hxc_timecard_summary_pkg.insert_summary_row
266: (p_timecard_id => p_blocks(l_timecard_index).time_building_block_id
267: ,p_mode => p_mode
268: ,p_approval_item_type => p_approval_item_type
269: ,p_approval_process_name => p_approval_process_name

Line 279: if(p_mode = hxc_timecard_summary_pkg.c_migration_mode) then

275: --
276: -- 4. Create the link information if the
277: -- mode is migration
278: --
279: if(p_mode = hxc_timecard_summary_pkg.c_migration_mode) then
280: hxc_tc_ap_links_pkg.create_timecard_links
281: (p_timecard_id => p_blocks(l_timecard_index).time_building_block_id);
282: end if;
283: End timecard_deposit;

Line 286: (p_timecard_id in hxc_timecard_summary.timecard_id%type

282: end if;
283: End timecard_deposit;
284:
285: Procedure timecard_deposit
286: (p_timecard_id in hxc_timecard_summary.timecard_id%type
287: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
288: ,p_approval_item_type in varchar2
289: ,p_approval_process_name in varchar2
290: ,p_approval_item_key in varchar2

Line 287: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

283: End timecard_deposit;
284:
285: Procedure timecard_deposit
286: (p_timecard_id in hxc_timecard_summary.timecard_id%type
287: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
288: ,p_approval_item_type in varchar2
289: ,p_approval_process_name in varchar2
290: ,p_approval_item_key in varchar2
291: ,p_tk_audit_item_type in varchar2

Line 307: hxc_timecard_summary_pkg.insert_summary_row

303: delete_timecard(p_timecard_id, p_mode);
304: --
305: -- 3. Create timecard summary info
306: --
307: hxc_timecard_summary_pkg.insert_summary_row
308: (p_timecard_id => p_timecard_id
309: ,p_mode => p_mode
310: ,p_approval_item_type => p_approval_item_type
311: ,p_approval_process_name => p_approval_process_name

Line 329: delete_timecard(p_blocks,l_timecard_index, hxc_timecard_summary_pkg.c_normal_mode);

325: Begin
326:
327: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
328:
329: delete_timecard(p_blocks,l_timecard_index, hxc_timecard_summary_pkg.c_normal_mode);
330:
331: End timecard_delete;
332:
333: Procedure timecard_delete

Line 334: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is

330:
331: End timecard_delete;
332:
333: Procedure timecard_delete
334: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
335:
336: Begin
337:
338: delete_timecard(p_timecard_id, hxc_timecard_summary_pkg.c_normal_mode);

Line 338: delete_timecard(p_timecard_id, hxc_timecard_summary_pkg.c_normal_mode);

334: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
335:
336: Begin
337:
338: delete_timecard(p_timecard_id, hxc_timecard_summary_pkg.c_normal_mode);
339:
340: End timecard_delete;
341:
342: procedure reject_timecards

Line 354: from hxc_tc_ap_links lnk, hxc_timecard_summary ts

350:
351: cursor c_timecards
352: (p_ap_id in hxc_tc_ap_links.application_period_id%type) is
353: select ts.timecard_id
354: from hxc_tc_ap_links lnk, hxc_timecard_summary ts
355: where application_period_id = p_ap_id
356: and ts.timecard_id = lnk.timecard_id
357: and ts.approval_status <> hxc_timecard.c_rejected_status;
358:

Line 362: hxc_timecard_summary_pkg.reject_timecard(tc_rec.timecard_id);

358:
359: Begin
360:
361: for tc_rec in c_timecards(p_application_period_id) loop
362: hxc_timecard_summary_pkg.reject_timecard(tc_rec.timecard_id);
363: end loop;
364:
365: End reject_timecards;
366:

Line 373: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1

369:
370: cursor c_timecards_to_check
371: (p_id in hxc_app_period_summary.application_period_id%type) is
372: select tc1.timecard_id ,tc1.approval_status
373: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1
374: where lnk1.application_period_id = p_id
375: and lnk1.timecard_id = tc1.timecard_id
376: and tc1.approval_status <> hxc_timecard.c_submitted_status;
377:

Line 396: hxc_timecard_summary_pkg.submit_timecard(tc_check.timecard_id);

392: --
393: -- It doesn't matter about the other approval periods
394: -- just set the timecards to submitted.
395: --
396: hxc_timecard_summary_pkg.submit_timecard(tc_check.timecard_id);
397: elsif(tc_check.approval_status = hxc_timecard.c_rejected_status) then
398: --
399: -- It must be rejected, therefore we should check to see if we
400: -- can upgrade to submitted status (since we only look for APPROVED

Line 409: hxc_timecard_summary_pkg.submit_timecard(tc_check.timecard_id);

405: if (c_any_reject_app_periods%notfound) then
406: --
407: -- There are no more REJECTED app periods update to
408: -- submitted.
409: hxc_timecard_summary_pkg.submit_timecard(tc_check.timecard_id);
410: end if;
411: close c_any_reject_app_periods;
412: else
413: -- Timecard status should not be changed if it is submitted or

Line 428: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1

424:
425: cursor c_timecards_to_check
426: (p_id in hxc_app_period_summary.application_period_id%type) is
427: select tc1.timecard_id
428: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1
429: where lnk1.application_period_id = p_id
430: and lnk1.timecard_id = tc1.timecard_id
431: and tc1.approval_status = hxc_timecard.c_submitted_status;
432:

Line 434: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is

430: and lnk1.timecard_id = tc1.timecard_id
431: and tc1.approval_status = hxc_timecard.c_submitted_status;
432:
433: cursor c_any_non_approved_app_periods
434: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
435: select asm.approval_status
436: from hxc_app_period_summary asm, hxc_tc_ap_links lnk1
437: where lnk1.timecard_id = p_timecard_id
438: and lnk1.application_period_id = asm.application_period_id

Line 458: hxc_timecard_summary_pkg.approve_timecard(tc_check.timecard_id);

454: close c_any_non_approved_app_periods;
455: --
456: -- We can appprove this timecard!
457: --
458: hxc_timecard_summary_pkg.approve_timecard(tc_check.timecard_id);
459: else
460: close c_any_non_approved_app_periods;
461: if(l_dummy_approval = hxc_timecard.c_rejected_status) then
462: hxc_timecard_summary_pkg.reject_timecard(tc_check.timecard_id);

Line 462: hxc_timecard_summary_pkg.reject_timecard(tc_check.timecard_id);

458: hxc_timecard_summary_pkg.approve_timecard(tc_check.timecard_id);
459: else
460: close c_any_non_approved_app_periods;
461: if(l_dummy_approval = hxc_timecard.c_rejected_status) then
462: hxc_timecard_summary_pkg.reject_timecard(tc_check.timecard_id);
463: end if;
464: end if;
465: end loop;
466:

Line 509: end hxc_timecard_summary_api;

505: close c_app_period_info;
506:
507: End reevaluate_timecard_statuses;
508:
509: end hxc_timecard_summary_api;