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_K_ENTITY_LOCKS_GRP dependencies on OKC_TEMPLATE_USAGES

Line 117: l_from_table := 'OKC_TEMPLATE_USAGES';

113: l_entity_pk1_column := 'ID';
114: l_entity_pk1_n := TO_NUMBER (p_entity_pk1);
115: ELSIF p_entity_name = G_XPRT_ENTITY
116: THEN
117: l_from_table := 'OKC_TEMPLATE_USAGES';
118: l_entity_pk1_column := 'DOCUMENT_ID';
119: l_entity_pk1_n := TO_NUMBER (p_entity_pk1);
120: l_entity_pk2_column := 'DOCUMENT_TYPE';
121: l_entity_pk2_c := p_entity_pk2;

Line 1466: FROM okc_template_usages

1462: )
1463: IS
1464: SELECT config_header_id, config_revision_number, valid_config_yn,
1465: orig_system_reference_code, orig_system_reference_id1
1466: FROM okc_template_usages
1467: WHERE document_type = cp_document_type
1468: AND document_id = cp_document_id;
1469:
1470: TYPE l_clause_id_list IS TABLE OF NUMBER

Line 1474: l_old_config_header_id okc_template_usages.config_header_id%TYPE;

1470: TYPE l_clause_id_list IS TABLE OF NUMBER
1471: INDEX BY PLS_INTEGER;
1472:
1473: l_clause_id_tbl l_clause_id_list;
1474: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
1475: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
1476: l_old_valid_config_yn okc_template_usages.valid_config_yn%TYPE;
1477: l_src_document_type VARCHAR2 (30);
1478: l_src_document_id NUMBER;

Line 1475: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;

1471: INDEX BY PLS_INTEGER;
1472:
1473: l_clause_id_tbl l_clause_id_list;
1474: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
1475: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
1476: l_old_valid_config_yn okc_template_usages.valid_config_yn%TYPE;
1477: l_src_document_type VARCHAR2 (30);
1478: l_src_document_id NUMBER;
1479: l_src_config_header_id okc_template_usages.config_header_id%TYPE;

Line 1476: l_old_valid_config_yn okc_template_usages.valid_config_yn%TYPE;

1472:
1473: l_clause_id_tbl l_clause_id_list;
1474: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
1475: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
1476: l_old_valid_config_yn okc_template_usages.valid_config_yn%TYPE;
1477: l_src_document_type VARCHAR2 (30);
1478: l_src_document_id NUMBER;
1479: l_src_config_header_id okc_template_usages.config_header_id%TYPE;
1480: l_src_config_revision_number okc_template_usages.config_revision_number%TYPE;

Line 1479: l_src_config_header_id okc_template_usages.config_header_id%TYPE;

1475: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
1476: l_old_valid_config_yn okc_template_usages.valid_config_yn%TYPE;
1477: l_src_document_type VARCHAR2 (30);
1478: l_src_document_id NUMBER;
1479: l_src_config_header_id okc_template_usages.config_header_id%TYPE;
1480: l_src_config_revision_number okc_template_usages.config_revision_number%TYPE;
1481: l_src_valid_config_yn okc_template_usages.valid_config_yn%TYPE;
1482: l_src_src_document_type VARCHAR2 (30);
1483: l_src_src_document_id NUMBER;

Line 1480: l_src_config_revision_number okc_template_usages.config_revision_number%TYPE;

1476: l_old_valid_config_yn okc_template_usages.valid_config_yn%TYPE;
1477: l_src_document_type VARCHAR2 (30);
1478: l_src_document_id NUMBER;
1479: l_src_config_header_id okc_template_usages.config_header_id%TYPE;
1480: l_src_config_revision_number okc_template_usages.config_revision_number%TYPE;
1481: l_src_valid_config_yn okc_template_usages.valid_config_yn%TYPE;
1482: l_src_src_document_type VARCHAR2 (30);
1483: l_src_src_document_id NUMBER;
1484: l_new_config_header_id okc_template_usages.config_header_id%TYPE;

Line 1481: l_src_valid_config_yn okc_template_usages.valid_config_yn%TYPE;

1477: l_src_document_type VARCHAR2 (30);
1478: l_src_document_id NUMBER;
1479: l_src_config_header_id okc_template_usages.config_header_id%TYPE;
1480: l_src_config_revision_number okc_template_usages.config_revision_number%TYPE;
1481: l_src_valid_config_yn okc_template_usages.valid_config_yn%TYPE;
1482: l_src_src_document_type VARCHAR2 (30);
1483: l_src_src_document_id NUMBER;
1484: l_new_config_header_id okc_template_usages.config_header_id%TYPE;
1485: l_new_config_rev_nbr okc_template_usages.config_revision_number%TYPE;

