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.PV_PARTNER_TREND_PVT dependencies on JTF_NUMBER_TABLE

Line 172: l_attr_trend_id_tbl jtf_number_table;

168:
169: l_last_incr_refresh_str VARCHAR2(100);
170: l_last_incr_refresh_date DATE;
171:
172: l_attr_trend_id_tbl jtf_number_table;
173: l_partner_id_tbl jtf_number_table;
174: l_attribute_id_tbl jtf_number_table;
175: l_result_tbl jtf_number_table;
176: l_month_tbl jtf_varchar2_table_4000;

Line 173: l_partner_id_tbl jtf_number_table;

169: l_last_incr_refresh_str VARCHAR2(100);
170: l_last_incr_refresh_date DATE;
171:
172: l_attr_trend_id_tbl jtf_number_table;
173: l_partner_id_tbl jtf_number_table;
174: l_attribute_id_tbl jtf_number_table;
175: l_result_tbl jtf_number_table;
176: l_month_tbl jtf_varchar2_table_4000;
177: l_result_tmp_tbl jtf_number_table;

Line 174: l_attribute_id_tbl jtf_number_table;

170: l_last_incr_refresh_date DATE;
171:
172: l_attr_trend_id_tbl jtf_number_table;
173: l_partner_id_tbl jtf_number_table;
174: l_attribute_id_tbl jtf_number_table;
175: l_result_tbl jtf_number_table;
176: l_month_tbl jtf_varchar2_table_4000;
177: l_result_tmp_tbl jtf_number_table;
178: l_month_tmp_tbl jtf_varchar2_table_4000;

Line 175: l_result_tbl jtf_number_table;

171:
172: l_attr_trend_id_tbl jtf_number_table;
173: l_partner_id_tbl jtf_number_table;
174: l_attribute_id_tbl jtf_number_table;
175: l_result_tbl jtf_number_table;
176: l_month_tbl jtf_varchar2_table_4000;
177: l_result_tmp_tbl jtf_number_table;
178: l_month_tmp_tbl jtf_varchar2_table_4000;
179: l_currency_code_tbl jtf_varchar2_table_4000;

Line 177: l_result_tmp_tbl jtf_number_table;

173: l_partner_id_tbl jtf_number_table;
174: l_attribute_id_tbl jtf_number_table;
175: l_result_tbl jtf_number_table;
176: l_month_tbl jtf_varchar2_table_4000;
177: l_result_tmp_tbl jtf_number_table;
178: l_month_tmp_tbl jtf_varchar2_table_4000;
179: l_currency_code_tbl jtf_varchar2_table_4000;
180: l_currency_date_tbl jtf_date_table;
181:

Line 251: l_partner_id_tbl := jtf_number_table();

247: -- else partner_id will be null
248: FOR L_NEW_PT_REC IN LC_GET_NEW_PT(pc_creation_date => l_last_incr_refresh_date, pc_partner_id => p_partner_id) loop
249:
250: Debug('Refreshing partner trends for partner_id: ' || l_new_pt_rec.partner_id);
251: l_partner_id_tbl := jtf_number_table();
252: l_result_tbl := jtf_number_table();
253: l_month_tbl := jtf_varchar2_table_4000();
254: l_attribute_id_tbl := jtf_number_table();
255: l_currency_code_tbl := jtf_varchar2_table_4000();

Line 252: l_result_tbl := jtf_number_table();

248: FOR L_NEW_PT_REC IN LC_GET_NEW_PT(pc_creation_date => l_last_incr_refresh_date, pc_partner_id => p_partner_id) loop
249:
250: Debug('Refreshing partner trends for partner_id: ' || l_new_pt_rec.partner_id);
251: l_partner_id_tbl := jtf_number_table();
252: l_result_tbl := jtf_number_table();
253: l_month_tbl := jtf_varchar2_table_4000();
254: l_attribute_id_tbl := jtf_number_table();
255: l_currency_code_tbl := jtf_varchar2_table_4000();
256: l_currency_date_tbl := jtf_date_table();

Line 254: l_attribute_id_tbl := jtf_number_table();

