eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CS_LEASE_RENEWAL_PVT dependencies on OKL_TRX_REQUESTS

Line 56: FROM okl_trx_requests

52: IS
53: SELECT request_status_code,
54: object1_id1,
55: jtot_object1_code
56: FROM okl_trx_requests
57: where id=a_id;
58:
59: CURSOR c_supertrump_csr (a_id IN NUMBER)
60: IS

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 860: l_request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE;

856: l_new_term NUMBER;
857: l_current_lease_attribs lease_details_tbl_type;
858:
859: l_object_version_number NUMBER;
860: l_request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE;
861:
862: CURSOR c_get_req_details(p_req_id NUMBER) IS
863: SELECT OBJECT_VERSION_NUMBER, REQUEST_STATUS_CODE
864: FROM OKL_TRX_REQUESTS

Line 864: FROM OKL_TRX_REQUESTS

860: l_request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE;
861:
862: CURSOR c_get_req_details(p_req_id NUMBER) IS
863: SELECT OBJECT_VERSION_NUMBER, REQUEST_STATUS_CODE
864: FROM OKL_TRX_REQUESTS
865: WHERE ID = p_req_id;
866:
867: BEGIN
868: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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 973: l_csm_lease_header.jtot_object1_code := 'OKL_TRX_REQUESTS';

969: RAISE OKL_API.G_EXCEPTION_ERROR;
970: END IF;
971: --Fine tune the params
972: --x_csm_lease_header
973: l_csm_lease_header.jtot_object1_code := 'OKL_TRX_REQUESTS';
974: l_csm_lease_header.object1_id1 := x_trqv_tbl(1).id;
975: l_csm_lease_header.orp_code := OKL_CREATE_STREAMS_PUB.G_ORP_CODE_RENEWAL;
976:
977: --Check the following with Susan.

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 1124: FROM okl_trx_requests

1120:
1121: CURSOR c_obj_vers_csr (a_id NUMBER)
1122: IS
1123: SELECT object_Version_number
1124: FROM okl_trx_requests
1125: WHERE id=a_id;
1126:
1127: BEGIN
1128:

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,