Line 1484: l_new_config_header_id okc_template_usages.config_header_id%TYPE;

1480: l_src_config_revision_number okc_template_usages.config_revision_number%TYPE;
1481: l_src_valid_config_yn okc_template_usages.valid_config_yn%TYPE;
1482: l_src_src_document_type VARCHAR2 (30);
1483: l_src_src_document_id NUMBER;
1484: l_new_config_header_id okc_template_usages.config_header_id%TYPE;
1485: l_new_config_rev_nbr okc_template_usages.config_revision_number%TYPE;
1486:
1487: CURSOR cur_src_xprt_clauses (
1488: cp_document_type IN VARCHAR2,

Line 1485: l_new_config_rev_nbr okc_template_usages.config_revision_number%TYPE;

1481: l_src_valid_config_yn okc_template_usages.valid_config_yn%TYPE;
1482: l_src_src_document_type VARCHAR2 (30);
1483: l_src_src_document_id NUMBER;
1484: l_new_config_header_id okc_template_usages.config_header_id%TYPE;
1485: l_new_config_rev_nbr okc_template_usages.config_revision_number%TYPE;
1486:
1487: CURSOR cur_src_xprt_clauses (
1488: cp_document_type IN VARCHAR2,
1489: cp_document_id IN NUMBER

Line 1643: UPDATE okc_template_usages

1639: (SELECT okc_xprt_doc_ques_response_s.NEXTVAL, p_target_document_id, p_target_document_type, question_id, response
1640: FROM okc_xprt_doc_ques_response WHERE doc_id = l_src_document_id AND doc_type = l_src_document_type );
1641:
1642: --updating the finish flag to the previous state of the base document
1643: UPDATE okc_template_usages
1644: SET contract_expert_finish_flag = (SELECT contract_expert_finish_flag FROM okc_template_usages WHERE document_type = l_src_document_type AND document_id = l_src_document_id)
1645: WHERE document_type = p_target_document_type
1646: AND document_id = p_target_document_id;
1647:

Line 1644: SET contract_expert_finish_flag = (SELECT contract_expert_finish_flag FROM okc_template_usages WHERE document_type = l_src_document_type AND document_id = l_src_document_id)

1640: FROM okc_xprt_doc_ques_response WHERE doc_id = l_src_document_id AND doc_type = l_src_document_type );
1641:
1642: --updating the finish flag to the previous state of the base document
1643: UPDATE okc_template_usages
1644: SET contract_expert_finish_flag = (SELECT contract_expert_finish_flag FROM okc_template_usages WHERE document_type = l_src_document_type AND document_id = l_src_document_id)
1645: WHERE document_type = p_target_document_type
1646: AND document_id = p_target_document_id;
1647:
1648: ELSE ---configurator

Line 1698: UPDATE okc_template_usages

1694: THEN
1695: RAISE fnd_api.g_exc_error;
1696: END IF;
1697:
1698: UPDATE okc_template_usages
1699: SET config_header_id = l_new_config_header_id,
1700: config_revision_number = l_new_config_rev_nbr,
1701: valid_config_yn = l_src_valid_config_yn
1702: WHERE document_type = p_target_document_type

Line 2708: FROM okc_template_usages

2704:
2705: CURSOR cur_get_details_from_usage
2706: IS
2707: SELECT orig_system_reference_code, To_Char(orig_system_reference_id1)
2708: FROM okc_template_usages
2709: WHERE document_type = p_doc_type
2710: AND document_id= p_doc_id;
2711:
2712: CURSOR cur_get_details_from_sections

Line 2866: FROM okc_template_usages

2862:
2863: CURSOR cur_src_doc_details
2864: IS
2865: SELECT orig_system_reference_code, orig_system_reference_id1
2866: FROM okc_template_usages
2867: WHERE document_type = p_tgt_document_type
2868: AND document_id = p_tgt_document_id;
2869:
2870: CURSOR cur_src_del_details (cp_del_id NUMBER)

Line 2979: FROM okc_template_usages

2975:
2976: CURSOR cur_src_doc_details
2977: IS
2978: SELECT orig_system_reference_code, orig_system_reference_id1
2979: FROM okc_template_usages
2980: WHERE document_type = p_tgt_document_type
2981: AND document_id = p_tgt_document_id;
2982:
2983: BEGIN