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 50: (p_template_id in hxc_time_building_blocks.time_building_block_id%type

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

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

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

Line 376: ,p_timecard_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

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

Line 408: ,p_timecard_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

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

Line 468: (p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE

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

Line 469: ,p_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE

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

Line 470: ,p_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE

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

Line 471: ,p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

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

Line 474: l_existing_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;

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

Line 479: from hxc_time_building_blocks tbb

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

Line 534: l_test_tc_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;

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

Line 613: l_test_tc_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;

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

Line 935: l_inactive_detail_id hxc_time_building_blocks.time_building_block_id%type;

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

Line 936: l_inactive_detail_ovn hxc_time_building_blocks.object_version_number%type;

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

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

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

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

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

Line 1154: from hxc_time_building_blocks

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

Line 1335: (p_resource_id in hxc_time_building_blocks.resource_id%type

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

Line 1340: (p_resource_id in hxc_time_building_blocks.resource_id%type

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

Line 1343: from hxc_time_building_blocks ap, hxc_time_building_blocks tc

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

Line 1356: from hxc_time_building_blocks

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

Line 1364: l_dummy hxc_time_building_blocks.approval_status%type;

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

Line 1385: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

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

Line 1390: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

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

Line 1393: FROM hxc_time_building_blocks detail,

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

Line 1394: hxc_time_building_blocks day,

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

Line 1395: hxc_time_building_blocks parent

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

Line 1402: from hxc_time_building_blocks ap

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

Line 1438: ,p_resource_id in hxc_time_building_blocks.resource_id%type

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

Line 1472: p_resource_id in hxc_time_building_blocks.resource_id%type,

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