177: p_itemkey IN VARCHAR2,
178: x_noti_rec OUT NOCOPY noti_rec_type) IS
179:
180:
181: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
182: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
183: l_dispose_date DATE;
184: l_return_date DATE;
185: l_term_date DATE;
178: x_noti_rec OUT NOCOPY noti_rec_type) IS
179:
180:
181: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
182: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
183: l_dispose_date DATE;
184: l_return_date DATE;
185: l_term_date DATE;
186:
516:
517: -- Get all serviced assets for the contract
518: CURSOR get_k_serviced_assets_csr (p_khr_id IN NUMBER) IS
519: SELECT DISTINCT LNK_SRV_CIM.object1_id1 asset_id
520: FROM OKC_K_HEADERS_B OKS_CHRB,
521: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
522: OKC_K_LINES_B OKS_COV_PD_CLEB,
523: OKC_K_REL_OBJS KREL,
524: OKC_LINE_STYLES_B LNK_SRV_LSE,
546:
547: -- Get all serviced assets for the quote
548: CURSOR get_q_serviced_assets_csr (p_qte_id IN NUMBER) IS
549: SELECT DISTINCT LNK_SRV_CIM.object1_id1 asset_id
550: FROM OKC_K_HEADERS_B OKS_CHRB,
551: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
552: OKC_K_LINES_B OKS_COV_PD_CLEB,
553: OKC_K_REL_OBJS KREL,
554: OKC_LINE_STYLES_B LNK_SRV_LSE,
773:
774: -- Get the OKL contract details
775: CURSOR okl_k_dtls_csr ( p_okl_khr_id IN NUMBER) IS
776: SELECT CHR.contract_number
777: FROM OKC_K_HEADERS_B CHR
778: WHERE CHR.id = p_okl_khr_id;
779:
780: -- Get the OKS contract details
781: CURSOR oks_k_dtls_csr ( p_oks_khr_id IN NUMBER) IS
779:
780: -- Get the OKS contract details
781: CURSOR oks_k_dtls_csr ( p_oks_khr_id IN NUMBER) IS
782: SELECT CHR.contract_number
783: FROM OKC_K_HEADERS_B CHR
784: WHERE CHR.id = p_oks_khr_id;
785:
786: -- Get the asset details
787: CURSOR asset_dtls_csr ( p_id IN NUMBER) IS
1123: l_item_type WF_ITEMS.item_type%TYPE;
1124: l_item_key WF_ITEMS.item_key%TYPE;
1125: l_colon NUMBER;
1126: l_msgbody VARCHAR2(32000);
1127: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1128: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1129: l_asset_schedule_tbl kle_tbl_type;
1130: l_noti_rec noti_rec_type;
1131: i NUMBER := 1;
1124: l_item_key WF_ITEMS.item_key%TYPE;
1125: l_colon NUMBER;
1126: l_msgbody VARCHAR2(32000);
1127: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1128: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1129: l_asset_schedule_tbl kle_tbl_type;
1130: l_noti_rec noti_rec_type;
1131: i NUMBER := 1;
1132:
1343: l_item_type WF_ITEMS.item_type%TYPE;
1344: l_item_key WF_ITEMS.item_key%TYPE;
1345: l_colon NUMBER;
1346: l_msgbody VARCHAR2(32000);
1347: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1348: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1349: l_asset_schedule_tbl kle_tbl_type;
1350: l_noti_rec noti_rec_type;
1351: i NUMBER := 1;
1344: l_item_key WF_ITEMS.item_key%TYPE;
1345: l_colon NUMBER;
1346: l_msgbody VARCHAR2(32000);
1347: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1348: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1349: l_asset_schedule_tbl kle_tbl_type;
1350: l_noti_rec noti_rec_type;
1351: i NUMBER := 1;
1352:
1543: l_item_type WF_ITEMS.item_type%TYPE;
1544: l_item_key WF_ITEMS.item_key%TYPE;
1545: l_colon NUMBER;
1546: l_msgbody VARCHAR2(32000);
1547: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1548: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1549: l_quote_id VARCHAR2(200);
1550: l_asset_schedule_tbl kle_tbl_type;
1551: l_noti_rec noti_rec_type;
1544: l_item_key WF_ITEMS.item_key%TYPE;
1545: l_colon NUMBER;
1546: l_msgbody VARCHAR2(32000);
1547: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1548: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1549: l_quote_id VARCHAR2(200);
1550: l_asset_schedule_tbl kle_tbl_type;
1551: l_noti_rec noti_rec_type;
1552: i NUMBER := 1;
1756: l_item_type WF_ITEMS.item_type%TYPE;
1757: l_item_key WF_ITEMS.item_key%TYPE;
1758: l_colon NUMBER;
1759: l_msgbody VARCHAR2(32000);
1760: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1761: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1762: l_quote_id VARCHAR2(200);
1763: l_asset_schedule_tbl kle_tbl_type;
1764: l_noti_rec noti_rec_type;
1757: l_item_key WF_ITEMS.item_key%TYPE;
1758: l_colon NUMBER;
1759: l_msgbody VARCHAR2(32000);
1760: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1761: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1762: l_quote_id VARCHAR2(200);
1763: l_asset_schedule_tbl kle_tbl_type;
1764: l_noti_rec noti_rec_type;
1765: i NUMBER := 1;
1944: l_item_type WF_ITEMS.item_type%TYPE;
1945: l_item_key WF_ITEMS.item_key%TYPE;
1946: l_colon NUMBER;
1947: l_msgbody VARCHAR2(32000);
1948: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1949: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1950: l_quote_id VARCHAR2(200);
1951: l_asset_schedule_tbl kle_tbl_type;
1952: l_noti_rec noti_rec_type;
1945: l_item_key WF_ITEMS.item_key%TYPE;
1946: l_colon NUMBER;
1947: l_msgbody VARCHAR2(32000);
1948: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1949: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1950: l_quote_id VARCHAR2(200);
1951: l_asset_schedule_tbl kle_tbl_type;
1952: l_noti_rec noti_rec_type;
1953: i NUMBER := 1;