APPS.GCS_AD_TRIALBALANCE_PKG dependencies on GCS_ENTRY_LINES

Line 558: from gcs_entry_lines where entry_id = -1 and financial_elem_id = 140'

554: THEN
555: fnd_log.STRING (fnd_log.level_statement,
556: g_pkg_name || '.' || l_api_name,
557: 'select decode(count(entry_id), 0, ''ACTUAL'', ''ADB'') into l_balance_type_code
558: from gcs_entry_lines where entry_id = -1 and financial_elem_id = 140'
559: );
560: END IF;
561: select decode(count(entry_id), 0, 'ACTUAL', 'ADB')
562: into l_balance_type_code

Line 563: from gcs_entry_lines

559: );
560: END IF;
561: select decode(count(entry_id), 0, 'ACTUAL', 'ADB')
562: into l_balance_type_code
563: from gcs_entry_lines
564: where entry_id = -1
565: and financial_elem_id = 140;
566:
567: l_elim_entity_id := get_elim_entity_id(p_consolidation_entity_id => p_consolidation_entity_id);

Line 588: 'delete from gcs_entry_lines'

584: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
585: THEN
586: fnd_log.STRING (fnd_log.level_statement,
587: g_pkg_name || '.' || l_api_name,
588: 'delete from gcs_entry_lines'
589: || g_nl
590: || 'where entry_id = '
591: || l_entry_id
592: );

Line 595: DELETE FROM gcs_entry_lines

591: || l_entry_id
592: );
593: END IF;
594:
595: DELETE FROM gcs_entry_lines
596: WHERE entry_id = l_entry_id;
597:
598:
599: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

Line 603: 'update gcs_entry_lines'

599: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
600: THEN
601: fnd_log.STRING (fnd_log.level_statement,
602: g_pkg_name || '.' || l_api_name,
603: 'update gcs_entry_lines'
604: || g_nl
605: || 'set entry_id = '
606: || l_entry_id
607: || ', last_update_date = sysdate,'

Line 612: WHERE gcs_entry_lines.line_item_id =

608: || g_nl
609: || ' line_type_code = decode((SELECT feata.dim_attribute_varchar_member
610: FROM fem_ext_acct_types_attr feata,
611: fem_ln_items_attr flia
612: WHERE gcs_entry_lines.line_item_id =
613: flia.line_item_id
614: AND flia.value_set_id =' ||
615: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id || '
616: AND flia.attribute_id = '||

Line 633: UPDATE gcs_entry_lines

629: );
630: END IF;
631:
632: --Bugfix 4332257 : Resolved the Issue with YTD_BALANCE_E not being populated
633: UPDATE gcs_entry_lines
634: SET entry_id = l_entry_id,
635: last_update_date = sysdate,
636: ytd_balance_e = NVL(ytd_debit_balance_e, 0) - NVL(ytd_credit_balance_e, 0),
637: line_type_code = decode(

Line 641: WHERE gcs_entry_lines.line_item_id = flia.line_item_id

637: line_type_code = decode(
638: (SELECT feata.dim_attribute_varchar_member
639: FROM fem_ext_acct_types_attr feata,
640: fem_ln_items_attr flia
641: WHERE gcs_entry_lines.line_item_id = flia.line_item_id
642: AND flia.value_set_id = l_line_item_vs_id
643: AND flia.attribute_id = l_ext_acct_type_attr
644: AND flia.version_id = l_ext_acct_type_version
645: AND feata.attribute_id = l_basic_acct_type_attr

Line 1258: 'DELETE FROM gcs_entry_lines WHERE entry_id = '

1254: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1255: THEN
1256: fnd_log.STRING (fnd_log.level_statement,
1257: g_pkg_name || '.' || l_api_name,
1258: 'DELETE FROM gcs_entry_lines WHERE entry_id = '
1259: || l_entry_id
1260: );
1261: END IF;
1262: delete from gcs_entry_lines where entry_id = l_entry_id;

Line 1262: delete from gcs_entry_lines where entry_id = l_entry_id;

1258: 'DELETE FROM gcs_entry_lines WHERE entry_id = '
1259: || l_entry_id
1260: );
1261: END IF;
1262: delete from gcs_entry_lines where entry_id = l_entry_id;
1263: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1264: THEN
1265: fnd_log.STRING (fnd_log.level_statement,
1266: g_pkg_name || '.' || l_api_name,