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_PUB dependencies on PA_TASK_ASSIGNMENTS_PUB

Line 1: PACKAGE BODY PA_TASK_ASSIGNMENTS_PUB AS

1: PACKAGE BODY PA_TASK_ASSIGNMENTS_PUB AS
2: -- $Header: PATAPUBB.pls 120.8 2007/02/06 10:01:16 dthakker ship $
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_TASK_ASSIGNMENTS_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_TASK_ASSIGNMENTS_PUB';

1: PACKAGE BODY PA_TASK_ASSIGNMENTS_PUB AS
2: -- $Header: PATAPUBB.pls 120.8 2007/02/06 10:01:16 dthakker ship $
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_TASK_ASSIGNMENTS_PUB';
6: g_periodic_mode varchar2(1) := null;
7: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
8: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9:

Line 2254: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(k_index).pa_task_id := l_d_task_id;

2250:
2251: p_task_assignments_out(k_index).pa_task_id := l_d_task_id;
2252: p_task_assignments_out(k_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
2253:
2254: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(k_index).pa_task_id := l_d_task_id;
2255: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(k_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
2256:
2257: lk_resource_list_member_id_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
2258:

Line 2255: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(k_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;

2251: p_task_assignments_out(k_index).pa_task_id := l_d_task_id;
2252: p_task_assignments_out(k_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
2253:
2254: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(k_index).pa_task_id := l_d_task_id;
2255: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(k_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
2256:
2257: lk_resource_list_member_id_tbl(k_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).resource_list_member_id) ;
2258:
2259: l_start_date_tbl(k_index) := pa_task_assignments_pvt.pfdate(p_task_assignments_in(i).start_date) ;

Line 2463: In both pa_task_assignments_pub create_task_assignments and

2459:
2460: --Added for Bug 3940284
2461:
2462: /* Updates from the bug
2463: In both pa_task_assignments_pub create_task_assignments and
2464: update_task_assignments AMG APIs, we are deleting the ta_display_flag='N'
2465: assignment records whenever the first resource is assigned to the task
2466: version. There are a few problems that need to be fixed:
2467:

Line 2712: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'S';

2708: pa_debug.g_err_stage:='Success on index:' || i;
2709: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
2710: END IF;
2711: p_task_assignments_out(i).return_status := 'S';
2712: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'S';
2713:
2714: ELSE
2715: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2716: pa_debug.g_err_stage:='Errored on index:' || i;

Line 2720: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'E';

2716: pa_debug.g_err_stage:='Errored on index:' || i;
2717: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
2718: END IF;
2719: p_task_assignments_out(i).return_status := 'E';
2720: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'E';
2721: END IF;
2722:
2723: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2724: pa_debug.g_err_stage:='Out resource_assignment_id:' || c_rec_out.resource_assignment_id || 'Out resource alias:' || c_rec_out.alias;

Line 2730: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;

2726: END IF;
2727: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
2728: p_task_assignments_out(i).resource_alias := c_rec_out.alias;
2729:
2730: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
2731: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out.alias;
2732:
2733:
2734: close c_cur_out;

Line 2731: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out.alias;

2727: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
2728: p_task_assignments_out(i).resource_alias := c_rec_out.alias;
2729:
2730: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
2731: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out.alias;
2732:
2733:
2734: close c_cur_out;
2735:

Line 2828: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE

2824: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2825: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2826: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2827: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
2828: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
2829: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
2830: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
2831: ,x_msg_count OUT NOCOPY NUMBER
2832: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2830: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE

2826: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2827: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
2828: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
2829: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
2830: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
2831: ,x_msg_count OUT NOCOPY NUMBER
2832: ,x_msg_data OUT NOCOPY VARCHAR2
2833: ,x_return_status OUT NOCOPY VARCHAR2
2834: ) IS

Line 2844: l_task_assignment_periods_out PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE;

2840: l_msg_data VARCHAR2(2000);
2841: l_msg_code VARCHAR2(30);
2842: l_msg_count NUMBER;
2843: l_project_id NUMBER;
2844: l_task_assignment_periods_out PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE;
2845: L_FuncProc varchar2(2000);
2846:
2847: -- Added for bug 5469303
2848: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER) is

Line 3102: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE

3098: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3099: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3100: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3101: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3102: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3103: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3104: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
3105: ,x_msg_count OUT NOCOPY NUMBER
3106: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3104: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE

3100: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3101: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3102: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3103: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3104: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
3105: ,x_msg_count OUT NOCOPY NUMBER
3106: ,x_msg_data OUT NOCOPY VARCHAR2
3107: ,x_return_status OUT NOCOPY VARCHAR2
3108: ) IS

Line 3118: l_task_assignment_periods_out PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE;

3114: l_msg_data VARCHAR2(2000);
3115: l_msg_count NUMBER;
3116: l_msg_code VARCHAR2(30);
3117: l_project_id NUMBER;
3118: l_task_assignment_periods_out PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE;
3119: L_FuncProc varchar2(2000);
3120:
3121: -- Added for bug 5469303
3122: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER) is

Line 4968: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;

4964: pa_debug.g_err_stage:='Setting global out variables for task and resource list member id';
4965: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4966: END IF;
4967:
4968: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;
4969: 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 ;
4970:
4971: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4972: pa_debug.g_err_stage:='Setting other main variables';

Line 4969: 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 ;

4965: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4966: END IF;
4967:
4968: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;
4969: 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 ;
4970:
4971: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4972: pa_debug.g_err_stage:='Setting other main variables';
4973: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 5356: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;

5352:
5353: p_task_assignments_out(c_index + u_index).pa_task_id := l_d_task_id;
5354: p_task_assignments_out(c_index + u_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
5355:
5356: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;
5357: 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 ;
5358:
5359:
5360: lc_task_elem_version_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(l_task_elem_version_id_tbl(i));

Line 5357: 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 ;

5353: p_task_assignments_out(c_index + u_index).pa_task_id := l_d_task_id;
5354: p_task_assignments_out(c_index + u_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
5355:
5356: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;
5357: 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 ;
5358:
5359:
5360: lc_task_elem_version_id_tbl(c_index) := pa_task_assignments_pvt.pfnum(l_task_elem_version_id_tbl(i));
5361: lc_task_name_tbl(c_index) := NULL; --TBD

Line 5451: In both pa_task_assignments_pub create_task_assignments and

5447:
5448: --Added for Bug 3940284
5449:
5450: /* Updates from the bug
5451: In both pa_task_assignments_pub create_task_assignments and
5452: update_task_assignments AMG APIs, we are deleting the ta_display_flag='N'
5453: assignment records whenever the first resource is assigned to the task
5454: version. There are a few problems that need to be fixed:
5455:

Line 5948: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'S';

5944: pa_debug.g_err_stage:='Success on index:' || i;
5945: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5946: END IF;
5947: p_task_assignments_out(i).return_status := 'S';
5948: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'S';
5949:
5950: ELSE
5951: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5952: pa_debug.g_err_stage:='Errored on index:' || i;

Line 5956: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'E';

5952: pa_debug.g_err_stage:='Errored on index:' || i;
5953: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5954: END IF;
5955: p_task_assignments_out(i).return_status := 'E';
5956: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'E';
5957: END IF;
5958:
5959: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5960: pa_debug.g_err_stage:='Out resource_assignment_id:' || c_rec_out.resource_assignment_id;

Line 5969: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;

5965:
5966: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
5967: p_task_assignments_out(i).resource_alias := c_rec_out.alias;
5968:
5969: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
5970: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out.alias;
5971:
5972:
5973: close c_cur_out;

Line 5970: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out.alias;

5966: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
5967: p_task_assignments_out(i).resource_alias := c_rec_out.alias;
5968:
5969: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
5970: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out.alias;
5971:
5972:
5973: close c_cur_out;
5974:

Line 6751: end PA_TASK_ASSIGNMENTS_PUB;

6747: END IF;
6748:
6749: END Convert_pm_taref_to_id;
6750:
6751: end PA_TASK_ASSIGNMENTS_PUB;