[Home] [Help]
39: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
40: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
41: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
42: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
43: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
44: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
45: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
46: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
47: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1304: l_location_region pa_locations.region%TYPE;
1305: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
1306: l_location_country_code pa_locations.country_code%TYPE;
1307: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
1308: l_work_type_name pa_work_types_vl.name%TYPE;
1309: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1310: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1311: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1850: --get the name as we will not have it as the field is a poplist on the page
1851: IF l_work_type_id <> FND_API.G_MISS_NUM AND l_work_type_id IS NOT NULL THEN
1852: IF l_work_type_name = FND_API.G_MISS_CHAR OR l_work_type_name IS NULL THEN
1853: SELECT name INTO l_work_type_name
1854: FROM pa_work_types_vl
1855: WHERE work_type_id = l_work_type_id;
1856: END IF;
1857: x_document := x_document||get_translated_attr_name('WORK_TYPE_NAME')||' - '||l_work_type_name||'
';
1858: END IF;