[Home] [Help]
61: ,p_position_structure;
62: CLOSE cFlexStructures;
63: END get_flex_structures;
64: --
65: -- Calls hr_contract_api.update_contract in date-track CORRECTION mode for all records
66: -- matching supplied contract_id argument, (excluding that which matches the supplied object_version_number
67: -- if the exclude flag is set to 'Y'), passing only the required arguements plus current values for
68: -- user_status and user_status_date_change.
69: --
115: OPEN c_all_con;
116: FETCH c_all_con INTO l_con;
117: WHILE c_all_con%FOUND LOOP
118: -- for each record, set the doc_status and doc_status_change_date attributes via
119: -- a call to hr_contract_api.update_contract using CORRECTION dt mode.
120: --
121: l_object_version_number := l_con.object_version_number;
122: --
123: -- if we are at the current record (same ovn), then set flag indicating we
125: IF l_object_version_number = p_object_version_number THEN
126: l_get_current_ovn := TRUE;
127: END IF;
128: --
129: hr_contract_api.update_contract
130: (p_contract_id => l_con.contract_id
131: ,p_effective_start_date => l_effective_start_date
132: ,p_effective_end_date => l_effective_end_date
133: ,p_object_version_number => l_object_version_number
157: OPEN c_exc_con;
158: FETCH c_exc_con INTO l_con;
159: WHILE c_exc_con%FOUND LOOP
160: -- for each record, set the doc_status and doc_status_change_date attributes via
161: -- a call to hr_contract_api.update_contract using CORRECTION dt mode.
162: --
163: l_object_version_number := l_con.object_version_number;
164: --
165: hr_contract_api.update_contract
161: -- a call to hr_contract_api.update_contract using CORRECTION dt mode.
162: --
163: l_object_version_number := l_con.object_version_number;
164: --
165: hr_contract_api.update_contract
166: (p_contract_id => l_con.contract_id
167: ,p_effective_start_date => l_effective_start_date
168: ,p_effective_end_date => l_effective_end_date
169: ,p_object_version_number => l_object_version_number