APPS.IEX_CO_REPORT_CB_PVT dependencies on OKL_OPI_PVT

Line 36: l_party_rec okl_opi_pvt.party_rec_type;

32:
33: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
34: l_case_rec case_rec_type;
35:
36: l_party_rec okl_opi_pvt.party_rec_type;
37: l_owner_resource_id NUMBER;
38: l_resource_phone VARCHAR2(100);
39: l_resource_email VARCHAR2(1995);
40: l_address VARCHAR2(1995);

Line 55: okl_opi_pvt.get_case_owner(p_cas_id => l_case_rec.cas_id

51: BEGIN
52: l_case_rec.cas_id := p_cas_id;
53:
54: --get case owner
55: okl_opi_pvt.get_case_owner(p_cas_id => l_case_rec.cas_id
56: ,x_owner_resource_id => l_owner_resource_id
57: ,x_resource_name => l_case_rec.case_owner
58: ,x_resource_phone => l_resource_phone
59: ,x_resource_email => l_resource_email

Line 67: okl_opi_pvt.get_party(p_contract_id => cur.object_id

63: l_case_rec.case_number := cur.case_number;
64: l_case_rec.case_status := get_code_meaning('OKL_CASE_STATUS', cur.status_code);
65:
66: --get case customer
67: okl_opi_pvt.get_party(p_contract_id => cur.object_id
68: ,x_party_rec => l_party_rec
69: ,x_return_status => l_return_status);
70:
71: l_case_rec.party_name := l_party_rec.party_name;

Line 144: lp_contract_rec okl_opi_pvt.contract_rec_type;

140: p_khr_id IN NUMBER,
141: x_form_contract_rec OUT NOCOPY form_contract_rec_type,
142: x_return_status OUT NOCOPY VARCHAR2) AS
143:
144: lp_contract_rec okl_opi_pvt.contract_rec_type;
145: lx_contract_rec okl_opi_pvt.contract_rec_type;
146: l_form_contract_rec form_contract_rec_type;
147: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
148: BEGIN

Line 145: lx_contract_rec okl_opi_pvt.contract_rec_type;

141: x_form_contract_rec OUT NOCOPY form_contract_rec_type,
142: x_return_status OUT NOCOPY VARCHAR2) AS
143:
144: lp_contract_rec okl_opi_pvt.contract_rec_type;
145: lx_contract_rec okl_opi_pvt.contract_rec_type;
146: l_form_contract_rec form_contract_rec_type;
147: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
148: BEGIN
149:

Line 150: okl_opi_pvt.get_contract(p_contract_id => p_khr_id

146: l_form_contract_rec form_contract_rec_type;
147: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
148: BEGIN
149:
150: okl_opi_pvt.get_contract(p_contract_id => p_khr_id
151: ,x_contract_rec => lx_contract_rec
152: ,x_return_status => l_return_status);
153:
154: l_form_contract_rec.contract_number := lx_contract_rec.contract_number;

Line 166: okl_opi_pvt.get_contract_payment_info(p_contract_rec => lp_contract_rec

162: l_form_contract_rec.term_duration := lx_contract_rec.term_duration;
163:
164: lp_contract_rec := lx_contract_rec;
165:
166: okl_opi_pvt.get_contract_payment_info(p_contract_rec => lp_contract_rec
167: ,x_contract_rec => lx_contract_rec
168: ,x_return_status => l_return_status);
169:
170: l_form_contract_rec.monthly_payment_amount := lx_contract_rec.monthly_payment_amount;