DBA Data[Home] [Help]

APPS.IEM_SERVICEREQUEST_PVT_W SQL Statements

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

Line: 496

    ddp_service_request_rec.last_update_channel := p13_a125;
Line: 565

  procedure update_servicerequest_wrap(p_api_version  NUMBER
    , 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
    , p_request_id  NUMBER
    , p_request_number  VARCHAR2
    , p_audit_comments  VARCHAR2
    , p_object_version_number  NUMBER
    , p_resp_appl_id  NUMBER
    , p_resp_id  NUMBER
    , p_last_updated_by  NUMBER
    , p_last_update_login  NUMBER
    , p_last_update_date  date
    , p15_a0  DATE
    , p15_a1  NUMBER
    , p15_a2  VARCHAR2
    , p15_a3  NUMBER
    , p15_a4  VARCHAR2
    , p15_a5  NUMBER
    , p15_a6  VARCHAR2
    , p15_a7  NUMBER
    , p15_a8  VARCHAR2
    , p15_a9  DATE
    , p15_a10  NUMBER
    , p15_a11  NUMBER
    , p15_a12  VARCHAR2
    , p15_a13  VARCHAR2
    , p15_a14  VARCHAR2
    , p15_a15  NUMBER
    , p15_a16  VARCHAR2
    , p15_a17  NUMBER
    , p15_a18  VARCHAR2
    , p15_a19  VARCHAR2
    , p15_a20  NUMBER
    , p15_a21  NUMBER
    , p15_a22  VARCHAR2
    , p15_a23  VARCHAR2
    , p15_a24  NUMBER
    , p15_a25  NUMBER
    , p15_a26  NUMBER
    , p15_a27  NUMBER
    , p15_a28  NUMBER
    , p15_a29  NUMBER
    , p15_a30  VARCHAR2
    , p15_a31  NUMBER
    , p15_a32  NUMBER
    , p15_a33  VARCHAR2
    , p15_a34  VARCHAR2
    , p15_a35  VARCHAR2
    , p15_a36  VARCHAR2
    , p15_a37  VARCHAR2
    , p15_a38  VARCHAR2
    , p15_a39  VARCHAR2
    , p15_a40  VARCHAR2
    , p15_a41  VARCHAR2
    , p15_a42  VARCHAR2
    , p15_a43  VARCHAR2
    , p15_a44  VARCHAR2
    , p15_a45  VARCHAR2
    , p15_a46  VARCHAR2
    , p15_a47  VARCHAR2
    , p15_a48  VARCHAR2
    , p15_a49  VARCHAR2
    , p15_a50  VARCHAR2
    , p15_a51  VARCHAR2
    , p15_a52  VARCHAR2
    , p15_a53  VARCHAR2
    , p15_a54  VARCHAR2
    , p15_a55  NUMBER
    , p15_a56  VARCHAR2
    , p15_a57  NUMBER
    , p15_a58  VARCHAR2
    , p15_a59  VARCHAR2
    , p15_a60  DATE
    , p15_a61  NUMBER
    , p15_a62  VARCHAR2
    , p15_a63  VARCHAR2
    , p15_a64  VARCHAR2
    , p15_a65  VARCHAR2
    , p15_a66  VARCHAR2
    , p15_a67  VARCHAR2
    , p15_a68  VARCHAR2
    , p15_a69  VARCHAR2
    , p15_a70  VARCHAR2
    , p15_a71  VARCHAR2
    , p15_a72  VARCHAR2
    , p15_a73  VARCHAR2
    , p15_a74  VARCHAR2
    , p15_a75  VARCHAR2
    , p15_a76  VARCHAR2
    , p15_a77  VARCHAR2
    , p15_a78  NUMBER
    , p15_a79  NUMBER
    , p15_a80  NUMBER
    , p15_a81  NUMBER
    , p15_a82  VARCHAR2
    , p15_a83  DATE
    , p15_a84  VARCHAR2
    , p15_a85  NUMBER
    , p15_a86  NUMBER
    , p15_a87  VARCHAR2
    , p15_a88  NUMBER
    , p15_a89  VARCHAR2
    , p15_a90  NUMBER
    , p15_a91  NUMBER
    , p15_a92  VARCHAR2
    , p15_a93  NUMBER
    , p15_a94  VARCHAR2
    , p15_a95  VARCHAR2
    , p15_a96  VARCHAR2
    , p15_a97  DATE
    , p15_a98  NUMBER
    , p15_a99  NUMBER
    , p15_a100  NUMBER
    , p15_a101  NUMBER
    , p15_a102  NUMBER
    , p15_a103  VARCHAR2
    , p15_a104  NUMBER
    , p15_a105  VARCHAR2
    , p15_a106  NUMBER
    , p15_a107  VARCHAR2
    , p15_a108  NUMBER
    , p15_a109  VARCHAR2
    , p15_a110  VARCHAR2
    , p15_a111  VARCHAR2
    , p15_a112  VARCHAR2
    , p15_a113  VARCHAR2
    , p15_a114  VARCHAR2
    , p15_a115  NUMBER
    , p15_a116  NUMBER
    , p15_a117  VARCHAR2
    , p15_a118  NUMBER
    , p15_a119  NUMBER
    , p15_a120  VARCHAR2
    , p15_a121  VARCHAR2
    , p15_a122  VARCHAR2
    , p15_a123  VARCHAR2
    , p15_a124  VARCHAR2
    , p15_a125  VARCHAR2
    , p16_a0 JTF_VARCHAR2_TABLE_2000
    , p16_a1 JTF_VARCHAR2_TABLE_32767
    , p16_a2 JTF_VARCHAR2_TABLE_300
    , p16_a3 JTF_VARCHAR2_TABLE_100
    , p16_a4 JTF_NUMBER_TABLE
    , p16_a5 JTF_VARCHAR2_TABLE_100
    , p16_a6 JTF_NUMBER_TABLE
    , p16_a7 JTF_VARCHAR2_TABLE_100
    , p16_a8 JTF_NUMBER_TABLE
    , p17_a0 JTF_NUMBER_TABLE
    , p17_a1 JTF_NUMBER_TABLE
    , p17_a2 JTF_NUMBER_TABLE
    , p17_a3 JTF_VARCHAR2_TABLE_100
    , p17_a4 JTF_VARCHAR2_TABLE_100
    , p17_a5 JTF_VARCHAR2_TABLE_100
    , p_called_by_workflow  VARCHAR2
    , p_workflow_process_id  NUMBER
    , x_workflow_process_id out nocopy  NUMBER
    , x_interaction_id out nocopy  NUMBER
  )

  as
    ddp_last_update_date date;
Line: 750

    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);
Line: 877

    ddp_service_request_rec.last_update_channel := p15_a125;
Line: 903

    iem_servicerequest_pvt.update_servicerequest_wrap(p_api_version,
      p_init_msg_list,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_request_id,
      p_request_number,
      p_audit_comments,
      p_object_version_number,
      p_resp_appl_id,
      p_resp_id,
      p_last_updated_by,
      p_last_update_login,
      ddp_last_update_date,
      ddp_service_request_rec,
      ddp_notes,
      ddp_contacts,
      p_called_by_workflow,
      p_workflow_process_id,
      x_workflow_process_id,
      x_interaction_id);
Line: 1209

    ddp_sr_record.last_update_channel := p0_a125;
Line: 1340

    p0_a125 := ddp_sr_record.last_update_channel;