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 FV_TREASURY_SYMBOLS

Line 74: SELECT a.* FROM fv_treasury_symbols a, fv_facts_federal_accounts b

70: l_module_name VARCHAR2(200) ;
71:
72: -- CURSOR DEFINITIONS
73: CURSOR c_treasury_symbol IS
74: SELECT a.* FROM fv_treasury_symbols a, fv_facts_federal_accounts b
75: WHERE b.treasury_dept_code = nvl(p_agency_identifier,b.treasury_dept_code)
76: AND (a.time_frame = 'A' or a.time_frame = 'M')
77: AND a.end_year_avail = p_copy_fiscal_year
78: --AND a.auto_create = 'Y'

Line 109: treasury_symbol_record FV_TREASURY_SYMBOLS%ROWTYPE;

105: AND (authority_duration_code = 'A' or authority_duration_code = 'M');
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;

Line 119: l_cancellation_date FV_TREASURY_SYMBOLS.CANCELLATION_DATE%TYPE;

115: l_max_period GL_PERIODS.PERIOD_NUM%TYPE;
116: l_min_period GL_PERIODS.PERIOD_NUM%TYPE;
117: l_start_date GL_PERIODS.START_DATE%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;

Line 121: l_treasury_symbol_id FV_TREASURY_SYMBOLS.treasury_symbol_id%TYPE;

117: l_start_date GL_PERIODS.START_DATE%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;

Line 157: l_auto_create_flag_betc FV_TREASURY_SYMBOLS.auto_create_flag_betc%TYPE;

153: l_tp_ts_str VARCHAR2(100);
154: tp_tas_duplicate_cnt NUMBER;
155: tp_tas_duplicate_cnt1 NUMBER;
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;

Line 159: l_auto_create_flag_tas FV_TREASURY_SYMBOLS.auto_create%TYPE;

155: tp_tas_duplicate_cnt1 NUMBER;
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;

Line 167: orig_established_fiscal_yr FV_TREASURY_SYMBOLS.established_fiscal_yr%TYPE;

163: bal_seg_suffix NUMBER;
164: bfy_seg_suffix NUMBER;
165: v_default_segment VARCHAR2(1000);
166:
167: orig_established_fiscal_yr FV_TREASURY_SYMBOLS.established_fiscal_yr%TYPE;
168: orig_end_year_avail FV_TREASURY_SYMBOLS.end_year_avail%TYPE;
169:
170: l_phase VARCHAR2(80);
171: l_status VARCHAR2(80);

Line 168: orig_end_year_avail FV_TREASURY_SYMBOLS.end_year_avail%TYPE;

164: bfy_seg_suffix NUMBER;
165: v_default_segment VARCHAR2(1000);
166:
167: orig_established_fiscal_yr FV_TREASURY_SYMBOLS.established_fiscal_yr%TYPE;
168: orig_end_year_avail FV_TREASURY_SYMBOLS.end_year_avail%TYPE;
169:
170: l_phase VARCHAR2(80);
171: l_status VARCHAR2(80);
172: l_dev_status VARCHAR2(80);

Line 250: FROM fv_facts_federal_accounts b, fv_treasury_symbols a

246: END IF;
247:
248: BEGIN
249: SELECT treasury_dept_code, treasury_acct_code into l_treasury_dept_code, l_treasury_acct_code
250: FROM fv_facts_federal_accounts b, fv_treasury_symbols a
251: WHERE a.treasury_symbol_id = l_treasury_symbol_id
252: AND a.federal_acct_symbol_id = b.federal_acct_symbol_id
253: AND a.set_of_books_id = p_ledger_id;
254: EXCEPTION

Line 282: SELECT auto_create INTO l_auto_create_flag_tas FROM fv_treasury_symbols

278: cgac_crttas_record.BPOA := treasury_symbol_record.established_fiscal_yr;
279: cgac_crttas_record.SUB := treasury_symbol_record.tafs_sub_acct;
280:
281: BEGIN
282: SELECT auto_create INTO l_auto_create_flag_tas FROM fv_treasury_symbols
283: WHERE set_of_books_id = p_ledger_id
284: AND treasury_symbol_id = l_treasury_symbol_id;
285: EXCEPTION
286: WHEN NO_DATA_FOUND THEN

Line 298: SELECT auto_create_flag_betc into l_auto_create_flag_betc FROM fv_treasury_symbols where

294: END IF;
295:
296: -- Check if Auto create checkbox on TAS/BETC mapping form is checked
297: BEGIN
298: SELECT auto_create_flag_betc into l_auto_create_flag_betc FROM fv_treasury_symbols where
299: treasury_symbol_id = cgac_crttas_record.original_treasury_symbol_id
300: AND set_of_books_id = p_ledger_id;
301: EXCEPTION
302: WHEN NO_DATA_FOUND THEN

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 392: select count(*)into tas_duplicate_cnt from fv_treasury_symbols where

388: -- Insert New Treasury Symbol values into interface record
389: cgac_crttas_record.treasury_symbol_id := treasury_symbol_record.treasury_symbol_id;
390: cgac_crttas_record.treasury_symbol := treasury_symbol_record.treasury_symbol;
391:
392: select count(*)into tas_duplicate_cnt from fv_treasury_symbols where
393: treasury_symbol = treasury_symbol_record.treasury_symbol
394: or (sub_level_prefix_code = treasury_symbol_record.sub_level_prefix_code and
395: dept_transfer = treasury_symbol_record.dept_transfer and
396: time_frame = treasury_symbol_record.time_frame and

Line 415: -- INSERT INTO fv_treasury_symbols VALUES treasury_symbol_record

411: END IF;
412:
413: IF p_run_mode = 'F' then
414: -- Commented for GSCC error
415: -- INSERT INTO fv_treasury_symbols VALUES treasury_symbol_record
416:
417: INSERT INTO fv_treasury_symbols(TREASURY_SYMBOL_ID,
418: TREASURY_SYMBOL,
419: SET_OF_BOOKS_ID,

Line 417: INSERT INTO fv_treasury_symbols(TREASURY_SYMBOL_ID,

413: IF p_run_mode = 'F' then
414: -- Commented for GSCC error
415: -- INSERT INTO fv_treasury_symbols VALUES treasury_symbol_record
416:
417: INSERT INTO fv_treasury_symbols(TREASURY_SYMBOL_ID,
418: TREASURY_SYMBOL,
419: SET_OF_BOOKS_ID,
420: SF224_TYPE_CODE,
421: FUND_GROUP_CODE,

Line 1287: SELECT fv_treasury_symbols_s.nextval INTO

1283: IF p_run_mode = 'F' then
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;