APPS.OZF_CLAIMS_HISTORY_PVT_W SQL Statements

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

Line: 167

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a2(indx));

Line: 168

          t(ddindx).last_updated_by := a3(indx);

Line: 171

          t(ddindx).last_update_login := a6(indx);

Line: 174

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a9(indx));

Line: 905

          a2(indx) := t(ddindx).last_update_date;

Line: 906

          a3(indx) := t(ddindx).last_updated_by;

Line: 909

          a6(indx) := t(ddindx).last_update_login;

Line: 912

          a9(indx) := t(ddindx).program_update_date;

Line: 1226

    ddp_claims_history_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);

Line: 1227

    ddp_claims_history_rec.last_updated_by := p7_a3;

Line: 1230

    ddp_claims_history_rec.last_update_login := p7_a6;

Line: 1233

    ddp_claims_history_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a9);

Line: 1392

  procedure update_claims_history(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p7_a0  NUMBER
    , p7_a1  NUMBER
    , p7_a2  DATE
    , p7_a3  NUMBER
    , p7_a4  DATE
    , p7_a5  NUMBER
    , p7_a6  NUMBER
    , p7_a7  NUMBER
    , p7_a8  NUMBER
    , p7_a9  DATE
    , p7_a10  NUMBER
    , p7_a11  VARCHAR2
    , p7_a12  NUMBER
    , p7_a13  NUMBER
    , p7_a14  VARCHAR2
    , p7_a15  NUMBER
    , p7_a16  VARCHAR2
    , p7_a17  DATE
    , p7_a18  DATE
    , p7_a19  NUMBER
    , p7_a20  VARCHAR2
    , p7_a21  DATE
    , p7_a22  VARCHAR2
    , p7_a23  NUMBER
    , p7_a24  NUMBER
    , p7_a25  DATE
    , p7_a26  NUMBER
    , p7_a27  NUMBER
    , p7_a28  NUMBER
    , p7_a29  NUMBER
    , p7_a30  NUMBER
    , p7_a31  NUMBER
    , p7_a32  NUMBER
    , p7_a33  NUMBER
    , p7_a34  NUMBER
    , p7_a35  NUMBER
    , p7_a36  VARCHAR2
    , p7_a37  VARCHAR2
    , p7_a38  VARCHAR2
    , p7_a39  VARCHAR2
    , p7_a40  DATE
    , p7_a41  NUMBER
    , p7_a42  NUMBER
    , p7_a43  DATE
    , p7_a44  NUMBER
    , p7_a45  VARCHAR2
    , p7_a46  NUMBER
    , p7_a47  VARCHAR2
    , p7_a48  NUMBER
    , p7_a49  NUMBER
    , p7_a50  NUMBER
    , p7_a51  NUMBER
    , p7_a52  VARCHAR2
    , p7_a53  NUMBER
    , p7_a54  NUMBER
    , p7_a55  VARCHAR2
    , p7_a56  NUMBER
    , p7_a57  NUMBER
    , p7_a58  VARCHAR2
    , p7_a59  NUMBER
    , p7_a60  NUMBER
    , p7_a61  VARCHAR2
    , p7_a62  NUMBER
    , p7_a63  NUMBER
    , p7_a64  NUMBER
    , p7_a65  NUMBER
    , p7_a66  NUMBER
    , p7_a67  NUMBER
    , p7_a68  DATE
    , p7_a69  VARCHAR2
    , p7_a70  NUMBER
    , p7_a71  NUMBER
    , p7_a72  VARCHAR2
    , p7_a73  NUMBER
    , p7_a74  NUMBER
    , p7_a75  DATE
    , p7_a76  VARCHAR2
    , p7_a77  NUMBER
    , p7_a78  VARCHAR2
    , p7_a79  NUMBER
    , p7_a80  VARCHAR2
    , p7_a81  DATE
    , p7_a82  VARCHAR2
    , p7_a83  VARCHAR2
    , p7_a84  DATE
    , p7_a85  NUMBER
    , p7_a86  DATE
    , p7_a87  NUMBER
    , p7_a88  DATE
    , p7_a89  NUMBER
    , p7_a90  NUMBER
    , p7_a91  NUMBER
    , p7_a92  NUMBER
    , p7_a93  VARCHAR2
    , p7_a94  NUMBER
    , p7_a95  DATE
    , p7_a96  NUMBER
    , p7_a97  VARCHAR2
    , p7_a98  VARCHAR2
    , p7_a99  VARCHAR2
    , p7_a100  VARCHAR2
    , p7_a101  VARCHAR2
    , p7_a102  VARCHAR2
    , p7_a103  VARCHAR2
    , p7_a104  VARCHAR2
    , p7_a105  VARCHAR2
    , p7_a106  VARCHAR2
    , p7_a107  VARCHAR2
    , p7_a108  VARCHAR2
    , p7_a109  VARCHAR2
    , p7_a110  VARCHAR2
    , p7_a111  VARCHAR2
    , p7_a112  VARCHAR2
    , p7_a113  VARCHAR2
    , p7_a114  VARCHAR2
    , p7_a115  VARCHAR2
    , p7_a116  VARCHAR2
    , p7_a117  VARCHAR2
    , p7_a118  VARCHAR2
    , p7_a119  VARCHAR2
    , p7_a120  VARCHAR2
    , p7_a121  VARCHAR2
    , p7_a122  VARCHAR2
    , p7_a123  VARCHAR2
    , p7_a124  VARCHAR2
    , p7_a125  VARCHAR2
    , p7_a126  VARCHAR2
    , p7_a127  VARCHAR2
    , p7_a128  VARCHAR2
    , p7_a129  VARCHAR2
    , p7_a130  NUMBER
    , p7_a131  VARCHAR2
    , p7_a132  NUMBER
    , p7_a133  VARCHAR2
    , p7_a134  VARCHAR2
    , p7_a135  NUMBER
    , p7_a136  NUMBER
    , p7_a137  NUMBER
    , p7_a138  VARCHAR2
    , p7_a139  NUMBER
    , p7_a140  NUMBER
    , p7_a141  VARCHAR2
    , p7_a142  VARCHAR2
    , p7_a143  VARCHAR2
    , x_object_version_number out nocopy  NUMBER
  )

  as
    ddp_claims_history_rec ozf_claims_history_pvt.claims_history_rec_type;

Line: 1561

    ddp_claims_history_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);

Line: 1562

    ddp_claims_history_rec.last_updated_by := p7_a3;

Line: 1565

    ddp_claims_history_rec.last_update_login := p7_a6;

Line: 1568

    ddp_claims_history_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a9);

Line: 1706

    ozf_claims_history_pvt.update_claims_history(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_claims_history_rec,
      x_object_version_number);

Line: 1890

    ddp_claims_history_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a2);

Line: 1891

    ddp_claims_history_rec.last_updated_by := p3_a3;

Line: 1894

    ddp_claims_history_rec.last_update_login := p3_a6;

Line: 1897

    ddp_claims_history_rec.program_update_date := rosetta_g_miss_date_in_map(p3_a9);