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,
291: p_token6_name IN VARCHAR2 := NULL,
292: p_token6_value IN VARCHAR2 := NULL,
293: p_error_message IN VARCHAR2 := NULL,
294: p_validation_id IN NUMBER := NULL,
295: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
296: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
297: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
298: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
299: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
292: p_token6_value IN VARCHAR2 := NULL,
293: p_error_message IN VARCHAR2 := NULL,
294: p_validation_id IN NUMBER := NULL,
295: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
296: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
297: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
298: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
299: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
300: ) IS
293: p_error_message IN VARCHAR2 := NULL,
294: p_validation_id IN NUMBER := NULL,
295: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
296: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
297: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
298: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
299: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
300: ) IS
301:
294: p_validation_id IN NUMBER := NULL,
295: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
296: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
297: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
298: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
299: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
300: ) IS
301:
302: d_api_name CONSTANT VARCHAR2(30) := 'add_fatal_error';
295: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
296: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
297: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
298: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
299: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
300: ) IS
301:
302: d_api_name CONSTANT VARCHAR2(30) := 'add_fatal_error';
303: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
414: ------------------------------------------------------------------------
415: PROCEDURE process_val_type_errors
416: ( x_results IN OUT NOCOPY po_validation_results_type,
417: p_table_name IN VARCHAR2,
418: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
419: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
420: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
421: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
422: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
415: PROCEDURE process_val_type_errors
416: ( x_results IN OUT NOCOPY po_validation_results_type,
417: p_table_name IN VARCHAR2,
418: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
419: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
420: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
421: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
422: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
423: )
416: ( x_results IN OUT NOCOPY po_validation_results_type,
417: p_table_name IN VARCHAR2,
418: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
419: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
420: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
421: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
422: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
423: )
424: IS
417: p_table_name IN VARCHAR2,
418: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
419: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
420: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
421: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
422: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
423: )
424: IS
425:
418: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
419: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
420: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
421: p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
422: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
423: )
424: IS
425:
426: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
777: ------------------------------------------------------------------------
778: PROCEDURE map_error_message
779: (
780: p_validation_id IN NUMBER,
781: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
782: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
783: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
784: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
785: p_table_name IN VARCHAR2 := NULL,
778: PROCEDURE map_error_message
779: (
780: p_validation_id IN NUMBER,
781: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
782: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
783: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
784: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
785: p_table_name IN VARCHAR2 := NULL,
786: p_interface_header_id IN NUMBER,
779: (
780: p_validation_id IN NUMBER,
781: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
782: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
783: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
784: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
785: p_table_name IN VARCHAR2 := NULL,
786: p_interface_header_id IN NUMBER,
787: p_interface_line_id IN NUMBER := NULL,
780: p_validation_id IN NUMBER,
781: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
782: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
783: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
784: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
785: p_table_name IN VARCHAR2 := NULL,
786: p_interface_header_id IN NUMBER,
787: p_interface_line_id IN NUMBER := NULL,
788: p_interface_line_location_id IN NUMBER := NULL,
1021: ------------------------------------------------------------------------
1022: FUNCTION get_value_from_key
1023: (
1024: p_key IN VARCHAR2,
1025: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
1026: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
1027: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
1028: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
1029: p_table_name IN VARCHAR2 := NULL,
1022: FUNCTION get_value_from_key
1023: (
1024: p_key IN VARCHAR2,
1025: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
1026: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
1027: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
1028: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
1029: p_table_name IN VARCHAR2 := NULL,
1030: p_interface_header_id IN NUMBER,
1023: (
1024: p_key IN VARCHAR2,
1025: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
1026: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
1027: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
1028: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
1029: p_table_name IN VARCHAR2 := NULL,
1030: p_interface_header_id IN NUMBER,
1031: p_interface_line_id IN NUMBER := NULL,
1024: p_key IN VARCHAR2,
1025: p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
1026: p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
1027: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
1028: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL,
1029: p_table_name IN VARCHAR2 := NULL,
1030: p_interface_header_id IN NUMBER,
1031: p_interface_line_id IN NUMBER := NULL,
1032: p_interface_line_location_id IN NUMBER := NULL,