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

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

114: ) is
115:
116:
117: cursor c_previous_timecard(
118: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
119: select tk_audit_item_key,tk_audit_item_type
120: from hxc_timecard_summary
121: where timecard_id = p_timecard_id;
122:

Line 120: from hxc_timecard_summary

116:
117: cursor c_previous_timecard(
118: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
119: select tk_audit_item_key,tk_audit_item_type
120: from hxc_timecard_summary
121: where timecard_id = p_timecard_id;
122:
123: l_timecard_blocks hxc_timecard.block_list;
124: l_day_blocks hxc_timecard.block_list;

Line 143: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

139: e_timekeeper_check EXCEPTION;
140:
141: l_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
142:
143: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
144: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
145:
146: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
147: tk_audit_process_name VARCHAR2(50) :=NULL;

Line 144: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

140:
141: l_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
142:
143: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
144: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
145:
146: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
147: tk_audit_process_name VARCHAR2(50) :=NULL;
148:

Line 493: hxc_timecard_summary_api.timecard_deposit

489: --
490: -- Maintain summary table
491: --
492:
493: hxc_timecard_summary_api.timecard_deposit
494: (p_blocks => p_blocks
495: ,p_approval_item_type => NULL
496: ,p_approval_process_name => NULL
497: ,p_approval_item_key => NULL

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

553: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL
554: ) IS
555:
556: cursor c_previous_timecard(
557: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
558: select tk_audit_item_key,tk_audit_item_type
559: from hxc_timecard_summary
560: where timecard_id = p_timecard_id;
561:

Line 559: from hxc_timecard_summary

555:
556: cursor c_previous_timecard(
557: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
558: select tk_audit_item_key,tk_audit_item_type
559: from hxc_timecard_summary
560: where timecard_id = p_timecard_id;
561:
562:
563: l_timecard_blocks hxc_timecard.block_list;

Line 583: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

579: tk_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
580: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
581: tk_audit_process_name VARCHAR2(50) :=NULL;
582:
583: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
584: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
585:
586:
587: BEGIN

Line 584: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

580: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
581: tk_audit_process_name VARCHAR2(50) :=NULL;
582:
583: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
584: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
585:
586:
587: BEGIN
588:

Line 925: hxc_timecard_summary_api.timecard_deposit

921: END IF;
922: --
923: -- Maintain summary table
924: --
925: hxc_timecard_summary_api.timecard_deposit
926: (p_blocks => p_blocks
927: ,p_approval_item_type => NULL
928: ,p_approval_process_name => NULL
929: ,p_approval_item_key => NULL

Line 975: hxc_timecard_summary_pkg.update_summary_row

971:
972:
973: -- set the out parameters --
974:
975: hxc_timecard_summary_pkg.update_summary_row
976: (p_timecard_id => p_timecard_id
977: ,p_approval_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
978: ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
979: ,p_approval_item_key => l_item_key

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

1009: );
1010: */
1011:
1012: cursor c_previous_timecard(
1013: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
1014: select tk_audit_item_key,tk_audit_item_type,timecard_ovn
1015: from hxc_timecard_summary
1016: where timecard_id = p_timecard_id;
1017:

Line 1015: from hxc_timecard_summary

1011:
1012: cursor c_previous_timecard(
1013: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
1014: select tk_audit_item_key,tk_audit_item_type,timecard_ovn
1015: from hxc_timecard_summary
1016: where timecard_id = p_timecard_id;
1017:
1018: /*
1019: cursor c_timecard_ovn

Line 1060: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

1056:
1057: l_rollback BOOLEAN := FALSE;
1058: e_timekeeper_check EXCEPTION;
1059:
1060: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
1061: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
1062:
1063: l_dummy_num NUMBER(1);
1064:

Line 1061: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

1057: l_rollback BOOLEAN := FALSE;
1058: e_timekeeper_check EXCEPTION;
1059:
1060: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
1061: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
1062:
1063: l_dummy_num NUMBER(1);
1064:
1065: Begin

Line 1222: hxc_timecard_summary_api.delete_timecard

1218: --hxc_timecard_message_helper.processerrors
1219: --(p_messages => l_messages);
1220:
1221:
1222: hxc_timecard_summary_api.delete_timecard
1223: (p_blocks => l_blocks
1224: ,p_timecard_id => p_timecard_id
1225: );
1226: