3679: l_api_version NUMBER := 1.0;
3680: l_msg_count NUMBER;
3681: l_msg_data VARCHAR2(2000);
3682: l_error VARCHAR2(2000);
3683: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3684: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3685:
3686: CURSOR c_obj_vers_csr (a_id NUMBER)
3687: IS
3680: l_msg_count NUMBER;
3681: l_msg_data VARCHAR2(2000);
3682: l_error VARCHAR2(2000);
3683: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3684: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3685:
3686: CURSOR c_obj_vers_csr (a_id NUMBER)
3687: IS
3688: SELECT object_Version_number
3704: FETCH c_obj_vers_csr INTO l_trqv_rec.object_Version_number;
3705: CLOSE c_obj_vers_csr;
3706:
3707: -- Call the public API for updation here.
3708: okl_trx_requests_pub.update_trx_requests(
3709: p_api_version => l_api_version,
3710: p_init_msg_list => fnd_api.g_false,
3711: x_return_status => l_return_status,
3712: x_msg_count => l_msg_count,
4046: l_api_version NUMBER := 1.0;
4047: l_msg_count NUMBER;
4048: l_msg_data VARCHAR2(2000);
4049: l_error VARCHAR2(2000);
4050: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4051: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4052:
4053: CURSOR c_obj_vers_csr (a_id NUMBER)
4054: IS
4047: l_msg_count NUMBER;
4048: l_msg_data VARCHAR2(2000);
4049: l_error VARCHAR2(2000);
4050: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4051: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4052:
4053: CURSOR c_obj_vers_csr (a_id NUMBER)
4054: IS
4055: SELECT object_Version_number
4071: FETCH c_obj_vers_csr INTO l_trqv_rec.object_Version_number;
4072: CLOSE c_obj_vers_csr;
4073:
4074: -- Call the public API for updation here.
4075: okl_trx_requests_pub.update_trx_requests(
4076: p_api_version => l_api_version,
4077: p_init_msg_list =>fnd_api.g_false,
4078: x_return_status => l_return_status,
4079: x_msg_count => l_msg_count,
4146: l_api_version NUMBER := 1.0;
4147: l_msg_count NUMBER;
4148: l_msg_data VARCHAR2(2000);
4149: l_error VARCHAR2(2000);
4150: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4151: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4152:
4153: CURSOR c_obj_vers_csr (a_id NUMBER)
4154: IS
4147: l_msg_count NUMBER;
4148: l_msg_data VARCHAR2(2000);
4149: l_error VARCHAR2(2000);
4150: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4151: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4152:
4153: CURSOR c_obj_vers_csr (a_id NUMBER)
4154: IS
4155: SELECT object_Version_number
4171: FETCH c_obj_vers_csr INTO l_trqv_rec.object_Version_number;
4172: CLOSE c_obj_vers_csr;
4173:
4174: -- Call the public API for updation here.
4175: okl_trx_requests_pub.update_trx_requests(
4176: p_api_version => l_api_version,
4177: p_init_msg_list =>fnd_api.g_false,
4178: x_return_status => l_return_status,
4179: x_msg_count => l_msg_count,
4249: l_api_version NUMBER := 1.0;
4250: l_msg_count NUMBER;
4251: l_msg_data VARCHAR2(2000);
4252: l_error VARCHAR2(2000);
4253: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4254: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4255:
4256: CURSOR c_obj_vers_csr (a_id NUMBER)
4257: IS
4250: l_msg_count NUMBER;
4251: l_msg_data VARCHAR2(2000);
4252: l_error VARCHAR2(2000);
4253: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4254: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4255:
4256: CURSOR c_obj_vers_csr (a_id NUMBER)
4257: IS
4258: SELECT object_Version_number
4279: FETCH c_obj_vers_csr INTO l_trqv_rec.object_Version_number;
4280: CLOSE c_obj_vers_csr;
4281:
4282: -- Call the public API for updation here.
4283: okl_trx_requests_pub.update_trx_requests(
4284: p_api_version => l_api_version,
4285: p_init_msg_list =>fnd_api.g_false,
4286: x_return_status => l_return_status,
4287: x_msg_count => l_msg_count,
4353: l_api_version NUMBER := 1.0;
4354: l_msg_count NUMBER;
4355: l_msg_data VARCHAR2(2000);
4356: l_error VARCHAR2(2000);
4357: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4358: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4359:
4360: CURSOR c_obj_vers_csr (a_id NUMBER)
4361: IS
4354: l_msg_count NUMBER;
4355: l_msg_data VARCHAR2(2000);
4356: l_error VARCHAR2(2000);
4357: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4358: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4359:
4360: CURSOR c_obj_vers_csr (a_id NUMBER)
4361: IS
4362: SELECT object_Version_number
4378: FETCH c_obj_vers_csr INTO l_trqv_rec.object_Version_number;
4379: CLOSE c_obj_vers_csr;
4380:
4381: -- Call the public API for updation here.
4382: okl_trx_requests_pub.update_trx_requests(
4383: p_api_version => l_api_version,
4384: p_init_msg_list =>fnd_api.g_false,
4385: x_return_status => l_return_status,
4386: x_msg_count => l_msg_count,