761: P_VALIDATION_LEVEL IN NUMBER,
762: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
763: X_MSG_COUNT OUT NOCOPY NUMBER,
764: X_MSG_DATA OUT NOCOPY VARCHAR2,
765: P_WORK_ITEM_ID_TBL IN DBMS_SQL.NUMBER_TABLE,
766: P_UWQ_STATUS IN VARCHAR2,
767: P_NO_DAYS IN NUMBER)
768: IS
769: l_api_name CONSTANT VARCHAR2(30) := 'SHOW_IN_UWQ';
780:
781: Type refCur is Ref Cursor;
782: l_cursor refCur;
783: l_SQL VARCHAR2(10000);
784: l_broken_promises DBMS_SQL.NUMBER_TABLE;
785: i number;
786: j number;
787: l_uwq_active_date date;
788: l_uwq_complete_date date;