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.PSP_EFF_REPORT_DETAILS_API dependencies on HR_API

Line 114: g_er_proposed_salary_amt(i) := hr_api.g_number;

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;

Line 115: g_er_proposed_effort_percent(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;

Line 116: g_er_committed_cost_share(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;

Line 117: g_er_value1(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;

Line 118: g_er_value2(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;

Line 119: g_er_value3(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;

Line 120: g_er_value4(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;

Line 121: g_er_value5(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;

Line 122: g_er_value6(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;

Line 123: g_er_value7(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;

Line 124: g_er_value8(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;
128: g_er_attribute2(i) := hr_api.g_varchar2;

Line 125: g_er_value9(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;
129: g_er_attribute3(i) := hr_api.g_varchar2;

Line 126: g_er_value10(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;
130: g_er_attribute4(i) := hr_api.g_varchar2;

Line 127: g_er_attribute1(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;

Line 128: g_er_attribute2(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;

Line 129: g_er_attribute3(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;

Line 130: g_er_attribute4(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;

Line 131: g_er_attribute5(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;

Line 132: g_er_attribute6(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;

Line 133: g_er_attribute7(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

Line 134: g_er_attribute8(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
138:

Line 135: g_er_attribute9(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:
139: l_approver_person_id(i) := g_er_approver_person_id(i);

Line 136: g_er_attribute10(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);
140: l_investigator_name(i) := g_er_investigator_name(i);

Line 137: g_er_grouping_category(i) := hr_api.g_varchar2; -- Add for Hospital Effort Report

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);

Line 248: if g_er_proposed_salary_amt(i) <> hr_api.g_number OR g_er_proposed_effort_percent(i) <> hr_api.g_number

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

Line 249: OR g_er_committed_cost_share(i) <> hr_api.g_number OR g_er_value1(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

Line 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

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

Line 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

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

Line 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

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

Line 253: OR g_er_attribute1(i) <> hr_api.g_varchar2 OR g_er_attribute2(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

Line 254: OR g_er_attribute3(i) <> hr_api.g_varchar2 OR g_er_attribute4(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)

Line 255: OR g_er_attribute5(i) <> hr_api.g_varchar2 OR g_er_attribute6(i) <> hr_api.g_varchar2

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)

Line 256: OR g_er_attribute7(i) <> hr_api.g_varchar2 OR g_er_attribute8(i) <> hr_api.g_varchar2

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)

Line 257: OR g_er_attribute9(i) <> hr_api.g_varchar2 OR g_er_attribute10(i) <> hr_api.g_varchar2

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)

Line 262: OR g_er_grouping_category(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)
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)

Line 391: when hr_api.cannot_find_prog_unit then

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: );

Line 392: hr_api.cannot_find_prog_unit_error

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;

Line 435: raise hr_api.validate_enabled;

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: --

Line 489: when hr_api.validate_enabled then

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: --