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.OKC_XPRT_RULES_ENGINE_PVT dependencies on OKC_XPRT_DOC_QUES_RESPONSE_H

Line 1667: --copying the responses to okc_xprt_doc_ques_response_h

1663:
1664: p_doc_id := doc_id;
1665: p_doc_type := doc_type;
1666:
1667: --copying the responses to okc_xprt_doc_ques_response_h
1668: INSERT INTO okc_xprt_doc_ques_response_h (doc_question_response_id, doc_id, doc_type, major_version, question_id, response)
1669: (SELECT doc_question_response_id, p_doc_id, p_doc_type, p_major_version, question_id, response FROM okc_xprt_doc_ques_response
1670: WHERE doc_id = p_doc_id AND doc_type = p_doc_type);
1671:

Line 1668: INSERT INTO okc_xprt_doc_ques_response_h (doc_question_response_id, doc_id, doc_type, major_version, question_id, response)

1664: p_doc_id := doc_id;
1665: p_doc_type := doc_type;
1666:
1667: --copying the responses to okc_xprt_doc_ques_response_h
1668: INSERT INTO okc_xprt_doc_ques_response_h (doc_question_response_id, doc_id, doc_type, major_version, question_id, response)
1669: (SELECT doc_question_response_id, p_doc_id, p_doc_type, p_major_version, question_id, response FROM okc_xprt_doc_ques_response
1670: WHERE doc_id = p_doc_id AND doc_type = p_doc_type);
1671:
1672: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1704: --copying the responses to okc_xprt_doc_ques_response from okc_xprt_doc_ques_response_h table

1700:
1701: p_doc_id := doc_id;
1702: p_doc_type := doc_type;
1703:
1704: --copying the responses to okc_xprt_doc_ques_response from okc_xprt_doc_ques_response_h table
1705: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id, doc_id, doc_type, question_id, response)
1706: (SELECT doc_question_response_id, p_doc_id, p_doc_type, question_id, response FROM okc_xprt_doc_ques_response_h
1707: WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND major_version = p_major_version);
1708:

Line 1706: (SELECT doc_question_response_id, p_doc_id, p_doc_type, question_id, response FROM okc_xprt_doc_ques_response_h

1702: p_doc_type := doc_type;
1703:
1704: --copying the responses to okc_xprt_doc_ques_response from okc_xprt_doc_ques_response_h table
1705: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id, doc_id, doc_type, question_id, response)
1706: (SELECT doc_question_response_id, p_doc_id, p_doc_type, question_id, response FROM okc_xprt_doc_ques_response_h
1707: WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND major_version = p_major_version);
1708:
1709: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1710: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, '110: no. of rows copied : ' || sql%rowcount);

Line 1741: --deleting the responses from okc_xprt_doc_ques_response_h history table as the revision is deleted.

1737:
1738: p_doc_id := doc_id;
1739: p_doc_type := doc_type;
1740:
1741: --deleting the responses from okc_xprt_doc_ques_response_h history table as the revision is deleted.
1742: DELETE FROM okc_xprt_doc_ques_response_h
1743: WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND major_version = p_major_version;
1744:
1745: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1742: DELETE FROM okc_xprt_doc_ques_response_h

1738: p_doc_id := doc_id;
1739: p_doc_type := doc_type;
1740:
1741: --deleting the responses from okc_xprt_doc_ques_response_h history table as the revision is deleted.
1742: DELETE FROM okc_xprt_doc_ques_response_h
1743: WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND major_version = p_major_version;
1744:
1745: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1746: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, '110: no. of rows deleted : ' || sql%rowcount);