DBA Data[Home] [Help]

APPS.CSI_PRICING_ATTRIBS_PUB_W SQL Statements

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

Line: 867

  procedure update_pricing_attribs(p_api_version  NUMBER
    , p_commit  VARCHAR2
    , p_init_msg_list  VARCHAR2
    , p_validation_level  NUMBER
    , p4_a0 JTF_NUMBER_TABLE
    , p4_a1 JTF_NUMBER_TABLE
    , p4_a2 JTF_DATE_TABLE
    , p4_a3 JTF_DATE_TABLE
    , p4_a4 JTF_VARCHAR2_TABLE_100
    , p4_a5 JTF_VARCHAR2_TABLE_200
    , p4_a6 JTF_VARCHAR2_TABLE_200
    , p4_a7 JTF_VARCHAR2_TABLE_200
    , p4_a8 JTF_VARCHAR2_TABLE_200
    , p4_a9 JTF_VARCHAR2_TABLE_200
    , p4_a10 JTF_VARCHAR2_TABLE_200
    , p4_a11 JTF_VARCHAR2_TABLE_200
    , p4_a12 JTF_VARCHAR2_TABLE_200
    , p4_a13 JTF_VARCHAR2_TABLE_200
    , p4_a14 JTF_VARCHAR2_TABLE_200
    , p4_a15 JTF_VARCHAR2_TABLE_200
    , p4_a16 JTF_VARCHAR2_TABLE_200
    , p4_a17 JTF_VARCHAR2_TABLE_200
    , p4_a18 JTF_VARCHAR2_TABLE_200
    , p4_a19 JTF_VARCHAR2_TABLE_200
    , p4_a20 JTF_VARCHAR2_TABLE_200
    , p4_a21 JTF_VARCHAR2_TABLE_200
    , p4_a22 JTF_VARCHAR2_TABLE_200
    , p4_a23 JTF_VARCHAR2_TABLE_200
    , p4_a24 JTF_VARCHAR2_TABLE_300
    , p4_a25 JTF_VARCHAR2_TABLE_200
    , p4_a26 JTF_VARCHAR2_TABLE_200
    , p4_a27 JTF_VARCHAR2_TABLE_200
    , p4_a28 JTF_VARCHAR2_TABLE_200
    , p4_a29 JTF_VARCHAR2_TABLE_200
    , p4_a30 JTF_VARCHAR2_TABLE_200
    , p4_a31 JTF_VARCHAR2_TABLE_200
    , p4_a32 JTF_VARCHAR2_TABLE_200
    , p4_a33 JTF_VARCHAR2_TABLE_200
    , p4_a34 JTF_VARCHAR2_TABLE_200
    , p4_a35 JTF_VARCHAR2_TABLE_200
    , p4_a36 JTF_VARCHAR2_TABLE_200
    , p4_a37 JTF_VARCHAR2_TABLE_200
    , p4_a38 JTF_VARCHAR2_TABLE_200
    , p4_a39 JTF_VARCHAR2_TABLE_200
    , p4_a40 JTF_VARCHAR2_TABLE_200
    , p4_a41 JTF_VARCHAR2_TABLE_200
    , p4_a42 JTF_VARCHAR2_TABLE_200
    , p4_a43 JTF_VARCHAR2_TABLE_200
    , p4_a44 JTF_VARCHAR2_TABLE_200
    , p4_a45 JTF_VARCHAR2_TABLE_200
    , p4_a46 JTF_VARCHAR2_TABLE_200
    , p4_a47 JTF_VARCHAR2_TABLE_200
    , p4_a48 JTF_VARCHAR2_TABLE_200
    , p4_a49 JTF_VARCHAR2_TABLE_200
    , p4_a50 JTF_VARCHAR2_TABLE_200
    , p4_a51 JTF_VARCHAR2_TABLE_200
    , p4_a52 JTF_VARCHAR2_TABLE_200
    , p4_a53 JTF_VARCHAR2_TABLE_200
    , p4_a54 JTF_VARCHAR2_TABLE_200
    , p4_a55 JTF_VARCHAR2_TABLE_200
    , p4_a56 JTF_VARCHAR2_TABLE_200
    , p4_a57 JTF_VARCHAR2_TABLE_200
    , p4_a58 JTF_VARCHAR2_TABLE_200
    , p4_a59 JTF_VARCHAR2_TABLE_200
    , p4_a60 JTF_VARCHAR2_TABLE_200
    , p4_a61 JTF_VARCHAR2_TABLE_200
    , p4_a62 JTF_VARCHAR2_TABLE_200
    , p4_a63 JTF_VARCHAR2_TABLE_200
    , p4_a64 JTF_VARCHAR2_TABLE_200
    , p4_a65 JTF_VARCHAR2_TABLE_200
    , p4_a66 JTF_VARCHAR2_TABLE_200
    , p4_a67 JTF_VARCHAR2_TABLE_200
    , p4_a68 JTF_VARCHAR2_TABLE_200
    , p4_a69 JTF_VARCHAR2_TABLE_200
    , p4_a70 JTF_VARCHAR2_TABLE_200
    , p4_a71 JTF_VARCHAR2_TABLE_200
    , p4_a72 JTF_VARCHAR2_TABLE_200
    , p4_a73 JTF_VARCHAR2_TABLE_200
    , p4_a74 JTF_VARCHAR2_TABLE_200
    , p4_a75 JTF_VARCHAR2_TABLE_200
    , p4_a76 JTF_VARCHAR2_TABLE_200
    , p4_a77 JTF_VARCHAR2_TABLE_200
    , p4_a78 JTF_VARCHAR2_TABLE_200
    , p4_a79 JTF_VARCHAR2_TABLE_200
    , p4_a80 JTF_VARCHAR2_TABLE_200
    , p4_a81 JTF_VARCHAR2_TABLE_200
    , p4_a82 JTF_VARCHAR2_TABLE_200
    , p4_a83 JTF_VARCHAR2_TABLE_200
    , p4_a84 JTF_VARCHAR2_TABLE_200
    , p4_a85 JTF_VARCHAR2_TABLE_200
    , p4_a86 JTF_VARCHAR2_TABLE_200
    , p4_a87 JTF_VARCHAR2_TABLE_200
    , p4_a88 JTF_VARCHAR2_TABLE_200
    , p4_a89 JTF_VARCHAR2_TABLE_200
    , p4_a90 JTF_VARCHAR2_TABLE_200
    , p4_a91 JTF_VARCHAR2_TABLE_200
    , p4_a92 JTF_VARCHAR2_TABLE_200
    , p4_a93 JTF_VARCHAR2_TABLE_200
    , p4_a94 JTF_VARCHAR2_TABLE_200
    , p4_a95 JTF_VARCHAR2_TABLE_200
    , p4_a96 JTF_VARCHAR2_TABLE_200
    , p4_a97 JTF_VARCHAR2_TABLE_200
    , p4_a98 JTF_VARCHAR2_TABLE_200
    , p4_a99 JTF_VARCHAR2_TABLE_200
    , p4_a100 JTF_VARCHAR2_TABLE_200
    , p4_a101 JTF_VARCHAR2_TABLE_200
    , p4_a102 JTF_VARCHAR2_TABLE_200
    , p4_a103 JTF_VARCHAR2_TABLE_200
    , p4_a104 JTF_VARCHAR2_TABLE_200
    , p4_a105 JTF_VARCHAR2_TABLE_100
    , p4_a106 JTF_VARCHAR2_TABLE_200
    , p4_a107 JTF_VARCHAR2_TABLE_200
    , p4_a108 JTF_VARCHAR2_TABLE_200
    , p4_a109 JTF_VARCHAR2_TABLE_200
    , p4_a110 JTF_VARCHAR2_TABLE_200
    , p4_a111 JTF_VARCHAR2_TABLE_200
    , p4_a112 JTF_VARCHAR2_TABLE_200
    , p4_a113 JTF_VARCHAR2_TABLE_200
    , p4_a114 JTF_VARCHAR2_TABLE_200
    , p4_a115 JTF_VARCHAR2_TABLE_200
    , p4_a116 JTF_VARCHAR2_TABLE_200
    , p4_a117 JTF_VARCHAR2_TABLE_200
    , p4_a118 JTF_VARCHAR2_TABLE_200
    , p4_a119 JTF_VARCHAR2_TABLE_200
    , p4_a120 JTF_VARCHAR2_TABLE_200
    , p4_a121 JTF_NUMBER_TABLE
    , p4_a122 JTF_NUMBER_TABLE
    , p5_a0 in out nocopy  NUMBER
    , p5_a1 in out nocopy  DATE
    , p5_a2 in out nocopy  DATE
    , p5_a3 in out nocopy  NUMBER
    , p5_a4 in out nocopy  NUMBER
    , p5_a5 in out nocopy  NUMBER
    , p5_a6 in out nocopy  VARCHAR2
    , p5_a7 in out nocopy  NUMBER
    , p5_a8 in out nocopy  VARCHAR2
    , p5_a9 in out nocopy  NUMBER
    , p5_a10 in out nocopy  VARCHAR2
    , p5_a11 in out nocopy  NUMBER
    , p5_a12 in out nocopy  NUMBER
    , p5_a13 in out nocopy  NUMBER
    , p5_a14 in out nocopy  NUMBER
    , p5_a15 in out nocopy  VARCHAR2
    , p5_a16 in out nocopy  NUMBER
    , p5_a17 in out nocopy  VARCHAR2
    , p5_a18 in out nocopy  VARCHAR2
    , p5_a19 in out nocopy  NUMBER
    , p5_a20 in out nocopy  VARCHAR2
    , p5_a21 in out nocopy  VARCHAR2
    , p5_a22 in out nocopy  VARCHAR2
    , p5_a23 in out nocopy  VARCHAR2
    , p5_a24 in out nocopy  VARCHAR2
    , p5_a25 in out nocopy  VARCHAR2
    , p5_a26 in out nocopy  VARCHAR2
    , p5_a27 in out nocopy  VARCHAR2
    , p5_a28 in out nocopy  VARCHAR2
    , p5_a29 in out nocopy  VARCHAR2
    , p5_a30 in out nocopy  VARCHAR2
    , p5_a31 in out nocopy  VARCHAR2
    , p5_a32 in out nocopy  VARCHAR2
    , p5_a33 in out nocopy  VARCHAR2
    , p5_a34 in out nocopy  VARCHAR2
    , p5_a35 in out nocopy  VARCHAR2
    , p5_a36 in out nocopy  NUMBER
    , p5_a37 in out nocopy  VARCHAR2
    , p5_a38 in out nocopy  DATE
    , p5_a39 in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
Line: 1220

    csi_pricing_attribs_pub.update_pricing_attribs(p_api_version,
      p_commit,
      p_init_msg_list,
      p_validation_level,
      ddp_pricing_attribs_tbl,
      ddp_txn_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);