APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUC_DOCTYPE_RULES

Line 1069: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed

1065:
1066: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = g_auction_header_id;
1067:
1068: SELECT
1069: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1070: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1071: , PON_AUC_BIZRULES pon_auc_bizrules
1072: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1073: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

Line 1070: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

1066: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = g_auction_header_id;
1067:
1068: SELECT
1069: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1070: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1071: , PON_AUC_BIZRULES pon_auc_bizrules
1072: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1073: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1074: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';

Line 1072: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

1068: SELECT
1069: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1070: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1071: , PON_AUC_BIZRULES pon_auc_bizrules
1072: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1073: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1074: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
1075: EXCEPTION
1076: WHEN No_Data_Found THEN

Line 1073: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

1069: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1070: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1071: , PON_AUC_BIZRULES pon_auc_bizrules
1072: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1073: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1074: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
1075: EXCEPTION
1076: WHEN No_Data_Found THEN
1077: l_is_fed := 'N';