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_TERMS_COPY_PVT dependencies on OKC_XPRT_DOC_QUES_RESPONSE

Line 3065: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'550: Copying question and response to okc_xprt_doc_ques_response.');

3061: ELSIF l_cntrcts_ruls_eng_exists = 'Y' THEN
3062:
3063: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3064: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'550: Contracts rules engine is enabled.');
3065: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'550: Copying question and response to okc_xprt_doc_ques_response.');
3066: END IF;
3067:
3068: BEGIN
3069: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id,doc_id,doc_type,question_id,response)

Line 3069: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id,doc_id,doc_type,question_id,response)

3065: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'550: Copying question and response to okc_xprt_doc_ques_response.');
3066: END IF;
3067:
3068: BEGIN
3069: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id,doc_id,doc_type,question_id,response)
3070: (SELECT okc_xprt_doc_ques_response_s.NEXTVAL,p_target_doc_id,p_target_doc_type,question_id,response
3071: FROM okc_xprt_doc_ques_response WHERE doc_id = p_source_doc_id AND doc_type = p_source_doc_type );
3072:
3073: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3070: (SELECT okc_xprt_doc_ques_response_s.NEXTVAL,p_target_doc_id,p_target_doc_type,question_id,response

3066: END IF;
3067:
3068: BEGIN
3069: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id,doc_id,doc_type,question_id,response)
3070: (SELECT okc_xprt_doc_ques_response_s.NEXTVAL,p_target_doc_id,p_target_doc_type,question_id,response
3071: FROM okc_xprt_doc_ques_response WHERE doc_id = p_source_doc_id AND doc_type = p_source_doc_type );
3072:
3073: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3074: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'550: Succesfull in copying values to

Line 3071: FROM okc_xprt_doc_ques_response WHERE doc_id = p_source_doc_id AND doc_type = p_source_doc_type );

3067:
3068: BEGIN
3069: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id,doc_id,doc_type,question_id,response)
3070: (SELECT okc_xprt_doc_ques_response_s.NEXTVAL,p_target_doc_id,p_target_doc_type,question_id,response
3071: FROM okc_xprt_doc_ques_response WHERE doc_id = p_source_doc_id AND doc_type = p_source_doc_type );
3072:
3073: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3074: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'550: Succesfull in copying values to
3075: okc_xprt_doc_ques_response.');

Line 3075: okc_xprt_doc_ques_response.');

3071: FROM okc_xprt_doc_ques_response WHERE doc_id = p_source_doc_id AND doc_type = p_source_doc_type );
3072:
3073: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3074: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'550: Succesfull in copying values to
3075: okc_xprt_doc_ques_response.');
3076: END IF;
3077:
3078: EXCEPTION
3079: WHEN OTHERS THEN

Line 3082: okc_xprt_doc_ques_response.');

3078: EXCEPTION
3079: WHEN OTHERS THEN
3080: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3081: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'550: Failed copying values to
3082: okc_xprt_doc_ques_response.');
3083: END IF;
3084: END;
3085: -- end of contracts rules engine copy
3086:

Line 3420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'405: Deleting the responses from okc_xprt_doc_ques_response table');

3416: WHERE document_type = p_target_doc_type
3417: AND document_id = p_target_doc_id;
3418:
3419: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'405: Deleting the responses from okc_xprt_doc_ques_response table');
3421: END IF;
3422:
3423: --deleting responses when u change the template
3424: DELETE FROM okc_xprt_doc_ques_response

Line 3424: DELETE FROM okc_xprt_doc_ques_response

3420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'405: Deleting the responses from okc_xprt_doc_ques_response table');
3421: END IF;
3422:
3423: --deleting responses when u change the template
3424: DELETE FROM okc_xprt_doc_ques_response
3425: WHERE doc_id = p_target_doc_id
3426: AND doc_type = p_target_doc_type;
3427:
3428: ELSE --configurator rule engine