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.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXC_GENERIC_RETRIEVAL_PKG

Line 333: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

329: -- In the case where an excpetion is thrown for a bb_id without processing
330: -- the attibutes, this funciton is used to maintain the p_last_att_index
331: -- index
332: FUNCTION sync_attributes (
333: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
334: p_bb_id IN NUMBER,
335: p_last_att_index IN BINARY_INTEGER
336: )
337: RETURN VARCHAR2

Line 367: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

363: --
364: --------------------------- get_attributes -------------------------------
365: --
366: PROCEDURE get_attributes (
367: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
368: p_bb_id IN NUMBER,
369: p_field_name OUT NOCOPY t_field_name,
370: p_value OUT NOCOPY t_value,
371: p_context OUT NOCOPY t_field_name,

Line 2067: IF (hxc_generic_retrieval_pkg.t_tx_detail_bb_id (p_bb_index) <>

2063: hr_utility.TRACE ('Status is ' || p_status);
2064: hr_utility.TRACE ('Exception is ' || p_excep);
2065: END IF;
2066:
2067: IF (hxc_generic_retrieval_pkg.t_tx_detail_bb_id (p_bb_index) <>
2068: p_bb_id
2069: )
2070: THEN
2071: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 2077: hxc_generic_retrieval_pkg.t_tx_detail_status (p_bb_index) := p_status;

2073: fnd_message.set_token ('STEP', 'status bb id mismatch');
2074: fnd_message.raise_error;
2075: END IF;
2076:
2077: hxc_generic_retrieval_pkg.t_tx_detail_status (p_bb_index) := p_status;
2078: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_bb_index) :=
2079: p_excep;
2080:
2081: IF g_debug

Line 2078: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_bb_index) :=

2074: fnd_message.raise_error;
2075: END IF;
2076:
2077: hxc_generic_retrieval_pkg.t_tx_detail_status (p_bb_index) := p_status;
2078: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_bb_index) :=
2079: p_excep;
2080:
2081: IF g_debug
2082: THEN

Line 2209: hxc_generic_retrieval_pkg.execute_retrieval_process

2205: g_timecards.DELETE;
2206: l_last_att_index := NULL;
2207: l_old_last_att_index := NULL;
2208: l_old_bb_index := NULL; -- GPM v115.45 WWB 3245991
2209: hxc_generic_retrieval_pkg.execute_retrieval_process
2210: (p_process => l_process_name,
2211: p_transaction_code => p_retrieval_transaction_code,
2212: p_start_date => l_start_date,
2213: p_end_date => l_end_date,

Line 2246: -- g_cnt_t_bld_blks := hxc_generic_retrieval_pkg.t_bld_blks.COUNT;

2242:
2243: --
2244: ----------------------------- Transfer to BEE -----------------------------
2245: --
2246: -- g_cnt_t_bld_blks := hxc_generic_retrieval_pkg.t_bld_blks.COUNT;
2247: g_cnt_t_attributes := hxc_generic_retrieval_pkg.t_attributes.COUNT;
2248: g_cnt_t_detail_bld_blks :=
2249: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;
2250: g_cnt_t_detail_attributes :=

Line 2247: g_cnt_t_attributes := hxc_generic_retrieval_pkg.t_attributes.COUNT;

2243: --
2244: ----------------------------- Transfer to BEE -----------------------------
2245: --
2246: -- g_cnt_t_bld_blks := hxc_generic_retrieval_pkg.t_bld_blks.COUNT;
2247: g_cnt_t_attributes := hxc_generic_retrieval_pkg.t_attributes.COUNT;
2248: g_cnt_t_detail_bld_blks :=
2249: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;
2250: g_cnt_t_detail_attributes :=
2251: hxc_generic_retrieval_pkg.t_detail_attributes.COUNT;

Line 2249: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;

2245: --
2246: -- g_cnt_t_bld_blks := hxc_generic_retrieval_pkg.t_bld_blks.COUNT;
2247: g_cnt_t_attributes := hxc_generic_retrieval_pkg.t_attributes.COUNT;
2248: g_cnt_t_detail_bld_blks :=
2249: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;
2250: g_cnt_t_detail_attributes :=
2251: hxc_generic_retrieval_pkg.t_detail_attributes.COUNT;
2252: g_cnt_t_day_bld_blks :=
2253: hxc_generic_retrieval_pkg.t_day_bld_blks.COUNT;

Line 2251: hxc_generic_retrieval_pkg.t_detail_attributes.COUNT;

2247: g_cnt_t_attributes := hxc_generic_retrieval_pkg.t_attributes.COUNT;
2248: g_cnt_t_detail_bld_blks :=
2249: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;
2250: g_cnt_t_detail_attributes :=
2251: hxc_generic_retrieval_pkg.t_detail_attributes.COUNT;
2252: g_cnt_t_day_bld_blks :=
2253: hxc_generic_retrieval_pkg.t_day_bld_blks.COUNT;
2254: --
2255: g_cnt_t_old_day_bld_blks :=

Line 2253: hxc_generic_retrieval_pkg.t_day_bld_blks.COUNT;

2249: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;
2250: g_cnt_t_detail_attributes :=
2251: hxc_generic_retrieval_pkg.t_detail_attributes.COUNT;
2252: g_cnt_t_day_bld_blks :=
2253: hxc_generic_retrieval_pkg.t_day_bld_blks.COUNT;
2254: --
2255: g_cnt_t_old_day_bld_blks :=
2256: hxc_generic_retrieval_pkg.t_old_day_bld_blks.COUNT;
2257: g_cnt_t_old_detail_bld_blks :=

Line 2256: hxc_generic_retrieval_pkg.t_old_day_bld_blks.COUNT;

2252: g_cnt_t_day_bld_blks :=
2253: hxc_generic_retrieval_pkg.t_day_bld_blks.COUNT;
2254: --
2255: g_cnt_t_old_day_bld_blks :=
2256: hxc_generic_retrieval_pkg.t_old_day_bld_blks.COUNT;
2257: g_cnt_t_old_detail_bld_blks :=
2258: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT;
2259: g_cnt_t_old_detail_attributes :=
2260: hxc_generic_retrieval_pkg.t_old_detail_attributes.COUNT;

Line 2258: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT;

2254: --
2255: g_cnt_t_old_day_bld_blks :=
2256: hxc_generic_retrieval_pkg.t_old_day_bld_blks.COUNT;
2257: g_cnt_t_old_detail_bld_blks :=
2258: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT;
2259: g_cnt_t_old_detail_attributes :=
2260: hxc_generic_retrieval_pkg.t_old_detail_attributes.COUNT;
2261: --
2262: g_cnt_t_tx_det_bb_id :=

Line 2260: hxc_generic_retrieval_pkg.t_old_detail_attributes.COUNT;

2256: hxc_generic_retrieval_pkg.t_old_day_bld_blks.COUNT;
2257: g_cnt_t_old_detail_bld_blks :=
2258: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT;
2259: g_cnt_t_old_detail_attributes :=
2260: hxc_generic_retrieval_pkg.t_old_detail_attributes.COUNT;
2261: --
2262: g_cnt_t_tx_det_bb_id :=
2263: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT;
2264: g_cnt_t_tx_det_status :=

Line 2263: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT;

2259: g_cnt_t_old_detail_attributes :=
2260: hxc_generic_retrieval_pkg.t_old_detail_attributes.COUNT;
2261: --
2262: g_cnt_t_tx_det_bb_id :=
2263: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT;
2264: g_cnt_t_tx_det_status :=
2265: hxc_generic_retrieval_pkg.t_tx_detail_status.COUNT;
2266: g_cnt_t_tx_det_exception :=
2267: hxc_generic_retrieval_pkg.t_tx_detail_exception.COUNT;

Line 2265: hxc_generic_retrieval_pkg.t_tx_detail_status.COUNT;

2261: --
2262: g_cnt_t_tx_det_bb_id :=
2263: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT;
2264: g_cnt_t_tx_det_status :=
2265: hxc_generic_retrieval_pkg.t_tx_detail_status.COUNT;
2266: g_cnt_t_tx_det_exception :=
2267: hxc_generic_retrieval_pkg.t_tx_detail_exception.COUNT;
2268:
2269: --

Line 2267: hxc_generic_retrieval_pkg.t_tx_detail_exception.COUNT;

2263: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT;
2264: g_cnt_t_tx_det_status :=
2265: hxc_generic_retrieval_pkg.t_tx_detail_status.COUNT;
2266: g_cnt_t_tx_det_exception :=
2267: hxc_generic_retrieval_pkg.t_tx_detail_exception.COUNT;
2268:
2269: --
2270: -- FOR l_cnt in 1 .. g_cnt_t_detail_bld_blks LOOP
2271: IF hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT <> 0

Line 2271: IF hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT <> 0

2267: hxc_generic_retrieval_pkg.t_tx_detail_exception.COUNT;
2268:
2269: --
2270: -- FOR l_cnt in 1 .. g_cnt_t_detail_bld_blks LOOP
2271: IF hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT <> 0
2272: THEN
2273: --
2274: FOR l_cnt IN
2275: hxc_generic_retrieval_pkg.t_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_detail_bld_blks.LAST

Line 2275: hxc_generic_retrieval_pkg.t_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_detail_bld_blks.LAST

2271: IF hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT <> 0
2272: THEN
2273: --
2274: FOR l_cnt IN
2275: hxc_generic_retrieval_pkg.t_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_detail_bld_blks.LAST
2276: LOOP
2277: BEGIN
2278: l_bb_id :=
2279: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).bb_id;

Line 2279: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).bb_id;

2275: hxc_generic_retrieval_pkg.t_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_detail_bld_blks.LAST
2276: LOOP
2277: BEGIN
2278: l_bb_id :=
2279: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).bb_id;
2280: l_ovn :=
2281: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).ovn;
2282: l_type :=
2283: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;

Line 2281: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).ovn;

2277: BEGIN
2278: l_bb_id :=
2279: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).bb_id;
2280: l_ovn :=
2281: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).ovn;
2282: l_type :=
2283: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;
2284: l_measure :=
2285: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;

Line 2283: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;

2279: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).bb_id;
2280: l_ovn :=
2281: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).ovn;
2282: l_type :=
2283: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;
2284: l_measure :=
2285: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;
2286: l_start_time :=
2287: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;

Line 2285: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;

2281: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).ovn;
2282: l_type :=
2283: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;
2284: l_measure :=
2285: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;
2286: l_start_time :=
2287: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;
2288: l_stop_time :=
2289: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;

Line 2287: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;

2283: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;
2284: l_measure :=
2285: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;
2286: l_start_time :=
2287: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;
2288: l_stop_time :=
2289: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;
2290: l_parent_bb_id :=
2291: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;

Line 2289: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;

2285: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;
2286: l_start_time :=
2287: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;
2288: l_stop_time :=
2289: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;
2290: l_parent_bb_id :=
2291: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;
2292: l_scope :=
2293: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;

Line 2291: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;

2287: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;
2288: l_stop_time :=
2289: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;
2290: l_parent_bb_id :=
2291: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;
2292: l_scope :=
2293: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;
2294: l_resource_id :=
2295: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;

Line 2293: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;

2289: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;
2290: l_parent_bb_id :=
2291: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;
2292: l_scope :=
2293: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;
2294: l_resource_id :=
2295: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;
2296: l_resource_type :=
2297: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;

Line 2295: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;

2291: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;
2292: l_scope :=
2293: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;
2294: l_resource_id :=
2295: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;
2296: l_resource_type :=
2297: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;
2298: l_comment_text :=
2299: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;

Line 2297: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;

2293: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;
2294: l_resource_id :=
2295: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;
2296: l_resource_type :=
2297: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;
2298: l_comment_text :=
2299: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;
2300: l_changed :=
2301: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).changed;

Line 2299: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;

2295: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;
2296: l_resource_type :=
2297: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;
2298: l_comment_text :=
2299: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;
2300: l_changed :=
2301: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).changed;
2302: l_deleted :=
2303: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).deleted;

Line 2301: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).changed;

2297: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;
2298: l_comment_text :=
2299: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;
2300: l_changed :=
2301: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).changed;
2302: l_deleted :=
2303: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).deleted;
2304: l_no_times := 'N';
2305:

Line 2303: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).deleted;

2299: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;
2300: l_changed :=
2301: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).changed;
2302: l_deleted :=
2303: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).deleted;
2304: l_no_times := 'N';
2305:
2306: --
2307: IF g_debug

Line 2349: hxc_generic_retrieval_pkg.t_day_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_day_bld_blks.LAST

2345:
2346: IF l_type = 'MEASURE' AND l_start_time IS NULL
2347: THEN
2348: FOR l_bb_cnt IN
2349: hxc_generic_retrieval_pkg.t_day_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_day_bld_blks.LAST
2350: LOOP
2351: --
2352: IF (l_parent_bb_id =
2353: hxc_generic_retrieval_pkg.t_day_bld_blks

Line 2353: hxc_generic_retrieval_pkg.t_day_bld_blks

2349: hxc_generic_retrieval_pkg.t_day_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_day_bld_blks.LAST
2350: LOOP
2351: --
2352: IF (l_parent_bb_id =
2353: hxc_generic_retrieval_pkg.t_day_bld_blks
2354: (l_bb_cnt).bb_id
2355: )
2356: AND (hxc_generic_retrieval_pkg.t_day_bld_blks
2357: (l_bb_cnt).SCOPE =

Line 2356: AND (hxc_generic_retrieval_pkg.t_day_bld_blks

2352: IF (l_parent_bb_id =
2353: hxc_generic_retrieval_pkg.t_day_bld_blks
2354: (l_bb_cnt).bb_id
2355: )
2356: AND (hxc_generic_retrieval_pkg.t_day_bld_blks
2357: (l_bb_cnt).SCOPE =
2358: 'DAY'
2359: )
2360: THEN

Line 2363: hxc_generic_retrieval_pkg.t_day_bld_blks

2359: )
2360: THEN
2361: --
2362: l_start_time :=
2363: hxc_generic_retrieval_pkg.t_day_bld_blks
2364: (l_bb_cnt).start_time;
2365: l_stop_time :=
2366: hxc_generic_retrieval_pkg.t_day_bld_blks
2367: (l_bb_cnt).stop_time;

Line 2366: hxc_generic_retrieval_pkg.t_day_bld_blks

2362: l_start_time :=
2363: hxc_generic_retrieval_pkg.t_day_bld_blks
2364: (l_bb_cnt).start_time;
2365: l_stop_time :=
2366: hxc_generic_retrieval_pkg.t_day_bld_blks
2367: (l_bb_cnt).stop_time;
2368: l_no_times := 'Y';
2369:
2370: --

Line 2464: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,

2460: 'HR_52365_PTU_NO_PERSON_EXISTS'
2461: );
2462: l_last_att_index :=
2463: sync_attributes
2464: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,
2465: p_bb_id => l_bb_id,
2466: p_last_att_index => l_last_att_index
2467: );
2468: l_old_last_att_index :=

Line 2470: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,

2466: p_last_att_index => l_last_att_index
2467: );
2468: l_old_last_att_index :=
2469: sync_attributes
2470: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,
2471: p_bb_id => l_bb_id,
2472: p_last_att_index => l_old_last_att_index
2473: );
2474: hr_utility.raise_error;

Line 2488: (hxc_generic_retrieval_pkg.t_detail_attributes,

2484: l_context.DELETE;
2485: l_category.DELETE;
2486: --
2487: get_attributes
2488: (hxc_generic_retrieval_pkg.t_detail_attributes,
2489: l_bb_id,
2490: l_field_name,
2491: l_value,
2492: l_context,

Line 2603: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

2599:
2600: l_old_bb_index :=
2601: NVL
2602: (l_old_bb_index,
2603: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
2604: );
2605:
2606: --
2607: IF g_debug

Line 2613: (hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT

2609: hr_utility.TRACE ('Before IF');
2610: hr_utility.TRACE
2611: ( 'g_cnt_t_old_detail_bld_blks count is '
2612: || TO_CHAR
2613: (hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT
2614: )
2615: );
2616: hr_utility.TRACE ( 'l_old_bb_index IS : '
2617: || TO_CHAR (l_old_bb_index)

Line 2634: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_old_detail_bld_blks.LAST

2630:
2631: IF g_debug
2632: THEN
2633: FOR i IN
2634: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_old_detail_bld_blks.LAST
2635: LOOP
2636: hr_utility.TRACE
2637: ( 'BB ID IS : '
2638: || TO_CHAR

Line 2639: (hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2635: LOOP
2636: hr_utility.TRACE
2637: ( 'BB ID IS : '
2638: || TO_CHAR
2639: (hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2640: (i).bb_id
2641: )
2642: );
2643: hr_utility.TRACE ('i is : ' || TO_CHAR (i));

Line 2650: -- IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks(l_cnt).bb_id <> l_bb_id

2646:
2647:
2648:
2649: --
2650: -- IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks(l_cnt).bb_id <> l_bb_id
2651: IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2652: (l_old_bb_index).bb_id <>
2653: l_bb_id
2654: THEN

Line 2651: IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2647:
2648:
2649: --
2650: -- IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks(l_cnt).bb_id <> l_bb_id
2651: IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2652: (l_old_bb_index).bb_id <>
2653: l_bb_id
2654: THEN
2655: IF g_debug

Line 2682: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2678: END IF;
2679:
2680: --
2681: l_old_ovn :=
2682: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2683: (l_old_bb_index).ovn;
2684: l_old_type :=
2685: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2686: (l_old_bb_index).TYPE;

Line 2685: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2681: l_old_ovn :=
2682: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2683: (l_old_bb_index).ovn;
2684: l_old_type :=
2685: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2686: (l_old_bb_index).TYPE;
2687: l_old_measure :=
2688: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2689: (l_old_bb_index).measure;

Line 2688: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2684: l_old_type :=
2685: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2686: (l_old_bb_index).TYPE;
2687: l_old_measure :=
2688: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2689: (l_old_bb_index).measure;
2690: l_old_start_time :=
2691: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2692: (l_old_bb_index).start_time;

Line 2691: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2687: l_old_measure :=
2688: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2689: (l_old_bb_index).measure;
2690: l_old_start_time :=
2691: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2692: (l_old_bb_index).start_time;
2693: l_old_stop_time :=
2694: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2695: (l_old_bb_index).stop_time;

Line 2694: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2690: l_old_start_time :=
2691: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2692: (l_old_bb_index).start_time;
2693: l_old_stop_time :=
2694: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2695: (l_old_bb_index).stop_time;
2696: l_old_parent_bb_id :=
2697: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2698: (l_old_bb_index).parent_bb_id;

Line 2697: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2693: l_old_stop_time :=
2694: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2695: (l_old_bb_index).stop_time;
2696: l_old_parent_bb_id :=
2697: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2698: (l_old_bb_index).parent_bb_id;
2699: l_old_scope :=
2700: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2701: (l_old_bb_index).SCOPE;

Line 2700: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2696: l_old_parent_bb_id :=
2697: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2698: (l_old_bb_index).parent_bb_id;
2699: l_old_scope :=
2700: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2701: (l_old_bb_index).SCOPE;
2702: l_old_resource_id :=
2703: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2704: (l_old_bb_index).resource_id;

Line 2703: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2699: l_old_scope :=
2700: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2701: (l_old_bb_index).SCOPE;
2702: l_old_resource_id :=
2703: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2704: (l_old_bb_index).resource_id;
2705: l_old_resource_type :=
2706: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2707: (l_old_bb_index).resource_type;

Line 2706: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2702: l_old_resource_id :=
2703: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2704: (l_old_bb_index).resource_id;
2705: l_old_resource_type :=
2706: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2707: (l_old_bb_index).resource_type;
2708: l_old_comment_text :=
2709: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2710: (l_old_bb_index).comment_text;

Line 2709: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

2705: l_old_resource_type :=
2706: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2707: (l_old_bb_index).resource_type;
2708: l_old_comment_text :=
2709: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
2710: (l_old_bb_index).comment_text;
2711: l_no_old_times := 'N';
2712: l_old_bb_index := l_old_bb_index + 1;
2713:

Line 2724: hxc_generic_retrieval_pkg.t_old_day_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_old_day_bld_blks.LAST

2720: IF l_old_type = 'MEASURE'
2721: AND l_old_start_time IS NULL
2722: THEN
2723: FOR l_old_bb_cnt IN
2724: hxc_generic_retrieval_pkg.t_old_day_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_old_day_bld_blks.LAST
2725: LOOP
2726: --
2727: IF g_debug
2728: THEN

Line 2736: hxc_generic_retrieval_pkg.t_old_day_bld_blks

2732: END IF;
2733:
2734: --
2735: IF (l_old_parent_bb_id =
2736: hxc_generic_retrieval_pkg.t_old_day_bld_blks
2737: (l_old_bb_cnt).bb_id
2738: )
2739: AND hxc_generic_retrieval_pkg.t_old_day_bld_blks
2740: (l_old_bb_cnt).SCOPE =

Line 2739: AND hxc_generic_retrieval_pkg.t_old_day_bld_blks

2735: IF (l_old_parent_bb_id =
2736: hxc_generic_retrieval_pkg.t_old_day_bld_blks
2737: (l_old_bb_cnt).bb_id
2738: )
2739: AND hxc_generic_retrieval_pkg.t_old_day_bld_blks
2740: (l_old_bb_cnt).SCOPE =
2741: 'DAY'
2742: THEN
2743: --

Line 2745: hxc_generic_retrieval_pkg.t_old_day_bld_blks

2741: 'DAY'
2742: THEN
2743: --
2744: l_old_start_time :=
2745: hxc_generic_retrieval_pkg.t_old_day_bld_blks
2746: (l_old_bb_cnt).start_time;
2747: l_old_stop_time :=
2748: hxc_generic_retrieval_pkg.t_old_day_bld_blks
2749: (l_old_bb_cnt).stop_time;

Line 2748: hxc_generic_retrieval_pkg.t_old_day_bld_blks

2744: l_old_start_time :=
2745: hxc_generic_retrieval_pkg.t_old_day_bld_blks
2746: (l_old_bb_cnt).start_time;
2747: l_old_stop_time :=
2748: hxc_generic_retrieval_pkg.t_old_day_bld_blks
2749: (l_old_bb_cnt).stop_time;
2750: l_no_old_times := 'Y';
2751:
2752: --

Line 2804: (hxc_generic_retrieval_pkg.t_old_detail_attributes,

2800: END IF;
2801:
2802: --
2803: get_attributes
2804: (hxc_generic_retrieval_pkg.t_old_detail_attributes,
2805: l_bb_id,
2806: l_old_field_name,
2807: l_old_value,
2808: l_old_context,

Line 3281: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,

3277: );
3278: --
3279: l_last_att_index :=
3280: sync_attributes
3281: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,
3282: p_bb_id => l_bb_id,
3283: p_last_att_index => l_last_att_index
3284: );
3285: l_old_last_att_index :=

Line 3287: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,

3283: p_last_att_index => l_last_att_index
3284: );
3285: l_old_last_att_index :=
3286: sync_attributes
3287: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,
3288: p_bb_id => l_bb_id,
3289: p_last_att_index => l_old_last_att_index
3290: );
3291:

Line 3310: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

3306:
3307: IF l_changed = 'Y' AND p_incremental = 'Y'
3308: THEN
3309: l_old_bb_index := NVL(l_old_bb_index,
3310: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
3311: );
3312:
3313: IF (l_old_bb_index <= g_cnt_t_old_detail_bld_blks)
3314: THEN

Line 3350: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,

3346: p_excep => g_exception_description
3347: );
3348: l_last_att_index :=
3349: sync_attributes
3350: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,
3351: p_bb_id => l_bb_id,
3352: p_last_att_index => l_last_att_index
3353: );
3354: l_old_last_att_index :=

Line 3356: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,

3352: p_last_att_index => l_last_att_index
3353: );
3354: l_old_last_att_index :=
3355: sync_attributes
3356: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,
3357: p_bb_id => l_bb_id,
3358: p_last_att_index => l_old_last_att_index
3359: );
3360:

