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.AMS_IS_LINE_PVT_W SQL Statements

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

Line: 327


          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a2(indx));

Line: 328


          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a3(indx));

Line: 331


          t(ddindx).last_update_login := rosetta_g_miss_num_map(a6(indx));

Line: 1820


          a2(indx) := t(ddindx).last_update_date;

Line: 1821


          a3(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);

Line: 1824


          a6(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);

Line: 2443


    ddp_is_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);

Line: 2444


    ddp_is_line_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);

Line: 2447


    ddp_is_line_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);

Line: 2760


  procedure update_is_line(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_object_version_number out nocopy  NUMBER
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  NUMBER := 0-1962.0724
    , p7_a2  DATE := fnd_api.g_miss_date
    , p7_a3  NUMBER := 0-1962.0724
    , p7_a4  DATE := fnd_api.g_miss_date
    , p7_a5  NUMBER := 0-1962.0724
    , p7_a6  NUMBER := 0-1962.0724
    , p7_a7  NUMBER := 0-1962.0724
    , p7_a8  VARCHAR2 := fnd_api.g_miss_char
    , p7_a9  VARCHAR2 := fnd_api.g_miss_char
    , p7_a10  VARCHAR2 := fnd_api.g_miss_char
    , p7_a11  DATE := fnd_api.g_miss_date
    , p7_a12  NUMBER := 0-1962.0724
    , p7_a13  VARCHAR2 := fnd_api.g_miss_char
    , p7_a14  VARCHAR2 := fnd_api.g_miss_char
    , p7_a15  VARCHAR2 := fnd_api.g_miss_char
    , p7_a16  VARCHAR2 := fnd_api.g_miss_char
    , p7_a17  VARCHAR2 := fnd_api.g_miss_char
    , p7_a18  VARCHAR2 := fnd_api.g_miss_char
    , p7_a19  VARCHAR2 := fnd_api.g_miss_char
    , p7_a20  VARCHAR2 := fnd_api.g_miss_char
    , p7_a21  VARCHAR2 := fnd_api.g_miss_char
    , p7_a22  VARCHAR2 := fnd_api.g_miss_char
    , p7_a23  VARCHAR2 := fnd_api.g_miss_char
    , p7_a24  VARCHAR2 := fnd_api.g_miss_char
    , p7_a25  VARCHAR2 := fnd_api.g_miss_char
    , p7_a26  VARCHAR2 := fnd_api.g_miss_char
    , p7_a27  VARCHAR2 := fnd_api.g_miss_char
    , p7_a28  VARCHAR2 := fnd_api.g_miss_char
    , p7_a29  VARCHAR2 := fnd_api.g_miss_char
    , p7_a30  VARCHAR2 := fnd_api.g_miss_char
    , p7_a31  VARCHAR2 := fnd_api.g_miss_char
    , p7_a32  VARCHAR2 := fnd_api.g_miss_char
    , p7_a33  VARCHAR2 := fnd_api.g_miss_char
    , p7_a34  VARCHAR2 := fnd_api.g_miss_char
    , p7_a35  VARCHAR2 := fnd_api.g_miss_char
    , p7_a36  VARCHAR2 := fnd_api.g_miss_char
    , p7_a37  VARCHAR2 := fnd_api.g_miss_char
    , p7_a38  VARCHAR2 := fnd_api.g_miss_char
    , p7_a39  VARCHAR2 := fnd_api.g_miss_char
    , p7_a40  VARCHAR2 := fnd_api.g_miss_char
    , p7_a41  VARCHAR2 := fnd_api.g_miss_char
    , p7_a42  VARCHAR2 := fnd_api.g_miss_char
    , p7_a43  VARCHAR2 := fnd_api.g_miss_char
    , p7_a44  VARCHAR2 := fnd_api.g_miss_char
    , p7_a45  VARCHAR2 := fnd_api.g_miss_char
    , p7_a46  VARCHAR2 := fnd_api.g_miss_char
    , p7_a47  VARCHAR2 := fnd_api.g_miss_char
    , p7_a48  VARCHAR2 := fnd_api.g_miss_char
    , p7_a49  VARCHAR2 := fnd_api.g_miss_char
    , p7_a50  VARCHAR2 := fnd_api.g_miss_char
    , p7_a51  VARCHAR2 := fnd_api.g_miss_char
    , p7_a52  VARCHAR2 := fnd_api.g_miss_char
    , p7_a53  VARCHAR2 := fnd_api.g_miss_char
    , p7_a54  VARCHAR2 := fnd_api.g_miss_char
    , p7_a55  VARCHAR2 := fnd_api.g_miss_char
    , p7_a56  VARCHAR2 := fnd_api.g_miss_char
    , p7_a57  VARCHAR2 := fnd_api.g_miss_char
    , p7_a58  VARCHAR2 := fnd_api.g_miss_char
    , p7_a59  VARCHAR2 := fnd_api.g_miss_char
    , p7_a60  VARCHAR2 := fnd_api.g_miss_char
    , p7_a61  VARCHAR2 := fnd_api.g_miss_char
    , p7_a62  VARCHAR2 := fnd_api.g_miss_char
    , p7_a63  VARCHAR2 := fnd_api.g_miss_char
    , p7_a64  VARCHAR2 := fnd_api.g_miss_char
    , p7_a65  VARCHAR2 := fnd_api.g_miss_char
    , p7_a66  VARCHAR2 := fnd_api.g_miss_char
    , p7_a67  VARCHAR2 := fnd_api.g_miss_char
    , p7_a68  VARCHAR2 := fnd_api.g_miss_char
    , p7_a69  VARCHAR2 := fnd_api.g_miss_char
    , p7_a70  VARCHAR2 := fnd_api.g_miss_char
    , p7_a71  VARCHAR2 := fnd_api.g_miss_char
    , p7_a72  VARCHAR2 := fnd_api.g_miss_char
    , p7_a73  VARCHAR2 := fnd_api.g_miss_char
    , p7_a74  VARCHAR2 := fnd_api.g_miss_char
    , p7_a75  VARCHAR2 := fnd_api.g_miss_char
    , p7_a76  VARCHAR2 := fnd_api.g_miss_char
    , p7_a77  VARCHAR2 := fnd_api.g_miss_char
    , p7_a78  VARCHAR2 := fnd_api.g_miss_char
    , p7_a79  VARCHAR2 := fnd_api.g_miss_char
    , p7_a80  VARCHAR2 := fnd_api.g_miss_char
    , p7_a81  VARCHAR2 := fnd_api.g_miss_char
    , p7_a82  VARCHAR2 := fnd_api.g_miss_char
    , p7_a83  VARCHAR2 := fnd_api.g_miss_char
    , p7_a84  VARCHAR2 := fnd_api.g_miss_char
    , p7_a85  VARCHAR2 := fnd_api.g_miss_char
    , p7_a86  VARCHAR2 := fnd_api.g_miss_char
    , p7_a87  VARCHAR2 := fnd_api.g_miss_char
    , p7_a88  VARCHAR2 := fnd_api.g_miss_char
    , p7_a89  VARCHAR2 := fnd_api.g_miss_char
    , p7_a90  VARCHAR2 := fnd_api.g_miss_char
    , p7_a91  VARCHAR2 := fnd_api.g_miss_char
    , p7_a92  VARCHAR2 := fnd_api.g_miss_char
    , p7_a93  VARCHAR2 := fnd_api.g_miss_char
    , p7_a94  VARCHAR2 := fnd_api.g_miss_char
    , p7_a95  VARCHAR2 := fnd_api.g_miss_char
    , p7_a96  VARCHAR2 := fnd_api.g_miss_char
    , p7_a97  VARCHAR2 := fnd_api.g_miss_char
    , p7_a98  VARCHAR2 := fnd_api.g_miss_char
    , p7_a99  VARCHAR2 := fnd_api.g_miss_char
    , p7_a100  VARCHAR2 := fnd_api.g_miss_char
    , p7_a101  VARCHAR2 := fnd_api.g_miss_char
    , p7_a102  VARCHAR2 := fnd_api.g_miss_char
    , p7_a103  VARCHAR2 := fnd_api.g_miss_char
    , p7_a104  VARCHAR2 := fnd_api.g_miss_char
    , p7_a105  VARCHAR2 := fnd_api.g_miss_char
    , p7_a106  VARCHAR2 := fnd_api.g_miss_char
    , p7_a107  VARCHAR2 := fnd_api.g_miss_char
    , p7_a108  VARCHAR2 := fnd_api.g_miss_char
    , p7_a109  VARCHAR2 := fnd_api.g_miss_char
    , p7_a110  VARCHAR2 := fnd_api.g_miss_char
    , p7_a111  VARCHAR2 := fnd_api.g_miss_char
    , p7_a112  VARCHAR2 := fnd_api.g_miss_char
    , p7_a113  VARCHAR2 := fnd_api.g_miss_char
    , p7_a114  VARCHAR2 := fnd_api.g_miss_char
    , p7_a115  VARCHAR2 := fnd_api.g_miss_char
    , p7_a116  VARCHAR2 := fnd_api.g_miss_char
    , p7_a117  VARCHAR2 := fnd_api.g_miss_char
    , p7_a118  VARCHAR2 := fnd_api.g_miss_char
    , p7_a119  VARCHAR2 := fnd_api.g_miss_char
    , p7_a120  VARCHAR2 := fnd_api.g_miss_char
    , p7_a121  VARCHAR2 := fnd_api.g_miss_char
    , p7_a122  VARCHAR2 := fnd_api.g_miss_char
    , p7_a123  VARCHAR2 := fnd_api.g_miss_char
    , p7_a124  VARCHAR2 := fnd_api.g_miss_char
    , p7_a125  VARCHAR2 := fnd_api.g_miss_char
    , p7_a126  VARCHAR2 := fnd_api.g_miss_char
    , p7_a127  VARCHAR2 := fnd_api.g_miss_char
    , p7_a128  VARCHAR2 := fnd_api.g_miss_char
    , p7_a129  VARCHAR2 := fnd_api.g_miss_char
    , p7_a130  VARCHAR2 := fnd_api.g_miss_char
    , p7_a131  VARCHAR2 := fnd_api.g_miss_char
    , p7_a132  VARCHAR2 := fnd_api.g_miss_char
    , p7_a133  VARCHAR2 := fnd_api.g_miss_char
    , p7_a134  VARCHAR2 := fnd_api.g_miss_char
    , p7_a135  VARCHAR2 := fnd_api.g_miss_char
    , p7_a136  VARCHAR2 := fnd_api.g_miss_char
    , p7_a137  VARCHAR2 := fnd_api.g_miss_char
    , p7_a138  VARCHAR2 := fnd_api.g_miss_char
    , p7_a139  VARCHAR2 := fnd_api.g_miss_char
    , p7_a140  VARCHAR2 := fnd_api.g_miss_char
    , p7_a141  VARCHAR2 := fnd_api.g_miss_char
    , p7_a142  VARCHAR2 := fnd_api.g_miss_char
    , p7_a143  VARCHAR2 := fnd_api.g_miss_char
    , p7_a144  VARCHAR2 := fnd_api.g_miss_char
    , p7_a145  VARCHAR2 := fnd_api.g_miss_char
    , p7_a146  VARCHAR2 := fnd_api.g_miss_char
    , p7_a147  VARCHAR2 := fnd_api.g_miss_char
    , p7_a148  VARCHAR2 := fnd_api.g_miss_char
    , p7_a149  VARCHAR2 := fnd_api.g_miss_char
    , p7_a150  VARCHAR2 := fnd_api.g_miss_char
    , p7_a151  VARCHAR2 := fnd_api.g_miss_char
    , p7_a152  VARCHAR2 := fnd_api.g_miss_char
    , p7_a153  VARCHAR2 := fnd_api.g_miss_char
    , p7_a154  VARCHAR2 := fnd_api.g_miss_char
    , p7_a155  VARCHAR2 := fnd_api.g_miss_char
    , p7_a156  VARCHAR2 := fnd_api.g_miss_char
    , p7_a157  VARCHAR2 := fnd_api.g_miss_char
    , p7_a158  VARCHAR2 := fnd_api.g_miss_char
    , p7_a159  VARCHAR2 := fnd_api.g_miss_char
    , p7_a160  VARCHAR2 := fnd_api.g_miss_char
    , p7_a161  VARCHAR2 := fnd_api.g_miss_char
    , p7_a162  VARCHAR2 := fnd_api.g_miss_char
    , p7_a163  VARCHAR2 := fnd_api.g_miss_char
    , p7_a164  VARCHAR2 := fnd_api.g_miss_char
    , p7_a165  VARCHAR2 := fnd_api.g_miss_char
    , p7_a166  VARCHAR2 := fnd_api.g_miss_char
    , p7_a167  VARCHAR2 := fnd_api.g_miss_char
    , p7_a168  VARCHAR2 := fnd_api.g_miss_char
    , p7_a169  VARCHAR2 := fnd_api.g_miss_char
    , p7_a170  VARCHAR2 := fnd_api.g_miss_char
    , p7_a171  VARCHAR2 := fnd_api.g_miss_char
    , p7_a172  VARCHAR2 := fnd_api.g_miss_char
    , p7_a173  VARCHAR2 := fnd_api.g_miss_char
    , p7_a174  VARCHAR2 := fnd_api.g_miss_char
    , p7_a175  VARCHAR2 := fnd_api.g_miss_char
    , p7_a176  VARCHAR2 := fnd_api.g_miss_char
    , p7_a177  VARCHAR2 := fnd_api.g_miss_char
    , p7_a178  VARCHAR2 := fnd_api.g_miss_char
    , p7_a179  VARCHAR2 := fnd_api.g_miss_char
    , p7_a180  VARCHAR2 := fnd_api.g_miss_char
    , p7_a181  VARCHAR2 := fnd_api.g_miss_char
    , p7_a182  VARCHAR2 := fnd_api.g_miss_char
    , p7_a183  VARCHAR2 := fnd_api.g_miss_char
    , p7_a184  VARCHAR2 := fnd_api.g_miss_char
    , p7_a185  VARCHAR2 := fnd_api.g_miss_char
    , p7_a186  VARCHAR2 := fnd_api.g_miss_char
    , p7_a187  VARCHAR2 := fnd_api.g_miss_char
    , p7_a188  VARCHAR2 := fnd_api.g_miss_char
    , p7_a189  VARCHAR2 := fnd_api.g_miss_char
    , p7_a190  VARCHAR2 := fnd_api.g_miss_char
    , p7_a191  VARCHAR2 := fnd_api.g_miss_char
    , p7_a192  VARCHAR2 := fnd_api.g_miss_char
    , p7_a193  VARCHAR2 := fnd_api.g_miss_char
    , p7_a194  VARCHAR2 := fnd_api.g_miss_char
    , p7_a195  VARCHAR2 := fnd_api.g_miss_char
    , p7_a196  VARCHAR2 := fnd_api.g_miss_char
    , p7_a197  VARCHAR2 := fnd_api.g_miss_char
    , p7_a198  VARCHAR2 := fnd_api.g_miss_char
    , p7_a199  VARCHAR2 := fnd_api.g_miss_char
    , p7_a200  VARCHAR2 := fnd_api.g_miss_char
    , p7_a201  VARCHAR2 := fnd_api.g_miss_char
    , p7_a202  VARCHAR2 := fnd_api.g_miss_char
    , p7_a203  VARCHAR2 := fnd_api.g_miss_char
    , p7_a204  VARCHAR2 := fnd_api.g_miss_char
    , p7_a205  VARCHAR2 := fnd_api.g_miss_char
    , p7_a206  VARCHAR2 := fnd_api.g_miss_char
    , p7_a207  VARCHAR2 := fnd_api.g_miss_char
    , p7_a208  VARCHAR2 := fnd_api.g_miss_char
    , p7_a209  VARCHAR2 := fnd_api.g_miss_char
    , p7_a210  VARCHAR2 := fnd_api.g_miss_char
    , p7_a211  VARCHAR2 := fnd_api.g_miss_char
    , p7_a212  VARCHAR2 := fnd_api.g_miss_char
    , p7_a213  VARCHAR2 := fnd_api.g_miss_char
    , p7_a214  VARCHAR2 := fnd_api.g_miss_char
    , p7_a215  VARCHAR2 := fnd_api.g_miss_char
    , p7_a216  VARCHAR2 := fnd_api.g_miss_char
    , p7_a217  VARCHAR2 := fnd_api.g_miss_char
    , p7_a218  VARCHAR2 := fnd_api.g_miss_char
    , p7_a219  VARCHAR2 := fnd_api.g_miss_char
    , p7_a220  VARCHAR2 := fnd_api.g_miss_char
    , p7_a221  VARCHAR2 := fnd_api.g_miss_char
    , p7_a222  VARCHAR2 := fnd_api.g_miss_char
    , p7_a223  VARCHAR2 := fnd_api.g_miss_char
    , p7_a224  VARCHAR2 := fnd_api.g_miss_char
    , p7_a225  VARCHAR2 := fnd_api.g_miss_char
    , p7_a226  VARCHAR2 := fnd_api.g_miss_char
    , p7_a227  VARCHAR2 := fnd_api.g_miss_char
    , p7_a228  VARCHAR2 := fnd_api.g_miss_char
    , p7_a229  VARCHAR2 := fnd_api.g_miss_char
    , p7_a230  VARCHAR2 := fnd_api.g_miss_char
    , p7_a231  VARCHAR2 := fnd_api.g_miss_char
    , p7_a232  VARCHAR2 := fnd_api.g_miss_char
    , p7_a233  VARCHAR2 := fnd_api.g_miss_char
    , p7_a234  VARCHAR2 := fnd_api.g_miss_char
    , p7_a235  VARCHAR2 := fnd_api.g_miss_char
    , p7_a236  VARCHAR2 := fnd_api.g_miss_char
    , p7_a237  VARCHAR2 := fnd_api.g_miss_char
    , p7_a238  VARCHAR2 := fnd_api.g_miss_char
    , p7_a239  VARCHAR2 := fnd_api.g_miss_char
    , p7_a240  VARCHAR2 := fnd_api.g_miss_char
    , p7_a241  VARCHAR2 := fnd_api.g_miss_char
    , p7_a242  VARCHAR2 := fnd_api.g_miss_char
    , p7_a243  VARCHAR2 := fnd_api.g_miss_char
    , p7_a244  VARCHAR2 := fnd_api.g_miss_char
    , p7_a245  VARCHAR2 := fnd_api.g_miss_char
    , p7_a246  VARCHAR2 := fnd_api.g_miss_char
    , p7_a247  VARCHAR2 := fnd_api.g_miss_char
    , p7_a248  VARCHAR2 := fnd_api.g_miss_char
    , p7_a249  VARCHAR2 := fnd_api.g_miss_char
    , p7_a250  VARCHAR2 := fnd_api.g_miss_char
    , p7_a251  VARCHAR2 := fnd_api.g_miss_char
    , p7_a252  VARCHAR2 := fnd_api.g_miss_char
    , p7_a253  VARCHAR2 := fnd_api.g_miss_char
    , p7_a254  VARCHAR2 := fnd_api.g_miss_char
    , p7_a255  VARCHAR2 := fnd_api.g_miss_char
    , p7_a256  VARCHAR2 := fnd_api.g_miss_char
    , p7_a257  VARCHAR2 := fnd_api.g_miss_char
    , p7_a258  VARCHAR2 := fnd_api.g_miss_char
    , p7_a259  VARCHAR2 := fnd_api.g_miss_char
    , p7_a260  VARCHAR2 := fnd_api.g_miss_char
    , p7_a261  VARCHAR2 := fnd_api.g_miss_char
    , p7_a262  VARCHAR2 := fnd_api.g_miss_char
    , p7_a263  VARCHAR2 := fnd_api.g_miss_char
    , p7_a264  VARCHAR2 := fnd_api.g_miss_char
    , p7_a265  NUMBER := 0-1962.0724
    , p7_a266  VARCHAR2 := fnd_api.g_miss_char
    , p7_a267  VARCHAR2 := fnd_api.g_miss_char
    , p7_a268  VARCHAR2 := fnd_api.g_miss_char
    , p7_a269  VARCHAR2 := fnd_api.g_miss_char
    , p7_a270  VARCHAR2 := fnd_api.g_miss_char
    , p7_a271  VARCHAR2 := fnd_api.g_miss_char
    , p7_a272  VARCHAR2 := fnd_api.g_miss_char
    , p7_a273  VARCHAR2 := fnd_api.g_miss_char
    , p7_a274  VARCHAR2 := fnd_api.g_miss_char
    , p7_a275  VARCHAR2 := fnd_api.g_miss_char
    , p7_a276  VARCHAR2 := fnd_api.g_miss_char
    , p7_a277  VARCHAR2 := fnd_api.g_miss_char
    , p7_a278  VARCHAR2 := fnd_api.g_miss_char
    , p7_a279  VARCHAR2 := fnd_api.g_miss_char
    , p7_a280  VARCHAR2 := fnd_api.g_miss_char
    , p7_a281  VARCHAR2 := fnd_api.g_miss_char
    , p7_a282  VARCHAR2 := fnd_api.g_miss_char
    , p7_a283  VARCHAR2 := fnd_api.g_miss_char
    , p7_a284  VARCHAR2 := fnd_api.g_miss_char
    , p7_a285  VARCHAR2 := fnd_api.g_miss_char
    , p7_a286  VARCHAR2 := fnd_api.g_miss_char
    , p7_a287  VARCHAR2 := fnd_api.g_miss_char
    , p7_a288  VARCHAR2 := fnd_api.g_miss_char
    , p7_a289  VARCHAR2 := fnd_api.g_miss_char
    , p7_a290  VARCHAR2 := fnd_api.g_miss_char
    , p7_a291  VARCHAR2 := fnd_api.g_miss_char
    , p7_a292  VARCHAR2 := fnd_api.g_miss_char
    , p7_a293  VARCHAR2 := fnd_api.g_miss_char
    , p7_a294  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_is_line_rec ams_is_line_pvt.is_line_rec_type;

Line: 3080


    ddp_is_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);

Line: 3081


    ddp_is_line_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);

Line: 3084


    ddp_is_line_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);

Line: 3376


    ams_is_line_pvt.update_is_line(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_is_line_rec,
      x_object_version_number);

Line: 3711


    ddp_is_line_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a2);

Line: 3712


    ddp_is_line_rec.last_updated_by := rosetta_g_miss_num_map(p3_a3);

Line: 3715


    ddp_is_line_rec.last_update_login := rosetta_g_miss_num_map(p3_a6);

Line: 4333


    ddp_is_line_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);

Line: 4334


    ddp_is_line_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);

Line: 4337


    ddp_is_line_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);

Line: 4954


    ddp_is_line_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a2);

Line: 4955


    ddp_is_line_rec.last_updated_by := rosetta_g_miss_num_map(p5_a3);

Line: 4958


    ddp_is_line_rec.last_update_login := rosetta_g_miss_num_map(p5_a6);