APPS.FV_CGAC_CRT_TAS SQL Statements

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

Line: 32

        DELETE FROM fv_cgac_crt_tas_temp;

Line: 74

    SELECT a.* FROM fv_treasury_symbols  a, fv_facts_federal_accounts b
    WHERE b.treasury_dept_code = nvl(p_agency_identifier,b.treasury_dept_code)
    AND (a.time_frame = 'A' or a.time_frame = 'M')
    AND a.end_year_avail = p_copy_fiscal_year
    --AND a.auto_create = 'Y'
    AND a.federal_acct_symbol_id = b.federal_acct_symbol_id
    AND a.set_of_books_id = p_ledger_id;

Line: 83

    SELECT * FROM fv_fund_parameters
    WHERE treasury_symbol_id = p_treasury_symbol_id
    AND set_of_books_id = p_ledger_id;

Line: 89

    SELECT * FROM fv_budget_distribution_hdr
    WHERE treasury_symbol_id = p_treasury_symbol_id
    AND set_of_books_id = p_ledger_id
    AND fund_value = p_fund_value;

Line: 95

    SELECT * FROM fv_budget_distribution_dtl
    WHERE distribution_id = p_distribution_hdr_id
    AND fund_value = p_fund_value
    AND set_of_books_id = p_ledger_id;

Line: 102

    SELECT * FROM fv_tp_treasury_symbols
    WHERE end_year_avail = p_copy_fiscal_year
    AND agency_id = nvl(p_agency_identifier_tp,agency_id)
    AND (authority_duration_code = 'A' or authority_duration_code = 'M');

Line: 136

    l_update_query     VARCHAR2(2000);

Line: 193

        select concatenated_segment_delimiter
        into l_flex_delimiter
        from fnd_id_flex_structures flex, gl_ledgers l
        where l.chart_of_accounts_id = flex.id_flex_num
        and l.ledger_id = p_ledger_id
        and flex.id_flex_code = 'GL#'
        and flex.application_id = 101;

Line: 218

        SELECT  chart_of_accounts_id
        INTO    g_coa_id
        FROM    gl_ledgers_public_v
        WHERE   ledger_id = p_ledger_id;

Line: 249

            SELECT treasury_dept_code, treasury_acct_code into l_treasury_dept_code, l_treasury_acct_code
            FROM fv_facts_federal_accounts b, fv_treasury_symbols a
            WHERE a.treasury_symbol_id  = l_treasury_symbol_id
            AND a.federal_acct_symbol_id = b.federal_acct_symbol_id
            AND a.set_of_books_id = p_ledger_id;

Line: 282

            SELECT auto_create INTO l_auto_create_flag_tas FROM fv_treasury_symbols
            WHERE set_of_books_id = p_ledger_id
            AND treasury_symbol_id = l_treasury_symbol_id;

Line: 293

            INSERT INTO fv_cgac_crt_tas_temp values cgac_crttas_record;

Line: 298

            SELECT auto_create_flag_betc into l_auto_create_flag_betc FROM fv_treasury_symbols where
            treasury_symbol_id = cgac_crttas_record.original_treasury_symbol_id
            AND set_of_books_id = p_ledger_id;

Line: 310

            SELECT fv_treasury_symbols_s.nextval INTO  treasury_symbol_record.treasury_symbol_id  from dual;

Line: 339

            treasury_symbol_record.LAST_UPDATE_DATE := sysdate;

Line: 341

            treasury_symbol_record.LAST_UPDATED_BY := l_user_id;

Line: 392

            select count(*)into tas_duplicate_cnt from fv_treasury_symbols where
            treasury_symbol =  treasury_symbol_record.treasury_symbol
            or (sub_level_prefix_code = treasury_symbol_record.sub_level_prefix_code and
            dept_transfer = treasury_symbol_record.dept_transfer and
            time_frame = treasury_symbol_record.time_frame and
            established_fiscal_yr = treasury_symbol_record.established_fiscal_yr and
            end_year_avail = treasury_symbol_record.end_year_avail and
            availability_type_code = treasury_symbol_record.availability_type_code and
            tafs_sub_acct = treasury_symbol_record.tafs_sub_acct);

Line: 402

            select count(*)into tas_duplicate_cnt1 from fv_cgac_crt_tas_temp where
            treasury_symbol = treasury_symbol_record.treasury_symbol;

Line: 409

              INSERT INTO fv_cgac_crt_tas_temp values cgac_crttas_record;

Line: 415

	      -- INSERT INTO fv_treasury_symbols  VALUES treasury_symbol_record

		INSERT INTO fv_treasury_symbols(TREASURY_SYMBOL_ID,
		TREASURY_SYMBOL,
		SET_OF_BOOKS_ID,
		SF224_TYPE_CODE,
		FUND_GROUP_CODE,
		TIME_FRAME,
		ESTABLISHED_FISCAL_YR,
		DEPARTMENT_ID,
		BUREAU_ID,
		LAST_UPDATE_DATE,
		LAST_UPDATED_BY,
		LAST_UPDATE_LOGIN,
		CREATION_DATE,
		CREATED_BY,
		EXPIRATION_DATE,
		CANCELLATION_DATE,
		RESOURCE_TYPE,
		PRECLOSING_UNEXPENDED_AMT,
		CLOSE_REQUISITIONS,
		YEARS_AVAILABLE,
		BUSINESS_LINE,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE_CATEGORY,
		ORG_ID,
		FEDERAL_ACCT_SYMBOL_ID,
		DEPT_TRANSFER,
		TAFS_SUB_ACCT,
		TAFS_SPLIT_CODE,
		TAFS_SPLIT_NAME,
		PUBLIC_LAW_CODE,
		TS_FLAG,
		DEF_INDEF_FLAG,
		SF224_QTR1_OUTLAY,
		SF224_QTR2_OUTLAY,
		SF224_QTR3_OUTLAY,
		SF224_QTR4_OUTLAY,
		CUST_NON_CUST,
		SUB_LEVEL_PREFIX_CODE,
		END_YEAR_AVAIL,
		AVAILABILITY_TYPE_CODE,
		FUND_TYPE,
		FACTS_REPORTABLE_INDICATOR,
		START_DATE,
		RECEIPT_ACCOUNT_INDICATOR,
		AUTO_CREATE,
		--PRECLOSING_SUBCLASS_AMT,
		--SUBCLASS_CODE,
		FINANCING_ACCOUNT,
		NO_PYA_ACCT_FLAG,
		AUTO_CREATE_FLAG_BETC,
		GTAS_REPORTABLE_INDICATOR )  VALUES (
		treasury_symbol_record.TREASURY_SYMBOL_ID,
		treasury_symbol_record.TREASURY_SYMBOL,
		treasury_symbol_record.SET_OF_BOOKS_ID,
		treasury_symbol_record.SF224_TYPE_CODE,
		treasury_symbol_record.FUND_GROUP_CODE,
		treasury_symbol_record.TIME_FRAME,
		treasury_symbol_record.ESTABLISHED_FISCAL_YR,
		treasury_symbol_record.DEPARTMENT_ID,
		treasury_symbol_record.BUREAU_ID,
		treasury_symbol_record.LAST_UPDATE_DATE,
		treasury_symbol_record.LAST_UPDATED_BY,
		treasury_symbol_record.LAST_UPDATE_LOGIN,
		treasury_symbol_record.CREATION_DATE,
		treasury_symbol_record.CREATED_BY,
		treasury_symbol_record.EXPIRATION_DATE,
		treasury_symbol_record.CANCELLATION_DATE,
		treasury_symbol_record.RESOURCE_TYPE,
		treasury_symbol_record.PRECLOSING_UNEXPENDED_AMT,
		treasury_symbol_record.CLOSE_REQUISITIONS,
		treasury_symbol_record.YEARS_AVAILABLE,
		treasury_symbol_record.BUSINESS_LINE,
		treasury_symbol_record.ATTRIBUTE1,
		treasury_symbol_record.ATTRIBUTE2,
		treasury_symbol_record.ATTRIBUTE3,
		treasury_symbol_record.ATTRIBUTE4,
		treasury_symbol_record.ATTRIBUTE5,
		treasury_symbol_record.ATTRIBUTE6,
		treasury_symbol_record.ATTRIBUTE7,
		treasury_symbol_record.ATTRIBUTE8,
		treasury_symbol_record.ATTRIBUTE9,
		treasury_symbol_record.ATTRIBUTE10,
		treasury_symbol_record.ATTRIBUTE11,
		treasury_symbol_record.ATTRIBUTE12,
		treasury_symbol_record.ATTRIBUTE13,
		treasury_symbol_record.ATTRIBUTE14,
		treasury_symbol_record.ATTRIBUTE15,
		treasury_symbol_record.ATTRIBUTE_CATEGORY,
		treasury_symbol_record.ORG_ID,
		treasury_symbol_record.FEDERAL_ACCT_SYMBOL_ID,
		treasury_symbol_record.DEPT_TRANSFER,
		treasury_symbol_record.TAFS_SUB_ACCT,
		treasury_symbol_record.TAFS_SPLIT_CODE,
		treasury_symbol_record.TAFS_SPLIT_NAME,
		treasury_symbol_record.PUBLIC_LAW_CODE,
		treasury_symbol_record.TS_FLAG,
		treasury_symbol_record.DEF_INDEF_FLAG,
		treasury_symbol_record.SF224_QTR1_OUTLAY,
		treasury_symbol_record.SF224_QTR2_OUTLAY,
		treasury_symbol_record.SF224_QTR3_OUTLAY,
		treasury_symbol_record.SF224_QTR4_OUTLAY,
		treasury_symbol_record.CUST_NON_CUST,
		treasury_symbol_record.SUB_LEVEL_PREFIX_CODE,
		treasury_symbol_record.END_YEAR_AVAIL,
		treasury_symbol_record.AVAILABILITY_TYPE_CODE,
		treasury_symbol_record.FUND_TYPE,
		treasury_symbol_record.FACTS_REPORTABLE_INDICATOR,
		treasury_symbol_record.START_DATE,
		treasury_symbol_record.RECEIPT_ACCOUNT_INDICATOR,
		treasury_symbol_record.AUTO_CREATE,
		--treasury_symbol_record.PRECLOSING_SUBCLASS_AMT,
		--treasury_symbol_record.SUBCLASS_CODE,
		treasury_symbol_record.FINANCING_ACCOUNT,
		treasury_symbol_record.NO_PYA_ACCT_FLAG,
		treasury_symbol_record.AUTO_CREATE_FLAG_BETC,
		treasury_symbol_record.GTAS_REPORTABLE_INDICATOR ) ;

Line: 548

                FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Inserted new treasury symbol');

Line: 554

                SELECT COUNT(*) INTO l_betc_map_cnt FROM fv_tas_betc_map WHERE
                treasury_symbol_id = cgac_crttas_record.original_treasury_symbol_id
                AND set_of_books_id = p_ledger_id
                AND (tas_type is null or tas_type='A');

Line: 561

                  INSERT INTO fv_tas_betc_map(
                  treasury_symbol_id,
                  betc_code,
                  set_of_books_id,
                  created_by,
                  last_update_date,
                  last_updated_by,
                  creation_date,
                  last_update_login,
                  tas_type)
                  SELECT
                  treasury_symbol_record.treasury_symbol_id,
                  betc_code,
                  p_ledger_id,
                  l_user_id,
                  sysdate,
                  l_user_id,
                  sysdate,
                  l_user_id,
                  'A'
                  FROM fv_tas_betc_map
                  WHERE treasury_symbol_id = cgac_crttas_record.original_treasury_symbol_id
                  AND set_of_books_id = p_ledger_id;

Line: 614

                SELECT auto_create into l_auto_create_fund FROM fv_fund_parameters
                WHERE treasury_symbol_id = l_treasury_symbol_id
                AND fund_value = l_fund_value
                AND set_of_books_id = p_ledger_id;

Line: 626

                INSERT INTO fv_cgac_crt_tas_temp values cgac_crttas_record;

Line: 695

                    SELECT maximum_size
                    INTO l_max_fund_value_size
                    FROM fnd_flex_value_sets
                    WHERE flex_value_set_name  = x_value_set_name;

Line: 716

                    INSERT INTO fv_cgac_crt_tas_temp values cgac_crttas_record;

Line: 727

                  select count(*)into fund_duplicate_cnt from fnd_flex_values val,  fnd_flex_value_sets vset
                  where val.flex_value = fund_values_record.fund_value and val.flex_value_set_id = vset.flex_value_set_id
                  and vset.flex_value_set_name= x_value_set_name;

Line: 731

                  select count(*) into fund_duplicate_cnt1 from fv_cgac_crt_tas_temp where
                  fund_value = fund_values_record.fund_value;

Line: 738

                    INSERT INTO fv_cgac_crt_tas_temp values cgac_crttas_record;

Line: 741

                    UPDATE fv_cgac_crt_tas_temp SET error_message = 'New Duplicate Fund Value'
                    WHERE fund_value = fund_values_record.fund_value;

Line: 751

                      errbuf := 'Error in inserting fund into value set '||x_value_set_name|| SQLERRM;

