APPS.FND_DIAG_REQUEST_ANALYZER dependencies on FND_LOOKUPS

Line 7: c_status fnd_lookups.meaning%TYPE;

3: str_error VARCHAR2(2000);
4: str_fix_info VARCHAR2(2000);
5:
6: FUNCTION get_status(p_status_code VARCHAR2) RETURN VARCHAR2 AS
7: c_status fnd_lookups.meaning%TYPE;
8: BEGIN
9: SELECT nvl(meaning, 'UNKNOWN')
10: INTO c_status
11: FROM fnd_lookups

Line 11: FROM fnd_lookups

7: c_status fnd_lookups.meaning%TYPE;
8: BEGIN
9: SELECT nvl(meaning, 'UNKNOWN')
10: INTO c_status
11: FROM fnd_lookups
12: WHERE lookup_type = 'CP_STATUS_CODE'
13: AND lookup_code = p_status_code;
14: RETURN RTRIM(c_status);
15: END get_status;

Line 17: c_phase fnd_lookups.meaning%TYPE;

13: AND lookup_code = p_status_code;
14: RETURN RTRIM(c_status);
15: END get_status;
16: FUNCTION get_phase(p_phase_code VARCHAR2) RETURN VARCHAR2 AS
17: c_phase fnd_lookups.meaning%TYPE;
18: BEGIN
19: SELECT nvl(meaning, 'UNKNOWN')
20: INTO c_phase
21: FROM fnd_lookups

Line 21: FROM fnd_lookups

17: c_phase fnd_lookups.meaning%TYPE;
18: BEGIN
19: SELECT nvl(meaning, 'UNKNOWN')
20: INTO c_phase
21: FROM fnd_lookups
22: WHERE lookup_type = 'CP_PHASE_CODE'
23: AND lookup_code = p_phase_code;
24: RETURN RTRIM(c_phase);
25: END get_phase;

Line 90: fnd_lookups fl

86: decode(fcwr.control_code, 'A', fl.meaning, 'D', fl.meaning, 'E', fl.meaning, 'N', fl.meaning, 'R', fl.meaning, 'T',
87: fl.meaning, 'U', fl.meaning, 'V', fl.meaning, 'X', fl.meaning, NULL, 'Running', '** Unknown Status **') status
88: FROM fnd_concurrent_queues_vl fcqv,
89: fnd_concurrent_worker_requests fcwr,
90: fnd_lookups fl
91: WHERE fcwr.request_id = rid
92: AND fcwr.concurrent_queue_id = fcqv.concurrent_queue_id
93: AND fcwr.concurrent_queue_id NOT IN(1, 4)
94: AND fl.lookup_code(+) = fcwr.control_code

Line 139: c_status fnd_lookups.meaning%TYPE;

135: -- CP Request Analyser
136: p_req_id NUMBER;
137: reqinfo fnd_concurrent_requests % rowtype;
138: proginfo fnd_concurrent_programs_vl % rowtype;
139: c_status fnd_lookups.meaning%TYPE;
140: m_buf fnd_lookups.meaning%TYPE;
141: conc_prog_name fnd_concurrent_programs.concurrent_program_name%TYPE;
142: exe_method_code fnd_concurrent_programs_vl.execution_method_code%TYPE;
143: conc_app_name fnd_application_vl.application_name%TYPE;

Line 140: m_buf fnd_lookups.meaning%TYPE;

136: p_req_id NUMBER;
137: reqinfo fnd_concurrent_requests % rowtype;
138: proginfo fnd_concurrent_programs_vl % rowtype;
139: c_status fnd_lookups.meaning%TYPE;
140: m_buf fnd_lookups.meaning%TYPE;
141: conc_prog_name fnd_concurrent_programs.concurrent_program_name%TYPE;
142: exe_method_code fnd_concurrent_programs_vl.execution_method_code%TYPE;
143: conc_app_name fnd_application_vl.application_name%TYPE;
144: tmp_id NUMBER(15);

Line 261: FROM fnd_lookups

257: AND fcr.program_application_id = fvl.application_id;
258:
259: SELECT nvl(meaning, 'UNKNOWN')
260: INTO m_buf
261: FROM fnd_lookups
262: WHERE lookup_type = 'CP_EXECUTION_METHOD_CODE'
263: AND lookup_code = proginfo.execution_method_code;
264:
265: SELECT nvl(execution_file_name, 'NONE')