[Home] [Help]
443:
444: hr_utility.set_location('geocode_action_creation',4);
445: select pay_assignment_actions_s.nextval
446: into lockingactid
447: from dual;
448:
449: -- insert the action record.
450:
451: hr_nonrun_asact.insact(lockingactid => lockingactid,
493:
494: hr_utility.set_location('gocode_action_creation',7);
495: select pay_assignment_actions_s.nextval
496: into lockingactid
497: from dual;
498: --
499: /*Bug#7240914: if lv_no_of_chunks < 1 then assign all to chunk 1
500: else use the iterator lv_count to distribute records among
501: all chunks. */
503: lv_curr_chunk := 1 ;
504: ELSE
505: select decode (mod(lv_count,lv_no_of_chunks),0,lv_no_of_chunks,mod(lv_count,lv_no_of_chunks))
506: into lv_curr_chunk
507: from dual;
508: END IF;
509:
510: hr_utility.trace( 'lv_count: ' || to_char(lv_count));
511: hr_utility.trace( 'lv_current_chunk: ' || to_char(lv_curr_chunk));
673:
674: -- Bug 3354053 -- Changed the cursor query to remove the FTS from pay_us_geo_update.
675: Cursor c_geo_upd (p_patch_id in number,
676: p_patch_status in varchar2) is
677: select 'x' from dual
678: where exists(select 'x' from pay_us_geo_update
679: where id = p_patch_id
680: and status = p_patch_status
681: and rownum < 2);
3012: BEGIN
3013:
3014: SELECT 'Y'
3015: INTO lv_update_prr
3016: FROM dual
3017: WHERE EXISTS (SELECT 0
3018: FROM pay_us_city_tax_info_f
3019: WHERE jurisdiction_code = main_old_juri_code)
3020: OR EXISTS (SELECT 0
4840: -- Bug 3319878 -- Changed the query to remove FTS from PAY_US_GEO_UPDATE
4841:
4842: CURSOR chk_last_api(p_geo_phase_id NUMBER, p_mode VARCHAR2) IS
4843: SELECT 'Y'
4844: FROM dual
4845: WHERE exists (SELECT /*+index(pugu PAY_US_GEO_UPDATE_N2) */ 'Y'
4846: FROM PAY_US_GEO_UPDATE pugu
4847: WHERE pugu.id = p_geo_phase_id
4848: AND pugu.process_mode = p_mode