APPS.HR_FULL_SYNC_MESSAGES dependencies on HR_PSFT_SYNC_RUN

Line 73: /*Common procedure to update the hr_psft_sync_run table begins here*/

69:
70: Jobcodefulltype JobCodeTblType;
71: Jobcodedeltatype JobCodeTblType;
72:
73: /*Common procedure to update the hr_psft_sync_run table begins here*/
74: PROCEDURE update_psft_sync_run
75: (p_status number
76: ,p_process_name varchar2
77: ,p_run_date date

Line 93: update hr_psft_sync_run

89: elsif p_status = 3 then
90: l_status := 'ERROR';
91: end if;
92:
93: update hr_psft_sync_run
94: set status = l_status
95: where process = p_process_name
96: and run_date = p_run_date;
97: commit;

Line 109: /*Common procedure to update the hr_psft_sync_run table ends here*/

105: FND_FILE.NEW_LINE(FND_FILE.log, 1);
106: FND_FILE.put_line(fnd_file.log,'Error Msg: '||substr(SQLERRM,1,700));
107:
108: END update_psft_sync_run;
109: /*Common procedure to update the hr_psft_sync_run table ends here*/
110:
111: /*Common procedure to insert into hr_psft_sync_run table begins here*/
112:
113: PROCEDURE insert_psft_sync_run

Line 111: /*Common procedure to insert into hr_psft_sync_run table begins here*/

107:
108: END update_psft_sync_run;
109: /*Common procedure to update the hr_psft_sync_run table ends here*/
110:
111: /*Common procedure to insert into hr_psft_sync_run table begins here*/
112:
113: PROCEDURE insert_psft_sync_run
114: (p_status number
115: ,p_process_name varchar2

Line 132: INSERT INTO hr_psft_sync_run(run_date,status,process)

128: elsif p_status = 3 then
129: l_status := 'ERROR';
130: end if;
131:
132: INSERT INTO hr_psft_sync_run(run_date,status,process)
133: Values(sysdate,l_status,p_process_name);
134: commit;
135:
136: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 169: from hr_psft_sync_run

165: order by ft.territory_code;
166:
167: cursor fet_psft_sync is
168: select count('x')
169: from hr_psft_sync_run
170: where process = 'STATE_FULL_SYNC'
171: and run_date < p_effective_date
172: and status = 'STARTED';
173:

Line 238: from hr_psft_sync_run

234: order by ft.territory_code;
235:
236: cursor fet_psft_sync is
237: select count('x')
238: from hr_psft_sync_run
239: where process = 'COUNTRY_FULL_SYNC'
240: and run_date < p_effective_date
241: and status = 'STARTED';
242:

Line 357: from hr_psft_sync_run

353:
354:
355: cursor fet_psft_sync is
356: select count('x')
357: from hr_psft_sync_run
358: where process = 'LOC_FULL_SYNC'
359: and run_date < p_effective_date
360: and status = 'STARTED';
361:

Line 566: from hr_psft_sync_run

562:
563:
564: cursor csr_psft_sync is
565: select COUNT ('1')
566: from hr_psft_sync_run
567: where process = 'PERSON_FULL_SYNC'
568: and run_date > sysdate
569: and status = 'STARTED';
570:

Line 644: from hr_psft_sync_run

640: l_current_date date default sysdate;
641:
642: cursor fet_psft_sync is
643: select count('x')
644: from hr_psft_sync_run
645: where process = 'JOBCODE_FULL_SYNC'
646: and run_date < p_eff_date
647: and status = 'STARTED';
648:

Line 740: from hr_psft_sync_run

736: l_current_date date default sysdate;
737:
738: cursor fet_psft_sync is
739: select count('x')
740: from hr_psft_sync_run
741: where process = 'WORKFORCE_FULL_SYNC'
742: and run_date < p_eff_date
743: and status = 'STARTED';
744: l_dummy number;

Line 911: from hr_psft_sync_run

907:
908:
909: cursor fet_psft_sync is
910: select count('x')
911: from hr_psft_sync_run
912: where process = 'ORG_FULL_SYNC'
913: and run_date < p_effective_date
914: and status = 'STARTED';
915:

Line 985: from hr_psft_sync_run

981:
982:
983: cursor fet_psft_sync is
984: select count('x')
985: from hr_psft_sync_run
986: where process = 'BG_FULL_SYNC'
987: and run_date < p_effective_date
988: and status = 'STARTED';
989:

Line 1060: from hr_psft_sync_run

1056:
1057:
1058: cursor fet_psft_sync is
1059: select count('x')
1060: from hr_psft_sync_run
1061: where process = 'PYRL_FULL_SYNC'
1062: and run_date < p_effective_date
1063: and status = 'STARTED';
1064: