DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on OKL_CLD_PVT

Line 1319: x_cldv_rec OUT NOCOPY OKL_CLD_PVT.CLDV_REC_TYPE,

1315: PROCEDURE pop_checklist_item(
1316: p_api_version IN NUMBER,
1317: p_init_msg_list IN VARCHAR2,
1318: p_cld_id IN OKL_CHECKLIST_DETAILS.ID%TYPE,
1319: x_cldv_rec OUT NOCOPY OKL_CLD_PVT.CLDV_REC_TYPE,
1320: x_return_status OUT NOCOPY VARCHAR2,
1321: x_msg_count OUT NOCOPY NUMBER,
1322: x_msg_data OUT NOCOPY VARCHAR2)
1323: IS

Line 1330: l_cldv_rec OKL_CLD_PVT.CLDV_REC_TYPE;

1326: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POP_CHECKLIST_ITEM';
1327: l_return_status VARCHAR2(1);
1328:
1329: -- Record/Table Type Declarations
1330: l_cldv_rec OKL_CLD_PVT.CLDV_REC_TYPE;
1331:
1332: --Cursor to populate Lease Application details from database
1333: CURSOR cld_db_val_csr(cp_cld_id NUMBER) IS
1334: SELECT CLD.ID ID

Line 2517: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;

2513:
2514: -- Record/Table Type Declarations
2515: l_clhv_rec OKL_CLH_PVT.CLHV_REC_TYPE;
2516: x_clhv_rec OKL_CLH_PVT.CLHV_REC_TYPE;
2517: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2518: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2519:
2520: -- Bug#4741121 - viselvar - Modified - Start
2521: l_parameter_list wf_parameter_list_t;

Line 2518: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;

2514: -- Record/Table Type Declarations
2515: l_clhv_rec OKL_CLH_PVT.CLHV_REC_TYPE;
2516: x_clhv_rec OKL_CLH_PVT.CLHV_REC_TYPE;
2517: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2518: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2519:
2520: -- Bug#4741121 - viselvar - Modified - Start
2521: l_parameter_list wf_parameter_list_t;
2522: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.checklist_associated';

Line 11440: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;

11436: process_chklst BOOLEAN;
11437: approve BOOLEAN;
11438:
11439: -- Record/Table Type Declarations
11440: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
11441: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
11442: l_appealing_reco_tbl OCM_RECOMMENDATIONS_PUB.APPEALING_RECO_TBL;
11443:
11444: --Cursor to obtain Credit Recommendation details

Line 11441: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;

11437: approve BOOLEAN;
11438:
11439: -- Record/Table Type Declarations
11440: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
11441: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
11442: l_appealing_reco_tbl OCM_RECOMMENDATIONS_PUB.APPEALING_RECO_TBL;
11443:
11444: --Cursor to obtain Credit Recommendation details
11445: CURSOR credit_recom_csr(cp_lap_id NUMBER, cp_recom_id NUMBER, cp_cr_recom VARCHAR2)