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

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

Line: 345


/*Once the WF is approved then we have to call this to insert the data into actual table*/
PROCEDURE CREATE_DATA(
P_VALIDATE                  IN     BOOLEAN DEFAULT FALSE
,P_TRANSACTION_STEP_ID      IN     NUMBER
)
IS
  l_proc                             varchar2(100) := g_package||'CREATE_DATA';

Line: 529


PROCEDURE UPDATE_ASSG_COST(
          P_ITEM_TYPE                    IN VARCHAR2
         ,P_ITEM_KEY                     IN VARCHAR2
         ,P_ACTID                        IN NUMBER
         ,P_LOGIN_PERSON_ID              IN NUMBER
         ,P_UPDATE_MODE                  IN VARCHAR2 DEFAULT 'UPDATE'
         ,P_EFFECTIVE_DATE               IN DATE     DEFAULT SYSDATE
         ,P_ASSIGNMENT_ID                IN NUMBER
         ,P_COST_ALLOCATION_ID           IN NUMBER
         ,P_BUSINESS_GROUP_ID            IN NUMBER
         ,P_COST_ALLOCATION_KEYFLEX_ID   IN NUMBER
         ,P_OBJECT_VERSION_NUMBER        IN NUMBER
         ,P_PROPORTION                   IN NUMBER   default hr_api.g_number
         ,P_SEGMENT1                     IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT2                     IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT3                     IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT4                     IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT5                     IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT6                     IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT7                     IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT8                     IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT9                     IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT10                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT11                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT12                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT13                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT14                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT15                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT16                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT17                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT18                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT19                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT20                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT21                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT22                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT23                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT24                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT25                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT26                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT27                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT28                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT29                    IN VARCHAR2 default hr_api.g_varchar2
         ,P_SEGMENT30                    IN VARCHAR2 default hr_api.g_varchar2
	 ,P_CONCATENATED_SEGMENTS        IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
         ,P_EFFECTIVE_START_DATE         IN DATE     DEFAULT NULL
         ,P_EFFECTIVE_END_DATE           IN DATE     DEFAULT NULL
         ,P_TRANSACTION_ID               OUT NOCOPY    NUMBER
         ,P_TRANSACTION_STEP_ID          OUT NOCOPY    NUMBER
         ) as
    l_proc varchar2(100) := g_package||'UPDATE_ASSG_COST';

Line: 607


                     ,p_api_name              => g_package||'UPDATE_DATA'
                     ,p_transaction_step_id   => l_transaction_step_id
                     ,p_object_version_number => l_trs_object_version_number);

Line: 639


    l_transaction_table(l_count).param_name := 'P_UPDATE_MODE';

Line: 640


    l_transaction_table(l_count).param_value := P_UPDATE_MODE;

Line: 864


                ,p_api_name => g_package || 'UPDATE_DATA'
                ,p_transaction_data => l_transaction_table);

Line: 872


END UPDATE_ASSG_COST;

Line: 874


PROCEDURE UPDATE_DATA(
P_VALIDATE                  IN     BOOLEAN DEFAULT FALSE
,P_TRANSACTION_STEP_ID      IN     NUMBER
)
IS
  l_proc                             varchar2(100) := g_package||'UPDATE_DATA';

Line: 888


  l_update_datetrack_mode            VARCHAR2(20);

Line: 895


  SAVEPOINT UPDATE_DATA;

Line: 910


    l_update_datetrack_mode := hr_transaction_api.get_varchar2_value(
				  p_transaction_step_id => p_transaction_step_id,
				  p_name => 'P_UPDATE_MODE');

Line: 920


        hr_utility.set_location('Calling PAY_COST_ALLOCATION_API.UPDATE_COST_ALLOCATION', 50);

Line: 924


    PAY_COST_ALLOCATION_API.UPDATE_COST_ALLOCATION
    (p_validate                => p_validate
    ,p_effective_date          => l_effective_date
    ,p_datetrack_update_mode   => nvl(l_update_datetrack_mode,'UPDATE')
    ,p_cost_allocation_id      => hr_transaction_api.get_number_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_COST_ALLOCATION_ID')
    ,p_object_version_number   => l_object_version_number
    ,p_proportion              => hr_transaction_api.get_number_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_PROPORTION')/100
    ,p_segment1                => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT1')
    ,p_segment2                => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT2')
    ,p_segment3                => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT3')
    ,p_segment4                => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT4')
    ,p_segment5                => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT5')
    ,p_segment6                => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT6')
    ,p_segment7                => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT7')
    ,p_segment8                => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT8')
    ,p_segment9                => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT9')
    ,p_segment10               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT10')
    ,p_segment11               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT11')
    ,p_segment12               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT12')
    ,p_segment13               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT13')
    ,p_segment14               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT14')
    ,p_segment15               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT15')
    ,p_segment16               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT16')
    ,p_segment17               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT17')
    ,p_segment18               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT18')
    ,p_segment19               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT19')
    ,p_segment20               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT20')
    ,p_segment21               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT21')
    ,p_segment22               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT22')
    ,p_segment23               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT23')
    ,p_segment24               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT24')
    ,p_segment25               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT25')
    ,p_segment26               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT26')
    ,p_segment27               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT27')
    ,p_segment28               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT28')
    ,p_segment29               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT29')
    ,p_segment30               => hr_transaction_api.get_varchar2_value
                                  (p_transaction_step_id => p_transaction_step_id
                                  ,p_name => 'P_SEGMENT30')
    ,p_combination_name        => l_combination_name
    ,p_cost_allocation_keyflex_id => l_cost_allocation_keyflex_id
    ,p_effective_start_date    => l_effective_start_date
    ,p_effective_end_date      => l_effective_end_date);

Line: 1031


        hr_utility.set_location('After Calling PAY_COST_ALLOCATION_API.UPDATE_COST_ALLOCATION', 60);

Line: 1047


        ROLLBACK TO UPDATE_DATA;

Line: 1052


        ROLLBACK TO UPDATE_DATA;

Line: 1054


END UPDATE_DATA;

Line: 1056


PROCEDURE DELETE_ASSG_COST(
          P_ITEM_TYPE                    IN VARCHAR2
         ,P_ITEM_KEY                     IN VARCHAR2
         ,P_ACTID                        IN NUMBER
         ,P_LOGIN_PERSON_ID              IN NUMBER
         ,P_DELETE_MODE                  IN VARCHAR2 DEFAULT 'DELETE'
         ,P_EFFECTIVE_DATE               IN DATE
         ,P_ASSIGNMENT_ID                IN NUMBER
         ,P_BUSINESS_GROUP_ID            IN NUMBER
         ,P_COST_ALLOCATION_ID           IN NUMBER
         ,P_OBJECT_VERSION_NUMBER        IN NUMBER
	 ,P_CONCATENATED_SEGMENTS        IN VARCHAR2 DEFAULT NULL
         ,P_EFFECTIVE_START_DATE         IN DATE     DEFAULT NULL
         ,P_EFFECTIVE_END_DATE           IN DATE     DEFAULT NULL
         ,P_TRANSACTION_ID               OUT NOCOPY    NUMBER
         ,P_TRANSACTION_STEP_ID          OUT NOCOPY    NUMBER
         ) is
    l_proc varchar2(100) := g_package||'DELETE_ASSG_COST';

Line: 1103


                     ,p_api_name              => g_package||'DELETE_DATA'
                     ,p_transaction_step_id   => l_transaction_step_id
                     ,p_object_version_number => l_trs_object_version_number);

Line: 1137


    l_transaction_table(l_count).param_name := 'P_DELETE_MODE';

Line: 1138


    l_transaction_table(l_count).param_value := P_DELETE_MODE;

Line: 1196


                ,p_api_name => g_package || 'DELETE_DATA'
                ,p_transaction_data => l_transaction_table);

Line: 1201


END DELETE_ASSG_COST;

Line: 1203


PROCEDURE DELETE_DATA(
P_VALIDATE                  IN     BOOLEAN DEFAULT FALSE
,P_TRANSACTION_STEP_ID      IN     NUMBER
)
IS
  l_proc                             varchar2(100) := g_package||'DELETE_DATA';

Line: 1216


  l_datetrack_delete_mode            VARCHAR2(20);

Line: 1242


    l_datetrack_delete_mode := hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                 ,p_name => 'P_DELETE_MODE');

Line: 1246


    /*Now Call the API to delete the cost allocations.*/
    PAY_COST_ALLOCATION_API.DELETE_COST_ALLOCATION
    (p_validate                    => P_VALIDATE
    ,p_effective_date              => l_effective_date
    ,p_datetrack_delete_mode       => nvl(l_datetrack_delete_mode,'DELETE')
    ,p_cost_allocation_id          => hr_transaction_api.get_number_value
                                      (p_transaction_step_id => p_transaction_step_id
                                      ,p_name => 'P_COST_ALLOCATION_ID')
    ,p_object_version_number       => l_object_version_number
    ,p_effective_start_date        => l_effective_start_date
    ,p_effective_end_date          => l_effective_end_date);

Line: 1259


        hr_utility.set_location('After Calling PAY_COST_ALLOCATION_API.UPDATE_COST_ALLOCATION', 60);

Line: 1265


END DELETE_DATA;