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.

APPS.AHL_APPROVALS_PVT_W SQL Statements

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

Line: 60


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

Line: 61


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

Line: 64


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

Line: 223


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

Line: 224


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

Line: 227


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

Line: 374


    ddp_x_approval_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a33);

Line: 375


    ddp_x_approval_rules_rec.last_updated_by := p4_a34;

Line: 376


    ddp_x_approval_rules_rec.last_update_login := p4_a35;

Line: 462


    p4_a33 := ddp_x_approval_rules_rec.last_update_date;

Line: 463


    p4_a34 := ddp_x_approval_rules_rec.last_updated_by;

Line: 464


    p4_a35 := ddp_x_approval_rules_rec.last_update_login;

Line: 595


    ddp_approval_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a33);

Line: 596


    ddp_approval_rules_rec.last_updated_by := p7_a34;

Line: 597


    ddp_approval_rules_rec.last_update_login := p7_a35;

Line: 623


  procedure update_approval_rules(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p7_a0  NUMBER
    , p7_a1  NUMBER
    , p7_a2  VARCHAR2
    , p7_a3  VARCHAR2
    , p7_a4  VARCHAR2
    , p7_a5  VARCHAR2
    , p7_a6  VARCHAR2
    , p7_a7  NUMBER
    , p7_a8  VARCHAR2
    , p7_a9  DATE
    , p7_a10  DATE
    , p7_a11  VARCHAR2
    , p7_a12  VARCHAR2
    , p7_a13  VARCHAR2
    , p7_a14  VARCHAR2
    , p7_a15  VARCHAR2
    , p7_a16  VARCHAR2
    , p7_a17  VARCHAR2
    , p7_a18  VARCHAR2
    , p7_a19  VARCHAR2
    , p7_a20  VARCHAR2
    , p7_a21  VARCHAR2
    , p7_a22  VARCHAR2
    , p7_a23  VARCHAR2
    , p7_a24  VARCHAR2
    , p7_a25  VARCHAR2
    , p7_a26  VARCHAR2
    , p7_a27  VARCHAR2
    , p7_a28  VARCHAR2
    , p7_a29  VARCHAR2
    , p7_a30  VARCHAR2
    , p7_a31  DATE
    , p7_a32  NUMBER
    , p7_a33  DATE
    , p7_a34  NUMBER
    , p7_a35  NUMBER
    , p7_a36  VARCHAR2
  )

  as
    ddp_approval_rules_rec ahl_approvals_pvt.approval_rules_rec_type;

Line: 715


    ddp_approval_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a33);

Line: 716


    ddp_approval_rules_rec.last_updated_by := p7_a34;

Line: 717


    ddp_approval_rules_rec.last_update_login := p7_a35;

Line: 721


    ahl_approvals_pvt.update_approval_rules(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_approval_rules_rec);

Line: 832


    ddp_approval_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a33);

Line: 833


    ddp_approval_rules_rec.last_updated_by := p7_a34;

Line: 834


    ddp_approval_rules_rec.last_update_login := p7_a35;

Line: 937


    ddp_approval_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a33);

Line: 938


    ddp_approval_rules_rec.last_updated_by := p0_a34;

Line: 939


    ddp_approval_rules_rec.last_update_login := p0_a35;

Line: 1071


    ddp_approval_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a33);

Line: 1072


    ddp_approval_rules_rec.last_updated_by := p0_a34;

Line: 1073


    ddp_approval_rules_rec.last_update_login := p0_a35;

Line: 1109


    ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a33);

Line: 1110


    ddp_complete_rec.last_updated_by := p1_a34;

Line: 1111


    ddp_complete_rec.last_update_login := p1_a35;

Line: 1241


    ddp_approval_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a33);

Line: 1242


    ddp_approval_rules_rec.last_updated_by := p0_a34;

Line: 1243


    ddp_approval_rules_rec.last_update_login := p0_a35;

Line: 1286


    p1_a33 := ddx_complete_rec.last_update_date;

Line: 1287


    p1_a34 := ddx_complete_rec.last_updated_by;

Line: 1288


    p1_a35 := ddx_complete_rec.last_update_login;

Line: 1351


    ddp_approvers_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a7);

Line: 1352


    ddp_approvers_rec.last_updated_by := p7_a8;

Line: 1355


    ddp_approvers_rec.last_update_login := p7_a11;

Line: 1397


  procedure update_approvers(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p4_a0  NUMBER
    , p4_a1  NUMBER
    , p4_a2  NUMBER
    , p4_a3  VARCHAR2
    , p4_a4  NUMBER
    , p4_a5  NUMBER
    , p4_a6  VARCHAR2
    , p4_a7  DATE
    , p4_a8  NUMBER
    , p4_a9  DATE
    , p4_a10  NUMBER
    , p4_a11  NUMBER
    , p4_a12  VARCHAR2
    , p4_a13  VARCHAR2
    , p4_a14  VARCHAR2
    , p4_a15  VARCHAR2
    , p4_a16  VARCHAR2
    , p4_a17  VARCHAR2
    , p4_a18  VARCHAR2
    , p4_a19  VARCHAR2
    , p4_a20  VARCHAR2
    , p4_a21  VARCHAR2
    , p4_a22  VARCHAR2
    , p4_a23  VARCHAR2
    , p4_a24  VARCHAR2
    , p4_a25  VARCHAR2
    , p4_a26  VARCHAR2
    , p4_a27  VARCHAR2
    , p4_a28  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_approvers_rec ahl_approvals_pvt.approvers_rec_type;

Line: 1452


    ddp_approvers_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a7);

Line: 1453


    ddp_approvers_rec.last_updated_by := p4_a8;

Line: 1456


    ddp_approvers_rec.last_update_login := p4_a11;

Line: 1479


    ahl_approvals_pvt.update_approvers(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      ddp_approvers_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 1556


    ddp_approvers_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a7);

Line: 1557


    ddp_approvers_rec.last_updated_by := p7_a8;

Line: 1560


    ddp_approvers_rec.last_update_login := p7_a11;

Line: 1646


    ddp_approvers_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a7);

Line: 1647


    ddp_approvers_rec.last_updated_by := p1_a8;

Line: 1650


    ddp_approvers_rec.last_update_login := p1_a11;

Line: 1754


    ddp_approvers_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a7);

Line: 1755


    ddp_approvers_rec.last_updated_by := p0_a8;

Line: 1758


    ddp_approvers_rec.last_update_login := p0_a11;

Line: 1791


    p1_a7 := ddx_complete_rec.last_update_date;

Line: 1792


    p1_a8 := ddx_complete_rec.last_updated_by;

Line: 1795


    p1_a11 := ddx_complete_rec.last_update_login;