APPS.GCS_TEMPLATES_DYNAMIC_PKG SQL Statements

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

Line: 14

   SELECT SPECIFIC_INTERCOMPANY_ID
     FROM GCS_CATEGORIES_B
    WHERE CATEGORY_CODE = 'INTRACOMPANY';

Line: 34

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

Line: 43

      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: 81

                            '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: 94

      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: 111

                            '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: 139

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

Line: 157

                         '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: 207

SELECT gel_1.company_cost_center_org_id,

                     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
, gel_1.company_cost_center_org_id ) src
        ON (    gel.entry_id = :2
 AND gel.line_type_code = ''CALCULATED'' )
   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, 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'',  -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: 288

SELECT :6 company_cost_center_org_id,

                     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
) src
        ON (    gel.entry_id = :2
 AND gel.line_type_code = ''CALCULATED'' )
   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,  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'',  -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: 368

     USING (SELECT   gel_1.company_cost_center_org_id, 
                     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 gel_1.company_cost_center_org_id) src
        ON (    gel.entry_id = :2
 AND gel.line_type_code = ''CALCULATED'' )
   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, 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'',  -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: 445

     USING (SELECT   :6 company_cost_center_org_id, 
                     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 ) src
        ON (    gel.entry_id = :2
 AND gel.line_type_code = ''CALCULATED'' )
   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, 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'',  -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: 566

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

Line: 575

      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: 601

                            '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: 639

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

Line: 657

                         '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: 707

SELECT fb.company_cost_center_org_id,

                     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
, fb.company_cost_center_org_id ) src
        ON (    gel.entry_id = :2
 AND gel.line_type_code = ''CALCULATED'' )
   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, 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'',  -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: 792

SELECT :6 company_cost_center_org_id,

                     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
) src
        ON (    gel.entry_id = :2
 AND gel.line_type_code = ''CALCULATED'' )
   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,  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'',  -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: 877

     USING (SELECT   fb.company_cost_center_org_id, 
                     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 fb.company_cost_center_org_id) src
        ON (    gel.entry_id = :2
 AND gel.line_type_code = ''CALCULATED'' )
   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, 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'',  -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: 958

     USING (SELECT   :6 company_cost_center_org_id, 
                     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 ) src
        ON (    gel.entry_id = :2
 AND gel.line_type_code = ''CALCULATED'' )
   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, 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'',  -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: 1073

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

Line: 1080

         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: 1092

      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: 1134

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

Line: 1138

      SELECT enforce_balancing_flag
      INTO l_enforce_balancing_flag
      FROM gcs_data_type_codes_b
      WHERE data_type_code = p_bal_type_code;

Line: 1158

                            '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: 1186

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

Line: 1209

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

Line: 1227

                         '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: 1260

                            ' 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: 1267

        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: 1314

SELECT gel_1.company_cost_center_org_id,

                     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
 AND gel.line_type_code = ''CALCULATED'' )
   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: 1347

             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,  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'')),  ';

Line: 1406

SELECT :6 company_cost_center_org_id,

                     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
 AND gel.line_type_code = ''CALCULATED'' )
   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: 1437

             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,  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'')),  ';

Line: 1496

     USING (SELECT   gel_1.company_cost_center_org_id,              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
 AND gel.line_type_code = ''CALCULATED'' )
   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: 1527

             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,  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'')),  ';

Line: 1584

     USING (SELECT   :4 company_cost_center_org_id,  
                  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
 AND gel.line_type_code = ''CALCULATED'' )
   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: 1615

             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,  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'')),  ';

Line: 1672

         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: 1681

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

Line: 1692

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