APPS.HZ_BANK_PUB_JW SQL Statements

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

Line: 428

  procedure update_bank_2(p_init_msg_list  VARCHAR2
    , p_pobject_version_number in out nocopy  NUMBER
    , p_bitobject_version_number in out nocopy  NUMBER
    , x_profile_id out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  VARCHAR2 := null
    , p1_a1  VARCHAR2 := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  VARCHAR2 := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  DATE := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
    , p1_a11  VARCHAR2 := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  NUMBER := null
    , p1_a17  NUMBER := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  VARCHAR2 := null
    , p1_a34  NUMBER := null
    , p1_a35  DATE := null
    , p1_a36  VARCHAR2 := null
    , p1_a37  NUMBER := null
    , p1_a38  VARCHAR2 := null
    , p1_a39  VARCHAR2 := null
    , p1_a40  VARCHAR2 := null
    , p1_a41  VARCHAR2 := null
    , p1_a42  VARCHAR2 := null
    , p1_a43  VARCHAR2 := null
    , p1_a44  VARCHAR2 := null
    , p1_a45  VARCHAR2 := null
    , p1_a46  VARCHAR2 := null
    , p1_a47  DATE := null
    , p1_a48  DATE := null
    , p1_a49  VARCHAR2 := null
    , p1_a50  VARCHAR2 := null
    , p1_a51  VARCHAR2 := null
    , p1_a52  VARCHAR2 := null
    , p1_a53  VARCHAR2 := null
    , p1_a54  VARCHAR2 := null
    , p1_a55  NUMBER := null
    , p1_a56  NUMBER := null
    , p1_a57  NUMBER := null
    , p1_a58  VARCHAR2 := null
    , p1_a59  VARCHAR2 := null
    , p1_a60  VARCHAR2 := null
    , p1_a61  VARCHAR2 := null
    , p1_a62  VARCHAR2 := null
    , p1_a63  VARCHAR2 := null
    , p1_a64  VARCHAR2 := null
    , p1_a65  VARCHAR2 := null
    , p1_a66  VARCHAR2 := null
    , p1_a67  VARCHAR2 := null
    , p1_a68  VARCHAR2 := null
    , p1_a69  VARCHAR2 := null
    , p1_a70  VARCHAR2 := null
    , p1_a71  VARCHAR2 := null
    , p1_a72  VARCHAR2 := null
    , p1_a73  VARCHAR2 := null
    , p1_a74  VARCHAR2 := null
    , p1_a75  VARCHAR2 := null
    , p1_a76  NUMBER := null
    , p1_a77  VARCHAR2 := null
    , p1_a78  VARCHAR2 := null
    , p1_a79  VARCHAR2 := null
    , p1_a80  VARCHAR2 := null
    , p1_a81  VARCHAR2 := null
    , p1_a82  VARCHAR2 := null
    , p1_a83  VARCHAR2 := null
    , p1_a84  VARCHAR2 := null
    , p1_a85  VARCHAR2 := null
    , p1_a86  NUMBER := null
    , p1_a87  NUMBER := null
    , p1_a88  NUMBER := null
    , p1_a89  NUMBER := null
    , p1_a90  NUMBER := null
    , p1_a91  NUMBER := null
    , p1_a92  NUMBER := null
    , p1_a93  DATE := null
    , p1_a94  VARCHAR2 := null
    , p1_a95  VARCHAR2 := null
    , p1_a96  VARCHAR2 := null
    , p1_a97  VARCHAR2 := null
    , p1_a98  VARCHAR2 := null
    , p1_a99  VARCHAR2 := null
    , p1_a100  VARCHAR2 := null
    , p1_a101  VARCHAR2 := null
    , p1_a102  VARCHAR2 := null
    , p1_a103  NUMBER := null
    , p1_a104  NUMBER := null
    , p1_a105  NUMBER := null
    , p1_a106  DATE := null
    , p1_a107  VARCHAR2 := null
    , p1_a108  VARCHAR2 := null
    , p1_a109  VARCHAR2 := null
    , p1_a110  VARCHAR2 := null
    , p1_a111  VARCHAR2 := null
    , p1_a112  VARCHAR2 := null
    , p1_a113  VARCHAR2 := null
    , p1_a114  VARCHAR2 := null
    , p1_a115  VARCHAR2 := null
    , p1_a116  NUMBER := null
    , p1_a117  VARCHAR2 := null
    , p1_a118  NUMBER := null
    , p1_a119  VARCHAR2 := null
    , p1_a120  VARCHAR2 := null
    , p1_a121  VARCHAR2 := null
    , p1_a122  VARCHAR2 := null
    , p1_a123  VARCHAR2 := null
    , p1_a124  VARCHAR2 := null
    , p1_a125  VARCHAR2 := null
    , p1_a126  VARCHAR2 := null
    , p1_a127  VARCHAR2 := null
    , p1_a128  VARCHAR2 := null
    , p1_a129  VARCHAR2 := null
    , p1_a130  VARCHAR2 := null
    , p1_a131  VARCHAR2 := null
    , p1_a132  VARCHAR2 := null
    , p1_a133  VARCHAR2 := null
    , p1_a134  VARCHAR2 := null
    , p1_a135  VARCHAR2 := null
    , p1_a136  VARCHAR2 := null
    , p1_a137  VARCHAR2 := null
    , p1_a138  VARCHAR2 := null
    , p1_a139  VARCHAR2 := null
    , p1_a140  VARCHAR2 := null
    , p1_a141  VARCHAR2 := null
    , p1_a142  VARCHAR2 := null
    , p1_a143  NUMBER := null
    , p1_a144  VARCHAR2 := null
    , p1_a145  VARCHAR2 := null
    , p1_a146  VARCHAR2 := null
    , p1_a147  NUMBER := null
    , p1_a148  VARCHAR2 := null
    , p1_a149  VARCHAR2 := null
    , p1_a150  VARCHAR2 := null
    , p1_a151  VARCHAR2 := null
    , p1_a152  VARCHAR2 := null
    , p1_a153  VARCHAR2 := null
    , p1_a154  VARCHAR2 := null
    , p1_a155  VARCHAR2 := null
    , p1_a156  VARCHAR2 := null
    , p1_a157  VARCHAR2 := null
    , p1_a158  VARCHAR2 := null
    , p1_a159  VARCHAR2 := null
    , p1_a160  VARCHAR2 := null
    , p1_a161  VARCHAR2 := null
    , p1_a162  VARCHAR2 := null
    , p1_a163  VARCHAR2 := null
    , p1_a164  VARCHAR2 := null
    , p1_a165  VARCHAR2 := null
    , p1_a166  VARCHAR2 := null
    , p1_a167  VARCHAR2 := null
    , p1_a168  VARCHAR2 := null
    , p1_a169  VARCHAR2 := null
    , p1_a170  VARCHAR2 := null
    , p1_a171  VARCHAR2 := null
    , p1_a172  VARCHAR2 := null
    , p1_a173  VARCHAR2 := null
    , p1_a174  VARCHAR2 := null
    , p1_a175  VARCHAR2 := null
    , p1_a176  VARCHAR2 := null
    , p1_a177  VARCHAR2 := null
    , p1_a178  VARCHAR2 := null
    , p1_a179  VARCHAR2 := null
  )
  as
    ddp_bank_rec hz_bank_pub.bank_rec_type;

Line: 811

    hz_bank_pub.update_bank(p_init_msg_list,
      ddp_bank_rec,
      p_pobject_version_number,
      p_bitobject_version_number,
      x_profile_id,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 1260

  procedure update_bank_branch_4(p_init_msg_list  VARCHAR2
    , p_bank_party_id  NUMBER
    , p_relationship_id in out nocopy  NUMBER
    , p_pobject_version_number in out nocopy  NUMBER
    , p_bbtobject_version_number in out nocopy  NUMBER
    , p_rfcobject_version_number in out nocopy  NUMBER
    , x_profile_id out nocopy  NUMBER
    , x_rel_party_id out nocopy  NUMBER
    , x_rel_party_number out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  VARCHAR2 := null
    , p1_a1  VARCHAR2 := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  VARCHAR2 := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  DATE := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
    , p1_a11  VARCHAR2 := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  NUMBER := null
    , p1_a17  NUMBER := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  VARCHAR2 := null
    , p1_a34  NUMBER := null
    , p1_a35  DATE := null
    , p1_a36  VARCHAR2 := null
    , p1_a37  NUMBER := null
    , p1_a38  VARCHAR2 := null
    , p1_a39  VARCHAR2 := null
    , p1_a40  VARCHAR2 := null
    , p1_a41  VARCHAR2 := null
    , p1_a42  VARCHAR2 := null
    , p1_a43  VARCHAR2 := null
    , p1_a44  VARCHAR2 := null
    , p1_a45  VARCHAR2 := null
    , p1_a46  VARCHAR2 := null
    , p1_a47  DATE := null
    , p1_a48  DATE := null
    , p1_a49  VARCHAR2 := null
    , p1_a50  VARCHAR2 := null
    , p1_a51  VARCHAR2 := null
    , p1_a52  VARCHAR2 := null
    , p1_a53  VARCHAR2 := null
    , p1_a54  VARCHAR2 := null
    , p1_a55  NUMBER := null
    , p1_a56  NUMBER := null
    , p1_a57  NUMBER := null
    , p1_a58  VARCHAR2 := null
    , p1_a59  VARCHAR2 := null
    , p1_a60  VARCHAR2 := null
    , p1_a61  VARCHAR2 := null
    , p1_a62  VARCHAR2 := null
    , p1_a63  VARCHAR2 := null
    , p1_a64  VARCHAR2 := null
    , p1_a65  VARCHAR2 := null
    , p1_a66  VARCHAR2 := null
    , p1_a67  VARCHAR2 := null
    , p1_a68  VARCHAR2 := null
    , p1_a69  VARCHAR2 := null
    , p1_a70  VARCHAR2 := null
    , p1_a71  VARCHAR2 := null
    , p1_a72  VARCHAR2 := null
    , p1_a73  VARCHAR2 := null
    , p1_a74  VARCHAR2 := null
    , p1_a75  VARCHAR2 := null
    , p1_a76  NUMBER := null
    , p1_a77  VARCHAR2 := null
    , p1_a78  VARCHAR2 := null
    , p1_a79  VARCHAR2 := null
    , p1_a80  VARCHAR2 := null
    , p1_a81  VARCHAR2 := null
    , p1_a82  VARCHAR2 := null
    , p1_a83  VARCHAR2 := null
    , p1_a84  VARCHAR2 := null
    , p1_a85  VARCHAR2 := null
    , p1_a86  NUMBER := null
    , p1_a87  NUMBER := null
    , p1_a88  NUMBER := null
    , p1_a89  NUMBER := null
    , p1_a90  NUMBER := null
    , p1_a91  NUMBER := null
    , p1_a92  NUMBER := null
    , p1_a93  DATE := null
    , p1_a94  VARCHAR2 := null
    , p1_a95  VARCHAR2 := null
    , p1_a96  VARCHAR2 := null
    , p1_a97  VARCHAR2 := null
    , p1_a98  VARCHAR2 := null
    , p1_a99  VARCHAR2 := null
    , p1_a100  VARCHAR2 := null
    , p1_a101  VARCHAR2 := null
    , p1_a102  VARCHAR2 := null
    , p1_a103  NUMBER := null
    , p1_a104  NUMBER := null
    , p1_a105  NUMBER := null
    , p1_a106  DATE := null
    , p1_a107  VARCHAR2 := null
    , p1_a108  VARCHAR2 := null
    , p1_a109  VARCHAR2 := null
    , p1_a110  VARCHAR2 := null
    , p1_a111  VARCHAR2 := null
    , p1_a112  VARCHAR2 := null
    , p1_a113  VARCHAR2 := null
    , p1_a114  VARCHAR2 := null
    , p1_a115  VARCHAR2 := null
    , p1_a116  NUMBER := null
    , p1_a117  VARCHAR2 := null
    , p1_a118  NUMBER := null
    , p1_a119  VARCHAR2 := null
    , p1_a120  VARCHAR2 := null
    , p1_a121  VARCHAR2 := null
    , p1_a122  VARCHAR2 := null
    , p1_a123  VARCHAR2 := null
    , p1_a124  VARCHAR2 := null
    , p1_a125  VARCHAR2 := null
    , p1_a126  VARCHAR2 := null
    , p1_a127  VARCHAR2 := null
    , p1_a128  VARCHAR2 := null
    , p1_a129  VARCHAR2 := null
    , p1_a130  VARCHAR2 := null
    , p1_a131  VARCHAR2 := null
    , p1_a132  VARCHAR2 := null
    , p1_a133  VARCHAR2 := null
    , p1_a134  VARCHAR2 := null
    , p1_a135  VARCHAR2 := null
    , p1_a136  VARCHAR2 := null
    , p1_a137  VARCHAR2 := null
    , p1_a138  VARCHAR2 := null
    , p1_a139  VARCHAR2 := null
    , p1_a140  VARCHAR2 := null
    , p1_a141  VARCHAR2 := null
    , p1_a142  VARCHAR2 := null
    , p1_a143  NUMBER := null
    , p1_a144  VARCHAR2 := null
    , p1_a145  VARCHAR2 := null
    , p1_a146  VARCHAR2 := null
    , p1_a147  NUMBER := null
    , p1_a148  VARCHAR2 := null
    , p1_a149  VARCHAR2 := null
    , p1_a150  VARCHAR2 := null
    , p1_a151  VARCHAR2 := null
    , p1_a152  VARCHAR2 := null
    , p1_a153  VARCHAR2 := null
    , p1_a154  VARCHAR2 := null
    , p1_a155  VARCHAR2 := null
    , p1_a156  VARCHAR2 := null
    , p1_a157  VARCHAR2 := null
    , p1_a158  VARCHAR2 := null
    , p1_a159  VARCHAR2 := null
    , p1_a160  VARCHAR2 := null
    , p1_a161  VARCHAR2 := null
    , p1_a162  VARCHAR2 := null
    , p1_a163  VARCHAR2 := null
    , p1_a164  VARCHAR2 := null
    , p1_a165  VARCHAR2 := null
    , p1_a166  VARCHAR2 := null
    , p1_a167  VARCHAR2 := null
    , p1_a168  VARCHAR2 := null
    , p1_a169  VARCHAR2 := null
    , p1_a170  VARCHAR2 := null
    , p1_a171  VARCHAR2 := null
    , p1_a172  VARCHAR2 := null
    , p1_a173  VARCHAR2 := null
    , p1_a174  VARCHAR2 := null
    , p1_a175  VARCHAR2 := null
    , p1_a176  VARCHAR2 := null
    , p1_a177  VARCHAR2 := null
    , p1_a178  VARCHAR2 := null
    , p1_a179  VARCHAR2 := null
  )
  as
    ddp_bank_rec hz_bank_pub.bank_rec_type;

Line: 1653

    hz_bank_pub.update_bank_branch(p_init_msg_list,
      ddp_bank_rec,
      p_bank_party_id,
      p_relationship_id,
      p_pobject_version_number,
      p_bbtobject_version_number,
      p_rfcobject_version_number,
      x_profile_id,
      x_rel_party_id,
      x_rel_party_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 1796

  procedure update_banking_group_6(p_init_msg_list  VARCHAR2
    , p_pobject_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  VARCHAR2 := null
    , p1_a1  VARCHAR2 := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  NUMBER := null
    , p1_a5  NUMBER := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  VARCHAR2 := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
    , p1_a11  VARCHAR2 := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  VARCHAR2 := null
    , p1_a17  VARCHAR2 := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  VARCHAR2 := null
    , p1_a34  VARCHAR2 := null
    , p1_a35  VARCHAR2 := null
    , p1_a36  VARCHAR2 := null
    , p1_a37  VARCHAR2 := null
  )
  as
    ddp_group_rec hz_party_v2pub.group_rec_type;

Line: 1891

    hz_bank_pub.update_banking_group(p_init_msg_list,
      ddp_group_rec,
      p_pobject_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 2152

  procedure update_bank_group_member_8(p_init_msg_list  VARCHAR2
    , p_robject_version_number in out nocopy  NUMBER
    , p_pobject_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := null
    , p1_a1  NUMBER := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  NUMBER := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  VARCHAR2 := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  DATE := null
    , p1_a11  DATE := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  VARCHAR2 := null
    , p1_a17  VARCHAR2 := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  VARCHAR2 := null
    , p1_a34  VARCHAR2 := null
    , p1_a35  VARCHAR2 := null
    , p1_a36  NUMBER := null
    , p1_a37  NUMBER := null
    , p1_a38  VARCHAR2 := null
    , p1_a39  VARCHAR2 := null
    , p1_a40  VARCHAR2 := null
    , p1_a41  VARCHAR2 := null
    , p1_a42  VARCHAR2 := null
    , p1_a43  VARCHAR2 := null
    , p1_a44  VARCHAR2 := null
    , p1_a45  VARCHAR2 := null
    , p1_a46  VARCHAR2 := null
    , p1_a47  VARCHAR2 := null
    , p1_a48  VARCHAR2 := null
    , p1_a49  VARCHAR2 := null
    , p1_a50  VARCHAR2 := null
    , p1_a51  VARCHAR2 := null
    , p1_a52  VARCHAR2 := null
    , p1_a53  VARCHAR2 := null
    , p1_a54  VARCHAR2 := null
    , p1_a55  VARCHAR2 := null
    , p1_a56  VARCHAR2 := null
    , p1_a57  VARCHAR2 := null
    , p1_a58  VARCHAR2 := null
    , p1_a59  VARCHAR2 := null
    , p1_a60  VARCHAR2 := null
    , p1_a61  VARCHAR2 := null
    , p1_a62  VARCHAR2 := null
    , p1_a63  VARCHAR2 := null
    , p1_a64  VARCHAR2 := null
    , p1_a65  VARCHAR2 := null
    , p1_a66  VARCHAR2 := null
    , p1_a67  VARCHAR2 := null
    , p1_a68  VARCHAR2 := null
    , p1_a69  VARCHAR2 := null
    , p1_a70  VARCHAR2 := null
    , p1_a71  VARCHAR2 := null
    , p1_a72  VARCHAR2 := null
    , p1_a73  VARCHAR2 := null
    , p1_a74  VARCHAR2 := null
    , p1_a75  VARCHAR2 := null
    , p1_a76  VARCHAR2 := null
    , p1_a77  VARCHAR2 := null
    , p1_a78  VARCHAR2 := null
    , p1_a79  VARCHAR2 := null
    , p1_a80  VARCHAR2 := null
    , p1_a81  VARCHAR2 := null
    , p1_a82  VARCHAR2 := null
    , p1_a83  VARCHAR2 := null
    , p1_a84  VARCHAR2 := null
    , p1_a85  VARCHAR2 := null
    , p1_a86  VARCHAR2 := null
    , p1_a87  VARCHAR2 := null
    , p1_a88  VARCHAR2 := null
    , p1_a89  VARCHAR2 := null
    , p1_a90  VARCHAR2 := null
    , p1_a91  VARCHAR2 := null
    , p1_a92  VARCHAR2 := null
    , p1_a93  VARCHAR2 := null
    , p1_a94  VARCHAR2 := null
    , p1_a95  VARCHAR2 := null
    , p1_a96  VARCHAR2 := null
    , p1_a97  VARCHAR2 := null
    , p1_a98  VARCHAR2 := null
    , p1_a99  VARCHAR2 := null
    , p1_a100  NUMBER := null
    , p1_a101  VARCHAR2 := null
  )
  as
    ddp_relationship_rec hz_relationship_v2pub.relationship_rec_type;

Line: 2377

    hz_bank_pub.update_bank_group_member(p_init_msg_list,
      ddp_relationship_rec,
      p_robject_version_number,
      p_pobject_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 2640

  procedure update_clearinghouse_assign_10(p_init_msg_list  VARCHAR2
    , p_robject_version_number in out nocopy  NUMBER
    , p_pobject_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := null
    , p1_a1  NUMBER := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  NUMBER := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  VARCHAR2 := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  DATE := null
    , p1_a11  DATE := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  VARCHAR2 := null
    , p1_a17  VARCHAR2 := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  VARCHAR2 := null
    , p1_a34  VARCHAR2 := null
    , p1_a35  VARCHAR2 := null
    , p1_a36  NUMBER := null
    , p1_a37  NUMBER := null
    , p1_a38  VARCHAR2 := null
    , p1_a39  VARCHAR2 := null
    , p1_a40  VARCHAR2 := null
    , p1_a41  VARCHAR2 := null
    , p1_a42  VARCHAR2 := null
    , p1_a43  VARCHAR2 := null
    , p1_a44  VARCHAR2 := null
    , p1_a45  VARCHAR2 := null
    , p1_a46  VARCHAR2 := null
    , p1_a47  VARCHAR2 := null
    , p1_a48  VARCHAR2 := null
    , p1_a49  VARCHAR2 := null
    , p1_a50  VARCHAR2 := null
    , p1_a51  VARCHAR2 := null
    , p1_a52  VARCHAR2 := null
    , p1_a53  VARCHAR2 := null
    , p1_a54  VARCHAR2 := null
    , p1_a55  VARCHAR2 := null
    , p1_a56  VARCHAR2 := null
    , p1_a57  VARCHAR2 := null
    , p1_a58  VARCHAR2 := null
    , p1_a59  VARCHAR2 := null
    , p1_a60  VARCHAR2 := null
    , p1_a61  VARCHAR2 := null
    , p1_a62  VARCHAR2 := null
    , p1_a63  VARCHAR2 := null
    , p1_a64  VARCHAR2 := null
    , p1_a65  VARCHAR2 := null
    , p1_a66  VARCHAR2 := null
    , p1_a67  VARCHAR2 := null
    , p1_a68  VARCHAR2 := null
    , p1_a69  VARCHAR2 := null
    , p1_a70  VARCHAR2 := null
    , p1_a71  VARCHAR2 := null
    , p1_a72  VARCHAR2 := null
    , p1_a73  VARCHAR2 := null
    , p1_a74  VARCHAR2 := null
    , p1_a75  VARCHAR2 := null
    , p1_a76  VARCHAR2 := null
    , p1_a77  VARCHAR2 := null
    , p1_a78  VARCHAR2 := null
    , p1_a79  VARCHAR2 := null
    , p1_a80  VARCHAR2 := null
    , p1_a81  VARCHAR2 := null
    , p1_a82  VARCHAR2 := null
    , p1_a83  VARCHAR2 := null
    , p1_a84  VARCHAR2 := null
    , p1_a85  VARCHAR2 := null
    , p1_a86  VARCHAR2 := null
    , p1_a87  VARCHAR2 := null
    , p1_a88  VARCHAR2 := null
    , p1_a89  VARCHAR2 := null
    , p1_a90  VARCHAR2 := null
    , p1_a91  VARCHAR2 := null
    , p1_a92  VARCHAR2 := null
    , p1_a93  VARCHAR2 := null
    , p1_a94  VARCHAR2 := null
    , p1_a95  VARCHAR2 := null
    , p1_a96  VARCHAR2 := null
    , p1_a97  VARCHAR2 := null
    , p1_a98  VARCHAR2 := null
    , p1_a99  VARCHAR2 := null
    , p1_a100  NUMBER := null
    , p1_a101  VARCHAR2 := null
  )
  as
    ddp_relationship_rec hz_relationship_v2pub.relationship_rec_type;

Line: 2865

    hz_bank_pub.update_clearinghouse_assign(p_init_msg_list,
      ddp_relationship_rec,
      p_robject_version_number,
      p_pobject_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 2994

  procedure update_bank_site_12(p_init_msg_list  VARCHAR2
    , p_psobject_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := null
    , p1_a1  NUMBER := null
    , p1_a2  NUMBER := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  VARCHAR2 := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  VARCHAR2 := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
    , p1_a11  VARCHAR2 := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  VARCHAR2 := null
    , p1_a17  VARCHAR2 := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  VARCHAR2 := null
    , p1_a34  NUMBER := null
    , p1_a35  VARCHAR2 := null
    , p1_a36  VARCHAR2 := null
  )
  as
    ddp_party_site_rec hz_party_site_v2pub.party_site_rec_type;

Line: 3087

    hz_bank_pub.update_bank_site(p_init_msg_list,
      ddp_party_site_rec,
      p_psobject_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 3226

  procedure update_edi_contact_point_14(p_init_msg_list  VARCHAR2
    , p_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := null
    , p1_a1  VARCHAR2 := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  NUMBER := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  VARCHAR2 := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
    , p1_a11  VARCHAR2 := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  VARCHAR2 := null
    , p1_a17  VARCHAR2 := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  NUMBER := null
    , p1_a34  VARCHAR2 := null
    , p2_a0  VARCHAR2 := null
    , p2_a1  VARCHAR2 := null
    , p2_a2  VARCHAR2 := null
    , p2_a3  VARCHAR2 := null
    , p2_a4  VARCHAR2 := null
    , p2_a5  VARCHAR2 := null
    , p2_a6  NUMBER := null
    , p2_a7  VARCHAR2 := null
  )
  as
    ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

Line: 3333

    hz_bank_pub.update_edi_contact_point(p_init_msg_list,
      ddp_contact_point_rec,
      ddp_edi_rec,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 3466

  procedure update_eft_contact_point_16(p_init_msg_list  VARCHAR2
    , p_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := null
    , p1_a1  VARCHAR2 := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  NUMBER := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  VARCHAR2 := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
    , p1_a11  VARCHAR2 := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  VARCHAR2 := null
    , p1_a17  VARCHAR2 := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  NUMBER := null
    , p1_a34  VARCHAR2 := null
    , p2_a0  NUMBER := null
    , p2_a1  NUMBER := null
    , p2_a2  VARCHAR2 := null
    , p2_a3  VARCHAR2 := null
  )
  as
    ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

Line: 3565

    hz_bank_pub.update_eft_contact_point(p_init_msg_list,
      ddp_contact_point_rec,
      ddp_eft_rec,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 3694

  procedure update_web_contact_point_18(p_init_msg_list  VARCHAR2
    , p_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := null
    , p1_a1  VARCHAR2 := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  NUMBER := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  VARCHAR2 := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
    , p1_a11  VARCHAR2 := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  VARCHAR2 := null
    , p1_a17  VARCHAR2 := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  NUMBER := null
    , p1_a34  VARCHAR2 := null
    , p2_a0  VARCHAR2 := null
    , p2_a1  VARCHAR2 := null
  )
  as
    ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

Line: 3789

    hz_bank_pub.update_web_contact_point(p_init_msg_list,
      ddp_contact_point_rec,
      ddp_web_rec,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 3932

  procedure update_phone_contact_point_20(p_init_msg_list  VARCHAR2
    , p_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := null
    , p1_a1  VARCHAR2 := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  NUMBER := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  VARCHAR2 := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
    , p1_a11  VARCHAR2 := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  VARCHAR2 := null
    , p1_a17  VARCHAR2 := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  NUMBER := null
    , p1_a34  VARCHAR2 := null
    , p2_a0  VARCHAR2 := null
    , p2_a1  DATE := null
    , p2_a2  NUMBER := null
    , p2_a3  VARCHAR2 := null
    , p2_a4  VARCHAR2 := null
    , p2_a5  VARCHAR2 := null
    , p2_a6  VARCHAR2 := null
    , p2_a7  VARCHAR2 := null
    , p2_a8  VARCHAR2 := null
  )
  as
    ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

Line: 4041

    hz_bank_pub.update_phone_contact_point(p_init_msg_list,
      ddp_contact_point_rec,
      ddp_phone_rec,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 4170

  procedure update_email_contact_point_22(p_init_msg_list  VARCHAR2
    , p_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := null
    , p1_a1  VARCHAR2 := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  NUMBER := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  VARCHAR2 := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
    , p1_a11  VARCHAR2 := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  VARCHAR2 := null
    , p1_a17  VARCHAR2 := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  NUMBER := null
    , p1_a34  VARCHAR2 := null
    , p2_a0  VARCHAR2 := null
    , p2_a1  VARCHAR2 := null
  )
  as
    ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

Line: 4265

    hz_bank_pub.update_email_contact_point(p_init_msg_list,
      ddp_contact_point_rec,
      ddp_email_rec,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 4392

  procedure update_telex_contact_point_24(p_init_msg_list  VARCHAR2
    , p_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := null
    , p1_a1  VARCHAR2 := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  NUMBER := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := null
    , p1_a7  VARCHAR2 := null
    , p1_a8  VARCHAR2 := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
    , p1_a11  VARCHAR2 := null
    , p1_a12  VARCHAR2 := null
    , p1_a13  VARCHAR2 := null
    , p1_a14  VARCHAR2 := null
    , p1_a15  VARCHAR2 := null
    , p1_a16  VARCHAR2 := null
    , p1_a17  VARCHAR2 := null
    , p1_a18  VARCHAR2 := null
    , p1_a19  VARCHAR2 := null
    , p1_a20  VARCHAR2 := null
    , p1_a21  VARCHAR2 := null
    , p1_a22  VARCHAR2 := null
    , p1_a23  VARCHAR2 := null
    , p1_a24  VARCHAR2 := null
    , p1_a25  VARCHAR2 := null
    , p1_a26  VARCHAR2 := null
    , p1_a27  VARCHAR2 := null
    , p1_a28  VARCHAR2 := null
    , p1_a29  VARCHAR2 := null
    , p1_a30  VARCHAR2 := null
    , p1_a31  VARCHAR2 := null
    , p1_a32  VARCHAR2 := null
    , p1_a33  NUMBER := null
    , p1_a34  VARCHAR2 := null
    , p2_a0  VARCHAR2 := null
  )
  as
    ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

Line: 4485

    hz_bank_pub.update_telex_contact_point(p_init_msg_list,
      ddp_contact_point_rec,
      ddp_telex_rec,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);