APPS.OKL_FUNDING_WF dependencies on OKL_TRX_CONTRACTS

Line 416: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

412: l_requester VARCHAR2(200);
413: l_name VARCHAR2(200);
414: l_requester_id VARCHAR2(200);
415:
416: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
417: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
418: l_approval_option VARCHAR2(5);
419:
420: BEGIN

Line 417: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

413: l_name VARCHAR2(200);
414: l_requester_id VARCHAR2(200);
415:
416: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
417: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
418: l_approval_option VARCHAR2(5);
419:
420: BEGIN
421: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 486: Okl_Trx_Contracts_Pub.create_trx_contracts(

482: l_trxH_in_rec.source_trx_id := l_key;
483: l_trxH_in_rec.source_trx_type := G_SOURCE_TRX_TYPE_WF;
484:
485: -- Create Transaction Header
486: Okl_Trx_Contracts_Pub.create_trx_contracts(
487: p_api_version => l_api_version
488: ,p_init_msg_list => l_init_msg_list
489: ,x_return_status => l_return_status
490: ,x_msg_count => l_msg_count

Line 1422: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)

1418: actid IN NUMBER,
1419: funcmode IN VARCHAR2,
1420: resultout OUT NOCOPY VARCHAR2)
1421: IS
1422: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
1423: IS
1424: SELECT id
1425: FROM okl_trx_contracts
1426: WHERE trx_number = p_trx_number

Line 1425: FROM okl_trx_contracts

1421: IS
1422: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
1423: IS
1424: SELECT id
1425: FROM okl_trx_contracts
1426: WHERE trx_number = p_trx_number
1427: --rkuttiya added for 12.1.1 Multi GAAP Project
1428: AND representation_type = 'PRIMARY';
1429: --

Line 1442: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1438: l_funding_id okl_trx_ap_invoices_b.id%TYPE;
1439: l_approved_yn VARCHAR2(30);
1440: l_trx_number VARCHAR2(100);
1441:
1442: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1443: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1444:
1445: -- variables for bug 4900097 - Start
1446: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

Line 1443: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1439: l_approved_yn VARCHAR2(30);
1440: l_trx_number VARCHAR2(100);
1441:
1442: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1443: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1444:
1445: -- variables for bug 4900097 - Start
1446: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
1447: l_khr_id OKC_K_HEADERS_B.ID%TYPE;

Line 1503: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)

1499: l_trx_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1500: itemkey => itemkey,
1501: aname => G_WF_ITM_TRANSACTION_ID);
1502:
1503: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)
1504: LOOP
1505: l_trxH_in_rec.id := l_okl_trx_contracts_rec.id;
1506: END LOOP;
1507:

Line 1505: l_trxH_in_rec.id := l_okl_trx_contracts_rec.id;

1501: aname => G_WF_ITM_TRANSACTION_ID);
1502:
1503: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)
1504: LOOP
1505: l_trxH_in_rec.id := l_okl_trx_contracts_rec.id;
1506: END LOOP;
1507:
1508: l_trxH_in_rec.tsu_code := G_TRX_TSU_CODE_PROCESSED;
1509:

Line 1510: Okl_Trx_Contracts_Pub.update_trx_contracts(

1506: END LOOP;
1507:
1508: l_trxH_in_rec.tsu_code := G_TRX_TSU_CODE_PROCESSED;
1509:
1510: Okl_Trx_Contracts_Pub.update_trx_contracts(
1511: p_api_version => l_api_version
1512: ,p_init_msg_list => l_init_msg_list
1513: ,x_return_status => l_return_status
1514: ,x_msg_count => l_msg_count