DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_PREPROC_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 218

            SELECT document_type_code,
                   document_subtype,
                   nvl(interface_source_code,'NOCODE'),
                   action,
                   group_code,
                   document_num,
        		   process_code,
                   draft_id
              INTO PO_AUTOCREATE_PARAMS.g_document_type,
                   PO_AUTOCREATE_PARAMS.g_document_subtype,
                   PO_AUTOCREATE_PARAMS.g_interface_source_code,
                   PO_AUTOCREATE_PARAMS.g_mode,
                   PO_AUTOCREATE_PARAMS.g_group_code,
                   PO_AUTOCREATE_PARAMS.g_old_document_num,
		           PO_AUTOCREATE_PARAMS.g_process_code,   -- Add to modification project
                   PO_AUTOCREATE_PARAMS.g_draft_id -- CLM Phase2 autocreate grouping.
                   /*now the draft id is populated from UI.
                     this draft_id will be used all along*/
              FROM po_headers_interface
             WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;