DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on OKL_TRX_REQUESTS_PUB

Line 3674: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

3670: l_api_version NUMBER := 1.0;
3671: l_msg_count NUMBER;
3672: l_msg_data VARCHAR2(2000);
3673: l_error VARCHAR2(2000);
3674: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3675: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3676:
3677: CURSOR c_obj_vers_csr (a_id NUMBER)
3678: IS

Line 3675: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

3671: l_msg_count NUMBER;
3672: l_msg_data VARCHAR2(2000);
3673: l_error VARCHAR2(2000);
3674: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3675: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3676:
3677: CURSOR c_obj_vers_csr (a_id NUMBER)
3678: IS
3679: SELECT object_Version_number

Line 3699: okl_trx_requests_pub.update_trx_requests(

3695: FETCH c_obj_vers_csr INTO l_trqv_rec.object_Version_number;
3696: CLOSE c_obj_vers_csr;
3697:
3698: -- Call the public API for updation here.
3699: okl_trx_requests_pub.update_trx_requests(
3700: p_api_version => l_api_version,
3701: p_init_msg_list => fnd_api.g_false,
3702: x_return_status => l_return_status,
3703: x_msg_count => l_msg_count,

Line 4041: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4037: l_api_version NUMBER := 1.0;
4038: l_msg_count NUMBER;
4039: l_msg_data VARCHAR2(2000);
4040: l_error VARCHAR2(2000);
4041: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4042: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4043:
4044: CURSOR c_obj_vers_csr (a_id NUMBER)
4045: IS

Line 4042: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4038: l_msg_count NUMBER;
4039: l_msg_data VARCHAR2(2000);
4040: l_error VARCHAR2(2000);
4041: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4042: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4043:
4044: CURSOR c_obj_vers_csr (a_id NUMBER)
4045: IS
4046: SELECT object_Version_number

Line 4066: okl_trx_requests_pub.update_trx_requests(

4062: FETCH c_obj_vers_csr INTO l_trqv_rec.object_Version_number;
4063: CLOSE c_obj_vers_csr;
4064:
4065: -- Call the public API for updation here.
4066: okl_trx_requests_pub.update_trx_requests(
4067: p_api_version => l_api_version,
4068: p_init_msg_list =>fnd_api.g_false,
4069: x_return_status => l_return_status,
4070: x_msg_count => l_msg_count,

Line 4141: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4137: l_api_version NUMBER := 1.0;
4138: l_msg_count NUMBER;
4139: l_msg_data VARCHAR2(2000);
4140: l_error VARCHAR2(2000);
4141: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4142: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4143:
4144: CURSOR c_obj_vers_csr (a_id NUMBER)
4145: IS

Line 4142: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4138: l_msg_count NUMBER;
4139: l_msg_data VARCHAR2(2000);
4140: l_error VARCHAR2(2000);
4141: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4142: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4143:
4144: CURSOR c_obj_vers_csr (a_id NUMBER)
4145: IS
4146: SELECT object_Version_number

Line 4166: okl_trx_requests_pub.update_trx_requests(

4162: FETCH c_obj_vers_csr INTO l_trqv_rec.object_Version_number;
4163: CLOSE c_obj_vers_csr;
4164:
4165: -- Call the public API for updation here.
4166: okl_trx_requests_pub.update_trx_requests(
4167: p_api_version => l_api_version,
4168: p_init_msg_list =>fnd_api.g_false,
4169: x_return_status => l_return_status,
4170: x_msg_count => l_msg_count,

Line 4244: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4240: l_api_version NUMBER := 1.0;
4241: l_msg_count NUMBER;
4242: l_msg_data VARCHAR2(2000);
4243: l_error VARCHAR2(2000);
4244: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4245: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4246:
4247: CURSOR c_obj_vers_csr (a_id NUMBER)
4248: IS

Line 4245: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4241: l_msg_count NUMBER;
4242: l_msg_data VARCHAR2(2000);
4243: l_error VARCHAR2(2000);
4244: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4245: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4246:
4247: CURSOR c_obj_vers_csr (a_id NUMBER)
4248: IS
4249: SELECT object_Version_number

Line 4274: okl_trx_requests_pub.update_trx_requests(

4270: FETCH c_obj_vers_csr INTO l_trqv_rec.object_Version_number;
4271: CLOSE c_obj_vers_csr;
4272:
4273: -- Call the public API for updation here.
4274: okl_trx_requests_pub.update_trx_requests(
4275: p_api_version => l_api_version,
4276: p_init_msg_list =>fnd_api.g_false,
4277: x_return_status => l_return_status,
4278: x_msg_count => l_msg_count,

Line 4348: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4344: l_api_version NUMBER := 1.0;
4345: l_msg_count NUMBER;
4346: l_msg_data VARCHAR2(2000);
4347: l_error VARCHAR2(2000);
4348: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4349: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4350:
4351: CURSOR c_obj_vers_csr (a_id NUMBER)
4352: IS

Line 4349: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4345: l_msg_count NUMBER;
4346: l_msg_data VARCHAR2(2000);
4347: l_error VARCHAR2(2000);
4348: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4349: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4350:
4351: CURSOR c_obj_vers_csr (a_id NUMBER)
4352: IS
4353: SELECT object_Version_number

Line 4373: okl_trx_requests_pub.update_trx_requests(

4369: FETCH c_obj_vers_csr INTO l_trqv_rec.object_Version_number;
4370: CLOSE c_obj_vers_csr;
4371:
4372: -- Call the public API for updation here.
4373: okl_trx_requests_pub.update_trx_requests(
4374: p_api_version => l_api_version,
4375: p_init_msg_list =>fnd_api.g_false,
4376: x_return_status => l_return_status,
4377: x_msg_count => l_msg_count,