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

APPS.JA_AU_CCID_PKG dependencies on GL_CODE_COMBINATIONS

Line 43: l_ccid gl_code_combinations.code_combination_id%TYPE;

39: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;
40: l_segvalues fnd_flex_ext.segmentarray;
41: l_seglength natural := 0;
42: l_segnumber natural := 0;
43: l_ccid gl_code_combinations.code_combination_id%TYPE;
44: l_num_segs number;
45: l_test_ccid boolean;
46:
47:

Line 93: the segment value from GL_CODE_COMBINATIONS for the specified

89: GOTO end_processing;
90: END IF;
91:
92: /* Fetch the AutoAccounting definitions a row at a time and retrieve
93: the segment value from GL_CODE_COMBINATIONS for the specified
94: segment */
95: OPEN l_autoaccount_defns;
96:
97: LOOP

Line 254: RETURN gl_code_combinations.segment1%TYPE IS

250: x_subinv_ccid IN
251: mtl_secondary_inventories.expense_account%TYPE,
252: x_item_ccid IN
253: mtl_system_items.expense_account%TYPE)
254: RETURN gl_code_combinations.segment1%TYPE IS
255:
256: l_value gl_code_combinations.segment1%TYPE;
257:
258: BEGIN

Line 256: l_value gl_code_combinations.segment1%TYPE;

252: x_item_ccid IN
253: mtl_system_items.expense_account%TYPE)
254: RETURN gl_code_combinations.segment1%TYPE IS
255:
256: l_value gl_code_combinations.segment1%TYPE;
257:
258: BEGIN
259:
260: IF SUBSTR(x_constant,1,2) = '!~' THEN /* Not a constant */

Line 295: gl_code_combinations.code_combination_id%TYPE,

291: -- *
292:
293: FUNCTION JA_AU_GET_VALUE
294: (x_ccid IN
295: gl_code_combinations.code_combination_id%TYPE,
296: x_segment IN
297: gl_code_combinations.segment1%TYPE)
298: RETURN gl_code_combinations.segment1%TYPE IS
299:

Line 297: gl_code_combinations.segment1%TYPE)

293: FUNCTION JA_AU_GET_VALUE
294: (x_ccid IN
295: gl_code_combinations.code_combination_id%TYPE,
296: x_segment IN
297: gl_code_combinations.segment1%TYPE)
298: RETURN gl_code_combinations.segment1%TYPE IS
299:
300: l_value gl_code_combinations.segment1%TYPE;
301:

Line 298: RETURN gl_code_combinations.segment1%TYPE IS

294: (x_ccid IN
295: gl_code_combinations.code_combination_id%TYPE,
296: x_segment IN
297: gl_code_combinations.segment1%TYPE)
298: RETURN gl_code_combinations.segment1%TYPE IS
299:
300: l_value gl_code_combinations.segment1%TYPE;
301:
302: BEGIN

Line 300: l_value gl_code_combinations.segment1%TYPE;

296: x_segment IN
297: gl_code_combinations.segment1%TYPE)
298: RETURN gl_code_combinations.segment1%TYPE IS
299:
300: l_value gl_code_combinations.segment1%TYPE;
301:
302: BEGIN
303:
304: IF SUBSTR(x_segment,1,9) = 'SEGMENT30' THEN

Line 307: FROM gl_code_combinations

303:
304: IF SUBSTR(x_segment,1,9) = 'SEGMENT30' THEN
305: SELECT nvl(segment30,'!@')
306: INTO l_value
307: FROM gl_code_combinations
308: WHERE code_combination_id = x_ccid ;
309: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT29' THEN
310: SELECT nvl(segment29,'!@')
311: INTO l_value

Line 312: FROM gl_code_combinations

308: WHERE code_combination_id = x_ccid ;
309: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT29' THEN
310: SELECT nvl(segment29,'!@')
311: INTO l_value
312: FROM gl_code_combinations
313: WHERE code_combination_id = x_ccid ;
314: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT28' THEN
315: SELECT nvl(segment28,'!@')
316: INTO l_value

Line 317: FROM gl_code_combinations