250: Debug('Refreshing partner trends for partner_id: ' || l_new_pt_rec.partner_id);
251: l_partner_id_tbl := jtf_number_table();
252: l_result_tbl := jtf_number_table();
253: l_month_tbl := jtf_varchar2_table_4000();
254: l_attribute_id_tbl := jtf_number_table();
255: l_currency_code_tbl := jtf_varchar2_table_4000();
256: l_currency_date_tbl := jtf_date_table();
257: l_counter := 0;
258:

Line 342: l_attr_trend_id_tbl := jtf_number_table();

338: where a.entity = 'PARTNER_TREND' and a.attribute_id = b.attribute_id
339: and b.performance_flag = 'Y' and b.additive_flag = 'N')
340: and entity_id = l_new_pt_rec.partner_id and trend_timeline = trunc(l_run_date, 'MM');
341:
342: l_attr_trend_id_tbl := jtf_number_table();
343: l_attr_trend_id_tbl.extend(l_partner_id_tbl.count);
344:
345: for i in 1..l_partner_id_tbl.count loop
346: l_attr_trend_id_tbl(i) := l_next_trend_id;

Line 402: l_partner_id_tbl := jtf_number_table();

398: else
399: Debug('Refreshing attribute: ' || lc_attr_rec.name ||
400: '. Last refresh date: ' || nvl(to_char(lc_attr_rec.last_refresh_date, 'YYYY/MM/DD HH24:MI:SS'), 'None'));
401:
402: l_partner_id_tbl := jtf_number_table();
403: l_result_tbl := jtf_number_table();
404: l_month_tbl := jtf_varchar2_table_4000();
405:
406: if lc_attr_rec.return_type = 'CURRENCY' then

Line 403: l_result_tbl := jtf_number_table();

399: Debug('Refreshing attribute: ' || lc_attr_rec.name ||
400: '. Last refresh date: ' || nvl(to_char(lc_attr_rec.last_refresh_date, 'YYYY/MM/DD HH24:MI:SS'), 'None'));
401:
402: l_partner_id_tbl := jtf_number_table();
403: l_result_tbl := jtf_number_table();
404: l_month_tbl := jtf_varchar2_table_4000();
405:
406: if lc_attr_rec.return_type = 'CURRENCY' then
407: l_currency_code := g_common_currency;

Line 446: l_attr_trend_id_tbl := jtf_number_table();

442: l_result_tbl(l_counter) := l_result;
443:
444: if l_counter = 1000 then
445:
446: l_attr_trend_id_tbl := jtf_number_table();
447: l_attr_trend_id_tbl.extend(l_partner_id_tbl.count);
448:
449: for i in 1..l_partner_id_tbl.count loop
450: l_attr_trend_id_tbl(i) := l_next_trend_id;

Line 478: l_partner_id_tbl := jtf_number_table();

474: CURRENCY_CODE,CURRENCY_DATE,TREND_TIMELINE,TIME_UOM) values
475: (l_attr_trend_id_tbl(i), sysdate, 1, sysdate, 1, 1, 1, 'PARTNER', l_partner_id_tbl(i),
476: lc_attr_rec.attribute_id, l_result_tbl(i), l_currency_code, l_currency_date, l_month_tbl(i), 'MONTH');
477:
478: l_partner_id_tbl := jtf_number_table();
479: l_result_tbl := jtf_number_table();
480: l_month_tbl := jtf_varchar2_table_4000();
481: l_counter := 0;
482: end if;

Line 479: l_result_tbl := jtf_number_table();

475: (l_attr_trend_id_tbl(i), sysdate, 1, sysdate, 1, 1, 1, 'PARTNER', l_partner_id_tbl(i),
476: lc_attr_rec.attribute_id, l_result_tbl(i), l_currency_code, l_currency_date, l_month_tbl(i), 'MONTH');
477:
478: l_partner_id_tbl := jtf_number_table();
479: l_result_tbl := jtf_number_table();
480: l_month_tbl := jtf_varchar2_table_4000();
481: l_counter := 0;
482: end if;
483:

Line 489: l_attr_trend_id_tbl := jtf_number_table();

485: close l_gen_cur;
486:
487: if l_partner_id_tbl.count > 0 then
488:
489: l_attr_trend_id_tbl := jtf_number_table();
490: l_attr_trend_id_tbl.extend(l_partner_id_tbl.count);
491:
492: for i in 1..l_partner_id_tbl.count loop
493: l_attr_trend_id_tbl(i) := l_next_trend_id;