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 55: --- hxc_generic_retrieval_pkg.update_transaction_status would have updated all the existing

51: ---
52: ---
53: --- Retro entries to each timecard has a retro batch. This retro batch is generated only
54: --- after explosion. Since the explosion happens at the end of the process, by that time
55: --- hxc_generic_retrieval_pkg.update_transaction_status would have updated all the existing
56: --- and inserted new records into hxc_ret_pay_latest_details
57: --- For all of these updated/inserted records, we need to mark batch_id column with the retro_batch_id
58: --- generated during explosion so that later, Xfer to BEE(Retro) correctly knows which records to
59: --- target.

Line 834: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

830: -- In the case where an excpetion is thrown for a bb_id without processing
831: -- the attibutes, this funciton is used to maintain the p_last_att_index
832: -- index
833: FUNCTION sync_attributes (
834: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
835: p_bb_id IN NUMBER,
836: p_last_att_index IN BINARY_INTEGER
837: )
838: RETURN VARCHAR2

Line 869: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

865: --
866: --------------------------- get_attributes -------------------------------
867: --
868: PROCEDURE get_attributes (
869: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
870: p_bb_id IN NUMBER,
871: p_field_name OUT NOCOPY t_field_name,
872: p_value OUT NOCOPY t_value,
873: p_context OUT NOCOPY t_field_name,

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

2717: hr_utility.TRACE ('Status is ' || p_status);
2718: hr_utility.TRACE ('Exception is ' || p_excep);
2719: END IF;
2720:
2721: IF (hxc_generic_retrieval_pkg.t_tx_detail_bb_id (p_bb_index) <>
2722: p_bb_id
2723: )
2724: THEN
2725: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

2727: fnd_message.set_token ('STEP', 'status bb id mismatch');
2728: fnd_message.raise_error;
2729: END IF;
2730:
2731: hxc_generic_retrieval_pkg.t_tx_detail_status (p_bb_index) := p_status;
2732: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_bb_index) :=
2733: p_excep;
2734:
2735: IF g_debug

Line 2732: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_bb_index) :=

2728: fnd_message.raise_error;
2729: END IF;
2730:
2731: hxc_generic_retrieval_pkg.t_tx_detail_status (p_bb_index) := p_status;
2732: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_bb_index) :=
2733: p_excep;
2734:
2735: IF g_debug
2736: THEN

Line 2868: hxc_generic_retrieval_pkg.execute_retrieval_process

2864: g_rdb_retro_tab := NUMTAB();
2865: l_last_att_index := NULL;
2866: l_old_last_att_index := NULL;
2867: l_old_bb_index := NULL; -- GPM v115.45 WWB 3245991
2868: hxc_generic_retrieval_pkg.execute_retrieval_process
2869: (p_process => l_process_name,
2870: p_transaction_code => p_retrieval_transaction_code,
2871: p_start_date => l_start_date,
2872: p_end_date => l_end_date,

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

2901:
2902: --
2903: ----------------------------- Transfer to BEE -----------------------------
2904: --
2905: -- g_cnt_t_bld_blks := hxc_generic_retrieval_pkg.t_bld_blks.COUNT;
2906: g_cnt_t_attributes := hxc_generic_retrieval_pkg.t_attributes.COUNT;
2907: g_cnt_t_detail_bld_blks :=
2908: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;
2909: g_cnt_t_detail_attributes :=

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

2902: --
2903: ----------------------------- Transfer to BEE -----------------------------
2904: --
2905: -- g_cnt_t_bld_blks := hxc_generic_retrieval_pkg.t_bld_blks.COUNT;
2906: g_cnt_t_attributes := hxc_generic_retrieval_pkg.t_attributes.COUNT;
2907: g_cnt_t_detail_bld_blks :=
2908: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;
2909: g_cnt_t_detail_attributes :=
2910: hxc_generic_retrieval_pkg.t_detail_attributes.COUNT;

Line 2908: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;

2904: --
2905: -- g_cnt_t_bld_blks := hxc_generic_retrieval_pkg.t_bld_blks.COUNT;
2906: g_cnt_t_attributes := hxc_generic_retrieval_pkg.t_attributes.COUNT;
2907: g_cnt_t_detail_bld_blks :=
2908: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;
2909: g_cnt_t_detail_attributes :=
2910: hxc_generic_retrieval_pkg.t_detail_attributes.COUNT;
2911: g_cnt_t_day_bld_blks :=
2912: hxc_generic_retrieval_pkg.t_day_bld_blks.COUNT;

Line 2910: hxc_generic_retrieval_pkg.t_detail_attributes.COUNT;

2906: g_cnt_t_attributes := hxc_generic_retrieval_pkg.t_attributes.COUNT;
2907: g_cnt_t_detail_bld_blks :=
2908: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;
2909: g_cnt_t_detail_attributes :=
2910: hxc_generic_retrieval_pkg.t_detail_attributes.COUNT;
2911: g_cnt_t_day_bld_blks :=
2912: hxc_generic_retrieval_pkg.t_day_bld_blks.COUNT;
2913: --
2914: g_cnt_t_old_day_bld_blks :=

Line 2912: hxc_generic_retrieval_pkg.t_day_bld_blks.COUNT;

2908: hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT;
2909: g_cnt_t_detail_attributes :=
2910: hxc_generic_retrieval_pkg.t_detail_attributes.COUNT;
2911: g_cnt_t_day_bld_blks :=
2912: hxc_generic_retrieval_pkg.t_day_bld_blks.COUNT;
2913: --
2914: g_cnt_t_old_day_bld_blks :=
2915: hxc_generic_retrieval_pkg.t_old_day_bld_blks.COUNT;
2916: g_cnt_t_old_detail_bld_blks :=

Line 2915: hxc_generic_retrieval_pkg.t_old_day_bld_blks.COUNT;

2911: g_cnt_t_day_bld_blks :=
2912: hxc_generic_retrieval_pkg.t_day_bld_blks.COUNT;
2913: --
2914: g_cnt_t_old_day_bld_blks :=
2915: hxc_generic_retrieval_pkg.t_old_day_bld_blks.COUNT;
2916: g_cnt_t_old_detail_bld_blks :=
2917: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT;
2918: g_cnt_t_old_detail_attributes :=
2919: hxc_generic_retrieval_pkg.t_old_detail_attributes.COUNT;

Line 2917: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT;

2913: --
2914: g_cnt_t_old_day_bld_blks :=
2915: hxc_generic_retrieval_pkg.t_old_day_bld_blks.COUNT;
2916: g_cnt_t_old_detail_bld_blks :=
2917: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT;
2918: g_cnt_t_old_detail_attributes :=
2919: hxc_generic_retrieval_pkg.t_old_detail_attributes.COUNT;
2920: --
2921: g_cnt_t_tx_det_bb_id :=

Line 2919: hxc_generic_retrieval_pkg.t_old_detail_attributes.COUNT;

2915: hxc_generic_retrieval_pkg.t_old_day_bld_blks.COUNT;
2916: g_cnt_t_old_detail_bld_blks :=
2917: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT;
2918: g_cnt_t_old_detail_attributes :=
2919: hxc_generic_retrieval_pkg.t_old_detail_attributes.COUNT;
2920: --
2921: g_cnt_t_tx_det_bb_id :=
2922: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT;
2923: g_cnt_t_tx_det_status :=

Line 2922: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT;

2918: g_cnt_t_old_detail_attributes :=
2919: hxc_generic_retrieval_pkg.t_old_detail_attributes.COUNT;
2920: --
2921: g_cnt_t_tx_det_bb_id :=
2922: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT;
2923: g_cnt_t_tx_det_status :=
2924: hxc_generic_retrieval_pkg.t_tx_detail_status.COUNT;
2925: g_cnt_t_tx_det_exception :=
2926: hxc_generic_retrieval_pkg.t_tx_detail_exception.COUNT;

Line 2924: hxc_generic_retrieval_pkg.t_tx_detail_status.COUNT;

2920: --
2921: g_cnt_t_tx_det_bb_id :=
2922: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT;
2923: g_cnt_t_tx_det_status :=
2924: hxc_generic_retrieval_pkg.t_tx_detail_status.COUNT;
2925: g_cnt_t_tx_det_exception :=
2926: hxc_generic_retrieval_pkg.t_tx_detail_exception.COUNT;
2927:
2928: --

Line 2926: hxc_generic_retrieval_pkg.t_tx_detail_exception.COUNT;

2922: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT;
2923: g_cnt_t_tx_det_status :=
2924: hxc_generic_retrieval_pkg.t_tx_detail_status.COUNT;
2925: g_cnt_t_tx_det_exception :=
2926: hxc_generic_retrieval_pkg.t_tx_detail_exception.COUNT;
2927:
2928: --
2929: -- FOR l_cnt in 1 .. g_cnt_t_detail_bld_blks LOOP
2930: IF hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT <> 0

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

2926: hxc_generic_retrieval_pkg.t_tx_detail_exception.COUNT;
2927:
2928: --
2929: -- FOR l_cnt in 1 .. g_cnt_t_detail_bld_blks LOOP
2930: IF hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT <> 0
2931: THEN
2932: --
2933: FOR l_cnt IN
2934: hxc_generic_retrieval_pkg.t_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_detail_bld_blks.LAST

Line 2934: hxc_generic_retrieval_pkg.t_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_detail_bld_blks.LAST

2930: IF hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT <> 0
2931: THEN
2932: --
2933: FOR l_cnt IN
2934: hxc_generic_retrieval_pkg.t_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_detail_bld_blks.LAST
2935: LOOP
2936: BEGIN
2937: l_bb_id :=
2938: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).bb_id;

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

