DBA Data[Home] [Help]

APPS.WPS_GANTT_UTILITIES SQL Statements

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

Line: 10

   summary before the insertion.
*/

PROCEDURE Populate_Bucketed_Res_Load
                       (p_group_id          IN  NUMBER,
                        p_organization_id   IN  NUMBER,
                        p_department_id     IN  NUMBER,
                        p_resource_id       IN  NUMBER,
                        p_bucket_size       IN  NUMBER DEFAULT DAILY_BUCKET,
                        p_date_from         IN  DATE,
                        p_date_to           IN  DATE,
                        p_userid            IN  NUMBER,
                        p_applicationid     IN  NUMBER,
                        p_errnum            OUT NOCOPY NUMBER,
                        p_errmesg           OUT NOCOPY VARCHAR2 )
IS
Begin

   /* This is a very simple wrapper routine provided
      for the Gantt Chart */
  Wip_Sfcb_Utilities.Populate_Resource_Load (
                        p_group_id => p_group_id,
                        p_organization_id => p_organization_id,
                        p_date_from => p_date_from,
                        p_date_to => p_date_to,
                        p_department_id => p_department_id,
                        p_resource_id => p_resource_id,
                        p_userid => p_userid,
                        p_applicationid => p_applicationid,
                        p_errnum  => p_errnum,
                        p_errmesg  => p_errmesg );