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.AMS_R_CODE_DEFINITIONS_PKG dependencies on FND_API

Line 82: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

78: object_def,
79: code_definition_id,
80: object_version_number
81: ) VALUES (
82: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

79: code_definition_id,
80: object_version_number
81: ) VALUES (
82: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),

Line 84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

80: object_version_number
81: ) VALUES (
82: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
88: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),

Line 85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

81: ) VALUES (
82: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
88: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
89: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),

Line 86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

82: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
88: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
89: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),
90: -- DECODE( px_code_definition_id, FND_API.g_miss_num, NULL, px_code_definition_id),

Line 87: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),

83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
88: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
89: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),
90: -- DECODE( px_code_definition_id, FND_API.g_miss_num, NULL, px_code_definition_id),
91: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,

Line 88: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),

84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
88: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
89: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),
90: -- DECODE( px_code_definition_id, FND_API.g_miss_num, NULL, px_code_definition_id),
91: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

Line 89: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),

85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
88: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
89: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),
90: -- DECODE( px_code_definition_id, FND_API.g_miss_num, NULL, px_code_definition_id),
91: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
93:

Line 90: -- DECODE( px_code_definition_id, FND_API.g_miss_num, NULL, px_code_definition_id),

86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
88: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
89: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),
90: -- DECODE( px_code_definition_id, FND_API.g_miss_num, NULL, px_code_definition_id),
91: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
93:
94: -- AMS_UTILITY_PVT.debug_message( 'After first Insert_Row '||p_object_type);

Line 92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

88: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
89: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),
90: -- DECODE( px_code_definition_id, FND_API.g_miss_num, NULL, px_code_definition_id),
91: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
92: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
93:
94: -- AMS_UTILITY_PVT.debug_message( 'After first Insert_Row '||p_object_type);
95:
96: if( p_object_type = 'RANK') then

Line 114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

110: object_def,
111: code_definition_id,
112: object_version_number
113: ) VALUES (
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

111: code_definition_id,
112: object_version_number
113: ) VALUES (
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
119: 'RANK_DBI',

Line 116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

112: object_version_number
113: ) VALUES (
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
119: 'RANK_DBI',
120: DECODE( p_column_name, FND_API.g_miss_char, NULL,'A',p_column_name,'B',p_column_name,'C',p_column_name,'D',p_column_name,'Z'),

Line 117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

113: ) VALUES (
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
119: 'RANK_DBI',
120: DECODE( p_column_name, FND_API.g_miss_char, NULL,'A',p_column_name,'B',p_column_name,'C',p_column_name,'D',p_column_name,'Z'),
121: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),

Line 118: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
119: 'RANK_DBI',
120: DECODE( p_column_name, FND_API.g_miss_char, NULL,'A',p_column_name,'B',p_column_name,'C',p_column_name,'D',p_column_name,'Z'),
121: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),
122: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,

Line 120: DECODE( p_column_name, FND_API.g_miss_char, NULL,'A',p_column_name,'B',p_column_name,'C',p_column_name,'D',p_column_name,'Z'),

116: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
119: 'RANK_DBI',
120: DECODE( p_column_name, FND_API.g_miss_char, NULL,'A',p_column_name,'B',p_column_name,'C',p_column_name,'D',p_column_name,'Z'),
121: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),
122: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
123: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
124:

Line 121: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),

117: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
118: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
119: 'RANK_DBI',
120: DECODE( p_column_name, FND_API.g_miss_char, NULL,'A',p_column_name,'B',p_column_name,'C',p_column_name,'D',p_column_name,'Z'),
121: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),
122: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
123: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
124:
125: --AMS_UTILITY_PVT.debug_message( 'After second Insert_Row ');

Line 123: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

119: 'RANK_DBI',
120: DECODE( p_column_name, FND_API.g_miss_char, NULL,'A',p_column_name,'B',p_column_name,'C',p_column_name,'D',p_column_name,'Z'),
121: DECODE( p_object_def, FND_API.g_miss_char, NULL, p_object_def),
122: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
123: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
124:
125: --AMS_UTILITY_PVT.debug_message( 'After second Insert_Row ');
126:
127: OPEN c_get_dbi_ranks;

Line 224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

220:
221: BEGIN
222: Update BIM_R_CODE_DEFINITIONS
223: SET
224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
228: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),

Line 225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

221: BEGIN
222: Update BIM_R_CODE_DEFINITIONS
223: SET
224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
228: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
229: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),

Line 226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

222: Update BIM_R_CODE_DEFINITIONS
223: SET
224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
228: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
229: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
230: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),

Line 227: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),

223: SET
224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
228: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
229: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
230: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),
231: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)

Line 228: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),

224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
228: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
229: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
230: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),
231: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)
232: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID;

Line 229: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),

225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
228: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
229: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
230: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),
231: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)
232: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID;
233:

Line 230: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),

226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
228: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
229: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
230: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),
231: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)
232: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID;
233:
234: OPEN c_get_dbi_ranks(p_CODE_DEFINITION_ID+1);

Line 231: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)

227: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
228: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
229: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
230: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),
231: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)
232: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID;
233:
234: OPEN c_get_dbi_ranks(p_CODE_DEFINITION_ID+1);
235: FETCH c_get_dbi_ranks INTO l_dbi_rank_count;

Line 246: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

242: if( p_object_type = 'RANK') then
243:
244: Update BIM_R_CODE_DEFINITIONS
245: SET
246: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
247: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
248: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
249: object_type = 'RANK_DBI',
250: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),

Line 247: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

243:
244: Update BIM_R_CODE_DEFINITIONS
245: SET
246: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
247: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
248: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
249: object_type = 'RANK_DBI',
250: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
251: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),

Line 248: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

244: Update BIM_R_CODE_DEFINITIONS
245: SET
246: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
247: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
248: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
249: object_type = 'RANK_DBI',
250: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
251: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
252: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),

Line 250: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),

246: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
247: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
248: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
249: object_type = 'RANK_DBI',
250: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
251: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
252: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),
253: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)
254: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID+1

Line 251: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),

247: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
248: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
249: object_type = 'RANK_DBI',
250: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
251: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
252: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),
253: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)
254: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID+1
255: AND object_type = 'RANK_DBI';

Line 252: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),

248: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
249: object_type = 'RANK_DBI',
250: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
251: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
252: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),
253: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)
254: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID+1
255: AND object_type = 'RANK_DBI';
256:

Line 253: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)

249: object_type = 'RANK_DBI',
250: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
251: object_def = DECODE( p_object_def, FND_API.g_miss_char, object_def, p_object_def),
252: code_definition_id = DECODE( p_code_definition_id, FND_API.g_miss_num, code_definition_id, p_code_definition_id),
253: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1)
254: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID+1
255: AND object_type = 'RANK_DBI';
256:
257: OPEN c_get_dbi_ranks2;

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: END IF;
298: END IF;
299:
300: IF (SQL%NOTFOUND) THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303: END Update_Row;
304:
305:

Line 366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

362: )
363: ;
364:
365: If (SQL%NOTFOUND) then
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: End If;
368:
369:
370: END Delete_Row ;