APPS.HR_EFC_INFO dependencies on HR_EFC_PROCESS_COMPONENTS

Line 382: FROM hr_efc_process_components epc

378: -- Cursor to find no. of workers
379: CURSOR csr_check_workers(c_action_id IN number
380: ,c_component_name IN varchar2) IS
381: SELECT epc.total_workers
382: FROM hr_efc_process_components epc
383: WHERE epc.efc_action_id = c_action_id
384: AND epc.process_component_name = c_component_name;
385: --
386: -- Cursor to find sub phases

Line 392: FROM hr_efc_process_components epc

388: ,c_sub_step IN number
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

Line 406: FROM hr_efc_process_components epc

402: CURSOR csr_check_rows(c_action_id IN number
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

Line 979: FROM hr_efc_process_components epc

975: --
976: CURSOR csr_fetch_comp_id(c_action_id IN number
977: ,c_process_component_name IN varchar2) IS
978: SELECT epc.efc_process_component_id
979: FROM hr_efc_process_components epc
980: WHERE epc.efc_action_id = c_action_id
981: AND epc.process_component_name = c_process_component_name;
982: --
983: BEGIN

Line 985: dbms_lock.allocate_unique(lockname => 'HR_EFC_PROCESS_COMPONENTS'

981: AND epc.process_component_name = c_process_component_name;
982: --
983: BEGIN
984: -- Get lock handle for EFC lock
985: dbms_lock.allocate_unique(lockname => 'HR_EFC_PROCESS_COMPONENTS'
986: ,lockhandle => l_lockhandle);
987: --
988: LOOP
989: -- Attempt to take lock

Line 1014: INSERT INTO hr_efc_process_components

1010: FETCH csr_fetch_comp_id INTO p_process_component_id;
1011: IF csr_fetch_comp_id%NOTFOUND THEN
1012: -- row does not exist, so insert row into process components table.
1013: --
1014: INSERT INTO hr_efc_process_components
1015: (efc_process_component_id
1016: ,efc_action_id
1017: ,process_component_name
1018: ,table_name

Line 1028: (hr_efc_process_components_s.nextval

1024: ,last_update_login
1025: ,created_by
1026: ,creation_date)
1027: VALUES
1028: (hr_efc_process_components_s.nextval
1029: ,p_action_id
1030: ,p_process_component_name
1031: ,p_table_name
1032: ,p_total_workers

Line 1078: FROM hr_efc_process_components epc

1074: , ewo.pk2
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