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 DUAL

Line 197: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

193: open fet_cntry_sync(p_country_code,p_row1_id);
194: fetch fet_cntry_sync into p_cntry_code,p_cntry_desc,p_cntry_code,p_obs_flag,p_row_id,p_last_update_date;
195: if fet_cntry_sync%found then
196:
197: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
198: insert into hr_country_delta_sync(COUNTRY_CODE,COUNTRY_DESCRIPTION,ROW_ID,
199: COUNTRY_2CHAR,OBSOLETE_FLAG,LAST_UPDATE_DATE,STATUS,EFFECTIVE_STATUS_DATE,EVENT_KEY)
200: values(p_cntry_code,p_cntry_desc,p_row_id,p_cntry_code,p_obs_flag,p_last_update_date,'QUEUED',p_effective_date,
201: p_cntry_code||'-'||to_char(p_unique_key));

Line 237: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

233: open fet_cntry_fsync(p_max_run_date);
234: loop
235: fetch fet_cntry_fsync into p_cntry_code,p_cntry_desc,p_cntry_code,p_obs_flag,p_row_id,p_last_update_date;
236: if fet_cntry_fsync%found then
237: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
238: insert into hr_country_delta_sync(COUNTRY_CODE,COUNTRY_DESCRIPTION,ROW_ID,
239: COUNTRY_2CHAR,OBSOLETE_FLAG,LAST_UPDATE_DATE,STATUS,EFFECTIVE_STATUS_DATE,EVENT_KEY)
240: values(p_cntry_code,p_cntry_desc,p_row_id,p_cntry_code,p_obs_flag,p_last_update_date,'QUEUED',p_effective_date,
241: p_cntry_code||'-'||to_char(p_unique_key));

Line 403: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

399: open fet_state_qsync(p_country_code,p_stt_code);
400: fetch fet_state_qsync into p_cntry_code,p_state_code,p_state_desc,p_enable_flag,p_last_update_date;
401: if fet_state_qsync%found then
402:
403: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
404: insert into hr_state_delta_sync(COUNTRY_CODE,STATE_CODE,
405: STATE_DESCRIPTION,ENABLE_FLAG,STATUS,EFFECTIVE_STATUS_DATE,
406: LAST_UPDATE_DATE,EVENT_KEY )
407: values(p_cntry_code,p_state_code,p_state_desc,p_enable_flag,'QUEUED',p_effective_date,p_last_update_date,p_state_code||'-'||to_char(p_unique_key));

Line 442: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

438: open fet_state_sync(p_max_run_date);
439: loop
440: fetch fet_state_sync into p_cntry_code,p_state_code,p_state_desc,p_enable_flag,p_last_update_date;
441: if fet_state_sync%found then
442: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
443: insert into hr_state_delta_sync(COUNTRY_CODE,STATE_CODE,
444: STATE_DESCRIPTION,ENABLE_FLAG,STATUS,EFFECTIVE_STATUS_DATE,
445: LAST_UPDATE_DATE,EVENT_KEY ) values(p_cntry_code,p_state_code,p_state_desc,p_enable_flag,'QUEUED',p_effective_date,p_last_update_date,p_state_code||'-'||to_char(p_unique_key));
446: commit;

Line 708: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

704: p_town_or_city,p_region_1,p_region_2,p_region_3,p_postal_code,p_tel_no_1,p_tel_no_2 ,
705: p_tel_no_3,p_loc_info_13, p_loc_info_14,p_loc_info_15,p_loc_info_16,p_loc_info_17,p_loc_info_18,
706: p_loc_info_19,p_loc_info_20,p_last_update_date;
707: if fet_loc_qsync%found then
708: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
709: insert into hr_locn_delta_sync(BUSINESS_GROUP_ID,
710: LOCATION_ID,
711: EFFECTIVE_DATE,
712: EFFECTIVE_STATUS,

Line 786: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

782: p_town_or_city,p_region_1,p_region_2,p_region_3,p_postal_code,p_tel_no_1,p_tel_no_2 ,
783: p_tel_no_3,p_loc_info_13, p_loc_info_14,p_loc_info_15,p_loc_info_16,p_loc_info_17,p_loc_info_18,
784: p_loc_info_19,p_loc_info_20,p_last_update_date;
785: if fet_loc_sync%found then
786: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
787: insert into hr_locn_delta_sync(BUSINESS_GROUP_ID,
788: LOCATION_ID,
789: EFFECTIVE_DATE,
790: EFFECTIVE_STATUS,

Line 1213: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

1209: l_business_group_id,p_last_update_date ;
1210:
1211: if csr_person_delta_qsync%found then
1212:
1213: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1214: insert into hr_person_delta_sync
1215: (EMPLOYEE_NUMBER,USER_PERSON_TYPE ,
1216: DATE_OF_BIRTH,TOWN_OF_BIRTH,
1217: COUNTRY_OF_BIRTH,BUSINESS_GROUP_ID,

Line 1285: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

1281: l_business_group_id,p_last_update_date ;
1282:
1283: if csr_person_delta_sync%found then
1284:
1285: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1286: insert into hr_person_delta_sync
1287: (EMPLOYEE_NUMBER,USER_PERSON_TYPE ,
1288: DATE_OF_BIRTH,TOWN_OF_BIRTH,
1289: COUNTRY_OF_BIRTH,BUSINESS_GROUP_ID,

Line 1561: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

1557:
1558: if workforce_deltaq%FOUND then
1559:
1560:
1561: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1562: insert into HR_WORKFORCE_DELTA_SYNC
1563: (EMPLOYEE_NUMBER,
1564: EMPL_RCD ,
1565: ORIGINAL_DATE_OF_HIRE,

Line 1722: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

1718: END LOOP;
1719:
1720:
1721: FOR I IN 1 .. p_cnt Loop
1722: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1723: insert into HR_WORKFORCE_DELTA_SYNC
1724: (EMPLOYEE_NUMBER,
1725: EMPL_RCD ,
1726: ORIGINAL_DATE_OF_HIRE,

Line 1955: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

1951: ,Jobcodedeltatype.LAST_UPD_DATE(1);
1952:
1953: IF jobcode_deltaq%found then
1954:
1955: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1956:
1957: insert into HR_JOBCODE_DELTA_SYNC(
1958: SETID ,
1959: JOBCODE ,

Line 2067: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

2063:
2064:
2065: FOR I IN 1 .. p_cnt Loop
2066:
2067: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2068:
2069: insert into HR_JOBCODE_DELTA_SYNC(
2070: SETID ,
2071: JOBCODE ,

Line 2290: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

2286: open fet_orgn_sync(p_bgrp_id,p_orgn_id,p_lstupd_date);
2287: fetch fet_orgn_sync into p_bg_id,p_dept_id,p_eff_date,p_eff_status,p_bg_name,p_loc_id,p_person_id,p_full_name,p_last_update_date;
2288: if fet_orgn_sync%found then
2289:
2290: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2291: insert into hr_organization_delta_sync(BUSINESS_GROUP_ID,
2292: ORGANIZATION_ID,
2293: BUSINESS_GROUP_NAME ,
2294: EFFECTIVE_DATE,

Line 2344: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

2340: open fet_orgn_fsync(p_max_run_date);
2341: loop
2342: fetch fet_orgn_fsync into p_bg_id,p_dept_id,p_eff_date,p_eff_status,p_bg_name,p_loc_id,p_person_id,p_full_name,p_last_update_date;
2343: if fet_orgn_fsync%found then
2344: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2345: insert into hr_organization_delta_sync(BUSINESS_GROUP_ID,
2346: ORGANIZATION_ID,
2347: BUSINESS_GROUP_NAME ,
2348: EFFECTIVE_DATE,

Line 2530: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

2526: open fet_bg_sync(p_bgrp_id,p_lstupd_date);
2527: fetch fet_bg_sync into p_bg_id,p_bg_name,p_eff_date,p_eff_status,p_last_update_date;
2528: if fet_bg_sync%found then
2529:
2530: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2531: insert into hr_bgrp_delta_sync(BUSINESS_GROUP_ID,BUSINESS_GROUP_NAME,
2532: EFFECTIVE_DATE,EFFECTIVE_STATUS,LAST_UPDATE_DATE ,STATUS,EFFECTIVE_STATUS_DATE,
2533: EVENT_KEY)
2534: values(p_bg_id,p_bg_name,p_eff_date,p_eff_status,p_last_update_date,'QUEUED',p_effective_date,

Line 2572: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

2568: open fet_bg_fsync(p_max_run_date);
2569: loop
2570: fetch fet_bg_fsync into p_bg_id,p_bg_name,p_eff_date,p_eff_status,p_last_update_date;
2571: if fet_bg_fsync%found then
2572: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2573: insert into hr_bgrp_delta_sync(BUSINESS_GROUP_ID,BUSINESS_GROUP_NAME,
2574: EFFECTIVE_DATE,EFFECTIVE_STATUS,LAST_UPDATE_DATE ,STATUS,EFFECTIVE_STATUS_DATE,
2575: EVENT_KEY)
2576: values(p_bg_id,p_bg_name,p_eff_date,p_eff_status,p_last_update_date,'QUEUED',p_effective_date,

Line 2758: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

2754: open fet_pyrl_sync(p_payroll_id,p_bgrp_id,p_lstupd_date);
2755: fetch fet_pyrl_sync into p_pyrl_id,p_pyrl_name,p_bg_id,p_eff_date,p_eff_status,p_last_update_date;
2756: if fet_pyrl_sync%found then
2757:
2758: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2759: insert into hr_pyrl_delta_sync(PAYROLL_ID,
2760: PAYROLL_NAME,
2761: BUSINESS_GROUP_ID ,
2762: EFFECTIVE_DATE,

Line 2807: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

2803: open fet_pyrl_fsync(p_max_run_date);
2804: loop
2805: fetch fet_pyrl_fsync into p_pyrl_id,p_pyrl_name,p_bg_id,p_eff_date,p_eff_status,p_last_update_date;
2806: if fet_pyrl_fsync%found then
2807: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2808: insert into hr_pyrl_delta_sync(PAYROLL_ID,
2809: PAYROLL_NAME,
2810: BUSINESS_GROUP_ID ,
2811: EFFECTIVE_DATE,