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.QRM_PA_CALCULATION_P dependencies on FND_GLOBAL

Line 986: p_request_id := FND_GLOBAL.conc_request_id;

982: IF (get_settings%NOTFOUND) THEN
983: raise e_no_setting_found;
984: -- if called by Concurrent Manager and in progress, raise exception
985: ELSIF (p_settings.status = '3' AND p_source <> 'AM') THEN
986: p_request_id := FND_GLOBAL.conc_request_id;
987: call_status := FND_CONCURRENT.get_request_status(
988: p_request_id,'','', rphase, rstatus,
989: dphase, dstatus, message);
990: IF (g_proc_level>=g_debug_level) THEN

Line 1197: process_id = FND_GLOBAL.conc_request_id,

1193: -- update status column to "In Progress"
1194: -- updates both history_flag='C' and 'S' rows in analysis settings
1195: UPDATE qrm_analysis_settings
1196: SET status = '3',
1197: process_id = FND_GLOBAL.conc_request_id,
1198: last_run_date = p_ref_datetime,
1199: dirty = 'N'
1200: WHERE analysis_name = p_analysis_name;
1201:

Line 6198: FND_GLOBAL.user_id, p_ref_datetime,

6194: p_gap_date_insert(j), p_reval_price_insert(j),
6195: p_reval_price_usd_insert(j), p_reval_price_sob_insert(j),
6196: p_trans_price_insert(j), p_trans_price_usd_insert(j),
6197: p_trans_price_sob_insert(j), p_ref_datetime,
6198: FND_GLOBAL.user_id, p_ref_datetime,
6199: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6200: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6201: FND_GLOBAL.conc_program_id, p_ref_datetime);
6202:

Line 6199: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,

6195: p_reval_price_usd_insert(j), p_reval_price_sob_insert(j),
6196: p_trans_price_insert(j), p_trans_price_usd_insert(j),
6197: p_trans_price_sob_insert(j), p_ref_datetime,
6198: FND_GLOBAL.user_id, p_ref_datetime,
6199: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6200: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6201: FND_GLOBAL.conc_program_id, p_ref_datetime);
6202:
6203: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 6200: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,

6196: p_trans_price_insert(j), p_trans_price_usd_insert(j),
6197: p_trans_price_sob_insert(j), p_ref_datetime,
6198: FND_GLOBAL.user_id, p_ref_datetime,
6199: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6200: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6201: FND_GLOBAL.conc_program_id, p_ref_datetime);
6202:
6203: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6204: XTR_RISK_DEBUG_PKG.dlog('DML','INSERTED QRM_DEAL_CALCULATIONS',

Line 6201: FND_GLOBAL.conc_program_id, p_ref_datetime);