Line 3367: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

3363:
3364: IF l_changed = 'Y' AND p_incremental = 'Y'
3365: THEN
3366: l_old_bb_index := NVL(l_old_bb_index,
3367: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
3368: );
3369:
3370: IF (l_old_bb_index <= g_cnt_t_old_detail_bld_blks)
3371: THEN

Line 3412: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,

3408: p_excep => g_exception_description
3409: );
3410: l_last_att_index :=
3411: sync_attributes
3412: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,
3413: p_bb_id => l_bb_id,
3414: p_last_att_index => l_last_att_index
3415: );
3416: l_old_last_att_index :=

Line 3418: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,

3414: p_last_att_index => l_last_att_index
3415: );
3416: l_old_last_att_index :=
3417: sync_attributes
3418: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,
3419: p_bb_id => l_bb_id,
3420: p_last_att_index => l_old_last_att_index
3421: );
3422:

Line 3428: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

3424:
3425: IF l_changed = 'Y' AND p_incremental = 'Y'
3426: THEN
3427: l_old_bb_index := NVL(l_old_bb_index,
3428: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
3429: );
3430:
3431: IF (l_old_bb_index <= g_cnt_t_old_detail_bld_blks)
3432: THEN

Line 3469: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,

3465: );
3466: --
3467: l_last_att_index :=
3468: sync_attributes
3469: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,
3470: p_bb_id => l_bb_id,
3471: p_last_att_index => l_last_att_index
3472: );
3473: l_old_last_att_index :=

