APPS.PO_CLM_CAR_WF_UTIL dependencies on PO_CLM_CAR_LOGS

Line 16: TYPE err_code_tbl_type IS TABLE OF PO_CLM_CAR_LOGS.MESSAGE_CODE%TYPE;

12: l_draft_id NUMBER;
13: NL VARCHAR2(1) := fnd_global.newline;
14:
15: TYPE car_num_tbl_type IS TABLE OF PO_CLM_CARS.CAR_NUMBER%TYPE;
16: TYPE err_code_tbl_type IS TABLE OF PO_CLM_CAR_LOGS.MESSAGE_CODE%TYPE;
17: TYPE err_level_tbl_type IS TABLE OF VARCHAR2(60);
18: TYPE err_text_tbl_type IS TABLE OF PO_CLM_CAR_LOGS.MESSAGE_TEXT%TYPE;
19:
20: l_car_num_tbl car_num_tbl_type;

Line 18: TYPE err_text_tbl_type IS TABLE OF PO_CLM_CAR_LOGS.MESSAGE_TEXT%TYPE;

14:
15: TYPE car_num_tbl_type IS TABLE OF PO_CLM_CARS.CAR_NUMBER%TYPE;
16: TYPE err_code_tbl_type IS TABLE OF PO_CLM_CAR_LOGS.MESSAGE_CODE%TYPE;
17: TYPE err_level_tbl_type IS TABLE OF VARCHAR2(60);
18: TYPE err_text_tbl_type IS TABLE OF PO_CLM_CAR_LOGS.MESSAGE_TEXT%TYPE;
19:
20: l_car_num_tbl car_num_tbl_type;
21: l_err_code_tbl err_code_tbl_type;
22: l_err_level_tbl err_level_tbl_type;

Line 32: PO_CLM_CAR_LOGS LOG, po_lookup_codes PLC

28: MESSAGE_CODE,
29: NVL(PLC.DISPLAYED_FIELD, MESSAGE_LEVEL) MESSAGE_LEVEL_MEANING,
30: MESSAGE_TEXT
31: FROM
32: PO_CLM_CAR_LOGS LOG, po_lookup_codes PLC
33: WHERE
34: LOG.PO_HEADER_ID = v_document_id AND
35: LOG.PO_DRAFT_ID = v_draft_id AND
36: PLC.LOOKUP_TYPE(+) = 'PO_CLM_CAR_MESSAGE_LEVELS' AND

Line 61: l_document := '' || NL;

57: l_count := car_logs_csr%ROWCOUNT;
58: CLOSE car_logs_csr;
59:
60: IF (display_type = 'text/html') THEN
61: l_document := '

' || NL;
62:
63: l_document := l_document || '';
64:
65: l_document := l_document || '

' ||