110: Begin
111: for i in 1..l_count_eff_detail_id Loop
112:
113:
114: g_er_proposed_salary_amt(i) := hr_api.g_number;
115: g_er_proposed_effort_percent(i) := hr_api.g_number;
116: g_er_committed_cost_share(i) := hr_api.g_number;
117: g_er_value1(i) := hr_api.g_number;
118: g_er_value2(i) := hr_api.g_number;
111: for i in 1..l_count_eff_detail_id Loop
112:
113:
114: g_er_proposed_salary_amt(i) := hr_api.g_number;
115: g_er_proposed_effort_percent(i) := hr_api.g_number;
116: g_er_committed_cost_share(i) := hr_api.g_number;
117: g_er_value1(i) := hr_api.g_number;
118: g_er_value2(i) := hr_api.g_number;
119: g_er_value3(i) := hr_api.g_number;
112:
113:
114: g_er_proposed_salary_amt(i) := hr_api.g_number;
115: g_er_proposed_effort_percent(i) := hr_api.g_number;
116: g_er_committed_cost_share(i) := hr_api.g_number;
117: g_er_value1(i) := hr_api.g_number;
118: g_er_value2(i) := hr_api.g_number;
119: g_er_value3(i) := hr_api.g_number;
120: g_er_value4(i) := hr_api.g_number;
113:
114: g_er_proposed_salary_amt(i) := hr_api.g_number;
115: g_er_proposed_effort_percent(i) := hr_api.g_number;
116: g_er_committed_cost_share(i) := hr_api.g_number;
117: g_er_value1(i) := hr_api.g_number;
118: g_er_value2(i) := hr_api.g_number;
119: g_er_value3(i) := hr_api.g_number;
120: g_er_value4(i) := hr_api.g_number;
121: g_er_value5(i) := hr_api.g_number;
114: g_er_proposed_salary_amt(i) := hr_api.g_number;
115: g_er_proposed_effort_percent(i) := hr_api.g_number;
116: g_er_committed_cost_share(i) := hr_api.g_number;
117: g_er_value1(i) := hr_api.g_number;
118: g_er_value2(i) := hr_api.g_number;
119: g_er_value3(i) := hr_api.g_number;
120: g_er_value4(i) := hr_api.g_number;
121: g_er_value5(i) := hr_api.g_number;
122: g_er_value6(i) := hr_api.g_number;
115: g_er_proposed_effort_percent(i) := hr_api.g_number;
116: g_er_committed_cost_share(i) := hr_api.g_number;
117: g_er_value1(i) := hr_api.g_number;
118: g_er_value2(i) := hr_api.g_number;
119: g_er_value3(i) := hr_api.g_number;
120: g_er_value4(i) := hr_api.g_number;
121: g_er_value5(i) := hr_api.g_number;
122: g_er_value6(i) := hr_api.g_number;
123: g_er_value7(i) := hr_api.g_number;
116: g_er_committed_cost_share(i) := hr_api.g_number;
117: g_er_value1(i) := hr_api.g_number;
118: g_er_value2(i) := hr_api.g_number;
119: g_er_value3(i) := hr_api.g_number;
120: g_er_value4(i) := hr_api.g_number;
121: g_er_value5(i) := hr_api.g_number;
122: g_er_value6(i) := hr_api.g_number;
123: g_er_value7(i) := hr_api.g_number;
124: g_er_value8(i) := hr_api.g_number;
117: g_er_value1(i) := hr_api.g_number;
118: g_er_value2(i) := hr_api.g_number;
119: g_er_value3(i) := hr_api.g_number;
120: g_er_value4(i) := hr_api.g_number;
121: g_er_value5(i) := hr_api.g_number;
122: g_er_value6(i) := hr_api.g_number;
123: g_er_value7(i) := hr_api.g_number;
124: g_er_value8(i) := hr_api.g_number;
125: g_er_value9(i) := hr_api.g_number;
118: g_er_value2(i) := hr_api.g_number;
119: g_er_value3(i) := hr_api.g_number;
120: g_er_value4(i) := hr_api.g_number;
121: g_er_value5(i) := hr_api.g_number;
122: g_er_value6(i) := hr_api.g_number;
123: g_er_value7(i) := hr_api.g_number;
124: g_er_value8(i) := hr_api.g_number;
125: g_er_value9(i) := hr_api.g_number;
126: g_er_value10(i) := hr_api.g_number;
119: g_er_value3(i) := hr_api.g_number;
120: g_er_value4(i) := hr_api.g_number;
121: g_er_value5(i) := hr_api.g_number;
122: g_er_value6(i) := hr_api.g_number;
123: g_er_value7(i) := hr_api.g_number;
124: g_er_value8(i) := hr_api.g_number;
125: g_er_value9(i) := hr_api.g_number;
126: g_er_value10(i) := hr_api.g_number;
127: g_er_attribute1(i) := hr_api.g_varchar2;
120: g_er_value4(i) := hr_api.g_number;
121: g_er_value5(i) := hr_api.g_number;
122: g_er_value6(i) := hr_api.g_number;
123: g_er_value7(i) := hr_api.g_number;
124: g_er_value8(i) := hr_api.g_number;
125: g_er_value9(i) := hr_api.g_number;
126: g_er_value10(i) := hr_api.g_number;
127: g_er_attribute1(i) := hr_api.g_varchar2;
128: g_er_attribute2(i) := hr_api.g_varchar2;
121: g_er_value5(i) := hr_api.g_number;
122: g_er_value6(i) := hr_api.g_number;
123: g_er_value7(i) := hr_api.g_number;
124: g_er_value8(i) := hr_api.g_number;
125: g_er_value9(i) := hr_api.g_number;
126: g_er_value10(i) := hr_api.g_number;
127: g_er_attribute1(i) := hr_api.g_varchar2;
128: g_er_attribute2(i) := hr_api.g_varchar2;
129: g_er_attribute3(i) := hr_api.g_varchar2;
122: g_er_value6(i) := hr_api.g_number;
123: g_er_value7(i) := hr_api.g_number;
124: g_er_value8(i) := hr_api.g_number;
125: g_er_value9(i) := hr_api.g_number;
126: g_er_value10(i) := hr_api.g_number;
127: g_er_attribute1(i) := hr_api.g_varchar2;
128: g_er_attribute2(i) := hr_api.g_varchar2;
129: g_er_attribute3(i) := hr_api.g_varchar2;
130: g_er_attribute4(i) := hr_api.g_varchar2;
123: g_er_value7(i) := hr_api.g_number;
124: g_er_value8(i) := hr_api.g_number;
125: g_er_value9(i) := hr_api.g_number;
126: g_er_value10(i) := hr_api.g_number;
127: g_er_attribute1(i) := hr_api.g_varchar2;
128: g_er_attribute2(i) := hr_api.g_varchar2;
129: g_er_attribute3(i) := hr_api.g_varchar2;
130: g_er_attribute4(i) := hr_api.g_varchar2;
131: g_er_attribute5(i) := hr_api.g_varchar2;
124: g_er_value8(i) := hr_api.g_number;
125: g_er_value9(i) := hr_api.g_number;
126: g_er_value10(i) := hr_api.g_number;
127: g_er_attribute1(i) := hr_api.g_varchar2;
128: g_er_attribute2(i) := hr_api.g_varchar2;
129: g_er_attribute3(i) := hr_api.g_varchar2;
130: g_er_attribute4(i) := hr_api.g_varchar2;
131: g_er_attribute5(i) := hr_api.g_varchar2;
132: g_er_attribute6(i) := hr_api.g_varchar2;
125: g_er_value9(i) := hr_api.g_number;
126: g_er_value10(i) := hr_api.g_number;
127: g_er_attribute1(i) := hr_api.g_varchar2;
128: g_er_attribute2(i) := hr_api.g_varchar2;
129: g_er_attribute3(i) := hr_api.g_varchar2;
130: g_er_attribute4(i) := hr_api.g_varchar2;
131: g_er_attribute5(i) := hr_api.g_varchar2;
132: g_er_attribute6(i) := hr_api.g_varchar2;
133: g_er_attribute7(i) := hr_api.g_varchar2;
126: g_er_value10(i) := hr_api.g_number;
127: g_er_attribute1(i) := hr_api.g_varchar2;
128: g_er_attribute2(i) := hr_api.g_varchar2;
129: g_er_attribute3(i) := hr_api.g_varchar2;
130: g_er_attribute4(i) := hr_api.g_varchar2;
131: g_er_attribute5(i) := hr_api.g_varchar2;
132: g_er_attribute6(i) := hr_api.g_varchar2;
133: g_er_attribute7(i) := hr_api.g_varchar2;
134: g_er_attribute8(i) := hr_api.g_varchar2;
127: g_er_attribute1(i) := hr_api.g_varchar2;
128: g_er_attribute2(i) := hr_api.g_varchar2;
129: g_er_attribute3(i) := hr_api.g_varchar2;
130: g_er_attribute4(i) := hr_api.g_varchar2;
131: g_er_attribute5(i) := hr_api.g_varchar2;
132: g_er_attribute6(i) := hr_api.g_varchar2;
133: g_er_attribute7(i) := hr_api.g_varchar2;
134: g_er_attribute8(i) := hr_api.g_varchar2;
135: g_er_attribute9(i) := hr_api.g_varchar2;
128: g_er_attribute2(i) := hr_api.g_varchar2;
129: g_er_attribute3(i) := hr_api.g_varchar2;
130: g_er_attribute4(i) := hr_api.g_varchar2;
131: g_er_attribute5(i) := hr_api.g_varchar2;
132: g_er_attribute6(i) := hr_api.g_varchar2;
133: g_er_attribute7(i) := hr_api.g_varchar2;
134: g_er_attribute8(i) := hr_api.g_varchar2;
135: g_er_attribute9(i) := hr_api.g_varchar2;
136: g_er_attribute10(i) := hr_api.g_varchar2;
129: g_er_attribute3(i) := hr_api.g_varchar2;
130: g_er_attribute4(i) := hr_api.g_varchar2;
131: g_er_attribute5(i) := hr_api.g_varchar2;
132: g_er_attribute6(i) := hr_api.g_varchar2;
133: g_er_attribute7(i) := hr_api.g_varchar2;
134: g_er_attribute8(i) := hr_api.g_varchar2;
135: g_er_attribute9(i) := hr_api.g_varchar2;
136: g_er_attribute10(i) := hr_api.g_varchar2;
137: g_er_grouping_category(i) := hr_api.g_varchar2; -- Add for Hospital Effort Report
130: g_er_attribute4(i) := hr_api.g_varchar2;
131: g_er_attribute5(i) := hr_api.g_varchar2;
132: g_er_attribute6(i) := hr_api.g_varchar2;
133: g_er_attribute7(i) := hr_api.g_varchar2;
134: g_er_attribute8(i) := hr_api.g_varchar2;
135: g_er_attribute9(i) := hr_api.g_varchar2;
136: g_er_attribute10(i) := hr_api.g_varchar2;
137: g_er_grouping_category(i) := hr_api.g_varchar2; -- Add for Hospital Effort Report
138:
131: g_er_attribute5(i) := hr_api.g_varchar2;
132: g_er_attribute6(i) := hr_api.g_varchar2;
133: g_er_attribute7(i) := hr_api.g_varchar2;
134: g_er_attribute8(i) := hr_api.g_varchar2;
135: g_er_attribute9(i) := hr_api.g_varchar2;
136: g_er_attribute10(i) := hr_api.g_varchar2;
137: g_er_grouping_category(i) := hr_api.g_varchar2; -- Add for Hospital Effort Report
138:
139: l_approver_person_id(i) := g_er_approver_person_id(i);
132: g_er_attribute6(i) := hr_api.g_varchar2;
133: g_er_attribute7(i) := hr_api.g_varchar2;
134: g_er_attribute8(i) := hr_api.g_varchar2;
135: g_er_attribute9(i) := hr_api.g_varchar2;
136: g_er_attribute10(i) := hr_api.g_varchar2;
137: g_er_grouping_category(i) := hr_api.g_varchar2; -- Add for Hospital Effort Report
138:
139: l_approver_person_id(i) := g_er_approver_person_id(i);
140: l_investigator_name(i) := g_er_investigator_name(i);
133: g_er_attribute7(i) := hr_api.g_varchar2;
134: g_er_attribute8(i) := hr_api.g_varchar2;
135: g_er_attribute9(i) := hr_api.g_varchar2;
136: g_er_attribute10(i) := hr_api.g_varchar2;
137: g_er_grouping_category(i) := hr_api.g_varchar2; -- Add for Hospital Effort Report
138:
139: l_approver_person_id(i) := g_er_approver_person_id(i);
140: l_investigator_name(i) := g_er_investigator_name(i);
141: l_inv_primary_org_id(i) := g_er_inv_primary_org_id(i);
244: END IF;
245:
246:
247: /* Added check to provent unnecessary update */
248: if g_er_proposed_salary_amt(i) <> hr_api.g_number OR g_er_proposed_effort_percent(i) <> hr_api.g_number
249: OR g_er_committed_cost_share(i) <> hr_api.g_number OR g_er_value1(i) <> hr_api.g_number
250: OR g_er_value2(i) <> hr_api.g_number OR g_er_value3(i) <> hr_api.g_number OR g_er_value4(i) <> hr_api.g_number
251: OR g_er_value5(i) <> hr_api.g_number OR g_er_value6(i) <> hr_api.g_number OR g_er_value7(i) <> hr_api.g_number
252: OR g_er_value8(i) <> hr_api.g_number OR g_er_value9(i) <> hr_api.g_number OR g_er_value10(i) <> hr_api.g_number
245:
246:
247: /* Added check to provent unnecessary update */
248: if g_er_proposed_salary_amt(i) <> hr_api.g_number OR g_er_proposed_effort_percent(i) <> hr_api.g_number
249: OR g_er_committed_cost_share(i) <> hr_api.g_number OR g_er_value1(i) <> hr_api.g_number
250: OR g_er_value2(i) <> hr_api.g_number OR g_er_value3(i) <> hr_api.g_number OR g_er_value4(i) <> hr_api.g_number
251: OR g_er_value5(i) <> hr_api.g_number OR g_er_value6(i) <> hr_api.g_number OR g_er_value7(i) <> hr_api.g_number
252: OR g_er_value8(i) <> hr_api.g_number OR g_er_value9(i) <> hr_api.g_number OR g_er_value10(i) <> hr_api.g_number
253: OR g_er_attribute1(i) <> hr_api.g_varchar2 OR g_er_attribute2(i) <> hr_api.g_varchar2
246:
247: /* Added check to provent unnecessary update */
248: if g_er_proposed_salary_amt(i) <> hr_api.g_number OR g_er_proposed_effort_percent(i) <> hr_api.g_number
249: OR g_er_committed_cost_share(i) <> hr_api.g_number OR g_er_value1(i) <> hr_api.g_number
250: OR g_er_value2(i) <> hr_api.g_number OR g_er_value3(i) <> hr_api.g_number OR g_er_value4(i) <> hr_api.g_number
251: OR g_er_value5(i) <> hr_api.g_number OR g_er_value6(i) <> hr_api.g_number OR g_er_value7(i) <> hr_api.g_number
252: OR g_er_value8(i) <> hr_api.g_number OR g_er_value9(i) <> hr_api.g_number OR g_er_value10(i) <> hr_api.g_number
253: OR g_er_attribute1(i) <> hr_api.g_varchar2 OR g_er_attribute2(i) <> hr_api.g_varchar2
254: OR g_er_attribute3(i) <> hr_api.g_varchar2 OR g_er_attribute4(i) <> hr_api.g_varchar2
247: /* Added check to provent unnecessary update */
248: if g_er_proposed_salary_amt(i) <> hr_api.g_number OR g_er_proposed_effort_percent(i) <> hr_api.g_number
249: OR g_er_committed_cost_share(i) <> hr_api.g_number OR g_er_value1(i) <> hr_api.g_number
250: OR g_er_value2(i) <> hr_api.g_number OR g_er_value3(i) <> hr_api.g_number OR g_er_value4(i) <> hr_api.g_number
251: OR g_er_value5(i) <> hr_api.g_number OR g_er_value6(i) <> hr_api.g_number OR g_er_value7(i) <> hr_api.g_number
252: OR g_er_value8(i) <> hr_api.g_number OR g_er_value9(i) <> hr_api.g_number OR g_er_value10(i) <> hr_api.g_number
253: OR g_er_attribute1(i) <> hr_api.g_varchar2 OR g_er_attribute2(i) <> hr_api.g_varchar2
254: OR g_er_attribute3(i) <> hr_api.g_varchar2 OR g_er_attribute4(i) <> hr_api.g_varchar2
255: OR g_er_attribute5(i) <> hr_api.g_varchar2 OR g_er_attribute6(i) <> hr_api.g_varchar2
248: if g_er_proposed_salary_amt(i) <> hr_api.g_number OR g_er_proposed_effort_percent(i) <> hr_api.g_number
249: OR g_er_committed_cost_share(i) <> hr_api.g_number OR g_er_value1(i) <> hr_api.g_number
250: OR g_er_value2(i) <> hr_api.g_number OR g_er_value3(i) <> hr_api.g_number OR g_er_value4(i) <> hr_api.g_number
251: OR g_er_value5(i) <> hr_api.g_number OR g_er_value6(i) <> hr_api.g_number OR g_er_value7(i) <> hr_api.g_number
252: OR g_er_value8(i) <> hr_api.g_number OR g_er_value9(i) <> hr_api.g_number OR g_er_value10(i) <> hr_api.g_number
253: OR g_er_attribute1(i) <> hr_api.g_varchar2 OR g_er_attribute2(i) <> hr_api.g_varchar2
254: OR g_er_attribute3(i) <> hr_api.g_varchar2 OR g_er_attribute4(i) <> hr_api.g_varchar2
255: OR g_er_attribute5(i) <> hr_api.g_varchar2 OR g_er_attribute6(i) <> hr_api.g_varchar2
256: OR g_er_attribute7(i) <> hr_api.g_varchar2 OR g_er_attribute8(i) <> hr_api.g_varchar2
249: OR g_er_committed_cost_share(i) <> hr_api.g_number OR g_er_value1(i) <> hr_api.g_number
250: OR g_er_value2(i) <> hr_api.g_number OR g_er_value3(i) <> hr_api.g_number OR g_er_value4(i) <> hr_api.g_number
251: OR g_er_value5(i) <> hr_api.g_number OR g_er_value6(i) <> hr_api.g_number OR g_er_value7(i) <> hr_api.g_number
252: OR g_er_value8(i) <> hr_api.g_number OR g_er_value9(i) <> hr_api.g_number OR g_er_value10(i) <> hr_api.g_number
253: OR g_er_attribute1(i) <> hr_api.g_varchar2 OR g_er_attribute2(i) <> hr_api.g_varchar2
254: OR g_er_attribute3(i) <> hr_api.g_varchar2 OR g_er_attribute4(i) <> hr_api.g_varchar2
255: OR g_er_attribute5(i) <> hr_api.g_varchar2 OR g_er_attribute6(i) <> hr_api.g_varchar2
256: OR g_er_attribute7(i) <> hr_api.g_varchar2 OR g_er_attribute8(i) <> hr_api.g_varchar2
257: OR g_er_attribute9(i) <> hr_api.g_varchar2 OR g_er_attribute10(i) <> hr_api.g_varchar2
250: OR g_er_value2(i) <> hr_api.g_number OR g_er_value3(i) <> hr_api.g_number OR g_er_value4(i) <> hr_api.g_number
251: OR g_er_value5(i) <> hr_api.g_number OR g_er_value6(i) <> hr_api.g_number OR g_er_value7(i) <> hr_api.g_number
252: OR g_er_value8(i) <> hr_api.g_number OR g_er_value9(i) <> hr_api.g_number OR g_er_value10(i) <> hr_api.g_number
253: OR g_er_attribute1(i) <> hr_api.g_varchar2 OR g_er_attribute2(i) <> hr_api.g_varchar2
254: OR g_er_attribute3(i) <> hr_api.g_varchar2 OR g_er_attribute4(i) <> hr_api.g_varchar2
255: OR g_er_attribute5(i) <> hr_api.g_varchar2 OR g_er_attribute6(i) <> hr_api.g_varchar2
256: OR g_er_attribute7(i) <> hr_api.g_varchar2 OR g_er_attribute8(i) <> hr_api.g_varchar2
257: OR g_er_attribute9(i) <> hr_api.g_varchar2 OR g_er_attribute10(i) <> hr_api.g_varchar2
258: OR g_er_approver_person_id(i) <> l_approver_person_id(i)
251: OR g_er_value5(i) <> hr_api.g_number OR g_er_value6(i) <> hr_api.g_number OR g_er_value7(i) <> hr_api.g_number
252: OR g_er_value8(i) <> hr_api.g_number OR g_er_value9(i) <> hr_api.g_number OR g_er_value10(i) <> hr_api.g_number
253: OR g_er_attribute1(i) <> hr_api.g_varchar2 OR g_er_attribute2(i) <> hr_api.g_varchar2
254: OR g_er_attribute3(i) <> hr_api.g_varchar2 OR g_er_attribute4(i) <> hr_api.g_varchar2
255: OR g_er_attribute5(i) <> hr_api.g_varchar2 OR g_er_attribute6(i) <> hr_api.g_varchar2
256: OR g_er_attribute7(i) <> hr_api.g_varchar2 OR g_er_attribute8(i) <> hr_api.g_varchar2
257: OR g_er_attribute9(i) <> hr_api.g_varchar2 OR g_er_attribute10(i) <> hr_api.g_varchar2
258: OR g_er_approver_person_id(i) <> l_approver_person_id(i)
259: OR g_er_investigator_name(i) <> l_investigator_name(i)
252: OR g_er_value8(i) <> hr_api.g_number OR g_er_value9(i) <> hr_api.g_number OR g_er_value10(i) <> hr_api.g_number
253: OR g_er_attribute1(i) <> hr_api.g_varchar2 OR g_er_attribute2(i) <> hr_api.g_varchar2
254: OR g_er_attribute3(i) <> hr_api.g_varchar2 OR g_er_attribute4(i) <> hr_api.g_varchar2
255: OR g_er_attribute5(i) <> hr_api.g_varchar2 OR g_er_attribute6(i) <> hr_api.g_varchar2
256: OR g_er_attribute7(i) <> hr_api.g_varchar2 OR g_er_attribute8(i) <> hr_api.g_varchar2
257: OR g_er_attribute9(i) <> hr_api.g_varchar2 OR g_er_attribute10(i) <> hr_api.g_varchar2
258: OR g_er_approver_person_id(i) <> l_approver_person_id(i)
259: OR g_er_investigator_name(i) <> l_investigator_name(i)
260: OR g_er_investigator_org_name(i) <> l_investigator_org_name(i)
253: OR g_er_attribute1(i) <> hr_api.g_varchar2 OR g_er_attribute2(i) <> hr_api.g_varchar2
254: OR g_er_attribute3(i) <> hr_api.g_varchar2 OR g_er_attribute4(i) <> hr_api.g_varchar2
255: OR g_er_attribute5(i) <> hr_api.g_varchar2 OR g_er_attribute6(i) <> hr_api.g_varchar2
256: OR g_er_attribute7(i) <> hr_api.g_varchar2 OR g_er_attribute8(i) <> hr_api.g_varchar2
257: OR g_er_attribute9(i) <> hr_api.g_varchar2 OR g_er_attribute10(i) <> hr_api.g_varchar2
258: OR g_er_approver_person_id(i) <> l_approver_person_id(i)
259: OR g_er_investigator_name(i) <> l_investigator_name(i)
260: OR g_er_investigator_org_name(i) <> l_investigator_org_name(i)
261: OR g_er_inv_primary_org_id(i) <> l_inv_primary_org_id(i)
258: OR g_er_approver_person_id(i) <> l_approver_person_id(i)
259: OR g_er_investigator_name(i) <> l_investigator_name(i)
260: OR g_er_investigator_org_name(i) <> l_investigator_org_name(i)
261: OR g_er_inv_primary_org_id(i) <> l_inv_primary_org_id(i)
262: OR g_er_grouping_category(i) <> hr_api.g_varchar2
263: THEN
264: psp_erd_upd.upd (
265: p_effort_report_detail_id => g_er_EFFORT_REPORT_DETAIL_ID(i)
266: ,p_object_version_number => g_er_OBJECT_VERSION_NUMBER(i)
387: ,p_INVESTIGATOR_PRIMARY_ORG_ID => g_er_inv_primary_org_id(i)
388: );
389: End Loop;
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'UPDATE_EFF_REPORT_DETAILS'
394: ,p_hook_type => 'AP'
395: );
388: );
389: End Loop;
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'UPDATE_EFF_REPORT_DETAILS'
394: ,p_hook_type => 'AP'
395: );
396: l_message := sqlerrm;
431: --
432: -- When in validation only mode raise the Validate_Enabled exception
433: --
434: if p_validate then
435: raise hr_api.validate_enabled;
436: end if;
437: --
438: -- Set all IN OUT and OUT parameters with out values
439: --
485: end if;
486: End Loop;
487: close c_MAX_PROPOSED_EFFORT_PERCENT;
488: */
489: when hr_api.validate_enabled then
490: --
491: -- As the Validate_Enabled exception has been raised
492: -- we must rollback to the savepoint
493: --