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

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

162: ) is
163:
164:
165: cursor c_previous_timecard(
166: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
167: select tk_audit_item_key,tk_audit_item_type
168: from hxc_timecard_summary
169: where timecard_id = p_timecard_id;
170:

Line 168: from hxc_timecard_summary

164:
165: cursor c_previous_timecard(
166: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
167: select tk_audit_item_key,tk_audit_item_type
168: from hxc_timecard_summary
169: where timecard_id = p_timecard_id;
170:
171: l_timecard_blocks hxc_timecard.block_list;
172: l_day_blocks hxc_timecard.block_list;

Line 191: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

187: e_timekeeper_check EXCEPTION;
188:
189: l_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
190:
191: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
192: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
193:
194: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
195: tk_audit_process_name VARCHAR2(50) :=NULL;

Line 192: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

188:
189: l_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
190:
191: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
192: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
193:
194: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
195: tk_audit_process_name VARCHAR2(50) :=NULL;
196:

Line 1220: hxc_timecard_summary_api.timecard_deposit

1216: --
1217: -- Maintain summary table
1218: --
1219:
1220: hxc_timecard_summary_api.timecard_deposit
1221: (p_blocks => p_blocks
1222: ,p_approval_item_type => NULL
1223: ,p_approval_process_name => NULL
1224: ,p_approval_item_key => NULL

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

1321: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL
1322: ) IS
1323:
1324: cursor c_previous_timecard(
1325: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
1326: select tk_audit_item_key,tk_audit_item_type
1327: from hxc_timecard_summary
1328: where timecard_id = p_timecard_id;
1329:

Line 1327: from hxc_timecard_summary

1323:
1324: cursor c_previous_timecard(
1325: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
1326: select tk_audit_item_key,tk_audit_item_type
1327: from hxc_timecard_summary
1328: where timecard_id = p_timecard_id;
1329:
1330:
1331: l_timecard_blocks hxc_timecard.block_list;

Line 1351: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

1347: tk_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
1348: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
1349: tk_audit_process_name VARCHAR2(50) :=NULL;
1350:
1351: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
1352: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
1353:
1354: l_index NUMBER;
1355:

Line 1352: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

1348: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
1349: tk_audit_process_name VARCHAR2(50) :=NULL;
1350:
1351: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
1352: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
1353:
1354: l_index NUMBER;
1355:
1356: l_resource_id NUMBER;

Line 2371: hxc_timecard_summary_api.timecard_deposit

2367: END IF;
2368: --
2369: -- Maintain summary table
2370: --
2371: hxc_timecard_summary_api.timecard_deposit
2372: (p_blocks => p_blocks
2373: ,p_approval_item_type => NULL
2374: ,p_approval_process_name => NULL
2375: ,p_approval_item_key => NULL

Line 2421: hxc_timecard_summary_pkg.update_summary_row

2417:
2418:
2419: -- set the out parameters --
2420:
2421: hxc_timecard_summary_pkg.update_summary_row
2422: (p_timecard_id => p_timecard_id
2423: ,p_approval_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
2424: ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
2425: ,p_approval_item_key => l_item_key

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

2504: );
2505: */
2506:
2507: cursor c_previous_timecard(
2508: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
2509: select tk_audit_item_key,tk_audit_item_type,timecard_ovn
2510: from hxc_timecard_summary
2511: where timecard_id = p_timecard_id;
2512:

Line 2510: from hxc_timecard_summary

2506:
2507: cursor c_previous_timecard(
2508: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
2509: select tk_audit_item_key,tk_audit_item_type,timecard_ovn
2510: from hxc_timecard_summary
2511: where timecard_id = p_timecard_id;
2512:
2513: /*
2514: cursor c_timecard_ovn

Line 2555: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

2551:
2552: l_rollback BOOLEAN := FALSE;
2553: e_timekeeper_check EXCEPTION;
2554:
2555: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
2556: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
2557:
2558: l_dummy_num NUMBER(1);
2559:

Line 2556: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

2552: l_rollback BOOLEAN := FALSE;
2553: e_timekeeper_check EXCEPTION;
2554:
2555: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
2556: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
2557:
2558: l_dummy_num NUMBER(1);
2559:
2560: l_resource_id NUMBER;

Line 2743: hxc_timecard_summary_api.delete_timecard

2739: --(p_messages => l_messages);
2740:
2741: end_date_app_period(p_timecard_id);
2742:
2743: hxc_timecard_summary_api.delete_timecard
2744: (p_blocks => l_blocks
2745: ,p_timecard_id => p_timecard_id
2746: );
2747: