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.

[Home] [Help]

APPS.GCS_TEMPLATES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19


      l_select_clause         VARCHAR2 (5000);        -- vars to form a cursor

Line: 20


      l_insert_clause         VARCHAR2 (5000);        -- vars to form a cursor

Line: 57


   SELECT SPECIFIC_INTERCOMPANY_ID
     FROM GCS_CATEGORIES_B
    WHERE CATEGORY_CODE = ''INTRACOMPANY'';

Line: 77


         SELECT hb.balance_by_org_flag, hb.column_name
           FROM gcs_hierarchies_b hb
          WHERE hb.hierarchy_id = p_hierarchy_id;

Line: 86


      SELECT fxata.number_assign_value
      FROM   gcs_dimension_templates dt,
             fem_ln_items_attr flia,
             fem_ext_acct_types_attr fxata
      WHERE  dt.hierarchy_id = p_hierarchy_id
      AND    dt.template_code = ''RE''
      AND    flia.line_item_id = dt.line_item_id
      AND    flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
      AND    flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
      AND    fxata.ext_account_type_code = flia.dim_attribute_varchar_member
      AND    fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
      AND    fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;

Line: 124


                            ''SELECT ''''X''''''
                         || g_nl
                         || ''FROM	gcs_entry_headers ''
                         || g_nl
                         || ''WHERE  entry_id = ''
                         || p_entry_id
                         || g_nl
                         || ''AND start_cal_period_id <> end_cal_period_id ''
                        );

Line: 137


      SELECT ''Y''
      INTO l_re_required
      FROM gcs_entry_headers
      WHERE entry_id = p_entry_id
      AND start_cal_period_id <> nvl(end_cal_period_id, 0);

Line: 154


                            ''SELECT hb.balance_by_org_flag, hb.column_name''
                         || g_nl
                         || ''FROM	gcs_hierarchies_b hb ''
                         || g_nl
                         || ''WHERE  hb.hierarchy_id = ''
                         || p_hierarchy_id
                        );

Line: 182


                        ''SELECT specific_intercompany_id FROM gcs_hierarchies_b ''
                        || '' WHERE hierarchy_id =  '' || p_hierarchy_id
                        || '' AND INTERCOMPANY_ORG_TYPE_CODE = ''''SPECIFIC_VALUE'''''');

Line: 200


                         ''SELECT fxata.number_assign_value'' || g_nl ||
                         ''FROM   gcs_dimension_templates dt, '' || g_nl ||
                         ''       fem_ln_items_attr flia,'' || g_nl ||
                         ''       fem_ext_acct_types_attr fxata'' || g_nl ||
                         ''WHERE  dt.hierarchy_id = '' || p_hierarchy_id || g_nl ||
                         ''AND    dt.template_code = ''''RE'''''' || g_nl ||
                         ''AND    flia.line_item_id = dt.line_item_id'' || g_nl ||
                         ''AND    flia.attribute_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id || g_nl ||
                         ''AND    flia.version_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
                         ''AND    fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
                         ''AND    fxata.attribute_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id || g_nl ||
                         ''AND    fxata.version_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id
                        );

Line: 334


SELECT gel_1.company_cost_center_org_id,
' ||l_decode_text
||'
                     SUM (  NVL (gel_1.ytd_credit_balance_e, 0)
                          - NVL (gel_1.ytd_debit_balance_e, 0)
                         ) amount
FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
fem_ext_acct_types_attr feata
WHERE gdt.hierarchy_id = :1
AND gdt.template_code = ''''RE''''
AND gel_1.entry_id = :2
AND  feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
AND  feata.dim_attribute_numeric_member IS NULL
AND flia.value_set_id = ''
            || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
            || ''
AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
AND flia.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
            || ''
AND feata.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
            || ''
AND flia.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
            || ''
AND feata.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
            || ''
AND gel_1.line_item_id = flia.line_item_id
GROUP BY
' ||l_decode_group_text
||', gel_1.company_cost_center_org_id ) src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * -src.amount,
             gel.xtd_balance_e = gel.xtd_balance_e + '' || sign_value || '' * -src.amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.amount), 1, 0,-src.amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.ptd_debit_balance_e = gel.ptd_debit_balance_e + decode(sign(src.amount), 1, 0,-src.amount),
             gel.ptd_credit_balance_e = gel.ptd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.last_update_date = SYSDATE,
             gel.last_updated_by = :3
   WHEN NOT MATCHED THEN
      INSERT (entry_id, line_type_code, description, '||l_gel_dims_text
      ||'gel.xtd_balance_e, gel.ytd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, ''''CALCULATED'''', ''''RE_LINE'''', '||l_src_dims_text
      ||' -src.amount * '' || sign_value || '', -src.amount * '' || sign_value || '',
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              SYSDATE, :3, SYSDATE, :3, :4)
'';

Line: 422


SELECT :6 company_cost_center_org_id,
' ||l_decode_text
||'
                     SUM (  NVL (gel_1.ytd_credit_balance_e, 0)
                          - NVL (gel_1.ytd_debit_balance_e, 0)) amount
FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
fem_ext_acct_types_attr feata
WHERE gdt.hierarchy_id = :1
AND gdt.template_code = ''''RE''''
AND gel_1.entry_id = :2
AND  feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
AND  feata.dim_attribute_numeric_member IS NULL
AND flia.value_set_id = ''
            || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
            || ''
AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
AND flia.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
            || ''
AND feata.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
            || ''
AND flia.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
            || ''
AND feata.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
            || ''
AND gel_1.line_item_id = flia.line_item_id
            GROUP BY
' ||l_decode_group_text
||') src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * -src.amount,
             gel.xtd_balance_e = gel.xtd_balance_e + '' || sign_value || '' * -src.amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.ptd_debit_balance_e = gel.ptd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ptd_credit_balance_e = gel.ptd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.last_update_date = SYSDATE,
             gel.last_updated_by = :3
   WHEN NOT MATCHED THEN
      INSERT (entry_id, line_type_code, description, '||l_gel_dims_text
      ||' gel.xtd_balance_e, gel.ytd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, ''''CALCULATED'''', ''''RE_LINE'''', '||l_src_dims_text
      ||' -src.amount * '' || sign_value || '', -src.amount * '' || sign_value || '',
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              SYSDATE, :3, SYSDATE, :3, :4)
'';

Line: 509


     USING (SELECT   gel_1.company_cost_center_org_id, '||l_gdt_dims_text||'
                     SUM (  NVL (gel_1.ytd_credit_balance_e, 0)
                          - NVL (gel_1.ytd_debit_balance_e, 0)
                         ) amount
FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
fem_ext_acct_types_attr feata
WHERE gdt.hierarchy_id = :1
AND gdt.template_code = ''''RE''''
AND gel_1.entry_id = :2
AND  feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
AND  feata.dim_attribute_numeric_member IS NULL
AND flia.value_set_id = ''
            || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
            || ''
AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
AND flia.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
            || ''
AND feata.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
            || ''
AND flia.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
            || ''
AND feata.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
            || ''
AND gel_1.line_item_id = flia.line_item_id
            GROUP BY '||l_gdt_dims_text||'gel_1.company_cost_center_org_id) src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * -src.amount,
             gel.xtd_balance_e = gel.xtd_balance_e + '' || sign_value || '' * -src.amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.ptd_debit_balance_e = gel.ptd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ptd_credit_balance_e = gel.ptd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.last_update_date = SYSDATE,
             gel.last_updated_by = :5
   WHEN NOT MATCHED THEN
      INSERT (entry_id, line_type_code, description, '||l_gel_dims_text|| 'gel.xtd_balance_e, gel.ytd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, ''''CALCULATED'''', ''''RE_LINE'''', '||l_src_dims_text
      ||' -src.amount * '' || sign_value || '', -src.amount * '' || sign_value || '',
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              SYSDATE, :3, SYSDATE, :3, :4)
'';

Line: 588


     USING (SELECT   :6 company_cost_center_org_id, '||l_gdt_dims_text||'
                     SUM (  NVL (gel_1.ytd_credit_balance_e, 0)
                          - NVL (gel_1.ytd_debit_balance_e, 0)
                         ) amount
FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
fem_ext_acct_types_attr feata
WHERE gdt.hierarchy_id = :1
AND gdt.template_code = ''''RE''''
AND gel_1.entry_id = :2
AND feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
AND feata.dim_attribute_numeric_member IS NULL
AND flia.value_set_id = ''
            || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
            || ''
AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
AND flia.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
            || ''
AND feata.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
            || ''
AND flia.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
            || ''
AND feata.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
            || ''
AND gel_1.line_item_id = flia.line_item_id
            GROUP BY '||SUBSTR(l_gdt_dims_text, 0, LENGTH(l_gdt_dims_text)-2)||') src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * -src.amount,
             gel.xtd_balance_e = gel.xtd_balance_e + '' || sign_value || '' * -src.amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.ptd_debit_balance_e = gel.ptd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ptd_credit_balance_e = gel.ptd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.last_update_date = SYSDATE,
             gel.last_updated_by = :5
   WHEN NOT MATCHED THEN
      INSERT (entry_id, line_type_code, description, '||l_gel_dims_text||'gel.xtd_balance_e, gel.ytd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, ''''CALCULATED'''', ''''RE_LINE'''', '||l_src_dims_text
      ||' -src.amount * '' || sign_value || '', -src.amount * '' || sign_value || '',
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              SYSDATE, :3, SYSDATE, :3, :4)
'';

Line: 723


         SELECT hb.balance_by_org_flag, hb.column_name
           FROM gcs_hierarchies_b hb
          WHERE hb.hierarchy_id = p_hierarchy_id;

Line: 732


      SELECT fxata.number_assign_value
      FROM   gcs_dimension_templates dt,
             fem_ln_items_attr flia,
             fem_ext_acct_types_attr fxata
      WHERE  dt.hierarchy_id = p_hierarchy_id
      AND    dt.template_code = ''RE''
      AND    flia.line_item_id = dt.line_item_id
      AND    flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
      AND    flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
      AND    fxata.ext_account_type_code = flia.dim_attribute_varchar_member
      AND    fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
      AND    fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;

Line: 758


                            ''SELECT hb.balance_by_org_flag, hb.column_name''
                         || g_nl
                         || ''FROM	gcs_hierarchies_b hb ''
                         || g_nl
                         || ''WHERE  hb.hierarchy_id = ''
                         || p_hierarchy_id
                        );

Line: 796


                        ''SELECT specific_intercompany_id FROM gcs_hierarchies_b ''
                        || '' WHERE hierarchy_id =  '' || p_hierarchy_id
                        || '' AND INTERCOMPANY_ORG_TYPE_CODE = ''''SPECIFIC_VALUE'''''');

Line: 814


                         ''SELECT fxata.number_assign_value'' || g_nl ||
                         ''FROM   gcs_dimension_templates dt'' || g_nl ||
                         ''       fem_ln_items_attr flia,'' || g_nl ||
                         ''       fem_ext_acct_types_attr fxata'' || g_nl ||
                         ''WHERE  dt.hierarchy_id = '' || p_hierarchy_id || g_nl ||
                         ''AND    dt.template_code = ''''RE'''''' || g_nl ||
                         ''AND    flia.line_item_id = dt.line_item_id'' || g_nl ||
                         ''AND    flia.attribute_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id || g_nl ||
                         ''AND    flia.version_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
                         ''AND    fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
                         ''AND    fxata.attribute_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id|| g_nl ||
                         ''AND    fxata.version_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id
                        );

Line: 877


SELECT fb.company_cost_center_org_id,
' ||l_decode_text
||'
                     SUM (  NVL (fb.ytd_credit_balance_e, 0)
                          - NVL (fb.ytd_debit_balance_e, 0)
                         ) amount
FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
WHERE gdt.hierarchy_id = :1
AND gdt.template_code = ''''RE''''
AND fb.cal_period_id = :2
AND fb.line_item_id = flia.line_item_id
AND fssb.source_system_display_code = ''''GCS''''
AND fb.hierarchy_id = gdt.hierarchy_id
AND fb.source_system_code = fssb.source_system_code
AND  feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
AND  feata.dim_attribute_numeric_member IS NULL
AND flia.value_set_id = ''
            || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
            || ''
AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
AND flia.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
            || ''
AND feata.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
            || ''
AND flia.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
            || ''
AND feata.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
            || ''
AND fb.line_item_id = flia.line_item_id
GROUP BY
' ||l_decode_group_text
||', fb.company_cost_center_org_id ) src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * -src.amount,
             gel.xtd_balance_e = gel.xtd_balance_e + '' || sign_value || '' * -src.amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.ptd_debit_balance_e = gel.ptd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ptd_credit_balance_e = gel.ptd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.last_update_date = SYSDATE,
             gel.last_updated_by = :3
   WHEN NOT MATCHED THEN
      INSERT (entry_id, line_type_code, description, '||l_gel_dims_text
      ||'gel.xtd_balance_e, gel.ytd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, ''''CALCULATED'''', ''''RE_LINE'''', '||l_src_dims_text
      ||' -src.amount * '' || sign_value || '', -src.amount * '' || sign_value || '',
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              SYSDATE, :3, SYSDATE, :3, :4)
'';

Line: 969


SELECT :6 company_cost_center_org_id,
' ||l_decode_text
||'
                     SUM (  NVL (fb.ytd_credit_balance_e, 0)
                          - NVL (fb.ytd_debit_balance_e, 0)
                         ) amount
FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
WHERE gdt.hierarchy_id = :1
AND gdt.template_code = ''''RE''''
AND fb.cal_period_id = :2
AND fb.line_item_id = flia.line_item_id
AND fssb.source_system_display_code = ''''GCS''''
AND fb.hierarchy_id = gdt.hierarchy_id
AND fb.source_system_code = fssb.source_system_code
AND  feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
AND  feata.dim_attribute_numeric_member IS NULL
AND flia.value_set_id = ''
            || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
            || ''
AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
AND flia.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
            || ''
AND feata.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
            || ''
AND flia.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
            || ''
AND feata.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
            || ''
AND fb.line_item_id = flia.line_item_id
            GROUP BY
' ||l_decode_group_text
||') src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * -src.amount,
             gel.xtd_balance_e = gel.xtd_balance_e + '' || sign_value || '' * -src.amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.ptd_debit_balance_e = gel.ptd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ptd_credit_balance_e = gel.ptd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.last_update_date = SYSDATE,
             gel.last_updated_by = :3
   WHEN NOT MATCHED THEN
      INSERT (entry_id, line_type_code, description, '||l_gel_dims_text
      ||' gel.xtd_balance_e, gel.ytd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, ''''CALCULATED'''', ''''RE_LINE'''', '||l_src_dims_text
      ||' -src.amount * '' || sign_value || '', -src.amount * '' || sign_value || '',
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              SYSDATE, :3, SYSDATE, :3, :4)
'';

Line: 1061


     USING (SELECT   fb.company_cost_center_org_id, '||l_gdt_dims_text||'
                     SUM (  NVL (fb.ytd_credit_balance_e, 0)
                          - NVL (fb.ytd_debit_balance_e, 0)
                         ) amount
FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
WHERE gdt.hierarchy_id = :1
AND gdt.template_code = ''''RE''''
AND fb.cal_period_id = :2
AND fb.line_item_id = flia.line_item_id
AND fssb.source_system_display_code = ''''GCS''''
AND fb.hierarchy_id = gdt.hierarchy_id
AND fb.source_system_code = fssb.source_system_code
AND  feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
AND  feata.dim_attribute_numeric_member IS NULL
AND flia.value_set_id = ''
            || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
            || ''
AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
AND flia.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
            || ''
AND feata.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
            || ''
AND flia.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
            || ''
AND feata.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
            || ''
AND fb.line_item_id = flia.line_item_id
            GROUP BY '||l_gdt_dims_text||'fb.company_cost_center_org_id) src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * -src.amount,
             gel.xtd_balance_e = gel.xtd_balance_e + '' || sign_value || '' * -src.amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.ptd_debit_balance_e = gel.ptd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ptd_credit_balance_e = gel.ptd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.last_update_date = SYSDATE,
             gel.last_updated_by = :5
   WHEN NOT MATCHED THEN
      INSERT (entry_id, line_type_code, description, '||l_gel_dims_text|| 'gel.xtd_balance_e, gel.ytd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, ''''CALCULATED'''', ''''RE_LINE'''', '||l_src_dims_text
      ||' -src.amount * '' || sign_value || '', -src.amount * '' || sign_value || '',
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              SYSDATE, :3, SYSDATE, :3, :4)
'';

Line: 1144


     USING (SELECT   :6 company_cost_center_org_id, '||l_gdt_dims_text||'
                     SUM (  NVL (fb.ytd_credit_balance_e, 0)
                          - NVL (fb.ytd_debit_balance_e, 0)
                         ) amount
FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
WHERE gdt.hierarchy_id = :1
AND gdt.template_code = ''''RE''''
AND fb.cal_period_id = :2
AND fb.line_item_id = flia.line_item_id
AND fssb.source_system_display_code = ''''GCS''''
AND fb.hierarchy_id = gdt.hierarchy_id
AND fb.source_system_code = fssb.source_system_code
AND  feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
AND  feata.dim_attribute_numeric_member IS NULL
AND flia.value_set_id = ''
            || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
            || ''
AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
AND flia.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
            || ''
AND feata.attribute_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
            || ''
AND flia.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info
                                         (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
            || ''
AND feata.version_id = ''
            || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
            || ''
AND fb.line_item_id = flia.line_item_id
            GROUP BY '||SUBSTR(l_gdt_dims_text, 0, LENGTH(l_gdt_dims_text)-2)||') src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * -src.amount,
             gel.xtd_balance_e = gel.xtd_balance_e + '' || sign_value || '' * -src.amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.ptd_debit_balance_e = gel.ptd_debit_balance_e + decode(sign(src.amount), 1, 0, -src.amount),
             gel.ptd_credit_balance_e = gel.ptd_credit_balance_e + decode(sign(src.amount), 1, src.amount, 0),
             gel.last_update_date = SYSDATE,
             gel.last_updated_by = :5
   WHEN NOT MATCHED THEN
      INSERT (entry_id, line_type_code, description, '||l_gel_dims_text||'gel.xtd_balance_e, gel.ytd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, ''''CALCULATED'''', ''''RE_LINE'''', '||l_src_dims_text
      ||' -src.amount * '' || sign_value || '', -src.amount * '' || sign_value || '',
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
              SYSDATE, :3, SYSDATE, :3, :4)
'';

Line: 1274


         SELECT hb.balance_by_org_flag, hb.column_name
           FROM gcs_hierarchies_b hb
          WHERE hb.hierarchy_id = p_hierarchy_id;

Line: 1281


         SELECT cb.category_code,
		cb.category_type_code
           FROM gcs_entry_headers eh,
		gcs_categories_b cb
          WHERE eh.entry_id = p_entry_id
            AND cb.category_code = eh.category_code;

Line: 1293


      SELECT fxata.number_assign_value
      FROM   fem_ln_items_attr flia,
             fem_ext_acct_types_attr fxata
      WHERE  flia.line_item_id = p_template.line_item_id
      AND    flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
      AND    flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
      AND    fxata.ext_account_type_code = flia.dim_attribute_varchar_member
      AND    fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
      AND    fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;

Line: 1335


                     ''SELECT enforce_balancing_flag'' || g_nl ||
                     ''FROM	gcs_data_type_codes_b '' || g_nl ||
                     ''WHERE  data_type_code = '' || p_bal_type_code);

Line: 1339


      SELECT enforce_balancing_flag
      INTO l_enforce_balancing_flag
      FROM gcs_data_type_codes_b
      WHERE data_type_code = p_bal_type_code;

Line: 1359


                            ''SELECT hb.balance_by_org_flag, hb.column_name''
                         || g_nl
                         || ''FROM	gcs_hierarchies_b hb ''
                         || g_nl
                         || ''WHERE  hb.hierarchy_id = ''
                         || p_hierarchy_id
                        );

Line: 1387


                            ''SELECT category_code''
                         || g_nl
                         || ''FROM	gcs_entry_headers ''
                         || g_nl
                         || ''WHERE  entry_id = ''
                         || p_entry_id
                        );

Line: 1410


                        ''SELECT specific_intercompany_id FROM gcs_hierarchies_b ''
                        || '' WHERE hierarchy_id =  '' || p_hierarchy_id
                        || '' AND INTERCOMPANY_ORG_TYPE_CODE = ''''SPECIFIC_VALUE'''''');

Line: 1428


                         ''SELECT fxata.number_assign_value'' || g_nl ||
                         ''FROM   fem_ln_items_attr flia,'' || g_nl ||
                         ''       fem_ext_acct_types_attr fxata'' || g_nl ||
                         ''WHERE  flia.line_item_id = '' || p_template.line_item_id || g_nl ||
                         ''AND    flia.attribute_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id || g_nl ||
                         ''AND    flia.version_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
                         ''AND    fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
                         ''AND    fxata.attribute_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id || g_nl ||
                         ''AND    fxata.version_id = '' ||
                         GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id
                        );

Line: 1461


                            '' select start_cal_period_id, currency_code
        into l_cal_period_id, l_currency_code
        from gcs_entry_headers
        where entry_id = ''  || p_entry_id
                        );

Line: 1468


        select start_cal_period_id, currency_code
        into l_cal_period_id, l_currency_code
        from gcs_entry_headers
        where entry_id = p_entry_id;

Line: 1515


SELECT gel_1.company_cost_center_org_id,
' ||l_bal_decode_text
||'
                     SUM (  NVL (gel_1.ytd_credit_balance_e, 0)
                          - NVL (gel_1.ytd_debit_balance_e, 0)
                         ) ytd_amount,
                     SUM (  NVL (gel_1.ptd_credit_balance_e, 0)
                          - NVL (gel_1.ptd_debit_balance_e, 0)
                         ) ptd_amount
FROM gcs_entry_lines gel_1
WHERE gel_1.entry_id = :2
GROUP BY gel_1.company_cost_center_org_id, ''||secondary_dimension_column||''
HAVING SUM (  NVL (gel_1.ytd_credit_balance_e, 0) - NVL (gel_1.ytd_debit_balance_e, 0) ) <>0 ) src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * src.ytd_amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.ytd_amount), -1, 0, src.ytd_amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.ytd_amount), -1, -src.ytd_amount, 0),'';

Line: 1550


             gel.last_update_date = SYSDATE,
             gel.description = decode(sign(abs(gel.ytd_balance_e + src.ytd_amount)-nvl(:11, 0)), 1, decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_EXCEEDED''''),
      decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_LINE'''')),
             gel.last_updated_by = :3
   WHEN NOT MATCHED THEN
      INSERT (entry_id, description, '||l_gel_dims_text
      ||' gel.xtd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_balance_e, gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, decode(sign(abs(src.ytd_amount)-nvl(:11,0)), 1, decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_EXCEEDED''''),
      decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_LINE'''')), '||l_src_dims_text
      ||' '';

Line: 1625


SELECT :6 company_cost_center_org_id,
' ||l_bal_decode_text
||'
                     SUM (  NVL (gel_1.ytd_credit_balance_e, 0)
                          - NVL (gel_1.ytd_debit_balance_e, 0)) ytd_amount,
                     SUM (  NVL (gel_1.ptd_credit_balance_e, 0)
                          - NVL (gel_1.ptd_debit_balance_e, 0)) ptd_amount
FROM gcs_entry_lines gel_1
WHERE gel_1.entry_id = :2
GROUP BY ''||secondary_dimension_column||''
HAVING SUM (  NVL (gel_1.ytd_credit_balance_e, 0) - NVL (gel_1.ytd_debit_balance_e, 0) ) <>0 ) src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * src.ytd_amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.ytd_amount), -1, 0, src.ytd_amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.ytd_amount), -1, -src.ytd_amount, 0),'';

Line: 1658


             gel.last_update_date = SYSDATE,
             gel.description = decode(sign(abs(gel.ytd_balance_e + src.ytd_amount)-nvl(:11, 0)), 1, decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_EXCEEDED''''),
      decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_LINE'''')),
             gel.last_updated_by = :3
   WHEN NOT MATCHED THEN
      INSERT (entry_id, description, '||l_gel_dims_text
      ||' gel.xtd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_balance_e, gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, decode(sign(abs(src.ytd_amount)-nvl(:11, 0)), 1, decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_EXCEEDED''''),
      decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_LINE'''')), '||l_src_dims_text
      ||' '';

Line: 1720


     USING (SELECT   gel_1.company_cost_center_org_id, '||l_bind_dims_text
     ||'             SUM (  NVL (gel_1.ytd_credit_balance_e, 0)
                          - NVL (gel_1.ytd_debit_balance_e, 0)
                         ) ytd_amount,
                     SUM (  NVL (gel_1.ptd_credit_balance_e, 0)
                          - NVL (gel_1.ptd_debit_balance_e, 0)
                         ) ptd_amount
FROM gcs_entry_lines gel_1
WHERE gel_1.entry_id = :2
GROUP BY company_cost_center_org_id
HAVING SUM (  NVL (gel_1.ytd_credit_balance_e, 0) - NVL (gel_1.ytd_debit_balance_e, 0) ) <>0 ) src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * src.ytd_amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.ytd_amount), -1, 0, src.ytd_amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.ytd_amount), -1, -src.ytd_amount, 0),'';

Line: 1753


             gel.last_update_date = SYSDATE,
             gel.description = decode(sign(abs(gel.ytd_balance_e + src.ytd_amount)-nvl(:11, 0)), 1, decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_EXCEEDED''''),
      decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_LINE'''')),
             gel.last_updated_by = :5
   WHEN NOT MATCHED THEN
      INSERT (entry_id, description, '||l_gel_dims_text
      ||' gel.xtd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_balance_e, gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, decode(sign(abs(src.ytd_amount)-nvl(:11, 0)), 1, decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_EXCEEDED''''),
      decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_LINE'''')), '||l_src_dims_text
      ||' '';

Line: 1826


     USING (SELECT   :4 company_cost_center_org_id,  '||l_bind_dims_text
     ||'
                  SUM (  NVL (gel_1.ytd_credit_balance_e, 0)
                          - NVL (gel_1.ytd_debit_balance_e, 0)
                         ) ytd_amount,
                  SUM (  NVL (gel_1.ptd_credit_balance_e, 0)
                          - NVL (gel_1.ptd_debit_balance_e, 0)
                         ) ptd_amount
FROM gcs_entry_lines gel_1
WHERE gel_1.entry_id = :2
HAVING SUM (  NVL (gel_1.ytd_credit_balance_e, 0) - NVL (gel_1.ytd_debit_balance_e, 0) ) <>0 ) src
        ON (    gel.entry_id = :2
' ||l_equal_text
||')
   WHEN MATCHED THEN
      UPDATE
         SET gel.ytd_balance_e = gel.ytd_balance_e + '' || sign_value || '' * src.ytd_amount,
             gel.ytd_debit_balance_e = gel.ytd_debit_balance_e + decode(sign(src.ytd_amount), -1, 0, src.ytd_amount),
             gel.ytd_credit_balance_e = gel.ytd_credit_balance_e + decode(sign(src.ytd_amount), -1, -src.ytd_amount, 0),'';

Line: 1859


             gel.last_update_date = SYSDATE,
             gel.description = decode(sign(abs(gel.ytd_balance_e + src.ytd_amount)-nvl(:11, 0)), 1, decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_EXCEEDED''''),
      decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_LINE'''')),
             gel.last_updated_by = :5
   WHEN NOT MATCHED THEN
      INSERT (entry_id, description, '||l_gel_dims_text
      ||' gel.xtd_balance_e,
              gel.ptd_debit_balance_e, gel.ptd_credit_balance_e,
              gel.ytd_balance_e, gel.ytd_debit_balance_e, gel.ytd_credit_balance_e,
              creation_date, created_by, last_update_date, last_updated_by,
              last_update_login)
      VALUES (:2, decode(sign(abs(src.ytd_amount)-nvl(:11,0)), 1, decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_EXCEEDED''''),
      decode(:CATEGORY, ''''TRANSLATION'''', ''''CTA_LINE'''', ''''SUSPENSE_LINE'''')), '||l_src_dims_text
      ||' '';

Line: 1919


         SELECT ''Y''
         INTO l_threshold_passed_flag
         FROM dual
         WHERE EXISTS(
                SELECT ''X''
                FROM gcs_entry_lines
                WHERE entry_id = p_entry_id
                AND description = ''SUSPENSE_EXCEEDED'');

Line: 1928


         UPDATE gcs_entry_lines
         SET description = ''SUSPENSE_LINE''
         WHERE description = ''SUSPENSE_EXCEEDED''
         AND entry_id = p_entry_id;

Line: 1939


         UPDATE gcs_entry_headers
            SET suspense_exceeded_flag = ''Y''
          WHERE entry_id = p_entry_id;

Line: 2029


                                  insert_newlines => 'FALSE',
                                  comp_error => err
                                 );

Line: 2056


         SELECT financial_elem_id, product_id, natural_account_id,
                channel_id, line_item_id, project_id, customer_id, task_id,
                user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id,
                user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id,
                user_dim9_id, user_dim10_id
           FROM gcs_dimension_templates
          WHERE hierarchy_id = p_hierarchy_id
            AND template_code = p_template_code;