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

Line 105: FROM okc_terms_templates_all,

101: DECODE(parent_template_id, NULL, template_id, parent_template_id),
102: intent,
103: name,
104: org_id
105: FROM okc_terms_templates_all,
106: hr_operating_units
107: WHERE organization_id = org_id
108: AND template_id = p_template_id ;
109:

Line 118: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;

114: l_template_folder_id NUMBER :=NULL;
115: l_folder_desc VARCHAR2(255);
116: l_import_status VARCHAR2(10);
117:
118: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
119: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
120: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;
121: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
122: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;

Line 119: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;

115: l_folder_desc VARCHAR2(255);
116: l_import_status VARCHAR2(10);
117:
118: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
119: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
120: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;
121: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
122: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
123: l_folder_name cz_rp_entries.name%TYPE;

Line 120: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;

116: l_import_status VARCHAR2(10);
117:
118: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
119: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
120: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;
121: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
122: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
123: l_folder_name cz_rp_entries.name%TYPE;
124:

Line 121: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;

117:
118: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
119: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
120: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;
121: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
122: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
123: l_folder_name cz_rp_entries.name%TYPE;
124:
125: BEGIN

Line 178: UPDATE okc_terms_templates_all

174: fnd_file.put_line(FND_FILE.LOG,' ');
175: fnd_file.put_line(FND_FILE.LOG,'Template Name : '||l_template_name);
176:
177: -- Update the xprt_request_id for the current template
178: UPDATE okc_terms_templates_all
179: SET xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID,
180: last_update_login = FND_GLOBAL.LOGIN_ID,
181: last_update_date = SYSDATE,
182: last_updated_by = FND_GLOBAL.USER_ID

Line 286: FROM okc_terms_templates_all t,

282: -- Templates to be rebuilt for Publishing or Disabling Rules
283: CURSOR csr_local_rules_templates IS
284: -- Templates on Local Rules
285: SELECT DISTINCT to_char(r.template_id)
286: FROM okc_terms_templates_all t,
287: okc_xprt_template_rules r,
288: okc_xprt_rule_hdrs_all h
289: WHERE r.template_id = t.template_id
290: AND r.rule_id = h.rule_id

Line 298: FROM okc_terms_templates_all t

294:
295: CURSOR csr_org_rules_templates(p_org_id IN NUMBER) IS
296: -- Org Wide Rule Templates
297: SELECT t.template_id
298: FROM okc_terms_templates_all t
299: WHERE t.org_id = p_org_id
300: AND t.intent IN (SELECT DISTINCT intent
301: FROM okc_xprt_rule_hdrs_all
302: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

Line 321: l_template_id okc_terms_templates_all.template_id%TYPE;

317: FROM okc_xprt_rule_hdrs_all
318: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
319:
320: l_api_name CONSTANT VARCHAR2(30) := 'sync_templates';
321: l_template_id okc_terms_templates_all.template_id%TYPE;
322: l_org_rules_yn okc_xprt_rule_hdrs_all.org_wide_flag%TYPE := NULL;
323: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
324:
325: BEGIN

Line 1453: FROM okc_terms_templates_all

1449: last_update_date = SYSDATE,
1450: last_update_login = FND_GLOBAL.LOGIN_ID
1451: WHERE question_rule_status = 'PENDINGPUB'
1452: AND template_id IN ( SELECT template_id
1453: FROM okc_terms_templates_all
1454: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
1455: );
1456:
1457: -- Delete from okc_xprt_template_rules

Line 1461: FROM okc_terms_templates_all

1457: -- Delete from okc_xprt_template_rules
1458: DELETE FROM okc_xprt_template_rules
1459: WHERE NVL(deleted_flag,'N') = 'Y'
1460: AND template_id IN ( SELECT template_id
1461: FROM okc_terms_templates_all
1462: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
1463: );
1464:
1465: -- Update published_flag in okc_xprt_template_rules

Line 1469: FROM okc_terms_templates_all

1465: -- Update published_flag in okc_xprt_template_rules
1466: UPDATE okc_xprt_template_rules
1467: SET published_flag = 'Y'
1468: WHERE template_id IN ( SELECT template_id
1469: FROM okc_terms_templates_all
1470: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
1471: );
1472: -- Update Rule status
1473: OPEN csr_rules;

Line 2351: FROM okc_terms_templates_all t

2347: ) IS
2348:
2349: CURSOR csr_tmpl_dtls IS
2350: SELECT 'x'
2351: FROM okc_terms_templates_all t
2352: WHERE t.org_id = p_org_id
2353: AND t.intent = p_intent
2354: AND t.template_id = NVL(p_template_id, template_id);
2355: