DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_AUC_DOCTYPE_RULES

Line 7: TYPE DOCUMENT_TYPE_REQUIRED_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.REQUIRED_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;

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;

Line 8: TYPE DOCUMENT_TYPE_VALIDITY_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.VALIDITY_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;

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;

Line 6254: PON_AUC_DOCTYPE_RULES DOCTYPE_RULE

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: