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.OTA_TPS_UPD dependencies on OTA_TPS_SHD

Line 55: (p_rec IN OUT NOCOPY ota_tps_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: PROCEDURE update_dml
55: (p_rec IN OUT NOCOPY ota_tps_shd.g_rec_type
56: ) IS
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 66: ota_tps_shd.g_api_dml := TRUE; -- Set the api dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: ota_tps_shd.g_api_dml := TRUE; -- Set the api dml status
67: --
68: -- Update the ota_training_plans Row
69: --
70: UPDATE ota_training_plans

Line 119: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status

115: ,learning_path_id = p_rec.learning_path_id
116: ,contact_id = p_rec.contact_id
117: WHERE training_plan_id = p_rec.training_plan_id;
118: --
119: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: --
123: EXCEPTION

Line 126: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status

122: --
123: EXCEPTION
124: WHEN hr_api.check_integrity_violated THEN
125: -- A check constraint has been violated
126: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
127: ota_tps_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: WHEN hr_api.parent_integrity_violated THEN
130: -- Parent integrity has been violated

Line 127: ota_tps_shd.constraint_error

123: EXCEPTION
124: WHEN hr_api.check_integrity_violated THEN
125: -- A check constraint has been violated
126: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
127: ota_tps_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: WHEN hr_api.parent_integrity_violated THEN
130: -- Parent integrity has been violated
131: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status

Line 131: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status

127: ota_tps_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: WHEN hr_api.parent_integrity_violated THEN
130: -- Parent integrity has been violated
131: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
132: ota_tps_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: WHEN hr_api.unique_integrity_violated THEN
135: -- Unique integrity has been violated

Line 132: ota_tps_shd.constraint_error

128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: WHEN hr_api.parent_integrity_violated THEN
130: -- Parent integrity has been violated
131: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
132: ota_tps_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: WHEN hr_api.unique_integrity_violated THEN
135: -- Unique integrity has been violated
136: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status

Line 136: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status

132: ota_tps_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: WHEN hr_api.unique_integrity_violated THEN
135: -- Unique integrity has been violated
136: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
137: ota_tps_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: WHEN Others THEN
140: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status

Line 137: ota_tps_shd.constraint_error

133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: WHEN hr_api.unique_integrity_violated THEN
135: -- Unique integrity has been violated
136: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
137: ota_tps_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: WHEN Others THEN
140: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
141: RAISE;

Line 140: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status

136: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
137: ota_tps_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: WHEN Others THEN
140: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
141: RAISE;
142: END update_dml;
143: --
144: -- ----------------------------------------------------------------------------

Line 177: (p_rec IN ota_tps_shd.g_rec_type

173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: PROCEDURE pre_update
177: (p_rec IN ota_tps_shd.g_rec_type
178: ) IS
179: --
180: l_proc varchar2(72) := g_package||'pre_update';
181: --

Line 222: ,p_rec IN ota_tps_shd.g_rec_type

218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: PROCEDURE post_update
221: (p_effective_date IN date
222: ,p_rec IN ota_tps_shd.g_rec_type
223: ) IS
224: --
225: l_proc varchar2(72) := g_package||'post_update';
226: --

Line 323: => ota_tps_shd.g_old_rec.time_period_id

319: ,p_additional_member_flag => p_rec.additional_member_flag
320: ,p_learning_path_id => p_rec.learning_path_id
321: ,p_contact_id => p_rec.contact_id
322: ,p_time_period_id_o
323: => ota_tps_shd.g_old_rec.time_period_id
324: ,p_plan_status_type_id_o
325: => ota_tps_shd.g_old_rec.plan_status_type_id
326: ,p_organization_id_o
327: => ota_tps_shd.g_old_rec.organization_id

Line 325: => ota_tps_shd.g_old_rec.plan_status_type_id

321: ,p_contact_id => p_rec.contact_id
322: ,p_time_period_id_o
323: => ota_tps_shd.g_old_rec.time_period_id
324: ,p_plan_status_type_id_o
325: => ota_tps_shd.g_old_rec.plan_status_type_id
326: ,p_organization_id_o
327: => ota_tps_shd.g_old_rec.organization_id
328: ,p_person_id_o
329: => ota_tps_shd.g_old_rec.person_id

Line 327: => ota_tps_shd.g_old_rec.organization_id

323: => ota_tps_shd.g_old_rec.time_period_id
324: ,p_plan_status_type_id_o
325: => ota_tps_shd.g_old_rec.plan_status_type_id
326: ,p_organization_id_o
327: => ota_tps_shd.g_old_rec.organization_id
328: ,p_person_id_o
329: => ota_tps_shd.g_old_rec.person_id
330: ,p_budget_currency_o
331: => ota_tps_shd.g_old_rec.budget_currency

Line 329: => ota_tps_shd.g_old_rec.person_id

325: => ota_tps_shd.g_old_rec.plan_status_type_id
326: ,p_organization_id_o
327: => ota_tps_shd.g_old_rec.organization_id
328: ,p_person_id_o
329: => ota_tps_shd.g_old_rec.person_id
330: ,p_budget_currency_o
331: => ota_tps_shd.g_old_rec.budget_currency
332: ,p_name_o
333: => ota_tps_shd.g_old_rec.name

Line 331: => ota_tps_shd.g_old_rec.budget_currency

327: => ota_tps_shd.g_old_rec.organization_id
328: ,p_person_id_o
329: => ota_tps_shd.g_old_rec.person_id
330: ,p_budget_currency_o
331: => ota_tps_shd.g_old_rec.budget_currency
332: ,p_name_o
333: => ota_tps_shd.g_old_rec.name
334: ,p_description_o
335: => ota_tps_shd.g_old_rec.description

Line 333: => ota_tps_shd.g_old_rec.name

329: => ota_tps_shd.g_old_rec.person_id
330: ,p_budget_currency_o
331: => ota_tps_shd.g_old_rec.budget_currency
332: ,p_name_o
333: => ota_tps_shd.g_old_rec.name
334: ,p_description_o
335: => ota_tps_shd.g_old_rec.description
336: ,p_business_group_id_o
337: => ota_tps_shd.g_old_rec.business_group_id

Line 335: => ota_tps_shd.g_old_rec.description

331: => ota_tps_shd.g_old_rec.budget_currency
332: ,p_name_o
333: => ota_tps_shd.g_old_rec.name
334: ,p_description_o
335: => ota_tps_shd.g_old_rec.description
336: ,p_business_group_id_o
337: => ota_tps_shd.g_old_rec.business_group_id
338: ,p_object_version_number_o
339: => ota_tps_shd.g_old_rec.object_version_number

Line 337: => ota_tps_shd.g_old_rec.business_group_id

333: => ota_tps_shd.g_old_rec.name
334: ,p_description_o
335: => ota_tps_shd.g_old_rec.description
336: ,p_business_group_id_o
337: => ota_tps_shd.g_old_rec.business_group_id
338: ,p_object_version_number_o
339: => ota_tps_shd.g_old_rec.object_version_number
340: ,p_attribute_category_o
341: => ota_tps_shd.g_old_rec.attribute_category

Line 339: => ota_tps_shd.g_old_rec.object_version_number

335: => ota_tps_shd.g_old_rec.description
336: ,p_business_group_id_o
337: => ota_tps_shd.g_old_rec.business_group_id
338: ,p_object_version_number_o
339: => ota_tps_shd.g_old_rec.object_version_number
340: ,p_attribute_category_o
341: => ota_tps_shd.g_old_rec.attribute_category
342: ,p_attribute1_o
343: => ota_tps_shd.g_old_rec.attribute1

Line 341: => ota_tps_shd.g_old_rec.attribute_category

337: => ota_tps_shd.g_old_rec.business_group_id
338: ,p_object_version_number_o
339: => ota_tps_shd.g_old_rec.object_version_number
340: ,p_attribute_category_o
341: => ota_tps_shd.g_old_rec.attribute_category
342: ,p_attribute1_o
343: => ota_tps_shd.g_old_rec.attribute1
344: ,p_attribute2_o
345: => ota_tps_shd.g_old_rec.attribute2

Line 343: => ota_tps_shd.g_old_rec.attribute1

339: => ota_tps_shd.g_old_rec.object_version_number
340: ,p_attribute_category_o
341: => ota_tps_shd.g_old_rec.attribute_category
342: ,p_attribute1_o
343: => ota_tps_shd.g_old_rec.attribute1
344: ,p_attribute2_o
345: => ota_tps_shd.g_old_rec.attribute2
346: ,p_attribute3_o
347: => ota_tps_shd.g_old_rec.attribute3

Line 345: => ota_tps_shd.g_old_rec.attribute2

341: => ota_tps_shd.g_old_rec.attribute_category
342: ,p_attribute1_o
343: => ota_tps_shd.g_old_rec.attribute1
344: ,p_attribute2_o
345: => ota_tps_shd.g_old_rec.attribute2
346: ,p_attribute3_o
347: => ota_tps_shd.g_old_rec.attribute3
348: ,p_attribute4_o
349: => ota_tps_shd.g_old_rec.attribute4

Line 347: => ota_tps_shd.g_old_rec.attribute3

343: => ota_tps_shd.g_old_rec.attribute1
344: ,p_attribute2_o
345: => ota_tps_shd.g_old_rec.attribute2
346: ,p_attribute3_o
347: => ota_tps_shd.g_old_rec.attribute3
348: ,p_attribute4_o
349: => ota_tps_shd.g_old_rec.attribute4
350: ,p_attribute5_o
351: => ota_tps_shd.g_old_rec.attribute5

Line 349: => ota_tps_shd.g_old_rec.attribute4

345: => ota_tps_shd.g_old_rec.attribute2
346: ,p_attribute3_o
347: => ota_tps_shd.g_old_rec.attribute3
348: ,p_attribute4_o
349: => ota_tps_shd.g_old_rec.attribute4
350: ,p_attribute5_o
351: => ota_tps_shd.g_old_rec.attribute5
352: ,p_attribute6_o
353: => ota_tps_shd.g_old_rec.attribute6

Line 351: => ota_tps_shd.g_old_rec.attribute5

347: => ota_tps_shd.g_old_rec.attribute3
348: ,p_attribute4_o
349: => ota_tps_shd.g_old_rec.attribute4
350: ,p_attribute5_o
351: => ota_tps_shd.g_old_rec.attribute5
352: ,p_attribute6_o
353: => ota_tps_shd.g_old_rec.attribute6
354: ,p_attribute7_o
355: => ota_tps_shd.g_old_rec.attribute7

Line 353: => ota_tps_shd.g_old_rec.attribute6

349: => ota_tps_shd.g_old_rec.attribute4
350: ,p_attribute5_o
351: => ota_tps_shd.g_old_rec.attribute5
352: ,p_attribute6_o
353: => ota_tps_shd.g_old_rec.attribute6
354: ,p_attribute7_o
355: => ota_tps_shd.g_old_rec.attribute7
356: ,p_attribute8_o
357: => ota_tps_shd.g_old_rec.attribute8

Line 355: => ota_tps_shd.g_old_rec.attribute7

351: => ota_tps_shd.g_old_rec.attribute5
352: ,p_attribute6_o
353: => ota_tps_shd.g_old_rec.attribute6
354: ,p_attribute7_o
355: => ota_tps_shd.g_old_rec.attribute7
356: ,p_attribute8_o
357: => ota_tps_shd.g_old_rec.attribute8
358: ,p_attribute9_o
359: => ota_tps_shd.g_old_rec.attribute9

Line 357: => ota_tps_shd.g_old_rec.attribute8

353: => ota_tps_shd.g_old_rec.attribute6
354: ,p_attribute7_o
355: => ota_tps_shd.g_old_rec.attribute7
356: ,p_attribute8_o
357: => ota_tps_shd.g_old_rec.attribute8
358: ,p_attribute9_o
359: => ota_tps_shd.g_old_rec.attribute9
360: ,p_attribute10_o
361: => ota_tps_shd.g_old_rec.attribute10

Line 359: => ota_tps_shd.g_old_rec.attribute9

355: => ota_tps_shd.g_old_rec.attribute7
356: ,p_attribute8_o
357: => ota_tps_shd.g_old_rec.attribute8
358: ,p_attribute9_o
359: => ota_tps_shd.g_old_rec.attribute9
360: ,p_attribute10_o
361: => ota_tps_shd.g_old_rec.attribute10
362: ,p_attribute11_o
363: => ota_tps_shd.g_old_rec.attribute11

Line 361: => ota_tps_shd.g_old_rec.attribute10

357: => ota_tps_shd.g_old_rec.attribute8
358: ,p_attribute9_o
359: => ota_tps_shd.g_old_rec.attribute9
360: ,p_attribute10_o
361: => ota_tps_shd.g_old_rec.attribute10
362: ,p_attribute11_o
363: => ota_tps_shd.g_old_rec.attribute11
364: ,p_attribute12_o
365: => ota_tps_shd.g_old_rec.attribute12

Line 363: => ota_tps_shd.g_old_rec.attribute11

359: => ota_tps_shd.g_old_rec.attribute9
360: ,p_attribute10_o
361: => ota_tps_shd.g_old_rec.attribute10
362: ,p_attribute11_o
363: => ota_tps_shd.g_old_rec.attribute11
364: ,p_attribute12_o
365: => ota_tps_shd.g_old_rec.attribute12
366: ,p_attribute13_o
367: => ota_tps_shd.g_old_rec.attribute13

Line 365: => ota_tps_shd.g_old_rec.attribute12

361: => ota_tps_shd.g_old_rec.attribute10
362: ,p_attribute11_o
363: => ota_tps_shd.g_old_rec.attribute11
364: ,p_attribute12_o
365: => ota_tps_shd.g_old_rec.attribute12
366: ,p_attribute13_o
367: => ota_tps_shd.g_old_rec.attribute13
368: ,p_attribute14_o
369: => ota_tps_shd.g_old_rec.attribute14

Line 367: => ota_tps_shd.g_old_rec.attribute13

363: => ota_tps_shd.g_old_rec.attribute11
364: ,p_attribute12_o
365: => ota_tps_shd.g_old_rec.attribute12
366: ,p_attribute13_o
367: => ota_tps_shd.g_old_rec.attribute13
368: ,p_attribute14_o
369: => ota_tps_shd.g_old_rec.attribute14
370: ,p_attribute15_o
371: => ota_tps_shd.g_old_rec.attribute15

Line 369: => ota_tps_shd.g_old_rec.attribute14

365: => ota_tps_shd.g_old_rec.attribute12
366: ,p_attribute13_o
367: => ota_tps_shd.g_old_rec.attribute13
368: ,p_attribute14_o
369: => ota_tps_shd.g_old_rec.attribute14
370: ,p_attribute15_o
371: => ota_tps_shd.g_old_rec.attribute15
372: ,p_attribute16_o
373: => ota_tps_shd.g_old_rec.attribute16

Line 371: => ota_tps_shd.g_old_rec.attribute15

367: => ota_tps_shd.g_old_rec.attribute13
368: ,p_attribute14_o
369: => ota_tps_shd.g_old_rec.attribute14
370: ,p_attribute15_o
371: => ota_tps_shd.g_old_rec.attribute15
372: ,p_attribute16_o
373: => ota_tps_shd.g_old_rec.attribute16
374: ,p_attribute17_o
375: => ota_tps_shd.g_old_rec.attribute17

Line 373: => ota_tps_shd.g_old_rec.attribute16

369: => ota_tps_shd.g_old_rec.attribute14
370: ,p_attribute15_o
371: => ota_tps_shd.g_old_rec.attribute15
372: ,p_attribute16_o
373: => ota_tps_shd.g_old_rec.attribute16
374: ,p_attribute17_o
375: => ota_tps_shd.g_old_rec.attribute17
376: ,p_attribute18_o
377: => ota_tps_shd.g_old_rec.attribute18

Line 375: => ota_tps_shd.g_old_rec.attribute17

371: => ota_tps_shd.g_old_rec.attribute15
372: ,p_attribute16_o
373: => ota_tps_shd.g_old_rec.attribute16
374: ,p_attribute17_o
375: => ota_tps_shd.g_old_rec.attribute17
376: ,p_attribute18_o
377: => ota_tps_shd.g_old_rec.attribute18
378: ,p_attribute19_o
379: => ota_tps_shd.g_old_rec.attribute19

Line 377: => ota_tps_shd.g_old_rec.attribute18

373: => ota_tps_shd.g_old_rec.attribute16
374: ,p_attribute17_o
375: => ota_tps_shd.g_old_rec.attribute17
376: ,p_attribute18_o
377: => ota_tps_shd.g_old_rec.attribute18
378: ,p_attribute19_o
379: => ota_tps_shd.g_old_rec.attribute19
380: ,p_attribute20_o
381: => ota_tps_shd.g_old_rec.attribute20

Line 379: => ota_tps_shd.g_old_rec.attribute19

375: => ota_tps_shd.g_old_rec.attribute17
376: ,p_attribute18_o
377: => ota_tps_shd.g_old_rec.attribute18
378: ,p_attribute19_o
379: => ota_tps_shd.g_old_rec.attribute19
380: ,p_attribute20_o
381: => ota_tps_shd.g_old_rec.attribute20
382: ,p_attribute21_o
383: => ota_tps_shd.g_old_rec.attribute21

Line 381: => ota_tps_shd.g_old_rec.attribute20

377: => ota_tps_shd.g_old_rec.attribute18
378: ,p_attribute19_o
379: => ota_tps_shd.g_old_rec.attribute19
380: ,p_attribute20_o
381: => ota_tps_shd.g_old_rec.attribute20
382: ,p_attribute21_o
383: => ota_tps_shd.g_old_rec.attribute21
384: ,p_attribute22_o
385: => ota_tps_shd.g_old_rec.attribute22

Line 383: => ota_tps_shd.g_old_rec.attribute21

379: => ota_tps_shd.g_old_rec.attribute19
380: ,p_attribute20_o
381: => ota_tps_shd.g_old_rec.attribute20
382: ,p_attribute21_o
383: => ota_tps_shd.g_old_rec.attribute21
384: ,p_attribute22_o
385: => ota_tps_shd.g_old_rec.attribute22
386: ,p_attribute23_o
387: => ota_tps_shd.g_old_rec.attribute23

Line 385: => ota_tps_shd.g_old_rec.attribute22

381: => ota_tps_shd.g_old_rec.attribute20
382: ,p_attribute21_o
383: => ota_tps_shd.g_old_rec.attribute21
384: ,p_attribute22_o
385: => ota_tps_shd.g_old_rec.attribute22
386: ,p_attribute23_o
387: => ota_tps_shd.g_old_rec.attribute23
388: ,p_attribute24_o
389: => ota_tps_shd.g_old_rec.attribute24

Line 387: => ota_tps_shd.g_old_rec.attribute23

383: => ota_tps_shd.g_old_rec.attribute21
384: ,p_attribute22_o
385: => ota_tps_shd.g_old_rec.attribute22
386: ,p_attribute23_o
387: => ota_tps_shd.g_old_rec.attribute23
388: ,p_attribute24_o
389: => ota_tps_shd.g_old_rec.attribute24
390: ,p_attribute25_o
391: => ota_tps_shd.g_old_rec.attribute25

Line 389: => ota_tps_shd.g_old_rec.attribute24

385: => ota_tps_shd.g_old_rec.attribute22
386: ,p_attribute23_o
387: => ota_tps_shd.g_old_rec.attribute23
388: ,p_attribute24_o
389: => ota_tps_shd.g_old_rec.attribute24
390: ,p_attribute25_o
391: => ota_tps_shd.g_old_rec.attribute25
392: ,p_attribute26_o
393: => ota_tps_shd.g_old_rec.attribute26

Line 391: => ota_tps_shd.g_old_rec.attribute25

387: => ota_tps_shd.g_old_rec.attribute23
388: ,p_attribute24_o
389: => ota_tps_shd.g_old_rec.attribute24
390: ,p_attribute25_o
391: => ota_tps_shd.g_old_rec.attribute25
392: ,p_attribute26_o
393: => ota_tps_shd.g_old_rec.attribute26
394: ,p_attribute27_o
395: => ota_tps_shd.g_old_rec.attribute27

Line 393: => ota_tps_shd.g_old_rec.attribute26

389: => ota_tps_shd.g_old_rec.attribute24
390: ,p_attribute25_o
391: => ota_tps_shd.g_old_rec.attribute25
392: ,p_attribute26_o
393: => ota_tps_shd.g_old_rec.attribute26
394: ,p_attribute27_o
395: => ota_tps_shd.g_old_rec.attribute27
396: ,p_attribute28_o
397: => ota_tps_shd.g_old_rec.attribute28

Line 395: => ota_tps_shd.g_old_rec.attribute27

391: => ota_tps_shd.g_old_rec.attribute25
392: ,p_attribute26_o
393: => ota_tps_shd.g_old_rec.attribute26
394: ,p_attribute27_o
395: => ota_tps_shd.g_old_rec.attribute27
396: ,p_attribute28_o
397: => ota_tps_shd.g_old_rec.attribute28
398: ,p_attribute29_o
399: => ota_tps_shd.g_old_rec.attribute29

Line 397: => ota_tps_shd.g_old_rec.attribute28

393: => ota_tps_shd.g_old_rec.attribute26
394: ,p_attribute27_o
395: => ota_tps_shd.g_old_rec.attribute27
396: ,p_attribute28_o
397: => ota_tps_shd.g_old_rec.attribute28
398: ,p_attribute29_o
399: => ota_tps_shd.g_old_rec.attribute29
400: ,p_attribute30_o
401: => ota_tps_shd.g_old_rec.attribute30

Line 399: => ota_tps_shd.g_old_rec.attribute29

395: => ota_tps_shd.g_old_rec.attribute27
396: ,p_attribute28_o
397: => ota_tps_shd.g_old_rec.attribute28
398: ,p_attribute29_o
399: => ota_tps_shd.g_old_rec.attribute29
400: ,p_attribute30_o
401: => ota_tps_shd.g_old_rec.attribute30
402: ,p_plan_source_o => ota_tps_shd.g_old_rec.plan_source --changed
403: ,p_start_date_o => ota_tps_shd.g_old_rec.start_date

Line 401: => ota_tps_shd.g_old_rec.attribute30

397: => ota_tps_shd.g_old_rec.attribute28
398: ,p_attribute29_o
399: => ota_tps_shd.g_old_rec.attribute29
400: ,p_attribute30_o
401: => ota_tps_shd.g_old_rec.attribute30
402: ,p_plan_source_o => ota_tps_shd.g_old_rec.plan_source --changed
403: ,p_start_date_o => ota_tps_shd.g_old_rec.start_date
404: ,p_end_date_o => ota_tps_shd.g_old_rec.end_date
405: ,p_creator_person_id_o => ota_tps_shd.g_old_rec.creator_person_id

Line 402: ,p_plan_source_o => ota_tps_shd.g_old_rec.plan_source --changed

398: ,p_attribute29_o
399: => ota_tps_shd.g_old_rec.attribute29
400: ,p_attribute30_o
401: => ota_tps_shd.g_old_rec.attribute30
402: ,p_plan_source_o => ota_tps_shd.g_old_rec.plan_source --changed
403: ,p_start_date_o => ota_tps_shd.g_old_rec.start_date
404: ,p_end_date_o => ota_tps_shd.g_old_rec.end_date
405: ,p_creator_person_id_o => ota_tps_shd.g_old_rec.creator_person_id
406: ,p_additional_member_flag_o => ota_tps_shd.g_old_rec.additional_member_flag

Line 403: ,p_start_date_o => ota_tps_shd.g_old_rec.start_date

399: => ota_tps_shd.g_old_rec.attribute29
400: ,p_attribute30_o
401: => ota_tps_shd.g_old_rec.attribute30
402: ,p_plan_source_o => ota_tps_shd.g_old_rec.plan_source --changed
403: ,p_start_date_o => ota_tps_shd.g_old_rec.start_date
404: ,p_end_date_o => ota_tps_shd.g_old_rec.end_date
405: ,p_creator_person_id_o => ota_tps_shd.g_old_rec.creator_person_id
406: ,p_additional_member_flag_o => ota_tps_shd.g_old_rec.additional_member_flag
407: ,p_learning_path_id_o => ota_tps_shd.g_old_rec.learning_path_id

Line 404: ,p_end_date_o => ota_tps_shd.g_old_rec.end_date

400: ,p_attribute30_o
401: => ota_tps_shd.g_old_rec.attribute30
402: ,p_plan_source_o => ota_tps_shd.g_old_rec.plan_source --changed
403: ,p_start_date_o => ota_tps_shd.g_old_rec.start_date
404: ,p_end_date_o => ota_tps_shd.g_old_rec.end_date
405: ,p_creator_person_id_o => ota_tps_shd.g_old_rec.creator_person_id
406: ,p_additional_member_flag_o => ota_tps_shd.g_old_rec.additional_member_flag
407: ,p_learning_path_id_o => ota_tps_shd.g_old_rec.learning_path_id
408: ,p_contact_id_o => ota_tps_shd.g_old_rec.contact_id

Line 405: ,p_creator_person_id_o => ota_tps_shd.g_old_rec.creator_person_id

401: => ota_tps_shd.g_old_rec.attribute30
402: ,p_plan_source_o => ota_tps_shd.g_old_rec.plan_source --changed
403: ,p_start_date_o => ota_tps_shd.g_old_rec.start_date
404: ,p_end_date_o => ota_tps_shd.g_old_rec.end_date
405: ,p_creator_person_id_o => ota_tps_shd.g_old_rec.creator_person_id
406: ,p_additional_member_flag_o => ota_tps_shd.g_old_rec.additional_member_flag
407: ,p_learning_path_id_o => ota_tps_shd.g_old_rec.learning_path_id
408: ,p_contact_id_o => ota_tps_shd.g_old_rec.contact_id
409: );

Line 406: ,p_additional_member_flag_o => ota_tps_shd.g_old_rec.additional_member_flag

402: ,p_plan_source_o => ota_tps_shd.g_old_rec.plan_source --changed
403: ,p_start_date_o => ota_tps_shd.g_old_rec.start_date
404: ,p_end_date_o => ota_tps_shd.g_old_rec.end_date
405: ,p_creator_person_id_o => ota_tps_shd.g_old_rec.creator_person_id
406: ,p_additional_member_flag_o => ota_tps_shd.g_old_rec.additional_member_flag
407: ,p_learning_path_id_o => ota_tps_shd.g_old_rec.learning_path_id
408: ,p_contact_id_o => ota_tps_shd.g_old_rec.contact_id
409: );
410: --

