DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT_OA SQL Statements

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

Line: 2229

  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
    , p4_a1  NUMBER
    , p4_a2  VARCHAR2
    , p4_a3  VARCHAR2
    , p4_a4  NUMBER
    , p4_a5  VARCHAR2
    , p4_a6  NUMBER
    , p4_a7  NUMBER
    , p4_a8  VARCHAR2
    , p4_a9  VARCHAR2
    , p4_a10  NUMBER
    , p4_a11  NUMBER
    , p4_a12  DATE
    , p4_a13  DATE
    , p4_a14  VARCHAR2
    , p4_a15  DATE
    , p4_a16  VARCHAR2
    , p4_a17  VARCHAR2
    , p4_a18  NUMBER
    , p4_a19  VARCHAR2
    , p4_a20  NUMBER
    , p4_a21  NUMBER
    , p4_a22  NUMBER
    , p4_a23  NUMBER
    , p4_a24  VARCHAR2
    , p4_a25  VARCHAR2
    , p4_a26  VARCHAR2
    , p4_a27  VARCHAR2
    , p4_a28  VARCHAR2
    , p4_a29  VARCHAR2
    , p4_a30  VARCHAR2
    , p4_a31  VARCHAR2
    , p4_a32  VARCHAR2
    , p4_a33  VARCHAR2
    , p4_a34  VARCHAR2
    , p4_a35  VARCHAR2
    , p4_a36  VARCHAR2
    , p4_a37  VARCHAR2
    , p4_a38  VARCHAR2
    , p4_a39  VARCHAR2
    , p4_a40  VARCHAR2
    , p4_a41  VARCHAR2
    , p4_a42  VARCHAR2
    , p4_a43  DATE
    , p4_a44  DATE
    , p4_a45  VARCHAR2
    , p4_a46  VARCHAR2
    , p4_a47  VARCHAR2
    , p4_a48  VARCHAR2
    , p4_a49  VARCHAR2
    , p4_a50  VARCHAR2
    , p4_a51  DATE
    , p4_a52  DATE
    , p4_a53  VARCHAR2
    , p4_a54  DATE
    , p4_a55  DATE
    , p4_a56  VARCHAR2
    , p4_a57  VARCHAR2
    , p4_a58  NUMBER
    , p4_a59  NUMBER
    , p4_a60  VARCHAR2
    , p4_a61  NUMBER
    , p4_a62  VARCHAR2
    , p4_a63  VARCHAR2
    , p4_a64  NUMBER
    , p4_a65  VARCHAR2
    , p4_a66  NUMBER
    , p4_a67  NUMBER
    , p4_a68  VARCHAR2
    , p4_a69  VARCHAR2
    , p4_a70  VARCHAR2
    , p4_a71  VARCHAR2
    , p4_a72  VARCHAR2
    , p4_a73  VARCHAR2
    , p4_a74  VARCHAR2
    , p4_a75  VARCHAR2
    , p4_a76  VARCHAR2
    , p4_a77  VARCHAR2
    , p4_a78  VARCHAR2
    , p4_a79  NUMBER
    , p4_a80  VARCHAR2
    , p4_a81  VARCHAR2
    , p4_a82  NUMBER
  )

  as
    ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
Line: 2413

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