APPS.WSH_DELIVERY_VALIDATIONS dependencies on DBMS_SQL

Line 10815: l_CursorID := DBMS_SQL.Open_Cursor;

10811: l_strQuery := l_strQuery || l_tempStr;
10812:
10813: -- Parse cursor
10814:
10815: l_CursorID := DBMS_SQL.Open_Cursor;
10816: DBMS_SQL.PARSE(l_CursorID, l_strQuery, DBMS_SQL.v7);
10817: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, v_delivery_id);
10818:
10819: IF l_debug_on THEN

Line 10816: DBMS_SQL.PARSE(l_CursorID, l_strQuery, DBMS_SQL.v7);

10812:
10813: -- Parse cursor
10814:
10815: l_CursorID := DBMS_SQL.Open_Cursor;
10816: DBMS_SQL.PARSE(l_CursorID, l_strQuery, DBMS_SQL.v7);
10817: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, v_delivery_id);
10818:
10819: IF l_debug_on THEN
10820: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 10817: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, v_delivery_id);

10813: -- Parse cursor
10814:
10815: l_CursorID := DBMS_SQL.Open_Cursor;
10816: DBMS_SQL.PARSE(l_CursorID, l_strQuery, DBMS_SQL.v7);
10817: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, v_delivery_id);
10818:
10819: IF l_debug_on THEN
10820: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
10821: END IF;

Line 10824: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);

10820: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
10821: END IF;
10822: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_del_Table, l_CursorID);
10823:
10824: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
10825:
10826: l_rows_fetched := dbms_sql.fetch_rows(l_CursorID);
10827: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
10828:

Line 10826: l_rows_fetched := dbms_sql.fetch_rows(l_CursorID);

10822: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_del_Table, l_CursorID);
10823:
10824: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
10825:
10826: l_rows_fetched := dbms_sql.fetch_rows(l_CursorID);
10827: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
10828:
10829: IF (l_rows_fetched = 0) THEN
10830:

Line 10827: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

10823:
10824: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
10825:
10826: l_rows_fetched := dbms_sql.fetch_rows(l_CursorID);
10827: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
10828:
10829: IF (l_rows_fetched = 0) THEN
10830:
10831: IF l_debug_on THEN