APPS.OKS_WF_K_PROCESS_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 241: FROM okc_k_headers_all_b

237: l_item_key wf_items.item_key%TYPE :=NULL;
238:
239: CURSOR l_kdetails_csr(p_contract_id NUMBER) IS
240: SELECT contract_number,contract_number_modifier
241: FROM okc_k_headers_all_b
242: WHERE id = p_contract_id;
243:
244: l_kdetails_rec l_kdetails_csr%ROWTYPE;
245: l_rownotfound BOOLEAN := FALSE;

Line 428: FROM okc_k_headers_all_b

424: SELECT contract_number,contract_number_modifier,
425: to_char(OKS_EXTWAR_UTIL_PVT.round_currency_amt(estimated_amount,currency_code),
426: fnd_currency.get_format_mask(currency_code, 50)
427: ) estimated_amount, currency_code
428: FROM okc_k_headers_all_b
429: WHERE id = p_chr_id;
430:
431: CURSOR l_install_lang_csr IS
432: SELECT language_code

Line 1197: FROM okc_k_headers_all_b

1193: AND end_date IS NULL;
1194:
1195: CURSOR l_chrid_csr IS
1196: SELECT id
1197: FROM okc_k_headers_all_b
1198: WHERE contract_number = p_contract_number
1199: AND contract_number_modifier = p_contract_number_modifier;
1200:
1201: l_rownotfound BOOLEAN := FALSE;

Line 1409: okc_k_headers_all_b kh

1405: SELECT decode(kh.contract_number_modifier,NULL,kh.contract_number, kh.contract_number||' - '|| kh.contract_number_modifier)
1406: FROM okc_operation_lines ol,
1407: okc_operation_instances oi,
1408: okc_class_operations co,
1409: okc_k_headers_all_b kh
1410: WHERE co.cls_code = 'SERVICE'
1411: AND co.opn_code = 'RENEWAL'
1412: AND co.id = oi.cop_id
1413: AND ol.oie_id = oi.id

Line 1974: FROM okc_k_headers_all_b

1970: SELECT contract_number,contract_number_modifier,
1971: to_char(OKS_EXTWAR_UTIL_PVT.round_currency_amt(estimated_amount,currency_code),
1972: fnd_currency.get_format_mask(currency_code, 50)
1973: ) estimated_amount, currency_code
1974: FROM okc_k_headers_all_b
1975: WHERE id = p_chr_id;
1976:
1977: CURSOR l_install_lang_csr IS
1978: SELECT language_code

Line 2476: FROM okc_k_headers_all_b okch,

2472: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2473:
2474: CURSOR l_payment_csr(p_chr_id NUMBER) IS
2475: SELECT fndl.meaning
2476: FROM okc_k_headers_all_b okch,
2477: oks_k_headers_b oksh,
2478: fnd_lookups fndl
2479: WHERE okch.id = oksh.chr_id
2480: AND oksh.chr_id = p_chr_id

Line 2810: FROM OKC_K_HEADERS_ALL_B okck,

2806: l_api_name CONSTANT VARCHAR2(30) := 'customer_decline_quote';
2807:
2808: CURSOR c_old_sts (p_contract_id IN NUMBER) is
2809: SELECT STS_CODE
2810: FROM OKC_K_HEADERS_ALL_B okck,
2811: OKC_STATUSES_B sts
2812: WHERE sts.ste_code = 'ENTERED'
2813: AND id = p_contract_id
2814: AND sts.code = okck.sts_code;

Line 4412: FROM okc_k_headers_all_b

4408: l_api_name CONSTANT VARCHAR2(30) := 'launch_k_process_wf';
4409:
4410: CURSOR l_kdetails_csr(l_contract_id NUMBER) IS
4411: SELECT contract_number, contract_number_modifier
4412: FROM okc_k_headers_all_b
4413: WHERE id = l_contract_id;
4414:
4415: /*start bug8705707*/
4416: CURSOR wf_cur(p_wf_item_key varchar2) IS

Line 5604: SELECT 'Y' FROM okc_k_headers_all_b

5600: l_msg_count NUMBER;
5601: l_msg_data VARCHAR2(4000);
5602:
5603: CURSOR l_curr_conv_invalid_csr (p_chr_id NUMBER) IS
5604: SELECT 'Y' FROM okc_k_headers_all_b
5605: WHERE id =p_chr_id AND
5606: Upper(conversion_type) ='USER'
5607: AND conversion_rate_date NOT BETWEEN start_date AND end_date;
5608:

Line 6641: FROM okc_k_headers_all_b

6637:
6638: CURSOR l_qa_csr ( p_chr_id NUMBER ) IS
6639: SELECT contract_number, contract_number_modifier, qcl_id,
6640: authoring_org_id, inv_organization_id
6641: FROM okc_k_headers_all_b
6642: WHERE id = p_chr_id;
6643:
6644: l_contract_id NUMBER;
6645: l_qa_rec l_qa_csr%ROWTYPE;

Line 8857: OKC_K_HEADERS_ALL_B okck,

8853: okck.CONTRACT_NUMBER CONTRACT_NUMBER,
8854: nvl(okck.CONTRACT_NUMBER_MODIFIER, FND_API.G_MISS_CHAR) CONTRACT_NUMBER_MODIFIER,
8855: nvl(oksk.RENEWAL_STATUS, G_NEG_STS_DRAFT) RENEWAL_STATUS
8856: FROM OKS_K_HEADERS_B oksk,
8857: OKC_K_HEADERS_ALL_B okck,
8858: OKC_STATUSES_B sts
8859: WHERE oksk.chr_id = okck.id
8860: AND sts.ste_code = 'ENTERED'
8861: AND sts.code = okck.sts_code