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_TMPL_APPROVAL_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 62: FROM okc_terms_templates_all tmpl,

58: tmpl.working_copy_flag,
59: tmpl.print_template_id,
60: tmpl.contract_expert_enabled,
61: fnd_lang.description language_desc
62: FROM okc_terms_templates_all tmpl,
63: fnd_languages_vl fnd_lang
64: WHERE tmpl.template_id = cp_template_id
65: AND ( tmpl.object_version_number = cp_object_version_number
66: OR cp_object_version_number IS NULL)

Line 217: FROM OKC_TERMS_TEMPLATES_ALL

213: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
214:
215: CURSOR lchk_csr (cp_template_id NUMBER) IS
216: SELECT object_version_number
217: FROM OKC_TERMS_TEMPLATES_ALL
218: WHERE TEMPLATE_ID = cp_template_id;
219:
220: l_return_status VARCHAR2(1);
221: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;

Line 221: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;

217: FROM OKC_TERMS_TEMPLATES_ALL
218: WHERE TEMPLATE_ID = cp_template_id;
219:
220: l_return_status VARCHAR2(1);
221: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
222: l_row_notfound BOOLEAN := FALSE;
223:
224: BEGIN
225:

Line 397: FROM okc_terms_templates_all

393: --modify cursor to fetch org_id also
394: CURSOR tmpl_exists_csr IS
395: SELECT org_id
396: -- SELECT '!'
397: FROM okc_terms_templates_all
398: WHERE template_id = p_template_id;
399:
400: CURSOR article_exists_cur IS
401: SELECT 1

Line 662: UPDATE okc_terms_templates_all

658: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'change_clause_status', get_error_string(l_art_validation_results));
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661:
662: UPDATE okc_terms_templates_all
663: SET status_code = 'PENDING_APPROVAL',
664: object_version_number = object_version_number + 1,
665: last_update_date = sysdate,
666: last_updated_by = fnd_global.user_id

Line 910: l_tmpl_id okc_terms_templates_all.template_id%TYPE;

906: IS
907:
908: pragma autonomous_transaction;
909:
910: l_tmpl_id okc_terms_templates_all.template_id%TYPE;
911: l_tmpl_status okc_terms_templates_all.status_code%TYPE;
912: l_tmpl_wc okc_terms_templates_all.working_copy_flag%TYPE;
913: l_tmpl_wf_seq_id NUMBER;
914: x_return_status VARCHAR2(1);

Line 911: l_tmpl_status okc_terms_templates_all.status_code%TYPE;

907:
908: pragma autonomous_transaction;
909:
910: l_tmpl_id okc_terms_templates_all.template_id%TYPE;
911: l_tmpl_status okc_terms_templates_all.status_code%TYPE;
912: l_tmpl_wc okc_terms_templates_all.working_copy_flag%TYPE;
913: l_tmpl_wf_seq_id NUMBER;
914: x_return_status VARCHAR2(1);
915: x_msg_count NUMBER;

Line 912: l_tmpl_wc okc_terms_templates_all.working_copy_flag%TYPE;

908: pragma autonomous_transaction;
909:
910: l_tmpl_id okc_terms_templates_all.template_id%TYPE;
911: l_tmpl_status okc_terms_templates_all.status_code%TYPE;
912: l_tmpl_wc okc_terms_templates_all.working_copy_flag%TYPE;
913: l_tmpl_wf_seq_id NUMBER;
914: x_return_status VARCHAR2(1);
915: x_msg_count NUMBER;
916: x_msg_data VARCHAR2(2000);

Line 1000: UPDATE okc_terms_templates_all

996: avalue => l_parent_template_id);
997:
998: ELSE
999:
1000: UPDATE okc_terms_templates_all
1001: SET status_code = 'APPROVED'
1002: WHERE template_id = l_tmpl_id;
1003:
1004: END IF;

Line 1013: UPDATE okc_terms_templates_all

1009: COMMIT;
1010: ELSE
1011: /*
1012: ROLLBACK;
1013: UPDATE okc_terms_templates_all
1014: SET status_code = l_tmpl_status
1015: WHERE template_id = l_tmpl_id;
1016: COMMIT;
1017: */

Line 1101: l_tmpl_id okc_terms_templates_all.template_id%TYPE;

1097: funcmode in varchar2,
1098: resultout out nocopy varchar2 )
1099: IS
1100:
1101: l_tmpl_id okc_terms_templates_all.template_id%TYPE;
1102: l_tmpl_status okc_terms_templates_all.status_code%TYPE;
1103: l_tmpl_wf_seq_id NUMBER;
1104: x_return_status VARCHAR2(1);
1105: x_msg_count NUMBER;

Line 1102: l_tmpl_status okc_terms_templates_all.status_code%TYPE;

1098: resultout out nocopy varchar2 )
1099: IS
1100:
1101: l_tmpl_id okc_terms_templates_all.template_id%TYPE;
1102: l_tmpl_status okc_terms_templates_all.status_code%TYPE;
1103: l_tmpl_wf_seq_id NUMBER;
1104: x_return_status VARCHAR2(1);
1105: x_msg_count NUMBER;
1106: x_msg_data VARCHAR2(2000);

Line 1144: UPDATE okc_terms_templates_all

1140: -- unexpected error
1141: RAISE clause_sts_exception_2;
1142: END IF;
1143:
1144: UPDATE okc_terms_templates_all
1145: --SET status_code = nvl(l_tmpl_status,decode(working_copy_flag,null,'DRAFT','REVISION'))
1146: --SET status_code = decode(working_copy_flag,null,'DRAFT','REVISION')
1147: SET status_code = 'REJECTED'
1148: WHERE template_id = l_tmpl_id;

Line 1211: okc_terms_templates_all tmpl

1207:
1208: CURSOR tmpl_approver_csr(cp_template_id IN NUMBER) IS
1209: SELECT decode(tmpl.intent,'S',org.org_information2,org.org_information6) org_information
1210: FROM hr_organization_information org,
1211: okc_terms_templates_all tmpl
1212: WHERE org.organization_id = tmpl.org_id
1213: AND org.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
1214: AND tmpl.template_id = cp_template_id;
1215:

Line 1366: FROM OKC_TERMS_TEMPLATES_ALL

1362: l_dummy_var VARCHAR2(1);
1363:
1364: CURSOR print_template_exits_csr(cp_tmpl_id IN NUMBER) IS
1365: SELECT 1
1366: FROM OKC_TERMS_TEMPLATES_ALL
1367: WHERE template_id = cp_tmpl_id
1368: AND print_template_id IS NOT NULL;
1369:
1370: BEGIN

Line 1487: SELECT org_id from OKC_TERMS_TEMPLATES_ALL

1483: l_current_org_id NUMBER;
1484: l_article_version_id_tbl OKC_ART_BLK_PVT.NUM_TBL_TYPE;
1485:
1486: CURSOR l_tmpl_csr (cp_template_id IN NUMBER) IS
1487: SELECT org_id from OKC_TERMS_TEMPLATES_ALL
1488: WHERE template_id = cp_template_id;
1489:
1490: CURSOR l_tmpl_clauses_csr (cp_template_id IN NUMBER, cp_wf_seq_id IN NUMBER) IS
1491: SELECT article_version_id from OKC_TMPL_DRAFT_CLAUSES

Line 2098: select template_id from okc_terms_templates_all

2094:
2095: UPDATE OKC_TMPL_DRAFT_CLAUSES
2096: SET selected_yn = 'Y'
2097: WHERE template_id = (
2098: select template_id from okc_terms_templates_all
2099: where template_id = p_template_id and status_code in ('DRAFT', 'REJECTED', 'REVISION'));
2100:
2101: -- Standard call to get message count and if count is 1, get message info.
2102: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );