DBA Data[Home] [Help]

APPS.OKL_EQUIPMENT_EXCHANGE_PVT dependencies on OKL_TRX_ASSETS

Line 95: FROM OKL_TRX_ASSETS

91: TRY_ID,
92: DATE_TRANS_OCCURRED
93: ,TRANS_NUMBER
94: ,COMMENTS
95: FROM OKL_TRX_ASSETS
96: WHERE OKL_TRX_ASSETS.id = p_id;
97: l_okl_tasv_pk okl_tasv_pk_csr%ROWTYPE;
98: l_thpv_tbl thpv_tbl_type;
99: BEGIN

Line 96: WHERE OKL_TRX_ASSETS.id = p_id;

92: DATE_TRANS_OCCURRED
93: ,TRANS_NUMBER
94: ,COMMENTS
95: FROM OKL_TRX_ASSETS
96: WHERE OKL_TRX_ASSETS.id = p_id;
97: l_okl_tasv_pk okl_tasv_pk_csr%ROWTYPE;
98: l_thpv_tbl thpv_tbl_type;
99: BEGIN
100: p_no_data_found := TRUE;

Line 457: FROM OKL_TRX_ASSETS

453: l_exchange_type VARCHAR2(60);
454:
455: CURSOR c_exch_type IS
456: SELECT TAS_TYPE
457: FROM OKL_TRX_ASSETS
458: WHERE ID=p_tas_id;
459: BEGIN
460:
461: OPEN c_exch_type;

Line 972: okl_trx_assets_pub.create_trx_ass_h_def(

968:
969: OPEN okl_trn_c;
970: FETCH okl_trn_c INTO l_thpv_tbl(1).trans_number;
971: CLOSE okl_trn_c;
972: okl_trx_assets_pub.create_trx_ass_h_def(
973: p_api_version => p_api_version,
974: p_init_msg_list => p_init_msg_list,
975: x_return_status => x_return_status,
976: x_msg_count => x_msg_count,

Line 1391: okl_trx_assets_pub.update_trx_ass_h_def(

1387: --concerned person abt this. How do we do this?
1388: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1389: p_thpv_tbl(1).id := p_tas_id;
1390: p_thpv_tbl(1).tsu_code := 'PROCESSED';
1391: okl_trx_assets_pub.update_trx_ass_h_def(
1392: p_api_version => p_api_version,
1393: p_init_msg_list => p_init_msg_list,
1394: x_return_status => x_return_status,
1395: x_msg_count => x_msg_count,