DBA Data[Home] [Help]

APPS.PER_HRWF_SYNCH dependencies on PER_HRWF_SYNCH

Line 1: PACKAGE BODY PER_HRWF_SYNCH AS

1: PACKAGE BODY PER_HRWF_SYNCH AS
2: /* $Header: perhrwfs.pkb 120.6.12020000.6 2013/05/24 06:50:04 pathota ship $ */
3: --
4: g_package varchar2(30) := 'per_hrwf_synch.';
5: g_count number := 0;

Line 4: g_package varchar2(30) := 'per_hrwf_synch.';

1: PACKAGE BODY PER_HRWF_SYNCH AS
2: /* $Header: perhrwfs.pkb 120.6.12020000.6 2013/05/24 06:50:04 pathota ship $ */
3: --
4: g_package varchar2(30) := 'per_hrwf_synch.';
5: g_count number := 0;
6: --
7: --
8: -- ----------------------------------------------------------------------------

Line 166: PER_HRWF_SYNCH.per_per_wf(p_rec => l_person_rec,

162: close l_person_cur;
163: --
164: hr_utility.set_location('Before call to person routine '||l_proc,40);
165: --
166: PER_HRWF_SYNCH.per_per_wf(p_rec => l_person_rec,
167: p_action => null);
168: hr_utility.set_location('After call to person routine '||l_proc,45);
169: --
170: end if; -- l_entity = 'PERSON'

Line 186: PER_HRWF_SYNCH.per_pds_wf(p_rec => l_pds_rec,

182: close l_pds_cur;
183:
184: hr_utility.set_location('Before call to pds routine '||l_proc,47);
185:
186: PER_HRWF_SYNCH.per_pds_wf(p_rec => l_pds_rec,
187: p_date => l_pds_rec.actual_termination_date,
188: p_action => 'TERMINATION');
189:
190: end if;

Line 210: PER_HRWF_SYNCH.per_asg_wf(p_rec => l_assignment_rec,

206: hr_utility.set_location('Before call to Assignment routine '||l_proc,35);
207: --
208: --call the routine
209: --
210: PER_HRWF_SYNCH.per_asg_wf(p_rec => l_assignment_rec,
211: p_action => null);
212: hr_utility.set_location('After call to Assignment routine '||l_proc,35);
213: --
214: end if; --l_entity = 'POSITION'

Line 365: hr_utility.set_location('PER_HRWF_SYNCH.per_per_wf - l_check_person_id'||p_rec.person_id,70);

361: p_origSystemID =>p_rec.person_id );
362:
363: open per_role_role_exists (p_rec.person_id);
364: fetch per_role_role_exists into l_per_role;
365: hr_utility.set_location('PER_HRWF_SYNCH.per_per_wf - l_check_person_id'||p_rec.person_id,70);
366: if per_role_role_exists%notfound then
367: l_per_role := 'PER_ROLE:'||p_rec.person_id;
368: end if;
369: close per_role_role_exists;

Line 387: l_date_chk := PER_HRWF_SYNCH.chk_date_status(

383: return;
384: --
385: end if;
386: --
387: l_date_chk := PER_HRWF_SYNCH.chk_date_status(
388: p_rec.effective_start_date,
389: p_rec.effective_end_date);
390: --
391: -- If the transaction is in CURRENT time frame

Line 561: wf_util.call_me_later(p_callback => 'per_hrwf_synch.call_back',

557: --
558: hr_utility.set_location('Before calling call_me_later '||l_proc,50);
559: -- Call the routine wf_util.call_me_later ()
560: --
561: wf_util.call_me_later(p_callback => 'per_hrwf_synch.call_back',
562: p_when => trunc(p_rec.effective_start_date),
563: p_parameters => l_parameters);
564: --
565: end if;

Line 658: l_date_chk := PER_HRWF_SYNCH.chk_date_status(

654: return;
655: --
656: end if;
657: --
658: l_date_chk := PER_HRWF_SYNCH.chk_date_status(
659: p_rec.effective_start_date,
660: p_rec.effective_end_date);
661: --
662: -- If the transaction is in CURRENT time frame

Line 734: WF_UTIL.call_me_later(p_callback => 'PER_HRWF_SYNCH.call_back',

730:
731: -- Call the routine wf_util.call_me_later ()
732: --
733: hr_utility.set_location('Calling WF routine call_me_later.... ',45);
734: WF_UTIL.call_me_later(p_callback => 'PER_HRWF_SYNCH.call_back',
735: p_when => trunc(p_rec.effective_start_date),
736: p_parameters => l_parameters);
737: --
738: end if;

Line 901: wf_util.call_me_later(p_callback => 'per_hrwf_synch.call_back',

897: hr_utility.set_location('Before calling call_me_later for PER_ROLE '||l_proc,50);
898: hr_utility.set_location('Before calling later:trunc(p_rec.actual_termination_date+1)='||trunc(p_rec.actual_termination_date+1)||l_proc,50);
899:
900:
901: wf_util.call_me_later(p_callback => 'per_hrwf_synch.call_back',
902: p_when => trunc(p_rec.actual_termination_date+1),
903: p_parameters => l_parameters);
904:
905: End if;

Line 1004: l_proc varchar2(200) := 'per_hrwf_synch.synch_user_pos_role.';

1000: l_filter_loop_iter number :=0;
1001: l_filter_row_count number :=0;
1002: j number :=0;
1003:
1004: l_proc varchar2(200) := 'per_hrwf_synch.synch_user_pos_role.';
1005: Cursor Csr_assignment_data (p_in_person_id in number,p_in_start_date in date,p_in_exp_date in date)
1006: is
1007: Select *
1008: from per_all_assignments_f paaf

Line 1084: end per_hrwf_synch;

1080: --dbms_output.put_line(sqlerrm);
1081: raise;
1082: end sych_user_pos_role;
1083: ----------
1084: end per_hrwf_synch;