APPS.POR_UTIL_PKG2_TEST SQL Statements

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

Line: 29

                            p_last_update_date        OUT VARCHAR2,
                            p_approval_list_string    OUT VARCHAR2,
                            p_approval_list_count     OUT NUMBER,
                            p_quote_char              OUT VARCHAR2,
                            p_field_delimiter         OUT VARCHAR2,
                            p_return_code             OUT NUMBER,
                            p_error_stack_string      OUT VARCHAR2) IS
  l_approval_list           po_approvallist_s1.ApprovalListType;

Line: 39

  l_last_update_date        DATE;

Line: 79

      p_last_update_date=>l_last_update_date,
      p_approval_list=>l_approval_list);

Line: 82

    p_last_update_date := to_char(l_last_update_date, g_date_format_mask);

Line: 132

                             p_last_update_date        IN     VARCHAR2,
                             p_quote_char              IN     VARCHAR2,
                             p_field_delimiter         IN     VARCHAR2,
                             p_return_code             OUT    NUMBER,
                             p_error_stack_string      OUT    VARCHAR2) IS
  l_approval_list     po_approvallist_s1.ApprovalListType;

Line: 143

  l_last_update_date  DATE;

Line: 149

    l_last_update_date := NULL;

Line: 151

    IF (p_last_update_date IS NULL) THEN
      RETURN;

Line: 154

      l_last_update_date := to_date(p_last_update_date, g_date_format_mask);

Line: 245

      p_last_update_date=>l_last_update_date,
      p_approval_list_header_id=>p_approval_list_header_id,
      p_return_code=>l_return_code,
      p_error_stack=>l_error_stack);