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.HR_ITEM_PROPERTIES_PKG dependencies on HR_API

Line 123: ALIGNMENT = decode(nvl(ALIGNMENT,hr_api.g_number),nvl(l_original.ALIGNMENT,hr_api.g_number),X_ALIGNMENT,ALIGNMENT),

119: if csr_original%found then
120: close csr_original;
121: for l_copy in csr_copies loop
122: update HR_ITEM_PROPERTIES_B set
123: ALIGNMENT = decode(nvl(ALIGNMENT,hr_api.g_number),nvl(l_original.ALIGNMENT,hr_api.g_number),X_ALIGNMENT,ALIGNMENT),
124: BEVEL = decode(nvl(BEVEL,hr_api.g_number),nvl(l_original.BEVEL,hr_api.g_number),X_BEVEL,BEVEL),
125: CASE_RESTRICTION = decode(nvl(CASE_RESTRICTION,hr_api.g_number),nvl(l_original.CASE_RESTRICTION,hr_api.g_number),X_CASE_RESTRICTION,CASE_RESTRICTION),
126: ENABLED = decode(nvl(ENABLED,hr_api.g_number),nvl(l_original.ENABLED,hr_api.g_number),X_ENABLED,ENABLED),
127: FORMAT_MASK = decode(nvl(FORMAT_MASK,hr_api.g_varchar2),nvl(l_original.FORMAT_MASK,hr_api.g_varchar2),X_FORMAT_MASK,FORMAT_MASK),

Line 124: BEVEL = decode(nvl(BEVEL,hr_api.g_number),nvl(l_original.BEVEL,hr_api.g_number),X_BEVEL,BEVEL),

120: close csr_original;
121: for l_copy in csr_copies loop
122: update HR_ITEM_PROPERTIES_B set
123: ALIGNMENT = decode(nvl(ALIGNMENT,hr_api.g_number),nvl(l_original.ALIGNMENT,hr_api.g_number),X_ALIGNMENT,ALIGNMENT),
124: BEVEL = decode(nvl(BEVEL,hr_api.g_number),nvl(l_original.BEVEL,hr_api.g_number),X_BEVEL,BEVEL),
125: CASE_RESTRICTION = decode(nvl(CASE_RESTRICTION,hr_api.g_number),nvl(l_original.CASE_RESTRICTION,hr_api.g_number),X_CASE_RESTRICTION,CASE_RESTRICTION),
126: ENABLED = decode(nvl(ENABLED,hr_api.g_number),nvl(l_original.ENABLED,hr_api.g_number),X_ENABLED,ENABLED),
127: FORMAT_MASK = decode(nvl(FORMAT_MASK,hr_api.g_varchar2),nvl(l_original.FORMAT_MASK,hr_api.g_varchar2),X_FORMAT_MASK,FORMAT_MASK),
128: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),

Line 125: CASE_RESTRICTION = decode(nvl(CASE_RESTRICTION,hr_api.g_number),nvl(l_original.CASE_RESTRICTION,hr_api.g_number),X_CASE_RESTRICTION,CASE_RESTRICTION),

121: for l_copy in csr_copies loop
122: update HR_ITEM_PROPERTIES_B set
123: ALIGNMENT = decode(nvl(ALIGNMENT,hr_api.g_number),nvl(l_original.ALIGNMENT,hr_api.g_number),X_ALIGNMENT,ALIGNMENT),
124: BEVEL = decode(nvl(BEVEL,hr_api.g_number),nvl(l_original.BEVEL,hr_api.g_number),X_BEVEL,BEVEL),
125: CASE_RESTRICTION = decode(nvl(CASE_RESTRICTION,hr_api.g_number),nvl(l_original.CASE_RESTRICTION,hr_api.g_number),X_CASE_RESTRICTION,CASE_RESTRICTION),
126: ENABLED = decode(nvl(ENABLED,hr_api.g_number),nvl(l_original.ENABLED,hr_api.g_number),X_ENABLED,ENABLED),
127: FORMAT_MASK = decode(nvl(FORMAT_MASK,hr_api.g_varchar2),nvl(l_original.FORMAT_MASK,hr_api.g_varchar2),X_FORMAT_MASK,FORMAT_MASK),
128: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
129: INFORMATION_FORMULA_ID = decode(nvl(INFORMATION_FORMULA_ID,hr_api.g_number),nvl(l_original.INFORMATION_FORMULA_ID,hr_api.g_number),X_INFORMATION_FORMULA_ID,INFORMATION_FORMULA_ID),

Line 126: ENABLED = decode(nvl(ENABLED,hr_api.g_number),nvl(l_original.ENABLED,hr_api.g_number),X_ENABLED,ENABLED),

122: update HR_ITEM_PROPERTIES_B set
123: ALIGNMENT = decode(nvl(ALIGNMENT,hr_api.g_number),nvl(l_original.ALIGNMENT,hr_api.g_number),X_ALIGNMENT,ALIGNMENT),
124: BEVEL = decode(nvl(BEVEL,hr_api.g_number),nvl(l_original.BEVEL,hr_api.g_number),X_BEVEL,BEVEL),
125: CASE_RESTRICTION = decode(nvl(CASE_RESTRICTION,hr_api.g_number),nvl(l_original.CASE_RESTRICTION,hr_api.g_number),X_CASE_RESTRICTION,CASE_RESTRICTION),
126: ENABLED = decode(nvl(ENABLED,hr_api.g_number),nvl(l_original.ENABLED,hr_api.g_number),X_ENABLED,ENABLED),
127: FORMAT_MASK = decode(nvl(FORMAT_MASK,hr_api.g_varchar2),nvl(l_original.FORMAT_MASK,hr_api.g_varchar2),X_FORMAT_MASK,FORMAT_MASK),
128: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
129: INFORMATION_FORMULA_ID = decode(nvl(INFORMATION_FORMULA_ID,hr_api.g_number),nvl(l_original.INFORMATION_FORMULA_ID,hr_api.g_number),X_INFORMATION_FORMULA_ID,INFORMATION_FORMULA_ID),
130: INFORMATION_PARAMETER_ITEM_ID1 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID1,INFORMATION_PARAMETER_ITEM_ID1),

Line 127: FORMAT_MASK = decode(nvl(FORMAT_MASK,hr_api.g_varchar2),nvl(l_original.FORMAT_MASK,hr_api.g_varchar2),X_FORMAT_MASK,FORMAT_MASK),

123: ALIGNMENT = decode(nvl(ALIGNMENT,hr_api.g_number),nvl(l_original.ALIGNMENT,hr_api.g_number),X_ALIGNMENT,ALIGNMENT),
124: BEVEL = decode(nvl(BEVEL,hr_api.g_number),nvl(l_original.BEVEL,hr_api.g_number),X_BEVEL,BEVEL),
125: CASE_RESTRICTION = decode(nvl(CASE_RESTRICTION,hr_api.g_number),nvl(l_original.CASE_RESTRICTION,hr_api.g_number),X_CASE_RESTRICTION,CASE_RESTRICTION),
126: ENABLED = decode(nvl(ENABLED,hr_api.g_number),nvl(l_original.ENABLED,hr_api.g_number),X_ENABLED,ENABLED),
127: FORMAT_MASK = decode(nvl(FORMAT_MASK,hr_api.g_varchar2),nvl(l_original.FORMAT_MASK,hr_api.g_varchar2),X_FORMAT_MASK,FORMAT_MASK),
128: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
129: INFORMATION_FORMULA_ID = decode(nvl(INFORMATION_FORMULA_ID,hr_api.g_number),nvl(l_original.INFORMATION_FORMULA_ID,hr_api.g_number),X_INFORMATION_FORMULA_ID,INFORMATION_FORMULA_ID),
130: INFORMATION_PARAMETER_ITEM_ID1 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID1,INFORMATION_PARAMETER_ITEM_ID1),
131: INFORMATION_PARAMETER_ITEM_ID2 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID2,INFORMATION_PARAMETER_ITEM_ID2),

Line 128: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),

124: BEVEL = decode(nvl(BEVEL,hr_api.g_number),nvl(l_original.BEVEL,hr_api.g_number),X_BEVEL,BEVEL),
125: CASE_RESTRICTION = decode(nvl(CASE_RESTRICTION,hr_api.g_number),nvl(l_original.CASE_RESTRICTION,hr_api.g_number),X_CASE_RESTRICTION,CASE_RESTRICTION),
126: ENABLED = decode(nvl(ENABLED,hr_api.g_number),nvl(l_original.ENABLED,hr_api.g_number),X_ENABLED,ENABLED),
127: FORMAT_MASK = decode(nvl(FORMAT_MASK,hr_api.g_varchar2),nvl(l_original.FORMAT_MASK,hr_api.g_varchar2),X_FORMAT_MASK,FORMAT_MASK),
128: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
129: INFORMATION_FORMULA_ID = decode(nvl(INFORMATION_FORMULA_ID,hr_api.g_number),nvl(l_original.INFORMATION_FORMULA_ID,hr_api.g_number),X_INFORMATION_FORMULA_ID,INFORMATION_FORMULA_ID),
130: INFORMATION_PARAMETER_ITEM_ID1 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID1,INFORMATION_PARAMETER_ITEM_ID1),
131: INFORMATION_PARAMETER_ITEM_ID2 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID2,INFORMATION_PARAMETER_ITEM_ID2),
132: INFORMATION_PARAMETER_ITEM_ID3 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID3,INFORMATION_PARAMETER_ITEM_ID3),

Line 129: INFORMATION_FORMULA_ID = decode(nvl(INFORMATION_FORMULA_ID,hr_api.g_number),nvl(l_original.INFORMATION_FORMULA_ID,hr_api.g_number),X_INFORMATION_FORMULA_ID,INFORMATION_FORMULA_ID),

125: CASE_RESTRICTION = decode(nvl(CASE_RESTRICTION,hr_api.g_number),nvl(l_original.CASE_RESTRICTION,hr_api.g_number),X_CASE_RESTRICTION,CASE_RESTRICTION),
126: ENABLED = decode(nvl(ENABLED,hr_api.g_number),nvl(l_original.ENABLED,hr_api.g_number),X_ENABLED,ENABLED),
127: FORMAT_MASK = decode(nvl(FORMAT_MASK,hr_api.g_varchar2),nvl(l_original.FORMAT_MASK,hr_api.g_varchar2),X_FORMAT_MASK,FORMAT_MASK),
128: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
129: INFORMATION_FORMULA_ID = decode(nvl(INFORMATION_FORMULA_ID,hr_api.g_number),nvl(l_original.INFORMATION_FORMULA_ID,hr_api.g_number),X_INFORMATION_FORMULA_ID,INFORMATION_FORMULA_ID),
130: INFORMATION_PARAMETER_ITEM_ID1 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID1,INFORMATION_PARAMETER_ITEM_ID1),
131: INFORMATION_PARAMETER_ITEM_ID2 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID2,INFORMATION_PARAMETER_ITEM_ID2),
132: INFORMATION_PARAMETER_ITEM_ID3 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID3,INFORMATION_PARAMETER_ITEM_ID3),
133: INFORMATION_PARAMETER_ITEM_ID4 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID4,INFORMATION_PARAMETER_ITEM_ID4),

Line 130: INFORMATION_PARAMETER_ITEM_ID1 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID1,INFORMATION_PARAMETER_ITEM_ID1),

126: ENABLED = decode(nvl(ENABLED,hr_api.g_number),nvl(l_original.ENABLED,hr_api.g_number),X_ENABLED,ENABLED),
127: FORMAT_MASK = decode(nvl(FORMAT_MASK,hr_api.g_varchar2),nvl(l_original.FORMAT_MASK,hr_api.g_varchar2),X_FORMAT_MASK,FORMAT_MASK),
128: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
129: INFORMATION_FORMULA_ID = decode(nvl(INFORMATION_FORMULA_ID,hr_api.g_number),nvl(l_original.INFORMATION_FORMULA_ID,hr_api.g_number),X_INFORMATION_FORMULA_ID,INFORMATION_FORMULA_ID),
130: INFORMATION_PARAMETER_ITEM_ID1 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID1,INFORMATION_PARAMETER_ITEM_ID1),
131: INFORMATION_PARAMETER_ITEM_ID2 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID2,INFORMATION_PARAMETER_ITEM_ID2),
132: INFORMATION_PARAMETER_ITEM_ID3 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID3,INFORMATION_PARAMETER_ITEM_ID3),
133: INFORMATION_PARAMETER_ITEM_ID4 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID4,INFORMATION_PARAMETER_ITEM_ID4),
134: INFORMATION_PARAMETER_ITEM_ID5 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID5,INFORMATION_PARAMETER_ITEM_ID5),

Line 131: INFORMATION_PARAMETER_ITEM_ID2 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID2,INFORMATION_PARAMETER_ITEM_ID2),

127: FORMAT_MASK = decode(nvl(FORMAT_MASK,hr_api.g_varchar2),nvl(l_original.FORMAT_MASK,hr_api.g_varchar2),X_FORMAT_MASK,FORMAT_MASK),
128: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
129: INFORMATION_FORMULA_ID = decode(nvl(INFORMATION_FORMULA_ID,hr_api.g_number),nvl(l_original.INFORMATION_FORMULA_ID,hr_api.g_number),X_INFORMATION_FORMULA_ID,INFORMATION_FORMULA_ID),
130: INFORMATION_PARAMETER_ITEM_ID1 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID1,INFORMATION_PARAMETER_ITEM_ID1),
131: INFORMATION_PARAMETER_ITEM_ID2 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID2,INFORMATION_PARAMETER_ITEM_ID2),
132: INFORMATION_PARAMETER_ITEM_ID3 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID3,INFORMATION_PARAMETER_ITEM_ID3),
133: INFORMATION_PARAMETER_ITEM_ID4 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID4,INFORMATION_PARAMETER_ITEM_ID4),
134: INFORMATION_PARAMETER_ITEM_ID5 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID5,INFORMATION_PARAMETER_ITEM_ID5),
135: INSERT_ALLOWED = decode(nvl(INSERT_ALLOWED,hr_api.g_number),nvl(l_original.INSERT_ALLOWED,hr_api.g_number),X_INSERT_ALLOWED,INSERT_ALLOWED),

Line 132: INFORMATION_PARAMETER_ITEM_ID3 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID3,INFORMATION_PARAMETER_ITEM_ID3),

128: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
129: INFORMATION_FORMULA_ID = decode(nvl(INFORMATION_FORMULA_ID,hr_api.g_number),nvl(l_original.INFORMATION_FORMULA_ID,hr_api.g_number),X_INFORMATION_FORMULA_ID,INFORMATION_FORMULA_ID),
130: INFORMATION_PARAMETER_ITEM_ID1 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID1,INFORMATION_PARAMETER_ITEM_ID1),
131: INFORMATION_PARAMETER_ITEM_ID2 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID2,INFORMATION_PARAMETER_ITEM_ID2),
132: INFORMATION_PARAMETER_ITEM_ID3 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID3,INFORMATION_PARAMETER_ITEM_ID3),
133: INFORMATION_PARAMETER_ITEM_ID4 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID4,INFORMATION_PARAMETER_ITEM_ID4),
134: INFORMATION_PARAMETER_ITEM_ID5 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID5,INFORMATION_PARAMETER_ITEM_ID5),
135: INSERT_ALLOWED = decode(nvl(INSERT_ALLOWED,hr_api.g_number),nvl(l_original.INSERT_ALLOWED,hr_api.g_number),X_INSERT_ALLOWED,INSERT_ALLOWED),
136: NEXT_NAVIGATION_ITEM_ID = decode(nvl(NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),X_NEXT_NAVIGATION_ITEM_ID,NEXT_NAVIGATION_ITEM_ID),

Line 133: INFORMATION_PARAMETER_ITEM_ID4 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID4,INFORMATION_PARAMETER_ITEM_ID4),

129: INFORMATION_FORMULA_ID = decode(nvl(INFORMATION_FORMULA_ID,hr_api.g_number),nvl(l_original.INFORMATION_FORMULA_ID,hr_api.g_number),X_INFORMATION_FORMULA_ID,INFORMATION_FORMULA_ID),
130: INFORMATION_PARAMETER_ITEM_ID1 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID1,INFORMATION_PARAMETER_ITEM_ID1),
131: INFORMATION_PARAMETER_ITEM_ID2 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID2,INFORMATION_PARAMETER_ITEM_ID2),
132: INFORMATION_PARAMETER_ITEM_ID3 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID3,INFORMATION_PARAMETER_ITEM_ID3),
133: INFORMATION_PARAMETER_ITEM_ID4 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID4,INFORMATION_PARAMETER_ITEM_ID4),
134: INFORMATION_PARAMETER_ITEM_ID5 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID5,INFORMATION_PARAMETER_ITEM_ID5),
135: INSERT_ALLOWED = decode(nvl(INSERT_ALLOWED,hr_api.g_number),nvl(l_original.INSERT_ALLOWED,hr_api.g_number),X_INSERT_ALLOWED,INSERT_ALLOWED),
136: NEXT_NAVIGATION_ITEM_ID = decode(nvl(NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),X_NEXT_NAVIGATION_ITEM_ID,NEXT_NAVIGATION_ITEM_ID),
137: PREVIOUS_NAVIGATION_ITEM_ID = decode(nvl(PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),X_PREVIOUS_NAVIGATION_ITEM_ID,PREVIOUS_NAVIGATION_ITEM_ID),

Line 134: INFORMATION_PARAMETER_ITEM_ID5 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID5,INFORMATION_PARAMETER_ITEM_ID5),

130: INFORMATION_PARAMETER_ITEM_ID1 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID1,INFORMATION_PARAMETER_ITEM_ID1),
131: INFORMATION_PARAMETER_ITEM_ID2 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID2,INFORMATION_PARAMETER_ITEM_ID2),
132: INFORMATION_PARAMETER_ITEM_ID3 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID3,INFORMATION_PARAMETER_ITEM_ID3),
133: INFORMATION_PARAMETER_ITEM_ID4 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID4,INFORMATION_PARAMETER_ITEM_ID4),
134: INFORMATION_PARAMETER_ITEM_ID5 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID5,INFORMATION_PARAMETER_ITEM_ID5),
135: INSERT_ALLOWED = decode(nvl(INSERT_ALLOWED,hr_api.g_number),nvl(l_original.INSERT_ALLOWED,hr_api.g_number),X_INSERT_ALLOWED,INSERT_ALLOWED),
136: NEXT_NAVIGATION_ITEM_ID = decode(nvl(NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),X_NEXT_NAVIGATION_ITEM_ID,NEXT_NAVIGATION_ITEM_ID),
137: PREVIOUS_NAVIGATION_ITEM_ID = decode(nvl(PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),X_PREVIOUS_NAVIGATION_ITEM_ID,PREVIOUS_NAVIGATION_ITEM_ID),
138: PROMPT_ALIGNMENT_OFFSET = decode(nvl(PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),X_PROMPT_ALIGNMENT_OFFSET,PROMPT_ALIGNMENT_OFFSET),

Line 135: INSERT_ALLOWED = decode(nvl(INSERT_ALLOWED,hr_api.g_number),nvl(l_original.INSERT_ALLOWED,hr_api.g_number),X_INSERT_ALLOWED,INSERT_ALLOWED),

131: INFORMATION_PARAMETER_ITEM_ID2 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID2,INFORMATION_PARAMETER_ITEM_ID2),
132: INFORMATION_PARAMETER_ITEM_ID3 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID3,INFORMATION_PARAMETER_ITEM_ID3),
133: INFORMATION_PARAMETER_ITEM_ID4 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID4,INFORMATION_PARAMETER_ITEM_ID4),
134: INFORMATION_PARAMETER_ITEM_ID5 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID5,INFORMATION_PARAMETER_ITEM_ID5),
135: INSERT_ALLOWED = decode(nvl(INSERT_ALLOWED,hr_api.g_number),nvl(l_original.INSERT_ALLOWED,hr_api.g_number),X_INSERT_ALLOWED,INSERT_ALLOWED),
136: NEXT_NAVIGATION_ITEM_ID = decode(nvl(NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),X_NEXT_NAVIGATION_ITEM_ID,NEXT_NAVIGATION_ITEM_ID),
137: PREVIOUS_NAVIGATION_ITEM_ID = decode(nvl(PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),X_PREVIOUS_NAVIGATION_ITEM_ID,PREVIOUS_NAVIGATION_ITEM_ID),
138: PROMPT_ALIGNMENT_OFFSET = decode(nvl(PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),X_PROMPT_ALIGNMENT_OFFSET,PROMPT_ALIGNMENT_OFFSET),
139: PROMPT_DISPLAY_STYLE = decode(nvl(PROMPT_DISPLAY_STYLE,hr_api.g_number),nvl(l_original.PROMPT_DISPLAY_STYLE,hr_api.g_number),X_PROMPT_DISPLAY_STYLE,PROMPT_DISPLAY_STYLE),

Line 136: NEXT_NAVIGATION_ITEM_ID = decode(nvl(NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),X_NEXT_NAVIGATION_ITEM_ID,NEXT_NAVIGATION_ITEM_ID),

132: INFORMATION_PARAMETER_ITEM_ID3 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID3,INFORMATION_PARAMETER_ITEM_ID3),
133: INFORMATION_PARAMETER_ITEM_ID4 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID4,INFORMATION_PARAMETER_ITEM_ID4),
134: INFORMATION_PARAMETER_ITEM_ID5 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID5,INFORMATION_PARAMETER_ITEM_ID5),
135: INSERT_ALLOWED = decode(nvl(INSERT_ALLOWED,hr_api.g_number),nvl(l_original.INSERT_ALLOWED,hr_api.g_number),X_INSERT_ALLOWED,INSERT_ALLOWED),
136: NEXT_NAVIGATION_ITEM_ID = decode(nvl(NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),X_NEXT_NAVIGATION_ITEM_ID,NEXT_NAVIGATION_ITEM_ID),
137: PREVIOUS_NAVIGATION_ITEM_ID = decode(nvl(PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),X_PREVIOUS_NAVIGATION_ITEM_ID,PREVIOUS_NAVIGATION_ITEM_ID),
138: PROMPT_ALIGNMENT_OFFSET = decode(nvl(PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),X_PROMPT_ALIGNMENT_OFFSET,PROMPT_ALIGNMENT_OFFSET),
139: PROMPT_DISPLAY_STYLE = decode(nvl(PROMPT_DISPLAY_STYLE,hr_api.g_number),nvl(l_original.PROMPT_DISPLAY_STYLE,hr_api.g_number),X_PROMPT_DISPLAY_STYLE,PROMPT_DISPLAY_STYLE),
140: PROMPT_EDGE = decode(nvl(PROMPT_EDGE,hr_api.g_number),nvl(l_original.PROMPT_EDGE,hr_api.g_number),X_PROMPT_EDGE,PROMPT_EDGE),

Line 137: PREVIOUS_NAVIGATION_ITEM_ID = decode(nvl(PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),X_PREVIOUS_NAVIGATION_ITEM_ID,PREVIOUS_NAVIGATION_ITEM_ID),

133: INFORMATION_PARAMETER_ITEM_ID4 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID4,INFORMATION_PARAMETER_ITEM_ID4),
134: INFORMATION_PARAMETER_ITEM_ID5 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID5,INFORMATION_PARAMETER_ITEM_ID5),
135: INSERT_ALLOWED = decode(nvl(INSERT_ALLOWED,hr_api.g_number),nvl(l_original.INSERT_ALLOWED,hr_api.g_number),X_INSERT_ALLOWED,INSERT_ALLOWED),
136: NEXT_NAVIGATION_ITEM_ID = decode(nvl(NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),X_NEXT_NAVIGATION_ITEM_ID,NEXT_NAVIGATION_ITEM_ID),
137: PREVIOUS_NAVIGATION_ITEM_ID = decode(nvl(PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),X_PREVIOUS_NAVIGATION_ITEM_ID,PREVIOUS_NAVIGATION_ITEM_ID),
138: PROMPT_ALIGNMENT_OFFSET = decode(nvl(PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),X_PROMPT_ALIGNMENT_OFFSET,PROMPT_ALIGNMENT_OFFSET),
139: PROMPT_DISPLAY_STYLE = decode(nvl(PROMPT_DISPLAY_STYLE,hr_api.g_number),nvl(l_original.PROMPT_DISPLAY_STYLE,hr_api.g_number),X_PROMPT_DISPLAY_STYLE,PROMPT_DISPLAY_STYLE),
140: PROMPT_EDGE = decode(nvl(PROMPT_EDGE,hr_api.g_number),nvl(l_original.PROMPT_EDGE,hr_api.g_number),X_PROMPT_EDGE,PROMPT_EDGE),
141: PROMPT_EDGE_OFFSET = decode(nvl(PROMPT_EDGE_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_EDGE_OFFSET,hr_api.g_number),X_PROMPT_EDGE_OFFSET,PROMPT_EDGE_OFFSET),

Line 138: PROMPT_ALIGNMENT_OFFSET = decode(nvl(PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),X_PROMPT_ALIGNMENT_OFFSET,PROMPT_ALIGNMENT_OFFSET),

134: INFORMATION_PARAMETER_ITEM_ID5 = decode(nvl(INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.INFORMATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_INFORMATION_PARAM_ITEM_ID5,INFORMATION_PARAMETER_ITEM_ID5),
135: INSERT_ALLOWED = decode(nvl(INSERT_ALLOWED,hr_api.g_number),nvl(l_original.INSERT_ALLOWED,hr_api.g_number),X_INSERT_ALLOWED,INSERT_ALLOWED),
136: NEXT_NAVIGATION_ITEM_ID = decode(nvl(NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),X_NEXT_NAVIGATION_ITEM_ID,NEXT_NAVIGATION_ITEM_ID),
137: PREVIOUS_NAVIGATION_ITEM_ID = decode(nvl(PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),X_PREVIOUS_NAVIGATION_ITEM_ID,PREVIOUS_NAVIGATION_ITEM_ID),
138: PROMPT_ALIGNMENT_OFFSET = decode(nvl(PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),X_PROMPT_ALIGNMENT_OFFSET,PROMPT_ALIGNMENT_OFFSET),
139: PROMPT_DISPLAY_STYLE = decode(nvl(PROMPT_DISPLAY_STYLE,hr_api.g_number),nvl(l_original.PROMPT_DISPLAY_STYLE,hr_api.g_number),X_PROMPT_DISPLAY_STYLE,PROMPT_DISPLAY_STYLE),
140: PROMPT_EDGE = decode(nvl(PROMPT_EDGE,hr_api.g_number),nvl(l_original.PROMPT_EDGE,hr_api.g_number),X_PROMPT_EDGE,PROMPT_EDGE),
141: PROMPT_EDGE_OFFSET = decode(nvl(PROMPT_EDGE_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_EDGE_OFFSET,hr_api.g_number),X_PROMPT_EDGE_OFFSET,PROMPT_EDGE_OFFSET),
142: PROMPT_EDGE_ALIGNMENT = decode(nvl(PROMPT_EDGE_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_EDGE_ALIGNMENT,hr_api.g_number),X_PROMPT_EDGE_ALIGNMENT,PROMPT_EDGE_ALIGNMENT),

Line 139: PROMPT_DISPLAY_STYLE = decode(nvl(PROMPT_DISPLAY_STYLE,hr_api.g_number),nvl(l_original.PROMPT_DISPLAY_STYLE,hr_api.g_number),X_PROMPT_DISPLAY_STYLE,PROMPT_DISPLAY_STYLE),

135: INSERT_ALLOWED = decode(nvl(INSERT_ALLOWED,hr_api.g_number),nvl(l_original.INSERT_ALLOWED,hr_api.g_number),X_INSERT_ALLOWED,INSERT_ALLOWED),
136: NEXT_NAVIGATION_ITEM_ID = decode(nvl(NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),X_NEXT_NAVIGATION_ITEM_ID,NEXT_NAVIGATION_ITEM_ID),
137: PREVIOUS_NAVIGATION_ITEM_ID = decode(nvl(PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),X_PREVIOUS_NAVIGATION_ITEM_ID,PREVIOUS_NAVIGATION_ITEM_ID),
138: PROMPT_ALIGNMENT_OFFSET = decode(nvl(PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),X_PROMPT_ALIGNMENT_OFFSET,PROMPT_ALIGNMENT_OFFSET),
139: PROMPT_DISPLAY_STYLE = decode(nvl(PROMPT_DISPLAY_STYLE,hr_api.g_number),nvl(l_original.PROMPT_DISPLAY_STYLE,hr_api.g_number),X_PROMPT_DISPLAY_STYLE,PROMPT_DISPLAY_STYLE),
140: PROMPT_EDGE = decode(nvl(PROMPT_EDGE,hr_api.g_number),nvl(l_original.PROMPT_EDGE,hr_api.g_number),X_PROMPT_EDGE,PROMPT_EDGE),
141: PROMPT_EDGE_OFFSET = decode(nvl(PROMPT_EDGE_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_EDGE_OFFSET,hr_api.g_number),X_PROMPT_EDGE_OFFSET,PROMPT_EDGE_OFFSET),
142: PROMPT_EDGE_ALIGNMENT = decode(nvl(PROMPT_EDGE_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_EDGE_ALIGNMENT,hr_api.g_number),X_PROMPT_EDGE_ALIGNMENT,PROMPT_EDGE_ALIGNMENT),
143: PROMPT_TEXT_ALIGNMENT = decode(nvl(PROMPT_TEXT_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_TEXT_ALIGNMENT,hr_api.g_number),X_PROMPT_TEXT_ALIGNMENT,PROMPT_TEXT_ALIGNMENT),

Line 140: PROMPT_EDGE = decode(nvl(PROMPT_EDGE,hr_api.g_number),nvl(l_original.PROMPT_EDGE,hr_api.g_number),X_PROMPT_EDGE,PROMPT_EDGE),

136: NEXT_NAVIGATION_ITEM_ID = decode(nvl(NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.NEXT_NAVIGATION_ITEM_ID,hr_api.g_number),X_NEXT_NAVIGATION_ITEM_ID,NEXT_NAVIGATION_ITEM_ID),
137: PREVIOUS_NAVIGATION_ITEM_ID = decode(nvl(PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),X_PREVIOUS_NAVIGATION_ITEM_ID,PREVIOUS_NAVIGATION_ITEM_ID),
138: PROMPT_ALIGNMENT_OFFSET = decode(nvl(PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),X_PROMPT_ALIGNMENT_OFFSET,PROMPT_ALIGNMENT_OFFSET),
139: PROMPT_DISPLAY_STYLE = decode(nvl(PROMPT_DISPLAY_STYLE,hr_api.g_number),nvl(l_original.PROMPT_DISPLAY_STYLE,hr_api.g_number),X_PROMPT_DISPLAY_STYLE,PROMPT_DISPLAY_STYLE),
140: PROMPT_EDGE = decode(nvl(PROMPT_EDGE,hr_api.g_number),nvl(l_original.PROMPT_EDGE,hr_api.g_number),X_PROMPT_EDGE,PROMPT_EDGE),
141: PROMPT_EDGE_OFFSET = decode(nvl(PROMPT_EDGE_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_EDGE_OFFSET,hr_api.g_number),X_PROMPT_EDGE_OFFSET,PROMPT_EDGE_OFFSET),
142: PROMPT_EDGE_ALIGNMENT = decode(nvl(PROMPT_EDGE_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_EDGE_ALIGNMENT,hr_api.g_number),X_PROMPT_EDGE_ALIGNMENT,PROMPT_EDGE_ALIGNMENT),
143: PROMPT_TEXT_ALIGNMENT = decode(nvl(PROMPT_TEXT_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_TEXT_ALIGNMENT,hr_api.g_number),X_PROMPT_TEXT_ALIGNMENT,PROMPT_TEXT_ALIGNMENT),
144: QUERY_ALLOWED = decode(nvl(QUERY_ALLOWED,hr_api.g_number),nvl(l_original.QUERY_ALLOWED,hr_api.g_number),X_QUERY_ALLOWED,QUERY_ALLOWED),

Line 141: PROMPT_EDGE_OFFSET = decode(nvl(PROMPT_EDGE_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_EDGE_OFFSET,hr_api.g_number),X_PROMPT_EDGE_OFFSET,PROMPT_EDGE_OFFSET),

137: PREVIOUS_NAVIGATION_ITEM_ID = decode(nvl(PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),nvl(l_original.PREVIOUS_NAVIGATION_ITEM_ID,hr_api.g_number),X_PREVIOUS_NAVIGATION_ITEM_ID,PREVIOUS_NAVIGATION_ITEM_ID),
138: PROMPT_ALIGNMENT_OFFSET = decode(nvl(PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),X_PROMPT_ALIGNMENT_OFFSET,PROMPT_ALIGNMENT_OFFSET),
139: PROMPT_DISPLAY_STYLE = decode(nvl(PROMPT_DISPLAY_STYLE,hr_api.g_number),nvl(l_original.PROMPT_DISPLAY_STYLE,hr_api.g_number),X_PROMPT_DISPLAY_STYLE,PROMPT_DISPLAY_STYLE),
140: PROMPT_EDGE = decode(nvl(PROMPT_EDGE,hr_api.g_number),nvl(l_original.PROMPT_EDGE,hr_api.g_number),X_PROMPT_EDGE,PROMPT_EDGE),
141: PROMPT_EDGE_OFFSET = decode(nvl(PROMPT_EDGE_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_EDGE_OFFSET,hr_api.g_number),X_PROMPT_EDGE_OFFSET,PROMPT_EDGE_OFFSET),
142: PROMPT_EDGE_ALIGNMENT = decode(nvl(PROMPT_EDGE_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_EDGE_ALIGNMENT,hr_api.g_number),X_PROMPT_EDGE_ALIGNMENT,PROMPT_EDGE_ALIGNMENT),
143: PROMPT_TEXT_ALIGNMENT = decode(nvl(PROMPT_TEXT_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_TEXT_ALIGNMENT,hr_api.g_number),X_PROMPT_TEXT_ALIGNMENT,PROMPT_TEXT_ALIGNMENT),
144: QUERY_ALLOWED = decode(nvl(QUERY_ALLOWED,hr_api.g_number),nvl(l_original.QUERY_ALLOWED,hr_api.g_number),X_QUERY_ALLOWED,QUERY_ALLOWED),
145: REQUIRED = decode(nvl(REQUIRED,hr_api.g_number),nvl(l_original.REQUIRED,hr_api.g_number),X_REQUIRED,REQUIRED),

Line 142: PROMPT_EDGE_ALIGNMENT = decode(nvl(PROMPT_EDGE_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_EDGE_ALIGNMENT,hr_api.g_number),X_PROMPT_EDGE_ALIGNMENT,PROMPT_EDGE_ALIGNMENT),

138: PROMPT_ALIGNMENT_OFFSET = decode(nvl(PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_ALIGNMENT_OFFSET,hr_api.g_number),X_PROMPT_ALIGNMENT_OFFSET,PROMPT_ALIGNMENT_OFFSET),
139: PROMPT_DISPLAY_STYLE = decode(nvl(PROMPT_DISPLAY_STYLE,hr_api.g_number),nvl(l_original.PROMPT_DISPLAY_STYLE,hr_api.g_number),X_PROMPT_DISPLAY_STYLE,PROMPT_DISPLAY_STYLE),
140: PROMPT_EDGE = decode(nvl(PROMPT_EDGE,hr_api.g_number),nvl(l_original.PROMPT_EDGE,hr_api.g_number),X_PROMPT_EDGE,PROMPT_EDGE),
141: PROMPT_EDGE_OFFSET = decode(nvl(PROMPT_EDGE_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_EDGE_OFFSET,hr_api.g_number),X_PROMPT_EDGE_OFFSET,PROMPT_EDGE_OFFSET),
142: PROMPT_EDGE_ALIGNMENT = decode(nvl(PROMPT_EDGE_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_EDGE_ALIGNMENT,hr_api.g_number),X_PROMPT_EDGE_ALIGNMENT,PROMPT_EDGE_ALIGNMENT),
143: PROMPT_TEXT_ALIGNMENT = decode(nvl(PROMPT_TEXT_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_TEXT_ALIGNMENT,hr_api.g_number),X_PROMPT_TEXT_ALIGNMENT,PROMPT_TEXT_ALIGNMENT),
144: QUERY_ALLOWED = decode(nvl(QUERY_ALLOWED,hr_api.g_number),nvl(l_original.QUERY_ALLOWED,hr_api.g_number),X_QUERY_ALLOWED,QUERY_ALLOWED),
145: REQUIRED = decode(nvl(REQUIRED,hr_api.g_number),nvl(l_original.REQUIRED,hr_api.g_number),X_REQUIRED,REQUIRED),
146: UPDATE_ALLOWED = decode(nvl(UPDATE_ALLOWED,hr_api.g_number),nvl(l_original.UPDATE_ALLOWED,hr_api.g_number),X_UPDATE_ALLOWED,UPDATE_ALLOWED),

Line 143: PROMPT_TEXT_ALIGNMENT = decode(nvl(PROMPT_TEXT_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_TEXT_ALIGNMENT,hr_api.g_number),X_PROMPT_TEXT_ALIGNMENT,PROMPT_TEXT_ALIGNMENT),

139: PROMPT_DISPLAY_STYLE = decode(nvl(PROMPT_DISPLAY_STYLE,hr_api.g_number),nvl(l_original.PROMPT_DISPLAY_STYLE,hr_api.g_number),X_PROMPT_DISPLAY_STYLE,PROMPT_DISPLAY_STYLE),
140: PROMPT_EDGE = decode(nvl(PROMPT_EDGE,hr_api.g_number),nvl(l_original.PROMPT_EDGE,hr_api.g_number),X_PROMPT_EDGE,PROMPT_EDGE),
141: PROMPT_EDGE_OFFSET = decode(nvl(PROMPT_EDGE_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_EDGE_OFFSET,hr_api.g_number),X_PROMPT_EDGE_OFFSET,PROMPT_EDGE_OFFSET),
142: PROMPT_EDGE_ALIGNMENT = decode(nvl(PROMPT_EDGE_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_EDGE_ALIGNMENT,hr_api.g_number),X_PROMPT_EDGE_ALIGNMENT,PROMPT_EDGE_ALIGNMENT),
143: PROMPT_TEXT_ALIGNMENT = decode(nvl(PROMPT_TEXT_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_TEXT_ALIGNMENT,hr_api.g_number),X_PROMPT_TEXT_ALIGNMENT,PROMPT_TEXT_ALIGNMENT),
144: QUERY_ALLOWED = decode(nvl(QUERY_ALLOWED,hr_api.g_number),nvl(l_original.QUERY_ALLOWED,hr_api.g_number),X_QUERY_ALLOWED,QUERY_ALLOWED),
145: REQUIRED = decode(nvl(REQUIRED,hr_api.g_number),nvl(l_original.REQUIRED,hr_api.g_number),X_REQUIRED,REQUIRED),
146: UPDATE_ALLOWED = decode(nvl(UPDATE_ALLOWED,hr_api.g_number),nvl(l_original.UPDATE_ALLOWED,hr_api.g_number),X_UPDATE_ALLOWED,UPDATE_ALLOWED),
147: VALIDATION_FORMULA_ID = decode(nvl(VALIDATION_FORMULA_ID,hr_api.g_number),nvl(l_original.VALIDATION_FORMULA_ID,hr_api.g_number),X_VALIDATION_FORMULA_ID,VALIDATION_FORMULA_ID),

Line 144: QUERY_ALLOWED = decode(nvl(QUERY_ALLOWED,hr_api.g_number),nvl(l_original.QUERY_ALLOWED,hr_api.g_number),X_QUERY_ALLOWED,QUERY_ALLOWED),

140: PROMPT_EDGE = decode(nvl(PROMPT_EDGE,hr_api.g_number),nvl(l_original.PROMPT_EDGE,hr_api.g_number),X_PROMPT_EDGE,PROMPT_EDGE),
141: PROMPT_EDGE_OFFSET = decode(nvl(PROMPT_EDGE_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_EDGE_OFFSET,hr_api.g_number),X_PROMPT_EDGE_OFFSET,PROMPT_EDGE_OFFSET),
142: PROMPT_EDGE_ALIGNMENT = decode(nvl(PROMPT_EDGE_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_EDGE_ALIGNMENT,hr_api.g_number),X_PROMPT_EDGE_ALIGNMENT,PROMPT_EDGE_ALIGNMENT),
143: PROMPT_TEXT_ALIGNMENT = decode(nvl(PROMPT_TEXT_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_TEXT_ALIGNMENT,hr_api.g_number),X_PROMPT_TEXT_ALIGNMENT,PROMPT_TEXT_ALIGNMENT),
144: QUERY_ALLOWED = decode(nvl(QUERY_ALLOWED,hr_api.g_number),nvl(l_original.QUERY_ALLOWED,hr_api.g_number),X_QUERY_ALLOWED,QUERY_ALLOWED),
145: REQUIRED = decode(nvl(REQUIRED,hr_api.g_number),nvl(l_original.REQUIRED,hr_api.g_number),X_REQUIRED,REQUIRED),
146: UPDATE_ALLOWED = decode(nvl(UPDATE_ALLOWED,hr_api.g_number),nvl(l_original.UPDATE_ALLOWED,hr_api.g_number),X_UPDATE_ALLOWED,UPDATE_ALLOWED),
147: VALIDATION_FORMULA_ID = decode(nvl(VALIDATION_FORMULA_ID,hr_api.g_number),nvl(l_original.VALIDATION_FORMULA_ID,hr_api.g_number),X_VALIDATION_FORMULA_ID,VALIDATION_FORMULA_ID),
148: VALIDATION_PARAMETER_ITEM_ID1 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID1,VALIDATION_PARAMETER_ITEM_ID1),

Line 145: REQUIRED = decode(nvl(REQUIRED,hr_api.g_number),nvl(l_original.REQUIRED,hr_api.g_number),X_REQUIRED,REQUIRED),

141: PROMPT_EDGE_OFFSET = decode(nvl(PROMPT_EDGE_OFFSET,hr_api.g_number),nvl(l_original.PROMPT_EDGE_OFFSET,hr_api.g_number),X_PROMPT_EDGE_OFFSET,PROMPT_EDGE_OFFSET),
142: PROMPT_EDGE_ALIGNMENT = decode(nvl(PROMPT_EDGE_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_EDGE_ALIGNMENT,hr_api.g_number),X_PROMPT_EDGE_ALIGNMENT,PROMPT_EDGE_ALIGNMENT),
143: PROMPT_TEXT_ALIGNMENT = decode(nvl(PROMPT_TEXT_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_TEXT_ALIGNMENT,hr_api.g_number),X_PROMPT_TEXT_ALIGNMENT,PROMPT_TEXT_ALIGNMENT),
144: QUERY_ALLOWED = decode(nvl(QUERY_ALLOWED,hr_api.g_number),nvl(l_original.QUERY_ALLOWED,hr_api.g_number),X_QUERY_ALLOWED,QUERY_ALLOWED),
145: REQUIRED = decode(nvl(REQUIRED,hr_api.g_number),nvl(l_original.REQUIRED,hr_api.g_number),X_REQUIRED,REQUIRED),
146: UPDATE_ALLOWED = decode(nvl(UPDATE_ALLOWED,hr_api.g_number),nvl(l_original.UPDATE_ALLOWED,hr_api.g_number),X_UPDATE_ALLOWED,UPDATE_ALLOWED),
147: VALIDATION_FORMULA_ID = decode(nvl(VALIDATION_FORMULA_ID,hr_api.g_number),nvl(l_original.VALIDATION_FORMULA_ID,hr_api.g_number),X_VALIDATION_FORMULA_ID,VALIDATION_FORMULA_ID),
148: VALIDATION_PARAMETER_ITEM_ID1 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID1,VALIDATION_PARAMETER_ITEM_ID1),
149: VALIDATION_PARAMETER_ITEM_ID2 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID2,VALIDATION_PARAMETER_ITEM_ID2),

Line 146: UPDATE_ALLOWED = decode(nvl(UPDATE_ALLOWED,hr_api.g_number),nvl(l_original.UPDATE_ALLOWED,hr_api.g_number),X_UPDATE_ALLOWED,UPDATE_ALLOWED),

142: PROMPT_EDGE_ALIGNMENT = decode(nvl(PROMPT_EDGE_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_EDGE_ALIGNMENT,hr_api.g_number),X_PROMPT_EDGE_ALIGNMENT,PROMPT_EDGE_ALIGNMENT),
143: PROMPT_TEXT_ALIGNMENT = decode(nvl(PROMPT_TEXT_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_TEXT_ALIGNMENT,hr_api.g_number),X_PROMPT_TEXT_ALIGNMENT,PROMPT_TEXT_ALIGNMENT),
144: QUERY_ALLOWED = decode(nvl(QUERY_ALLOWED,hr_api.g_number),nvl(l_original.QUERY_ALLOWED,hr_api.g_number),X_QUERY_ALLOWED,QUERY_ALLOWED),
145: REQUIRED = decode(nvl(REQUIRED,hr_api.g_number),nvl(l_original.REQUIRED,hr_api.g_number),X_REQUIRED,REQUIRED),
146: UPDATE_ALLOWED = decode(nvl(UPDATE_ALLOWED,hr_api.g_number),nvl(l_original.UPDATE_ALLOWED,hr_api.g_number),X_UPDATE_ALLOWED,UPDATE_ALLOWED),
147: VALIDATION_FORMULA_ID = decode(nvl(VALIDATION_FORMULA_ID,hr_api.g_number),nvl(l_original.VALIDATION_FORMULA_ID,hr_api.g_number),X_VALIDATION_FORMULA_ID,VALIDATION_FORMULA_ID),
148: VALIDATION_PARAMETER_ITEM_ID1 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID1,VALIDATION_PARAMETER_ITEM_ID1),
149: VALIDATION_PARAMETER_ITEM_ID2 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID2,VALIDATION_PARAMETER_ITEM_ID2),
150: VALIDATION_PARAMETER_ITEM_ID3 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID3,VALIDATION_PARAMETER_ITEM_ID3),

