APPS.AHL_MC_RULE_PVT dependencies on AHL_MC_RULES_B

Line 704: FROM AHL_MC_RULES_B

700: AND lookup_type = 'AHL_MC_RULE_TYPES';
701: --
702: CURSOR Check_rule_name_csr (p_name IN VARCHAR2, p_mc_header_id IN NUMBER) IS
703: SELECT 'X'
704: FROM AHL_MC_RULES_B
705: WHERE mc_header_id = p_mc_header_id
706: AND rule_name = p_name;
707: --
708: l_api_version CONSTANT NUMBER := 1.0;

Line 865: SELECT AHL_MC_RULES_B_S.nextval

861: IF x_msg_count > 0 THEN
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;
864:
865: SELECT AHL_MC_RULES_B_S.nextval
866: INTO p_x_rule_rec.rule_id
867: FROM dual;
868:
869: --Convert the flat structure into a rule tree.

Line 1011: FROM AHL_MC_RULES_B

1007: CURSOR Check_rule_name_csr (p_name IN VARCHAR2,
1008: p_mc_header_id IN NUMBER,
1009: p_rule_id IN NUMBER) IS
1010: SELECT 'X'
1011: FROM AHL_MC_RULES_B
1012: WHERE mc_header_id = p_mc_header_id
1013: AND rule_name = p_name
1014: AND rule_id <> p_rule_id;
1015: --

Line 1024: FROM ahl_mc_rules_b rule, ahl_mc_headers_v header

1020: WHERE rule_id = p_rule_id;
1021: --
1022: CURSOR check_mc_status_csr (p_rule_id IN NUMBER) IS
1023: SELECT config_status_code, config_status_meaning
1024: FROM ahl_mc_rules_b rule, ahl_mc_headers_v header
1025: WHERE rule.mc_header_id = header.mc_header_id
1026: AND rule.rule_id = p_rule_id;
1027: --
1028: l_api_version CONSTANT NUMBER := 1.0;

Line 1408: FROM ahl_mc_rules_b rule

1404: IS
1405: --
1406: CURSOR check_obj_ver_csr (p_rule_id IN NUMBER, p_obj_ver IN NUMBER) IS
1407: SELECT 'X'
1408: FROM ahl_mc_rules_b rule
1409: WHERE rule.object_version_number = p_obj_ver
1410: AND rule.rule_id = p_rule_id;
1411: --
1412: CURSOR check_mc_status_csr (p_rule_id IN NUMBER) IS

Line 1414: FROM ahl_mc_rules_b rule, ahl_mc_headers_v header

1410: AND rule.rule_id = p_rule_id;
1411: --
1412: CURSOR check_mc_status_csr (p_rule_id IN NUMBER) IS
1413: SELECT config_status_code, config_status_meaning, header.mc_header_id
1414: FROM ahl_mc_rules_b rule, ahl_mc_headers_v header
1415: WHERE rule.mc_header_id = header.mc_header_id
1416: AND rule.rule_id = p_rule_id;
1417: --
1418: l_api_version CONSTANT NUMBER := 1.0;

Line 1601: SELECT AHL_MC_RULES_B_S.nextval

1597: EXIT WHEN get_rule_rec_csr%NOTFOUND;
1598:
1599: SAVEPOINT copy_rule_pvt;
1600:
1601: SELECT AHL_MC_RULES_B_S.nextval
1602: INTO l_new_rule_id
1603: FROM dual;
1604:
1605: --Copy the Rule Record

Line 1739: FROM AHL_MC_RULES_B

1735: IS
1736: --
1737: CURSOR get_rule_ids_csr (p_mc_header_id IN NUMBER) IS
1738: SELECT rule_id, object_version_number
1739: FROM AHL_MC_RULES_B
1740: WHERE MC_HEADER_ID = p_mc_header_id;
1741: --
1742: l_api_version CONSTANT NUMBER := 1.0;
1743: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rules_For_Mc';