2121: ELSIF p_short_name = 'OIPLFLX10' THEN
2122: l_rslt_elmt := ben_ext_person.g_oipl_attr_10;
2123: ELSIF p_short_name = 'OTL_TC_START_DATE' THEN
2124: l_rslt_elmt := apply_format_mask
2125: (hxc_ext_timecard.OTL_TC_START_DATE, p_frmt_mask_cd);
2126: ELSIF p_short_name = 'OTL_TC_END_DATE' THEN
2127: l_rslt_elmt := apply_format_mask
2128: (hxc_ext_timecard.OTL_TC_END_DATE, p_frmt_mask_cd);
2129: ELSIF p_short_name = 'OTL_TC_STATUS' THEN
2124: l_rslt_elmt := apply_format_mask
2125: (hxc_ext_timecard.OTL_TC_START_DATE, p_frmt_mask_cd);
2126: ELSIF p_short_name = 'OTL_TC_END_DATE' THEN
2127: l_rslt_elmt := apply_format_mask
2128: (hxc_ext_timecard.OTL_TC_END_DATE, p_frmt_mask_cd);
2129: ELSIF p_short_name = 'OTL_TC_STATUS' THEN
2130: l_rslt_elmt := hxc_ext_timecard.OTL_TC_STATUS;
2131: ELSIF p_short_name = 'OTL_TC_COMMENTS' THEN
2132: l_rslt_elmt := hxc_ext_timecard.OTL_TC_COMMENTS;
2126: ELSIF p_short_name = 'OTL_TC_END_DATE' THEN
2127: l_rslt_elmt := apply_format_mask
2128: (hxc_ext_timecard.OTL_TC_END_DATE, p_frmt_mask_cd);
2129: ELSIF p_short_name = 'OTL_TC_STATUS' THEN
2130: l_rslt_elmt := hxc_ext_timecard.OTL_TC_STATUS;
2131: ELSIF p_short_name = 'OTL_TC_COMMENTS' THEN
2132: l_rslt_elmt := hxc_ext_timecard.OTL_TC_COMMENTS;
2133: ELSIF p_short_name = 'OTL_TC_DELTED' THEN
2134: l_rslt_elmt := hxc_ext_timecard.OTL_TC_DELTED;
2128: (hxc_ext_timecard.OTL_TC_END_DATE, p_frmt_mask_cd);
2129: ELSIF p_short_name = 'OTL_TC_STATUS' THEN
2130: l_rslt_elmt := hxc_ext_timecard.OTL_TC_STATUS;
2131: ELSIF p_short_name = 'OTL_TC_COMMENTS' THEN
2132: l_rslt_elmt := hxc_ext_timecard.OTL_TC_COMMENTS;
2133: ELSIF p_short_name = 'OTL_TC_DELTED' THEN
2134: l_rslt_elmt := hxc_ext_timecard.OTL_TC_DELTED;
2135: ELSIF p_short_name = 'OTL_DAY' THEN
2136: l_rslt_elmt := apply_format_mask
2130: l_rslt_elmt := hxc_ext_timecard.OTL_TC_STATUS;
2131: ELSIF p_short_name = 'OTL_TC_COMMENTS' THEN
2132: l_rslt_elmt := hxc_ext_timecard.OTL_TC_COMMENTS;
2133: ELSIF p_short_name = 'OTL_TC_DELTED' THEN
2134: l_rslt_elmt := hxc_ext_timecard.OTL_TC_DELTED;
2135: ELSIF p_short_name = 'OTL_DAY' THEN
2136: l_rslt_elmt := apply_format_mask
2137: (hxc_ext_timecard.OTL_DAY, p_frmt_mask_cd);
2138: ELSIF p_short_name = 'OTL_DAY_COMMENTS' THEN
2133: ELSIF p_short_name = 'OTL_TC_DELTED' THEN
2134: l_rslt_elmt := hxc_ext_timecard.OTL_TC_DELTED;
2135: ELSIF p_short_name = 'OTL_DAY' THEN
2136: l_rslt_elmt := apply_format_mask
2137: (hxc_ext_timecard.OTL_DAY, p_frmt_mask_cd);
2138: ELSIF p_short_name = 'OTL_DAY_COMMENTS' THEN
2139: l_rslt_elmt := hxc_ext_timecard.OTL_DAY_COMMENTS;
2140: ELSIF p_short_name = 'OTL_MEASURE' THEN
2141: l_rslt_elmt := hxc_ext_timecard.OTL_MEASURE;
2135: ELSIF p_short_name = 'OTL_DAY' THEN
2136: l_rslt_elmt := apply_format_mask
2137: (hxc_ext_timecard.OTL_DAY, p_frmt_mask_cd);
2138: ELSIF p_short_name = 'OTL_DAY_COMMENTS' THEN
2139: l_rslt_elmt := hxc_ext_timecard.OTL_DAY_COMMENTS;
2140: ELSIF p_short_name = 'OTL_MEASURE' THEN
2141: l_rslt_elmt := hxc_ext_timecard.OTL_MEASURE;
2142: ELSIF p_short_name = 'OTL_DAY_START' THEN
2143: l_rslt_elmt := apply_format_mask
2137: (hxc_ext_timecard.OTL_DAY, p_frmt_mask_cd);
2138: ELSIF p_short_name = 'OTL_DAY_COMMENTS' THEN
2139: l_rslt_elmt := hxc_ext_timecard.OTL_DAY_COMMENTS;
2140: ELSIF p_short_name = 'OTL_MEASURE' THEN
2141: l_rslt_elmt := hxc_ext_timecard.OTL_MEASURE;
2142: ELSIF p_short_name = 'OTL_DAY_START' THEN
2143: l_rslt_elmt := apply_format_mask
2144: (hxc_ext_timecard.OTL_DAY_START, p_frmt_mask_cd);
2145: ELSIF p_short_name = 'OTL_DAY_STOP' THEN
2140: ELSIF p_short_name = 'OTL_MEASURE' THEN
2141: l_rslt_elmt := hxc_ext_timecard.OTL_MEASURE;
2142: ELSIF p_short_name = 'OTL_DAY_START' THEN
2143: l_rslt_elmt := apply_format_mask
2144: (hxc_ext_timecard.OTL_DAY_START, p_frmt_mask_cd);
2145: ELSIF p_short_name = 'OTL_DAY_STOP' THEN
2146: l_rslt_elmt := apply_format_mask
2147: (hxc_ext_timecard.OTL_DAY_STOP, p_frmt_mask_cd);
2148: ELSIF p_short_name = 'OTL_PA_SYS_LINK_FUNCN' THEN
2143: l_rslt_elmt := apply_format_mask
2144: (hxc_ext_timecard.OTL_DAY_START, p_frmt_mask_cd);
2145: ELSIF p_short_name = 'OTL_DAY_STOP' THEN
2146: l_rslt_elmt := apply_format_mask
2147: (hxc_ext_timecard.OTL_DAY_STOP, p_frmt_mask_cd);
2148: ELSIF p_short_name = 'OTL_PA_SYS_LINK_FUNCN' THEN
2149: l_rslt_elmt := hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN;
2150: ELSIF p_short_name = 'OTL_PA_BILLABLE_FLAG' THEN
2151: l_rslt_elmt := hxc_ext_timecard.OTL_PA_BILLABLE_FLAG;
2145: ELSIF p_short_name = 'OTL_DAY_STOP' THEN
2146: l_rslt_elmt := apply_format_mask
2147: (hxc_ext_timecard.OTL_DAY_STOP, p_frmt_mask_cd);
2148: ELSIF p_short_name = 'OTL_PA_SYS_LINK_FUNCN' THEN
2149: l_rslt_elmt := hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN;
2150: ELSIF p_short_name = 'OTL_PA_BILLABLE_FLAG' THEN
2151: l_rslt_elmt := hxc_ext_timecard.OTL_PA_BILLABLE_FLAG;
2152: ELSIF p_short_name = 'OTL_PA_TASK' THEN
2153: l_rslt_elmt := hxc_ext_timecard.OTL_PA_TASK;
2147: (hxc_ext_timecard.OTL_DAY_STOP, p_frmt_mask_cd);
2148: ELSIF p_short_name = 'OTL_PA_SYS_LINK_FUNCN' THEN
2149: l_rslt_elmt := hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN;
2150: ELSIF p_short_name = 'OTL_PA_BILLABLE_FLAG' THEN
2151: l_rslt_elmt := hxc_ext_timecard.OTL_PA_BILLABLE_FLAG;
2152: ELSIF p_short_name = 'OTL_PA_TASK' THEN
2153: l_rslt_elmt := hxc_ext_timecard.OTL_PA_TASK;
2154: ELSIF p_short_name = 'OTL_PA_PROJECT' THEN
2155: l_rslt_elmt := hxc_ext_timecard.OTL_PA_PROJECT;
2149: l_rslt_elmt := hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN;
2150: ELSIF p_short_name = 'OTL_PA_BILLABLE_FLAG' THEN
2151: l_rslt_elmt := hxc_ext_timecard.OTL_PA_BILLABLE_FLAG;
2152: ELSIF p_short_name = 'OTL_PA_TASK' THEN
2153: l_rslt_elmt := hxc_ext_timecard.OTL_PA_TASK;
2154: ELSIF p_short_name = 'OTL_PA_PROJECT' THEN
2155: l_rslt_elmt := hxc_ext_timecard.OTL_PA_PROJECT;
2156: ELSIF p_short_name = 'OTL_PA_EXPENDITURE_TYPE' THEN
2157: l_rslt_elmt := hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE;
2151: l_rslt_elmt := hxc_ext_timecard.OTL_PA_BILLABLE_FLAG;
2152: ELSIF p_short_name = 'OTL_PA_TASK' THEN
2153: l_rslt_elmt := hxc_ext_timecard.OTL_PA_TASK;
2154: ELSIF p_short_name = 'OTL_PA_PROJECT' THEN
2155: l_rslt_elmt := hxc_ext_timecard.OTL_PA_PROJECT;
2156: ELSIF p_short_name = 'OTL_PA_EXPENDITURE_TYPE' THEN
2157: l_rslt_elmt := hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE;
2158: ELSIF p_short_name = 'OTL_PA_EXPENDITURE_COMMENT' THEN
2159: l_rslt_elmt := hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT;
2153: l_rslt_elmt := hxc_ext_timecard.OTL_PA_TASK;
2154: ELSIF p_short_name = 'OTL_PA_PROJECT' THEN
2155: l_rslt_elmt := hxc_ext_timecard.OTL_PA_PROJECT;
2156: ELSIF p_short_name = 'OTL_PA_EXPENDITURE_TYPE' THEN
2157: l_rslt_elmt := hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE;
2158: ELSIF p_short_name = 'OTL_PA_EXPENDITURE_COMMENT' THEN
2159: l_rslt_elmt := hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT;
2160: ELSIF p_short_name = 'OTL_PAY_ELEMENT_NAME' THEN
2161: l_rslt_elmt := hxc_ext_timecard.OTL_PAY_ELEMENT_NAME;
2155: l_rslt_elmt := hxc_ext_timecard.OTL_PA_PROJECT;
2156: ELSIF p_short_name = 'OTL_PA_EXPENDITURE_TYPE' THEN
2157: l_rslt_elmt := hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE;
2158: ELSIF p_short_name = 'OTL_PA_EXPENDITURE_COMMENT' THEN
2159: l_rslt_elmt := hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT;
2160: ELSIF p_short_name = 'OTL_PAY_ELEMENT_NAME' THEN
2161: l_rslt_elmt := hxc_ext_timecard.OTL_PAY_ELEMENT_NAME;
2162: ELSIF p_short_name = 'OTL_PAY_COST_CENTRE' THEN
2163: l_rslt_elmt := hxc_ext_timecard.OTL_PAY_COST_CENTRE;
2157: l_rslt_elmt := hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE;
2158: ELSIF p_short_name = 'OTL_PA_EXPENDITURE_COMMENT' THEN
2159: l_rslt_elmt := hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT;
2160: ELSIF p_short_name = 'OTL_PAY_ELEMENT_NAME' THEN
2161: l_rslt_elmt := hxc_ext_timecard.OTL_PAY_ELEMENT_NAME;
2162: ELSIF p_short_name = 'OTL_PAY_COST_CENTRE' THEN
2163: l_rslt_elmt := hxc_ext_timecard.OTL_PAY_COST_CENTRE;
2164: ELSIF p_short_name = 'OTL_PO_NUMBER' THEN
2165: l_rslt_elmt := hxc_ext_timecard.OTL_PO_NUMBER;
2159: l_rslt_elmt := hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT;
2160: ELSIF p_short_name = 'OTL_PAY_ELEMENT_NAME' THEN
2161: l_rslt_elmt := hxc_ext_timecard.OTL_PAY_ELEMENT_NAME;
2162: ELSIF p_short_name = 'OTL_PAY_COST_CENTRE' THEN
2163: l_rslt_elmt := hxc_ext_timecard.OTL_PAY_COST_CENTRE;
2164: ELSIF p_short_name = 'OTL_PO_NUMBER' THEN
2165: l_rslt_elmt := hxc_ext_timecard.OTL_PO_NUMBER;
2166: ELSIF p_short_name = 'OTL_PO_LINE_ID' THEN
2167: l_rslt_elmt := hxc_ext_timecard.OTL_PO_LINE_ID;
2161: l_rslt_elmt := hxc_ext_timecard.OTL_PAY_ELEMENT_NAME;
2162: ELSIF p_short_name = 'OTL_PAY_COST_CENTRE' THEN
2163: l_rslt_elmt := hxc_ext_timecard.OTL_PAY_COST_CENTRE;
2164: ELSIF p_short_name = 'OTL_PO_NUMBER' THEN
2165: l_rslt_elmt := hxc_ext_timecard.OTL_PO_NUMBER;
2166: ELSIF p_short_name = 'OTL_PO_LINE_ID' THEN
2167: l_rslt_elmt := hxc_ext_timecard.OTL_PO_LINE_ID;
2168: ELSIF p_short_name = 'OTL_PO_PRICE_TYPE' THEN
2169: l_rslt_elmt := hxc_ext_timecard.OTL_PO_PRICE_TYPE;
2163: l_rslt_elmt := hxc_ext_timecard.OTL_PAY_COST_CENTRE;
2164: ELSIF p_short_name = 'OTL_PO_NUMBER' THEN
2165: l_rslt_elmt := hxc_ext_timecard.OTL_PO_NUMBER;
2166: ELSIF p_short_name = 'OTL_PO_LINE_ID' THEN
2167: l_rslt_elmt := hxc_ext_timecard.OTL_PO_LINE_ID;
2168: ELSIF p_short_name = 'OTL_PO_PRICE_TYPE' THEN
2169: l_rslt_elmt := hxc_ext_timecard.OTL_PO_PRICE_TYPE;
2170: ELSIF p_short_name = 'OTL_ALIAS_ELEMENTS_EXP_SLF' THEN
2171: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF;
2165: l_rslt_elmt := hxc_ext_timecard.OTL_PO_NUMBER;
2166: ELSIF p_short_name = 'OTL_PO_LINE_ID' THEN
2167: l_rslt_elmt := hxc_ext_timecard.OTL_PO_LINE_ID;
2168: ELSIF p_short_name = 'OTL_PO_PRICE_TYPE' THEN
2169: l_rslt_elmt := hxc_ext_timecard.OTL_PO_PRICE_TYPE;
2170: ELSIF p_short_name = 'OTL_ALIAS_ELEMENTS_EXP_SLF' THEN
2171: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF;
2172: ELSIF p_short_name = 'OTL_ALIAS_EXPENDITURE_ELEMENTS' THEN
2173: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS;
2167: l_rslt_elmt := hxc_ext_timecard.OTL_PO_LINE_ID;
2168: ELSIF p_short_name = 'OTL_PO_PRICE_TYPE' THEN
2169: l_rslt_elmt := hxc_ext_timecard.OTL_PO_PRICE_TYPE;
2170: ELSIF p_short_name = 'OTL_ALIAS_ELEMENTS_EXP_SLF' THEN
2171: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF;
2172: ELSIF p_short_name = 'OTL_ALIAS_EXPENDITURE_ELEMENTS' THEN
2173: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS;
2174: ELSIF p_short_name = 'OTL_ALIAS_EXPENDITURE_TYPES' THEN
2175: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES;
2169: l_rslt_elmt := hxc_ext_timecard.OTL_PO_PRICE_TYPE;
2170: ELSIF p_short_name = 'OTL_ALIAS_ELEMENTS_EXP_SLF' THEN
2171: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF;
2172: ELSIF p_short_name = 'OTL_ALIAS_EXPENDITURE_ELEMENTS' THEN
2173: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS;
2174: ELSIF p_short_name = 'OTL_ALIAS_EXPENDITURE_TYPES' THEN
2175: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES;
2176: ELSIF p_short_name = 'OTL_ALIAS_LOCATIONS' THEN
2177: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_LOCATIONS;
2171: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF;
2172: ELSIF p_short_name = 'OTL_ALIAS_EXPENDITURE_ELEMENTS' THEN
2173: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS;
2174: ELSIF p_short_name = 'OTL_ALIAS_EXPENDITURE_TYPES' THEN
2175: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES;
2176: ELSIF p_short_name = 'OTL_ALIAS_LOCATIONS' THEN
2177: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_LOCATIONS;
2178: ELSIF p_short_name = 'OTL_ALIAS_PAYROLL_ELEMENTS' THEN
2179: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS;
2173: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS;
2174: ELSIF p_short_name = 'OTL_ALIAS_EXPENDITURE_TYPES' THEN
2175: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES;
2176: ELSIF p_short_name = 'OTL_ALIAS_LOCATIONS' THEN
2177: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_LOCATIONS;
2178: ELSIF p_short_name = 'OTL_ALIAS_PAYROLL_ELEMENTS' THEN
2179: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS;
2180: ELSIF p_short_name = 'OTL_ALIAS_PROJECTS' THEN
2181: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_PROJECTS;
2175: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES;
2176: ELSIF p_short_name = 'OTL_ALIAS_LOCATIONS' THEN
2177: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_LOCATIONS;
2178: ELSIF p_short_name = 'OTL_ALIAS_PAYROLL_ELEMENTS' THEN
2179: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS;
2180: ELSIF p_short_name = 'OTL_ALIAS_PROJECTS' THEN
2181: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_PROJECTS;
2182: ELSIF p_short_name = 'OTL_ALIAS_TASKS' THEN
2183: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_TASKS;
2177: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_LOCATIONS;
2178: ELSIF p_short_name = 'OTL_ALIAS_PAYROLL_ELEMENTS' THEN
2179: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS;
2180: ELSIF p_short_name = 'OTL_ALIAS_PROJECTS' THEN
2181: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_PROJECTS;
2182: ELSIF p_short_name = 'OTL_ALIAS_TASKS' THEN
2183: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_TASKS;
2184: ELSIF p_short_name = 'OTL_ALIAS_RATE_TYPE_EXP_SLF' THEN
2185: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF;
2179: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS;
2180: ELSIF p_short_name = 'OTL_ALIAS_PROJECTS' THEN
2181: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_PROJECTS;
2182: ELSIF p_short_name = 'OTL_ALIAS_TASKS' THEN
2183: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_TASKS;
2184: ELSIF p_short_name = 'OTL_ALIAS_RATE_TYPE_EXP_SLF' THEN
2185: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF;
2186: END IF;
2187:
2181: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_PROJECTS;
2182: ELSIF p_short_name = 'OTL_ALIAS_TASKS' THEN
2183: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_TASKS;
2184: ELSIF p_short_name = 'OTL_ALIAS_RATE_TYPE_EXP_SLF' THEN
2185: l_rslt_elmt := hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF;
2186: END IF;
2187:
2188: elsif p_one_char_substr = 'P' then
2189: if p_two_char_substr = 'PA' then