Line 147: VALIDATION_FORMULA_ID = decode(nvl(VALIDATION_FORMULA_ID,hr_api.g_number),nvl(l_original.VALIDATION_FORMULA_ID,hr_api.g_number),X_VALIDATION_FORMULA_ID,VALIDATION_FORMULA_ID),

143: PROMPT_TEXT_ALIGNMENT = decode(nvl(PROMPT_TEXT_ALIGNMENT,hr_api.g_number),nvl(l_original.PROMPT_TEXT_ALIGNMENT,hr_api.g_number),X_PROMPT_TEXT_ALIGNMENT,PROMPT_TEXT_ALIGNMENT),
144: QUERY_ALLOWED = decode(nvl(QUERY_ALLOWED,hr_api.g_number),nvl(l_original.QUERY_ALLOWED,hr_api.g_number),X_QUERY_ALLOWED,QUERY_ALLOWED),
145: REQUIRED = decode(nvl(REQUIRED,hr_api.g_number),nvl(l_original.REQUIRED,hr_api.g_number),X_REQUIRED,REQUIRED),
146: UPDATE_ALLOWED = decode(nvl(UPDATE_ALLOWED,hr_api.g_number),nvl(l_original.UPDATE_ALLOWED,hr_api.g_number),X_UPDATE_ALLOWED,UPDATE_ALLOWED),
147: VALIDATION_FORMULA_ID = decode(nvl(VALIDATION_FORMULA_ID,hr_api.g_number),nvl(l_original.VALIDATION_FORMULA_ID,hr_api.g_number),X_VALIDATION_FORMULA_ID,VALIDATION_FORMULA_ID),
148: VALIDATION_PARAMETER_ITEM_ID1 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID1,VALIDATION_PARAMETER_ITEM_ID1),
149: VALIDATION_PARAMETER_ITEM_ID2 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID2,VALIDATION_PARAMETER_ITEM_ID2),
150: VALIDATION_PARAMETER_ITEM_ID3 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID3,VALIDATION_PARAMETER_ITEM_ID3),
151: VALIDATION_PARAMETER_ITEM_ID4 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID4,VALIDATION_PARAMETER_ITEM_ID4),

Line 148: VALIDATION_PARAMETER_ITEM_ID1 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID1,VALIDATION_PARAMETER_ITEM_ID1),

144: QUERY_ALLOWED = decode(nvl(QUERY_ALLOWED,hr_api.g_number),nvl(l_original.QUERY_ALLOWED,hr_api.g_number),X_QUERY_ALLOWED,QUERY_ALLOWED),
145: REQUIRED = decode(nvl(REQUIRED,hr_api.g_number),nvl(l_original.REQUIRED,hr_api.g_number),X_REQUIRED,REQUIRED),
146: UPDATE_ALLOWED = decode(nvl(UPDATE_ALLOWED,hr_api.g_number),nvl(l_original.UPDATE_ALLOWED,hr_api.g_number),X_UPDATE_ALLOWED,UPDATE_ALLOWED),
147: VALIDATION_FORMULA_ID = decode(nvl(VALIDATION_FORMULA_ID,hr_api.g_number),nvl(l_original.VALIDATION_FORMULA_ID,hr_api.g_number),X_VALIDATION_FORMULA_ID,VALIDATION_FORMULA_ID),
148: VALIDATION_PARAMETER_ITEM_ID1 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID1,VALIDATION_PARAMETER_ITEM_ID1),
149: VALIDATION_PARAMETER_ITEM_ID2 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID2,VALIDATION_PARAMETER_ITEM_ID2),
150: VALIDATION_PARAMETER_ITEM_ID3 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID3,VALIDATION_PARAMETER_ITEM_ID3),
151: VALIDATION_PARAMETER_ITEM_ID4 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID4,VALIDATION_PARAMETER_ITEM_ID4),
152: VALIDATION_PARAMETER_ITEM_ID5 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID5,VALIDATION_PARAMETER_ITEM_ID5),

Line 149: VALIDATION_PARAMETER_ITEM_ID2 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID2,VALIDATION_PARAMETER_ITEM_ID2),

145: REQUIRED = decode(nvl(REQUIRED,hr_api.g_number),nvl(l_original.REQUIRED,hr_api.g_number),X_REQUIRED,REQUIRED),
146: UPDATE_ALLOWED = decode(nvl(UPDATE_ALLOWED,hr_api.g_number),nvl(l_original.UPDATE_ALLOWED,hr_api.g_number),X_UPDATE_ALLOWED,UPDATE_ALLOWED),
147: VALIDATION_FORMULA_ID = decode(nvl(VALIDATION_FORMULA_ID,hr_api.g_number),nvl(l_original.VALIDATION_FORMULA_ID,hr_api.g_number),X_VALIDATION_FORMULA_ID,VALIDATION_FORMULA_ID),
148: VALIDATION_PARAMETER_ITEM_ID1 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID1,VALIDATION_PARAMETER_ITEM_ID1),
149: VALIDATION_PARAMETER_ITEM_ID2 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID2,VALIDATION_PARAMETER_ITEM_ID2),
150: VALIDATION_PARAMETER_ITEM_ID3 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID3,VALIDATION_PARAMETER_ITEM_ID3),
151: VALIDATION_PARAMETER_ITEM_ID4 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID4,VALIDATION_PARAMETER_ITEM_ID4),
152: VALIDATION_PARAMETER_ITEM_ID5 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID5,VALIDATION_PARAMETER_ITEM_ID5),
153: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),

Line 150: VALIDATION_PARAMETER_ITEM_ID3 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID3,VALIDATION_PARAMETER_ITEM_ID3),

146: UPDATE_ALLOWED = decode(nvl(UPDATE_ALLOWED,hr_api.g_number),nvl(l_original.UPDATE_ALLOWED,hr_api.g_number),X_UPDATE_ALLOWED,UPDATE_ALLOWED),
147: VALIDATION_FORMULA_ID = decode(nvl(VALIDATION_FORMULA_ID,hr_api.g_number),nvl(l_original.VALIDATION_FORMULA_ID,hr_api.g_number),X_VALIDATION_FORMULA_ID,VALIDATION_FORMULA_ID),
148: VALIDATION_PARAMETER_ITEM_ID1 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID1,VALIDATION_PARAMETER_ITEM_ID1),
149: VALIDATION_PARAMETER_ITEM_ID2 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID2,VALIDATION_PARAMETER_ITEM_ID2),
150: VALIDATION_PARAMETER_ITEM_ID3 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID3,VALIDATION_PARAMETER_ITEM_ID3),
151: VALIDATION_PARAMETER_ITEM_ID4 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID4,VALIDATION_PARAMETER_ITEM_ID4),
152: VALIDATION_PARAMETER_ITEM_ID5 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID5,VALIDATION_PARAMETER_ITEM_ID5),
153: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
154: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),

Line 151: VALIDATION_PARAMETER_ITEM_ID4 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID4,VALIDATION_PARAMETER_ITEM_ID4),

147: VALIDATION_FORMULA_ID = decode(nvl(VALIDATION_FORMULA_ID,hr_api.g_number),nvl(l_original.VALIDATION_FORMULA_ID,hr_api.g_number),X_VALIDATION_FORMULA_ID,VALIDATION_FORMULA_ID),
148: VALIDATION_PARAMETER_ITEM_ID1 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID1,VALIDATION_PARAMETER_ITEM_ID1),
149: VALIDATION_PARAMETER_ITEM_ID2 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID2,VALIDATION_PARAMETER_ITEM_ID2),
150: VALIDATION_PARAMETER_ITEM_ID3 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID3,VALIDATION_PARAMETER_ITEM_ID3),
151: VALIDATION_PARAMETER_ITEM_ID4 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID4,VALIDATION_PARAMETER_ITEM_ID4),
152: VALIDATION_PARAMETER_ITEM_ID5 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID5,VALIDATION_PARAMETER_ITEM_ID5),
153: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
154: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
155: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),

Line 152: VALIDATION_PARAMETER_ITEM_ID5 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID5,VALIDATION_PARAMETER_ITEM_ID5),

148: VALIDATION_PARAMETER_ITEM_ID1 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID1,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID1,VALIDATION_PARAMETER_ITEM_ID1),
149: VALIDATION_PARAMETER_ITEM_ID2 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID2,VALIDATION_PARAMETER_ITEM_ID2),
150: VALIDATION_PARAMETER_ITEM_ID3 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID3,VALIDATION_PARAMETER_ITEM_ID3),
151: VALIDATION_PARAMETER_ITEM_ID4 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID4,VALIDATION_PARAMETER_ITEM_ID4),
152: VALIDATION_PARAMETER_ITEM_ID5 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID5,VALIDATION_PARAMETER_ITEM_ID5),
153: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
154: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
155: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),
156: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),

Line 153: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),

149: VALIDATION_PARAMETER_ITEM_ID2 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID2,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID2,VALIDATION_PARAMETER_ITEM_ID2),
150: VALIDATION_PARAMETER_ITEM_ID3 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID3,VALIDATION_PARAMETER_ITEM_ID3),
151: VALIDATION_PARAMETER_ITEM_ID4 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID4,VALIDATION_PARAMETER_ITEM_ID4),
152: VALIDATION_PARAMETER_ITEM_ID5 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID5,VALIDATION_PARAMETER_ITEM_ID5),
153: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
154: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
155: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),
156: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),
157: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),

Line 154: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),

150: VALIDATION_PARAMETER_ITEM_ID3 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID3,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID3,VALIDATION_PARAMETER_ITEM_ID3),
151: VALIDATION_PARAMETER_ITEM_ID4 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID4,VALIDATION_PARAMETER_ITEM_ID4),
152: VALIDATION_PARAMETER_ITEM_ID5 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID5,VALIDATION_PARAMETER_ITEM_ID5),
153: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
154: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
155: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),
156: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),
157: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
158: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),

Line 155: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),

151: VALIDATION_PARAMETER_ITEM_ID4 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID4,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID4,VALIDATION_PARAMETER_ITEM_ID4),
152: VALIDATION_PARAMETER_ITEM_ID5 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID5,VALIDATION_PARAMETER_ITEM_ID5),
153: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
154: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
155: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),
156: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),
157: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
158: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
159: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),

Line 156: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),

152: VALIDATION_PARAMETER_ITEM_ID5 = decode(nvl(VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),nvl(l_original.VALIDATION_PARAMETER_ITEM_ID5,hr_api.g_number),X_VALIDATION_PARAM_ITEM_ID5,VALIDATION_PARAMETER_ITEM_ID5),
153: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
154: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
155: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),
156: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),
157: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
158: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
159: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),
160: INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),

Line 157: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),

153: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
154: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
155: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),
156: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),
157: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
158: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
159: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),
160: INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),
161: INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),

Line 158: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),

154: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
155: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),
156: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),
157: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
158: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
159: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),
160: INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),
161: INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),
162: INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),

Line 159: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),

155: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),
156: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),
157: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
158: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
159: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),
160: INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),
161: INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),
162: INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),
163: INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),

Line 160: INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),

156: Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),
157: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
158: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
159: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),
160: INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),
161: INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),
162: INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),
163: INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),
164: INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),

Line 161: INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),

157: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
158: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
159: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),
160: INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),
161: INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),
162: INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),
163: INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),
164: INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),
165: INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),

