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_FACTS_TRANSACTIONS dependencies on FV_FACTS_SUBMISSION

Line 267: SELECT fv_facts_submission.rowid,

263: l_flag NUMBER;
264:
265: -- CGAC: Report only those treasury symbols whose FACTS_REPORTABLE_INDICATOR is I or II or both
266: CURSOR facts_record IS
267: SELECT fv_facts_submission.rowid,
268: fv_facts_submission.Set_Of_Books_Id ,
269: fv_facts_submission.Run_Mode,
270: fv_treasury_symbols.Treasury_Symbol,
271: fv_facts_submission.rep_fyr ,

Line 268: fv_facts_submission.Set_Of_Books_Id ,

264:
265: -- CGAC: Report only those treasury symbols whose FACTS_REPORTABLE_INDICATOR is I or II or both
266: CURSOR facts_record IS
267: SELECT fv_facts_submission.rowid,
268: fv_facts_submission.Set_Of_Books_Id ,
269: fv_facts_submission.Run_Mode,
270: fv_treasury_symbols.Treasury_Symbol,
271: fv_facts_submission.rep_fyr ,
272: fv_facts_submission.rep_period_num,

Line 269: fv_facts_submission.Run_Mode,

265: -- CGAC: Report only those treasury symbols whose FACTS_REPORTABLE_INDICATOR is I or II or both
266: CURSOR facts_record IS
267: SELECT fv_facts_submission.rowid,
268: fv_facts_submission.Set_Of_Books_Id ,
269: fv_facts_submission.Run_Mode,
270: fv_treasury_symbols.Treasury_Symbol,
271: fv_facts_submission.rep_fyr ,
272: fv_facts_submission.rep_period_num,
273: fv_facts_submission.first_name,

Line 271: fv_facts_submission.rep_fyr ,

267: SELECT fv_facts_submission.rowid,
268: fv_facts_submission.Set_Of_Books_Id ,
269: fv_facts_submission.Run_Mode,
270: fv_treasury_symbols.Treasury_Symbol,
271: fv_facts_submission.rep_fyr ,
272: fv_facts_submission.rep_period_num,
273: fv_facts_submission.first_name,
274: fv_facts_submission.last_name,
275: fv_facts_submission.phone_no,

Line 272: fv_facts_submission.rep_period_num,

268: fv_facts_submission.Set_Of_Books_Id ,
269: fv_facts_submission.Run_Mode,
270: fv_treasury_symbols.Treasury_Symbol,
271: fv_facts_submission.rep_fyr ,
272: fv_facts_submission.rep_period_num,
273: fv_facts_submission.first_name,
274: fv_facts_submission.last_name,
275: fv_facts_submission.phone_no,
276: fv_facts_submission.phone_ext,

Line 273: fv_facts_submission.first_name,

269: fv_facts_submission.Run_Mode,
270: fv_treasury_symbols.Treasury_Symbol,
271: fv_facts_submission.rep_fyr ,
272: fv_facts_submission.rep_period_num,
273: fv_facts_submission.first_name,
274: fv_facts_submission.last_name,
275: fv_facts_submission.phone_no,
276: fv_facts_submission.phone_ext,
277: fv_facts_submission.email_address,

Line 274: fv_facts_submission.last_name,

270: fv_treasury_symbols.Treasury_Symbol,
271: fv_facts_submission.rep_fyr ,
272: fv_facts_submission.rep_period_num,
273: fv_facts_submission.first_name,
274: fv_facts_submission.last_name,
275: fv_facts_submission.phone_no,
276: fv_facts_submission.phone_ext,
277: fv_facts_submission.email_address,
278: fv_facts_submission.fax_num ,

Line 275: fv_facts_submission.phone_no,

271: fv_facts_submission.rep_fyr ,
272: fv_facts_submission.rep_period_num,
273: fv_facts_submission.first_name,
274: fv_facts_submission.last_name,
275: fv_facts_submission.phone_no,
276: fv_facts_submission.phone_ext,
277: fv_facts_submission.email_address,
278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,

Line 276: fv_facts_submission.phone_ext,

272: fv_facts_submission.rep_period_num,
273: fv_facts_submission.first_name,
274: fv_facts_submission.last_name,
275: fv_facts_submission.phone_no,
276: fv_facts_submission.phone_ext,
277: fv_facts_submission.email_address,
278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,

Line 277: fv_facts_submission.email_address,

273: fv_facts_submission.first_name,
274: fv_facts_submission.last_name,
275: fv_facts_submission.phone_no,
276: fv_facts_submission.phone_ext,
277: fv_facts_submission.email_address,
278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,

Line 278: fv_facts_submission.fax_num ,

274: fv_facts_submission.last_name,
275: fv_facts_submission.phone_no,
276: fv_facts_submission.phone_ext,
277: fv_facts_submission.email_address,
278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,

Line 279: fv_facts_submission.mothers_m_name ,

275: fv_facts_submission.phone_no,
276: fv_facts_submission.phone_ext,
277: fv_facts_submission.email_address,
278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,

Line 280: fv_facts_submission.supervisor_name ,

276: fv_facts_submission.phone_ext,
277: fv_facts_submission.email_address,
278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,

Line 281: fv_facts_submission.supervisor_phone,

277: fv_facts_submission.email_address,
278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,

Line 282: fv_facts_submission.supervisor_ext ,

278: fv_facts_submission.fax_num ,
279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,
286: fv_facts_submission.address_2 ,

Line 283: fv_facts_submission.agency_name_1 ,

279: fv_facts_submission.mothers_m_name ,
280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,
286: fv_facts_submission.address_2 ,
287: fv_facts_submission.city ,

Line 284: fv_facts_submission.agency_name_2 ,

280: fv_facts_submission.supervisor_name ,
281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,
286: fv_facts_submission.address_2 ,
287: fv_facts_submission.city ,
288: fv_facts_submission.state ,

Line 285: fv_facts_submission.address_1 ,

281: fv_facts_submission.supervisor_phone,
282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,
286: fv_facts_submission.address_2 ,
287: fv_facts_submission.city ,
288: fv_facts_submission.state ,
289: fv_facts_submission.zip ,

Line 286: fv_facts_submission.address_2 ,

282: fv_facts_submission.supervisor_ext ,
283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,
286: fv_facts_submission.address_2 ,
287: fv_facts_submission.city ,
288: fv_facts_submission.state ,
289: fv_facts_submission.zip ,
290: fv_facts_submission.currency_code,

Line 287: fv_facts_submission.city ,

283: fv_facts_submission.agency_name_1 ,
284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,
286: fv_facts_submission.address_2 ,
287: fv_facts_submission.city ,
288: fv_facts_submission.state ,
289: fv_facts_submission.zip ,
290: fv_facts_submission.currency_code,
291: fv_facts_submission.treasury_symbol_id

Line 288: fv_facts_submission.state ,

284: fv_facts_submission.agency_name_2 ,
285: fv_facts_submission.address_1 ,
286: fv_facts_submission.address_2 ,
287: fv_facts_submission.city ,
288: fv_facts_submission.state ,
289: fv_facts_submission.zip ,
290: fv_facts_submission.currency_code,
291: fv_facts_submission.treasury_symbol_id
292: FROM fv_facts_submission ,

Line 289: fv_facts_submission.zip ,

285: fv_facts_submission.address_1 ,
286: fv_facts_submission.address_2 ,
287: fv_facts_submission.city ,
288: fv_facts_submission.state ,
289: fv_facts_submission.zip ,
290: fv_facts_submission.currency_code,
291: fv_facts_submission.treasury_symbol_id
292: FROM fv_facts_submission ,
293: fv_treasury_symbols

Line 290: fv_facts_submission.currency_code,

286: fv_facts_submission.address_2 ,
287: fv_facts_submission.city ,
288: fv_facts_submission.state ,
289: fv_facts_submission.zip ,
290: fv_facts_submission.currency_code,
291: fv_facts_submission.treasury_symbol_id
292: FROM fv_facts_submission ,
293: fv_treasury_symbols
294: WHERE submit_flag = 'Y'

Line 291: fv_facts_submission.treasury_symbol_id

287: fv_facts_submission.city ,
288: fv_facts_submission.state ,
289: fv_facts_submission.zip ,
290: fv_facts_submission.currency_code,
291: fv_facts_submission.treasury_symbol_id
292: FROM fv_facts_submission ,
293: fv_treasury_symbols
294: WHERE submit_flag = 'Y'
295: AND fv_treasury_symbols.set_of_books_id = sob

Line 292: FROM fv_facts_submission ,

288: fv_facts_submission.state ,
289: fv_facts_submission.zip ,
290: fv_facts_submission.currency_code,
291: fv_facts_submission.treasury_symbol_id
292: FROM fv_facts_submission ,
293: fv_treasury_symbols
294: WHERE submit_flag = 'Y'
295: AND fv_treasury_symbols.set_of_books_id = sob
296: AND fv_facts_submission.set_of_books_id = sob

Line 296: AND fv_facts_submission.set_of_books_id = sob

292: FROM fv_facts_submission ,
293: fv_treasury_symbols
294: WHERE submit_flag = 'Y'
295: AND fv_treasury_symbols.set_of_books_id = sob
296: AND fv_facts_submission.set_of_books_id = sob
297: AND fv_facts_submission.treasury_symbol_id =
298: fv_treasury_symbols.treasury_symbol_id
299: AND (fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'II' OR
300: fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'I and II');

Line 297: AND fv_facts_submission.treasury_symbol_id =

293: fv_treasury_symbols
294: WHERE submit_flag = 'Y'
295: AND fv_treasury_symbols.set_of_books_id = sob
296: AND fv_facts_submission.set_of_books_id = sob
297: AND fv_facts_submission.treasury_symbol_id =
298: fv_treasury_symbols.treasury_symbol_id
299: AND (fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'II' OR
300: fv_treasury_symbols.FACTS_REPORTABLE_INDICATOR LIKE 'I and II');
301:

Line 371: UPDATE fv_facts_submission

367: 'No program reporting code mapping found for'||
368: ' Treasury Symbol: '||crec.treasury_symbol||
369: ' and Fund Value: '||vl_fund);
370:
371: UPDATE fv_facts_submission
372: SET submitted_by = fnd_global.user_name,
373: facts2_status = 'NO PRC MAPPED',
374: submit_flag = 'N'
375: WHERE rowid = crec.rowid;

Line 386: UPDATE fv_facts_submission

382: 'No Category B reporting code mapping found for'||
383: ' Treasury Symbol: '||crec.treasury_symbol||
384: ' and Fund Value: '||vl_fund);
385:
386: UPDATE fv_facts_submission
387: SET submitted_by = fnd_global.user_name,
388: facts2_status = 'NO CATB PRC MAPPED',
389: submit_flag = 'N'
390: WHERE rowid = crec.rowid;

Line 403: UPDATE fv_facts_submission

399: 'No Program Category Number reporting code mapping found for'||
400: ' Treasury Symbol: '||crec.treasury_symbol||
401: ' and Fund Value: '||vl_fund);
402:
403: UPDATE fv_facts_submission
404: SET submitted_by = fnd_global.user_name,
405: facts2_status = 'NO PRN PRC MAPPED',
406: submit_flag = 'N'
407: WHERE rowid = crec.rowid;

Line 441: UPDATE fv_facts_submission

437: crec.state,
438: crec.zip,
439: crec.currency_code );
440:
441: UPDATE fv_facts_submission
442: SET submitted_by = fnd_global.user_name,
443: submitted_id = req_id,
444: facts2_status = 'IN PROCESS'
445: WHERE rowid = crec.rowid;

Line 721: ---- Updating fv_facts_submission with the status and uncheck submit flag

717: 'Stopped FACTS Main Process.....') ;
718: END IF;
719: END IF ;
720:
721: ---- Updating fv_facts_submission with the status and uncheck submit flag
722: UPDATE fv_facts_submission
723: SET submit_flag = 'N',
724: facts2_status = vl_facts2_status
725: WHERE submit_flag = 'Y'

Line 722: UPDATE fv_facts_submission

718: END IF;
719: END IF ;
720:
721: ---- Updating fv_facts_submission with the status and uncheck submit flag
722: UPDATE fv_facts_submission
723: SET submit_flag = 'N',
724: facts2_status = vl_facts2_status
725: WHERE submit_flag = 'Y'
726: AND treasury_symbol_id = v_treasury_symbol_id ;

Line 737: UPDATE fv_facts_submission

733: l_module_name||'.final_exception',vp_errbuf);
734:
735: ROLLBACK;
736:
737: UPDATE fv_facts_submission
738: SET submit_flag = 'N',
739: facts2_status = 'ERROR'
740: WHERE submit_flag = 'Y'
741: AND treasury_symbol_id = v_treasury_symbol_id ;

Line 5299: SELECT fv_facts_submission_s.nextval

5295: BEGIN
5296: l_module_name := g_module_name || 'create_bulk_file';
5297: sob := p_ledger_id;
5298: -- get the sequence number
5299: SELECT fv_facts_submission_s.nextval
5300: INTO v3_req_id
5301: FROM DUAL;
5302:
5303: UPDATE fv_facts_submission

Line 5303: UPDATE fv_facts_submission

5299: SELECT fv_facts_submission_s.nextval
5300: INTO v3_req_id
5301: FROM DUAL;
5302:
5303: UPDATE fv_facts_submission
5304: SET bulk_file_sub_id = v3_req_id,
5305: submitted_by = fnd_global.user_name,
5306: facts2_status = 'CREATING BULK FILE'
5307: WHERE bulk_flag = 'Y';

Line 5327: UPDATE fv_facts_submission

5323: COMMIT;
5324: call_status := fnd_concurrent.wait_for_request(v2_req_id, 0, 0, rphase,
5325: rstatus, dphase, dstatus, message);
5326: IF (upper(dstatus) <> 'ERROR') THEN
5327: UPDATE fv_facts_submission
5328: SET run_mode = 'P',
5329: submitted_by = NULL,
5330: submitted_id = NULL,
5331: facts2_status = NULL,