APPS.AHL_MC_NODE_PVT dependencies on AHL_CTR_UPDATE_RULES

Line 1200: DELETE FROM ahl_ctr_update_rules

1196: );
1197: END IF;
1198:
1199: -- 9g. Delete all counter rule associations with the current node
1200: DELETE FROM ahl_ctr_update_rules
1201: WHERE relationship_id = l_node_csr_rec.relationship_id;
1202:
1203: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1204: THEN

Line 1567: FROM ahl_ctr_update_rules

1563: p_rel_id in number
1564: )
1565: IS
1566: SELECT *
1567: FROM ahl_ctr_update_rules
1568: WHERE relationship_id = p_rel_id;
1569:
1570: TYPE Number_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1571:

Line 3285: FROM ahl_ctr_update_rules

3281:
3282: CURSOR check_counter_exists
3283: IS
3284: SELECT object_version_number
3285: FROM ahl_ctr_update_rules
3286: WHERE ctr_update_rule_id = p_ctr_rule_id;
3287:
3288: BEGIN
3289:

Line 3344: FROM ahl_ctr_update_rules

3340: -- already exists for the node or not
3341: CURSOR check_uom_rule
3342: IS
3343: SELECT 'x'
3344: FROM ahl_ctr_update_rules
3345: WHERE relationship_id = p_counter_rule_rec.relationship_id AND
3346: rule_code = p_counter_rule_rec.rule_code AND
3347: uom_code = p_counter_rule_rec.uom_code AND
3348: ctr_update_rule_id <> nvl(p_counter_rule_rec.ctr_update_rule_id, -1);

Line 3850: SELECT ahl_ctr_update_rules_s.nextval INTO p_x_counter_rule_rec.ctr_update_rule_id FROM DUAL;

3846: 'Counter rule validation successful'
3847: );
3848: END IF;
3849:
3850: SELECT ahl_ctr_update_rules_s.nextval INTO p_x_counter_rule_rec.ctr_update_rule_id FROM DUAL;
3851: p_x_counter_rule_rec.object_version_number := 1;
3852: p_x_counter_rule_rec.security_group_id := null;
3853:
3854: INSERT INTO AHL_CTR_UPDATE_RULES

Line 3854: INSERT INTO AHL_CTR_UPDATE_RULES

3850: SELECT ahl_ctr_update_rules_s.nextval INTO p_x_counter_rule_rec.ctr_update_rule_id FROM DUAL;
3851: p_x_counter_rule_rec.object_version_number := 1;
3852: p_x_counter_rule_rec.security_group_id := null;
3853:
3854: INSERT INTO AHL_CTR_UPDATE_RULES
3855: (
3856: CTR_UPDATE_RULE_ID,
3857: RELATIONSHIP_ID,
3858: UOM_CODE,

Line 3939: FROM ahl_ctr_update_rules

3935: -- already exists for the node or not
3936: CURSOR check_uom_rule
3937: IS
3938: SELECT 'x'
3939: FROM ahl_ctr_update_rules
3940: WHERE relationship_id = p_x_counter_rule_rec.relationship_id AND
3941: rule_code = p_x_counter_rule_rec.rule_code AND
3942: uom_code = p_x_counter_rule_rec.uom_code AND
3943: ctr_update_rule_id <> p_x_counter_rule_rec.ctr_update_rule_id;

Line 3991: UPDATE AHL_CTR_UPDATE_RULES

3987: END IF;
3988:
3989: p_x_counter_rule_rec.object_version_number := p_x_counter_rule_rec.object_version_number + 1;
3990:
3991: UPDATE AHL_CTR_UPDATE_RULES
3992: SET RATIO = p_x_counter_rule_rec.RATIO,
3993: RULE_CODE = p_x_counter_rule_rec.RULE_CODE,
3994: OBJECT_VERSION_NUMBER = p_x_counter_rule_rec.OBJECT_VERSION_NUMBER,
3995: SECURITY_GROUP_ID = p_x_counter_rule_rec.SECURITY_GROUP_ID,

Line 4047: DELETE FROM ahl_ctr_update_rules

4043:
4044: -- Validate p_ctr_update_rule_id exists
4045: Validate_Counter_Exists(p_ctr_update_rule_id, nvl(p_object_ver_num, 0));
4046:
4047: DELETE FROM ahl_ctr_update_rules
4048: WHERE ctr_update_rule_id = p_ctr_update_rule_id;
4049:
4050: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4051: THEN