DBA Data[Home] [Help]

APPS.PO_POXRQDDR_XMLP_PKG dependencies on PO_SYSTEM_PARAMETERS

Line 130: from po_system_parameters psp;

126: begin
127:
128: select psp.manual_req_num_type
129: into numbering_type
130: from po_system_parameters psp;
131:
132: if (numbering_type = 'NUMERIC') then
133: RETURN (' AND decode(rtrim(prh.segment1,''0123456789''),NULL,to_number(prh.segment1),-1)
134: BETWEEN decode(rtrim(nvl('||''''||p_req_num_from||''''||',prh.segment1),''0123456789''),NULL,to_number(nvl('||''''||p_req_num_from||''''||',prh.segment1)),-1)