DBA Data[Home] [Help]

APPS.AP_WEB_OA_ACTIVE_PKG dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 14: gan_old_approver_name WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE := NULL;

10: grsc_old_status_code ap_lookup_codes.lookup_code%TYPE := NULL;
11:
12: -- Cache for GetApproverName
13: gan_old_report_header_id NUMBER := NULL;
14: gan_old_approver_name WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE := NULL;
15: gan_old_attribute_name WF_ITEM_ATTRIBUTE_VALUES.NAME%TYPE := NULL;
16:
17: -- Global variable for session language code.
18: g_langCode language_code := NULL;

Line 15: gan_old_attribute_name WF_ITEM_ATTRIBUTE_VALUES.NAME%TYPE := NULL;

11:
12: -- Cache for GetApproverName
13: gan_old_report_header_id NUMBER := NULL;
14: gan_old_approver_name WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE := NULL;
15: gan_old_attribute_name WF_ITEM_ATTRIBUTE_VALUES.NAME%TYPE := NULL;
16:
17: -- Global variable for session language code.
18: g_langCode language_code := NULL;
19:

Line 230: v_approver WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE := NULL;

226:
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

Line 415: v_current_approver WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE := NULL;

411: p_report_header_id IN NUMBER,
412: p_status_code IN VARCHAR2)
413: RETURN VARCHAR2
414: IS
415: v_current_approver WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE := NULL;
416: v_status_code ap_lookup_codes.lookup_code%TYPE := NULL;
417:
418: BEGIN
419: