APPS.AP_WEB_OA_ACTIVE_PKG dependencies on AP_LOOKUP_CODES

Line 5: g_ApApprover ap_lookup_codes.displayed_field%TYPE := NULL;

1: PACKAGE BODY AP_WEB_OA_ACTIVE_PKG AS
2: /* $Header: apwoaacb.pls 120.21.12020000.2 2012/09/20 07:13:32 meesubra ship $ */
3:
4: -- Cache for AP Approver and Expenses Administrator
5: g_ApApprover ap_lookup_codes.displayed_field%TYPE := NULL;
6: g_ExpensesAdmin ap_lookup_codes.displayed_field%TYPE := NULL;
7:
8: -- Cache for GetReportStatusCode
9: grsc_old_report_header_id NUMBER := NULL;

Line 6: g_ExpensesAdmin ap_lookup_codes.displayed_field%TYPE := NULL;

2: /* $Header: apwoaacb.pls 120.21.12020000.2 2012/09/20 07:13:32 meesubra ship $ */
3:
4: -- Cache for AP Approver and Expenses Administrator
5: g_ApApprover ap_lookup_codes.displayed_field%TYPE := NULL;
6: g_ExpensesAdmin ap_lookup_codes.displayed_field%TYPE := NULL;
7:
8: -- Cache for GetReportStatusCode
9: grsc_old_report_header_id NUMBER := NULL;
10: grsc_old_status_code ap_lookup_codes.lookup_code%TYPE := NULL;

Line 10: grsc_old_status_code ap_lookup_codes.lookup_code%TYPE := NULL;

6: g_ExpensesAdmin ap_lookup_codes.displayed_field%TYPE := NULL;
7:
8: -- Cache for GetReportStatusCode
9: grsc_old_report_header_id NUMBER := 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;

Line 81: v_ApApprover ap_lookup_codes.displayed_field%TYPE := NULL;

77: --
78:
79: FUNCTION GetApApprover RETURN VARCHAR2
80: IS
81: v_ApApprover ap_lookup_codes.displayed_field%TYPE := NULL;
82: v_langCode language_code;
83: BEGIN
84: v_langCode := userenv('LANG');
85:

Line 94: FROM ap_lookup_codes

90: g_langCode := v_langCode;
91:
92: SELECT DISPLAYED_FIELD
93: INTO v_ApApprover
94: FROM ap_lookup_codes
95: WHERE LOOKUP_TYPE = C_EXPENSE_REPORT_APPROVER
96: AND LOOKUP_CODE = C_AP;
97:
98: -- Update cache

Line 126: v_ExpensesAdmin ap_lookup_codes.displayed_field%TYPE := NULL;

122: --
123:
124: FUNCTION GetExpensesAdmin RETURN VARCHAR2
125: IS
126: v_ExpensesAdmin ap_lookup_codes.displayed_field%TYPE := NULL;
127: v_langCode language_code;
128: BEGIN
129: v_langCode := userenv('LANG');
130:

Line 139: FROM ap_lookup_codes

135: g_langCode := v_langCode;
136:
137: SELECT DISPLAYED_FIELD
138: INTO v_ExpensesAdmin
139: FROM ap_lookup_codes
140: WHERE LOOKUP_TYPE = C_EXPENSE_REPORT_APPROVER
141: AND LOOKUP_CODE = C_EXPADMIN;
142:
143: -- Update cache

Line 224: v_status_code ap_lookup_codes.lookup_code%TYPE := NULL;

220: p_report_header_id IN NUMBER,
221: p_cache IN VARCHAR2,
222: p_query_wf_activities IN VARCHAR2) RETURN VARCHAR2
223: IS
224: v_status_code ap_lookup_codes.lookup_code%TYPE := NULL;
225: v_expense_status_code ap_expense_report_headers_all.expense_status_code%TYPE := NULL;
226:
227: --Bug 3612002:Changed datatype of the variable so that length
228: -- will become 4000.

Line 375: v_status_code ap_lookup_codes.lookup_code%TYPE := NULL;

371: p_workflow_approved_flag IN VARCHAR2,
372: p_report_header_id IN NUMBER
373: ) RETURN VARCHAR2
374: IS
375: v_status_code ap_lookup_codes.lookup_code%TYPE := NULL;
376: v_status ap_lookup_codes.displayed_field%TYPE := NULL;
377:
378: BEGIN
379: -- Determine the status code

Line 376: v_status ap_lookup_codes.displayed_field%TYPE := NULL;

372: p_report_header_id IN NUMBER
373: ) RETURN VARCHAR2
374: IS
375: v_status_code ap_lookup_codes.lookup_code%TYPE := NULL;
376: v_status ap_lookup_codes.displayed_field%TYPE := NULL;
377:
378: BEGIN
379: -- Determine the status code
380: v_status_code := GetReportStatusCode(p_source,

Line 387: FROM ap_lookup_codes

383:
384: -- Using status code, retrieve displayed value.
385: SELECT DISPLAYED_FIELD
386: INTO v_status
387: FROM ap_lookup_codes
388: WHERE LOOKUP_TYPE = C_EXPENSE_REPORT_STATUS
389: AND LOOKUP_CODE = v_status_code;
390:
391: RETURN v_status;

Line 416: v_status_code ap_lookup_codes.lookup_code%TYPE := NULL;

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:
420: -- Use p_status_code if given.

Line 464: l_status ap_lookup_codes.lookup_code%TYPE ;

460:
461: FUNCTION GetIncludeNotification(p_category IN VARCHAR2,
462: p_trx_id IN NUMBER)
463: RETURN VARCHAR2 IS
464: l_status ap_lookup_codes.lookup_code%TYPE ;
465: l_source ap_expense_report_headers.source%TYPE;
466: l_workflow_approved_flag ap_expense_report_headers.workflow_approved_flag%TYPE;
467: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
468: