APPS.AS_OPPORTUNITY_PUB_W4 SQL Statements

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

Line: 244

    ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a0);

Line: 245

    ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p6_a1);

Line: 248

    ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p6_a4);

Line: 252

    ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a8);

Line: 298

    ddp_header_rec.updateable_flag := p6_a54;

Line: 304

    ddp_header_rec.deleted_flag := p6_a60;

Line: 319

    ddp_header_rec.delete_allowed_flag := p6_a75;

Line: 396

  procedure update_contacts(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_identity_salesforce_id  NUMBER
    , p5_a0 JTF_DATE_TABLE
    , p5_a1 JTF_NUMBER_TABLE
    , p5_a2 JTF_DATE_TABLE
    , p5_a3 JTF_NUMBER_TABLE
    , p5_a4 JTF_NUMBER_TABLE
    , p5_a5 JTF_NUMBER_TABLE
    , p5_a6 JTF_NUMBER_TABLE
    , p5_a7 JTF_NUMBER_TABLE
    , p5_a8 JTF_DATE_TABLE
    , p5_a9 JTF_NUMBER_TABLE
    , p5_a10 JTF_NUMBER_TABLE
    , p5_a11 JTF_NUMBER_TABLE
    , p5_a12 JTF_NUMBER_TABLE
    , p5_a13 JTF_NUMBER_TABLE
    , p5_a14 JTF_VARCHAR2_TABLE_100
    , p5_a15 JTF_VARCHAR2_TABLE_100
    , p5_a16 JTF_VARCHAR2_TABLE_100
    , p5_a17 JTF_VARCHAR2_TABLE_300
    , p5_a18 JTF_NUMBER_TABLE
    , p5_a19 JTF_VARCHAR2_TABLE_100
    , p5_a20 JTF_VARCHAR2_TABLE_100
    , p5_a21 JTF_VARCHAR2_TABLE_100
    , p5_a22 JTF_VARCHAR2_TABLE_100
    , p5_a23 JTF_VARCHAR2_TABLE_100
    , p5_a24 JTF_NUMBER_TABLE
    , p5_a25 JTF_VARCHAR2_TABLE_100
    , p5_a26 JTF_VARCHAR2_TABLE_100
    , p5_a27 JTF_NUMBER_TABLE
    , p5_a28 JTF_VARCHAR2_TABLE_100
    , p5_a29 JTF_VARCHAR2_TABLE_200
    , p5_a30 JTF_VARCHAR2_TABLE_200
    , p5_a31 JTF_VARCHAR2_TABLE_200
    , p5_a32 JTF_VARCHAR2_TABLE_200
    , p5_a33 JTF_VARCHAR2_TABLE_200
    , p5_a34 JTF_VARCHAR2_TABLE_200
    , p5_a35 JTF_VARCHAR2_TABLE_200
    , p5_a36 JTF_VARCHAR2_TABLE_200
    , p5_a37 JTF_VARCHAR2_TABLE_200
    , p5_a38 JTF_VARCHAR2_TABLE_200
    , p5_a39 JTF_VARCHAR2_TABLE_200
    , p5_a40 JTF_VARCHAR2_TABLE_200
    , p5_a41 JTF_VARCHAR2_TABLE_200
    , p5_a42 JTF_VARCHAR2_TABLE_200
    , p5_a43 JTF_VARCHAR2_TABLE_200
    , p_check_access_flag  VARCHAR2
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_partner_cont_party_id  NUMBER
    , p10_a0 JTF_VARCHAR2_TABLE_100
    , p10_a1 JTF_VARCHAR2_TABLE_300
    , p11_a0 out nocopy JTF_NUMBER_TABLE
    , p11_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_contact_tbl as_opportunity_pub.contact_tbl_type;

Line: 530

    as_opportunity_pub.update_contacts(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_identity_salesforce_id,
      ddp_contact_tbl,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_partner_cont_party_id,
      ddp_profile_tbl,
      ddx_contact_out_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 566

  procedure delete_contacts(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_identity_salesforce_id  NUMBER
    , p5_a0 JTF_DATE_TABLE
    , p5_a1 JTF_NUMBER_TABLE
    , p5_a2 JTF_DATE_TABLE
    , p5_a3 JTF_NUMBER_TABLE
    , p5_a4 JTF_NUMBER_TABLE
    , p5_a5 JTF_NUMBER_TABLE
    , p5_a6 JTF_NUMBER_TABLE
    , p5_a7 JTF_NUMBER_TABLE
    , p5_a8 JTF_DATE_TABLE
    , p5_a9 JTF_NUMBER_TABLE
    , p5_a10 JTF_NUMBER_TABLE
    , p5_a11 JTF_NUMBER_TABLE
    , p5_a12 JTF_NUMBER_TABLE
    , p5_a13 JTF_NUMBER_TABLE
    , p5_a14 JTF_VARCHAR2_TABLE_100
    , p5_a15 JTF_VARCHAR2_TABLE_100
    , p5_a16 JTF_VARCHAR2_TABLE_100
    , p5_a17 JTF_VARCHAR2_TABLE_300
    , p5_a18 JTF_NUMBER_TABLE
    , p5_a19 JTF_VARCHAR2_TABLE_100
    , p5_a20 JTF_VARCHAR2_TABLE_100
    , p5_a21 JTF_VARCHAR2_TABLE_100
    , p5_a22 JTF_VARCHAR2_TABLE_100
    , p5_a23 JTF_VARCHAR2_TABLE_100
    , p5_a24 JTF_NUMBER_TABLE
    , p5_a25 JTF_VARCHAR2_TABLE_100
    , p5_a26 JTF_VARCHAR2_TABLE_100
    , p5_a27 JTF_NUMBER_TABLE
    , p5_a28 JTF_VARCHAR2_TABLE_100
    , p5_a29 JTF_VARCHAR2_TABLE_200
    , p5_a30 JTF_VARCHAR2_TABLE_200
    , p5_a31 JTF_VARCHAR2_TABLE_200
    , p5_a32 JTF_VARCHAR2_TABLE_200
    , p5_a33 JTF_VARCHAR2_TABLE_200
    , p5_a34 JTF_VARCHAR2_TABLE_200
    , p5_a35 JTF_VARCHAR2_TABLE_200
    , p5_a36 JTF_VARCHAR2_TABLE_200
    , p5_a37 JTF_VARCHAR2_TABLE_200
    , p5_a38 JTF_VARCHAR2_TABLE_200
    , p5_a39 JTF_VARCHAR2_TABLE_200
    , p5_a40 JTF_VARCHAR2_TABLE_200
    , p5_a41 JTF_VARCHAR2_TABLE_200
    , p5_a42 JTF_VARCHAR2_TABLE_200
    , p5_a43 JTF_VARCHAR2_TABLE_200
    , p_check_access_flag  VARCHAR2
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_partner_cont_party_id  NUMBER
    , p10_a0 JTF_VARCHAR2_TABLE_100
    , p10_a1 JTF_VARCHAR2_TABLE_300
    , p11_a0 out nocopy JTF_NUMBER_TABLE
    , p11_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_contact_tbl as_opportunity_pub.contact_tbl_type;

Line: 700

    as_opportunity_pub.delete_contacts(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_identity_salesforce_id,
      ddp_contact_tbl,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_partner_cont_party_id,
      ddp_profile_tbl,
      ddx_contact_out_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 736

  procedure delete_salesteams(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p4_a0 JTF_NUMBER_TABLE
    , p4_a1 JTF_DATE_TABLE
    , p4_a2 JTF_NUMBER_TABLE
    , p4_a3 JTF_DATE_TABLE
    , p4_a4 JTF_NUMBER_TABLE
    , p4_a5 JTF_NUMBER_TABLE
    , p4_a6 JTF_VARCHAR2_TABLE_100
    , p4_a7 JTF_VARCHAR2_TABLE_100
    , p4_a8 JTF_VARCHAR2_TABLE_100
    , p4_a9 JTF_NUMBER_TABLE
    , p4_a10 JTF_NUMBER_TABLE
    , p4_a11 JTF_NUMBER_TABLE
    , p4_a12 JTF_NUMBER_TABLE
    , p4_a13 JTF_VARCHAR2_TABLE_300
    , p4_a14 JTF_VARCHAR2_TABLE_100
    , p4_a15 JTF_VARCHAR2_TABLE_100
    , p4_a16 JTF_VARCHAR2_TABLE_300
    , p4_a17 JTF_VARCHAR2_TABLE_100
    , p4_a18 JTF_NUMBER_TABLE
    , p4_a19 JTF_VARCHAR2_TABLE_100
    , p4_a20 JTF_NUMBER_TABLE
    , p4_a21 JTF_NUMBER_TABLE
    , p4_a22 JTF_VARCHAR2_TABLE_100
    , p4_a23 JTF_VARCHAR2_TABLE_100
    , p4_a24 JTF_VARCHAR2_TABLE_100
    , p4_a25 JTF_VARCHAR2_TABLE_100
    , p4_a26 JTF_VARCHAR2_TABLE_100
    , p4_a27 JTF_VARCHAR2_TABLE_100
    , p4_a28 JTF_NUMBER_TABLE
    , p4_a29 JTF_NUMBER_TABLE
    , p4_a30 JTF_DATE_TABLE
    , p4_a31 JTF_VARCHAR2_TABLE_300
    , p4_a32 JTF_DATE_TABLE
    , p4_a33 JTF_NUMBER_TABLE
    , p4_a34 JTF_VARCHAR2_TABLE_100
    , p4_a35 JTF_VARCHAR2_TABLE_100
    , p4_a36 JTF_VARCHAR2_TABLE_200
    , p4_a37 JTF_VARCHAR2_TABLE_200
    , p4_a38 JTF_VARCHAR2_TABLE_200
    , p4_a39 JTF_VARCHAR2_TABLE_200
    , p4_a40 JTF_VARCHAR2_TABLE_200
    , p4_a41 JTF_VARCHAR2_TABLE_200
    , p4_a42 JTF_VARCHAR2_TABLE_200
    , p4_a43 JTF_VARCHAR2_TABLE_200
    , p4_a44 JTF_VARCHAR2_TABLE_200
    , p4_a45 JTF_VARCHAR2_TABLE_200
    , p4_a46 JTF_VARCHAR2_TABLE_200
    , p4_a47 JTF_VARCHAR2_TABLE_200
    , p4_a48 JTF_VARCHAR2_TABLE_200
    , p4_a49 JTF_VARCHAR2_TABLE_200
    , p4_a50 JTF_VARCHAR2_TABLE_200
    , p4_a51 JTF_VARCHAR2_TABLE_100
    , p4_a52 JTF_VARCHAR2_TABLE_100
    , p4_a53 JTF_VARCHAR2_TABLE_100
    , p4_a54 JTF_NUMBER_TABLE
    , p4_a55 JTF_NUMBER_TABLE
    , p4_a56 JTF_VARCHAR2_TABLE_100
    , p4_a57 JTF_VARCHAR2_TABLE_100
    , p4_a58 JTF_VARCHAR2_TABLE_100
    , p4_a59 JTF_VARCHAR2_TABLE_100
    , p_check_access_flag  VARCHAR2
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_identity_salesforce_id  NUMBER
    , p_partner_cont_party_id  NUMBER
    , p10_a0 JTF_VARCHAR2_TABLE_100
    , p10_a1 JTF_VARCHAR2_TABLE_300
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_sales_team_tbl as_access_pub.sales_team_tbl_type;

Line: 898

    as_opportunity_pub.delete_salesteams(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      ddp_sales_team_tbl,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_identity_salesforce_id,
      p_partner_cont_party_id,
      ddp_profile_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 1075

    p1_a3 := ddx_access_profile_rec.mgr_update_profile_value;

Line: 1076

    p1_a4 := ddx_access_profile_rec.admin_update_profile_value;