APPS.AHL_VWP_RULES_PVT_W SQL Statements

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

Line: 288

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

Line: 289

          t(ddindx).last_updated_by := a35(indx);

Line: 292

          t(ddindx).last_update_login := a38(indx);

Line: 781

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

Line: 782

          a35(indx) := t(ddindx).last_updated_by;

Line: 785

          a38(indx) := t(ddindx).last_update_login;

Line: 852

  procedure insert_tasks(p_visit_id  NUMBER
    , p_unit_id  NUMBER
    , p_serial_id  NUMBER
    , p_service_id  NUMBER
    , p_dept_id  NUMBER
    , p_item_id  NUMBER
    , p_item_org_id  NUMBER
    , p_mr_id  NUMBER
    , p_mr_route_id  NUMBER
    , p_parent_id  NUMBER
    , p_flag  VARCHAR2
    , p_stage_id  NUMBER
    , p_past_task_start_date  date
    , p_past_task_end_date  date
    , p_quantity  NUMBER
    , p_task_start_date  date
    , p_service_type_code  VARCHAR2
    , x_task_id out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_past_task_start_date date;

Line: 908

    ahl_vwp_rules_pvt.insert_tasks(p_visit_id,
      p_unit_id,
      p_serial_id,
      p_service_id,
      p_dept_id,
      p_item_id,
      p_item_org_id,
      p_mr_id,
      p_mr_route_id,
      p_parent_id,
      p_flag,
      p_stage_id,
      ddp_past_task_start_date,
      ddp_past_task_end_date,
      p_quantity,
      ddp_task_start_date,
      p_service_type_code,
      x_task_id,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 1264

    ddp_task_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a34);

Line: 1265

    ddp_task_rec.last_updated_by := p0_a35;

Line: 1268

    ddp_task_rec.last_update_login := p0_a38;

Line: 1366

    p0_a34 := ddp_task_rec.last_update_date;

Line: 1367

    p0_a35 := ddp_task_rec.last_updated_by;

Line: 1370

    p0_a38 := ddp_task_rec.last_update_login;

Line: 1530

  procedure get_warranty_rec_for_update(p0_a0  NUMBER
    , p0_a1  NUMBER
    , p0_a2  NUMBER
    , p0_a3  VARCHAR2
    , p0_a4  NUMBER
    , p0_a5  NUMBER
    , p0_a6  VARCHAR2
    , p0_a7  NUMBER
    , p0_a8  NUMBER
    , p0_a9  NUMBER
    , p0_a10  VARCHAR2
    , p0_a11  NUMBER
    , p0_a12  VARCHAR2
    , p0_a13  NUMBER
    , p0_a14  NUMBER
    , p0_a15  VARCHAR2
    , p0_a16  NUMBER
    , p0_a17  VARCHAR2
    , p0_a18  NUMBER
    , p0_a19  NUMBER
    , p0_a20  NUMBER
    , p0_a21  VARCHAR2
    , p0_a22  NUMBER
    , p0_a23  VARCHAR2
    , p0_a24  NUMBER
    , p0_a25  NUMBER
    , p0_a26  NUMBER
    , p0_a27  VARCHAR2
    , p0_a28  VARCHAR2
    , p0_a29  VARCHAR2
    , p0_a30  VARCHAR2
    , p0_a31  VARCHAR2
    , p0_a32  VARCHAR2
    , p0_a33  NUMBER
    , p0_a34  DATE
    , p0_a35  NUMBER
    , p0_a36  DATE
    , p0_a37  NUMBER
    , p0_a38  NUMBER
    , p0_a39  VARCHAR2
    , p0_a40  VARCHAR2
    , p0_a41  VARCHAR2
    , p0_a42  VARCHAR2
    , p0_a43  VARCHAR2
    , p0_a44  VARCHAR2
    , p0_a45  VARCHAR2
    , p0_a46  VARCHAR2
    , p0_a47  VARCHAR2
    , p0_a48  VARCHAR2
    , p0_a49  VARCHAR2
    , p0_a50  VARCHAR2
    , p0_a51  VARCHAR2
    , p0_a52  VARCHAR2
    , p0_a53  VARCHAR2
    , p0_a54  VARCHAR2
    , p0_a55  DATE
    , p0_a56  DATE
    , p0_a57  DATE
    , p0_a58  VARCHAR2
    , p0_a59  VARCHAR2
    , p0_a60  NUMBER
    , p0_a61  NUMBER
    , p0_a62  VARCHAR2
    , p0_a63  NUMBER
    , p0_a64  VARCHAR2
    , p0_a65  VARCHAR2
    , p0_a66  DATE
    , p0_a67  DATE
    , p0_a68  VARCHAR2
    , p0_a69  VARCHAR2
    , p0_a70  VARCHAR2
    , p0_a71  NUMBER
    , p0_a72  VARCHAR2
    , p0_a73  NUMBER
    , p0_a74  VARCHAR2
    , p0_a75  VARCHAR2
    , p0_a76  VARCHAR2
    , p0_a77  VARCHAR2
    , p0_a78  DATE
    , p0_a79  DATE
    , p0_a80  NUMBER
    , p0_a81  NUMBER
    , p0_a82  NUMBER
    , p0_a83  VARCHAR2
    , p0_a84  VARCHAR2
    , p0_a85  VARCHAR2
    , p0_a86  VARCHAR2
    , p0_a87  VARCHAR2
    , p0_a88  VARCHAR2
    , p0_a89  VARCHAR2
    , p0_a90  VARCHAR2
    , p0_a91  VARCHAR2
    , p0_a92  VARCHAR2
    , p0_a93  NUMBER
    , p0_a94  VARCHAR2
    , p1_a0 out nocopy JTF_NUMBER_TABLE
    , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
    , p1_a2 out nocopy JTF_NUMBER_TABLE
    , p1_a3 out nocopy JTF_DATE_TABLE
    , p1_a4 out nocopy JTF_NUMBER_TABLE
    , p1_a5 out nocopy JTF_DATE_TABLE
    , p1_a6 out nocopy JTF_NUMBER_TABLE
    , p1_a7 out nocopy JTF_NUMBER_TABLE
    , p1_a8 out nocopy JTF_NUMBER_TABLE
    , p1_a9 out nocopy JTF_NUMBER_TABLE
    , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100
    , p1_a11 out nocopy JTF_NUMBER_TABLE
    , p1_a12 out nocopy JTF_NUMBER_TABLE
    , p1_a13 out nocopy JTF_NUMBER_TABLE
    , p1_a14 out nocopy JTF_NUMBER_TABLE
    , p1_a15 out nocopy JTF_NUMBER_TABLE
    , p1_a16 out nocopy JTF_NUMBER_TABLE
    , p1_a17 out nocopy JTF_VARCHAR2_TABLE_100
    , p1_a18 out nocopy JTF_VARCHAR2_TABLE_100
    , p1_a19 out nocopy JTF_NUMBER_TABLE
    , p1_a20 out nocopy JTF_VARCHAR2_TABLE_100
    , p1_a21 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a22 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a23 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a24 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a25 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a26 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a27 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a28 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a29 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a30 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a31 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a32 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a33 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a34 out nocopy JTF_VARCHAR2_TABLE_200
    , p1_a35 out nocopy JTF_VARCHAR2_TABLE_200
  )

  as
    ddp_task_rec ahl_vwp_rules_pvt.task_rec_type;

Line: 1704

    ddp_task_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a34);

Line: 1705

    ddp_task_rec.last_updated_by := p0_a35;

Line: 1708

    ddp_task_rec.last_update_login := p0_a38;

Line: 1768

    ahl_vwp_rules_pvt.get_warranty_rec_for_update(ddp_task_rec,
      ddx_warranty_entl_tbl);