DBA Data[Home] [Help]

APPS.CSP_RECEIVE_PVT_W SQL Statements

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

Line: 347

          t(ddindx).update_mln := a144(indx);
Line: 375

          t(ddindx).update_msn := a172(indx);
Line: 1325

          a144(indx) := t(ddindx).update_mln;
Line: 1353

          a172(indx) := t(ddindx).update_msn;
Line: 1857

  procedure insert_rcv_txn_interface(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
    , x_interface_transaction_id out nocopy  NUMBER
    , p8_a0  NUMBER
    , p8_a1  NUMBER
    , p8_a2  NUMBER
    , p8_a3  NUMBER
    , p8_a4  NUMBER
    , p8_a5  VARCHAR2
    , p8_a6  VARCHAR2
    , p8_a7  VARCHAR2
    , p8_a8  VARCHAR2
    , p8_a9  NUMBER
    , p8_a10  VARCHAR2
    , p8_a11  NUMBER
    , p8_a12  NUMBER
    , p8_a13  NUMBER
    , p8_a14  NUMBER
    , p8_a15  NUMBER
    , p8_a16  NUMBER
    , p8_a17  NUMBER
    , p8_a18  VARCHAR2
    , p8_a19  NUMBER
    , p8_a20  NUMBER
    , p8_a21  NUMBER
    , p8_a22  NUMBER
    , p8_a23  VARCHAR2
    , p8_a24  NUMBER
    , p8_a25  NUMBER
    , p8_a26  NUMBER
    , p8_a27  NUMBER
    , p8_a28  NUMBER
    , p8_a29  VARCHAR2
    , p8_a30  NUMBER
    , p8_a31  VARCHAR2
    , p8_a32  VARCHAR2
    , p8_a33  NUMBER
    , p8_a34  VARCHAR2
    , p8_a35  VARCHAR2
    , p8_a36  VARCHAR2
    , p8_a37  NUMBER
    , p8_a38  NUMBER
    , p8_a39  VARCHAR2
    , p8_a40  VARCHAR2
    , p8_a41  NUMBER
    , p8_a42  NUMBER
    , p8_a43  NUMBER
    , p8_a44  NUMBER
    , p8_a45  VARCHAR2
    , p8_a46  VARCHAR2
    , p8_a47  VARCHAR2
    , p8_a48  VARCHAR2
    , p8_a49  VARCHAR2
    , p8_a50  NUMBER
    , p8_a51  VARCHAR2
    , p8_a52  VARCHAR2
    , p8_a53  VARCHAR2
    , p8_a54  NUMBER
    , p8_a55  VARCHAR2
    , p8_a56  VARCHAR2
    , p8_a57  NUMBER
    , p8_a58  VARCHAR2
    , p8_a59  DATE
    , p8_a60  DATE
    , p8_a61  NUMBER
    , p8_a62  VARCHAR2
    , p8_a63  VARCHAR2
    , p8_a64  VARCHAR2
    , p8_a65  VARCHAR2
    , p8_a66  VARCHAR2
    , p8_a67  VARCHAR2
    , p8_a68  VARCHAR2
    , p8_a69  NUMBER
    , p8_a70  VARCHAR2
    , p8_a71  VARCHAR2
    , p8_a72  DATE
    , p8_a73  NUMBER
    , p8_a74  VARCHAR2
    , p8_a75  VARCHAR2
    , p8_a76  NUMBER
    , p8_a77  NUMBER
    , p8_a78  VARCHAR2
    , p8_a79  VARCHAR2
    , p8_a80  VARCHAR2
    , p8_a81  VARCHAR2
    , p8_a82  VARCHAR2
    , p8_a83  VARCHAR2
    , p8_a84  VARCHAR2
    , p8_a85  VARCHAR2
    , p8_a86  VARCHAR2
    , p8_a87  VARCHAR2
    , p8_a88  VARCHAR2
    , p8_a89  VARCHAR2
    , p8_a90  VARCHAR2
    , p8_a91  VARCHAR2
    , p8_a92  VARCHAR2
    , p8_a93  VARCHAR2
    , p8_a94  VARCHAR2
    , p8_a95  VARCHAR2
    , p8_a96  VARCHAR2
    , p8_a97  VARCHAR2
    , p8_a98  DATE
    , p8_a99  VARCHAR2
    , p8_a100  VARCHAR2
    , p8_a101  VARCHAR2
    , p8_a102  VARCHAR2
    , p8_a103  VARCHAR2
    , p8_a104  VARCHAR2
    , p8_a105  VARCHAR2
    , p8_a106  VARCHAR2
    , p8_a107  VARCHAR2
    , p8_a108  VARCHAR2
    , p8_a109  NUMBER
    , p8_a110  NUMBER
    , p8_a111  NUMBER
    , p8_a112  NUMBER
    , p8_a113  NUMBER
    , p8_a114  NUMBER
    , p8_a115  VARCHAR2
    , p8_a116  VARCHAR2
    , p8_a117  NUMBER
    , p8_a118  NUMBER
    , p8_a119  NUMBER
    , p8_a120  NUMBER
    , p8_a121  NUMBER
    , p8_a122  NUMBER
    , p8_a123  NUMBER
    , p8_a124  NUMBER
    , p8_a125  VARCHAR2
    , p8_a126  VARCHAR2
    , p8_a127  NUMBER
    , p8_a128  DATE
    , p8_a129  NUMBER
    , p8_a130  NUMBER
    , p8_a131  NUMBER
    , p8_a132  NUMBER
    , p8_a133  VARCHAR2
    , p8_a134  NUMBER
    , p8_a135  VARCHAR2
    , p8_a136  NUMBER
    , p8_a137  NUMBER
    , p8_a138  NUMBER
    , p8_a139  DATE
    , p8_a140  NUMBER
    , p8_a141  NUMBER
    , p8_a142  VARCHAR2
    , p8_a143  VARCHAR2
    , p8_a144  VARCHAR2
    , p8_a145  VARCHAR2
    , p8_a146  VARCHAR2
    , p8_a147  VARCHAR2
    , p8_a148  DATE
    , p8_a149  VARCHAR2
    , p8_a150  VARCHAR2
    , p8_a151  DATE
    , p8_a152  DATE
    , p8_a153  DATE
    , p8_a154  NUMBER
    , p8_a155  NUMBER
    , p8_a156  VARCHAR2
    , p8_a157  NUMBER
    , p8_a158  VARCHAR2
    , p8_a159  VARCHAR2
    , p8_a160  DATE
    , p8_a161  NUMBER
    , p8_a162  VARCHAR2
    , p8_a163  NUMBER
    , p8_a164  NUMBER
    , p8_a165  VARCHAR2
    , p8_a166  NUMBER
    , p8_a167  VARCHAR2
    , p8_a168  VARCHAR2
    , p8_a169  VARCHAR2
    , p8_a170  VARCHAR2
    , p8_a171  VARCHAR2
    , p8_a172  VARCHAR2
    , p8_a173  VARCHAR2
    , p8_a174  VARCHAR2
    , p8_a175  VARCHAR2
    , p8_a176  NUMBER
    , p8_a177  NUMBER
    , p8_a178  NUMBER
    , p8_a179  NUMBER
    , p8_a180  NUMBER
    , p8_a181  NUMBER
    , p8_a182  NUMBER
    , p8_a183  NUMBER
    , p8_a184  NUMBER
    , p8_a185  NUMBER
    , p8_a186  NUMBER
    , p8_a187  NUMBER
    , p8_a188  NUMBER
    , p8_a189  VARCHAR2
    , p8_a190  VARCHAR2
    , p8_a191  VARCHAR2
  )

  as
    ddp_receive_rec csp_receive_pvt.rcv_rec_type;
Line: 2217

    ddp_receive_rec.update_mln := p8_a144;
Line: 2245

    ddp_receive_rec.update_msn := p8_a172;
Line: 2267

    csp_receive_pvt.insert_rcv_txn_interface(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      x_interface_transaction_id,
      ddp_receive_rec);