339: SELECT hou.NAME
340: FROM hr_operating_units hou
341: WHERE hou.organization_id = p_org_id;
342:
343: l_org_id NUMBER := mo_global.get_current_org_id
344: ();
345: l_org_name VARCHAR2 (300);
346: l_orcl_logo VARCHAR2 (300);
347: l_term_heading VARCHAR2 (300);
4153: -- Do not spawn a worker if theres no data to process
4154: -- This occurs if more workers are requested and the
4155: -- distribution of data does not utilize them all
4156: IF l_worker_load (j).worker_load > 0 THEN
4157: fnd_request.set_org_id (mo_global.get_current_org_id);
4158: --MOAC- Concurrent request
4159: request_id :=
4160: fnd_request.submit_request (application => 'OKL',
4161: program => 'OKL_AM_CHILD_TERM',