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.JTF_TERRITORY_PUB SQL Statements

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

Line: 60


      x_terr_rec.last_update_date := p_terr_rec.last_update_date;

Line: 61


      x_terr_rec.last_updated_by := p_terr_rec.last_updated_by;

Line: 64


      x_terr_rec.last_update_login := p_terr_rec.last_update_login;

Line: 71


      x_terr_rec.program_update_date := p_terr_rec.program_update_date;

Line: 76


      x_terr_rec.update_flag := p_terr_rec.update_flag;

Line: 141


         x_terrqual_tbl (l_counter).last_update_date :=
            p_terrqual_tbl (l_counter).last_update_date;

Line: 143


         x_terrqual_tbl (l_counter).last_updated_by :=
            p_terrqual_tbl (l_counter).last_updated_by;

Line: 149


         x_terrqual_tbl (l_counter).last_update_login :=
            p_terrqual_tbl (l_counter).last_update_login;

Line: 202


         x_terrvalues_tbl (l_counter).last_update_date :=
            p_terrvalues_tbl (l_counter).last_update_date;

Line: 204


         x_terrvalues_tbl (l_counter).last_updated_by :=
            p_terrvalues_tbl (l_counter).last_updated_by;

Line: 210


         x_terrvalues_tbl (l_counter).last_update_login :=
            p_terrvalues_tbl (l_counter).last_update_login;

Line: 299


         x_terrusgs_tbl (l_counter).last_update_date :=
            p_terrusgs_tbl (l_counter).last_update_date;

Line: 301


         x_terrusgs_tbl (l_counter).last_updated_by :=
            p_terrusgs_tbl (l_counter).last_updated_by;

Line: 307


         x_terrusgs_tbl (l_counter).last_update_login :=
            p_terrusgs_tbl (l_counter).last_update_login;

Line: 349


         x_terrqtypeusgs_tbl (l_counter).last_update_date :=
            p_terrqtypeusgs_tbl (l_counter).last_update_date;

Line: 351


         x_terrqtypeusgs_tbl (l_counter).last_updated_by :=
            p_terrqtypeusgs_tbl (l_counter).last_updated_by;

Line: 357


         x_terrqtypeusgs_tbl (l_counter).last_update_login :=
            p_terrqtypeusgs_tbl (l_counter).last_update_login;

Line: 563


         x_terrrsc_tbl (l_counter).last_update_date :=
            p_terrrsc_tbl (l_counter).last_update_date;

Line: 565


         x_terrrsc_tbl (l_counter).last_updated_by :=
            p_terrrsc_tbl (l_counter).last_updated_by;

Line: 571


         x_terrrsc_tbl (l_counter).last_update_login :=
            p_terrrsc_tbl (l_counter).last_update_login;

Line: 630


         x_terrrscacc_tbl (l_counter).last_update_date :=
            p_terrrscacc_tbl (l_counter).last_update_date;

Line: 632


         x_terrrscacc_tbl (l_counter).last_updated_by :=
            p_terrrscacc_tbl (l_counter).last_updated_by;

Line: 638


         x_terrrscacc_tbl (l_counter).last_update_login :=
            p_terrrscacc_tbl (l_counter).last_update_login;

Line: 1003


   PROCEDURE delete_territory (
      p_api_version_number   IN       NUMBER,
      p_init_msg_list        IN       VARCHAR2 := fnd_api.g_false,
      p_commit               IN       VARCHAR2 := fnd_api.g_false,
      x_return_status        OUT NOCOPY      VARCHAR2,
      x_msg_count            OUT NOCOPY      NUMBER,
      x_msg_data             OUT NOCOPY      VARCHAR2,
      p_terr_id              IN       NUMBER
   )
   AS
      l_api_name           CONSTANT VARCHAR2(30) := 'Delete_Territory';

Line: 1018


      SAVEPOINT delete_territory_pub;

Line: 1050


      jtf_territory_pvt.delete_territory (
         p_api_version_number => p_api_version_number,
         p_init_msg_list => p_init_msg_list,
         p_commit => p_commit,
         x_return_status => x_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data,
         p_terr_id => p_terr_id
      );

Line: 1089


         ROLLBACK TO delete_territory_pub;

Line: 1097


         ROLLBACK TO delete_territory_pub;

Line: 1105


         ROLLBACK TO delete_territory_pub;

Line: 1111


               'Others exception in Delete_Territory PUB' || SQLERRM
            );

Line: 1121


   END delete_territory;

Line: 1167


   PROCEDURE update_territory (
      p_api_version_number          IN       NUMBER,
      p_init_msg_list               IN       VARCHAR2 := fnd_api.g_false,
      p_commit                      IN       VARCHAR2 := fnd_api.g_false,
      x_return_status               OUT NOCOPY      VARCHAR2,
      x_msg_count                   OUT NOCOPY      NUMBER,
      x_msg_data                    OUT NOCOPY      VARCHAR2,
      p_terr_all_rec                IN       terr_all_rec_type
            := g_miss_terr_all_rec,
      p_terr_usgs_tbl               IN       terr_usgs_tbl_type
            := g_miss_terr_usgs_tbl,
      p_terr_qualtypeusgs_tbl       IN       terr_qualtypeusgs_tbl_type
            := g_miss_terr_qualtypeusgs_tbl,
      p_terr_qual_tbl               IN       terr_qual_tbl_type
            := g_miss_terr_qual_tbl,
      p_terr_values_tbl             IN       terr_values_tbl_type
            := g_miss_terr_values_tbl,
      x_terr_all_out_rec            OUT NOCOPY      terr_all_out_rec_type,
      x_terr_usgs_out_tbl           OUT NOCOPY      terr_usgs_out_tbl_type,
      x_terr_qualtypeusgs_out_tbl   OUT NOCOPY      terr_qualtypeusgs_out_tbl_type,
      x_terr_qual_out_tbl           OUT NOCOPY      terr_qual_out_tbl_type,
      x_terr_values_out_tbl         OUT NOCOPY      terr_values_out_tbl_type
   )
   AS
      l_api_name           CONSTANT VARCHAR2(30) := 'Update_Territory';