313: WHERE code_combination_id = x_ccid ;
314: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT28' THEN
315: SELECT nvl(segment28,'!@')
316: INTO l_value
317: FROM gl_code_combinations
318: WHERE code_combination_id = x_ccid ;
319: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT27' THEN
320: SELECT nvl(segment27,'!@')
321: INTO l_value

Line 322: FROM gl_code_combinations

318: WHERE code_combination_id = x_ccid ;
319: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT27' THEN
320: SELECT nvl(segment27,'!@')
321: INTO l_value
322: FROM gl_code_combinations
323: WHERE code_combination_id = x_ccid ;
324: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT26' THEN
325: SELECT nvl(segment26,'!@')
326: INTO l_value

Line 327: FROM gl_code_combinations

323: WHERE code_combination_id = x_ccid ;
324: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT26' THEN
325: SELECT nvl(segment26,'!@')
326: INTO l_value
327: FROM gl_code_combinations
328: WHERE code_combination_id = x_ccid ;
329: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT25' THEN
330: SELECT nvl(segment25,'!@')
331: INTO l_value

Line 332: FROM gl_code_combinations

328: WHERE code_combination_id = x_ccid ;
329: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT25' THEN
330: SELECT nvl(segment25,'!@')
331: INTO l_value
332: FROM gl_code_combinations
333: WHERE code_combination_id = x_ccid ;
334: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT24' THEN
335: SELECT nvl(segment24,'!@')
336: INTO l_value

Line 337: FROM gl_code_combinations

333: WHERE code_combination_id = x_ccid ;
334: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT24' THEN
335: SELECT nvl(segment24,'!@')
336: INTO l_value
337: FROM gl_code_combinations
338: WHERE code_combination_id = x_ccid ;
339: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT23' THEN
340: SELECT nvl(segment23,'!@')
341: INTO l_value

Line 342: FROM gl_code_combinations

338: WHERE code_combination_id = x_ccid ;
339: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT23' THEN
340: SELECT nvl(segment23,'!@')
341: INTO l_value
342: FROM gl_code_combinations
343: WHERE code_combination_id = x_ccid ;
344: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT22' THEN
345: SELECT nvl(segment22,'!@')
346: INTO l_value

Line 347: FROM gl_code_combinations

343: WHERE code_combination_id = x_ccid ;
344: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT22' THEN
345: SELECT nvl(segment22,'!@')
346: INTO l_value
347: FROM gl_code_combinations
348: WHERE code_combination_id = x_ccid ;
349: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT21' THEN
350: SELECT nvl(segment21,'!@')
351: INTO l_value

Line 352: FROM gl_code_combinations

348: WHERE code_combination_id = x_ccid ;
349: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT21' THEN
350: SELECT nvl(segment21,'!@')
351: INTO l_value
352: FROM gl_code_combinations
353: WHERE code_combination_id = x_ccid ;
354: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT20' THEN
355: SELECT nvl(segment20,'!@')
356: INTO l_value

Line 357: FROM gl_code_combinations

353: WHERE code_combination_id = x_ccid ;
354: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT20' THEN
355: SELECT nvl(segment20,'!@')
356: INTO l_value
357: FROM gl_code_combinations
358: WHERE code_combination_id = x_ccid ;
359: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT19' THEN
360: SELECT nvl(segment19,'!@')
361: INTO l_value

Line 362: FROM gl_code_combinations

358: WHERE code_combination_id = x_ccid ;
359: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT19' THEN
360: SELECT nvl(segment19,'!@')
361: INTO l_value
362: FROM gl_code_combinations
363: WHERE code_combination_id = x_ccid ;
364: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT18' THEN
365: SELECT nvl(segment18,'!@')
366: INTO l_value

Line 367: FROM gl_code_combinations

363: WHERE code_combination_id = x_ccid ;
364: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT18' THEN
365: SELECT nvl(segment18,'!@')
366: INTO l_value
367: FROM gl_code_combinations
368: WHERE code_combination_id = x_ccid ;
369: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT17' THEN
370: SELECT nvl(segment17,'!@')
371: INTO l_value

