APPS.OKC_TERMS_MULTIREC_GRP dependencies on OKC_TERMS_TEMPLATES_ALL

Line 1063: okc_terms_templates_all t

1059: CURSOR csr_mandatory_flag IS
1060: SELECT NVL(t.xprt_clause_mandatory_flag,'N'),
1061: NVL(t.xprt_scn_code,'UNASSIGNED')
1062: FROM okc_template_usages u,
1063: okc_terms_templates_all t
1064: WHERE u.template_id = t.template_id
1065: AND u.document_type = p_doc_type
1066: AND u.document_id = p_doc_id ;
1067: --CLM changes start

Line 1077: l_xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE;

1073: l_art_var_exists VARCHAR2(1) := 'N';
1074: --CLM changes end
1075:
1076:
1077: l_xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE;
1078: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;
1079:
1080: l_article_rec l_get_active_article_csr%ROWTYPE;
1081: l_max_article_rec l_get_max_article_csr%ROWTYPE;

Line 1078: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;

1074: --CLM changes end
1075:
1076:
1077: l_xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE;
1078: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;
1079:
1080: l_article_rec l_get_active_article_csr%ROWTYPE;
1081: l_max_article_rec l_get_max_article_csr%ROWTYPE;
1082: l_prov_allowed VARCHAR2(1) ;

Line 1472: Added new column xprt_scn_code to okc_terms_templates_all

1468: -- article is not provison or provision is allowed on document
1469: -- since we are inserting one or more articles, renumber
1470: -- we will renumber ONLY if article is Not added to unassigned section
1471: /*
1472: Added new column xprt_scn_code to okc_terms_templates_all
1473: If the article does not have a default scn_code in library then
1474: we will put the article in xprt_scn_code
1475: We always have to run renumber
1476: */