2934: hxc_generic_retrieval_pkg.t_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_detail_bld_blks.LAST
2935: LOOP
2936: BEGIN
2937: l_bb_id :=
2938: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).bb_id;
2939: l_ovn :=
2940: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).ovn;
2941: l_type :=
2942: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;

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

2936: BEGIN
2937: l_bb_id :=
2938: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).bb_id;
2939: l_ovn :=
2940: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).ovn;
2941: l_type :=
2942: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;
2943: l_measure :=
2944: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;

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

2938: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).bb_id;
2939: l_ovn :=
2940: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).ovn;
2941: l_type :=
2942: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;
2943: l_measure :=
2944: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;
2945: l_start_time :=
2946: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;

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

2940: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).ovn;
2941: l_type :=
2942: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;
2943: l_measure :=
2944: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;
2945: l_start_time :=
2946: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;
2947: l_stop_time :=
2948: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;

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

2942: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).TYPE;
2943: l_measure :=
2944: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;
2945: l_start_time :=
2946: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;
2947: l_stop_time :=
2948: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;
2949: l_parent_bb_id :=
2950: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;

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

2944: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).measure;
2945: l_start_time :=
2946: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;
2947: l_stop_time :=
2948: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;
2949: l_parent_bb_id :=
2950: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;
2951: l_scope :=
2952: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;

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

2946: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).start_time;
2947: l_stop_time :=
2948: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;
2949: l_parent_bb_id :=
2950: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;
2951: l_scope :=
2952: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;
2953: l_resource_id :=
2954: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;

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

2948: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).stop_time;
2949: l_parent_bb_id :=
2950: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;
2951: l_scope :=
2952: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;
2953: l_resource_id :=
2954: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;
2955: l_resource_type :=
2956: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;

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

2950: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).parent_bb_id;
2951: l_scope :=
2952: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;
2953: l_resource_id :=
2954: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;
2955: l_resource_type :=
2956: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;
2957: l_comment_text :=
2958: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;

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

2952: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).SCOPE;
2953: l_resource_id :=
2954: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;
2955: l_resource_type :=
2956: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;
2957: l_comment_text :=
2958: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;
2959: l_changed :=
2960: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).changed;

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

2954: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_id;
2955: l_resource_type :=
2956: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;
2957: l_comment_text :=
2958: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;
2959: l_changed :=
2960: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).changed;
2961: l_deleted :=
2962: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).deleted;

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

2956: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).resource_type;
2957: l_comment_text :=
2958: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;
2959: l_changed :=
2960: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).changed;
2961: l_deleted :=
2962: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).deleted;
2963: l_no_times := 'N';
2964: -- Bug 12850901

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

2958: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).comment_text;
2959: l_changed :=
2960: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).changed;
2961: l_deleted :=
2962: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).deleted;
2963: l_no_times := 'N';
2964: -- Bug 12850901
2965: -- Picking up the tc bb id and OVN too.
2966: l_tc_bb_id :=

Line 2967: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).timecard_bb_id;

2963: l_no_times := 'N';
2964: -- Bug 12850901
2965: -- Picking up the tc bb id and OVN too.
2966: l_tc_bb_id :=
2967: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).timecard_bb_id;
2968: l_tc_ovn :=
2969: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).timecard_ovn;
2970:
2971:

Line 2969: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).timecard_ovn;

2965: -- Picking up the tc bb id and OVN too.
2966: l_tc_bb_id :=
2967: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).timecard_bb_id;
2968: l_tc_ovn :=
2969: hxc_generic_retrieval_pkg.t_detail_bld_blks (l_cnt).timecard_ovn;
2970:
2971:
2972: -- Bug 8888777
2973: -- Clear any left over data.

Line 3023: hxc_generic_retrieval_pkg.t_day_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_day_bld_blks.LAST

3019:
3020: IF l_type = 'MEASURE' AND l_start_time IS NULL
3021: THEN
3022: FOR l_bb_cnt IN
3023: hxc_generic_retrieval_pkg.t_day_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_day_bld_blks.LAST
3024: LOOP
3025: --
3026: IF (l_parent_bb_id =
3027: hxc_generic_retrieval_pkg.t_day_bld_blks

Line 3027: hxc_generic_retrieval_pkg.t_day_bld_blks

3023: hxc_generic_retrieval_pkg.t_day_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_day_bld_blks.LAST
3024: LOOP
3025: --
3026: IF (l_parent_bb_id =
3027: hxc_generic_retrieval_pkg.t_day_bld_blks
3028: (l_bb_cnt).bb_id
3029: )
3030: AND (hxc_generic_retrieval_pkg.t_day_bld_blks
3031: (l_bb_cnt).SCOPE =

Line 3030: AND (hxc_generic_retrieval_pkg.t_day_bld_blks

3026: IF (l_parent_bb_id =
3027: hxc_generic_retrieval_pkg.t_day_bld_blks
3028: (l_bb_cnt).bb_id
3029: )
3030: AND (hxc_generic_retrieval_pkg.t_day_bld_blks
3031: (l_bb_cnt).SCOPE =
3032: 'DAY'
3033: )
3034: THEN

Line 3037: hxc_generic_retrieval_pkg.t_day_bld_blks

3033: )
3034: THEN
3035: --
3036: l_start_time :=
3037: hxc_generic_retrieval_pkg.t_day_bld_blks
3038: (l_bb_cnt).start_time;
3039: l_stop_time :=
3040: hxc_generic_retrieval_pkg.t_day_bld_blks
3041: (l_bb_cnt).stop_time;

Line 3040: hxc_generic_retrieval_pkg.t_day_bld_blks

3036: l_start_time :=
3037: hxc_generic_retrieval_pkg.t_day_bld_blks
3038: (l_bb_cnt).start_time;
3039: l_stop_time :=
3040: hxc_generic_retrieval_pkg.t_day_bld_blks
3041: (l_bb_cnt).stop_time;
3042: l_no_times := 'Y';
3043:
3044: --

Line 3138: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,

3134: 'HR_52365_PTU_NO_PERSON_EXISTS'
3135: );
3136: l_last_att_index :=
3137: sync_attributes
3138: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,
3139: p_bb_id => l_bb_id,
3140: p_last_att_index => l_last_att_index
3141: );
3142: l_old_last_att_index :=

Line 3144: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,

3140: p_last_att_index => l_last_att_index
3141: );
3142: l_old_last_att_index :=
3143: sync_attributes
3144: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,
3145: p_bb_id => l_bb_id,
3146: p_last_att_index => l_old_last_att_index
3147: );
3148: hr_utility.raise_error;

Line 3162: (hxc_generic_retrieval_pkg.t_detail_attributes,

3158: l_context.DELETE;
3159: l_category.DELETE;
3160: --
3161: get_attributes
3162: (hxc_generic_retrieval_pkg.t_detail_attributes,
3163: l_bb_id,
3164: l_field_name,
3165: l_value,
3166: l_context,

Line 3277: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

3273:
3274: l_old_bb_index :=
3275: NVL
3276: (l_old_bb_index,
3277: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
3278: );
3279:
3280: --
3281: IF g_debug

Line 3287: (hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT

3283: hr_utility.TRACE ('Before IF');
3284: hr_utility.TRACE
3285: ( 'g_cnt_t_old_detail_bld_blks count is '
3286: || TO_CHAR
3287: (hxc_generic_retrieval_pkg.t_old_detail_bld_blks.COUNT
3288: )
3289: );
3290: hr_utility.TRACE ( 'l_old_bb_index IS : '
3291: || TO_CHAR (l_old_bb_index)

Line 3308: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_old_detail_bld_blks.LAST

3304:
3305: IF g_debug
3306: THEN
3307: FOR i IN
3308: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_old_detail_bld_blks.LAST
3309: LOOP
3310: hr_utility.TRACE
3311: ( 'BB ID IS : '
3312: || TO_CHAR

Line 3313: (hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3309: LOOP
3310: hr_utility.TRACE
3311: ( 'BB ID IS : '
3312: || TO_CHAR
3313: (hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3314: (i).bb_id
3315: )
3316: );
3317: hr_utility.TRACE ('i is : ' || TO_CHAR (i));

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

3320:
3321:
3322:
3323: --
3324: -- IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks(l_cnt).bb_id <> l_bb_id
3325: IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3326: (l_old_bb_index).bb_id <>
3327: l_bb_id
3328: THEN

Line 3325: IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3321:
3322:
3323: --
3324: -- IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks(l_cnt).bb_id <> l_bb_id
3325: IF hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3326: (l_old_bb_index).bb_id <>
3327: l_bb_id
3328: THEN
3329: IF g_debug

Line 3356: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3352: END IF;
3353:
3354: --
3355: l_old_ovn :=
3356: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3357: (l_old_bb_index).ovn;
3358: l_old_type :=
3359: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3360: (l_old_bb_index).TYPE;

Line 3359: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3355: l_old_ovn :=
3356: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3357: (l_old_bb_index).ovn;
3358: l_old_type :=
3359: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3360: (l_old_bb_index).TYPE;
3361: l_old_measure :=
3362: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3363: (l_old_bb_index).measure;

Line 3362: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3358: l_old_type :=
3359: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3360: (l_old_bb_index).TYPE;
3361: l_old_measure :=
3362: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3363: (l_old_bb_index).measure;
3364: l_old_start_time :=
3365: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3366: (l_old_bb_index).start_time;

Line 3365: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3361: l_old_measure :=
3362: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3363: (l_old_bb_index).measure;
3364: l_old_start_time :=
3365: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3366: (l_old_bb_index).start_time;
3367: l_old_stop_time :=
3368: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3369: (l_old_bb_index).stop_time;

Line 3368: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3364: l_old_start_time :=
3365: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3366: (l_old_bb_index).start_time;
3367: l_old_stop_time :=
3368: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3369: (l_old_bb_index).stop_time;
3370: l_old_parent_bb_id :=
3371: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3372: (l_old_bb_index).parent_bb_id;

Line 3371: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3367: l_old_stop_time :=
3368: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3369: (l_old_bb_index).stop_time;
3370: l_old_parent_bb_id :=
3371: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3372: (l_old_bb_index).parent_bb_id;
3373: l_old_scope :=
3374: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3375: (l_old_bb_index).SCOPE;

Line 3374: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3370: l_old_parent_bb_id :=
3371: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3372: (l_old_bb_index).parent_bb_id;
3373: l_old_scope :=
3374: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3375: (l_old_bb_index).SCOPE;
3376: l_old_resource_id :=
3377: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3378: (l_old_bb_index).resource_id;

Line 3377: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3373: l_old_scope :=
3374: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3375: (l_old_bb_index).SCOPE;
3376: l_old_resource_id :=
3377: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3378: (l_old_bb_index).resource_id;
3379: l_old_resource_type :=
3380: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3381: (l_old_bb_index).resource_type;

Line 3380: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3376: l_old_resource_id :=
3377: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3378: (l_old_bb_index).resource_id;
3379: l_old_resource_type :=
3380: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3381: (l_old_bb_index).resource_type;
3382: l_old_comment_text :=
3383: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3384: (l_old_bb_index).comment_text;

Line 3383: hxc_generic_retrieval_pkg.t_old_detail_bld_blks

3379: l_old_resource_type :=
3380: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3381: (l_old_bb_index).resource_type;
3382: l_old_comment_text :=
3383: hxc_generic_retrieval_pkg.t_old_detail_bld_blks
3384: (l_old_bb_index).comment_text;
3385: l_no_old_times := 'N';
3386:
3387: -- Bug 9308216

Line 3406: hxc_generic_retrieval_pkg.t_old_day_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_old_day_bld_blks.LAST

3402: IF l_old_type = 'MEASURE'
3403: AND l_old_start_time IS NULL
3404: THEN
3405: FOR l_old_bb_cnt IN
3406: hxc_generic_retrieval_pkg.t_old_day_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_old_day_bld_blks.LAST
3407: LOOP
3408: --
3409: IF g_debug
3410: THEN

Line 3418: hxc_generic_retrieval_pkg.t_old_day_bld_blks

3414: END IF;
3415:
3416: --
3417: IF (l_old_parent_bb_id =
3418: hxc_generic_retrieval_pkg.t_old_day_bld_blks
3419: (l_old_bb_cnt).bb_id
3420: )
3421: AND hxc_generic_retrieval_pkg.t_old_day_bld_blks
3422: (l_old_bb_cnt).SCOPE =

Line 3421: AND hxc_generic_retrieval_pkg.t_old_day_bld_blks

3417: IF (l_old_parent_bb_id =
3418: hxc_generic_retrieval_pkg.t_old_day_bld_blks
3419: (l_old_bb_cnt).bb_id
3420: )
3421: AND hxc_generic_retrieval_pkg.t_old_day_bld_blks
3422: (l_old_bb_cnt).SCOPE =
3423: 'DAY'
3424: THEN
3425: --

Line 3427: hxc_generic_retrieval_pkg.t_old_day_bld_blks

3423: 'DAY'
3424: THEN
3425: --
3426: l_old_start_time :=
3427: hxc_generic_retrieval_pkg.t_old_day_bld_blks
3428: (l_old_bb_cnt).start_time;
3429: l_old_stop_time :=
3430: hxc_generic_retrieval_pkg.t_old_day_bld_blks
3431: (l_old_bb_cnt).stop_time;

Line 3430: hxc_generic_retrieval_pkg.t_old_day_bld_blks

3426: l_old_start_time :=
3427: hxc_generic_retrieval_pkg.t_old_day_bld_blks
3428: (l_old_bb_cnt).start_time;
3429: l_old_stop_time :=
3430: hxc_generic_retrieval_pkg.t_old_day_bld_blks
3431: (l_old_bb_cnt).stop_time;
3432: l_no_old_times := 'Y';
3433:
3434: --

Line 3486: (hxc_generic_retrieval_pkg.t_old_detail_attributes,

3482: END IF;
3483:
3484: --
3485: get_attributes
3486: (hxc_generic_retrieval_pkg.t_old_detail_attributes,
3487: l_bb_id,
3488: l_old_field_name,
3489: l_old_value,
3490: l_old_context,

Line 3980: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

3976: END IF;
3977: IF l_changed = 'Y' AND p_incremental = 'Y'
3978: THEN
3979: l_old_bb_index := NVL(l_old_bb_index,
3980: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
3981: );
3982:
3983: IF (l_old_bb_index <= g_cnt_t_old_detail_bld_blks)
3984: THEN

Line 4010: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,

4006: );
4007: --
4008: l_last_att_index :=
4009: sync_attributes
4010: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,
4011: p_bb_id => l_bb_id,
4012: p_last_att_index => l_last_att_index
4013: );
4014: l_old_last_att_index :=

Line 4016: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,

4012: p_last_att_index => l_last_att_index
4013: );
4014: l_old_last_att_index :=
4015: sync_attributes
4016: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,
4017: p_bb_id => l_bb_id,
4018: p_last_att_index => l_old_last_att_index
4019: );
4020:

Line 4044: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

4040:
4041: IF l_changed = 'Y' AND p_incremental = 'Y'
4042: THEN
4043: l_old_bb_index := NVL(l_old_bb_index,
4044: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
4045: );
4046:
4047: IF (l_old_bb_index <= g_cnt_t_old_detail_bld_blks)
4048: THEN

Line 4085: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,

4081: p_excep => g_exception_description
4082: );
4083: l_last_att_index :=
4084: sync_attributes
4085: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,
4086: p_bb_id => l_bb_id,
4087: p_last_att_index => l_last_att_index
4088: );
4089: l_old_last_att_index :=

Line 4091: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,

4087: p_last_att_index => l_last_att_index
4088: );
4089: l_old_last_att_index :=
4090: sync_attributes
4091: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,
4092: p_bb_id => l_bb_id,
4093: p_last_att_index => l_old_last_att_index
4094: );
4095:

