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 37: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

33: --
34: -- {End Of Comments}
35: -- ----------------------------------------------------------------------------
36: PROCEDURE chk_unique
37: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
38: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
39: ,p_organization_id IN ota_training_plans.organization_id%TYPE
40: ,p_person_id IN ota_training_plans.person_id%TYPE
41: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE

Line 38: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE

34: -- {End Of Comments}
35: -- ----------------------------------------------------------------------------
36: PROCEDURE chk_unique
37: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
38: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
39: ,p_organization_id IN ota_training_plans.organization_id%TYPE
40: ,p_person_id IN ota_training_plans.person_id%TYPE
41: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
42: ) ;

Line 39: ,p_organization_id IN ota_training_plans.organization_id%TYPE

35: -- ----------------------------------------------------------------------------
36: PROCEDURE chk_unique
37: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
38: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
39: ,p_organization_id IN ota_training_plans.organization_id%TYPE
40: ,p_person_id IN ota_training_plans.person_id%TYPE
41: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
42: ) ;
43: -- ----------------------------------------------------------------------------

Line 40: ,p_person_id IN ota_training_plans.person_id%TYPE

36: PROCEDURE chk_unique
37: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
38: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
39: ,p_organization_id IN ota_training_plans.organization_id%TYPE
40: ,p_person_id IN ota_training_plans.person_id%TYPE
41: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
42: ) ;
43: -- ----------------------------------------------------------------------------
44: -- |---------------------------------< chk_org_person >----------------------------------|

Line 41: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE

37: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
38: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
39: ,p_organization_id IN ota_training_plans.organization_id%TYPE
40: ,p_person_id IN ota_training_plans.person_id%TYPE
41: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
42: ) ;
43: -- ----------------------------------------------------------------------------
44: -- |---------------------------------< chk_org_person >----------------------------------|
45: -- ----------------------------------------------------------------------------

Line 74: (p_organization_id IN ota_training_plans.organization_id%TYPE

70: --
71: -- {End Of Comments}
72: -- ----------------------------------------------------------------------------
73: PROCEDURE chk_org_person
74: (p_organization_id IN ota_training_plans.organization_id%TYPE
75: ,p_person_id IN ota_training_plans.person_id%TYPE
76: ,p_contact_id IN ota_training_plans.contact_id%TYPE
77: ) ;
78: -- ----------------------------------------------------------------------------

Line 75: ,p_person_id IN ota_training_plans.person_id%TYPE

71: -- {End Of Comments}
72: -- ----------------------------------------------------------------------------
73: PROCEDURE chk_org_person
74: (p_organization_id IN ota_training_plans.organization_id%TYPE
75: ,p_person_id IN ota_training_plans.person_id%TYPE
76: ,p_contact_id IN ota_training_plans.contact_id%TYPE
77: ) ;
78: -- ----------------------------------------------------------------------------
79: -- |---------------------------------< chk_organization_id >----------------------------------|

Line 76: ,p_contact_id IN ota_training_plans.contact_id%TYPE

72: -- ----------------------------------------------------------------------------
73: PROCEDURE chk_org_person
74: (p_organization_id IN ota_training_plans.organization_id%TYPE
75: ,p_person_id IN ota_training_plans.person_id%TYPE
76: ,p_contact_id IN ota_training_plans.contact_id%TYPE
77: ) ;
78: -- ----------------------------------------------------------------------------
79: -- |---------------------------------< chk_organization_id >----------------------------------|
80: -- ----------------------------------------------------------------------------

Line 110: (p_organization_id IN ota_training_plans.organization_id%TYPE

106: --
107: -- {End Of Comments}
108: -- ----------------------------------------------------------------------------
109: PROCEDURE chk_organization_id
110: (p_organization_id IN ota_training_plans.organization_id%TYPE
111: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
112: );
113: -- ----------------------------------------------------------------------------
114: -- |---------------------------------< chk_person_id >----------------------------------|

Line 111: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

107: -- {End Of Comments}
108: -- ----------------------------------------------------------------------------
109: PROCEDURE chk_organization_id
110: (p_organization_id IN ota_training_plans.organization_id%TYPE
111: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
112: );
113: -- ----------------------------------------------------------------------------
114: -- |---------------------------------< chk_person_id >----------------------------------|
115: -- ----------------------------------------------------------------------------

Line 147: ,p_person_id IN ota_training_plans.person_id%TYPE

143: -- {End Of Comments}
144: -- ----------------------------------------------------------------------------
145: PROCEDURE chk_person_id
146: (p_effective_date IN date
147: ,p_person_id IN ota_training_plans.person_id%TYPE
148: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
149: ) ;
150: -- ----------------------------------------------------------------------------
151: -- |---------------------------------< chk_plan_status_type_id >----------------------------------|

Line 148: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

144: -- ----------------------------------------------------------------------------
145: PROCEDURE chk_person_id
146: (p_effective_date IN date
147: ,p_person_id IN ota_training_plans.person_id%TYPE
148: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
149: ) ;
150: -- ----------------------------------------------------------------------------
151: -- |---------------------------------< chk_plan_status_type_id >----------------------------------|
152: -- ----------------------------------------------------------------------------

Line 183: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE

179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: PROCEDURE chk_plan_status_type_id
182: (p_effective_date IN date
183: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
184: ) ;
185: -- ----------------------------------------------------------------------------
186: -- |---------------------------------< chk_time_period_id >----------------------------------|
187: -- ----------------------------------------------------------------------------

Line 219: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

215: --
216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: PROCEDURE chk_time_period_id
219: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
220: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
221: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
222: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
223: ) ;

Line 220: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE

216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: PROCEDURE chk_time_period_id
219: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
220: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
221: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
222: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
223: ) ;
224: -- ----------------------------------------------------------------------------

Line 221: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE

217: -- ----------------------------------------------------------------------------
218: PROCEDURE chk_time_period_id
219: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
220: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
221: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
222: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
223: ) ;
224: -- ----------------------------------------------------------------------------
225: -- |---------------------------------< chk_period_overlap >----------------------------------|

Line 222: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

218: PROCEDURE chk_time_period_id
219: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
220: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
221: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
222: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
223: ) ;
224: -- ----------------------------------------------------------------------------
225: -- |---------------------------------< chk_period_overlap >----------------------------------|
226: -- ----------------------------------------------------------------------------

Line 259: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

255: -- Internal Development Use Only.
256: --
257: -- ----------------------------------------------------------------------------
258: PROCEDURE chk_period_overlap
259: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
260: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
261: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
262: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
263: ,p_person_id IN ota_training_plans.person_id%TYPE

Line 260: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE

256: --
257: -- ----------------------------------------------------------------------------
258: PROCEDURE chk_period_overlap
259: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
260: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
261: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
262: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
263: ,p_person_id IN ota_training_plans.person_id%TYPE
264: ,p_organization_id IN ota_training_plans.organization_id%TYPE

Line 261: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE

257: -- ----------------------------------------------------------------------------
258: PROCEDURE chk_period_overlap
259: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
260: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
261: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
262: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
263: ,p_person_id IN ota_training_plans.person_id%TYPE
264: ,p_organization_id IN ota_training_plans.organization_id%TYPE
265: );

Line 262: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE

258: PROCEDURE chk_period_overlap
259: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
260: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
261: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
262: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
263: ,p_person_id IN ota_training_plans.person_id%TYPE
264: ,p_organization_id IN ota_training_plans.organization_id%TYPE
265: );
266: -- ----------------------------------------------------------------------------

Line 263: ,p_person_id IN ota_training_plans.person_id%TYPE

259: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
260: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
261: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
262: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
263: ,p_person_id IN ota_training_plans.person_id%TYPE
264: ,p_organization_id IN ota_training_plans.organization_id%TYPE
265: );
266: -- ----------------------------------------------------------------------------
267: -- |---------------------------------< chk_currency_code >----------------------------------|

Line 264: ,p_organization_id IN ota_training_plans.organization_id%TYPE

260: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
261: ,p_plan_status_type_id IN ota_training_plans.plan_status_type_id%TYPE
262: ,p_time_period_id IN ota_training_plans.time_period_id%TYPE
263: ,p_person_id IN ota_training_plans.person_id%TYPE
264: ,p_organization_id IN ota_training_plans.organization_id%TYPE
265: );
266: -- ----------------------------------------------------------------------------
267: -- |---------------------------------< chk_currency_code >----------------------------------|
268: -- ----------------------------------------------------------------------------

Line 299: ( p_budget_currency IN ota_training_plans.budget_currency%TYPE

295: --
296: -- {End Of Comments}
297: -- ----------------------------------------------------------------------------
298: PROCEDURE chk_currency_code
299: ( p_budget_currency IN ota_training_plans.budget_currency%TYPE
300: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
301: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
302: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
303: );

Line 300: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

296: -- {End Of Comments}
297: -- ----------------------------------------------------------------------------
298: PROCEDURE chk_currency_code
299: ( p_budget_currency IN ota_training_plans.budget_currency%TYPE
300: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
301: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
302: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
303: );
304: -- ----------------------------------------------------------------------------

Line 301: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

297: -- ----------------------------------------------------------------------------
298: PROCEDURE chk_currency_code
299: ( p_budget_currency IN ota_training_plans.budget_currency%TYPE
300: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
301: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
302: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
303: );
304: -- ----------------------------------------------------------------------------
305: -- |---------------------------------< chk_name >-----------------------------|

Line 302: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE

298: PROCEDURE chk_currency_code
299: ( p_budget_currency IN ota_training_plans.budget_currency%TYPE
300: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
301: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
302: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
303: );
304: -- ----------------------------------------------------------------------------
305: -- |---------------------------------< chk_name >-----------------------------|
306: -- ----------------------------------------------------------------------------

Line 336: (p_name IN ota_training_plans.name%TYPE

332: --
333: -- {End Of Comments}
334: -- ----------------------------------------------------------------------------
335: PROCEDURE chk_name
336: (p_name IN ota_training_plans.name%TYPE
337: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
338: ,p_person_id IN ota_training_plans.person_id%TYPE
339: ,p_contact_id IN ota_training_plans.contact_id%TYPE
340: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

Line 337: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

333: -- {End Of Comments}
334: -- ----------------------------------------------------------------------------
335: PROCEDURE chk_name
336: (p_name IN ota_training_plans.name%TYPE
337: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
338: ,p_person_id IN ota_training_plans.person_id%TYPE
339: ,p_contact_id IN ota_training_plans.contact_id%TYPE
340: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
341: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE

Line 338: ,p_person_id IN ota_training_plans.person_id%TYPE

334: -- ----------------------------------------------------------------------------
335: PROCEDURE chk_name
336: (p_name IN ota_training_plans.name%TYPE
337: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
338: ,p_person_id IN ota_training_plans.person_id%TYPE
339: ,p_contact_id IN ota_training_plans.contact_id%TYPE
340: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
341: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
342: );

Line 339: ,p_contact_id IN ota_training_plans.contact_id%TYPE

335: PROCEDURE chk_name
336: (p_name IN ota_training_plans.name%TYPE
337: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
338: ,p_person_id IN ota_training_plans.person_id%TYPE
339: ,p_contact_id IN ota_training_plans.contact_id%TYPE
340: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
341: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
342: );
343: -- ----------------------------------------------------------------------------

Line 340: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE

336: (p_name IN ota_training_plans.name%TYPE
337: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
338: ,p_person_id IN ota_training_plans.person_id%TYPE
339: ,p_contact_id IN ota_training_plans.contact_id%TYPE
340: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
341: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
342: );
343: -- ----------------------------------------------------------------------------
344: -- |------------------------< chk_del_training_plan_id >---------------------|

Line 341: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE

337: ,p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
338: ,p_person_id IN ota_training_plans.person_id%TYPE
339: ,p_contact_id IN ota_training_plans.contact_id%TYPE
340: ,p_business_group_id IN ota_training_plans.business_group_id%TYPE
341: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE
342: );
343: -- ----------------------------------------------------------------------------
344: -- |------------------------< chk_del_training_plan_id >---------------------|
345: -- ----------------------------------------------------------------------------

Line 377: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

373: --
374: -- {End Of Comments}
375: -- ----------------------------------------------------------------------------
376: PROCEDURE chk_del_training_plan_id
377: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
378: ) ;
379:
380: -- ----------------------------------------------------------------------------
381: -- |---------------------------< chk_plan_source >----------------------------|

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

449: --
450: -- {End Of Comments}
451: -- ----------------------------------------------------------------------------
452:
453: PROCEDURE chk_tp_date_range (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
454: ,p_start_date IN ota_training_plans.start_date%TYPE
455: ,p_end_date IN ota_training_plans.end_date%TYPE DEFAULT NULL
456: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE);
457:

Line 454: ,p_start_date IN ota_training_plans.start_date%TYPE

450: -- {End Of Comments}
451: -- ----------------------------------------------------------------------------
452:
453: PROCEDURE chk_tp_date_range (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
454: ,p_start_date IN ota_training_plans.start_date%TYPE
455: ,p_end_date IN ota_training_plans.end_date%TYPE DEFAULT NULL
456: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE);
457:
458: END ota_tps_bus1;

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

451: -- ----------------------------------------------------------------------------
452:
453: PROCEDURE chk_tp_date_range (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
454: ,p_start_date IN ota_training_plans.start_date%TYPE
455: ,p_end_date IN ota_training_plans.end_date%TYPE DEFAULT NULL
456: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE);
457:
458: END ota_tps_bus1;

Line 456: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE);

452:
453: PROCEDURE chk_tp_date_range (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
454: ,p_start_date IN ota_training_plans.start_date%TYPE
455: ,p_end_date IN ota_training_plans.end_date%TYPE DEFAULT NULL
456: ,p_object_version_number IN ota_training_plans.object_version_number%TYPE);
457:
458: END ota_tps_bus1;