eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT_W SQL Statements

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

Line: 126


          t(ddindx).select_disable_flag := a43(indx);

Line: 504


          a43(indx) := t(ddindx).select_disable_flag;

Line: 1286


  procedure calc_qty_on_inst_selection(p0_a0 in out nocopy  NUMBER
    , p0_a1 in out nocopy  NUMBER
    , p0_a2 in out nocopy  NUMBER
    , p0_a3 in out nocopy  NUMBER
    , p0_a4 in out nocopy  NUMBER
    , p0_a5 in out nocopy  NUMBER
    , p0_a6 in out nocopy  VARCHAR2
    , p0_a7 in out nocopy  NUMBER
    , p0_a8 in out nocopy  NUMBER
    , p0_a9 in out nocopy  NUMBER
    , p0_a10 in out nocopy  NUMBER
    , p0_a11 in out nocopy  NUMBER
    , p0_a12 in out nocopy  VARCHAR2
    , p0_a13 in out nocopy  NUMBER
    , p0_a14 in out nocopy  VARCHAR2
    , p0_a15 in out nocopy  VARCHAR2
    , p0_a16 in out nocopy  VARCHAR2
    , p0_a17 in out nocopy  NUMBER
    , p0_a18 in out nocopy  VARCHAR2
    , p0_a19 in out nocopy  VARCHAR2
    , p0_a20 in out nocopy  VARCHAR2
    , p0_a21 in out nocopy  VARCHAR2
    , p0_a22 in out nocopy  VARCHAR2
    , p0_a23 in out nocopy  VARCHAR2
    , p0_a24 in out nocopy  VARCHAR2
    , p0_a25 in out nocopy  NUMBER
    , p0_a26 in out nocopy  NUMBER
    , p0_a27 in out nocopy  NUMBER
    , p0_a28 in out nocopy  VARCHAR2
    , p0_a29 in out nocopy  VARCHAR2
    , p0_a30 in out nocopy  VARCHAR2
    , p0_a31 in out nocopy  NUMBER
    , p0_a32 in out nocopy  NUMBER
    , p0_a33 in out nocopy  NUMBER
    , p0_a34 in out nocopy  DATE
    , p0_a35 in out nocopy  DATE
    , p0_a36 in out nocopy  NUMBER
    , p0_a37 in out nocopy  VARCHAR2
    , p0_a38 in out nocopy  VARCHAR2
    , p0_a39 in out nocopy  VARCHAR2
    , p0_a40 in out nocopy  VARCHAR2
    , p0_a41 in out nocopy  NUMBER
    , p0_a42 in out nocopy  VARCHAR2
    , p0_a43 in out nocopy  VARCHAR2
    , p0_a44 in out nocopy  VARCHAR2
    , p0_a45 in out nocopy  NUMBER
    , p0_a46 in out nocopy  NUMBER
    , p0_a47 in out nocopy  VARCHAR2
    , p0_a48 in out nocopy  NUMBER
    , p0_a49 in out nocopy  VARCHAR2
    , p0_a50 in out nocopy  VARCHAR2
    , p0_a51 in out nocopy  VARCHAR2
    , p0_a52 in out nocopy  VARCHAR2
    , p0_a53 in out nocopy  VARCHAR2
    , p0_a54 in out nocopy  NUMBER
    , p0_a55 in out nocopy  NUMBER
    , p0_a56 in out nocopy  NUMBER
    , p0_a57 in out nocopy  VARCHAR2
    , p0_a58 in out nocopy  VARCHAR2
    , p0_a59 in out nocopy  VARCHAR2
    , p0_a60 in out nocopy  NUMBER
    , p0_a61 in out nocopy  VARCHAR2
    , p0_a62 in out nocopy  VARCHAR2
    , p0_a63 in out nocopy  VARCHAR2
    , p0_a64 in out nocopy  NUMBER
    , p0_a65 in out nocopy  VARCHAR2
    , p0_a66 in out nocopy  VARCHAR2
    , p0_a67 in out nocopy  VARCHAR2
    , p0_a68 in out nocopy  NUMBER
    , p0_a69 in out nocopy  VARCHAR2
    , p0_a70 in out nocopy  VARCHAR2
    , p0_a71 in out nocopy  VARCHAR2
  )

  as
    ddp_x_uc_details_rec ahl_prd_blk_parts_change_pvt.uc_details_hgrid_rec_type;

Line: 1409


    ddp_x_uc_details_rec.select_disable_flag := p0_a43;

Line: 1440


    ahl_prd_blk_parts_change_pvt.calc_qty_on_inst_selection(ddp_x_uc_details_rec);

Line: 1486


    p0_a43 := ddp_x_uc_details_rec.select_disable_flag;