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

Line 848: PSB_WS_POS1.Cache_Named_Attributes

844:
845: if g_position_exists then
846: begin
847:
848: PSB_WS_POS1.Cache_Named_Attributes
849: (p_return_status => l_return_status,
850: p_business_group_id => g_business_group_id);
851:
852: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 4332: PSB_WS_POS1.g_salary_budget_group_id := null;

4328: end loop;
4329:
4330: g_num_fte_assignments := 0;
4331:
4332: PSB_WS_POS1.g_salary_budget_group_id := null;
4333: PSB_WS_POS1.Initialize_Salary_Dist;
4334:
4335: for l_init_index in 1..PSB_WS_POS1.g_elements.Count loop
4336: PSB_WS_POS1.g_elements(l_init_index).pay_element_id := null;

Line 4333: PSB_WS_POS1.Initialize_Salary_Dist;

4329:
4330: g_num_fte_assignments := 0;
4331:
4332: PSB_WS_POS1.g_salary_budget_group_id := null;
4333: PSB_WS_POS1.Initialize_Salary_Dist;
4334:
4335: for l_init_index in 1..PSB_WS_POS1.g_elements.Count loop
4336: PSB_WS_POS1.g_elements(l_init_index).pay_element_id := null;
4337: PSB_WS_POS1.g_elements(l_init_index).element_name := null;

Line 4335: for l_init_index in 1..PSB_WS_POS1.g_elements.Count loop

4331:
4332: PSB_WS_POS1.g_salary_budget_group_id := null;
4333: PSB_WS_POS1.Initialize_Salary_Dist;
4334:
4335: for l_init_index in 1..PSB_WS_POS1.g_elements.Count loop
4336: PSB_WS_POS1.g_elements(l_init_index).pay_element_id := null;
4337: PSB_WS_POS1.g_elements(l_init_index).element_name := null;
4338: PSB_WS_POS1.g_elements(l_init_index).processing_type := null;
4339: PSB_WS_POS1.g_elements(l_init_index).max_element_value_type := null;

Line 4336: PSB_WS_POS1.g_elements(l_init_index).pay_element_id := null;

4332: PSB_WS_POS1.g_salary_budget_group_id := null;
4333: PSB_WS_POS1.Initialize_Salary_Dist;
4334:
4335: for l_init_index in 1..PSB_WS_POS1.g_elements.Count loop
4336: PSB_WS_POS1.g_elements(l_init_index).pay_element_id := null;
4337: PSB_WS_POS1.g_elements(l_init_index).element_name := null;
4338: PSB_WS_POS1.g_elements(l_init_index).processing_type := null;
4339: PSB_WS_POS1.g_elements(l_init_index).max_element_value_type := null;
4340: PSB_WS_POS1.g_elements(l_init_index).max_element_value := null;

Line 4337: PSB_WS_POS1.g_elements(l_init_index).element_name := null;

4333: PSB_WS_POS1.Initialize_Salary_Dist;
4334:
4335: for l_init_index in 1..PSB_WS_POS1.g_elements.Count loop
4336: PSB_WS_POS1.g_elements(l_init_index).pay_element_id := null;
4337: PSB_WS_POS1.g_elements(l_init_index).element_name := null;
4338: PSB_WS_POS1.g_elements(l_init_index).processing_type := null;
4339: PSB_WS_POS1.g_elements(l_init_index).max_element_value_type := null;
4340: PSB_WS_POS1.g_elements(l_init_index).max_element_value := null;
4341: PSB_WS_POS1.g_elements(l_init_index).salary_flag := null;

Line 4338: PSB_WS_POS1.g_elements(l_init_index).processing_type := null;

4334:
4335: for l_init_index in 1..PSB_WS_POS1.g_elements.Count loop
4336: PSB_WS_POS1.g_elements(l_init_index).pay_element_id := null;
4337: PSB_WS_POS1.g_elements(l_init_index).element_name := null;
4338: PSB_WS_POS1.g_elements(l_init_index).processing_type := null;
4339: PSB_WS_POS1.g_elements(l_init_index).max_element_value_type := null;
4340: PSB_WS_POS1.g_elements(l_init_index).max_element_value := null;
4341: PSB_WS_POS1.g_elements(l_init_index).salary_flag := null;
4342: PSB_WS_POS1.g_elements(l_init_index).option_flag := null;

Line 4339: PSB_WS_POS1.g_elements(l_init_index).max_element_value_type := null;

4335: for l_init_index in 1..PSB_WS_POS1.g_elements.Count loop
4336: PSB_WS_POS1.g_elements(l_init_index).pay_element_id := null;
4337: PSB_WS_POS1.g_elements(l_init_index).element_name := null;
4338: PSB_WS_POS1.g_elements(l_init_index).processing_type := null;
4339: PSB_WS_POS1.g_elements(l_init_index).max_element_value_type := null;
4340: PSB_WS_POS1.g_elements(l_init_index).max_element_value := null;
4341: PSB_WS_POS1.g_elements(l_init_index).salary_flag := null;
4342: PSB_WS_POS1.g_elements(l_init_index).option_flag := null;
4343: PSB_WS_POS1.g_elements(l_init_index).overwrite_flag := null;

Line 4340: PSB_WS_POS1.g_elements(l_init_index).max_element_value := null;

4336: PSB_WS_POS1.g_elements(l_init_index).pay_element_id := null;
4337: PSB_WS_POS1.g_elements(l_init_index).element_name := null;
4338: PSB_WS_POS1.g_elements(l_init_index).processing_type := null;
4339: PSB_WS_POS1.g_elements(l_init_index).max_element_value_type := null;
4340: PSB_WS_POS1.g_elements(l_init_index).max_element_value := null;
4341: PSB_WS_POS1.g_elements(l_init_index).salary_flag := null;
4342: PSB_WS_POS1.g_elements(l_init_index).option_flag := null;
4343: PSB_WS_POS1.g_elements(l_init_index).overwrite_flag := null;
4344: PSB_WS_POS1.g_elements(l_init_index).salary_type := null;

Line 4341: PSB_WS_POS1.g_elements(l_init_index).salary_flag := null;

4337: PSB_WS_POS1.g_elements(l_init_index).element_name := null;
4338: PSB_WS_POS1.g_elements(l_init_index).processing_type := null;
4339: PSB_WS_POS1.g_elements(l_init_index).max_element_value_type := null;
4340: PSB_WS_POS1.g_elements(l_init_index).max_element_value := null;
4341: PSB_WS_POS1.g_elements(l_init_index).salary_flag := null;
4342: PSB_WS_POS1.g_elements(l_init_index).option_flag := null;
4343: PSB_WS_POS1.g_elements(l_init_index).overwrite_flag := null;
4344: PSB_WS_POS1.g_elements(l_init_index).salary_type := null;
4345: PSB_WS_POS1.g_elements(l_init_index).follow_salary := null;

Line 4342: PSB_WS_POS1.g_elements(l_init_index).option_flag := null;

4338: PSB_WS_POS1.g_elements(l_init_index).processing_type := null;
4339: PSB_WS_POS1.g_elements(l_init_index).max_element_value_type := null;
4340: PSB_WS_POS1.g_elements(l_init_index).max_element_value := null;
4341: PSB_WS_POS1.g_elements(l_init_index).salary_flag := null;
4342: PSB_WS_POS1.g_elements(l_init_index).option_flag := null;
4343: PSB_WS_POS1.g_elements(l_init_index).overwrite_flag := null;
4344: PSB_WS_POS1.g_elements(l_init_index).salary_type := null;
4345: PSB_WS_POS1.g_elements(l_init_index).follow_salary := null;
4346: PSB_WS_POS1.g_elements(l_init_index).period_type := null;

Line 4343: PSB_WS_POS1.g_elements(l_init_index).overwrite_flag := null;

4339: PSB_WS_POS1.g_elements(l_init_index).max_element_value_type := null;
4340: PSB_WS_POS1.g_elements(l_init_index).max_element_value := null;
4341: PSB_WS_POS1.g_elements(l_init_index).salary_flag := null;
4342: PSB_WS_POS1.g_elements(l_init_index).option_flag := null;
4343: PSB_WS_POS1.g_elements(l_init_index).overwrite_flag := null;
4344: PSB_WS_POS1.g_elements(l_init_index).salary_type := null;
4345: PSB_WS_POS1.g_elements(l_init_index).follow_salary := null;
4346: PSB_WS_POS1.g_elements(l_init_index).period_type := null;
4347: PSB_WS_POS1.g_elements(l_init_index).process_period_type := null;

Line 4344: PSB_WS_POS1.g_elements(l_init_index).salary_type := null;

4340: PSB_WS_POS1.g_elements(l_init_index).max_element_value := null;
4341: PSB_WS_POS1.g_elements(l_init_index).salary_flag := null;
4342: PSB_WS_POS1.g_elements(l_init_index).option_flag := null;
4343: PSB_WS_POS1.g_elements(l_init_index).overwrite_flag := null;
4344: PSB_WS_POS1.g_elements(l_init_index).salary_type := null;
4345: PSB_WS_POS1.g_elements(l_init_index).follow_salary := null;
4346: PSB_WS_POS1.g_elements(l_init_index).period_type := null;
4347: PSB_WS_POS1.g_elements(l_init_index).process_period_type := null;
4348: end loop;

Line 4345: PSB_WS_POS1.g_elements(l_init_index).follow_salary := null;

4341: PSB_WS_POS1.g_elements(l_init_index).salary_flag := null;
4342: PSB_WS_POS1.g_elements(l_init_index).option_flag := null;
4343: PSB_WS_POS1.g_elements(l_init_index).overwrite_flag := null;
4344: PSB_WS_POS1.g_elements(l_init_index).salary_type := null;
4345: PSB_WS_POS1.g_elements(l_init_index).follow_salary := null;
4346: PSB_WS_POS1.g_elements(l_init_index).period_type := null;
4347: PSB_WS_POS1.g_elements(l_init_index).process_period_type := null;
4348: end loop;
4349:

Line 4346: PSB_WS_POS1.g_elements(l_init_index).period_type := null;

4342: PSB_WS_POS1.g_elements(l_init_index).option_flag := null;
4343: PSB_WS_POS1.g_elements(l_init_index).overwrite_flag := null;
4344: PSB_WS_POS1.g_elements(l_init_index).salary_type := null;
4345: PSB_WS_POS1.g_elements(l_init_index).follow_salary := null;
4346: PSB_WS_POS1.g_elements(l_init_index).period_type := null;
4347: PSB_WS_POS1.g_elements(l_init_index).process_period_type := null;
4348: end loop;
4349:
4350: PSB_WS_POS1.g_num_elements := 0;

Line 4347: PSB_WS_POS1.g_elements(l_init_index).process_period_type := null;

4343: PSB_WS_POS1.g_elements(l_init_index).overwrite_flag := null;
4344: PSB_WS_POS1.g_elements(l_init_index).salary_type := null;
4345: PSB_WS_POS1.g_elements(l_init_index).follow_salary := null;
4346: PSB_WS_POS1.g_elements(l_init_index).period_type := null;
4347: PSB_WS_POS1.g_elements(l_init_index).process_period_type := null;
4348: end loop;
4349:
4350: PSB_WS_POS1.g_num_elements := 0;
4351:

Line 4350: PSB_WS_POS1.g_num_elements := 0;