Line 372: FROM gl_code_combinations

368: WHERE code_combination_id = x_ccid ;
369: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT17' THEN
370: SELECT nvl(segment17,'!@')
371: INTO l_value
372: FROM gl_code_combinations
373: WHERE code_combination_id = x_ccid ;
374: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT16' THEN
375: SELECT nvl(segment16,'!@')
376: INTO l_value

Line 377: FROM gl_code_combinations

373: WHERE code_combination_id = x_ccid ;
374: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT16' THEN
375: SELECT nvl(segment16,'!@')
376: INTO l_value
377: FROM gl_code_combinations
378: WHERE code_combination_id = x_ccid ;
379: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT15' THEN
380: SELECT nvl(segment15,'!@')
381: INTO l_value

Line 382: FROM gl_code_combinations

378: WHERE code_combination_id = x_ccid ;
379: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT15' THEN
380: SELECT nvl(segment15,'!@')
381: INTO l_value
382: FROM gl_code_combinations
383: WHERE code_combination_id = x_ccid ;
384: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT14' THEN
385: SELECT nvl(segment14,'!@')
386: INTO l_value

Line 387: FROM gl_code_combinations

383: WHERE code_combination_id = x_ccid ;
384: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT14' THEN
385: SELECT nvl(segment14,'!@')
386: INTO l_value
387: FROM gl_code_combinations
388: WHERE code_combination_id = x_ccid ;
389: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT13' THEN
390: SELECT nvl(segment13,'!@')
391: INTO l_value

Line 392: FROM gl_code_combinations

388: WHERE code_combination_id = x_ccid ;
389: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT13' THEN
390: SELECT nvl(segment13,'!@')
391: INTO l_value
392: FROM gl_code_combinations
393: WHERE code_combination_id = x_ccid ;
394: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT12' THEN
395: SELECT nvl(segment12,'!@')
396: INTO l_value

Line 397: FROM gl_code_combinations

393: WHERE code_combination_id = x_ccid ;
394: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT12' THEN
395: SELECT nvl(segment12,'!@')
396: INTO l_value
397: FROM gl_code_combinations
398: WHERE code_combination_id = x_ccid ;
399: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT11' THEN
400: SELECT nvl(segment11,'!@')
401: INTO l_value

Line 402: FROM gl_code_combinations

398: WHERE code_combination_id = x_ccid ;
399: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT11' THEN
400: SELECT nvl(segment11,'!@')
401: INTO l_value
402: FROM gl_code_combinations
403: WHERE code_combination_id = x_ccid ;
404: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT10' THEN
405: SELECT nvl(segment10,'!@')
406: INTO l_value

Line 407: FROM gl_code_combinations

403: WHERE code_combination_id = x_ccid ;
404: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT10' THEN
405: SELECT nvl(segment10,'!@')
406: INTO l_value
407: FROM gl_code_combinations
408: WHERE code_combination_id = x_ccid ;
409: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT9' THEN
410: SELECT nvl(segment9,'!@')
411: INTO l_value

Line 412: FROM gl_code_combinations

408: WHERE code_combination_id = x_ccid ;
409: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT9' THEN
410: SELECT nvl(segment9,'!@')
411: INTO l_value
412: FROM gl_code_combinations
413: WHERE code_combination_id = x_ccid ;
414: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT8' THEN
415: SELECT nvl(segment8,'!@')
416: INTO l_value

Line 417: FROM gl_code_combinations

413: WHERE code_combination_id = x_ccid ;
414: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT8' THEN
415: SELECT nvl(segment8,'!@')
416: INTO l_value
417: FROM gl_code_combinations
418: WHERE code_combination_id = x_ccid ;
419: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT7' THEN
420: SELECT nvl(segment7,'!@')
421: INTO l_value

Line 422: FROM gl_code_combinations

418: WHERE code_combination_id = x_ccid ;
419: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT7' THEN
420: SELECT nvl(segment7,'!@')
421: INTO l_value
422: FROM gl_code_combinations
423: WHERE code_combination_id = x_ccid ;
424: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT6' THEN
425: SELECT nvl(segment6,'!@')
426: INTO l_value

Line 427: FROM gl_code_combinations

423: WHERE code_combination_id = x_ccid ;
424: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT6' THEN
425: SELECT nvl(segment6,'!@')
426: INTO l_value
427: FROM gl_code_combinations
428: WHERE code_combination_id = x_ccid ;
429: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT5' THEN
430: SELECT nvl(segment5,'!@')
431: INTO l_value

Line 432: FROM gl_code_combinations

428: WHERE code_combination_id = x_ccid ;
429: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT5' THEN
430: SELECT nvl(segment5,'!@')
431: INTO l_value
432: FROM gl_code_combinations
433: WHERE code_combination_id = x_ccid ;
434: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT4' THEN
435: SELECT nvl(segment4,'!@')
436: INTO l_value

Line 437: FROM gl_code_combinations

433: WHERE code_combination_id = x_ccid ;
434: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT4' THEN
435: SELECT nvl(segment4,'!@')
436: INTO l_value
437: FROM gl_code_combinations
438: WHERE code_combination_id = x_ccid ;
439: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT3' THEN
440: SELECT nvl(segment3,'!@')
441: INTO l_value

Line 442: FROM gl_code_combinations

438: WHERE code_combination_id = x_ccid ;
439: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT3' THEN
440: SELECT nvl(segment3,'!@')
441: INTO l_value
442: FROM gl_code_combinations
443: WHERE code_combination_id = x_ccid ;
444: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT2' THEN
445: SELECT nvl(segment2,'!@')
446: INTO l_value

Line 447: FROM gl_code_combinations

443: WHERE code_combination_id = x_ccid ;
444: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT2' THEN
445: SELECT nvl(segment2,'!@')
446: INTO l_value
447: FROM gl_code_combinations
448: WHERE code_combination_id = x_ccid ;
449: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT1' THEN
450: SELECT nvl(segment1,'!@')
451: INTO l_value

Line 452: FROM gl_code_combinations

448: WHERE code_combination_id = x_ccid ;
449: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT1' THEN
450: SELECT nvl(segment1,'!@')
451: INTO l_value
452: FROM gl_code_combinations
453: WHERE code_combination_id = x_ccid ;
454: ELSE
455: RAISE l_invalid_segment;
456: END IF;

Line 468: l_error_msg := 'AUTOGL ERROR - Segment value in GL_CODE_COMBINATIONS is null';

464: EXCEPTION
465: WHEN l_invalid_segment THEN
466: l_error_msg := 'AUTOGL ERROR - Incorrect AutoAccounting setup - Invalid Segment';
467: WHEN l_null_segment THEN
468: l_error_msg := 'AUTOGL ERROR - Segment value in GL_CODE_COMBINATIONS is null';
469: WHEN NO_DATA_FOUND THEN
470: l_error_msg := 'AUTOGL ERROR - Could not retrieve segment value from GL_CODE_COMBINATIONS.';
471: WHEN OTHERS THEN
472: null;

Line 470: l_error_msg := 'AUTOGL ERROR - Could not retrieve segment value from GL_CODE_COMBINATIONS.';

466: l_error_msg := 'AUTOGL ERROR - Incorrect AutoAccounting setup - Invalid Segment';
467: WHEN l_null_segment THEN
468: l_error_msg := 'AUTOGL ERROR - Segment value in GL_CODE_COMBINATIONS is null';
469: WHEN NO_DATA_FOUND THEN
470: l_error_msg := 'AUTOGL ERROR - Could not retrieve segment value from GL_CODE_COMBINATIONS.';
471: WHEN OTHERS THEN
472: null;
473:
474: END JA_AU_GET_VALUE;

Line 481: gl_code_combinations.code_combination_id%TYPE)

477: PROCEDURE JA_AU_UPDATE_MTLTRXACCT
478: (x_transaction_id IN
479: mtl_transaction_accounts.transaction_id%TYPE,
480: x_ccid IN
481: gl_code_combinations.code_combination_id%TYPE)
482: IS
483: BEGIN
484:
485: UPDATE mtl_transaction_accounts