DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on OKL_CLD_PVT

Line 1277: x_cldv_rec OUT NOCOPY OKL_CLD_PVT.CLDV_REC_TYPE,

1273: PROCEDURE pop_checklist_item(
1274: p_api_version IN NUMBER,
1275: p_init_msg_list IN VARCHAR2,
1276: p_cld_id IN OKL_CHECKLIST_DETAILS.ID%TYPE,
1277: x_cldv_rec OUT NOCOPY OKL_CLD_PVT.CLDV_REC_TYPE,
1278: x_return_status OUT NOCOPY VARCHAR2,
1279: x_msg_count OUT NOCOPY NUMBER,
1280: x_msg_data OUT NOCOPY VARCHAR2)
1281: IS

Line 1288: l_cldv_rec OKL_CLD_PVT.CLDV_REC_TYPE;

1284: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POP_CHECKLIST_ITEM';
1285: l_return_status VARCHAR2(1);
1286:
1287: -- Record/Table Type Declarations
1288: l_cldv_rec OKL_CLD_PVT.CLDV_REC_TYPE;
1289:
1290: --Cursor to populate Lease Application details from database
1291: CURSOR cld_db_val_csr(cp_cld_id NUMBER) IS
1292: SELECT CLD.ID ID

Line 2475: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;

2471:
2472: -- Record/Table Type Declarations
2473: l_clhv_rec OKL_CLH_PVT.CLHV_REC_TYPE;
2474: x_clhv_rec OKL_CLH_PVT.CLHV_REC_TYPE;
2475: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2476: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2477:
2478: -- Bug#4741121 - viselvar - Modified - Start
2479: l_parameter_list wf_parameter_list_t;

Line 2476: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;

2472: -- Record/Table Type Declarations
2473: l_clhv_rec OKL_CLH_PVT.CLHV_REC_TYPE;
2474: x_clhv_rec OKL_CLH_PVT.CLHV_REC_TYPE;
2475: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2476: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2477:
2478: -- Bug#4741121 - viselvar - Modified - Start
2479: l_parameter_list wf_parameter_list_t;
2480: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.checklist_associated';

Line 11288: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;

11284: process_chklst BOOLEAN;
11285: approve BOOLEAN;
11286:
11287: -- Record/Table Type Declarations
11288: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
11289: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
11290: l_appealing_reco_tbl OCM_RECOMMENDATIONS_PUB.APPEALING_RECO_TBL;
11291:
11292: --Cursor to obtain Credit Recommendation details

Line 11289: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;

11285: approve BOOLEAN;
11286:
11287: -- Record/Table Type Declarations
11288: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
11289: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
11290: l_appealing_reco_tbl OCM_RECOMMENDATIONS_PUB.APPEALING_RECO_TBL;
11291:
11292: --Cursor to obtain Credit Recommendation details
11293: CURSOR credit_recom_csr(cp_lap_id NUMBER, cp_recom_id NUMBER, cp_cr_recom VARCHAR2)