Line 162: INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),

158: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
159: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),
160: INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),
161: INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),
162: INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),
163: INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),
164: INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),
165: INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),
166: INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),

Line 163: INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),

159: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),
160: INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),
161: INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),
162: INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),
163: INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),
164: INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),
165: INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),
166: INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),
167: INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),

Line 164: INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),

160: INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),
161: INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),
162: INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),
163: INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),
164: INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),
165: INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),
166: INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),
167: INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),
168: INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),

Line 165: INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),

161: INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),
162: INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),
163: INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),
164: INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),
165: INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),
166: INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),
167: INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),
168: INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),
169: INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),

Line 166: INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),

162: INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),
163: INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),
164: INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),
165: INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),
166: INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),
167: INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),
168: INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),
169: INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),
170: INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),

Line 167: INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),

163: INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),
164: INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),
165: INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),
166: INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),
167: INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),
168: INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),
169: INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),
170: INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),
171: INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),

Line 168: INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),

164: INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),
165: INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),
166: INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),
167: INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),
168: INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),
169: INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),
170: INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),
171: INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),
172: INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),

Line 169: INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),

165: INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),
166: INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),
167: INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),
168: INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),
169: INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),
170: INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),
171: INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),
172: INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),
173: INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),

Line 170: INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),

166: INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),
167: INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),
168: INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),
169: INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),
170: INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),
171: INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),
172: INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),
173: INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),
174: INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),

Line 171: INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),

167: INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),
168: INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),
169: INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),
170: INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),
171: INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),
172: INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),
173: INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),
174: INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),
175: INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),

Line 172: INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),

168: INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),
169: INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),
170: INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),
171: INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),
172: INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),
173: INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),
174: INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),
175: INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),
176: INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),

Line 173: INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),

169: INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),
170: INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),
171: INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),
172: INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),
173: INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),
174: INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),
175: INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),
176: INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),
177: INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),

Line 174: INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),

170: INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),
171: INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),
172: INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),
173: INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),
174: INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),
175: INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),
176: INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),
177: INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),
178: INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),

Line 175: INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),

171: INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),
172: INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),
173: INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),
174: INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),
175: INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),
176: INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),
177: INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),
178: INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),
179: INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),

Line 176: INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),

172: INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),
173: INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),
174: INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),
175: INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),
176: INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),
177: INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),
178: INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),
179: INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),
180: INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),

Line 177: INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),

173: INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),
174: INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),
175: INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),
176: INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),
177: INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),
178: INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),
179: INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),
180: INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),
181: INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),

Line 178: INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),

174: INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),
175: INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),
176: INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),
177: INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),
178: INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),
179: INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),
180: INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),
181: INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),
182: INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),

Line 179: INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),

175: INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),
176: INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),
177: INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),
178: INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),
179: INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),
180: INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),
181: INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),
182: INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),
183: INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),

Line 180: INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),

176: INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),
177: INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),
178: INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),
179: INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),
180: INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),
181: INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),
182: INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),
183: INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),
184: INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),

Line 181: INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),

177: INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),
178: INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),
179: INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),
180: INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),
181: INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),
182: INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),
183: INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),
184: INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),
185: INFORMATION28 = decode(nvl(INFORMATION28,hr_api.g_varchar2),nvl(l_original.INFORMATION28,hr_api.g_varchar2),X_INFORMATION28,INFORMATION28),

Line 182: INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),

178: INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),
179: INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),
180: INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),
181: INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),
182: INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),
183: INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),
184: INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),
185: INFORMATION28 = decode(nvl(INFORMATION28,hr_api.g_varchar2),nvl(l_original.INFORMATION28,hr_api.g_varchar2),X_INFORMATION28,INFORMATION28),
186: INFORMATION29 = decode(nvl(INFORMATION29,hr_api.g_varchar2),nvl(l_original.INFORMATION29,hr_api.g_varchar2),X_INFORMATION29,INFORMATION29),

Line 183: INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),

179: INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),
180: INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),
181: INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),
182: INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),
183: INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),
184: INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),
185: INFORMATION28 = decode(nvl(INFORMATION28,hr_api.g_varchar2),nvl(l_original.INFORMATION28,hr_api.g_varchar2),X_INFORMATION28,INFORMATION28),
186: INFORMATION29 = decode(nvl(INFORMATION29,hr_api.g_varchar2),nvl(l_original.INFORMATION29,hr_api.g_varchar2),X_INFORMATION29,INFORMATION29),
187: INFORMATION30 = decode(nvl(INFORMATION30,hr_api.g_varchar2),nvl(l_original.INFORMATION30,hr_api.g_varchar2),X_INFORMATION30,INFORMATION30),

Line 184: INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),

180: INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),
181: INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),
182: INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),
183: INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),
184: INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),
185: INFORMATION28 = decode(nvl(INFORMATION28,hr_api.g_varchar2),nvl(l_original.INFORMATION28,hr_api.g_varchar2),X_INFORMATION28,INFORMATION28),
186: INFORMATION29 = decode(nvl(INFORMATION29,hr_api.g_varchar2),nvl(l_original.INFORMATION29,hr_api.g_varchar2),X_INFORMATION29,INFORMATION29),
187: INFORMATION30 = decode(nvl(INFORMATION30,hr_api.g_varchar2),nvl(l_original.INFORMATION30,hr_api.g_varchar2),X_INFORMATION30,INFORMATION30),
188: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 185: INFORMATION28 = decode(nvl(INFORMATION28,hr_api.g_varchar2),nvl(l_original.INFORMATION28,hr_api.g_varchar2),X_INFORMATION28,INFORMATION28),

181: INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),
182: INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),
183: INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),
184: INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),
185: INFORMATION28 = decode(nvl(INFORMATION28,hr_api.g_varchar2),nvl(l_original.INFORMATION28,hr_api.g_varchar2),X_INFORMATION28,INFORMATION28),
186: INFORMATION29 = decode(nvl(INFORMATION29,hr_api.g_varchar2),nvl(l_original.INFORMATION29,hr_api.g_varchar2),X_INFORMATION29,INFORMATION29),
187: INFORMATION30 = decode(nvl(INFORMATION30,hr_api.g_varchar2),nvl(l_original.INFORMATION30,hr_api.g_varchar2),X_INFORMATION30,INFORMATION30),
188: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
189: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 186: INFORMATION29 = decode(nvl(INFORMATION29,hr_api.g_varchar2),nvl(l_original.INFORMATION29,hr_api.g_varchar2),X_INFORMATION29,INFORMATION29),

182: INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),
183: INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),
184: INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),
185: INFORMATION28 = decode(nvl(INFORMATION28,hr_api.g_varchar2),nvl(l_original.INFORMATION28,hr_api.g_varchar2),X_INFORMATION28,INFORMATION28),
186: INFORMATION29 = decode(nvl(INFORMATION29,hr_api.g_varchar2),nvl(l_original.INFORMATION29,hr_api.g_varchar2),X_INFORMATION29,INFORMATION29),
187: INFORMATION30 = decode(nvl(INFORMATION30,hr_api.g_varchar2),nvl(l_original.INFORMATION30,hr_api.g_varchar2),X_INFORMATION30,INFORMATION30),
188: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
189: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
190: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 187: INFORMATION30 = decode(nvl(INFORMATION30,hr_api.g_varchar2),nvl(l_original.INFORMATION30,hr_api.g_varchar2),X_INFORMATION30,INFORMATION30),

183: INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),
184: INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),
185: INFORMATION28 = decode(nvl(INFORMATION28,hr_api.g_varchar2),nvl(l_original.INFORMATION28,hr_api.g_varchar2),X_INFORMATION28,INFORMATION28),
186: INFORMATION29 = decode(nvl(INFORMATION29,hr_api.g_varchar2),nvl(l_original.INFORMATION29,hr_api.g_varchar2),X_INFORMATION29,INFORMATION29),
187: INFORMATION30 = decode(nvl(INFORMATION30,hr_api.g_varchar2),nvl(l_original.INFORMATION30,hr_api.g_varchar2),X_INFORMATION30,INFORMATION30),
188: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
189: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
190: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
191: where ITEM_PROPERTY_ID = l_copy.ITEM_PROPERTY_ID;

Line 196: DEFAULT_VALUE = decode(nvl(DEFAULT_VALUE,hr_api.g_varchar2),nvl(l_original.DEFAULT_VALUE,hr_api.g_varchar2),X_DEFAULT_VALUE,DEFAULT_VALUE),

192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195: update HR_ITEM_PROPERTIES_TL set
196: DEFAULT_VALUE = decode(nvl(DEFAULT_VALUE,hr_api.g_varchar2),nvl(l_original.DEFAULT_VALUE,hr_api.g_varchar2),X_DEFAULT_VALUE,DEFAULT_VALUE),
197: INFORMATION_PROMPT = decode(nvl(INFORMATION_PROMPT,hr_api.g_varchar2),nvl(l_original.INFORMATION_PROMPT,hr_api.g_varchar2),X_INFORMATION_PROMPT,INFORMATION_PROMPT),
198: LABEL = decode(nvl(LABEL,hr_api.g_varchar2),nvl(l_original.LABEL,hr_api.g_varchar2),X_LABEL,LABEL),
199: PROMPT_TEXT = decode(nvl(PROMPT_TEXT,hr_api.g_varchar2),nvl(l_original.PROMPT_TEXT,hr_api.g_varchar2),X_PROMPT_TEXT,PROMPT_TEXT),
200: TOOLTIP_TEXT = decode(nvl(TOOLTIP_TEXT,hr_api.g_varchar2),nvl(l_original.TOOLTIP_TEXT,hr_api.g_varchar2),X_TOOLTIP_TEXT,TOOLTIP_TEXT),

Line 197: INFORMATION_PROMPT = decode(nvl(INFORMATION_PROMPT,hr_api.g_varchar2),nvl(l_original.INFORMATION_PROMPT,hr_api.g_varchar2),X_INFORMATION_PROMPT,INFORMATION_PROMPT),

193: raise no_data_found;
194: end if;
195: update HR_ITEM_PROPERTIES_TL set
196: DEFAULT_VALUE = decode(nvl(DEFAULT_VALUE,hr_api.g_varchar2),nvl(l_original.DEFAULT_VALUE,hr_api.g_varchar2),X_DEFAULT_VALUE,DEFAULT_VALUE),
197: INFORMATION_PROMPT = decode(nvl(INFORMATION_PROMPT,hr_api.g_varchar2),nvl(l_original.INFORMATION_PROMPT,hr_api.g_varchar2),X_INFORMATION_PROMPT,INFORMATION_PROMPT),
198: LABEL = decode(nvl(LABEL,hr_api.g_varchar2),nvl(l_original.LABEL,hr_api.g_varchar2),X_LABEL,LABEL),
199: PROMPT_TEXT = decode(nvl(PROMPT_TEXT,hr_api.g_varchar2),nvl(l_original.PROMPT_TEXT,hr_api.g_varchar2),X_PROMPT_TEXT,PROMPT_TEXT),
200: TOOLTIP_TEXT = decode(nvl(TOOLTIP_TEXT,hr_api.g_varchar2),nvl(l_original.TOOLTIP_TEXT,hr_api.g_varchar2),X_TOOLTIP_TEXT,TOOLTIP_TEXT),
201: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 198: LABEL = decode(nvl(LABEL,hr_api.g_varchar2),nvl(l_original.LABEL,hr_api.g_varchar2),X_LABEL,LABEL),

194: end if;
195: update HR_ITEM_PROPERTIES_TL set
196: DEFAULT_VALUE = decode(nvl(DEFAULT_VALUE,hr_api.g_varchar2),nvl(l_original.DEFAULT_VALUE,hr_api.g_varchar2),X_DEFAULT_VALUE,DEFAULT_VALUE),
197: INFORMATION_PROMPT = decode(nvl(INFORMATION_PROMPT,hr_api.g_varchar2),nvl(l_original.INFORMATION_PROMPT,hr_api.g_varchar2),X_INFORMATION_PROMPT,INFORMATION_PROMPT),
198: LABEL = decode(nvl(LABEL,hr_api.g_varchar2),nvl(l_original.LABEL,hr_api.g_varchar2),X_LABEL,LABEL),
199: PROMPT_TEXT = decode(nvl(PROMPT_TEXT,hr_api.g_varchar2),nvl(l_original.PROMPT_TEXT,hr_api.g_varchar2),X_PROMPT_TEXT,PROMPT_TEXT),
200: TOOLTIP_TEXT = decode(nvl(TOOLTIP_TEXT,hr_api.g_varchar2),nvl(l_original.TOOLTIP_TEXT,hr_api.g_varchar2),X_TOOLTIP_TEXT,TOOLTIP_TEXT),
201: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
202: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 199: PROMPT_TEXT = decode(nvl(PROMPT_TEXT,hr_api.g_varchar2),nvl(l_original.PROMPT_TEXT,hr_api.g_varchar2),X_PROMPT_TEXT,PROMPT_TEXT),

195: update HR_ITEM_PROPERTIES_TL set
196: DEFAULT_VALUE = decode(nvl(DEFAULT_VALUE,hr_api.g_varchar2),nvl(l_original.DEFAULT_VALUE,hr_api.g_varchar2),X_DEFAULT_VALUE,DEFAULT_VALUE),
197: INFORMATION_PROMPT = decode(nvl(INFORMATION_PROMPT,hr_api.g_varchar2),nvl(l_original.INFORMATION_PROMPT,hr_api.g_varchar2),X_INFORMATION_PROMPT,INFORMATION_PROMPT),
198: LABEL = decode(nvl(LABEL,hr_api.g_varchar2),nvl(l_original.LABEL,hr_api.g_varchar2),X_LABEL,LABEL),
199: PROMPT_TEXT = decode(nvl(PROMPT_TEXT,hr_api.g_varchar2),nvl(l_original.PROMPT_TEXT,hr_api.g_varchar2),X_PROMPT_TEXT,PROMPT_TEXT),
200: TOOLTIP_TEXT = decode(nvl(TOOLTIP_TEXT,hr_api.g_varchar2),nvl(l_original.TOOLTIP_TEXT,hr_api.g_varchar2),X_TOOLTIP_TEXT,TOOLTIP_TEXT),
201: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
202: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
203: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 200: TOOLTIP_TEXT = decode(nvl(TOOLTIP_TEXT,hr_api.g_varchar2),nvl(l_original.TOOLTIP_TEXT,hr_api.g_varchar2),X_TOOLTIP_TEXT,TOOLTIP_TEXT),

196: DEFAULT_VALUE = decode(nvl(DEFAULT_VALUE,hr_api.g_varchar2),nvl(l_original.DEFAULT_VALUE,hr_api.g_varchar2),X_DEFAULT_VALUE,DEFAULT_VALUE),
197: INFORMATION_PROMPT = decode(nvl(INFORMATION_PROMPT,hr_api.g_varchar2),nvl(l_original.INFORMATION_PROMPT,hr_api.g_varchar2),X_INFORMATION_PROMPT,INFORMATION_PROMPT),
198: LABEL = decode(nvl(LABEL,hr_api.g_varchar2),nvl(l_original.LABEL,hr_api.g_varchar2),X_LABEL,LABEL),
199: PROMPT_TEXT = decode(nvl(PROMPT_TEXT,hr_api.g_varchar2),nvl(l_original.PROMPT_TEXT,hr_api.g_varchar2),X_PROMPT_TEXT,PROMPT_TEXT),
200: TOOLTIP_TEXT = decode(nvl(TOOLTIP_TEXT,hr_api.g_varchar2),nvl(l_original.TOOLTIP_TEXT,hr_api.g_varchar2),X_TOOLTIP_TEXT,TOOLTIP_TEXT),
201: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
202: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
203: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
204: SOURCE_LANG = userenv('LANG')

Line 1402: where nvl(business_group_id,hr_api.g_number) = nvl(x_business_group_id,hr_api.g_number)

1398:
1399: select formula_id
1400: into x_information_formula_id
1401: from ff_formulas_f
1402: where nvl(business_group_id,hr_api.g_number) = nvl(x_business_group_id,hr_api.g_number)
1403: and nvl(legislation_code,hr_api.g_varchar2) = nvl(x_legislation_code,hr_api.g_varchar2)
1404: and formula_type_id = x_formula_type_id
1405: and formula_name = x_info_formula_name;
1406:

Line 1403: and nvl(legislation_code,hr_api.g_varchar2) = nvl(x_legislation_code,hr_api.g_varchar2)

1399: select formula_id
1400: into x_information_formula_id
1401: from ff_formulas_f
1402: where nvl(business_group_id,hr_api.g_number) = nvl(x_business_group_id,hr_api.g_number)
1403: and nvl(legislation_code,hr_api.g_varchar2) = nvl(x_legislation_code,hr_api.g_varchar2)
1404: and formula_type_id = x_formula_type_id
1405: and formula_name = x_info_formula_name;
1406:
1407: if ltrim(rtrim(x_full_item_name_ip1)) is not null then

Line 1568: where nvl(business_group_id,hr_api.g_number) = nvl(x_business_group_id,hr_api.g_number)

1564:
1565: select formula_id
1566: into x_validation_formula_id
1567: from ff_formulas_f
1568: where nvl(business_group_id,hr_api.g_number) = nvl(x_business_group_id,hr_api.g_number)
1569: and nvl(legislation_code,hr_api.g_varchar2) = nvl(x_legislation_code,hr_api.g_varchar2)
1570: and formula_type_id = x_formula_type_id
1571: and formula_name = x_val_formula_name;
1572:

Line 1569: and nvl(legislation_code,hr_api.g_varchar2) = nvl(x_legislation_code,hr_api.g_varchar2)

1565: select formula_id
1566: into x_validation_formula_id
1567: from ff_formulas_f
1568: where nvl(business_group_id,hr_api.g_number) = nvl(x_business_group_id,hr_api.g_number)
1569: and nvl(legislation_code,hr_api.g_varchar2) = nvl(x_legislation_code,hr_api.g_varchar2)
1570: and formula_type_id = x_formula_type_id
1571: and formula_name = x_val_formula_name;
1572:
1573: if ltrim(rtrim(x_full_item_name_vp1)) is not null then

Line 1724: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)

1720: ,hr_item_contexts hic
1721: ,fnd_id_flex_structures fifs
1722: where ticb.template_item_id = x_template_item_id
1723: and ticb.item_context_id = hic.item_context_id
1724: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
1725: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
1726: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
1727: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
1728: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)

Line 1725: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)

1721: ,fnd_id_flex_structures fifs
1722: where ticb.template_item_id = x_template_item_id
1723: and ticb.item_context_id = hic.item_context_id
1724: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
1725: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
1726: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
1727: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
1728: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
1729: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)

Line 1726: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)

1722: where ticb.template_item_id = x_template_item_id
1723: and ticb.item_context_id = hic.item_context_id
1724: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
1725: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
1726: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
1727: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
1728: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
1729: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
1730: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)

Line 1727: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)

1723: and ticb.item_context_id = hic.item_context_id
1724: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
1725: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
1726: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
1727: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
1728: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
1729: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
1730: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
1731: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)

Line 1728: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)

1724: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
1725: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
1726: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
1727: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
1728: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
1729: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
1730: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
1731: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
1732: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)

Line 1729: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)

1725: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
1726: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
1727: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
1728: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
1729: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
1730: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
1731: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
1732: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
1733: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)

Line 1730: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)

1726: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
1727: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
1728: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
1729: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
1730: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
1731: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
1732: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
1733: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
1734: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)

Line 1731: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)

1727: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
1728: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
1729: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
1730: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
1731: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
1732: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
1733: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
1734: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
1735: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)

Line 1732: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)

1728: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
1729: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
1730: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
1731: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
1732: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
1733: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
1734: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
1735: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
1736: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)

Line 1733: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)

1729: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
1730: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
1731: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
1732: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
1733: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
1734: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
1735: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
1736: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
1737: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)

Line 1734: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)

1730: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
1731: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
1732: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
1733: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
1734: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
1735: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
1736: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
1737: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
1738: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)

Line 1735: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)

1731: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
1732: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
1733: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
1734: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
1735: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
1736: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
1737: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
1738: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
1739: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)

Line 1736: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)

1732: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
1733: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
1734: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
1735: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
1736: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
1737: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
1738: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
1739: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
1740: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)

Line 1737: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)

1733: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
1734: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
1735: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
1736: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
1737: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
1738: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
1739: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
1740: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
1741: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)

Line 1738: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)

1734: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
1735: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
1736: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
1737: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
1738: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
1739: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
1740: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
1741: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
1742: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)

Line 1739: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)

1735: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
1736: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
1737: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
1738: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
1739: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
1740: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
1741: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
1742: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
1743: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)

Line 1740: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)

1736: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
1737: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
1738: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
1739: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
1740: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
1741: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
1742: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
1743: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
1744: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)

Line 1741: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)

1737: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
1738: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
1739: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
1740: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
1741: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
1742: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
1743: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
1744: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
1745: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)

Line 1742: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)

1738: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
1739: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
1740: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
1741: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
1742: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
1743: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
1744: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
1745: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
1746: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)

Line 1743: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)

1739: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
1740: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
1741: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
1742: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
1743: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
1744: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
1745: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
1746: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
1747: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)

Line 1744: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)

1740: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
1741: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
1742: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
1743: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
1744: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
1745: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
1746: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
1747: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
1748: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)

Line 1745: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)

1741: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
1742: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
1743: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
1744: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
1745: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
1746: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
1747: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
1748: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
1749: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)

Line 1746: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)

1742: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
1743: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
1744: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
1745: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
1746: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
1747: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
1748: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
1749: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
1750: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)

Line 1747: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)

1743: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
1744: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
1745: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
1746: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
1747: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
1748: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
1749: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
1750: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
1751: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)

Line 1748: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)

1744: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
1745: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
1746: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
1747: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
1748: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
1749: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
1750: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
1751: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
1752: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)

Line 1749: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)

1745: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
1746: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
1747: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
1748: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
1749: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
1750: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
1751: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
1752: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
1753: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)

Line 1750: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)

1746: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
1747: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
1748: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
1749: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
1750: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
1751: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
1752: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
1753: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
1754: and hic.id_flex_num = fifs.id_flex_num

Line 1751: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)

1747: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
1748: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
1749: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
1750: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
1751: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
1752: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
1753: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
1754: and hic.id_flex_num = fifs.id_flex_num
1755: and fifs.application_id = x_application_id

Line 1752: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)

1748: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
1749: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
1750: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
1751: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
1752: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
1753: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
1754: and hic.id_flex_num = fifs.id_flex_num
1755: and fifs.application_id = x_application_id
1756: and fifs.id_flex_structure_code = x_id_flex_structure_code

Line 1753: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)

1749: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
1750: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
1751: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
1752: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
1753: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
1754: and hic.id_flex_num = fifs.id_flex_num
1755: and fifs.application_id = x_application_id
1756: and fifs.id_flex_structure_code = x_id_flex_structure_code
1757: and fifs.id_flex_code = x_id_flex_code;

Line 1793: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)

1789: begin
1790: select item_property_id
1791: into x_item_property_id
1792: from hr_item_properties_b
1793: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
1794: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
1795: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
1796: */
1797:

Line 1794: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)

1790: select item_property_id
1791: into x_item_property_id
1792: from hr_item_properties_b
1793: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
1794: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
1795: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
1796: */
1797:
1798: exception

Line 1795: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);

1791: into x_item_property_id
1792: from hr_item_properties_b
1793: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
1794: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
1795: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
1796: */
1797:
1798: exception
1799: when no_data_found then

Line 2246: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)

2242: ,hr_item_contexts hic
2243: ,fnd_id_flex_structures fifs
2244: where ticb.template_item_id = x_template_item_id
2245: and ticb.item_context_id = hic.item_context_id
2246: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
2247: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2248: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2249: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2250: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)

Line 2247: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)

2243: ,fnd_id_flex_structures fifs
2244: where ticb.template_item_id = x_template_item_id
2245: and ticb.item_context_id = hic.item_context_id
2246: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
2247: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2248: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2249: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2250: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2251: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)

Line 2248: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)

2244: where ticb.template_item_id = x_template_item_id
2245: and ticb.item_context_id = hic.item_context_id
2246: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
2247: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2248: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2249: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2250: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2251: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2252: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)

Line 2249: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)

2245: and ticb.item_context_id = hic.item_context_id
2246: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
2247: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2248: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2249: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2250: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2251: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2252: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2253: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)

Line 2250: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)

2246: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
2247: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2248: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2249: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2250: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2251: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2252: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2253: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2254: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)

Line 2251: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)

2247: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2248: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2249: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2250: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2251: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2252: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2253: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2254: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2255: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)

Line 2252: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)

2248: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2249: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2250: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2251: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2252: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2253: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2254: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2255: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2256: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)

Line 2253: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)

2249: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2250: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2251: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2252: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2253: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2254: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2255: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2256: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2257: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)

Line 2254: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)

2250: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2251: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2252: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2253: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2254: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2255: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2256: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2257: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2258: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)

Line 2255: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)

2251: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2252: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2253: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2254: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2255: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2256: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2257: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2258: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2259: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)

Line 2256: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)

2252: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2253: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2254: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2255: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2256: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2257: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2258: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2259: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2260: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)

Line 2257: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)

2253: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2254: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2255: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2256: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2257: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2258: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2259: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2260: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2261: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)

Line 2258: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)

2254: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2255: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2256: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2257: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2258: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2259: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2260: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2261: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2262: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)

Line 2259: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)

2255: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2256: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2257: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2258: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2259: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2260: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2261: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2262: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2263: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)

Line 2260: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)

2256: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2257: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2258: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2259: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2260: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2261: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2262: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2263: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2264: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)

Line 2261: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)

2257: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2258: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2259: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2260: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2261: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2262: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2263: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2264: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2265: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)

Line 2262: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)

2258: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2259: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2260: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2261: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2262: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2263: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2264: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2265: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2266: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)

Line 2263: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)

2259: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2260: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2261: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2262: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2263: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2264: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2265: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2266: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2267: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)

Line 2264: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)

2260: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2261: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2262: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2263: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2264: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2265: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2266: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2267: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2268: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)

Line 2265: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)

2261: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2262: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2263: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2264: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2265: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2266: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2267: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2268: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2269: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)

Line 2266: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)

2262: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2263: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2264: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2265: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2266: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2267: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2268: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2269: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2270: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)

Line 2267: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)

2263: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2264: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2265: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2266: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2267: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2268: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2269: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2270: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2271: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)

Line 2268: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)

2264: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2265: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2266: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2267: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2268: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2269: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2270: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2271: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2272: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)

Line 2269: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)

2265: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2266: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2267: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2268: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2269: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2270: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2271: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2272: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2273: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)

Line 2270: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)

2266: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2267: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2268: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2269: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2270: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2271: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2272: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2273: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2274: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)

Line 2271: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)

2267: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2268: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2269: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2270: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2271: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2272: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2273: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2274: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
2275: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)

Line 2272: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)

2268: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2269: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2270: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2271: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2272: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2273: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2274: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
2275: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
2276: and hic.id_flex_num = fifs.id_flex_num

Line 2273: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)

2269: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2270: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2271: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2272: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2273: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2274: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
2275: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
2276: and hic.id_flex_num = fifs.id_flex_num
2277: and fifs.application_id = g_application_id --x_application_id

Line 2274: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)

2270: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2271: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2272: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2273: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2274: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
2275: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
2276: and hic.id_flex_num = fifs.id_flex_num
2277: and fifs.application_id = g_application_id --x_application_id
2278: and fifs.id_flex_structure_code = x_id_flex_structure_code

Line 2275: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)

2271: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2272: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2273: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2274: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
2275: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
2276: and hic.id_flex_num = fifs.id_flex_num
2277: and fifs.application_id = g_application_id --x_application_id
2278: and fifs.id_flex_structure_code = x_id_flex_structure_code
2279: and fifs.id_flex_code = x_id_flex_code;

Line 2313: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)

2309: /* removed for performance reasons, replaced by separate sql stmts immediately above
2310: select item_property_id
2311: into x_item_property_id
2312: from hr_item_properties_b
2313: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
2314: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
2315: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2316: */
2317:

Line 2314: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)

2310: select item_property_id
2311: into x_item_property_id
2312: from hr_item_properties_b
2313: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
2314: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
2315: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2316: */
2317:
2318: -- Translate owner to file_last_updated_by

Line 2315: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);

2311: into x_item_property_id
2312: from hr_item_properties_b
2313: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
2314: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
2315: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2316: */
2317:
2318: -- Translate owner to file_last_updated_by
2319: f_luby := fnd_load_util.owner_id(X_OWNER);

Line 2534: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)

2530: ,hr_item_contexts hic
2531: ,fnd_id_flex_structures fifs
2532: where ticb.template_item_id = x_template_item_id
2533: and ticb.item_context_id = hic.item_context_id
2534: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
2535: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2536: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2537: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2538: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)

Line 2535: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)

2531: ,fnd_id_flex_structures fifs
2532: where ticb.template_item_id = x_template_item_id
2533: and ticb.item_context_id = hic.item_context_id
2534: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
2535: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2536: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2537: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2538: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2539: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)

Line 2536: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)

2532: where ticb.template_item_id = x_template_item_id
2533: and ticb.item_context_id = hic.item_context_id
2534: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
2535: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2536: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2537: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2538: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2539: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2540: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)

Line 2537: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)

2533: and ticb.item_context_id = hic.item_context_id
2534: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
2535: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2536: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2537: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2538: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2539: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2540: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2541: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)

Line 2538: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)

2534: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
2535: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2536: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2537: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2538: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2539: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2540: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2541: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2542: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)

Line 2539: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)

2535: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
2536: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2537: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2538: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2539: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2540: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2541: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2542: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2543: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)

Line 2540: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)

2536: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
2537: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2538: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2539: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2540: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2541: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2542: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2543: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2544: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)

Line 2541: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)

2537: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
2538: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2539: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2540: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2541: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2542: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2543: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2544: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2545: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)

Line 2542: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)

2538: and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
2539: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2540: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2541: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2542: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2543: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2544: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2545: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2546: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)

Line 2543: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)

2539: and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
2540: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2541: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2542: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2543: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2544: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2545: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2546: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2547: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)

Line 2544: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)

2540: and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
2541: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2542: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2543: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2544: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2545: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2546: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2547: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2548: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)

Line 2545: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)

2541: and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
2542: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2543: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2544: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2545: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2546: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2547: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2548: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2549: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)

Line 2546: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)

2542: and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
2543: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2544: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2545: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2546: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2547: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2548: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2549: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2550: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)

Line 2547: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)

2543: and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
2544: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2545: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2546: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2547: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2548: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2549: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2550: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2551: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)

Line 2548: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)

2544: and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
2545: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2546: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2547: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2548: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2549: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2550: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2551: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2552: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)

Line 2549: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)

2545: and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
2546: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2547: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2548: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2549: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2550: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2551: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2552: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2553: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)

Line 2550: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)

2546: and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
2547: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2548: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2549: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2550: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2551: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2552: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2553: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2554: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)

Line 2551: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)

2547: and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
2548: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2549: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2550: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2551: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2552: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2553: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2554: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2555: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)

Line 2552: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)

2548: and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
2549: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2550: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2551: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2552: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2553: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2554: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2555: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2556: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)

Line 2553: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)

2549: and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
2550: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2551: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2552: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2553: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2554: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2555: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2556: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2557: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)

Line 2554: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)

2550: and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
2551: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2552: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2553: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2554: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2555: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2556: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2557: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2558: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)

Line 2555: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)

2551: and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
2552: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2553: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2554: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2555: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2556: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2557: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2558: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2559: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)

Line 2556: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)

2552: and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
2553: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2554: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2555: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2556: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2557: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2558: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2559: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2560: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)

Line 2557: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)

2553: and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
2554: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2555: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2556: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2557: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2558: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2559: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2560: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2561: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)

Line 2558: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)

2554: and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
2555: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2556: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2557: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2558: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2559: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2560: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2561: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2562: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)

Line 2559: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)

2555: and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
2556: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2557: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2558: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2559: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2560: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2561: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2562: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
2563: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)

Line 2560: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)

2556: and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
2557: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2558: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2559: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2560: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2561: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2562: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
2563: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
2564: and hic.id_flex_num = fifs.id_flex_num

Line 2561: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)

2557: and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
2558: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2559: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2560: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2561: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2562: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
2563: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
2564: and hic.id_flex_num = fifs.id_flex_num
2565: and fifs.application_id = g_application_id --x_application_id

Line 2562: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)

2558: and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
2559: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2560: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2561: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2562: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
2563: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
2564: and hic.id_flex_num = fifs.id_flex_num
2565: and fifs.application_id = g_application_id --x_application_id
2566: and fifs.id_flex_structure_code = x_id_flex_structure_code

Line 2563: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)

2559: and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
2560: and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
2561: and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
2562: and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
2563: and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
2564: and hic.id_flex_num = fifs.id_flex_num
2565: and fifs.application_id = g_application_id --x_application_id
2566: and fifs.id_flex_structure_code = x_id_flex_structure_code
2567: and fifs.id_flex_code = x_id_flex_code;

Line 2601: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)

2597: /* removed for performance reasons, replaced by separate sql stmts immediately above
2598: select item_property_id
2599: into x_item_property_id
2600: from hr_item_properties_b
2601: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
2602: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
2603: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2604: */
2605:

Line 2602: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)

2598: select item_property_id
2599: into x_item_property_id
2600: from hr_item_properties_b
2601: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
2602: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
2603: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2604: */
2605:
2606: -- Translate owner to file_last_updated_by

Line 2603: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);

2599: into x_item_property_id
2600: from hr_item_properties_b
2601: where nvl(form_item_id,hr_api.g_number) = nvl(x_form_item_id,hr_api.g_number)
2602: and nvl(template_item_id,hr_api.g_number) = nvl(x_template_item_id,hr_api.g_number)
2603: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2604: */
2605:
2606: -- Translate owner to file_last_updated_by
2607: f_luby := fnd_load_util.owner_id(X_OWNER);