APPS.IEM_MAILITEM_PUB_W SQL Statements

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

Line: 782

    p7_a25 := ddx_email_data.last_updated_by;

Line: 783

    p7_a26 := ddx_email_data.last_update_date;

Line: 784

    p7_a27 := ddx_email_data.last_update_login;

Line: 936

    p7_a25 := ddx_email_data.last_updated_by;

Line: 937

    p7_a26 := ddx_email_data.last_update_date;

Line: 938

    p7_a27 := ddx_email_data.last_update_login;

Line: 1077

    p5_a25 := ddx_email_data.last_updated_by;

Line: 1078

    p5_a26 := ddx_email_data.last_update_date;

Line: 1079

    p5_a27 := ddx_email_data.last_update_login;

Line: 1146

  procedure updatemailitem(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p3_a0  NUMBER
    , p3_a1  NUMBER
    , p3_a2  NUMBER
    , p3_a3  NUMBER
    , p3_a4  NUMBER
    , p3_a5  VARCHAR2
    , p3_a6  DATE
    , p3_a7  NUMBER
    , p3_a8  NUMBER
    , p3_a9  NUMBER
    , p3_a10  NUMBER
    , p3_a11  NUMBER
    , p3_a12  NUMBER
    , p3_a13  VARCHAR2
    , p3_a14  VARCHAR2
    , p3_a15  VARCHAR2
    , p3_a16  VARCHAR2
    , p3_a17  VARCHAR2
    , p3_a18  NUMBER
    , p3_a19  NUMBER
    , p3_a20  VARCHAR2
    , p3_a21  VARCHAR2
    , p3_a22  NUMBER
    , p3_a23  NUMBER
    , p3_a24  DATE
    , p3_a25  NUMBER
    , p3_a26  DATE
    , p3_a27  NUMBER
    , p3_a28  VARCHAR2
    , p3_a29  VARCHAR2
    , p3_a30  VARCHAR2
    , p3_a31  VARCHAR2
    , p3_a32  VARCHAR2
    , p3_a33  VARCHAR2
    , p3_a34  VARCHAR2
    , p3_a35  VARCHAR2
    , p3_a36  VARCHAR2
    , p3_a37  VARCHAR2
    , p3_a38  VARCHAR2
    , p3_a39  VARCHAR2
    , p3_a40  VARCHAR2
    , p3_a41  VARCHAR2
    , p3_a42  VARCHAR2
    , p3_a43  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_email_data iem_rt_proc_emails%rowtype;

Line: 1232

    ddp_email_data.last_updated_by := p3_a25;

Line: 1233

    ddp_email_data.last_update_date := rosetta_g_miss_date_in_map(p3_a26);

Line: 1234

    ddp_email_data.last_update_login := p3_a27;

Line: 1256

    iem_mailitem_pub.updatemailitem(p_api_version_number,
      p_init_msg_list,
      p_commit,
      ddp_email_data,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 1388

    p6_a25 := ddx_email_data.last_updated_by;

Line: 1389

    p6_a26 := ddx_email_data.last_update_date;

Line: 1390

    p6_a27 := ddx_email_data.last_update_login;

Line: 1640

    p7_a25 := ddx_email_data.last_updated_by;

Line: 1641

    p7_a26 := ddx_email_data.last_update_date;

Line: 1642

    p7_a27 := ddx_email_data.last_update_login;