APPS.PON_CLM_UTIL_PKG dependencies on PON_AUC_DOCTYPE_RULES

Line 11: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules,

7: l_rule_count number;
8: BEGIN
9: SELECT count(*)
10: INTO l_rule_count
11: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules,
12: PON_AUC_BIZRULES pon_auc_bizrules
13: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
14: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doc_type_id
15: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION'

Line 13: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

9: SELECT count(*)
10: INTO l_rule_count
11: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules,
12: PON_AUC_BIZRULES pon_auc_bizrules
13: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
14: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doc_type_id
15: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION'
16: AND pon_auc_doctype_rules.default_value = 'Y';
17:

Line 14: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doc_type_id

10: INTO l_rule_count
11: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules,
12: PON_AUC_BIZRULES pon_auc_bizrules
13: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
14: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doc_type_id
15: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION'
16: AND pon_auc_doctype_rules.default_value = 'Y';
17:
18: if l_rule_count > 0 then

Line 16: AND pon_auc_doctype_rules.default_value = 'Y';

12: PON_AUC_BIZRULES pon_auc_bizrules
13: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
14: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doc_type_id
15: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION'
16: AND pon_auc_doctype_rules.default_value = 'Y';
17:
18: if l_rule_count > 0 then
19: l_is_doc_federal := 1;
20: end if;

Line 189: return ' exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE

185: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'ProfileValue : '||ProfileValue);
186: END IF;
187:
188: IF ProfileValue <> 'N' THEN
189: return ' exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE
190: PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND
191: PAB.NAME = ''FEDERAL_NEGOTIATION'' AND PADR.DEFAULT_VALUE = ''Y'') ';
192: ELSE
193: return ' not exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE

Line 193: return ' not exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE

189: return ' exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE
190: PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND
191: PAB.NAME = ''FEDERAL_NEGOTIATION'' AND PADR.DEFAULT_VALUE = ''Y'') ';
192: ELSE
193: return ' not exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE
194: PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND
195: PAB.NAME = ''FEDERAL_NEGOTIATION'' AND PADR.DEFAULT_VALUE = ''Y'') ';
196: END IF;
197: ELSE