eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_PSFT_SYNC_RUN

Line 4: /Procedure to update the record into hr_psft_sync_run table begins/

1: PACKAGE BODY HR_DELTA_SYNC_MESSAGES as
2: /* $Header: perhrhdrir.pkb 120.13 2008/03/19 09:50:29 sathkris noship $ */
3:
4: /*Procedure to update the record into hr_psft_sync_run table begins*/
5: PROCEDURE update_psft_sync_run
6: (p_status number
7: ,p_process_name varchar2
8: ,p_run_date date

Line 24: update hr_psft_sync_run

20: elsif p_status = 3 then
21: l_status := 'ERROR';
22: end if;
23:
24: update hr_psft_sync_run
25: set status = l_status where process = p_process_name
26: and run_date =p_run_date;
27: commit;
28:

Line 39: /Procedure to update the record into hr_psft_sync_run table ends/

35: FND_FILE.NEW_LINE(FND_FILE.log, 1);
36: FND_FILE.put_line(fnd_file.log,'Error Msg: '||substr(SQLERRM,1,700));
37:
38: END update_psft_sync_run;
39: /*Procedure to update the record into hr_psft_sync_run table ends*/
40:
41: /*Procedure to insert the record into hr_psft_sync_run table begins*/
42: PROCEDURE insert_psft_sync_run
43: (p_status number

Line 41: /Procedure to insert the record into hr_psft_sync_run table begins/

37:
38: END update_psft_sync_run;
39: /*Procedure to update the record into hr_psft_sync_run table ends*/
40:
41: /*Procedure to insert the record into hr_psft_sync_run table begins*/
42: PROCEDURE insert_psft_sync_run
43: (p_status number
44: ,p_process_name varchar2
45: ,errbuf OUT NOCOPY VARCHAR2

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

57: elsif p_status = 3 then
58: l_status := 'ERROR';
59: end if;
60:
61: INSERT INTO hr_psft_sync_run(run_date,status,process)
62: Values(sysdate,l_status,p_process_name);
63: commit;
64:
65: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 75: /Procedure to insert the record into hr_psft_sync_run table ends/

71: FND_FILE.NEW_LINE(FND_FILE.log, 1);
72: FND_FILE.put_line(fnd_file.log,'Error Msg: '||substr(SQLERRM,1,700));
73:
74: END insert_psft_sync_run;
75: /*Procedure to insert the record into hr_psft_sync_run table ends*/
76:
77: /*Procedure to extract the delta synch data for country begins here*/
78:
79: PROCEDURE hr_country_delta_sync(errbuf OUT NOCOPY VARCHAR2

Line 137: from hr_psft_sync_run

133: p_event_key_gen varchar2(50);
134:
135: cursor fet_psft_run_dt is
136: select max(run_date)
137: from hr_psft_sync_run
138: where process = 'COUNTRY_DELTA_SYNC'
139: and run_date < p_effective_date
140: and status = 'COMPLETED';
141:

Line 144: from hr_psft_sync_run

140: and status = 'COMPLETED';
141:
142: cursor fet_psft_run_dt1 is
143: select max(run_date)
144: from hr_psft_sync_run
145: where process = 'COUNTRY_FULL_SYNC'
146: and status = 'COMPLETED';
147:
148: cursor fet_psft_sync is

Line 150: from hr_psft_sync_run

146: and status = 'COMPLETED';
147:
148: cursor fet_psft_sync is
149: select count('x')
150: from hr_psft_sync_run
151: where process = 'COUNTRY_DELTA_SYNC'
152: and run_date < p_effective_date
153: and status = 'STARTED';
154:

Line 306: from hr_psft_sync_run

302: p_gen_status varchar2(10);
303:
304: cursor fet_psft_run_dt is
305: select max(run_date)
306: from hr_psft_sync_run
307: where process = 'STATE_DELTA_SYNC'
308: and run_date < p_effective_date
309: and status = 'COMPLETED';
310:

Line 313: from hr_psft_sync_run

309: and status = 'COMPLETED';
310:
311: cursor fet_psft_run_dt1 is
312: select max(run_date)
313: from hr_psft_sync_run
314: where process = 'STATE_FULL_SYNC'
315: and status = 'COMPLETED';
316:
317: cursor csr_gen_msg(p_evn_key varchar2)

Line 358: from hr_psft_sync_run

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

Line 540: from hr_psft_sync_run

536: p_gen_status varchar2(10);
537:
538: cursor fet_psft_sync is
539: select count('x')
540: from hr_psft_sync_run
541: where process = 'LOC_DELTA_SYNC'
542: and run_date < p_effective_date
543: and status = 'STARTED';
544:

Line 547: from hr_psft_sync_run

543: and status = 'STARTED';
544:
545: cursor fet_psft_run_dt is
546: select max(run_date)
547: from hr_psft_sync_run
548: where process = 'LOC_DELTA_SYNC'
549: and run_date < p_effective_date
550: and status = 'COMPLETED';
551:

Line 555: from hr_psft_sync_run

551:
552:
553: cursor fet_psft_run_dt1 is
554: select max(run_date)
555: from hr_psft_sync_run
556: where process = 'LOC_FULL_SYNC'
557: and status = 'COMPLETED';
558:
559: l_dummy number;

Line 1138: from hr_psft_sync_run

1134: p_cntry_delta_sts varchar2(10);
1135:
1136: cursor fet_psft_sync is
1137: select count('x')
1138: from hr_psft_sync_run
1139: where process = 'PERSON_DELTA_SYNC'
1140: and run_date < sysdate
1141: and status = 'STARTED';
1142:

Line 1146: from hr_psft_sync_run

1142:
1143:
1144: cursor csr_psft_sync is
1145: select max (run_date)
1146: from hr_psft_sync_run
1147: where process = 'PERSON_DELTA_SYNC'
1148: and run_date < sysdate
1149: and status = 'COMPLETED';
1150:

Line 1154: from hr_psft_sync_run

1150:
1151:
1152: cursor csr_psft_sync_FULL is
1153: select ruN_date
1154: from hr_psft_sync_run
1155: where process = 'PERSON_FULL_SYNC'
1156: and status = 'COMPLETED';
1157:
1158: l_dummy number;

Line 1436: from hr_psft_sync_run

1432: p_gen_status varchar2(10);
1433:
1434: cursor fet_psft_run_dt is
1435: select max(run_date)
1436: from hr_psft_sync_run
1437: where process = 'WORKFORCE_DELTA_SYNC'
1438: and run_date < p_effective_date
1439: and status = 'COMPLETED';
1440:

Line 1443: from hr_psft_sync_run

1439: and status = 'COMPLETED';
1440:
1441: cursor fet_psft_run_dt1 is
1442: select max(run_date)
1443: from hr_psft_sync_run
1444: where process = 'WORKFORCE_FULL_SYNC'
1445: and status = 'COMPLETED';
1446:
1447: cursor fet_psft_sync is

Line 1449: from hr_psft_sync_run

1445: and status = 'COMPLETED';
1446:
1447: cursor fet_psft_sync is
1448: select count('x')
1449: from hr_psft_sync_run
1450: where process = 'WORKFORCE_DELTA_SYNC'
1451: and run_date < p_effective_date
1452: and status = 'STARTED';
1453:

Line 1855: from hr_psft_sync_run

1851: p_effective_date date default sysdate;
1852:
1853: cursor fet_psft_run_dt is
1854: select max(run_date)
1855: from hr_psft_sync_run
1856: where process = 'JOBCODE_DELTA_SYNC'
1857: and run_date < p_effective_date
1858: and status = 'COMPLETED';
1859:

Line 1862: from hr_psft_sync_run

1858: and status = 'COMPLETED';
1859:
1860: cursor fet_psft_run_dt1 is
1861: select max(run_date)
1862: from hr_psft_sync_run
1863: where process = 'JOBCODE_FULL_SYNC'
1864: and status = 'COMPLETED';
1865:
1866: cursor fet_psft_sync is

Line 1868: from hr_psft_sync_run

1864: and status = 'COMPLETED';
1865:
1866: cursor fet_psft_sync is
1867: select count('x')
1868: from hr_psft_sync_run
1869: where process = 'JOBCODE_DELTA_SYNC'
1870: and run_date < p_effective_date
1871: and status = 'STARTED';
1872:

Line 2230: from hr_psft_sync_run

2226: p_event_key_gen varchar2(50);
2227:
2228: cursor fet_psft_run_dt is
2229: select max(run_date)
2230: from hr_psft_sync_run
2231: where process = 'ORG_DELTA_SYNC'
2232: and run_date < p_effective_date
2233: and status = 'COMPLETED';
2234:

Line 2237: from hr_psft_sync_run

2233: and status = 'COMPLETED';
2234:
2235: cursor fet_psft_run_dt1 is
2236: select max(run_date)
2237: from hr_psft_sync_run
2238: where process = 'ORG_FULL_SYNC'
2239: and status = 'COMPLETED';
2240:
2241: cursor fet_psft_sync is

Line 2243: from hr_psft_sync_run

2239: and status = 'COMPLETED';
2240:
2241: cursor fet_psft_sync is
2242: select count('x')
2243: from hr_psft_sync_run
2244: where process = 'ORG_DELTA_SYNC'
2245: and run_date < p_effective_date
2246: and status = 'STARTED';
2247:

Line 2470: from hr_psft_sync_run

2466: p_event_key_gen varchar2(50);
2467:
2468: cursor fet_psft_run_dt is
2469: select max(run_date)
2470: from hr_psft_sync_run
2471: where process = 'BG_DELTA_SYNC'
2472: and run_date < p_effective_date
2473: and status = 'COMPLETED';
2474:

Line 2477: from hr_psft_sync_run

2473: and status = 'COMPLETED';
2474:
2475: cursor fet_psft_run_dt1 is
2476: select max(run_date)
2477: from hr_psft_sync_run
2478: where process = 'BG_FULL_SYNC'
2479: and status = 'COMPLETED';
2480:
2481: cursor fet_psft_sync is

Line 2483: from hr_psft_sync_run

2479: and status = 'COMPLETED';
2480:
2481: cursor fet_psft_sync is
2482: select count('x')
2483: from hr_psft_sync_run
2484: where process = 'BG_DELTA_SYNC'
2485: and run_date < p_effective_date
2486: and status = 'STARTED';
2487:

Line 2698: from hr_psft_sync_run

2694: p_event_key_gen varchar2(50);
2695:
2696: cursor fet_psft_run_dt is
2697: select max(run_date)
2698: from hr_psft_sync_run
2699: where process = 'PYRL_DELTA_SYNC'
2700: and run_date < p_effective_date
2701: and status = 'COMPLETED';
2702:

Line 2705: from hr_psft_sync_run

2701: and status = 'COMPLETED';
2702:
2703: cursor fet_psft_run_dt1 is
2704: select max(run_date)
2705: from hr_psft_sync_run
2706: where process = 'PYRL_FULL_SYNC'
2707: and status = 'COMPLETED';
2708:
2709: cursor fet_psft_sync is

Line 2711: from hr_psft_sync_run

2707: and status = 'COMPLETED';
2708:
2709: cursor fet_psft_sync is
2710: select count('x')
2711: from hr_psft_sync_run
2712: where process = 'PYRL_DELTA_SYNC'
2713: and run_date < p_effective_date
2714: and status = 'STARTED';
2715: