eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_SERVICE_K_INT_WF dependencies on OKC_K_HEADERS_B

Line 181: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

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;

Line 182: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

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:

Line 520: FROM OKC_K_HEADERS_B OKS_CHRB,

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,

Line 550: FROM OKC_K_HEADERS_B OKS_CHRB,

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,

Line 777: FROM OKC_K_HEADERS_B CHR

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

Line 783: FROM OKC_K_HEADERS_B CHR

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

Line 1127: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

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;

Line 1128: l_oks_contract_number OKC_K_HEADERS_B.contract_number%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;
1132:

Line 1298: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

1294: l_item_type WF_ITEMS.item_type%TYPE;
1295: l_item_key WF_ITEMS.item_key%TYPE;
1296: l_colon NUMBER;
1297: l_msgbody VARCHAR2(32000);
1298: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1299: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1300: l_asset_schedule_tbl kle_tbl_type;
1301: l_noti_rec noti_rec_type;
1302: i NUMBER := 1;

Line 1299: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

1295: l_item_key WF_ITEMS.item_key%TYPE;
1296: l_colon NUMBER;
1297: l_msgbody VARCHAR2(32000);
1298: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1299: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1300: l_asset_schedule_tbl kle_tbl_type;
1301: l_noti_rec noti_rec_type;
1302: i NUMBER := 1;
1303:

Line 1448: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

1444: l_item_type WF_ITEMS.item_type%TYPE;
1445: l_item_key WF_ITEMS.item_key%TYPE;
1446: l_colon NUMBER;
1447: l_msgbody VARCHAR2(32000);
1448: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1449: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1450: l_quote_id VARCHAR2(200);
1451: l_asset_schedule_tbl kle_tbl_type;
1452: l_noti_rec noti_rec_type;

Line 1449: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

1445: l_item_key WF_ITEMS.item_key%TYPE;
1446: l_colon NUMBER;
1447: l_msgbody VARCHAR2(32000);
1448: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1449: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1450: l_quote_id VARCHAR2(200);
1451: l_asset_schedule_tbl kle_tbl_type;
1452: l_noti_rec noti_rec_type;
1453: i NUMBER := 1;

Line 1613: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

1609: l_item_type WF_ITEMS.item_type%TYPE;
1610: l_item_key WF_ITEMS.item_key%TYPE;
1611: l_colon NUMBER;
1612: l_msgbody VARCHAR2(32000);
1613: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1614: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1615: l_quote_id VARCHAR2(200);
1616: l_asset_schedule_tbl kle_tbl_type;
1617: l_noti_rec noti_rec_type;

Line 1614: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

1610: l_item_key WF_ITEMS.item_key%TYPE;
1611: l_colon NUMBER;
1612: l_msgbody VARCHAR2(32000);
1613: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1614: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1615: l_quote_id VARCHAR2(200);
1616: l_asset_schedule_tbl kle_tbl_type;
1617: l_noti_rec noti_rec_type;
1618: i NUMBER := 1;

Line 1752: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

1748: l_item_type WF_ITEMS.item_type%TYPE;
1749: l_item_key WF_ITEMS.item_key%TYPE;
1750: l_colon NUMBER;
1751: l_msgbody VARCHAR2(32000);
1752: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1753: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1754: l_quote_id VARCHAR2(200);
1755: l_asset_schedule_tbl kle_tbl_type;
1756: l_noti_rec noti_rec_type;

Line 1753: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

1749: l_item_key WF_ITEMS.item_key%TYPE;
1750: l_colon NUMBER;
1751: l_msgbody VARCHAR2(32000);
1752: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1753: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1754: l_quote_id VARCHAR2(200);
1755: l_asset_schedule_tbl kle_tbl_type;
1756: l_noti_rec noti_rec_type;
1757: i NUMBER := 1;