[Home] [Help]
2224: open csrOfferDetails(rec.transaction_id);
2225: fetch csrOfferDetails into l_offer_id, l_applicant_assignment_id,l_offer_status;
2226: close csrOfferDetails;
2227:
2228: hr_transaction_api.rollback_transaction(p_transaction_id => rec.transaction_id);
2229:
2230: begin
2231: /* To check if it is the approval process for an offer. If yes, close the offer*/
2232: if l_offer_id is not null then
2353:
2354: BEGIN -- Block to 'purge' the data in the SSHR transaction tables.
2355: -- get the transaction for this transaction from workflow
2356: -- TRANSACTION_ID
2357: hr_transaction_api.rollback_transaction(p_transaction_id => rec.transaction_id );
2358: exception
2359: when others then
2360: wf_core.Context(g_package, 'remove_defunct_process',
2361: itemtype, itemkey, to_char(actid),
2376:
2377: --Bug fix 8358911
2378: for rec in csr_wfdfctitms_newarch(l_transaction_age,c_status) loop
2379: begin
2380: hr_transaction_api.rollback_transaction(p_transaction_id => rec.transaction_id );
2381: exception
2382: when others then
2383: wf_core.Context(g_package, 'remove_defunct_process',
2384: itemtype, itemkey, to_char(actid),
2395: wf_engine.abortprocess(itemtype => rec.item_type
2396: ,itemkey => rec.item_key
2397: ,result => 'eng_force');
2398:
2399: hr_transaction_api.rollback_transaction(p_transaction_id => rec.transaction_id );
2400:
2401: exception
2402: when others then
2403: wf_core.Context(g_package, 'remove_defunct_process',
2570: resultout := wf_engine.eng_null;
2571: return;
2572: end if;
2573:
2574: hr_transaction_api.Set_Process_Order_String(p_item_type => itemtype
2575: ,p_item_key => itemkey
2576: ,p_actid => actid);
2577:
2578: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||