4346: PSB_WS_POS1.g_elements(l_init_index).period_type := null;
4347: PSB_WS_POS1.g_elements(l_init_index).process_period_type := null;
4348: end loop;
4349:
4350: PSB_WS_POS1.g_num_elements := 0;
4351:
4352: End Initialize_Revisions;
4353:
4354: /* ----------------------------------------------------------------------- */

Line 4387: PSB_WS_POS1.g_num_elements := PSB_WS_POS1.g_num_elements + 1;

4383: BEGIN
4384:
4385: for c_Elements_Rec in c_Elements loop
4386:
4387: PSB_WS_POS1.g_num_elements := PSB_WS_POS1.g_num_elements + 1;
4388:
4389: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).pay_element_id := c_Elements_Rec.pay_element_id;
4390: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).element_name := c_Elements_Rec.name;
4391: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).processing_type := c_Elements_Rec.processing_type;

Line 4389: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).pay_element_id := c_Elements_Rec.pay_element_id;

4385: for c_Elements_Rec in c_Elements loop
4386:
4387: PSB_WS_POS1.g_num_elements := PSB_WS_POS1.g_num_elements + 1;
4388:
4389: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).pay_element_id := c_Elements_Rec.pay_element_id;
4390: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).element_name := c_Elements_Rec.name;
4391: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).processing_type := c_Elements_Rec.processing_type;
4392: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value_type := c_Elements_Rec.max_element_value_type;
4393: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value := c_Elements_Rec.max_element_value;

Line 4390: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).element_name := c_Elements_Rec.name;

4386:
4387: PSB_WS_POS1.g_num_elements := PSB_WS_POS1.g_num_elements + 1;
4388:
4389: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).pay_element_id := c_Elements_Rec.pay_element_id;
4390: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).element_name := c_Elements_Rec.name;
4391: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).processing_type := c_Elements_Rec.processing_type;
4392: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value_type := c_Elements_Rec.max_element_value_type;
4393: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value := c_Elements_Rec.max_element_value;
4394: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).option_flag := c_Elements_Rec.option_flag;

Line 4391: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).processing_type := c_Elements_Rec.processing_type;

4387: PSB_WS_POS1.g_num_elements := PSB_WS_POS1.g_num_elements + 1;
4388:
4389: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).pay_element_id := c_Elements_Rec.pay_element_id;
4390: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).element_name := c_Elements_Rec.name;
4391: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).processing_type := c_Elements_Rec.processing_type;
4392: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value_type := c_Elements_Rec.max_element_value_type;
4393: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value := c_Elements_Rec.max_element_value;
4394: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).option_flag := c_Elements_Rec.option_flag;
4395: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).overwrite_flag := c_Elements_Rec.overwrite_flag;

Line 4392: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value_type := c_Elements_Rec.max_element_value_type;

4388:
4389: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).pay_element_id := c_Elements_Rec.pay_element_id;
4390: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).element_name := c_Elements_Rec.name;
4391: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).processing_type := c_Elements_Rec.processing_type;
4392: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value_type := c_Elements_Rec.max_element_value_type;
4393: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value := c_Elements_Rec.max_element_value;
4394: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).option_flag := c_Elements_Rec.option_flag;
4395: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).overwrite_flag := c_Elements_Rec.overwrite_flag;
4396: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_flag := c_Elements_Rec.salary_flag;

Line 4393: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value := c_Elements_Rec.max_element_value;

4389: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).pay_element_id := c_Elements_Rec.pay_element_id;
4390: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).element_name := c_Elements_Rec.name;
4391: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).processing_type := c_Elements_Rec.processing_type;
4392: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value_type := c_Elements_Rec.max_element_value_type;
4393: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value := c_Elements_Rec.max_element_value;
4394: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).option_flag := c_Elements_Rec.option_flag;
4395: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).overwrite_flag := c_Elements_Rec.overwrite_flag;
4396: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_flag := c_Elements_Rec.salary_flag;
4397: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_type := c_Elements_Rec.salary_type;

Line 4394: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).option_flag := c_Elements_Rec.option_flag;

4390: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).element_name := c_Elements_Rec.name;
4391: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).processing_type := c_Elements_Rec.processing_type;
4392: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value_type := c_Elements_Rec.max_element_value_type;
4393: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value := c_Elements_Rec.max_element_value;
4394: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).option_flag := c_Elements_Rec.option_flag;
4395: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).overwrite_flag := c_Elements_Rec.overwrite_flag;
4396: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_flag := c_Elements_Rec.salary_flag;
4397: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_type := c_Elements_Rec.salary_type;
4398: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).follow_salary := c_Elements_Rec.follow_salary;

Line 4395: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).overwrite_flag := c_Elements_Rec.overwrite_flag;

4391: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).processing_type := c_Elements_Rec.processing_type;
4392: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value_type := c_Elements_Rec.max_element_value_type;
4393: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value := c_Elements_Rec.max_element_value;
4394: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).option_flag := c_Elements_Rec.option_flag;
4395: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).overwrite_flag := c_Elements_Rec.overwrite_flag;
4396: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_flag := c_Elements_Rec.salary_flag;
4397: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_type := c_Elements_Rec.salary_type;
4398: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).follow_salary := c_Elements_Rec.follow_salary;
4399: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).period_type := c_Elements_Rec.period_type;

Line 4396: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_flag := c_Elements_Rec.salary_flag;

4392: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value_type := c_Elements_Rec.max_element_value_type;
4393: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value := c_Elements_Rec.max_element_value;
4394: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).option_flag := c_Elements_Rec.option_flag;
4395: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).overwrite_flag := c_Elements_Rec.overwrite_flag;
4396: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_flag := c_Elements_Rec.salary_flag;
4397: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_type := c_Elements_Rec.salary_type;
4398: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).follow_salary := c_Elements_Rec.follow_salary;
4399: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).period_type := c_Elements_Rec.period_type;
4400: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).process_period_type := c_Elements_Rec.process_period_type;

Line 4397: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_type := c_Elements_Rec.salary_type;

4393: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).max_element_value := c_Elements_Rec.max_element_value;
4394: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).option_flag := c_Elements_Rec.option_flag;
4395: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).overwrite_flag := c_Elements_Rec.overwrite_flag;
4396: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_flag := c_Elements_Rec.salary_flag;
4397: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_type := c_Elements_Rec.salary_type;
4398: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).follow_salary := c_Elements_Rec.follow_salary;
4399: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).period_type := c_Elements_Rec.period_type;
4400: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).process_period_type := c_Elements_Rec.process_period_type;
4401: end loop;

Line 4398: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).follow_salary := c_Elements_Rec.follow_salary;

4394: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).option_flag := c_Elements_Rec.option_flag;
4395: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).overwrite_flag := c_Elements_Rec.overwrite_flag;
4396: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_flag := c_Elements_Rec.salary_flag;
4397: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_type := c_Elements_Rec.salary_type;
4398: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).follow_salary := c_Elements_Rec.follow_salary;
4399: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).period_type := c_Elements_Rec.period_type;
4400: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).process_period_type := c_Elements_Rec.process_period_type;
4401: end loop;
4402:

Line 4399: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).period_type := c_Elements_Rec.period_type;

4395: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).overwrite_flag := c_Elements_Rec.overwrite_flag;
4396: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_flag := c_Elements_Rec.salary_flag;
4397: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_type := c_Elements_Rec.salary_type;
4398: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).follow_salary := c_Elements_Rec.follow_salary;
4399: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).period_type := c_Elements_Rec.period_type;
4400: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).process_period_type := c_Elements_Rec.process_period_type;
4401: end loop;
4402:
4403: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4400: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).process_period_type := c_Elements_Rec.process_period_type;

4396: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_flag := c_Elements_Rec.salary_flag;
4397: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).salary_type := c_Elements_Rec.salary_type;
4398: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).follow_salary := c_Elements_Rec.follow_salary;
4399: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).period_type := c_Elements_Rec.period_type;
4400: PSB_WS_POS1.g_elements(PSB_WS_POS1.g_num_elements).process_period_type := c_Elements_Rec.process_period_type;
4401: end loop;
4402:
4403: p_return_status := FND_API.G_RET_STS_SUCCESS;
4404:

Line 4503: if nvl(PSB_WS_POS1.g_salary_budget_group_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then

4499:
4500: l_saldist_found := TRUE;
4501: g_revised_position := TRUE;
4502:
4503: if nvl(PSB_WS_POS1.g_salary_budget_group_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
4504: begin
4505:
4506: for c_Budget_Group_Rec in c_Budget_Group (c_Dist_Rec.code_combination_id) loop
4507: PSB_WS_POS1.g_salary_budget_group_id := c_Budget_Group_Rec.budget_group_id;

Line 4507: PSB_WS_POS1.g_salary_budget_group_id := c_Budget_Group_Rec.budget_group_id;

4503: if nvl(PSB_WS_POS1.g_salary_budget_group_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
4504: begin
4505:
4506: for c_Budget_Group_Rec in c_Budget_Group (c_Dist_Rec.code_combination_id) loop
4507: PSB_WS_POS1.g_salary_budget_group_id := c_Budget_Group_Rec.budget_group_id;
4508: l_budget_group_found := TRUE;
4509: end loop;
4510:
4511: -- Budget Group for a Position is the Budget Group assigned to the CCID with

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

4530:
4531: end;
4532: end if;
4533:
4534: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
4535:
4536: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;
4537: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;
4538: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;

Line 4536: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;

4532: end if;
4533:
4534: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
4535:
4536: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;
4537: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;
4538: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;
4539: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).end_date := c_Dist_Rec.effective_end_date;
4540:

Line 4537: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;

4533:
4534: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
4535:
4536: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;
4537: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;
4538: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;
4539: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).end_date := c_Dist_Rec.effective_end_date;
4540:
4541: end loop;

Line 4538: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;

4534: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
4535:
4536: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;
4537: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;
4538: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;
4539: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).end_date := c_Dist_Rec.effective_end_date;
4540:
4541: end loop;
4542:

Line 4539: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).end_date := c_Dist_Rec.effective_end_date;

4535:
4536: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;
4537: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;
4538: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;
4539: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).end_date := c_Dist_Rec.effective_end_date;
4540:
4541: end loop;
4542:
4543: if not l_saldist_found then

Line 4550: if nvl(PSB_WS_POS1.g_salary_budget_group_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then

4546: for c_Dist_Rec in c_Dist loop
4547:
4548: l_saldist_found := TRUE;
4549:
4550: if nvl(PSB_WS_POS1.g_salary_budget_group_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
4551: begin
4552:
4553: for c_Budget_Group_Rec in c_Budget_Group (c_Dist_Rec.code_combination_id) loop
4554: PSB_WS_POS1.g_salary_budget_group_id := c_Budget_Group_Rec.budget_group_id;

Line 4554: PSB_WS_POS1.g_salary_budget_group_id := c_Budget_Group_Rec.budget_group_id;

4550: if nvl(PSB_WS_POS1.g_salary_budget_group_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
4551: begin
4552:
4553: for c_Budget_Group_Rec in c_Budget_Group (c_Dist_Rec.code_combination_id) loop
4554: PSB_WS_POS1.g_salary_budget_group_id := c_Budget_Group_Rec.budget_group_id;
4555: l_budget_group_found := TRUE;
4556: end loop;
4557:
4558: -- Budget Group for a Position is the Budget Group assigned to the CCID with

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

4577:
4578: end;
4579: end if;
4580:
4581: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
4582:
4583: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;
4584: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;
4585: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;

Line 4583: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;

4579: end if;
4580:
4581: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
4582:
4583: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;
4584: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;
4585: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;
4586: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).end_date := c_Dist_Rec.effective_end_date;
4587:

Line 4584: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;

4580:
4581: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
4582:
4583: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;
4584: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;
4585: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;
4586: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).end_date := c_Dist_Rec.effective_end_date;
4587:
4588: end loop;

Line 4585: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;

4581: PSB_WS_POS1.g_num_salary_dist := PSB_WS_POS1.g_num_salary_dist + 1;
4582:
4583: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;
4584: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;
4585: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;
4586: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).end_date := c_Dist_Rec.effective_end_date;
4587:
4588: end loop;
4589:

Line 4586: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).end_date := c_Dist_Rec.effective_end_date;

4582:
4583: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).ccid := c_Dist_Rec.code_combination_id;
4584: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).percent := c_Dist_Rec.distribution_percent;
4585: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).start_date := c_Dist_Rec.effective_start_date;
4586: PSB_WS_POS1.g_salary_dist(PSB_WS_POS1.g_num_salary_dist).end_date := c_Dist_Rec.effective_end_date;
4587:
4588: end loop;
4589:
4590: end;

Line 4844: PSB_WS_POS1.Initialize_Salary_Dist;

4840: for c_accdistr_rec in c_accdistr loop
4841:
4842: l_position_id := c_accdistr_rec.position_id;
4843:
4844: PSB_WS_POS1.Initialize_Salary_Dist;
4845:
4846: for c_Positions_Rec in c_Positions loop
4847:
4848: Cache_Salary_Dist

Line 4875: p_budget_group_id => PSB_WS_POS1.g_salary_budget_group_id,

4871: p_position_definition_id => c_positions_rec.position_definition_id,
4872: p_hr_position_id => c_positions_rec.hr_position_id,
4873: p_hr_employee_id => c_positions_rec.hr_employee_id,
4874: p_business_group_id => c_positions_rec.business_group_id,
4875: p_budget_group_id => PSB_WS_POS1.g_salary_budget_group_id,
4876: p_effective_start_DATE => c_positions_rec.effective_start_date,
4877: p_effective_END_DATE => c_positions_rec.effective_end_date,
4878: p_set_of_books_id => c_positions_rec.set_of_books_id,
4879: p_vacant_position_flag => c_positions_rec.vacant_position_flag,

Line 5506: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop

5502: l_rate_found BOOLEAN;
5503:
5504: BEGIN
5505:
5506: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop
5507: l_pay_element_id := PSB_WS_POS1.g_elements(l_element_index).pay_element_id;
5508: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
5509: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;
5510: l_element_cost := 0;

Line 5507: l_pay_element_id := PSB_WS_POS1.g_elements(l_element_index).pay_element_id;

5503:
5504: BEGIN
5505:
5506: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop
5507: l_pay_element_id := PSB_WS_POS1.g_elements(l_element_index).pay_element_id;
5508: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
5509: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;
5510: l_element_cost := 0;
5511: l_salary_value := 0;

Line 5508: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;

5504: BEGIN
5505:
5506: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop
5507: l_pay_element_id := PSB_WS_POS1.g_elements(l_element_index).pay_element_id;
5508: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
5509: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;
5510: l_element_cost := 0;
5511: l_salary_value := 0;
5512: l_element_assigned := FALSE;

Line 5509: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;

5505:
5506: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop
5507: l_pay_element_id := PSB_WS_POS1.g_elements(l_element_index).pay_element_id;
5508: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
5509: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;
5510: l_element_cost := 0;
5511: l_salary_value := 0;
5512: l_element_assigned := FALSE;
5513:

Line 5633: message_token('ELEMENT', PSB_WS_POS1.g_elements(l_element_index).element_name);

5629: end loop;
5630:
5631: if l_element_value_type = 'PI' then
5632: message_token('ELEMENT_VALUE_TYPE', l_element_value_type);
5633: message_token('ELEMENT', PSB_WS_POS1.g_elements(l_element_index).element_name);
5634: message_token('POSITION', p_position_name);
5635: add_message('PSB', 'PSB_INVALID_ASSIGNMENT_TYPE');
5636: raise FND_API.G_EXC_ERROR;
5637: end if;

Line 5639: if PSB_WS_POS1.g_elements(l_element_index).salary_flag = 'Y' then

5635: add_message('PSB', 'PSB_INVALID_ASSIGNMENT_TYPE');
5636: raise FND_API.G_EXC_ERROR;
5637: end if;
5638:
5639: if PSB_WS_POS1.g_elements(l_element_index).salary_flag = 'Y' then
5640: begin
5641: if l_pay_basis = 'ANNUAL' then
5642: begin
5643: l_element_cost := l_element_cost + l_fte

Line 5736: if PSB_WS_POS1.g_elements(l_element_index).salary_flag = 'Y' then

5732:
5733: g_num_costs := g_num_costs + 1;
5734: g_costs(g_num_costs).pay_element_id := l_pay_element_id;
5735:
5736: if PSB_WS_POS1.g_elements(l_element_index).salary_flag = 'Y' then
5737: g_costs(g_num_costs).element_type := 'S';
5738: elsif PSB_WS_POS1.g_elements(l_element_index).follow_salary = 'Y' then
5739: g_costs(g_num_costs).element_type := 'F';
5740: end if;

Line 5738: elsif PSB_WS_POS1.g_elements(l_element_index).follow_salary = 'Y' then

5734: g_costs(g_num_costs).pay_element_id := l_pay_element_id;
5735:
5736: if PSB_WS_POS1.g_elements(l_element_index).salary_flag = 'Y' then
5737: g_costs(g_num_costs).element_type := 'S';
5738: elsif PSB_WS_POS1.g_elements(l_element_index).follow_salary = 'Y' then
5739: g_costs(g_num_costs).element_type := 'F';
5740: end if;
5741:
5742: g_costs(g_num_costs).element_cost := l_element_cost;

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

5789:
5790: if g_costs(l_calc_index).pay_element_id = p_pay_element_id then
5791: begin
5792:
5793: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
5794:
5795: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= g_costs(l_calc_index).end_date) and
5796: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5797: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or

Line 5795: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= g_costs(l_calc_index).end_date) and

5791: begin
5792:
5793: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
5794:
5795: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= g_costs(l_calc_index).end_date) and
5796: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5797: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5798: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5799: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < g_costs(l_calc_index).start_date) and

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

5792:
5793: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
5794:
5795: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= g_costs(l_calc_index).end_date) and
5796: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5797: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5798: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5799: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < g_costs(l_calc_index).start_date) and
5800: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > g_costs(l_calc_index).end_date)))) then

Line 5797: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or

5793: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
5794:
5795: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= g_costs(l_calc_index).end_date) and
5796: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5797: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5798: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5799: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < g_costs(l_calc_index).start_date) and
5800: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > g_costs(l_calc_index).end_date)))) then
5801: begin

Line 5798: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or

5794:
5795: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= g_costs(l_calc_index).end_date) and
5796: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5797: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5798: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5799: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < g_costs(l_calc_index).start_date) and
5800: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > g_costs(l_calc_index).end_date)))) then
5801: begin
5802:

Line 5799: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < g_costs(l_calc_index).start_date) and

5795: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= g_costs(l_calc_index).end_date) and
5796: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5797: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5798: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5799: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < g_costs(l_calc_index).start_date) and
5800: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > g_costs(l_calc_index).end_date)))) then
5801: begin
5802:
5803: l_dist_found := FALSE;

Line 5800: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > g_costs(l_calc_index).end_date)))) then

5796: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5797: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5798: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between g_costs(l_calc_index).start_date and g_costs(l_calc_index).end_date) or
5799: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < g_costs(l_calc_index).start_date) and
5800: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > g_costs(l_calc_index).end_date)))) then
5801: begin
5802:
5803: l_dist_found := FALSE;
5804: l_account_index := null;

Line 5805: l_start_date := greatest(g_costs(l_calc_index).start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);

5801: begin
5802:
5803: l_dist_found := FALSE;
5804: l_account_index := null;
5805: l_start_date := greatest(g_costs(l_calc_index).start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
5806: l_end_date := least(g_costs(l_calc_index).end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, g_costs(l_calc_index).end_date));
5807:
5808: for l_dist_index in 1..g_num_dists loop
5809:

Line 5806: l_end_date := least(g_costs(l_calc_index).end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, g_costs(l_calc_index).end_date));

5802:
5803: l_dist_found := FALSE;
5804: l_account_index := null;
5805: l_start_date := greatest(g_costs(l_calc_index).start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
5806: l_end_date := least(g_costs(l_calc_index).end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, g_costs(l_calc_index).end_date));
5807:
5808: for l_dist_index in 1..g_num_dists loop
5809:
5810: if g_dists(l_dist_index).ccid = PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid then

Line 5810: if g_dists(l_dist_index).ccid = PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid then

5806: l_end_date := least(g_costs(l_calc_index).end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, g_costs(l_calc_index).end_date));
5807:
5808: for l_dist_index in 1..g_num_dists loop
5809:
5810: if g_dists(l_dist_index).ccid = PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid then
5811: l_dist_found := TRUE;
5812: l_account_index := l_dist_index;
5813: end if;
5814:

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

5814:
5815: end loop;
5816:
5817: -- commented for bug # 4502946
5818: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then
5819: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;
5820: else
5821: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5822: end if;*/

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

5815: end loop;
5816:
5817: -- commented for bug # 4502946
5818: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then
5819: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;
5820: else
5821: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5822: end if;*/
5823:

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

5817: -- commented for bug # 4502946
5818: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then
5819: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;
5820: else
5821: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5822: end if;*/
5823:
5824: -- added for bug # 4502946
5825: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;

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

5821: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5822: end if;*/
5823:
5824: -- added for bug # 4502946
5825: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5826:
5827: if not l_dist_found then
5828: begin
5829:

Line 5832: g_dists(g_num_dists).ccid := PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid;

5828: begin
5829:
5830: g_num_dists := g_num_dists + 1;
5831:
5832: g_dists(g_num_dists).ccid := PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid;
5833: g_dists(g_num_dists).budget_group_id := PSB_WS_POS1.g_salary_budget_group_id;
5834: g_dists(g_num_dists).currency_code := g_func_currency;
5835: g_dists(g_num_dists).start_date := l_start_date;
5836: g_dists(g_num_dists).end_date := l_end_date;

Line 5833: g_dists(g_num_dists).budget_group_id := PSB_WS_POS1.g_salary_budget_group_id;

5829:
5830: g_num_dists := g_num_dists + 1;
5831:
5832: g_dists(g_num_dists).ccid := PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid;
5833: g_dists(g_num_dists).budget_group_id := PSB_WS_POS1.g_salary_budget_group_id;
5834: g_dists(g_num_dists).currency_code := g_func_currency;
5835: g_dists(g_num_dists).start_date := l_start_date;
5836: g_dists(g_num_dists).end_date := l_end_date;
5837:

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

5958:
5959: l_start_date := greatest(g_costs(l_calc_index).start_date, c_Dist_Rec.effective_start_date);
5960: l_end_date := least(g_costs(l_calc_index).end_date, nvl(c_Dist_Rec.effective_end_date, g_costs(l_calc_index).end_date));
5961:
5962: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
5963:
5964: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
5965: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5966: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or

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

5960: l_end_date := least(g_costs(l_calc_index).end_date, nvl(c_Dist_Rec.effective_end_date, g_costs(l_calc_index).end_date));
5961:
5962: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
5963:
5964: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
5965: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5966: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
5967: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
5968: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and

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

5961:
5962: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
5963:
5964: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
5965: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5966: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
5967: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
5968: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
5969: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then

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

5962: for l_saldist_index in 1..PSB_WS_POS1.g_num_salary_dist loop
5963:
5964: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
5965: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5966: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
5967: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
5968: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
5969: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
5970: begin

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

5963:
5964: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
5965: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5966: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
5967: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
5968: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
5969: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
5970: begin
5971:

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

5964: if (((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date <= l_end_date) and
5965: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5966: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
5967: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
5968: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
5969: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
5970: begin
5971:
5972: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);

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

5965: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date is null)) or
5966: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date between l_start_date and l_end_date) or
5967: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date between l_start_date and l_end_date) or
5968: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
5969: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
5970: begin
5971:
5972: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
5973: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));

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

5968: ((PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date < l_start_date) and
5969: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
5970: begin
5971:
5972: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
5973: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));
5974:
5975: l_dist_found := FALSE;
5976: l_account_index := null;

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

5969: (PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date > l_end_date)))) then
5970: begin
5971:
5972: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
5973: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));
5974:
5975: l_dist_found := FALSE;
5976: l_account_index := null;
5977:

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

5975: l_dist_found := FALSE;
5976: l_account_index := null;
5977:
5978: -- commented for bug # 4502946
5979: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then
5980: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;
5981: else
5982: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5983: end if;*/

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

5976: l_account_index := null;
5977:
5978: -- commented for bug # 4502946
5979: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then
5980: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;
5981: else
5982: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5983: end if;*/
5984:

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

5978: -- commented for bug # 4502946
5979: /*if PSB_WS_POS1.g_salary_dist(l_saldist_index).percent < 1 then
5980: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent;
5981: else
5982: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5983: end if;*/
5984:
5985: -- added for bug # 4502946
5986: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;

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

5982: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5983: end if;*/
5984:
5985: -- added for bug # 4502946
5986: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5987:
5988: for l_init_index in 1..PSB_WS_ACCT1.g_num_segs loop
5989: l_ccid_val(l_init_index) := null;
5990: l_seg_val(l_init_index) := null;

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

5993: if not FND_FLEX_EXT.Get_Segments
5994: (application_short_name => 'SQLGL',
5995: key_flex_code => 'GL#',
5996: structure_number => g_flex_code,
5997: combination_id => PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid,
5998: n_segments => PSB_WS_ACCT1.g_num_segs,
5999: segments => l_ccid_val) then
6000:
6001: FND_MSG_PUB.Add;

Line 6162: g_dists(g_num_dists).budget_group_id := PSB_WS_POS1.g_salary_budget_group_id;

6158:
6159: g_num_dists := g_num_dists + 1;
6160:
6161: g_dists(g_num_dists).ccid := l_ccid;
6162: g_dists(g_num_dists).budget_group_id := PSB_WS_POS1.g_salary_budget_group_id;
6163: g_dists(g_num_dists).currency_code := g_func_currency;
6164: g_dists(g_num_dists).start_date := l_start_date;
6165: g_dists(g_num_dists).end_date := l_end_date;
6166: g_dists(g_num_dists).amount := l_percent *

Line 6307: g_dists(g_num_dists).budget_group_id := PSB_WS_POS1.g_salary_budget_group_id;

6303: begin
6304:
6305: g_num_dists := g_num_dists + 1;
6306: g_dists(g_num_dists).ccid := c_Dist_Rec.code_combination_id;
6307: g_dists(g_num_dists).budget_group_id := PSB_WS_POS1.g_salary_budget_group_id;
6308: g_dists(g_num_dists).currency_code := g_func_currency;
6309: g_dists(g_num_dists).start_date := l_start_date;
6310: g_dists(g_num_dists).end_date := l_end_date;
6311: g_dists(g_num_dists).amount := l_percent *

Line 6370: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop

6366: l_return_status VARCHAR2(1);
6367:
6368: BEGIN
6369:
6370: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop
6371:
6372: if PSB_WS_POS1.g_elements(l_element_index).salary_flag = 'Y' then
6373: begin
6374:

Line 6372: if PSB_WS_POS1.g_elements(l_element_index).salary_flag = 'Y' then

6368: BEGIN
6369:
6370: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop
6371:
6372: if PSB_WS_POS1.g_elements(l_element_index).salary_flag = 'Y' then
6373: begin
6374:
6375: Distribute_Salary
6376: (p_return_status => l_return_status,

Line 6377: p_pay_element_id => PSB_WS_POS1.g_elements(l_element_index).pay_element_id,

6373: begin
6374:
6375: Distribute_Salary
6376: (p_return_status => l_return_status,
6377: p_pay_element_id => PSB_WS_POS1.g_elements(l_element_index).pay_element_id,
6378: p_position_id => p_position_id,
6379: p_revision_start_date => p_revision_start_date,
6380: p_revision_end_date => p_revision_end_date);
6381:

Line 6390: if PSB_WS_POS1.g_elements(l_element_index).follow_salary = 'Y' then

6386: end;
6387: else
6388: begin
6389:
6390: if PSB_WS_POS1.g_elements(l_element_index).follow_salary = 'Y' then
6391: begin
6392:
6393: Distribute_Following_Elements
6394: (p_return_status => l_return_status,

Line 6395: p_pay_element_id => PSB_WS_POS1.g_elements(l_element_index).pay_element_id,

6391: begin
6392:
6393: Distribute_Following_Elements
6394: (p_return_status => l_return_status,
6395: p_pay_element_id => PSB_WS_POS1.g_elements(l_element_index).pay_element_id,
6396: p_position_id => p_position_id,
6397: p_revision_start_date => p_revision_start_date,
6398: p_revision_end_date => p_revision_end_date);
6399:

Line 6410: p_pay_element_id => PSB_WS_POS1.g_elements(l_element_index).pay_element_id,

6406: begin
6407:
6408: Distribute_Other_Elements
6409: (p_return_status => l_return_status,
6410: p_pay_element_id => PSB_WS_POS1.g_elements(l_element_index).pay_element_id,
6411: p_position_id => p_position_id,
6412: p_revision_start_date => p_revision_start_date,
6413: p_revision_end_date => p_revision_end_date);
6414:

Line 6626: p_budget_group_id => PSB_WS_POS1.g_salary_budget_group_id,

6622: p_msg_data => l_msg_data,
6623: p_budget_revision_id => p_budget_revision_id,
6624: p_budget_revision_pos_line_id => l_budget_rev_pos_line_id,
6625: p_position_id => p_position_id,
6626: p_budget_group_id => PSB_WS_POS1.g_salary_budget_group_id,
6627: p_effective_start_date => p_revision_start_date,
6628: p_effective_end_date => p_revision_end_date,
6629: p_revision_type => null,
6630: p_revision_value_type => null,

Line 6765: p_budget_group_id => PSB_WS_POS1.g_salary_budget_group_id,

6761: p_msg_data => l_msg_data,
6762: p_budget_revision_id => p_budget_revision_id,
6763: p_budget_revision_acct_line_id => l_budget_rev_acct_line_id,
6764: p_code_combination_id => g_revaccts(l_revacct_index).ccid,
6765: p_budget_group_id => PSB_WS_POS1.g_salary_budget_group_id,
6766: p_gl_period_name => l_gl_period_name,
6767: p_gl_budget_version_id => l_gl_budget_version_id,
6768: p_position_id => p_position_id,
6769: p_currency_code => g_func_currency,

Line 6987: where attribute_id in (PSB_WS_POS1.g_default_wklyhrs_id, PSB_WS_POS1.g_fte_id)

6983: -- Fixed bug # 3683644
6984: FND_NUMBER.canonical_to_number(attribute_value) attribute_value,
6985: attribute_value_id
6986: from PSB_POSITION_ASSIGNMENTS
6987: where attribute_id in (PSB_WS_POS1.g_default_wklyhrs_id, PSB_WS_POS1.g_fte_id)
6988: and (( worksheet_id = g_global_budget_revision_id) or (worksheet_id is null))
6989: and assignment_type = 'ATTRIBUTE'
6990: and (((effective_start_date <= l_end_date)
6991: and (effective_end_date is null))

Line 7135: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop

7131: g_elem_assignments(g_num_elem_assignments).use_in_calc := FALSE;
7132:
7133: end loop;
7134:
7135: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop
7136:
7137: l_element_found := FALSE;
7138:
7139: for l_elemassign_index in 1..g_num_elem_assignments loop

Line 7141: if ((g_elem_assignments(l_elemassign_index).pay_element_id = PSB_WS_POS1.g_elements(l_element_index).pay_element_id) and

7137: l_element_found := FALSE;
7138:
7139: for l_elemassign_index in 1..g_num_elem_assignments loop
7140:
7141: if ((g_elem_assignments(l_elemassign_index).pay_element_id = PSB_WS_POS1.g_elements(l_element_index).pay_element_id) and
7142: (g_elem_assignments(l_elemassign_index).budget_revision_id is not null)) then
7143: begin
7144: l_element_found := TRUE;
7145: g_revised_position := TRUE;

Line 7157: if ((g_elem_assignments(l_elemassign_index).pay_element_id = PSB_WS_POS1.g_elements(l_element_index).pay_element_id) and

7153: begin
7154:
7155: for l_elemassign_index in 1..g_num_elem_assignments loop
7156:
7157: if ((g_elem_assignments(l_elemassign_index).pay_element_id = PSB_WS_POS1.g_elements(l_element_index).pay_element_id) and
7158: (g_elem_assignments(l_elemassign_index).budget_revision_id is null)) then
7159: g_elem_assignments(l_elemassign_index).use_in_calc := TRUE;
7160: end if;
7161:

Line 7253: if c_Attributes_Rec.attribute_id = PSB_WS_POS1.g_default_wklyhrs_id then

7249: if ((c_Attributes_Rec.attribute_value is null) and (c_Attributes_Rec.attribute_value_id is not null)) then
7250: l_attribute_value := PSB_WS_POS2.Get_Attribute_Value(c_Attributes_Rec.attribute_value_id);
7251: end if;
7252:
7253: if c_Attributes_Rec.attribute_id = PSB_WS_POS1.g_default_wklyhrs_id then
7254: begin
7255: g_num_wkh_assignments := g_num_wkh_assignments + 1;
7256: g_wkh_assignments(g_num_wkh_assignments).start_date := c_Attributes_Rec.effective_start_date;
7257: g_wkh_assignments(g_num_wkh_assignments).end_date := c_Attributes_Rec.effective_end_date;

Line 7260: elsif ((c_Attributes_Rec.attribute_id = PSB_WS_POS1.g_fte_id) and not (l_fte_found)) then

7256: g_wkh_assignments(g_num_wkh_assignments).start_date := c_Attributes_Rec.effective_start_date;
7257: g_wkh_assignments(g_num_wkh_assignments).end_date := c_Attributes_Rec.effective_end_date;
7258: g_wkh_assignments(g_num_wkh_assignments).default_weekly_hours := nvl(c_Attributes_Rec.attribute_value, l_attribute_value);
7259: end;
7260: elsif ((c_Attributes_Rec.attribute_id = PSB_WS_POS1.g_fte_id) and not (l_fte_found)) then
7261: begin
7262: g_new_position := TRUE;
7263: g_num_fte_assignments := g_num_fte_assignments + 1;
7264: g_fte_assignments(g_num_fte_assignments).start_date := c_Attributes_Rec.effective_start_date;