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 1076: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE

1072: FUNCTION get_info_type_id(
1073: p_field_name IN hxc_mapping_components.field_name%TYPE
1074: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1075: )
1076: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1077: IS
1078: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1079:
1080: CURSOR c_info_type_id(

Line 1078: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

1074: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1075: )
1076: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1077: IS
1078: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1079:
1080: CURSOR c_info_type_id(
1081: p_field_name IN hxc_mapping_components.field_name%TYPE
1082: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE

Line 1118: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE

1114: -- get building block information type id from a building block
1115: -- information type
1116: ---------------------------------------------------------------------
1117: FUNCTION get_info_type_id_from_type(
1118: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1119: )
1120: RETURN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1121: IS
1122: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

Line 1120: RETURN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE

1116: ---------------------------------------------------------------------
1117: FUNCTION get_info_type_id_from_type(
1118: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1119: )
1120: RETURN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1121: IS
1122: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1123:
1124: CURSOR c_info_type_id(

Line 1122: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

1118: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1119: )
1120: RETURN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1121: IS
1122: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1123:
1124: CURSOR c_info_type_id(
1125: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1126: )

Line 1125: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE

1121: IS
1122: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1123:
1124: CURSOR c_info_type_id(
1125: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1126: )
1127: IS
1128: SELECT bld_blk_info_type_id
1129: FROM hxc_bld_blk_info_types

Line 1129: FROM hxc_bld_blk_info_types

1125: p_bld_blk_info_type IN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1126: )
1127: IS
1128: SELECT bld_blk_info_type_id
1129: FROM hxc_bld_blk_info_types
1130: WHERE bld_blk_info_type = p_bld_blk_info_type;
1131:
1132: BEGIN
1133:

Line 1166: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE

1162: -- get building block information type from a building block
1163: -- information type id
1164: -- -----------------------------------------------------------------
1165: FUNCTION get_info_type(
1166: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1167: )
1168: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1169: IS
1170: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

Line 1168: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE

1164: -- -----------------------------------------------------------------
1165: FUNCTION get_info_type(
1166: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1167: )
1168: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1169: IS
1170: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1171:
1172: CURSOR c_info_type(

Line 1170: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

1166: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1167: )
1168: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1169: IS
1170: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1171:
1172: CURSOR c_info_type(
1173: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1174: )

Line 1173: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE

1169: IS
1170: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1171:
1172: CURSOR c_info_type(
1173: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1174: )
1175: IS
1176: SELECT bld_blk_info_type
1177: FROM hxc_bld_blk_info_types

Line 1177: FROM hxc_bld_blk_info_types

1173: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
1174: )
1175: IS
1176: SELECT bld_blk_info_type
1177: FROM hxc_bld_blk_info_types
1178: WHERE bld_blk_info_type_id = p_bld_blk_info_type_id;
1179:
1180: BEGIN
1181:

Line 1218: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

1214: ,p_template_type IN VARCHAR2
1215: )
1216: IS
1217: l_att_count NUMBER;
1218: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1219: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1220: l_segment hxc_mapping_components.segment%TYPE;
1221:
1222: CURSOR csr_segment(

Line 1219: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

1215: )
1216: IS
1217: l_att_count NUMBER;
1218: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1219: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1220: l_segment hxc_mapping_components.segment%TYPE;
1221:
1222: CURSOR csr_segment(
1223: p_retrieval_process_id NUMBER

Line 1233: ,hxc_bld_blk_info_types bbit

1229: from hxc_mapping_components mc
1230: ,hxc_mapping_comp_usages mcu
1231: ,hxc_mappings m
1232: ,hxc_retrieval_processes rp
1233: ,hxc_bld_blk_info_types bbit
1234: ,hxc_bld_blk_info_type_usages bbui
1235: where rp.mapping_id = m.mapping_id
1236: AND mc.field_name = p_field_name
1237: and rp.retrieval_process_id = p_retrieval_process_id

Line 1417: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

1413: RETURN HXC_ATTRIBUTE_TABLE_TYPE
1414: IS
1415: l_block_attributes HXC_ATTRIBUTE_TABLE_TYPE;
1416: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
1417: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1418: l_app_attribute_index NUMBER;
1419: l_block_attribute_index NUMBER := 0;
1420:
1421: BEGIN

Line 3414: hxc_bld_blk_info_types bbit

3410: ,'N' NEW
3411: ,'N' CHANGED
3412: from hxc_time_attributes a,
3413: hxc_time_attribute_usages au,
3414: hxc_bld_blk_info_types bbit
3415: where au.time_building_block_id = p_building_block_id
3416: and au.time_building_block_ovn = p_ovn
3417: and au.time_attribute_id = a.time_attribute_id
3418: and (not (a.attribute_category = 'SECURITY'))

Line 3511: hxc_bld_blk_info_types bbit

3507: ,'N' CHANGED
3508: ,'N' PROCESS
3509: from hxc_time_attributes a,
3510: hxc_time_attribute_usages au,
3511: hxc_bld_blk_info_types bbit
3512: where au.time_building_block_id = p_building_block_id
3513: and au.time_building_block_ovn = p_ovn
3514: and au.time_attribute_id = a.time_attribute_id
3515: and (not (a.attribute_category = 'SECURITY'))