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_BUS1 dependencies on OTA_TRAINING_PLANS

Line 15: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

11: -- |---------------------------------------------------------------|
12: -- ----------------------------------------------------------------------------
13: --
14: PROCEDURE chk_unique
15: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
16: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
17: ,p_organization_id IN ota_training_plans.organization_id%TYPE
18: ,p_person_id IN ota_training_plans.person_id%TYPE
19: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE

Line 16: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE

12: -- ----------------------------------------------------------------------------
13: --
14: PROCEDURE chk_unique
15: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
16: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
17: ,p_organization_id IN ota_training_plans.organization_id%TYPE
18: ,p_person_id IN ota_training_plans.person_id%TYPE
19: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
20: ) IS

Line 17: ,p_organization_id IN ota_training_plans.organization_id%TYPE

13: --
14: PROCEDURE chk_unique
15: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
16: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
17: ,p_organization_id IN ota_training_plans.organization_id%TYPE
18: ,p_person_id IN ota_training_plans.person_id%TYPE
19: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
20: ) IS
21: --

Line 18: ,p_person_id IN ota_training_plans.person_id%TYPE

14: PROCEDURE chk_unique
15: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
16: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
17: ,p_organization_id IN ota_training_plans.organization_id%TYPE
18: ,p_person_id IN ota_training_plans.person_id%TYPE
19: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
20: ) IS
21: --
22: l_proc varchar2(72) := g_package|| 'chk_unique';

Line 19: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE

15: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
16: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
17: ,p_organization_id IN ota_training_plans.organization_id%TYPE
18: ,p_person_id IN ota_training_plans.person_id%TYPE
19: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
20: ) IS
21: --
22: l_proc varchar2(72) := g_package|| 'chk_unique';
23: l_exists varchar2(1);

Line 28: FROM OTA_TRAINING_PLANS

24: l_api_updating boolean;
25: --
26: CURSOR csr_unique IS
27: SELECT NULL
28: FROM OTA_TRAINING_PLANS
29: WHERE training_plan_id <> NVL(p_training_plan_id, -1)
30: AND ( (p_organization_id IS NOT NULL AND organization_id = p_organization_id )
31: OR (p_person_id IS NOT NULL AND person_id = p_person_id) )
32: AND time_period_id = p_time_period_id;

Line 42: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'

38: --
39: hr_utility.set_location(' Step:'|| l_proc, 45);
40:
41: IF hr_multi_message.no_exclusive_error
42: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
43: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
44: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
45: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
46: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'

Line 43: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'

39: hr_utility.set_location(' Step:'|| l_proc, 45);
40:
41: IF hr_multi_message.no_exclusive_error
42: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
43: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
44: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
45: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
46: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
47: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'

Line 44: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'

40:
41: IF hr_multi_message.no_exclusive_error
42: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
43: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
44: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
45: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
46: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
47: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
48: ) THEN

Line 45: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'

41: IF hr_multi_message.no_exclusive_error
42: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
43: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
44: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
45: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
46: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
47: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
48: ) THEN
49:

Line 46: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'

42: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
43: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
44: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
45: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
46: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
47: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
48: ) THEN
49:
50: hr_api.mandatory_arg_error

Line 47: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'

43: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
44: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
45: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
46: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
47: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
48: ) THEN
49:
50: hr_api.mandatory_arg_error
51: (p_api_name => l_proc

Line 110: (p_organization_id IN ota_training_plans.organization_id%TYPE

106: -- |----------------------------------------------------------|
107: -- ----------------------------------------------------------------------------
108: --
109: PROCEDURE chk_org_person
110: (p_organization_id IN ota_training_plans.organization_id%TYPE
111: ,p_person_id IN ota_training_plans.person_id%TYPE
112: ,p_contact_id IN ota_training_plans.contact_id%TYPE
113: ) IS
114: --

Line 111: ,p_person_id IN ota_training_plans.person_id%TYPE

107: -- ----------------------------------------------------------------------------
108: --
109: PROCEDURE chk_org_person
110: (p_organization_id IN ota_training_plans.organization_id%TYPE
111: ,p_person_id IN ota_training_plans.person_id%TYPE
112: ,p_contact_id IN ota_training_plans.contact_id%TYPE
113: ) IS
114: --
115: l_proc varchar2(72) := g_package|| 'chk_org_person';

Line 112: ,p_contact_id IN ota_training_plans.contact_id%TYPE

108: --
109: PROCEDURE chk_org_person
110: (p_organization_id IN ota_training_plans.organization_id%TYPE
111: ,p_person_id IN ota_training_plans.person_id%TYPE
112: ,p_contact_id IN ota_training_plans.contact_id%TYPE
113: ) IS
114: --
115: l_proc varchar2(72) := g_package|| 'chk_org_person';
116: --

Line 141: p_associated_column1 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'

137:
138: WHEN app_exception.application_exception THEN
139:
140: IF hr_multi_message.exception_add(
141: p_associated_column1 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
142: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
143: ,p_associated_column3 => 'OTA_TRAINING_PLANS.CONTACT_ID') THEN
144:
145: hr_utility.set_location(' Leaving:'||l_proc, 22);

Line 142: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'

138: WHEN app_exception.application_exception THEN
139:
140: IF hr_multi_message.exception_add(
141: p_associated_column1 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
142: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
143: ,p_associated_column3 => 'OTA_TRAINING_PLANS.CONTACT_ID') THEN
144:
145: hr_utility.set_location(' Leaving:'||l_proc, 22);
146: RAISE;

Line 143: ,p_associated_column3 => 'OTA_TRAINING_PLANS.CONTACT_ID') THEN

139:
140: IF hr_multi_message.exception_add(
141: p_associated_column1 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
142: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
143: ,p_associated_column3 => 'OTA_TRAINING_PLANS.CONTACT_ID') THEN
144:
145: hr_utility.set_location(' Leaving:'||l_proc, 22);
146: RAISE;
147:

Line 157: (p_organization_id IN ota_training_plans.organization_id%TYPE

153: -- |-----------------------------------------------------|
154: -- ----------------------------------------------------------------------------
155: --
156: PROCEDURE chk_organization_id
157: (p_organization_id IN ota_training_plans.organization_id%TYPE
158: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
159: ) IS
160: --
161: l_exists varchar2(1);

Line 158: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

154: -- ----------------------------------------------------------------------------
155: --
156: PROCEDURE chk_organization_id
157: (p_organization_id IN ota_training_plans.organization_id%TYPE
158: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
159: ) IS
160: --
161: l_exists varchar2(1);
162: l_proc varchar2(72) := g_package|| 'chk_organization_id';

Line 163: l_business_group_id ota_training_plans.business_group_id%TYPE;

159: ) IS
160: --
161: l_exists varchar2(1);
162: l_proc varchar2(72) := g_package|| 'chk_organization_id';
163: l_business_group_id ota_training_plans.business_group_id%TYPE;
164: --
165: CURSOR csr_organization_id IS
166: SELECT business_group_id
167: FROM HR_ALL_ORGANIZATION_UNITS

Line 206: p_associated_column1 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID') THEN

202:
203: WHEN app_exception.application_exception THEN
204:
205: IF hr_multi_message.exception_add(
206: p_associated_column1 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID') THEN
207:
208: hr_utility.set_location(' Leaving:'||l_proc, 52);
209: RAISE;
210:

Line 223: ,p_person_id IN ota_training_plans.person_id%TYPE

219: -- ----------------------------------------------------------------------------
220: --
221: PROCEDURE chk_person_id
222: (p_effective_date IN date
223: ,p_person_id IN ota_training_plans.person_id%TYPE
224: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
225: ) IS
226: --
227: l_exists varchar2(1);

Line 224: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

220: --
221: PROCEDURE chk_person_id
222: (p_effective_date IN date
223: ,p_person_id IN ota_training_plans.person_id%TYPE
224: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
225: ) IS
226: --
227: l_exists varchar2(1);
228: l_proc varchar2(72) := g_package|| 'chk_person_id';

Line 229: l_business_group_id ota_training_plans.business_group_id%TYPE;

225: ) IS
226: --
227: l_exists varchar2(1);
228: l_proc varchar2(72) := g_package|| 'chk_person_id';
229: l_business_group_id ota_training_plans.business_group_id%TYPE;
230: --
231: CURSOR csr_person_id IS
232: SELECT business_group_id
233: FROM PER_ALL_PEOPLE_F

Line 276: p_associated_column1 => 'OTA_TRAINING_PLANS.PERSON_ID') THEN

272:
273: WHEN app_exception.application_exception THEN
274:
275: IF hr_multi_message.exception_add(
276: p_associated_column1 => 'OTA_TRAINING_PLANS.PERSON_ID') THEN
277:
278: hr_utility.set_location(' Leaving:'||l_proc, 52);
279: RAISE;
280:

Line 290: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

286: -- |-------------------------------------------------------|
287: -- ----------------------------------------------------------------------------
288: --
289: PROCEDURE chk_time_period_id
290: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
291: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
292: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
293: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
294: ) IS

Line 291: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE

287: -- ----------------------------------------------------------------------------
288: --
289: PROCEDURE chk_time_period_id
290: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
291: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
292: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
293: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
294: ) IS
295: --

Line 292: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE

288: --
289: PROCEDURE chk_time_period_id
290: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
291: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
292: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
293: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
294: ) IS
295: --
296: l_exists varchar2(1);

Line 293: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

289: PROCEDURE chk_time_period_id
290: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
291: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
292: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
293: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
294: ) IS
295: --
296: l_exists varchar2(1);
297: l_proc varchar2(72) := g_package|| 'chk_time_period_id';

Line 375: p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID') THEN

371:
372: WHEN app_exception.application_exception THEN
373:
374: IF hr_multi_message.exception_add(
375: p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID') THEN
376:
377: hr_utility.set_location(' Leaving:'||l_proc, 62);
378: RAISE;
379:

Line 391: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE

387: -- ----------------------------------------------------------------------------
388: --
389: PROCEDURE chk_plan_status_type_id
390: (p_effective_date IN date
391: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
392: ) IS
393: --
394: l_proc varchar2(72) := g_package|| 'chk_plan_status_type_id';
395: --

Line 432: p_associated_column1 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID') THEN

428:
429: WHEN app_exception.application_exception THEN
430:
431: IF hr_multi_message.exception_add(
432: p_associated_column1 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID') THEN
433:
434: hr_utility.set_location(' Leaving:'||l_proc, 32);
435: RAISE;
436:

Line 446: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

442: -- |-------------------------------------------------------|
443: -- ----------------------------------------------------------------------------
444: --
445: PROCEDURE chk_period_overlap
446: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
447: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
448: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
449: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
450: ,p_person_id IN ota_training_plans.person_id%TYPE

Line 447: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE

443: -- ----------------------------------------------------------------------------
444: --
445: PROCEDURE chk_period_overlap
446: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
447: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
448: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
449: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
450: ,p_person_id IN ota_training_plans.person_id%TYPE
451: ,p_organization_id IN ota_training_plans.organization_id%TYPE

Line 448: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE

444: --
445: PROCEDURE chk_period_overlap
446: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
447: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
448: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
449: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
450: ,p_person_id IN ota_training_plans.person_id%TYPE
451: ,p_organization_id IN ota_training_plans.organization_id%TYPE
452: ) IS

Line 449: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE

445: PROCEDURE chk_period_overlap
446: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
447: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
448: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
449: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
450: ,p_person_id IN ota_training_plans.person_id%TYPE
451: ,p_organization_id IN ota_training_plans.organization_id%TYPE
452: ) IS
453: --

Line 450: ,p_person_id IN ota_training_plans.person_id%TYPE

446: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
447: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
448: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
449: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
450: ,p_person_id IN ota_training_plans.person_id%TYPE
451: ,p_organization_id IN ota_training_plans.organization_id%TYPE
452: ) IS
453: --
454: l_exists varchar2(1);

Line 451: ,p_organization_id IN ota_training_plans.organization_id%TYPE

447: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
448: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
449: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
450: ,p_person_id IN ota_training_plans.person_id%TYPE
451: ,p_organization_id IN ota_training_plans.organization_id%TYPE
452: ) IS
453: --
454: l_exists varchar2(1);
455: l_proc varchar2(72) := g_package|| 'chk_period_overlap';

Line 469: ,OTA_TRAINING_PLANS tps

465: --
466: CURSOR csr_plan_overlap IS
467: SELECT NULL
468: FROM PER_TIME_PERIODS ptp
469: ,OTA_TRAINING_PLANS tps
470: WHERE ( (p_person_id IS NOT NULL AND tps.person_id = p_person_id )
471: OR (p_organization_id IS NOT NULL AND tps.organization_id = p_organization_id) )
472: AND (NVL(p_training_plan_id, -1) <> training_plan_id)
473: AND tps.plan_status_type_id <> 'CANCELLED'

Line 499: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'

495:
496: --MULTI MESSAGE SUPPORT
497:
498: IF hr_multi_message.no_exclusive_error
499: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
500: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
501: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
502: ,p_check_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
503: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'

Line 500: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'

496: --MULTI MESSAGE SUPPORT
497:
498: IF hr_multi_message.no_exclusive_error
499: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
500: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
501: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
502: ,p_check_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
503: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
504: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'

Line 501: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'

497:
498: IF hr_multi_message.no_exclusive_error
499: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
500: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
501: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
502: ,p_check_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
503: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
504: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
505: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'

Line 502: ,p_check_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'

498: IF hr_multi_message.no_exclusive_error
499: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
500: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
501: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
502: ,p_check_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
503: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
504: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
505: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
506: ,p_associated_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'

Line 503: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'

499: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
500: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
501: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
502: ,p_check_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
503: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
504: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
505: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
506: ,p_associated_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
507: ) THEN

Line 504: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'

500: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
501: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
502: ,p_check_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
503: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
504: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
505: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
506: ,p_associated_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
507: ) THEN
508:

Line 505: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'

501: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
502: ,p_check_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
503: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
504: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
505: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
506: ,p_associated_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
507: ) THEN
508:
509: hr_api.mandatory_arg_error

Line 506: ,p_associated_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'

502: ,p_check_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
503: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
504: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
505: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
506: ,p_associated_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
507: ) THEN
508:
509: hr_api.mandatory_arg_error
510: (p_api_name => l_proc

Line 590: ( p_budget_currency IN ota_training_plans.budget_currency%TYPE

586: -- |-------------------------------------------------------|
587: -- ----------------------------------------------------------------------------
588: --
589: PROCEDURE chk_currency_code
590: ( p_budget_currency IN ota_training_plans.budget_currency%TYPE
591: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
592: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
593: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
594: )IS

Line 591: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

587: -- ----------------------------------------------------------------------------
588: --
589: PROCEDURE chk_currency_code
590: ( p_budget_currency IN ota_training_plans.budget_currency%TYPE
591: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
592: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
593: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
594: )IS
595: --

Line 592: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

588: --
589: PROCEDURE chk_currency_code
590: ( p_budget_currency IN ota_training_plans.budget_currency%TYPE
591: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
592: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
593: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
594: )IS
595: --
596: l_exists varchar2(1);

Line 593: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE

589: PROCEDURE chk_currency_code
590: ( p_budget_currency IN ota_training_plans.budget_currency%TYPE
591: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
592: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
593: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
594: )IS
595: --
596: l_exists varchar2(1);
597: l_proc varchar2(72) := g_package|| 'chk_currency_value';

Line 659: p_associated_column1 => 'OTA_TRAINING_PLANS.BUDGET_CURRENCY') THEN

655:
656: WHEN app_exception.application_exception THEN
657:
658: IF hr_multi_message.exception_add(
659: p_associated_column1 => 'OTA_TRAINING_PLANS.BUDGET_CURRENCY') THEN
660:
661: hr_utility.set_location(' Leaving:'||l_proc, 92);
662: RAISE;
663:

Line 674: (p_name IN ota_training_plans.name%TYPE

670: -- ----------------------------------------------------------------------------
671: -- |-----------------------------------------------------------------|
672: -- ----------------------------------------------------------------------------
673: PROCEDURE chk_name
674: (p_name IN ota_training_plans.name%TYPE
675: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
676: ,p_person_id IN ota_training_plans.person_id%TYPE
677: ,p_contact_id IN ota_training_plans.contact_id%TYPE
678: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

Line 675: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

671: -- |-----------------------------------------------------------------|
672: -- ----------------------------------------------------------------------------
673: PROCEDURE chk_name
674: (p_name IN ota_training_plans.name%TYPE
675: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
676: ,p_person_id IN ota_training_plans.person_id%TYPE
677: ,p_contact_id IN ota_training_plans.contact_id%TYPE
678: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
679: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE ) IS

Line 676: ,p_person_id IN ota_training_plans.person_id%TYPE

672: -- ----------------------------------------------------------------------------
673: PROCEDURE chk_name
674: (p_name IN ota_training_plans.name%TYPE
675: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
676: ,p_person_id IN ota_training_plans.person_id%TYPE
677: ,p_contact_id IN ota_training_plans.contact_id%TYPE
678: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
679: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE ) IS
680: --

Line 677: ,p_contact_id IN ota_training_plans.contact_id%TYPE

673: PROCEDURE chk_name
674: (p_name IN ota_training_plans.name%TYPE
675: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
676: ,p_person_id IN ota_training_plans.person_id%TYPE
677: ,p_contact_id IN ota_training_plans.contact_id%TYPE
678: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
679: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE ) IS
680: --
681: l_proc varchar2(72) := g_package||'chk_name';

Line 678: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

674: (p_name IN ota_training_plans.name%TYPE
675: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
676: ,p_person_id IN ota_training_plans.person_id%TYPE
677: ,p_contact_id IN ota_training_plans.contact_id%TYPE
678: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
679: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE ) IS
680: --
681: l_proc varchar2(72) := g_package||'chk_name';
682: l_api_updating boolean;

Line 679: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE ) IS

675: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
676: ,p_person_id IN ota_training_plans.person_id%TYPE
677: ,p_contact_id IN ota_training_plans.contact_id%TYPE
678: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
679: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE ) IS
680: --
681: l_proc varchar2(72) := g_package||'chk_name';
682: l_api_updating boolean;
683: l_exists varchar2(1);

Line 687: FROM OTA_TRAINING_PLANS

683: l_exists varchar2(1);
684: --
685: CURSOR csr_name IS
686: SELECT NULL
687: FROM OTA_TRAINING_PLANS
688: WHERE NVL(p_training_plan_id, -1) <> training_plan_id
689: AND name = p_name
690: AND business_group_id = p_business_group_id;
691: --

Line 695: FROM OTA_TRAINING_PLANS

691: --
692: --Bug#3484692
693: CURSOR csr_plp_name IS
694: SELECT NULL
695: FROM OTA_TRAINING_PLANS
696: WHERE NVL(p_training_plan_id, -1) <> training_plan_id
697: AND name = p_name
698: -- Modified for bug#3855813
699: AND ((p_person_id IS NOT NULL AND person_id = p_person_id)

Line 764: p_associated_column1 => 'OTA_TRAINING_PLANS.NAME') THEN

760:
761: WHEN app_exception.application_exception THEN
762:
763: IF hr_multi_message.exception_add(
764: p_associated_column1 => 'OTA_TRAINING_PLANS.NAME') THEN
765:
766: hr_utility.set_location(' Leaving:'||l_proc, 12);
767: RAISE;
768:

Line 777: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

773: -- ----------------------------------------------------------------------------
774: -- |-------------------------------------------------|
775: -- ----------------------------------------------------------------------------
776: PROCEDURE chk_del_training_plan_id
777: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
778: ) IS
779: --
780: l_exists varchar2(1);
781: l_proc varchar2(72) := g_package||'chk_del_training_plan_id';

Line 876: p_associated_column1 => 'OTA_TRAINING_PLANS.PLAN_SOURCE') THEN

