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

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

Line: 155


    ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 156


    ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 159


    ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);

Line: 164


    ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a10);

Line: 174


    ddp_listheader_rec.row_selection_type := p7_a20;

Line: 205


    ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p7_a51);

Line: 206


    ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p7_a52);

Line: 207


    ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p7_a53);

Line: 208


    ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p7_a54);

Line: 287


  procedure update_listheader(p_api_version  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
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  DATE := fnd_api.g_miss_date
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  DATE := fnd_api.g_miss_date
    , p7_a4  NUMBER := 0-1962.0724
    , 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  NUMBER := 0-1962.0724
    , p7_a10  DATE := fnd_api.g_miss_date
    , p7_a11  NUMBER := 0-1962.0724
    , p7_a12  VARCHAR2 := fnd_api.g_miss_char
    , p7_a13  NUMBER := 0-1962.0724
    , 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  DATE := fnd_api.g_miss_date
    , 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  NUMBER := 0-1962.0724
    , 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  DATE := fnd_api.g_miss_date
    , p7_a30  DATE := fnd_api.g_miss_date
    , p7_a31  DATE := fnd_api.g_miss_date
    , p7_a32  DATE := fnd_api.g_miss_date
    , p7_a33  DATE := fnd_api.g_miss_date
    , p7_a34  DATE := fnd_api.g_miss_date
    , p7_a35  NUMBER := 0-1962.0724
    , p7_a36  NUMBER := 0-1962.0724
    , p7_a37  NUMBER := 0-1962.0724
    , p7_a38  NUMBER := 0-1962.0724
    , p7_a39  NUMBER := 0-1962.0724
    , 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  NUMBER := 0-1962.0724
    , p7_a45  NUMBER := 0-1962.0724
    , p7_a46  NUMBER := 0-1962.0724
    , p7_a47  NUMBER := 0-1962.0724
    , p7_a48  NUMBER := 0-1962.0724
    , p7_a49  DATE := fnd_api.g_miss_date
    , p7_a50  DATE := fnd_api.g_miss_date
    , p7_a51  NUMBER := 0-1962.0724
    , p7_a52  NUMBER := 0-1962.0724
    , p7_a53  NUMBER := 0-1962.0724
    , p7_a54  NUMBER := 0-1962.0724
    , 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  NUMBER := 0-1962.0724
    , p7_a60  NUMBER := 0-1962.0724
    , 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  NUMBER := 0-1962.0724
    , p7_a65  VARCHAR2 := fnd_api.g_miss_char
    , p7_a66  NUMBER := 0-1962.0724
    , p7_a67  NUMBER := 0-1962.0724
    , p7_a68  NUMBER := 0-1962.0724
    , p7_a69  NUMBER := 0-1962.0724
    , p7_a70  DATE := fnd_api.g_miss_date
    , 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  NUMBER := 0-1962.0724
    , p7_a88  DATE := fnd_api.g_miss_date
    , p7_a89  NUMBER := 0-1962.0724
    , p7_a90  NUMBER := 0-1962.0724
    , p7_a91  NUMBER := 0-1962.0724
    , p7_a92  VARCHAR2 := fnd_api.g_miss_char
    , p7_a93  NUMBER := 0-1962.0724
    , p7_a94  VARCHAR2 := fnd_api.g_miss_char
    , p7_a95  NUMBER := 0-1962.0724
    , p7_a96  NUMBER := 0-1962.0724
    , 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  NUMBER := 0-1962.0724
    , p7_a104  NUMBER := 0-1962.0724
    , p7_a105  NUMBER := 0-1962.0724
    , p7_a106  VARCHAR2 := fnd_api.g_miss_char
    , p7_a107  NUMBER := 0-1962.0724
    , p7_a108  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;

Line: 419


    ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 420


    ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 423


    ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);

Line: 428


    ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a10);

Line: 438


    ddp_listheader_rec.row_selection_type := p7_a20;

Line: 469


    ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p7_a51);

Line: 470


    ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p7_a52);

Line: 471


    ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p7_a53);

Line: 472


    ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p7_a54);

Line: 529


    ams_listheader_pvt.update_listheader(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_listheader_rec);

Line: 678


    ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);

Line: 679


    ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);

Line: 682


    ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);

Line: 687


    ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a10);

Line: 697


    ddp_listheader_rec.row_selection_type := p6_a20;

Line: 728


    ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p6_a51);

Line: 729


    ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p6_a52);

Line: 730


    ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p6_a53);

Line: 731


    ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p6_a54);

Line: 925


    ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 926


    ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 929


    ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 934


    ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a10);

Line: 944


    ddp_listheader_rec.row_selection_type := p0_a20;

Line: 975


    ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p0_a51);

Line: 976


    ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p0_a52);

Line: 977


    ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p0_a53);

Line: 978


    ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p0_a54);

Line: 1275


    ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1276


    ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 1279


    ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 1284


    ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a10);

Line: 1294


    ddp_listheader_rec.row_selection_type := p0_a20;

Line: 1325


    ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p0_a51);

Line: 1326


    ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p0_a52);

Line: 1327


    ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p0_a53);

Line: 1328


    ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p0_a54);

Line: 1385


    ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);

Line: 1386


    ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);

Line: 1389


    ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);

Line: 1394


    ddp_complete_rec.program_update_date := rosetta_g_miss_date_in_map(p1_a10);

Line: 1404


    ddp_complete_rec.row_selection_type := p1_a20;

Line: 1435


    ddp_complete_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p1_a51);

Line: 1436


    ddp_complete_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p1_a52);

Line: 1437


    ddp_complete_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p1_a53);

Line: 1438


    ddp_complete_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p1_a54);

Line: 1628


    p0_a1 := ddx_listheader_rec.last_update_date;

Line: 1629


    p0_a2 := rosetta_g_miss_num_map(ddx_listheader_rec.last_updated_by);

Line: 1632


    p0_a5 := rosetta_g_miss_num_map(ddx_listheader_rec.last_update_login);

Line: 1637


    p0_a10 := ddx_listheader_rec.program_update_date;

Line: 1647


    p0_a20 := ddx_listheader_rec.row_selection_type;

Line: 1678


    p0_a51 := rosetta_g_miss_num_map(ddx_listheader_rec.main_random_nth_row_selection);

Line: 1679


    p0_a52 := rosetta_g_miss_num_map(ddx_listheader_rec.main_random_pct_row_selection);

Line: 1680


    p0_a53 := rosetta_g_miss_num_map(ddx_listheader_rec.ctrl_random_nth_row_selection);

Line: 1681


    p0_a54 := rosetta_g_miss_num_map(ddx_listheader_rec.ctrl_random_pct_row_selection);

Line: 1966


    ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1967


    ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 1970


    ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);

Line: 1975


    ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a10);

Line: 1985


    ddp_listheader_rec.row_selection_type := p0_a20;

Line: 2016


    ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p0_a51);

Line: 2017


    ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p0_a52);

Line: 2018


    ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p0_a53);

Line: 2019


    ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p0_a54);

Line: 2083


    p1_a1 := ddx_complete_rec.last_update_date;

Line: 2084


    p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);

Line: 2087


    p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);

Line: 2092


    p1_a10 := ddx_complete_rec.program_update_date;

Line: 2102


    p1_a20 := ddx_complete_rec.row_selection_type;

Line: 2133


    p1_a51 := rosetta_g_miss_num_map(ddx_complete_rec.main_random_nth_row_selection);

Line: 2134


    p1_a52 := rosetta_g_miss_num_map(ddx_complete_rec.main_random_pct_row_selection);

Line: 2135


    p1_a53 := rosetta_g_miss_num_map(ddx_complete_rec.ctrl_random_nth_row_selection);

Line: 2136


    p1_a54 := rosetta_g_miss_num_map(ddx_complete_rec.ctrl_random_pct_row_selection);

Line: 2193


  procedure update_prev_contacted_count(p_used_by_id  NUMBER
    , p_used_by  VARCHAR2
    , p_last_contacted_date  date
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_last_contacted_date date;

Line: 2219


    ams_listheader_pvt.update_prev_contacted_count(p_used_by_id,
      p_used_by,
      ddp_last_contacted_date,
      p_init_msg_list,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 2246


    , p_copy_select_actions  VARCHAR2
    , p_copy_list_queries  VARCHAR2
    , p_copy_list_entries  VARCHAR2
    , x_listheader_id out nocopy  NUMBER
    , p8_a0  NUMBER := 0-1962.0724
    , p8_a1  DATE := fnd_api.g_miss_date
    , p8_a2  NUMBER := 0-1962.0724
    , p8_a3  DATE := fnd_api.g_miss_date
    , p8_a4  NUMBER := 0-1962.0724
    , p8_a5  NUMBER := 0-1962.0724
    , p8_a6  NUMBER := 0-1962.0724
    , p8_a7  NUMBER := 0-1962.0724
    , p8_a8  NUMBER := 0-1962.0724
    , p8_a9  NUMBER := 0-1962.0724
    , p8_a10  DATE := fnd_api.g_miss_date
    , p8_a11  NUMBER := 0-1962.0724
    , p8_a12  VARCHAR2 := fnd_api.g_miss_char
    , p8_a13  NUMBER := 0-1962.0724
    , p8_a14  VARCHAR2 := fnd_api.g_miss_char
    , p8_a15  VARCHAR2 := fnd_api.g_miss_char
    , p8_a16  VARCHAR2 := fnd_api.g_miss_char
    , p8_a17  DATE := fnd_api.g_miss_date
    , p8_a18  VARCHAR2 := fnd_api.g_miss_char
    , p8_a19  VARCHAR2 := fnd_api.g_miss_char
    , p8_a20  VARCHAR2 := fnd_api.g_miss_char
    , p8_a21  NUMBER := 0-1962.0724
    , p8_a22  VARCHAR2 := fnd_api.g_miss_char
    , p8_a23  VARCHAR2 := fnd_api.g_miss_char
    , p8_a24  VARCHAR2 := fnd_api.g_miss_char
    , p8_a25  VARCHAR2 := fnd_api.g_miss_char
    , p8_a26  VARCHAR2 := fnd_api.g_miss_char
    , p8_a27  VARCHAR2 := fnd_api.g_miss_char
    , p8_a28  VARCHAR2 := fnd_api.g_miss_char
    , p8_a29  DATE := fnd_api.g_miss_date
    , p8_a30  DATE := fnd_api.g_miss_date
    , p8_a31  DATE := fnd_api.g_miss_date
    , p8_a32  DATE := fnd_api.g_miss_date
    , p8_a33  DATE := fnd_api.g_miss_date
    , p8_a34  DATE := fnd_api.g_miss_date
    , p8_a35  NUMBER := 0-1962.0724
    , p8_a36  NUMBER := 0-1962.0724
    , p8_a37  NUMBER := 0-1962.0724
    , p8_a38  NUMBER := 0-1962.0724
    , p8_a39  NUMBER := 0-1962.0724
    , p8_a40  NUMBER := 0-1962.0724
    , p8_a41  NUMBER := 0-1962.0724
    , p8_a42  NUMBER := 0-1962.0724
    , p8_a43  NUMBER := 0-1962.0724
    , p8_a44  NUMBER := 0-1962.0724
    , p8_a45  NUMBER := 0-1962.0724
    , p8_a46  NUMBER := 0-1962.0724
    , p8_a47  NUMBER := 0-1962.0724
    , p8_a48  NUMBER := 0-1962.0724
    , p8_a49  DATE := fnd_api.g_miss_date
    , p8_a50  DATE := fnd_api.g_miss_date
    , p8_a51  NUMBER := 0-1962.0724
    , p8_a52  NUMBER := 0-1962.0724
    , p8_a53  NUMBER := 0-1962.0724
    , p8_a54  NUMBER := 0-1962.0724
    , p8_a55  VARCHAR2 := fnd_api.g_miss_char
    , p8_a56  VARCHAR2 := fnd_api.g_miss_char
    , p8_a57  VARCHAR2 := fnd_api.g_miss_char
    , p8_a58  VARCHAR2 := fnd_api.g_miss_char
    , p8_a59  NUMBER := 0-1962.0724
    , p8_a60  NUMBER := 0-1962.0724
    , p8_a61  VARCHAR2 := fnd_api.g_miss_char
    , p8_a62  VARCHAR2 := fnd_api.g_miss_char
    , p8_a63  VARCHAR2 := fnd_api.g_miss_char
    , p8_a64  NUMBER := 0-1962.0724
    , p8_a65  VARCHAR2 := fnd_api.g_miss_char
    , p8_a66  NUMBER := 0-1962.0724
    , p8_a67  NUMBER := 0-1962.0724
    , p8_a68  NUMBER := 0-1962.0724
    , p8_a69  NUMBER := 0-1962.0724
    , p8_a70  DATE := fnd_api.g_miss_date
    , p8_a71  VARCHAR2 := fnd_api.g_miss_char
    , p8_a72  VARCHAR2 := fnd_api.g_miss_char
    , p8_a73  VARCHAR2 := fnd_api.g_miss_char
    , p8_a74  VARCHAR2 := fnd_api.g_miss_char
    , p8_a75  VARCHAR2 := fnd_api.g_miss_char
    , p8_a76  VARCHAR2 := fnd_api.g_miss_char
    , p8_a77  VARCHAR2 := fnd_api.g_miss_char
    , p8_a78  VARCHAR2 := fnd_api.g_miss_char
    , p8_a79  VARCHAR2 := fnd_api.g_miss_char
    , p8_a80  VARCHAR2 := fnd_api.g_miss_char
    , p8_a81  VARCHAR2 := fnd_api.g_miss_char
    , p8_a82  VARCHAR2 := fnd_api.g_miss_char
    , p8_a83  VARCHAR2 := fnd_api.g_miss_char
    , p8_a84  VARCHAR2 := fnd_api.g_miss_char
    , p8_a85  VARCHAR2 := fnd_api.g_miss_char
    , p8_a86  VARCHAR2 := fnd_api.g_miss_char
    , p8_a87  NUMBER := 0-1962.0724
    , p8_a88  DATE := fnd_api.g_miss_date
    , p8_a89  NUMBER := 0-1962.0724
    , p8_a90  NUMBER := 0-1962.0724
    , p8_a91  NUMBER := 0-1962.0724
    , p8_a92  VARCHAR2 := fnd_api.g_miss_char
    , p8_a93  NUMBER := 0-1962.0724
    , p8_a94  VARCHAR2 := fnd_api.g_miss_char
    , p8_a95  NUMBER := 0-1962.0724
    , p8_a96  NUMBER := 0-1962.0724
    , p8_a97  VARCHAR2 := fnd_api.g_miss_char
    , p8_a98  VARCHAR2 := fnd_api.g_miss_char
    , p8_a99  VARCHAR2 := fnd_api.g_miss_char
    , p8_a100  VARCHAR2 := fnd_api.g_miss_char
    , p8_a101  VARCHAR2 := fnd_api.g_miss_char
    , p8_a102  VARCHAR2 := fnd_api.g_miss_char
    , p8_a103  NUMBER := 0-1962.0724
    , p8_a104  NUMBER := 0-1962.0724
    , p8_a105  NUMBER := 0-1962.0724
    , p8_a106  VARCHAR2 := fnd_api.g_miss_char
    , p8_a107  NUMBER := 0-1962.0724
    , p8_a108  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;

Line: 2376


    ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a1);

Line: 2377


    ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p8_a2);

Line: 2380


    ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p8_a5);

Line: 2385


    ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p8_a10);

Line: 2395


    ddp_listheader_rec.row_selection_type := p8_a20;

Line: 2426


    ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p8_a51);

Line: 2427


    ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p8_a52);

Line: 2428


    ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p8_a53);

Line: 2429


    ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p8_a54);

Line: 2499


      p_copy_select_actions,
      p_copy_list_queries,
      p_copy_list_entries,
      x_listheader_id);