APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_SR_UTIL

Line 980: l_sql := l_sql || qpr_sr_util.get_dblink(g_instance_id);

976: g_t_src_lines(p_src_ctr).SOURCE_REF_LINE_ID;
977: if g_meas_type = ASO_MEAS_TYPE_DEALINT then
978: begin
979: l_sql := 'select QUOTE_LINE_NUMBER from qpr_sr_quote_line_num_v';
980: l_sql := l_sql || qpr_sr_util.get_dblink(g_instance_id);
981: l_sql := l_sql || ' where quote_header_id = :1 ';
982: l_sql := l_sql || ' and quote_line_id = :2 and source_id = :3';
983: execute immediate l_sql into l_line_no using
984: g_t_src_lines(p_src_ctr).SOURCE_REF_HDR_ID,

Line 1804: db_link := qpr_sr_util.get_dblink(p_instance_id);

1800: log_debug('Starting...');
1801: select hsecs into l_start_time from v$timer;
1802: log_debug('Start time :'||
1803: to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
1804: db_link := qpr_sr_util.get_dblink(p_instance_id);
1805:
1806: g_instance_id := p_instance_id;
1807: g_meas_type := p_meas_type;
1808:

Line 1816: if not qpr_sr_util.dm_parameters_ok then

1812: g_login_id := fnd_global.conc_login_id;
1813: g_prg_appl_id := fnd_global.prog_appl_id;
1814: g_prg_id := fnd_global.conc_program_id;
1815:
1816: if not qpr_sr_util.dm_parameters_ok then
1817: retcode:= 2;
1818: FND_MESSAGE.Set_Name ('QPR','QPR_NULL_PARAMETERS');
1819: FND_MSG_PUB.Add;
1820: log_debug('One or more mandatory parameters are not filled');

Line 1965: || src_tbl_name||qpr_sr_util.get_dblink(p_instance_id)

1961: from qpr_instances
1962: where instance_id = p_instance_id);
1963: if p_quote_header_id is null then
1964: l_sql := 'select quote_header_id, quote_header_sd, source_id from '
1965: || src_tbl_name||qpr_sr_util.get_dblink(p_instance_id)
1966: || ' where quote_number = ' || p_quote_number
1967: || ' and quote_version = ' || p_quote_version ;
1968: if p_src_choice = 1 or p_src_choice = 660 then
1969: l_sql := l_sql || ' and order_type_name = ''' || p_order_type || '''';

Line 1974: || src_tbl_name||qpr_sr_util.get_dblink(p_instance_id)

1970: end if;
1971: l_sql := l_sql || ' and rownum < 2';
1972: else
1973: l_sql := 'select quote_header_id, quote_header_sd, source_id from '
1974: || src_tbl_name||qpr_sr_util.get_dblink(p_instance_id)
1975: || ' where quote_header_id = ' || p_quote_header_id;
1976: l_sql := l_sql || ' and rownum < 2';
1977: end if;
1978: log_debug('SQL: '||l_sql);

Line 2060: l_src_tbl := l_src_tbl || qpr_sr_util.get_dblink(p_instance_id);

2056: open c_src_cols(l_src_tbl);
2057: fetch c_src_cols bulk collect into g_src_cols, g_trg_cols;
2058: close c_src_cols;
2059:
2060: l_src_tbl := l_src_tbl || qpr_sr_util.get_dblink(p_instance_id);
2061:
2062: l_sql := get_deal_sql(l_src_tbl, p_tgt_tbl_name);
2063:
2064: return l_sql;