APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_TXL_ITM_INSTS

Line 226: OKL_TXL_ITM_INSTS TXL,

222: CURSOR c_get_entered_alc_trx(cp_kle_id IN NUMBER)
223: IS
224: SELECT 'X'
225: FROM OKL_TRX_ASSETS TRX,
226: OKL_TXL_ITM_INSTS TXL,
227: OKL_TRX_TYPES_B TRY
228: WHERE TRX.ID = TXL.TAS_ID
229: AND TRX.TRY_ID = TRY.ID
230: AND TRY.TRX_TYPE_CLASS = 'ASSET_RELOCATION'

Line 450: ---Creating records in Okl_txl_itm_insts

446: OPEN c_ib_inst(l_c_item.object1_id1,l_c_item.object1_id2);
447: FETCH c_ib_inst INTO l_c_ib_inst;
448: IF c_ib_inst%FOUND THEN
449:
450: ---Creating records in Okl_txl_itm_insts
451:
452: l_itiv_rec.kle_id := l_c_item.cle_id;
453: l_itiv_rec.dnz_cle_id := p_loc_rec.parent_line_id;
454: l_itiv_rec.line_number := G_CTR;

Line 676: OKL_TXL_ITM_INSTS_PUB.create_txl_itm_insts(

672: END IF;
673: -- evaluate conditions, build outcomes for true conditions and
674: -- put them on outcome queue
675:
676: OKL_TXL_ITM_INSTS_PUB.create_txl_itm_insts(
677: p_api_version => p_api_version,
678: p_init_msg_list => p_init_msg_list,
679: x_return_status => x_return_status,
680: x_msg_count => x_msg_count,

Line 1769: OKL_TXL_ITM_INSTS TXL,

1765: SELECT TRX.ID,TRX.TSU_CODE, TXL.object_id1_new, TXL.object_id2_new,
1766: TXL.object_id1_old,object_id2_old,psu.location_id, psu.party_site_id,
1767: TRX.DATE_TRANS_OCCURRED,TRX.req_asset_id
1768: FROM OKL_TRX_ASSETS TRX,
1769: OKL_TXL_ITM_INSTS TXL,
1770: OKL_TRX_TYPES_B TRY,
1771: OKX_PARTY_SITE_USES_V psu
1772: WHERE TRX.ID = TXL.TAS_ID
1773: AND TRX.TRY_ID = TRY.ID