APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_AUC_DOCTYPE_RULES

Line 252: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed

248:
249: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auc_header_id;
250:
251: SELECT
252: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
253: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
254: , PON_AUC_BIZRULES pon_auc_bizrules
255: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
256: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

Line 253: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

249: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auc_header_id;
250:
251: SELECT
252: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
253: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
254: , PON_AUC_BIZRULES pon_auc_bizrules
255: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
256: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
257: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';

Line 255: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

251: SELECT
252: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
253: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
254: , PON_AUC_BIZRULES pon_auc_bizrules
255: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
256: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
257: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
258: EXCEPTION
259: WHEN No_Data_Found THEN

Line 256: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

252: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
253: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
254: , PON_AUC_BIZRULES pon_auc_bizrules
255: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
256: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
257: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
258: EXCEPTION
259: WHEN No_Data_Found THEN
260: l_is_fed := 'N';