DBA Data[Home] [Help]

APPS.INL_RULE_PVT dependencies on INL_RULES_VL

Line 374: FROM inl_rules_vl

370: CLOSE c_cond_tables;
371:
372: SELECT usage_code
373: INTO l_usage_code
374: FROM inl_rules_vl
375: WHERE rule_id = p_rule_id;
376:
377: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
378: p_procedure_name => l_func_name,

Line 713: FROM inl_rules_vl r

709: FROM dual;
710:
711: SELECT r.package_name, r.rule_name
712: INTO l_package_name, l_rule_name
713: FROM inl_rules_vl r
714: WHERE r.package_name IS NOT NULL
715: AND r.rule_id = p_rule_id;
716:
717: -- First line to create package specification

Line 841: FROM inl_rules_vl irb

837: FROM dual;
838:
839: SELECT irb.package_name, irb.rule_name
840: INTO l_package_name, l_rule_name
841: FROM inl_rules_vl irb
842: WHERE irb.package_name IS NOT NULL
843: AND rule_id = p_rule_id;
844:
845: -- First line to create package specification

Line 1070: FROM inl_rules_vl r

1066: x_return_status := FND_API.G_RET_STS_SUCCESS;
1067:
1068: SELECT r.rule_name, r.usage_code
1069: INTO l_rule_name, l_usage_code
1070: FROM inl_rules_vl r
1071: WHERE r.rule_id = p_rule_id;
1072:
1073: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1074: p_procedure_name => l_api_name,

Line 1663: FROM inl_rules_vl

1659: x_return_status := FND_API.G_RET_STS_SUCCESS;
1660:
1661: SELECT package_name
1662: INTO l_package_name
1663: FROM inl_rules_vl
1664: WHERE rule_id = p_rule_id;
1665:
1666: IF l_package_name IS NOT NULL AND l_package_name LIKE 'INL_RULE_%' || p_rule_id THEN
1667: