DBA Data[Home] [Help]

APPS.OKL_SPLIT_CONTRACT_PVT dependencies on OKC_QA_CHECK_LISTS_V

Line 1331: FROM okc_qa_check_lists_v

1327: ln_qcl_id OKC_K_HEADERS_B.QCL_ID%TYPE;
1328: ln_chr_id OKC_K_HEADERS_B.ID%TYPE;
1329: CURSOR get_qcl_id_name(p_qcl_name VARCHAR2) IS
1330: SELECT id
1331: FROM okc_qa_check_lists_v
1332: WHERE name = p_qcl_name;
1333:
1334: CURSOR get_qcl_id_chr (p_chr_id NUMBER) IS
1335: SELECT NVL(qcl_id,0)

Line 4796: -- Then QCL_ID can be fetched from table okc_qa_check_lists_v using hard coded

4792: END IF;
4793: -- To run the QA checker we need to get the QCL_ID for the first contract
4794: -- since we assume for now the split contract will be split into Two contracts
4795: -- only.If the source contract do not have QCL_ID(which is never the case)
4796: -- Then QCL_ID can be fetched from table okc_qa_check_lists_v using hard coded
4797: -- name as 'OKL LA QA CHECK LIST'.
4798: x_return_status := get_qcl_id(p_chr_id => p_new1_contract_id,
4799: x_qcl_id => ln_qcl_id1);
4800:

Line 4822: -- Then QCL_ID can be fetched from table okc_qa_check_lists_v using hard coded

4818: END IF;
4819: -- To run the QA checker we need to get the QCL_ID for the first Second
4820: -- since we assume for now the split contract will be split into Two contracts
4821: -- only.If the source contract do not have QCL_ID(which is never the case)
4822: -- Then QCL_ID can be fetched from table okc_qa_check_lists_v using hard coded
4823: -- name as 'OKL LA QA CHECK LIST'.
4824: x_return_status := get_qcl_id(p_chr_id => p_new2_contract_id,
4825: x_qcl_id => ln_qcl_id2);
4826: