DBA Data[Home] [Help]

APPS.IGC_UPGRADE_DATA_R12 dependencies on FND_CONCURRENT

Line 20: g_conc_pr_user FND_CONCURRENT_PROGRAMS_VL.user_concurrent_program_name%TYPE;

16: g_sob_id NUMBER := 0;
17: g_sob_name VARCHAR2(50) := NULL;
18: g_cbc_ledger_id gl_ledgers.ledger_id%TYPE := 0;
19: g_cbc_ledger_name VARCHAR2(50) := NULL;
20: g_conc_pr_user FND_CONCURRENT_PROGRAMS_VL.user_concurrent_program_name%TYPE;
21:
22: TYPE t_typ_errors IS RECORD
23: (error_mesg VARCHAR2(4000)
24: );

Line 2031: FROM fnd_concurrent_requests

2027: FUNCTION check_request(p_request_id IN NUMBER) RETURN NUMBER IS
2028: CURSOR c_req(c_request_id IN NUMBER) IS
2029: SELECT parent_request_id,
2030: request_id,level
2031: FROM fnd_concurrent_requests
2032: CONNECT BY PRIOR request_id = parent_request_id
2033: START with request_id = c_request_id
2034: order by request_id;
2035: l_other_request NUMBER;

Line 2049: bln_request_status := FND_CONCURRENT.WAIT_FOR_REQUEST

2045: BEGIN
2046: FOR l_req in c_req(p_request_id)
2047: LOOP
2048: l_other_request := l_req.request_id;
2049: bln_request_status := FND_CONCURRENT.WAIT_FOR_REQUEST
2050: ( request_id =>l_other_request,
2051: phase =>l_req_comp_phase,status => l_req_comp_status,
2052: dev_phase =>l_req_comp_dev_phase,dev_status => l_req_comp_dev_status,
2053: message=>l_req_comp_mesg);

Line 2074: l_conc_pr_name FND_CONCURRENT_PROGRAMS_VL.concurrent_program_name%TYPE;

2070: PROCEDURE print_header(p_balance_type IN VARCHAR2,
2071: p_mode IN VARCHAR2,
2072: p_fiscal_year IN NUMBER) IS
2073: l_conc_id NUMBER := fnd_global.CONC_PROGRAM_ID;
2074: l_conc_pr_name FND_CONCURRENT_PROGRAMS_VL.concurrent_program_name%TYPE;
2075: l_param_out NUMBER;
2076: l_balance_type_param VARCHAR2(240);
2077: l_mode_param VARCHAR2(240);
2078: l_fiscal_year_param VARCHAR2(240);

Line 2084: FROM fnd_concurrent_programs_vl

2080: SELECT concurrent_program_name,
2081: user_concurrent_program_name
2082: INTO l_conc_pr_name,
2083: g_conc_pr_user
2084: FROM fnd_concurrent_programs_vl
2085: WHERE concurrent_program_id = l_conc_id;
2086:
2087: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_conc_pr_name ||(rpad(' ',40,' '))||g_conc_pr_user );
2088: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');