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

Line 1340: PSB_WS_POS1.Cache_Elements

1336:
1337: BEGIN
1338:
1339: -- Cache all the Elements
1340: PSB_WS_POS1.Cache_Elements
1341: (p_return_status => l_return_status,
1342: p_data_extract_id => g_data_extract_id,
1343: p_business_group_id => g_business_group_id,
1344: p_worksheet_id => g_worksheet_id);

Line 1351: PSB_WS_POS1.Cache_Named_Attributes

1347: raise FND_API.G_EXC_ERROR;
1348: end if;
1349:
1350:
1351: PSB_WS_POS1.Cache_Named_Attributes
1352: (p_return_status => l_return_status,
1353: p_business_group_id => g_business_group_id);
1354:
1355: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 2137: where attribute_id = PSB_WS_POS1.g_default_wklyhrs_id

2133: attribute_id,
2134: -- Fixed Bug # 3683644
2135: FND_NUMBER.canonical_to_number(attribute_value) attribute_value
2136: from PSB_POSITION_ASSIGNMENTS
2137: where attribute_id = PSB_WS_POS1.g_default_wklyhrs_id
2138: and (worksheet_id is null or worksheet_id = g_global_worksheet_id)
2139: and assignment_type = 'ATTRIBUTE'
2140: and (((effective_start_date <= l_end_date)
2141: and (effective_end_date is null))

Line 2194: PSB_WS_POS1.Cache_Named_Attribute_Values

2190: end loop;
2191:
2192: g_num_poswkh_assignments := 0;
2193:
2194: PSB_WS_POS1.Cache_Named_Attribute_Values
2195: (p_return_status => l_return_status,
2196: p_worksheet_id => g_global_worksheet_id,
2197: p_data_extract_id => g_data_extract_id,
2198: p_position_id => l_position_id);

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

3217:
3218: BEGIN
3219: l_pay_element_id := p_pay_element_id;
3220:
3221: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop
3222:
3223: if PSB_WS_POS1.g_elements(l_element_index).pay_element_id = l_pay_element_id then
3224:
3225: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;

Line 3223: if PSB_WS_POS1.g_elements(l_element_index).pay_element_id = l_pay_element_id then

3219: l_pay_element_id := p_pay_element_id;
3220:
3221: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop
3222:
3223: if PSB_WS_POS1.g_elements(l_element_index).pay_element_id = l_pay_element_id then
3224:
3225: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;
3226: l_processing_type := PSB_WS_POS1.g_elements(l_element_index).processing_type;
3227: l_max_element_value_type := PSB_WS_POS1.g_elements(l_element_index).max_element_value_type;

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

3221: for l_element_index in 1..PSB_WS_POS1.g_num_elements loop
3222:
3223: if PSB_WS_POS1.g_elements(l_element_index).pay_element_id = l_pay_element_id then
3224:
3225: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;
3226: l_processing_type := PSB_WS_POS1.g_elements(l_element_index).processing_type;
3227: l_max_element_value_type := PSB_WS_POS1.g_elements(l_element_index).max_element_value_type;
3228: l_max_element_value := PSB_WS_POS1.g_elements(l_element_index).max_element_value;
3229: l_salary_flag := PSB_WS_POS1.g_elements(l_element_index).salary_flag;

Line 3226: l_processing_type := PSB_WS_POS1.g_elements(l_element_index).processing_type;

3222:
3223: if PSB_WS_POS1.g_elements(l_element_index).pay_element_id = l_pay_element_id then
3224:
3225: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;
3226: l_processing_type := PSB_WS_POS1.g_elements(l_element_index).processing_type;
3227: l_max_element_value_type := PSB_WS_POS1.g_elements(l_element_index).max_element_value_type;
3228: l_max_element_value := PSB_WS_POS1.g_elements(l_element_index).max_element_value;
3229: l_salary_flag := PSB_WS_POS1.g_elements(l_element_index).salary_flag;
3230: l_salary_type := PSB_WS_POS1.g_elements(l_element_index).salary_type;

Line 3227: l_max_element_value_type := PSB_WS_POS1.g_elements(l_element_index).max_element_value_type;

3223: if PSB_WS_POS1.g_elements(l_element_index).pay_element_id = l_pay_element_id then
3224:
3225: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;
3226: l_processing_type := PSB_WS_POS1.g_elements(l_element_index).processing_type;
3227: l_max_element_value_type := PSB_WS_POS1.g_elements(l_element_index).max_element_value_type;
3228: l_max_element_value := PSB_WS_POS1.g_elements(l_element_index).max_element_value;
3229: l_salary_flag := PSB_WS_POS1.g_elements(l_element_index).salary_flag;
3230: l_salary_type := PSB_WS_POS1.g_elements(l_element_index).salary_type;
3231: l_follow_salary := PSB_WS_POS1.g_elements(l_element_index).follow_salary;

Line 3228: l_max_element_value := PSB_WS_POS1.g_elements(l_element_index).max_element_value;

3224:
3225: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;
3226: l_processing_type := PSB_WS_POS1.g_elements(l_element_index).processing_type;
3227: l_max_element_value_type := PSB_WS_POS1.g_elements(l_element_index).max_element_value_type;
3228: l_max_element_value := PSB_WS_POS1.g_elements(l_element_index).max_element_value;
3229: l_salary_flag := PSB_WS_POS1.g_elements(l_element_index).salary_flag;
3230: l_salary_type := PSB_WS_POS1.g_elements(l_element_index).salary_type;
3231: l_follow_salary := PSB_WS_POS1.g_elements(l_element_index).follow_salary;
3232: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;

Line 3229: l_salary_flag := PSB_WS_POS1.g_elements(l_element_index).salary_flag;

3225: l_element_name := PSB_WS_POS1.g_elements(l_element_index).element_name;
3226: l_processing_type := PSB_WS_POS1.g_elements(l_element_index).processing_type;
3227: l_max_element_value_type := PSB_WS_POS1.g_elements(l_element_index).max_element_value_type;
3228: l_max_element_value := PSB_WS_POS1.g_elements(l_element_index).max_element_value;
3229: l_salary_flag := PSB_WS_POS1.g_elements(l_element_index).salary_flag;
3230: l_salary_type := PSB_WS_POS1.g_elements(l_element_index).salary_type;
3231: l_follow_salary := PSB_WS_POS1.g_elements(l_element_index).follow_salary;
3232: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
3233: l_process_period_type := PSB_WS_POS1.g_elements(l_element_index).process_period_type;

Line 3230: l_salary_type := PSB_WS_POS1.g_elements(l_element_index).salary_type;

3226: l_processing_type := PSB_WS_POS1.g_elements(l_element_index).processing_type;
3227: l_max_element_value_type := PSB_WS_POS1.g_elements(l_element_index).max_element_value_type;
3228: l_max_element_value := PSB_WS_POS1.g_elements(l_element_index).max_element_value;
3229: l_salary_flag := PSB_WS_POS1.g_elements(l_element_index).salary_flag;
3230: l_salary_type := PSB_WS_POS1.g_elements(l_element_index).salary_type;
3231: l_follow_salary := PSB_WS_POS1.g_elements(l_element_index).follow_salary;
3232: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
3233: l_process_period_type := PSB_WS_POS1.g_elements(l_element_index).process_period_type;
3234: l_option_flag := PSB_WS_POS1.g_elements(l_element_index).option_flag;

Line 3231: l_follow_salary := PSB_WS_POS1.g_elements(l_element_index).follow_salary;

3227: l_max_element_value_type := PSB_WS_POS1.g_elements(l_element_index).max_element_value_type;
3228: l_max_element_value := PSB_WS_POS1.g_elements(l_element_index).max_element_value;
3229: l_salary_flag := PSB_WS_POS1.g_elements(l_element_index).salary_flag;
3230: l_salary_type := PSB_WS_POS1.g_elements(l_element_index).salary_type;
3231: l_follow_salary := PSB_WS_POS1.g_elements(l_element_index).follow_salary;
3232: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
3233: l_process_period_type := PSB_WS_POS1.g_elements(l_element_index).process_period_type;
3234: l_option_flag := PSB_WS_POS1.g_elements(l_element_index).option_flag;
3235: l_overwrite_flag := PSB_WS_POS1.g_elements(l_element_index).overwrite_flag;

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

3228: l_max_element_value := PSB_WS_POS1.g_elements(l_element_index).max_element_value;
3229: l_salary_flag := PSB_WS_POS1.g_elements(l_element_index).salary_flag;
3230: l_salary_type := PSB_WS_POS1.g_elements(l_element_index).salary_type;
3231: l_follow_salary := PSB_WS_POS1.g_elements(l_element_index).follow_salary;
3232: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
3233: l_process_period_type := PSB_WS_POS1.g_elements(l_element_index).process_period_type;
3234: l_option_flag := PSB_WS_POS1.g_elements(l_element_index).option_flag;
3235: l_overwrite_flag := PSB_WS_POS1.g_elements(l_element_index).overwrite_flag;
3236:

Line 3233: l_process_period_type := PSB_WS_POS1.g_elements(l_element_index).process_period_type;

3229: l_salary_flag := PSB_WS_POS1.g_elements(l_element_index).salary_flag;
3230: l_salary_type := PSB_WS_POS1.g_elements(l_element_index).salary_type;
3231: l_follow_salary := PSB_WS_POS1.g_elements(l_element_index).follow_salary;
3232: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
3233: l_process_period_type := PSB_WS_POS1.g_elements(l_element_index).process_period_type;
3234: l_option_flag := PSB_WS_POS1.g_elements(l_element_index).option_flag;
3235: l_overwrite_flag := PSB_WS_POS1.g_elements(l_element_index).overwrite_flag;
3236:
3237: exit;

Line 3234: l_option_flag := PSB_WS_POS1.g_elements(l_element_index).option_flag;

3230: l_salary_type := PSB_WS_POS1.g_elements(l_element_index).salary_type;
3231: l_follow_salary := PSB_WS_POS1.g_elements(l_element_index).follow_salary;
3232: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
3233: l_process_period_type := PSB_WS_POS1.g_elements(l_element_index).process_period_type;
3234: l_option_flag := PSB_WS_POS1.g_elements(l_element_index).option_flag;
3235: l_overwrite_flag := PSB_WS_POS1.g_elements(l_element_index).overwrite_flag;
3236:
3237: exit;
3238: end if;

Line 3235: l_overwrite_flag := PSB_WS_POS1.g_elements(l_element_index).overwrite_flag;

3231: l_follow_salary := PSB_WS_POS1.g_elements(l_element_index).follow_salary;
3232: l_period_type := PSB_WS_POS1.g_elements(l_element_index).period_type;
3233: l_process_period_type := PSB_WS_POS1.g_elements(l_element_index).process_period_type;
3234: l_option_flag := PSB_WS_POS1.g_elements(l_element_index).option_flag;
3235: l_overwrite_flag := PSB_WS_POS1.g_elements(l_element_index).overwrite_flag;
3236:
3237: exit;
3238: end if;
3239: end loop;

Line 3460: PSB_WS_POS1.HRMS_Factor

3456:
3457: if l_pay_basis = 'ANNUAL' then
3458: begin
3459:
3460: PSB_WS_POS1.HRMS_Factor
3461: (p_return_status => l_return_status,
3462: p_hrms_period_type => 'Y',
3463: p_budget_period_type => l_budget_period_type,
3464: p_position_name => p_position_name,

Line 3481: PSB_WS_POS1.HRMS_Factor

3477: end;
3478: elsif l_pay_basis = 'HOURLY' then
3479: begin
3480:
3481: PSB_WS_POS1.HRMS_Factor
3482: (p_return_status => l_return_status,
3483: p_hrms_period_type => 'W',
3484: p_budget_period_type => l_budget_period_type,
3485: p_position_name => p_position_name,

Line 3507: PSB_WS_POS1.HRMS_Factor

3503: end;
3504: elsif l_pay_basis = 'MONTHLY' then
3505: begin
3506:
3507: PSB_WS_POS1.HRMS_Factor
3508: (p_return_status => l_return_status,
3509: p_hrms_period_type => 'CM',
3510: p_budget_period_type => l_budget_period_type,
3511: p_position_name => p_position_name,

Line 3528: PSB_WS_POS1.HRMS_Factor

3524:
3525: end;
3526: elsif l_pay_basis = 'PERIOD' then
3527: begin
3528: PSB_WS_POS1.HRMS_Factor
3529: (p_return_status => l_return_status,
3530: /* For Bug No. 2504333 : Start */
3531: -- p_hrms_period_type => PSB_WS_POS1.g_elements(l_element_index).period_type,
3532: p_hrms_period_type => l_period_type,

Line 3531: -- p_hrms_period_type => PSB_WS_POS1.g_elements(l_element_index).period_type,

3527: begin
3528: PSB_WS_POS1.HRMS_Factor
3529: (p_return_status => l_return_status,
3530: /* For Bug No. 2504333 : Start */
3531: -- p_hrms_period_type => PSB_WS_POS1.g_elements(l_element_index).period_type,
3532: p_hrms_period_type => l_period_type,
3533: /* For Bug No. 2504333 : End */
3534: p_budget_period_type => l_budget_period_type,
3535: p_position_name => p_position_name,

Line 3553: else --PSB_WS_POS1.g_elements(l_element_index).salary_flag <> 'Y'

3549:
3550: end;
3551: end if; -- processing type <> 'N' (Non-recurring)
3552: end;
3553: else --PSB_WS_POS1.g_elements(l_element_index).salary_flag <> 'Y'
3554: begin
3555:
3556: if l_element_value_type = 'PS' then
3557: begin

Line 3567: PSB_WS_POS1.HRMS_Factor

3563: if l_processing_type = 'N' then
3564: l_new_element_value := l_new_element_cost;
3565: else
3566: begin
3567: PSB_WS_POS1.HRMS_Factor
3568: (p_return_status => l_return_status,
3569: /* For Bug No. 2504333 : Start */
3570: -- p_hrms_period_type => PSB_WS_POS1.g_elements(l_element_index).period_type,
3571: p_hrms_period_type => l_period_type,

Line 3570: -- p_hrms_period_type => PSB_WS_POS1.g_elements(l_element_index).period_type,

3566: begin
3567: PSB_WS_POS1.HRMS_Factor
3568: (p_return_status => l_return_status,
3569: /* For Bug No. 2504333 : Start */
3570: -- p_hrms_period_type => PSB_WS_POS1.g_elements(l_element_index).period_type,
3571: p_hrms_period_type => l_period_type,
3572: /* For Bug No. 2504333 : End */
3573: p_budget_period_type => l_budget_period_type,
3574: p_position_name => p_position_name,

Line 3591: end if; --PSB_WS_POS1.g_elements(l_element_index).salary_flag <> 'Y'

3587: --Ignore if l_element_value_type = 'F' (Formula)
3588: end if; -- l_element_value_type
3589:
3590: end;
3591: end if; --PSB_WS_POS1.g_elements(l_element_index).salary_flag <> 'Y'
3592:
3593:
3594: -- Limit the element value to the max value
3595: l_new_element_value := least(l_new_element_value, nvl(l_max_element_value, l_new_element_value));