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.13.12020000.5 2013/04/30 18:51:44 sachandr 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.13.12020000.5 2013/04/30 18:51:44 sachandr 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 1078: l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id := pa_task_assignments_pvt.pfnum(l_resource_assignment_id_tbl(i));

1074: END IF;
1075:
1076:
1077: -- 10/22/04: To handle only lines after the progress as of date
1078: l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id := pa_task_assignments_pvt.pfnum(l_resource_assignment_id_tbl(i));
1079:
1080: OPEN C_Get_res_info(l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id);
1081: FETCH C_Get_res_info INTO C_Get_res_info_rec;
1082: CLOSE C_Get_res_info;

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

1093: FETCH C_Workplan_Costs_enabled into C_Workplan_Costs_rec;
1094: CLOSE C_Workplan_Costs_enabled;
1095:
1096: --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);
1097: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 := pa_task_assignments_pvt.pfnum(l_d_task_id);
1098: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1);
1099: 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);
1100: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2);
1101:

Line 1099: 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);

1095:
1096: --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);
1097: l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 := pa_task_assignments_pvt.pfnum(l_d_task_id);
1098: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1);
1099: 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);
1100: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2);
1101:
1102: -- aDDED FOR cbs ::pUBLIC_a
1103:

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

1100: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2);
1101:
1102: -- aDDED FOR cbs ::pUBLIC_a
1103:
1104: l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date := pa_task_assignments_pvt.pfdate(l_period_start_date) ;
1105: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date);
1106: l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date := pa_task_assignments_pvt.pfdate(l_period_end_date) ;
1107: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date);
1108: l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).quantity) ;

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

1102: -- aDDED FOR cbs ::pUBLIC_a
1103:
1104: l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date := pa_task_assignments_pvt.pfdate(l_period_start_date) ;
1105: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date);
1106: l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date := pa_task_assignments_pvt.pfdate(l_period_end_date) ;
1107: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date);
1108: l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).quantity) ;
1109: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity);
1110: l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name := pa_task_assignments_pvt.pfchar(l_period_name) ;

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

1104: l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date := pa_task_assignments_pvt.pfdate(l_period_start_date) ;
1105: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date);
1106: l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date := pa_task_assignments_pvt.pfdate(l_period_end_date) ;
1107: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date);
1108: l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).quantity) ;
1109: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity);
1110: l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name := pa_task_assignments_pvt.pfchar(l_period_name) ;
1111: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name);
1112:

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

1106: l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date := pa_task_assignments_pvt.pfdate(l_period_end_date) ;
1107: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date);
1108: l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity := pa_task_assignments_pvt.pfnum(p_task_assignment_periods_in(i).quantity) ;
1109: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).quantity);
1110: l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name := pa_task_assignments_pvt.pfchar(l_period_name) ;
1111: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name);
1112:
1113: IF l_prog_resource_assignment_id = l_resource_assignment_id_tbl(i) THEN
1114: --new message case bug 3855080

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

1111: --dbms_output.put_line('l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name:' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name);
1112:
1113: IF l_prog_resource_assignment_id = l_resource_assignment_id_tbl(i) THEN
1114: --new message case bug 3855080
1115: IF pa_task_assignments_pvt.pfchar(p_task_assignment_periods_in(i).txn_currency_code) <> l_txn_currency_code THEN
1116: PA_UTILS.ADD_MESSAGE
1117: (p_app_short_name => 'PA',
1118: p_msg_name => 'PA_TA_SAME_CURR_PROG_ERR',
1119: p_token1 => 'RESOURCE_REF',

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

1129: IF C_Get_res_info_rec.rate_based_flag = 'Y' AND C_Workplan_Costs_rec.enabled_flag = 'N' THEN
1130: l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code := NVL(l_txn_currency_code, l_project_currency_code) ;
1131: ELSE
1132: l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code :=
1133: NVL(NVL(pa_task_assignments_pvt.pfchar(p_task_assignment_periods_in(i).txn_currency_code),
1134: l_txn_currency_code), l_project_currency_code) ;
1135: END IF;
1136: ELSIF l_prog_resource_assignment_id <> l_resource_assignment_id_tbl(i) AND
1137: l_old_resource_assignment_id = l_resource_assignment_id_tbl(i) THEN

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

1135: END IF;
1136: ELSIF l_prog_resource_assignment_id <> l_resource_assignment_id_tbl(i) AND
1137: l_old_resource_assignment_id = l_resource_assignment_id_tbl(i) THEN
1138: --new message case bug 3855080
1139: IF pa_task_assignments_pvt.pfchar(p_task_assignment_periods_in(i).txn_currency_code) <> l_old_txn_currency THEN
1140: PA_UTILS.ADD_MESSAGE
1141: (p_app_short_name => 'PA',
1142: p_msg_name => 'PA_TA_SAME_CURR_ERR',
1143: p_token1 => 'RESOURCE_REF',

Line 1156: 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) ;

1152:
1153:
1154:
1155: --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);
1156: 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) ;
1157: --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);
1158: 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) ;
1159: --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);
1160:

Line 1158: 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) ;

1154:
1155: --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);
1156: 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) ;
1157: --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);
1158: 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) ;
1159: --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);
1160:
1161: l_old_txn_currency := l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code;
1162:

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

2056: pa_task_assignment_utils.g_ta_display_flag := 'N';
2057: PA_TASK_ASSIGNMENT_UTILS.g_apply_progress_flag := 'N'; -- Bug 4286558
2058:
2059: -- Set the excetption Message and the stack
2060: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Derive_Task_Assignments'
2061: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2062: --
2063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2064:

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

2245:
2246: EXCEPTION
2247: WHEN OTHERS THEN
2248: -- Set the exception message and the stack
2249: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Copy_Missing_Unplanned_Asgmts',
2250: p_procedure_name => PA_DEBUG.G_Err_Stack );
2251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2252: RAISE; -- This is optional depending on the needs
2253:

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

2369: x_return_status := FND_API.G_RET_STS_ERROR;
2370:
2371: WHEN OTHERS THEN
2372: -- Set the exception message and the stack
2373: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Check_Period_Details',
2374: p_procedure_name => PA_DEBUG.G_Err_Stack );
2375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2376:
2377: P_PERIOD_NAME := NULL ; -- 4537865

Line 2386: END PA_TASK_ASSIGNMENTS_PVT;

2382:
2383: END Check_Period_Details;
2384:
2385:
2386: END PA_TASK_ASSIGNMENTS_PVT;