[Home] [Help]
1689: --Added by ajprabha for 10+ validations.
1690: --========================================================================
1691: -- PROCEDURE : TENDER_TRIP_VALIDATIONS PRIVATE
1692: --
1693: -- PARAMETERS: p_tripNameTab IN FTE_NAME_TAB_TYPE
1694: --
1695: -- RETURN : Token of Trips Names as per required to display.
1696: -- VERSION : current version 1.0
1697: -- initial version 1.0
1729: --Added by ajprabha for 10+ validations.
1730: --========================================================================
1731: -- PROCEDURE : TENDER_TRIP_VALIDATIONS PRIVATE
1732: --
1733: -- PARAMETERS: p_tripNameTab IN FTE_NAME_TAB_TYPE
1734: --
1735: -- RETURN : Token of Trips Names as per required to display.
1736: -- VERSION : current version 1.0
1737: -- initial version 1.0
1736: -- VERSION : current version 1.0
1737: -- initial version 1.0
1738: --========================================================================
1739: FUNCTION GET_TRIP_MSG_TOKEN
1740: (p_tripNamesTab IN FTE_NAME_TAB_TYPE -- Table of Trip Names
1741: ) RETURN VARCHAR2 IS
1742: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1743: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.' || 'GET_TRIP_MSG_TOKEN';
1744:
2003:
2004: --Result and Failed IDs
2005: l_error_id_tab FTE_ID_TAB_TYPE;
2006: l_valid_ids_tab FTE_ID_TAB_TYPE;
2007: l_error_name_tab FTE_NAME_TAB_TYPE;
2008: l_valid_name_tab FTE_NAME_TAB_TYPE;
2009:
2010: l_tenderIds VARCHAR2(500);
2011:
2004: --Result and Failed IDs
2005: l_error_id_tab FTE_ID_TAB_TYPE;
2006: l_valid_ids_tab FTE_ID_TAB_TYPE;
2007: l_error_name_tab FTE_NAME_TAB_TYPE;
2008: l_valid_name_tab FTE_NAME_TAB_TYPE;
2009:
2010: l_tenderIds VARCHAR2(500);
2011:
2012: l_trip_action_rec FTE_TRIP_ACTION_PARAM_REC;
2140: END IF;
2141:
2142: l_error_id_tab := FTE_ID_TAB_TYPE();
2143: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2144: l_error_name_tab := FTE_NAME_TAB_TYPE();
2145: l_valid_name_tab := FTE_NAME_TAB_TYPE();
2146:
2147:
2148: BEGIN
2141:
2142: l_error_id_tab := FTE_ID_TAB_TYPE();
2143: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2144: l_error_name_tab := FTE_NAME_TAB_TYPE();
2145: l_valid_name_tab := FTE_NAME_TAB_TYPE();
2146:
2147:
2148: BEGIN
2149: --Looping through the trips to tender if possible.
2564:
2565: --Result and Failed IDs
2566: l_error_id_tab FTE_ID_TAB_TYPE;
2567: l_valid_ids_tab FTE_ID_TAB_TYPE;
2568: l_error_name_tab FTE_NAME_TAB_TYPE;
2569:
2570: x_trip_id NUMBER := 0;
2571: x_trip_name VARCHAR2(30);
2572: x_CREATION_DATE DATE;
2592: END IF;
2593:
2594: l_error_id_tab := FTE_ID_TAB_TYPE();
2595: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2596: l_error_name_tab := FTE_NAME_TAB_TYPE();
2597:
2598: BEGIN
2599: FOR i IN p_trip_id_tab.FIRST..p_trip_id_tab.LAST LOOP
2600: IF l_debug_on THEN
5738: PROCEDURE Get_Disabled_List(
5739: p_entity_type IN VARCHAR2,
5740: p_entity_id IN NUMBER,
5741: p_parent_entity_id IN NUMBER DEFAULT NULL,
5742: x_disabled_list OUT NOCOPY FTE_NAME_TAB_TYPE,
5743: x_return_status OUT NOCOPY VARCHAR2,
5744: x_msg_count OUT NOCOPY NUMBER,
5745: x_msg_data OUT NOCOPY VARCHAR2
5746: ) IS
5787: IF ((l_disabled_list IS NOT NULL) AND (l_disabled_list.COUNT > 0) AND
5788: ((x_return_status <>WSH_UTIL_CORE.G_RET_STS_ERROR ) OR
5789: (x_return_status <>WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)))
5790: THEN
5791: x_disabled_list:=FTE_NAME_TAB_TYPE('NULL');
5792: x_disabled_list.EXTEND(l_disabled_list.COUNT-1,1);
5793: i:=l_disabled_list.FIRST();
5794:
5795: WHILE( i IS NOT NULL)