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_TPM_BUS1 dependencies on OTA_TRAINING_PLAN_MEMBERS

Line 16: (p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

12: -- |-----------------------------------------------------|
13: -- ----------------------------------------------------------------------------
14: --
15: PROCEDURE chk_training_plan_id
16: (p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
17: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
18: ) IS
19: --
20: l_exists VARCHAR2(1);

Line 17: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE

13: -- ----------------------------------------------------------------------------
14: --
15: PROCEDURE chk_training_plan_id
16: (p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
17: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
18: ) IS
19: --
20: l_exists VARCHAR2(1);
21: l_proc VARCHAR2(72) := g_package|| 'chk_training_plan_id';

Line 67: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN

63:
64: WHEN app_exception.application_exception THEN
65:
66: IF hr_multi_message.exception_add
67: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN
68:
69: hr_utility.set_location(' Leaving:'||l_proc, 92);
70: RAISE;
71: END IF;

Line 81: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

77: -- |----------------------------------------------|
78: -- ----------------------------------------------------------------------------
79: --
80: PROCEDURE chk_activity_definition_id (
81: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
82: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
83: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
84: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
85: ) IS

Line 82: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE

78: -- ----------------------------------------------------------------------------
79: --
80: PROCEDURE chk_activity_definition_id (
81: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
82: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
83: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
84: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
85: ) IS
86: --

Line 83: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE

79: --
80: PROCEDURE chk_activity_definition_id (
81: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
82: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
83: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
84: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
85: ) IS
86: --
87: l_proc VARCHAR2(72) := g_package|| 'activity_definition_id';

Line 84: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE

80: PROCEDURE chk_activity_definition_id (
81: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
82: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
83: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
84: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
85: ) IS
86: --
87: l_proc VARCHAR2(72) := g_package|| 'activity_definition_id';
88: l_api_updating boolean;

Line 89: l_business_group_id ota_training_plan_members.business_group_id%TYPE;

85: ) IS
86: --
87: l_proc VARCHAR2(72) := g_package|| 'activity_definition_id';
88: l_api_updating boolean;
89: l_business_group_id ota_training_plan_members.business_group_id%TYPE;
90: --
91: CURSOR csr_activity_definition_id IS
92: SELECT oad.business_group_id
93: FROM OTA_ACTIVITY_DEFINITIONS oad

Line 149: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN

145:
146: WHEN app_exception.application_exception THEN
147:
148: IF hr_multi_message.exception_add
149: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
150:
151: hr_utility.set_location(' Leaving:'||l_proc, 42);
152: RAISE;
153: END IF;

Line 163: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

159: -- |--------------------------------------------------|
160: -- ----------------------------------------------------------------------------
161: --
162: PROCEDURE chk_version_definition (
163: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
164: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
165: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
166: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
167: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE

Line 164: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE

160: -- ----------------------------------------------------------------------------
161: --
162: PROCEDURE chk_version_definition (
163: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
164: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
165: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
166: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
167: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
168: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

Line 165: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE

161: --
162: PROCEDURE chk_version_definition (
163: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
164: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
165: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
166: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
167: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
168: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
169: ) IS

Line 166: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE

162: PROCEDURE chk_version_definition (
163: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
164: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
165: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
166: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
167: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
168: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
169: ) IS
170: --

Line 167: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE

163: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
164: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
165: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
166: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
167: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
168: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
169: ) IS
170: --
171: l_api_updating boolean;

Line 168: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

164: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
165: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
166: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
167: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
168: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
169: ) IS
170: --
171: l_api_updating boolean;
172: l_exists VARCHAR2(1);

Line 244: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

240:
241: WHEN app_exception.application_exception THEN
242:
243: IF hr_multi_message.exception_add
244: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
245: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
246:
247: hr_utility.set_location(' Leaving:'||l_proc, 102);
248: RAISE;

Line 245: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN

241: WHEN app_exception.application_exception THEN
242:
243: IF hr_multi_message.exception_add
244: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
245: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
246:
247: hr_utility.set_location(' Leaving:'||l_proc, 102);
248: RAISE;
249: END IF;

Line 259: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

255: -- |-------------------------------------------------|
256: -- ----------------------------------------------------------------------------
257: --
258: PROCEDURE chk_activity_version_id (
259: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
260: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
261: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
262: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
263: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

Line 260: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE

256: -- ----------------------------------------------------------------------------
257: --
258: PROCEDURE chk_activity_version_id (
259: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
260: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
261: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
262: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
263: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
264: ) IS

Line 261: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE

257: --
258: PROCEDURE chk_activity_version_id (
259: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
260: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
261: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
262: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
263: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
264: ) IS
265: --

Line 262: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE

258: PROCEDURE chk_activity_version_id (
259: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
260: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
261: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
262: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
263: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
264: ) IS
265: --
266: --

Line 263: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

259: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
260: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
261: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
262: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
263: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
264: ) IS
265: --
266: --
267: l_proc VARCHAR2(72) := g_package|| 'activity_definition_id';

Line 269: l_business_group_id ota_training_plan_members.business_group_id%TYPE;

265: --
266: --
267: l_proc VARCHAR2(72) := g_package|| 'activity_definition_id';
268: l_api_updating BOOLEAN;
269: l_business_group_id ota_training_plan_members.business_group_id%TYPE;
270: l_plan_start_date ota_training_plans.start_date%TYPE;
271: l_plan_end_date ota_training_plans.end_date%TYPE;
272: l_version_start_date DATE;
273: l_version_end_date DATE;

Line 312: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'

308: --
309: hr_utility.set_location(' Step:'|| l_proc, 10);
310:
311: IF hr_multi_message.no_exclusive_error
312: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
313: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN
314:
315: hr_api.mandatory_arg_error
316: (p_api_name => l_proc

Line 313: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN

309: hr_utility.set_location(' Step:'|| l_proc, 10);
310:
311: IF hr_multi_message.no_exclusive_error
312: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
313: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN
314:
315: hr_api.mandatory_arg_error
316: (p_api_name => l_proc
317: ,p_argument => 'p_business_group_id'

Line 410: ,p_member_status_type_id IN ota_training_plan_members.member_status_type_id%TYPE

406: -- ----------------------------------------------------------------------------
407: --
408: PROCEDURE chk_member_status_type_id
409: (p_effective_date IN date
410: ,p_member_status_type_id IN ota_training_plan_members.member_status_type_id%TYPE
411: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
412: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
413: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
414: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE

Line 411: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE

407: --
408: PROCEDURE chk_member_status_type_id
409: (p_effective_date IN date
410: ,p_member_status_type_id IN ota_training_plan_members.member_status_type_id%TYPE
411: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
412: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
413: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
414: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
415: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE

Line 412: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

408: PROCEDURE chk_member_status_type_id
409: (p_effective_date IN date
410: ,p_member_status_type_id IN ota_training_plan_members.member_status_type_id%TYPE
411: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
412: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
413: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
414: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
415: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
416: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

Line 413: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE

409: (p_effective_date IN date
410: ,p_member_status_type_id IN ota_training_plan_members.member_status_type_id%TYPE
411: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
412: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
413: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
414: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
415: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
416: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
417: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE)

Line 414: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE

410: ,p_member_status_type_id IN ota_training_plan_members.member_status_type_id%TYPE
411: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
412: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
413: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
414: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
415: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
416: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
417: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE)
418: IS

Line 415: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE

411: ,p_business_group_id IN ota_training_plan_members.business_group_id%TYPE
412: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
413: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
414: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
415: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
416: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
417: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE)
418: IS
419: --

Line 416: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

412: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
413: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
414: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
415: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
416: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
417: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE)
418: IS
419: --
420: l_proc VARCHAR2(72) := g_package|| 'chk_member_status_type_id';

Line 417: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE)

413: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
414: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
415: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
416: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
417: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE)
418: IS
419: --
420: l_proc VARCHAR2(72) := g_package|| 'chk_member_status_type_id';
421: l_api_updating boolean;

Line 428: ,OTA_TRAINING_PLAN_MEMBERS tpm

424: CURSOR csr_seek_statuses IS
425: SELECT NULL
426: FROM OTA_ACTIVITY_DEFINITIONS oad
427: ,OTA_ACTIVITY_VERSIONS oav
428: ,OTA_TRAINING_PLAN_MEMBERS tpm
429: WHERE ((oad.activity_id = p_activity_definition_id AND p_activity_definition_id IS NOT NULL)
430: OR (oav.activity_version_id = p_activity_version_id AND p_activity_version_id IS NOT NULL))
431: AND oad.activity_id = oav.activity_id
432: AND ( oav.activity_version_id = tpm.activity_version_id

Line 446: -- from ota_training_plan_members

442: -- Following two cursor statements disused
443: --
444: -- cursor csr_parents is
445: -- select null
446: -- from ota_training_plan_members
447: -- where business_group_id = p_business_group_id
448: -- and member_status_type_id <> 'CANCELLED'
449: -- and ( nvl(training_plan_member_id, -1) <> nvl(p_training_plan_member_id, -1) )
450: -- and activity_version_id in (

Line 458: -- from ota_training_plan_members

454: -- start with activity_version_id = p_activity_version_id);
455: --
456: -- cursor csr_children is
457: -- select null
458: -- from ota_training_plan_members
459: -- where business_group_id = p_business_group_id
460: -- and member_status_type_id <> 'CANCELLED'
461: -- and ( nvl(training_plan_member_id, -1) <> nvl(p_training_plan_member_id, -1) ) and activity_version_id in (
462: -- select activity_version_id

Line 474: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'

470: --
471: hr_utility.set_location(' Step:'|| l_proc, 30);
472:
473: IF hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
475: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
476: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
477: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
478: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

Line 475: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

471: hr_utility.set_location(' Step:'|| l_proc, 30);
472:
473: IF hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
475: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
476: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
477: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
478: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
479: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN

Line 476: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'

472:
473: IF hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
475: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
476: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
477: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
478: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
479: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
480:

Line 477: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'

473: IF hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
475: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
476: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
477: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
478: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
479: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
480:
481:

Line 478: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

474: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
475: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
476: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
477: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
478: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
479: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
480:
481:
482: hr_api.mandatory_arg_error

Line 479: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN

475: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
476: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
477: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
478: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
479: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
480:
481:
482: hr_api.mandatory_arg_error
483: (p_api_name => l_proc

Line 589: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

585: -- |---------------------------------------------------------------|
586: -- ----------------------------------------------------------------------------
587: --
588: PROCEDURE chk_unique
589: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
590: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
591: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
592: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
593: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

Line 590: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE

586: -- ----------------------------------------------------------------------------
587: --
588: PROCEDURE chk_unique
589: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
590: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
591: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
592: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
593: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
594: ) IS

Line 591: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE

587: --
588: PROCEDURE chk_unique
589: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
590: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
591: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
592: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
593: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
594: ) IS
595: --

Line 592: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE

588: PROCEDURE chk_unique
589: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
590: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
591: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
592: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
593: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
594: ) IS
595: --
596: l_proc VARCHAR2(72) := g_package|| 'chk_unique';

Line 593: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

589: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
590: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
591: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
592: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
593: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
594: ) IS
595: --
596: l_proc VARCHAR2(72) := g_package|| 'chk_unique';
597: l_exists VARCHAR2(1);

Line 602: FROM OTA_TRAINING_PLAN_MEMBERS

598: l_api_updating boolean;
599: --
600: CURSOR csr_unique IS
601: SELECT NULL
602: FROM OTA_TRAINING_PLAN_MEMBERS
603: WHERE training_plan_id = p_training_plan_id
604: AND ( (p_activity_version_id IS NOT NULL AND
605: p_activity_version_id = activity_version_id)
606: OR (p_activity_definition_id IS NOT NULL AND

Line 616: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'

612: --
613: hr_utility.set_location(' Step:'|| l_proc, 30);
614:
615: IF hr_multi_message.no_exclusive_error
616: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
617: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
618: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
619: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
620: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

Line 617: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

613: hr_utility.set_location(' Step:'|| l_proc, 30);
614:
615: IF hr_multi_message.no_exclusive_error
616: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
617: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
618: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
619: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
620: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
621: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN

Line 618: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'

614:
615: IF hr_multi_message.no_exclusive_error
616: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
617: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
618: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
619: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
620: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
621: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
622:

Line 619: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'

615: IF hr_multi_message.no_exclusive_error
616: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
617: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
618: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
619: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
620: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
621: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
622:
623:

Line 620: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

616: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
617: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
618: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
619: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
620: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
621: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
622:
623:
624: hr_api.mandatory_arg_error

Line 621: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN

617: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
618: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
619: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
620: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
621: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
622:
623:
624: hr_api.mandatory_arg_error
625: (p_api_name => l_proc

Line 683: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

679: -- |---------------------------------------------------------------|
680: -- ----------------------------------------------------------------------------
681: --
682: PROCEDURE chk_unique1
683: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
684: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
685: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
686: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
687: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

Line 684: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE

680: -- ----------------------------------------------------------------------------
681: --
682: PROCEDURE chk_unique1
683: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
684: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
685: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
686: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
687: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
688: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE

Line 685: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE

681: --
682: PROCEDURE chk_unique1
683: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
684: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
685: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
686: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
687: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
688: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
689: ) IS

Line 686: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE

682: PROCEDURE chk_unique1
683: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
684: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
685: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
686: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
687: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
688: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
689: ) IS
690: --

Line 687: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

683: (p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
684: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
685: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
686: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
687: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
688: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
689: ) IS
690: --
691: l_proc VARCHAR2(72) := g_package|| 'chk_unique1';

Line 688: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE

684: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE
685: ,p_activity_definition_id IN ota_training_plan_members.activity_definition_id%TYPE
686: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
687: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
688: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
689: ) IS
690: --
691: l_proc VARCHAR2(72) := g_package|| 'chk_unique1';
692: l_exists VARCHAR2(1);

Line 698: FROM ota_training_plan_members

694: l_member_status_type_id varchar2(30);
695: --
696: CURSOR csr_unique IS
697: SELECT 1,member_status_type_id
698: FROM ota_training_plan_members
699: WHERE training_plan_id = p_training_plan_id
700: AND ( (p_activity_version_id IS NOT NULL AND
701: p_activity_version_id = activity_version_id)
702: OR (p_activity_definition_id IS NOT NULL AND

Line 717: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'

713: --
714: hr_utility.set_location(' Step:'|| l_proc, 30);
715:
716: IF hr_multi_message.no_exclusive_error
717: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
718: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
719: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
720: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
721: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

Line 718: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

714: hr_utility.set_location(' Step:'|| l_proc, 30);
715:
716: IF hr_multi_message.no_exclusive_error
717: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
718: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
719: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
720: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
721: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
722: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN

Line 719: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'

715:
716: IF hr_multi_message.no_exclusive_error
717: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
718: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
719: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
720: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
721: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
722: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
723:

Line 720: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'

716: IF hr_multi_message.no_exclusive_error
717: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
718: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
719: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
720: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
721: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
722: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
723:
724:

Line 721: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

717: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
718: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
719: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
720: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
721: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
722: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
723:
724:
725: hr_api.mandatory_arg_error

Line 722: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN

718: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
719: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
720: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
721: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
722: ,p_associated_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
723:
724:
725: hr_api.mandatory_arg_error
726: (p_api_name => l_proc

Line 795: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

791: -- |--------------------------------------------------------------|
792: -- ----------------------------------------------------------------------------
793: --
794: PROCEDURE chk_delete (
795: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
796: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
797: ) IS
798: --
799: l_api_updating boolean;

Line 796: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE

792: -- ----------------------------------------------------------------------------
793: --
794: PROCEDURE chk_delete (
795: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
796: ,p_training_plan_id IN ota_training_plan_members.training_plan_id%TYPE
797: ) IS
798: --
799: l_api_updating boolean;
800: l_exists VARCHAR2(1);

Line 816: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'

812: --
813: hr_utility.set_location(' Step:'|| l_proc, 30);
814:
815: IF hr_multi_message.no_exclusive_error
816: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
817: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN
818:
819:
820: hr_api.mandatory_arg_error

Line 817: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN

813: hr_utility.set_location(' Step:'|| l_proc, 30);
814:
815: IF hr_multi_message.no_exclusive_error
816: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
817: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN
818:
819:
820: hr_api.mandatory_arg_error
821: (p_api_name => l_proc

Line 920: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.SOURCE_FUNCTION') THEN

916:
917: WHEN app_exception.application_exception THEN
918:
919: IF hr_multi_message.exception_add
920: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.SOURCE_FUNCTION') THEN
921:
922: hr_utility.set_location(' Leaving:'||l_proc, 42);
923: RAISE;
924: END IF;

Line 981: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.CANCELLATION_REASON') THEN

977:
978: WHEN app_exception.application_exception THEN
979:
980: IF hr_multi_message.exception_add
981: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.CANCELLATION_REASON') THEN
982:
983: hr_utility.set_location(' Leaving:'||l_proc, 42);
984: RAISE;
985: END IF;

Line 997: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

993: -- ----------------------------------------------------------------------------
994:
995:
996: PROCEDURE chk_tpc_tp_actver_dates (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
997: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
998: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
999: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE
1000: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
1001: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE)

Line 998: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE

994:
995:
996: PROCEDURE chk_tpc_tp_actver_dates (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
997: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
998: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
999: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE
1000: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
1001: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE)
1002: IS

Line 999: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE

995:
996: PROCEDURE chk_tpc_tp_actver_dates (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
997: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
998: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
999: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE
1000: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
1001: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE)
1002: IS
1003:

Line 1000: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE

996: PROCEDURE chk_tpc_tp_actver_dates (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
997: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
998: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
999: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE
1000: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
1001: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE)
1002: IS
1003:
1004: l_proc VARCHAR2(72) := g_package|| 'chk_tpc_tp_actver_dates';

Line 1001: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE)

997: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
998: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
999: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE
1000: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
1001: ,p_object_version_number IN ota_training_plan_members.object_version_number%TYPE)
1002: IS
1003:
1004: l_proc VARCHAR2(72) := g_package|| 'chk_tpc_tp_actver_dates';
1005:

Line 1016: FROM ota_training_plan_members

1012: AND otp.end_date < p_target_completion_date) );
1013:
1014: CURSOR csr_tpm_overlap IS
1015: SELECT NULL
1016: FROM ota_training_plan_members
1017: WHERE training_plan_id = p_training_plan_id
1018: AND activity_version_id = p_activity_version_id
1019: AND target_completion_date >= p_earliest_start_date
1020: AND earliest_start_date <= p_target_completion_date

Line 1144: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE') THEN

1140: WHEN app_exception.application_exception THEN
1141:
1142: IF l_flag ='END_DATE' THEN
1143: /* IF hr_multi_message.exception_add(
1144: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE') THEN
1145: -- ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1146:
1147: hr_utility.set_location(' Leaving:'||l_proc, 32);
1148: RAISE;

Line 1145: -- ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN

1141:
1142: IF l_flag ='END_DATE' THEN
1143: /* IF hr_multi_message.exception_add(
1144: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE') THEN
1145: -- ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1146:
1147: hr_utility.set_location(' Leaving:'||l_proc, 32);
1148: RAISE;
1149:

Line 1153: -- p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE') THEN

1149:
1150: END IF;
1151: ELSIF l_flag = 'END_DATE' THEN */
1152: IF hr_multi_message.exception_add(
1153: -- p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE') THEN
1154: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1155:
1156: hr_utility.set_location(' Leaving:'||l_proc, 35);
1157: RAISE;

Line 1154: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN

1150: END IF;
1151: ELSIF l_flag = 'END_DATE' THEN */
1152: IF hr_multi_message.exception_add(
1153: -- p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE') THEN
1154: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1155:
1156: hr_utility.set_location(' Leaving:'||l_proc, 35);
1157: RAISE;
1158:

Line 1162: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE'

1158:
1159: END IF;
1160: ELSE
1161: IF hr_multi_message.exception_add(
1162: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE'
1163: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1164:
1165: hr_utility.set_location(' Leaving:'||l_proc, 36);
1166: RAISE;

Line 1163: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN

1159: END IF;
1160: ELSE
1161: IF hr_multi_message.exception_add(
1162: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE'
1163: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1164:
1165: hr_utility.set_location(' Leaving:'||l_proc, 36);
1166: RAISE;
1167: