[Home] [Help]
1075:
1076: IF nvl(g_asgmts_periods_tbl_count,0) > 0 THEN
1077:
1078: --dbms_output.put_line('calling create task assignment periods');
1079: Pa_Task_Assignments_Pvt.Create_Task_Assignment_Periods
1080: ( p_api_version_number => 1.0
1081: ,p_commit => FND_API.G_FALSE
1082: ,p_init_msg_list => FND_API.G_FALSE
1083: ,p_pm_product_code => p_pm_product_code
1251: END IF;
1252:
1253: IF nvl(g_asgmts_periods_tbl_count,0) > 0 THEN
1254:
1255: Pa_Task_Assignments_Pvt.Create_Task_Assignment_Periods
1256: (p_api_version_number => 1.0
1257: ,p_commit => FND_API.G_FALSE
1258: ,p_init_msg_list => FND_API.G_FALSE
1259: ,p_pm_product_code => p_pm_product_code
1890: END IF;
1891:
1892: -- DHI ER: allowing multiple user to update task assignment
1893: -- Removed logic to lock version.
1894: -- pa_task_assignments_pvt.lock_version(l_project_id, l_struct_elem_version_id);
1895:
1896: -- Bug 3940853: Raise locking error return from structure API
1897: IF FND_MSG_PUB.count_msg > 0 THEN
1898: x_return_status := FND_API.G_RET_STS_ERROR;
2409:
2410: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(k_index).pa_task_id := l_d_task_id;
2411: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(k_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
2412:
2413: lk_resource_list_member_id_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
2414:
2415: l_cbs_element_id_tbl(k_index) :=pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ; -- Added for CBS 16598322
2416:
2417: l_start_date_tbl(k_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
2411: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(k_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
2412:
2413: lk_resource_list_member_id_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
2414:
2415: l_cbs_element_id_tbl(k_index) :=pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ; -- Added for CBS 16598322
2416:
2417: l_start_date_tbl(k_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
2418: l_end_date_tbl(k_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
2419: --l_latest_eff_pub_flag_tbl(1) := NULL ; --TBD
2413: lk_resource_list_member_id_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
2414:
2415: l_cbs_element_id_tbl(k_index) :=pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ; -- Added for CBS 16598322
2416:
2417: l_start_date_tbl(k_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
2418: l_end_date_tbl(k_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
2419: --l_latest_eff_pub_flag_tbl(1) := NULL ; --TBD
2420: l_resource_list_member_id_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
2421: l_project_assignment_id_tbl(k_index) := -1 ;
2414:
2415: l_cbs_element_id_tbl(k_index) :=pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ; -- Added for CBS 16598322
2416:
2417: l_start_date_tbl(k_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
2418: l_end_date_tbl(k_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
2419: --l_latest_eff_pub_flag_tbl(1) := NULL ; --TBD
2420: l_resource_list_member_id_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
2421: l_project_assignment_id_tbl(k_index) := -1 ;
2422:
2416:
2417: l_start_date_tbl(k_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
2418: l_end_date_tbl(k_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
2419: --l_latest_eff_pub_flag_tbl(1) := NULL ; --TBD
2420: l_resource_list_member_id_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
2421: l_project_assignment_id_tbl(k_index) := -1 ;
2422:
2423: IF g_asgmts_periods_tbl_count > 0 THEN
2424:
2432: FETCH C_Workplan_Costs_enabled INTO C_Workplan_Costs_rec;
2433: CLOSE C_Workplan_Costs_enabled;
2434:
2435: IF C_Workplan_Costs_rec.enabled_flag = 'Y' THEN
2436: l_raw_cost_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_raw_cost) ;
2437: l_burdened_cost_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_bur_cost) ;
2438: /* Bug Fix 5505113
2439: As per the B n F team request started overriding the miss num with NULL.
2440:
2433: CLOSE C_Workplan_Costs_enabled;
2434:
2435: IF C_Workplan_Costs_rec.enabled_flag = 'Y' THEN
2436: l_raw_cost_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_raw_cost) ;
2437: l_burdened_cost_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_bur_cost) ;
2438: /* Bug Fix 5505113
2439: As per the B n F team request started overriding the miss num with NULL.
2440:
2441: */
2447: l_burdened_cost_tbl(k_index) := NULL;
2448: END IF;
2449:
2450: END IF;
2451: l_quantity_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_quantity) ;
2452: /* Bug Fix 5505113
2453: As per the B n F team request started overriding the miss num with NULL.
2454:
2455: */
2458: END IF;
2459:
2460: END IF;
2461:
2462: l_currency_code_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).currency_code) ;
2463: l_product_code_tbl(k_index) := p_pm_product_code ;
2464: l_product_reference_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).pm_task_asgmt_reference) ;
2465: l_attribute_category_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category) ;
2466: l_attribute1(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
2460: END IF;
2461:
2462: l_currency_code_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).currency_code) ;
2463: l_product_code_tbl(k_index) := p_pm_product_code ;
2464: l_product_reference_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).pm_task_asgmt_reference) ;
2465: l_attribute_category_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category) ;
2466: l_attribute1(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
2467: l_attribute2(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
2468: l_attribute3(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
2461:
2462: l_currency_code_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).currency_code) ;
2463: l_product_code_tbl(k_index) := p_pm_product_code ;
2464: l_product_reference_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).pm_task_asgmt_reference) ;
2465: l_attribute_category_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category) ;
2466: l_attribute1(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
2467: l_attribute2(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
2468: l_attribute3(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
2469: l_attribute4(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
2462: l_currency_code_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).currency_code) ;
2463: l_product_code_tbl(k_index) := p_pm_product_code ;
2464: l_product_reference_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).pm_task_asgmt_reference) ;
2465: l_attribute_category_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category) ;
2466: l_attribute1(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
2467: l_attribute2(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
2468: l_attribute3(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
2469: l_attribute4(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
2470: l_attribute5(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
2463: l_product_code_tbl(k_index) := p_pm_product_code ;
2464: l_product_reference_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).pm_task_asgmt_reference) ;
2465: l_attribute_category_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category) ;
2466: l_attribute1(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
2467: l_attribute2(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
2468: l_attribute3(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
2469: l_attribute4(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
2470: l_attribute5(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
2471: l_attribute6(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
2464: l_product_reference_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).pm_task_asgmt_reference) ;
2465: l_attribute_category_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category) ;
2466: l_attribute1(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
2467: l_attribute2(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
2468: l_attribute3(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
2469: l_attribute4(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
2470: l_attribute5(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
2471: l_attribute6(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
2472: l_attribute7(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
2465: l_attribute_category_tbl(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category) ;
2466: l_attribute1(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
2467: l_attribute2(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
2468: l_attribute3(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
2469: l_attribute4(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
2470: l_attribute5(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
2471: l_attribute6(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
2472: l_attribute7(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
2473: l_attribute8(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
2466: l_attribute1(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
2467: l_attribute2(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
2468: l_attribute3(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
2469: l_attribute4(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
2470: l_attribute5(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
2471: l_attribute6(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
2472: l_attribute7(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
2473: l_attribute8(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
2474: l_attribute9(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
2467: l_attribute2(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
2468: l_attribute3(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
2469: l_attribute4(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
2470: l_attribute5(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
2471: l_attribute6(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
2472: l_attribute7(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
2473: l_attribute8(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
2474: l_attribute9(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
2475: l_attribute10(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
2468: l_attribute3(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
2469: l_attribute4(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
2470: l_attribute5(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
2471: l_attribute6(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
2472: l_attribute7(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
2473: l_attribute8(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
2474: l_attribute9(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
2475: l_attribute10(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
2476: l_attribute11(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
2469: l_attribute4(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
2470: l_attribute5(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
2471: l_attribute6(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
2472: l_attribute7(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
2473: l_attribute8(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
2474: l_attribute9(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
2475: l_attribute10(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
2476: l_attribute11(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
2477: l_attribute12(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
2470: l_attribute5(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
2471: l_attribute6(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
2472: l_attribute7(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
2473: l_attribute8(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
2474: l_attribute9(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
2475: l_attribute10(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
2476: l_attribute11(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
2477: l_attribute12(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
2478: l_attribute13(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
2471: l_attribute6(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
2472: l_attribute7(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
2473: l_attribute8(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
2474: l_attribute9(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
2475: l_attribute10(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
2476: l_attribute11(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
2477: l_attribute12(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
2478: l_attribute13(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
2479: l_attribute14(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
2472: l_attribute7(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
2473: l_attribute8(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
2474: l_attribute9(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
2475: l_attribute10(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
2476: l_attribute11(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
2477: l_attribute12(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
2478: l_attribute13(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
2479: l_attribute14(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
2480: l_attribute15(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
2473: l_attribute8(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
2474: l_attribute9(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
2475: l_attribute10(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
2476: l_attribute11(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
2477: l_attribute12(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
2478: l_attribute13(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
2479: l_attribute14(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
2480: l_attribute15(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
2481: l_attribute16(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
2474: l_attribute9(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
2475: l_attribute10(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
2476: l_attribute11(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
2477: l_attribute12(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
2478: l_attribute13(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
2479: l_attribute14(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
2480: l_attribute15(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
2481: l_attribute16(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
2482: l_attribute17(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
2475: l_attribute10(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
2476: l_attribute11(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
2477: l_attribute12(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
2478: l_attribute13(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
2479: l_attribute14(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
2480: l_attribute15(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
2481: l_attribute16(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
2482: l_attribute17(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
2483: l_attribute18(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
2476: l_attribute11(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
2477: l_attribute12(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
2478: l_attribute13(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
2479: l_attribute14(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
2480: l_attribute15(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
2481: l_attribute16(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
2482: l_attribute17(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
2483: l_attribute18(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
2484: l_attribute19(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
2477: l_attribute12(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
2478: l_attribute13(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
2479: l_attribute14(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
2480: l_attribute15(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
2481: l_attribute16(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
2482: l_attribute17(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
2483: l_attribute18(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
2484: l_attribute19(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
2485: l_attribute20(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
2478: l_attribute13(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
2479: l_attribute14(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
2480: l_attribute15(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
2481: l_attribute16(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
2482: l_attribute17(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
2483: l_attribute18(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
2484: l_attribute19(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
2485: l_attribute20(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
2486: l_attribute21(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
2479: l_attribute14(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
2480: l_attribute15(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
2481: l_attribute16(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
2482: l_attribute17(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
2483: l_attribute18(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
2484: l_attribute19(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
2485: l_attribute20(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
2486: l_attribute21(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
2487: l_attribute22(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
2480: l_attribute15(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
2481: l_attribute16(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
2482: l_attribute17(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
2483: l_attribute18(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
2484: l_attribute19(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
2485: l_attribute20(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
2486: l_attribute21(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
2487: l_attribute22(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
2488: l_attribute23(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
2481: l_attribute16(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
2482: l_attribute17(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
2483: l_attribute18(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
2484: l_attribute19(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
2485: l_attribute20(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
2486: l_attribute21(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
2487: l_attribute22(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
2488: l_attribute23(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
2489: l_attribute24(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
2482: l_attribute17(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
2483: l_attribute18(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
2484: l_attribute19(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
2485: l_attribute20(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
2486: l_attribute21(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
2487: l_attribute22(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
2488: l_attribute23(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
2489: l_attribute24(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
2490: l_attribute25(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
2483: l_attribute18(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
2484: l_attribute19(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
2485: l_attribute20(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
2486: l_attribute21(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
2487: l_attribute22(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
2488: l_attribute23(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
2489: l_attribute24(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
2490: l_attribute25(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
2491: l_attribute26(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
2484: l_attribute19(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
2485: l_attribute20(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
2486: l_attribute21(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
2487: l_attribute22(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
2488: l_attribute23(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
2489: l_attribute24(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
2490: l_attribute25(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
2491: l_attribute26(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
2492: l_attribute27(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
2485: l_attribute20(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
2486: l_attribute21(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
2487: l_attribute22(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
2488: l_attribute23(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
2489: l_attribute24(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
2490: l_attribute25(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
2491: l_attribute26(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
2492: l_attribute27(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
2493: l_attribute28(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
2486: l_attribute21(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
2487: l_attribute22(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
2488: l_attribute23(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
2489: l_attribute24(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
2490: l_attribute25(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
2491: l_attribute26(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
2492: l_attribute27(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
2493: l_attribute28(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
2494: l_attribute29(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
2487: l_attribute22(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
2488: l_attribute23(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
2489: l_attribute24(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
2490: l_attribute25(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
2491: l_attribute26(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
2492: l_attribute27(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
2493: l_attribute28(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
2494: l_attribute29(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
2495: l_attribute30(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
2488: l_attribute23(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
2489: l_attribute24(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
2490: l_attribute25(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
2491: l_attribute26(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
2492: l_attribute27(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
2493: l_attribute28(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
2494: l_attribute29(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
2495: l_attribute30(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
2496: l_scheduled_delay_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay) ;--Bug 3948128
2489: l_attribute24(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
2490: l_attribute25(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
2491: l_attribute26(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
2492: l_attribute27(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
2493: l_attribute28(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
2494: l_attribute29(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
2495: l_attribute30(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
2496: l_scheduled_delay_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay) ;--Bug 3948128
2497:
2490: l_attribute25(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
2491: l_attribute26(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
2492: l_attribute27(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
2493: l_attribute28(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
2494: l_attribute29(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
2495: l_attribute30(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
2496: l_scheduled_delay_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay) ;--Bug 3948128
2497:
2498: IF l_cbs_enabled_project = 'N' THEN
2491: l_attribute26(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
2492: l_attribute27(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
2493: l_attribute28(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
2494: l_attribute29(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
2495: l_attribute30(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
2496: l_scheduled_delay_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay) ;--Bug 3948128
2497:
2498: IF l_cbs_enabled_project = 'N' THEN
2499: open c_unique_res_check( l_struct_elem_version_id,
2492: l_attribute27(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
2493: l_attribute28(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
2494: l_attribute29(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
2495: l_attribute30(k_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
2496: l_scheduled_delay_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay) ;--Bug 3948128
2497:
2498: IF l_cbs_enabled_project = 'N' THEN
2499: open c_unique_res_check( l_struct_elem_version_id,
2500: l_project_id,
3222: -- Bug 4200146: Set the global variable to
3223: -- prevent rollup from happening in PJI plan update call
3224: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N';
3225:
3226: Pa_Task_Assignments_pvt.Create_Task_Assignment_Periods
3227: ( p_api_version_number => 1.0
3228: ,p_commit => FND_API.G_FALSE
3229: ,p_init_msg_list => FND_API.G_FALSE
3230: ,p_pm_product_code => p_pm_product_code
3498: -- Bug 4200146: Set the global variable to
3499: -- prevent rollup from happening in PJI plan update call
3500: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N';
3501:
3502: Pa_Task_Assignments_pvt.Create_Task_Assignment_Periods
3503: ( p_api_version_number => 1.0
3504: ,p_commit => FND_API.G_FALSE
3505: ,p_init_msg_list => FND_API.G_FALSE
3506: ,p_pm_product_code => p_pm_product_code
4590: END IF;
4591:
4592: -- DHI ER: allowing multiple user to update task assignment
4593: -- Removed logic to lock version.
4594: -- pa_task_assignments_pvt.lock_version(l_project_id, l_struct_elem_version_id);
4595:
4596: -- Bug 3940853: Raise locking error return from structure API
4597: IF FND_MSG_PUB.count_msg > 0 THEN
4598: x_return_status := FND_API.G_RET_STS_ERROR;
5587: pa_debug.g_err_stage:='Setting other main variables';
5588: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5589: END IF;
5590:
5591: l_start_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
5592: l_end_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
5593:
5594: l_planning_start_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_start_date) ;
5595: l_planning_end_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_end_date) ;
5588: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5589: END IF;
5590:
5591: l_start_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
5592: l_end_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
5593:
5594: l_planning_start_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_start_date) ;
5595: l_planning_end_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_end_date) ;
5596:
5590:
5591: l_start_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
5592: l_end_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
5593:
5594: l_planning_start_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_start_date) ;
5595: l_planning_end_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_end_date) ;
5596:
5597: lu_task_elem_version_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_task_elem_version_id_tbl(i));
5598:
5591: l_start_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
5592: l_end_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
5593:
5594: l_planning_start_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_start_date) ;
5595: l_planning_end_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_end_date) ;
5596:
5597: lu_task_elem_version_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_task_elem_version_id_tbl(i));
5598:
5599: l_resource_list_member_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
5593:
5594: l_planning_start_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_start_date) ;
5595: l_planning_end_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_end_date) ;
5596:
5597: lu_task_elem_version_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_task_elem_version_id_tbl(i));
5598:
5599: l_resource_list_member_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
5600: l_resource_assignment_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(lp_resource_assignment_id_tbl(i));
5601:
5595: l_planning_end_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(C_Res_Asgmt_Data_Rec.planning_end_date) ;
5596:
5597: lu_task_elem_version_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_task_elem_version_id_tbl(i));
5598:
5599: l_resource_list_member_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
5600: l_resource_assignment_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(lp_resource_assignment_id_tbl(i));
5601:
5602: l_cbs_element_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ;
5603:
5596:
5597: lu_task_elem_version_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_task_elem_version_id_tbl(i));
5598:
5599: l_resource_list_member_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
5600: l_resource_assignment_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(lp_resource_assignment_id_tbl(i));
5601:
5602: l_cbs_element_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ;
5603:
5604: ----Bug#9374037 Starts
5598:
5599: l_resource_list_member_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
5600: l_resource_assignment_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(lp_resource_assignment_id_tbl(i));
5601:
5602: l_cbs_element_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ;
5603:
5604: ----Bug#9374037 Starts
5605: -- l_project_assignment_id_tbl(u_index) := -1 ;
5606:
5625: --Non-rate based one can override currency.
5626: if C_Res_Asgmt_Data_Rec.rate_based_flag = 'Y' AND C_Workplan_Costs_rec.enabled_flag = 'N' THEN
5627: l_currency_code_tbl(u_index) := NULL;
5628: else
5629: l_currency_code_tbl(u_index) := pa_task_assignments_pvt.pfchar(l_currency_code) ;
5630: end if;
5631:
5632: IF g_asgmts_periods_tbl_count > 0 THEN
5633:
5636: l_burdened_cost_tbl(u_index) := NULL ;
5637:
5638: ELSE
5639: IF C_Workplan_Costs_rec.enabled_flag = 'Y' THEN
5640: l_raw_cost_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_raw_cost) ;
5641: l_burdened_cost_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_bur_cost) ;
5642: /* Bug Fix 5505113
5643: */
5644: IF l_raw_cost_tbl(u_index) = FND_API.G_MISS_NUM THEN
5637:
5638: ELSE
5639: IF C_Workplan_Costs_rec.enabled_flag = 'Y' THEN
5640: l_raw_cost_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_raw_cost) ;
5641: l_burdened_cost_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_bur_cost) ;
5642: /* Bug Fix 5505113
5643: */
5644: IF l_raw_cost_tbl(u_index) = FND_API.G_MISS_NUM THEN
5645: l_raw_cost_tbl(u_index) := NULL;
5649: l_burdened_cost_tbl(u_index) := NULL;
5650: END IF;
5651:
5652: END IF;
5653: l_quantity_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_quantity) ;
5654: /* Bug Fix 5505113
5655: */
5656: IF l_quantity_tbl(u_index) = FND_API.G_MISS_NUM THEN
5657: l_quantity_tbl(u_index) := NULL;
5663: pa_debug.g_err_stage:='Setting attributes';
5664: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5665: END IF;
5666:
5667: l_attribute_category_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category);
5668: l_attribute1_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1);
5669: l_attribute2_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2);
5670: l_attribute3_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3);
5671: l_attribute4_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4);
5664: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5665: END IF;
5666:
5667: l_attribute_category_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category);
5668: l_attribute1_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1);
5669: l_attribute2_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2);
5670: l_attribute3_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3);
5671: l_attribute4_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4);
5672: l_attribute5_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5);
5665: END IF;
5666:
5667: l_attribute_category_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category);
5668: l_attribute1_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1);
5669: l_attribute2_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2);
5670: l_attribute3_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3);
5671: l_attribute4_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4);
5672: l_attribute5_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5);
5673: l_attribute6_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6);
5666:
5667: l_attribute_category_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category);
5668: l_attribute1_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1);
5669: l_attribute2_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2);
5670: l_attribute3_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3);
5671: l_attribute4_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4);
5672: l_attribute5_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5);
5673: l_attribute6_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6);
5674: l_attribute7_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7);
5667: l_attribute_category_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute_category);
5668: l_attribute1_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1);
5669: l_attribute2_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2);
5670: l_attribute3_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3);
5671: l_attribute4_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4);
5672: l_attribute5_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5);
5673: l_attribute6_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6);
5674: l_attribute7_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7);
5675: l_attribute8_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8);
5668: l_attribute1_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1);
5669: l_attribute2_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2);
5670: l_attribute3_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3);
5671: l_attribute4_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4);
5672: l_attribute5_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5);
5673: l_attribute6_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6);
5674: l_attribute7_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7);
5675: l_attribute8_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8);
5676: l_attribute9_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9);
5669: l_attribute2_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2);
5670: l_attribute3_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3);
5671: l_attribute4_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4);
5672: l_attribute5_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5);
5673: l_attribute6_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6);
5674: l_attribute7_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7);
5675: l_attribute8_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8);
5676: l_attribute9_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9);
5677: l_attribute10_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10);
5670: l_attribute3_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3);
5671: l_attribute4_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4);
5672: l_attribute5_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5);
5673: l_attribute6_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6);
5674: l_attribute7_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7);
5675: l_attribute8_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8);
5676: l_attribute9_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9);
5677: l_attribute10_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10);
5678: l_attribute11_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11);
5671: l_attribute4_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4);
5672: l_attribute5_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5);
5673: l_attribute6_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6);
5674: l_attribute7_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7);
5675: l_attribute8_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8);
5676: l_attribute9_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9);
5677: l_attribute10_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10);
5678: l_attribute11_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11);
5679: l_attribute12_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12);
5672: l_attribute5_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5);
5673: l_attribute6_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6);
5674: l_attribute7_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7);
5675: l_attribute8_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8);
5676: l_attribute9_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9);
5677: l_attribute10_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10);
5678: l_attribute11_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11);
5679: l_attribute12_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12);
5680: l_attribute13_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13);
5673: l_attribute6_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6);
5674: l_attribute7_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7);
5675: l_attribute8_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8);
5676: l_attribute9_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9);
5677: l_attribute10_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10);
5678: l_attribute11_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11);
5679: l_attribute12_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12);
5680: l_attribute13_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13);
5681: l_attribute14_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14);
5674: l_attribute7_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7);
5675: l_attribute8_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8);
5676: l_attribute9_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9);
5677: l_attribute10_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10);
5678: l_attribute11_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11);
5679: l_attribute12_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12);
5680: l_attribute13_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13);
5681: l_attribute14_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14);
5682: l_attribute15_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15);
5675: l_attribute8_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8);
5676: l_attribute9_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9);
5677: l_attribute10_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10);
5678: l_attribute11_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11);
5679: l_attribute12_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12);
5680: l_attribute13_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13);
5681: l_attribute14_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14);
5682: l_attribute15_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15);
5683: l_attribute16_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16);
5676: l_attribute9_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9);
5677: l_attribute10_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10);
5678: l_attribute11_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11);
5679: l_attribute12_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12);
5680: l_attribute13_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13);
5681: l_attribute14_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14);
5682: l_attribute15_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15);
5683: l_attribute16_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16);
5684: l_attribute17_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17);
5677: l_attribute10_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10);
5678: l_attribute11_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11);
5679: l_attribute12_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12);
5680: l_attribute13_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13);
5681: l_attribute14_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14);
5682: l_attribute15_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15);
5683: l_attribute16_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16);
5684: l_attribute17_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17);
5685: l_attribute18_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18);
5678: l_attribute11_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11);
5679: l_attribute12_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12);
5680: l_attribute13_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13);
5681: l_attribute14_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14);
5682: l_attribute15_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15);
5683: l_attribute16_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16);
5684: l_attribute17_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17);
5685: l_attribute18_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18);
5686: l_attribute19_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19);
5679: l_attribute12_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12);
5680: l_attribute13_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13);
5681: l_attribute14_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14);
5682: l_attribute15_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15);
5683: l_attribute16_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16);
5684: l_attribute17_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17);
5685: l_attribute18_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18);
5686: l_attribute19_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19);
5687: l_attribute20_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20);
5680: l_attribute13_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13);
5681: l_attribute14_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14);
5682: l_attribute15_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15);
5683: l_attribute16_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16);
5684: l_attribute17_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17);
5685: l_attribute18_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18);
5686: l_attribute19_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19);
5687: l_attribute20_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20);
5688: l_attribute21_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21);
5681: l_attribute14_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14);
5682: l_attribute15_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15);
5683: l_attribute16_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16);
5684: l_attribute17_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17);
5685: l_attribute18_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18);
5686: l_attribute19_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19);
5687: l_attribute20_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20);
5688: l_attribute21_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21);
5689: l_attribute22_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22);
5682: l_attribute15_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15);
5683: l_attribute16_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16);
5684: l_attribute17_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17);
5685: l_attribute18_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18);
5686: l_attribute19_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19);
5687: l_attribute20_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20);
5688: l_attribute21_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21);
5689: l_attribute22_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22);
5690: l_attribute23_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23);
5683: l_attribute16_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16);
5684: l_attribute17_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17);
5685: l_attribute18_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18);
5686: l_attribute19_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19);
5687: l_attribute20_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20);
5688: l_attribute21_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21);
5689: l_attribute22_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22);
5690: l_attribute23_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23);
5691: l_attribute24_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24);
5684: l_attribute17_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17);
5685: l_attribute18_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18);
5686: l_attribute19_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19);
5687: l_attribute20_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20);
5688: l_attribute21_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21);
5689: l_attribute22_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22);
5690: l_attribute23_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23);
5691: l_attribute24_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24);
5692: l_attribute25_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25);
5685: l_attribute18_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18);
5686: l_attribute19_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19);
5687: l_attribute20_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20);
5688: l_attribute21_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21);
5689: l_attribute22_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22);
5690: l_attribute23_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23);
5691: l_attribute24_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24);
5692: l_attribute25_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25);
5693: l_attribute26_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26);
5686: l_attribute19_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19);
5687: l_attribute20_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20);
5688: l_attribute21_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21);
5689: l_attribute22_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22);
5690: l_attribute23_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23);
5691: l_attribute24_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24);
5692: l_attribute25_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25);
5693: l_attribute26_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26);
5694: l_attribute27_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27);
5687: l_attribute20_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20);
5688: l_attribute21_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21);
5689: l_attribute22_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22);
5690: l_attribute23_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23);
5691: l_attribute24_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24);
5692: l_attribute25_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25);
5693: l_attribute26_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26);
5694: l_attribute27_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27);
5695: l_attribute28_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28);
5688: l_attribute21_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21);
5689: l_attribute22_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22);
5690: l_attribute23_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23);
5691: l_attribute24_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24);
5692: l_attribute25_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25);
5693: l_attribute26_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26);
5694: l_attribute27_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27);
5695: l_attribute28_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28);
5696: l_attribute29_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29);
5689: l_attribute22_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22);
5690: l_attribute23_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23);
5691: l_attribute24_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24);
5692: l_attribute25_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25);
5693: l_attribute26_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26);
5694: l_attribute27_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27);
5695: l_attribute28_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28);
5696: l_attribute29_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29);
5697: l_attribute30_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30);
5690: l_attribute23_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23);
5691: l_attribute24_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24);
5692: l_attribute25_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25);
5693: l_attribute26_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26);
5694: l_attribute27_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27);
5695: l_attribute28_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28);
5696: l_attribute29_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29);
5697: l_attribute30_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30);
5698: l_scheduled_delay_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay); --Bug 3948128
5691: l_attribute24_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24);
5692: l_attribute25_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25);
5693: l_attribute26_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26);
5694: l_attribute27_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27);
5695: l_attribute28_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28);
5696: l_attribute29_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29);
5697: l_attribute30_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30);
5698: l_scheduled_delay_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay); --Bug 3948128
5699: l_spread_curve_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_spread_curve_id);--Bug#8646853
5692: l_attribute25_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25);
5693: l_attribute26_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26);
5694: l_attribute27_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27);
5695: l_attribute28_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28);
5696: l_attribute29_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29);
5697: l_attribute30_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30);
5698: l_scheduled_delay_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay); --Bug 3948128
5699: l_spread_curve_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_spread_curve_id);--Bug#8646853
5700: l_fixed_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(l_fixed_date) ;--Bug#8646853
5693: l_attribute26_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26);
5694: l_attribute27_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27);
5695: l_attribute28_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28);
5696: l_attribute29_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29);
5697: l_attribute30_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30);
5698: l_scheduled_delay_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay); --Bug 3948128
5699: l_spread_curve_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_spread_curve_id);--Bug#8646853
5700: l_fixed_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(l_fixed_date) ;--Bug#8646853
5701:
5694: l_attribute27_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27);
5695: l_attribute28_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28);
5696: l_attribute29_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29);
5697: l_attribute30_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30);
5698: l_scheduled_delay_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay); --Bug 3948128
5699: l_spread_curve_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_spread_curve_id);--Bug#8646853
5700: l_fixed_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(l_fixed_date) ;--Bug#8646853
5701:
5702:
5695: l_attribute28_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28);
5696: l_attribute29_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29);
5697: l_attribute30_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30);
5698: l_scheduled_delay_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay); --Bug 3948128
5699: l_spread_curve_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_spread_curve_id);--Bug#8646853
5700: l_fixed_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(l_fixed_date) ;--Bug#8646853
5701:
5702:
5703: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5696: l_attribute29_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29);
5697: l_attribute30_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30);
5698: l_scheduled_delay_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay); --Bug 3948128
5699: l_spread_curve_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_spread_curve_id);--Bug#8646853
5700: l_fixed_date_tbl(u_index) := pa_task_assignments_pvt.pfdate(l_fixed_date) ;--Bug#8646853
5701:
5702:
5703: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5704: pa_debug.g_err_stage:='Setting update only parameters:';
5704: pa_debug.g_err_stage:='Setting update only parameters:';
5705: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5706: END IF;
5707:
5708: l_description_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).description);
5709: l_use_task_schedule_flag_tbl(u_index) := pa_task_assignments_pvt.pfchar(nvl(p_task_assignments_in(i).use_task_schedule_flag, C_Res_Asgmt_Data_Rec.use_task_schedule_flag));
5710:
5711: --dbms_output.put_line('p_task_assignments_in(i).procure_resource_flag:' || p_task_assignments_in(i).procure_resource_flag);
5712: --dbms_output.put_line('p_task_assignments_in(i).use_task_schedule_flag:' || p_task_assignments_in(i).use_task_schedule_flag);
5705: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5706: END IF;
5707:
5708: l_description_tbl(u_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).description);
5709: l_use_task_schedule_flag_tbl(u_index) := pa_task_assignments_pvt.pfchar(nvl(p_task_assignments_in(i).use_task_schedule_flag, C_Res_Asgmt_Data_Rec.use_task_schedule_flag));
5710:
5711: --dbms_output.put_line('p_task_assignments_in(i).procure_resource_flag:' || p_task_assignments_in(i).procure_resource_flag);
5712: --dbms_output.put_line('p_task_assignments_in(i).use_task_schedule_flag:' || p_task_assignments_in(i).use_task_schedule_flag);
5713:
5710:
5711: --dbms_output.put_line('p_task_assignments_in(i).procure_resource_flag:' || p_task_assignments_in(i).procure_resource_flag);
5712: --dbms_output.put_line('p_task_assignments_in(i).use_task_schedule_flag:' || p_task_assignments_in(i).use_task_schedule_flag);
5713:
5714: -- l_procure_resource_flag_tbl(u_index) := pa_task_assignments_pvt.pfchar(nvl(p_task_assignments_in(i).procure_resource_flag, C_Res_Asgmt_Data_Rec.procure_resource_flag));
5715:
5716:
5717: IF g_asgmts_periods_tbl_count > 0 THEN
5718:
5720: l_burd_cost_rate_override_tbl(u_index) := NULL ;
5721: ELSE
5722: if C_Res_Asgmt_Data_Rec.rate_based_flag = 'Y' AND C_Workplan_Costs_rec.enabled_flag = 'Y' THEN
5723: --dbms_output.put_line('p_task_assignments_in(i).raw_cost_rate_override:' || p_task_assignments_in(i).raw_cost_rate_override);
5724: l_raw_cost_rate_override_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).raw_cost_rate_override);
5725:
5726: --dbms_output.put_line('p_task_assignments_in(i).burd_cost_rate_override:' || p_task_assignments_in(i).burd_cost_rate_override);
5727:
5728: l_burd_cost_rate_override_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).burd_cost_rate_override);
5724: l_raw_cost_rate_override_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).raw_cost_rate_override);
5725:
5726: --dbms_output.put_line('p_task_assignments_in(i).burd_cost_rate_override:' || p_task_assignments_in(i).burd_cost_rate_override);
5727:
5728: l_burd_cost_rate_override_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).burd_cost_rate_override);
5729: /* Bug Fix 5505113
5730: */
5731: IF l_raw_cost_rate_override_tbl(u_index) = FND_API.G_MISS_NUM THEN
5732: l_raw_cost_rate_override_tbl(u_index) := NULL;
5738:
5739: elsif C_Res_Asgmt_Data_Rec.rate_based_flag = 'N' AND C_Workplan_Costs_rec.enabled_flag = 'Y' THEN
5740: --dbms_output.put_line('p_task_assignments_in(i).burd_cost_rate_override:' || p_task_assignments_in(i).burd_cost_rate_override);
5741:
5742: l_burd_cost_rate_override_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).burd_cost_rate_override);
5743: /* Bug Fix 5505113
5744: */
5745: IF l_burd_cost_rate_override_tbl(u_index) = FND_API.G_MISS_NUM THEN
5746: l_burd_cost_rate_override_tbl(u_index) := NULL;
5753: pa_debug.g_err_stage:='p_task_assignments_in(i).billable_work_percent' || p_task_assignments_in(i).billable_work_percent;
5754: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5755: END IF;
5756:
5757: l_billable_work_percent_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).billable_work_percent);
5758:
5759: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5760: pa_debug.g_err_stage:='l_cost_type_id' || l_cost_type_id;
5761: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5760: pa_debug.g_err_stage:='l_cost_type_id' || l_cost_type_id;
5761: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5762: END IF;
5763:
5764: l_mfc_cost_type_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(l_cost_type_id);
5765: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5766: pa_debug.g_err_stage:='End of Setting All Update Params: int. index:' || u_index || ' Overall Index:' || i;
5767: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5768:
5773: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5774: END IF;
5775:
5776:
5777: l_task_name_tbl(u_index) := pa_task_assignments_pvt.pfchar(pa_proj_elements_utils.get_element_name(C_Res_Asgmt_Data_Rec.task_id));
5778:
5779: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5780: pa_debug.g_err_stage:='pa_proj_elements_utils.get_element_number(C_Res_Asgmt_Data_Rec.task_id)' || pa_proj_elements_utils.get_element_number(C_Res_Asgmt_Data_Rec.task_id);
5781: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5780: pa_debug.g_err_stage:='pa_proj_elements_utils.get_element_number(C_Res_Asgmt_Data_Rec.task_id)' || pa_proj_elements_utils.get_element_number(C_Res_Asgmt_Data_Rec.task_id);
5781: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5782: END IF;
5783:
5784: l_task_number_tbl(u_index) := pa_task_assignments_pvt.pfchar(pa_proj_elements_utils.get_element_number(C_Res_Asgmt_Data_Rec.task_id));
5785:
5786: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5787: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.Resource_Class_Code' || C_Res_Asgmt_Data_Rec.Resource_Class_Code;
5788: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5787: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.Resource_Class_Code' || C_Res_Asgmt_Data_Rec.Resource_Class_Code;
5788: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5789: END IF;
5790:
5791: l_resource_class_code_tbl(u_index) := pa_task_assignments_pvt.pfchar(C_Res_Asgmt_Data_Rec.Resource_Class_Code);
5792:
5793: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5794: pa_debug.g_err_stage:='C_Res_List_Mem_Check_Rec.Alias' || C_Res_List_Mem_Check_Rec.Alias;
5795: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5794: pa_debug.g_err_stage:='C_Res_List_Mem_Check_Rec.Alias' || C_Res_List_Mem_Check_Rec.Alias;
5795: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5796: END IF;
5797:
5798: l_resource_alias_tbl(u_index) := pa_task_assignments_pvt.pfchar(C_Res_List_Mem_Check_Rec.Alias);
5799:
5800: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5801: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.res_type_code' || C_Res_Asgmt_Data_Rec.res_type_code;
5802: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5801: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.res_type_code' || C_Res_Asgmt_Data_Rec.res_type_code;
5802: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5803: END IF;
5804:
5805: l_res_type_code_tbl(u_index) := pa_task_assignments_pvt.pfchar(C_Res_Asgmt_Data_Rec.Res_Type_Code);
5806:
5807: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5808: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.resource_assignment_id ' || C_Res_Asgmt_Data_Rec.resource_assignment_id;
5809: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5811: pa_debug.g_err_stage:='PA_PLANNING_RESOURCE_UTILS.Get_resource_Code(C_Res_Asgmt_Data_Rec.resource_assignment_id)' || PA_PLANNING_RESOURCE_UTILS.Get_resource_Code(C_Res_Asgmt_Data_Rec.resource_assignment_id);
5812: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5813: END IF;
5814:
5815: l_resource_code_tbl(u_index) := pa_task_assignments_pvt.pfchar(PA_PLANNING_RESOURCE_UTILS.Get_resource_Code(C_Res_Asgmt_Data_Rec.resource_assignment_id));
5816:
5817: l_resource_name(u_index) := pa_task_assignments_pvt.pfchar(PA_PLANNING_RESOURCE_UTILS.RET_RESOURCE_NAME (
5818: LP_RES_TYPE_CODE,
5819: LP_PERSON_ID,
5813: END IF;
5814:
5815: l_resource_code_tbl(u_index) := pa_task_assignments_pvt.pfchar(PA_PLANNING_RESOURCE_UTILS.Get_resource_Code(C_Res_Asgmt_Data_Rec.resource_assignment_id));
5816:
5817: l_resource_name(u_index) := pa_task_assignments_pvt.pfchar(PA_PLANNING_RESOURCE_UTILS.RET_RESOURCE_NAME (
5818: LP_RES_TYPE_CODE,
5819: LP_PERSON_ID,
5820: LP_BOM_RESOURCE_ID, LP_JOB_ID,
5821: LP_PERSON_TYPE_CODE,
5830: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.Project_Role_Id: ' || C_Res_Asgmt_Data_Rec.Project_Role_Id;
5831: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5832: END IF;
5833:
5834: l_project_role_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(C_Res_Asgmt_Data_Rec.Project_Role_Id);
5835:
5836: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5837: pa_debug.g_err_stage:='pa_planning_element_utils.get_project_role_name(C_Res_Asgmt_Data_Rec.Project_Role_Id): ' || pa_planning_element_utils.get_project_role_name(C_Res_Asgmt_Data_Rec.Project_Role_Id);
5838: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5837: pa_debug.g_err_stage:='pa_planning_element_utils.get_project_role_name(C_Res_Asgmt_Data_Rec.Project_Role_Id): ' || pa_planning_element_utils.get_project_role_name(C_Res_Asgmt_Data_Rec.Project_Role_Id);
5838: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5839: END IF;
5840:
5841: l_project_role_name_tbl(u_index) := pa_task_assignments_pvt.pfchar(pa_planning_element_utils.get_project_role_name(C_Res_Asgmt_Data_Rec.Project_Role_Id));
5842:
5843: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5844: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.Organization_Id: ' || C_Res_Asgmt_Data_Rec.Organization_Id;
5845: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5844: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.Organization_Id: ' || C_Res_Asgmt_Data_Rec.Organization_Id;
5845: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5846: END IF;
5847:
5848: l_organization_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(C_Res_Asgmt_Data_Rec.Organization_Id);
5849:
5850: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5851: pa_debug.g_err_stage:='pa_expenditures_utils.GetOrgTlName(C_Res_Asgmt_Data_Rec.Organization_Id):' || pa_expenditures_utils.GetOrgTlName(C_Res_Asgmt_Data_Rec.Organization_Id);
5852: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5851: pa_debug.g_err_stage:='pa_expenditures_utils.GetOrgTlName(C_Res_Asgmt_Data_Rec.Organization_Id):' || pa_expenditures_utils.GetOrgTlName(C_Res_Asgmt_Data_Rec.Organization_Id);
5852: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5853: END IF;
5854:
5855: l_organization_name_tbl(u_index) := pa_task_assignments_pvt.pfchar(pa_expenditures_utils.GetOrgTlName(C_Res_Asgmt_Data_Rec.Organization_Id));
5856:
5857:
5858: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5859: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.fc_res_type_Code:' || C_Res_Asgmt_Data_Rec.fc_res_type_Code;
5859: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.fc_res_type_Code:' || C_Res_Asgmt_Data_Rec.fc_res_type_Code;
5860: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5861: END IF;
5862:
5863: l_fc_res_type_code_tbl(u_index) := pa_task_assignments_pvt.pfchar(C_Res_Asgmt_Data_Rec.fc_res_type_Code);
5864:
5865:
5866: l_financial_category_name_tbl(u_index) := pa_task_assignments_pvt.pfchar(PA_PLANNING_RESOURCE_UTILS.RET_FIN_CATEGORY_NAME (IP_FC_RES_TYPE_CODE, IP_EXPENDITURE_TYPE, IP_EXPENDITURE_CATEGORY,
5867: IP_EVENT_TYPE, IP_REVENUE_CATEGORY_CODE, C_Res_Asgmt_Data_Rec.Resource_Assignment_Id ));
5862:
5863: l_fc_res_type_code_tbl(u_index) := pa_task_assignments_pvt.pfchar(C_Res_Asgmt_Data_Rec.fc_res_type_Code);
5864:
5865:
5866: l_financial_category_name_tbl(u_index) := pa_task_assignments_pvt.pfchar(PA_PLANNING_RESOURCE_UTILS.RET_FIN_CATEGORY_NAME (IP_FC_RES_TYPE_CODE, IP_EXPENDITURE_TYPE, IP_EXPENDITURE_CATEGORY,
5867: IP_EVENT_TYPE, IP_REVENUE_CATEGORY_CODE, C_Res_Asgmt_Data_Rec.Resource_Assignment_Id ));
5868:
5869: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5870: pa_debug.g_err_stage:='financial category name :' || l_financial_category_name_tbl(u_index);
5871: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5872: END IF;
5873:
5874: -- Bug 4246109: Should pass in supplier to update_planning_transaction
5875: l_supplier_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(C_Res_Asgmt_Data_Rec.supplier_id);
5876:
5877: -- Bug 4528392:
5878: IF l_supplier_id_tbl(u_index) IS NOT NULL and l_supplier_id_tbl(u_index) <> FND_API.G_MISS_NUM THEN
5879: l_supplier_name_tbl(u_index) := pa_task_assignments_pvt.pfchar(pa_planning_resource_utils.ret_supplier_name(l_supplier_id_tbl(u_index)));
5875: l_supplier_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(C_Res_Asgmt_Data_Rec.supplier_id);
5876:
5877: -- Bug 4528392:
5878: IF l_supplier_id_tbl(u_index) IS NOT NULL and l_supplier_id_tbl(u_index) <> FND_API.G_MISS_NUM THEN
5879: l_supplier_name_tbl(u_index) := pa_task_assignments_pvt.pfchar(pa_planning_resource_utils.ret_supplier_name(l_supplier_id_tbl(u_index)));
5880: ELSIF l_supplier_id_tbl(u_index) IS NULL THEN
5881: l_supplier_name_tbl(u_index) := NULL;
5882: ELSE
5883: l_supplier_name_tbl(u_index) := FND_API.G_MISS_CHAR;
5888: pa_debug.g_err_stage:='C_Res_Asgmt_Data_Rec.Named_Role: ' || C_Res_Asgmt_Data_Rec.Named_Role;
5889: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5890: END IF;
5891:
5892: l_named_role_tbl(u_index) := pa_task_assignments_pvt.pfchar(C_Res_Asgmt_Data_Rec.Named_Role);
5893:
5894: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5895: pa_debug.g_err_stage:='PA_PLANNING_RESOURCE_UTILS.GET_INCUR_BY_RES_CODE( C_Res_Asgmt_Data_Rec.resource_assignment_id) ' || PA_PLANNING_RESOURCE_UTILS.GET_INCUR_BY_RES_CODE( C_Res_Asgmt_Data_Rec.resource_assignment_id);
5896: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5895: pa_debug.g_err_stage:='PA_PLANNING_RESOURCE_UTILS.GET_INCUR_BY_RES_CODE( C_Res_Asgmt_Data_Rec.resource_assignment_id) ' || PA_PLANNING_RESOURCE_UTILS.GET_INCUR_BY_RES_CODE( C_Res_Asgmt_Data_Rec.resource_assignment_id);
5896: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5897: END IF;
5898:
5899: l_incur_by_resource_code_tbl(u_index) := pa_task_assignments_pvt.pfchar(PA_PLANNING_RESOURCE_UTILS.GET_INCUR_BY_RES_CODE( C_Res_Asgmt_Data_Rec.resource_assignment_id) );
5900:
5901:
5902: ELSE -- Add content.
5903:
6000: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
6001: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).cbs_element_id := p_task_assignments_in(i).cbs_element_id ;-- 16598322
6002:
6003:
6004: lc_task_elem_version_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(l_task_elem_version_id_tbl(i));
6005: lc_task_name_tbl(c_index) := NULL; --TBD
6006: lc_task_number_tbl(c_index) := NULL; --TBD
6007: lc_start_date_tbl(c_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
6008: lc_end_date_tbl(c_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
6003:
6004: lc_task_elem_version_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(l_task_elem_version_id_tbl(i));
6005: lc_task_name_tbl(c_index) := NULL; --TBD
6006: lc_task_number_tbl(c_index) := NULL; --TBD
6007: lc_start_date_tbl(c_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
6008: lc_end_date_tbl(c_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
6009: lc_latest_eff_pub_flag_tbl(c_index) := NULL ; --TBD
6010: lc_resource_list_member_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
6011: lc_cbs_element_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ;
6004: lc_task_elem_version_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(l_task_elem_version_id_tbl(i));
6005: lc_task_name_tbl(c_index) := NULL; --TBD
6006: lc_task_number_tbl(c_index) := NULL; --TBD
6007: lc_start_date_tbl(c_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
6008: lc_end_date_tbl(c_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
6009: lc_latest_eff_pub_flag_tbl(c_index) := NULL ; --TBD
6010: lc_resource_list_member_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
6011: lc_cbs_element_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ;
6012: lc_project_assignment_id_tbl(c_index) := -1 ;
6006: lc_task_number_tbl(c_index) := NULL; --TBD
6007: lc_start_date_tbl(c_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
6008: lc_end_date_tbl(c_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
6009: lc_latest_eff_pub_flag_tbl(c_index) := NULL ; --TBD
6010: lc_resource_list_member_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
6011: lc_cbs_element_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ;
6012: lc_project_assignment_id_tbl(c_index) := -1 ;
6013: lc_currency_code_tbl(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).currency_code) ;
6014:
6007: lc_start_date_tbl(c_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;
6008: lc_end_date_tbl(c_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).end_date) ;
6009: lc_latest_eff_pub_flag_tbl(c_index) := NULL ; --TBD
6010: lc_resource_list_member_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
6011: lc_cbs_element_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ;
6012: lc_project_assignment_id_tbl(c_index) := -1 ;
6013: lc_currency_code_tbl(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).currency_code) ;
6014:
6015: OPEN C_Workplan_Costs_enabled(l_budget_version_id);
6009: lc_latest_eff_pub_flag_tbl(c_index) := NULL ; --TBD
6010: lc_resource_list_member_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
6011: lc_cbs_element_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).cbs_element_id) ;
6012: lc_project_assignment_id_tbl(c_index) := -1 ;
6013: lc_currency_code_tbl(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).currency_code) ;
6014:
6015: OPEN C_Workplan_Costs_enabled(l_budget_version_id);
6016: FETCH C_Workplan_Costs_enabled INTO C_Workplan_Costs_rec;
6017: CLOSE C_Workplan_Costs_enabled;
6023: lc_burdened_cost_tbl(c_index) := NULL ;
6024:
6025: ELSE
6026: IF C_Workplan_Costs_rec.enabled_flag = 'Y' THEN
6027: lc_raw_cost_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_raw_cost) ;
6028: lc_burdened_cost_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_bur_cost) ;
6029: /* Bug Fix 5505113
6030: */
6031: IF lc_raw_cost_tbl(c_index) = FND_API.G_MISS_NUM THEN
6024:
6025: ELSE
6026: IF C_Workplan_Costs_rec.enabled_flag = 'Y' THEN
6027: lc_raw_cost_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_raw_cost) ;
6028: lc_burdened_cost_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_bur_cost) ;
6029: /* Bug Fix 5505113
6030: */
6031: IF lc_raw_cost_tbl(c_index) = FND_API.G_MISS_NUM THEN
6032: lc_raw_cost_tbl(c_index) := NULL;
6037: END IF;
6038:
6039: END IF;
6040:
6041: lc_quantity_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_quantity);
6042: /* Bug Fix 5505113
6043: */
6044: IF lc_quantity_tbl(c_index) = FND_API.G_MISS_NUM THEN
6045: lc_quantity_tbl(c_index) := NULL;
6049:
6050: -- Made the pm_task_asgmt_reference to refer to l_task_assignments_in plsql table.
6051: -- For Bug 8842724
6052:
6053: lc_product_code_tbl(c_index) := pa_task_assignments_pvt.pfchar(p_pm_product_code) ;
6054: lc_product_reference_tbl(c_index) := pa_task_assignments_pvt.pfchar(l_task_assignments_in(i).pm_task_asgmt_reference) ;
6055: lc_attribute1(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
6056: lc_attribute2(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
6057: lc_attribute3(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
6050: -- Made the pm_task_asgmt_reference to refer to l_task_assignments_in plsql table.
6051: -- For Bug 8842724
6052:
6053: lc_product_code_tbl(c_index) := pa_task_assignments_pvt.pfchar(p_pm_product_code) ;
6054: lc_product_reference_tbl(c_index) := pa_task_assignments_pvt.pfchar(l_task_assignments_in(i).pm_task_asgmt_reference) ;
6055: lc_attribute1(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
6056: lc_attribute2(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
6057: lc_attribute3(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
6058: lc_attribute4(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
6051: -- For Bug 8842724
6052:
6053: lc_product_code_tbl(c_index) := pa_task_assignments_pvt.pfchar(p_pm_product_code) ;
6054: lc_product_reference_tbl(c_index) := pa_task_assignments_pvt.pfchar(l_task_assignments_in(i).pm_task_asgmt_reference) ;
6055: lc_attribute1(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
6056: lc_attribute2(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
6057: lc_attribute3(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
6058: lc_attribute4(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
6059: lc_attribute5(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
6052:
6053: lc_product_code_tbl(c_index) := pa_task_assignments_pvt.pfchar(p_pm_product_code) ;
6054: lc_product_reference_tbl(c_index) := pa_task_assignments_pvt.pfchar(l_task_assignments_in(i).pm_task_asgmt_reference) ;
6055: lc_attribute1(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
6056: lc_attribute2(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
6057: lc_attribute3(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
6058: lc_attribute4(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
6059: lc_attribute5(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
6060: lc_attribute6(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
6053: lc_product_code_tbl(c_index) := pa_task_assignments_pvt.pfchar(p_pm_product_code) ;
6054: lc_product_reference_tbl(c_index) := pa_task_assignments_pvt.pfchar(l_task_assignments_in(i).pm_task_asgmt_reference) ;
6055: lc_attribute1(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
6056: lc_attribute2(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
6057: lc_attribute3(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
6058: lc_attribute4(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
6059: lc_attribute5(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
6060: lc_attribute6(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
6061: lc_attribute7(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
6054: lc_product_reference_tbl(c_index) := pa_task_assignments_pvt.pfchar(l_task_assignments_in(i).pm_task_asgmt_reference) ;
6055: lc_attribute1(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
6056: lc_attribute2(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
6057: lc_attribute3(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
6058: lc_attribute4(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
6059: lc_attribute5(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
6060: lc_attribute6(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
6061: lc_attribute7(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
6062: lc_attribute8(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
6055: lc_attribute1(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute1) ;
6056: lc_attribute2(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
6057: lc_attribute3(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
6058: lc_attribute4(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
6059: lc_attribute5(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
6060: lc_attribute6(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
6061: lc_attribute7(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
6062: lc_attribute8(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
6063: lc_attribute9(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
6056: lc_attribute2(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute2) ;
6057: lc_attribute3(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
6058: lc_attribute4(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
6059: lc_attribute5(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
6060: lc_attribute6(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
6061: lc_attribute7(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
6062: lc_attribute8(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
6063: lc_attribute9(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
6064: lc_attribute10(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
6057: lc_attribute3(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute3) ;
6058: lc_attribute4(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
6059: lc_attribute5(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
6060: lc_attribute6(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
6061: lc_attribute7(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
6062: lc_attribute8(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
6063: lc_attribute9(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
6064: lc_attribute10(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
6065: lc_attribute11(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
6058: lc_attribute4(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute4) ;
6059: lc_attribute5(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
6060: lc_attribute6(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
6061: lc_attribute7(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
6062: lc_attribute8(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
6063: lc_attribute9(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
6064: lc_attribute10(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
6065: lc_attribute11(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
6066: lc_attribute12(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
6059: lc_attribute5(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute5) ;
6060: lc_attribute6(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
6061: lc_attribute7(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
6062: lc_attribute8(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
6063: lc_attribute9(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
6064: lc_attribute10(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
6065: lc_attribute11(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
6066: lc_attribute12(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
6067: lc_attribute13(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
6060: lc_attribute6(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute6) ;
6061: lc_attribute7(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
6062: lc_attribute8(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
6063: lc_attribute9(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
6064: lc_attribute10(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
6065: lc_attribute11(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
6066: lc_attribute12(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
6067: lc_attribute13(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
6068: lc_attribute14(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
6061: lc_attribute7(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute7) ;
6062: lc_attribute8(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
6063: lc_attribute9(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
6064: lc_attribute10(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
6065: lc_attribute11(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
6066: lc_attribute12(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
6067: lc_attribute13(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
6068: lc_attribute14(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
6069: lc_attribute15(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
6062: lc_attribute8(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute8) ;
6063: lc_attribute9(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
6064: lc_attribute10(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
6065: lc_attribute11(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
6066: lc_attribute12(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
6067: lc_attribute13(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
6068: lc_attribute14(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
6069: lc_attribute15(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
6070: lc_attribute16(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
6063: lc_attribute9(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute9) ;
6064: lc_attribute10(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
6065: lc_attribute11(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
6066: lc_attribute12(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
6067: lc_attribute13(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
6068: lc_attribute14(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
6069: lc_attribute15(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
6070: lc_attribute16(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
6071: lc_attribute17(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
6064: lc_attribute10(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute10) ;
6065: lc_attribute11(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
6066: lc_attribute12(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
6067: lc_attribute13(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
6068: lc_attribute14(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
6069: lc_attribute15(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
6070: lc_attribute16(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
6071: lc_attribute17(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
6072: lc_attribute18(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
6065: lc_attribute11(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute11) ;
6066: lc_attribute12(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
6067: lc_attribute13(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
6068: lc_attribute14(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
6069: lc_attribute15(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
6070: lc_attribute16(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
6071: lc_attribute17(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
6072: lc_attribute18(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
6073: lc_attribute19(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
6066: lc_attribute12(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute12) ;
6067: lc_attribute13(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
6068: lc_attribute14(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
6069: lc_attribute15(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
6070: lc_attribute16(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
6071: lc_attribute17(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
6072: lc_attribute18(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
6073: lc_attribute19(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
6074: lc_attribute20(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
6067: lc_attribute13(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute13) ;
6068: lc_attribute14(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
6069: lc_attribute15(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
6070: lc_attribute16(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
6071: lc_attribute17(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
6072: lc_attribute18(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
6073: lc_attribute19(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
6074: lc_attribute20(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
6075: lc_attribute21(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
6068: lc_attribute14(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute14) ;
6069: lc_attribute15(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
6070: lc_attribute16(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
6071: lc_attribute17(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
6072: lc_attribute18(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
6073: lc_attribute19(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
6074: lc_attribute20(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
6075: lc_attribute21(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
6076: lc_attribute22(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
6069: lc_attribute15(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute15) ;
6070: lc_attribute16(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
6071: lc_attribute17(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
6072: lc_attribute18(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
6073: lc_attribute19(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
6074: lc_attribute20(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
6075: lc_attribute21(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
6076: lc_attribute22(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
6077: lc_attribute23(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
6070: lc_attribute16(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute16) ;
6071: lc_attribute17(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
6072: lc_attribute18(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
6073: lc_attribute19(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
6074: lc_attribute20(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
6075: lc_attribute21(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
6076: lc_attribute22(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
6077: lc_attribute23(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
6078: lc_attribute24(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
6071: lc_attribute17(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute17) ;
6072: lc_attribute18(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
6073: lc_attribute19(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
6074: lc_attribute20(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
6075: lc_attribute21(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
6076: lc_attribute22(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
6077: lc_attribute23(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
6078: lc_attribute24(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
6079: lc_attribute25(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
6072: lc_attribute18(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute18) ;
6073: lc_attribute19(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
6074: lc_attribute20(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
6075: lc_attribute21(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
6076: lc_attribute22(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
6077: lc_attribute23(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
6078: lc_attribute24(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
6079: lc_attribute25(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
6080: lc_attribute26(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
6073: lc_attribute19(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute19) ;
6074: lc_attribute20(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
6075: lc_attribute21(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
6076: lc_attribute22(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
6077: lc_attribute23(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
6078: lc_attribute24(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
6079: lc_attribute25(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
6080: lc_attribute26(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
6081: lc_attribute27(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
6074: lc_attribute20(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute20) ;
6075: lc_attribute21(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
6076: lc_attribute22(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
6077: lc_attribute23(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
6078: lc_attribute24(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
6079: lc_attribute25(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
6080: lc_attribute26(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
6081: lc_attribute27(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
6082: lc_attribute28(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
6075: lc_attribute21(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute21) ;
6076: lc_attribute22(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
6077: lc_attribute23(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
6078: lc_attribute24(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
6079: lc_attribute25(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
6080: lc_attribute26(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
6081: lc_attribute27(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
6082: lc_attribute28(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
6083: lc_attribute29(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
6076: lc_attribute22(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute22) ;
6077: lc_attribute23(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
6078: lc_attribute24(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
6079: lc_attribute25(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
6080: lc_attribute26(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
6081: lc_attribute27(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
6082: lc_attribute28(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
6083: lc_attribute29(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
6084: lc_attribute30(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
6077: lc_attribute23(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute23) ;
6078: lc_attribute24(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
6079: lc_attribute25(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
6080: lc_attribute26(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
6081: lc_attribute27(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
6082: lc_attribute28(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
6083: lc_attribute29(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
6084: lc_attribute30(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
6085: lc_scheduled_delay_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay) ; --Bug 3948128
6078: lc_attribute24(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute24) ;
6079: lc_attribute25(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
6080: lc_attribute26(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
6081: lc_attribute27(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
6082: lc_attribute28(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
6083: lc_attribute29(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
6084: lc_attribute30(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
6085: lc_scheduled_delay_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay) ; --Bug 3948128
6086:
6079: lc_attribute25(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute25) ;
6080: lc_attribute26(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
6081: lc_attribute27(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
6082: lc_attribute28(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
6083: lc_attribute29(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
6084: lc_attribute30(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
6085: lc_scheduled_delay_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay) ; --Bug 3948128
6086:
6087: END IF;
6080: lc_attribute26(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute26) ;
6081: lc_attribute27(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
6082: lc_attribute28(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
6083: lc_attribute29(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
6084: lc_attribute30(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
6085: lc_scheduled_delay_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay) ; --Bug 3948128
6086:
6087: END IF;
6088:
6081: lc_attribute27(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute27) ;
6082: lc_attribute28(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute28) ;
6083: lc_attribute29(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute29) ;
6084: lc_attribute30(c_index) := pa_task_assignments_pvt.pfchar(p_task_assignments_in(i).attribute30) ;
6085: lc_scheduled_delay_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).scheduled_delay) ; --Bug 3948128
6086:
6087: END IF;
6088:
6089: END LOOP;