DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on OKL_LEASE_APP_PVT

Line 1: PACKAGE BODY OKL_LEASE_APP_PVT AS

1: PACKAGE BODY OKL_LEASE_APP_PVT AS
2: /* $Header: OKLRLAPB.pls 120.93.12010000.10 2010/02/10 08:31:01 smadhava ship $*/
3: -- Bug#4741121 - smadhava - Modified - Start
4: G_WF_EVT_LEASE_APP_WDW_PENDING CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.sales.leaseapplication.withdrawn';
5: G_WF_LEASE_APP_ID CONSTANT VARCHAR2(50) := 'LA_ID';

Line 759: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.POPULATE_EC_REC';

755: AND ADJ.ADJUSTMENT_SOURCE_TYPE = cp_adj_src_type;
756:
757: BEGIN
758: l_return_status := OKL_API.G_RET_STS_SUCCESS;
759: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.POPULATE_EC_REC';
760:
761: -- check for logging on PROCEDURE level
762: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
763: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 1142: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.POPULATE_LEASE_APP';

1138: lap_db_val_rec lap_db_val_csr%ROWTYPE;
1139:
1140: BEGIN
1141: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1142: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.POPULATE_LEASE_APP';
1143:
1144: -- check for logging on PROCEDURE level
1145: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
1146: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 1370: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.POP_CHECKLIST_ITEM';

1366: WHERE CLD.ID = cp_cld_id;
1367: cld_db_val_rec cld_db_val_csr%ROWTYPE;
1368: BEGIN
1369: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1370: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.POP_CHECKLIST_ITEM';
1371:
1372: -- check for logging on PROCEDURE level
1373: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
1374: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 1525: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SET_IN_PROGRESS_STATUS';

1521: x_lapv_rec lapv_rec_type;
1522: x_lsqv_rec lsqv_rec_type;
1523: BEGIN
1524: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1525: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SET_IN_PROGRESS_STATUS';
1526:
1527: -- check for logging on PROCEDURE level
1528: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
1529: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 1720: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.REVERT_TO_ORIG_STATUS';

1716: AND PLAB.ID = LAB.PARENT_LEASEAPP_ID;
1717: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
1718: BEGIN
1719: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1720: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.REVERT_TO_ORIG_STATUS';
1721:
1722: -- check for logging on PROCEDURE level
1723: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
1724: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 1991: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CHECK_LEASE_QUOTE_DEFAULTS';

1987: WHERE LQ.ID = cp_lsq_id;
1988: lsq_parent_rec lsq_parent_csr%ROWTYPE;
1989: BEGIN
1990: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1991: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CHECK_LEASE_QUOTE_DEFAULTS';
1992:
1993: -- check for logging on PROCEDURE level
1994: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
1995: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 2277: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CREATE_CREDIT_APP';

2273: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
2274:
2275: BEGIN
2276: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2277: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CREATE_CREDIT_APP';
2278:
2279: -- check for logging on PROCEDURE level
2280: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
2281: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 2579: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CHECKLIST_INST_CRE';

2575: lap_chk_dtls_rec lap_chk_dtls_csr%ROWTYPE;
2576:
2577: BEGIN
2578: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2579: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CHECKLIST_INST_CRE';
2580:
2581: -- check for logging on PROCEDURE level
2582: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
2583: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 2953: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_CRE';

2949: --End - varangan-3-11-2005- removed lease application reference for bug#4713798
2950: lse_app_src_dtls_rec lse_app_src_dtls_csr%ROWTYPE;
2951: BEGIN
2952: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2953: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_CRE';
2954:
2955: -- check for logging on PROCEDURE level
2956: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
2957: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 3706: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_UPD';

3702: get_crd_app_data_rec get_crd_app_data%ROWTYPE;
3703: --asawanka Bug 4865418 changes end
3704: BEGIN
3705: l_return_status := OKL_API.G_RET_STS_SUCCESS;
3706: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_UPD';
3707:
3708: -- check for logging on PROCEDURE level
3709: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
3710: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 4359: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_VAL';

4355: --Bug# 6850094 :End
4356: AND LATV.ID = p_latv_id;
4357: BEGIN
4358: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4359: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_VAL';
4360:
4361: -- check for logging on PROCEDURE level
4362: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
4363: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 4775: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_ACCEPT';

4771: p_event_name1 VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.quote_accepted';
4772: -- Bug#4741121 - viselvar - Modified - End
4773: BEGIN
4774: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4775: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_ACCEPT';
4776:
4777: -- check for logging on PROCEDURE level
4778: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
4779: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 5122: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_WITHDRAW';

5118: l_event_name wf_events.name%TYPE;
5119: -- Bug#4741121 - smadhava - Added - End
5120: BEGIN
5121: l_return_status := OKL_API.G_RET_STS_SUCCESS;
5122: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_WITHDRAW';
5123:
5124: -- check for logging on PROCEDURE level
5125: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
5126: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 5530: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_DUP';

5526: src_lse_opp_dtls_rec src_lse_opp_dtls_csr%ROWTYPE;
5527: --End-bug#4721142 - varangan- cursor to fetch quote details from opportunity id
5528: BEGIN
5529: l_return_status := OKL_API.G_RET_STS_SUCCESS;
5530: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_DUP';
5531:
5532: -- check for logging on PROCEDURE level
5533: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
5534: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 6204: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SUBMIT_FOR_PRICING';

6200: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
6201: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;
6202: BEGIN
6203: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6204: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SUBMIT_FOR_PRICING';
6205:
6206: -- check for logging on PROCEDURE level
6207: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
6208: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 6636: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SUBMIT_FOR_CREDIT';

6632: WHERE LAB.ID = p_lap_id;
6633: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
6634: BEGIN
6635: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6636: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SUBMIT_FOR_CREDIT';
6637:
6638: -- check for logging on PROCEDURE level
6639: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
6640: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 7181: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.IS_VALID_PROGRAM_AGREEMENT';

7177:
7178: BEGIN
7179: l_return_status := OKL_API.G_RET_STS_ERROR;
7180: l_eligible := false;
7181: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.IS_VALID_PROGRAM_AGREEMENT';
7182:
7183: -- check for logging on PROCEDURE level
7184: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
7185: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 7378: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.IS_VALID_LEASEAPP_TEMPLATE';

7374:
7375: BEGIN
7376: l_return_status := OKL_API.G_RET_STS_ERROR;
7377: l_eligible := false;
7378: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.IS_VALID_LEASEAPP_TEMPLATE';
7379:
7380: -- check for logging on PROCEDURE level
7381: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
7382: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 7565: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.GET_CREDIT_CLASSFICATION';

7561: l_site_use_id NUMBER;
7562:
7563: BEGIN
7564: l_cr_class := NULL;
7565: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.GET_CREDIT_CLASSFICATION';
7566:
7567: -- check for logging on PROCEDURE level
7568: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
7569: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 7681: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.ACCEPT_COUNTER_OFFER';

7677: in_play_qte_dtls_rec in_play_qte_dtls_csr%ROWTYPE;
7678:
7679: BEGIN
7680: l_return_status := OKL_API.G_RET_STS_SUCCESS;
7681: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.ACCEPT_COUNTER_OFFER';
7682:
7683: -- check for logging on PROCEDURE level
7684: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
7685: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 7952: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.REVERT_LEASEAPP';

7948: lap_db_val_rec lap_db_val_csr%ROWTYPE;
7949:
7950: BEGIN
7951: l_return_status := OKL_API.G_RET_STS_SUCCESS;
7952: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.REVERT_LEASEAPP';
7953:
7954: -- check for logging on PROCEDURE level
7955: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
7956: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 8183: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.VALIDATE_CREDIT_RESULTS';

8179: AND CCR.SOURCE_COLUMN1 = cp_lap_id
8180: AND CCRM.RECOMMENDATION_VALUE1 = cp_co_id;
8181: BEGIN
8182: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8183: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.VALIDATE_CREDIT_RESULTS';
8184:
8185: -- check for logging on PROCEDURE level
8186: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
8187: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 8490: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_RESUBMIT';

8486: AND LAP.ID = cp_lap_id;
8487: src_lse_app_dtls_rec src_lse_app_dtls_csr%ROWTYPE;
8488: BEGIN
8489: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8490: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_RESUBMIT';
8491:
8492: -- check for logging on PROCEDURE level
8493: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
8494: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 8928: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_CANCEL';

8924: WHERE LAB.ID = cp_lap_id;
8925: lap_db_val_rec lap_db_val_csr%ROWTYPE;
8926: BEGIN
8927: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8928: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_CANCEL';
8929:
8930: -- check for logging on PROCEDURE level
8931: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
8932: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 9300: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_APPEAL';

9296: AND LAP.ID = cp_lap_id;
9297: src_lse_app_dtls_rec src_lse_app_dtls_csr%ROWTYPE;
9298: BEGIN
9299: l_return_status := OKL_API.G_RET_STS_SUCCESS;
9300: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_APPEAL';
9301:
9302: -- check for logging on PROCEDURE level
9303: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
9304: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 9800: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CHECK_ELIGIBILITY';

9796: WHERE LAB.ID = p_lap_id;
9797: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
9798: BEGIN
9799: l_return_status := OKL_API.G_RET_STS_SUCCESS;
9800: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CHECK_ELIGIBILITY';
9801:
9802: -- check for logging on PROCEDURE level
9803: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
9804: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 10158: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_QA_VAL';

10154: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'LEASE_APP_QA_VAL';
10155: l_return_status VARCHAR2(1);
10156: BEGIN
10157: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10158: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_QA_VAL';
10159:
10160: -- check for logging on PROCEDURE level
10161: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
10162: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 10304: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_PRICE';

10300: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;
10301:
10302: BEGIN
10303: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10304: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_PRICE';
10305:
10306: -- check for logging on PROCEDURE level
10307: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
10308: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 10519: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SET_LEASE_APP_STATUS';

10515: x_lsqv_rec lsqv_rec_type;
10516:
10517: BEGIN
10518: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10519: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SET_LEASE_APP_STATUS';
10520:
10521: -- check for logging on PROCEDURE level
10522: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
10523: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 10698: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SET_LEASE_APP_EXPDAYS';

10694: x_lsqv_rec lsqv_rec_type;
10695:
10696: BEGIN
10697: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10698: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SET_LEASE_APP_EXPDAYS';
10699:
10700: -- check for logging on PROCEDURE level
10701: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
10702: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 11029: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_UNACCEPT';

11025: WHERE LAB.ID = p_lse_app_id;
11026: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
11027: BEGIN
11028: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11029: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_UNACCEPT';
11030:
11031: -- check for logging on PROCEDURE level
11032: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
11033: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 11282: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CREATE_CONTRACT';

11278: l_lap_dtls_rec l_lap_dtls_csr%ROWTYPE;
11279:
11280: BEGIN
11281: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11282: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CREATE_CONTRACT';
11283:
11284: -- check for logging on PROCEDURE level
11285: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
11286: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 11485: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.APPEAL_RECOMMENDATIONS';

11481: AND LAB.ID = cp_lap_id;
11482: crd_app_data_rec crd_app_data_csr%ROWTYPE;
11483: BEGIN
11484: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11485: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.APPEAL_RECOMMENDATIONS';
11486:
11487: -- check for logging on PROCEDURE level
11488: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
11489: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 11881: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CREATE_CONTRACT_VAL';

11877: AND CLAB.ID = p_lap_id;
11878: l_uniq_qte_contract_rec l_uniq_qte_contract_csr%ROWTYPE;
11879: BEGIN
11880: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11881: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CREATE_CONTRACT_VAL';
11882:
11883: -- check for logging on PROCEDURE level
11884: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
11885: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 12080: END OKL_LEASE_APP_PVT;

12076: x_msg_data => x_msg_data,
12077: p_api_type => G_API_TYPE);
12078: END create_contract_val;
12079:
12080: END OKL_LEASE_APP_PVT;