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_WS_POS1 dependencies on PSB_WS_POS1

Line 1: PACKAGE BODY PSB_WS_POS1 AS

1: PACKAGE BODY PSB_WS_POS1 AS
2: /* $Header: PSBVWP1B.pls 120.20 2006/02/23 13:29:39 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WS_POS1';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WS_POS1';

1: PACKAGE BODY PSB_WS_POS1 AS
2: /* $Header: PSBVWP1B.pls 120.20 2006/02/23 13:29:39 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WS_POS1';
5:
6: cursor c_WS (Worksheet NUMBER) is
7: select budget_calendar_id,
8: budget_group_id,

Line 3172: PSB_WS_POS1.Cache_Salary_Dist

3168: LOOP
3169: l_position_id := c_positions_rec.position_id;
3170: END LOOP;
3171:
3172: PSB_WS_POS1.Cache_Salary_Dist
3173: (p_return_status => l_return_status,
3174: p_worksheet_id => p_worksheet_id,
3175: p_root_budget_group_id => l_root_budget_group_id,
3176: p_flex_code => l_chart_of_accounts_id,

Line 4455: PSB_WS_POS1.Initialize_Period_Dist;

4451: if FND_API.to_Boolean(l_elem_found) then
4452: begin
4453:
4454: /* Bug No 2278216 Start */
4455: PSB_WS_POS1.Initialize_Period_Dist;
4456: /* Bug No 2278216 End */
4457:
4458: for l_calc_index in REVERSE 1..(l_element_index - 1) loop
4459:

Line 4483: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and

4479: l_end_date := least(p_end_date, nvl(c_Dist_Rec.effective_end_date, p_end_date));
4480:
4481: for l_saldist_index in 1..g_num_salary_dist loop
4482:
4483: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
4484: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
4485: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
4486: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
4487: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and

Line 4484: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or

4480:
4481: for l_saldist_index in 1..g_num_salary_dist loop
4482:
4483: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
4484: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
4485: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
4486: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
4487: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
4488: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then

Line 4485: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or

4481: for l_saldist_index in 1..g_num_salary_dist loop
4482:
4483: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
4484: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
4485: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
4486: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
4487: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
4488: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
4489: begin

Line 4486: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or

4482:
4483: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
4484: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
4485: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
4486: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
4487: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
4488: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
4489: begin
4490:

Line 4487: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and

4483: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
4484: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
4485: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
4486: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
4487: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
4488: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
4489: begin
4490:
4491: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);

Line 4488: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then

4484: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
4485: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
4486: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
4487: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
4488: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
4489: begin
4490:
4491: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
4492: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));

Line 4491: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);

4487: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
4488: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
4489: begin
4490:
4491: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
4492: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));
4493:
4494: l_dist_found := FND_API.G_FALSE;
4495:

Line 4492: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));

4488: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
4489: begin
4490:
4491: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
4492: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));
4493:
4494: l_dist_found := FND_API.G_FALSE;
4495:
4496: -- commented for bug # 4502946

Line 5462: END PSB_WS_POS1;

5458: END Get_Debug;
5459:
5460: /* ----------------------------------------------------------------------- */
5461:
5462: END PSB_WS_POS1;