APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on FND_LOOKUPS

Line 3311: l_wbs_update_option fnd_lookups.meaning%TYPE;

3307: ,p_project_id IN NUMBER default null --bug 4370533
3308: )
3309: return VARCHAR2 IS
3310:
3311: l_wbs_update_option fnd_lookups.meaning%TYPE;
3312: l_threshold_task_cnt number;
3313:
3314: CURSOR cur_link_exists
3315: IS

Line 3416: l_process_code FND_LOOKUPS.lookup_code%TYPE;

3412: and pst.PROJ_ELEMENT_ID = vs.proj_element_id
3413: and pst.structure_type_id = st.structure_type_id
3414: and st.structure_type = c_structure_type;
3415:
3416: l_process_code FND_LOOKUPS.lookup_code%TYPE;
3417: BEGIN
3418:
3419: open cur_proc_ver(p_project_id,p_structure_type);
3420: fetch cur_proc_ver into l_process_code;

Line 4301: l_process_code FND_LOOKUPS.lookup_code%TYPE := null;

4297: from pa_proj_elem_ver_structure
4298: where project_id = c_project_id
4299: and element_version_id = c_structure_version_id;
4300:
4301: l_process_code FND_LOOKUPS.lookup_code%TYPE := null;
4302: l_structure_version_id NUMBER:= null;
4303: l_conc_request_id NUMBER := null;
4304:
4305: cursor cur_message(c_process_code FND_LOOKUPS.lookup_code%TYPE) is

Line 4305: cursor cur_message(c_process_code FND_LOOKUPS.lookup_code%TYPE) is

4301: l_process_code FND_LOOKUPS.lookup_code%TYPE := null;
4302: l_structure_version_id NUMBER:= null;
4303: l_conc_request_id NUMBER := null;
4304:
4305: cursor cur_message(c_process_code FND_LOOKUPS.lookup_code%TYPE) is
4306: select meaning message_name, 'PROCESS' message_type
4307: from pa_lookups
4308: where lookup_code = c_process_code
4309: and c_process_code like '%P'