Line 3475: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,

3471: p_last_att_index => l_last_att_index
3472: );
3473: l_old_last_att_index :=
3474: sync_attributes
3475: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,
3476: p_bb_id => l_bb_id,
3477: p_last_att_index => l_old_last_att_index
3478: );
3479:

Line 3485: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

3481:
3482: IF l_changed = 'Y' AND p_incremental = 'Y'
3483: THEN
3484: l_old_bb_index := NVL(l_old_bb_index,
3485: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
3486: );
3487:
3488: IF (l_old_bb_index <= g_cnt_t_old_detail_bld_blks)
3489: THEN

Line 3525: hxc_generic_retrieval_pkg.update_transaction_status

3521: g_status := 'SUCCESS';
3522: fnd_message.set_name ('HXC', 'HXC_HXT_RET_PROC_SUCCESS');
3523: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
3524: --
3525: hxc_generic_retrieval_pkg.update_transaction_status
3526: (p_process => l_process_name,
3527: p_status => g_status,
3528: p_exception_description => g_exception_description,
3529: p_rollback => FALSE

Line 3614: hxc_generic_retrieval_pkg.update_transaction_status

3610: THEN
3611: --
3612: hxc_generic_retrieval_utils.set_parent_statuses;
3613: --
3614: hxc_generic_retrieval_pkg.update_transaction_status
3615: (p_process => l_process_name,
3616: p_status => g_status,
3617: p_exception_description => g_exception_description,
3618: p_rollback => FALSE

Line 3645: hxc_generic_retrieval_pkg.update_transaction_status

3641: THEN
3642: --
3643: hxc_generic_retrieval_utils.set_parent_statuses;
3644: --
3645: hxc_generic_retrieval_pkg.update_transaction_status
3646: (p_process => l_process_name,
3647: p_status => g_status,
3648: p_exception_description => g_exception_description,
3649: p_rollback => FALSE

Line 3662: hxc_generic_retrieval_pkg.update_transaction_status

3658: AND (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'BOTH')
3659: )
3660: THEN
3661: hxc_generic_retrieval_utils.set_parent_statuses;
3662: hxc_generic_retrieval_pkg.update_transaction_status
3663: (p_process => l_process_name,
3664: p_status => 'ERRORS',
3665: p_exception_description => g_exception_description,
3666: p_rollback => FALSE

Line 3679: hxc_generic_retrieval_pkg.update_transaction_status

3675: ELSIF (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'OTLR')
3676: THEN
3677: hxc_generic_retrieval_utils.set_parent_statuses;
3678: --
3679: hxc_generic_retrieval_pkg.update_transaction_status
3680: (p_process => l_process_name,
3681: p_status => 'ERRORS',
3682: p_exception_description => g_exception_description,
3683: p_rollback => FALSE