3:
4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_NEGOTIATION_PUBLISH_PVT.';
5:
6: TYPE DOCUMENT_TYPE_NAME IS TABLE OF PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE INDEX BY BINARY_INTEGER;
7: TYPE DOCUMENT_TYPE_REQUIRED_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.REQUIRED_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;
8: TYPE DOCUMENT_TYPE_VALIDITY_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.VALIDITY_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;
9:
10: g_document_type_required_rule DOCUMENT_TYPE_REQUIRED_RULE;
11: g_document_type_validity_rule DOCUMENT_TYPE_VALIDITY_RULE;
4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_NEGOTIATION_PUBLISH_PVT.';
5:
6: TYPE DOCUMENT_TYPE_NAME IS TABLE OF PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE INDEX BY BINARY_INTEGER;
7: TYPE DOCUMENT_TYPE_REQUIRED_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.REQUIRED_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;
8: TYPE DOCUMENT_TYPE_VALIDITY_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.VALIDITY_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;
9:
10: g_document_type_required_rule DOCUMENT_TYPE_REQUIRED_RULE;
11: g_document_type_validity_rule DOCUMENT_TYPE_VALIDITY_RULE;
12: g_document_type_names DOCUMENT_TYPE_NAME;
6250: l_doctype_rule_required,
6251: l_doctype_rule_validity
6252: FROM
6253: PON_AUC_BIZRULES BIZRULE,
6254: PON_AUC_DOCTYPE_RULES DOCTYPE_RULE
6255: WHERE
6256: BIZRULE.BIZRULE_ID = DOCTYPE_RULE.BIZRULE_ID AND
6257: DOCTYPE_RULE.DOCTYPE_ID = p_doctype_id;
6258: