APPS.OKL_OPI_PVT dependencies on OKL_OPEN_INT_PRTY

Line 243: FROM okl_open_int_prty

239:
240: CURSOR l_guarantor_csr(cp_khr_id IN NUMBER
241: ,cp_party_id IN NUMBER) IS
242: SELECT id
243: FROM okl_open_int_prty
244: WHERE khr_id = cp_khr_id
245: AND party_id = cp_party_id;
246: BEGIN
247: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 354: --insert/update guarantors into okl_open_int_prty_v

350: get_guarantor(p_contract_id => lx_oinv_rec.khr_id
351: ,x_party_tbl => l_guarantor_tbl
352: ,x_return_status => l_return_status);
353:
354: --insert/update guarantors into okl_open_int_prty_v
355: --DBMS_OUTPUT.PUT_LINE('GUARANTOR count - ' || l_guarantor_tbl.count);
356: FOR i IN 1..l_guarantor_tbl.COUNT LOOP
357: l_oipv_rec.khr_id := lx_oinv_rec.khr_id;
358: l_oipv_rec.party_id := l_guarantor_tbl(i).party_id;

Line 398: okl_open_int_prty_pub.update_open_int_prty( p_api_version => l_api_version

394: EXIT;
395: END LOOP;
396:
397: IF (l_guarantor_found) THEN
398: okl_open_int_prty_pub.update_open_int_prty( p_api_version => l_api_version
399: ,p_init_msg_list => p_init_msg_list
400: ,x_return_status => l_return_status
401: ,x_msg_count => x_msg_count
402: ,x_msg_data => x_msg_data

Line 417: okl_open_int_prty_pub.insert_open_int_prty( p_api_version => l_api_version

413: --dbms_output.put_line('khr_id : ' || l_oipv_rec.khr_id);
414: --dbms_output.put_line('party_id : ' || l_oipv_rec.party_id);
415: --dbms_output.put_line('party_name : ' || l_oipv_rec.party_name);
416:
417: okl_open_int_prty_pub.insert_open_int_prty( p_api_version => l_api_version
418: ,p_init_msg_list => p_init_msg_list
419: ,x_return_status => l_return_status
420: ,x_msg_count => x_msg_count
421: ,x_msg_data => x_msg_data