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

Line 439: okc_template_usages tuse,

435: AND var.variable_code IN
436: (SELECT distinct rcon.object_code variable_code -- LHS of Condition from Template rule
437: FROM okc_xprt_rule_hdrs_all rhdr,
438: okc_xprt_rule_conditions rcon,
439: okc_template_usages tuse,
440: okc_xprt_template_rules trule
441: WHERE tuse.document_id = p_doc_id
442: AND tuse.document_type = p_doc_type
443: AND tuse.template_id = trule.template_id

Line 454: okc_template_usages tuse,

450: UNION
451: SELECT distinct rcon.object_value_code variable_code -- RHS of Condition from Template rule
452: FROM okc_xprt_rule_hdrs_all rhdr,
453: okc_xprt_rule_conditions rcon,
454: okc_template_usages tuse,
455: okc_xprt_template_rules trule
456: WHERE tuse.document_id = p_doc_id
457: AND tuse.document_type = p_doc_type
458: AND tuse.template_id = trule.template_id

Line 1411: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE;

1407: x_msg_count OUT NOCOPY NUMBER)
1408: IS
1409: l_api_name CONSTANT VARCHAR2(30) := 'insert_usages_row';
1410:
1411: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1412: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
1413: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
1414: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
1415: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line 1412: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;

1408: IS
1409: l_api_name CONSTANT VARCHAR2(30) := 'insert_usages_row';
1410:
1411: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1412: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
1413: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
1414: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
1415: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
1416: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;

Line 1413: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;

1409: l_api_name CONSTANT VARCHAR2(30) := 'insert_usages_row';
1410:
1411: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1412: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
1413: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
1414: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
1415: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
1416: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;
1417: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;

Line 1414: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;

1410:
1411: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1412: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
1413: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
1414: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
1415: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
1416: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;
1417: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;
1418:

Line 1415: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;

1411: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1412: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
1413: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
1414: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
1415: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
1416: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;
1417: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;
1418:
1419: l_temp_exists VARCHAR2(1) := 'N';

Line 1416: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;

1412: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
1413: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
1414: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
1415: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
1416: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;
1417: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;
1418:
1419: l_temp_exists VARCHAR2(1) := 'N';
1420:

Line 1417: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;

1413: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
1414: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
1415: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
1416: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;
1417: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;
1418:
1419: l_temp_exists VARCHAR2(1) := 'N';
1420:
1421: CURSOR l_get_temp_already_exists_csr IS

Line 1548: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE;

1544: WHERE DOCUMENT_TYPE = cp_document_type AND DOCUMENT_ID = cp_document_id;
1545:
1546: l_return_status VARCHAR2(1);
1547: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
1548: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1549:
1550: l_row_notfound BOOLEAN := FALSE;
1551: BEGIN
1552:

Line 1710: SELECT template_id FROM okc_template_usages

1706: l_api_name CONSTANT VARCHAR2(30) := 'check_dup_templates';
1707:
1708: CURSOR l_template_exists_csr IS
1709: SELECT 'Y' FROM dual WHERE p_template_id IN (
1710: SELECT template_id FROM okc_template_usages
1711: WHERE document_type = p_document_type AND document_id = p_document_id
1712: UNION ALL
1713: SELECT template_id FROM okc_mlp_template_usages
1714: WHERE document_type = p_document_type AND document_id = p_document_id);