Line 4108: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

4104:
4105: IF l_changed = 'Y' AND p_incremental = 'Y'
4106: THEN
4107: l_old_bb_index := NVL(l_old_bb_index,
4108: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
4109: );
4110:
4111: IF (l_old_bb_index <= g_cnt_t_old_detail_bld_blks)
4112: THEN

Line 4169: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,

4165: p_excep => g_exception_description
4166: );
4167: l_last_att_index :=
4168: sync_attributes
4169: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,
4170: p_bb_id => l_bb_id,
4171: p_last_att_index => l_last_att_index
4172: );
4173: l_old_last_att_index :=

Line 4175: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,

4171: p_last_att_index => l_last_att_index
4172: );
4173: l_old_last_att_index :=
4174: sync_attributes
4175: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,
4176: p_bb_id => l_bb_id,
4177: p_last_att_index => l_old_last_att_index
4178: );
4179:

Line 4191: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

4187:
4188: IF l_changed = 'Y' AND p_incremental = 'Y'
4189: THEN
4190: l_old_bb_index := NVL(l_old_bb_index,
4191: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
4192: );
4193:
4194: IF (l_old_bb_index <= g_cnt_t_old_detail_bld_blks)
4195: THEN

Line 4236: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,

4232: );
4233: --
4234: l_last_att_index :=
4235: sync_attributes
4236: (p_att_table => hxc_generic_retrieval_pkg.t_detail_attributes,
4237: p_bb_id => l_bb_id,
4238: p_last_att_index => l_last_att_index
4239: );
4240: l_old_last_att_index :=

