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 3288: FROM ahl_ctr_update_rules

3284:
3285: CURSOR check_counter_exists
3286: IS
3287: SELECT object_version_number
3288: FROM ahl_ctr_update_rules
3289: WHERE ctr_update_rule_id = p_ctr_rule_id;
3290:
3291: BEGIN
3292:

Line 3347: FROM ahl_ctr_update_rules

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

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

3872: 'Counter rule validation successful'
3873: );
3874: END IF;
3875:
3876: SELECT ahl_ctr_update_rules_s.nextval INTO p_x_counter_rule_rec.ctr_update_rule_id FROM DUAL;
3877: p_x_counter_rule_rec.object_version_number := 1;
3878: p_x_counter_rule_rec.security_group_id := null;
3879:
3880: INSERT INTO AHL_CTR_UPDATE_RULES

Line 3880: INSERT INTO AHL_CTR_UPDATE_RULES

3876: SELECT ahl_ctr_update_rules_s.nextval INTO p_x_counter_rule_rec.ctr_update_rule_id FROM DUAL;
3877: p_x_counter_rule_rec.object_version_number := 1;
3878: p_x_counter_rule_rec.security_group_id := null;
3879:
3880: INSERT INTO AHL_CTR_UPDATE_RULES
3881: (
3882: CTR_UPDATE_RULE_ID,
3883: RELATIONSHIP_ID,
3884: UOM_CODE,

Line 3965: FROM ahl_ctr_update_rules

3961: -- already exists for the node or not
3962: CURSOR check_uom_rule
3963: IS
3964: SELECT 'x'
3965: FROM ahl_ctr_update_rules
3966: WHERE relationship_id = p_x_counter_rule_rec.relationship_id AND
3967: rule_code = p_x_counter_rule_rec.rule_code AND
3968: uom_code = p_x_counter_rule_rec.uom_code AND
3969: ctr_update_rule_id <> p_x_counter_rule_rec.ctr_update_rule_id;

Line 4017: UPDATE AHL_CTR_UPDATE_RULES

4013: END IF;
4014:
4015: p_x_counter_rule_rec.object_version_number := p_x_counter_rule_rec.object_version_number + 1;
4016:
4017: UPDATE AHL_CTR_UPDATE_RULES
4018: SET RATIO = p_x_counter_rule_rec.RATIO,
4019: RULE_CODE = p_x_counter_rule_rec.RULE_CODE,
4020: OBJECT_VERSION_NUMBER = p_x_counter_rule_rec.OBJECT_VERSION_NUMBER,
4021: SECURITY_GROUP_ID = p_x_counter_rule_rec.SECURITY_GROUP_ID,

Line 4073: DELETE FROM ahl_ctr_update_rules

4069:
4070: -- Validate p_ctr_update_rule_id exists
4071: Validate_Counter_Exists(p_ctr_update_rule_id, nvl(p_object_ver_num, 0));
4072:
4073: DELETE FROM ahl_ctr_update_rules
4074: WHERE ctr_update_rule_id = p_ctr_update_rule_id;
4075:
4076: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4077: THEN