APPS.OKC_XPRT_TMPL_RULE_ASSNS_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 42: FROM okc_terms_templates_all

38: ) IS
39:
40: CURSOR csr_template_org(p_template_id IN NUMBER) IS
41: SELECT org_id
42: FROM okc_terms_templates_all
43: WHERE template_id = p_template_id;
44:
45: -- get all rules on source template that are Not Inactive
46: CURSOR csr_template_rules IS

Line 70: l_source_template_org_id okc_terms_templates_all.org_id%TYPE;

66: WHERE template_id = p_source_template_id;
67:
68: l_api_version CONSTANT NUMBER := 1;
69: l_api_name CONSTANT VARCHAR2(30) := 'copy_template_rule_assns';
70: l_source_template_org_id okc_terms_templates_all.org_id%TYPE;
71: l_target_template_org_id okc_terms_templates_all.org_id%TYPE;
72:
73:
74: TYPE ruleIdList IS TABLE OF okc_xprt_template_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;

Line 71: l_target_template_org_id okc_terms_templates_all.org_id%TYPE;

67:
68: l_api_version CONSTANT NUMBER := 1;
69: l_api_name CONSTANT VARCHAR2(30) := 'copy_template_rule_assns';
70: l_source_template_org_id okc_terms_templates_all.org_id%TYPE;
71: l_target_template_org_id okc_terms_templates_all.org_id%TYPE;
72:
73:
74: TYPE ruleIdList IS TABLE OF okc_xprt_template_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
75: TYPE questionIdList IS TABLE OF okc_xprt_question_orders.question_id%TYPE INDEX BY BINARY_INTEGER;

Line 405: FROM okc_terms_templates_all

401: l_api_version CONSTANT NUMBER := 1;
402:
403: CURSOR csr_xprt_enabled IS
404: SELECT NVL(contract_expert_enabled,'N')
405: FROM okc_terms_templates_all
406: WHERE template_id = p_parent_template_id;
407:
408: l_xprt_enabled_flag okc_terms_templates_all.contract_expert_enabled%TYPE;
409:

Line 408: l_xprt_enabled_flag okc_terms_templates_all.contract_expert_enabled%TYPE;

404: SELECT NVL(contract_expert_enabled,'N')
405: FROM okc_terms_templates_all
406: WHERE template_id = p_parent_template_id;
407:
408: l_xprt_enabled_flag okc_terms_templates_all.contract_expert_enabled%TYPE;
409:
410:
411: BEGIN
412: