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 3986: l_old_config_header_id okc_template_usages.config_header_id%TYPE;

3982:
3983: l_expert_articles_tbl OKC_TERMS_MULTIREC_GRP.article_id_tbl_type;
3984: l_validation_string VARCHAR2(100);
3985:
3986: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
3987: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
3988: --
3989: -- Currsor to Select the Expert Articles
3990: -- that are in the latest Configuration

Line 3987: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;

3983: l_expert_articles_tbl OKC_TERMS_MULTIREC_GRP.article_id_tbl_type;
3984: l_validation_string VARCHAR2(100);
3985:
3986: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
3987: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
3988: --
3989: -- Currsor to Select the Expert Articles
3990: -- that are in the latest Configuration
3991: --

Line 4007: FROM okc_template_usages

4003: --
4004: CURSOR csr_old_config_dtls IS
4005: SELECT config_header_id,
4006: config_revision_number
4007: FROM okc_template_usages
4008: WHERE document_type = p_document_type
4009: AND document_id = p_document_id ;
4010:
4011: BEGIN

Line 4084: UPDATE okc_template_usages

4080:
4081: --
4082: -- Update the template usage with new config_header_id and config_rev_nbr
4083: --
4084: UPDATE okc_template_usages
4085: SET config_header_id = p_config_header_id,
4086: config_revision_number = p_config_rev_nbr,
4087: valid_config_yn = 'Y',
4088: last_update_date = SYSDATE,

Line 4095: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

4091: WHERE document_type = p_document_type
4092: AND document_id = p_document_id ;
4093:
4094: /*
4095: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4096: p_api_version => 1,
4097: p_init_msg_list => FND_API.G_FALSE,
4098: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4099: p_commit => FND_API.G_FALSE,

Line 4257: l_old_config_header_id okc_template_usages.config_header_id%TYPE;

4253: IS
4254: l_api_name CONSTANT VARCHAR2(30) := 'update_config_id_rev_nbr';
4255: l_api_version CONSTANT NUMBER := 1;
4256:
4257: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
4258: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
4259:
4260: --
4261: -- Cursor to read the previous config_header_id and config_rev_nbr and delete the same

Line 4258: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;

4254: l_api_name CONSTANT VARCHAR2(30) := 'update_config_id_rev_nbr';
4255: l_api_version CONSTANT NUMBER := 1;
4256:
4257: l_old_config_header_id okc_template_usages.config_header_id%TYPE;
4258: l_old_config_revision_number okc_template_usages.config_revision_number%TYPE;
4259:
4260: --
4261: -- Cursor to read the previous config_header_id and config_rev_nbr and delete the same
4262: --

Line 4266: FROM okc_template_usages

4262: --
4263: CURSOR csr_old_config_dtls IS
4264: SELECT config_header_id,
4265: config_revision_number
4266: FROM okc_template_usages
4267: WHERE document_type = p_document_type
4268: AND document_id = p_document_id ;
4269:
4270:

Line 4313: UPDATE okc_template_usages

4309:
4310: --
4311: -- Update the template usage with new config_header_id and config_rev_nbr
4312: --
4313: UPDATE okc_template_usages
4314: SET config_header_id = p_config_header_id,
4315: config_revision_number = p_config_rev_nbr,
4316: valid_config_yn = 'Y',
4317: last_update_date = SYSDATE,

Line 4324: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

4320: WHERE document_type = p_document_type
4321: AND document_id = p_document_id ;
4322:
4323: /*
4324: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4325: p_api_version => 1,
4326: p_init_msg_list => FND_API.G_FALSE,
4327: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4328: p_commit => FND_API.G_FALSE,

Line 6610: FROM okc_template_usages

6606: l_ce_profile_option_enabled VARCHAR2(100);
6607:
6608: CURSOR csr_config_header_id IS
6609: SELECT config_header_id
6610: FROM okc_template_usages
6611: WHERE document_id = p_document_id
6612: AND document_type = p_document_type
6613: AND template_id = p_template_id;
6614:

Line 7573: FROM okc_template_usages u,

7569: AND vers.article_version_id = b_article_version_id;
7570:
7571: CURSOR csr_xprt_scn_code IS
7572: SELECT NVL(t.xprt_scn_code,'UNASSIGNED')
7573: FROM okc_template_usages u,
7574: okc_terms_templates_all t
7575: WHERE u.template_id = t.template_id
7576: AND u.document_type = p_document_type
7577: AND u.document_id = p_document_id ;

Line 8795: FROM okc_template_usages u,

8791: SELECT u.config_header_id,
8792: u.config_revision_number,
8793: t.template_id,
8794: t.contract_expert_enabled
8795: FROM okc_template_usages u,
8796: okc_terms_templates_all t
8797: WHERE t.template_id = u.template_id
8798: AND u.document_type= p_document_type
8799: AND u.document_id = p_document_id;

Line 9721: FROM okc_template_usages

9717: l_template_applied VARCHAR2(1);
9718:
9719: CURSOR csr_tmpl_applied_yn IS
9720: SELECT 'X'
9721: FROM okc_template_usages
9722: WHERE document_type = p_document_type
9723: AND document_id = p_document_id
9724: AND template_id = p_template_id;
9725:

Line 9866: FROM okc_template_usages u,

9862: SELECT u.config_header_id,
9863: u.config_revision_number,
9864: t.template_id,
9865: t.contract_expert_enabled
9866: FROM okc_template_usages u,
9867: okc_terms_templates_all t
9868: WHERE t.template_id = u.template_id
9869: AND u.document_type= p_document_type
9870: AND u.document_id = p_document_id

Line 10114: from cz_config_hdrs_v chv, okc_template_usages otu

10110: l_api_name CONSTANT VARCHAR2(30) := 'is_config_complete';
10111:
10112: CURSOR doc_config_details_csr IS
10113: select nvl(config_status, 0)
10114: from cz_config_hdrs_v chv, okc_template_usages otu
10115: where chv.config_hdr_id = otu.config_header_id
10116: and chv.config_rev_nbr = otu.config_revision_number
10117: and otu.document_type = p_document_type
10118: and otu.document_id = p_document_id;

Line 10164: from okc_template_usages u, okc_terms_templates_all a

10160: l_api_name CONSTANT VARCHAR2(30) := 'has_unanswered_questions';
10161:
10162: CURSOR doc_template_dtls_csr IS
10163: select u.template_id, a.contract_expert_enabled, u.contract_source_code
10164: from okc_template_usages u, okc_terms_templates_all a
10165: where u.template_id = a.template_id
10166: and u.document_type = p_document_type
10167: and u.document_id = p_document_id;
10168:

Line 10172: l_contract_source okc_template_usages.contract_source_code%type;

10168:
10169: l_return_val VARCHAR2(1);
10170: l_template_id okc_terms_templates_all.template_id%type;
10171: l_expert_enabled okc_terms_templates_all.contract_expert_enabled%type;
10172: l_contract_source okc_template_usages.contract_source_code%type;
10173: l_has_questions VARCHAR2(1);
10174: l_ce_enabled VARCHAR2(50);
10175:
10176: BEGIN