87: --cursor to check for vendor program template
88: CURSOR l_chk_template_csr (p_chr_id IN Number) IS
89: SELECT chr.template_yn,
90: khr.template_type_code
91: FROM okc_k_headers_b chr,
92: okl_k_headers khr
93: WHERE chr.id = p_chr_id
94: AND chr.id = khr.id;
95:
226: b.template_yn template_yn,
227: --Bug# 4502754
228: c.template_type_code
229: from okc_statuses_v a,
230: okc_k_headers_b b,
231: okl_k_headers c
232: where a.code = b.sts_code
233: and b.id = c.id
234: and b.id = chrId;
235:
236: CURSOR chr_csr(p_chr_id OKL_K_HEADERS.KHR_ID%TYPE) IS
237: SELECT chr.SCS_CODE class,
238: chr.STS_CODE okc_status
239: FROM OKC_K_HEADERS_B chr,
240: OKL_K_HEADERS khr
241: WHERE chr.id = p_chr_id
242: AND chr.id = khr.id;
243:
246: ,pdt.name product_name
247: ,chr.sts_code okl_status
248: FROM okl_products_v pdt
249: ,okl_k_headers khr
250: ,okc_k_headers_b chr
251: WHERE 1=1
252: AND khr.id = p_contract_id
253: AND khr.pdt_id = pdt.id
254: AND khr.id = chr.id;
490: START_DATE,
491: END_DATE,
492: CURRENCY_CODE,
493: SCS_CODE
494: FROM OKC_K_HEADERS_B
495: WHERE ID = p_chr_id;
496:
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
493: SCS_CODE
494: FROM OKC_K_HEADERS_B
495: WHERE ID = p_chr_id;
496:
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
494: FROM OKC_K_HEADERS_B
495: WHERE ID = p_chr_id;
496:
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
502:
495: WHERE ID = p_chr_id;
496:
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
502:
503: --cursor to get contract line status
496:
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
502:
503: --cursor to get contract line status
504: CURSOR kle_sts_csr (p_chr_id IN NUMBER) is
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
502:
503: --cursor to get contract line status
504: CURSOR kle_sts_csr (p_chr_id IN NUMBER) is
505: SELECT STS_CODE,
831: START_DATE,
832: END_DATE,
833: CURRENCY_CODE,
834: SCS_CODE
835: FROM OKC_K_HEADERS_B
836: WHERE ID = p_chr_id;
837:
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
834: SCS_CODE
835: FROM OKC_K_HEADERS_B
836: WHERE ID = p_chr_id;
837:
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
835: FROM OKC_K_HEADERS_B
836: WHERE ID = p_chr_id;
837:
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
843:
836: WHERE ID = p_chr_id;
837:
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
843:
844: --cursor to get contract line status
837:
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
843:
844: --cursor to get contract line status
845: CURSOR kle_sts_csr (p_chr_id IN NUMBER) is
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
843:
844: --cursor to get contract line status
845: CURSOR kle_sts_csr (p_chr_id IN NUMBER) is
846: SELECT A.STS_CODE,
1050: CURRENCY_CODE,
1051: SCS_CODE,
1052: CONTRACT_NUMBER,
1053: TEMPLATE_YN --Bug#4728470
1054: FROM OKC_K_HEADERS_B
1055: WHERE ID = p_chr_id;
1056:
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1053: TEMPLATE_YN --Bug#4728470
1054: FROM OKC_K_HEADERS_B
1055: WHERE ID = p_chr_id;
1056:
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1054: FROM OKC_K_HEADERS_B
1055: WHERE ID = p_chr_id;
1056:
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1055: WHERE ID = p_chr_id;
1056:
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1063:
1056:
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1063:
1064: --Bug#4728470
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1063:
1064: --Bug#4728470
1065: l_khr_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1063:
1064: --Bug#4728470
1065: l_khr_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
1066:
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1063:
1064: --Bug#4728470
1065: l_khr_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
1066:
1067: --cusrsor to get OKC_STATUS check if status not in OKC frozen statuses
1068: CURSOR okc_sts_csr (p_okl_sts IN VARCHAR2) IS
1069: SELECT ste_code