APPS.OE_EXTERNAL_CREDIT_PVT dependencies on OE_CREDIT_CHECK_RULES

Line 197: oe_credit_check_rules.name%TYPE := NULL;

193: )
194: IS
195: l_credit_check_rule_id NUMBER := NULL;
196: l_credit_check_rule_name
197: oe_credit_check_rules.name%TYPE := NULL;
198: l_credit_check_level_code
199: oe_credit_check_rules.credit_check_level_code%TYPE := NULL;
200: l_check_item_categories_flag
201: oe_credit_check_rules.check_item_categories_flag%TYPE := NULL;

Line 199: oe_credit_check_rules.credit_check_level_code%TYPE := NULL;

195: l_credit_check_rule_id NUMBER := NULL;
196: l_credit_check_rule_name
197: oe_credit_check_rules.name%TYPE := NULL;
198: l_credit_check_level_code
199: oe_credit_check_rules.credit_check_level_code%TYPE := NULL;
200: l_check_item_categories_flag
201: oe_credit_check_rules.check_item_categories_flag%TYPE := NULL;
202: BEGIN
203: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Credit_Check_Rule_ID');

Line 201: oe_credit_check_rules.check_item_categories_flag%TYPE := NULL;

197: oe_credit_check_rules.name%TYPE := NULL;
198: l_credit_check_level_code
199: oe_credit_check_rules.credit_check_level_code%TYPE := NULL;
200: l_check_item_categories_flag
201: oe_credit_check_rules.check_item_categories_flag%TYPE := NULL;
202: BEGIN
203: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Credit_Check_Rule_ID');
204: x_return_status := FND_API.G_RET_STS_SUCCESS;
205: IF p_credit_check_rule_id IS NOT NULL AND

Line 216: FROM oe_credit_check_rules

212: INTO l_credit_check_rule_id,
213: l_credit_check_rule_name,
214: l_credit_check_level_code,
215: l_check_item_categories_flag
216: FROM oe_credit_check_rules
217: WHERE credit_check_rule_id = p_credit_check_rule_id;
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;

Line 242: FROM oe_credit_check_rules

238: INTO l_credit_check_rule_id,
239: l_credit_check_rule_name,
240: l_credit_check_level_code,
241: l_check_item_categories_flag
242: FROM oe_credit_check_rules
243: WHERE name = p_credit_check_rule_name;
244: EXCEPTION
245: WHEN NO_DATA_FOUND THEN
246: x_return_status := FND_API.G_RET_STS_ERROR;