13:
14: PROCEDURE map_error_message
15: (
16: p_validation_id IN NUMBER,
17: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
18: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
19: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
20: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
21: p_table_name IN VARCHAR2 := NULL,
14: PROCEDURE map_error_message
15: (
16: p_validation_id IN NUMBER,
17: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
18: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
19: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
20: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
21: p_table_name IN VARCHAR2 := NULL,
22: p_interface_header_id IN NUMBER,
15: (
16: p_validation_id IN NUMBER,
17: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
18: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
19: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
20: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
21: p_table_name IN VARCHAR2 := NULL,
22: p_interface_header_id IN NUMBER,
23: p_interface_line_id IN NUMBER := NULL,
16: p_validation_id IN NUMBER,
17: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
18: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
19: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
20: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
21: p_table_name IN VARCHAR2 := NULL,
22: p_interface_header_id IN NUMBER,
23: p_interface_line_id IN NUMBER := NULL,
24: p_interface_line_location_id IN NUMBER := NULL,
29:
30: FUNCTION get_value_from_key
31: (
32: p_key IN VARCHAR2,
33: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
34: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
35: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
36: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
37: p_table_name IN VARCHAR2 := NULL,
30: FUNCTION get_value_from_key
31: (
32: p_key IN VARCHAR2,
33: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
34: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
35: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
36: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
37: p_table_name IN VARCHAR2 := NULL,
38: p_interface_header_id IN NUMBER,
31: (
32: p_key IN VARCHAR2,
33: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
34: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
35: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
36: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
37: p_table_name IN VARCHAR2 := NULL,
38: p_interface_header_id IN NUMBER,
39: p_interface_line_id IN NUMBER := NULL,
32: p_key IN VARCHAR2,
33: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
34: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
35: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
36: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
37: p_table_name IN VARCHAR2 := NULL,
38: p_interface_header_id IN NUMBER,
39: p_interface_line_id IN NUMBER := NULL,
40: p_interface_line_location_id IN NUMBER := NULL,
306: p_token6_name IN VARCHAR2 := NULL,
307: p_token6_value IN VARCHAR2 := NULL,
308: p_error_message IN VARCHAR2 := NULL,
309: p_validation_id IN NUMBER := NULL,
310: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
311: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
312: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
313: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
314: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
307: p_token6_value IN VARCHAR2 := NULL,
308: p_error_message IN VARCHAR2 := NULL,
309: p_validation_id IN NUMBER := NULL,
310: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
311: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
312: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
313: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
314: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
315: ) IS
308: p_error_message IN VARCHAR2 := NULL,
309: p_validation_id IN NUMBER := NULL,
310: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
311: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
312: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
313: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
314: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
315: ) IS
316:
309: p_validation_id IN NUMBER := NULL,
310: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
311: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
312: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
313: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
314: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
315: ) IS
316:
317: d_api_name CONSTANT VARCHAR2(30) := 'add_fatal_error';
310: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
311: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
312: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
313: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
314: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
315: ) IS
316:
317: d_api_name CONSTANT VARCHAR2(30) := 'add_fatal_error';
318: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
429: ------------------------------------------------------------------------
430: PROCEDURE process_val_type_errors
431: ( x_results IN OUT NOCOPY po_validation_results_type,
432: p_table_name IN VARCHAR2,
433: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
434: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
435: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
436: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
437: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
430: PROCEDURE process_val_type_errors
431: ( x_results IN OUT NOCOPY po_validation_results_type,
432: p_table_name IN VARCHAR2,
433: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
434: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
435: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
436: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
437: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
438: )
431: ( x_results IN OUT NOCOPY po_validation_results_type,
432: p_table_name IN VARCHAR2,
433: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
434: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
435: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
436: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
437: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
438: )
439: IS
432: p_table_name IN VARCHAR2,
433: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
434: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
435: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
436: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
437: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
438: )
439: IS
440:
433: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
434: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
435: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
436: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
437: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
438: )
439: IS
440:
441: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
792: ------------------------------------------------------------------------
793: PROCEDURE map_error_message
794: (
795: p_validation_id IN NUMBER,
796: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
797: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
798: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
799: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
800: p_table_name IN VARCHAR2 := NULL,
793: PROCEDURE map_error_message
794: (
795: p_validation_id IN NUMBER,
796: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
797: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
798: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
799: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
800: p_table_name IN VARCHAR2 := NULL,
801: p_interface_header_id IN NUMBER,
794: (
795: p_validation_id IN NUMBER,
796: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
797: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
798: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
799: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
800: p_table_name IN VARCHAR2 := NULL,
801: p_interface_header_id IN NUMBER,
802: p_interface_line_id IN NUMBER := NULL,
795: p_validation_id IN NUMBER,
796: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
797: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
798: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
799: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
800: p_table_name IN VARCHAR2 := NULL,
801: p_interface_header_id IN NUMBER,
802: p_interface_line_id IN NUMBER := NULL,
803: p_interface_line_location_id IN NUMBER := NULL,
1036: ------------------------------------------------------------------------
1037: FUNCTION get_value_from_key
1038: (
1039: p_key IN VARCHAR2,
1040: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
1041: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
1042: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
1043: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
1044: p_table_name IN VARCHAR2 := NULL,
1037: FUNCTION get_value_from_key
1038: (
1039: p_key IN VARCHAR2,
1040: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
1041: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
1042: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
1043: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
1044: p_table_name IN VARCHAR2 := NULL,
1045: p_interface_header_id IN NUMBER,
1038: (
1039: p_key IN VARCHAR2,
1040: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
1041: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
1042: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
1043: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
1044: p_table_name IN VARCHAR2 := NULL,
1045: p_interface_header_id IN NUMBER,
1046: p_interface_line_id IN NUMBER := NULL,
1039: p_key IN VARCHAR2,
1040: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
1041: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
1042: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
1043: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
1044: p_table_name IN VARCHAR2 := NULL,
1045: p_interface_header_id IN NUMBER,
1046: p_interface_line_id IN NUMBER := NULL,
1047: p_interface_line_location_id IN NUMBER := NULL,