APPS.FV_CGAC_CRT_TAS dependencies on FV_FUND_PARAMETERS

Line 83: SELECT * FROM fv_fund_parameters

79: AND a.federal_acct_symbol_id = b.federal_acct_symbol_id
80: AND a.set_of_books_id = p_ledger_id;
81:
82: CURSOR c_fund_value(p_treasury_symbol_id NUMBER) IS
83: SELECT * FROM fv_fund_parameters
84: WHERE treasury_symbol_id = p_treasury_symbol_id
85: AND set_of_books_id = p_ledger_id;
86: --AND auto_create='Y';
87:

Line 110: fund_values_record FV_FUND_PARAMETERS%ROWTYPE;

106: --AND auto_create_flag = 'Y';
107:
108: -- RECORD DEFINITIONS
109: treasury_symbol_record FV_TREASURY_SYMBOLS%ROWTYPE;
110: fund_values_record FV_FUND_PARAMETERS%ROWTYPE;
111: bud_distr_hdr_record FV_BUDGET_DISTRIBUTION_HDR%ROWTYPE;
112: bud_distr_dtl_record FV_BUDGET_DISTRIBUTION_DTL%ROWTYPE;
113: cgac_crttas_record FV_CGAC_CRT_TAS_TEMP%ROWTYPE;
114:

Line 122: l_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE;

118: l_end_date GL_PERIODS.END_DATE%TYPE;
119: l_cancellation_date FV_TREASURY_SYMBOLS.CANCELLATION_DATE%TYPE;
120: l_ts_str VARCHAR2(100);
121: l_treasury_symbol_id FV_TREASURY_SYMBOLS.treasury_symbol_id%TYPE;
122: l_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE;
123: l_bud_distribution_id FV_BUDGET_DISTRIBUTION_HDR.distribution_id%TYPE;
124: l_bud_distribution_dtl_id FV_BUDGET_DISTRIBUTION_DTL.distribution_dtl_id%TYPE;
125: l_treasury_acct_code FV_FACTS_FEDERAL_ACCOUNTS.treasury_acct_code%TYPE;
126: l_treasury_dept_code FV_FACTS_FEDERAL_ACCOUNTS.treasury_dept_code%TYPE;

Line 160: l_auto_create_fund FV_FUND_PARAMETERS.auto_create%TYPE;

156: l_tp_treasury_symbol FV_TP_TREASURY_SYMBOLS.treasury_symbol%TYPE;
157: l_auto_create_flag_betc FV_TREASURY_SYMBOLS.auto_create_flag_betc%TYPE;
158: l_auto_create_flag FV_TP_TREASURY_SYMBOLS.auto_create_flag%TYPE;
159: l_auto_create_flag_tas FV_TREASURY_SYMBOLS.auto_create%TYPE;
160: l_auto_create_fund FV_FUND_PARAMETERS.auto_create%TYPE;
161: l_auto_create_dist FV_BUDGET_DISTRIBUTION_HDR.auto_create_flag%TYPE;
162:
163: bal_seg_suffix NUMBER;
164: bfy_seg_suffix NUMBER;

Line 614: SELECT auto_create into l_auto_create_fund FROM fv_fund_parameters

610: cgac_crttas_record.default_segment := NULL;
611: cgac_crttas_record.auto_dist := NULL;
612:
613: BEGIN
614: SELECT auto_create into l_auto_create_fund FROM fv_fund_parameters
615: WHERE treasury_symbol_id = l_treasury_symbol_id
616: AND fund_value = l_fund_value
617: AND set_of_books_id = p_ledger_id;
618: EXCEPTION

Line 645: --Insert new fund records into fv_fund_parameters table and interface table only if a new fund is created.

641: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'New fund value: '||fund_values_record.fund_value);
643: END IF;
644:
645: --Insert new fund records into fv_fund_parameters table and interface table only if a new fund is created.
646: IF fund_values_record.fund_value IS NOT NULL THEN
647:
648: --Insert the fund value into the balancing segment value set
649: -- Getting the Account and Balancing segments' application column names

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 781: INSERT INTO fv_fund_parameters VALUES fund_values_record;

777: fund_values_record.fund_expire_date := treasury_symbol_record.expiration_date;
778: fund_values_record.fund_cancel_date := treasury_symbol_record.cancellation_date;
779:
780: IF p_run_mode = 'F' THEN
781: INSERT INTO fv_fund_parameters VALUES fund_values_record;
782: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
783: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Inserted new fund value');
784: END IF;
785: END IF;