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_TP_TREASURY_SYMBOLS

Line 102: SELECT * FROM fv_tp_treasury_symbols

98: AND set_of_books_id = p_ledger_id;
99:
100: --BETC changes
101: CURSOR c_tp_treasury_symbol IS
102: SELECT * FROM fv_tp_treasury_symbols
103: WHERE end_year_avail = p_copy_fiscal_year
104: AND agency_id = nvl(p_agency_identifier_tp,agency_id)
105: AND (authority_duration_code = 'A' or authority_duration_code = 'M');
106: --AND auto_create_flag = 'Y';

Line 152: tp_treasury_symbol_record FV_TP_TREASURY_SYMBOLS%ROWTYPE;

148: fund_duplicate_cnt1 NUMBER;
149:
150: --BETC enhancements
151: l_betc_map_cnt NUMBER DEFAULT 0;
152: tp_treasury_symbol_record FV_TP_TREASURY_SYMBOLS%ROWTYPE;
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;

Line 156: l_tp_treasury_symbol FV_TP_TREASURY_SYMBOLS.treasury_symbol%TYPE;

152: tp_treasury_symbol_record FV_TP_TREASURY_SYMBOLS%ROWTYPE;
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;

Line 158: l_auto_create_flag FV_TP_TREASURY_SYMBOLS.auto_create_flag%TYPE;

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;
162:

Line 1177: FROM fv_tp_treasury_symbols where

1173: -- Partner Treasury Account Symbols form is checked
1174: BEGIN
1175: SELECT auto_create_flag, auto_create_flag_betc into
1176: l_auto_create_flag, l_auto_create_flag_betc
1177: FROM fv_tp_treasury_symbols where
1178: treasury_symbol = cgac_crttas_record.original_treasury_symbol;
1179: EXCEPTION
1180: WHEN NO_DATA_FOUND THEN
1181: l_auto_create_flag := NULL;

Line 1261: select count(*)into tp_tas_duplicate_cnt from fv_tp_treasury_symbols where

1257: ||l_tp_ts_str);
1258: END IF;
1259: cgac_crttas_record.treasury_symbol := l_tp_ts_str;
1260:
1261: select count(*)into tp_tas_duplicate_cnt from fv_tp_treasury_symbols where
1262: treasury_symbol = tp_treasury_symbol_record.treasury_symbol;
1263:
1264: select count(*)into tp_tas_duplicate_cnt1 from fv_cgac_crt_tas_temp where
1265: treasury_symbol = tp_treasury_symbol_record.treasury_symbol;

Line 1286: -- GTAS. To support new treasury_symbol_id column in fv_tp_treasury_symbols

1282:
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

Line 1291: -- INSERT INTO fv_tp_treasury_symbols VALUES tp_treasury_symbol_record;

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,
1293: --SUB_LEVEL_PREFIX_CODE,
1294: DEPT_TRANSFER,
1295: AGENCY_ID,

Line 1292: INSERT INTO fv_tp_treasury_symbols(TREASURY_SYMBOL,

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,
1293: --SUB_LEVEL_PREFIX_CODE,
1294: DEPT_TRANSFER,
1295: AGENCY_ID,
1296: ESTABLISHED_FISCAL_YR,