DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKL_TXD_ASSETS_PUB

Line 952: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;

948: l_txd_asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE;
949:
950: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
951: lx_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
952: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
953: lx_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
954:
955:
956: Begin

Line 953: lx_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;

949:
950: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
951: lx_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
952: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
953: lx_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
954:
955:
956: Begin
957: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1055: okl_txd_assets_pub.update_txd_asset_Def(

1051: IF l_txd_asset_number is not null then
1052: l_adpv_rec.id := l_txd_id;
1053: l_adpv_rec.asset_number := l_asset_no;
1054:
1055: okl_txd_assets_pub.update_txd_asset_Def(
1056: p_api_version => p_api_version,
1057: p_init_msg_list => p_init_msg_list,
1058: x_return_status => x_return_status,
1059: x_msg_count => x_msg_count,

Line 1817: l_adpv_tbl OKL_TXD_ASSETS_PUB.adpv_tbl_type;

1813: and cleb.dnz_chr_id = p_chr_id;
1814:
1815: l_txd_rec l_txd_csr%ROWTYPE;
1816:
1817: l_adpv_tbl OKL_TXD_ASSETS_PUB.adpv_tbl_type;
1818:
1819: i number;
1820: l_curr_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;
1821: l_curr_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;

Line 2994: l_adpv_tbl OKL_TXD_ASSETS_PUB.adpv_tbl_type;

2990: and lseb.lty_code = 'FIXED_ASSET'
2991: and cleb.dnz_chr_id = p_chr_id;
2992:
2993: l_txd_rec l_txd_csr%ROWTYPE;
2994: l_adpv_tbl OKL_TXD_ASSETS_PUB.adpv_tbl_type;
2995: i number;
2996: -- Bug 7610725 end
2997:
2998:

Line 3161: OKL_TXD_ASSETS_PUB.delete_txd_asset_Def(

3157: end Loop;
3158: close l_txd_csr;
3159:
3160: If l_adpv_tbl.COUNT <> 0 then
3161: OKL_TXD_ASSETS_PUB.delete_txd_asset_Def(
3162: p_api_version => p_api_version,
3163: p_init_msg_list => p_init_msg_list,
3164: x_return_status => x_return_status,
3165: x_msg_count => x_msg_count,

Line 7329: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;

7325: WHERE tal_id = p_tal_id;
7326:
7327: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
7328:
7329: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
7330: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
7331: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
7332:
7333: --Bug # 2522268

Line 7733: OKL_TXD_ASSETS_PUB.delete_txd_asset_Def(

7729: Null;
7730: Else
7731: --delete txd record
7732: l_adpv_rec.id := l_txd_id;
7733: OKL_TXD_ASSETS_PUB.delete_txd_asset_Def(
7734: p_api_version => p_api_version,
7735: p_init_msg_list => p_init_msg_list,
7736: x_return_status => x_return_status,
7737: x_msg_count => x_msg_count,

Line 8178: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;

8174: WHERE tal_id = p_tal_id;
8175:
8176: l_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
8177:
8178: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
8179: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
8180: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
8181:
8182: --Bug # 2522268

Line 8695: OKL_TXD_ASSETS_PUB.delete_txd_asset_Def(

8691: Null;
8692: Else
8693: --delete txd record
8694: l_adpv_rec.id := l_txd_id;
8695: OKL_TXD_ASSETS_PUB.delete_txd_asset_Def(
8696: p_api_version => p_api_version,
8697: p_init_msg_list => p_init_msg_list,
8698: x_return_status => x_return_status,
8699: x_msg_count => x_msg_count,