DBA Data[Home] [Help]

APPS.IGC_UPGRADE_DATA_R12 dependencies on FND_GLOBAL

Line 352: SET mig_request_id = FND_GLOBAL.CONC_REQUEST_ID

348:
349: /*Update Request ID of the CBC Upgrade Concurrent program*/
350:
351: UPDATE igc_cbc_je_lines
352: SET mig_request_id = FND_GLOBAL.CONC_REQUEST_ID
353: WHERE reference_1 = l_cbc_line.reference_1
354: AND je_category = l_cbc_line.je_category
355: AND effective_date = l_cbc_line.effective_date
356: AND cbc_je_batch_id = l_cbc_line.cbc_je_batch_id;

Line 1457: MIG_REQUEST_ID = fnd_global.conc_request_id

1453: );
1454: END LOOP; --For all records of GL_SUMMARY_BC_OPTIONS for each template.
1455:
1456: update igc_cbc_summary_templates set MIG_RESULT_CODE = 'T',
1457: MIG_REQUEST_ID = fnd_global.conc_request_id
1458: WHERE template_id = i.template_id;
1459:
1460: /* Submitting "Add/Delete Summary Accounts" concurrent program */
1461:

Line 1512: l_user_id NUMBER := FND_GLOBAL.user_id;

1508:
1509:
1510: PROCEDURE migrate_cbc_bud_jounals(p_fiscal_year IN NUMBER)
1511: IS
1512: l_user_id NUMBER := FND_GLOBAL.user_id;
1513:
1514: l_gl_data_access_set fnd_profile_option_values.profile_option_value%type;
1515:
1516: l_request_id_current NUMBER := fnd_global.conc_request_id;

Line 1516: l_request_id_current NUMBER := fnd_global.conc_request_id;

1512: l_user_id NUMBER := FND_GLOBAL.user_id;
1513:
1514: l_gl_data_access_set fnd_profile_option_values.profile_option_value%type;
1515:
1516: l_request_id_current NUMBER := fnd_global.conc_request_id;
1517: l_request_id_bud NUMBER;
1518: l_request_id_comp NUMBER;
1519:
1520: bln_request_status BOOLEAN;

Line 2073: l_conc_id NUMBER := fnd_global.CONC_PROGRAM_ID;

2069:
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);

Line 2090: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Run Id :'||fnd_global.CONC_REQUEST_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,' ');
2089: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2090: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Run Id :'||fnd_global.CONC_REQUEST_ID);
2091:
2092: --l_param_out := FND_REQUEST_INFO.get_param_info(1,l_balance_type_param);
2093: --l_param_out := FND_REQUEST_INFO.get_param_info(10,l_mode_param);
2094: --l_param_out := FND_REQUEST_INFO.get_param_info(20,l_fiscal_year_param);

Line 2109: SUM(decode(mig_request_id,fnd_global.CONC_REQUEST_ID,

2105: PROCEDURE print_enc_stat(p_fiscal_year IN NUMBER) IS
2106: CURSOR c_result IS
2107: SELECT period_name,
2108: SUM(1) total_count,
2109: SUM(decode(mig_request_id,fnd_global.CONC_REQUEST_ID,
2110: decode(substr(mig_result_code,1,1),'P',1,0)
2111: ,0)) migrated_count,
2112: SUM(decode(substr(mig_result_code,1,1),'P',0,1)) pending_count
2113: FROM igc_cbc_je_lines

Line 2124: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(' ',30,' ')||' '||rpad('In Request Id '||fnd_global.CONC_REQUEST_ID,25,' '));

2120: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2121: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('=',40,'=')||'CBC Encumbrance Migration Result========================'||rpad('=',40,'='));
2122: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2123: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Period Name',30,' ')||' '||rpad('Migrated Lines',25,' ')||' '||rpad('Pending Lines',25,' ')||' '||rpad('Total Lines',25,' '));
2124: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(' ',30,' ')||' '||rpad('In Request Id '||fnd_global.CONC_REQUEST_ID,25,' '));
2125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('-',30,'-')||' '||rpad('-',25,'-')||' '||rpad('-',25,'-')||' '||rpad('-',25,'-'));
2126: FOR l_result IN c_result
2127: LOOP
2128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_result.period_name,30,' ')||' '||rpad(l_result.migrated_count,25,' ')||' '||rpad(l_result.pending_count,25,' ')||' '||rpad(l_result.total_count,25,' '));