APPS.OKL_FUNDING_WF dependencies on OKL_TRX_CONTRACTS

Line 447: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

443: l_requester VARCHAR2(200);
444: l_name VARCHAR2(200);
445: l_requester_id VARCHAR2(200);
446:
447: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
448: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
449: l_approval_option VARCHAR2(5);
450:
451: BEGIN

Line 448: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

444: l_name VARCHAR2(200);
445: l_requester_id VARCHAR2(200);
446:
447: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
448: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
449: l_approval_option VARCHAR2(5);
450:
451: BEGIN
452: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 517: Okl_Trx_Contracts_Pub.create_trx_contracts(

513: l_trxH_in_rec.source_trx_id := l_key;
514: l_trxH_in_rec.source_trx_type := G_SOURCE_TRX_TYPE_WF;
515:
516: -- Create Transaction Header
517: Okl_Trx_Contracts_Pub.create_trx_contracts(
518: p_api_version => l_api_version
519: ,p_init_msg_list => l_init_msg_list
520: ,x_return_status => l_return_status
521: ,x_msg_count => l_msg_count

Line 1464: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)

1460: actid IN NUMBER,
1461: funcmode IN VARCHAR2,
1462: resultout OUT NOCOPY VARCHAR2)
1463: IS
1464: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
1465: IS
1466: SELECT id
1467: FROM okl_trx_contracts
1468: WHERE trx_number = p_trx_number

Line 1467: FROM okl_trx_contracts

1463: IS
1464: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
1465: IS
1466: SELECT id
1467: FROM okl_trx_contracts
1468: WHERE trx_number = p_trx_number
1469: --rkuttiya added for 12.1.1 Multi GAAP Project
1470: AND representation_type = 'PRIMARY';
1471: --

Line 1492: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1488: l_funding_id okl_trx_ap_invoices_b.id%TYPE;
1489: l_approved_yn VARCHAR2(30);
1490: l_trx_number VARCHAR2(100);
1491:
1492: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1493: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1494:
1495: -- variables for bug 4900097 - Start
1496: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

Line 1493: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1489: l_approved_yn VARCHAR2(30);
1490: l_trx_number VARCHAR2(100);
1491:
1492: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1493: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1494:
1495: -- variables for bug 4900097 - Start
1496: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
1497: l_khr_id OKC_K_HEADERS_B.ID%TYPE;

Line 1567: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)

1563: l_trx_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1564: itemkey => itemkey,
1565: aname => G_WF_ITM_TRANSACTION_ID);
1566:
1567: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)
1568: LOOP
1569: l_trxH_in_rec.id := l_okl_trx_contracts_rec.id;
1570: END LOOP;
1571:

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

1565: aname => G_WF_ITM_TRANSACTION_ID);
1566:
1567: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)
1568: LOOP
1569: l_trxH_in_rec.id := l_okl_trx_contracts_rec.id;
1570: END LOOP;
1571:
1572: l_trxH_in_rec.tsu_code := G_TRX_TSU_CODE_PROCESSED;
1573:

Line 1574: Okl_Trx_Contracts_Pub.update_trx_contracts(

1570: END LOOP;
1571:
1572: l_trxH_in_rec.tsu_code := G_TRX_TSU_CODE_PROCESSED;
1573:
1574: Okl_Trx_Contracts_Pub.update_trx_contracts(
1575: p_api_version => l_api_version
1576: ,p_init_msg_list => l_init_msg_list
1577: ,x_return_status => l_return_status
1578: ,x_msg_count => l_msg_count