24:
25: cursor csr_fnd_install_processes(p_fnd_schema in varchar2) is
26: Select
27: OBJECT_NAME
28: from ALL_OBJECTS
29: where OBJECT_NAME = 'FND_INSTALL_PROCESSES'
30: and OBJECT_TYPE ='TABLE'
31: and OWNER = p_fnd_schema;
32:
36: from PAY_ACTION_PARAMETERS
37: where PARAMETER_NAME = 'HRLEGDEL_SLEEP';
38: --
39:
40: l_object_name all_objects.object_name%type;
41: l_flag_fnd_install_processes boolean;
42:
43: l_flag_stop_process boolean; -- flag to represent the 'STATUS' and 'ACTION field
44: -- status