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.7 2008/12/20 01:36:06 smereddy 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 717: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.POPULATE_EC_REC';

713: AND ADJ.ADJUSTMENT_SOURCE_TYPE = cp_adj_src_type;
714:
715: BEGIN
716: l_return_status := OKL_API.G_RET_STS_SUCCESS;
717: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.POPULATE_EC_REC';
718:
719: -- check for logging on PROCEDURE level
720: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
721: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

1096: lap_db_val_rec lap_db_val_csr%ROWTYPE;
1097:
1098: BEGIN
1099: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1100: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.POPULATE_LEASE_APP';
1101:
1102: -- check for logging on PROCEDURE level
1103: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
1104: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

1324: WHERE CLD.ID = cp_cld_id;
1325: cld_db_val_rec cld_db_val_csr%ROWTYPE;
1326: BEGIN
1327: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1328: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.POP_CHECKLIST_ITEM';
1329:
1330: -- check for logging on PROCEDURE level
1331: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
1332: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

1479: x_lapv_rec lapv_rec_type;
1480: x_lsqv_rec lsqv_rec_type;
1481: BEGIN
1482: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1483: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SET_IN_PROGRESS_STATUS';
1484:
1485: -- check for logging on PROCEDURE level
1486: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
1487: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

1674: AND PLAB.ID = LAB.PARENT_LEASEAPP_ID;
1675: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
1676: BEGIN
1677: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1678: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.REVERT_TO_ORIG_STATUS';
1679:
1680: -- check for logging on PROCEDURE level
1681: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
1682: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

1945: WHERE LQ.ID = cp_lsq_id;
1946: lsq_parent_rec lsq_parent_csr%ROWTYPE;
1947: BEGIN
1948: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1949: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CHECK_LEASE_QUOTE_DEFAULTS';
1950:
1951: -- check for logging on PROCEDURE level
1952: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
1953: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

2231: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
2232:
2233: BEGIN
2234: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2235: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CREATE_CREDIT_APP';
2236:
2237: -- check for logging on PROCEDURE level
2238: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
2239: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

2533: lap_chk_dtls_rec lap_chk_dtls_csr%ROWTYPE;
2534:
2535: BEGIN
2536: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2537: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CHECKLIST_INST_CRE';
2538:
2539: -- check for logging on PROCEDURE level
2540: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
2541: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

2907: --End - varangan-3-11-2005- removed lease application reference for bug#4713798
2908: lse_app_src_dtls_rec lse_app_src_dtls_csr%ROWTYPE;
2909: BEGIN
2910: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2911: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_CRE';
2912:
2913: -- check for logging on PROCEDURE level
2914: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
2915: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

3614: get_crd_app_data_rec get_crd_app_data%ROWTYPE;
3615: --asawanka Bug 4865418 changes end
3616: BEGIN
3617: l_return_status := OKL_API.G_RET_STS_SUCCESS;
3618: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_UPD';
3619:
3620: -- check for logging on PROCEDURE level
3621: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
3622: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

4267: --Bug# 6850094 :End
4268: AND LATV.ID = p_latv_id;
4269: BEGIN
4270: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4271: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_VAL';
4272:
4273: -- check for logging on PROCEDURE level
4274: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
4275: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

4683: p_event_name1 VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.quote_accepted';
4684: -- Bug#4741121 - viselvar - Modified - End
4685: BEGIN
4686: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4687: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_ACCEPT';
4688:
4689: -- check for logging on PROCEDURE level
4690: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
4691: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

5030: l_event_name wf_events.name%TYPE;
5031: -- Bug#4741121 - smadhava - Added - End
5032: BEGIN
5033: l_return_status := OKL_API.G_RET_STS_SUCCESS;
5034: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_WITHDRAW';
5035:
5036: -- check for logging on PROCEDURE level
5037: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
5038: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

5438: src_lse_opp_dtls_rec src_lse_opp_dtls_csr%ROWTYPE;
5439: --End-bug#4721142 - varangan- cursor to fetch quote details from opportunity id
5440: BEGIN
5441: l_return_status := OKL_API.G_RET_STS_SUCCESS;
5442: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_DUP';
5443:
5444: -- check for logging on PROCEDURE level
5445: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
5446: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

6069: AND LSQ.PARENT_OBJECT_ID = p_lap_id;
6070: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;
6071: BEGIN
6072: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6073: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SUBMIT_FOR_PRICING';
6074:
6075: -- check for logging on PROCEDURE level
6076: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
6077: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

6501: WHERE LAB.ID = p_lap_id;
6502: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
6503: BEGIN
6504: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6505: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SUBMIT_FOR_CREDIT';
6506:
6507: -- check for logging on PROCEDURE level
6508: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
6509: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

7046:
7047: BEGIN
7048: l_return_status := OKL_API.G_RET_STS_ERROR;
7049: l_eligible := false;
7050: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.IS_VALID_PROGRAM_AGREEMENT';
7051:
7052: -- check for logging on PROCEDURE level
7053: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
7054: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

7243:
7244: BEGIN
7245: l_return_status := OKL_API.G_RET_STS_ERROR;
7246: l_eligible := false;
7247: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.IS_VALID_LEASEAPP_TEMPLATE';
7248:
7249: -- check for logging on PROCEDURE level
7250: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
7251: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

7430: l_site_use_id NUMBER;
7431:
7432: BEGIN
7433: l_cr_class := NULL;
7434: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.GET_CREDIT_CLASSFICATION';
7435:
7436: -- check for logging on PROCEDURE level
7437: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
7438: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

7546: in_play_qte_dtls_rec in_play_qte_dtls_csr%ROWTYPE;
7547:
7548: BEGIN
7549: l_return_status := OKL_API.G_RET_STS_SUCCESS;
7550: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.ACCEPT_COUNTER_OFFER';
7551:
7552: -- check for logging on PROCEDURE level
7553: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
7554: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

7817: lap_db_val_rec lap_db_val_csr%ROWTYPE;
7818:
7819: BEGIN
7820: l_return_status := OKL_API.G_RET_STS_SUCCESS;
7821: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.REVERT_LEASEAPP';
7822:
7823: -- check for logging on PROCEDURE level
7824: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
7825: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

8048: AND CCR.SOURCE_COLUMN1 = cp_lap_id
8049: AND CCRM.RECOMMENDATION_VALUE1 = cp_co_id;
8050: BEGIN
8051: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8052: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.VALIDATE_CREDIT_RESULTS';
8053:
8054: -- check for logging on PROCEDURE level
8055: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
8056: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

8355: AND LAP.ID = cp_lap_id;
8356: src_lse_app_dtls_rec src_lse_app_dtls_csr%ROWTYPE;
8357: BEGIN
8358: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8359: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_RESUBMIT';
8360:
8361: -- check for logging on PROCEDURE level
8362: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
8363: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

8793: WHERE LAB.ID = cp_lap_id;
8794: lap_db_val_rec lap_db_val_csr%ROWTYPE;
8795: BEGIN
8796: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8797: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_CANCEL';
8798:
8799: -- check for logging on PROCEDURE level
8800: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
8801: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

9165: AND LAP.ID = cp_lap_id;
9166: src_lse_app_dtls_rec src_lse_app_dtls_csr%ROWTYPE;
9167: BEGIN
9168: l_return_status := OKL_API.G_RET_STS_SUCCESS;
9169: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_APPEAL';
9170:
9171: -- check for logging on PROCEDURE level
9172: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
9173: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

9665: WHERE LAB.ID = p_lap_id;
9666: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
9667: BEGIN
9668: l_return_status := OKL_API.G_RET_STS_SUCCESS;
9669: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CHECK_ELIGIBILITY';
9670:
9671: -- check for logging on PROCEDURE level
9672: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
9673: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

10002: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'LEASE_APP_QA_VAL';
10003: l_return_status VARCHAR2(1);
10004: BEGIN
10005: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10006: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_QA_VAL';
10007:
10008: -- check for logging on PROCEDURE level
10009: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
10010: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

10148: l_lsq_dtls_rec l_lsq_dtls_csr%ROWTYPE;
10149:
10150: BEGIN
10151: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10152: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_PRICE';
10153:
10154: -- check for logging on PROCEDURE level
10155: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
10156: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

10363: x_lsqv_rec lsqv_rec_type;
10364:
10365: BEGIN
10366: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10367: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SET_LEASE_APP_STATUS';
10368:
10369: -- check for logging on PROCEDURE level
10370: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
10371: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

10542: x_lsqv_rec lsqv_rec_type;
10543:
10544: BEGIN
10545: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10546: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.SET_LEASE_APP_EXPDAYS';
10547:
10548: -- check for logging on PROCEDURE level
10549: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
10550: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

10873: WHERE LAB.ID = p_lse_app_id;
10874: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
10875: BEGIN
10876: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10877: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.LEASE_APP_UNACCEPT';
10878:
10879: -- check for logging on PROCEDURE level
10880: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
10881: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

11126: l_lap_dtls_rec l_lap_dtls_csr%ROWTYPE;
11127:
11128: BEGIN
11129: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11130: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CREATE_CONTRACT';
11131:
11132: -- check for logging on PROCEDURE level
11133: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
11134: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

11329: AND LAB.ID = cp_lap_id;
11330: crd_app_data_rec crd_app_data_csr%ROWTYPE;
11331: BEGIN
11332: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11333: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.APPEAL_RECOMMENDATIONS';
11334:
11335: -- check for logging on PROCEDURE level
11336: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
11337: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

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

11725: AND CLAB.ID = p_lap_id;
11726: l_uniq_qte_contract_rec l_uniq_qte_contract_csr%ROWTYPE;
11727: BEGIN
11728: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11729: L_MODULE := 'OKL.PLSQL.OKL_LEASE_APP_PVT.CREATE_CONTRACT_VAL';
11730:
11731: -- check for logging on PROCEDURE level
11732: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
11733: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 11917: END OKL_LEASE_APP_PVT;

11913: x_msg_data => x_msg_data,
11914: p_api_type => G_API_TYPE);
11915: END create_contract_val;
11916:
11917: END OKL_LEASE_APP_PVT;