DBA Data[Home] [Help]

APPS.AP_WEB_OA_REPORTING_UTIL dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 5: g_CostCenterSegmentName FND_SEGMENT_ATTRIBUTE_VALUES.application_column_name%TYPE := NULL;

1: PACKAGE BODY AP_WEB_OA_REPORTING_UTIL AS
2: /* $Header: apwrputb.pls 120.9 2010/09/09 11:54:41 dsadipir ship $ */
3:
4: -- Cache for Segment Name which implements the Cost Center
5: g_CostCenterSegmentName FND_SEGMENT_ATTRIBUTE_VALUES.application_column_name%TYPE := NULL;
6:
7: -- Cache for GetCostCenter
8: gcc_old_code_combination_id NUMBER := NULL;
9: gcc_cost_center VARCHAR2(30) := NULL;

Line 72: l_CostCenterSegmentName FND_SEGMENT_ATTRIBUTE_VALUES.application_column_name%TYPE;

68: | 13-MAR-2002 krmenon Created
69: *=======================================================================*/
70: FUNCTION GetCostCenter (p_code_combination_id IN NUMBER) RETURN VARCHAR2
71: IS
72: l_CostCenterSegmentName FND_SEGMENT_ATTRIBUTE_VALUES.application_column_name%TYPE;
73: l_SqlQry VARCHAR2(300);
74: BEGIN
75: -- Check if cached, and return cached value
76: IF ( p_code_combination_id = gcc_old_code_combination_id ) THEN