APPS.IEM_ROUTE_PVT dependencies on IEM_ROUTE_RULES

Line 181: FROM IEM_ROUTE_RULES

177:
178:
179: DELETE
180:
181: FROM IEM_ROUTE_RULES
182: WHERE route_id=p_route_ids_tbl(i);
183: END LOOP;
184:
185: end if;

Line 249: l_route_rule_id IEM_ROUTE_RULES.ROUTE_RULE_ID%TYPE;

245: l_api_name VARCHAR2(255):='create_item_wrap';
246: l_api_version_number NUMBER:=1.0;
247:
248: l_route_id IEM_ROUTES.ROUTE_ID%TYPE;
249: l_route_rule_id IEM_ROUTE_RULES.ROUTE_RULE_ID%TYPE;
250: l_return_type VARCHAR2(30);
251:
252:
253: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

Line 733: SELECT IEM_ROUTE_RULES_s1.nextval

729: end if;
730: */
731:
732:
733: SELECT IEM_ROUTE_RULES_s1.nextval
734: INTO l_seq_id
735: FROM dual;
736:
737:

Line 739: INSERT INTO IEM_ROUTE_RULES

735: FROM dual;
736:
737:
738:
739: INSERT INTO IEM_ROUTE_RULES
740: (
741:
742: ROUTE_RULE_ID,
743: ROUTE_ID,

Line 1040: --update iem_routes, update iem_route_rules, insert iem_route_rules

1036: );
1037:
1038: END create_item_account_routes;
1039:
1040: --update iem_routes, update iem_route_rules, insert iem_route_rules
1041: PROCEDURE update_item_wrap (p_api_version_number IN NUMBER,
1042: p_init_msg_list IN VARCHAR2 := null,
1043: p_commit IN VARCHAR2 := null,
1044: p_route_id IN NUMBER,

Line 1159: --update iem_route_rules table

1155: raise l_IEM_FAIL_TO_CALL;
1156: end if;
1157:
1158:
1159: --update iem_route_rules table
1160: if ( p_update_rule_ids_tbl.count <>0 ) then
1161:
1162: FOR i IN p_update_rule_ids_tbl.FIRST..p_update_rule_ids_tbl.LAST loop
1163: iem_route_pvt.update_item_rule(p_api_version_number => l_api_version_number,

Line 1182: -- update by deleting rules from iem_route_rules table

1178: end loop;
1179: end if;
1180:
1181:
1182: -- update by deleting rules from iem_route_rules table
1183: if ( p_remove_rule_ids_tbl.count <> 0 ) then
1184: FORALL i IN p_remove_rule_ids_tbl.FIRST..p_remove_rule_ids_tbl.LAST
1185: DELETE
1186: FROM IEM_ROUTE_RULES

Line 1186: FROM IEM_ROUTE_RULES

1182: -- update by deleting rules from iem_route_rules table
1183: if ( p_remove_rule_ids_tbl.count <> 0 ) then
1184: FORALL i IN p_remove_rule_ids_tbl.FIRST..p_remove_rule_ids_tbl.LAST
1185: DELETE
1186: FROM IEM_ROUTE_RULES
1187: WHERE route_rule_id = p_remove_rule_ids_tbl(i);
1188:
1189: if SQL%NOTFOUND then
1190: raise IEM_RULE_NOT_DELETED;

Line 1217: select count(*) into l_rule_count from iem_route_rules where route_id = p_route_id;

1213: end if;
1214:
1215: -- check if exist at least one rule for each route
1216:
1217: select count(*) into l_rule_count from iem_route_rules where route_id = p_route_id;
1218:
1219: if p_all_emails<>'Y' then
1220: if l_rule_count < 1 then
1221: raise IEM_ADMIN_ROUTE_NO_RULE;

Line 1515: select count(*) into l_rule from iem_route_rules

1511: -- Initialize API return status to SUCCESS
1512: x_return_status := FND_API.G_RET_STS_SUCCESS;
1513:
1514: -- check if the route_id exist in iem_routes
1515: select count(*) into l_rule from iem_route_rules
1516:
1517: where route_rule_id = p_route_rule_id;
1518:
1519: if l_rule < 1 then

Line 1541: update IEM_ROUTE_RULES

1537: */
1538:
1539:
1540:
1541: update IEM_ROUTE_RULES
1542: set
1543: key_type_code=decode(p_key_type_code,null,key_type_code,p_key_type_code),
1544: operator_type_code=decode(p_operator_type_code,null,operator_type_code,p_operator_type_code),
1545: value=decode(p_value,null,value,p_value),