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_DEPOSIT_CHECKS dependencies on HXC_TIME_BUILDING_BLOCKS

Line 47: (p_template_id in hxc_time_building_blocks.time_building_block_id%type

43: -- {End Of Comments}
44: --
45: --
46: Procedure can_delete_template
47: (p_template_id in hxc_time_building_blocks.time_building_block_id%type
48: ,p_messages in out nocopy hxc_message_table_type) is
49:
50: cursor c_template_details
51: (p_id in hxc_time_building_blocks.time_building_block_id%type) is

Line 51: (p_id in hxc_time_building_blocks.time_building_block_id%type) is

47: (p_template_id in hxc_time_building_blocks.time_building_block_id%type
48: ,p_messages in out nocopy hxc_message_table_type) is
49:
50: cursor c_template_details
51: (p_id in hxc_time_building_blocks.time_building_block_id%type) is
52: select TEMPLATE_TYPE from hxc_template_summary
53: where template_id = p_id;
54:
55: l_exists VARCHAR2(6);

Line 373: ,p_timecard_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

369: --
370: --
371: FUNCTION timecard_deleted
372: (p_blocks in HXC_BLOCK_TABLE_TYPE
373: ,p_timecard_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
374: ) return BOOLEAN is
375:
376: l_deleted_tc BOOLEAN := false;
377: l_block_count NUMBER;

Line 405: ,p_timecard_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

401: -- Overloaded version, to call from deposit wrapper.
402: --
403: FUNCTION timecard_deleted
404: (p_blocks in hxc_self_service_time_deposit.timecard_info
405: ,p_timecard_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
406: ) return BOOLEAN is
407:
408: l_deleted_tc BOOLEAN := false;
409: l_block_count NUMBER;

Line 465: (p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE

461: -- {End Of Comments}
462: --
463: --
464: FUNCTION chk_timecard_exists
465: (p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
466: ,p_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
467: ,p_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
468: ,p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
469: ) RETURN NUMBER is

Line 466: ,p_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE

462: --
463: --
464: FUNCTION chk_timecard_exists
465: (p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
466: ,p_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
467: ,p_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
468: ,p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
469: ) RETURN NUMBER is
470:

Line 467: ,p_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE

463: --
464: FUNCTION chk_timecard_exists
465: (p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
466: ,p_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
467: ,p_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
468: ,p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
469: ) RETURN NUMBER is
470:
471: l_existing_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;

Line 468: ,p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

464: FUNCTION chk_timecard_exists
465: (p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
466: ,p_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
467: ,p_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
468: ,p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
469: ) RETURN NUMBER is
470:
471: l_existing_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
472:

Line 471: l_existing_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;

467: ,p_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
468: ,p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
469: ) RETURN NUMBER is
470:
471: l_existing_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
472:
473: begin
474:
475: select tbb.time_building_block_id into l_existing_timecard_id

Line 476: from hxc_time_building_blocks tbb

472:
473: begin
474:
475: select tbb.time_building_block_id into l_existing_timecard_id
476: from hxc_time_building_blocks tbb
477: where tbb.resource_id = p_resource_id
478: and tbb.scope = 'TIMECARD'
479: and tbb.date_to = hr_general.end_of_time
480: and tbb.start_time <= p_stop_time

Line 531: l_test_tc_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;

527: (p_blocks in HXC_BLOCK_TABLE_TYPE
528: ,p_block_number in NUMBER
529: ) return BOOLEAN is
530:
531: l_test_tc_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
532:
533: l_proc varchar2(72) := g_package||'chk_timceard_deposit';
534:
535: BEGIN

Line 610: l_test_tc_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;

606: (p_blocks in hxc_self_service_time_deposit.timecard_info
607: ,p_block_number in NUMBER
608: ) return BOOLEAN is
609:
610: l_test_tc_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
611:
612: BEGIN
613:
614: --

Line 932: l_inactive_detail_id hxc_time_building_blocks.time_building_block_id%type;

928: l_tc_index NUMBER;
929: l_index NUMBER;
930: l_idx NUMBER;
931:
932: l_inactive_detail_id hxc_time_building_blocks.time_building_block_id%type;
933: l_inactive_detail_ovn hxc_time_building_blocks.object_version_number%type;
934: l_block_idxs block_list;
935:
936: l_proc varchar2(72) := g_package||'perform_checks';

Line 933: l_inactive_detail_ovn hxc_time_building_blocks.object_version_number%type;

929: l_index NUMBER;
930: l_idx NUMBER;
931:
932: l_inactive_detail_id hxc_time_building_blocks.time_building_block_id%type;
933: l_inactive_detail_ovn hxc_time_building_blocks.object_version_number%type;
934: l_block_idxs block_list;
935:
936: l_proc varchar2(72) := g_package||'perform_checks';
937:

Line 1148: (p_id in hxc_time_building_blocks.time_building_block_id%type,

1144: p_attributes in hxc_attribute_table_type)
1145: Return Boolean is
1146:
1147: cursor c_old_block
1148: (p_id in hxc_time_building_blocks.time_building_block_id%type,
1149: p_ovn in hxc_time_building_blocks.object_version_number%type) is
1150: select *
1151: from hxc_time_building_blocks
1152: where time_building_block_id = p_id

Line 1149: p_ovn in hxc_time_building_blocks.object_version_number%type) is

1145: Return Boolean is
1146:
1147: cursor c_old_block
1148: (p_id in hxc_time_building_blocks.time_building_block_id%type,
1149: p_ovn in hxc_time_building_blocks.object_version_number%type) is
1150: select *
1151: from hxc_time_building_blocks
1152: where time_building_block_id = p_id
1153: and object_version_number = p_ovn;

Line 1151: from hxc_time_building_blocks

1147: cursor c_old_block
1148: (p_id in hxc_time_building_blocks.time_building_block_id%type,
1149: p_ovn in hxc_time_building_blocks.object_version_number%type) is
1150: select *
1151: from hxc_time_building_blocks
1152: where time_building_block_id = p_id
1153: and object_version_number = p_ovn;
1154:
1155: l_old_block c_old_block%rowtype;

Line 1332: (p_resource_id in hxc_time_building_blocks.resource_id%type

1328:
1329: End find_locking_preference;
1330:
1331: Function day_approved
1332: (p_resource_id in hxc_time_building_blocks.resource_id%type
1333: ,p_date in date
1334: ) return boolean is
1335:
1336: cursor c_approved_day

Line 1337: (p_resource_id in hxc_time_building_blocks.resource_id%type

1333: ,p_date in date
1334: ) return boolean is
1335:
1336: cursor c_approved_day
1337: (p_resource_id in hxc_time_building_blocks.resource_id%type
1338: ,p_date in date) is
1339: select ap.approval_status
1340: from hxc_time_building_blocks ap, hxc_time_building_blocks tc
1341: where ap.resource_id = p_resource_id

Line 1340: from hxc_time_building_blocks ap, hxc_time_building_blocks tc

1336: cursor c_approved_day
1337: (p_resource_id in hxc_time_building_blocks.resource_id%type
1338: ,p_date in date) is
1339: select ap.approval_status
1340: from hxc_time_building_blocks ap, hxc_time_building_blocks tc
1341: where ap.resource_id = p_resource_id
1342: and ap.scope = 'APPLICATION_PERIOD'
1343: and ap.approval_status = 'APPROVED'
1344: and p_date between ap.start_time and ap.stop_time

Line 1353: from hxc_time_building_blocks

1349: and tc.start_time <= ap.stop_time
1350: and tc.stop_time >= ap.start_time
1351: and NOT exists
1352: (select 'Y'
1353: from hxc_time_building_blocks
1354: where resource_id = p_resource_id
1355: and scope = 'APPLICATION_PERIOD'
1356: and date_to = hr_general.end_of_time
1357: and approval_status = 'REJECTED'

Line 1361: l_dummy hxc_time_building_blocks.approval_status%type;

1357: and approval_status = 'REJECTED'
1358: and p_date between start_time and stop_time
1359: );
1360:
1361: l_dummy hxc_time_building_blocks.approval_status%type;
1362:
1363: Begin
1364:
1365: open c_approved_day(p_resource_id,p_date);

Line 1382: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

1378: -- santos locking of approved days functionality.
1379: --
1380: FUNCTION detail_with_day
1381: (p_date IN DATE,
1382: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1383: ) RETURN BOOLEAN IS
1384:
1385: CURSOR c_detail_exists
1386: (p_date IN DATE,

Line 1387: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

1383: ) RETURN BOOLEAN IS
1384:
1385: CURSOR c_detail_exists
1386: (p_date IN DATE,
1387: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1388: ) IS
1389: SELECT 'Y'
1390: FROM hxc_time_building_blocks detail,
1391: hxc_time_building_blocks day,

Line 1390: FROM hxc_time_building_blocks detail,

1386: (p_date IN DATE,
1387: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1388: ) IS
1389: SELECT 'Y'
1390: FROM hxc_time_building_blocks detail,
1391: hxc_time_building_blocks day,
1392: hxc_time_building_blocks parent
1393: WHERE detail.parent_building_block_id = day.time_building_block_id
1394: AND detail.parent_building_block_ovn = day.object_version_number

Line 1391: hxc_time_building_blocks day,

1387: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1388: ) IS
1389: SELECT 'Y'
1390: FROM hxc_time_building_blocks detail,
1391: hxc_time_building_blocks day,
1392: hxc_time_building_blocks parent
1393: WHERE detail.parent_building_block_id = day.time_building_block_id
1394: AND detail.parent_building_block_ovn = day.object_version_number
1395: AND detail.date_to = hr_general.end_of_time

