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

Line 10: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,

6: TYPE t_mapping_comp IS RECORD
7: (segment hxc_mapping_components.segment%TYPE,
8: field_name hxc_mapping_components.field_name%TYPE,
9: bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE,
10: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
11: building_block_category hxc_bld_blk_info_type_usages.building_block_category%TYPE);
12:
13: TYPE t_mapping IS TABLE OF
14: t_mapping_comp

Line 21: HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE

17:
18: -- Bug 2384849
19:
20: TYPE t_bld_blk_info_types IS TABLE OF
21: HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE
22: INDEX BY BINARY_INTEGER;
23:
24: TYPE timecard_block_order IS TABLE OF
25: NUMBER

Line 108: (p_info_type in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE) RETURN NUMBER is

104: END mapping_comp_info;
105: -- Bug 2384849
106:
107: FUNCTION cache_bld_blk_info_types
108: (p_info_type in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE) RETURN NUMBER is
109:
110: l_bld_blk_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;
111: l_count NUMBER;
112: l_found BOOLEAN := FALSE;

Line 110: l_bld_blk_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;

106:
107: FUNCTION cache_bld_blk_info_types
108: (p_info_type in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE) RETURN NUMBER is
109:
110: l_bld_blk_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;
111: l_count NUMBER;
112: l_found BOOLEAN := FALSE;
113:
114: BEGIN

Line 138: from hxc_bld_blk_info_types

134:
135: -- Go to the db!
136:
137: select bld_blk_info_type_id into l_bld_blk_id
138: from hxc_bld_blk_info_types
139: where bld_blk_info_type = p_info_type;
140:
141: -- add this to the queried string!
142: -- (not yet, we'll count the number of times the SQL is executed)

Line 181: ,hxc_bld_blk_info_types bbit

177: from hxc_mapping_components mc
178: ,hxc_mapping_comp_usages mcu
179: ,hxc_mappings m
180: ,hxc_retrieval_processes rp
181: ,hxc_bld_blk_info_types bbit
182: ,hxc_bld_blk_info_type_usages bbui
183: where rp.mapping_id = m.mapping_id
184: and rp.retrieval_process_id = p_retrieval_process_id
185: and m.mapping_id = mcu.mapping_id

Line 201: ,hxc_bld_blk_info_types bbit

197: from hxc_mapping_components mc
198: ,hxc_mapping_comp_usages mcu
199: ,hxc_mappings m
200: ,hxc_deposit_processes dp
201: ,hxc_bld_blk_info_types bbit
202: ,hxc_bld_blk_info_type_usages bbui
203: where dp.mapping_id = m.mapping_id
204: and dp.deposit_process_id = p_deposit_process_id
205: and m.mapping_id = mcu.mapping_id

Line 1654: hxc_bld_blk_info_types bbit

1650: bbui.building_block_category
1651: FROM
1652: hxc_mapping_components mc,
1653: hxc_bld_blk_info_type_usages bbui,
1654: hxc_bld_blk_info_types bbit
1655: WHERE
1656: mc.mapping_component_id in (Select mcu.mapping_component_id from
1657: hxc_mappings m ,
1658: hxc_mapping_comp_usages mcu,

Line 1677: ,hxc_bld_blk_info_types bbit

1673: from hxc_mapping_components mc
1674: ,hxc_mapping_comp_usages mcu
1675: ,hxc_mappings m
1676: ,hxc_deposit_processes dp
1677: ,hxc_bld_blk_info_types bbit
1678: ,hxc_bld_blk_info_type_usages bbui
1679: where dp.mapping_id = m.mapping_id
1680: and dp.deposit_process_id = p_deposit_process_id --AI3
1681: and m.mapping_id = mcu.mapping_id

Line 1692: l_attribute_category HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;

1688: l_attribute BINARY_INTEGER;
1689: l_attribute_index BINARY_INTEGER :=0;
1690: l_proc VARCHAR2(70) := 'BUILD_APPLICATION_ATTRIBUTES';
1691: l_exception EXCEPTION;
1692: l_attribute_category HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;
1693:
1694: BEGIN
1695:
1696: l_app_attributes.delete;

Line 2002: FROM hxc_bld_blk_info_types

1998: FUNCTION get_bld_blk_type_id(p_type IN varchar2) RETURN NUMBER IS
1999:
2000: CURSOR csr_bld_blk_id(p_type IN varchar2) IS
2001: SELECT bld_blk_info_type_id
2002: FROM hxc_bld_blk_info_types
2003: WHERE bld_blk_info_type = p_type;
2004:
2005: BEGIN
2006:

Line 2271: l_bb_info HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE := g_attributes(p_attribute_number).bld_blk_info_type;

2267: ,p_attribute_number in number) RETURN BOOLEAN is
2268:
2269: l_return BOOLEAN := false;
2270: l_tbb_id NUMBER := g_attributes(p_attribute_number).building_block_id;
2271: l_bb_info HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE := g_attributes(p_attribute_number).bld_blk_info_type;
2272: l_acount NUMBER;
2273: l_proc VARCHAR2(35) := 'REPLACEMENT_ATTRIBUTE';
2274:
2275: BEGIN

Line 2329: ,hxc_bld_blk_info_types bbit

2325: from hxc_mapping_components mc
2326: ,hxc_mapping_comp_usages mcu
2327: ,hxc_mappings m
2328: ,hxc_deposit_processes dp
2329: ,hxc_bld_blk_info_types bbit
2330: where dp.mapping_id = m.mapping_id
2331: and dp.deposit_process_id = p_deposit_process_id
2332: and m.mapping_id = mcu.mapping_id
2333: and mcu.mapping_component_id = mc.mapping_component_id

Line 2340: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;

2336: --
2337:
2338:
2339: l_attribute_index NUMBER;
2340: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;
2341: l_bld_blk_info_type VARCHAR2(150);
2342: l_proc VARCHAR2(30) := 'build_timecard_structure';
2343: l_old_attribute HXC_TIME_ATTRIBUTES%ROWTYPE;
2344: l_exception EXCEPTION;

Line 2689: ,hxc_bld_blk_info_types bbit

2685: from hxc_mapping_components mc
2686: ,hxc_mapping_comp_usages mcu
2687: ,hxc_mappings m
2688: ,hxc_retrieval_processes rp
2689: ,hxc_bld_blk_info_types bbit
2690: ,hxc_bld_blk_info_type_usages bbui
2691: where rp.mapping_id = m.mapping_id
2692: AND mc.field_name = p_field_name
2693: and rp.retrieval_process_id = p_retrieval_process_id

Line 2965: l_attribute_category HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;

2961: ) IS
2962:
2963: l_next_attribute_id NUMBER;
2964: l_bld_blk_info_type_id NUMBER;
2965: l_attribute_category HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;
2966: l_att_count NUMBER;
2967:
2968: cursor csr_attribute
2969: (p_time_attribute_id in HXC_TIME_ATTRIBUTES.TIME_ATTRIBUTE_ID%TYPE

Line 3356: from hxc_bld_blk_info_types

3352:
3353: BEGIN
3354:
3355: select 'Y' into l_dummy
3356: from hxc_bld_blk_info_types
3357: where bld_blk_info_type_id = p_id;
3358:
3359: return true;
3360:

Line 3411: from hxc_bld_blk_info_types

3407:
3408: cursor c_bld_blk_info_id
3409: (p_info_type in varchar2) is
3410: select bld_blk_info_type_id
3411: from hxc_bld_blk_info_types
3412: where bld_blk_info_type = p_info_type;
3413:
3414: l_last_index BINARY_INTEGER;
3415: l_next_index BINARY_INTEGER;

Line 3418: l_attribute_category HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;

3414: l_last_index BINARY_INTEGER;
3415: l_next_index BINARY_INTEGER;
3416: l_proc VARCHAR2(30) := 'DEPOSIT ATTRIBUTE INFO';
3417: l_attribute1 HXC_TIME_ATTRIBUTES.ATTRIBUTE1%TYPE := P_ATTRIBUTE1;
3418: l_attribute_category HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;
3419: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;
3420:
3421: BEGIN
3422: --

Line 3419: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;

3415: l_next_index BINARY_INTEGER;
3416: l_proc VARCHAR2(30) := 'DEPOSIT ATTRIBUTE INFO';
3417: l_attribute1 HXC_TIME_ATTRIBUTES.ATTRIBUTE1%TYPE := P_ATTRIBUTE1;
3418: l_attribute_category HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;
3419: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;
3420:
3421: BEGIN
3422: --
3423: -- Find the next index

Line 5076: hxc_bld_blk_info_types bbit

5072: ,ta.BLD_BLK_INFO_TYPE_ID ta_INFO_TYPE
5073: ,ta.OBJECT_VERSION_NUMBER ta_OVN
5074: from hxc_time_attribute_usages tau,
5075: hxc_time_attributes ta,
5076: hxc_bld_blk_info_types bbit
5077: where tau.time_building_block_id = p_tbb_id
5078: and tau.time_building_block_ovn = p_tbb_ovn
5079: and ta.time_attribute_id = tau.time_attribute_id
5080: and ta.bld_blk_info_type_id = bbit.bld_blk_info_type_id;

Line 5656: hxc_bld_blk_info_types hbbit

5652: hta.bld_blk_info_type_id, hta.object_version_number, 'N' NEW,
5653: 'N' changed, 'N' process
5654: FROM hxc_time_attributes hta,
5655: hxc_time_attribute_usages htau,
5656: hxc_bld_blk_info_types hbbit
5657: WHERE htau.time_building_block_id = p_build_block_id
5658: AND htau.time_building_block_ovn = p_build_block_ovn
5659: AND htau.time_attribute_id = hta.time_attribute_id
5660: AND hta.bld_blk_info_type_id = hbbit.bld_blk_info_type_id;