APPS.HR_EFC_INFO dependencies on HR_EFC_WORKERS

Line 393: , hr_efc_workers efw

389: ,c_step IN varchar2
390: ) IS
391: SELECT 'Y'
392: FROM hr_efc_process_components epc
393: , hr_efc_workers efw
394: WHERE epc.efc_action_id = c_action_id
395: AND epc.step = c_step
396: AND epc.sub_step < c_sub_step
397: AND efw.efc_process_component_id = epc.efc_process_component_id

Line 407: , hr_efc_workers efw

403: ,c_sub_step IN number
404: ,c_step IN varchar2) IS
405: SELECT count(*)
406: FROM hr_efc_process_components epc
407: , hr_efc_workers efw
408: WHERE epc.efc_action_id = c_action_id
409: AND epc.step = c_step
410: AND epc.sub_step = c_sub_step
411: AND efw.efc_process_component_id = epc.efc_process_component_id

Line 1079: , hr_efc_workers ewo

1075: , ewo.pk3
1076: , ewo.pk4
1077: , ewo.pk5
1078: FROM hr_efc_process_components epc
1079: , hr_efc_workers ewo
1080: WHERE epc.efc_action_id = c_action_id
1081: AND epc.process_component_name = c_component
1082: AND epc.efc_process_component_id = ewo.efc_process_component_id
1083: AND ewo.worker_number = c_worker_id;

Line 1116: INSERT INTO hr_efc_workers

1112: OPEN csr_fetch_spid;
1113: FETCH csr_fetch_spid INTO l_spid;
1114: CLOSE csr_fetch_spid;
1115: --
1116: INSERT INTO hr_efc_workers
1117: (efc_worker_id
1118: ,efc_process_component_id
1119: ,efc_action_id
1120: ,worker_number

Line 1135: (hr_efc_workers_s.nextval

1131: ,created_by
1132: ,creation_date
1133: )
1134: VALUES
1135: (hr_efc_workers_s.nextval
1136: ,p_process_component_id
1137: ,p_action_id
1138: ,p_worker_number
1139: ,p_status

Line 1158: -- Row exists in HR_EFC_WORKERS table already, so set return values

1154: --
1155: -- Set return values
1156: p_pk1 := l_pk1;
1157: ELSE
1158: -- Row exists in HR_EFC_WORKERS table already, so set return values
1159: -- and also update SPID
1160: IF l_restart.worker_process_status = 'P' THEN
1161: -- Check if SQL_TRACE is on
1162: l_spid := NULL;

Line 1171: UPDATE hr_efc_workers

1167: CLOSE csr_fetch_spid;
1168: --
1169: IF l_spid IS NOT NULL THEN
1170: -- update worker row
1171: UPDATE hr_efc_workers
1172: SET spid = l_spid
1173: WHERE efc_worker_id = l_restart.efc_worker_id;
1174: END IF;
1175: END IF;

Line 1187: -- We now definitely have a row in HR_EFC_WORKERS table

1183: --
1184: END IF;
1185: CLOSE csr_restart;
1186: --
1187: -- We now definitely have a row in HR_EFC_WORKERS table
1188: --
1189: END insert_or_select_worker_row;
1190: --
1191: -- ----------------------------------------------------------------------------

Line 1375: UPDATE hr_efc_workers

1371: ) IS
1372: BEGIN
1373: --
1374: -- Update the worker row
1375: UPDATE hr_efc_workers
1376: SET pk1 = p_pk1
1377: , pk2 = p_pk2
1378: , pk3 = p_pk3
1379: , pk4 = p_pk4

Line 1397: UPDATE hr_efc_workers

1393: ,p_pk5 IN varchar2
1394: ) IS
1395: BEGIN
1396: --
1397: UPDATE hr_efc_workers
1398: SET pk1 = p_pk1
1399: , pk2 = p_pk2
1400: , pk3 = p_pk3
1401: , pk4 = p_pk4