APPS.AP_WEB_OA_ACTIVE_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

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

159: --
160:
161: FUNCTION GetWFLastNotificationActivity (p_report_header_id IN NUMBER) RETURN VARCHAR2
162: IS
163: v_activity_label wf_item_activity_statuses_v.activity_label%TYPE := NULL;
164:
165: BEGIN
166: -- Find activity with last notification id
167: /*Bug 2790208: Added rownum = 1 with an order by clause

Line 176: FROM WF_ITEM_ACTIVITY_STATUSES IAS,

172: SELECT INSTANCE_LABEL
173: INTO v_activity_label
174: FROM (
175: SELECT PA.INSTANCE_LABEL
176: FROM WF_ITEM_ACTIVITY_STATUSES IAS,
177: WF_PROCESS_ACTIVITIES PA
178: WHERE
179: IAS.ITEM_TYPE = C_APEXP
180: AND IAS.ACTIVITY_STATUS = C_NOTIFIED

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

217: --Bug 3612002:Changed datatype of the variable so that length
218: -- will become 4000.
219:
220: v_approver WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE := NULL;
221: v_activity_label wf_item_activity_statuses_v.activity_label%TYPE := NULL;
222:
223: BEGIN
224: -- Check cache
225: IF ((p_report_header_id = grsc_old_report_header_id) AND (p_cache = 'Y'))THEN