DBA Data[Home] [Help]

APPS.AS_OPPORTUNITY_PUB_W SQL Statements

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

Line: 130

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
Line: 131

          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
Line: 134

          t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
Line: 138

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
Line: 184

          t(ddindx).updateable_flag := a54(indx);
Line: 190

          t(ddindx).deleted_flag := a60(indx);
Line: 205

          t(ddindx).delete_allowed_flag := a75(indx);
Line: 648

          a0(indx) := t(ddindx).last_update_date;
Line: 649

          a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
Line: 652

          a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
Line: 656

          a8(indx) := t(ddindx).program_update_date;
Line: 702

          a54(indx) := t(ddindx).updateable_flag;
Line: 708

          a60(indx) := t(ddindx).deleted_flag;
Line: 723

          a75(indx) := t(ddindx).delete_allowed_flag;
Line: 835

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
Line: 836

          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
Line: 839

          t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
Line: 843

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
Line: 1198

          a0(indx) := t(ddindx).last_update_date;
Line: 1199

          a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
Line: 1202

          a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
Line: 1206

          a8(indx) := t(ddindx).program_update_date;
Line: 1396

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
Line: 1397

          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
Line: 1400

          t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
Line: 1404

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
Line: 1430

          t(ddindx).delete_flag := a34(indx);
Line: 1719

          a0(indx) := t(ddindx).last_update_date;
Line: 1720

          a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
Line: 1723

          a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
Line: 1727

          a8(indx) := t(ddindx).program_update_date;
Line: 1753

          a34(indx) := t(ddindx).delete_flag;
Line: 1882

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
Line: 1883

          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
Line: 1886

          t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
Line: 1890

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
Line: 2070

          a0(indx) := t(ddindx).last_update_date;
Line: 2071

          a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
Line: 2074

          a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
Line: 2078

          a8(indx) := t(ddindx).program_update_date;
Line: 2211

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
Line: 2212

          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
Line: 2215

          t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
Line: 2219

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
Line: 2424

          a0(indx) := t(ddindx).last_update_date;
Line: 2425

          a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
Line: 2428

          a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
Line: 2432

          a8(indx) := t(ddindx).program_update_date;
Line: 2568

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
Line: 2569

          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
Line: 2572

          t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
Line: 2576

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
Line: 2771

          a0(indx) := t(ddindx).last_update_date;
Line: 2772

          a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
Line: 2775

          a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
Line: 2779

          a8(indx) := t(ddindx).program_update_date;
Line: 2920

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a0(indx));
Line: 2921

          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a1(indx));
Line: 2924

          t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
Line: 2928

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a8(indx));
Line: 3158

          a0(indx) := t(ddindx).last_update_date;
Line: 3159

          a1(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
Line: 3162

          a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
Line: 3166

          a8(indx) := t(ddindx).program_update_date;
Line: 3317

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a17(indx));
Line: 3325

          t(ddindx).last_update_login := rosetta_g_miss_num_map(a25(indx));
Line: 3326

          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a26(indx));
Line: 3327

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a27(indx));
Line: 3485

          a17(indx) := t(ddindx).program_update_date;
Line: 3493

          a25(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
Line: 3494

          a26(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
Line: 3495

          a27(indx) := t(ddindx).last_update_date;
Line: 3612

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a16(indx));
Line: 3622

          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a26(indx));
Line: 3623

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a27(indx));
Line: 3624

          t(ddindx).last_update_login := rosetta_g_miss_num_map(a28(indx));
Line: 3780

          a16(indx) := t(ddindx).program_update_date;
Line: 3790

          a26(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
Line: 3791

          a27(indx) := t(ddindx).last_update_date;
Line: 3792

          a28(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
Line: 3983

    ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a0);
Line: 3984

    ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p4_a1);
Line: 3987

    ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p4_a4);
Line: 3991

    ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p4_a8);
Line: 4037

    ddp_header_rec.updateable_flag := p4_a54;
Line: 4043

    ddp_header_rec.deleted_flag := p4_a60;
Line: 4058

    ddp_header_rec.delete_allowed_flag := p4_a75;
Line: 4134

  procedure update_opp_header(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
    , 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
    , x_lead_id out nocopy  NUMBER
    , p4_a0  DATE := fnd_api.g_miss_date
    , p4_a1  NUMBER := 0-1962.0724
    , p4_a2  DATE := fnd_api.g_miss_date
    , p4_a3  NUMBER := 0-1962.0724
    , p4_a4  NUMBER := 0-1962.0724
    , p4_a5  NUMBER := 0-1962.0724
    , p4_a6  NUMBER := 0-1962.0724
    , p4_a7  NUMBER := 0-1962.0724
    , p4_a8  DATE := fnd_api.g_miss_date
    , p4_a9  NUMBER := 0-1962.0724
    , p4_a10  VARCHAR2 := fnd_api.g_miss_char
    , p4_a11  VARCHAR2 := fnd_api.g_miss_char
    , p4_a12  VARCHAR2 := fnd_api.g_miss_char
    , p4_a13  VARCHAR2 := fnd_api.g_miss_char
    , p4_a14  VARCHAR2 := fnd_api.g_miss_char
    , p4_a15  NUMBER := 0-1962.0724
    , p4_a16  VARCHAR2 := fnd_api.g_miss_char
    , p4_a17  NUMBER := 0-1962.0724
    , p4_a18  VARCHAR2 := fnd_api.g_miss_char
    , p4_a19  VARCHAR2 := fnd_api.g_miss_char
    , p4_a20  NUMBER := 0-1962.0724
    , p4_a21  VARCHAR2 := fnd_api.g_miss_char
    , p4_a22  VARCHAR2 := fnd_api.g_miss_char
    , p4_a23  VARCHAR2 := fnd_api.g_miss_char
    , p4_a24  VARCHAR2 := fnd_api.g_miss_char
    , p4_a25  VARCHAR2 := fnd_api.g_miss_char
    , p4_a26  VARCHAR2 := fnd_api.g_miss_char
    , p4_a27  VARCHAR2 := fnd_api.g_miss_char
    , p4_a28  VARCHAR2 := fnd_api.g_miss_char
    , p4_a29  NUMBER := 0-1962.0724
    , p4_a30  VARCHAR2 := fnd_api.g_miss_char
    , p4_a31  NUMBER := 0-1962.0724
    , p4_a32  VARCHAR2 := fnd_api.g_miss_char
    , p4_a33  VARCHAR2 := fnd_api.g_miss_char
    , p4_a34  NUMBER := 0-1962.0724
    , p4_a35  NUMBER := 0-1962.0724
    , p4_a36  VARCHAR2 := fnd_api.g_miss_char
    , p4_a37  VARCHAR2 := fnd_api.g_miss_char
    , p4_a38  DATE := fnd_api.g_miss_date
    , p4_a39  VARCHAR2 := fnd_api.g_miss_char
    , p4_a40  VARCHAR2 := fnd_api.g_miss_char
    , p4_a41  VARCHAR2 := fnd_api.g_miss_char
    , p4_a42  VARCHAR2 := fnd_api.g_miss_char
    , p4_a43  VARCHAR2 := fnd_api.g_miss_char
    , p4_a44  NUMBER := 0-1962.0724
    , p4_a45  VARCHAR2 := fnd_api.g_miss_char
    , p4_a46  VARCHAR2 := fnd_api.g_miss_char
    , p4_a47  NUMBER := 0-1962.0724
    , p4_a48  VARCHAR2 := fnd_api.g_miss_char
    , p4_a49  NUMBER := 0-1962.0724
    , p4_a50  NUMBER := 0-1962.0724
    , p4_a51  NUMBER := 0-1962.0724
    , p4_a52  VARCHAR2 := fnd_api.g_miss_char
    , p4_a53  VARCHAR2 := fnd_api.g_miss_char
    , p4_a54  VARCHAR2 := fnd_api.g_miss_char
    , p4_a55  NUMBER := 0-1962.0724
    , p4_a56  NUMBER := 0-1962.0724
    , p4_a57  VARCHAR2 := fnd_api.g_miss_char
    , p4_a58  VARCHAR2 := fnd_api.g_miss_char
    , p4_a59  VARCHAR2 := fnd_api.g_miss_char
    , p4_a60  VARCHAR2 := fnd_api.g_miss_char
    , p4_a61  VARCHAR2 := fnd_api.g_miss_char
    , p4_a62  VARCHAR2 := fnd_api.g_miss_char
    , p4_a63  NUMBER := 0-1962.0724
    , p4_a64  VARCHAR2 := fnd_api.g_miss_char
    , p4_a65  NUMBER := 0-1962.0724
    , p4_a66  NUMBER := 0-1962.0724
    , p4_a67  VARCHAR2 := fnd_api.g_miss_char
    , p4_a68  NUMBER := 0-1962.0724
    , p4_a69  NUMBER := 0-1962.0724
    , p4_a70  NUMBER := 0-1962.0724
    , p4_a71  VARCHAR2 := fnd_api.g_miss_char
    , p4_a72  VARCHAR2 := fnd_api.g_miss_char
    , p4_a73  DATE := fnd_api.g_miss_date
    , p4_a74  VARCHAR2 := fnd_api.g_miss_char
    , p4_a75  VARCHAR2 := fnd_api.g_miss_char
    , p4_a76  VARCHAR2 := fnd_api.g_miss_char
    , p4_a77  VARCHAR2 := fnd_api.g_miss_char
    , p4_a78  VARCHAR2 := fnd_api.g_miss_char
    , p4_a79  VARCHAR2 := fnd_api.g_miss_char
    , p4_a80  NUMBER := 0-1962.0724
    , p4_a81  VARCHAR2 := fnd_api.g_miss_char
    , p4_a82  VARCHAR2 := fnd_api.g_miss_char
    , p4_a83  VARCHAR2 := fnd_api.g_miss_char
    , p4_a84  VARCHAR2 := fnd_api.g_miss_char
    , p4_a85  VARCHAR2 := fnd_api.g_miss_char
    , p4_a86  VARCHAR2 := fnd_api.g_miss_char
    , p4_a87  VARCHAR2 := fnd_api.g_miss_char
    , p4_a88  VARCHAR2 := fnd_api.g_miss_char
    , p4_a89  VARCHAR2 := fnd_api.g_miss_char
    , p4_a90  VARCHAR2 := fnd_api.g_miss_char
    , p4_a91  VARCHAR2 := fnd_api.g_miss_char
    , p4_a92  VARCHAR2 := fnd_api.g_miss_char
    , p4_a93  VARCHAR2 := fnd_api.g_miss_char
    , p4_a94  VARCHAR2 := fnd_api.g_miss_char
    , p4_a95  VARCHAR2 := fnd_api.g_miss_char
    , p4_a96  VARCHAR2 := fnd_api.g_miss_char
    , p4_a97  VARCHAR2 := fnd_api.g_miss_char
    , p4_a98  VARCHAR2 := fnd_api.g_miss_char
    , p4_a99  NUMBER := 0-1962.0724
  )

  as
    ddp_header_rec as_opportunity_pub.header_rec_type;
Line: 4262

    ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a0);
Line: 4263

    ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p4_a1);
Line: 4266

    ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p4_a4);
Line: 4270

    ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p4_a8);
Line: 4316

    ddp_header_rec.updateable_flag := p4_a54;
Line: 4322

    ddp_header_rec.deleted_flag := p4_a60;
Line: 4337

    ddp_header_rec.delete_allowed_flag := p4_a75;
Line: 4377

    as_opportunity_pub.update_opp_header(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      ddp_header_rec,
      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,
      x_lead_id);
Line: 4410

  procedure delete_opp_header(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
    , 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
    , x_lead_id out nocopy  NUMBER
    , p4_a0  DATE := fnd_api.g_miss_date
    , p4_a1  NUMBER := 0-1962.0724
    , p4_a2  DATE := fnd_api.g_miss_date
    , p4_a3  NUMBER := 0-1962.0724
    , p4_a4  NUMBER := 0-1962.0724
    , p4_a5  NUMBER := 0-1962.0724
    , p4_a6  NUMBER := 0-1962.0724
    , p4_a7  NUMBER := 0-1962.0724
    , p4_a8  DATE := fnd_api.g_miss_date
    , p4_a9  NUMBER := 0-1962.0724
    , p4_a10  VARCHAR2 := fnd_api.g_miss_char
    , p4_a11  VARCHAR2 := fnd_api.g_miss_char
    , p4_a12  VARCHAR2 := fnd_api.g_miss_char
    , p4_a13  VARCHAR2 := fnd_api.g_miss_char
    , p4_a14  VARCHAR2 := fnd_api.g_miss_char
    , p4_a15  NUMBER := 0-1962.0724
    , p4_a16  VARCHAR2 := fnd_api.g_miss_char
    , p4_a17  NUMBER := 0-1962.0724
    , p4_a18  VARCHAR2 := fnd_api.g_miss_char
    , p4_a19  VARCHAR2 := fnd_api.g_miss_char
    , p4_a20  NUMBER := 0-1962.0724
    , p4_a21  VARCHAR2 := fnd_api.g_miss_char
    , p4_a22  VARCHAR2 := fnd_api.g_miss_char
    , p4_a23  VARCHAR2 := fnd_api.g_miss_char
    , p4_a24  VARCHAR2 := fnd_api.g_miss_char
    , p4_a25  VARCHAR2 := fnd_api.g_miss_char
    , p4_a26  VARCHAR2 := fnd_api.g_miss_char
    , p4_a27  VARCHAR2 := fnd_api.g_miss_char
    , p4_a28  VARCHAR2 := fnd_api.g_miss_char
    , p4_a29  NUMBER := 0-1962.0724
    , p4_a30  VARCHAR2 := fnd_api.g_miss_char
    , p4_a31  NUMBER := 0-1962.0724
    , p4_a32  VARCHAR2 := fnd_api.g_miss_char
    , p4_a33  VARCHAR2 := fnd_api.g_miss_char
    , p4_a34  NUMBER := 0-1962.0724
    , p4_a35  NUMBER := 0-1962.0724
    , p4_a36  VARCHAR2 := fnd_api.g_miss_char
    , p4_a37  VARCHAR2 := fnd_api.g_miss_char
    , p4_a38  DATE := fnd_api.g_miss_date
    , p4_a39  VARCHAR2 := fnd_api.g_miss_char
    , p4_a40  VARCHAR2 := fnd_api.g_miss_char
    , p4_a41  VARCHAR2 := fnd_api.g_miss_char
    , p4_a42  VARCHAR2 := fnd_api.g_miss_char
    , p4_a43  VARCHAR2 := fnd_api.g_miss_char
    , p4_a44  NUMBER := 0-1962.0724
    , p4_a45  VARCHAR2 := fnd_api.g_miss_char
    , p4_a46  VARCHAR2 := fnd_api.g_miss_char
    , p4_a47  NUMBER := 0-1962.0724
    , p4_a48  VARCHAR2 := fnd_api.g_miss_char
    , p4_a49  NUMBER := 0-1962.0724
    , p4_a50  NUMBER := 0-1962.0724
    , p4_a51  NUMBER := 0-1962.0724
    , p4_a52  VARCHAR2 := fnd_api.g_miss_char
    , p4_a53  VARCHAR2 := fnd_api.g_miss_char
    , p4_a54  VARCHAR2 := fnd_api.g_miss_char
    , p4_a55  NUMBER := 0-1962.0724
    , p4_a56  NUMBER := 0-1962.0724
    , p4_a57  VARCHAR2 := fnd_api.g_miss_char
    , p4_a58  VARCHAR2 := fnd_api.g_miss_char
    , p4_a59  VARCHAR2 := fnd_api.g_miss_char
    , p4_a60  VARCHAR2 := fnd_api.g_miss_char
    , p4_a61  VARCHAR2 := fnd_api.g_miss_char
    , p4_a62  VARCHAR2 := fnd_api.g_miss_char
    , p4_a63  NUMBER := 0-1962.0724
    , p4_a64  VARCHAR2 := fnd_api.g_miss_char
    , p4_a65  NUMBER := 0-1962.0724
    , p4_a66  NUMBER := 0-1962.0724
    , p4_a67  VARCHAR2 := fnd_api.g_miss_char
    , p4_a68  NUMBER := 0-1962.0724
    , p4_a69  NUMBER := 0-1962.0724
    , p4_a70  NUMBER := 0-1962.0724
    , p4_a71  VARCHAR2 := fnd_api.g_miss_char
    , p4_a72  VARCHAR2 := fnd_api.g_miss_char
    , p4_a73  DATE := fnd_api.g_miss_date
    , p4_a74  VARCHAR2 := fnd_api.g_miss_char
    , p4_a75  VARCHAR2 := fnd_api.g_miss_char
    , p4_a76  VARCHAR2 := fnd_api.g_miss_char
    , p4_a77  VARCHAR2 := fnd_api.g_miss_char
    , p4_a78  VARCHAR2 := fnd_api.g_miss_char
    , p4_a79  VARCHAR2 := fnd_api.g_miss_char
    , p4_a80  NUMBER := 0-1962.0724
    , p4_a81  VARCHAR2 := fnd_api.g_miss_char
    , p4_a82  VARCHAR2 := fnd_api.g_miss_char
    , p4_a83  VARCHAR2 := fnd_api.g_miss_char
    , p4_a84  VARCHAR2 := fnd_api.g_miss_char
    , p4_a85  VARCHAR2 := fnd_api.g_miss_char
    , p4_a86  VARCHAR2 := fnd_api.g_miss_char
    , p4_a87  VARCHAR2 := fnd_api.g_miss_char
    , p4_a88  VARCHAR2 := fnd_api.g_miss_char
    , p4_a89  VARCHAR2 := fnd_api.g_miss_char
    , p4_a90  VARCHAR2 := fnd_api.g_miss_char
    , p4_a91  VARCHAR2 := fnd_api.g_miss_char
    , p4_a92  VARCHAR2 := fnd_api.g_miss_char
    , p4_a93  VARCHAR2 := fnd_api.g_miss_char
    , p4_a94  VARCHAR2 := fnd_api.g_miss_char
    , p4_a95  VARCHAR2 := fnd_api.g_miss_char
    , p4_a96  VARCHAR2 := fnd_api.g_miss_char
    , p4_a97  VARCHAR2 := fnd_api.g_miss_char
    , p4_a98  VARCHAR2 := fnd_api.g_miss_char
    , p4_a99  NUMBER := 0-1962.0724
  )

  as
    ddp_header_rec as_opportunity_pub.header_rec_type;
Line: 4538

    ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a0);
Line: 4539

    ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p4_a1);
Line: 4542

    ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p4_a4);
Line: 4546

    ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p4_a8);
Line: 4592

    ddp_header_rec.updateable_flag := p4_a54;
Line: 4598

    ddp_header_rec.deleted_flag := p4_a60;
Line: 4613

    ddp_header_rec.delete_allowed_flag := p4_a75;
Line: 4653

    as_opportunity_pub.delete_opp_header(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      ddp_header_rec,
      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,
      x_lead_id);
Line: 4958

    ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a0);
Line: 4959

    ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p5_a1);
Line: 4962

    ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p5_a4);
Line: 4966

    ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a8);
Line: 5012

    ddp_header_rec.updateable_flag := p5_a54;
Line: 5018

    ddp_header_rec.deleted_flag := p5_a60;
Line: 5033

    ddp_header_rec.delete_allowed_flag := p5_a75;
Line: 5114

  procedure update_opp_lines(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_VARCHAR2_TABLE_100
    , p5_a14 JTF_VARCHAR2_TABLE_100
    , p5_a15 JTF_NUMBER_TABLE
    , p5_a16 JTF_VARCHAR2_TABLE_100
    , p5_a17 JTF_NUMBER_TABLE
    , p5_a18 JTF_VARCHAR2_TABLE_100
    , p5_a19 JTF_NUMBER_TABLE
    , p5_a20 JTF_VARCHAR2_TABLE_2000
    , p5_a21 JTF_NUMBER_TABLE
    , p5_a22 JTF_VARCHAR2_TABLE_100
    , p5_a23 JTF_VARCHAR2_TABLE_100
    , p5_a24 JTF_NUMBER_TABLE
    , p5_a25 JTF_DATE_TABLE
    , p5_a26 JTF_NUMBER_TABLE
    , p5_a27 JTF_NUMBER_TABLE
    , p5_a28 JTF_VARCHAR2_TABLE_100
    , p5_a29 JTF_NUMBER_TABLE
    , p5_a30 JTF_VARCHAR2_TABLE_100
    , p5_a31 JTF_VARCHAR2_TABLE_100
    , p5_a32 JTF_DATE_TABLE
    , p5_a33 JTF_VARCHAR2_TABLE_100
    , p5_a34 JTF_VARCHAR2_TABLE_100
    , p5_a35 JTF_NUMBER_TABLE
    , p5_a36 JTF_NUMBER_TABLE
    , p5_a37 JTF_NUMBER_TABLE
    , p5_a38 JTF_VARCHAR2_TABLE_100
    , p5_a39 JTF_VARCHAR2_TABLE_100
    , p5_a40 JTF_VARCHAR2_TABLE_100
    , p5_a41 JTF_VARCHAR2_TABLE_100
    , p5_a42 JTF_NUMBER_TABLE
    , p5_a43 JTF_NUMBER_TABLE
    , p5_a44 JTF_DATE_TABLE
    , p5_a45 JTF_VARCHAR2_TABLE_100
    , p5_a46 JTF_NUMBER_TABLE
    , p5_a47 JTF_NUMBER_TABLE
    , p5_a48 JTF_NUMBER_TABLE
    , p5_a49 JTF_NUMBER_TABLE
    , p5_a50 JTF_VARCHAR2_TABLE_100
    , p5_a51 JTF_VARCHAR2_TABLE_200
    , p5_a52 JTF_VARCHAR2_TABLE_200
    , p5_a53 JTF_VARCHAR2_TABLE_200
    , p5_a54 JTF_VARCHAR2_TABLE_200
    , p5_a55 JTF_VARCHAR2_TABLE_200
    , p5_a56 JTF_VARCHAR2_TABLE_200
    , p5_a57 JTF_VARCHAR2_TABLE_200
    , p5_a58 JTF_VARCHAR2_TABLE_200
    , p5_a59 JTF_VARCHAR2_TABLE_200
    , p5_a60 JTF_VARCHAR2_TABLE_200
    , p5_a61 JTF_VARCHAR2_TABLE_200
    , p5_a62 JTF_VARCHAR2_TABLE_200
    , p5_a63 JTF_VARCHAR2_TABLE_200
    , p5_a64 JTF_VARCHAR2_TABLE_200
    , p5_a65 JTF_VARCHAR2_TABLE_200
    , p5_a66 JTF_NUMBER_TABLE
    , p5_a67 JTF_NUMBER_TABLE
    , p5_a68 JTF_NUMBER_TABLE
    , p_check_access_flag  VARCHAR2
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_partner_cont_party_id  NUMBER
    , p11_a0 JTF_VARCHAR2_TABLE_100
    , p11_a1 JTF_VARCHAR2_TABLE_300
    , p12_a0 out nocopy JTF_NUMBER_TABLE
    , p12_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
    , p6_a0  DATE := fnd_api.g_miss_date
    , p6_a1  NUMBER := 0-1962.0724
    , p6_a2  DATE := fnd_api.g_miss_date
    , p6_a3  NUMBER := 0-1962.0724
    , p6_a4  NUMBER := 0-1962.0724
    , p6_a5  NUMBER := 0-1962.0724
    , p6_a6  NUMBER := 0-1962.0724
    , p6_a7  NUMBER := 0-1962.0724
    , p6_a8  DATE := fnd_api.g_miss_date
    , p6_a9  NUMBER := 0-1962.0724
    , p6_a10  VARCHAR2 := fnd_api.g_miss_char
    , p6_a11  VARCHAR2 := fnd_api.g_miss_char
    , p6_a12  VARCHAR2 := fnd_api.g_miss_char
    , p6_a13  VARCHAR2 := fnd_api.g_miss_char
    , p6_a14  VARCHAR2 := fnd_api.g_miss_char
    , p6_a15  NUMBER := 0-1962.0724
    , p6_a16  VARCHAR2 := fnd_api.g_miss_char
    , p6_a17  NUMBER := 0-1962.0724
    , p6_a18  VARCHAR2 := fnd_api.g_miss_char
    , p6_a19  VARCHAR2 := fnd_api.g_miss_char
    , p6_a20  NUMBER := 0-1962.0724
    , p6_a21  VARCHAR2 := fnd_api.g_miss_char
    , p6_a22  VARCHAR2 := fnd_api.g_miss_char
    , p6_a23  VARCHAR2 := fnd_api.g_miss_char
    , p6_a24  VARCHAR2 := fnd_api.g_miss_char
    , p6_a25  VARCHAR2 := fnd_api.g_miss_char
    , p6_a26  VARCHAR2 := fnd_api.g_miss_char
    , p6_a27  VARCHAR2 := fnd_api.g_miss_char
    , p6_a28  VARCHAR2 := fnd_api.g_miss_char
    , p6_a29  NUMBER := 0-1962.0724
    , p6_a30  VARCHAR2 := fnd_api.g_miss_char
    , p6_a31  NUMBER := 0-1962.0724
    , p6_a32  VARCHAR2 := fnd_api.g_miss_char
    , p6_a33  VARCHAR2 := fnd_api.g_miss_char
    , p6_a34  NUMBER := 0-1962.0724
    , p6_a35  NUMBER := 0-1962.0724
    , p6_a36  VARCHAR2 := fnd_api.g_miss_char
    , p6_a37  VARCHAR2 := fnd_api.g_miss_char
    , p6_a38  DATE := fnd_api.g_miss_date
    , p6_a39  VARCHAR2 := fnd_api.g_miss_char
    , p6_a40  VARCHAR2 := fnd_api.g_miss_char
    , p6_a41  VARCHAR2 := fnd_api.g_miss_char
    , p6_a42  VARCHAR2 := fnd_api.g_miss_char
    , p6_a43  VARCHAR2 := fnd_api.g_miss_char
    , p6_a44  NUMBER := 0-1962.0724
    , p6_a45  VARCHAR2 := fnd_api.g_miss_char
    , p6_a46  VARCHAR2 := fnd_api.g_miss_char
    , p6_a47  NUMBER := 0-1962.0724
    , p6_a48  VARCHAR2 := fnd_api.g_miss_char
    , p6_a49  NUMBER := 0-1962.0724
    , p6_a50  NUMBER := 0-1962.0724
    , p6_a51  NUMBER := 0-1962.0724
    , p6_a52  VARCHAR2 := fnd_api.g_miss_char
    , p6_a53  VARCHAR2 := fnd_api.g_miss_char
    , p6_a54  VARCHAR2 := fnd_api.g_miss_char
    , p6_a55  NUMBER := 0-1962.0724
    , p6_a56  NUMBER := 0-1962.0724
    , p6_a57  VARCHAR2 := fnd_api.g_miss_char
    , p6_a58  VARCHAR2 := fnd_api.g_miss_char
    , p6_a59  VARCHAR2 := fnd_api.g_miss_char
    , p6_a60  VARCHAR2 := fnd_api.g_miss_char
    , p6_a61  VARCHAR2 := fnd_api.g_miss_char
    , p6_a62  VARCHAR2 := fnd_api.g_miss_char
    , p6_a63  NUMBER := 0-1962.0724
    , p6_a64  VARCHAR2 := fnd_api.g_miss_char
    , p6_a65  NUMBER := 0-1962.0724
    , p6_a66  NUMBER := 0-1962.0724
    , p6_a67  VARCHAR2 := fnd_api.g_miss_char
    , p6_a68  NUMBER := 0-1962.0724
    , p6_a69  NUMBER := 0-1962.0724
    , p6_a70  NUMBER := 0-1962.0724
    , p6_a71  VARCHAR2 := fnd_api.g_miss_char
    , p6_a72  VARCHAR2 := fnd_api.g_miss_char
    , p6_a73  DATE := fnd_api.g_miss_date
    , p6_a74  VARCHAR2 := fnd_api.g_miss_char
    , p6_a75  VARCHAR2 := fnd_api.g_miss_char
    , p6_a76  VARCHAR2 := fnd_api.g_miss_char
    , p6_a77  VARCHAR2 := fnd_api.g_miss_char
    , p6_a78  VARCHAR2 := fnd_api.g_miss_char
    , p6_a79  VARCHAR2 := fnd_api.g_miss_char
    , p6_a80  NUMBER := 0-1962.0724
    , p6_a81  VARCHAR2 := fnd_api.g_miss_char
    , p6_a82  VARCHAR2 := fnd_api.g_miss_char
    , p6_a83  VARCHAR2 := fnd_api.g_miss_char
    , p6_a84  VARCHAR2 := fnd_api.g_miss_char
    , p6_a85  VARCHAR2 := fnd_api.g_miss_char
    , p6_a86  VARCHAR2 := fnd_api.g_miss_char
    , p6_a87  VARCHAR2 := fnd_api.g_miss_char
    , p6_a88  VARCHAR2 := fnd_api.g_miss_char
    , p6_a89  VARCHAR2 := fnd_api.g_miss_char
    , p6_a90  VARCHAR2 := fnd_api.g_miss_char
    , p6_a91  VARCHAR2 := fnd_api.g_miss_char
    , p6_a92  VARCHAR2 := fnd_api.g_miss_char
    , p6_a93  VARCHAR2 := fnd_api.g_miss_char
    , p6_a94  VARCHAR2 := fnd_api.g_miss_char
    , p6_a95  VARCHAR2 := fnd_api.g_miss_char
    , p6_a96  VARCHAR2 := fnd_api.g_miss_char
    , p6_a97  VARCHAR2 := fnd_api.g_miss_char
    , p6_a98  VARCHAR2 := fnd_api.g_miss_char
    , p6_a99  NUMBER := 0-1962.0724
  )

  as
    ddp_line_tbl as_opportunity_pub.line_tbl_type;
Line: 5386

    ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a0);
Line: 5387

    ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p6_a1);
Line: 5390

    ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p6_a4);
Line: 5394

    ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a8);
Line: 5440

    ddp_header_rec.updateable_flag := p6_a54;
Line: 5446

    ddp_header_rec.deleted_flag := p6_a60;
Line: 5461

    ddp_header_rec.delete_allowed_flag := p6_a75;
Line: 5500

    as_opportunity_pub.update_opp_lines(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_identity_salesforce_id,
      ddp_line_tbl,
      ddp_header_rec,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_partner_cont_party_id,
      ddp_profile_tbl,
      ddx_line_out_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 5538

  procedure delete_opp_lines(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_VARCHAR2_TABLE_100
    , p5_a14 JTF_VARCHAR2_TABLE_100
    , p5_a15 JTF_NUMBER_TABLE
    , p5_a16 JTF_VARCHAR2_TABLE_100
    , p5_a17 JTF_NUMBER_TABLE
    , p5_a18 JTF_VARCHAR2_TABLE_100
    , p5_a19 JTF_NUMBER_TABLE
    , p5_a20 JTF_VARCHAR2_TABLE_2000
    , p5_a21 JTF_NUMBER_TABLE
    , p5_a22 JTF_VARCHAR2_TABLE_100
    , p5_a23 JTF_VARCHAR2_TABLE_100
    , p5_a24 JTF_NUMBER_TABLE
    , p5_a25 JTF_DATE_TABLE
    , p5_a26 JTF_NUMBER_TABLE
    , p5_a27 JTF_NUMBER_TABLE
    , p5_a28 JTF_VARCHAR2_TABLE_100
    , p5_a29 JTF_NUMBER_TABLE
    , p5_a30 JTF_VARCHAR2_TABLE_100
    , p5_a31 JTF_VARCHAR2_TABLE_100
    , p5_a32 JTF_DATE_TABLE
    , p5_a33 JTF_VARCHAR2_TABLE_100
    , p5_a34 JTF_VARCHAR2_TABLE_100
    , p5_a35 JTF_NUMBER_TABLE
    , p5_a36 JTF_NUMBER_TABLE
    , p5_a37 JTF_NUMBER_TABLE
    , p5_a38 JTF_VARCHAR2_TABLE_100
    , p5_a39 JTF_VARCHAR2_TABLE_100
    , p5_a40 JTF_VARCHAR2_TABLE_100
    , p5_a41 JTF_VARCHAR2_TABLE_100
    , p5_a42 JTF_NUMBER_TABLE
    , p5_a43 JTF_NUMBER_TABLE
    , p5_a44 JTF_DATE_TABLE
    , p5_a45 JTF_VARCHAR2_TABLE_100
    , p5_a46 JTF_NUMBER_TABLE
    , p5_a47 JTF_NUMBER_TABLE
    , p5_a48 JTF_NUMBER_TABLE
    , p5_a49 JTF_NUMBER_TABLE
    , p5_a50 JTF_VARCHAR2_TABLE_100
    , p5_a51 JTF_VARCHAR2_TABLE_200
    , p5_a52 JTF_VARCHAR2_TABLE_200
    , p5_a53 JTF_VARCHAR2_TABLE_200
    , p5_a54 JTF_VARCHAR2_TABLE_200
    , p5_a55 JTF_VARCHAR2_TABLE_200
    , p5_a56 JTF_VARCHAR2_TABLE_200
    , p5_a57 JTF_VARCHAR2_TABLE_200
    , p5_a58 JTF_VARCHAR2_TABLE_200
    , p5_a59 JTF_VARCHAR2_TABLE_200
    , p5_a60 JTF_VARCHAR2_TABLE_200
    , p5_a61 JTF_VARCHAR2_TABLE_200
    , p5_a62 JTF_VARCHAR2_TABLE_200
    , p5_a63 JTF_VARCHAR2_TABLE_200
    , p5_a64 JTF_VARCHAR2_TABLE_200
    , p5_a65 JTF_VARCHAR2_TABLE_200
    , p5_a66 JTF_NUMBER_TABLE
    , p5_a67 JTF_NUMBER_TABLE
    , p5_a68 JTF_NUMBER_TABLE
    , p_check_access_flag  VARCHAR2
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_partner_cont_party_id  NUMBER
    , p11_a0 JTF_VARCHAR2_TABLE_100
    , p11_a1 JTF_VARCHAR2_TABLE_300
    , p12_a0 out nocopy JTF_NUMBER_TABLE
    , p12_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
    , p6_a0  DATE := fnd_api.g_miss_date
    , p6_a1  NUMBER := 0-1962.0724
    , p6_a2  DATE := fnd_api.g_miss_date
    , p6_a3  NUMBER := 0-1962.0724
    , p6_a4  NUMBER := 0-1962.0724
    , p6_a5  NUMBER := 0-1962.0724
    , p6_a6  NUMBER := 0-1962.0724
    , p6_a7  NUMBER := 0-1962.0724
    , p6_a8  DATE := fnd_api.g_miss_date
    , p6_a9  NUMBER := 0-1962.0724
    , p6_a10  VARCHAR2 := fnd_api.g_miss_char
    , p6_a11  VARCHAR2 := fnd_api.g_miss_char
    , p6_a12  VARCHAR2 := fnd_api.g_miss_char
    , p6_a13  VARCHAR2 := fnd_api.g_miss_char
    , p6_a14  VARCHAR2 := fnd_api.g_miss_char
    , p6_a15  NUMBER := 0-1962.0724
    , p6_a16  VARCHAR2 := fnd_api.g_miss_char
    , p6_a17  NUMBER := 0-1962.0724
    , p6_a18  VARCHAR2 := fnd_api.g_miss_char
    , p6_a19  VARCHAR2 := fnd_api.g_miss_char
    , p6_a20  NUMBER := 0-1962.0724
    , p6_a21  VARCHAR2 := fnd_api.g_miss_char
    , p6_a22  VARCHAR2 := fnd_api.g_miss_char
    , p6_a23  VARCHAR2 := fnd_api.g_miss_char
    , p6_a24  VARCHAR2 := fnd_api.g_miss_char
    , p6_a25  VARCHAR2 := fnd_api.g_miss_char
    , p6_a26  VARCHAR2 := fnd_api.g_miss_char
    , p6_a27  VARCHAR2 := fnd_api.g_miss_char
    , p6_a28  VARCHAR2 := fnd_api.g_miss_char
    , p6_a29  NUMBER := 0-1962.0724
    , p6_a30  VARCHAR2 := fnd_api.g_miss_char
    , p6_a31  NUMBER := 0-1962.0724
    , p6_a32  VARCHAR2 := fnd_api.g_miss_char
    , p6_a33  VARCHAR2 := fnd_api.g_miss_char
    , p6_a34  NUMBER := 0-1962.0724
    , p6_a35  NUMBER := 0-1962.0724
    , p6_a36  VARCHAR2 := fnd_api.g_miss_char
    , p6_a37  VARCHAR2 := fnd_api.g_miss_char
    , p6_a38  DATE := fnd_api.g_miss_date
    , p6_a39  VARCHAR2 := fnd_api.g_miss_char
    , p6_a40  VARCHAR2 := fnd_api.g_miss_char
    , p6_a41  VARCHAR2 := fnd_api.g_miss_char
    , p6_a42  VARCHAR2 := fnd_api.g_miss_char
    , p6_a43  VARCHAR2 := fnd_api.g_miss_char
    , p6_a44  NUMBER := 0-1962.0724
    , p6_a45  VARCHAR2 := fnd_api.g_miss_char
    , p6_a46  VARCHAR2 := fnd_api.g_miss_char
    , p6_a47  NUMBER := 0-1962.0724
    , p6_a48  VARCHAR2 := fnd_api.g_miss_char
    , p6_a49  NUMBER := 0-1962.0724
    , p6_a50  NUMBER := 0-1962.0724
    , p6_a51  NUMBER := 0-1962.0724
    , p6_a52  VARCHAR2 := fnd_api.g_miss_char
    , p6_a53  VARCHAR2 := fnd_api.g_miss_char
    , p6_a54  VARCHAR2 := fnd_api.g_miss_char
    , p6_a55  NUMBER := 0-1962.0724
    , p6_a56  NUMBER := 0-1962.0724
    , p6_a57  VARCHAR2 := fnd_api.g_miss_char
    , p6_a58  VARCHAR2 := fnd_api.g_miss_char
    , p6_a59  VARCHAR2 := fnd_api.g_miss_char
    , p6_a60  VARCHAR2 := fnd_api.g_miss_char
    , p6_a61  VARCHAR2 := fnd_api.g_miss_char
    , p6_a62  VARCHAR2 := fnd_api.g_miss_char
    , p6_a63  NUMBER := 0-1962.0724
    , p6_a64  VARCHAR2 := fnd_api.g_miss_char
    , p6_a65  NUMBER := 0-1962.0724
    , p6_a66  NUMBER := 0-1962.0724
    , p6_a67  VARCHAR2 := fnd_api.g_miss_char
    , p6_a68  NUMBER := 0-1962.0724
    , p6_a69  NUMBER := 0-1962.0724
    , p6_a70  NUMBER := 0-1962.0724
    , p6_a71  VARCHAR2 := fnd_api.g_miss_char
    , p6_a72  VARCHAR2 := fnd_api.g_miss_char
    , p6_a73  DATE := fnd_api.g_miss_date
    , p6_a74  VARCHAR2 := fnd_api.g_miss_char
    , p6_a75  VARCHAR2 := fnd_api.g_miss_char
    , p6_a76  VARCHAR2 := fnd_api.g_miss_char
    , p6_a77  VARCHAR2 := fnd_api.g_miss_char
    , p6_a78  VARCHAR2 := fnd_api.g_miss_char
    , p6_a79  VARCHAR2 := fnd_api.g_miss_char
    , p6_a80  NUMBER := 0-1962.0724
    , p6_a81  VARCHAR2 := fnd_api.g_miss_char
    , p6_a82  VARCHAR2 := fnd_api.g_miss_char
    , p6_a83  VARCHAR2 := fnd_api.g_miss_char
    , p6_a84  VARCHAR2 := fnd_api.g_miss_char
    , p6_a85  VARCHAR2 := fnd_api.g_miss_char
    , p6_a86  VARCHAR2 := fnd_api.g_miss_char
    , p6_a87  VARCHAR2 := fnd_api.g_miss_char
    , p6_a88  VARCHAR2 := fnd_api.g_miss_char
    , p6_a89  VARCHAR2 := fnd_api.g_miss_char
    , p6_a90  VARCHAR2 := fnd_api.g_miss_char
    , p6_a91  VARCHAR2 := fnd_api.g_miss_char
    , p6_a92  VARCHAR2 := fnd_api.g_miss_char
    , p6_a93  VARCHAR2 := fnd_api.g_miss_char
    , p6_a94  VARCHAR2 := fnd_api.g_miss_char
    , p6_a95  VARCHAR2 := fnd_api.g_miss_char
    , p6_a96  VARCHAR2 := fnd_api.g_miss_char
    , p6_a97  VARCHAR2 := fnd_api.g_miss_char
    , p6_a98  VARCHAR2 := fnd_api.g_miss_char
    , p6_a99  NUMBER := 0-1962.0724
  )

  as
    ddp_line_tbl as_opportunity_pub.line_tbl_type;
Line: 5810

    ddp_header_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a0);
