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.17.12020000.3 2013/06/11 14:53:52 rmuthine 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.17.12020000.3 2013/06/11 14:53:52 rmuthine 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 2410: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(k_index).pa_task_id := l_d_task_id;

2406: p_task_assignments_out(k_index).pa_task_id := l_d_task_id;
2407: p_task_assignments_out(k_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
2408: p_task_assignments_out(k_index).cbs_element_id := p_task_assignments_in(i).cbs_element_id ;-- Added for CBS 16598322
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:

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

2407: p_task_assignments_out(k_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
2408: p_task_assignments_out(k_index).cbs_element_id := p_task_assignments_in(i).cbs_element_id ;-- Added for CBS 16598322
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

Line 2666: In both pa_task_assignments_pub create_task_assignments and

2662:
2663: --Added for Bug 3940284
2664:
2665: /* Updates from the bug
2666: In both pa_task_assignments_pub create_task_assignments and
2667: update_task_assignments AMG APIs, we are deleting the ta_display_flag='N'
2668: assignment records whenever the first resource is assigned to the task
2669: version. There are a few problems that need to be fixed:
2670:

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

2913: pa_debug.g_err_stage:='Success on index:' || i;
2914: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
2915: END IF;
2916: p_task_assignments_out(i).return_status := 'S';
2917: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'S';
2918:
2919: ELSE
2920: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2921: pa_debug.g_err_stage:='Errored on index:' || i;

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

2921: pa_debug.g_err_stage:='Errored on index:' || i;
2922: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
2923: END IF;
2924: p_task_assignments_out(i).return_status := 'E';
2925: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'E';
2926: END IF;
2927:
2928: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2929: pa_debug.g_err_stage:='Out resource_assignment_id:' || c_rec_out.resource_assignment_id || 'Out resource alias:' || c_rec_out.alias;

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

2931: END IF;
2932: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
2933: p_task_assignments_out(i).resource_alias := c_rec_out.alias;
2934:
2935: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
2936: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out.alias;
2937:
2938:
2939: close c_cur_out;

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

2932: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
2933: p_task_assignments_out(i).resource_alias := c_rec_out.alias;
2934:
2935: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
2936: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out.alias;
2937:
2938:
2939: close c_cur_out;
2940: ELSE -- for CBS enabled projects

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

2946: pa_debug.g_err_stage:='Success on index:' || i;
2947: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
2948: END IF;
2949: p_task_assignments_out(i).return_status := 'S';
2950: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'S';
2951:
2952: ELSE
2953: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2954: pa_debug.g_err_stage:='Errored on index:' || i;

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

2954: pa_debug.g_err_stage:='Errored on index:' || i;
2955: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
2956: END IF;
2957: p_task_assignments_out(i).return_status := 'E';
2958: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'E';
2959: END IF;
2960:
2961: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2962: pa_debug.g_err_stage:='Out resource_assignment_id:' || c_rec_out_for_cbs.resource_assignment_id || 'Out resource alias:' || c_rec_out.alias;

Line 2968: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;

2964: END IF;
2965: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
2966: p_task_assignments_out(i).resource_alias := c_rec_out_for_cbs.alias;
2967:
2968: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
2969: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out_for_cbs.alias;
2970:
2971:
2972: close c_cur_out_for_cbs;

Line 2969: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out_for_cbs.alias;

2965: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
2966: p_task_assignments_out(i).resource_alias := c_rec_out_for_cbs.alias;
2967:
2968: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
2969: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out_for_cbs.alias;
2970:
2971:
2972: close c_cur_out_for_cbs;
2973:

Line 3069: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE

3065: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3066: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3067: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3068: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3069: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3070: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3071: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
3072: ,x_msg_count OUT NOCOPY NUMBER
3073: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3071: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE

3067: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3068: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3069: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3070: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3071: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
3072: ,x_msg_count OUT NOCOPY NUMBER
3073: ,x_msg_data OUT NOCOPY VARCHAR2
3074: ,x_return_status OUT NOCOPY VARCHAR2
3075: ) IS

Line 3085: l_task_assignment_periods_out PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE;

3081: l_msg_data VARCHAR2(2000);
3082: l_msg_code VARCHAR2(30);
3083: l_msg_count NUMBER;
3084: l_project_id NUMBER;
3085: l_task_assignment_periods_out PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE;
3086: L_FuncProc varchar2(2000);
3087:
3088: -- Added for bug 5469303
3089: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER) is

Line 3343: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE

3339: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3340: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3341: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3342: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3343: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3344: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3345: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
3346: ,x_msg_count OUT NOCOPY NUMBER
3347: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3345: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE

3341: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3342: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3343: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3344: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3345: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
3346: ,x_msg_count OUT NOCOPY NUMBER
3347: ,x_msg_data OUT NOCOPY VARCHAR2
3348: ,x_return_status OUT NOCOPY VARCHAR2
3349: ) IS

Line 3359: l_task_assignment_periods_out PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE;

3355: l_msg_data VARCHAR2(2000);
3356: l_msg_count NUMBER;
3357: l_msg_code VARCHAR2(30);
3358: l_project_id NUMBER;
3359: l_task_assignment_periods_out PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE;
3360: L_FuncProc varchar2(2000);
3361:
3362: -- Added for bug 5469303
3363: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER) is

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

5578: pa_debug.g_err_stage:='Setting global out variables for task and resource list member id';
5579: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5580: END IF;
5581:
5582: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;
5583: 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 ;
5584: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).cbs_element_id := p_task_assignments_in(i).cbs_element_id ;
5585:
5586: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

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

5579: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5580: END IF;
5581:
5582: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;
5583: 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 ;
5584: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).cbs_element_id := p_task_assignments_in(i).cbs_element_id ;
5585:
5586: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5587: pa_debug.g_err_stage:='Setting other main variables';

Line 5584: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).cbs_element_id := p_task_assignments_in(i).cbs_element_id ;

5580: END IF;
5581:
5582: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;
5583: 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 ;
5584: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).cbs_element_id := p_task_assignments_in(i).cbs_element_id ;
5585:
5586: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5587: pa_debug.g_err_stage:='Setting other main variables';
5588: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

5995: p_task_assignments_out(c_index + u_index).pa_task_id := l_d_task_id;
5996: p_task_assignments_out(c_index + u_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
5997: p_task_assignments_out(c_index + u_index).cbs_element_id := p_task_assignments_in(i).cbs_element_id ; -- 16598322
5998:
5999: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;
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:

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

5996: p_task_assignments_out(c_index + u_index).resource_list_member_id := p_task_assignments_in(i).resource_list_member_id ;
5997: p_task_assignments_out(c_index + u_index).cbs_element_id := p_task_assignments_in(i).cbs_element_id ; -- 16598322
5998:
5999: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;
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));

Line 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

5997: p_task_assignments_out(c_index + u_index).cbs_element_id := p_task_assignments_in(i).cbs_element_id ; -- 16598322
5998:
5999: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(c_index + u_index).pa_task_id := l_d_task_id;
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

Line 6099: In both pa_task_assignments_pub create_task_assignments and

6095:
6096: --Added for Bug 3940284
6097:
6098: /* Updates from the bug
6099: In both pa_task_assignments_pub create_task_assignments and
6100: update_task_assignments AMG APIs, we are deleting the ta_display_flag='N'
6101: assignment records whenever the first resource is assigned to the task
6102: version. There are a few problems that need to be fixed:
6103:

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

6597: pa_debug.g_err_stage:='Success on index:' || i;
6598: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6599: END IF;
6600: p_task_assignments_out(i).return_status := 'S';
6601: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'S';
6602:
6603: ELSE
6604: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
6605: pa_debug.g_err_stage:='Errored on index:' || i;

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

6605: pa_debug.g_err_stage:='Errored on index:' || i;
6606: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6607: END IF;
6608: p_task_assignments_out(i).return_status := 'E';
6609: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'E';
6610: END IF;
6611:
6612: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
6613: pa_debug.g_err_stage:='Out resource_assignment_id:' || c_rec_out.resource_assignment_id;

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

6618:
6619: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
6620: p_task_assignments_out(i).resource_alias := c_rec_out.alias;
6621:
6622: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
6623: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out.alias;
6624:
6625:
6626: close c_cur_out;

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

6619: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
6620: p_task_assignments_out(i).resource_alias := c_rec_out.alias;
6621:
6622: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
6623: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out.alias;
6624:
6625:
6626: close c_cur_out;
6627: ELSE-- Added for CBS 16598322

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

6633: pa_debug.g_err_stage:='Success on index:' || i;
6634: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6635: END IF;
6636: p_task_assignments_out(i).return_status := 'S';
6637: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'S';
6638:
6639: ELSE
6640: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
6641: pa_debug.g_err_stage:='Errored on index:' || i;

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

6641: pa_debug.g_err_stage:='Errored on index:' || i;
6642: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6643: END IF;
6644: p_task_assignments_out(i).return_status := 'E';
6645: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).return_status:= 'E';
6646: END IF;
6647:
6648: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
6649: pa_debug.g_err_stage:='Out resource_assignment_id:' || c_rec_out_for_cbs.resource_assignment_id;

Line 6658: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;

6654:
6655: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
6656: p_task_assignments_out(i).resource_alias := c_rec_out_for_cbs.alias;
6657:
6658: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
6659: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out_for_cbs.alias;
6660:
6661:
6662: close c_cur_out_for_cbs;

Line 6659: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out_for_cbs.alias;

6655: p_task_assignments_out(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
6656: p_task_assignments_out(i).resource_alias := c_rec_out_for_cbs.alias;
6657:
6658: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
6659: PA_TASK_ASSIGNMENTS_PUB.g_task_asgmts_out_tbl(i).resource_alias := c_rec_out_for_cbs.alias;
6660:
6661:
6662: close c_cur_out_for_cbs;
6663:

Line 7457: end PA_TASK_ASSIGNMENTS_PUB;

7453: END IF;
7454:
7455: END Convert_pm_taref_to_id;
7456:
7457: end PA_TASK_ASSIGNMENTS_PUB;