DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_TASK_ASSIGNMENTS_PUB

Line 22: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE

18: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
20: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
23: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
24: ,x_msg_count OUT NOCOPY NUMBER
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ,x_return_status OUT NOCOPY VARCHAR2

Line 23: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE

19: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
20: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
23: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
24: ,x_msg_count OUT NOCOPY NUMBER
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ,x_return_status OUT NOCOPY VARCHAR2
27: ) IS

Line 732: PA_TASK_ASSIGNMENTS_PUB.Convert_PM_TARef_To_ID( p_pm_product_code => p_pm_product_code

728: p_task_assignment_periods_in(i).pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
729:
730: --dbms_output.put_line('Converting Task Asgmt Reference:' || p_task_assignment_periods_in(i).pm_task_asgmt_reference );
731:
732: PA_TASK_ASSIGNMENTS_PUB.Convert_PM_TARef_To_ID( p_pm_product_code => p_pm_product_code
733: ,p_pa_project_id => l_project_id
734: ,p_pa_structure_version_id => l_struct_elem_version_id
735: ,p_pa_task_id => l_d_task_id
736: ,p_pa_task_elem_ver_id => l_task_elem_version_id_tbl(i)

Line 1136: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';

1132: --dbms_output.put_line('Success on index:' || i);
1133: p_task_assignment_periods_out(i).return_status := 'S';
1134: -- Bug Fix 5638541.
1135: -- removed the hard coded apps.
1136: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';
1137: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';
1138: -- End of Bug Fix 5638541.
1139:
1140: ELSE

Line 1137: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';

1133: p_task_assignment_periods_out(i).return_status := 'S';
1134: -- Bug Fix 5638541.
1135: -- removed the hard coded apps.
1136: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';
1137: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';
1138: -- End of Bug Fix 5638541.
1139:
1140: ELSE
1141: --dbms_output.put_line('Errored on index:' || i);

Line 1145: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';

1141: --dbms_output.put_line('Errored on index:' || i);
1142: p_task_assignment_periods_out(i).return_status := 'E';
1143: -- Bug Fix 5638541.
1144: -- removed the hard coded apps.
1145: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';
1146: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';
1147: -- End of Bug Fix 5638541.
1148: END IF;
1149:

Line 1146: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';

1142: p_task_assignment_periods_out(i).return_status := 'E';
1143: -- Bug Fix 5638541.
1144: -- removed the hard coded apps.
1145: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';
1146: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';
1147: -- End of Bug Fix 5638541.
1148: END IF;
1149:
1150: --dbms_output.put_line('Out resource_assignment_id:' || c_rec_out.resource_assignment_id);

Line 1158: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;

1154: p_task_assignment_periods_out(i).resource_alias := c_rec_out.alias;
1155:
1156: -- Bug Fix 5638541.
1157: -- removed the hard coded apps.
1158: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1159: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1160: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1161: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1162: -- End of Bug Fix 5638541.

Line 1159: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;

1155:
1156: -- Bug Fix 5638541.
1157: -- removed the hard coded apps.
1158: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1159: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1160: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1161: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1162: -- End of Bug Fix 5638541.
1163:

Line 1160: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;

1156: -- Bug Fix 5638541.
1157: -- removed the hard coded apps.
1158: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1159: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1160: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1161: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1162: -- End of Bug Fix 5638541.
1163:
1164:

Line 1161: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;

1157: -- removed the hard coded apps.
1158: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1159: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1160: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1161: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1162: -- End of Bug Fix 5638541.
1163:
1164:
1165: close c_cur_out;