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.GL_FLEX_INSERT_PKG dependencies on GL_SUMMARY_TEMPLATES

Line 258: /* GL_SUMMARY_TEMPLATES */

254: /* GL_CODE_COMBINATIONS */
255: /* GL_LEDGERS */
256: /* GL_BUDGET_ASSIGNMENT_RANGES */
257: /* GL_BUDGET_ASSIGNMENTS */
258: /* GL_SUMMARY_TEMPLATES */
259: /* GL_DYNAMIC_SUMM_COMBINATIONS */
260: /* GL_ROLLUP_GROUP_SCORES */
261: /* GL_CONCURRENCY_CONTROL */
262: /* GL_ACCOUNT_HIERARCHIES */

Line 1479: template_name gl_summary_templates.template_name%TYPE;

1475: rgroup SegRgrpArray;
1476: rgroup_sorted RgrpSrtArray;
1477: rgroup_ind RgrpIndArray;
1478:
1479: template_name gl_summary_templates.template_name%TYPE;
1480: template_id gl_summary_templates.template_id%TYPE;
1481: lgr_id gl_summary_templates.ledger_id%TYPE;
1482: segment1_type gl_summary_templates.segment1_type%TYPE;
1483: segment2_type gl_summary_templates.segment2_type%TYPE;

Line 1480: template_id gl_summary_templates.template_id%TYPE;

1476: rgroup_sorted RgrpSrtArray;
1477: rgroup_ind RgrpIndArray;
1478:
1479: template_name gl_summary_templates.template_name%TYPE;
1480: template_id gl_summary_templates.template_id%TYPE;
1481: lgr_id gl_summary_templates.ledger_id%TYPE;
1482: segment1_type gl_summary_templates.segment1_type%TYPE;
1483: segment2_type gl_summary_templates.segment2_type%TYPE;
1484: segment3_type gl_summary_templates.segment3_type%TYPE;

Line 1481: lgr_id gl_summary_templates.ledger_id%TYPE;

1477: rgroup_ind RgrpIndArray;
1478:
1479: template_name gl_summary_templates.template_name%TYPE;
1480: template_id gl_summary_templates.template_id%TYPE;
1481: lgr_id gl_summary_templates.ledger_id%TYPE;
1482: segment1_type gl_summary_templates.segment1_type%TYPE;
1483: segment2_type gl_summary_templates.segment2_type%TYPE;
1484: segment3_type gl_summary_templates.segment3_type%TYPE;
1485: segment4_type gl_summary_templates.segment4_type%TYPE;

Line 1482: segment1_type gl_summary_templates.segment1_type%TYPE;

1478:
1479: template_name gl_summary_templates.template_name%TYPE;
1480: template_id gl_summary_templates.template_id%TYPE;
1481: lgr_id gl_summary_templates.ledger_id%TYPE;
1482: segment1_type gl_summary_templates.segment1_type%TYPE;
1483: segment2_type gl_summary_templates.segment2_type%TYPE;
1484: segment3_type gl_summary_templates.segment3_type%TYPE;
1485: segment4_type gl_summary_templates.segment4_type%TYPE;
1486: segment5_type gl_summary_templates.segment5_type%TYPE;

Line 1483: segment2_type gl_summary_templates.segment2_type%TYPE;

1479: template_name gl_summary_templates.template_name%TYPE;
1480: template_id gl_summary_templates.template_id%TYPE;
1481: lgr_id gl_summary_templates.ledger_id%TYPE;
1482: segment1_type gl_summary_templates.segment1_type%TYPE;
1483: segment2_type gl_summary_templates.segment2_type%TYPE;
1484: segment3_type gl_summary_templates.segment3_type%TYPE;
1485: segment4_type gl_summary_templates.segment4_type%TYPE;
1486: segment5_type gl_summary_templates.segment5_type%TYPE;
1487: segment6_type gl_summary_templates.segment6_type%TYPE;

Line 1484: segment3_type gl_summary_templates.segment3_type%TYPE;

1480: template_id gl_summary_templates.template_id%TYPE;
1481: lgr_id gl_summary_templates.ledger_id%TYPE;
1482: segment1_type gl_summary_templates.segment1_type%TYPE;
1483: segment2_type gl_summary_templates.segment2_type%TYPE;
1484: segment3_type gl_summary_templates.segment3_type%TYPE;
1485: segment4_type gl_summary_templates.segment4_type%TYPE;
1486: segment5_type gl_summary_templates.segment5_type%TYPE;
1487: segment6_type gl_summary_templates.segment6_type%TYPE;
1488: segment7_type gl_summary_templates.segment7_type%TYPE;

Line 1485: segment4_type gl_summary_templates.segment4_type%TYPE;

1481: lgr_id gl_summary_templates.ledger_id%TYPE;
1482: segment1_type gl_summary_templates.segment1_type%TYPE;
1483: segment2_type gl_summary_templates.segment2_type%TYPE;
1484: segment3_type gl_summary_templates.segment3_type%TYPE;
1485: segment4_type gl_summary_templates.segment4_type%TYPE;
1486: segment5_type gl_summary_templates.segment5_type%TYPE;
1487: segment6_type gl_summary_templates.segment6_type%TYPE;
1488: segment7_type gl_summary_templates.segment7_type%TYPE;
1489: segment8_type gl_summary_templates.segment8_type%TYPE;

Line 1486: segment5_type gl_summary_templates.segment5_type%TYPE;

1482: segment1_type gl_summary_templates.segment1_type%TYPE;
1483: segment2_type gl_summary_templates.segment2_type%TYPE;
1484: segment3_type gl_summary_templates.segment3_type%TYPE;
1485: segment4_type gl_summary_templates.segment4_type%TYPE;
1486: segment5_type gl_summary_templates.segment5_type%TYPE;
1487: segment6_type gl_summary_templates.segment6_type%TYPE;
1488: segment7_type gl_summary_templates.segment7_type%TYPE;
1489: segment8_type gl_summary_templates.segment8_type%TYPE;
1490: segment9_type gl_summary_templates.segment9_type%TYPE;

Line 1487: segment6_type gl_summary_templates.segment6_type%TYPE;

1483: segment2_type gl_summary_templates.segment2_type%TYPE;
1484: segment3_type gl_summary_templates.segment3_type%TYPE;
1485: segment4_type gl_summary_templates.segment4_type%TYPE;
1486: segment5_type gl_summary_templates.segment5_type%TYPE;
1487: segment6_type gl_summary_templates.segment6_type%TYPE;
1488: segment7_type gl_summary_templates.segment7_type%TYPE;
1489: segment8_type gl_summary_templates.segment8_type%TYPE;
1490: segment9_type gl_summary_templates.segment9_type%TYPE;
1491: segment10_type gl_summary_templates.segment10_type%TYPE;

Line 1488: segment7_type gl_summary_templates.segment7_type%TYPE;

1484: segment3_type gl_summary_templates.segment3_type%TYPE;
1485: segment4_type gl_summary_templates.segment4_type%TYPE;
1486: segment5_type gl_summary_templates.segment5_type%TYPE;
1487: segment6_type gl_summary_templates.segment6_type%TYPE;
1488: segment7_type gl_summary_templates.segment7_type%TYPE;
1489: segment8_type gl_summary_templates.segment8_type%TYPE;
1490: segment9_type gl_summary_templates.segment9_type%TYPE;
1491: segment10_type gl_summary_templates.segment10_type%TYPE;
1492: segment11_type gl_summary_templates.segment11_type%TYPE;

Line 1489: segment8_type gl_summary_templates.segment8_type%TYPE;

1485: segment4_type gl_summary_templates.segment4_type%TYPE;
1486: segment5_type gl_summary_templates.segment5_type%TYPE;
1487: segment6_type gl_summary_templates.segment6_type%TYPE;
1488: segment7_type gl_summary_templates.segment7_type%TYPE;
1489: segment8_type gl_summary_templates.segment8_type%TYPE;
1490: segment9_type gl_summary_templates.segment9_type%TYPE;
1491: segment10_type gl_summary_templates.segment10_type%TYPE;
1492: segment11_type gl_summary_templates.segment11_type%TYPE;
1493: segment12_type gl_summary_templates.segment12_type%TYPE;

Line 1490: segment9_type gl_summary_templates.segment9_type%TYPE;

1486: segment5_type gl_summary_templates.segment5_type%TYPE;
1487: segment6_type gl_summary_templates.segment6_type%TYPE;
1488: segment7_type gl_summary_templates.segment7_type%TYPE;
1489: segment8_type gl_summary_templates.segment8_type%TYPE;
1490: segment9_type gl_summary_templates.segment9_type%TYPE;
1491: segment10_type gl_summary_templates.segment10_type%TYPE;
1492: segment11_type gl_summary_templates.segment11_type%TYPE;
1493: segment12_type gl_summary_templates.segment12_type%TYPE;
1494: segment13_type gl_summary_templates.segment13_type%TYPE;

Line 1491: segment10_type gl_summary_templates.segment10_type%TYPE;

1487: segment6_type gl_summary_templates.segment6_type%TYPE;
1488: segment7_type gl_summary_templates.segment7_type%TYPE;
1489: segment8_type gl_summary_templates.segment8_type%TYPE;
1490: segment9_type gl_summary_templates.segment9_type%TYPE;
1491: segment10_type gl_summary_templates.segment10_type%TYPE;
1492: segment11_type gl_summary_templates.segment11_type%TYPE;
1493: segment12_type gl_summary_templates.segment12_type%TYPE;
1494: segment13_type gl_summary_templates.segment13_type%TYPE;
1495: segment14_type gl_summary_templates.segment14_type%TYPE;

Line 1492: segment11_type gl_summary_templates.segment11_type%TYPE;

1488: segment7_type gl_summary_templates.segment7_type%TYPE;
1489: segment8_type gl_summary_templates.segment8_type%TYPE;
1490: segment9_type gl_summary_templates.segment9_type%TYPE;
1491: segment10_type gl_summary_templates.segment10_type%TYPE;
1492: segment11_type gl_summary_templates.segment11_type%TYPE;
1493: segment12_type gl_summary_templates.segment12_type%TYPE;
1494: segment13_type gl_summary_templates.segment13_type%TYPE;
1495: segment14_type gl_summary_templates.segment14_type%TYPE;
1496: segment15_type gl_summary_templates.segment15_type%TYPE;

Line 1493: segment12_type gl_summary_templates.segment12_type%TYPE;

1489: segment8_type gl_summary_templates.segment8_type%TYPE;
1490: segment9_type gl_summary_templates.segment9_type%TYPE;
1491: segment10_type gl_summary_templates.segment10_type%TYPE;
1492: segment11_type gl_summary_templates.segment11_type%TYPE;
1493: segment12_type gl_summary_templates.segment12_type%TYPE;
1494: segment13_type gl_summary_templates.segment13_type%TYPE;
1495: segment14_type gl_summary_templates.segment14_type%TYPE;
1496: segment15_type gl_summary_templates.segment15_type%TYPE;
1497: segment16_type gl_summary_templates.segment16_type%TYPE;

Line 1494: segment13_type gl_summary_templates.segment13_type%TYPE;

1490: segment9_type gl_summary_templates.segment9_type%TYPE;
1491: segment10_type gl_summary_templates.segment10_type%TYPE;
1492: segment11_type gl_summary_templates.segment11_type%TYPE;
1493: segment12_type gl_summary_templates.segment12_type%TYPE;
1494: segment13_type gl_summary_templates.segment13_type%TYPE;
1495: segment14_type gl_summary_templates.segment14_type%TYPE;
1496: segment15_type gl_summary_templates.segment15_type%TYPE;
1497: segment16_type gl_summary_templates.segment16_type%TYPE;
1498: segment17_type gl_summary_templates.segment17_type%TYPE;

Line 1495: segment14_type gl_summary_templates.segment14_type%TYPE;

1491: segment10_type gl_summary_templates.segment10_type%TYPE;
1492: segment11_type gl_summary_templates.segment11_type%TYPE;
1493: segment12_type gl_summary_templates.segment12_type%TYPE;
1494: segment13_type gl_summary_templates.segment13_type%TYPE;
1495: segment14_type gl_summary_templates.segment14_type%TYPE;
1496: segment15_type gl_summary_templates.segment15_type%TYPE;
1497: segment16_type gl_summary_templates.segment16_type%TYPE;
1498: segment17_type gl_summary_templates.segment17_type%TYPE;
1499: segment18_type gl_summary_templates.segment18_type%TYPE;

Line 1496: segment15_type gl_summary_templates.segment15_type%TYPE;

1492: segment11_type gl_summary_templates.segment11_type%TYPE;
1493: segment12_type gl_summary_templates.segment12_type%TYPE;
1494: segment13_type gl_summary_templates.segment13_type%TYPE;
1495: segment14_type gl_summary_templates.segment14_type%TYPE;
1496: segment15_type gl_summary_templates.segment15_type%TYPE;
1497: segment16_type gl_summary_templates.segment16_type%TYPE;
1498: segment17_type gl_summary_templates.segment17_type%TYPE;
1499: segment18_type gl_summary_templates.segment18_type%TYPE;
1500: segment19_type gl_summary_templates.segment19_type%TYPE;

Line 1497: segment16_type gl_summary_templates.segment16_type%TYPE;

1493: segment12_type gl_summary_templates.segment12_type%TYPE;
1494: segment13_type gl_summary_templates.segment13_type%TYPE;
1495: segment14_type gl_summary_templates.segment14_type%TYPE;
1496: segment15_type gl_summary_templates.segment15_type%TYPE;
1497: segment16_type gl_summary_templates.segment16_type%TYPE;
1498: segment17_type gl_summary_templates.segment17_type%TYPE;
1499: segment18_type gl_summary_templates.segment18_type%TYPE;
1500: segment19_type gl_summary_templates.segment19_type%TYPE;
1501: segment20_type gl_summary_templates.segment20_type%TYPE;

Line 1498: segment17_type gl_summary_templates.segment17_type%TYPE;

1494: segment13_type gl_summary_templates.segment13_type%TYPE;
1495: segment14_type gl_summary_templates.segment14_type%TYPE;
1496: segment15_type gl_summary_templates.segment15_type%TYPE;
1497: segment16_type gl_summary_templates.segment16_type%TYPE;
1498: segment17_type gl_summary_templates.segment17_type%TYPE;
1499: segment18_type gl_summary_templates.segment18_type%TYPE;
1500: segment19_type gl_summary_templates.segment19_type%TYPE;
1501: segment20_type gl_summary_templates.segment20_type%TYPE;
1502: segment21_type gl_summary_templates.segment21_type%TYPE;

Line 1499: segment18_type gl_summary_templates.segment18_type%TYPE;

1495: segment14_type gl_summary_templates.segment14_type%TYPE;
1496: segment15_type gl_summary_templates.segment15_type%TYPE;
1497: segment16_type gl_summary_templates.segment16_type%TYPE;
1498: segment17_type gl_summary_templates.segment17_type%TYPE;
1499: segment18_type gl_summary_templates.segment18_type%TYPE;
1500: segment19_type gl_summary_templates.segment19_type%TYPE;
1501: segment20_type gl_summary_templates.segment20_type%TYPE;
1502: segment21_type gl_summary_templates.segment21_type%TYPE;
1503: segment22_type gl_summary_templates.segment22_type%TYPE;

Line 1500: segment19_type gl_summary_templates.segment19_type%TYPE;

1496: segment15_type gl_summary_templates.segment15_type%TYPE;
1497: segment16_type gl_summary_templates.segment16_type%TYPE;
1498: segment17_type gl_summary_templates.segment17_type%TYPE;
1499: segment18_type gl_summary_templates.segment18_type%TYPE;
1500: segment19_type gl_summary_templates.segment19_type%TYPE;
1501: segment20_type gl_summary_templates.segment20_type%TYPE;
1502: segment21_type gl_summary_templates.segment21_type%TYPE;
1503: segment22_type gl_summary_templates.segment22_type%TYPE;
1504: segment23_type gl_summary_templates.segment23_type%TYPE;

