DBA Data[Home] [Help]

APPS.AP_WEB_OA_ACTIVE_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 172: v_activity_label wf_item_activity_statuses_v.activity_label%TYPE := NULL;

168: --
169:
170: FUNCTION GetWFLastNotificationActivity (p_report_header_id IN NUMBER) RETURN VARCHAR2
171: IS
172: v_activity_label wf_item_activity_statuses_v.activity_label%TYPE := NULL;
173:
174: BEGIN
175: -- Find activity with last notification id
176: /*Bug 2790208: Added rownum = 1 with an order by clause

Line 231: v_activity_label wf_item_activity_statuses_v.activity_label%TYPE := NULL;

227: --Bug 3612002:Changed datatype of the variable so that length
228: -- will become 4000.
229:
230: v_approver WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE := NULL;
231: v_activity_label wf_item_activity_statuses_v.activity_label%TYPE := NULL;
232:
233: BEGIN
234: -- Check cache
235: IF ((p_report_header_id = grsc_old_report_header_id) AND (p_cache = 'Y'))THEN