APPS.PON_VALIDATE_SHIPMENTS_INT dependencies on PON_AUC_DOCTYPE_RULES

Line 58: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed

54: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auction_header_id;
55:
56: BEGIN
57: SELECT
58: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
59: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules,
60: PON_AUC_BIZRULES pon_auc_bizrules
61: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
62: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

Line 59: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules,

55:
56: BEGIN
57: SELECT
58: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
59: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules,
60: PON_AUC_BIZRULES pon_auc_bizrules
61: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
62: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
63: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';

Line 61: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

57: SELECT
58: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
59: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules,
60: PON_AUC_BIZRULES pon_auc_bizrules
61: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
62: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
63: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
64:
65: EXCEPTION

Line 62: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

58: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
59: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules,
60: PON_AUC_BIZRULES pon_auc_bizrules
61: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
62: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
63: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
64:
65: EXCEPTION
66: WHEN OTHERS THEN