[Home] [Help]
6: -- Constants for fragment view
7: c_for_fragment CONSTANT VARCHAR2(8) := 'FRAGMENT';
8: c_for_approver CONSTANT VARCHAR2(8) := 'APPROVER';
9:
10: g_debug boolean := hr_utility.debug_enabled;
11:
12: -- Types created for the Zero Hrs Template Enhancement.
13:
14: TYPE v_att_ids IS RECORD (
628:
629: -- DBMS_PROFILER.START_PROFILER('Kunal');
630: IF g_debug THEN
631: l_proc := 'modify_to_zero_hrs_template';
632: hr_utility.set_location (g_package || l_proc, 120);
633: END IF;
634: -- Get the range calculated
635: l_first_day := fnd_date.canonical_to_date (p_start_time);
636: --
762: l_det_att_index := l_detail_attributes.LAST +1;
763:
764:
765: /* IF g_debug THEN
766: hr_utility.trace('| '||p_attribute_array (l_index).BUILDING_BLOCK_ID||' | '||p_attribute_array (l_index).TIME_ATTRIBUTE_ID||' | '||p_attribute_array (l_index).ATTRIBUTE_CATEGORY);
767: END IF;
768: */
769: END IF; -- attribute BB_ID = Time BB_ID
770: l_index := p_attribute_array.NEXT (l_index);
770: l_index := p_attribute_array.NEXT (l_index);
771: END LOOP; -- l_index IS NOT NULL
772:
773: /* IF g_debug THEN
774: hr_utility.trace(p_block_array(l_index_detail).time_building_block_id||' | '||l_detail_attributes.COUNT);
775: END IF;
776: */
777: -- Here we have a list of all attributes for the main DETAIL id.
778: -- Now loop thru the rest of the DETAILS to find other DETAILS
826: END LOOP; -- l_index IS NOT NULL
827:
828: -- Just a check to see all is well
829: /* IF g_debug THEN
830: hr_utility.trace(p_block_array(l_index_detail).time_building_block_id||' | '||l_detail_attributes.COUNT||' | '||p_block_array(l_sub_index_detail).time_building_block_id||' | '||l_detail_sub_attributes.COUNT);
831: END IF;
832: */
833:
834:
843: THEN
844: --
845: -- Just a check to see all is well
846: /* IF g_debug THEN
847: hr_utility.trace(p_block_array(l_index_detail).time_building_block_id||' | '||l_detail_attributes.COUNT||' | '||p_block_array(l_sub_index_detail).time_building_block_id||' | '||l_detail_sub_attributes.COUNT);
848: END IF;
849: */
850: -- OK, here we go, Start the Comparison here
851: l_det_sub_att_index := null;
969: THEN
970:
971: -- Check to see if the correct TBB is obtained
972: /* IF g_debug THEN
973: hr_utility.trace(p_block_array(l_index_detail).time_building_block_id||' | '||p_block_array(l_sub_index_detail).time_building_block_id||' | ');
974: END IF;
975: */
976: -- First add the TBB ID to the temp table
977: -- that will be used later to clear the attributes
1979:
1980:
1981: IF g_debug THEN
1982: l_proc := 'chk_all_days_in_block';
1983: hr_utility.set_location (g_package || l_proc, 120);
1984: END IF;
1985: -- Get the range calculated
1986: l_new_start_time := fnd_date.canonical_to_date (p_start_time);
1987: l_new_stop_time := fnd_date.canonical_to_date (p_stop_time);
2155:
2156:
2157: IF g_debug THEN
2158: l_proc := 'append_blocks';
2159: hr_utility.set_location ( g_package||l_proc, 300);
2160: END IF;
2161:
2162: l_new_blocks := p_new_blocks;
2163: l_new_attributes := p_new_attributes;
2166: -- blocks and attributes and return them
2167: IF p_block_array.count = 0
2168: THEN
2169: IF g_debug THEN
2170: hr_utility.set_location ( g_package||l_proc, 310);
2171: END IF;
2172:
2173: assign_block_ids(
2174: p_start_id => -2
2176: ,p_attributes => l_new_attributes
2177: );
2178:
2179: IF g_debug THEN
2180: hr_utility.set_location ( g_package||l_proc, 320);
2181: END IF;
2182:
2183: assign_attribute_ids(
2184: p_start_id => -2
2185: ,p_attributes => l_new_attributes
2186: );
2187:
2188: IF g_debug THEN
2189: hr_utility.set_location ( g_package||l_proc, 330);
2190: END IF;
2191:
2192:
2193: p_block_array := l_new_blocks;
2215: --
2216: IF p_overwrite = 'Y'
2217: THEN
2218: IF g_debug THEN
2219: hr_utility.set_location ( g_package||l_proc, 340);
2220: END IF;
2221:
2222: --end date all the existing blocks
2223: l_block_index := l_complete_blocks.first;
2229: l_block_index := l_complete_blocks.next(l_block_index);
2230: END LOOP;
2231:
2232: IF g_debug THEN
2233: hr_utility.set_location ( g_package||l_proc, 350);
2234: END IF;
2235:
2236: -- append new blocks
2237: -- before we append new blocks, we need to assign new ids to new blocks
2242: ,p_attributes => l_new_attributes
2243: );
2244:
2245: IF g_debug THEN
2246: hr_utility.set_location ( g_package||l_proc, 360);
2247: END IF;
2248:
2249: l_block_index := l_complete_blocks.last + 1;
2250: l_new_block_index := l_new_blocks.first;
2258: l_new_block_index := l_new_blocks.next(l_new_block_index);
2259: END LOOP;
2260:
2261: IF g_debug THEN
2262: hr_utility.set_location ( g_package||l_proc, 370);
2263: END IF;
2264:
2265: l_new_attribute_id := get_next_attribute_id(
2266: p_attributes => p_attribute_array
2353: l_new_attribute_id := get_next_attribute_id(
2354: p_attributes => l_complete_attributes
2355: );
2356: IF g_debug THEN
2357: hr_utility.set_location ( g_package||l_proc, 380);
2358: END IF;
2359:
2360: l_complete_block_count := l_complete_blocks.last + 1;
2361: l_complete_attribute_count := l_complete_attributes.last + 1;
2379: ,p_found => l_found
2380: );
2381:
2382: IF g_debug THEN
2383: hr_utility.set_location ( g_package||l_proc, 390);
2384: END IF;
2385:
2386: -- append comment to corrresponding block
2387: -- attach attributes to corrresponding block
2387: -- attach attributes to corrresponding block
2388: IF l_found
2389: THEN
2390: IF g_debug THEN
2391: hr_utility.set_location ( g_package||l_proc, 400);
2392: END IF;
2393:
2394: --append comments
2395: IF l_new_blocks_array(l_new_block_index).COMMENT_TEXT IS NOT NULL
2406: END IF;
2407: END IF;
2408:
2409: IF g_debug THEN
2410: hr_utility.set_location ( g_package||l_proc, 410);
2411: END IF;
2412:
2413: --append attributes
2414: l_attribute_index := l_new_attributes.first;
2464: l_attribute_index := l_new_attributes.next(l_attribute_index);
2465: END LOOP;
2466:
2467: IF g_debug THEN
2468: hr_utility.set_location ( g_package||l_proc, 420);
2469: END IF;
2470:
2471: IF l_new_blocks_array(l_new_block_index).SCOPE = 'DAY'
2472: THEN
2531: l_new_block_index := l_new_blocks_array.next(l_new_block_index);
2532: END LOOP;
2533:
2534: IF g_debug THEN
2535: hr_utility.set_location ( g_package||l_proc, 430);
2536: END IF;
2537:
2538: p_block_array := l_complete_blocks;
2539:
2557:
2558:
2559: IF g_debug THEN
2560: l_proc := 'attributes_to_array';
2561: hr_utility.set_location ( g_package||l_proc, 10);
2562: END IF;
2563:
2564: --initialize attribute array
2565: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
2617: l_attribute_index := p_attributes.next(l_attribute_index);
2618: END LOOP;
2619:
2620: IF g_debug THEN
2621: hr_utility.set_location ( g_package||l_proc, 20);
2622: END IF;
2623: RETURN l_attribute_array;
2624: END attributes_to_array;
2625: */
2640:
2641:
2642: IF g_debug THEN
2643: l_proc := 'blocks_to_array';
2644: hr_utility.set_location ( g_package||l_proc, 10);
2645: END IF;
2646:
2647: l_block_array := HXC_BLOCK_TABLE_TYPE();
2648:
2680: l_block_index := p_blocks.next(l_block_index);
2681: END LOOP;
2682:
2683: IF g_debug THEN
2684: hr_utility.set_location ( g_package||l_proc, 140);
2685: END IF;
2686: RETURN l_block_array;
2687: END blocks_to_array;
2688: */
2727: begin
2728:
2729:
2730: IF g_debug THEN
2731: hr_utility.trace ('p_template_procedure='||p_template_procedure);
2732: END IF;
2733: hxc_timecard_message_helper.initializeErrors;
2734:
2735: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2742: ||',p_messages => :6);'||fnd_global.newline
2743: ||'END;';
2744:
2745: IF g_debug THEN
2746: hr_utility.trace ('l_dyn_template_sql='||l_dyn_template_sql);
2747: END IF;
2748:
2749:
2750: EXECUTE IMMEDIATE l_dyn_template_sql
2884:
2885: l_remove_redundant_entries := FALSE;
2886: IF g_debug THEN
2887: l_proc := 'get_blocks_from_template';
2888: hr_utility.set_location ( g_package||l_proc, 120);
2889: END IF;
2890: l_template_type := SUBSTR(p_template_code, 1, INSTR(p_template_code, '|') - 1);
2891: get_template_info(
2892: p_template_code => p_template_code
2894: ,p_template_action => l_template_action
2895: );
2896:
2897: IF g_debug THEN
2898: hr_utility.set_location ( g_package||l_proc, 130);
2899: END IF;
2900:
2901: IF l_template_action = 'INVALID'
2902: THEN
2911: IF l_template_handle = 'WORK_SCHEDULE'
2912: THEN
2913:
2914: IF g_debug THEN
2915: hr_utility.set_location ( g_package||l_proc, 140);
2916: END IF;
2917:
2918: HXT_TIMECARD_INFO.GENERATE_TIME(
2919: p_resource_id => TO_NUMBER(p_resource_id)
2939: END IF;
2940:
2941: ELSE
2942: IF g_debug THEN
2943: hr_utility.set_location ( g_package||l_proc, 150);
2944: END IF;
2945:
2946: -- find the corresponding dynamic template function for the
2947: -- specific application
2987: l_message_string,
2988: p_messages);
2989:
2990: IF g_debug THEN
2991: hr_utility.set_location ( g_package||l_proc, 160);
2992: END IF;
2993:
2994: OPEN c_retrieval_process(
2995: p_dyn_template_process => l_template_procedure
3006: CLOSE c_retrieval_process;
3007: END IF;
3008:
3009: IF g_debug THEN
3010: hr_utility.set_location ( g_package||l_proc, 170);
3011: END IF;
3012:
3013: l_temp_blocks := hxc_deposit_wrapper_utilities.string_to_blocks(
3014: p_block_string => l_block_string
3022:
3023: END IF;
3024:
3025: IF g_debug THEN
3026: hr_utility.set_location ( g_package||l_proc, 180);
3027: END IF;
3028:
3029: --now we need to update the returned block info
3030: l_blocks := hxc_deposit_wrapper_utilities.blocks_to_array(p_blocks => l_temp_blocks);
3043: RETURN;
3044: END IF;
3045:
3046: IF g_debug THEN
3047: hr_utility.trace('block count=' || l_blocks.count);
3048: hr_utility.set_location ( g_package||l_proc, 190);
3049: END IF;
3050:
3051: -- update the returned apps attributes and convert them to block attributes
3044: END IF;
3045:
3046: IF g_debug THEN
3047: hr_utility.trace('block count=' || l_blocks.count);
3048: hr_utility.set_location ( g_package||l_proc, 190);
3049: END IF;
3050:
3051: -- update the returned apps attributes and convert them to block attributes
3052: l_attributes := app_to_block_attributes(
3057: ,p_template_type => l_template_handle
3058: );
3059:
3060: IF g_debug THEN
3061: hr_utility.set_location ( g_package||l_proc, 200);
3062: END IF;
3063:
3064: append_blocks(
3065: p_block_array => p_block_array
3075: ,p_remove_redundant_entries => FALSE
3076: );
3077:
3078: IF g_debug THEN
3079: hr_utility.set_location ( g_package||l_proc, 210);
3080: END IF;
3081:
3082: p_message_string := l_message_string;
3083: RETURN;
3087: -- need to work out the last time card
3088: IF l_template_action = 'SYS' AND l_template_handle = 'LAST_TIMECARD'
3089: THEN
3090: IF g_debug THEN
3091: hr_utility.set_location ( g_package||l_proc, 220);
3092: END IF;
3093:
3094: OPEN c_last_timecard(
3095: p_resource_id => TO_NUMBER(p_resource_id)
3133: l_block_array_idx := p_block_array.next(l_block_array_idx);
3134: End Loop;
3135:
3136: IF g_debug THEN
3137: hr_utility.set_location ( g_package||l_proc, 230);
3138: END IF;
3139:
3140: -- we need to retrieve the template from time building blocks table
3141: IF l_template_action = 'STATIC'
3181: l_template_display_key := false;
3182: end if;
3183:
3184: IF g_debug THEN
3185: hr_utility.set_location ( g_package||l_proc, 246);
3186: END IF;
3187:
3188: IF l_template_action = 'LAST_TIMECARD'
3189: THEN
3277: END IF;
3278: END LOOP;
3279:
3280: IF g_debug THEN
3281: hr_utility.set_location ( g_package||l_proc, 250);
3282: END IF;
3283:
3284: if((l_blocks.COUNT > 0) AND (l_template_action = 'SYS' AND l_template_handle = 'LAST_TIMECARD'))
3285: then
3325: ,p_remove_redundant_entries =>l_remove_redundant_entries
3326: );
3327:
3328: IF g_debug THEN
3329: hr_utility.set_location ( g_package||l_proc, 260);
3330: END IF;
3331: --
3332: -- If the timecard, or the template are missing the display keys
3333: -- we must permit the timecard to dynamically allocate the row
3343: End Loop;
3344: end if;
3345:
3346: IF g_debug THEN
3347: hr_utility.set_location ( g_package||l_proc, 270);
3348: END IF;
3349:
3350: p_message_string := NULL;
3351:
3583: END IF;
3584:
3585: IF g_debug THEN
3586: l_proc := 'translate_alias_timecards';
3587: hr_utility.set_location ( g_package||l_proc, 20);
3588: END IF;
3589:
3590: HXC_ALIAS_TRANSLATOR.do_retrieval_translation(
3591: p_attributes => p_attribute_array
3596: ,p_messages => l_messages_table
3597: );
3598:
3599: IF g_debug THEN
3600: hr_utility.set_location ( g_package||l_proc, 30);
3601: END IF;
3602:
3603: END translate_alias_timecards;
3604:
4341:
4342: CLOSE c_timecard_block;
4343:
4344: IF g_debug THEN
4345: hr_utility.trace('found timecard');
4346: END IF;
4347:
4348: IF trunc(l_blocks(l_block_index).START_TIME) = trunc(l_app_period.start_time)
4349: AND trunc(l_blocks(l_block_index).STOP_TIME) = trunc(l_app_period.stop_time) THEN
4700:
4701: l_resp_id NUMBER;
4702: l_resp_appl_id NUMBER;
4703: BEGIN
4704: g_debug := hr_utility.debug_enabled;
4705:
4706: IF g_debug THEN
4707: l_proc := 'fetch_blocks_and_attributes';
4708: hr_utility.set_location (g_package||l_proc, 20);
4704: g_debug := hr_utility.debug_enabled;
4705:
4706: IF g_debug THEN
4707: l_proc := 'fetch_blocks_and_attributes';
4708: hr_utility.set_location (g_package||l_proc, 20);
4709: END IF;
4710:
4711: --if(p_timecard_action <> 'Template') then
4712: if(p_timecard_action NOT IN ('Template','Export')) then
4745: );
4746: END IF;
4747:
4748: IF g_debug THEN
4749: hr_utility.set_location ( g_package||l_proc, 20);
4750: END IF;
4751:
4752: IF p_timecard_id IS NOT NULL
4753: AND is_app_period(TO_NUMBER(p_timecard_id))
4788: ,p_messages => p_messages
4789: );
4790:
4791: IF g_debug THEN
4792: hr_utility.set_location ( g_package||l_proc, 30);
4793: END IF;
4794:
4795: p_message_string := l_message_string;
4796:
4826: RETURN;
4827: END IF;
4828:
4829: IF g_debug THEN
4830: hr_utility.set_location ( g_package||l_proc, 40);
4831:
4832: hr_utility.trace(' p_resource_id=' || p_resource_id);
4833: hr_utility.trace('p_resource_type=' || p_resource_type);
4834: hr_utility.trace('p_start_time=' || p_start_time);
4828:
4829: IF g_debug THEN
4830: hr_utility.set_location ( g_package||l_proc, 40);
4831:
4832: hr_utility.trace(' p_resource_id=' || p_resource_id);
4833: hr_utility.trace('p_resource_type=' || p_resource_type);
4834: hr_utility.trace('p_start_time=' || p_start_time);
4835: hr_utility.trace('p_stop_time=' || p_stop_time);
4836: hr_utility.trace('p_timecard_id=' || p_timecard_id);
4829: IF g_debug THEN
4830: hr_utility.set_location ( g_package||l_proc, 40);
4831:
4832: hr_utility.trace(' p_resource_id=' || p_resource_id);
4833: hr_utility.trace('p_resource_type=' || p_resource_type);
4834: hr_utility.trace('p_start_time=' || p_start_time);
4835: hr_utility.trace('p_stop_time=' || p_stop_time);
4836: hr_utility.trace('p_timecard_id=' || p_timecard_id);
4837: END IF;
4830: hr_utility.set_location ( g_package||l_proc, 40);
4831:
4832: hr_utility.trace(' p_resource_id=' || p_resource_id);
4833: hr_utility.trace('p_resource_type=' || p_resource_type);
4834: hr_utility.trace('p_start_time=' || p_start_time);
4835: hr_utility.trace('p_stop_time=' || p_stop_time);
4836: hr_utility.trace('p_timecard_id=' || p_timecard_id);
4837: END IF;
4838:
4831:
4832: hr_utility.trace(' p_resource_id=' || p_resource_id);
4833: hr_utility.trace('p_resource_type=' || p_resource_type);
4834: hr_utility.trace('p_start_time=' || p_start_time);
4835: hr_utility.trace('p_stop_time=' || p_stop_time);
4836: hr_utility.trace('p_timecard_id=' || p_timecard_id);
4837: END IF;
4838:
4839: --(3)retrieve an existing timecard
4832: hr_utility.trace(' p_resource_id=' || p_resource_id);
4833: hr_utility.trace('p_resource_type=' || p_resource_type);
4834: hr_utility.trace('p_start_time=' || p_start_time);
4835: hr_utility.trace('p_stop_time=' || p_stop_time);
4836: hr_utility.trace('p_timecard_id=' || p_timecard_id);
4837: END IF;
4838:
4839: --(3)retrieve an existing timecard
4840: -- Make sure we replace the display key
4883: End Loop;
4884: end if;
4885:
4886: IF g_debug THEN
4887: hr_utility.set_location ( g_package||l_proc, 50);
4888: END IF;
4889:
4890: -- if there is an existing timecard, return the info in string
4891: IF p_block_array is not null THEN
4897: );
4898: end if;
4899:
4900: IF g_debug THEN
4901: hr_utility.set_location ( g_package||l_proc, 60);
4902: END IF;
4903:
4904: -- call translator alias package
4905: translate_alias_timecards(
4929: END IF;
4930:
4931:
4932: IF g_debug THEN
4933: hr_utility.trace('app period jxtan');
4934: END IF;
4935: --(4) there is no existing timecard, check if this period
4936: -- corresponds to an application period
4937: -- this part is here so that the url we created for
4993: );
4994: END IF;
4995:
4996: IF g_debug THEN
4997: hr_utility.set_location ( g_package||l_proc, 100);
4998: END IF;
4999:
5000: IF l_template_code IS NOT NULL
5001: THEN
5013: ,p_messages => p_messages
5014: );
5015:
5016: IF g_debug THEN
5017: hr_utility.set_location ( g_package||l_proc, 110);
5018: END IF;
5019:
5020: p_message_string := l_message_string;
5021:
5242: AND htr.time_recipient_id = hrp.time_recipient_id;
5243:
5244: BEGIN
5245:
5246: g_debug := hr_utility.debug_enabled;
5247:
5248: get_template_info(
5249: p_template_code => p_template_code
5250: ,p_template_handle => l_template_handle
5252: );
5253:
5254: IF g_debug THEN
5255: l_proc := 'get_blocks_from_template';
5256: hr_utility.set_location ( g_package||l_template_action, 130);
5257: END IF;
5258:
5259:
5260: IF l_template_action = 'APP'
5265: IF l_template_handle = 'WORK_SCHEDULE'
5266: THEN
5267:
5268: IF g_debug THEN
5269: hr_utility.set_location ( g_package||l_proc, 140);
5270: END IF;
5271:
5272: HXT_TIMECARD_INFO.GENERATE_TIME(
5273: p_resource_id => TO_NUMBER(p_resource_id)
5301:
5302: FETCH c_dyn_template_procedure INTO l_template_procedure;
5303:
5304: IF g_debug THEN
5305: hr_utility.set_location ( 'PJRM=='||l_template_procedure, 150);
5306: END IF;
5307:
5308: IF c_dyn_template_procedure%NOTFOUND
5309: THEN
5314:
5315: CLOSE c_dyn_template_procedure;
5316:
5317: IF g_debug THEN
5318: hr_utility.set_location ( 'calling get_dynamic_templates_info==', 160);
5319: END IF;
5320: get_dynamic_templates_info
5321: ( l_template_procedure,
5322: l_tp_resource_id,
5327: l_message_string,
5328: p_messages);
5329:
5330: IF g_debug THEN
5331: hr_utility.set_location ( 'completed get_dynamic_templates_info=='||p_messages.count, 170);
5332: END IF;
5333:
5334: OPEN c_retrieval_process(
5335: p_dyn_template_process => l_template_procedure
5452: INTO bb_id_tab,
5453: bb_ovn_tab;
5454: CLOSE c_get_latest_timecard_details;
5455:
5456: hr_utility.trace('Detail Building Blocks Count :' || bb_id_tab.COUNT);
5457:
5458:
5459:
5460: ------------------------------ check whether data has transfer or not------------------------------
5464: LOOP
5465: EXIT
5466: WHEN NOT bb_id_tab.EXISTS(l_index);
5467:
5468: hr_utility.trace(bb_id_tab(l_index) || '-' || bb_ovn_tab(l_index));
5469:
5470: OPEN c_get_transaction_id(bb_id_tab(l_index), bb_ovn_tab(l_index));
5471: FETCH c_get_transaction_id bulk collect
5472: INTO l_transaction_id_tab,l_transaction_process_id_tab;
5491: IF l_transaction_id_tab IS NOT NULL THEN
5492:
5493: IF g_debug
5494: THEN
5495: hr_utility.trace('l_transfer_to : YET TO DECIDE');
5496: hr_utility.trace('Transaction Ids Count :' || l_transaction_id_tab.COUNT);
5497: hr_utility.trace('l_transfer_to :' || l_transfer_to);
5498: END IF;
5499:
5492:
5493: IF g_debug
5494: THEN
5495: hr_utility.trace('l_transfer_to : YET TO DECIDE');
5496: hr_utility.trace('Transaction Ids Count :' || l_transaction_id_tab.COUNT);
5497: hr_utility.trace('l_transfer_to :' || l_transfer_to);
5498: END IF;
5499:
5500: l_index := l_transaction_id_tab.FIRST;
5493: IF g_debug
5494: THEN
5495: hr_utility.trace('l_transfer_to : YET TO DECIDE');
5496: hr_utility.trace('Transaction Ids Count :' || l_transaction_id_tab.COUNT);
5497: hr_utility.trace('l_transfer_to :' || l_transfer_to);
5498: END IF;
5499:
5500: l_index := l_transaction_id_tab.FIRST;
5501:
5501:
5502: LOOP
5503: EXIT
5504: WHEN NOT l_transaction_id_tab.EXISTS(l_index);
5505: hr_utility.trace('l_transaction_id_tab('||l_index||'):'||l_transaction_id_tab(l_index)
5506: ||'-'||'l_transaction_process_id_tab('||l_index||'):'||l_transaction_process_id_tab(l_index));
5507:
5508: IF l_transaction_process_id_tab(l_index) = -1 THEN
5509: SELECT retrieval_process_id
5527: WHERE retrieval_process_id = l_transaction_process_id_tab(l_index));
5528:
5529:
5530:
5531: hr_utility.trace('l_time_recipient_name :' || l_time_recipient_name);
5532:
5533: IF l_transfer_to = 'None' AND l_time_recipient_name IS NOT NULL THEN
5534: l_transfer_to := l_time_recipient_name;
5535: ELSIF instrb(l_transfer_to, l_time_recipient_name) = 0 THEN
5543: END IF; -- IF l_transaction_id IS NOT NULL THEN
5544:
5545: ------------------------------- pass the transfer_to data to TcActivitiesPG .------------------
5546:
5547: hr_utility.trace('l_transfer_to :' || l_transfer_to);
5548: hr_utility.trace('end');
5549:
5550:
5551: RETURN l_transfer_to;
5544:
5545: ------------------------------- pass the transfer_to data to TcActivitiesPG .------------------
5546:
5547: hr_utility.trace('l_transfer_to :' || l_transfer_to);
5548: hr_utility.trace('end');
5549:
5550:
5551: RETURN l_transfer_to;
5552: