DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on OKC_CVM_PVT

Line 2215: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type ;

2211:
2212: l_con_update_date date;
2213: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
2214: l_chrv_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
2215: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type ;
2216: l_cvmv_out_rec OKC_CVM_PVT.cvmv_rec_type ;
2217: l_return_status VARCHAR2(1);
2218: l_msg_data VARCHAR2(2000);
2219: l_msg_cnt NUMBER;

Line 2216: l_cvmv_out_rec OKC_CVM_PVT.cvmv_rec_type ;

2212: l_con_update_date date;
2213: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
2214: l_chrv_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
2215: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type ;
2216: l_cvmv_out_rec OKC_CVM_PVT.cvmv_rec_type ;
2217: l_return_status VARCHAR2(1);
2218: l_msg_data VARCHAR2(2000);
2219: l_msg_cnt NUMBER;
2220: l_api_version CONSTANT NUMBER := 1.0;

Line 2235: okc_cvm_pvt.g_trans_id := 'XXX';

2231: FETCH l_contract_update_date into l_con_update_date;
2232: CLOSE l_contract_update_date;
2233:
2234: IF (trunc(l_con_update_date) <> trunc(sysdate)) THEN
2235: okc_cvm_pvt.g_trans_id := 'XXX';
2236: l_cvmv_rec.chr_id := p_dnz_chr_id;
2237:
2238: OKC_CVM_PVT.update_contract_version(
2239: P_API_VERSION => l_api_version,

Line 2238: OKC_CVM_PVT.update_contract_version(

2234: IF (trunc(l_con_update_date) <> trunc(sysdate)) THEN
2235: okc_cvm_pvt.g_trans_id := 'XXX';
2236: l_cvmv_rec.chr_id := p_dnz_chr_id;
2237:
2238: OKC_CVM_PVT.update_contract_version(
2239: P_API_VERSION => l_api_version,
2240: P_INIT_MSG_LIST => l_init_msg_list,
2241: X_RETURN_STATUS => l_return_status,
2242: X_MSG_COUNT => l_msg_cnt,

Line 2248: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After calling OKC_CVM_PVT.update_contract_version l_return_status '||l_return_status);

2244: P_CVMV_REC => l_cvmv_rec,
2245: X_CVMV_REC => l_cvmv_out_rec);
2246:
2247: IF l_write_log THEN
2248: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After calling OKC_CVM_PVT.update_contract_version l_return_status '||l_return_status);
2249: END IF;
2250:
2251: l_chrv_rec.id := p_dnz_chr_id;
2252: l_chrv_rec.last_update_date := sysdate;

Line 2403: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type ;

2399:
2400:
2401:
2402: X_return_status Varchar2(1); -- was a parameter until subrequest impl.
2403: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type ;
2404: l_cvmv_out_rec OKC_CVM_PVT.cvmv_rec_type ;
2405: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
2406: l_chrv_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
2407: qty_uom_rec QTY_UOM_CSR%rowtype;

Line 2404: l_cvmv_out_rec OKC_CVM_PVT.cvmv_rec_type ;

2400:
2401:
2402: X_return_status Varchar2(1); -- was a parameter until subrequest impl.
2403: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type ;
2404: l_cvmv_out_rec OKC_CVM_PVT.cvmv_rec_type ;
2405: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
2406: l_chrv_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
2407: qty_uom_rec QTY_UOM_CSR%rowtype;
2408: l_bill_rec L_BILL_LINE_CSR%rowtype;