APPS.OKL_CREDIT_LINE_WF dependencies on OKL_TRX_CONTRACTS

Line 332: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

328: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
329: l_requester VARCHAR2(200);
330: l_name VARCHAR2(200);
331: l_requester_id VARCHAR2(200);
332: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
333: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
334: l_approval_option VARCHAR2(5);
335:
336: BEGIN

Line 333: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

329: l_requester VARCHAR2(200);
330: l_name VARCHAR2(200);
331: l_requester_id VARCHAR2(200);
332: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
333: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
334: l_approval_option VARCHAR2(5);
335:
336: BEGIN
337:

Line 391: Okl_Trx_Contracts_Pub.create_trx_contracts(p_api_version => l_api_version

387: l_trxH_in_rec.source_trx_id := l_key;
388: l_trxH_in_rec.source_trx_type := G_SOURCE_TRX_TYPE_WF;
389:
390: -- Create Transaction Header
391: Okl_Trx_Contracts_Pub.create_trx_contracts(p_api_version => l_api_version
392: ,p_init_msg_list => l_init_msg_list
393: ,x_return_status => l_return_status
394: ,x_msg_count => l_msg_count
395: ,x_msg_data => l_msg_data

Line 1049: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)

1045: actid IN NUMBER,
1046: funcmode IN VARCHAR2,
1047: resultout OUT NOCOPY VARCHAR2)
1048: IS
1049: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
1050: IS
1051: SELECT id
1052: FROM okl_trx_contracts
1053: WHERE trx_number = p_trx_number;

Line 1052: FROM okl_trx_contracts

1048: IS
1049: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
1050: IS
1051: SELECT id
1052: FROM okl_trx_contracts
1053: WHERE trx_number = p_trx_number;
1054:
1055: l_return_status VARCHAR2(3) ;
1056: l_api_version NUMBER ;

Line 1065: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1061: l_chrv_id OKC_K_HEADERS_V.ID%TYPE;
1062: l_approved_yn VARCHAR2(30);
1063: l_trx_number VARCHAR2(100);
1064: lv_approval_status_ame VARCHAR2(10);
1065: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1066: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1067:
1068: BEGIN
1069:

Line 1066: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1062: l_approved_yn VARCHAR2(30);
1063: l_trx_number VARCHAR2(100);
1064: lv_approval_status_ame VARCHAR2(10);
1065: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1066: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1067:
1068: BEGIN
1069:
1070: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1124: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)

1120: l_trx_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1121: itemkey => itemkey,
1122: aname => G_WF_ITM_TRANSACTION_ID);
1123:
1124: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)
1125: LOOP
1126: l_trxH_in_rec.id := l_okl_trx_contracts_rec.id;
1127: END LOOP;
1128:

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

1122: aname => G_WF_ITM_TRANSACTION_ID);
1123:
1124: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)
1125: LOOP
1126: l_trxH_in_rec.id := l_okl_trx_contracts_rec.id;
1127: END LOOP;
1128:
1129: l_trxH_in_rec.tsu_code := G_TRX_TSU_CODE_PROCESSED;
1130:

Line 1131: Okl_Trx_Contracts_Pub.update_trx_contracts(

1127: END LOOP;
1128:
1129: l_trxH_in_rec.tsu_code := G_TRX_TSU_CODE_PROCESSED;
1130:
1131: Okl_Trx_Contracts_Pub.update_trx_contracts(
1132: p_api_version => l_api_version
1133: ,p_init_msg_list => l_init_msg_list
1134: ,x_return_status => l_return_status
1135: ,x_msg_count => l_msg_count