APPS.BEN_CWB_SINGLE_PER_PROCESS_PKG dependencies on BEN_TRANSACTION

Line 344: insert into ben_transaction( transaction_id

340: else
341: l_index := FND_MSG_PUB.G_NEXT;
342: end if;
343: l_err := FND_MSG_PUB.GET_DETAIL(p_msg_index => l_index);
344: insert into ben_transaction( transaction_id
345: ,transaction_type
346: ,status
347: ,attribute1
348: ,attribute2

Line 351: values( BEN_TRANSACTION_S.NEXTVAL

347: ,attribute1
348: ,attribute2
349: --,attribute3
350: )
351: values( BEN_TRANSACTION_S.NEXTVAL
352: ,'EMPENROLL'||l_benefit_action_id
353: ,'E'
354: --,FND_MSG_PUB.GET_DETAIL(p_msg_index => l_index)
355: ,replace(l_err,chr(0),' ')

Line 376: from ben_benefit_actions actn, ben_transaction, fnd_concurrent_requests req

372: procedure recreate_error_stack(p_request_id in number) is
373:
374: cursor c_errors(v_request_id in number) is
375: select attribute1
376: from ben_benefit_actions actn, ben_transaction, fnd_concurrent_requests req
377: where req.request_id = v_request_id
378: and req.request_id = actn.request_id
379: and transaction_type = 'EMPENROLL'||benefit_action_id
380: and attribute2 = req.ARGUMENT3;