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 232: FROM OKC_TERMS_TEMPLATES_ALL

228: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
229:
230: CURSOR lchk_csr (cp_template_id NUMBER) IS
231: SELECT object_version_number
232: FROM OKC_TERMS_TEMPLATES_ALL
233: WHERE TEMPLATE_ID = cp_template_id;
234:
235: l_return_status VARCHAR2(1);
236: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;

Line 236: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;

232: FROM OKC_TERMS_TEMPLATES_ALL
233: WHERE TEMPLATE_ID = cp_template_id;
234:
235: l_return_status VARCHAR2(1);
236: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
237: l_row_notfound BOOLEAN := FALSE;
238:
239: BEGIN
240:

Line 412: FROM okc_terms_templates_all

408: --modify cursor to fetch org_id also
409: CURSOR tmpl_exists_csr IS
410: SELECT org_id
411: -- SELECT '!'
412: FROM okc_terms_templates_all
413: WHERE template_id = p_template_id;
414:
415: CURSOR article_exists_cur IS
416: SELECT 1

Line 677: UPDATE okc_terms_templates_all

673: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'change_clause_status', get_error_string(l_art_validation_results));
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;
676:
677: UPDATE okc_terms_templates_all
678: SET status_code = 'PENDING_APPROVAL',
679: object_version_number = object_version_number + 1,
680: last_update_date = sysdate,
681: last_updated_by = fnd_global.user_id

Line 925: l_tmpl_id okc_terms_templates_all.template_id%TYPE;

921: IS
922:
923: pragma autonomous_transaction;
924:
925: l_tmpl_id okc_terms_templates_all.template_id%TYPE;
926: l_tmpl_status okc_terms_templates_all.status_code%TYPE;
927: l_tmpl_wc okc_terms_templates_all.working_copy_flag%TYPE;
928: l_tmpl_wf_seq_id NUMBER;
929: x_return_status VARCHAR2(1);

Line 926: l_tmpl_status okc_terms_templates_all.status_code%TYPE;

922:
923: pragma autonomous_transaction;
924:
925: l_tmpl_id okc_terms_templates_all.template_id%TYPE;
926: l_tmpl_status okc_terms_templates_all.status_code%TYPE;
927: l_tmpl_wc okc_terms_templates_all.working_copy_flag%TYPE;
928: l_tmpl_wf_seq_id NUMBER;
929: x_return_status VARCHAR2(1);
930: x_msg_count NUMBER;

Line 927: l_tmpl_wc okc_terms_templates_all.working_copy_flag%TYPE;

923: pragma autonomous_transaction;
924:
925: l_tmpl_id okc_terms_templates_all.template_id%TYPE;
926: l_tmpl_status okc_terms_templates_all.status_code%TYPE;
927: l_tmpl_wc okc_terms_templates_all.working_copy_flag%TYPE;
928: l_tmpl_wf_seq_id NUMBER;
929: x_return_status VARCHAR2(1);
930: x_msg_count NUMBER;
931: x_msg_data VARCHAR2(2000);

Line 1049: UPDATE okc_terms_templates_all

1045: avalue => l_parent_template_id);
1046:
1047: ELSE
1048:
1049: UPDATE okc_terms_templates_all
1050: SET status_code = 'APPROVED'
1051: WHERE template_id = l_tmpl_id;
1052:
1053: END IF;

Line 1062: UPDATE okc_terms_templates_all

1058: COMMIT;
1059: ELSE
1060: /*
1061: ROLLBACK;
1062: UPDATE okc_terms_templates_all
1063: SET status_code = l_tmpl_status
1064: WHERE template_id = l_tmpl_id;
1065: COMMIT;
1066: */

Line 1150: l_tmpl_id okc_terms_templates_all.template_id%TYPE;

1146: funcmode in varchar2,
1147: resultout out nocopy varchar2 )
1148: IS
1149:
1150: l_tmpl_id okc_terms_templates_all.template_id%TYPE;
1151: l_tmpl_status okc_terms_templates_all.status_code%TYPE;
1152: l_tmpl_wf_seq_id NUMBER;
1153: x_return_status VARCHAR2(1);
1154: x_msg_count NUMBER;

Line 1151: l_tmpl_status okc_terms_templates_all.status_code%TYPE;

1147: resultout out nocopy varchar2 )
1148: IS
1149:
1150: l_tmpl_id okc_terms_templates_all.template_id%TYPE;
1151: l_tmpl_status okc_terms_templates_all.status_code%TYPE;
1152: l_tmpl_wf_seq_id NUMBER;
1153: x_return_status VARCHAR2(1);
1154: x_msg_count NUMBER;
1155: x_msg_data VARCHAR2(2000);

Line 1193: UPDATE okc_terms_templates_all

1189: -- unexpected error
1190: RAISE clause_sts_exception_2;
1191: END IF;
1192:
1193: UPDATE okc_terms_templates_all
1194: --SET status_code = nvl(l_tmpl_status,decode(working_copy_flag,null,'DRAFT','REVISION'))
1195: --SET status_code = decode(working_copy_flag,null,'DRAFT','REVISION')
1196: SET status_code = 'REJECTED'
1197: WHERE template_id = l_tmpl_id;

Line 1260: okc_terms_templates_all tmpl

1256:
1257: CURSOR tmpl_approver_csr(cp_template_id IN NUMBER) IS
1258: SELECT decode(tmpl.intent,'S',org.org_information2,org.org_information6) org_information
1259: FROM hr_organization_information org,
1260: okc_terms_templates_all tmpl
1261: WHERE org.organization_id = tmpl.org_id
1262: AND org.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
1263: AND tmpl.template_id = cp_template_id;
1264:

Line 1415: FROM OKC_TERMS_TEMPLATES_ALL

1411: l_dummy_var VARCHAR2(1);
1412:
1413: CURSOR print_template_exits_csr(cp_tmpl_id IN NUMBER) IS
1414: SELECT 1
1415: FROM OKC_TERMS_TEMPLATES_ALL
1416: WHERE template_id = cp_tmpl_id
1417: AND print_template_id IS NOT NULL;
1418:
1419: BEGIN

Line 1536: SELECT org_id from OKC_TERMS_TEMPLATES_ALL

1532: l_current_org_id NUMBER;
1533: l_article_version_id_tbl OKC_ART_BLK_PVT.NUM_TBL_TYPE;
1534:
1535: CURSOR l_tmpl_csr (cp_template_id IN NUMBER) IS
1536: SELECT org_id from OKC_TERMS_TEMPLATES_ALL
1537: WHERE template_id = cp_template_id;
1538:
1539: CURSOR l_tmpl_clauses_csr (cp_template_id IN NUMBER, cp_wf_seq_id IN NUMBER) IS
1540: SELECT article_version_id from OKC_TMPL_DRAFT_CLAUSES

Line 2168: select template_id from okc_terms_templates_all

2164:
2165: UPDATE OKC_TMPL_DRAFT_CLAUSES
2166: SET selected_yn = 'Y'
2167: WHERE template_id = (
2168: select template_id from okc_terms_templates_all
2169: where template_id = p_template_id and status_code in ('DRAFT', 'REJECTED', 'REVISION'));
2170:
2171: -- Standard call to get message count and if count is 1, get message info.
2172: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );