APPS.OKC_TERMS_MULTIREC_GRP dependencies on OKC_TERMS_TEMPLATES_ALL

Line 1060: okc_terms_templates_all t

1056: CURSOR csr_mandatory_flag IS
1057: SELECT NVL(t.xprt_clause_mandatory_flag,'N'),
1058: NVL(t.xprt_scn_code,'UNASSIGNED')
1059: FROM okc_template_usages u,
1060: okc_terms_templates_all t
1061: WHERE u.template_id = t.template_id
1062: AND u.document_type = p_doc_type
1063: AND u.document_id = p_doc_id ;
1064:

Line 1066: l_xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE;

1062: AND u.document_type = p_doc_type
1063: AND u.document_id = p_doc_id ;
1064:
1065:
1066: l_xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE;
1067: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;
1068:
1069: l_article_rec l_get_active_article_csr%ROWTYPE;
1070: l_max_article_rec l_get_max_article_csr%ROWTYPE;

Line 1067: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;

1063: AND u.document_id = p_doc_id ;
1064:
1065:
1066: l_xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE;
1067: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;
1068:
1069: l_article_rec l_get_active_article_csr%ROWTYPE;
1070: l_max_article_rec l_get_max_article_csr%ROWTYPE;
1071: l_prov_allowed VARCHAR2(1) ;

Line 1448: Added new column xprt_scn_code to okc_terms_templates_all

1444: -- article is not provison or provision is allowed on document
1445: -- since we are inserting one or more articles, renumber
1446: -- we will renumber ONLY if article is Not added to unassigned section
1447: /*
1448: Added new column xprt_scn_code to okc_terms_templates_all
1449: If the article does not have a default scn_code in library then
1450: we will put the article in xprt_scn_code
1451: We always have to run renumber
1452: */