DBA Data[Home] [Help]

APPS.JA_CN_FSG_XML_SUBMIT_PROG dependencies on FND_REQUEST

Line 170: req_id := FND_REQUEST.SUBMIT_REQUEST('SQLGL',

166: END IF;
167:
168: IF (rep_run_type = 'P') THEN
169: X_PROGRAM := 'RGSSRQ';
170: req_id := FND_REQUEST.SUBMIT_REQUEST('SQLGL',
171: 'RGSSRQ',
172: report_rec.report_title,
173: '',
174: FALSE,

Line 217: req_id := FND_REQUEST.SUBMIT_REQUEST('JA',

213: REQUEST_ID = req_id;
214: END IF;
215: ELSE
216: X_PROGRAM := 'JACNFSGC';
217: req_id := FND_REQUEST.SUBMIT_REQUEST('JA',
218: 'JACNFSGC',
219: report_rec.report_title,
220: '',
221: FALSE,

Line 325: x_xml_request_id := fnd_request.submit_request('XDO',

321: g_module_name || '.' || l_procedure_name || '.begin',
322: 'begin procedure');
323: END IF; --l_procedure_level >= l_runtime_level
324: -- submit xml publisher concurrent program
325: x_xml_request_id := fnd_request.submit_request('XDO',
326: 'XDOREPPB',
327: NULL,
328: SYSDATE,
329: FALSE,

Line 1318: ln_reqid_fsg:=FND_REQUEST.Submit_Request( 'SQLGL'

1314: OPEN C_COMPANY_NAME;
1315: FETCH C_COMPANY_NAME INTO lv_company_name;
1316: CLOSE C_COMPANY_NAME;
1317:
1318: ln_reqid_fsg:=FND_REQUEST.Submit_Request( 'SQLGL'
1319: ,'RGRARG'
1320: ,''
1321: ,''
1322: ,FALSE

Line 1419: ln_reqid_cal:=FND_REQUEST.Submit_Request(application => 'JA'

1415: --(4.3)If FSG xml output request for cfs is successfully completed,
1416: -- then submit the second concurrent program 'Cash Flow Statement - Calculation'.
1417: IF nvl(ln_reqid_fsg,0)<>0 AND lv_error_flag='N'
1418: THEN
1419: ln_reqid_cal:=FND_REQUEST.Submit_Request(application => 'JA'
1420: ,program => 'JACNCFSN'
1421: ,argument1 => pn_legal_entity_id
1422: ,argument2 => pn_ledger_id
1423: ,argument3 => pv_period_name

Line 1463: lb_xml_layout := FND_REQUEST.Add_Layout(template_appl_name => 'JA'

1459: --Completed with successful
1460: IF lv_cal_req_status_code='C'
1461: THEN
1462: --Submit the third concurrent program 'Cash flow statement - Combination'
1463: lb_xml_layout := FND_REQUEST.Add_Layout(template_appl_name => 'JA'
1464: ,template_code => 'JACNCFSC'
1465: ,template_language => pv_xml_template_language --'zh' ('en')
1466: ,template_territory => pv_xml_template_territory--'00' ('US')
1467: ,output_format => pv_xml_output_format --'ETEXT'

Line 1470: ln_csf_comb_req_id:=FND_REQUEST.Submit_Request(application => 'JA'

1466: ,template_territory => pv_xml_template_territory--'00' ('US')
1467: ,output_format => pv_xml_output_format --'ETEXT'
1468: );
1469:
1470: ln_csf_comb_req_id:=FND_REQUEST.Submit_Request(application => 'JA'
1471: ,program => 'JACNCFSC'
1472: ,argument1 => ln_reqid_fsg
1473: ,argument2 => ln_reqid_cal
1474: );

Line 1511: ln_reqid_convert:=FND_REQUEST.Submit_Request(application => 'JA'

1507:
1508: --dbms_output.put_line('Invoke Report Item Data Convert program');
1509:
1510: -- (5) Invoke Report Item Data Convert program to covert the FSG output
1511: ln_reqid_convert:=FND_REQUEST.Submit_Request(application => 'JA'
1512: ,program => 'JACNCDCP'
1513: ,argument1 => ln_csf_comb_req_id
1514: ,argument2 => pn_csf_report_num
1515: ,argument3 => ln_balance_sheet_req_id

Line 2316: ln_reqid_fsg:=FND_REQUEST.Submit_Request( 'SQLGL'

2312: OPEN C_COMPANY_NAME;
2313: FETCH C_COMPANY_NAME INTO lv_company_name;
2314: CLOSE C_COMPANY_NAME;
2315:
2316: ln_reqid_fsg:=FND_REQUEST.Submit_Request( 'SQLGL'
2317: ,'RGRARG'
2318: ,''
2319: ,''
2320: ,FALSE

Line 2417: ln_reqid_cal:=FND_REQUEST.Submit_Request(application => 'JA'

2413: --(4.3)If FSG xml output request for cfs is successfully completed,
2414: -- then submit the second concurrent program 'Cash Flow Statement - Calculation'.
2415: IF nvl(ln_reqid_fsg,0)<>0 AND lv_error_flag='N'
2416: THEN
2417: ln_reqid_cal:=FND_REQUEST.Submit_Request(application => 'JA'
2418: ,program => 'JACNCFSN'
2419: ,argument1 => pn_legal_entity_id
2420: ,argument2 => pn_ledger_id
2421: ,argument3 => pv_period_name

Line 2461: lb_xml_layout := FND_REQUEST.Add_Layout(template_appl_name => 'JA'

2457: --Completed with successful
2458: IF lv_cal_req_status_code='C'
2459: THEN
2460: --Submit the third concurrent program 'Cash flow statement - Combination'
2461: lb_xml_layout := FND_REQUEST.Add_Layout(template_appl_name => 'JA'
2462: ,template_code => 'JACNCFSC'
2463: ,template_language => pv_xml_template_language --'zh' ('en')
2464: ,template_territory => pv_xml_template_territory--'00' ('US')
2465: ,output_format => pv_xml_output_format --'ETEXT'

Line 2468: ln_csf_comb_req_id:=FND_REQUEST.Submit_Request(application => 'JA'

2464: ,template_territory => pv_xml_template_territory--'00' ('US')
2465: ,output_format => pv_xml_output_format --'ETEXT'
2466: );
2467:
2468: ln_csf_comb_req_id:=FND_REQUEST.Submit_Request(application => 'JA'
2469: ,program => 'JACNCFSC'
2470: ,argument1 => ln_reqid_fsg
2471: ,argument2 => ln_reqid_cal
2472: );

Line 2509: ln_reqid_convert:=FND_REQUEST.Submit_Request(application => 'JA'

2505:
2506: --dbms_output.put_line('Invoke Report Item Data Convert program');
2507:
2508: -- (5) Invoke Report Item Data Convert program to covert the FSG output
2509: ln_reqid_convert:=FND_REQUEST.Submit_Request(application => 'JA'
2510: ,program => 'JACNCDCP'
2511: ,argument1 => ln_csf_comb_req_id
2512: ,argument2 => pn_csf_report_num
2513: ,argument3 => ln_balance_sheet_req_id