APPS.OKC_OUTCOME_INIT_PVT dependencies on OKS_DA_INTERFACE_B

Line 276: okc_debug.Log('Inserting data into interface table OKS_DA_INTERFACE_B',2);

272: );
273: ELSE
274:
275: IF (l_debug = 'Y') THEN
276: okc_debug.Log('Inserting data into interface table OKS_DA_INTERFACE_B',2);
277: END IF;
278:
279: INSERT INTO OKS_DA_INTERFACE_B
280: (id,contract_id,enque_date,status,proc,proc_name,s_recipient,e_recipient,extra_attr_text)values

Line 279: INSERT INTO OKS_DA_INTERFACE_B

275: IF (l_debug = 'Y') THEN
276: okc_debug.Log('Inserting data into interface table OKS_DA_INTERFACE_B',2);
277: END IF;
278:
279: INSERT INTO OKS_DA_INTERFACE_B
280: (id,contract_id,enque_date,status,proc,proc_name,s_recipient,e_recipient,extra_attr_text)values
281: (OKS_DA_INTERFACE_S.NEXTVAL,l_contract_id,SYSDATE,'PENDING',l_proc,l_proc_name,l_s_recipient,l_e_recipient,okc_wf.get_wf_string);
282:
283: END IF;

Line 797: FROM OKS_DA_INTERFACE_B

793: --Get all the contracts information captured to launch the workflow
794: CURSOR launch_wf_csr(l_tot_que IN number) IS
795: SELECT * from
796: (SELECT *
797: FROM OKS_DA_INTERFACE_B
798: WHERE status IN ('PENDING','ERROR')
799: ORDER BY enque_date)
800: where ROWNUM<=l_tot_que;
801:

Line 851: UPDATE OKS_DA_INTERFACE_B

847:
848:
849:
850: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
851: UPDATE OKS_DA_INTERFACE_B
852: SET status='ERROR'
853: WHERE id=launch_wf_rec.id;
854:
855: ELSE

Line 859: DELETE from OKS_DA_INTERFACE_B

855: ELSE
856:
857: l_oks_cnt:=l_oks_cnt+1;
858:
859: DELETE from OKS_DA_INTERFACE_B
860: WHERE id=launch_wf_rec.id;
861:
862: END IF;
863: