eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_JAINBBR_XMLP_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 103: CURSOR GET_APP_COLUMN_NAME(CP_ID_FLEX_CODE IN FND_SEGMENT_ATTRIBUTE_VALUES.ID_FLEX_CODE%TYPE,CP_SEG_ATT_TYPE IN FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE) IS

99: RETURN (V_SOB_NAME);
100: END CF_1FORMULA;
101:
102: FUNCTION CF_ACCT_DESCFORMULA (account_code IN NUMBER) RETURN VARCHAR2 IS
103: CURSOR GET_APP_COLUMN_NAME(CP_ID_FLEX_CODE IN FND_SEGMENT_ATTRIBUTE_VALUES.ID_FLEX_CODE%TYPE,CP_SEG_ATT_TYPE IN FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE) IS
104: SELECT
105: DISTINCT
106: APPLICATION_COLUMN_NAME
107: FROM

Line 108: FND_SEGMENT_ATTRIBUTE_VALUES

104: SELECT
105: DISTINCT
106: APPLICATION_COLUMN_NAME
107: FROM
108: FND_SEGMENT_ATTRIBUTE_VALUES
109: WHERE APPLICATION_ID = 101
110: AND ID_FLEX_CODE = CP_ID_FLEX_CODE
111: AND ID_FLEX_NUM = P_CHART_OF_ACCTS_ID
112: AND SEGMENT_ATTRIBUTE_TYPE = CP_SEG_ATT_TYPE

Line 114: CURSOR FLEX_VAL_SET_ID(V_COLUMN_NAME IN VARCHAR2,CP_ID_FLEX_CODE IN FND_SEGMENT_ATTRIBUTE_VALUES.ID_FLEX_CODE%TYPE) IS

110: AND ID_FLEX_CODE = CP_ID_FLEX_CODE
111: AND ID_FLEX_NUM = P_CHART_OF_ACCTS_ID
112: AND SEGMENT_ATTRIBUTE_TYPE = CP_SEG_ATT_TYPE
113: AND ATTRIBUTE_VALUE = 'Y';
114: CURSOR FLEX_VAL_SET_ID(V_COLUMN_NAME IN VARCHAR2,CP_ID_FLEX_CODE IN FND_SEGMENT_ATTRIBUTE_VALUES.ID_FLEX_CODE%TYPE) IS
115: SELECT
116: A.FLEX_VALUE_SET_ID
117: FROM
118: FND_ID_FLEX_SEGMENTS A