Line 1392: hxc_time_building_blocks parent

1388: ) IS
1389: SELECT 'Y'
1390: FROM hxc_time_building_blocks detail,
1391: hxc_time_building_blocks day,
1392: hxc_time_building_blocks parent
1393: WHERE detail.parent_building_block_id = day.time_building_block_id
1394: AND detail.parent_building_block_ovn = day.object_version_number
1395: AND detail.date_to = hr_general.end_of_time
1396: AND detail.resource_id = p_resource_id

Line 1399: from hxc_time_building_blocks ap

1395: AND detail.date_to = hr_general.end_of_time
1396: AND detail.resource_id = p_resource_id
1397: AND detail.scope = 'DETAIL'
1398: AND detail.creation_date <=(select max(ap.creation_date)
1399: from hxc_time_building_blocks ap
1400: where ap.resource_id = p_resource_id
1401: and ap.scope = 'APPLICATION_PERIOD'
1402: and ap.approval_status = 'APPROVED'
1403: and p_date between ap.start_time and ap.stop_time

Line 1435: ,p_resource_id in hxc_time_building_blocks.resource_id%type

1431: END detail_with_day;
1432:
1433: Function day_locked
1434: (p_timecard_props in hxc_timecard_prop_table_type
1435: ,p_resource_id in hxc_time_building_blocks.resource_id%type
1436: ,p_date in date
1437: ) return boolean is
1438:
1439: l_locked boolean := false;

Line 1469: p_resource_id in hxc_time_building_blocks.resource_id%type,

1465: End day_locked;
1466:
1467: Function detail_locked
1468: (p_timecard_props in hxc_timecard_prop_table_type,
1469: p_resource_id in hxc_time_building_blocks.resource_id%type,
1470: p_date in date,
1471: p_detail_id in hxc_ap_detail_links.time_building_block_id%type,
1472: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type
1473: ) return boolean is