APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_TXL_ITM_INSTS

Line 258: OKL_TXL_ITM_INSTS TXL,

254: CURSOR c_get_entered_alc_trx(cp_kle_id IN NUMBER)
255: IS
256: SELECT 'X'
257: FROM OKL_TRX_ASSETS TRX,
258: OKL_TXL_ITM_INSTS TXL,
259: OKL_TRX_TYPES_B TRY
260: WHERE TRX.ID = TXL.TAS_ID
261: AND TRX.TRY_ID = TRY.ID
262: AND TRY.TRX_TYPE_CLASS = 'ASSET_RELOCATION'

Line 482: ---Creating records in Okl_txl_itm_insts

478: OPEN c_ib_inst(l_c_item.object1_id1,l_c_item.object1_id2);
479: FETCH c_ib_inst INTO l_c_ib_inst;
480: IF c_ib_inst%FOUND THEN
481:
482: ---Creating records in Okl_txl_itm_insts
483:
484: l_itiv_rec.kle_id := l_c_item.cle_id;
485: l_itiv_rec.dnz_cle_id := p_loc_rec.parent_line_id;
486: l_itiv_rec.line_number := G_CTR;

Line 708: OKL_TXL_ITM_INSTS_PUB.create_txl_itm_insts(

704: END IF;
705: -- evaluate conditions, build outcomes for true conditions and
706: -- put them on outcome queue
707:
708: OKL_TXL_ITM_INSTS_PUB.create_txl_itm_insts(
709: p_api_version => p_api_version,
710: p_init_msg_list => p_init_msg_list,
711: x_return_status => x_return_status,
712: x_msg_count => x_msg_count,

Line 1801: OKL_TXL_ITM_INSTS TXL,

1797: SELECT TRX.ID,TRX.TSU_CODE, TXL.object_id1_new, TXL.object_id2_new,
1798: TXL.object_id1_old,object_id2_old,psu.location_id, psu.party_site_id,
1799: TRX.DATE_TRANS_OCCURRED,TRX.req_asset_id
1800: FROM OKL_TRX_ASSETS TRX,
1801: OKL_TXL_ITM_INSTS TXL,
1802: OKL_TRX_TYPES_B TRY,
1803: OKX_PARTY_SITE_USES_V psu
1804: WHERE TRX.ID = TXL.TAS_ID
1805: AND TRX.TRY_ID = TRY.ID