Line 407: ,p_learning_path_id_o => ota_tps_shd.g_old_rec.learning_path_id

403: ,p_start_date_o => ota_tps_shd.g_old_rec.start_date
404: ,p_end_date_o => ota_tps_shd.g_old_rec.end_date
405: ,p_creator_person_id_o => ota_tps_shd.g_old_rec.creator_person_id
406: ,p_additional_member_flag_o => ota_tps_shd.g_old_rec.additional_member_flag
407: ,p_learning_path_id_o => ota_tps_shd.g_old_rec.learning_path_id
408: ,p_contact_id_o => ota_tps_shd.g_old_rec.contact_id
409: );
410: --
411: EXCEPTION

Line 408: ,p_contact_id_o => ota_tps_shd.g_old_rec.contact_id

404: ,p_end_date_o => ota_tps_shd.g_old_rec.end_date
405: ,p_creator_person_id_o => ota_tps_shd.g_old_rec.creator_person_id
406: ,p_additional_member_flag_o => ota_tps_shd.g_old_rec.additional_member_flag
407: ,p_learning_path_id_o => ota_tps_shd.g_old_rec.learning_path_id
408: ,p_contact_id_o => ota_tps_shd.g_old_rec.contact_id
409: );
410: --
411: EXCEPTION
412: --

