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_LIST_ENTRIES_PVT_W SQL Statements

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

Line: 420


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

Line: 421


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

Line: 424


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

Line: 426


          t(ddindx).list_select_action_id := rosetta_g_miss_num_map(a8(indx));

Line: 427


          t(ddindx).arc_list_select_action_from := a9(indx);

Line: 428


          t(ddindx).list_select_action_from_name := a10(indx);

Line: 795


          t(ddindx).newly_updated_flag := a377(indx);

Line: 2378


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

Line: 2379


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

Line: 2382


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

Line: 2384


          a8(indx) := rosetta_g_miss_num_map(t(ddindx).list_select_action_id);

Line: 2385


          a9(indx) := t(ddindx).arc_list_select_action_from;

Line: 2386


          a10(indx) := t(ddindx).list_select_action_from_name;

Line: 2753


          a377(indx) := t(ddindx).newly_updated_flag;

Line: 3186


    ddp_list_entries_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);

Line: 3187


    ddp_list_entries_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);

Line: 3190


    ddp_list_entries_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);

Line: 3192


    ddp_list_entries_rec.list_select_action_id := rosetta_g_miss_num_map(p7_a8);

Line: 3193


    ddp_list_entries_rec.arc_list_select_action_from := p7_a9;

Line: 3194


    ddp_list_entries_rec.list_select_action_from_name := p7_a10;

Line: 3561


    ddp_list_entries_rec.newly_updated_flag := p7_a377;

Line: 3596


  procedure update_list_entries(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  NUMBER := 0-1962.0724
    , p7_a9  VARCHAR2 := fnd_api.g_miss_char
    , p7_a10  VARCHAR2 := fnd_api.g_miss_char
    , p7_a11  VARCHAR2 := fnd_api.g_miss_char
    , p7_a12  VARCHAR2 := fnd_api.g_miss_char
    , p7_a13  NUMBER := 0-1962.0724
    , p7_a14  VARCHAR2 := fnd_api.g_miss_char
    , p7_a15  NUMBER := 0-1962.0724
    , p7_a16  VARCHAR2 := fnd_api.g_miss_char
    , p7_a17  NUMBER := 0-1962.0724
    , 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  NUMBER := 0-1962.0724
    , p7_a27  NUMBER := 0-1962.0724
    , p7_a28  NUMBER := 0-1962.0724
    , p7_a29  NUMBER := 0-1962.0724
    , p7_a30  NUMBER := 0-1962.0724
    , p7_a31  NUMBER := 0-1962.0724
    , p7_a32  NUMBER := 0-1962.0724
    , p7_a33  NUMBER := 0-1962.0724
    , p7_a34  NUMBER := 0-1962.0724
    , 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  NUMBER := 0-1962.0724
    , p7_a39  VARCHAR2 := fnd_api.g_miss_char
    , p7_a40  NUMBER := 0-1962.0724
    , p7_a41  NUMBER := 0-1962.0724
    , p7_a42  NUMBER := 0-1962.0724
    , p7_a43  NUMBER := 0-1962.0724
    , 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  VARCHAR2 := fnd_api.g_miss_char
    , 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
    , p7_a295  VARCHAR2 := fnd_api.g_miss_char
    , p7_a296  VARCHAR2 := fnd_api.g_miss_char
    , p7_a297  VARCHAR2 := fnd_api.g_miss_char
    , p7_a298  VARCHAR2 := fnd_api.g_miss_char
    , p7_a299  VARCHAR2 := fnd_api.g_miss_char
    , p7_a300  VARCHAR2 := fnd_api.g_miss_char
    , p7_a301  VARCHAR2 := fnd_api.g_miss_char
    , p7_a302  VARCHAR2 := fnd_api.g_miss_char
    , p7_a303  VARCHAR2 := fnd_api.g_miss_char
    , p7_a304  VARCHAR2 := fnd_api.g_miss_char
    , p7_a305  VARCHAR2 := fnd_api.g_miss_char
    , p7_a306  VARCHAR2 := fnd_api.g_miss_char
    , p7_a307  VARCHAR2 := fnd_api.g_miss_char
    , p7_a308  VARCHAR2 := fnd_api.g_miss_char
    , p7_a309  VARCHAR2 := fnd_api.g_miss_char
    , p7_a310  VARCHAR2 := fnd_api.g_miss_char
    , p7_a311  VARCHAR2 := fnd_api.g_miss_char
    , p7_a312  VARCHAR2 := fnd_api.g_miss_char
    , p7_a313  VARCHAR2 := fnd_api.g_miss_char
    , p7_a314  VARCHAR2 := fnd_api.g_miss_char
    , p7_a315  VARCHAR2 := fnd_api.g_miss_char
    , p7_a316  VARCHAR2 := fnd_api.g_miss_char
    , p7_a317  VARCHAR2 := fnd_api.g_miss_char
    , p7_a318  VARCHAR2 := fnd_api.g_miss_char
    , p7_a319  VARCHAR2 := fnd_api.g_miss_char
    , p7_a320  VARCHAR2 := fnd_api.g_miss_char
    , p7_a321  VARCHAR2 := fnd_api.g_miss_char
    , p7_a322  VARCHAR2 := fnd_api.g_miss_char
    , p7_a323  VARCHAR2 := fnd_api.g_miss_char
    , p7_a324  VARCHAR2 := fnd_api.g_miss_char
    , p7_a325  VARCHAR2 := fnd_api.g_miss_char
    , p7_a326  VARCHAR2 := fnd_api.g_miss_char
    , p7_a327  VARCHAR2 := fnd_api.g_miss_char
    , p7_a328  VARCHAR2 := fnd_api.g_miss_char
    , p7_a329  VARCHAR2 := fnd_api.g_miss_char
    , p7_a330  VARCHAR2 := fnd_api.g_miss_char
    , p7_a331  VARCHAR2 := fnd_api.g_miss_char
    , p7_a332  VARCHAR2 := fnd_api.g_miss_char
    , p7_a333  VARCHAR2 := fnd_api.g_miss_char
    , p7_a334  VARCHAR2 := fnd_api.g_miss_char
    , p7_a335  VARCHAR2 := fnd_api.g_miss_char
    , p7_a336  VARCHAR2 := fnd_api.g_miss_char
    , p7_a337  VARCHAR2 := fnd_api.g_miss_char
    , p7_a338  VARCHAR2 := fnd_api.g_miss_char
    , p7_a339  VARCHAR2 := fnd_api.g_miss_char
    , p7_a340  VARCHAR2 := fnd_api.g_miss_char
    , p7_a341  VARCHAR2 := fnd_api.g_miss_char
    , p7_a342  VARCHAR2 := fnd_api.g_miss_char
    , p7_a343  VARCHAR2 := fnd_api.g_miss_char
    , p7_a344  VARCHAR2 := fnd_api.g_miss_char
    , p7_a345  VARCHAR2 := fnd_api.g_miss_char
    , p7_a346  VARCHAR2 := fnd_api.g_miss_char
    , p7_a347  VARCHAR2 := fnd_api.g_miss_char
    , p7_a348  VARCHAR2 := fnd_api.g_miss_char
    , p7_a349  VARCHAR2 := fnd_api.g_miss_char
    , p7_a350  VARCHAR2 := fnd_api.g_miss_char
    , p7_a351  VARCHAR2 := fnd_api.g_miss_char
    , p7_a352  VARCHAR2 := fnd_api.g_miss_char
    , p7_a353  VARCHAR2 := fnd_api.g_miss_char
    , p7_a354  VARCHAR2 := fnd_api.g_miss_char
    , p7_a355  VARCHAR2 := fnd_api.g_miss_char
    , p7_a356  VARCHAR2 := fnd_api.g_miss_char
    , p7_a357  VARCHAR2 := fnd_api.g_miss_char
    , p7_a358  VARCHAR2 := fnd_api.g_miss_char
    , p7_a359  VARCHAR2 := fnd_api.g_miss_char
    , p7_a360  VARCHAR2 := fnd_api.g_miss_char
    , p7_a361  NUMBER := 0-1962.0724
    , p7_a362  NUMBER := 0-1962.0724
    , p7_a363  NUMBER := 0-1962.0724
    , p7_a364  NUMBER := 0-1962.0724
    , p7_a365  NUMBER := 0-1962.0724
    , p7_a366  NUMBER := 0-1962.0724
    , p7_a367  NUMBER := 0-1962.0724
    , p7_a368  NUMBER := 0-1962.0724
    , p7_a369  VARCHAR2 := fnd_api.g_miss_char
    , p7_a370  DATE := fnd_api.g_miss_date
    , p7_a371  VARCHAR2 := fnd_api.g_miss_char
    , p7_a372  VARCHAR2 := fnd_api.g_miss_char
    , p7_a373  VARCHAR2 := fnd_api.g_miss_char
    , p7_a374  VARCHAR2 := fnd_api.g_miss_char
    , p7_a375  DATE := fnd_api.g_miss_date
    , p7_a376  VARCHAR2 := fnd_api.g_miss_char
    , p7_a377  VARCHAR2 := fnd_api.g_miss_char
    , p7_a378  NUMBER := 0-1962.0724
    , p7_a379  NUMBER := 0-1962.0724
    , p7_a380  NUMBER := 0-1962.0724
    , p7_a381  VARCHAR2 := fnd_api.g_miss_char
    , p7_a382  VARCHAR2 := fnd_api.g_miss_char
    , p7_a383  VARCHAR2 := fnd_api.g_miss_char
    , p7_a384  NUMBER := 0-1962.0724
    , p7_a385  NUMBER := 0-1962.0724
    , p7_a386  NUMBER := 0-1962.0724
    , p7_a387  DATE := fnd_api.g_miss_date
  )
  as
    ddp_list_entries_rec ams_list_entries_pvt.list_entries_rec_type;

Line: 4008


    ddp_list_entries_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);

Line: 4009


    ddp_list_entries_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);

Line: 4012


    ddp_list_entries_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);

Line: 4014


    ddp_list_entries_rec.list_select_action_id := rosetta_g_miss_num_map(p7_a8);

Line: 4015


    ddp_list_entries_rec.arc_list_select_action_from := p7_a9;

Line: 4016


    ddp_list_entries_rec.list_select_action_from_name := p7_a10;

Line: 4383


    ddp_list_entries_rec.newly_updated_flag := p7_a377;

Line: 4397


    ams_list_entries_pvt.update_list_entries(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_list_entries_rec,
      x_object_version_number);

Line: 4826


    ddp_list_entries_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a2);

Line: 4827


    ddp_list_entries_rec.last_updated_by := rosetta_g_miss_num_map(p4_a3);

Line: 4830


    ddp_list_entries_rec.last_update_login := rosetta_g_miss_num_map(p4_a6);

Line: 4832


    ddp_list_entries_rec.list_select_action_id := rosetta_g_miss_num_map(p4_a8);

Line: 4833


    ddp_list_entries_rec.arc_list_select_action_from := p4_a9;

Line: 4834


    ddp_list_entries_rec.list_select_action_from_name := p4_a10;

Line: 5201


    ddp_list_entries_rec.newly_updated_flag := p4_a377;

Line: 5635


    ddp_list_entries_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);

Line: 5636


    ddp_list_entries_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);

Line: 5639


    ddp_list_entries_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);

Line: 5641


    ddp_list_entries_rec.list_select_action_id := rosetta_g_miss_num_map(p0_a8);

Line: 5642


    ddp_list_entries_rec.arc_list_select_action_from := p0_a9;

Line: 5643


    ddp_list_entries_rec.list_select_action_from_name := p0_a10;

Line: 6010


    ddp_list_entries_rec.newly_updated_flag := p0_a377;

Line: 6441


    ddp_list_entries_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a2);

Line: 6442


    ddp_list_entries_rec.last_updated_by := rosetta_g_miss_num_map(p5_a3);

Line: 6445


    ddp_list_entries_rec.last_update_login := rosetta_g_miss_num_map(p5_a6);

Line: 6447


    ddp_list_entries_rec.list_select_action_id := rosetta_g_miss_num_map(p5_a8);

Line: 6448


    ddp_list_entries_rec.arc_list_select_action_from := p5_a9;

Line: 6449


    ddp_list_entries_rec.list_select_action_from_name := p5_a10;

Line: 6816


    ddp_list_entries_rec.newly_updated_flag := p5_a377;

Line: 7246


    p0_a2 := ddx_entry_rec.last_update_date;

Line: 7247


    p0_a3 := rosetta_g_miss_num_map(ddx_entry_rec.last_updated_by);

Line: 7250


    p0_a6 := rosetta_g_miss_num_map(ddx_entry_rec.last_update_login);

Line: 7252


    p0_a8 := rosetta_g_miss_num_map(ddx_entry_rec.list_select_action_id);

Line: 7253


    p0_a9 := ddx_entry_rec.arc_list_select_action_from;

Line: 7254


    p0_a10 := ddx_entry_rec.list_select_action_from_name;

Line: 7621


    p0_a377 := ddx_entry_rec.newly_updated_flag;