[Home] [Help]
PACKAGE: APPS.OTA_TRNG_PLAN_COMP_SS
Source
1 PACKAGE OTA_TRNG_PLAN_COMP_SS AUTHID CURRENT_USER AS
2 /* $Header: ottpmwrs.pkh 115.6 2004/03/03 05:16:54 rdola noship $ */
3
4 -- ---------------------------------------------------------------------------
5 -- |----------------------< Update_tpc_sshr_change >--------------------------|
6 -- ---------------------------------------------------------------------------
7 --
8
9 Procedure Update_tpc_sshr_change(
10 p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type,
11 p_person_id ota_training_plans.person_id%type,
12 p_mode varchar2);
13 -- ---------------------------------------------------------------------------
14 -- |----------------------< Update_tp_tpc_change >--------------------------|
15 -- ---------------------------------------------------------------------------
16 --
17 -- This procedure will get called only when a tpc is Cancelled
18
19 Procedure Update_tp_tpc_change
20 (p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type);
21
22 Procedure Update_tp_tpc_change
23 (p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type,
24 p_learning_path_ids OUT NOCOPY varchar2);
25
26 -- ---------------------------------------------------------------------------
27 -- |----------------------< update_tpc_enroll_status_chg >--------------------------|
28 -- ---------------------------------------------------------------------------
29 -- {Start Of Comments}
30 --
31 -- Description:
32 -- when Enrollment status to an event changes the TPC's status attached to the
33 -- event also changes.
34 -- Called from ota_tdb_api_upd2.update_enrollment and ota_tdb_api_ins2.create_enrollment
35 -- Prerequisites:
36 --
37 --
38 -- In Arguments:
39 -- p_event_id
40 -- p_person_id
41 --
42 -- Post Success:
43 -- The attached TPC's status is updated
44 --
45 -- Post Failure:
46 --
47 --
48 -- Access Status:
49 -- Internal Development Use Only.
50 --
51 -- {End Of Comments}
52 -- ---------------------------------------------------------------------------
53 PROCEDURE update_tpc_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,
54 p_person_id IN ota_training_plans.person_id%TYPE,
55 -- Modified for Bug#3479186
56 p_contact_id IN ota_training_plans.contact_id%TYPE,
57 p_learning_path_ids OUT NOCOPY varchar2);
58
59
60 -- ---------------------------------------------------------------------------
61 -- |----------------------< update_tpc_evt_date_change >--------------------------|
62 -- ---------------------------------------------------------------------------
63 -- {Start Of Comments}
64 --
65 -- Description:
66 -- Training plan member status is updated when an event date is changed
67 -- called from ota_evt_upd.upd
68 --
69 -- Prerequisites:
70 --
71 --
72 -- In Arguments:
73 -- p_event_id
74 --
75 --
76 -- Post Success:
77 -- The TPC's status is updated
78 --
79 -- Post Failure:
80 --
81 --
82 -- Access Status:
83 -- Internal Development Use Only.
84 --
85 -- {End Of Comments}
86 -- ---------------------------------------------------------------------------
87
88 PROCEDURE update_tpc_evt_change (p_event_id IN ota_events.event_id%TYPE,
89 p_course_start_date IN ota_events.course_start_date%TYPE,
90 p_course_end_date IN ota_events.course_end_date%TYPE);
91
92
93 -- ----------------------------------------------------------------------------
94 -- ---------------------------< validate_TPC >-----------------------------
95 -- ----------------------------------------------------------------------------
96 Procedure validate_tpc
97 ( p_mode in varchar2
98 ,p_validate IN NUMBER DEFAULT hr_api.g_false_num
99 ,p_effective_date IN date
100 ,p_business_group_id IN number
101 ,p_training_plan_id IN number
102 ,p_activity_version_id IN NUMBER DEFAULT NULL
103 ,p_activity_definition_id IN NUMBER DEFAULT NULL
104 ,p_member_status_type_id IN VARCHAR2
105 ,p_target_completion_date IN date DEFAULT NULL
106 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
107 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
108 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
109 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
110 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
111 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
112 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
113 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
114 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
115 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
116 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
117 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
118 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
119 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
120 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
121 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
122 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
123 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
124 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
125 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
126 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
127 ,p_attribute21 IN VARCHAR2 DEFAULT NULL
128 ,p_attribute22 IN VARCHAR2 DEFAULT NULL
129 ,p_attribute23 IN VARCHAR2 DEFAULT NULL
130 ,p_attribute24 IN VARCHAR2 DEFAULT NULL
131 ,p_attribute25 IN VARCHAR2 DEFAULT NULL
132 ,p_attribute26 IN VARCHAR2 DEFAULT NULL
133 ,p_attribute27 IN VARCHAR2 DEFAULT NULL
134 ,p_attribute28 IN VARCHAR2 DEFAULT NULL
135 ,p_attribute29 IN VARCHAR2 DEFAULT NULL
136 ,p_attribute30 IN VARCHAR2 DEFAULT NULL
137 ,p_assignment_id IN NUMBER DEFAULT NULL
138 ,p_source_id IN NUMBER DEFAULT NULL
139 ,p_source_function IN VARCHAR2 DEFAULT NULL
140 ,p_cancellation_reason IN VARCHAR2 DEFAULT NULL
141 ,p_earliest_start_date IN date DEFAULT NULL
142 ,p_training_plan_member_id IN number
143 ,p_creator_person_id IN number
144 ,p_object_version_NUMBER IN OUT NOCOPY number
145 ,p_return_status OUT NOCOPY VARCHAR2);
146
147
148
149
150 END ota_trng_plan_comp_ss;
151