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.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_WORKSHEET

Line 167: elsif (g_var_name = 'G_PSB_WORKSHEET_ID') then

163: AS
164: Begin
165: if (g_var_name = 'G_PSB_BUDGET_GROUP_ID') then
166: g_psb_budget_group_id := to_number(g_var_value);
167: elsif (g_var_name = 'G_PSB_WORKSHEET_ID') then
168: g_psb_worksheet_id := to_number(g_var_value);
169: elsif (g_var_name = 'G_PSB_DATA_EXTRACT_ID') then
170: g_psb_data_extract_id := to_number(g_var_value);
171: elsif (g_var_name = 'G_PSB_BUSINESS_GROUP_ID') then

Line 168: g_psb_worksheet_id := to_number(g_var_value);

164: Begin
165: if (g_var_name = 'G_PSB_BUDGET_GROUP_ID') then
166: g_psb_budget_group_id := to_number(g_var_value);
167: elsif (g_var_name = 'G_PSB_WORKSHEET_ID') then
168: g_psb_worksheet_id := to_number(g_var_value);
169: elsif (g_var_name = 'G_PSB_DATA_EXTRACT_ID') then
170: g_psb_data_extract_id := to_number(g_var_value);
171: elsif (g_var_name = 'G_PSB_BUSINESS_GROUP_ID') then
172: g_psb_business_group_id := to_number(g_var_value);

Line 191: elsif (g_var_name = 'G_PSB_WORKSHEET_ID') then

187: AS
188: Begin
189: if (g_var_name = 'G_PSB_BUDGET_GROUP_ID') then
190: return to_char(g_psb_budget_group_id) ;
191: elsif (g_var_name = 'G_PSB_WORKSHEET_ID') then
192: return to_char(g_psb_worksheet_id) ;
193: elsif (g_var_name = 'G_PSB_DATA_EXTRACT_ID') then
194: return to_char(g_psb_data_extract_id);
195: elsif (g_var_name = 'G_PSB_BUSINESS_GROUP_ID') then

Line 192: return to_char(g_psb_worksheet_id) ;

188: Begin
189: if (g_var_name = 'G_PSB_BUDGET_GROUP_ID') then
190: return to_char(g_psb_budget_group_id) ;
191: elsif (g_var_name = 'G_PSB_WORKSHEET_ID') then
192: return to_char(g_psb_worksheet_id) ;
193: elsif (g_var_name = 'G_PSB_DATA_EXTRACT_ID') then
194: return to_char(g_psb_data_extract_id);
195: elsif (g_var_name = 'G_PSB_BUSINESS_GROUP_ID') then
196: return to_char(g_psb_business_group_id) ;

Line 2239: psb_worksheets ws

2235: cursor c_ws_positions is
2236: select wpl.position_line_id, wlp.worksheet_id
2237: from psb_ws_position_lines wpl,
2238: psb_ws_lines_positions wlp,
2239: psb_worksheets ws
2240: where wpl.position_id = l_psb_position_id
2241: and wlp.position_line_id = wpl.position_line_id
2242: and ws.worksheet_id = wlp.worksheet_id
2243: and ws.global_worksheet_flag = 'Y';

Line 2748: PSB_WORKSHEET.Delete_WPL

2744:
2745: if l_psb_position_id is not null then
2746: For c_ws_positions_rec in c_ws_positions loop
2747:
2748: PSB_WORKSHEET.Delete_WPL
2749: (p_api_version => 1.0,
2750: p_return_status => l_return_status,
2751: p_worksheet_id => c_ws_positions_rec.worksheet_id,
2752: p_position_line_id => c_ws_positions_rec.position_line_id);

Line 3400: hr_utility.set_location(' ws id is ' || get_global('G_PSB_WORKSHEET_ID') ,888);

3396: END IF;
3397:
3398: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
3399: hr_utility.set_location(' bg id is ' || get_global('G_PSB_BUDGET_GROUP_ID') ,888);
3400: hr_utility.set_location(' ws id is ' || get_global('G_PSB_WORKSHEET_ID') ,888);
3401:
3402: Update_Worksheet_Values ( p_return_status => l_return_status,
3403: p_position_id => l_position_id,
3404: p_org_id => p_organization_id);

Line 4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);

4082: RETURN;
4083: END IF;
4084:
4085: hr_utility.set_location(' Inside update ws values',333);
4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);
4087: hr_utility.set_location(' BG id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_BUDGET_GROUP_ID'),333);
4088: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
4089: hr_utility.set_location(' positionid ' || p_position_id ,888);
4090:

Line 4118: p_worksheet_id => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),

4114: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4115: p_return_status => l_return_status,
4116: p_msg_count => l_msg_count,
4117: p_msg_data => l_msg_data,
4118: p_worksheet_id => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),
4119: p_position_id => p_position_id,
4120: p_budget_group_id => l_org_budget_group_id,
4121: p_position_line_id => l_position_line_id);
4122:

Line 4139: p_budget_revision_id => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),

4135: (p_api_version => 1.0,
4136: p_return_status => l_return_status,
4137: p_msg_count => l_msg_count,
4138: p_msg_data => l_msg_data,
4139: p_budget_revision_id => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),
4140: p_budget_revision_pos_line_id => l_budget_rev_pos_line_id,
4141: p_position_id => p_position_id,
4142: p_budget_group_id => l_org_budget_group_id,
4143: p_effective_start_date =>

Line 4160: l_budget_revision_id := PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID');

4156: else
4157: -- update the position table for system data extract with budget group ID
4158: -- start bug 3253644
4159:
4160: l_budget_revision_id := PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID');
4161:
4162: FOR l_bud_group_csr IN (
4163: SELECT a.budget_group_id, b.root_budget_group
4164: FROM psb_budget_revisions a,