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: 191


        x_terrqual_rec .last_update_date :=     p_terrqual_rec.last_update_date;

Line: 192


         x_terrqual_rec.last_updated_by :=      p_terrqual_rec.last_updated_by;

Line: 195


         x_terrqual_rec.last_update_login :=    p_terrqual_rec.last_update_login;

Line: 238


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

Line: 240


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

Line: 246


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

Line: 335


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

Line: 337


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

Line: 343


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

Line: 385


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

Line: 387


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

Line: 393


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

Line: 621


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

Line: 623


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

Line: 629


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

Line: 703


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

Line: 705


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

Line: 711


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

Line: 1081


   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: 1096


      SAVEPOINT delete_territory_pub;

Line: 1128


      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: 1168


         ROLLBACK TO delete_territory_pub;

Line: 1176


         ROLLBACK TO delete_territory_pub;

Line: 1184


         ROLLBACK TO delete_territory_pub;

Line: 1190


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

Line: 1200


   END delete_territory;

Line: 1237


   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,
    /* Territory Usage and Transaction types cant be updated in R12.
      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: 1279


      SAVEPOINT update_territory_pub;

Line: 1335


      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: 1407


         ROLLBACK TO update_territory_pub;

Line: 1416


         ROLLBACK TO update_territory_pub;

Line: 1425


         ROLLBACK TO update_territory_pub;

Line: 1431


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

Line: 1441


   END update_territory;

Line: 1818


   PROCEDURE Delete_Terr_Qualifier (
      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_Qual_Id         IN       NUMBER
   )
   AS
      l_api_name           CONSTANT VARCHAR2(30) := 'Delete_Terr_Qualifier';

Line: 1833


      SAVEPOINT delete_territory_pub;

Line: 1865


      jtf_territory_pvt.Delete_Terr_Qualifier (
         p_api_version_number => p_api_version_number,
         p_init_msg_list => p_init_msg_list,
         p_commit => p_commit,
         x_return_status => l_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data,
         P_Terr_Qual_Id => P_Terr_Qual_Id
      );

Line: 1905


         ROLLBACK TO delete_territory_pub;

Line: 1913


         ROLLBACK TO delete_territory_pub;

Line: 1921


         ROLLBACK TO delete_territory_pub;

Line: 1927


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

Line: 1937


  END Delete_Terr_Qualifier;

Line: 1994


      SAVEPOINT update_territory_pub;

Line: 2088


         ROLLBACK TO update_territory_pub;

Line: 2097


         ROLLBACK TO update_territory_pub;

Line: 2106


         ROLLBACK TO update_territory_pub;

Line: 2155


 PROCEDURE Update_Qualifier_Value (
      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_values_tbl             IN       terr_values_tbl_type
            := g_miss_terr_values_tbl,
      x_terr_values_out_tbl         OUT NOCOPY      terr_values_out_tbl_type
   )
   AS
      l_api_name           CONSTANT VARCHAR2(30) := 'Update_Territory';

Line: 2176


      SAVEPOINT update_territory_pub;

Line: 2219


         jtf_territory_pvt.Update_Terr_Value( 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,
                                              P_Terr_Value_Tbl              =>  l_Terr_Values_Tbl,
                                              X_Return_Status               =>  l_Return_Status,
                                              X_Msg_Count                   =>  x_Msg_Count,
                                              X_Msg_Data                    =>  x_Msg_Data,
                                              X_Terr_Value_Out_Tbl          =>  l_Terr_Values_Out_Tbl);

Line: 2268


         ROLLBACK TO update_territory_pub;

Line: 2277


         ROLLBACK TO update_territory_pub;

Line: 2286


         ROLLBACK TO update_territory_pub;

Line: 2292


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

Line: 2302


   END Update_Qualifier_Value;

Line: 2336


   PROCEDURE Delete_Qualifier_Value (
      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_Value_Id         IN       NUMBER
   )
   AS
      l_api_name           CONSTANT VARCHAR2(30) := 'Delete_Terr_Value';

Line: 2351


      SAVEPOINT delete_territory_pub;

Line: 2384


      jtf_territory_pvt.Delete_Terr_Value (
         p_api_version_number => p_api_version_number,
         p_init_msg_list => p_init_msg_list,
         p_commit => p_commit,
         x_return_status => l_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data,
         P_Terr_Value_Id => P_Terr_Value_Id
      );

Line: 2424


         ROLLBACK TO delete_territory_pub;

Line: 2432


         ROLLBACK TO delete_territory_pub;

Line: 2440


         ROLLBACK TO delete_territory_pub;

Line: 2446


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

Line: 2456


   END Delete_Qualifier_Value;

Line: 2692


   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: 2707


      SAVEPOINT delete_terrresource_pub;

Line: 2739


      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 => l_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data,
         p_terrrsc_id => p_terrrsc_id
      );

Line: 2780


         ROLLBACK TO delete_terrresource_pub;

Line: 2788


         ROLLBACK TO delete_terrresource_pub;

Line: 2796


         ROLLBACK TO delete_terrresource_pub;

Line: 2802


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

Line: 2812


   END delete_terrresource;

Line: 2851


   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: 2877


      SAVEPOINT update_terrresource_pub;

Line: 2919


      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: 2968


         ROLLBACK TO update_terrresource_pub;

Line: 2976


         ROLLBACK TO update_terrresource_pub;

Line: 2985


         ROLLBACK TO update_terrresource_pub;

Line: 2991


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

Line: 3001


   END update_terrresource;