APPS.AP_WEB_DB_VIOLATIONS_PKG SQL Statements

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

Line: 5

PROCEDURE deleteViolationEntry(
        p_report_header_id      IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS
-------------------------------------------------------------------------------
  l_debug_info	     VARCHAR2(200);

Line: 11

  DELETE
  FROM	 ap_pol_violations
  WHERE	 report_header_id = p_report_header_id;

Line: 17

    AP_WEB_DB_UTIL_PKG.RaiseException('deleteViolationEntry');

Line: 19

END deleteViolationEntry;

Line: 22

FUNCTION updateViolationsHeaderId(
p_ReportHeaderID           IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
p_newReportHeaderID        IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)
RETURN BOOLEAN IS
--------------------------------------------------------------------------------
BEGIN
        -- set the report_header_id for the line

        UPDATE ap_pol_violations
        SET    report_header_id = p_newReportHeaderID
        WHERE  report_header_id = p_ReportHeaderID
        AND    distribution_line_number IN(
          SELECT distribution_line_number
          FROM   ap_expense_report_lines
          WHERE  report_header_id = p_newReportHeaderID);

Line: 43

    AP_WEB_DB_UTIL_PKG.RaiseException('updateViolationsHeaderId');

Line: 46

END updateViolationsHeaderId;

Line: 57

  UPDATE ap_pol_violations
  SET	 report_header_id = p_new_report_header_id
  WHERE  distribution_line_number IN
      (select distribution_line_number
       from   ap_expense_report_lines
       where  report_header_id = p_new_report_header_id
       and   ( nvl(policy_shortpay_flag,'N') = 'Y'
               or
              (itemization_parent_id in
                  (select report_line_id
                   from   ap_expense_report_lines
                   where  report_header_id = p_new_report_header_id
                   and    nvl(policy_shortpay_flag,'N') = 'Y'
                   and    itemization_parent_id = -1
                  )
              )
            ))
  AND    report_header_id = p_orig_expense_report_id;

Line: 92

  UPDATE ap_pol_violations
  SET	 report_header_id = p_new_report_header_id
  WHERE  distribution_line_number IN
      (select distribution_line_number
       from   ap_expense_report_lines
       where  report_header_id = p_new_report_header_id
       and    ((receipt_required_flag = 'Y'
                and    nvl(receipt_verified_flag,'N') = 'N'
                and    nvl(policy_shortpay_flag, 'N') = 'N'
               )
               or
               (itemization_parent_id in
                 (select report_line_id
                  from   ap_expense_report_lines
                  where  report_header_id = p_new_report_header_id
                  and    receipt_required_flag = 'Y'
                  and    nvl(receipt_verified_flag,'N') = 'N'
                  and    nvl(policy_shortpay_flag, 'N') = 'N'
                  and    itemization_parent_id = -1
                 )
               )
              ))
  AND    report_header_id = p_orig_expense_report_id;

Line: 133

  UPDATE ap_pol_violations
  SET	 report_header_id = p_new_report_header_id
  WHERE  distribution_line_number IN
     (SELECT distribution_line_number
      FROM   ap_expense_report_lines
      WHERE  report_header_id = p_orig_expense_report_id
      AND    credit_card_trx_id IS NOT NULL)
  AND    report_header_id = p_orig_expense_report_id;