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 944: okl_trx_assets_pub.create_trx_ass_h_def(

940:
941: OPEN okl_trn_c;
942: FETCH okl_trn_c INTO l_thpv_tbl(1).trans_number;
943: CLOSE okl_trn_c;
944: okl_trx_assets_pub.create_trx_ass_h_def(
945: p_api_version => p_api_version,
946: p_init_msg_list => p_init_msg_list,
947: x_return_status => x_return_status,
948: x_msg_count => x_msg_count,

Line 1363: okl_trx_assets_pub.update_trx_ass_h_def(

1359: --concerned person abt this. How do we do this?
1360: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1361: p_thpv_tbl(1).id := p_tas_id;
1362: p_thpv_tbl(1).tsu_code := 'PROCESSED';
1363: okl_trx_assets_pub.update_trx_ass_h_def(
1364: p_api_version => p_api_version,
1365: p_init_msg_list => p_init_msg_list,
1366: x_return_status => x_return_status,
1367: x_msg_count => x_msg_count,