DBA Data[Home] [Help]

APPS.OKL_COPY_ASSET_PVT dependencies on OKL_TRX_ASSETS

Line 83: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;

79: -------------------------------------------------------------------------------------------------
80: subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;
81: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.clev_rec_type;
82: subtype klev_rec_type is OKL_CONTRACT_PUB.klev_rec_type;
83: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;
84: subtype trxv_tbl_type is OKL_TRX_ASSETS_PUB.thpv_tbl_type;
85: subtype talv_rec_type is OKL_TXL_ASSETS_PUB.tlpv_rec_type;
86: subtype talv_tbl_type is OKL_TXL_ASSETS_PUB.tlpv_tbl_type;
87: subtype txdv_tbl_type is OKL_TXD_ASSETS_PUB.adpv_tbl_type;

Line 84: subtype trxv_tbl_type is OKL_TRX_ASSETS_PUB.thpv_tbl_type;

80: subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;
81: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.clev_rec_type;
82: subtype klev_rec_type is OKL_CONTRACT_PUB.klev_rec_type;
83: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;
84: subtype trxv_tbl_type is OKL_TRX_ASSETS_PUB.thpv_tbl_type;
85: subtype talv_rec_type is OKL_TXL_ASSETS_PUB.tlpv_rec_type;
86: subtype talv_tbl_type is OKL_TXL_ASSETS_PUB.tlpv_tbl_type;
87: subtype txdv_tbl_type is OKL_TXD_ASSETS_PUB.adpv_tbl_type;
88: subtype txdv_rec_type is OKL_TXD_ASSETS_PUB.adpv_rec_type;

Line 1096: FROM OKL_TRX_ASSETS

1092: TRANS_NUMBER,
1093: COMMENTS,
1094: REQ_ASSET_ID,
1095: TOTAL_MATCH_AMOUNT
1096: FROM OKL_TRX_ASSETS
1097: WHERE id = p_tas_id;
1098: BEGIN
1099: OPEN c_trxv_rec(p_tas_id);
1100: FETCH c_trxv_rec INTO

Line 1900: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

1896: RAISE OKL_API.G_EXCEPTION_ERROR;
1897: END IF;
1898: -- evaluate conditions, build outcomes for true conditions and
1899: -- put them on outcome queue
1900: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
1901: p_api_version => p_api_version,
1902: p_init_msg_list => p_init_msg_list,
1903: x_return_status => x_return_status,
1904: x_msg_count => x_msg_count,

Line 1971: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

1967: RAISE OKL_API.G_EXCEPTION_ERROR;
1968: END IF;
1969: -- evaluate conditions, build outcomes for true conditions and
1970: -- put them on outcome queue
1971: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
1972: p_api_version => p_api_version,
1973: p_init_msg_list => p_init_msg_list,
1974: x_return_status => x_return_status,
1975: x_msg_count => x_msg_count,

Line 2549: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,

2545: x_return_status OUT NOCOPY VARCHAR2,
2546: x_msg_count OUT NOCOPY NUMBER,
2547: x_msg_data OUT NOCOPY VARCHAR2,
2548: p_talv_rec IN talv_rec_type,
2549: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
2550: x_trxv_rec OUT NOCOPY trxv_rec_type,
2551: x_talv_rec OUT NOCOPY talv_rec_type) IS
2552: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TXL_ASSET_LINE';
2553: l_trxv_rec trxv_rec_type;

Line 2750: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,

2746: x_msg_data OUT NOCOPY VARCHAR2,
2747: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
2748: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2749: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
2750: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
2751: x_trxv_rec OUT NOCOPY trxv_rec_type,
2752: x_talv_rec OUT NOCOPY talv_rec_type,
2753: x_txdv_tbl OUT NOCOPY txdv_tbl_type) IS
2754: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_HEADER_LINE_DETAILS';

Line 2829: p_token1_value => 'OKL_TRX_ASSETS record');

2825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2826: OKL_API.set_message(p_app_name => G_APP_NAME,
2827: p_msg_name => G_NO_MATCHING_RECORD,
2828: p_token1 => G_COL_NAME_TOKEN,
2829: p_token1_value => 'OKL_TRX_ASSETS record');
2830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2832: OKL_API.set_message(p_app_name => G_APP_NAME,
2833: p_msg_name => G_NO_MATCHING_RECORD,

Line 2835: p_token1_value => 'OKL_TRX_ASSETS record');

2831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2832: OKL_API.set_message(p_app_name => G_APP_NAME,
2833: p_msg_name => G_NO_MATCHING_RECORD,
2834: p_token1 => G_COL_NAME_TOKEN,
2835: p_token1_value => 'OKL_TRX_ASSETS record');
2836: RAISE OKL_API.G_EXCEPTION_ERROR;
2837: END IF;
2838: l_trxv_rec.tas_type := p_trans_type;
2839: l_trxv_rec.tsu_code := 'ENTERED';

Line 3049: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,

3045: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
3046: p_from_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3047: p_to_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3048: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
3049: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3050: x_trxv_rec OUT NOCOPY trxv_rec_type,
3051: x_talv_rec OUT NOCOPY talv_rec_type,
3052: x_txdv_tbl OUT NOCOPY txdv_tbl_type) IS
3053: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ASSET_TRX_LOAN';

Line 3300: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,

3296: x_return_status OUT NOCOPY VARCHAR2,
3297: x_msg_count OUT NOCOPY NUMBER,
3298: x_msg_data OUT NOCOPY VARCHAR2,
3299: p_itiv_rec IN itiv_rec_type,
3300: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3301: p_asset_number IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3302: x_trxv_rec OUT NOCOPY trxv_rec_type,
3303: x_itiv_rec OUT NOCOPY itiv_rec_type) IS
3304:

Line 3490: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,

3486: x_msg_data OUT NOCOPY VARCHAR2,
3487: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
3488: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
3489: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3490: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3491: p_asset_number IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3492: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
3493: x_trxv_rec OUT NOCOPY trxv_rec_type,
3494: x_itiv_rec OUT NOCOPY itiv_rec_type)

Line 3566: p_token1_value => 'OKL_TRX_ASSETS record');

3562: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3563: OKL_API.set_message(p_app_name => G_APP_NAME,
3564: p_msg_name => G_NO_MATCHING_RECORD,
3565: p_token1 => G_COL_NAME_TOKEN,
3566: p_token1_value => 'OKL_TRX_ASSETS record');
3567: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3568: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3569: OKL_API.set_message(p_app_name => G_APP_NAME,
3570: p_msg_name => G_NO_MATCHING_RECORD,

Line 3572: p_token1_value => 'OKL_TRX_ASSETS record');

3568: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3569: OKL_API.set_message(p_app_name => G_APP_NAME,
3570: p_msg_name => G_NO_MATCHING_RECORD,
3571: p_token1 => G_COL_NAME_TOKEN,
3572: p_token1_value => 'OKL_TRX_ASSETS record');
3573: RAISE OKL_API.G_EXCEPTION_ERROR;
3574: END IF;
3575: l_trxv_rec.tsu_code := 'ENTERED';
3576: l_trxv_rec.date_trans_occurred := sysdate;