APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PON_AUC_DOCTYPE_RULES

Line 85: l_valid_flag pon_auc_doctype_rules.VALIDITY_FLAG%TYPE;

81: , p_bizrule_name VARCHAR2
82: )
83: RETURN BOOLEAN IS
84: --
85: l_valid_flag pon_auc_doctype_rules.VALIDITY_FLAG%TYPE;
86: --
87: BEGIN
88: --
89: SELECT pon_auc_doctype_rules.VALIDITY_FLAG

Line 89: SELECT pon_auc_doctype_rules.VALIDITY_FLAG

85: l_valid_flag pon_auc_doctype_rules.VALIDITY_FLAG%TYPE;
86: --
87: BEGIN
88: --
89: SELECT pon_auc_doctype_rules.VALIDITY_FLAG
90: INTO l_valid_flag
91: FROM
92: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
93: , PON_AUC_BIZRULES pon_auc_bizrules

Line 92: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

88: --
89: SELECT pon_auc_doctype_rules.VALIDITY_FLAG
90: INTO l_valid_flag
91: FROM
92: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
93: , PON_AUC_BIZRULES pon_auc_bizrules
94: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
95: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
96: AND pon_auc_bizrules.NAME = p_bizrule_name;

Line 94: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

90: INTO l_valid_flag
91: FROM
92: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
93: , PON_AUC_BIZRULES pon_auc_bizrules
94: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
95: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
96: AND pon_auc_bizrules.NAME = p_bizrule_name;
97:
98: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

Line 95: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id

91: FROM
92: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
93: , PON_AUC_BIZRULES pon_auc_bizrules
94: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
95: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
96: AND pon_auc_bizrules.NAME = p_bizrule_name;
97:
98: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 119: l_required_flag pon_auc_doctype_rules.REQUIRED_FLAG%TYPE;

115: , p_bizrule_name VARCHAR2
116: )
117: RETURN BOOLEAN IS
118: --
119: l_required_flag pon_auc_doctype_rules.REQUIRED_FLAG%TYPE;
120: --
121: BEGIN
122: --
123: SELECT pon_auc_doctype_rules.REQUIRED_FLAG

Line 123: SELECT pon_auc_doctype_rules.REQUIRED_FLAG

119: l_required_flag pon_auc_doctype_rules.REQUIRED_FLAG%TYPE;
120: --
121: BEGIN
122: --
123: SELECT pon_auc_doctype_rules.REQUIRED_FLAG
124: INTO l_required_flag
125: FROM
126: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
127: , PON_AUC_BIZRULES pon_auc_bizrules

Line 126: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

122: --
123: SELECT pon_auc_doctype_rules.REQUIRED_FLAG
124: INTO l_required_flag
125: FROM
126: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
127: , PON_AUC_BIZRULES pon_auc_bizrules
128: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
129: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
130: AND pon_auc_bizrules.NAME = p_bizrule_name;

Line 128: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

124: INTO l_required_flag
125: FROM
126: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
127: , PON_AUC_BIZRULES pon_auc_bizrules
128: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
129: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
130: AND pon_auc_bizrules.NAME = p_bizrule_name;
131:
132: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

Line 129: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id

125: FROM
126: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
127: , PON_AUC_BIZRULES pon_auc_bizrules
128: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
129: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
130: AND pon_auc_bizrules.NAME = p_bizrule_name;
131:
132: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
133: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 1609: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed

1605:
1606: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = l_auction_header_id;
1607:
1608: SELECT
1609: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1610: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1611: , PON_AUC_BIZRULES pon_auc_bizrules
1612: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1613: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

Line 1610: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

1606: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = l_auction_header_id;
1607:
1608: SELECT
1609: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1610: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1611: , PON_AUC_BIZRULES pon_auc_bizrules
1612: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1613: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1614: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';

Line 1612: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

1608: SELECT
1609: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1610: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1611: , PON_AUC_BIZRULES pon_auc_bizrules
1612: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1613: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1614: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
1615:
1616: -- maximum allowed clin number is 9999

Line 1613: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

1609: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1610: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1611: , PON_AUC_BIZRULES pon_auc_bizrules
1612: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1613: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1614: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
1615:
1616: -- maximum allowed clin number is 9999
1617: -- so we wont accept more than 9999 clins