DBA Data[Home] [Help]

APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKL_POOL_PVT

Line 29: G_POC_STS_NEW CONSTANT VARCHAR2(3) := OKL_POOL_PVT.G_POC_STS_NEW;

25: G_SECURITIZED_CODE_N CONSTANT VARCHAR2(30) := 'N';
26: G_LESSOR_JTOT_OBJECT1_CODE CONSTANT VARCHAR2(30) := 'OKX_OPERUNIT';
27: G_TRUSTEE_JTOT_OBJECT1_CODE CONSTANT VARCHAR2(30) := 'OKX_VENDOR';
28:
29: G_POC_STS_NEW CONSTANT VARCHAR2(3) := OKL_POOL_PVT.G_POC_STS_NEW;
30: G_POC_STS_ACTIVE CONSTANT VARCHAR2(6) := OKL_POOL_PVT.G_POC_STS_ACTIVE;
31: G_POC_STS_INACTIVE CONSTANT VARCHAR2(8) := OKL_POOL_PVT.G_POC_STS_INACTIVE;
32:
33: G_FACTORING_SYND_FLAG_INVESTOR CONSTANT VARCHAR2(45) := 'INVESTOR';

Line 30: G_POC_STS_ACTIVE CONSTANT VARCHAR2(6) := OKL_POOL_PVT.G_POC_STS_ACTIVE;

26: G_LESSOR_JTOT_OBJECT1_CODE CONSTANT VARCHAR2(30) := 'OKX_OPERUNIT';
27: G_TRUSTEE_JTOT_OBJECT1_CODE CONSTANT VARCHAR2(30) := 'OKX_VENDOR';
28:
29: G_POC_STS_NEW CONSTANT VARCHAR2(3) := OKL_POOL_PVT.G_POC_STS_NEW;
30: G_POC_STS_ACTIVE CONSTANT VARCHAR2(6) := OKL_POOL_PVT.G_POC_STS_ACTIVE;
31: G_POC_STS_INACTIVE CONSTANT VARCHAR2(8) := OKL_POOL_PVT.G_POC_STS_INACTIVE;
32:
33: G_FACTORING_SYND_FLAG_INVESTOR CONSTANT VARCHAR2(45) := 'INVESTOR';
34: G_OKL_SEC_ACCT_TRX_DESC CONSTANT VARCHAR2(45) := 'OKL_SEC_ACCT_TRX_DESC';

Line 31: G_POC_STS_INACTIVE CONSTANT VARCHAR2(8) := OKL_POOL_PVT.G_POC_STS_INACTIVE;

27: G_TRUSTEE_JTOT_OBJECT1_CODE CONSTANT VARCHAR2(30) := 'OKX_VENDOR';
28:
29: G_POC_STS_NEW CONSTANT VARCHAR2(3) := OKL_POOL_PVT.G_POC_STS_NEW;
30: G_POC_STS_ACTIVE CONSTANT VARCHAR2(6) := OKL_POOL_PVT.G_POC_STS_ACTIVE;
31: G_POC_STS_INACTIVE CONSTANT VARCHAR2(8) := OKL_POOL_PVT.G_POC_STS_INACTIVE;
32:
33: G_FACTORING_SYND_FLAG_INVESTOR CONSTANT VARCHAR2(45) := 'INVESTOR';
34: G_OKL_SEC_ACCT_TRX_DESC CONSTANT VARCHAR2(45) := 'OKL_SEC_ACCT_TRX_DESC';
35: G_RULE_GRP_LASEAC CONSTANT VARCHAR2(45) := 'LASEAC';

Line 1922: OKL_POOL_PVT.update_pool(

1918: --
1919: l_polv_rec.id := p_secAgreement_rec.pol_id;
1920: l_polv_rec.khr_id := x_secAgreement_rec.ID;
1921:
1922: OKL_POOL_PVT.update_pool(
1923: p_api_version => p_api_version,
1924: p_init_msg_list => p_init_msg_list,
1925:
1926: x_return_status => x_return_status,

Line 2274: OKL_POOL_PVT.update_pool(

2270:
2271: l_polv_rec.id := l_pol_id;
2272: l_polv_rec.khr_id := NULL;
2273:
2274: OKL_POOL_PVT.update_pool(
2275: p_api_version => p_api_version,
2276: p_init_msg_list => p_init_msg_list,
2277: x_return_status => x_return_status,
2278: x_msg_count => x_msg_count,

Line 2299: OKL_POOL_PVT.update_pool(

2295:
2296: l_polv_rec.id := p_secAgreement_rec.pol_id;
2297: l_polv_rec.khr_id := p_secAgreement_rec.ID;
2298:
2299: OKL_POOL_PVT.update_pool(
2300: p_api_version => p_api_version,
2301: p_init_msg_list => p_init_msg_list,
2302: x_return_status => x_return_status,
2303: x_msg_count => x_msg_count,

Line 2603: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction START');

2599: -- initial transaction when pool become active
2600: --OKL_POOL_TRANSACTION_TYPE
2601: ----------------------------------------------------------------------------
2602: --dbms_output.put_line('1. CREATE a TRANSACTION FOR entire pool BY pol_id');
2603: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction START');
2604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2605: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '1. CREATE a TRANSACTION FOR entire pool BY pol_id: START');
2606: END IF;
2607: OPEN c_pool;

Line 2636: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_pool_pvt.create_pool_transaction');

2632: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_COMPLETE;
2633: --added abhsaxen for Legal Entity Uptake
2634: lp_poxv_rec.LEGAL_ENTITY_ID := l_legal_entity_id;
2635: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2636: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_pool_pvt.create_pool_transaction');
2637: END IF;
2638:
2639: OKL_POOL_PVT.create_pool_transaction(
2640: p_api_version => p_api_version,

Line 2639: OKL_POOL_PVT.create_pool_transaction(

2635: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2636: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_pool_pvt.create_pool_transaction');
2637: END IF;
2638:
2639: OKL_POOL_PVT.create_pool_transaction(
2640: p_api_version => p_api_version,
2641: p_init_msg_list => p_init_msg_list,
2642: x_return_status => x_return_status,
2643: x_msg_count => x_msg_count,

Line 2649: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction x_return_status :' || x_return_status);

2645: p_poxv_rec => lp_poxv_rec,
2646: x_poxv_rec => lx_poxv_rec);
2647: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2648: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2649: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction x_return_status :' || x_return_status);
2650: END IF;
2651:
2652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2658: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction END');

2654: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2655: RAISE OKL_API.G_EXCEPTION_ERROR;
2656: END IF;
2657: END IF;
2658: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction END');
2659: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2660: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction: END');
2661: END IF;
2662:

Line 2660: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction: END');

2656: END IF;
2657: END IF;
2658: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction END');
2659: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2660: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction: END');
2661: END IF;
2662:
2663: ----------------------------------------------------------------------------
2664: -- get pox_id after create trx entry

Line 2670: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents Start');

2666: -- make association between pool transaction and pool contents' records
2667: ----------------------------------------------------------------------------
2668: -- loop
2669: --dbms_output.put_line('2. update pool contents to point to this transaction');
2670: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents Start');
2671: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2672: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '2. update pool contents to point to this transaction');
2673: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_contents: START');
2674: END IF;

Line 2673: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_contents: START');

2669: --dbms_output.put_line('2. update pool contents to point to this transaction');
2670: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents Start');
2671: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2672: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '2. update pool contents to point to this transaction');
2673: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_contents: START');
2674: END IF;
2675:
2676: OPEN c_poc;
2677: LOOP

Line 2694: OKL_POOL_PVT.update_pool_contents(

2690: lp_pocv_rec.POL_ID := l_pol_id;
2691: lp_pocv_rec.POX_ID := lx_poxv_rec.id;
2692: lp_pocv_rec.TRANSACTION_NUMBER_IN := lx_poxv_rec.TRANSACTION_NUMBER;
2693:
2694: OKL_POOL_PVT.update_pool_contents(
2695: p_api_version => p_api_version,
2696: p_init_msg_list => p_init_msg_list,
2697: x_return_status => x_return_status,
2698: x_msg_count => x_msg_count,

Line 2705: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents x_return_status :' || x_return_status);

2701: x_pocv_rec => lx_pocv_rec);
2702:
2703: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2704: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2705: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents x_return_status :' || x_return_status);
2706: END IF;
2707:
2708: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2717: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents : END');

2713:
2714: END LOOP;
2715: CLOSE c_poc;
2716: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2717: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents : END');
2718: END IF;
2719:
2720: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents End');
2721:

Line 2720: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents End');

2716: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2717: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents : END');
2718: END IF;
2719:
2720: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents End');
2721:
2722: ----------------------------------------------------------------------------
2723: --3 Mark associated contract to securitizated
2724: ----------------------------------------------------------------------------

Line 3021: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_status_active');

3017: --11 update pool header and contents status to active
3018: ----------------------------------------------------------------------------
3019: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3020: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '11 update pool header and contents status to active: START');
3021: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_status_active');
3022: END IF;
3023:
3024: OKL_POOL_PVT.update_pool_status_active(
3025: p_api_version => p_api_version,

Line 3024: OKL_POOL_PVT.update_pool_status_active(

3020: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '11 update pool header and contents status to active: START');
3021: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_status_active');
3022: END IF;
3023:
3024: OKL_POOL_PVT.update_pool_status_active(
3025: p_api_version => p_api_version,
3026: p_init_msg_list => p_init_msg_list,
3027: x_return_status => x_return_status,
3028: x_msg_count => x_msg_count,

Line 3033: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_status_active x_return_status :' || x_return_status);

3029: x_msg_data => x_msg_data,
3030: p_pol_id => l_pol_id);
3031:
3032: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3033: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_status_active x_return_status :' || x_return_status);
3034: END IF;
3035:
3036: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3037: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3327: OKL_POOL_PVT.get_tot_recei_amt_pend(

3323: 'POOL_ID');
3324: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3325: END IF;
3326:
3327: OKL_POOL_PVT.get_tot_recei_amt_pend(
3328: p_api_version => '1.0',
3329: p_init_msg_list => p_init_msg_list,
3330: x_return_status => x_return_status,
3331: x_msg_count => x_msg_count,

Line 3345: OKL_POOL_PVT.reconcile_contents(

3341: x_return_status := OKL_API.G_RET_STS_ERROR;
3342: END IF;
3343:
3344: --Check to see if the pool recquires reconcilation
3345: OKL_POOL_PVT.reconcile_contents(
3346: p_api_version => p_api_version,
3347: p_init_msg_list => p_init_msg_list,
3348: x_return_status => x_return_status,
3349: x_msg_count => x_msg_count,

Line 3459: AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING;

3455: SELECT poc.khr_id,
3456: poc.id
3457: FROM okl_pool_contents poc
3458: WHERE poc.pol_id = p_pol_id
3459: AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING;
3460:
3461: /* ankushar Bug# 6773285 Added Principal Payment for Loan contracts also renamed Cursor
3462: Start Changes
3463: */

Line 3606: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,

3602: --Update the status of the Pool Transaction to INCOMPLETE and Halt processing
3603: lp_poxv_rec.id := l_pox_id;
3604: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_INCOMPLETE;
3605:
3606: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,
3607: p_init_msg_list => p_init_msg_list,
3608: x_return_status => x_return_status,
3609: x_msg_count => x_msg_count,
3610: x_msg_data => x_msg_data,

Line 3894: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_contents');

3890: --8 update pool contents status to active and pool transactions status to COMPLETE
3891: ----------------------------------------------------------------------------------
3892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3893: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool contents status to active: START');
3894: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_contents');
3895: END IF;
3896:
3897: --Update pool contents to ACTIVE
3898: FOR c_pool_chr_rec IN c_pool_chr_csr(l_pol_id)

Line 3901: lp_pocv_rec.status_code := Okl_Pool_Pvt.G_POC_STS_ACTIVE;

3897: --Update pool contents to ACTIVE
3898: FOR c_pool_chr_rec IN c_pool_chr_csr(l_pol_id)
3899: LOOP
3900: lp_pocv_rec.id := c_pool_chr_rec.id;
3901: lp_pocv_rec.status_code := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
3902:
3903: Okl_Pool_Pvt.update_pool_contents(
3904: p_api_version => p_api_version,
3905: p_init_msg_list => p_init_msg_list,

Line 3903: Okl_Pool_Pvt.update_pool_contents(

3899: LOOP
3900: lp_pocv_rec.id := c_pool_chr_rec.id;
3901: lp_pocv_rec.status_code := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
3902:
3903: Okl_Pool_Pvt.update_pool_contents(
3904: p_api_version => p_api_version,
3905: p_init_msg_list => p_init_msg_list,
3906: x_return_status => x_return_status,
3907: x_msg_count => x_msg_count,

Line 3913: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_POOL_PVT.update_pool_status_active x_return_status :' || x_return_status);

3909: p_pocv_rec => lp_pocv_rec,
3910: x_pocv_rec => lx_pocv_rec);
3911:
3912: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3913: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_POOL_PVT.update_pool_status_active x_return_status :' || x_return_status);
3914: END IF;
3915:
3916:
3917: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 3927: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_transaction');

3923:
3924:
3925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3926: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool transaction to Complete: START');
3927: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_transaction');
3928: END IF;
3929:
3930: --Update pool transaction to COMPLETE
3931: lp_poxv_rec.id := l_pox_id;

Line 3934: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,

3930: --Update pool transaction to COMPLETE
3931: lp_poxv_rec.id := l_pox_id;
3932: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_COMPLETE;
3933:
3934: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,
3935: p_init_msg_list => p_init_msg_list,
3936: x_return_status => x_return_status,
3937: x_msg_count => x_msg_count,
3938: x_msg_data => x_msg_data,

Line 3950: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_POOL_PVT.update_pool_transaction x_return_status :' || x_return_status);

3946: END IF;
3947:
3948:
3949: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3950: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_POOL_PVT.update_pool_transaction x_return_status :' || x_return_status);
3951: END IF;
3952:
3953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4103: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,

4099: l_agreement_id);
4100: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4101: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_INCOMPLETE;
4102:
4103: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,
4104: p_init_msg_list => p_init_msg_list,
4105: x_return_status => x_return_status,
4106: x_msg_count => x_msg_count,
4107: x_msg_data => x_msg_data,

Line 4125: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,

4121: IF(NVL(l_approval_process, 'NONE')) = 'NONE' THEN
4122: -- since no option is set at the profile, approve the operating agreement by default
4123: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_APPROVED;
4124:
4125: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,
4126: p_init_msg_list => p_init_msg_list,
4127: x_return_status => x_return_status,
4128: x_msg_count => x_msg_count,
4129: x_msg_data => x_msg_data,

Line 4143: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,

4139:
4140: -- We need to status to Approved Pending since We are sending for approval
4141: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_PENDING_APPR;
4142:
4143: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,
4144: p_init_msg_list => p_init_msg_list,
4145: x_return_status => x_return_status,
4146: x_msg_count => x_msg_count,
4147: x_msg_data => x_msg_data,