DBA Data[Home] [Help]

APPS.HR_CAED_SS dependencies on HR_TRANSACTION_API

Line 68: hr_transaction_api.create_transaction_step(

64:
65: --There is no transaction step for this transaction.
66: --Create a step within this new transaction
67:
68: hr_transaction_api.create_transaction_step(
69: p_validate => false
70: ,p_creator_person_id => p_login_person_id
71: ,p_transaction_id => ln_transaction_id
72: ,p_api_name => 'HR_CAED_SS.PROCESS_API'

Line 82: hr_transaction_api.set_varchar2_value (

78:
79: END IF;
80:
81: -- write activity name to txn table
82: hr_transaction_api.set_varchar2_value (
83: p_transaction_step_id =>ln_transaction_step_id,
84: p_person_id => lv_creator_person_id ,
85: p_name => 'p_activity_name' ,
86: p_value =>'HR_CAED' ) ;

Line 88: hr_transaction_api.set_varchar2_value (

84: p_person_id => lv_creator_person_id ,
85: p_name => 'p_activity_name' ,
86: p_value =>'HR_CAED' ) ;
87:
88: hr_transaction_api.set_varchar2_value (
89: p_transaction_step_id =>ln_transaction_step_id,
90: p_person_id => lv_creator_person_id ,
91: p_name => 'P_REVIEW_ACTID' ,
92: p_value =>p_act_id ) ;

Line 137: hr_transaction_api.set_varchar2_value (

133: hr_util_misc_web.validate_session(p_person_id => lv_creator_person_id);
134:
135:
136:
137: hr_transaction_api.set_varchar2_value (
138: p_transaction_step_id =>p_transaction_step_id,
139: p_person_id => lv_creator_person_id ,
140: p_name => 'P_REVIEW_PROC_CALL' ,
141: p_value =>p_review_proc_call ) ;

Line 144: hr_transaction_api.set_varchar2_value (

140: p_name => 'P_REVIEW_PROC_CALL' ,
141: p_value =>p_review_proc_call ) ;
142:
143:
144: hr_transaction_api.set_varchar2_value (
145: p_transaction_step_id =>p_transaction_step_id,
146: p_person_id => lv_creator_person_id ,
147: p_name => 'p_action_type' ,
148: p_value =>p_action ) ;

Line 151: hr_transaction_api.set_varchar2_value (

147: p_name => 'p_action_type' ,
148: p_value =>p_action ) ;
149:
150:
151: hr_transaction_api.set_varchar2_value (
152: p_transaction_step_id =>p_transaction_step_id,
153: p_person_id => lv_creator_person_id ,
154: p_name => 'p_granted_emp_name' ,
155: p_value =>p_granted_emp_name ) ;

Line 157: hr_transaction_api.set_varchar2_value (

153: p_person_id => lv_creator_person_id ,
154: p_name => 'p_granted_emp_name' ,
155: p_value =>p_granted_emp_name ) ;
156:
157: hr_transaction_api.set_varchar2_value (
158: p_transaction_step_id =>p_transaction_step_id,
159: p_person_id => lv_creator_person_id ,
160: p_name => 'p_deleted_emp_name' ,
161: p_value =>p_deleted_emp_name ) ;

Line 163: hr_transaction_api.set_number_value (

159: p_person_id => lv_creator_person_id ,
160: p_name => 'p_deleted_emp_name' ,
161: p_value =>p_deleted_emp_name ) ;
162:
163: hr_transaction_api.set_number_value (
164: p_transaction_step_id =>p_transaction_step_id,
165: p_person_id => lv_creator_person_id ,
166: p_name => 'p_granted_emp_id' ,
167: p_value =>p_granted_emp_id ) ;

Line 169: hr_transaction_api.set_number_value (

165: p_person_id => lv_creator_person_id ,
166: p_name => 'p_granted_emp_id' ,
167: p_value =>p_granted_emp_id ) ;
168:
169: hr_transaction_api.set_number_value (
170: p_transaction_step_id =>p_transaction_step_id,
171: p_person_id => lv_creator_person_id ,
172: p_name => 'p_login_person_id' ,
173: p_value =>p_login_person_id ) ;

Line 176: hr_transaction_api.set_number_value (

172: p_name => 'p_login_person_id' ,
173: p_value =>p_login_person_id ) ;
174:
175:
176: hr_transaction_api.set_number_value (
177: p_transaction_step_id =>p_transaction_step_id,
178: p_person_id => lv_creator_person_id ,
179: p_name => 'p_emp_person_id' ,
180: p_value =>p_emp_person_id ) ;

Line 183: hr_transaction_api.set_number_value (

179: p_name => 'p_emp_person_id' ,
180: p_value =>p_emp_person_id ) ;
181:
182:
183: hr_transaction_api.set_number_value (
184: p_transaction_step_id =>p_transaction_step_id,
185: p_person_id => lv_creator_person_id ,
186: p_name => 'p_granted_user_id' ,
187: p_value =>p_granted_user_id ) ;

Line 189: hr_transaction_api.set_number_value (

185: p_person_id => lv_creator_person_id ,
186: p_name => 'p_granted_user_id' ,
187: p_value =>p_granted_user_id ) ;
188:
189: hr_transaction_api.set_number_value (
190: p_transaction_step_id =>p_transaction_step_id,
191: p_person_id => lv_creator_person_id ,
192: p_name => 'p_deleted_emp_id' ,
193: p_value =>p_deleted_emp_id ) ;

Line 195: hr_transaction_api.set_number_value (

191: p_person_id => lv_creator_person_id ,
192: p_name => 'p_deleted_emp_id' ,
193: p_value =>p_deleted_emp_id ) ;
194:
195: hr_transaction_api.set_number_value (
196: p_transaction_step_id =>p_transaction_step_id,
197: p_person_id => lv_creator_person_id ,
198: p_name => 'p_deleted_emp_user_id' ,
199: p_value =>p_deleted_emp_user_id ) ;

Line 201: hr_transaction_api.set_varchar2_value (

197: p_person_id => lv_creator_person_id ,
198: p_name => 'p_deleted_emp_user_id' ,
199: p_value =>p_deleted_emp_user_id ) ;
200:
201: hr_transaction_api.set_varchar2_value (
202: p_transaction_step_id =>p_transaction_step_id,
203: p_person_id => lv_creator_person_id ,
204: p_name => 'P_REVIEW_PROC_CALL' ,
205: p_value =>p_review_proc_call ) ;

Line 436: lv_action_type := hr_transaction_api.get_varchar2_value(

432:
433: BEGIN
434:
435: hr_utility.set_location(' Entering:' || l_proc,5);
436: lv_action_type := hr_transaction_api.get_varchar2_value(
437: p_transaction_step_id => p_transaction_step_id,
438: p_name =>'p_action_type');
439:
440: ln_granted_emp_id := hr_transaction_api.get_number_value(

Line 440: ln_granted_emp_id := hr_transaction_api.get_number_value(

436: lv_action_type := hr_transaction_api.get_varchar2_value(
437: p_transaction_step_id => p_transaction_step_id,
438: p_name =>'p_action_type');
439:
440: ln_granted_emp_id := hr_transaction_api.get_number_value(
441: p_transaction_step_id => p_transaction_step_id,
442: p_name =>'p_granted_emp_id');
443:
444: ln_emp_person_id := hr_transaction_api.get_number_value(

Line 444: ln_emp_person_id := hr_transaction_api.get_number_value(

440: ln_granted_emp_id := hr_transaction_api.get_number_value(
441: p_transaction_step_id => p_transaction_step_id,
442: p_name =>'p_granted_emp_id');
443:
444: ln_emp_person_id := hr_transaction_api.get_number_value(
445: p_transaction_step_id => p_transaction_step_id,
446: p_name =>'p_emp_person_id');
447:
448: ln_granted_user_id := hr_transaction_api.get_number_value(

Line 448: ln_granted_user_id := hr_transaction_api.get_number_value(

444: ln_emp_person_id := hr_transaction_api.get_number_value(
445: p_transaction_step_id => p_transaction_step_id,
446: p_name =>'p_emp_person_id');
447:
448: ln_granted_user_id := hr_transaction_api.get_number_value(
449: p_transaction_step_id => p_transaction_step_id,
450: p_name =>'p_granted_user_id');
451:
452: ln_deleted_emp_id := hr_transaction_api.get_number_value(

Line 452: ln_deleted_emp_id := hr_transaction_api.get_number_value(

448: ln_granted_user_id := hr_transaction_api.get_number_value(
449: p_transaction_step_id => p_transaction_step_id,
450: p_name =>'p_granted_user_id');
451:
452: ln_deleted_emp_id := hr_transaction_api.get_number_value(
453: p_transaction_step_id => p_transaction_step_id,
454: p_name =>'p_deleted_emp_id');
455:
456: ln_deleted_emp_user_id := hr_transaction_api.get_number_value(

Line 456: ln_deleted_emp_user_id := hr_transaction_api.get_number_value(

452: ln_deleted_emp_id := hr_transaction_api.get_number_value(
453: p_transaction_step_id => p_transaction_step_id,
454: p_name =>'p_deleted_emp_id');
455:
456: ln_deleted_emp_user_id := hr_transaction_api.get_number_value(
457: p_transaction_step_id =>
458: p_transaction_step_id,
459: p_name =>'p_deleted_emp_user_id');
460: