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 4326: l_process_code FND_LOOKUPS.lookup_code%TYPE := null;

4322: from pa_proj_elem_ver_structure
4323: where project_id = c_project_id
4324: and element_version_id = c_structure_version_id;
4325:
4326: l_process_code FND_LOOKUPS.lookup_code%TYPE := null;
4327: l_structure_version_id NUMBER:= null;
4328: l_conc_request_id NUMBER := null;
4329:
4330: cursor cur_message(c_process_code FND_LOOKUPS.lookup_code%TYPE) is

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

4326: l_process_code FND_LOOKUPS.lookup_code%TYPE := null;
4327: l_structure_version_id NUMBER:= null;
4328: l_conc_request_id NUMBER := null;
4329:
4330: cursor cur_message(c_process_code FND_LOOKUPS.lookup_code%TYPE) is
4331: select meaning message_name, 'PROCESS' message_type
4332: from pa_lookups
4333: where lookup_code = c_process_code
4334: and c_process_code like '%P'