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_WF dependencies on OKL_TRX_REQUESTS

Line 3058: FROM OKL_TRX_REQUESTS

3054: l_parent_contract_num VARCHAR2(100);
3055:
3056: CURSOR c_req_record(p_id IN NUMBER) IS
3057: SELECT *
3058: FROM OKL_TRX_REQUESTS
3059: WHERE ID = p_id;
3060:
3061: l_req_rec c_req_record%ROWTYPE;
3062:

Line 3384: FROM OKL_TRX_REQUESTS

3380:
3381:
3382: CURSOR c_req_record(p_id IN NUMBER) IS
3383: SELECT *
3384: FROM OKL_TRX_REQUESTS
3385: WHERE ID = p_id;
3386:
3387: l_req_rec c_req_record%ROWTYPE;
3388:

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

3676:
3677: CURSOR c_obj_vers_csr (a_id NUMBER)
3678: IS
3679: SELECT object_Version_number
3680: FROM okl_trx_requests
3681: WHERE id=a_id;
3682:
3683:
3684: BEGIN

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 3825: FROM OKL_TRX_REQUESTS

3821: l_contract_num VARCHAR2(100);
3822:
3823: CURSOR c_req_record(p_id IN NUMBER) IS
3824: SELECT *
3825: FROM OKL_TRX_REQUESTS
3826: WHERE ID = p_id;
3827:
3828: l_req_rec c_req_record%ROWTYPE;
3829:

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

4043:
4044: CURSOR c_obj_vers_csr (a_id NUMBER)
4045: IS
4046: SELECT object_Version_number
4047: FROM okl_trx_requests
4048: WHERE id=a_id;
4049:
4050:
4051: BEGIN

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

4143:
4144: CURSOR c_obj_vers_csr (a_id NUMBER)
4145: IS
4146: SELECT object_Version_number
4147: FROM okl_trx_requests
4148: WHERE id=a_id;
4149:
4150:
4151: BEGIN

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

4246:
4247: CURSOR c_obj_vers_csr (a_id NUMBER)
4248: IS
4249: SELECT object_Version_number
4250: FROM okl_trx_requests
4251: WHERE id=a_id;
4252:
4253:
4254: BEGIN

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

4350:
4351: CURSOR c_obj_vers_csr (a_id NUMBER)
4352: IS
4353: SELECT object_Version_number
4354: FROM okl_trx_requests
4355: WHERE id=a_id;
4356:
4357:
4358: BEGIN

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,