eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_ITM_QUERY_CUSTOM

Line 11007: l_del_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;

11003: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
11004:
11005: l_strQuery VARCHAR2(12000);
11006: l_tempStr VARCHAR2(12000);
11007: l_del_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
11008: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
11009:
11010: l_CursorID NUMBER;
11011: l_ignore NUMBER;

Line 11008: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

11004:
11005: l_strQuery VARCHAR2(12000);
11006: l_tempStr VARCHAR2(12000);
11007: l_del_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
11008: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
11009:
11010: l_CursorID NUMBER;
11011: l_ignore NUMBER;
11012: v_delivery_id NUMBER := 0;

Line 11056: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

11052: l_Item_Condn1Tab(1).g_number_val := p_delivery_id;
11053: l_Item_Condn1Tab(1).g_Bind_Literal := ':b_delivery_id';
11054:
11055: IF l_debug_on THEN
11056: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
11057: END IF;
11058: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_del_Table, ' AND WND.delivery_id = :b_delivery_id', l_Item_Condn1Tab, 'NUMBER');
11059:
11060:

Line 11058: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_del_Table, ' AND WND.delivery_id = :b_delivery_id', l_Item_Condn1Tab, 'NUMBER');

11054:
11055: IF l_debug_on THEN
11056: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
11057: END IF;
11058: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_del_Table, ' AND WND.delivery_id = :b_delivery_id', l_Item_Condn1Tab, 'NUMBER');
11059:
11060:
11061:
11062: --Call the customized API

Line 11092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);

11088: DBMS_SQL.PARSE(l_CursorID, l_strQuery, DBMS_SQL.v7);
11089: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, v_delivery_id);
11090:
11091: IF l_debug_on THEN
11092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
11093: END IF;
11094: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_del_Table, l_CursorID);
11095:
11096: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);

Line 11094: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_del_Table, l_CursorID);

11090:
11091: IF l_debug_on THEN
11092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
11093: END IF;
11094: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_del_Table, l_CursorID);
11095:
11096: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
11097:
11098: l_rows_fetched := dbms_sql.fetch_rows(l_CursorID);