[Home] [Help]
PACKAGE: APPS.OTA_AME_ATTRIBUTES
Source
1 PACKAGE ota_ame_attributes AUTHID CURRENT_USER AS
2 /* $Header: otamewkf.pkh 120.1 2005/06/09 04:13 dbatra noship $ */
3
4 --
5 -- ------------------------------------------------------------------------
6 -- |------------------------< Get_class_standard_price >----------------------|
7 -- ------------------------------------------------------------------------
8 --
9 -- Description
10 --
11 -- Get the event standard price
12 --
13 function get_class_standard_price
14 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
15 return number;
16
17 -- ------------------------------------------------------------------------
18 -- |------------------------< get_Learning_path_name >----------------|
19 -- ------------------------------------------------------------------------
20 --
21 -- Description
22 --
23 -- Get the learning path name
24 --
25 function get_Learning_path_name
26 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
27 return varchar2;
28 -- ------------------------------------------------------------------------
29 -- |------------------------< get_course_primary_category >----------------|
30 -- ------------------------------------------------------------------------
31 --
32 -- Description
33 --
34 -- Get the course primary category
35 --
36 function get_course_primary_category
37 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
38 return varchar2;
39
40 --
41 -- ------------------------------------------------------------------------
42 -- |------------------------< Get_enrollment_status >-------------------------|
43 -- ------------------------------------------------------------------------
44 --
45 -- Description
46 --
47 -- Get the enrollment status
48 --
49 function get_enrollment_status
50 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
51 return varchar2;
52
53
54 --
55 -- ------------------------------------------------------------------------
56 -- |------------------------< get_ofr_delivery_mode >-------------------------|
57 -- ------------------------------------------------------------------------
58 --
59 -- Description
60 --
61 -- Get the delivery mode for the offering
62 --
63 function get_ofr_delivery_mode
64 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
65 return varchar2;
66
67 -- ------------------------------------------------------------------------
68 -- |------------------------< get_course_name >----------------|
69 -- ------------------------------------------------------------------------
70 --
71 -- Description
72 --
73 -- Get the course name
74 --
75 function get_course_name
76 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
77 return varchar2;
78
79 -- ------------------------------------------------------------------------
80 -- |------------------------< get_offering_name >----------------|
81 -- ------------------------------------------------------------------------
82 --
83 -- Description
84 --
85 -- Get the offering name
86 --
87 function get_offering_name
88 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
89 return varchar2;
90
91 -- ------------------------------------------------------------------------
92 -- |------------------------< get_class_name >----------------|
93 -- ------------------------------------------------------------------------
94 --
95 -- Description
96 --
97 -- Get the class name
98 --
99 function get_class_name
100 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
101 return varchar2;
102
103 -- ------------------------------------------------------------------------
104 -- |------------------------< get_class_location >----------------|
105 -- ------------------------------------------------------------------------
106 --
107 -- Description
108 --
109 -- Get the class location
110 --
111 function get_class_location
112 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
113 return varchar2;
114
115
116 function get_cert_period_end_date
117 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
118 return varchar2 ;
119
120 function get_cert_period_start_date
121 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
122 return varchar2;
123
124 function get_certification_name
125 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
126 return varchar2;
127
128 function get_certification_type
129 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
130 return varchar2;
131
132 function get_init_cert_comp_date
133 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
134 return varchar2 ;
135
136 function get_init_cert_dur
137 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
138 return varchar2;
139
140 function get_renewal_duration
141 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
142 return varchar2;
143
144 function get_validity_duration
145 (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
146 return varchar2;
147
148
149 END ota_ame_attributes;