APPS.OZF_OFFER_PVT_W SQL Statements

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

Line: 1998

  procedure update_offer_status(p_commit  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p4_a0  NUMBER := 0-1962.0724
    , p4_a1  NUMBER := 0-1962.0724
    , p4_a2  VARCHAR2 := fnd_api.g_miss_char
    , p4_a3  VARCHAR2 := fnd_api.g_miss_char
    , p4_a4  NUMBER := 0-1962.0724
    , p4_a5  VARCHAR2 := fnd_api.g_miss_char
    , p4_a6  NUMBER := 0-1962.0724
    , p4_a7  NUMBER := 0-1962.0724
    , p4_a8  VARCHAR2 := fnd_api.g_miss_char
    , p4_a9  VARCHAR2 := fnd_api.g_miss_char
    , p4_a10  NUMBER := 0-1962.0724
    , p4_a11  NUMBER := 0-1962.0724
    , p4_a12  DATE := fnd_api.g_miss_date
    , p4_a13  DATE := fnd_api.g_miss_date
    , p4_a14  VARCHAR2 := fnd_api.g_miss_char
    , p4_a15  DATE := fnd_api.g_miss_date
    , p4_a16  VARCHAR2 := fnd_api.g_miss_char
    , p4_a17  VARCHAR2 := fnd_api.g_miss_char
    , p4_a18  NUMBER := 0-1962.0724
    , p4_a19  VARCHAR2 := fnd_api.g_miss_char
    , p4_a20  NUMBER := 0-1962.0724
    , p4_a21  NUMBER := 0-1962.0724
    , p4_a22  NUMBER := 0-1962.0724
    , p4_a23  NUMBER := 0-1962.0724
    , p4_a24  VARCHAR2 := fnd_api.g_miss_char
    , p4_a25  VARCHAR2 := fnd_api.g_miss_char
    , p4_a26  VARCHAR2 := fnd_api.g_miss_char
    , p4_a27  VARCHAR2 := fnd_api.g_miss_char
    , p4_a28  VARCHAR2 := fnd_api.g_miss_char
    , p4_a29  VARCHAR2 := fnd_api.g_miss_char
    , p4_a30  VARCHAR2 := fnd_api.g_miss_char
    , p4_a31  VARCHAR2 := fnd_api.g_miss_char
    , p4_a32  VARCHAR2 := fnd_api.g_miss_char
    , p4_a33  VARCHAR2 := fnd_api.g_miss_char
    , p4_a34  VARCHAR2 := fnd_api.g_miss_char
    , p4_a35  VARCHAR2 := fnd_api.g_miss_char
    , p4_a36  VARCHAR2 := fnd_api.g_miss_char
    , p4_a37  VARCHAR2 := fnd_api.g_miss_char
    , p4_a38  VARCHAR2 := fnd_api.g_miss_char
    , p4_a39  VARCHAR2 := fnd_api.g_miss_char
    , p4_a40  VARCHAR2 := fnd_api.g_miss_char
    , p4_a41  VARCHAR2 := fnd_api.g_miss_char
    , p4_a42  VARCHAR2 := fnd_api.g_miss_char
    , p4_a43  DATE := fnd_api.g_miss_date
    , p4_a44  DATE := fnd_api.g_miss_date
    , p4_a45  VARCHAR2 := fnd_api.g_miss_char
    , p4_a46  VARCHAR2 := fnd_api.g_miss_char
    , p4_a47  VARCHAR2 := fnd_api.g_miss_char
    , p4_a48  VARCHAR2 := fnd_api.g_miss_char
    , p4_a49  VARCHAR2 := fnd_api.g_miss_char
    , p4_a50  VARCHAR2 := fnd_api.g_miss_char
    , p4_a51  DATE := fnd_api.g_miss_date
    , p4_a52  DATE := fnd_api.g_miss_date
    , p4_a53  VARCHAR2 := fnd_api.g_miss_char
    , p4_a54  DATE := fnd_api.g_miss_date
    , p4_a55  DATE := fnd_api.g_miss_date
    , p4_a56  VARCHAR2 := fnd_api.g_miss_char
    , p4_a57  VARCHAR2 := fnd_api.g_miss_char
    , p4_a58  NUMBER := 0-1962.0724
    , p4_a59  NUMBER := 0-1962.0724
    , p4_a60  VARCHAR2 := fnd_api.g_miss_char
    , p4_a61  NUMBER := 0-1962.0724
    , p4_a62  VARCHAR2 := fnd_api.g_miss_char
    , p4_a63  VARCHAR2 := fnd_api.g_miss_char
    , p4_a64  NUMBER := 0-1962.0724
    , p4_a65  VARCHAR2 := fnd_api.g_miss_char
    , p4_a66  NUMBER := 0-1962.0724
    , p4_a67  NUMBER := 0-1962.0724
    , p4_a68  VARCHAR2 := fnd_api.g_miss_char
    , p4_a69  VARCHAR2 := fnd_api.g_miss_char
    , p4_a70  VARCHAR2 := fnd_api.g_miss_char
    , p4_a71  VARCHAR2 := fnd_api.g_miss_char
    , p4_a72  VARCHAR2 := fnd_api.g_miss_char
    , p4_a73  VARCHAR2 := fnd_api.g_miss_char
    , p4_a74  VARCHAR2 := fnd_api.g_miss_char
    , p4_a75  VARCHAR2 := fnd_api.g_miss_char
    , p4_a76  VARCHAR2 := fnd_api.g_miss_char
    , p4_a77  VARCHAR2 := fnd_api.g_miss_char
    , p4_a78  VARCHAR2 := fnd_api.g_miss_char
    , p4_a79  NUMBER := 0-1962.0724
    , p4_a80  VARCHAR2 := fnd_api.g_miss_char
    , p4_a81  VARCHAR2 := fnd_api.g_miss_char
    , p4_a82  NUMBER := 0-1962.0724
    , p4_a83  VARCHAR2 := fnd_api.g_miss_char
    , p4_a84  NUMBER := 0-1962.0724
  )

  as
    ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

Line: 2186

    ozf_offer_pvt.update_offer_status(p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_modifier_list_rec);