DBA Data[Home] [Help]

APPS.OKC_XPRT_QA_PVT dependencies on OKC_QA_ERRORS_T_S

Line 2546: SELECT OKC_QA_ERRORS_T_S.NEXTVAL

2542: x_msg_data OUT NOCOPY VARCHAR2
2543: ) IS
2544:
2545: CURSOR l_seq_csr IS
2546: SELECT OKC_QA_ERRORS_T_S.NEXTVAL
2547: FROM DUAL;
2548:
2549: --Added for Bug 4725397
2550: CURSOR c_get_rule_org_id (p_rule_id NUMBER) IS

Line 2556: l_sequence_id okc_qa_errors_t.sequence_id%TYPE;

2552: FROM okc_xprt_rule_hdrs_all rules
2553: WHERE rules.rule_id = p_rule_id;
2554:
2555: l_api_name CONSTANT VARCHAR2(30) := 'qa_rules';
2556: l_sequence_id okc_qa_errors_t.sequence_id%TYPE;
2557: l_qa_status VARCHAR2(1);
2558: l_rule_qa_status VARCHAR2(1);
2559: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2560: l_rule_org_id NUMBER;