DBA Data[Home] [Help]

APPS.HR_PL_ASSIGNMENT_API SQL Statements

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

Line: 573

    SELECT  NULL
    FROM    per_assignments_f paf,
            per_business_groups pbg
    WHERE   paf.person_id = p_person_id
    AND     l_effective_date BETWEEN paf.effective_start_date AND     paf.effective_end_date
    AND     pbg.business_group_id = paf.business_group_id
    AND     pbg.legislation_code = 'PL';
Line: 777

procedure update_pl_emp_asg
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_datetrack_update_mode        in     varchar2
  ,p_assignment_id                in     number
  ,p_object_version_number        in out nocopy number
  ,p_supervisor_id                in     number   default hr_api.g_number
  ,p_assignment_number            in     varchar2 default hr_api.g_varchar2
  ,p_change_reason                in     varchar2 default hr_api.g_varchar2
  ,p_assignment_status_type_id    in     number   default hr_api.g_number
  ,p_comments                     in     varchar2 default hr_api.g_varchar2
  ,p_date_probation_end           in     date     default hr_api.g_date
  ,p_default_code_comb_id         in     number   default hr_api.g_number
  ,p_frequency                    in     varchar2 default hr_api.g_varchar2
  ,p_internal_address_line        in     varchar2 default hr_api.g_varchar2
  ,p_manager_flag                 in     varchar2 default hr_api.g_varchar2
  ,p_normal_hours                 in     number   default hr_api.g_number
  ,p_perf_review_period           in     number   default hr_api.g_number
  ,p_perf_review_period_frequency in     varchar2 default hr_api.g_varchar2
  ,p_probation_period             in     number   default hr_api.g_number
  ,p_probation_unit               in     varchar2 default hr_api.g_varchar2
  ,p_sal_review_period            in     number   default hr_api.g_number
  ,p_sal_review_period_frequency  in     varchar2 default hr_api.g_varchar2
  ,p_set_of_books_id              in     number   default hr_api.g_number
  ,p_source_type                  in     varchar2 default hr_api.g_varchar2
  ,p_time_normal_finish           in     varchar2 default hr_api.g_varchar2
  ,p_time_normal_start            in     varchar2 default hr_api.g_varchar2
  ,p_bargaining_unit_code         in     varchar2 default hr_api.g_varchar2
  ,p_labour_union_member_flag     in     varchar2 default hr_api.g_varchar2
  ,p_hourly_salaried_code         in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute_category       in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute1               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute2               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute3               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute4               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute5               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute6               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute7               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute8               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute9               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute10              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute11              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute12              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute13              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute14              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute15              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute16              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute17              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute18              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute19              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute20              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute21              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute22              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute23              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute24              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute25              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute26              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute27              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute28              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute29              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute30              in     varchar2 default hr_api.g_varchar2
  ,p_title                        in     varchar2 default hr_api.g_varchar2
  ,p_segment1                     in     varchar2 default hr_api.g_varchar2
  ,p_legal_employer               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_concat_segments              in     varchar2 default hr_api.g_varchar2
  ,p_contract_id                  in     number default hr_api.g_number
  ,p_establishment_id             in     number default hr_api.g_number
  ,p_collective_agreement_id      in     number default hr_api.g_number
  ,p_cagr_id_flex_num             in     number default hr_api.g_number
  ,p_cag_segment1                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment2                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment3                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment4                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment5                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment6                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment7                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment8                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment9                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment10                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment11                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment12                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment13                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment14                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment15                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment16                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment17                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment18                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment19                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment20                in     varchar2 default hr_api.g_varchar2
  ,p_notice_period		  in     number   default hr_api.g_number
  ,p_notice_period_uom	      	  in     varchar2 default hr_api.g_varchar2
  ,p_employee_category	          in     varchar2 default hr_api.g_varchar2
  ,p_work_at_home		  in     varchar2 default hr_api.g_varchar2
  ,p_job_post_source_name	  in     varchar2 default hr_api.g_varchar2
  ,p_supervisor_assignment_id     in     number   default hr_api.g_number
  ,p_cagr_grade_def_id            in out nocopy number
  ,p_cagr_concatenated_segments      out nocopy varchar2
  ,p_concatenated_segments           out nocopy varchar2
  ,p_soft_coding_keyflex_id       in out nocopy number
  ,p_comment_id                      out nocopy number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_no_managers_warning             out nocopy boolean
  ,p_other_manager_warning           out nocopy boolean
  ,p_hourly_salaried_warning         out nocopy boolean
  ,p_gsp_post_process_warning        out nocopy varchar2
  )is
 --
    -- Declare cursors AND local variables
    --
    l_proc                       VARCHAR2(72) := g_package||'update_pl_emp_asg OLD';
Line: 953

hr_assignment_api.update_emp_asg

*/
hr_pl_assignment_api.update_pl_emp_asg
(  p_validate                     =>p_validate
  ,p_effective_date               =>p_effective_date
  ,p_datetrack_update_mode        =>p_datetrack_update_mode
  ,p_assignment_id                =>p_assignment_id
  ,p_object_version_number        =>p_object_version_number
  ,p_supervisor_id                =>p_supervisor_id
  ,p_assignment_number            =>p_assignment_number
  ,p_change_reason                =>p_change_reason
  ,p_assignment_status_type_id    =>p_assignment_status_type_id
  ,p_comments                     =>p_comments
  ,p_date_probation_end           =>p_date_probation_end
  ,p_default_code_comb_id         =>p_default_code_comb_id
  ,p_frequency                    =>p_frequency
  ,p_internal_address_line        =>p_internal_address_line
  ,p_manager_flag                 =>p_manager_flag
  ,p_normal_hours                 =>p_normal_hours
  ,p_perf_review_period           =>p_perf_review_period
  ,p_perf_review_period_frequency =>p_perf_review_period_frequency
  ,p_probation_period             =>p_probation_period
  ,p_probation_unit               =>p_probation_unit
  ,p_sal_review_period            =>p_sal_review_period
  ,p_sal_review_period_frequency  =>p_sal_review_period_frequency
  ,p_set_of_books_id              =>p_set_of_books_id
  ,p_source_type                  =>p_source_type
  ,p_time_normal_finish           =>p_time_normal_finish
  ,p_time_normal_start            =>p_time_normal_start
  ,p_bargaining_unit_code         =>p_bargaining_unit_code
  ,p_labour_union_member_flag     =>p_labour_union_member_flag
  ,p_hourly_salaried_code         =>p_hourly_salaried_code
  ,p_ass_attribute_category       =>p_ass_attribute_category
  ,p_ass_attribute1               =>p_ass_attribute1
  ,p_ass_attribute2               =>p_ass_attribute2
  ,p_ass_attribute3               =>p_ass_attribute3
  ,p_ass_attribute4               =>p_ass_attribute4
  ,p_ass_attribute5               =>p_ass_attribute5
  ,p_ass_attribute6               =>p_ass_attribute6
  ,p_ass_attribute7               =>p_ass_attribute7
  ,p_ass_attribute8               =>p_ass_attribute8
  ,p_ass_attribute9               =>p_ass_attribute9
  ,p_ass_attribute10              =>p_ass_attribute10
  ,p_ass_attribute11              =>p_ass_attribute11
  ,p_ass_attribute12              =>p_ass_attribute12
  ,p_ass_attribute13              =>p_ass_attribute13
  ,p_ass_attribute14              =>p_ass_attribute14
  ,p_ass_attribute15              =>p_ass_attribute15
  ,p_ass_attribute16              =>p_ass_attribute16
  ,p_ass_attribute17              =>p_ass_attribute17
  ,p_ass_attribute18              =>p_ass_attribute18
  ,p_ass_attribute19              =>p_ass_attribute19
  ,p_ass_attribute20              =>p_ass_attribute20
  ,p_ass_attribute21              =>p_ass_attribute21
  ,p_ass_attribute22              =>p_ass_attribute22
  ,p_ass_attribute23              =>p_ass_attribute23
  ,p_ass_attribute24              =>p_ass_attribute24
  ,p_ass_attribute25              =>p_ass_attribute25
  ,p_ass_attribute26              =>p_ass_attribute26
  ,p_ass_attribute27              =>p_ass_attribute27
  ,p_ass_attribute28              =>p_ass_attribute28
  ,p_ass_attribute29              =>p_ass_attribute29
  ,p_ass_attribute30              =>p_ass_attribute30
  ,p_title                        =>p_title
  ,p_contract_category            =>p_segment3
  ,p_contract_type                =>p_segment4
  ,p_contract_number              =>p_segment5
  ,p_change_of_contract_reason    =>p_segment6
  ,p_job                          =>p_segment7
  ,p_work_in_special_condition    =>p_segment8
  ,p_end_of_contract_addl_details =>p_segment9
  ,p_contract_start_date          =>p_segment11
  ,p_planned_valid_to_date       =>p_segment12
  ,p_contract_type_change_date    =>p_segment13
  ,p_date_contract_signed         =>p_segment14
  ,p_notice_period_date           =>p_segment15
  ,p_notice_period_end_date       =>p_segment16
  ,p_concat_segments              =>p_concat_segments
  ,p_contract_id                  =>p_contract_id
  ,p_establishment_id             =>p_establishment_id
  ,p_collective_agreement_id      =>p_collective_agreement_id
  ,p_cagr_id_flex_num             =>p_cagr_id_flex_num
  ,p_cag_segment1                 =>p_cag_segment1
  ,p_cag_segment2                 =>p_cag_segment2
  ,p_cag_segment3                 =>p_cag_segment3
  ,p_cag_segment4                 =>p_cag_segment4
  ,p_cag_segment5                 =>p_cag_segment5
  ,p_cag_segment6                 =>p_cag_segment6
  ,p_cag_segment7                 =>p_cag_segment7
  ,p_cag_segment8                 =>p_cag_segment8
  ,p_cag_segment9                 =>p_cag_segment9
  ,p_cag_segment10                =>p_cag_segment10
  ,p_cag_segment11                =>p_cag_segment11
  ,p_cag_segment12                =>p_cag_segment12
  ,p_cag_segment13                =>p_cag_segment13
  ,p_cag_segment14                =>p_cag_segment14
  ,p_cag_segment15                =>p_cag_segment15
  ,p_cag_segment16                =>p_cag_segment16
  ,p_cag_segment17                =>p_cag_segment17
  ,p_cag_segment18                =>p_cag_segment18
  ,p_cag_segment19                =>p_cag_segment19
  ,p_cag_segment20                =>p_cag_segment20
  ,p_notice_period		          =>p_notice_period
  ,p_notice_period_uom	      	  =>p_notice_period_uom
  ,p_employee_category	          =>p_employee_category
  ,p_work_at_home		          =>p_work_at_home
  ,p_job_post_source_name	      =>p_job_post_source_name
  ,p_supervisor_assignment_id     =>p_supervisor_assignment_id
  ,p_cagr_grade_def_id            =>p_cagr_grade_def_id
  ,p_cagr_concatenated_segments   =>p_cagr_concatenated_segments
  ,p_concatenated_segments        =>p_concatenated_segments
  ,p_soft_coding_keyflex_id       =>p_soft_coding_keyflex_id
  ,p_comment_id                   =>p_comment_id
  ,p_effective_start_date         =>p_effective_start_date
  ,p_effective_end_date           =>p_effective_end_date
  ,p_no_managers_warning          =>p_no_managers_warning
  ,p_other_manager_warning        =>p_other_manager_warning
  ,p_hourly_salaried_warning      =>p_hourly_salaried_warning
  ,p_gsp_post_process_warning     =>p_gsp_post_process_warning
  );
Line: 1076

  END update_pl_emp_asg;
Line: 1083

procedure update_pl_emp_asg
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_datetrack_update_mode        in     varchar2
  ,p_assignment_id                in     number
  ,p_object_version_number        in out nocopy number
  ,p_supervisor_id                in     number   default hr_api.g_number
  ,p_assignment_number            in     varchar2 default hr_api.g_varchar2
  ,p_change_reason                in     varchar2 default hr_api.g_varchar2
  ,p_assignment_status_type_id    in     number   default hr_api.g_number
  ,p_comments                     in     varchar2 default hr_api.g_varchar2
  ,p_date_probation_end           in     date     default hr_api.g_date
  ,p_default_code_comb_id         in     number   default hr_api.g_number
  ,p_frequency                    in     varchar2 default hr_api.g_varchar2
  ,p_internal_address_line        in     varchar2 default hr_api.g_varchar2
  ,p_manager_flag                 in     varchar2 default hr_api.g_varchar2
  ,p_normal_hours                 in     number   default hr_api.g_number
  ,p_perf_review_period           in     number   default hr_api.g_number
  ,p_perf_review_period_frequency in     varchar2 default hr_api.g_varchar2
  ,p_probation_period             in     number   default hr_api.g_number
  ,p_probation_unit               in     varchar2 default hr_api.g_varchar2
  ,p_sal_review_period            in     number   default hr_api.g_number
  ,p_sal_review_period_frequency  in     varchar2 default hr_api.g_varchar2
  ,p_set_of_books_id              in     number   default hr_api.g_number
  ,p_source_type                  in     varchar2 default hr_api.g_varchar2
  ,p_time_normal_finish           in     varchar2 default hr_api.g_varchar2
  ,p_time_normal_start            in     varchar2 default hr_api.g_varchar2
  ,p_bargaining_unit_code         in     varchar2 default hr_api.g_varchar2
  ,p_labour_union_member_flag     in     varchar2 default hr_api.g_varchar2
  ,p_hourly_salaried_code         in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute_category       in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute1               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute2               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute3               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute4               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute5               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute6               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute7               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute8               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute9               in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute10              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute11              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute12              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute13              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute14              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute15              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute16              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute17              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute18              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute19              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute20              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute21              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute22              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute23              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute24              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute25              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute26              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute27              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute28              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute29              in     varchar2 default hr_api.g_varchar2
  ,p_ass_attribute30              in     varchar2 default hr_api.g_varchar2
  ,p_title                        in     varchar2 default hr_api.g_varchar2
  ,p_contract_category            in     varchar2 default hr_api.g_varchar2
  ,p_contract_type                in     varchar2 default hr_api.g_varchar2
  ,p_contract_number              in     varchar2 default hr_api.g_varchar2
  ,p_change_of_contract_reason    in     varchar2 default hr_api.g_varchar2
  ,p_job                          in     varchar2 default hr_api.g_varchar2
  ,p_work_in_special_condition    in     varchar2 default hr_api.g_varchar2
  ,p_end_of_contract_addl_details in     varchar2 default hr_api.g_varchar2
  ,p_contract_start_date          in     varchar2 default hr_api.g_varchar2
  ,p_planned_valid_to_date        in     varchar2 default hr_api.g_varchar2
  ,p_contract_type_change_date    in     varchar2 default hr_api.g_varchar2
  ,p_date_contract_signed         in     varchar2 default hr_api.g_varchar2
  ,p_notice_period_date           in     varchar2 default hr_api.g_varchar2
  ,p_notice_period_end_date       in     varchar2 default hr_api.g_varchar2
  ,p_concat_segments              in     varchar2 default hr_api.g_varchar2
  ,p_contract_id                  in     number default hr_api.g_number
  ,p_establishment_id             in     number default hr_api.g_number
  ,p_collective_agreement_id      in     number default hr_api.g_number
  ,p_cagr_id_flex_num             in     number default hr_api.g_number
  ,p_cag_segment1                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment2                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment3                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment4                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment5                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment6                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment7                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment8                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment9                 in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment10                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment11                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment12                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment13                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment14                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment15                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment16                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment17                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment18                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment19                in     varchar2 default hr_api.g_varchar2
  ,p_cag_segment20                in     varchar2 default hr_api.g_varchar2
  ,p_notice_period		  in     number   default hr_api.g_number
  ,p_notice_period_uom	      	  in     varchar2 default hr_api.g_varchar2
  ,p_employee_category	          in     varchar2 default hr_api.g_varchar2
  ,p_work_at_home		  in     varchar2 default hr_api.g_varchar2
  ,p_job_post_source_name	  in     varchar2 default hr_api.g_varchar2
  ,p_supervisor_assignment_id     in     number   default hr_api.g_number
  ,p_cagr_grade_def_id            in out nocopy number
  ,p_cagr_concatenated_segments      out nocopy varchar2
  ,p_concatenated_segments           out nocopy varchar2
  ,p_soft_coding_keyflex_id       in out nocopy number
  ,p_comment_id                      out nocopy number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_no_managers_warning             out nocopy boolean
  ,p_other_manager_warning           out nocopy boolean
  ,p_hourly_salaried_warning         out nocopy boolean
  ,p_gsp_post_process_warning        out nocopy varchar2
  )is
 --
    -- Declare cursors AND local variables
    --
    l_proc                       VARCHAR2(72) := g_package||'update_pl_emp_asg';
Line: 1216

      SELECT    bgp.legislation_code
      FROM      per_assignments_f asg,
                per_business_groups bgp
      WHERE     asg.business_group_id = bgp.business_group_id
      AND       asg.assignment_id     = c_assignment_id
      AND       c_effective_date BETWEEN effective_start_date AND effective_end_date;
Line: 1260

hr_assignment_api.update_emp_asg
(
   p_validate                         =>          p_validate
  ,p_effective_date                   =>          p_effective_date
  ,p_datetrack_update_mode            =>          p_datetrack_update_mode
  ,p_assignment_id                    =>          p_assignment_id
  ,p_object_version_number             =>         p_object_version_number
  ,p_supervisor_id                     =>         p_supervisor_id
  ,p_assignment_number                 =>         p_assignment_number
  ,p_change_reason                     =>         p_change_reason
  ,p_assignment_status_type_id         =>         p_assignment_status_type_id
  ,p_comments                          =>         p_comments
  ,p_date_probation_end                =>         p_date_probation_end
  ,p_default_code_comb_id              =>         p_default_code_comb_id
  ,p_frequency                         =>         p_frequency
  ,p_internal_address_line             =>         p_internal_address_line
  ,p_manager_flag                      =>         p_manager_flag
  ,p_normal_hours                      =>         p_normal_hours
  ,p_perf_review_period                =>         p_perf_review_period
  ,p_perf_review_period_frequency      =>         p_perf_review_period_frequency
  ,p_probation_period                  =>         p_probation_period
  ,p_probation_unit                    =>         p_probation_unit
  ,p_sal_review_period                 =>         p_sal_review_period
  ,p_sal_review_period_frequency       =>         p_sal_review_period_frequency
  ,p_set_of_books_id                   =>         p_set_of_books_id
  ,p_source_type                       =>         p_source_type
  ,p_time_normal_finish                =>         p_time_normal_finish
  ,p_time_normal_start                 =>         p_time_normal_start
  ,p_bargaining_unit_code              =>         p_bargaining_unit_code
  ,p_labour_union_member_flag          =>         p_labour_union_member_flag
  ,p_hourly_salaried_code              =>         p_hourly_salaried_code
  ,p_ass_attribute_category            =>         p_ass_attribute_category
  ,p_ass_attribute1                    =>         p_ass_attribute1
  ,p_ass_attribute2                    =>         p_ass_attribute2
  ,p_ass_attribute3                    =>         p_ass_attribute3
  ,p_ass_attribute4                    =>         p_ass_attribute4
  ,p_ass_attribute5                    =>         p_ass_attribute5
  ,p_ass_attribute6                    =>         p_ass_attribute6
  ,p_ass_attribute7                    =>         p_ass_attribute7
  ,p_ass_attribute8                    =>         p_ass_attribute8
  ,p_ass_attribute9                    =>         p_ass_attribute9
  ,p_ass_attribute10                   =>         p_ass_attribute10
  ,p_ass_attribute11                   =>         p_ass_attribute11
  ,p_ass_attribute12                   =>         p_ass_attribute12
  ,p_ass_attribute13                   =>         p_ass_attribute13
  ,p_ass_attribute14                   =>         p_ass_attribute14
  ,p_ass_attribute15                   =>         p_ass_attribute15
  ,p_ass_attribute16                   =>         p_ass_attribute16
  ,p_ass_attribute17                   =>         p_ass_attribute17
  ,p_ass_attribute18                   =>         p_ass_attribute18
  ,p_ass_attribute19                   =>         p_ass_attribute19
  ,p_ass_attribute20                   =>         p_ass_attribute20
  ,p_ass_attribute21                   =>         p_ass_attribute21
  ,p_ass_attribute22                   =>         p_ass_attribute22
  ,p_ass_attribute23                   =>         p_ass_attribute23
  ,p_ass_attribute24                   =>         p_ass_attribute24
  ,p_ass_attribute25                   =>         p_ass_attribute25
  ,p_ass_attribute26                   =>         p_ass_attribute26
  ,p_ass_attribute27                   =>         p_ass_attribute27
  ,p_ass_attribute28                   =>         p_ass_attribute28
  ,p_ass_attribute29                   =>         p_ass_attribute29
  ,p_ass_attribute30                   =>         p_ass_attribute30
  ,p_title                             =>         p_title
  ,p_segment3                          =>         p_contract_category
  ,p_segment4                          =>         p_contract_type
  ,p_segment5                          =>         p_contract_number
  ,p_segment6                          =>         p_change_of_contract_reason
  ,p_segment7                          =>         p_job
  ,p_segment8                          =>         p_work_in_special_condition
  ,p_segment9                          =>         p_end_of_contract_addl_details
  ,p_segment11                         =>         p_contract_start_date
  ,p_segment12                         =>         p_planned_valid_to_date
  ,p_segment13                         =>         p_contract_type_change_date
  ,p_segment14                         =>         p_date_contract_signed
  ,p_segment15                         =>         p_notice_period_date
  ,p_segment16                         =>         p_notice_period_end_date
  ,p_concat_segments                   =>         p_concat_segments
  ,p_contract_id                       =>         p_contract_id
  ,p_establishment_id                  =>         p_establishment_id
  ,p_collective_agreement_id           =>         p_collective_agreement_id
  ,p_cagr_id_flex_num                  =>         p_cagr_id_flex_num
  ,p_cag_segment1                      =>         p_cag_segment1
  ,p_cag_segment2                      =>         p_cag_segment2
  ,p_cag_segment3                      =>         p_cag_segment3
  ,p_cag_segment4                      =>         p_cag_segment4
  ,p_cag_segment5                      =>         p_cag_segment5
  ,p_cag_segment6                      =>         p_cag_segment6
  ,p_cag_segment7                      =>         p_cag_segment7
  ,p_cag_segment8                      =>         p_cag_segment8
  ,p_cag_segment9                      =>         p_cag_segment9
  ,p_cag_segment10                     =>         p_cag_segment10
  ,p_cag_segment11                     =>         p_cag_segment11
  ,p_cag_segment12                     =>         p_cag_segment12
  ,p_cag_segment13                     =>         p_cag_segment13
  ,p_cag_segment14                     =>         p_cag_segment14
  ,p_cag_segment15                     =>         p_cag_segment15
  ,p_cag_segment16                     =>         p_cag_segment16
  ,p_cag_segment17                     =>         p_cag_segment17
  ,p_cag_segment18                     =>         p_cag_segment18
  ,p_cag_segment19                     =>         p_cag_segment19
  ,p_cag_segment20                     =>         p_cag_segment20
  ,p_notice_period		               =>         p_notice_period
  ,p_notice_period_uom	      	       =>         p_notice_period_uom
  ,p_employee_category	               =>         p_employee_category
  ,p_work_at_home		               =>    	 p_work_at_home
  ,p_job_post_source_name	           => 	 p_job_post_source_name
  ,p_supervisor_assignment_id          =>         p_supervisor_assignment_id
  ,p_cagr_grade_def_id                 =>         p_cagr_grade_def_id
  ,p_cagr_concatenated_segments        =>	 p_cagr_concatenated_segments
  ,p_concatenated_segments             =>         p_concatenated_segments
  ,p_soft_coding_keyflex_id            =>         p_soft_coding_keyflex_id
  ,p_comment_id                        =>         p_comment_id
  ,p_effective_start_date              =>         p_effective_start_date
  ,p_effective_end_date                =>         p_effective_end_date
  ,p_no_managers_warning               =>         p_no_managers_warning
  ,p_other_manager_warning             =>         p_other_manager_warning
  ,p_hourly_salaried_warning           =>         p_hourly_salaried_warning
  ,p_gsp_post_process_warning 	       =>         p_gsp_post_process_warning

      );
Line: 1382

  END update_pl_emp_asg;