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 34: (p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

30: --
31: -- {End Of Comments}
32: -- ----------------------------------------------------------------------------
33: Procedure chk_training_plan_id
34: (p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
35: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
36: );
37: -- ----------------------------------------------------------------------------
38: -- |-----------------------------------------------|

Line 35: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE

31: -- {End Of Comments}
32: -- ----------------------------------------------------------------------------
33: Procedure chk_training_plan_id
34: (p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
35: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
36: );
37: -- ----------------------------------------------------------------------------
38: -- |-----------------------------------------------|
39: -- ----------------------------------------------------------------------------

Line 70: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE

66: --
67: -- {End Of Comments}
68: -- ----------------------------------------------------------------------------
69: Procedure chk_activity_definition_id (
70: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
71: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
72: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
73: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
74: ) ;

Line 71: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE

67: -- {End Of Comments}
68: -- ----------------------------------------------------------------------------
69: Procedure chk_activity_definition_id (
70: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
71: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
72: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
73: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
74: ) ;
75: -- ----------------------------------------------------------------------------

Line 72: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE

68: -- ----------------------------------------------------------------------------
69: Procedure chk_activity_definition_id (
70: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
71: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
72: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
73: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
74: ) ;
75: -- ----------------------------------------------------------------------------
76: -- |--------------------------------------------------|

Line 73: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE

69: Procedure chk_activity_definition_id (
70: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
71: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
72: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
73: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
74: ) ;
75: -- ----------------------------------------------------------------------------
76: -- |--------------------------------------------------|
77: -- ----------------------------------------------------------------------------

Line 115: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE

111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure chk_version_definition (
115: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
116: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
117: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
118: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
119: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE

Line 116: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE

112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure chk_version_definition (
115: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
116: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
117: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
118: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
119: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
120: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

Line 117: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE

113: -- ----------------------------------------------------------------------------
114: Procedure chk_version_definition (
115: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
116: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
117: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
118: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
119: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
120: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
121: );

Line 118: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE

114: Procedure chk_version_definition (
115: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
116: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
117: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
118: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
119: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
120: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
121: );
122: -- ----------------------------------------------------------------------------

Line 119: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE

115: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
116: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
117: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
118: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
119: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
120: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
121: );
122: -- ----------------------------------------------------------------------------
123: -- |-------------------------------------------------|

Line 120: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

116: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
117: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
118: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
119: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
120: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
121: );
122: -- ----------------------------------------------------------------------------
123: -- |-------------------------------------------------|
124: -- ----------------------------------------------------------------------------

Line 158: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE

154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure chk_activity_version_id (
158: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
159: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
160: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
161: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
162: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

Line 159: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE

155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure chk_activity_version_id (
158: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
159: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
160: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
161: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
162: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
163: );

Line 160: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE

156: -- ----------------------------------------------------------------------------
157: Procedure chk_activity_version_id (
158: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
159: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
160: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
161: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
162: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
163: );
164: -- ----------------------------------------------------------------------------

Line 161: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE

157: Procedure chk_activity_version_id (
158: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
159: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
160: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
161: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
162: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
163: );
164: -- ----------------------------------------------------------------------------
165: -- |-----------------------------------------------|

Line 162: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

158: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
159: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
160: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
161: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
162: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
163: );
164: -- ----------------------------------------------------------------------------
165: -- |-----------------------------------------------|
166: -- ----------------------------------------------------------------------------

Line 206: ,p_member_status_type_id in ota_training_plan_members.member_status_type_id%TYPE

202: -- {End Of Comments}
203: -- ----------------------------------------------------------------------------
204: Procedure chk_member_status_type_id (
205: p_effective_date in date
206: ,p_member_status_type_id in ota_training_plan_members.member_status_type_id%TYPE
207: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
208: ,p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
209: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
210: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE

Line 207: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE

203: -- ----------------------------------------------------------------------------
204: Procedure chk_member_status_type_id (
205: p_effective_date in date
206: ,p_member_status_type_id in ota_training_plan_members.member_status_type_id%TYPE
207: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
208: ,p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
209: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
210: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
211: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE

Line 208: ,p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE

204: Procedure chk_member_status_type_id (
205: p_effective_date in date
206: ,p_member_status_type_id in ota_training_plan_members.member_status_type_id%TYPE
207: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
208: ,p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
209: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
210: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
211: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
212: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

Line 209: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE

205: p_effective_date in date
206: ,p_member_status_type_id in ota_training_plan_members.member_status_type_id%TYPE
207: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
208: ,p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
209: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
210: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
211: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
212: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
213: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type

Line 210: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE

206: ,p_member_status_type_id in ota_training_plan_members.member_status_type_id%TYPE
207: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
208: ,p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
209: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
210: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
211: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
212: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
213: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type
214: );

Line 211: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE

207: ,p_business_group_id in ota_training_plan_members.business_group_id%TYPE
208: ,p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
209: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
210: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
211: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
212: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
213: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type
214: );
215:

Line 212: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

208: ,p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
209: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
210: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
211: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
212: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
213: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type
214: );
215:
216: -- ----------------------------------------------------------------------------

Line 213: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type

209: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
210: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
211: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
212: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
213: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type
214: );
215:
216: -- ----------------------------------------------------------------------------
217: -- |--------------------------------------------------------------|

Line 255: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE

251: --
252: -- {End Of Comments}
253: -- ----------------------------------------------------------------------------
254: Procedure chk_unique1 (
255: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
256: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
257: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
258: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
259: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

Line 256: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE

252: -- {End Of Comments}
253: -- ----------------------------------------------------------------------------
254: Procedure chk_unique1 (
255: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
256: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
257: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
258: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
259: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
260: ,p_target_completion_date in ota_training_plan_members.target_completion_date%TYPE

Line 257: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE

253: -- ----------------------------------------------------------------------------
254: Procedure chk_unique1 (
255: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
256: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
257: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
258: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
259: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
260: ,p_target_completion_date in ota_training_plan_members.target_completion_date%TYPE
261: );

Line 258: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE

254: Procedure chk_unique1 (
255: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
256: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
257: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
258: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
259: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
260: ,p_target_completion_date in ota_training_plan_members.target_completion_date%TYPE
261: );
262: -- ----------------------------------------------------------------------------

Line 259: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

255: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
256: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
257: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
258: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
259: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
260: ,p_target_completion_date in ota_training_plan_members.target_completion_date%TYPE
261: );
262: -- ----------------------------------------------------------------------------
263: -- |--------------------------------------------------------------|

Line 260: ,p_target_completion_date in ota_training_plan_members.target_completion_date%TYPE

256: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
257: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
258: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
259: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
260: ,p_target_completion_date in ota_training_plan_members.target_completion_date%TYPE
261: );
262: -- ----------------------------------------------------------------------------
263: -- |--------------------------------------------------------------|
264: -- ----------------------------------------------------------------------------

Line 301: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE

297: --
298: -- {End Of Comments}
299: -- ----------------------------------------------------------------------------
300: Procedure chk_unique (
301: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
302: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
303: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
304: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
305: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

Line 302: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE

298: -- {End Of Comments}
299: -- ----------------------------------------------------------------------------
300: Procedure chk_unique (
301: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
302: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
303: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
304: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
305: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
306: );

Line 303: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE

299: -- ----------------------------------------------------------------------------
300: Procedure chk_unique (
301: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
302: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
303: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
304: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
305: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
306: );
307: -- ----------------------------------------------------------------------------

Line 304: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE

300: Procedure chk_unique (
301: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
302: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
303: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
304: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
305: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
306: );
307: -- ----------------------------------------------------------------------------
308: -- |---------------------------------------------------------------|

Line 305: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

301: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
302: ,p_object_version_number in ota_training_plan_members.object_version_number%TYPE
303: ,p_activity_definition_id in ota_training_plan_members.activity_definition_id%TYPE
304: ,p_activity_version_id in ota_training_plan_members.activity_version_id%TYPE
305: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
306: );
307: -- ----------------------------------------------------------------------------
308: -- |---------------------------------------------------------------|
309: -- ----------------------------------------------------------------------------

Line 338: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE

334: --
335: -- {End Of Comments}
336: -- ----------------------------------------------------------------------------
337: Procedure chk_delete (
338: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
339: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
340: );
341:
342: -- ----------------------------------------------------------------------------

Line 339: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE

335: -- {End Of Comments}
336: -- ----------------------------------------------------------------------------
337: Procedure chk_delete (
338: p_training_plan_member_id in ota_training_plan_members.training_plan_member_id%TYPE
339: ,p_training_plan_id in ota_training_plan_members.training_plan_id%TYPE
340: );
341:
342: -- ----------------------------------------------------------------------------
343: -- |---------------------------------------------------------------|

Line 451: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

447: -- ----------------------------------------------------------------------------
448:
449:
450: Procedure chk_tpc_tp_actver_dates(p_training_plan_id in ota_training_plans.training_plan_id%type
451: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
452: ,p_activity_version_id in ota_training_plan_members.activity_version_id%type
453: ,p_earliest_start_date in ota_training_plan_members.earliest_start_date%TYPE
454: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type
455: ,p_object_version_number in ota_training_plan_members.object_version_number%type);

Line 452: ,p_activity_version_id in ota_training_plan_members.activity_version_id%type

448:
449:
450: Procedure chk_tpc_tp_actver_dates(p_training_plan_id in ota_training_plans.training_plan_id%type
451: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
452: ,p_activity_version_id in ota_training_plan_members.activity_version_id%type
453: ,p_earliest_start_date in ota_training_plan_members.earliest_start_date%TYPE
454: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type
455: ,p_object_version_number in ota_training_plan_members.object_version_number%type);
456:

Line 453: ,p_earliest_start_date in ota_training_plan_members.earliest_start_date%TYPE

449:
450: Procedure chk_tpc_tp_actver_dates(p_training_plan_id in ota_training_plans.training_plan_id%type
451: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
452: ,p_activity_version_id in ota_training_plan_members.activity_version_id%type
453: ,p_earliest_start_date in ota_training_plan_members.earliest_start_date%TYPE
454: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type
455: ,p_object_version_number in ota_training_plan_members.object_version_number%type);
456:
457:

Line 454: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type

450: Procedure chk_tpc_tp_actver_dates(p_training_plan_id in ota_training_plans.training_plan_id%type
451: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
452: ,p_activity_version_id in ota_training_plan_members.activity_version_id%type
453: ,p_earliest_start_date in ota_training_plan_members.earliest_start_date%TYPE
454: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type
455: ,p_object_version_number in ota_training_plan_members.object_version_number%type);
456:
457:
458:

Line 455: ,p_object_version_number in ota_training_plan_members.object_version_number%type);

451: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
452: ,p_activity_version_id in ota_training_plan_members.activity_version_id%type
453: ,p_earliest_start_date in ota_training_plan_members.earliest_start_date%TYPE
454: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type
455: ,p_object_version_number in ota_training_plan_members.object_version_number%type);
456:
457:
458:
459: