DBA Data[Home] [Help]

APPS.OTA_AME_ATTRIBUTES dependencies on HR_API_TRANSACTIONS

Line 14: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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 >----------------|

Line 26: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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: -- ------------------------------------------------------------------------

Line 37: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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: -- ------------------------------------------------------------------------

Line 50: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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: --

Line 64: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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 >----------------|

Line 76: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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 >----------------|

Line 88: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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 >----------------|

Line 100: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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 >----------------|

Line 112: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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

Line 117: (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)

Line 121: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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)

Line 125: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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)

Line 129: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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)

Line 133: (p_transaction_id IN hr_api_transactions.transaction_id%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)

Line 137: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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)

Line 141: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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)

Line 145: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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;