APPS.OKL_CS_LEASE_RENEWAL_PVT dependencies on OKL_TRX_REQUESTS_PUB

Line 836: p_trqv_tbl IN okl_trx_requests_pub.trqv_tbl_type,

832: p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,
833: x_return_status OUT NOCOPY VARCHAR2,
834: x_msg_count OUT NOCOPY NUMBER,
835: x_msg_data OUT NOCOPY VARCHAR2,
836: p_trqv_tbl IN okl_trx_requests_pub.trqv_tbl_type,
837: x_trqv_tbl OUT NOCOPY okl_trx_requests_pub.trqv_tbl_type)
838: AS
839: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE';
840: p_chr_id NUMBER;

Line 837: x_trqv_tbl OUT NOCOPY okl_trx_requests_pub.trqv_tbl_type)

833: x_return_status OUT NOCOPY VARCHAR2,
834: x_msg_count OUT NOCOPY NUMBER,
835: x_msg_data OUT NOCOPY VARCHAR2,
836: p_trqv_tbl IN okl_trx_requests_pub.trqv_tbl_type,
837: x_trqv_tbl OUT NOCOPY okl_trx_requests_pub.trqv_tbl_type)
838: AS
839: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE';
840: p_chr_id NUMBER;
841: l_trans_id NUMBER;

Line 843: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;

839: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE';
840: p_chr_id NUMBER;
841: l_trans_id NUMBER;
842: l_trans_status VARCHAR2(100);
843: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
844: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
845:
846: l_csm_lease_header Okl_Create_Streams_Pub.csm_lease_rec_type;
847: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;

Line 844: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;

840: p_chr_id NUMBER;
841: l_trans_id NUMBER;
842: l_trans_status VARCHAR2(100);
843: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
844: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
845:
846: l_csm_lease_header Okl_Create_Streams_Pub.csm_lease_rec_type;
847: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
848: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

Line 887: okl_trx_requests_pub.insert_trx_requests(

883: RAISE OKL_API.G_EXCEPTION_ERROR;
884: END IF;
885: IF p_trqv_tbl(1).id IS NULL THEN
886: -- Call the public API for insertion here.
887: okl_trx_requests_pub.insert_trx_requests(
888: p_api_version => p_api_version,
889: p_init_msg_list =>p_init_msg_list,
890: x_return_status => x_return_status,
891: x_msg_count => x_msg_count,

Line 910: okl_trx_requests_pub.update_trx_requests(

906: l_upd_trqv_tbl(1).amount := NULL;
907: l_upd_trqv_tbl(1).request_status_code := 'ENTERED';
908:
909: --Call update here.
910: okl_trx_requests_pub.update_trx_requests(
911: p_api_version => p_api_version,
912: p_init_msg_list =>p_init_msg_list,
913: x_return_status => x_return_status,
914: x_msg_count => x_msg_count,

Line 1059: okl_trx_requests_pub.update_trx_requests(

1055: l_trqv_tbl(1).jtot_object1_code := 'OKL_STREAM_INTERFACES';
1056: l_trqv_tbl(1).object1_id1 := l_trans_id;
1057:
1058: --Call update here.
1059: okl_trx_requests_pub.update_trx_requests(
1060: p_api_version => p_api_version,
1061: p_init_msg_list =>p_init_msg_list,
1062: x_return_status => x_return_status,
1063: x_msg_count => x_msg_count,

Line 1114: ,p_trqv_rec IN okl_trx_requests_pub.trqv_rec_type

1110: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1111: ,x_return_status OUT NOCOPY VARCHAR2
1112: ,x_msg_count OUT NOCOPY NUMBER
1113: ,x_msg_data OUT NOCOPY VARCHAR2
1114: ,p_trqv_rec IN okl_trx_requests_pub.trqv_rec_type
1115: ,x_trqv_rec OUT NOCOPY okl_trx_requests_pub.trqv_rec_type)
1116: AS
1117:
1118: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LRNW_REQUEST';

Line 1115: ,x_trqv_rec OUT NOCOPY okl_trx_requests_pub.trqv_rec_type)

1111: ,x_return_status OUT NOCOPY VARCHAR2
1112: ,x_msg_count OUT NOCOPY NUMBER
1113: ,x_msg_data OUT NOCOPY VARCHAR2
1114: ,p_trqv_rec IN okl_trx_requests_pub.trqv_rec_type
1115: ,x_trqv_rec OUT NOCOPY okl_trx_requests_pub.trqv_rec_type)
1116: AS
1117:
1118: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LRNW_REQUEST';
1119: l_trqv_rec okl_trx_requests_pub.trqv_rec_type := p_trqv_rec;

Line 1119: l_trqv_rec okl_trx_requests_pub.trqv_rec_type := p_trqv_rec;

1115: ,x_trqv_rec OUT NOCOPY okl_trx_requests_pub.trqv_rec_type)
1116: AS
1117:
1118: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LRNW_REQUEST';
1119: l_trqv_rec okl_trx_requests_pub.trqv_rec_type := p_trqv_rec;
1120:
1121: CURSOR c_obj_vers_csr (a_id NUMBER)
1122: IS
1123: SELECT object_Version_number

Line 1164: okl_trx_requests_pub.update_trx_requests(

1160: END IF;
1161:
1162:
1163: -- Call the public API for updation here.
1164: okl_trx_requests_pub.update_trx_requests(
1165: p_api_version => p_api_version,
1166: p_init_msg_list =>p_init_msg_list,
1167: x_return_status => x_return_status,
1168: x_msg_count => x_msg_count,