APPS.AP_WEB_DB_EXP_ATTENDEES_PKG SQL Statements

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

Line: 5

PROCEDURE DeleteAttendees(P_ReportID             IN NUMBER) IS
--------------------------------------------------------------------------------
  l_temp    OIE_ATTENDEES.EMPLOYEE_FLAG%type;

Line: 8

  l_curr_calling_sequence VARCHAR2(100) := 'DeleteAttendees';

Line: 15

    SELECT EMPLOYEE_FLAG
      FROM OIE_ATTENDEES oat, AP_EXPENSE_REPORT_LINES el
      WHERE (el.REPORT_HEADER_ID = P_ReportID AND
             el.REPORT_LINE_ID = oat.REPORT_LINE_ID)
      FOR UPDATE OF EMPLOYEE_FLAG NOWAIT;

Line: 32

    DELETE OIE_ATTENDEES WHERE CURRENT OF ExpAttendees;

Line: 42

    AP_WEB_DB_UTIL_PKG.RaiseException('DeleteAttendees');

Line: 44

END DeleteAttendees;

Line: 54

     SELECT ATTENDEE_LINE_ID
     FROM OIE_ATTENDEES
     WHERE REPORT_LINE_ID = p_source_report_line_id;

Line: 71

    SELECT OIE_ATTENDEES_S.NEXTVAL
    INTO l_new_attendee_id
    FROM DUAL;

Line: 76

   INSERT INTO OIE_ATTENDEES
    (
      ATTENDEE_LINE_ID,
      REPORT_LINE_ID,
      EMPLOYEE_FLAG,
      EMPLOYEE_ID,
      ATTENDEE_TYPE,
      NAME,
      TITLE,
      EMPLOYER,
      EMPLOYER_ADDRESS,
      TAX_ID,
      ORG_ID,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY
     )
    SELECT l_new_attendee_id AS ATTENDEE_LINE_ID,
           p_target_report_line_id AS REPORT_LINE_ID,
           EMPLOYEE_FLAG,
	   EMPLOYEE_ID,
           ATTENDEE_TYPE,
           NAME,
           TITLE,
           EMPLOYER,
           EMPLOYER_ADDRESS,
           TAX_ID,
           ORG_ID,
           sysdate AS CREATION_DATE,
           p_user_id AS CREATED_BY,
           sysdate AS LAST_UPDATE_DATE,
           p_user_id AS LAST_UPDATED_BY
    FROM  OIE_ATTENDEES
    WHERE ATTENDEE_LINE_ID = l_attendee_id;