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_SELF_SERVICE_TIMECARD dependencies on HXC_BLD_BLK_INFO_TYPES

Line 1374: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE

1370: FUNCTION get_info_type_id(
1371: p_field_name IN hxc_mapping_components.field_name%TYPE
1372: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1373: )
1374: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1375: IS
1376: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1377:
1378: CURSOR c_info_type_id(

Line 1376: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

1372: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1373: )
1374: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1375: IS
1376: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1377:
1378: CURSOR c_info_type_id(
1379: p_field_name IN hxc_mapping_components.field_name%TYPE
1380: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE

Line 1416: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE

1412: -- get building block information type id from a building block
1413: -- information type
1414: ---------------------------------------------------------------------
1415: FUNCTION get_info_type_id_from_type(
1416: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1417: )
1418: RETURN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1419: IS
1420: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

Line 1418: RETURN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE

1414: ---------------------------------------------------------------------
1415: FUNCTION get_info_type_id_from_type(
1416: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1417: )
1418: RETURN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1419: IS
1420: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1421:
1422: CURSOR c_info_type_id(

Line 1420: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

1416: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1417: )
1418: RETURN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1419: IS
1420: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1421:
1422: CURSOR c_info_type_id(
1423: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1424: )

Line 1423: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE

1419: IS
1420: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1421:
1422: CURSOR c_info_type_id(
1423: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1424: )
1425: IS
1426: SELECT bld_blk_info_type_id
1427: FROM hxc_bld_blk_info_types

Line 1427: FROM hxc_bld_blk_info_types

1423: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1424: )
1425: IS
1426: SELECT bld_blk_info_type_id
1427: FROM hxc_bld_blk_info_types
1428: WHERE bld_blk_info_type = p_bld_blk_info_type;
1429:
1430: BEGIN
1431:

Line 1464: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE

1460: -- get building block information type from a building block
1461: -- information type id
1462: -- -----------------------------------------------------------------
1463: FUNCTION get_info_type(
1464: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1465: )
1466: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1467: IS
1468: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

Line 1466: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE

1462: -- -----------------------------------------------------------------
1463: FUNCTION get_info_type(
1464: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1465: )
1466: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1467: IS
1468: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1469:
1470: CURSOR c_info_type(

Line 1468: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

1464: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1465: )
1466: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1467: IS
1468: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1469:
1470: CURSOR c_info_type(
1471: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1472: )

Line 1471: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE

1467: IS
1468: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1469:
1470: CURSOR c_info_type(
1471: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1472: )
1473: IS
1474: SELECT bld_blk_info_type
1475: FROM hxc_bld_blk_info_types

Line 1475: FROM hxc_bld_blk_info_types

1471: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1472: )
1473: IS
1474: SELECT bld_blk_info_type
1475: FROM hxc_bld_blk_info_types
1476: WHERE bld_blk_info_type_id = p_bld_blk_info_type_id;
1477:
1478: BEGIN
1479:

Line 1516: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

1512: ,p_template_type IN VARCHAR2
1513: )
1514: IS
1515: l_att_count NUMBER;
1516: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1517: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1518: l_segment hxc_mapping_components.segment%TYPE;
1519:
1520: CURSOR csr_segment(

Line 1517: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

1513: )
1514: IS
1515: l_att_count NUMBER;
1516: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1517: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1518: l_segment hxc_mapping_components.segment%TYPE;
1519:
1520: CURSOR csr_segment(
1521: p_retrieval_process_id NUMBER

Line 1531: ,hxc_bld_blk_info_types bbit

1527: from hxc_mapping_components mc
1528: ,hxc_mapping_comp_usages mcu
1529: ,hxc_mappings m
1530: ,hxc_retrieval_processes rp
1531: ,hxc_bld_blk_info_types bbit
1532: ,hxc_bld_blk_info_type_usages bbui
1533: where rp.mapping_id = m.mapping_id
1534: AND mc.field_name = p_field_name
1535: and rp.retrieval_process_id = p_retrieval_process_id

Line 1715: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

1711: RETURN HXC_ATTRIBUTE_TABLE_TYPE
1712: IS
1713: l_block_attributes HXC_ATTRIBUTE_TABLE_TYPE;
1714: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
1715: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1716: l_app_attribute_index NUMBER;
1717: l_block_attribute_index NUMBER := 0;
1718:
1719: BEGIN

Line 3750: hxc_bld_blk_info_types bbit

3746: ,'N' NEW
3747: ,'N' CHANGED
3748: from hxc_time_attributes a,
3749: hxc_time_attribute_usages au,
3750: hxc_bld_blk_info_types bbit
3751: where au.time_building_block_id = p_building_block_id
3752: and au.time_building_block_ovn = p_ovn
3753: and au.time_attribute_id = a.time_attribute_id
3754: and (not (a.attribute_category = 'SECURITY'))

Line 3847: hxc_bld_blk_info_types bbit

3843: ,'N' CHANGED
3844: ,'N' PROCESS
3845: from hxc_time_attributes a,
3846: hxc_time_attribute_usages au,
3847: hxc_bld_blk_info_types bbit
3848: where au.time_building_block_id = p_building_block_id
3849: and au.time_building_block_ovn = p_ovn
3850: and au.time_attribute_id = a.time_attribute_id
3851: and (not (a.attribute_category = 'SECURITY'))