APPS.PO_DOCS_INTERFACE_SV5 SQL Statements

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

Line: 14

                        X_selected_batch_id            IN  NUMBER,
                        X_buyer_id                  IN  NUMBER,
                        X_document_type               IN	VARCHAR2,
                        X_document_subtype            IN    VARCHAR2,
                        X_create_items                IN  VARCHAR2,
                        X_create_sourcing_rules_flag  IN  VARCHAR2,
                        X_rel_gen_method            IN   VARCHAR2,
                        X_approved_status            IN  VARCHAR2,
                        X_commit_interval            IN  NUMBER,
                        X_process_code              IN  VARCHAR2, -- can be 'PENDING' or 'NOTIFIED'
                        X_interface_header_id         IN    NUMBER ,
                        X_org_id_param                IN    NUMBER ,
                        X_ga_flag                     IN    VARCHAR2,
----
                        p_sourcing_level          IN    VARCHAR2 DEFAULT NULL,
                        p_inv_org_id               IN    PO_HEADERS_INTERFACE.org_id%type DEFAULT NULL
----
                        )   -- FPI GA

IS

d_api_name CONSTANT VARCHAR2(30) := 'process_po_headers_interface';

Line: 59

    p_selected_batch_id => x_selected_batch_id,
    p_batch_size => PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE,
    p_buyer_id => x_buyer_id,
    p_document_type => x_document_type,
    p_document_subtype => x_document_subtype,
    p_create_items => x_create_items,
    p_create_sourcing_rules_flag => x_create_sourcing_rules_flag,
    p_rel_gen_method => x_rel_gen_method,
    p_sourcing_level => p_sourcing_level,
    p_sourcing_inv_org_id => p_inv_org_id,
    p_approved_status => x_approved_status,
    p_process_code => x_process_code,
    p_interface_header_id => x_interface_header_id,
    p_org_id => x_org_id_param,
    p_ga_flag => x_ga_flag
  );