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_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 782: PA_TASK_ASSIGNMENTS_PUB.Convert_PM_TARef_To_ID( p_pm_product_code => p_pm_product_code

778: p_task_assignment_periods_in(i).pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
779:
780: --dbms_output.put_line('Converting Task Asgmt Reference:' || p_task_assignment_periods_in(i).pm_task_asgmt_reference );
781:
782: PA_TASK_ASSIGNMENTS_PUB.Convert_PM_TARef_To_ID( p_pm_product_code => p_pm_product_code
783: ,p_pa_project_id => l_project_id
784: ,p_pa_structure_version_id => l_struct_elem_version_id
785: ,p_pa_task_id => l_d_task_id
786: ,p_pa_task_elem_ver_id => l_task_elem_version_id_tbl(i)

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

1313: --dbms_output.put_line('Success on index:' || i);
1314: p_task_assignment_periods_out(i).return_status := 'S';
1315: -- Bug Fix 5638541.
1316: -- removed the hard coded apps.
1317: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';
1318: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';
1319: -- End of Bug Fix 5638541.
1320:
1321: ELSE

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

1314: p_task_assignment_periods_out(i).return_status := 'S';
1315: -- Bug Fix 5638541.
1316: -- removed the hard coded apps.
1317: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';
1318: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';
1319: -- End of Bug Fix 5638541.
1320:
1321: ELSE
1322: --dbms_output.put_line('Errored on index:' || i);

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

1322: --dbms_output.put_line('Errored on index:' || i);
1323: p_task_assignment_periods_out(i).return_status := 'E';
1324: -- Bug Fix 5638541.
1325: -- removed the hard coded apps.
1326: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';
1327: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';
1328: -- End of Bug Fix 5638541.
1329: END IF;
1330:

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

1323: p_task_assignment_periods_out(i).return_status := 'E';
1324: -- Bug Fix 5638541.
1325: -- removed the hard coded apps.
1326: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';
1327: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';
1328: -- End of Bug Fix 5638541.
1329: END IF;
1330:
1331: --dbms_output.put_line('Out resource_assignment_id:' || c_rec_out.resource_assignment_id);

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

1335: p_task_assignment_periods_out(i).resource_alias := c_rec_out.alias;
1336:
1337: -- Bug Fix 5638541.
1338: -- removed the hard coded apps.
1339: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1340: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1341: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1342: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1343: -- End of Bug Fix 5638541.

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

1336:
1337: -- Bug Fix 5638541.
1338: -- removed the hard coded apps.
1339: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1340: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1341: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1342: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1343: -- End of Bug Fix 5638541.
1344:

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

1337: -- Bug Fix 5638541.
1338: -- removed the hard coded apps.
1339: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1340: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1341: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1342: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1343: -- End of Bug Fix 5638541.
1344:
1345:

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

1338: -- removed the hard coded apps.
1339: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1340: -- APPS.PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1341: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out.resource_assignment_id;
1342: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out.alias;
1343: -- End of Bug Fix 5638541.
1344:
1345:
1346: close c_cur_out;

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

1352:
1353: IF c_cur_out_for_cbs%FOUND THEN
1354: --dbms_output.put_line('Success on index:' || i);
1355: p_task_assignment_periods_out(i).return_status := 'S';
1356: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'S';
1357:
1358: ELSE
1359: --dbms_output.put_line('Errored on index:' || i);
1360: p_task_assignment_periods_out(i).return_status := 'E';

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

1357:
1358: ELSE
1359: --dbms_output.put_line('Errored on index:' || i);
1360: p_task_assignment_periods_out(i).return_status := 'E';
1361: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).return_status:= 'E';
1362:
1363: END IF;
1364:
1365: p_task_assignment_periods_out(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;

Line 1369: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;

1365: p_task_assignment_periods_out(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
1366: p_task_assignment_periods_out(i).resource_alias := c_rec_out_for_cbs.alias;
1367: p_task_assignment_periods_out(i).cbs_element_id := p_task_assignment_periods_in(i).cbs_element_id;
1368:
1369: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
1370: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out_for_cbs.alias;
1371: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).cbs_element_id := p_task_assignment_periods_in(i).cbs_element_id;
1372: -- End of Bug Fix 5638541.
1373:

Line 1370: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out_for_cbs.alias;

1366: p_task_assignment_periods_out(i).resource_alias := c_rec_out_for_cbs.alias;
1367: p_task_assignment_periods_out(i).cbs_element_id := p_task_assignment_periods_in(i).cbs_element_id;
1368:
1369: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
1370: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out_for_cbs.alias;
1371: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).cbs_element_id := p_task_assignment_periods_in(i).cbs_element_id;
1372: -- End of Bug Fix 5638541.
1373:
1374:

Line 1371: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).cbs_element_id := p_task_assignment_periods_in(i).cbs_element_id;

1367: p_task_assignment_periods_out(i).cbs_element_id := p_task_assignment_periods_in(i).cbs_element_id;
1368:
1369: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).pa_task_assignment_id := c_rec_out_for_cbs.resource_assignment_id;
1370: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).resource_alias := c_rec_out_for_cbs.alias;
1371: PA_TASK_ASSIGNMENTS_PUB.g_asgmts_periods_out_tbl(i).cbs_element_id := p_task_assignment_periods_in(i).cbs_element_id;
1372: -- End of Bug Fix 5638541.
1373:
1374:
1375: close c_cur_out_for_cbs;