DBA Data[Home] [Help]

APPS.PQH_FR_ASSIGNMENT_API dependencies on HR_API

Line 77: ,p_organization_id in number default hr_api.g_number

73: procedure update_affectation
74: (p_validate in boolean default false
75: ,p_datetrack_update_mode in varchar2
76: ,p_effective_date in date
77: ,p_organization_id in number default hr_api.g_number
78: ,p_position_id in number default hr_api.g_number
79: ,p_person_id in number
80: ,p_job_id in number default hr_api.g_number
81: ,p_supervisor_id in number default hr_api.g_number

Line 78: ,p_position_id in number default hr_api.g_number

74: (p_validate in boolean default false
75: ,p_datetrack_update_mode in varchar2
76: ,p_effective_date in date
77: ,p_organization_id in number default hr_api.g_number
78: ,p_position_id in number default hr_api.g_number
79: ,p_person_id in number
80: ,p_job_id in number default hr_api.g_number
81: ,p_supervisor_id in number default hr_api.g_number
82: ,p_assignment_number in varchar2 default hr_api.g_varchar2

Line 80: ,p_job_id in number default hr_api.g_number

76: ,p_effective_date in date
77: ,p_organization_id in number default hr_api.g_number
78: ,p_position_id in number default hr_api.g_number
79: ,p_person_id in number
80: ,p_job_id in number default hr_api.g_number
81: ,p_supervisor_id in number default hr_api.g_number
82: ,p_assignment_number in varchar2 default hr_api.g_varchar2
83: ,p_assignment_status_type_id in number default hr_api.g_number
84: ,p_identifier in varchar2 default hr_api.g_varchar2

Line 81: ,p_supervisor_id in number default hr_api.g_number

77: ,p_organization_id in number default hr_api.g_number
78: ,p_position_id in number default hr_api.g_number
79: ,p_person_id in number
80: ,p_job_id in number default hr_api.g_number
81: ,p_supervisor_id in number default hr_api.g_number
82: ,p_assignment_number in varchar2 default hr_api.g_varchar2
83: ,p_assignment_status_type_id in number default hr_api.g_number
84: ,p_identifier in varchar2 default hr_api.g_varchar2
85: ,p_affectation_type in varchar2 default hr_api.g_varchar2

Line 82: ,p_assignment_number in varchar2 default hr_api.g_varchar2

78: ,p_position_id in number default hr_api.g_number
79: ,p_person_id in number
80: ,p_job_id in number default hr_api.g_number
81: ,p_supervisor_id in number default hr_api.g_number
82: ,p_assignment_number in varchar2 default hr_api.g_varchar2
83: ,p_assignment_status_type_id in number default hr_api.g_number
84: ,p_identifier in varchar2 default hr_api.g_varchar2
85: ,p_affectation_type in varchar2 default hr_api.g_varchar2
86: ,p_percent_effected in varchar2 default hr_api.g_varchar2

Line 83: ,p_assignment_status_type_id in number default hr_api.g_number

79: ,p_person_id in number
80: ,p_job_id in number default hr_api.g_number
81: ,p_supervisor_id in number default hr_api.g_number
82: ,p_assignment_number in varchar2 default hr_api.g_varchar2
83: ,p_assignment_status_type_id in number default hr_api.g_number
84: ,p_identifier in varchar2 default hr_api.g_varchar2
85: ,p_affectation_type in varchar2 default hr_api.g_varchar2
86: ,p_percent_effected in varchar2 default hr_api.g_varchar2
87: ,p_primary_affectation in varchar2 default 'N'

Line 84: ,p_identifier in varchar2 default hr_api.g_varchar2

80: ,p_job_id in number default hr_api.g_number
81: ,p_supervisor_id in number default hr_api.g_number
82: ,p_assignment_number in varchar2 default hr_api.g_varchar2
83: ,p_assignment_status_type_id in number default hr_api.g_number
84: ,p_identifier in varchar2 default hr_api.g_varchar2
85: ,p_affectation_type in varchar2 default hr_api.g_varchar2
86: ,p_percent_effected in varchar2 default hr_api.g_varchar2
87: ,p_primary_affectation in varchar2 default 'N'
88: ,p_group_name out nocopy varchar2

Line 85: ,p_affectation_type in varchar2 default hr_api.g_varchar2

81: ,p_supervisor_id in number default hr_api.g_number
82: ,p_assignment_number in varchar2 default hr_api.g_varchar2
83: ,p_assignment_status_type_id in number default hr_api.g_number
84: ,p_identifier in varchar2 default hr_api.g_varchar2
85: ,p_affectation_type in varchar2 default hr_api.g_varchar2
86: ,p_percent_effected in varchar2 default hr_api.g_varchar2
87: ,p_primary_affectation in varchar2 default 'N'
88: ,p_group_name out nocopy varchar2
89:

Line 86: ,p_percent_effected in varchar2 default hr_api.g_varchar2

82: ,p_assignment_number in varchar2 default hr_api.g_varchar2
83: ,p_assignment_status_type_id in number default hr_api.g_number
84: ,p_identifier in varchar2 default hr_api.g_varchar2
85: ,p_affectation_type in varchar2 default hr_api.g_varchar2
86: ,p_percent_effected in varchar2 default hr_api.g_varchar2
87: ,p_primary_affectation in varchar2 default 'N'
88: ,p_group_name out nocopy varchar2
89:
90: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2

Line 90: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2

86: ,p_percent_effected in varchar2 default hr_api.g_varchar2
87: ,p_primary_affectation in varchar2 default 'N'
88: ,p_group_name out nocopy varchar2
89:
90: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
91:
92: ,p_assignment_id in number
93: ,p_soft_coding_keyflex_id out nocopy number
94: ,p_object_version_number in out nocopy number

Line 107: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2

103: ,p_datetrack_update_mode IN VARCHAR2
104: ,p_effective_date IN DATE
105: ,p_assignment_id IN NUMBER
106: ,p_establishment_id IN NUMBER
107: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_assignment_category IN VARCHAR2
109: ,p_reason_for_parttime IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_working_hours_share IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_contract_id IN NUMBER DEFAULT HR_API.g_number

Line 109: ,p_reason_for_parttime IN VARCHAR2 DEFAULT HR_API.g_varchar2

105: ,p_assignment_id IN NUMBER
106: ,p_establishment_id IN NUMBER
107: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_assignment_category IN VARCHAR2
109: ,p_reason_for_parttime IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_working_hours_share IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_contract_id IN NUMBER DEFAULT HR_API.g_number
112: ,p_change_reason IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_normal_hours IN NUMBER DEFAULT HR_API.g_number

Line 110: ,p_working_hours_share IN VARCHAR2 DEFAULT HR_API.g_varchar2

106: ,p_establishment_id IN NUMBER
107: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_assignment_category IN VARCHAR2
109: ,p_reason_for_parttime IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_working_hours_share IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_contract_id IN NUMBER DEFAULT HR_API.g_number
112: ,p_change_reason IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_normal_hours IN NUMBER DEFAULT HR_API.g_number
114: ,p_frequency IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 111: ,p_contract_id IN NUMBER DEFAULT HR_API.g_number

107: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_assignment_category IN VARCHAR2
109: ,p_reason_for_parttime IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_working_hours_share IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_contract_id IN NUMBER DEFAULT HR_API.g_number
112: ,p_change_reason IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_normal_hours IN NUMBER DEFAULT HR_API.g_number
114: ,p_frequency IN VARCHAR2 DEFAULT HR_API.g_varchar2
115: ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER

Line 112: ,p_change_reason IN VARCHAR2 DEFAULT HR_API.g_varchar2

108: ,p_assignment_category IN VARCHAR2
109: ,p_reason_for_parttime IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_working_hours_share IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_contract_id IN NUMBER DEFAULT HR_API.g_number
112: ,p_change_reason IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_normal_hours IN NUMBER DEFAULT HR_API.g_number
114: ,p_frequency IN VARCHAR2 DEFAULT HR_API.g_varchar2
115: ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
116: ,p_object_version_number IN OUT NOCOPY NUMBER

Line 113: ,p_normal_hours IN NUMBER DEFAULT HR_API.g_number

109: ,p_reason_for_parttime IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_working_hours_share IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_contract_id IN NUMBER DEFAULT HR_API.g_number
112: ,p_change_reason IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_normal_hours IN NUMBER DEFAULT HR_API.g_number
114: ,p_frequency IN VARCHAR2 DEFAULT HR_API.g_varchar2
115: ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
116: ,p_object_version_number IN OUT NOCOPY NUMBER
117: ,p_effective_start_date OUT NOCOPY DATE

Line 114: ,p_frequency IN VARCHAR2 DEFAULT HR_API.g_varchar2

110: ,p_working_hours_share IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_contract_id IN NUMBER DEFAULT HR_API.g_number
112: ,p_change_reason IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_normal_hours IN NUMBER DEFAULT HR_API.g_number
114: ,p_frequency IN VARCHAR2 DEFAULT HR_API.g_varchar2
115: ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
116: ,p_object_version_number IN OUT NOCOPY NUMBER
117: ,p_effective_start_date OUT NOCOPY DATE
118: ,p_effective_end_date OUT NOCOPY DATE