872:
873: WHEN app_exception.application_exception THEN
874:
875: IF hr_multi_message.exception_add(
876: p_associated_column1 => 'OTA_TRAINING_PLANS.PLAN_SOURCE') THEN
877:
878: hr_utility.set_location(' Leaving:'||l_proc, 42);
879: RAISE;
880:

Line 891: PROCEDURE chk_tp_date_range (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

887: -- ----------------------------------------------------------------------------
888: -- |---------------------------< chk_tp_date_range >----------------------------|
889: -- ----------------------------------------------------------------------------
890:
891: PROCEDURE chk_tp_date_range (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
892: ,p_start_date IN ota_training_plans.start_date%TYPE
893: ,p_end_date IN ota_training_plans.end_date%TYPE DEFAULT NULL
894: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE)
895: IS

Line 892: ,p_start_date IN ota_training_plans.start_date%TYPE

888: -- |---------------------------< chk_tp_date_range >----------------------------|
889: -- ----------------------------------------------------------------------------
890:
891: PROCEDURE chk_tp_date_range (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
892: ,p_start_date IN ota_training_plans.start_date%TYPE
893: ,p_end_date IN ota_training_plans.end_date%TYPE DEFAULT NULL
894: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE)
895: IS
896:

Line 893: ,p_end_date IN ota_training_plans.end_date%TYPE DEFAULT NULL

889: -- ----------------------------------------------------------------------------
890:
891: PROCEDURE chk_tp_date_range (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
892: ,p_start_date IN ota_training_plans.start_date%TYPE
893: ,p_end_date IN ota_training_plans.end_date%TYPE DEFAULT NULL
894: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE)
895: IS
896:
897: l_proc VARCHAR2(72) := g_package|| 'chk_tp_date_range';

Line 894: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE)

890:
891: PROCEDURE chk_tp_date_range (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
892: ,p_start_date IN ota_training_plans.start_date%TYPE
893: ,p_end_date IN ota_training_plans.end_date%TYPE DEFAULT NULL
894: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE)
895: IS
896:
897: l_proc VARCHAR2(72) := g_package|| 'chk_tp_date_range';
898:

Line 1032: p_associated_column1 => 'OTA_TRAINING_PLANS.START_DATE') THEN

1028:
1029: IF l_flag = 'END_DATE' THEN
1030:
1031: /* IF hr_multi_message.exception_add(
1032: p_associated_column1 => 'OTA_TRAINING_PLANS.START_DATE') THEN
1033: hr_utility.set_location(' Leaving:'||l_proc, 32);
1034: RAISE;
1035:
1036: END IF;

Line 1040: p_associated_column1 => 'OTA_TRAINING_PLANS.END_DATE') THEN

1036: END IF;
1037: ELSIF l_flag = 'END_DATE' THEN */
1038:
1039: IF hr_multi_message.exception_add(
1040: p_associated_column1 => 'OTA_TRAINING_PLANS.END_DATE') THEN
1041:
1042: hr_utility.set_location(' Leaving:'||l_proc, 34);
1043: RAISE;
1044:

Line 1050: p_associated_column1 => 'OTA_TRAINING_PLANS.START_DATE'

1046:
1047: ELSE
1048:
1049: IF hr_multi_message.exception_add(
1050: p_associated_column1 => 'OTA_TRAINING_PLANS.START_DATE'
1051: ,p_associated_column2 => 'OTA_TRAINING_PLANS.END_DATE') THEN
1052:
1053: hr_utility.set_location(' Leaving:'||l_proc, 36);
1054: RAISE;

Line 1051: ,p_associated_column2 => 'OTA_TRAINING_PLANS.END_DATE') THEN

1047: ELSE
1048:
1049: IF hr_multi_message.exception_add(
1050: p_associated_column1 => 'OTA_TRAINING_PLANS.START_DATE'
1051: ,p_associated_column2 => 'OTA_TRAINING_PLANS.END_DATE') THEN
1052:
1053: hr_utility.set_location(' Leaving:'||l_proc, 36);
1054: RAISE;
1055: