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

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

Line: 63


   PROCEDURE insert_row
   (
      p_api_version           IN  NUMBER
     ,p_init_msg_list         IN  VARCHAR2 := fnd_api.g_false
     ,p_commit                IN  VARCHAR2 := fnd_api.g_false
     ,p_validation_level      IN  NUMBER   := fnd_api.g_valid_level_full
     ,p_object_type           IN  NUMBER
     ,p_object_id             IN  NUMBER
     ,p_organization_id       IN  NUMBER
     ,p_owning_department_id  IN  NUMBER   := NULL
     ,p_accounting_class_code IN  VARCHAR2 := NULL
     ,p_area_id               IN  NUMBER   := NULL
     ,p_activity_cause_code   IN  VARCHAR2 := NULL
     ,p_activity_type_code    IN  VARCHAR2 := NULL
     ,p_activity_source_code  IN  VARCHAR2 := NULL
     ,p_shutdown_type_code    IN  VARCHAR2 := NULL
     ,p_tagging_required_flag IN  VARCHAR2 := NULL
     ,x_return_status         OUT NOCOPY VARCHAR2
     ,x_msg_count             OUT NOCOPY NUMBER
     ,x_msg_data              OUT NOCOPY VARCHAR2
   ) IS

     l_api_name       CONSTANT VARCHAR2(30) := 'insert_row';

Line: 117


        INSERT INTO eam_org_maint_defaults
        (
           object_type
          ,object_id
          ,organization_id
          ,owning_department_id
          ,accounting_class_code
          ,area_id
          ,activity_cause_code
          ,activity_type_code
          ,activity_source_code
          ,shutdown_type_code
          ,tagging_required_flag
          ,created_by
          ,creation_date
          ,last_updated_by
          ,last_update_date
          ,last_update_login
        )
        VALUES
        (
           p_object_type
          ,p_object_id
          ,p_organization_id
          ,p_owning_department_id
          ,p_accounting_class_code
          ,p_area_id
          ,p_activity_cause_code
          ,p_activity_type_code
          ,p_activity_source_code
          ,p_shutdown_type_code
          ,p_tagging_required_flag
          ,fnd_global.user_id
          ,sysdate
          ,fnd_global.user_id
          ,sysdate
          ,fnd_global.login_id
        );

Line: 192


   END insert_row;

Line: 195


   PROCEDURE update_row
   (
      p_api_version           IN  NUMBER
     ,p_init_msg_list         IN  VARCHAR2 := fnd_api.g_false
     ,p_commit                IN  VARCHAR2 := fnd_api.g_false
     ,p_validation_level      IN  NUMBER   := fnd_api.g_valid_level_full
     ,p_object_type           IN  NUMBER
     ,p_object_id             IN  NUMBER
     ,p_organization_id       IN  NUMBER
     ,p_owning_department_id  IN  NUMBER   := NULL
     ,p_accounting_class_code IN  VARCHAR2 := NULL
     ,p_area_id               IN  NUMBER   := NULL
     ,p_activity_cause_code   IN  VARCHAR2 := NULL
     ,p_activity_type_code    IN  VARCHAR2 := NULL
     ,p_activity_source_code  IN  VARCHAR2 := NULL
     ,p_shutdown_type_code    IN  VARCHAR2 := NULL
     ,p_tagging_required_flag IN  VARCHAR2 := NULL
     ,x_return_status         OUT NOCOPY VARCHAR2
     ,x_msg_count             OUT NOCOPY NUMBER
     ,x_msg_data              OUT NOCOPY VARCHAR2
   ) IS

     l_api_name       CONSTANT VARCHAR2(30) := 'update_row';

Line: 249


        UPDATE eam_org_maint_defaults SET
           owning_department_id   =   decode(p_owning_department_id, fnd_api.g_miss_num, null, null, owning_department_id, p_owning_department_id)
          ,accounting_class_code  =   decode(p_accounting_class_code, fnd_api.g_miss_char, null, null, accounting_class_code, p_accounting_class_code)
          ,area_id                =   decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)
          ,activity_cause_code    =   decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)
          ,activity_type_code     =   decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
          ,activity_source_code   =   decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
          ,shutdown_type_code     =   decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
          ,tagging_required_flag  =   decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)
          ,created_by             =   fnd_global.user_id
          ,creation_date          =   sysdate
          ,last_updated_by        =   fnd_global.user_id
          ,last_update_date       =   sysdate
          ,last_update_login      =   fnd_global.login_id
        WHERE object_type = p_object_type AND object_id = p_object_id
          AND organization_id = p_organization_id;

Line: 302


   END update_row;

Line: 306


   PROCEDURE update_insert_row
   (
      p_api_version           IN  NUMBER
     ,p_init_msg_list         IN  VARCHAR2 := fnd_api.g_false
     ,p_commit                IN  VARCHAR2 := fnd_api.g_false
     ,p_validation_level      IN  NUMBER   := fnd_api.g_valid_level_full
     ,p_object_type           IN  NUMBER
     ,p_object_id             IN  NUMBER
     ,p_organization_id       IN  NUMBER
     ,p_owning_department_id  IN  NUMBER   := NULL
     ,p_accounting_class_code IN  VARCHAR2 := NULL
     ,p_area_id               IN  NUMBER   := NULL
     ,p_activity_cause_code   IN  VARCHAR2 := NULL
     ,p_activity_type_code    IN  VARCHAR2 := NULL
     ,p_activity_source_code  IN  VARCHAR2 := NULL
     ,p_shutdown_type_code    IN  VARCHAR2 := NULL
     ,p_tagging_required_flag IN  VARCHAR2 := NULL
     ,x_return_status         OUT NOCOPY VARCHAR2
     ,x_msg_count             OUT NOCOPY NUMBER
     ,x_msg_data              OUT NOCOPY VARCHAR2
   ) IS

     l_api_name       CONSTANT VARCHAR2(30) := 'update_insert_row';

Line: 358


     SELECT count(*) INTO l_count
       FROM eam_org_maint_defaults
      WHERE object_type = p_object_type AND object_id = p_object_id
        AND organization_id = p_organization_id;

Line: 364


        insert_row
        (
	  p_api_version           => 1.0
	 ,p_object_type           => p_object_type
	 ,p_object_id             => p_object_id
	 ,p_organization_id       => p_organization_id
	 ,p_owning_department_id  => from_fnd_std_num(p_owning_department_id)
	 ,p_accounting_class_code => from_fnd_std_char(p_accounting_class_code)
	 ,p_area_id               => from_fnd_std_num(p_area_id)
	 ,p_activity_cause_code   => from_fnd_std_char(p_activity_cause_code)
	 ,p_activity_type_code    => from_fnd_std_char(p_activity_type_code)
	 ,p_activity_source_code  => from_fnd_std_char(p_activity_source_code)
	 ,p_shutdown_type_code    => from_fnd_std_char(p_shutdown_type_code)
	 ,p_tagging_required_flag => from_fnd_std_char(p_tagging_required_flag)
	 ,x_return_status         => x_return_status
	 ,x_msg_count             => x_msg_count
	 ,x_msg_data              => x_msg_data
        );

Line: 383


        update_row
        (
	  p_api_version           => 1.0
	 ,p_object_type           => p_object_type
	 ,p_object_id             => p_object_id
	 ,p_organization_id       => p_organization_id
	 ,p_owning_department_id  => p_owning_department_id
	 ,p_accounting_class_code => p_accounting_class_code
	 ,p_area_id               => p_area_id
	 ,p_activity_cause_code   => p_activity_cause_code
	 ,p_activity_type_code    => p_activity_type_code
	 ,p_activity_source_code  => p_activity_source_code
	 ,p_shutdown_type_code    => p_shutdown_type_code
	 ,p_tagging_required_flag => p_tagging_required_flag
	 ,x_return_status         => x_return_status
	 ,x_msg_count             => x_msg_count
	 ,x_msg_data              => x_msg_data
        );

Line: 436


   END update_insert_row;