APPS.FTE_CARRIER_RANK_LIST_PVT dependencies on FTE_CARRIER_RANK_LIST_S

Line 37: UPDATE FTE_CARRIER_RANK_LIST SET

33:
34: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
35:
36:
37: UPDATE FTE_CARRIER_RANK_LIST SET
38: CARRIER_ID = decode(p_rank_info_rec.CARRIER_ID,NULL,CARRIER_ID,
39: FND_API.G_MISS_NUM,NULL,
40: p_rank_info_rec.CARRIER_ID),
41: SERVICE_LEVEL =decode(p_rank_info_rec.SERVICE_LEVEL,NULL,SERVICE_LEVEL,

Line 528: SELECT fte_carrier_rank_list_s.nextval

524: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
525:
526:
527: CURSOR get_next_rank_id IS
528: SELECT fte_carrier_rank_list_s.nextval
529: FROM sys.dual;
530:
531: l_temp_id NUMBER;
532: EMPTY_TRIP_ID EXCEPTION;

Line 3323: SELECT FTE_CARRIER_RANK_LIST_S.NEXTVAL INTO

3319:
3320: EXCEPTION
3321: WHEN NO_DATA_FOUND THEN
3322:
3323: SELECT FTE_CARRIER_RANK_LIST_S.NEXTVAL INTO
3324: p_ranklist.RANK_ID(i) FROM DUAL;
3325:
3326: IF l_debug_on
3327: THEN