Line: 1263


      jtf_territory_pvt.update_territory (
         p_api_version_number => 1.0,
         p_init_msg_list => fnd_api.g_false,
         p_commit => fnd_api.g_false,
         p_validation_level => fnd_api.g_valid_level_full,
         x_return_status => l_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data,
         p_terr_all_rec => l_terr_rec,
         p_terr_usgs_tbl => l_terr_usgs_tbl,
         p_terr_qualtypeusgs_tbl => l_terr_qualtypeusgs_tbl,
         p_terr_qual_tbl => l_terr_qual_tbl,
         p_terr_values_tbl => l_terr_values_tbl,
         x_terr_all_out_rec => l_terr_out_rec,
         x_terr_usgs_out_tbl => l_terr_usgs_out_tbl,
         x_terr_qualtypeusgs_out_tbl => l_terr_qualtypeusgs_out_tbl,
         x_terr_qual_out_tbl => l_terr_qual_out_tbl,
         x_terr_values_out_tbl => l_terr_values_out_tbl
      );

Line: 1332


         ROLLBACK TO update_territory_pub;

Line: 1341


         ROLLBACK TO update_territory_pub;

Line: 1350


         ROLLBACK TO update_territory_pub;

Line: 1356


               'Others exception in Update_Territory PUB' || SQLERRM
            );

Line: 1366


   END update_territory;

Line: 1751


   PROCEDURE delete_terrresource (
      p_api_version_number   IN       NUMBER,
      p_init_msg_list        IN       VARCHAR2 := fnd_api.g_false,
      p_commit               IN       VARCHAR2 := fnd_api.g_false,
      x_return_status        OUT NOCOPY      VARCHAR2,
      x_msg_count            OUT NOCOPY      NUMBER,
      x_msg_data             OUT NOCOPY      VARCHAR2,
      p_terrrsc_id           IN       NUMBER
   )
   AS
      l_api_name           CONSTANT VARCHAR2(30) := 'Delete_TerrResource';

Line: 1766


      SAVEPOINT delete_terrresource_pub;

Line: 1798


      jtf_territory_resource_pvt.delete_terr_resource (
         p_api_version_number => p_api_version_number,
         p_init_msg_list => p_init_msg_list,
         p_commit => p_commit,
         p_validation_level => fnd_api.g_valid_level_full,
         x_return_status => x_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data,
         p_terrrsc_id => p_terrrsc_id
      );

Line: 1838


         ROLLBACK TO delete_terrresource_pub;

Line: 1846


         ROLLBACK TO delete_terrresource_pub;

Line: 1854


         ROLLBACK TO delete_terrresource_pub;

Line: 1860


               'Others exception in Delete_TerrResource PUB' || SQLERRM
            );

Line: 1870


   END delete_terrresource;

Line: 1909


   PROCEDURE update_terrresource (
      p_api_version_number       IN       NUMBER,
      p_init_msg_list            IN       VARCHAR2 := fnd_api.g_false,
      p_commit                   IN       VARCHAR2 := fnd_api.g_false,
      x_return_status            OUT NOCOPY      VARCHAR2,
      x_msg_count                OUT NOCOPY      NUMBER,
      x_msg_data                 OUT NOCOPY      VARCHAR2,
      p_terrrsc_tbl              IN       terrresource_tbl_type
            := g_miss_terrresource_tbl,
      p_terrrsc_access_tbl       IN       terrrsc_access_tbl_type
            := g_miss_terrrsc_access_tbl,
      x_terrrsc_out_tbl          OUT NOCOPY      terrresource_out_tbl_type,
      x_terrrsc_access_out_tbl   OUT NOCOPY      terrrsc_access_out_tbl_type
   )
   AS
      l_api_name           CONSTANT VARCHAR2(30) := 'Update_TerrResource';

Line: 1977


      jtf_territory_resource_pvt.update_terrresource (
         p_api_version_number => 1.0,
         p_init_msg_list => fnd_api.g_false,
         p_commit => fnd_api.g_false,
         p_validation_level => fnd_api.g_valid_level_full,
         x_return_status => l_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data,
         p_terrrsc_tbl => l_terrrsc_tbl,
         p_terrrsc_access_tbl => l_terrrsc_access_tbl,
         x_terrrsc_out_tbl => l_terrrsc_out_tbl,
         x_terrrsc_access_out_tbl => l_terrrsc_access_out_tbl
      );

Line: 2025


         ROLLBACK TO update_terrresource_pub;

Line: 2033


         ROLLBACK TO update_terrresource_pub;

Line: 2042


         ROLLBACK TO update_terrresource_pub;

Line: 2048


               'Others exception in Update_TerrResource PUB' || SQLERRM
            );

Line: 2058


   END update_terrresource;