APPS.IEM_EML_CLASSIFICATIONS_PVT_W SQL Statements

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

Line: 79

    , p_last_updated_by  NUMBER
    , p_last_update_date  date
    , p_last_update_login  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_creation_date date;

Line: 89

    ddp_last_update_date date;

Line: 105

    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 121

      p_last_updated_by,
      ddp_last_update_date,
      p_last_update_login,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 267

    , p_last_updated_by  NUMBER
    , p_last_update_date  date
    , p_last_update_login  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_creation_date date;

Line: 277

    ddp_last_update_date date;

Line: 294

    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 311

      p_last_updated_by,
      ddp_last_update_date,
      p_last_update_login,
      x_return_status,
      x_msg_count,
      x_msg_data);