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

Line 4103: l_old_config_header_id okc_template_usages.config_header_id%TYPE;

4099:
4100: l_expert_articles_tbl OKC_TERMS_MULTIREC_GRP.article_id_tbl_type;
4101: l_validation_string VARCHAR2(100);
4102:
4103: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
4104: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
4105:
4106: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;
4107: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;

Line 4104: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;

4100: l_expert_articles_tbl OKC_TERMS_MULTIREC_GRP.article_id_tbl_type;
4101: l_validation_string VARCHAR2(100);
4102:
4103: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
4104: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
4105:
4106: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;
4107: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;
4108:

Line 4106: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;

4102:
4103: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
4104: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
4105:
4106: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;
4107: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;
4108:
4109: --
4110: -- Currsor to Select the Expert Articles

Line 4107: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;

4103: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
4104: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
4105:
4106: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;
4107: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;
4108:
4109: --
4110: -- Currsor to Select the Expert Articles
4111: -- that are in the latest Configuration

Line 4130: FROM okc_template_usages

4126: SELECT config_header_id,
4127: config_revision_number
4128: , orig_system_reference_code
4129: , orig_system_reference_id1
4130: FROM okc_template_usages
4131: WHERE document_type = p_document_type
4132: AND document_id = p_document_id ;
4133:
4134: BEGIN

Line 4241: UPDATE okc_template_usages

4237:
4238: --
4239: -- Update the template usage with new config_header_id and config_rev_nbr
4240: --
4241: UPDATE okc_template_usages
4242: SET config_header_id = p_config_header_id,
4243: config_revision_number = p_config_rev_nbr,
4244: valid_config_yn = 'Y',
4245: last_update_date = SYSDATE,

Line 4252: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

4248: WHERE document_type = p_document_type
4249: AND document_id = p_document_id ;
4250:
4251: /*
4252: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4253: p_api_version => 1,
4254: p_init_msg_list => FND_API.G_FALSE,
4255: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4256: p_commit => FND_API.G_FALSE,

Line 4415: l_old_config_header_id okc_template_usages.config_header_id%TYPE;

4411: IS
4412: l_api_name CONSTANT VARCHAR2(30) := 'update_config_id_rev_nbr';
4413: l_api_version CONSTANT NUMBER := 1;
4414:
4415: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
4416: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
4417:
4418: l_document_type okc_template_usages.orig_system_reference_code%TYPE;
4419: l_document_id okc_template_usages.orig_system_reference_id1%TYPE;

Line 4416: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;

4412: l_api_name CONSTANT VARCHAR2(30) := 'update_config_id_rev_nbr';
4413: l_api_version CONSTANT NUMBER := 1;
4414:
4415: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
4416: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
4417:
4418: l_document_type okc_template_usages.orig_system_reference_code%TYPE;
4419: l_document_id okc_template_usages.orig_system_reference_id1%TYPE;
4420:

Line 4418: l_document_type okc_template_usages.orig_system_reference_code%TYPE;

4414:
4415: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
4416: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
4417:
4418: l_document_type okc_template_usages.orig_system_reference_code%TYPE;
4419: l_document_id okc_template_usages.orig_system_reference_id1%TYPE;
4420:
4421: --
4422: -- Cursor to read the previous config_header_id and config_rev_nbr and delete the same

Line 4419: l_document_id okc_template_usages.orig_system_reference_id1%TYPE;

4415: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
4416: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
4417:
4418: l_document_type okc_template_usages.orig_system_reference_code%TYPE;
4419: l_document_id okc_template_usages.orig_system_reference_id1%TYPE;
4420:
4421: --
4422: -- Cursor to read the previous config_header_id and config_rev_nbr and delete the same
4423: --

Line 4429: FROM okc_template_usages

4425: SELECT config_header_id,
4426: config_revision_number
4427: ,orig_system_reference_code
4428: ,orig_system_reference_id1
4429: FROM okc_template_usages
4430: WHERE document_type = p_document_type
4431: AND document_id = p_document_id ;
4432:
4433:

Line 4511: UPDATE okc_template_usages

4507:
4508: --
4509: -- Update the template usage with new config_header_id and config_rev_nbr
4510: --
4511: UPDATE okc_template_usages
4512: SET config_header_id = p_config_header_id,
4513: config_revision_number = p_config_rev_nbr,
4514: valid_config_yn = 'Y',
4515: last_update_date = SYSDATE,

Line 4522: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

4518: WHERE document_type = p_document_type
4519: AND document_id = p_document_id ;
4520:
4521: /*
4522: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4523: p_api_version => 1,
4524: p_init_msg_list => FND_API.G_FALSE,
4525: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4526: p_commit => FND_API.G_FALSE,

Line 6810: FROM okc_template_usages

6806: l_has_responses VARCHAR2(1) := 'N';
6807:
6808: CURSOR csr_config_header_id IS
6809: SELECT config_header_id, nvl(contract_expert_finish_flag, 'N')
6810: FROM okc_template_usages
6811: WHERE document_id = p_document_id
6812: AND document_type = p_document_type
6813: AND template_id = p_template_id;
6814:

Line 7858: FROM okc_template_usages u,

7854: AND vers.article_version_id = b_article_version_id;
7855:
7856: CURSOR csr_xprt_scn_code IS
7857: SELECT NVL(t.xprt_scn_code,'UNASSIGNED')
7858: FROM okc_template_usages u,
7859: okc_terms_templates_all t
7860: WHERE u.template_id = t.template_id
7861: AND u.document_type = p_document_type
7862: AND u.document_id = p_document_id ;

Line 9125: FROM okc_template_usages u,

9121: u.config_revision_number,
9122: nvl(u.contract_expert_finish_flag, 'N'),
9123: t.template_id,
9124: t.contract_expert_enabled
9125: FROM okc_template_usages u,
9126: okc_terms_templates_all t
9127: WHERE t.template_id = u.template_id
9128: AND u.document_type= p_document_type
9129: AND u.document_id = p_document_id;

Line 10318: FROM okc_template_usages

10314: l_template_applied VARCHAR2(1);
10315:
10316: CURSOR csr_tmpl_applied_yn IS
10317: SELECT 'X'
10318: FROM okc_template_usages
10319: WHERE document_type = p_document_type
10320: AND document_id = p_document_id
10321: AND template_id = p_template_id;
10322:

Line 10463: FROM okc_template_usages u,

10459: SELECT u.config_header_id,
10460: u.config_revision_number,
10461: t.template_id,
10462: t.contract_expert_enabled
10463: FROM okc_template_usages u,
10464: okc_terms_templates_all t
10465: WHERE t.template_id = u.template_id
10466: AND u.document_type= p_document_type
10467: AND u.document_id = p_document_id

Line 10711: from cz_config_hdrs_v chv, okc_template_usages otu

10707: l_api_name CONSTANT VARCHAR2(30) := 'is_config_complete';
10708:
10709: CURSOR doc_config_details_csr IS
10710: select nvl(config_status, 0)
10711: from cz_config_hdrs_v chv, okc_template_usages otu
10712: where chv.config_hdr_id = otu.config_header_id
10713: and chv.config_rev_nbr = otu.config_revision_number
10714: and otu.document_type = p_document_type
10715: and otu.document_id = p_document_id;

Line 10761: from okc_template_usages u, okc_terms_templates_all a

10757: l_api_name CONSTANT VARCHAR2(30) := 'has_unanswered_questions';
10758:
10759: CURSOR doc_template_dtls_csr IS
10760: select u.template_id, a.contract_expert_enabled, u.contract_source_code, nvl(u.contract_expert_finish_flag, 'N')
10761: from okc_template_usages u, okc_terms_templates_all a
10762: where u.template_id = a.template_id
10763: and u.document_type = p_document_type
10764: and u.document_id = p_document_id;
10765:

Line 10769: l_contract_source okc_template_usages.contract_source_code%type;

10765:
10766: l_return_val VARCHAR2(1);
10767: l_template_id okc_terms_templates_all.template_id%type;
10768: l_expert_enabled okc_terms_templates_all.contract_expert_enabled%type;
10769: l_contract_source okc_template_usages.contract_source_code%type;
10770: l_has_questions VARCHAR2(1);
10771: l_ce_enabled VARCHAR2(50);
10772: l_ce_finish_flag VARCHAR2(1);
10773:

Line 10876: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;

10872:
10873: l_expert_articles_tbl OKC_TERMS_MULTIREC_GRP.article_id_tbl_type;
10874: l_validation_string VARCHAR2(100);
10875:
10876: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;
10877: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;
10878:
10879: -- Currsor to Select the Expert Articles
10880:

Line 10877: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;

10873: l_expert_articles_tbl OKC_TERMS_MULTIREC_GRP.article_id_tbl_type;
10874: l_validation_string VARCHAR2(100);
10875:
10876: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;
10877: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;
10878:
10879: -- Currsor to Select the Expert Articles
10880:
10881: CURSOR c_get_expert_articles IS

Line 10895: FROM okc_template_usages

10891: AND outcome.object_type = 'CLAUSE';
10892:
10893: CURSOR c_base_table_dtls IS
10894: SELECT orig_system_reference_code, orig_system_reference_id1
10895: FROM okc_template_usages
10896: WHERE document_type = p_document_type
10897: AND document_id = p_document_id;
10898:
10899: BEGIN

Line 10999: UPDATE okc_template_usages

10995: raise FND_API.G_EXC_UNEXPECTED_ERROR;
10996: END IF;
10997:
10998: --updating the contract expert finish status to Y.
10999: UPDATE okc_template_usages
11000: SET contract_expert_finish_flag = 'Y'
11001: WHERE document_id = p_document_id
11002: AND document_type = p_document_type;
11003: