eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_TASK_ASSIGNMENTS_PVT

Line 1: PACKAGE BODY PA_TASK_ASSIGNMENTS_PVT AS

1: PACKAGE BODY PA_TASK_ASSIGNMENTS_PVT AS
2: -- $Header: PATAPVTB.pls 120.7.12010000.3 2008/09/10 18:22:11 skkoppul ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_TASK_ASSIGNMENTS_PVT';
5: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_TASK_ASSIGNMENTS_PVT';

1: PACKAGE BODY PA_TASK_ASSIGNMENTS_PVT AS
2: -- $Header: PATAPVTB.pls 120.7.12010000.3 2008/09/10 18:22:11 skkoppul ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_TASK_ASSIGNMENTS_PVT';
5: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
6: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7:
8:

Line 915: l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id := pa_task_assignments_pvt.pfnum(l_resource_assignment_id_tbl(i));

911: END IF;
912: END IF;
913:
914: -- 10/22/04: To handle only lines after the progress as of date
915: l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id := pa_task_assignments_pvt.pfnum(l_resource_assignment_id_tbl(i));
916:
917: OPEN C_Get_res_info(l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id);
918: FETCH C_Get_res_info INTO C_Get_res_info_rec;
919: CLOSE C_Get_res_info;

Line 934: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 := pa_task_assignments_pvt.pfnum(l_d_task_id);

930: FETCH C_Workplan_Costs_enabled into C_Workplan_Costs_rec;
931: CLOSE C_Workplan_Costs_enabled;
932:
933: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id);
934: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 := pa_task_assignments_pvt.pfnum(l_d_task_id);
935: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1);
936: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 := NVL(pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).resource_list_member_id), C_Get_res_info_rec.resource_list_member_id);
937: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2);
938: l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date := pa_task_assignments_pvt.pfdate(l_period_start_date) ;

Line 936: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 := NVL(pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).resource_list_member_id), C_Get_res_info_rec.resource_list_member_id);

932:
933: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id);
934: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 := pa_task_assignments_pvt.pfnum(l_d_task_id);
935: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1);
936: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 := NVL(pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).resource_list_member_id), C_Get_res_info_rec.resource_list_member_id);
937: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2);
938: l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date := pa_task_assignments_pvt.pfdate(l_period_start_date) ;
939: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date);
940: l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date := pa_task_assignments_pvt.pfdate(l_period_end_date) ;

Line 938: l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date := pa_task_assignments_pvt.pfdate(l_period_start_date) ;

934: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 := pa_task_assignments_pvt.pfnum(l_d_task_id);
935: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1);
936: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 := NVL(pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).resource_list_member_id), C_Get_res_info_rec.resource_list_member_id);
937: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2);
938: l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date := pa_task_assignments_pvt.pfdate(l_period_start_date) ;
939: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date);
940: l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date := pa_task_assignments_pvt.pfdate(l_period_end_date) ;
941: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date);
942: l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).quantity) ;

Line 940: l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date := pa_task_assignments_pvt.pfdate(l_period_end_date) ;

936: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 := NVL(pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).resource_list_member_id), C_Get_res_info_rec.resource_list_member_id);
937: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2);
938: l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date := pa_task_assignments_pvt.pfdate(l_period_start_date) ;
939: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date);
940: l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date := pa_task_assignments_pvt.pfdate(l_period_end_date) ;
941: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date);
942: l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).quantity) ;
943: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity);
944: l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name := pa_task_assignments_pvt.pfchar(l_period_name) ;

Line 942: l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).quantity) ;

938: l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date := pa_task_assignments_pvt.pfdate(l_period_start_date) ;
939: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date);
940: l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date := pa_task_assignments_pvt.pfdate(l_period_end_date) ;
941: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date);
942: l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).quantity) ;
943: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity);
944: l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name := pa_task_assignments_pvt.pfchar(l_period_name) ;
945: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name);
946:

Line 944: l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name := pa_task_assignments_pvt.pfchar(l_period_name) ;

940: l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date := pa_task_assignments_pvt.pfdate(l_period_end_date) ;
941: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date);
942: l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).quantity) ;
943: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity);
944: l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name := pa_task_assignments_pvt.pfchar(l_period_name) ;
945: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name);
946:
947: IF l_prog_resource_assignment_id = l_resource_assignment_id_tbl(i) THEN
948: --new message case bug 3855080

Line 949: IF pa_task_assignments_pvt.pfchar(p_task_assignment_periods_in(i).txn_currency_code) <> l_txn_currency_code THEN

945: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name);
946:
947: IF l_prog_resource_assignment_id = l_resource_assignment_id_tbl(i) THEN
948: --new message case bug 3855080
949: IF pa_task_assignments_pvt.pfchar(p_task_assignment_periods_in(i).txn_currency_code) <> l_txn_currency_code THEN
950: PA_UTILS.ADD_MESSAGE
951: (p_app_short_name => 'PA',
952: p_msg_name => 'PA_TA_SAME_CURR_PROG_ERR',
953: p_token1 => 'RESOURCE_REF',

Line 967: NVL(NVL(pa_task_assignments_pvt.pfchar(p_task_assignment_periods_in(i).txn_currency_code),

963: IF C_Get_res_info_rec.rate_based_flag = 'Y' AND C_Workplan_Costs_rec.enabled_flag = 'N' THEN
964: l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code := NVL(l_txn_currency_code, l_project_currency_code) ;
965: ELSE
966: l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code :=
967: NVL(NVL(pa_task_assignments_pvt.pfchar(p_task_assignment_periods_in(i).txn_currency_code),
968: l_txn_currency_code), l_project_currency_code) ;
969: END IF;
970: ELSIF l_prog_resource_assignment_id <> l_resource_assignment_id_tbl(i) AND
971: l_old_resource_assignment_id = l_resource_assignment_id_tbl(i) THEN

Line 973: IF pa_task_assignments_pvt.pfchar(p_task_assignment_periods_in(i).txn_currency_code) <> l_old_txn_currency THEN

969: END IF;
970: ELSIF l_prog_resource_assignment_id <> l_resource_assignment_id_tbl(i) AND
971: l_old_resource_assignment_id = l_resource_assignment_id_tbl(i) THEN
972: --new message case bug 3855080
973: IF pa_task_assignments_pvt.pfchar(p_task_assignment_periods_in(i).txn_currency_code) <> l_old_txn_currency THEN
974: PA_UTILS.ADD_MESSAGE
975: (p_app_short_name => 'PA',
976: p_msg_name => 'PA_TA_SAME_CURR_ERR',
977: p_token1 => 'RESOURCE_REF',

Line 990: l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).txn_raw_cost) ;

986:
987:
988:
989: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code);
990: l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).txn_raw_cost) ;
991: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost);
992: l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).txn_burdened_cost) ;
993: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost);
994:

Line 992: l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).txn_burdened_cost) ;

988:
989: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code);
990: l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).txn_raw_cost) ;
991: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost);
992: l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).txn_burdened_cost) ;
993: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost);
994:
995: l_old_txn_currency := l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code;
996:

Line 1825: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Derive_Task_Assignments'

1821: pa_task_assignment_utils.g_ta_display_flag := 'N';
1822: PA_TASK_ASSIGNMENT_UTILS.g_apply_progress_flag := 'N'; -- Bug 4286558
1823:
1824: -- Set the excetption Message and the stack
1825: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Derive_Task_Assignments'
1826: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1827: --
1828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1829:

Line 2009: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Copy_Missing_Unplanned_Asgmts',

2005:
2006: EXCEPTION
2007: WHEN OTHERS THEN
2008: -- Set the exception message and the stack
2009: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Copy_Missing_Unplanned_Asgmts',
2010: p_procedure_name => PA_DEBUG.G_Err_Stack );
2011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2012: RAISE; -- This is optional depending on the needs
2013:

Line 2133: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Check_Period_Details',

2129: x_return_status := FND_API.G_RET_STS_ERROR;
2130:
2131: WHEN OTHERS THEN
2132: -- Set the exception message and the stack
2133: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Check_Period_Details',
2134: p_procedure_name => PA_DEBUG.G_Err_Stack );
2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2136:
2137: P_PERIOD_NAME := NULL ; -- 4537865

Line 2146: END PA_TASK_ASSIGNMENTS_PVT;

2142:
2143: END Check_Period_Details;
2144:
2145:
2146: END PA_TASK_ASSIGNMENTS_PVT;