APPS.OKL_KBK_APPROVALS_WF dependencies on OKL_TRX_CONTRACTS

Line 286: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

282: l_requester VARCHAR2(200);
283: l_name VARCHAR2(200);
284: l_requester_id VARCHAR2(200);
285:
286: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
287: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
288: l_approval_option VARCHAR2(5);
289: --Added by dpsingh for LE Uptake
290: l_legal_entity_id NUMBER;

Line 287: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

283: l_name VARCHAR2(200);
284: l_requester_id VARCHAR2(200);
285:
286: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
287: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
288: l_approval_option VARCHAR2(5);
289: --Added by dpsingh for LE Uptake
290: l_legal_entity_id NUMBER;
291: BEGIN

Line 355: Okl_Trx_Contracts_Pub.create_trx_contracts(

351: p_token1_value => l_contract_num);
352: RAISE OKL_API.G_EXCEPTION_ERROR;
353: END IF;
354: -- Create Transaction Header
355: Okl_Trx_Contracts_Pub.create_trx_contracts(
356: p_api_version => l_api_version
357: ,p_init_msg_list => l_init_msg_list
358: ,x_return_status => l_return_status
359: ,x_msg_count => l_msg_count

Line 1262: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)

1258: actid IN NUMBER,
1259: funcmode IN VARCHAR2,
1260: resultout OUT NOCOPY VARCHAR2)
1261: IS
1262: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
1263: IS
1264: SELECT id
1265: FROM okl_trx_contracts
1266: WHERE trx_number = p_trx_number

Line 1265: FROM okl_trx_contracts

1261: IS
1262: CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
1263: IS
1264: SELECT id
1265: FROM okl_trx_contracts
1266: WHERE trx_number = p_trx_number
1267: --rkuttiya added for 12.1.1 Multi GAAP Project
1268: AND representation_type = 'PRIMARY';
1269: --

Line 1282: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1278: l_chrv_id OKC_K_HEADERS_V.ID%TYPE;
1279: l_approved_yn VARCHAR2(30);
1280: l_trx_number VARCHAR2(100);
1281:
1282: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1283: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1284:
1285: BEGIN
1286: -- We getting the contract_Id from WF

Line 1283: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1279: l_approved_yn VARCHAR2(30);
1280: l_trx_number VARCHAR2(100);
1281:
1282: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1283: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1284:
1285: BEGIN
1286: -- We getting the contract_Id from WF
1287: l_chrv_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1342: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)

1338: l_trx_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1339: itemkey => itemkey,
1340: aname => G_WF_ITM_TRANSACTION_ID);
1341:
1342: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)
1343: LOOP
1344: l_trxH_in_rec.id := l_okl_trx_contracts_rec.id;
1345: END LOOP;
1346:

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

1340: aname => G_WF_ITM_TRANSACTION_ID);
1341:
1342: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)
1343: LOOP
1344: l_trxH_in_rec.id := l_okl_trx_contracts_rec.id;
1345: END LOOP;
1346:
1347: l_trxH_in_rec.tsu_code := G_TRX_TSU_CODE_PROCESSED;
1348:

Line 1349: Okl_Trx_Contracts_Pub.update_trx_contracts(

1345: END LOOP;
1346:
1347: l_trxH_in_rec.tsu_code := G_TRX_TSU_CODE_PROCESSED;
1348:
1349: Okl_Trx_Contracts_Pub.update_trx_contracts(
1350: p_api_version => l_api_version
1351: ,p_init_msg_list => l_init_msg_list
1352: ,x_return_status => l_return_status
1353: ,x_msg_count => l_msg_count