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_DYNAMIC_SUMM_COMBINATIONS

Line 100: dyn_grp_id gl_dynamic_summ_combinations.dynamic_group_id%TYPE;

96: acct_category VARCHAR2(1);
97:
98: -- Dynamic Group ID
99:
100: dyn_grp_id gl_dynamic_summ_combinations.dynamic_group_id%TYPE;
101:
102: -- Whether GL has been installed
103:
104: gl_installed VARCHAR2(15);

Line 121: min_ccid gl_dynamic_summ_combinations.code_combination_id%TYPE;

117:
118: -- Minimum CCID. All new Parent Accounts will have CCIDs greater than the
119: -- minimum CCID
120:
121: min_ccid gl_dynamic_summ_combinations.code_combination_id%TYPE;
122:
123: -- Number of Budgetary Control Ledgers
124:
125: num_bc_lgr NUMBER;

Line 259: /* GL_DYNAMIC_SUMM_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 */
263: /* */

Line 1840: select gl_dynamic_summ_combinations_s.NEXTVAL

1836:
1837: FUNCTION glfgdg RETURN BOOLEAN IS
1838:
1839: cursor dyngrp is
1840: select gl_dynamic_summ_combinations_s.NEXTVAL
1841: from sys.dual;
1842:
1843: -- ========================= FND LOG ===========================
1844: l_full_path VARCHAR2(100) := g_path || 'glfgdg.';

Line 2141: Type GDSC_Table IS TABLE OF GL_DYNAMIC_SUMM_COMBINATIONS%ROWTYPE;

2137: lgr_id IN NUMBER) RETURN BOOLEAN IS
2138:
2139: -- Create a PL/SQL table which will have the same structure as that of the table
2140: -- it will update
2141: Type GDSC_Table IS TABLE OF GL_DYNAMIC_SUMM_COMBINATIONS%ROWTYPE;
2142: GDSC_Type GDSC_Table := GDSC_Table();
2143: l_dup_rows NUMBER; -- Bug 5265341
2144:
2145: -- ========================= FND LOG ===========================

Line 2508: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_dynamic_summ_combinations');

2504:
2505: FOR i IN 1..GDSC_Type.COUNT LOOP
2506:
2507: -- ========================= FND LOG ===========================
2508: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_dynamic_summ_combinations');
2509: -- ========================= FND LOG ===========================
2510:
2511: insert into gl_dynamic_summ_combinations (
2512: dynamic_group_id,

Line 2511: insert into gl_dynamic_summ_combinations (

2507: -- ========================= FND LOG ===========================
2508: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_dynamic_summ_combinations');
2509: -- ========================= FND LOG ===========================
2510:
2511: insert into gl_dynamic_summ_combinations (
2512: dynamic_group_id,
2513: code_combination_id,
2514: last_update_date,
2515: last_updated_by,

Line 2649: DELETE FROM gl_dynamic_summ_combinations

2645:
2646:
2647: -- Delete the duplicate rows for this dynamic group id.
2648: -- This will not delete rows which have negative lgr and template ids
2649: DELETE FROM gl_dynamic_summ_combinations
2650: WHERE rowid NOT IN (SELECT min(rowid)
2651: FROM gl_dynamic_summ_combinations
2652: WHERE dynamic_group_id = dyn_grp_id
2653: GROUP BY dynamic_group_id,

Line 2651: FROM gl_dynamic_summ_combinations

2647: -- Delete the duplicate rows for this dynamic group id.
2648: -- This will not delete rows which have negative lgr and template ids
2649: DELETE FROM gl_dynamic_summ_combinations
2650: WHERE rowid NOT IN (SELECT min(rowid)
2651: FROM gl_dynamic_summ_combinations
2652: WHERE dynamic_group_id = dyn_grp_id
2653: GROUP BY dynamic_group_id,
2654: ledger_id,
2655: template_id,

Line 2690: ' DELETE FROM gl_dynamic_summ_combinations -> ' || SQL%ROWCOUNT);

2686: and dynamic_group_id = dyn_grp_id;
2687:
2688: -- ========================= FND LOG ===========================
2689: psa_utils.debug_other_string(g_state_level,l_full_path,
2690: ' DELETE FROM gl_dynamic_summ_combinations -> ' || SQL%ROWCOUNT);
2691: -- ========================= FND LOG ===========================
2692:
2693: -- bug 4130352 start
2694:

Line 2712: FROM gl_dynamic_summ_combinations

2708: segment19, segment20, segment21,
2709: segment22, segment23, segment24,
2710: segment25, segment26, segment27,
2711: segment28, segment29, segment30
2712: FROM gl_dynamic_summ_combinations
2713: WHERE dynamic_group_id = dyn_grp_id
2714: GROUP BY dynamic_group_id,
2715: abs(ledger_id),
2716: abs(template_id),

Line 2734: DELETE from gl_dynamic_summ_combinations

2730: -- ========================= FND LOG ===========================
2731: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside crec cursor');
2732: -- ========================= FND LOG ===========================
2733:
2734: DELETE from gl_dynamic_summ_combinations
2735: WHERE ledger_id = -1 * crec.ledger_id
2736: AND template_id = -1 * crec.template_id
2737: AND dynamic_group_id = dyn_grp_id
2738: AND nvl(segment1,g_segment_nvl_value) = nvl(crec.segment1,g_segment_nvl_value)

Line 2771: ' DELETE FROM gl_dynamic_summ_combinations II -> ' || SQL%ROWCOUNT);

2767: AND nvl(segment30,g_segment_nvl_value) = nvl(crec.segment30,g_segment_nvl_value);
2768:
2769: -- ========================= FND LOG ===========================
2770: psa_utils.debug_other_string(g_state_level,l_full_path,
2771: ' DELETE FROM gl_dynamic_summ_combinations II -> ' || SQL%ROWCOUNT);
2772: -- ========================= FND LOG ===========================
2773:
2774: END LOOP;
2775:

Line 2795: message_token('SQLSTR', 'INSERT INTO GL_DYNAMIC_SUMM_COMBINATIONS ...');

2791: -- ========================= FND LOG ===========================
2792:
2793: -- Dynamic SQL Exception
2794: message_token('MSG', SQLERRM);
2795: message_token('SQLSTR', 'INSERT INTO GL_DYNAMIC_SUMM_COMBINATIONS ...');
2796: add_message('FND', 'FLEXGL-DSQL EXCEPTION');
2797:
2798: return(FALSE);
2799:

Line 2827: from gl_dynamic_summ_combinations dsc

2823: where ct.concurrency_class = 'INSERT_SUMMARY_ACCOUNTS'
2824: and ct.concurrency_entity_name = 'SUMMARY_TEMPLATE'
2825: and exists (
2826: select 1
2827: from gl_dynamic_summ_combinations dsc
2828: where to_char(abs(dsc.template_id)) = ct.concurrency_entity_id
2829: and dsc.dynamic_group_id = dyn_grp_id
2830: )
2831: FOR UPDATE;

Line 2930: sql_statement := 'update gl_dynamic_summ_combinations tc1 ' ||

2926: -- ========================= FND LOG ===========================
2927: psa_utils.debug_other_string(g_state_level,l_full_path,' START glfaec ');
2928: -- ========================= FND LOG ===========================
2929:
2930: sql_statement := 'update gl_dynamic_summ_combinations tc1 ' ||
2931: 'set code_combination_id = (' ||
2932: 'select nvl(cc.code_combination_id, -1) ' ||
2933: 'from gl_code_combinations cc, ' ||
2934: 'gl_dynamic_summ_combinations tc2 ' ||

Line 2934: 'gl_dynamic_summ_combinations tc2 ' ||

2930: sql_statement := 'update gl_dynamic_summ_combinations tc1 ' ||
2931: 'set code_combination_id = (' ||
2932: 'select nvl(cc.code_combination_id, -1) ' ||
2933: 'from gl_code_combinations cc, ' ||
2934: 'gl_dynamic_summ_combinations tc2 ' ||
2935: 'where cc.template_id(+) = abs(tc1.template_id) ' ||
2936: 'and cc.chart_of_accounts_id(+) = ' || coaid || ' ';
2937:
2938: for i in 1..30 loop

Line 3020: update gl_dynamic_summ_combinations

3016: -- ========================= FND LOG ===========================
3017: goto return_invalid;
3018: end if;
3019:
3020: update gl_dynamic_summ_combinations
3021: set code_combination_id = gl_code_combinations_s.NEXTVAL
3022: where code_combination_id = -1
3023: and dynamic_group_id = dyn_grp_id;
3024:

Line 3027: ' update gl_dynamic_summ_combinations -' || SQL%ROWCOUNT);

3023: and dynamic_group_id = dyn_grp_id;
3024:
3025: -- ========================= FND LOG ===========================
3026: psa_utils.debug_other_string(g_state_level,l_full_path,
3027: ' update gl_dynamic_summ_combinations -' || SQL%ROWCOUNT);
3028: psa_utils.debug_other_string(g_state_level,l_full_path,
3029: ' RETURN -> TRUE');
3030: -- ========================= FND LOG ===========================
3031:

Line 3150: ' from gl_dynamic_summ_combinations dsc ' ||

3146: ', segment' || i;
3147: end loop;
3148:
3149: sql_inscc := sql_inscc ||
3150: ' from gl_dynamic_summ_combinations dsc ' ||
3151: 'where dynamic_group_id = :grp_id ' ||
3152: 'and code_combination_id > :min_ccid';
3153:
3154: -- ========================= FND LOG ===========================

Line 3295: 'from gl_dynamic_summ_combinations dsc ' ||

3291: 'template_id, ' ||
3292: ':user_id, ' ||
3293: 'sysdate, ' ||
3294: ':ordering_value ' ||
3295: 'from gl_dynamic_summ_combinations dsc ' ||
3296: 'where dsc.dynamic_group_id = :grp_id ' ||
3297: 'and not exists (' ||
3298: 'select 1 ' ||
3299: 'from gl_account_hierarchies ah ' ||

Line 3376: -- account; it then goes thru the gl_dynamic_summ_combinations table

3372: -- This function returns TRUE for non-Government install and when
3373: -- the Reporting Attributes profile is not set.
3374:
3375: -- This function first updates the reporting attributes for a detail
3376: -- account; it then goes thru the gl_dynamic_summ_combinations table
3377: -- to update the reporting attributes for all the summary accounts that
3378: -- have been created.
3379:
3380:

Line 3397: from gl_dynamic_summ_combinations

3393:
3394: cursor SummAcct(grp_id number,
3395: min_ccid number) IS
3396: select code_combination_id ccid
3397: from gl_dynamic_summ_combinations
3398: where dynamic_group_id = grp_id
3399: and code_combination_id >= min_ccid;
3400:
3401: value fnd_profile_option_values.profile_option_value%TYPE;