DBA Data[Home] [Help]

APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_WS_POS1

Line 8690: PSB_WS_POS1.g_salary_budget_group_id := null;

8686: l_return_status VARCHAR2(1);
8687:
8688: BEGIN
8689:
8690: PSB_WS_POS1.g_salary_budget_group_id := null;
8691: PSB_WS_POS1.Initialize_Salary_Dist;
8692:
8693: open c_Dist;
8694: loop

Line 8691: PSB_WS_POS1.Initialize_Salary_Dist;

8687:
8688: BEGIN
8689:
8690: PSB_WS_POS1.g_salary_budget_group_id := null;
8691: PSB_WS_POS1.Initialize_Salary_Dist;
8692:
8693: open c_Dist;
8694: loop
8695:

Line 8701: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;

8697: l_dist.pay_element_id, l_dist.code_combination_id, l_dist.distribution_percent LIMIT g_limit_bulk_numrows;
8698:
8699: for l_index in 1..l_dist.pay_element_id.count loop
8700:
8701: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
8702:
8703: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := l_dist.code_combination_id(l_index);
8704: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := l_dist.distribution_percent(l_index);
8705:

Line 8703: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := l_dist.code_combination_id(l_index);

8699: for l_index in 1..l_dist.pay_element_id.count loop
8700:
8701: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
8702:
8703: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := l_dist.code_combination_id(l_index);
8704: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := l_dist.distribution_percent(l_index);
8705:
8706: -- commented for bug # 4502946
8707: /*if l_dist.distribution_percent(l_index) < 1 then

Line 8704: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := l_dist.distribution_percent(l_index);

8700:
8701: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
8702:
8703: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := l_dist.code_combination_id(l_index);
8704: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := l_dist.distribution_percent(l_index);
8705:
8706: -- commented for bug # 4502946
8707: /*if l_dist.distribution_percent(l_index) < 1 then
8708: l_percent := l_dist.distribution_percent(l_index);

Line 8882: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop

8878:
8879: if l_dist.follow_salary(l_dist_index) = 'Y' then
8880: begin
8881:
8882: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
8883:
8884: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
8885: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));
8886:

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

8880: begin
8881:
8882: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
8883:
8884: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
8885: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));
8886:
8887: -- commented for bug # 4502946
8888: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then

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

8881:
8882: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
8883:
8884: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
8885: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));
8886:
8887: -- commented for bug # 4502946
8888: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then
8889: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;

Line 8888: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then

8884: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
8885: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));
8886:
8887: -- commented for bug # 4502946
8888: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then
8889: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;
8890: else
8891: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
8892: end if;*/

Line 8889: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;

8885: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));
8886:
8887: -- commented for bug # 4502946
8888: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then
8889: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;
8890: else
8891: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
8892: end if;*/
8893:

Line 8891: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;

8887: -- commented for bug # 4502946
8888: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then
8889: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;
8890: else
8891: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
8892: end if;*/
8893:
8894: -- added for bug # 4502946
8895: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;

Line 8895: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;

8891: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
8892: end if;*/
8893:
8894: -- added for bug # 4502946
8895: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
8896:
8897: for l_init_index in 1..PSB_WS_ACCT1.g_num_segs loop
8898: l_ccid_val(l_init_index) := null;
8899: l_seg_val(l_init_index) := null;

Line 8908: combination_id => PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid,

8904: if not FND_FLEX_EXT.Get_Segments
8905: (application_short_name => 'SQLGL',
8906: key_flex_code => 'GL#',
8907: structure_number => p_gl_flex_code,
8908: combination_id => PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid,
8909: n_segments => PSB_WS_ACCT1.g_num_segs,
8910: segments => l_ccid_val) then
8911:
8912: /* start bug 3666828 */