Line: 752

                      FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Error in inserting fund into value set '||x_value_set_name|| SQLERRM);

Line: 759

                      FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Fund inserted into balancing segment valueset ');

Line: 766

                  SELECT fv_fund_parameters_s.nextval INTO  fund_values_record.fund_parameter_id  FROM dual;

Line: 770

                  fund_values_record.last_update_date := SYSDATE;

Line: 772

                  fund_values_record.last_updated_by := l_user_id;

Line: 781

                    INSERT INTO fv_fund_parameters VALUES fund_values_record;

Line: 783

                      FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Inserted new fund value');

Line: 788

                    SELECT auto_create_flag into l_auto_create_dist FROM fv_budget_distribution_hdr
                    WHERE treasury_symbol_id = l_treasury_symbol_id
                    AND set_of_books_id = p_ledger_id
                    AND fund_value = l_fund_value;

Line: 800

                  INSERT INTO fv_cgac_crt_tas_temp values cgac_crttas_record;

Line: 802

                    FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,'Inserted into interface record') ;

Line: 812

                      SELECT FV_BE_TRX_HDRS_S.nextval INTO   budget_distribution_hdr_record.distribution_id  FROM dual;

Line: 816

                      budget_distribution_hdr_record.last_update_date := SYSDATE;

Line: 818

                      budget_distribution_hdr_record.last_updated_by := l_user_id;

Line: 822

		       -- INSERT INTO fv_budget_distribution_hdr VALUES  budget_distribution_hdr_record;

Line: 823

			INSERT INTO fv_budget_distribution_hdr
			(DISTRIBUTION_ID,
			FUND_VALUE,
			TREASURY_SYMBOL,
			SET_OF_BOOKS_ID,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_LOGIN,
			ATTRIBUTE1,
			ATTRIBUTE2,
			ATTRIBUTE3,
			ATTRIBUTE4,
			ATTRIBUTE5,
			ATTRIBUTE6,
			ATTRIBUTE7,
			ATTRIBUTE8,
			ATTRIBUTE9,
			ATTRIBUTE10,
			ATTRIBUTE11,
			ATTRIBUTE12,
			ATTRIBUTE13,
			ATTRIBUTE14,
			ATTRIBUTE15,
			ATTRIBUTE_CATEGORY,
			ORG_ID,
			FACTS_PRGM_SEGMENT,
			TREASURY_SYMBOL_ID,
			FREEZE_DEFINITION_FLAG,
			AUTO_CREATE_FLAG)
			VALUES  (
			budget_distribution_hdr_record.DISTRIBUTION_ID,
			budget_distribution_hdr_record.FUND_VALUE,
			budget_distribution_hdr_record.TREASURY_SYMBOL,
			budget_distribution_hdr_record.SET_OF_BOOKS_ID,
			budget_distribution_hdr_record.LAST_UPDATE_DATE,
			budget_distribution_hdr_record.LAST_UPDATED_BY,
			budget_distribution_hdr_record.CREATION_DATE,
			budget_distribution_hdr_record.CREATED_BY,
			budget_distribution_hdr_record.LAST_UPDATE_LOGIN,
			budget_distribution_hdr_record.ATTRIBUTE1,
			budget_distribution_hdr_record.ATTRIBUTE2,
			budget_distribution_hdr_record.ATTRIBUTE3,
			budget_distribution_hdr_record.ATTRIBUTE4,
			budget_distribution_hdr_record.ATTRIBUTE5,
			budget_distribution_hdr_record.ATTRIBUTE6,
			budget_distribution_hdr_record.ATTRIBUTE7,
			budget_distribution_hdr_record.ATTRIBUTE8,
			budget_distribution_hdr_record.ATTRIBUTE9,
			budget_distribution_hdr_record.ATTRIBUTE10,
			budget_distribution_hdr_record.ATTRIBUTE11,
			budget_distribution_hdr_record.ATTRIBUTE12,
			budget_distribution_hdr_record.ATTRIBUTE13,
			budget_distribution_hdr_record.ATTRIBUTE14,
			budget_distribution_hdr_record.ATTRIBUTE15,
			budget_distribution_hdr_record.ATTRIBUTE_CATEGORY,
			budget_distribution_hdr_record.ORG_ID,
			budget_distribution_hdr_record.FACTS_PRGM_SEGMENT,
			budget_distribution_hdr_record.TREASURY_SYMBOL_ID,
			budget_distribution_hdr_record.FREEZE_DEFINITION_FLAG,
			budget_distribution_hdr_record.AUTO_CREATE_FLAG);

Line: 887

                          FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'   Inserted new budget header');

Line: 901

                        SELECT FV_BE_TRX_DTLS_S.nextval INTO   budget_distribution_dtl_record.distribution_dtl_id FROM dual;

Line: 904

                        budget_distribution_dtl_record.last_update_date := SYSDATE;

Line: 906

                        budget_distribution_dtl_record.last_updated_by := l_user_id;

Line: 913

                          SELECT description into cgac_crttas_record.description FROM fv_budget_levels
                          WHERE set_of_books_id = p_ledger_id
                          AND budget_level_id = budget_distribution_dtl_record.budget_level_id;

Line: 923

                          SELECT fyr_segment_value INTO v_fyr_segment_name  FROM  fv_pya_fiscalyear_map
                          WHERE period_year = (p_copy_fiscal_year + 1)
                          AND  set_of_books_id = p_ledger_id;

Line: 936

                          SELECT application_column_name INTO v_bfy_Segment FROM fv_pya_fiscalyear_segment
                          WHERE set_of_books_id=p_ledger_id ;

Line: 947

                        select default_segment into v_default_segment from  fv_budget_distribution_dtl
                        where distribution_dtl_id = l_bud_distribution_dtl_id;

Line: 996

                          INSERT INTO fv_budget_distribution_dtl values budget_distribution_dtl_record;

Line: 999

                            FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Inserted new budget header');