Line: 5811

    ddp_header_rec.last_updated_by := rosetta_g_miss_num_map(p6_a1);
Line: 5814

    ddp_header_rec.last_update_login := rosetta_g_miss_num_map(p6_a4);
Line: 5818

    ddp_header_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a8);
Line: 5864

    ddp_header_rec.updateable_flag := p6_a54;
Line: 5870

    ddp_header_rec.deleted_flag := p6_a60;
Line: 5885

    ddp_header_rec.delete_allowed_flag := p6_a75;
Line: 5924

    as_opportunity_pub.delete_opp_lines(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_identity_salesforce_id,
      ddp_line_tbl,
      ddp_header_rec,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_partner_cont_party_id,
      ddp_profile_tbl,
      ddx_line_out_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 6166

  procedure update_sales_credits(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_NUMBER_TABLE
    , p5_a15 JTF_VARCHAR2_TABLE_100
    , p5_a16 JTF_VARCHAR2_TABLE_100
    , p5_a17 JTF_NUMBER_TABLE
    , p5_a18 JTF_VARCHAR2_TABLE_100
    , p5_a19 JTF_NUMBER_TABLE
    , p5_a20 JTF_VARCHAR2_TABLE_400
    , p5_a21 JTF_VARCHAR2_TABLE_100
    , p5_a22 JTF_NUMBER_TABLE
    , p5_a23 JTF_NUMBER_TABLE
    , p5_a24 JTF_NUMBER_TABLE
    , p5_a25 JTF_NUMBER_TABLE
    , p5_a26 JTF_NUMBER_TABLE
    , p5_a27 JTF_NUMBER_TABLE
    , p5_a28 JTF_NUMBER_TABLE
    , p5_a29 JTF_VARCHAR2_TABLE_100
    , p5_a30 JTF_VARCHAR2_TABLE_100
    , p5_a31 JTF_VARCHAR2_TABLE_100
    , p5_a32 JTF_DATE_TABLE
    , p5_a33 JTF_NUMBER_TABLE
    , p5_a34 JTF_VARCHAR2_TABLE_100
    , p5_a35 JTF_VARCHAR2_TABLE_100
    , p5_a36 JTF_NUMBER_TABLE
    , p5_a37 JTF_VARCHAR2_TABLE_100
    , p5_a38 JTF_NUMBER_TABLE
    , p5_a39 JTF_NUMBER_TABLE
    , p5_a40 JTF_NUMBER_TABLE
    , p5_a41 JTF_VARCHAR2_TABLE_100
    , p5_a42 JTF_VARCHAR2_TABLE_200
    , p5_a43 JTF_VARCHAR2_TABLE_200
    , p5_a44 JTF_VARCHAR2_TABLE_200
    , p5_a45 JTF_VARCHAR2_TABLE_200
    , p5_a46 JTF_VARCHAR2_TABLE_200
    , p5_a47 JTF_VARCHAR2_TABLE_200
    , p5_a48 JTF_VARCHAR2_TABLE_200
    , p5_a49 JTF_VARCHAR2_TABLE_200
    , p5_a50 JTF_VARCHAR2_TABLE_200
    , p5_a51 JTF_VARCHAR2_TABLE_200
    , p5_a52 JTF_VARCHAR2_TABLE_200
    , p5_a53 JTF_VARCHAR2_TABLE_200
    , p5_a54 JTF_VARCHAR2_TABLE_200
    , p5_a55 JTF_VARCHAR2_TABLE_200
    , p5_a56 JTF_VARCHAR2_TABLE_200
    , p5_a57 JTF_NUMBER_TABLE
    , p5_a58 JTF_NUMBER_TABLE
    , p5_a59 JTF_NUMBER_TABLE
    , p5_a60 JTF_VARCHAR2_TABLE_100
    , 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_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;
Line: 6334

    as_opportunity_pub.update_sales_credits(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_identity_salesforce_id,
      ddp_sales_credit_tbl,
      p_check_access_flag,
      p_admin_flag,
      p_admin_group_id,
      p_partner_cont_party_id,
      ddp_profile_tbl,
      ddx_sales_credit_out_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);