66:
67:
68: SELECT psp.security_position_structure_id
69: INTO x_security_hierarchy_id
70: FROM po_system_parameters psp;
71:
72:
73:
74: EXCEPTION
167:
168:
169: SELECT psp.security_position_structure_id
170: INTO x_security_hierarchy_id
171: FROM po_system_parameters psp;
172:
173:
174: EXCEPTION
175: WHEN OTHERS THEN
636: BEGIN
637: /* replacing the select statement with the new OE API. */
638: select order_source_id
639: into x_order_source_id
640: from po_system_parameters;
641:
642: --Bug# 1392077
643: --Toju George 08/31/2000
644: --Modified the call to procedure to replace req_num and line_num with ids.
653: /* SELECT distinct(soh.order_number)
654: INTO x_so_number
655: FROM so_lines sol,
656: so_headers soh,
657: po_system_parameters psp
658: WHERE sol.original_system_line_reference = to_char(x_line_num)
659: AND soh.original_system_reference = x_segment1
660: AND sol.header_id = soh.header_id
661: AND soh.original_system_source_code = psp.order_source_id;