Line: 1002

                          l_update_query := 'UPDATE fv_budget_distribution_dtl SET '||
                          v_bal_seg_name||'='''||fund_values_record.fund_value||''' , '|| v_bfy_Segment||' ='||
                          v_fyr_segment_name||' WHERE distribution_dtl_id = '||budget_distribution_dtl_record.distribution_dtl_id;

Line: 1007

                            FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_update_query);

Line: 1022

                            dbms_sql.parse(l_bud_dtl_cursor, l_update_query, DBMS_SQL.V7) ;

Line: 1034

                            FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.execute_bud_dtl_cursor', 'update statement executed') ;

Line: 1055

                          UPDATE fv_budget_distribution_dtl set default_segment = v_default_segment
                          WHERE distribution_dtl_id = budget_distribution_dtl_record.distribution_dtl_id;

Line: 1058

                          SELECT default_segment INTO cgac_crttas_record.default_segment
                          FROM fv_budget_distribution_dtl
                          WHERE distribution_dtl_id = budget_distribution_dtl_record.distribution_dtl_id;

Line: 1087

          l_fund_prefix_indicator := 'Insert';

Line: 1175

            SELECT auto_create_flag, auto_create_flag_betc into
            l_auto_create_flag, l_auto_create_flag_betc
            FROM fv_tp_treasury_symbols where
            treasury_symbol = cgac_crttas_record.original_treasury_symbol;

Line: 1193

            tp_treasury_symbol_record.LAST_UPDATE_DATE := sysdate;

Line: 1195

            tp_treasury_symbol_record.LAST_UPDATED_BY := l_user_id;

Line: 1261

            select count(*)into tp_tas_duplicate_cnt from fv_tp_treasury_symbols where
            treasury_symbol = tp_treasury_symbol_record.treasury_symbol;

Line: 1264

            select count(*)into tp_tas_duplicate_cnt1 from fv_cgac_crt_tas_temp where
            treasury_symbol = tp_treasury_symbol_record.treasury_symbol;

Line: 1271

              INSERT INTO fv_cgac_crt_tas_temp values cgac_crttas_record;

Line: 1277

          INSERT INTO fv_cgac_crt_tas_temp values cgac_crttas_record;

Line: 1280

          FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,'Inserted TP TAS data into interface record') ;

Line: 1287

              SELECT fv_treasury_symbols_s.nextval INTO
              tp_treasury_symbol_record.treasury_symbol_id  FROM dual;

Line: 1291

	     -- INSERT INTO fv_tp_treasury_symbols  VALUES tp_treasury_symbol_record;

Line: 1292

	     INSERT INTO fv_tp_treasury_symbols(TREASURY_SYMBOL,
              --SUB_LEVEL_PREFIX_CODE,
		DEPT_TRANSFER,
		AGENCY_ID,
		ESTABLISHED_FISCAL_YR,
		END_YEAR_AVAIL,
		AVAILABILITY_TYPE_CODE,
		MAIN_ACCT_CODE,
		SUB_ACCT_CODE,
		CREATED_BY,
		CREATION_DATE,
		LAST_UPDATE_DATE,
		LAST_UPDATE_LOGIN,
		LAST_UPDATED_BY,
		SUB_LEVEL_PREFIX_CODE,
		AUTHORITY_DURATION_CODE,
		FEDERAL_ACCT_SYMBOL_NAME,
		AUTO_CREATE_FLAG,
		END_DATE,
		START_DATE,
		TREASURY_SYMBOL_ID,
		SET_OF_BOOKS_ID,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE_CATEGORY,
		ORG_ID,
		AUTO_CREATE_FLAG_BETC)  VALUES (
		tp_treasury_symbol_record.TREASURY_SYMBOL,
		--tp_treasury_symbol_record.SUB_LEVEL_PREFIX_CODE,
		tp_treasury_symbol_record.DEPT_TRANSFER,
		tp_treasury_symbol_record.AGENCY_ID,
		tp_treasury_symbol_record.ESTABLISHED_FISCAL_YR,
		tp_treasury_symbol_record.END_YEAR_AVAIL,
		tp_treasury_symbol_record.AVAILABILITY_TYPE_CODE,
		tp_treasury_symbol_record.MAIN_ACCT_CODE,
		tp_treasury_symbol_record.SUB_ACCT_CODE,
		tp_treasury_symbol_record.CREATED_BY,
		tp_treasury_symbol_record.CREATION_DATE,
		tp_treasury_symbol_record.LAST_UPDATE_DATE,
		tp_treasury_symbol_record.LAST_UPDATE_LOGIN,
		tp_treasury_symbol_record.LAST_UPDATED_BY,
		tp_treasury_symbol_record.SUB_LEVEL_PREFIX_CODE,
		tp_treasury_symbol_record.AUTHORITY_DURATION_CODE,
		tp_treasury_symbol_record.FEDERAL_ACCT_SYMBOL_NAME,
		tp_treasury_symbol_record.AUTO_CREATE_FLAG,
		tp_treasury_symbol_record.END_DATE,
		tp_treasury_symbol_record.START_DATE,
		tp_treasury_symbol_record.TREASURY_SYMBOL_ID,
		tp_treasury_symbol_record.SET_OF_BOOKS_ID,
		tp_treasury_symbol_record.ATTRIBUTE1,
		tp_treasury_symbol_record.ATTRIBUTE2,
		tp_treasury_symbol_record.ATTRIBUTE3,
		tp_treasury_symbol_record.ATTRIBUTE4,
		tp_treasury_symbol_record.ATTRIBUTE5,
		tp_treasury_symbol_record.ATTRIBUTE6,
		tp_treasury_symbol_record.ATTRIBUTE7,
		tp_treasury_symbol_record.ATTRIBUTE8,
		tp_treasury_symbol_record.ATTRIBUTE9,
		tp_treasury_symbol_record.ATTRIBUTE10,
		tp_treasury_symbol_record.ATTRIBUTE11,
		tp_treasury_symbol_record.ATTRIBUTE12,
		tp_treasury_symbol_record.ATTRIBUTE13,
		tp_treasury_symbol_record.ATTRIBUTE14,
		tp_treasury_symbol_record.ATTRIBUTE15,
		tp_treasury_symbol_record.ATTRIBUTE_CATEGORY,
		tp_treasury_symbol_record.ORG_ID,
		tp_treasury_symbol_record.AUTO_CREATE_FLAG_BETC);

Line: 1374

                FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Inserted new Trading Partner Treasury Account symbol');

Line: 1381

              SELECT COUNT(*) INTO l_betc_map_cnt
              FROM fv_tas_betc_map
              WHERE treasury_symbol_id = cgac_crttas_record.original_treasury_symbol_id
              AND tas_type='T';

Line: 1390

                INSERT INTO fv_tas_betc_map(
                treasury_symbol_id,
                betc_code,
                created_by,
                last_update_date,
                last_updated_by,
                creation_date,
                last_update_login,
                default_flag,
                tas_type,
                set_of_books_id)
                SELECT
                tp_treasury_symbol_record.treasury_symbol_id,
                betc_code,
                l_user_id,
                sysdate,
                l_user_id,
                sysdate,
                l_user_id,
                default_flag,
                'T',
                p_ledger_id
                FROM fv_tas_betc_map
                WHERE treasury_symbol_id = cgac_crttas_record.original_treasury_symbol_id;

Line: 1432

          l_fund_prefix_indicator := 'Insert';