Line 468: (p_rec IN OUT NOCOPY ota_tps_shd.g_rec_type

464: --
465: -- {End Of Comments}
466: -- ----------------------------------------------------------------------------
467: PROCEDURE convert_defs
468: (p_rec IN OUT NOCOPY ota_tps_shd.g_rec_type
469: ) IS
470: --
471: BEGIN
472: --

Line 480: ota_tps_shd.g_old_rec.training_plan_id;

476: -- is being used then we must set to the 'current' argument value.
477: --
478: IF (p_rec.training_plan_id = hr_api.g_number) THEN
479: p_rec.training_plan_id :=
480: ota_tps_shd.g_old_rec.training_plan_id;
481: END IF;
482: IF (p_rec.time_period_id = hr_api.g_number) THEN
483: p_rec.time_period_id :=
484: ota_tps_shd.g_old_rec.time_period_id;

Line 484: ota_tps_shd.g_old_rec.time_period_id;

480: ota_tps_shd.g_old_rec.training_plan_id;
481: END IF;
482: IF (p_rec.time_period_id = hr_api.g_number) THEN
483: p_rec.time_period_id :=
484: ota_tps_shd.g_old_rec.time_period_id;
485: END IF;
486: IF (p_rec.plan_status_type_id = hr_api.g_varchar2) THEN
487: p_rec.plan_status_type_id :=
488: ota_tps_shd.g_old_rec.plan_status_type_id;

Line 488: ota_tps_shd.g_old_rec.plan_status_type_id;

484: ota_tps_shd.g_old_rec.time_period_id;
485: END IF;
486: IF (p_rec.plan_status_type_id = hr_api.g_varchar2) THEN
487: p_rec.plan_status_type_id :=
488: ota_tps_shd.g_old_rec.plan_status_type_id;
489: END IF;
490: IF (p_rec.organization_id = hr_api.g_number) THEN
491: p_rec.organization_id :=
492: ota_tps_shd.g_old_rec.organization_id;

Line 492: ota_tps_shd.g_old_rec.organization_id;

488: ota_tps_shd.g_old_rec.plan_status_type_id;
489: END IF;
490: IF (p_rec.organization_id = hr_api.g_number) THEN
491: p_rec.organization_id :=
492: ota_tps_shd.g_old_rec.organization_id;
493: END IF;
494: IF (p_rec.person_id = hr_api.g_number) THEN
495: p_rec.person_id :=
496: ota_tps_shd.g_old_rec.person_id;

Line 496: ota_tps_shd.g_old_rec.person_id;

492: ota_tps_shd.g_old_rec.organization_id;
493: END IF;
494: IF (p_rec.person_id = hr_api.g_number) THEN
495: p_rec.person_id :=
496: ota_tps_shd.g_old_rec.person_id;
497: END IF;
498: IF (p_rec.budget_currency = hr_api.g_varchar2) THEN
499: p_rec.budget_currency :=
500: ota_tps_shd.g_old_rec.budget_currency;

Line 500: ota_tps_shd.g_old_rec.budget_currency;

496: ota_tps_shd.g_old_rec.person_id;
497: END IF;
498: IF (p_rec.budget_currency = hr_api.g_varchar2) THEN
499: p_rec.budget_currency :=
500: ota_tps_shd.g_old_rec.budget_currency;
501: END IF;
502: IF (p_rec.name = hr_api.g_varchar2) THEN
503: p_rec.name :=
504: ota_tps_shd.g_old_rec.name;

Line 504: ota_tps_shd.g_old_rec.name;

500: ota_tps_shd.g_old_rec.budget_currency;
501: END IF;
502: IF (p_rec.name = hr_api.g_varchar2) THEN
503: p_rec.name :=
504: ota_tps_shd.g_old_rec.name;
505: END IF;
506: IF (p_rec.description = hr_api.g_varchar2) THEN
507: p_rec.description :=
508: ota_tps_shd.g_old_rec.description;

Line 508: ota_tps_shd.g_old_rec.description;

504: ota_tps_shd.g_old_rec.name;
505: END IF;
506: IF (p_rec.description = hr_api.g_varchar2) THEN
507: p_rec.description :=
508: ota_tps_shd.g_old_rec.description;
509: END IF;
510: IF (p_rec.business_group_id = hr_api.g_number) THEN
511: p_rec.business_group_id :=
512: ota_tps_shd.g_old_rec.business_group_id;

Line 512: ota_tps_shd.g_old_rec.business_group_id;

508: ota_tps_shd.g_old_rec.description;
509: END IF;
510: IF (p_rec.business_group_id = hr_api.g_number) THEN
511: p_rec.business_group_id :=
512: ota_tps_shd.g_old_rec.business_group_id;
513: END IF;
514: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
515: p_rec.attribute_category :=
516: ota_tps_shd.g_old_rec.attribute_category;

Line 516: ota_tps_shd.g_old_rec.attribute_category;

512: ota_tps_shd.g_old_rec.business_group_id;
513: END IF;
514: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
515: p_rec.attribute_category :=
516: ota_tps_shd.g_old_rec.attribute_category;
517: END IF;
518: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
519: p_rec.attribute1 :=
520: ota_tps_shd.g_old_rec.attribute1;

Line 520: ota_tps_shd.g_old_rec.attribute1;

516: ota_tps_shd.g_old_rec.attribute_category;
517: END IF;
518: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
519: p_rec.attribute1 :=
520: ota_tps_shd.g_old_rec.attribute1;
521: END IF;
522: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
523: p_rec.attribute2 :=
524: ota_tps_shd.g_old_rec.attribute2;

Line 524: ota_tps_shd.g_old_rec.attribute2;

520: ota_tps_shd.g_old_rec.attribute1;
521: END IF;
522: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
523: p_rec.attribute2 :=
524: ota_tps_shd.g_old_rec.attribute2;
525: END IF;
526: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
527: p_rec.attribute3 :=
528: ota_tps_shd.g_old_rec.attribute3;

Line 528: ota_tps_shd.g_old_rec.attribute3;

524: ota_tps_shd.g_old_rec.attribute2;
525: END IF;
526: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
527: p_rec.attribute3 :=
528: ota_tps_shd.g_old_rec.attribute3;
529: END IF;
530: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
531: p_rec.attribute4 :=
532: ota_tps_shd.g_old_rec.attribute4;

Line 532: ota_tps_shd.g_old_rec.attribute4;

528: ota_tps_shd.g_old_rec.attribute3;
529: END IF;
530: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
531: p_rec.attribute4 :=
532: ota_tps_shd.g_old_rec.attribute4;
533: END IF;
534: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
535: p_rec.attribute5 :=
536: ota_tps_shd.g_old_rec.attribute5;

Line 536: ota_tps_shd.g_old_rec.attribute5;

532: ota_tps_shd.g_old_rec.attribute4;
533: END IF;
534: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
535: p_rec.attribute5 :=
536: ota_tps_shd.g_old_rec.attribute5;
537: END IF;
538: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
539: p_rec.attribute6 :=
540: ota_tps_shd.g_old_rec.attribute6;

Line 540: ota_tps_shd.g_old_rec.attribute6;

536: ota_tps_shd.g_old_rec.attribute5;
537: END IF;
538: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
539: p_rec.attribute6 :=
540: ota_tps_shd.g_old_rec.attribute6;
541: END IF;
542: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
543: p_rec.attribute7 :=
544: ota_tps_shd.g_old_rec.attribute7;

Line 544: ota_tps_shd.g_old_rec.attribute7;

540: ota_tps_shd.g_old_rec.attribute6;
541: END IF;
542: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
543: p_rec.attribute7 :=
544: ota_tps_shd.g_old_rec.attribute7;
545: END IF;
546: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
547: p_rec.attribute8 :=
548: ota_tps_shd.g_old_rec.attribute8;

Line 548: ota_tps_shd.g_old_rec.attribute8;

544: ota_tps_shd.g_old_rec.attribute7;
545: END IF;
546: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
547: p_rec.attribute8 :=
548: ota_tps_shd.g_old_rec.attribute8;
549: END IF;
550: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
551: p_rec.attribute9 :=
552: ota_tps_shd.g_old_rec.attribute9;

Line 552: ota_tps_shd.g_old_rec.attribute9;

548: ota_tps_shd.g_old_rec.attribute8;
549: END IF;
550: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
551: p_rec.attribute9 :=
552: ota_tps_shd.g_old_rec.attribute9;
553: END IF;
554: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
555: p_rec.attribute10 :=
556: ota_tps_shd.g_old_rec.attribute10;

Line 556: ota_tps_shd.g_old_rec.attribute10;

552: ota_tps_shd.g_old_rec.attribute9;
553: END IF;
554: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
555: p_rec.attribute10 :=
556: ota_tps_shd.g_old_rec.attribute10;
557: END IF;
558: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
559: p_rec.attribute11 :=
560: ota_tps_shd.g_old_rec.attribute11;

Line 560: ota_tps_shd.g_old_rec.attribute11;

556: ota_tps_shd.g_old_rec.attribute10;
557: END IF;
558: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
559: p_rec.attribute11 :=
560: ota_tps_shd.g_old_rec.attribute11;
561: END IF;
562: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
563: p_rec.attribute12 :=
564: ota_tps_shd.g_old_rec.attribute12;

Line 564: ota_tps_shd.g_old_rec.attribute12;

560: ota_tps_shd.g_old_rec.attribute11;
561: END IF;
562: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
563: p_rec.attribute12 :=
564: ota_tps_shd.g_old_rec.attribute12;
565: END IF;
566: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
567: p_rec.attribute13 :=
568: ota_tps_shd.g_old_rec.attribute13;

Line 568: ota_tps_shd.g_old_rec.attribute13;

564: ota_tps_shd.g_old_rec.attribute12;
565: END IF;
566: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
567: p_rec.attribute13 :=
568: ota_tps_shd.g_old_rec.attribute13;
569: END IF;
570: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
571: p_rec.attribute14 :=
572: ota_tps_shd.g_old_rec.attribute14;

Line 572: ota_tps_shd.g_old_rec.attribute14;

568: ota_tps_shd.g_old_rec.attribute13;
569: END IF;
570: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
571: p_rec.attribute14 :=
572: ota_tps_shd.g_old_rec.attribute14;
573: END IF;
574: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
575: p_rec.attribute15 :=
576: ota_tps_shd.g_old_rec.attribute15;

Line 576: ota_tps_shd.g_old_rec.attribute15;

572: ota_tps_shd.g_old_rec.attribute14;
573: END IF;
574: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
575: p_rec.attribute15 :=
576: ota_tps_shd.g_old_rec.attribute15;
577: END IF;
578: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
579: p_rec.attribute16 :=
580: ota_tps_shd.g_old_rec.attribute16;

Line 580: ota_tps_shd.g_old_rec.attribute16;

576: ota_tps_shd.g_old_rec.attribute15;
577: END IF;
578: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
579: p_rec.attribute16 :=
580: ota_tps_shd.g_old_rec.attribute16;
581: END IF;
582: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
583: p_rec.attribute17 :=
584: ota_tps_shd.g_old_rec.attribute17;

Line 584: ota_tps_shd.g_old_rec.attribute17;

580: ota_tps_shd.g_old_rec.attribute16;
581: END IF;
582: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
583: p_rec.attribute17 :=
584: ota_tps_shd.g_old_rec.attribute17;
585: END IF;
586: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
587: p_rec.attribute18 :=
588: ota_tps_shd.g_old_rec.attribute18;

Line 588: ota_tps_shd.g_old_rec.attribute18;

584: ota_tps_shd.g_old_rec.attribute17;
585: END IF;
586: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
587: p_rec.attribute18 :=
588: ota_tps_shd.g_old_rec.attribute18;
589: END IF;
590: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
591: p_rec.attribute19 :=
592: ota_tps_shd.g_old_rec.attribute19;

Line 592: ota_tps_shd.g_old_rec.attribute19;

588: ota_tps_shd.g_old_rec.attribute18;
589: END IF;
590: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
591: p_rec.attribute19 :=
592: ota_tps_shd.g_old_rec.attribute19;
593: END IF;
594: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
595: p_rec.attribute20 :=
596: ota_tps_shd.g_old_rec.attribute20;

Line 596: ota_tps_shd.g_old_rec.attribute20;

592: ota_tps_shd.g_old_rec.attribute19;
593: END IF;
594: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
595: p_rec.attribute20 :=
596: ota_tps_shd.g_old_rec.attribute20;
597: END IF;
598: IF (p_rec.attribute21 = hr_api.g_varchar2) THEN
599: p_rec.attribute21 :=
600: ota_tps_shd.g_old_rec.attribute21;

Line 600: ota_tps_shd.g_old_rec.attribute21;

596: ota_tps_shd.g_old_rec.attribute20;
597: END IF;
598: IF (p_rec.attribute21 = hr_api.g_varchar2) THEN
599: p_rec.attribute21 :=
600: ota_tps_shd.g_old_rec.attribute21;
601: END IF;
602: IF (p_rec.attribute22 = hr_api.g_varchar2) THEN
603: p_rec.attribute22 :=
604: ota_tps_shd.g_old_rec.attribute22;

Line 604: ota_tps_shd.g_old_rec.attribute22;

600: ota_tps_shd.g_old_rec.attribute21;
601: END IF;
602: IF (p_rec.attribute22 = hr_api.g_varchar2) THEN
603: p_rec.attribute22 :=
604: ota_tps_shd.g_old_rec.attribute22;
605: END IF;
606: IF (p_rec.attribute23 = hr_api.g_varchar2) THEN
607: p_rec.attribute23 :=
608: ota_tps_shd.g_old_rec.attribute23;

Line 608: ota_tps_shd.g_old_rec.attribute23;

604: ota_tps_shd.g_old_rec.attribute22;
605: END IF;
606: IF (p_rec.attribute23 = hr_api.g_varchar2) THEN
607: p_rec.attribute23 :=
608: ota_tps_shd.g_old_rec.attribute23;
609: END IF;
610: IF (p_rec.attribute24 = hr_api.g_varchar2) THEN
611: p_rec.attribute24 :=
612: ota_tps_shd.g_old_rec.attribute24;

Line 612: ota_tps_shd.g_old_rec.attribute24;

608: ota_tps_shd.g_old_rec.attribute23;
609: END IF;
610: IF (p_rec.attribute24 = hr_api.g_varchar2) THEN
611: p_rec.attribute24 :=
612: ota_tps_shd.g_old_rec.attribute24;
613: END IF;
614: IF (p_rec.attribute25 = hr_api.g_varchar2) THEN
615: p_rec.attribute25 :=
616: ota_tps_shd.g_old_rec.attribute25;

Line 616: ota_tps_shd.g_old_rec.attribute25;

612: ota_tps_shd.g_old_rec.attribute24;
613: END IF;
614: IF (p_rec.attribute25 = hr_api.g_varchar2) THEN
615: p_rec.attribute25 :=
616: ota_tps_shd.g_old_rec.attribute25;
617: END IF;
618: IF (p_rec.attribute26 = hr_api.g_varchar2) THEN
619: p_rec.attribute26 :=
620: ota_tps_shd.g_old_rec.attribute26;

Line 620: ota_tps_shd.g_old_rec.attribute26;

616: ota_tps_shd.g_old_rec.attribute25;
617: END IF;
618: IF (p_rec.attribute26 = hr_api.g_varchar2) THEN
619: p_rec.attribute26 :=
620: ota_tps_shd.g_old_rec.attribute26;
621: END IF;
622: IF (p_rec.attribute27 = hr_api.g_varchar2) THEN
623: p_rec.attribute27 :=
624: ota_tps_shd.g_old_rec.attribute27;

Line 624: ota_tps_shd.g_old_rec.attribute27;

620: ota_tps_shd.g_old_rec.attribute26;
621: END IF;
622: IF (p_rec.attribute27 = hr_api.g_varchar2) THEN
623: p_rec.attribute27 :=
624: ota_tps_shd.g_old_rec.attribute27;
625: END IF;
626: IF (p_rec.attribute28 = hr_api.g_varchar2) THEN
627: p_rec.attribute28 :=
628: ota_tps_shd.g_old_rec.attribute28;

Line 628: ota_tps_shd.g_old_rec.attribute28;

624: ota_tps_shd.g_old_rec.attribute27;
625: END IF;
626: IF (p_rec.attribute28 = hr_api.g_varchar2) THEN
627: p_rec.attribute28 :=
628: ota_tps_shd.g_old_rec.attribute28;
629: END IF;
630: IF (p_rec.attribute29 = hr_api.g_varchar2) THEN
631: p_rec.attribute29 :=
632: ota_tps_shd.g_old_rec.attribute29;

Line 632: ota_tps_shd.g_old_rec.attribute29;

628: ota_tps_shd.g_old_rec.attribute28;
629: END IF;
630: IF (p_rec.attribute29 = hr_api.g_varchar2) THEN
631: p_rec.attribute29 :=
632: ota_tps_shd.g_old_rec.attribute29;
633: END IF;
634: IF (p_rec.attribute30 = hr_api.g_varchar2) THEN
635: p_rec.attribute30 :=
636: ota_tps_shd.g_old_rec.attribute30;

Line 636: ota_tps_shd.g_old_rec.attribute30;

632: ota_tps_shd.g_old_rec.attribute29;
633: END IF;
634: IF (p_rec.attribute30 = hr_api.g_varchar2) THEN
635: p_rec.attribute30 :=
636: ota_tps_shd.g_old_rec.attribute30;
637: END IF;
638: IF (p_rec.plan_source = hr_api.g_varchar2) THEN --cahnged
639: p_rec.plan_source :=
640: ota_tps_shd.g_old_rec.plan_source;

Line 640: ota_tps_shd.g_old_rec.plan_source;

636: ota_tps_shd.g_old_rec.attribute30;
637: END IF;
638: IF (p_rec.plan_source = hr_api.g_varchar2) THEN --cahnged
639: p_rec.plan_source :=
640: ota_tps_shd.g_old_rec.plan_source;
641: END IF;
642: IF (p_rec.start_date = hr_api.g_date) THEN
643: p_rec.start_date :=
644: ota_tps_shd.g_old_rec.start_date;

Line 644: ota_tps_shd.g_old_rec.start_date;

640: ota_tps_shd.g_old_rec.plan_source;
641: END IF;
642: IF (p_rec.start_date = hr_api.g_date) THEN
643: p_rec.start_date :=
644: ota_tps_shd.g_old_rec.start_date;
645: END IF;
646: IF (p_rec.end_date = hr_api.g_date) THEN
647: p_rec.end_date :=
648: ota_tps_shd.g_old_rec.end_date;

Line 648: ota_tps_shd.g_old_rec.end_date;

644: ota_tps_shd.g_old_rec.start_date;
645: END IF;
646: IF (p_rec.end_date = hr_api.g_date) THEN
647: p_rec.end_date :=
648: ota_tps_shd.g_old_rec.end_date;
649: END IF;
650: IF (p_rec.creator_person_id = hr_api.g_number) THEN
651: p_rec.creator_person_id :=
652: ota_tps_shd.g_old_rec.creator_person_id;

Line 652: ota_tps_shd.g_old_rec.creator_person_id;

648: ota_tps_shd.g_old_rec.end_date;
649: END IF;
650: IF (p_rec.creator_person_id = hr_api.g_number) THEN
651: p_rec.creator_person_id :=
652: ota_tps_shd.g_old_rec.creator_person_id;
653: END IF;
654: IF (p_rec.additional_member_flag = hr_api.g_varchar2) THEN --cahnged
655: p_rec.additional_member_flag :=
656: ota_tps_shd.g_old_rec.additional_member_flag;

Line 656: ota_tps_shd.g_old_rec.additional_member_flag;

652: ota_tps_shd.g_old_rec.creator_person_id;
653: END IF;
654: IF (p_rec.additional_member_flag = hr_api.g_varchar2) THEN --cahnged
655: p_rec.additional_member_flag :=
656: ota_tps_shd.g_old_rec.additional_member_flag;
657: END IF;
658: IF (p_rec.learning_path_id = hr_api.g_number) THEN --new
659: p_rec.learning_path_id :=
660: ota_tps_shd.g_old_rec.learning_path_id;

Line 660: ota_tps_shd.g_old_rec.learning_path_id;

656: ota_tps_shd.g_old_rec.additional_member_flag;
657: END IF;
658: IF (p_rec.learning_path_id = hr_api.g_number) THEN --new
659: p_rec.learning_path_id :=
660: ota_tps_shd.g_old_rec.learning_path_id;
661: END IF;
662: IF (p_rec.contact_id = hr_api.g_number) THEN --new
663: p_rec.contact_id :=
664: ota_tps_shd.g_old_rec.contact_id;

Line 664: ota_tps_shd.g_old_rec.contact_id;

660: ota_tps_shd.g_old_rec.learning_path_id;
661: END IF;
662: IF (p_rec.contact_id = hr_api.g_number) THEN --new
663: p_rec.contact_id :=
664: ota_tps_shd.g_old_rec.contact_id;
665: END IF;
666: --
667: END convert_defs;
668: --

Line 674: ,p_rec IN OUT NOCOPY ota_tps_shd.g_rec_type

670: -- |---------------------------------< upd >----------------------------------|
671: -- ----------------------------------------------------------------------------
672: PROCEDURE upd
673: (p_effective_date IN date
674: ,p_rec IN OUT NOCOPY ota_tps_shd.g_rec_type
675: ) IS
676: --
677: l_proc varchar2(72) := g_package||'upd';
678: --

Line 684: ota_tps_shd.lck

680: hr_utility.set_location('Entering:'||l_proc, 5);
681: --
682: -- We must lock the row which we need to update.
683: --
684: ota_tps_shd.lck
685: (p_rec.training_plan_id
686: ,p_rec.object_version_number
687: );
688: --

Line 777: l_rec ota_tps_shd.g_rec_type;

773: ,p_learning_path_id IN number DEFAULT hr_api.g_number
774: ,p_contact_id IN number DEFAULT hr_api.g_number
775: ) IS
776: --
777: l_rec ota_tps_shd.g_rec_type;
778: l_proc varchar2(72) := g_package||'upd';
779: --
780: BEGIN
781: hr_utility.set_location('Entering:'||l_proc, 5);

Line 787: ota_tps_shd.convert_args

783: -- Call conversion function to turn arguments into the
784: -- l_rec structure.
785: --
786: l_rec :=
787: ota_tps_shd.convert_args
788: (p_training_plan_id
789: ,p_time_period_id
790: ,p_plan_status_type_id
791: ,hr_api.g_number