6197: p_trans_price_sob_insert(j), p_ref_datetime,
6198: FND_GLOBAL.user_id, p_ref_datetime,
6199: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6200: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6201: FND_GLOBAL.conc_program_id, p_ref_datetime);
6202:
6203: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6204: XTR_RISK_DEBUG_PKG.dlog('DML','INSERTED QRM_DEAL_CALCULATIONS',
6205: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

Line 6345: created_by=FND_GLOBAL.user_id,

6341: volatility=p_volatility_update(j),
6342: yield_to_maturity=p_ytm_update(j),
6343: gap_date=p_gap_date_update(j),
6344: last_md_calc_date=p_upd_md_calc_date_update(j),
6345: created_by=FND_GLOBAL.user_id,
6346: creation_date=p_ref_datetime, last_updated_by=FND_GLOBAL.user_id,
6347: last_update_date=p_ref_datetime,
6348: last_update_login=FND_GLOBAL.login_id,
6349: request_id=FND_GLOBAL.conc_request_id,

Line 6346: creation_date=p_ref_datetime, last_updated_by=FND_GLOBAL.user_id,

6342: yield_to_maturity=p_ytm_update(j),
6343: gap_date=p_gap_date_update(j),
6344: last_md_calc_date=p_upd_md_calc_date_update(j),
6345: created_by=FND_GLOBAL.user_id,
6346: creation_date=p_ref_datetime, last_updated_by=FND_GLOBAL.user_id,
6347: last_update_date=p_ref_datetime,
6348: last_update_login=FND_GLOBAL.login_id,
6349: request_id=FND_GLOBAL.conc_request_id,
6350: program_application_id=FND_GLOBAL.prog_appl_id,

Line 6348: last_update_login=FND_GLOBAL.login_id,

6344: last_md_calc_date=p_upd_md_calc_date_update(j),
6345: created_by=FND_GLOBAL.user_id,
6346: creation_date=p_ref_datetime, last_updated_by=FND_GLOBAL.user_id,
6347: last_update_date=p_ref_datetime,
6348: last_update_login=FND_GLOBAL.login_id,
6349: request_id=FND_GLOBAL.conc_request_id,
6350: program_application_id=FND_GLOBAL.prog_appl_id,
6351: program_id=FND_GLOBAL.conc_program_id,
6352: program_update_date=p_ref_datetime

Line 6349: request_id=FND_GLOBAL.conc_request_id,

6345: created_by=FND_GLOBAL.user_id,
6346: creation_date=p_ref_datetime, last_updated_by=FND_GLOBAL.user_id,
6347: last_update_date=p_ref_datetime,
6348: last_update_login=FND_GLOBAL.login_id,
6349: request_id=FND_GLOBAL.conc_request_id,
6350: program_application_id=FND_GLOBAL.prog_appl_id,
6351: program_id=FND_GLOBAL.conc_program_id,
6352: program_update_date=p_ref_datetime
6353: WHERE deal_calc_id = p_deal_calc_id_update(j);

Line 6350: program_application_id=FND_GLOBAL.prog_appl_id,

6346: creation_date=p_ref_datetime, last_updated_by=FND_GLOBAL.user_id,
6347: last_update_date=p_ref_datetime,
6348: last_update_login=FND_GLOBAL.login_id,
6349: request_id=FND_GLOBAL.conc_request_id,
6350: program_application_id=FND_GLOBAL.prog_appl_id,
6351: program_id=FND_GLOBAL.conc_program_id,
6352: program_update_date=p_ref_datetime
6353: WHERE deal_calc_id = p_deal_calc_id_update(j);
6354:

Line 6351: program_id=FND_GLOBAL.conc_program_id,

6347: last_update_date=p_ref_datetime,
6348: last_update_login=FND_GLOBAL.login_id,
6349: request_id=FND_GLOBAL.conc_request_id,
6350: program_application_id=FND_GLOBAL.prog_appl_id,
6351: program_id=FND_GLOBAL.conc_program_id,
6352: program_update_date=p_ref_datetime
6353: WHERE deal_calc_id = p_deal_calc_id_update(j);
6354:
6355: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 6375: FND_GLOBAL.user_id||','|| p_ref_datetime||','|| FND_GLOBAL.user_id||','||

6371:
6372: IF (g_state_level>=g_debug_level) THEN --bug 3236479
6373: for j in 1..p_insert_counter loop
6374: v_log := p_seq_nos(j)||','|| p_analysis_name||','|| p_company_code_insert(j)||','||
6375: FND_GLOBAL.user_id||','|| p_ref_datetime||','|| FND_GLOBAL.user_id||','||
6376: p_ref_datetime||','|| FND_GLOBAL.login_id||','|| FND_GLOBAL.conc_request_id||','||
6377: FND_GLOBAL.prog_appl_id||','|| FND_GLOBAL.conc_program_id||','||p_ref_datetime;
6378: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEALS_ANALYSES',v_log,
6379: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

Line 6376: p_ref_datetime||','|| FND_GLOBAL.login_id||','|| FND_GLOBAL.conc_request_id||','||

6372: IF (g_state_level>=g_debug_level) THEN --bug 3236479
6373: for j in 1..p_insert_counter loop
6374: v_log := p_seq_nos(j)||','|| p_analysis_name||','|| p_company_code_insert(j)||','||
6375: FND_GLOBAL.user_id||','|| p_ref_datetime||','|| FND_GLOBAL.user_id||','||
6376: p_ref_datetime||','|| FND_GLOBAL.login_id||','|| FND_GLOBAL.conc_request_id||','||
6377: FND_GLOBAL.prog_appl_id||','|| FND_GLOBAL.conc_program_id||','||p_ref_datetime;
6378: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEALS_ANALYSES',v_log,
6379: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6380: end loop;

Line 6377: FND_GLOBAL.prog_appl_id||','|| FND_GLOBAL.conc_program_id||','||p_ref_datetime;

6373: for j in 1..p_insert_counter loop
6374: v_log := p_seq_nos(j)||','|| p_analysis_name||','|| p_company_code_insert(j)||','||
6375: FND_GLOBAL.user_id||','|| p_ref_datetime||','|| FND_GLOBAL.user_id||','||
6376: p_ref_datetime||','|| FND_GLOBAL.login_id||','|| FND_GLOBAL.conc_request_id||','||
6377: FND_GLOBAL.prog_appl_id||','|| FND_GLOBAL.conc_program_id||','||p_ref_datetime;
6378: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEALS_ANALYSES',v_log,
6379: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6380: end loop;
6381: for j in 1..p_update_counter loop

Line 6394: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.user_id,

6390: company_code, created_by, creation_date, last_updated_by,
6391: last_update_date, last_update_login, request_id,
6392: program_application_id, program_id, program_update_date)
6393: VALUES (p_seq_nos(j), p_analysis_name, p_company_code_insert(j),
6394: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.user_id,
6395: p_ref_datetime, FND_GLOBAL.login_id, FND_GLOBAL.conc_request_id,
6396: FND_GLOBAL.prog_appl_id, FND_GLOBAL.conc_program_id,p_ref_datetime);
6397: -- add links for updated deals
6398: FORALL j IN 1..p_update_counter

Line 6395: p_ref_datetime, FND_GLOBAL.login_id, FND_GLOBAL.conc_request_id,

6391: last_update_date, last_update_login, request_id,
6392: program_application_id, program_id, program_update_date)
6393: VALUES (p_seq_nos(j), p_analysis_name, p_company_code_insert(j),
6394: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.user_id,
6395: p_ref_datetime, FND_GLOBAL.login_id, FND_GLOBAL.conc_request_id,
6396: FND_GLOBAL.prog_appl_id, FND_GLOBAL.conc_program_id,p_ref_datetime);
6397: -- add links for updated deals
6398: FORALL j IN 1..p_update_counter
6399: INSERT INTO qrm_deals_analyses (deal_calc_id, analysis_name,

Line 6396: FND_GLOBAL.prog_appl_id, FND_GLOBAL.conc_program_id,p_ref_datetime);

6392: program_application_id, program_id, program_update_date)
6393: VALUES (p_seq_nos(j), p_analysis_name, p_company_code_insert(j),
6394: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.user_id,
6395: p_ref_datetime, FND_GLOBAL.login_id, FND_GLOBAL.conc_request_id,
6396: FND_GLOBAL.prog_appl_id, FND_GLOBAL.conc_program_id,p_ref_datetime);
6397: -- add links for updated deals
6398: FORALL j IN 1..p_update_counter
6399: INSERT INTO qrm_deals_analyses (deal_calc_id, analysis_name,
6400: company_code, created_by, creation_date, last_updated_by,

Line 6404: p_company_code_update(j), FND_GLOBAL.user_id, p_ref_datetime,

6400: company_code, created_by, creation_date, last_updated_by,
6401: last_update_date, last_update_login, request_id,
6402: program_application_id, program_id, program_update_date)
6403: VALUES (p_deal_calc_id_update(j), p_analysis_name,
6404: p_company_code_update(j), FND_GLOBAL.user_id, p_ref_datetime,
6405: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6406: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6407: FND_GLOBAL.conc_program_id, p_ref_datetime);
6408:

Line 6405: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,

6401: last_update_date, last_update_login, request_id,
6402: program_application_id, program_id, program_update_date)
6403: VALUES (p_deal_calc_id_update(j), p_analysis_name,
6404: p_company_code_update(j), FND_GLOBAL.user_id, p_ref_datetime,
6405: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6406: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6407: FND_GLOBAL.conc_program_id, p_ref_datetime);
6408:
6409: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 6406: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,

6402: program_application_id, program_id, program_update_date)
6403: VALUES (p_deal_calc_id_update(j), p_analysis_name,
6404: p_company_code_update(j), FND_GLOBAL.user_id, p_ref_datetime,
6405: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6406: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6407: FND_GLOBAL.conc_program_id, p_ref_datetime);
6408:
6409: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6410: XTR_RISK_DEBUG_PKG.dlog('DML','INSERTED QRM_DEAL_ANALYSES',

Line 6407: FND_GLOBAL.conc_program_id, p_ref_datetime);

6403: VALUES (p_deal_calc_id_update(j), p_analysis_name,
6404: p_company_code_update(j), FND_GLOBAL.user_id, p_ref_datetime,
6405: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6406: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6407: FND_GLOBAL.conc_program_id, p_ref_datetime);
6408:
6409: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6410: XTR_RISK_DEBUG_PKG.dlog('DML','INSERTED QRM_DEAL_ANALYSES',
6411: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

Line 6463: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.user_id,

6459: p_tb_interest_basis(j), p_tb_outst_amount(j),
6460: p_tb_outst_amount_usd(j), p_tb_outst_amount_sob(j),
6461: p_tb_coupon_rate(j), p_tb_next_coupon_date(j), p_tb_amt_qty_out(j),
6462: p_tb_amt_qty_out_usd(j), p_tb_amt_qty_out_sob(j),
6463: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.user_id,
6464: p_ref_datetime, FND_GLOBAL.login_id, FND_GLOBAL.conc_request_id,
6465: FND_GLOBAL.prog_appl_id,FND_GLOBAL.conc_program_id,p_ref_datetime);
6466:
6467: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 6464: p_ref_datetime, FND_GLOBAL.login_id, FND_GLOBAL.conc_request_id,

6460: p_tb_outst_amount_usd(j), p_tb_outst_amount_sob(j),
6461: p_tb_coupon_rate(j), p_tb_next_coupon_date(j), p_tb_amt_qty_out(j),
6462: p_tb_amt_qty_out_usd(j), p_tb_amt_qty_out_sob(j),
6463: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.user_id,
6464: p_ref_datetime, FND_GLOBAL.login_id, FND_GLOBAL.conc_request_id,
6465: FND_GLOBAL.prog_appl_id,FND_GLOBAL.conc_program_id,p_ref_datetime);
6466:
6467: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6468: XTR_RISK_DEBUG_PKG.dlog('DML','INSERTED QRM_TB_CALCULATIONS',

Line 6465: FND_GLOBAL.prog_appl_id,FND_GLOBAL.conc_program_id,p_ref_datetime);

6461: p_tb_coupon_rate(j), p_tb_next_coupon_date(j), p_tb_amt_qty_out(j),
6462: p_tb_amt_qty_out_usd(j), p_tb_amt_qty_out_sob(j),
6463: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.user_id,
6464: p_ref_datetime, FND_GLOBAL.login_id, FND_GLOBAL.conc_request_id,
6465: FND_GLOBAL.prog_appl_id,FND_GLOBAL.conc_program_id,p_ref_datetime);
6466:
6467: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6468: XTR_RISK_DEBUG_PKG.dlog('DML','INSERTED QRM_TB_CALCULATIONS',
6469: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

Line 6802: p_except_token_value(j), FND_GLOBAL.user_id, p_ref_datetime,

6798: request_id, program_application_id, program_id, program_update_date)
6799: VALUES (p_analysis_name, p_except_deal_no(j), p_except_transaction_no(j),
6800: p_except_market_data_set(j), p_except_error_type(j),
6801: p_except_error_code(j), p_except_token_name(j),
6802: p_except_token_value(j), FND_GLOBAL.user_id, p_ref_datetime,
6803: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6804: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6805: FND_GLOBAL.conc_program_id, p_ref_datetime);
6806:

Line 6803: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,

6799: VALUES (p_analysis_name, p_except_deal_no(j), p_except_transaction_no(j),
6800: p_except_market_data_set(j), p_except_error_type(j),
6801: p_except_error_code(j), p_except_token_name(j),
6802: p_except_token_value(j), FND_GLOBAL.user_id, p_ref_datetime,
6803: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6804: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6805: FND_GLOBAL.conc_program_id, p_ref_datetime);
6806:
6807: COMMIT;

Line 6804: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,

6800: p_except_market_data_set(j), p_except_error_type(j),
6801: p_except_error_code(j), p_except_token_name(j),
6802: p_except_token_value(j), FND_GLOBAL.user_id, p_ref_datetime,
6803: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6804: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6805: FND_GLOBAL.conc_program_id, p_ref_datetime);
6806:
6807: COMMIT;
6808:

Line 6805: FND_GLOBAL.conc_program_id, p_ref_datetime);

6801: p_except_error_code(j), p_except_token_name(j),
6802: p_except_token_value(j), FND_GLOBAL.user_id, p_ref_datetime,
6803: FND_GLOBAL.user_id, p_ref_datetime, FND_GLOBAL.login_id,
6804: FND_GLOBAL.conc_request_id, FND_GLOBAL.prog_appl_id,
6805: FND_GLOBAL.conc_program_id, p_ref_datetime);
6806:
6807: COMMIT;
6808:
6809: IF (g_event_level>=g_debug_level) THEN --bug 3236479