DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on OKL_TRX_REQUESTS_PUB

Line 3683: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

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

Line 3684: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

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

Line 3708: okl_trx_requests_pub.update_trx_requests(

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,

Line 4050: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

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

Line 4051: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

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

Line 4075: okl_trx_requests_pub.update_trx_requests(

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,

Line 4150: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

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

Line 4151: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

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

Line 4175: okl_trx_requests_pub.update_trx_requests(

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,

Line 4253: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

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

Line 4254: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

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

Line 4283: okl_trx_requests_pub.update_trx_requests(

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,

Line 4357: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

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

Line 4358: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

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

Line 4382: okl_trx_requests_pub.update_trx_requests(

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,