Line 1501: segment20_type gl_summary_templates.segment20_type%TYPE;

1497: segment16_type gl_summary_templates.segment16_type%TYPE;
1498: segment17_type gl_summary_templates.segment17_type%TYPE;
1499: segment18_type gl_summary_templates.segment18_type%TYPE;
1500: segment19_type gl_summary_templates.segment19_type%TYPE;
1501: segment20_type gl_summary_templates.segment20_type%TYPE;
1502: segment21_type gl_summary_templates.segment21_type%TYPE;
1503: segment22_type gl_summary_templates.segment22_type%TYPE;
1504: segment23_type gl_summary_templates.segment23_type%TYPE;
1505: segment24_type gl_summary_templates.segment24_type%TYPE;

Line 1502: segment21_type gl_summary_templates.segment21_type%TYPE;

1498: segment17_type gl_summary_templates.segment17_type%TYPE;
1499: segment18_type gl_summary_templates.segment18_type%TYPE;
1500: segment19_type gl_summary_templates.segment19_type%TYPE;
1501: segment20_type gl_summary_templates.segment20_type%TYPE;
1502: segment21_type gl_summary_templates.segment21_type%TYPE;
1503: segment22_type gl_summary_templates.segment22_type%TYPE;
1504: segment23_type gl_summary_templates.segment23_type%TYPE;
1505: segment24_type gl_summary_templates.segment24_type%TYPE;
1506: segment25_type gl_summary_templates.segment25_type%TYPE;

Line 1503: segment22_type gl_summary_templates.segment22_type%TYPE;

1499: segment18_type gl_summary_templates.segment18_type%TYPE;
1500: segment19_type gl_summary_templates.segment19_type%TYPE;
1501: segment20_type gl_summary_templates.segment20_type%TYPE;
1502: segment21_type gl_summary_templates.segment21_type%TYPE;
1503: segment22_type gl_summary_templates.segment22_type%TYPE;
1504: segment23_type gl_summary_templates.segment23_type%TYPE;
1505: segment24_type gl_summary_templates.segment24_type%TYPE;
1506: segment25_type gl_summary_templates.segment25_type%TYPE;
1507: segment26_type gl_summary_templates.segment26_type%TYPE;

Line 1504: segment23_type gl_summary_templates.segment23_type%TYPE;

1500: segment19_type gl_summary_templates.segment19_type%TYPE;
1501: segment20_type gl_summary_templates.segment20_type%TYPE;
1502: segment21_type gl_summary_templates.segment21_type%TYPE;
1503: segment22_type gl_summary_templates.segment22_type%TYPE;
1504: segment23_type gl_summary_templates.segment23_type%TYPE;
1505: segment24_type gl_summary_templates.segment24_type%TYPE;
1506: segment25_type gl_summary_templates.segment25_type%TYPE;
1507: segment26_type gl_summary_templates.segment26_type%TYPE;
1508: segment27_type gl_summary_templates.segment27_type%TYPE;

Line 1505: segment24_type gl_summary_templates.segment24_type%TYPE;

1501: segment20_type gl_summary_templates.segment20_type%TYPE;
1502: segment21_type gl_summary_templates.segment21_type%TYPE;
1503: segment22_type gl_summary_templates.segment22_type%TYPE;
1504: segment23_type gl_summary_templates.segment23_type%TYPE;
1505: segment24_type gl_summary_templates.segment24_type%TYPE;
1506: segment25_type gl_summary_templates.segment25_type%TYPE;
1507: segment26_type gl_summary_templates.segment26_type%TYPE;
1508: segment27_type gl_summary_templates.segment27_type%TYPE;
1509: segment28_type gl_summary_templates.segment28_type%TYPE;

Line 1506: segment25_type gl_summary_templates.segment25_type%TYPE;

1502: segment21_type gl_summary_templates.segment21_type%TYPE;
1503: segment22_type gl_summary_templates.segment22_type%TYPE;
1504: segment23_type gl_summary_templates.segment23_type%TYPE;
1505: segment24_type gl_summary_templates.segment24_type%TYPE;
1506: segment25_type gl_summary_templates.segment25_type%TYPE;
1507: segment26_type gl_summary_templates.segment26_type%TYPE;
1508: segment27_type gl_summary_templates.segment27_type%TYPE;
1509: segment28_type gl_summary_templates.segment28_type%TYPE;
1510: segment29_type gl_summary_templates.segment29_type%TYPE;

Line 1507: segment26_type gl_summary_templates.segment26_type%TYPE;

1503: segment22_type gl_summary_templates.segment22_type%TYPE;
1504: segment23_type gl_summary_templates.segment23_type%TYPE;
1505: segment24_type gl_summary_templates.segment24_type%TYPE;
1506: segment25_type gl_summary_templates.segment25_type%TYPE;
1507: segment26_type gl_summary_templates.segment26_type%TYPE;
1508: segment27_type gl_summary_templates.segment27_type%TYPE;
1509: segment28_type gl_summary_templates.segment28_type%TYPE;
1510: segment29_type gl_summary_templates.segment29_type%TYPE;
1511: segment30_type gl_summary_templates.segment30_type%TYPE;

Line 1508: segment27_type gl_summary_templates.segment27_type%TYPE;

1504: segment23_type gl_summary_templates.segment23_type%TYPE;
1505: segment24_type gl_summary_templates.segment24_type%TYPE;
1506: segment25_type gl_summary_templates.segment25_type%TYPE;
1507: segment26_type gl_summary_templates.segment26_type%TYPE;
1508: segment27_type gl_summary_templates.segment27_type%TYPE;
1509: segment28_type gl_summary_templates.segment28_type%TYPE;
1510: segment29_type gl_summary_templates.segment29_type%TYPE;
1511: segment30_type gl_summary_templates.segment30_type%TYPE;
1512:

Line 1509: segment28_type gl_summary_templates.segment28_type%TYPE;

1505: segment24_type gl_summary_templates.segment24_type%TYPE;
1506: segment25_type gl_summary_templates.segment25_type%TYPE;
1507: segment26_type gl_summary_templates.segment26_type%TYPE;
1508: segment27_type gl_summary_templates.segment27_type%TYPE;
1509: segment28_type gl_summary_templates.segment28_type%TYPE;
1510: segment29_type gl_summary_templates.segment29_type%TYPE;
1511: segment30_type gl_summary_templates.segment30_type%TYPE;
1512:
1513:

Line 1510: segment29_type gl_summary_templates.segment29_type%TYPE;

1506: segment25_type gl_summary_templates.segment25_type%TYPE;
1507: segment26_type gl_summary_templates.segment26_type%TYPE;
1508: segment27_type gl_summary_templates.segment27_type%TYPE;
1509: segment28_type gl_summary_templates.segment28_type%TYPE;
1510: segment29_type gl_summary_templates.segment29_type%TYPE;
1511: segment30_type gl_summary_templates.segment30_type%TYPE;
1512:
1513:
1514: -- ========================= FND LOG ===========================

Line 1511: segment30_type gl_summary_templates.segment30_type%TYPE;

1507: segment26_type gl_summary_templates.segment26_type%TYPE;
1508: segment27_type gl_summary_templates.segment27_type%TYPE;
1509: segment28_type gl_summary_templates.segment28_type%TYPE;
1510: segment29_type gl_summary_templates.segment29_type%TYPE;
1511: segment30_type gl_summary_templates.segment30_type%TYPE;
1512:
1513:
1514: -- ========================= FND LOG ===========================
1515: l_full_path VARCHAR2(100) := g_path || 'glfcst.';

Line 1535: 'from gl_summary_templates smt, ' ||

1531: ', smt.segment' || i || '_type';
1532: end loop;
1533:
1534: sql_stmp := sql_stmp || ' ' ||
1535: 'from gl_summary_templates smt, ' ||
1536: 'gl_ledgers lgr ' ||
1537: 'where smt.status in (''A'', ''F'') ' ||
1538: 'and smt.account_category_code = :catg ' ||
1539: 'and smt.ledger_id = lgr.ledger_id ' ||