[Home] [Help]
341: CLOSE C_COMPANY_NAME;
342:
343: --Submit the first concurrent program 'Cash Flow Statement - FSG',which
344: --will automatically submit another request for the CFS report to generate XML file
345: l_reqid_fsg:=FND_REQUEST.Submit_Request( 'SQLGL'
346: ,'RGRARG'
347: ,''
348: ,''
349: ,FALSE
449: IF nvl(l_reqid_fsg,0)<>0 AND l_error_flag='N'
450: THEN
451: --Submit the second concurrent program 'Cash flow statement - Calculation'
452: --this parameter is changed by lyb, add p_coa_id and delete p_internal_trx_flag
453: l_reqid_cal:=FND_REQUEST.Submit_Request(application => 'JA'
454: ,program => 'JACNCFSN'
455: ,argument1 => p_legal_entity_id
456: ,argument2 => p_ledger_id
457: ,argument3 => p_period_name
504: --As output of Cash flow statement - Combination' is in XML format and
505: --need to associate with XML publisher template automatically,
506: --it is required to set layout before submit the program, bug 5168016
507:
508: l_xml_layout := FND_REQUEST.Add_Layout(template_appl_name => 'JA'
509: ,template_code => 'JACNCFSC'
510: ,template_language => p_xml_template_language --'zh' ('en')
511: ,template_territory => p_xml_template_territory--'00' ('US')
512: ,output_format => p_xml_output_format --'ETEXT' (
512: ,output_format => p_xml_output_format --'ETEXT' (
513: );
514:
515:
516: l_reqid_comb:=FND_REQUEST.Submit_Request(application => 'JA'
517: ,program => 'JACNCFSC'
518: ,argument1 => l_reqid_fsg
519: ,argument2 => l_reqid_cal
520: );