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 356: from hr_psft_sync_run

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

Line 565: from hr_psft_sync_run

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

Line 643: from hr_psft_sync_run

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

Line 739: from hr_psft_sync_run

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

Line 910: from hr_psft_sync_run

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

Line 984: from hr_psft_sync_run

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

Line 1059: from hr_psft_sync_run

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