APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PON_AUC_BIZRULES

Line 93: , PON_AUC_BIZRULES pon_auc_bizrules

89: SELECT pon_auc_doctype_rules.VALIDITY_FLAG
90: INTO l_valid_flag
91: FROM
92: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
93: , PON_AUC_BIZRULES pon_auc_bizrules
94: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
95: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
96: AND pon_auc_bizrules.NAME = p_bizrule_name;
97:

Line 94: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

90: INTO l_valid_flag
91: FROM
92: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
93: , PON_AUC_BIZRULES pon_auc_bizrules
94: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
95: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
96: AND pon_auc_bizrules.NAME = p_bizrule_name;
97:
98: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

Line 96: AND pon_auc_bizrules.NAME = p_bizrule_name;

92: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
93: , PON_AUC_BIZRULES pon_auc_bizrules
94: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
95: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
96: AND pon_auc_bizrules.NAME = p_bizrule_name;
97:
98: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string(log_level => FND_LOG.level_statement,
100: module => g_module_prefix || 'is_valid_rule',

Line 127: , PON_AUC_BIZRULES pon_auc_bizrules

123: SELECT pon_auc_doctype_rules.REQUIRED_FLAG
124: INTO l_required_flag
125: FROM
126: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
127: , PON_AUC_BIZRULES pon_auc_bizrules
128: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
129: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
130: AND pon_auc_bizrules.NAME = p_bizrule_name;
131:

Line 128: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

124: INTO l_required_flag
125: FROM
126: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
127: , PON_AUC_BIZRULES pon_auc_bizrules
128: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
129: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
130: AND pon_auc_bizrules.NAME = p_bizrule_name;
131:
132: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

Line 130: AND pon_auc_bizrules.NAME = p_bizrule_name;

126: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
127: , PON_AUC_BIZRULES pon_auc_bizrules
128: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
129: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
130: AND pon_auc_bizrules.NAME = p_bizrule_name;
131:
132: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
133: FND_LOG.string(log_level => FND_LOG.level_statement,
134: module => g_module_prefix || 'is_required_rule',

Line 1611: , PON_AUC_BIZRULES pon_auc_bizrules

1607:
1608: SELECT
1609: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1610: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1611: , PON_AUC_BIZRULES pon_auc_bizrules
1612: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1613: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1614: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
1615:

Line 1612: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

1608: SELECT
1609: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1610: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1611: , PON_AUC_BIZRULES pon_auc_bizrules
1612: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1613: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1614: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
1615:
1616: -- maximum allowed clin number is 9999

Line 1614: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';

1610: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1611: , PON_AUC_BIZRULES pon_auc_bizrules
1612: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1613: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1614: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
1615:
1616: -- maximum allowed clin number is 9999
1617: -- so we wont accept more than 9999 clins
1618: IF(l_is_fed = 'Y') THEN