APPS.PSP_ERD_DEL dependencies on PSP_ERD_SHD

Line 52: (p_rec in psp_erd_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in psp_erd_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: psp_erd_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: psp_erd_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in psp_erd_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in psp_erd_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in psp_erd_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in psp_erd_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => psp_erd_shd.g_old_rec.effort_report_id

164: psp_erd_rkd.after_delete
165: (p_effort_report_detail_id
166: => p_rec.effort_report_detail_id
167: ,p_effort_report_id_o
168: => psp_erd_shd.g_old_rec.effort_report_id
169: ,p_object_version_number_o
170: => psp_erd_shd.g_old_rec.object_version_number
171: ,p_assignment_id_o
172: => psp_erd_shd.g_old_rec.assignment_id

Line 170: => psp_erd_shd.g_old_rec.object_version_number

166: => p_rec.effort_report_detail_id
167: ,p_effort_report_id_o
168: => psp_erd_shd.g_old_rec.effort_report_id
169: ,p_object_version_number_o
170: => psp_erd_shd.g_old_rec.object_version_number
171: ,p_assignment_id_o
172: => psp_erd_shd.g_old_rec.assignment_id
173: ,p_assignment_number_o
174: => psp_erd_shd.g_old_rec.assignment_number

Line 172: => psp_erd_shd.g_old_rec.assignment_id

168: => psp_erd_shd.g_old_rec.effort_report_id
169: ,p_object_version_number_o
170: => psp_erd_shd.g_old_rec.object_version_number
171: ,p_assignment_id_o
172: => psp_erd_shd.g_old_rec.assignment_id
173: ,p_assignment_number_o
174: => psp_erd_shd.g_old_rec.assignment_number
175: ,p_gl_sum_criteria_segment_na_o
176: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name

Line 174: => psp_erd_shd.g_old_rec.assignment_number

170: => psp_erd_shd.g_old_rec.object_version_number
171: ,p_assignment_id_o
172: => psp_erd_shd.g_old_rec.assignment_id
173: ,p_assignment_number_o
174: => psp_erd_shd.g_old_rec.assignment_number
175: ,p_gl_sum_criteria_segment_na_o
176: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name
177: ,p_gl_segment1_o
178: => psp_erd_shd.g_old_rec.gl_segment1

Line 176: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name

172: => psp_erd_shd.g_old_rec.assignment_id
173: ,p_assignment_number_o
174: => psp_erd_shd.g_old_rec.assignment_number
175: ,p_gl_sum_criteria_segment_na_o
176: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name
177: ,p_gl_segment1_o
178: => psp_erd_shd.g_old_rec.gl_segment1
179: ,p_gl_segment2_o
180: => psp_erd_shd.g_old_rec.gl_segment2

Line 178: => psp_erd_shd.g_old_rec.gl_segment1

174: => psp_erd_shd.g_old_rec.assignment_number
175: ,p_gl_sum_criteria_segment_na_o
176: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name
177: ,p_gl_segment1_o
178: => psp_erd_shd.g_old_rec.gl_segment1
179: ,p_gl_segment2_o
180: => psp_erd_shd.g_old_rec.gl_segment2
181: ,p_gl_segment3_o
182: => psp_erd_shd.g_old_rec.gl_segment3

Line 180: => psp_erd_shd.g_old_rec.gl_segment2

176: => psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name
177: ,p_gl_segment1_o
178: => psp_erd_shd.g_old_rec.gl_segment1
179: ,p_gl_segment2_o
180: => psp_erd_shd.g_old_rec.gl_segment2
181: ,p_gl_segment3_o
182: => psp_erd_shd.g_old_rec.gl_segment3
183: ,p_gl_segment4_o
184: => psp_erd_shd.g_old_rec.gl_segment4

Line 182: => psp_erd_shd.g_old_rec.gl_segment3

178: => psp_erd_shd.g_old_rec.gl_segment1
179: ,p_gl_segment2_o
180: => psp_erd_shd.g_old_rec.gl_segment2
181: ,p_gl_segment3_o
182: => psp_erd_shd.g_old_rec.gl_segment3
183: ,p_gl_segment4_o
184: => psp_erd_shd.g_old_rec.gl_segment4
185: ,p_gl_segment5_o
186: => psp_erd_shd.g_old_rec.gl_segment5

Line 184: => psp_erd_shd.g_old_rec.gl_segment4

180: => psp_erd_shd.g_old_rec.gl_segment2
181: ,p_gl_segment3_o
182: => psp_erd_shd.g_old_rec.gl_segment3
183: ,p_gl_segment4_o
184: => psp_erd_shd.g_old_rec.gl_segment4
185: ,p_gl_segment5_o
186: => psp_erd_shd.g_old_rec.gl_segment5
187: ,p_gl_segment6_o
188: => psp_erd_shd.g_old_rec.gl_segment6

Line 186: => psp_erd_shd.g_old_rec.gl_segment5

182: => psp_erd_shd.g_old_rec.gl_segment3
183: ,p_gl_segment4_o
184: => psp_erd_shd.g_old_rec.gl_segment4
185: ,p_gl_segment5_o
186: => psp_erd_shd.g_old_rec.gl_segment5
187: ,p_gl_segment6_o
188: => psp_erd_shd.g_old_rec.gl_segment6
189: ,p_gl_segment7_o
190: => psp_erd_shd.g_old_rec.gl_segment7

Line 188: => psp_erd_shd.g_old_rec.gl_segment6

184: => psp_erd_shd.g_old_rec.gl_segment4
185: ,p_gl_segment5_o
186: => psp_erd_shd.g_old_rec.gl_segment5
187: ,p_gl_segment6_o
188: => psp_erd_shd.g_old_rec.gl_segment6
189: ,p_gl_segment7_o
190: => psp_erd_shd.g_old_rec.gl_segment7
191: ,p_gl_segment8_o
192: => psp_erd_shd.g_old_rec.gl_segment8

Line 190: => psp_erd_shd.g_old_rec.gl_segment7

186: => psp_erd_shd.g_old_rec.gl_segment5
187: ,p_gl_segment6_o
188: => psp_erd_shd.g_old_rec.gl_segment6
189: ,p_gl_segment7_o
190: => psp_erd_shd.g_old_rec.gl_segment7
191: ,p_gl_segment8_o
192: => psp_erd_shd.g_old_rec.gl_segment8
193: ,p_gl_segment9_o
194: => psp_erd_shd.g_old_rec.gl_segment9

Line 192: => psp_erd_shd.g_old_rec.gl_segment8

188: => psp_erd_shd.g_old_rec.gl_segment6
189: ,p_gl_segment7_o
190: => psp_erd_shd.g_old_rec.gl_segment7
191: ,p_gl_segment8_o
192: => psp_erd_shd.g_old_rec.gl_segment8
193: ,p_gl_segment9_o
194: => psp_erd_shd.g_old_rec.gl_segment9
195: ,p_gl_segment10_o
196: => psp_erd_shd.g_old_rec.gl_segment10

Line 194: => psp_erd_shd.g_old_rec.gl_segment9

190: => psp_erd_shd.g_old_rec.gl_segment7
191: ,p_gl_segment8_o
192: => psp_erd_shd.g_old_rec.gl_segment8
193: ,p_gl_segment9_o
194: => psp_erd_shd.g_old_rec.gl_segment9
195: ,p_gl_segment10_o
196: => psp_erd_shd.g_old_rec.gl_segment10
197: ,p_gl_segment11_o
198: => psp_erd_shd.g_old_rec.gl_segment11

Line 196: => psp_erd_shd.g_old_rec.gl_segment10

192: => psp_erd_shd.g_old_rec.gl_segment8
193: ,p_gl_segment9_o
194: => psp_erd_shd.g_old_rec.gl_segment9
195: ,p_gl_segment10_o
196: => psp_erd_shd.g_old_rec.gl_segment10
197: ,p_gl_segment11_o
198: => psp_erd_shd.g_old_rec.gl_segment11
199: ,p_gl_segment12_o
200: => psp_erd_shd.g_old_rec.gl_segment12

Line 198: => psp_erd_shd.g_old_rec.gl_segment11

194: => psp_erd_shd.g_old_rec.gl_segment9
195: ,p_gl_segment10_o
196: => psp_erd_shd.g_old_rec.gl_segment10
197: ,p_gl_segment11_o
198: => psp_erd_shd.g_old_rec.gl_segment11
199: ,p_gl_segment12_o
200: => psp_erd_shd.g_old_rec.gl_segment12
201: ,p_gl_segment13_o
202: => psp_erd_shd.g_old_rec.gl_segment13

Line 200: => psp_erd_shd.g_old_rec.gl_segment12

196: => psp_erd_shd.g_old_rec.gl_segment10
197: ,p_gl_segment11_o
198: => psp_erd_shd.g_old_rec.gl_segment11
199: ,p_gl_segment12_o
200: => psp_erd_shd.g_old_rec.gl_segment12
201: ,p_gl_segment13_o
202: => psp_erd_shd.g_old_rec.gl_segment13
203: ,p_gl_segment14_o
204: => psp_erd_shd.g_old_rec.gl_segment14

Line 202: => psp_erd_shd.g_old_rec.gl_segment13

198: => psp_erd_shd.g_old_rec.gl_segment11
199: ,p_gl_segment12_o
200: => psp_erd_shd.g_old_rec.gl_segment12
201: ,p_gl_segment13_o
202: => psp_erd_shd.g_old_rec.gl_segment13
203: ,p_gl_segment14_o
204: => psp_erd_shd.g_old_rec.gl_segment14
205: ,p_gl_segment15_o
206: => psp_erd_shd.g_old_rec.gl_segment15

Line 204: => psp_erd_shd.g_old_rec.gl_segment14

200: => psp_erd_shd.g_old_rec.gl_segment12
201: ,p_gl_segment13_o
202: => psp_erd_shd.g_old_rec.gl_segment13
203: ,p_gl_segment14_o
204: => psp_erd_shd.g_old_rec.gl_segment14
205: ,p_gl_segment15_o
206: => psp_erd_shd.g_old_rec.gl_segment15
207: ,p_gl_segment16_o
208: => psp_erd_shd.g_old_rec.gl_segment16

Line 206: => psp_erd_shd.g_old_rec.gl_segment15

202: => psp_erd_shd.g_old_rec.gl_segment13
203: ,p_gl_segment14_o
204: => psp_erd_shd.g_old_rec.gl_segment14
205: ,p_gl_segment15_o
206: => psp_erd_shd.g_old_rec.gl_segment15
207: ,p_gl_segment16_o
208: => psp_erd_shd.g_old_rec.gl_segment16
209: ,p_gl_segment17_o
210: => psp_erd_shd.g_old_rec.gl_segment17

Line 208: => psp_erd_shd.g_old_rec.gl_segment16

204: => psp_erd_shd.g_old_rec.gl_segment14
205: ,p_gl_segment15_o
206: => psp_erd_shd.g_old_rec.gl_segment15
207: ,p_gl_segment16_o
208: => psp_erd_shd.g_old_rec.gl_segment16
209: ,p_gl_segment17_o
210: => psp_erd_shd.g_old_rec.gl_segment17
211: ,p_gl_segment18_o
212: => psp_erd_shd.g_old_rec.gl_segment18

Line 210: => psp_erd_shd.g_old_rec.gl_segment17

206: => psp_erd_shd.g_old_rec.gl_segment15
207: ,p_gl_segment16_o
208: => psp_erd_shd.g_old_rec.gl_segment16
209: ,p_gl_segment17_o
210: => psp_erd_shd.g_old_rec.gl_segment17
211: ,p_gl_segment18_o
212: => psp_erd_shd.g_old_rec.gl_segment18
213: ,p_gl_segment19_o
214: => psp_erd_shd.g_old_rec.gl_segment19

Line 212: => psp_erd_shd.g_old_rec.gl_segment18

208: => psp_erd_shd.g_old_rec.gl_segment16
209: ,p_gl_segment17_o
210: => psp_erd_shd.g_old_rec.gl_segment17
211: ,p_gl_segment18_o
212: => psp_erd_shd.g_old_rec.gl_segment18
213: ,p_gl_segment19_o
214: => psp_erd_shd.g_old_rec.gl_segment19
215: ,p_gl_segment20_o
216: => psp_erd_shd.g_old_rec.gl_segment20

Line 214: => psp_erd_shd.g_old_rec.gl_segment19

210: => psp_erd_shd.g_old_rec.gl_segment17
211: ,p_gl_segment18_o
212: => psp_erd_shd.g_old_rec.gl_segment18
213: ,p_gl_segment19_o
214: => psp_erd_shd.g_old_rec.gl_segment19
215: ,p_gl_segment20_o
216: => psp_erd_shd.g_old_rec.gl_segment20
217: ,p_gl_segment21_o
218: => psp_erd_shd.g_old_rec.gl_segment21

Line 216: => psp_erd_shd.g_old_rec.gl_segment20

212: => psp_erd_shd.g_old_rec.gl_segment18
213: ,p_gl_segment19_o
214: => psp_erd_shd.g_old_rec.gl_segment19
215: ,p_gl_segment20_o
216: => psp_erd_shd.g_old_rec.gl_segment20
217: ,p_gl_segment21_o
218: => psp_erd_shd.g_old_rec.gl_segment21
219: ,p_gl_segment22_o
220: => psp_erd_shd.g_old_rec.gl_segment22

Line 218: => psp_erd_shd.g_old_rec.gl_segment21

214: => psp_erd_shd.g_old_rec.gl_segment19
215: ,p_gl_segment20_o
216: => psp_erd_shd.g_old_rec.gl_segment20
217: ,p_gl_segment21_o
218: => psp_erd_shd.g_old_rec.gl_segment21
219: ,p_gl_segment22_o
220: => psp_erd_shd.g_old_rec.gl_segment22
221: ,p_gl_segment23_o
222: => psp_erd_shd.g_old_rec.gl_segment23

Line 220: => psp_erd_shd.g_old_rec.gl_segment22

216: => psp_erd_shd.g_old_rec.gl_segment20
217: ,p_gl_segment21_o
218: => psp_erd_shd.g_old_rec.gl_segment21
219: ,p_gl_segment22_o
220: => psp_erd_shd.g_old_rec.gl_segment22
221: ,p_gl_segment23_o
222: => psp_erd_shd.g_old_rec.gl_segment23
223: ,p_gl_segment24_o
224: => psp_erd_shd.g_old_rec.gl_segment24

Line 222: => psp_erd_shd.g_old_rec.gl_segment23

218: => psp_erd_shd.g_old_rec.gl_segment21
219: ,p_gl_segment22_o
220: => psp_erd_shd.g_old_rec.gl_segment22
221: ,p_gl_segment23_o
222: => psp_erd_shd.g_old_rec.gl_segment23
223: ,p_gl_segment24_o
224: => psp_erd_shd.g_old_rec.gl_segment24
225: ,p_gl_segment25_o
226: => psp_erd_shd.g_old_rec.gl_segment25

Line 224: => psp_erd_shd.g_old_rec.gl_segment24

220: => psp_erd_shd.g_old_rec.gl_segment22
221: ,p_gl_segment23_o
222: => psp_erd_shd.g_old_rec.gl_segment23
223: ,p_gl_segment24_o
224: => psp_erd_shd.g_old_rec.gl_segment24
225: ,p_gl_segment25_o
226: => psp_erd_shd.g_old_rec.gl_segment25
227: ,p_gl_segment26_o
228: => psp_erd_shd.g_old_rec.gl_segment26

Line 226: => psp_erd_shd.g_old_rec.gl_segment25

222: => psp_erd_shd.g_old_rec.gl_segment23
223: ,p_gl_segment24_o
224: => psp_erd_shd.g_old_rec.gl_segment24
225: ,p_gl_segment25_o
226: => psp_erd_shd.g_old_rec.gl_segment25
227: ,p_gl_segment26_o
228: => psp_erd_shd.g_old_rec.gl_segment26
229: ,p_gl_segment27_o
230: => psp_erd_shd.g_old_rec.gl_segment27

Line 228: => psp_erd_shd.g_old_rec.gl_segment26

224: => psp_erd_shd.g_old_rec.gl_segment24
225: ,p_gl_segment25_o
226: => psp_erd_shd.g_old_rec.gl_segment25
227: ,p_gl_segment26_o
228: => psp_erd_shd.g_old_rec.gl_segment26
229: ,p_gl_segment27_o
230: => psp_erd_shd.g_old_rec.gl_segment27
231: ,p_gl_segment28_o
232: => psp_erd_shd.g_old_rec.gl_segment28

Line 230: => psp_erd_shd.g_old_rec.gl_segment27

226: => psp_erd_shd.g_old_rec.gl_segment25
227: ,p_gl_segment26_o
228: => psp_erd_shd.g_old_rec.gl_segment26
229: ,p_gl_segment27_o
230: => psp_erd_shd.g_old_rec.gl_segment27
231: ,p_gl_segment28_o
232: => psp_erd_shd.g_old_rec.gl_segment28
233: ,p_gl_segment29_o
234: => psp_erd_shd.g_old_rec.gl_segment29

Line 232: => psp_erd_shd.g_old_rec.gl_segment28

228: => psp_erd_shd.g_old_rec.gl_segment26
229: ,p_gl_segment27_o
230: => psp_erd_shd.g_old_rec.gl_segment27
231: ,p_gl_segment28_o
232: => psp_erd_shd.g_old_rec.gl_segment28
233: ,p_gl_segment29_o
234: => psp_erd_shd.g_old_rec.gl_segment29
235: ,p_gl_segment30_o
236: => psp_erd_shd.g_old_rec.gl_segment30

Line 234: => psp_erd_shd.g_old_rec.gl_segment29

230: => psp_erd_shd.g_old_rec.gl_segment27
231: ,p_gl_segment28_o
232: => psp_erd_shd.g_old_rec.gl_segment28
233: ,p_gl_segment29_o
234: => psp_erd_shd.g_old_rec.gl_segment29
235: ,p_gl_segment30_o
236: => psp_erd_shd.g_old_rec.gl_segment30
237: ,p_project_id_o
238: => psp_erd_shd.g_old_rec.project_id

Line 236: => psp_erd_shd.g_old_rec.gl_segment30

232: => psp_erd_shd.g_old_rec.gl_segment28
233: ,p_gl_segment29_o
234: => psp_erd_shd.g_old_rec.gl_segment29
235: ,p_gl_segment30_o
236: => psp_erd_shd.g_old_rec.gl_segment30
237: ,p_project_id_o
238: => psp_erd_shd.g_old_rec.project_id
239: ,p_project_number_o
240: => psp_erd_shd.g_old_rec.project_number

Line 238: => psp_erd_shd.g_old_rec.project_id

234: => psp_erd_shd.g_old_rec.gl_segment29
235: ,p_gl_segment30_o
236: => psp_erd_shd.g_old_rec.gl_segment30
237: ,p_project_id_o
238: => psp_erd_shd.g_old_rec.project_id
239: ,p_project_number_o
240: => psp_erd_shd.g_old_rec.project_number
241: ,p_project_name_o
242: => psp_erd_shd.g_old_rec.project_name

Line 240: => psp_erd_shd.g_old_rec.project_number

236: => psp_erd_shd.g_old_rec.gl_segment30
237: ,p_project_id_o
238: => psp_erd_shd.g_old_rec.project_id
239: ,p_project_number_o
240: => psp_erd_shd.g_old_rec.project_number
241: ,p_project_name_o
242: => psp_erd_shd.g_old_rec.project_name
243: ,p_expenditure_organization_i_o
244: => psp_erd_shd.g_old_rec.expenditure_organization_id

Line 242: => psp_erd_shd.g_old_rec.project_name

238: => psp_erd_shd.g_old_rec.project_id
239: ,p_project_number_o
240: => psp_erd_shd.g_old_rec.project_number
241: ,p_project_name_o
242: => psp_erd_shd.g_old_rec.project_name
243: ,p_expenditure_organization_i_o
244: => psp_erd_shd.g_old_rec.expenditure_organization_id
245: ,p_exp_org_name_o
246: => psp_erd_shd.g_old_rec.exp_org_name

Line 244: => psp_erd_shd.g_old_rec.expenditure_organization_id

240: => psp_erd_shd.g_old_rec.project_number
241: ,p_project_name_o
242: => psp_erd_shd.g_old_rec.project_name
243: ,p_expenditure_organization_i_o
244: => psp_erd_shd.g_old_rec.expenditure_organization_id
245: ,p_exp_org_name_o
246: => psp_erd_shd.g_old_rec.exp_org_name
247: ,p_expenditure_type_o
248: => psp_erd_shd.g_old_rec.expenditure_type

Line 246: => psp_erd_shd.g_old_rec.exp_org_name

242: => psp_erd_shd.g_old_rec.project_name
243: ,p_expenditure_organization_i_o
244: => psp_erd_shd.g_old_rec.expenditure_organization_id
245: ,p_exp_org_name_o
246: => psp_erd_shd.g_old_rec.exp_org_name
247: ,p_expenditure_type_o
248: => psp_erd_shd.g_old_rec.expenditure_type
249: ,p_task_id_o
250: => psp_erd_shd.g_old_rec.task_id

Line 248: => psp_erd_shd.g_old_rec.expenditure_type

244: => psp_erd_shd.g_old_rec.expenditure_organization_id
245: ,p_exp_org_name_o
246: => psp_erd_shd.g_old_rec.exp_org_name
247: ,p_expenditure_type_o
248: => psp_erd_shd.g_old_rec.expenditure_type
249: ,p_task_id_o
250: => psp_erd_shd.g_old_rec.task_id
251: ,p_task_number_o
252: => psp_erd_shd.g_old_rec.task_number

Line 250: => psp_erd_shd.g_old_rec.task_id

246: => psp_erd_shd.g_old_rec.exp_org_name
247: ,p_expenditure_type_o
248: => psp_erd_shd.g_old_rec.expenditure_type
249: ,p_task_id_o
250: => psp_erd_shd.g_old_rec.task_id
251: ,p_task_number_o
252: => psp_erd_shd.g_old_rec.task_number
253: ,p_task_name_o
254: => psp_erd_shd.g_old_rec.task_name

Line 252: => psp_erd_shd.g_old_rec.task_number

248: => psp_erd_shd.g_old_rec.expenditure_type
249: ,p_task_id_o
250: => psp_erd_shd.g_old_rec.task_id
251: ,p_task_number_o
252: => psp_erd_shd.g_old_rec.task_number
253: ,p_task_name_o
254: => psp_erd_shd.g_old_rec.task_name
255: ,p_award_id_o
256: => psp_erd_shd.g_old_rec.award_id

Line 254: => psp_erd_shd.g_old_rec.task_name

250: => psp_erd_shd.g_old_rec.task_id
251: ,p_task_number_o
252: => psp_erd_shd.g_old_rec.task_number
253: ,p_task_name_o
254: => psp_erd_shd.g_old_rec.task_name
255: ,p_award_id_o
256: => psp_erd_shd.g_old_rec.award_id
257: ,p_award_number_o
258: => psp_erd_shd.g_old_rec.award_number

Line 256: => psp_erd_shd.g_old_rec.award_id

252: => psp_erd_shd.g_old_rec.task_number
253: ,p_task_name_o
254: => psp_erd_shd.g_old_rec.task_name
255: ,p_award_id_o
256: => psp_erd_shd.g_old_rec.award_id
257: ,p_award_number_o
258: => psp_erd_shd.g_old_rec.award_number
259: ,p_award_short_name_o
260: => psp_erd_shd.g_old_rec.award_short_name

Line 258: => psp_erd_shd.g_old_rec.award_number

254: => psp_erd_shd.g_old_rec.task_name
255: ,p_award_id_o
256: => psp_erd_shd.g_old_rec.award_id
257: ,p_award_number_o
258: => psp_erd_shd.g_old_rec.award_number
259: ,p_award_short_name_o
260: => psp_erd_shd.g_old_rec.award_short_name
261: ,p_actual_salary_amt_o
262: => psp_erd_shd.g_old_rec.actual_salary_amt

Line 260: => psp_erd_shd.g_old_rec.award_short_name

256: => psp_erd_shd.g_old_rec.award_id
257: ,p_award_number_o
258: => psp_erd_shd.g_old_rec.award_number
259: ,p_award_short_name_o
260: => psp_erd_shd.g_old_rec.award_short_name
261: ,p_actual_salary_amt_o
262: => psp_erd_shd.g_old_rec.actual_salary_amt
263: ,p_payroll_percent_o
264: => psp_erd_shd.g_old_rec.payroll_percent

Line 262: => psp_erd_shd.g_old_rec.actual_salary_amt

258: => psp_erd_shd.g_old_rec.award_number
259: ,p_award_short_name_o
260: => psp_erd_shd.g_old_rec.award_short_name
261: ,p_actual_salary_amt_o
262: => psp_erd_shd.g_old_rec.actual_salary_amt
263: ,p_payroll_percent_o
264: => psp_erd_shd.g_old_rec.payroll_percent
265: ,p_proposed_salary_amt_o
266: => psp_erd_shd.g_old_rec.proposed_salary_amt

Line 264: => psp_erd_shd.g_old_rec.payroll_percent

260: => psp_erd_shd.g_old_rec.award_short_name
261: ,p_actual_salary_amt_o
262: => psp_erd_shd.g_old_rec.actual_salary_amt
263: ,p_payroll_percent_o
264: => psp_erd_shd.g_old_rec.payroll_percent
265: ,p_proposed_salary_amt_o
266: => psp_erd_shd.g_old_rec.proposed_salary_amt
267: ,p_proposed_effort_percent_o
268: => psp_erd_shd.g_old_rec.proposed_effort_percent

Line 266: => psp_erd_shd.g_old_rec.proposed_salary_amt

262: => psp_erd_shd.g_old_rec.actual_salary_amt
263: ,p_payroll_percent_o
264: => psp_erd_shd.g_old_rec.payroll_percent
265: ,p_proposed_salary_amt_o
266: => psp_erd_shd.g_old_rec.proposed_salary_amt
267: ,p_proposed_effort_percent_o
268: => psp_erd_shd.g_old_rec.proposed_effort_percent
269: ,p_committed_cost_share_o
270: => psp_erd_shd.g_old_rec.committed_cost_share

Line 268: => psp_erd_shd.g_old_rec.proposed_effort_percent

264: => psp_erd_shd.g_old_rec.payroll_percent
265: ,p_proposed_salary_amt_o
266: => psp_erd_shd.g_old_rec.proposed_salary_amt
267: ,p_proposed_effort_percent_o
268: => psp_erd_shd.g_old_rec.proposed_effort_percent
269: ,p_committed_cost_share_o
270: => psp_erd_shd.g_old_rec.committed_cost_share
271: ,p_schedule_start_date_o
272: => psp_erd_shd.g_old_rec.schedule_start_date

Line 270: => psp_erd_shd.g_old_rec.committed_cost_share

266: => psp_erd_shd.g_old_rec.proposed_salary_amt
267: ,p_proposed_effort_percent_o
268: => psp_erd_shd.g_old_rec.proposed_effort_percent
269: ,p_committed_cost_share_o
270: => psp_erd_shd.g_old_rec.committed_cost_share
271: ,p_schedule_start_date_o
272: => psp_erd_shd.g_old_rec.schedule_start_date
273: ,p_schedule_end_date_o
274: => psp_erd_shd.g_old_rec.schedule_end_date

Line 272: => psp_erd_shd.g_old_rec.schedule_start_date

268: => psp_erd_shd.g_old_rec.proposed_effort_percent
269: ,p_committed_cost_share_o
270: => psp_erd_shd.g_old_rec.committed_cost_share
271: ,p_schedule_start_date_o
272: => psp_erd_shd.g_old_rec.schedule_start_date
273: ,p_schedule_end_date_o
274: => psp_erd_shd.g_old_rec.schedule_end_date
275: ,p_ame_transaction_id_o
276: => psp_erd_shd.g_old_rec.ame_transaction_id

Line 274: => psp_erd_shd.g_old_rec.schedule_end_date

270: => psp_erd_shd.g_old_rec.committed_cost_share
271: ,p_schedule_start_date_o
272: => psp_erd_shd.g_old_rec.schedule_start_date
273: ,p_schedule_end_date_o
274: => psp_erd_shd.g_old_rec.schedule_end_date
275: ,p_ame_transaction_id_o
276: => psp_erd_shd.g_old_rec.ame_transaction_id
277: ,p_investigator_name_o
278: => psp_erd_shd.g_old_rec.investigator_name

Line 276: => psp_erd_shd.g_old_rec.ame_transaction_id

272: => psp_erd_shd.g_old_rec.schedule_start_date
273: ,p_schedule_end_date_o
274: => psp_erd_shd.g_old_rec.schedule_end_date
275: ,p_ame_transaction_id_o
276: => psp_erd_shd.g_old_rec.ame_transaction_id
277: ,p_investigator_name_o
278: => psp_erd_shd.g_old_rec.investigator_name
279: ,p_investigator_person_id_o
280: => psp_erd_shd.g_old_rec.investigator_person_id

Line 278: => psp_erd_shd.g_old_rec.investigator_name

274: => psp_erd_shd.g_old_rec.schedule_end_date
275: ,p_ame_transaction_id_o
276: => psp_erd_shd.g_old_rec.ame_transaction_id
277: ,p_investigator_name_o
278: => psp_erd_shd.g_old_rec.investigator_name
279: ,p_investigator_person_id_o
280: => psp_erd_shd.g_old_rec.investigator_person_id
281: ,p_investigator_org_name_o
282: => psp_erd_shd.g_old_rec.investigator_org_name

Line 280: => psp_erd_shd.g_old_rec.investigator_person_id

276: => psp_erd_shd.g_old_rec.ame_transaction_id
277: ,p_investigator_name_o
278: => psp_erd_shd.g_old_rec.investigator_name
279: ,p_investigator_person_id_o
280: => psp_erd_shd.g_old_rec.investigator_person_id
281: ,p_investigator_org_name_o
282: => psp_erd_shd.g_old_rec.investigator_org_name
283: ,p_investigator_primary_org_i_o
284: => psp_erd_shd.g_old_rec.investigator_primary_org_id

Line 282: => psp_erd_shd.g_old_rec.investigator_org_name

278: => psp_erd_shd.g_old_rec.investigator_name
279: ,p_investigator_person_id_o
280: => psp_erd_shd.g_old_rec.investigator_person_id
281: ,p_investigator_org_name_o
282: => psp_erd_shd.g_old_rec.investigator_org_name
283: ,p_investigator_primary_org_i_o
284: => psp_erd_shd.g_old_rec.investigator_primary_org_id
285: ,p_value1_o
286: => psp_erd_shd.g_old_rec.value1

Line 284: => psp_erd_shd.g_old_rec.investigator_primary_org_id

280: => psp_erd_shd.g_old_rec.investigator_person_id
281: ,p_investigator_org_name_o
282: => psp_erd_shd.g_old_rec.investigator_org_name
283: ,p_investigator_primary_org_i_o
284: => psp_erd_shd.g_old_rec.investigator_primary_org_id
285: ,p_value1_o
286: => psp_erd_shd.g_old_rec.value1
287: ,p_value2_o
288: => psp_erd_shd.g_old_rec.value2

Line 286: => psp_erd_shd.g_old_rec.value1

282: => psp_erd_shd.g_old_rec.investigator_org_name
283: ,p_investigator_primary_org_i_o
284: => psp_erd_shd.g_old_rec.investigator_primary_org_id
285: ,p_value1_o
286: => psp_erd_shd.g_old_rec.value1
287: ,p_value2_o
288: => psp_erd_shd.g_old_rec.value2
289: ,p_value3_o
290: => psp_erd_shd.g_old_rec.value3

Line 288: => psp_erd_shd.g_old_rec.value2

284: => psp_erd_shd.g_old_rec.investigator_primary_org_id
285: ,p_value1_o
286: => psp_erd_shd.g_old_rec.value1
287: ,p_value2_o
288: => psp_erd_shd.g_old_rec.value2
289: ,p_value3_o
290: => psp_erd_shd.g_old_rec.value3
291: ,p_value4_o
292: => psp_erd_shd.g_old_rec.value4

Line 290: => psp_erd_shd.g_old_rec.value3

286: => psp_erd_shd.g_old_rec.value1
287: ,p_value2_o
288: => psp_erd_shd.g_old_rec.value2
289: ,p_value3_o
290: => psp_erd_shd.g_old_rec.value3
291: ,p_value4_o
292: => psp_erd_shd.g_old_rec.value4
293: ,p_value5_o
294: => psp_erd_shd.g_old_rec.value5

Line 292: => psp_erd_shd.g_old_rec.value4

288: => psp_erd_shd.g_old_rec.value2
289: ,p_value3_o
290: => psp_erd_shd.g_old_rec.value3
291: ,p_value4_o
292: => psp_erd_shd.g_old_rec.value4
293: ,p_value5_o
294: => psp_erd_shd.g_old_rec.value5
295: ,p_value6_o
296: => psp_erd_shd.g_old_rec.value6

Line 294: => psp_erd_shd.g_old_rec.value5

290: => psp_erd_shd.g_old_rec.value3
291: ,p_value4_o
292: => psp_erd_shd.g_old_rec.value4
293: ,p_value5_o
294: => psp_erd_shd.g_old_rec.value5
295: ,p_value6_o
296: => psp_erd_shd.g_old_rec.value6
297: ,p_value7_o
298: => psp_erd_shd.g_old_rec.value7

Line 296: => psp_erd_shd.g_old_rec.value6

292: => psp_erd_shd.g_old_rec.value4
293: ,p_value5_o
294: => psp_erd_shd.g_old_rec.value5
295: ,p_value6_o
296: => psp_erd_shd.g_old_rec.value6
297: ,p_value7_o
298: => psp_erd_shd.g_old_rec.value7
299: ,p_value8_o
300: => psp_erd_shd.g_old_rec.value8

Line 298: => psp_erd_shd.g_old_rec.value7

294: => psp_erd_shd.g_old_rec.value5
295: ,p_value6_o
296: => psp_erd_shd.g_old_rec.value6
297: ,p_value7_o
298: => psp_erd_shd.g_old_rec.value7
299: ,p_value8_o
300: => psp_erd_shd.g_old_rec.value8
301: ,p_value9_o
302: => psp_erd_shd.g_old_rec.value9

Line 300: => psp_erd_shd.g_old_rec.value8

296: => psp_erd_shd.g_old_rec.value6
297: ,p_value7_o
298: => psp_erd_shd.g_old_rec.value7
299: ,p_value8_o
300: => psp_erd_shd.g_old_rec.value8
301: ,p_value9_o
302: => psp_erd_shd.g_old_rec.value9
303: ,p_value10_o
304: => psp_erd_shd.g_old_rec.value10

Line 302: => psp_erd_shd.g_old_rec.value9

298: => psp_erd_shd.g_old_rec.value7
299: ,p_value8_o
300: => psp_erd_shd.g_old_rec.value8
301: ,p_value9_o
302: => psp_erd_shd.g_old_rec.value9
303: ,p_value10_o
304: => psp_erd_shd.g_old_rec.value10
305: ,p_attribute1_o
306: => psp_erd_shd.g_old_rec.attribute1

Line 304: => psp_erd_shd.g_old_rec.value10

300: => psp_erd_shd.g_old_rec.value8
301: ,p_value9_o
302: => psp_erd_shd.g_old_rec.value9
303: ,p_value10_o
304: => psp_erd_shd.g_old_rec.value10
305: ,p_attribute1_o
306: => psp_erd_shd.g_old_rec.attribute1
307: ,p_attribute2_o
308: => psp_erd_shd.g_old_rec.attribute2

Line 306: => psp_erd_shd.g_old_rec.attribute1

302: => psp_erd_shd.g_old_rec.value9
303: ,p_value10_o
304: => psp_erd_shd.g_old_rec.value10
305: ,p_attribute1_o
306: => psp_erd_shd.g_old_rec.attribute1
307: ,p_attribute2_o
308: => psp_erd_shd.g_old_rec.attribute2
309: ,p_attribute3_o
310: => psp_erd_shd.g_old_rec.attribute3

Line 308: => psp_erd_shd.g_old_rec.attribute2

304: => psp_erd_shd.g_old_rec.value10
305: ,p_attribute1_o
306: => psp_erd_shd.g_old_rec.attribute1
307: ,p_attribute2_o
308: => psp_erd_shd.g_old_rec.attribute2
309: ,p_attribute3_o
310: => psp_erd_shd.g_old_rec.attribute3
311: ,p_attribute4_o
312: => psp_erd_shd.g_old_rec.attribute4

Line 310: => psp_erd_shd.g_old_rec.attribute3

306: => psp_erd_shd.g_old_rec.attribute1
307: ,p_attribute2_o
308: => psp_erd_shd.g_old_rec.attribute2
309: ,p_attribute3_o
310: => psp_erd_shd.g_old_rec.attribute3
311: ,p_attribute4_o
312: => psp_erd_shd.g_old_rec.attribute4
313: ,p_attribute5_o
314: => psp_erd_shd.g_old_rec.attribute5

Line 312: => psp_erd_shd.g_old_rec.attribute4

308: => psp_erd_shd.g_old_rec.attribute2
309: ,p_attribute3_o
310: => psp_erd_shd.g_old_rec.attribute3
311: ,p_attribute4_o
312: => psp_erd_shd.g_old_rec.attribute4
313: ,p_attribute5_o
314: => psp_erd_shd.g_old_rec.attribute5
315: ,p_attribute6_o
316: => psp_erd_shd.g_old_rec.attribute6

Line 314: => psp_erd_shd.g_old_rec.attribute5

310: => psp_erd_shd.g_old_rec.attribute3
311: ,p_attribute4_o
312: => psp_erd_shd.g_old_rec.attribute4
313: ,p_attribute5_o
314: => psp_erd_shd.g_old_rec.attribute5
315: ,p_attribute6_o
316: => psp_erd_shd.g_old_rec.attribute6
317: ,p_attribute7_o
318: => psp_erd_shd.g_old_rec.attribute7

Line 316: => psp_erd_shd.g_old_rec.attribute6

312: => psp_erd_shd.g_old_rec.attribute4
313: ,p_attribute5_o
314: => psp_erd_shd.g_old_rec.attribute5
315: ,p_attribute6_o
316: => psp_erd_shd.g_old_rec.attribute6
317: ,p_attribute7_o
318: => psp_erd_shd.g_old_rec.attribute7
319: ,p_attribute8_o
320: => psp_erd_shd.g_old_rec.attribute8

Line 318: => psp_erd_shd.g_old_rec.attribute7

314: => psp_erd_shd.g_old_rec.attribute5
315: ,p_attribute6_o
316: => psp_erd_shd.g_old_rec.attribute6
317: ,p_attribute7_o
318: => psp_erd_shd.g_old_rec.attribute7
319: ,p_attribute8_o
320: => psp_erd_shd.g_old_rec.attribute8
321: ,p_attribute9_o
322: => psp_erd_shd.g_old_rec.attribute9

Line 320: => psp_erd_shd.g_old_rec.attribute8

316: => psp_erd_shd.g_old_rec.attribute6
317: ,p_attribute7_o
318: => psp_erd_shd.g_old_rec.attribute7
319: ,p_attribute8_o
320: => psp_erd_shd.g_old_rec.attribute8
321: ,p_attribute9_o
322: => psp_erd_shd.g_old_rec.attribute9
323: ,p_attribute10_o
324: => psp_erd_shd.g_old_rec.attribute10

Line 322: => psp_erd_shd.g_old_rec.attribute9

318: => psp_erd_shd.g_old_rec.attribute7
319: ,p_attribute8_o
320: => psp_erd_shd.g_old_rec.attribute8
321: ,p_attribute9_o
322: => psp_erd_shd.g_old_rec.attribute9
323: ,p_attribute10_o
324: => psp_erd_shd.g_old_rec.attribute10
325: ,p_grouping_category_o
326: => psp_erd_shd.g_old_rec.grouping_category

Line 324: => psp_erd_shd.g_old_rec.attribute10

320: => psp_erd_shd.g_old_rec.attribute8
321: ,p_attribute9_o
322: => psp_erd_shd.g_old_rec.attribute9
323: ,p_attribute10_o
324: => psp_erd_shd.g_old_rec.attribute10
325: ,p_grouping_category_o
326: => psp_erd_shd.g_old_rec.grouping_category
327: );
328: --

Line 326: => psp_erd_shd.g_old_rec.grouping_category

322: => psp_erd_shd.g_old_rec.attribute9
323: ,p_attribute10_o
324: => psp_erd_shd.g_old_rec.attribute10
325: ,p_grouping_category_o
326: => psp_erd_shd.g_old_rec.grouping_category
327: );
328: --
329: exception
330: --

Line 346: (p_rec in psp_erd_shd.g_rec_type

342: -- ----------------------------------------------------------------------------
343: -- |---------------------------------< del >----------------------------------|
344: -- ----------------------------------------------------------------------------
345: Procedure del
346: (p_rec in psp_erd_shd.g_rec_type
347: ) is
348: --
349: l_proc varchar2(72) := g_package||'del';
350: --

Line 356: psp_erd_shd.lck

352: hr_utility.set_location('Entering:'||l_proc, 5);
353: --
354: -- We must lock the row which we need to delete.
355: --
356: psp_erd_shd.lck
357: (p_rec.effort_report_detail_id
358: ,p_rec.object_version_number
359: );
360: --

Line 393: l_rec psp_erd_shd.g_rec_type;

389: (p_effort_report_detail_id in number
390: ,p_object_version_number in number
391: ) is
392: --
393: l_rec psp_erd_shd.g_rec_type;
394: l_proc varchar2(72) := g_package||'del';
395: --
396: Begin
397: hr_utility.set_location('Entering:'||l_proc, 5);