APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_AUC_DOCTYPE_RULES

Line 2063: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed

2059: FROM pon_auction_headers_all
2060: WHERE auction_Header_id = p_auction_header_id;
2061:
2062: SELECT
2063: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
2064: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
2065: , PON_AUC_BIZRULES pon_auc_bizrules
2066: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
2067: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

Line 2064: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

2060: WHERE auction_Header_id = p_auction_header_id;
2061:
2062: SELECT
2063: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
2064: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
2065: , PON_AUC_BIZRULES pon_auc_bizrules
2066: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
2067: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
2068: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';

Line 2066: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

2062: SELECT
2063: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
2064: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
2065: , PON_AUC_BIZRULES pon_auc_bizrules
2066: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
2067: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
2068: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
2069: EXCEPTION
2070: WHEN OTHERS THEN

Line 2067: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

2063: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
2064: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
2065: , PON_AUC_BIZRULES pon_auc_bizrules
2066: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
2067: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
2068: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
2069: EXCEPTION
2070: WHEN OTHERS THEN
2071: l_is_fed := 'N';