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

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

Line: 124


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

Line: 125


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

Line: 128


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

Line: 132


          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a9(indx));

Line: 179


          t(ddindx).deleted_flag := a56(indx);

Line: 607


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

Line: 608


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

Line: 611


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

Line: 615


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

Line: 662


          a56(indx) := t(ddindx).deleted_flag;

Line: 755


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

Line: 756


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

Line: 759


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

Line: 763


          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a9(indx));

Line: 958


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

Line: 959


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

Line: 962


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

Line: 966


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

Line: 1101


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

Line: 1102


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

Line: 1105


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

Line: 1109


          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a11(indx));

Line: 1299


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

Line: 1300


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

Line: 1303


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

Line: 1307


          a11(indx) := t(ddindx).program_update_date;

Line: 1652


    ddp_sales_lead_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a1);

Line: 1653


    ddp_sales_lead_rec.last_updated_by := rosetta_g_miss_num_map(p9_a2);

Line: 1656


    ddp_sales_lead_rec.last_update_login := rosetta_g_miss_num_map(p9_a5);

Line: 1660


    ddp_sales_lead_rec.program_update_date := rosetta_g_miss_date_in_map(p9_a9);

Line: 1707


    ddp_sales_lead_rec.deleted_flag := p9_a56;

Line: 1874


  procedure update_sales_lead(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_check_access_flag  VARCHAR2
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_identity_salesforce_id  NUMBER
    , p8_a0 JTF_VARCHAR2_TABLE_100
    , p8_a1 JTF_VARCHAR2_TABLE_300
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p9_a0  NUMBER := 0-1962.0724
    , p9_a1  DATE := fnd_api.g_miss_date
    , p9_a2  NUMBER := 0-1962.0724
    , p9_a3  DATE := fnd_api.g_miss_date
    , p9_a4  NUMBER := 0-1962.0724
    , p9_a5  NUMBER := 0-1962.0724
    , p9_a6  NUMBER := 0-1962.0724
    , p9_a7  NUMBER := 0-1962.0724
    , p9_a8  NUMBER := 0-1962.0724
    , p9_a9  DATE := fnd_api.g_miss_date
    , p9_a10  VARCHAR2 := fnd_api.g_miss_char
    , p9_a11  VARCHAR2 := fnd_api.g_miss_char
    , p9_a12  NUMBER := 0-1962.0724
    , p9_a13  NUMBER := 0-1962.0724
    , p9_a14  NUMBER := 0-1962.0724
    , p9_a15  NUMBER := 0-1962.0724
    , p9_a16  VARCHAR2 := fnd_api.g_miss_char
    , p9_a17  VARCHAR2 := fnd_api.g_miss_char
    , p9_a18  VARCHAR2 := fnd_api.g_miss_char
    , p9_a19  NUMBER := 0-1962.0724
    , p9_a20  VARCHAR2 := fnd_api.g_miss_char
    , p9_a21  VARCHAR2 := fnd_api.g_miss_char
    , p9_a22  VARCHAR2 := fnd_api.g_miss_char
    , p9_a23  NUMBER := 0-1962.0724
    , p9_a24  VARCHAR2 := fnd_api.g_miss_char
    , p9_a25  VARCHAR2 := fnd_api.g_miss_char
    , p9_a26  VARCHAR2 := fnd_api.g_miss_char
    , p9_a27  VARCHAR2 := fnd_api.g_miss_char
    , p9_a28  VARCHAR2 := fnd_api.g_miss_char
    , p9_a29  VARCHAR2 := fnd_api.g_miss_char
    , p9_a30  VARCHAR2 := fnd_api.g_miss_char
    , p9_a31  VARCHAR2 := fnd_api.g_miss_char
    , p9_a32  VARCHAR2 := fnd_api.g_miss_char
    , p9_a33  VARCHAR2 := fnd_api.g_miss_char
    , p9_a34  VARCHAR2 := fnd_api.g_miss_char
    , p9_a35  VARCHAR2 := fnd_api.g_miss_char
    , p9_a36  VARCHAR2 := fnd_api.g_miss_char
    , p9_a37  VARCHAR2 := fnd_api.g_miss_char
    , p9_a38  VARCHAR2 := fnd_api.g_miss_char
    , p9_a39  VARCHAR2 := fnd_api.g_miss_char
    , p9_a40  VARCHAR2 := fnd_api.g_miss_char
    , p9_a41  VARCHAR2 := fnd_api.g_miss_char
    , p9_a42  VARCHAR2 := fnd_api.g_miss_char
    , p9_a43  NUMBER := 0-1962.0724
    , p9_a44  NUMBER := 0-1962.0724
    , p9_a45  NUMBER := 0-1962.0724
    , p9_a46  DATE := fnd_api.g_miss_date
    , p9_a47  VARCHAR2 := fnd_api.g_miss_char
    , p9_a48  VARCHAR2 := fnd_api.g_miss_char
    , p9_a49  VARCHAR2 := fnd_api.g_miss_char
    , p9_a50  NUMBER := 0-1962.0724
    , p9_a51  NUMBER := 0-1962.0724
    , p9_a52  VARCHAR2 := fnd_api.g_miss_char
    , p9_a53  VARCHAR2 := fnd_api.g_miss_char
    , p9_a54  VARCHAR2 := fnd_api.g_miss_char
    , p9_a55  VARCHAR2 := fnd_api.g_miss_char
    , p9_a56  VARCHAR2 := fnd_api.g_miss_char
    , p9_a57  NUMBER := 0-1962.0724
    , p9_a58  NUMBER := 0-1962.0724
    , p9_a59  NUMBER := 0-1962.0724
    , p9_a60  VARCHAR2 := fnd_api.g_miss_char
    , p9_a61  VARCHAR2 := fnd_api.g_miss_char
    , p9_a62  VARCHAR2 := fnd_api.g_miss_char
    , p9_a63  VARCHAR2 := fnd_api.g_miss_char
    , p9_a64  VARCHAR2 := fnd_api.g_miss_char
    , p9_a65  VARCHAR2 := fnd_api.g_miss_char
    , p9_a66  VARCHAR2 := fnd_api.g_miss_char
    , p9_a67  VARCHAR2 := fnd_api.g_miss_char
    , p9_a68  NUMBER := 0-1962.0724
    , p9_a69  NUMBER := 0-1962.0724
    , p9_a70  NUMBER := 0-1962.0724
    , p9_a71  NUMBER := 0-1962.0724
    , p9_a72  VARCHAR2 := fnd_api.g_miss_char
    , p9_a73  VARCHAR2 := fnd_api.g_miss_char
    , p9_a74  VARCHAR2 := fnd_api.g_miss_char
    , p9_a75  VARCHAR2 := fnd_api.g_miss_char
    , p9_a76  NUMBER := 0-1962.0724
    , p9_a77  NUMBER := 0-1962.0724
    , p9_a78  NUMBER := 0-1962.0724
    , p9_a79  DATE := fnd_api.g_miss_date
    , p9_a80  VARCHAR2 := fnd_api.g_miss_char
    , p9_a81  VARCHAR2 := fnd_api.g_miss_char
    , p9_a82  NUMBER := 0-1962.0724
    , p9_a83  DATE := fnd_api.g_miss_date
    , p9_a84  DATE := fnd_api.g_miss_date
    , p9_a85  VARCHAR2 := fnd_api.g_miss_char
    , p9_a86  NUMBER := 0-1962.0724
    , p9_a87  NUMBER := 0-1962.0724
    , p9_a88  NUMBER := 0-1962.0724
    , p9_a89  VARCHAR2 := fnd_api.g_miss_char
    , p9_a90  VARCHAR2 := fnd_api.g_miss_char
    , p9_a91  NUMBER := 0-1962.0724
    , p9_a92  NUMBER := 0-1962.0724
  )

  as
    ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

Line: 2002


    ddp_sales_lead_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a1);

Line: 2003


    ddp_sales_lead_rec.last_updated_by := rosetta_g_miss_num_map(p9_a2);

Line: 2006


    ddp_sales_lead_rec.last_update_login := rosetta_g_miss_num_map(p9_a5);

Line: 2010


    ddp_sales_lead_rec.program_update_date := rosetta_g_miss_date_in_map(p9_a9);

Line: 2057


    ddp_sales_lead_rec.deleted_flag := p9_a56;

Line: 2099


    as_sales_leads_pub.update_sales_lead(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_identity_salesforce_id,
      ddp_sales_lead_profile_tbl,
      ddp_sales_lead_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 2284


  procedure update_sales_lead_lines(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_check_access_flag  VARCHAR2
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_identity_salesforce_id  NUMBER
    , p8_a0 JTF_VARCHAR2_TABLE_100
    , p8_a1 JTF_VARCHAR2_TABLE_300
    , p9_a0 JTF_NUMBER_TABLE
    , p9_a1 JTF_DATE_TABLE
    , p9_a2 JTF_NUMBER_TABLE
    , p9_a3 JTF_DATE_TABLE
    , p9_a4 JTF_NUMBER_TABLE
    , p9_a5 JTF_NUMBER_TABLE
    , p9_a6 JTF_NUMBER_TABLE
    , p9_a7 JTF_NUMBER_TABLE
    , p9_a8 JTF_NUMBER_TABLE
    , p9_a9 JTF_DATE_TABLE
    , p9_a10 JTF_NUMBER_TABLE
    , p9_a11 JTF_VARCHAR2_TABLE_100
    , p9_a12 JTF_NUMBER_TABLE
    , p9_a13 JTF_NUMBER_TABLE
    , p9_a14 JTF_NUMBER_TABLE
    , p9_a15 JTF_NUMBER_TABLE
    , p9_a16 JTF_VARCHAR2_TABLE_100
    , p9_a17 JTF_NUMBER_TABLE
    , p9_a18 JTF_NUMBER_TABLE
    , p9_a19 JTF_NUMBER_TABLE
    , p9_a20 JTF_VARCHAR2_TABLE_100
    , p9_a21 JTF_VARCHAR2_TABLE_200
    , p9_a22 JTF_VARCHAR2_TABLE_200
    , p9_a23 JTF_VARCHAR2_TABLE_200
    , p9_a24 JTF_VARCHAR2_TABLE_200
    , p9_a25 JTF_VARCHAR2_TABLE_200
    , p9_a26 JTF_VARCHAR2_TABLE_200
    , p9_a27 JTF_VARCHAR2_TABLE_200
    , p9_a28 JTF_VARCHAR2_TABLE_200
    , p9_a29 JTF_VARCHAR2_TABLE_200
    , p9_a30 JTF_VARCHAR2_TABLE_200
    , p9_a31 JTF_VARCHAR2_TABLE_200
    , p9_a32 JTF_VARCHAR2_TABLE_200
    , p9_a33 JTF_VARCHAR2_TABLE_200
    , p9_a34 JTF_VARCHAR2_TABLE_200
    , p9_a35 JTF_VARCHAR2_TABLE_200
    , p9_a36 JTF_NUMBER_TABLE
    , p10_a0 out nocopy JTF_NUMBER_TABLE
    , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

Line: 2402


    as_sales_leads_pub.update_sales_lead_lines(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_identity_salesforce_id,
      ddp_sales_lead_profile_tbl,
      ddp_sales_lead_line_tbl,
      ddx_sales_lead_line_out_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 2436


  procedure delete_sales_lead_lines(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_check_access_flag  VARCHAR2
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_identity_salesforce_id  NUMBER
    , p8_a0 JTF_VARCHAR2_TABLE_100
    , p8_a1 JTF_VARCHAR2_TABLE_300
    , p9_a0 JTF_NUMBER_TABLE
    , p9_a1 JTF_DATE_TABLE
    , p9_a2 JTF_NUMBER_TABLE
    , p9_a3 JTF_DATE_TABLE
    , p9_a4 JTF_NUMBER_TABLE
    , p9_a5 JTF_NUMBER_TABLE
    , p9_a6 JTF_NUMBER_TABLE
    , p9_a7 JTF_NUMBER_TABLE
    , p9_a8 JTF_NUMBER_TABLE
    , p9_a9 JTF_DATE_TABLE
    , p9_a10 JTF_NUMBER_TABLE
    , p9_a11 JTF_VARCHAR2_TABLE_100
    , p9_a12 JTF_NUMBER_TABLE
    , p9_a13 JTF_NUMBER_TABLE
    , p9_a14 JTF_NUMBER_TABLE
    , p9_a15 JTF_NUMBER_TABLE
    , p9_a16 JTF_VARCHAR2_TABLE_100
    , p9_a17 JTF_NUMBER_TABLE
    , p9_a18 JTF_NUMBER_TABLE
    , p9_a19 JTF_NUMBER_TABLE
    , p9_a20 JTF_VARCHAR2_TABLE_100
    , p9_a21 JTF_VARCHAR2_TABLE_200
    , p9_a22 JTF_VARCHAR2_TABLE_200
    , p9_a23 JTF_VARCHAR2_TABLE_200
    , p9_a24 JTF_VARCHAR2_TABLE_200
    , p9_a25 JTF_VARCHAR2_TABLE_200
    , p9_a26 JTF_VARCHAR2_TABLE_200
    , p9_a27 JTF_VARCHAR2_TABLE_200
    , p9_a28 JTF_VARCHAR2_TABLE_200
    , p9_a29 JTF_VARCHAR2_TABLE_200
    , p9_a30 JTF_VARCHAR2_TABLE_200
    , p9_a31 JTF_VARCHAR2_TABLE_200
    , p9_a32 JTF_VARCHAR2_TABLE_200
    , p9_a33 JTF_VARCHAR2_TABLE_200
    , p9_a34 JTF_VARCHAR2_TABLE_200
    , p9_a35 JTF_VARCHAR2_TABLE_200
    , p9_a36 JTF_NUMBER_TABLE
    , p10_a0 out nocopy JTF_NUMBER_TABLE
    , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

Line: 2554


    as_sales_leads_pub.delete_sales_lead_lines(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_identity_salesforce_id,
      ddp_sales_lead_profile_tbl,
      ddp_sales_lead_line_tbl,
      ddx_sales_lead_line_out_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 2742


  procedure update_sales_lead_contacts(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_check_access_flag  VARCHAR2
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_identity_salesforce_id  NUMBER
    , p8_a0 JTF_VARCHAR2_TABLE_100
    , p8_a1 JTF_VARCHAR2_TABLE_300
    , p9_a0 JTF_NUMBER_TABLE
    , p9_a1 JTF_NUMBER_TABLE
    , p9_a2 JTF_NUMBER_TABLE
    , p9_a3 JTF_DATE_TABLE
    , p9_a4 JTF_NUMBER_TABLE
    , p9_a5 JTF_DATE_TABLE
    , p9_a6 JTF_NUMBER_TABLE
    , p9_a7 JTF_NUMBER_TABLE
    , p9_a8 JTF_NUMBER_TABLE
    , p9_a9 JTF_NUMBER_TABLE
    , p9_a10 JTF_NUMBER_TABLE
    , p9_a11 JTF_DATE_TABLE
    , p9_a12 JTF_VARCHAR2_TABLE_100
    , p9_a13 JTF_VARCHAR2_TABLE_100
    , p9_a14 JTF_NUMBER_TABLE
    , p9_a15 JTF_NUMBER_TABLE
    , p9_a16 JTF_NUMBER_TABLE
    , p9_a17 JTF_VARCHAR2_TABLE_100
    , p9_a18 JTF_VARCHAR2_TABLE_100
    , p9_a19 JTF_VARCHAR2_TABLE_100
    , p9_a20 JTF_VARCHAR2_TABLE_200
    , p9_a21 JTF_VARCHAR2_TABLE_200
    , p9_a22 JTF_VARCHAR2_TABLE_200
    , p9_a23 JTF_VARCHAR2_TABLE_200
    , p9_a24 JTF_VARCHAR2_TABLE_200
    , p9_a25 JTF_VARCHAR2_TABLE_200
    , p9_a26 JTF_VARCHAR2_TABLE_200
    , p9_a27 JTF_VARCHAR2_TABLE_200
    , p9_a28 JTF_VARCHAR2_TABLE_200
    , p9_a29 JTF_VARCHAR2_TABLE_200
    , p9_a30 JTF_VARCHAR2_TABLE_200
    , p9_a31 JTF_VARCHAR2_TABLE_200
    , p9_a32 JTF_VARCHAR2_TABLE_200
    , p9_a33 JTF_VARCHAR2_TABLE_200
    , p9_a34 JTF_VARCHAR2_TABLE_200
    , p9_a35 JTF_NUMBER_TABLE
    , p10_a0 out nocopy JTF_NUMBER_TABLE
    , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

Line: 2858


    as_sales_leads_pub.update_sales_lead_contacts(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_identity_salesforce_id,
      ddp_sales_lead_profile_tbl,
      ddp_sales_lead_contact_tbl,
      ddx_sales_lead_cnt_out_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 2892


  procedure delete_sales_lead_contacts(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_check_access_flag  VARCHAR2
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_identity_salesforce_id  NUMBER
    , p8_a0 JTF_VARCHAR2_TABLE_100
    , p8_a1 JTF_VARCHAR2_TABLE_300
    , p9_a0 JTF_NUMBER_TABLE
    , p9_a1 JTF_NUMBER_TABLE
    , p9_a2 JTF_NUMBER_TABLE
    , p9_a3 JTF_DATE_TABLE
    , p9_a4 JTF_NUMBER_TABLE
    , p9_a5 JTF_DATE_TABLE
    , p9_a6 JTF_NUMBER_TABLE
    , p9_a7 JTF_NUMBER_TABLE
    , p9_a8 JTF_NUMBER_TABLE
    , p9_a9 JTF_NUMBER_TABLE
    , p9_a10 JTF_NUMBER_TABLE
    , p9_a11 JTF_DATE_TABLE
    , p9_a12 JTF_VARCHAR2_TABLE_100
    , p9_a13 JTF_VARCHAR2_TABLE_100
    , p9_a14 JTF_NUMBER_TABLE
    , p9_a15 JTF_NUMBER_TABLE
    , p9_a16 JTF_NUMBER_TABLE
    , p9_a17 JTF_VARCHAR2_TABLE_100
    , p9_a18 JTF_VARCHAR2_TABLE_100
    , p9_a19 JTF_VARCHAR2_TABLE_100
    , p9_a20 JTF_VARCHAR2_TABLE_200
    , p9_a21 JTF_VARCHAR2_TABLE_200
    , p9_a22 JTF_VARCHAR2_TABLE_200
    , p9_a23 JTF_VARCHAR2_TABLE_200
    , p9_a24 JTF_VARCHAR2_TABLE_200
    , p9_a25 JTF_VARCHAR2_TABLE_200
    , p9_a26 JTF_VARCHAR2_TABLE_200
    , p9_a27 JTF_VARCHAR2_TABLE_200
    , p9_a28 JTF_VARCHAR2_TABLE_200
    , p9_a29 JTF_VARCHAR2_TABLE_200
    , p9_a30 JTF_VARCHAR2_TABLE_200
    , p9_a31 JTF_VARCHAR2_TABLE_200
    , p9_a32 JTF_VARCHAR2_TABLE_200
    , p9_a33 JTF_VARCHAR2_TABLE_200
    , p9_a34 JTF_VARCHAR2_TABLE_200
    , p9_a35 JTF_NUMBER_TABLE
    , p10_a0 out nocopy JTF_NUMBER_TABLE
    , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

Line: 3008


    as_sales_leads_pub.delete_sales_lead_contacts(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_identity_salesforce_id,
      ddp_sales_lead_profile_tbl,
      ddp_sales_lead_contact_tbl,
      ddx_sales_lead_cnt_out_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);