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 1930: OKL_POOL_PVT.update_pool(

1926: --
1927: l_polv_rec.id := p_secAgreement_rec.pol_id;
1928: l_polv_rec.khr_id := x_secAgreement_rec.ID;
1929:
1930: OKL_POOL_PVT.update_pool(
1931: p_api_version => p_api_version,
1932: p_init_msg_list => p_init_msg_list,
1933:
1934: x_return_status => x_return_status,

Line 2291: OKL_POOL_PVT.update_pool(

2287:
2288: l_polv_rec.id := l_pol_id;
2289: l_polv_rec.khr_id := NULL;
2290:
2291: OKL_POOL_PVT.update_pool(
2292: p_api_version => p_api_version,
2293: p_init_msg_list => p_init_msg_list,
2294: x_return_status => x_return_status,
2295: x_msg_count => x_msg_count,

Line 2316: OKL_POOL_PVT.update_pool(

2312:
2313: l_polv_rec.id := p_secAgreement_rec.pol_id;
2314: l_polv_rec.khr_id := p_secAgreement_rec.ID;
2315:
2316: OKL_POOL_PVT.update_pool(
2317: p_api_version => p_api_version,
2318: p_init_msg_list => p_init_msg_list,
2319: x_return_status => x_return_status,
2320: x_msg_count => x_msg_count,

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

2616: -- initial transaction when pool become active
2617: --OKL_POOL_TRANSACTION_TYPE
2618: ----------------------------------------------------------------------------
2619: --dbms_output.put_line('1. CREATE a TRANSACTION FOR entire pool BY pol_id');
2620: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction START');
2621: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2622: 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');
2623: END IF;
2624: OPEN c_pool;

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

2649: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_COMPLETE;
2650: --added abhsaxen for Legal Entity Uptake
2651: lp_poxv_rec.LEGAL_ENTITY_ID := l_legal_entity_id;
2652: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2653: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_pool_pvt.create_pool_transaction');
2654: END IF;
2655:
2656: OKL_POOL_PVT.create_pool_transaction(
2657: p_api_version => p_api_version,

Line 2656: OKL_POOL_PVT.create_pool_transaction(

2652: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2653: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_pool_pvt.create_pool_transaction');
2654: END IF;
2655:
2656: OKL_POOL_PVT.create_pool_transaction(
2657: p_api_version => p_api_version,
2658: p_init_msg_list => p_init_msg_list,
2659: x_return_status => x_return_status,
2660: x_msg_count => x_msg_count,

Line 2666: 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);

2662: p_poxv_rec => lp_poxv_rec,
2663: x_poxv_rec => lx_poxv_rec);
2664: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2665: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2666: 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);
2667: END IF;
2668:
2669: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2671: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2672: RAISE OKL_API.G_EXCEPTION_ERROR;
2673: END IF;
2674: END IF;
2675: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction END');
2676: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2677: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction: END');
2678: END IF;
2679:

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

2673: END IF;
2674: END IF;
2675: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction END');
2676: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2677: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction: END');
2678: END IF;
2679:
2680: ----------------------------------------------------------------------------
2681: -- get pox_id after create trx entry

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

2683: -- make association between pool transaction and pool contents' records
2684: ----------------------------------------------------------------------------
2685: -- loop
2686: --dbms_output.put_line('2. update pool contents to point to this transaction');
2687: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents Start');
2688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2689: 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');
2690: 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');
2691: END IF;

Line 2690: 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');

2686: --dbms_output.put_line('2. update pool contents to point to this transaction');
2687: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents Start');
2688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2689: 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');
2690: 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');
2691: END IF;
2692:
2693: OPEN c_poc;
2694: LOOP

Line 2711: OKL_POOL_PVT.update_pool_contents(

2707: lp_pocv_rec.POL_ID := l_pol_id;
2708: lp_pocv_rec.POX_ID := lx_poxv_rec.id;
2709: lp_pocv_rec.TRANSACTION_NUMBER_IN := lx_poxv_rec.TRANSACTION_NUMBER;
2710:
2711: OKL_POOL_PVT.update_pool_contents(
2712: p_api_version => p_api_version,
2713: p_init_msg_list => p_init_msg_list,
2714: x_return_status => x_return_status,
2715: x_msg_count => x_msg_count,

Line 2722: 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);

2718: x_pocv_rec => lx_pocv_rec);
2719:
2720: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2721: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2722: 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);
2723: END IF;
2724:
2725: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2730:
2731: END LOOP;
2732: CLOSE c_poc;
2733: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2734: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents : END');
2735: END IF;
2736:
2737: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents End');
2738:

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

2733: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2734: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents : END');
2735: END IF;
2736:
2737: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents End');
2738:
2739: ----------------------------------------------------------------------------
2740: --3 Mark associated contract to securitizated
2741: ----------------------------------------------------------------------------

Line 3038: 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');

3034: --11 update pool header and contents status to active
3035: ----------------------------------------------------------------------------
3036: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3037: 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');
3038: 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');
3039: END IF;
3040:
3041: OKL_POOL_PVT.update_pool_status_active(
3042: p_api_version => p_api_version,

Line 3041: OKL_POOL_PVT.update_pool_status_active(

3037: 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');
3038: 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');
3039: END IF;
3040:
3041: OKL_POOL_PVT.update_pool_status_active(
3042: p_api_version => p_api_version,
3043: p_init_msg_list => p_init_msg_list,
3044: x_return_status => x_return_status,
3045: x_msg_count => x_msg_count,

Line 3050: 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);

3046: x_msg_data => x_msg_data,
3047: p_pol_id => l_pol_id);
3048:
3049: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3050: 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);
3051: END IF;
3052:
3053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3344: OKL_POOL_PVT.get_tot_recei_amt_pend(

3340: 'POOL_ID');
3341: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3342: END IF;
3343:
3344: OKL_POOL_PVT.get_tot_recei_amt_pend(
3345: p_api_version => '1.0',
3346: p_init_msg_list => p_init_msg_list,
3347: x_return_status => x_return_status,
3348: x_msg_count => x_msg_count,

Line 3362: OKL_POOL_PVT.reconcile_contents(

3358: x_return_status := OKL_API.G_RET_STS_ERROR;
3359: END IF;
3360:
3361: --Check to see if the pool recquires reconcilation
3362: OKL_POOL_PVT.reconcile_contents(
3363: p_api_version => p_api_version,
3364: p_init_msg_list => p_init_msg_list,
3365: x_return_status => x_return_status,
3366: x_msg_count => x_msg_count,

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

3472: SELECT poc.khr_id,
3473: poc.id
3474: FROM okl_pool_contents poc
3475: WHERE poc.pol_id = p_pol_id
3476: AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING;
3477:
3478: /* ankushar Bug# 6773285 Added Principal Payment for Loan contracts also renamed Cursor
3479: Start Changes
3480: */

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

3619: --Update the status of the Pool Transaction to INCOMPLETE and Halt processing
3620: lp_poxv_rec.id := l_pox_id;
3621: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_INCOMPLETE;
3622:
3623: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,
3624: p_init_msg_list => p_init_msg_list,
3625: x_return_status => x_return_status,
3626: x_msg_count => x_msg_count,
3627: x_msg_data => x_msg_data,

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

3907: --8 update pool contents status to active and pool transactions status to COMPLETE
3908: ----------------------------------------------------------------------------------
3909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3910: 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');
3911: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_contents');
3912: END IF;
3913:
3914: --Update pool contents to ACTIVE
3915: FOR c_pool_chr_rec IN c_pool_chr_csr(l_pol_id)

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

3914: --Update pool contents to ACTIVE
3915: FOR c_pool_chr_rec IN c_pool_chr_csr(l_pol_id)
3916: LOOP
3917: lp_pocv_rec.id := c_pool_chr_rec.id;
3918: lp_pocv_rec.status_code := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
3919:
3920: Okl_Pool_Pvt.update_pool_contents(
3921: p_api_version => p_api_version,
3922: p_init_msg_list => p_init_msg_list,

Line 3920: Okl_Pool_Pvt.update_pool_contents(

3916: LOOP
3917: lp_pocv_rec.id := c_pool_chr_rec.id;
3918: lp_pocv_rec.status_code := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
3919:
3920: Okl_Pool_Pvt.update_pool_contents(
3921: p_api_version => p_api_version,
3922: p_init_msg_list => p_init_msg_list,
3923: x_return_status => x_return_status,
3924: x_msg_count => x_msg_count,

Line 3930: 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);

3926: p_pocv_rec => lp_pocv_rec,
3927: x_pocv_rec => lx_pocv_rec);
3928:
3929: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3930: 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);
3931: END IF;
3932:
3933:
3934: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

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

3940:
3941:
3942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3943: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool transaction to Complete: START');
3944: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_transaction');
3945: END IF;
3946:
3947: --Update pool transaction to COMPLETE
3948: lp_poxv_rec.id := l_pox_id;

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

3947: --Update pool transaction to COMPLETE
3948: lp_poxv_rec.id := l_pox_id;
3949: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_COMPLETE;
3950:
3951: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,
3952: p_init_msg_list => p_init_msg_list,
3953: x_return_status => x_return_status,
3954: x_msg_count => x_msg_count,
3955: x_msg_data => x_msg_data,

Line 3967: 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);

3963: END IF;
3964:
3965:
3966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3967: 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);
3968: END IF;
3969:
3970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

4121: l_agreement_id);
4122: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4123: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_INCOMPLETE;
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 4153: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,

4149: IF(NVL(l_approval_process, 'NONE')) = 'NONE' THEN
4150: -- since no option is set at the profile, approve the operating agreement by default
4151: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_APPROVED;
4152:
4153: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,
4154: p_init_msg_list => p_init_msg_list,
4155: x_return_status => x_return_status,
4156: x_msg_count => x_msg_count,
4157: x_msg_data => x_msg_data,

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

4167:
4168: -- We need to status to Approved Pending since We are sending for approval
4169: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_PENDING_APPR;
4170:
4171: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,
4172: p_init_msg_list => p_init_msg_list,
4173: x_return_status => x_return_status,
4174: x_msg_count => x_msg_count,
4175: x_msg_data => x_msg_data,