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;
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:
216:
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
390: p_report_header_id IN NUMBER,
391: p_status_code IN VARCHAR2)
392: RETURN VARCHAR2
393: IS
394: v_current_approver WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE := NULL;
395: v_status_code ap_lookup_codes.lookup_code%TYPE := NULL;
396:
397: BEGIN
398: