APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_AUC_DOCTYPE_RULES

Line 7576: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed

7572:
7573: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auc_header_id;
7574:
7575: SELECT
7576: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
7577: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
7578: , PON_AUC_BIZRULES pon_auc_bizrules
7579: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
7580: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

Line 7577: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

7573: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auc_header_id;
7574:
7575: SELECT
7576: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
7577: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
7578: , PON_AUC_BIZRULES pon_auc_bizrules
7579: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
7580: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
7581: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';

Line 7579: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

7575: SELECT
7576: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
7577: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
7578: , PON_AUC_BIZRULES pon_auc_bizrules
7579: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
7580: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
7581: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
7582: EXCEPTION
7583: WHEN No_Data_Found THEN

Line 7580: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

7576: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
7577: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
7578: , PON_AUC_BIZRULES pon_auc_bizrules
7579: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
7580: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
7581: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
7582: EXCEPTION
7583: WHEN No_Data_Found THEN
7584: g_is_fed := 'N';