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 (l_valid_flag = 'Y') 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 (l_valid_flag = 'Y') THEN
99: RETURN TRUE;

Line 112: l_required_flag pon_auc_doctype_rules.REQUIRED_FLAG%TYPE;

108: , p_bizrule_name VARCHAR2
109: )
110: RETURN BOOLEAN IS
111: --
112: l_required_flag pon_auc_doctype_rules.REQUIRED_FLAG%TYPE;
113: --
114: BEGIN
115: --
116: SELECT pon_auc_doctype_rules.REQUIRED_FLAG

Line 116: SELECT pon_auc_doctype_rules.REQUIRED_FLAG

112: l_required_flag pon_auc_doctype_rules.REQUIRED_FLAG%TYPE;
113: --
114: BEGIN
115: --
116: SELECT pon_auc_doctype_rules.REQUIRED_FLAG
117: INTO l_required_flag
118: FROM
119: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
120: , PON_AUC_BIZRULES pon_auc_bizrules

Line 119: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

115: --
116: SELECT pon_auc_doctype_rules.REQUIRED_FLAG
117: INTO l_required_flag
118: FROM
119: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
120: , PON_AUC_BIZRULES pon_auc_bizrules
121: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
122: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
123: AND pon_auc_bizrules.NAME = p_bizrule_name;

Line 121: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

117: INTO l_required_flag
118: FROM
119: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
120: , PON_AUC_BIZRULES pon_auc_bizrules
121: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
122: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
123: AND pon_auc_bizrules.NAME = p_bizrule_name;
124: --
125: IF (l_required_flag = 'Y') THEN

Line 122: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id

118: FROM
119: PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
120: , PON_AUC_BIZRULES pon_auc_bizrules
121: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
122: AND pon_auc_doctype_rules.DOCTYPE_ID = p_doctype_Id
123: AND pon_auc_bizrules.NAME = p_bizrule_name;
124: --
125: IF (l_required_flag = 'Y') THEN
126: RETURN TRUE;