18: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_COUNT OUT NOCOPY NUMBER,
20: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
21:
22: l_contracts_in_tbl OKS_CON_COVERAGE_PUB.ser_tbl_type ;
23: l_contracts_out_tbl OKS_CON_COVERAGE_PUB.cov_tbl_type ;
24:
25: j NUMBER := 0;
26:
19: X_MSG_COUNT OUT NOCOPY NUMBER,
20: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
21:
22: l_contracts_in_tbl OKS_CON_COVERAGE_PUB.ser_tbl_type ;
23: l_contracts_out_tbl OKS_CON_COVERAGE_PUB.cov_tbl_type ;
24:
25: j NUMBER := 0;
26:
27: l_return_status VARCHAR2(1);
46: and l_contracts_in_tbl(1).business_process_id IS NOT NULL
47: and l_contracts_in_tbl(1).request_date IS NOT NULL
48: and l_contracts_in_tbl(1).charge_amount IS NOT NULL THEN
49:
50: OKS_CON_COVERAGE_PUB.APPLY_CONTRACT_COVERAGE (
51: P_API_VERSION => 1.0,
52: P_INIT_MSG_LIST => 'T',
53: P_EST_amt_TBL => l_contracts_in_tbl,
54: X_RETURN_STATUS => l_return_status,