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 BIM_R_CODE_DEFINITIONS

Line 55: FROM BIM_R_CODE_DEFINITIONS

51: l_dbi_rank_count NUMBER:=0;
52:
53: CURSOR c_get_dbi_ranks IS
54: SELECT count(*)
55: FROM BIM_R_CODE_DEFINITIONS
56: WHERE object_type = 'RANK_DBI'
57: and column_name = 'Z';
58:
59:

Line 70: INSERT INTO BIM_R_CODE_DEFINITIONS(

66:
67: --AMS_UTILITY_PVT.debug_message( 'Before calling insert ');
68:
69:
70: INSERT INTO BIM_R_CODE_DEFINITIONS(
71: creation_date,
72: last_update_date,
73: created_by,
74: last_updated_by,

Line 91: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,

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);
95:

Line 100: --delete from BIM_R_CODE_DEFINITIONS where object_type = 'RANK_DBI';

96: if( p_object_type = 'RANK') then
97:
98: --AMS_UTILITY_PVT.debug_message( 'Inside Rank loop'||p_object_type);
99:
100: --delete from BIM_R_CODE_DEFINITIONS where object_type = 'RANK_DBI';
101:
102: INSERT INTO BIM_R_CODE_DEFINITIONS(
103: creation_date,
104: last_update_date,

Line 102: INSERT INTO BIM_R_CODE_DEFINITIONS(

98: --AMS_UTILITY_PVT.debug_message( 'Inside Rank loop'||p_object_type);
99:
100: --delete from BIM_R_CODE_DEFINITIONS where object_type = 'RANK_DBI';
101:
102: INSERT INTO BIM_R_CODE_DEFINITIONS(
103: creation_date,
104: last_update_date,
105: created_by,
106: last_updated_by,

Line 122: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,

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 ');
126:

Line 133: DELETE FROM BIM_R_CODE_DEFINITIONS WHERE column_name = 'Z';

129: FETCH c_get_dbi_ranks INTO l_dbi_rank_count ;
130:
131: If ( l_dbi_rank_count>0) THEN
132:
133: DELETE FROM BIM_R_CODE_DEFINITIONS WHERE column_name = 'Z';
134:
135: END IF;
136:
137: --AMS_UTILITY_PVT.debug_message( 'After third Insert_Row ');

Line 140: INSERT INTO BIM_R_CODE_DEFINITIONS(

136:
137: --AMS_UTILITY_PVT.debug_message( 'After third Insert_Row ');
138:
139:
140: INSERT INTO BIM_R_CODE_DEFINITIONS(
141: creation_date,
142: last_update_date,
143: created_by,
144: last_updated_by,

Line 160: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,

156: 1,
157: 'RANK_DBI',
158: 'Z',
159: rank_id,
160: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
161: 1
162: FROM AS_SALES_LEAD_RANKS_VL a
163: --WHERE enabled_flag = 'Y'
164: WHERE to_char(a.rank_id)

Line 166: ( SELECT object_def from BIM_R_CODE_DEFINITIONS WHERE object_type = 'RANK' and column_name in ('A','B','C','D')

162: FROM AS_SALES_LEAD_RANKS_VL a
163: --WHERE enabled_flag = 'Y'
164: WHERE to_char(a.rank_id)
165: NOT IN
166: ( SELECT object_def from BIM_R_CODE_DEFINITIONS WHERE object_type = 'RANK' and column_name in ('A','B','C','D')
167: )
168: )
169: ;
170:

Line 207: FROM BIM_R_CODE_DEFINITIONS

203: IS
204:
205: CURSOR c_get_dbi_ranks(l_code_definition_id IN NUMBER) IS
206: SELECT count(*)
207: FROM BIM_R_CODE_DEFINITIONS
208: WHERE object_type = 'RANK_DBI'
209: and code_definition_id = l_code_definition_id;
210:
211: CURSOR c_get_dbi_ranks2 IS

Line 213: FROM BIM_R_CODE_DEFINITIONS

209: and code_definition_id = l_code_definition_id;
210:
211: CURSOR c_get_dbi_ranks2 IS
212: SELECT count(*)
213: FROM BIM_R_CODE_DEFINITIONS
214: WHERE object_type = 'RANK_DBI'
215: and column_name = 'Z';
216:
217:

Line 222: Update BIM_R_CODE_DEFINITIONS

218: l_dbi_rank_count NUMBER:=0;
219: l_dbi_rank_count2 NUMBER:=0;
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),

Line 244: Update BIM_R_CODE_DEFINITIONS

240:
241:
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),

Line 263: DELETE FROM BIM_R_CODE_DEFINITIONS WHERE column_name = 'Z';

259: FETCH c_get_dbi_ranks2 INTO l_dbi_rank_count2 ;
260:
261: If ( l_dbi_rank_count2>0) THEN
262:
263: DELETE FROM BIM_R_CODE_DEFINITIONS WHERE column_name = 'Z';
264:
265:
266: INSERT INTO BIM_R_CODE_DEFINITIONS(
267: creation_date,

Line 266: INSERT INTO BIM_R_CODE_DEFINITIONS(

262:
263: DELETE FROM BIM_R_CODE_DEFINITIONS WHERE column_name = 'Z';
264:
265:
266: INSERT INTO BIM_R_CODE_DEFINITIONS(
267: creation_date,
268: last_update_date,
269: created_by,
270: last_updated_by,

Line 286: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,

282: 1,
283: 'RANK_DBI',
284: 'Z',
285: rank_id,
286: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
287: 1
288: FROM AS_SALES_LEAD_RANKS_VL a
289: --WHERE enabled_flag = 'Y'
290: WHERE to_char(a.rank_id)

Line 292: ( SELECT object_def from BIM_R_CODE_DEFINITIONS WHERE object_type = 'RANK')

288: FROM AS_SALES_LEAD_RANKS_VL a
289: --WHERE enabled_flag = 'Y'
290: WHERE to_char(a.rank_id)
291: NOT IN
292: ( SELECT object_def from BIM_R_CODE_DEFINITIONS WHERE object_type = 'RANK')
293: )
294: ;
295:
296: END IF;

Line 326: DELETE FROM BIM_R_CODE_DEFINITIONS

322: PROCEDURE Delete_Row(
323: p_CODE_DEFINITION_ID NUMBER)
324: IS
325: BEGIN
326: DELETE FROM BIM_R_CODE_DEFINITIONS
327: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID;
328:
329: DELETE FROM BIM_R_CODE_DEFINITIONS
330: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID + 1

Line 329: DELETE FROM BIM_R_CODE_DEFINITIONS

325: BEGIN
326: DELETE FROM BIM_R_CODE_DEFINITIONS
327: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID;
328:
329: DELETE FROM BIM_R_CODE_DEFINITIONS
330: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID + 1
331: AND object_type = 'RANK_DBI';
332:
333: DELETE FROM BIM_R_CODE_DEFINITIONS WHERE column_name = 'Z';

Line 333: DELETE FROM BIM_R_CODE_DEFINITIONS WHERE column_name = 'Z';

329: DELETE FROM BIM_R_CODE_DEFINITIONS
330: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID + 1
331: AND object_type = 'RANK_DBI';
332:
333: DELETE FROM BIM_R_CODE_DEFINITIONS WHERE column_name = 'Z';
334:
335: INSERT INTO BIM_R_CODE_DEFINITIONS(
336: creation_date,
337: last_update_date,

Line 335: INSERT INTO BIM_R_CODE_DEFINITIONS(

331: AND object_type = 'RANK_DBI';
332:
333: DELETE FROM BIM_R_CODE_DEFINITIONS WHERE column_name = 'Z';
334:
335: INSERT INTO BIM_R_CODE_DEFINITIONS(
336: creation_date,
337: last_update_date,
338: created_by,
339: last_updated_by,

Line 355: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,

351: 1,
352: 'RANK_DBI',
353: 'Z',
354: rank_id,
355: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
356: 1
357: FROM AS_SALES_LEAD_RANKS_VL a
358: --WHERE enabled_flag = 'Y'
359: WHERE to_char(a.rank_id)

Line 361: ( SELECT object_def from BIM_R_CODE_DEFINITIONS WHERE object_type = 'RANK')

357: FROM AS_SALES_LEAD_RANKS_VL a
358: --WHERE enabled_flag = 'Y'
359: WHERE to_char(a.rank_id)
360: NOT IN
361: ( SELECT object_def from BIM_R_CODE_DEFINITIONS WHERE object_type = 'RANK')
362: )
363: ;
364:
365: If (SQL%NOTFOUND) then

Line 405: FROM BIM_R_CODE_DEFINITIONS

401:
402: IS
403: CURSOR C IS
404: SELECT *
405: FROM BIM_R_CODE_DEFINITIONS
406: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID
407: FOR UPDATE of CODE_DEFINITION_ID NOWAIT;
408: Recinfo C%ROWTYPE;
409: BEGIN