130: l_transaction_id number default null;
131: l_transaction_step_id number default null;
132: l_trans_obj_vers_num number default null;
133: l_count integer default 0;
134: l_transaction_table hr_transaction_ss.transaction_table;
135: l_review_item_name varchar2(50);
136: l_message_number VARCHAR2(10);
137: l_result varchar2(100) default null;
138: l_old_transaction_step_id number;
140:
141: begin
142:
143: -- First, check if transaction id exists or not
144: l_transaction_id := hr_transaction_ss.get_transaction_id
145: (p_item_type => p_item_type
146: ,p_item_key => p_item_key);
147:
148: --
147:
148: --
149: IF l_transaction_id is null THEN
150: -- Start a Transaction
151: hr_transaction_ss.start_transaction
152: (itemtype => p_item_type
153: ,itemkey => p_item_key
154: ,actid => p_activity_id
155: ,funmode => 'RUN'
155: ,funmode => 'RUN'
156: ,p_login_person_id => p_login_person_id
157: ,result => l_result);
158:
159: l_transaction_id := hr_transaction_ss.get_transaction_id
160: (p_item_type => p_item_type
161: ,p_item_key => p_item_key);
162: END IF;
163:
400: --bug 4146681
401:
402: End If;
403:
404: hr_transaction_ss.save_transaction_step
405: (p_item_type => p_item_type
406: ,p_item_key => p_item_key
407: ,p_actid => p_activity_id
408: ,p_login_person_id => p_login_person_id