APPS.IEM_ROUTE_CLASS_PVT dependencies on IEM_ROUTE_CLASS_RULES

Line 236: FROM IEM_ROUTE_CLASS_RULES

232: SET DELETED_FLAG='Y'
233: WHERE route_classification_id = p_class_ids_tbl(i);
234:
235: DELETE
236: FROM IEM_ROUTE_CLASS_RULES
237: WHERE route_classification_id = p_class_ids_tbl(i);
238:
239: DELETE
240: FROM IEM_ACCOUNT_ROUTE_CLASS

Line 334: l_class_rule_id IEM_ROUTE_CLASS_RULES.ROUTE_CLASS_RULE_ID%TYPE;

330:
331: l_api_version_number NUMBER:=1.0;
332:
333: l_class_id IEM_ROUTE_CLASSIFICATIONS.ROUTE_CLASSIFICATION_ID%TYPE;
334: l_class_rule_id IEM_ROUTE_CLASS_RULES.ROUTE_CLASS_RULE_ID%TYPE;
335: l_return_type VARCHAR2(30);
336:
337: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
338: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;

Line 807: SELECT IEM_ROUTE_CLASS_RULES_s1.nextval

803: */
804:
805:
806:
807: SELECT IEM_ROUTE_CLASS_RULES_s1.nextval
808: INTO l_seq_id
809: FROM dual;
810:
811:

Line 814: INSERT INTO IEM_ROUTE_CLASS_RULES

810:
811:
812:
813:
814: INSERT INTO IEM_ROUTE_CLASS_RULES
815: (
816: ROUTE_CLASS_RULE_ID,
817: ROUTE_CLASSIFICATION_ID,
818: KEY_TYPE_CODE,

Line 1091: FROM IEM_ROUTE_CLASS_RULES

1087: if ( p_remove_rule_ids_tbl.count <> 0 ) then
1088: FORALL i IN p_remove_rule_ids_tbl.FIRST..p_remove_rule_ids_tbl.LAST
1089:
1090: DELETE
1091: FROM IEM_ROUTE_CLASS_RULES
1092: WHERE route_class_rule_id = p_remove_rule_ids_tbl(i);
1093:
1094:
1095:

Line 1127: select count(*) into l_rule_count from iem_route_class_rules where route_classification_id = p_class_id;

1123: end if;
1124:
1125:
1126: -- check if exist at least one rule for each route
1127: select count(*) into l_rule_count from iem_route_class_rules where route_classification_id = p_class_id;
1128:
1129:
1130:
1131: if l_rule_count < 1 then

Line 1457: select count(*) into l_rule from iem_route_class_rules

1453: x_return_status := FND_API.G_RET_STS_SUCCESS;
1454:
1455: -- check if the route_id exist in iem_routes
1456:
1457: select count(*) into l_rule from iem_route_class_rules
1458: where route_class_rule_id = p_route_class_rule_id;
1459:
1460: if l_rule < 1 then
1461: raise IEM_NO_RULE_UPDATE;

Line 1491: update IEM_ROUTE_CLASS_RULES

1487: elsif ( p_value = FND_API.G_MISS_CHAR ) then
1488: raise IEM_RULE_KEY_OP_VAL_NULL;
1489: end if;
1490:
1491: update IEM_ROUTE_CLASS_RULES
1492: set
1493:
1494: key_type_code=decode(p_key_type_code,null,key_type_code,p_key_type_code),
1495: operator_type_code=decode(p_operator_type_code,null,operator_type_code,p_operator_type_code),