eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_CGAC_CRT_TAS dependencies on DUAL

Line 310: SELECT fv_treasury_symbols_s.nextval INTO treasury_symbol_record.treasury_symbol_id from dual;

306:
307: IF l_auto_create_flag_tas IS NOT NULL and l_auto_create_flag_tas = 'Y' THEN
308:
309: --assigning the new values
310: SELECT fv_treasury_symbols_s.nextval INTO treasury_symbol_record.treasury_symbol_id from dual;
311:
312: --treasury_symbol_record.established_fiscal_yr := p_create_fiscal_year;
313: orig_established_fiscal_yr := treasury_symbol_record.established_fiscal_yr;
314: orig_end_year_avail := treasury_symbol_record.end_year_avail;

Line 766: SELECT fv_fund_parameters_s.nextval INTO fund_values_record.fund_parameter_id FROM dual;

762:
763: -- assigning the values to be inserted into the tables
764: fund_values_record.treasury_symbol_id := treasury_symbol_record.treasury_symbol_id;
765:
766: SELECT fv_fund_parameters_s.nextval INTO fund_values_record.fund_parameter_id FROM dual;
767:
768: fund_values_record.auto_create_fund_value := NULL;
769: fund_values_record.creation_date := SYSDATE;
770: fund_values_record.last_update_date := SYSDATE;

Line 812: SELECT FV_BE_TRX_HDRS_S.nextval INTO budget_distribution_hdr_record.distribution_id FROM dual;

808: -- Bug 1024675
809: cgac_crttas_record.error_message := NULL;
810: cgac_crttas_record.default_segment := NULL;
811:
812: SELECT FV_BE_TRX_HDRS_S.nextval INTO budget_distribution_hdr_record.distribution_id FROM dual;
813: budget_distribution_hdr_record.treasury_symbol_id := treasury_symbol_record.treasury_symbol_id;
814: budget_distribution_hdr_record.fund_value := fund_values_record.fund_value;
815: budget_distribution_hdr_record.creation_date := SYSDATE;
816: budget_distribution_hdr_record.last_update_date := SYSDATE;

Line 901: SELECT FV_BE_TRX_DTLS_S.nextval INTO budget_distribution_dtl_record.distribution_dtl_id FROM dual;

897: budget_distribution_dtl_record.distribution_id := budget_distribution_dtl_record.distribution_id;
898: -- Bug 1024675
899: cgac_crttas_record.error_message := NULL;
900:
901: SELECT FV_BE_TRX_DTLS_S.nextval INTO budget_distribution_dtl_record.distribution_dtl_id FROM dual;
902: budget_distribution_dtl_record.fund_value := fund_values_record.fund_value;
903: budget_distribution_dtl_record.creation_date := SYSDATE;
904: budget_distribution_dtl_record.last_update_date := SYSDATE;
905: budget_distribution_dtl_record.created_by := l_user_id;

Line 1288: tp_treasury_symbol_record.treasury_symbol_id FROM dual;

1284:
1285: IF l_auto_create_flag ='Y' THEN
1286: -- GTAS. To support new treasury_symbol_id column in fv_tp_treasury_symbols
1287: SELECT fv_treasury_symbols_s.nextval INTO
1288: tp_treasury_symbol_record.treasury_symbol_id FROM dual;
1289:
1290: -- Commented for GSCC error
1291: -- INSERT INTO fv_tp_treasury_symbols VALUES tp_treasury_symbol_record;
1292: INSERT INTO fv_tp_treasury_symbols(TREASURY_SYMBOL,