DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PUB_W SQL Statements

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

Line: 707

          t(ddindx).last_updated_by := a29(indx);
Line: 708

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a30(indx));
Line: 709

          t(ddindx).last_update_login := a31(indx);
Line: 1075

          a29(indx) := t(ddindx).last_updated_by;
Line: 1076

          a30(indx) := t(ddindx).last_update_date;
Line: 1077

          a31(indx) := t(ddindx).last_update_login;
Line: 1501

    ddp_sr_record.last_update_channel := p0_a141;
Line: 1535

    ddp_sr_record.last_update_program_code := p0_a175;
Line: 1732

    p0_a141 := ddp_sr_record.last_update_channel;
Line: 1766

    p0_a175 := ddp_sr_record.last_update_program_code;
Line: 2261

    ddp_service_request_rec.last_update_channel := p13_a141;
Line: 2295

    ddp_service_request_rec.last_update_program_code := p13_a175;
Line: 2876

    ddp_service_request_rec.last_update_channel := p13_a141;
Line: 2910

    ddp_service_request_rec.last_update_program_code := p13_a175;
Line: 3047

  procedure update_servicerequest(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  VARCHAR2
    , p15_a79  VARCHAR2
    , p15_a80  VARCHAR2
    , p15_a81  VARCHAR2
    , p15_a82  VARCHAR2
    , p15_a83  VARCHAR2
    , p15_a84  VARCHAR2
    , p15_a85  VARCHAR2
    , p15_a86  VARCHAR2
    , p15_a87  VARCHAR2
    , p15_a88  VARCHAR2
    , p15_a89  VARCHAR2
    , p15_a90  VARCHAR2
    , p15_a91  VARCHAR2
    , p15_a92  VARCHAR2
    , p15_a93  VARCHAR2
    , p15_a94  NUMBER
    , p15_a95  NUMBER
    , p15_a96  NUMBER
    , p15_a97  NUMBER
    , p15_a98  VARCHAR2
    , p15_a99  DATE
    , p15_a100  VARCHAR2
    , p15_a101  NUMBER
    , p15_a102  NUMBER
    , p15_a103  VARCHAR2
    , p15_a104  NUMBER
    , p15_a105  VARCHAR2
    , p15_a106  NUMBER
    , p15_a107  NUMBER
    , p15_a108  VARCHAR2
    , p15_a109  NUMBER
    , p15_a110  VARCHAR2
    , p15_a111  VARCHAR2
    , p15_a112  VARCHAR2
    , p15_a113  DATE
    , p15_a114  NUMBER
    , p15_a115  NUMBER
    , p15_a116  NUMBER
    , p15_a117  NUMBER
    , p15_a118  NUMBER
    , p15_a119  VARCHAR2
    , p15_a120  NUMBER
    , p15_a121  VARCHAR2
    , p15_a122  NUMBER
    , p15_a123  VARCHAR2
    , p15_a124  NUMBER
    , p15_a125  VARCHAR2
    , p15_a126  VARCHAR2
    , p15_a127  VARCHAR2
    , p15_a128  VARCHAR2
    , p15_a129  VARCHAR2
    , p15_a130  VARCHAR2
    , p15_a131  NUMBER
    , p15_a132  NUMBER
    , p15_a133  VARCHAR2
    , p15_a134  NUMBER
    , p15_a135  NUMBER
    , p15_a136  VARCHAR2
    , p15_a137  VARCHAR2
    , p15_a138  VARCHAR2
    , p15_a139  VARCHAR2
    , p15_a140  VARCHAR2
    , p15_a141  VARCHAR2
    , p15_a142  NUMBER
    , p15_a143  VARCHAR2
    , p15_a144  NUMBER
    , p15_a145  VARCHAR2
    , p15_a146  DATE
    , p15_a147  DATE
    , p15_a148  DATE
    , p15_a149  VARCHAR2
    , p15_a150  NUMBER
    , p15_a151  VARCHAR2
    , p15_a152  VARCHAR2
    , p15_a153  VARCHAR2
    , p15_a154  VARCHAR2
    , p15_a155  VARCHAR2
    , p15_a156  VARCHAR2
    , p15_a157  VARCHAR2
    , p15_a158  VARCHAR2
    , p15_a159  VARCHAR2
    , p15_a160  VARCHAR2
    , p15_a161  VARCHAR2
    , p15_a162  VARCHAR2
    , p15_a163  VARCHAR2
    , p15_a164  DATE
    , p15_a165  VARCHAR
    , p15_a166  VARCHAR
    , p15_a167  VARCHAR
    , p15_a168  VARCHAR
    , p15_a169  NUMBER
    , p15_a170  NUMBER
    , p15_a171  NUMBER
    , p15_a172  NUMBER
    , p15_a173  NUMBER
    , p15_a174  VARCHAR2
    , p15_a175  VARCHAR2
    , p15_a176  NUMBER
    , p15_a177  NUMBER
    , p15_a178  NUMBER
    , p15_a179  NUMBER
    , p15_a180  NUMBER
    , p15_a181  NUMBER
    , p15_a182  NUMBER
    , p15_a183  NUMBER
    , p15_a184  VARCHAR2
    , p15_a185  VARCHAR2
    , p15_a186  VARCHAR2
    , p15_a187  VARCHAR2
    , p15_a188  VARCHAR2
    , p15_a189  VARCHAR2
    , p15_a190  VARCHAR2
    , p15_a191  VARCHAR2
    , p15_a192  VARCHAR2
    , p15_a193  VARCHAR2
    , p15_a194  VARCHAR2
    , p15_a195  VARCHAR2
    , p15_a196  VARCHAR2
    , p15_a197  VARCHAR2
    , p15_a198  VARCHAR2
    , p15_a199  VARCHAR2
    , p15_a200  VARCHAR2
    , p15_a201  VARCHAR2
    , p15_a202  VARCHAR2
    , p15_a203  VARCHAR2
    , p15_a204  VARCHAR2
    , p15_a205  NUMBER
    , p15_a206  VARCHAR2
    , p15_a207  NUMBER
    , p15_a208  VARCHAR2
    , p15_a209  VARCHAR2
    , p15_a210  NUMBER
    , p15_a211  DATE
    , p15_a212  NUMBER
    , p15_a213  NUMBER
    , p15_a214  NUMBER
    , p15_a215  NUMBER
    , p15_a216  NUMBER
    , p15_a217  DATE
    , p15_a218  DATE
    , p15_a219  DATE
    , p15_a220  DATE
    , p15_a221  DATE
    , p15_a222  DATE
    , p15_a223  NUMBER
    , p15_a224  NUMBER
    , p15_a225  NUMBER
    , 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
    , p17_a6 JTF_VARCHAR2_TABLE_100
    , p17_a7 JTF_DATE_TABLE
    , p17_a8 JTF_DATE_TABLE
    , p_called_by_workflow  VARCHAR2
    , p_workflow_process_id  NUMBER
    , p_auto_assign  VARCHAR2
    , p_validate_sr_closure  VARCHAR2
    , p_auto_close_child_entities  VARCHAR2
    , p_default_contract_sla_ind  VARCHAR2
    , p_auto_generate_tasks  VARCHAR2
    , p25_a0 out nocopy  NUMBER
    , p25_a1 out nocopy  NUMBER
    , p25_a2 out nocopy  NUMBER
    , p25_a3 out nocopy  NUMBER
    , p25_a4 out nocopy  VARCHAR2
    , p25_a5 out nocopy  DATE
    , p25_a6 out nocopy  DATE
    , p25_a7 out nocopy  NUMBER
    , p25_a8 out nocopy  DATE
    , p25_a9 out nocopy  NUMBER
  )

  as
    ddp_last_update_date date;
Line: 3330

    ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
Line: 3349

    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);
Line: 3492

    ddp_service_request_rec.last_update_channel := p15_a141;
Line: 3526

    ddp_service_request_rec.last_update_program_code := p15_a175;
Line: 3609

    cs_servicerequest_pub.update_servicerequest(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,
      p_auto_assign,
      p_validate_sr_closure,
      p_auto_close_child_entities,
      p_default_contract_sla_ind,
      p_auto_generate_tasks,
      ddx_sr_update_out_rec);
Line: 3662

    p25_a0 := ddx_sr_update_out_rec.interaction_id;
Line: 3663

    p25_a1 := ddx_sr_update_out_rec.workflow_process_id;
Line: 3664

    p25_a2 := ddx_sr_update_out_rec.individual_owner;
Line: 3665

    p25_a3 := ddx_sr_update_out_rec.group_owner;
Line: 3666

    p25_a4 := ddx_sr_update_out_rec.individual_type;
Line: 3667

    p25_a5 := ddx_sr_update_out_rec.resolved_on_date;
Line: 3668

    p25_a6 := ddx_sr_update_out_rec.responded_on_date;
Line: 3669

    p25_a7 := ddx_sr_update_out_rec.status_id;
Line: 3670

    p25_a8 := ddx_sr_update_out_rec.close_date;
Line: 3671

    p25_a9 := ddx_sr_update_out_rec.incident_location_id;
Line: 3674

  procedure update_servicerequest(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  VARCHAR2
    , p15_a79  VARCHAR2
    , p15_a80  VARCHAR2
    , p15_a81  VARCHAR2
    , p15_a82  VARCHAR2
    , p15_a83  VARCHAR2
    , p15_a84  VARCHAR2
    , p15_a85  VARCHAR2
    , p15_a86  VARCHAR2
    , p15_a87  VARCHAR2
    , p15_a88  VARCHAR2
    , p15_a89  VARCHAR2
    , p15_a90  VARCHAR2
    , p15_a91  VARCHAR2
    , p15_a92  VARCHAR2
    , p15_a93  VARCHAR2
    , p15_a94  NUMBER
    , p15_a95  NUMBER
    , p15_a96  NUMBER
    , p15_a97  NUMBER
    , p15_a98  VARCHAR2
    , p15_a99  DATE
    , p15_a100  VARCHAR2
    , p15_a101  NUMBER
    , p15_a102  NUMBER
    , p15_a103  VARCHAR2
    , p15_a104  NUMBER
    , p15_a105  VARCHAR2
    , p15_a106  NUMBER
    , p15_a107  NUMBER
    , p15_a108  VARCHAR2
    , p15_a109  NUMBER
    , p15_a110  VARCHAR2
    , p15_a111  VARCHAR2
    , p15_a112  VARCHAR2
    , p15_a113  DATE
    , p15_a114  NUMBER
    , p15_a115  NUMBER
    , p15_a116  NUMBER
    , p15_a117  NUMBER
    , p15_a118  NUMBER
    , p15_a119  VARCHAR2
    , p15_a120  NUMBER
    , p15_a121  VARCHAR2
    , p15_a122  NUMBER
    , p15_a123  VARCHAR2
    , p15_a124  NUMBER
    , p15_a125  VARCHAR2
    , p15_a126  VARCHAR2
    , p15_a127  VARCHAR2
    , p15_a128  VARCHAR2
    , p15_a129  VARCHAR2
    , p15_a130  VARCHAR2
    , p15_a131  NUMBER
    , p15_a132  NUMBER
    , p15_a133  VARCHAR2
    , p15_a134  NUMBER
    , p15_a135  NUMBER
    , p15_a136  VARCHAR2
    , p15_a137  VARCHAR2
    , p15_a138  VARCHAR2
    , p15_a139  VARCHAR2
    , p15_a140  VARCHAR2
    , p15_a141  VARCHAR2
    , p15_a142  NUMBER
    , p15_a143  VARCHAR2
    , p15_a144  NUMBER
    , p15_a145  VARCHAR2
    , p15_a146  DATE
    , p15_a147  DATE
    , p15_a148  DATE
    , p15_a149  VARCHAR2
    , p15_a150  NUMBER
    , p15_a151  VARCHAR2
    , p15_a152  VARCHAR2
    , p15_a153  VARCHAR2
    , p15_a154  VARCHAR2
    , p15_a155  VARCHAR2
    , p15_a156  VARCHAR2
    , p15_a157  VARCHAR2
    , p15_a158  VARCHAR2
    , p15_a159  VARCHAR2
    , p15_a160  VARCHAR2
    , p15_a161  VARCHAR2
    , p15_a162  VARCHAR2
    , p15_a163  VARCHAR2
    , p15_a164  DATE
    , p15_a165  VARCHAR
    , p15_a166  VARCHAR
    , p15_a167  VARCHAR
    , p15_a168  VARCHAR
    , p15_a169  NUMBER
    , p15_a170  NUMBER
    , p15_a171  NUMBER
    , p15_a172  NUMBER
    , p15_a173  NUMBER
    , p15_a174  VARCHAR2
    , p15_a175  VARCHAR2
    , p15_a176  NUMBER
    , p15_a177  NUMBER
    , p15_a178  NUMBER
    , p15_a179  NUMBER
    , p15_a180  NUMBER
    , p15_a181  NUMBER
    , p15_a182  NUMBER
    , p15_a183  NUMBER
    , p15_a184  VARCHAR2
    , p15_a185  VARCHAR2
    , p15_a186  VARCHAR2
    , p15_a187  VARCHAR2
    , p15_a188  VARCHAR2
    , p15_a189  VARCHAR2
    , p15_a190  VARCHAR2
    , p15_a191  VARCHAR2
    , p15_a192  VARCHAR2
    , p15_a193  VARCHAR2
    , p15_a194  VARCHAR2
    , p15_a195  VARCHAR2
    , p15_a196  VARCHAR2
    , p15_a197  VARCHAR2
    , p15_a198  VARCHAR2
    , p15_a199  VARCHAR2
    , p15_a200  VARCHAR2
    , p15_a201  VARCHAR2
    , p15_a202  VARCHAR2
    , p15_a203  VARCHAR2
    , p15_a204  VARCHAR2
    , p15_a205  NUMBER
    , p15_a206  VARCHAR2
    , p15_a207  NUMBER
    , p15_a208  VARCHAR2
    , p15_a209  VARCHAR2
    , p15_a210  NUMBER
    , p15_a211  DATE
    , p15_a212  NUMBER
    , p15_a213  NUMBER
    , p15_a214  NUMBER
    , p15_a215  NUMBER
    , p15_a216  NUMBER
    , p15_a217  DATE
    , p15_a218  DATE
    , p15_a219  DATE
    , p15_a220  DATE
    , p15_a221  DATE
    , p15_a222  DATE
    , p15_a223  NUMBER
    , p15_a224  NUMBER
    , p15_a225  NUMBER
    , 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
    , p17_a6 JTF_VARCHAR2_TABLE_100
    , p17_a7 JTF_DATE_TABLE
    , p17_a8 JTF_DATE_TABLE
    , p_called_by_workflow  VARCHAR2
    , p_workflow_process_id  NUMBER
    , p_default_contract_sla_ind  VARCHAR2
    , x_workflow_process_id out nocopy  NUMBER
    , x_interaction_id out nocopy  NUMBER
  )

  as
    ddp_last_update_date date;
Line: 3963

    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);
Line: 4106

    ddp_service_request_rec.last_update_channel := p15_a141;
Line: 4140

    ddp_service_request_rec.last_update_program_code := p15_a175;
Line: 4220

    cs_servicerequest_pub.update_servicerequest(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,
      p_default_contract_sla_ind,
      x_workflow_process_id,
      x_interaction_id);
Line: 4269

  procedure update_status(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_resp_appl_id  NUMBER
    , p_resp_id  NUMBER
    , p_user_id  NUMBER
    , p_login_id  NUMBER
    , p_request_id  NUMBER
    , p_request_number  VARCHAR2
    , p_object_version_number  NUMBER
    , p_status_id  NUMBER
    , p_status  VARCHAR2
    , p_closed_date  date
    , p_audit_comments  VARCHAR2
    , p_called_by_workflow  VARCHAR2
    , p_workflow_process_id  NUMBER
    , p_comments  VARCHAR2
    , p_public_comment_flag  VARCHAR2
    , p_validate_sr_closure  VARCHAR2
    , p_auto_close_child_entities  VARCHAR2
    , p_auto_generate_tasks  VARCHAR2
    , x_interaction_id out nocopy  NUMBER
  )

  as
    ddp_closed_date date;
Line: 4329

    cs_servicerequest_pub.update_status(p_api_version,
      p_init_msg_list,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_resp_appl_id,
      p_resp_id,
      p_user_id,
      p_login_id,
      p_request_id,
      p_request_number,
      p_object_version_number,
      p_status_id,
      p_status,
      ddp_closed_date,
      p_audit_comments,
      p_called_by_workflow,
      p_workflow_process_id,
      p_comments,
      p_public_comment_flag,
      p_validate_sr_closure,
      p_auto_close_child_entities,
      p_auto_generate_tasks,
      x_interaction_id);
Line: 4808

    ddp_service_request_rec.last_update_channel := p13_a141;
Line: 4842

    ddp_service_request_rec.last_update_program_code := p13_a175;
Line: 5318

    ddx_getsr_out_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a38);
Line: 5520

    p3_a38 := ddx_getsr_out_rec.last_update_date;