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.PQH_CBR_ENGINE dependencies on PQH_REFRESH_DATA

Line 403: pqh_refresh_data.g_refresh_tab.DELETE;

399: -- Organization_id : for position or organization we will get it.
400: -- Pool_id : I guess it is folder id , we will be having it
401: -- Entity_id : is current row.
402: hr_utility.set_location('Entering:'||l_proc, 5);
403: pqh_refresh_data.g_refresh_tab.DELETE;
404: hr_utility.set_location('dropped the context table:'||l_proc, 10);
405: pqh_refresh_data.g_refresh_tab(1).column_name := 'ENTITY_ID';
406: pqh_refresh_data.g_refresh_tab(1).TXN_VAL := p_entity_id;
407: pqh_refresh_data.g_refresh_tab(2).column_name := 'BUSINESS_GROUP_ID';

Line 405: pqh_refresh_data.g_refresh_tab(1).column_name := 'ENTITY_ID';

401: -- Entity_id : is current row.
402: hr_utility.set_location('Entering:'||l_proc, 5);
403: pqh_refresh_data.g_refresh_tab.DELETE;
404: hr_utility.set_location('dropped the context table:'||l_proc, 10);
405: pqh_refresh_data.g_refresh_tab(1).column_name := 'ENTITY_ID';
406: pqh_refresh_data.g_refresh_tab(1).TXN_VAL := p_entity_id;
407: pqh_refresh_data.g_refresh_tab(2).column_name := 'BUSINESS_GROUP_ID';
408: pqh_refresh_data.g_refresh_tab(2).TXN_VAL := g_business_group_id;
409: pqh_refresh_data.g_refresh_tab(3).column_name := 'POOL_ID';

Line 406: pqh_refresh_data.g_refresh_tab(1).TXN_VAL := p_entity_id;

402: hr_utility.set_location('Entering:'||l_proc, 5);
403: pqh_refresh_data.g_refresh_tab.DELETE;
404: hr_utility.set_location('dropped the context table:'||l_proc, 10);
405: pqh_refresh_data.g_refresh_tab(1).column_name := 'ENTITY_ID';
406: pqh_refresh_data.g_refresh_tab(1).TXN_VAL := p_entity_id;
407: pqh_refresh_data.g_refresh_tab(2).column_name := 'BUSINESS_GROUP_ID';
408: pqh_refresh_data.g_refresh_tab(2).TXN_VAL := g_business_group_id;
409: pqh_refresh_data.g_refresh_tab(3).column_name := 'POOL_ID';
410: pqh_refresh_data.g_refresh_tab(3).TXN_VAL := p_folder_id;

Line 407: pqh_refresh_data.g_refresh_tab(2).column_name := 'BUSINESS_GROUP_ID';

403: pqh_refresh_data.g_refresh_tab.DELETE;
404: hr_utility.set_location('dropped the context table:'||l_proc, 10);
405: pqh_refresh_data.g_refresh_tab(1).column_name := 'ENTITY_ID';
406: pqh_refresh_data.g_refresh_tab(1).TXN_VAL := p_entity_id;
407: pqh_refresh_data.g_refresh_tab(2).column_name := 'BUSINESS_GROUP_ID';
408: pqh_refresh_data.g_refresh_tab(2).TXN_VAL := g_business_group_id;
409: pqh_refresh_data.g_refresh_tab(3).column_name := 'POOL_ID';
410: pqh_refresh_data.g_refresh_tab(3).TXN_VAL := p_folder_id;
411: hr_utility.set_location('budget entity is:'||g_budget_entity||l_proc, 20);

Line 408: pqh_refresh_data.g_refresh_tab(2).TXN_VAL := g_business_group_id;

404: hr_utility.set_location('dropped the context table:'||l_proc, 10);
405: pqh_refresh_data.g_refresh_tab(1).column_name := 'ENTITY_ID';
406: pqh_refresh_data.g_refresh_tab(1).TXN_VAL := p_entity_id;
407: pqh_refresh_data.g_refresh_tab(2).column_name := 'BUSINESS_GROUP_ID';
408: pqh_refresh_data.g_refresh_tab(2).TXN_VAL := g_business_group_id;
409: pqh_refresh_data.g_refresh_tab(3).column_name := 'POOL_ID';
410: pqh_refresh_data.g_refresh_tab(3).TXN_VAL := p_folder_id;
411: hr_utility.set_location('budget entity is:'||g_budget_entity||l_proc, 20);
412: if g_budget_entity ='ORGANIZATION' then

Line 409: pqh_refresh_data.g_refresh_tab(3).column_name := 'POOL_ID';

405: pqh_refresh_data.g_refresh_tab(1).column_name := 'ENTITY_ID';
406: pqh_refresh_data.g_refresh_tab(1).TXN_VAL := p_entity_id;
407: pqh_refresh_data.g_refresh_tab(2).column_name := 'BUSINESS_GROUP_ID';
408: pqh_refresh_data.g_refresh_tab(2).TXN_VAL := g_business_group_id;
409: pqh_refresh_data.g_refresh_tab(3).column_name := 'POOL_ID';
410: pqh_refresh_data.g_refresh_tab(3).TXN_VAL := p_folder_id;
411: hr_utility.set_location('budget entity is:'||g_budget_entity||l_proc, 20);
412: if g_budget_entity ='ORGANIZATION' then
413: pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';

Line 410: pqh_refresh_data.g_refresh_tab(3).TXN_VAL := p_folder_id;

406: pqh_refresh_data.g_refresh_tab(1).TXN_VAL := p_entity_id;
407: pqh_refresh_data.g_refresh_tab(2).column_name := 'BUSINESS_GROUP_ID';
408: pqh_refresh_data.g_refresh_tab(2).TXN_VAL := g_business_group_id;
409: pqh_refresh_data.g_refresh_tab(3).column_name := 'POOL_ID';
410: pqh_refresh_data.g_refresh_tab(3).TXN_VAL := p_folder_id;
411: hr_utility.set_location('budget entity is:'||g_budget_entity||l_proc, 20);
412: if g_budget_entity ='ORGANIZATION' then
413: pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';
414: pqh_refresh_data.g_refresh_tab(4).TXN_VAL := p_entity_id;

Line 413: pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';

409: pqh_refresh_data.g_refresh_tab(3).column_name := 'POOL_ID';
410: pqh_refresh_data.g_refresh_tab(3).TXN_VAL := p_folder_id;
411: hr_utility.set_location('budget entity is:'||g_budget_entity||l_proc, 20);
412: if g_budget_entity ='ORGANIZATION' then
413: pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';
414: pqh_refresh_data.g_refresh_tab(4).TXN_VAL := p_entity_id;
415: elsif g_budget_entity ='POSITION' then
416: -- l_pos_organization_id := get_position_organization(p_position_id => p_entity_id,
417: -- p_effective_date => trunc(sysdate));

Line 414: pqh_refresh_data.g_refresh_tab(4).TXN_VAL := p_entity_id;

410: pqh_refresh_data.g_refresh_tab(3).TXN_VAL := p_folder_id;
411: hr_utility.set_location('budget entity is:'||g_budget_entity||l_proc, 20);
412: if g_budget_entity ='ORGANIZATION' then
413: pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';
414: pqh_refresh_data.g_refresh_tab(4).TXN_VAL := p_entity_id;
415: elsif g_budget_entity ='POSITION' then
416: -- l_pos_organization_id := get_position_organization(p_position_id => p_entity_id,
417: -- p_effective_date => trunc(sysdate));
418: -- pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';

Line 418: -- pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';

414: pqh_refresh_data.g_refresh_tab(4).TXN_VAL := p_entity_id;
415: elsif g_budget_entity ='POSITION' then
416: -- l_pos_organization_id := get_position_organization(p_position_id => p_entity_id,
417: -- p_effective_date => trunc(sysdate));
418: -- pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';
419: -- pqh_refresh_data.g_refresh_tab(4).TXN_VAL := l_organization_id;
420: pqh_refresh_data.g_refresh_tab(4).column_name := 'POSITION_ID';
421: pqh_refresh_data.g_refresh_tab(4).TXN_VAL := p_entity_id;
422: end if;

Line 419: -- pqh_refresh_data.g_refresh_tab(4).TXN_VAL := l_organization_id;

415: elsif g_budget_entity ='POSITION' then
416: -- l_pos_organization_id := get_position_organization(p_position_id => p_entity_id,
417: -- p_effective_date => trunc(sysdate));
418: -- pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';
419: -- pqh_refresh_data.g_refresh_tab(4).TXN_VAL := l_organization_id;
420: pqh_refresh_data.g_refresh_tab(4).column_name := 'POSITION_ID';
421: pqh_refresh_data.g_refresh_tab(4).TXN_VAL := p_entity_id;
422: end if;
423: hr_utility.set_location('leaving '||l_proc, 100);

Line 420: pqh_refresh_data.g_refresh_tab(4).column_name := 'POSITION_ID';

416: -- l_pos_organization_id := get_position_organization(p_position_id => p_entity_id,
417: -- p_effective_date => trunc(sysdate));
418: -- pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';
419: -- pqh_refresh_data.g_refresh_tab(4).TXN_VAL := l_organization_id;
420: pqh_refresh_data.g_refresh_tab(4).column_name := 'POSITION_ID';
421: pqh_refresh_data.g_refresh_tab(4).TXN_VAL := p_entity_id;
422: end if;
423: hr_utility.set_location('leaving '||l_proc, 100);
424: end populate_context;

Line 421: pqh_refresh_data.g_refresh_tab(4).TXN_VAL := p_entity_id;

417: -- p_effective_date => trunc(sysdate));
418: -- pqh_refresh_data.g_refresh_tab(4).column_name := 'ORGANIZATION_ID';
419: -- pqh_refresh_data.g_refresh_tab(4).TXN_VAL := l_organization_id;
420: pqh_refresh_data.g_refresh_tab(4).column_name := 'POSITION_ID';
421: pqh_refresh_data.g_refresh_tab(4).TXN_VAL := p_entity_id;
422: end if;
423: hr_utility.set_location('leaving '||l_proc, 100);
424: end populate_context;
425: --

Line 468: pqh_refresh_data.replace_where_params(

464: hr_utility.set_location('where_clause 2is : '||substr(l_where_clause_in,41,40),40);
465:
466: -- update the where clause with the context values
467:
468: pqh_refresh_data.replace_where_params(
469: p_where_clause_in => l_where_clause_in,
470: p_txn_tab_flag => 'N',
471: p_txn_id => p_entity_id,
472: p_where_clause_out => l_where_clause_out);