Line 4242: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,

4238: p_last_att_index => l_last_att_index
4239: );
4240: l_old_last_att_index :=
4241: sync_attributes
4242: (p_att_table => hxc_generic_retrieval_pkg.t_old_detail_attributes,
4243: p_bb_id => l_bb_id,
4244: p_last_att_index => l_old_last_att_index
4245: );
4246:

Line 4258: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST

4254:
4255: IF l_changed = 'Y' AND p_incremental = 'Y'
4256: THEN
4257: l_old_bb_index := NVL(l_old_bb_index,
4258: hxc_generic_retrieval_pkg.t_old_detail_bld_blks.FIRST
4259: );
4260:
4261: IF (l_old_bb_index <= g_cnt_t_old_detail_bld_blks)
4262: THEN

Line 4306: hxc_generic_retrieval_pkg.update_transaction_status

4302: -- We need to update the RDB tables for these to older state before
4303: -- update_transaction_status below stamps with the new request.
4304: update_held_retro_batches;
4305: --
4306: hxc_generic_retrieval_pkg.update_transaction_status
4307: (p_process => l_process_name,
4308: p_status => g_status,
4309: p_exception_description => g_exception_description,
4310: p_rollback => FALSE

Line 4401: hxc_generic_retrieval_pkg.update_transaction_status

4397: THEN
4398: --
4399: hxc_generic_retrieval_utils.set_parent_statuses;
4400: --
4401: hxc_generic_retrieval_pkg.update_transaction_status
4402: (p_process => l_process_name,
4403: p_status => g_status,
4404: p_exception_description => g_exception_description,
4405: p_rollback => FALSE

Line 4433: hxc_generic_retrieval_pkg.update_transaction_status

4429: THEN
4430: --
4431: hxc_generic_retrieval_utils.set_parent_statuses;
4432: --
4433: hxc_generic_retrieval_pkg.update_transaction_status
4434: (p_process => l_process_name,
4435: p_status => g_status,
4436: p_exception_description => g_exception_description,
4437: p_rollback => FALSE

Line 4450: hxc_generic_retrieval_pkg.update_transaction_status

4446: AND (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'BOTH')
4447: )
4448: THEN
4449: hxc_generic_retrieval_utils.set_parent_statuses;
4450: hxc_generic_retrieval_pkg.update_transaction_status
4451: (p_process => l_process_name,
4452: p_status => 'ERRORS',
4453: p_exception_description => g_exception_description,
4454: p_rollback => FALSE

Line 4467: hxc_generic_retrieval_pkg.update_transaction_status

4463: ELSIF (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'OTLR')
4464: THEN
4465: hxc_generic_retrieval_utils.set_parent_statuses;
4466: --
4467: hxc_generic_retrieval_pkg.update_transaction_status
4468: (p_process => l_process_name,
4469: p_status => 'ERRORS',
4470: p_exception_description => g_exception_description,
4471: p_rollback => FALSE