eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CUST_ACCOUNT_V2PUB_JW SQL Statements

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

Line: 443


    ddp_cust_account_rec.status_update_date := rosetta_g_miss_date_in_map(p1_a94);

Line: 1195


    ddp_cust_account_rec.status_update_date := rosetta_g_miss_date_in_map(p1_a94);

Line: 1526


  procedure update_cust_account_3(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  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  VARCHAR2 := null
    , p1_a35  VARCHAR2 := null
    , p1_a36  VARCHAR2 := null
    , p1_a37  VARCHAR2 := 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  NUMBER := null
    , p1_a50  VARCHAR2 := null
    , p1_a51  NUMBER := null
    , p1_a52  NUMBER := null
    , p1_a53  VARCHAR2 := null
    , p1_a54  VARCHAR2 := null
    , p1_a55  VARCHAR2 := null
    , p1_a56  VARCHAR2 := null
    , p1_a57  VARCHAR2 := null
    , p1_a58  NUMBER := null
    , p1_a59  VARCHAR2 := null
    , p1_a60  VARCHAR2 := null
    , p1_a61  VARCHAR2 := null
    , p1_a62  NUMBER := null
    , p1_a63  NUMBER := null
    , p1_a64  VARCHAR2 := null
    , p1_a65  NUMBER := null
    , p1_a66  DATE := null
    , p1_a67  DATE := null
    , p1_a68  DATE := null
    , p1_a69  VARCHAR2 := null
    , p1_a70  DATE := 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  DATE := null
    , p1_a79  VARCHAR2 := null
    , p1_a80  VARCHAR2 := null
    , p1_a81  NUMBER := null
    , p1_a82  NUMBER := null
    , p1_a83  VARCHAR2 := null
    , p1_a84  NUMBER := null
    , p1_a85  NUMBER := null
    , p1_a86  NUMBER := null
    , p1_a87  NUMBER := 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  DATE := null
    , p1_a95  VARCHAR2 := null
    , p1_a96  VARCHAR2 := null
    , p1_a97  NUMBER := null
    , p1_a98  NUMBER := null
    , p1_a99  VARCHAR2 := null
    , p1_a100  NUMBER := null
    , p1_a101  VARCHAR2 := null
    , p1_a102  VARCHAR2 := null
    , p1_a103  VARCHAR2 := null
    , p1_a104  VARCHAR2 := null
  )
  as
    ddp_cust_account_rec hz_cust_account_v2pub.cust_account_rec_type;

Line: 1738


    ddp_cust_account_rec.status_update_date := rosetta_g_miss_date_in_map(p1_a94);

Line: 1755


    hz_cust_account_v2pub.update_cust_account(p_init_msg_list,
      ddp_cust_account_rec,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 2108


    p2_a94 := ddx_cust_account_rec.status_update_date;

Line: 2408


  procedure update_cust_acct_relate_7(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  NUMBER := null
    , p1_a2  VARCHAR2 := 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  NUMBER := null
    , p1_a26  NUMBER := null
    , p1_a27  NUMBER := null
  )
  as
    ddp_cust_acct_relate_rec hz_cust_account_v2pub.cust_acct_relate_rec_type;

Line: 2483


    hz_cust_account_v2pub.update_cust_acct_relate(p_init_msg_list,
      ddp_cust_acct_relate_rec,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 2498


  procedure update_cust_acct_relate_8(p_init_msg_list  VARCHAR2
    , p_rowid  ROWID
    , 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  NUMBER := null
    , p1_a2  VARCHAR2 := 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  NUMBER := null
    , p1_a26  NUMBER := null
    , p1_a27  NUMBER := null
  )
  as
    ddp_cust_acct_relate_rec hz_cust_account_v2pub.cust_acct_relate_rec_type;

Line: 2575


    hz_cust_account_v2pub.update_cust_acct_relate(p_init_msg_list,
      ddp_cust_acct_relate_rec,
      p_rowid,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);