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_ASSIGNMENTS_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

6:
7: PROCEDURE Create_Assignment
8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 23: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
20: ,p_number_of_requirements IN NUMBER := 1
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
23: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
24: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
25: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
26: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
27: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 24: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895

20: ,p_number_of_requirements IN NUMBER := 1
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
23: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
24: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
25: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
26: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
27: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28: )

Line 37: l_assignment_effort pa_project_assignments.assignment_effort%TYPE;

33: l_return_status VARCHAR2(10);
34: l_row_id ROWID;
35: l_msg_count NUMBER;
36: l_msg_data VARCHAR2(4000);
37: l_assignment_effort pa_project_assignments.assignment_effort%TYPE;
38: l_work_type_id NUMBER;
39: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
40: l_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
41: l_assignment_effort_calc VARCHAR2(1) := 'N';

Line 39: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;

35: l_msg_count NUMBER;
36: l_msg_data VARCHAR2(4000);
37: l_assignment_effort pa_project_assignments.assignment_effort%TYPE;
38: l_work_type_id NUMBER;
39: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
40: l_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
41: l_assignment_effort_calc VARCHAR2(1) := 'N';
42: l_raw_revenue NUMBER;
43: l_rec_version_number NUMBER;

Line 40: l_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;

36: l_msg_data VARCHAR2(4000);
37: l_assignment_effort pa_project_assignments.assignment_effort%TYPE;
38: l_work_type_id NUMBER;
39: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
40: l_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
41: l_assignment_effort_calc VARCHAR2(1) := 'N';
42: l_raw_revenue NUMBER;
43: l_rec_version_number NUMBER;
44: -- FP.M Development

Line 53: WHERE object_type = 'PA_PROJECT_ASSIGNMENTS'

49: CURSOR get_subteam_id IS
50: SELECT project_subteam_id,
51: primary_subteam_flag
52: FROM pa_project_subteam_parties
53: WHERE object_type = 'PA_PROJECT_ASSIGNMENTS'
54: AND object_id = l_assignment_rec.source_assignment_id;
55:
56: BEGIN
57:

Line 244: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'

240:
241: PA_PROJECT_SUBTEAM_PARTIES_PVT.Create_Subteam_Party
242: ( p_validate_only => p_validate_only
243: ,p_project_subteam_id => p_project_subteam_id
244: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'
245: ,p_object_id => PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id
246: ,x_project_subteam_party_row_id => l_row_id
247: ,x_project_subteam_party_id => l_project_subteam_party_id
248: ,x_return_status => l_return_status

Line 276: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'

272:
273: PA_PROJECT_SUBTEAM_PARTIES_PVT.Create_Subteam_Party
274: ( p_validate_only => p_validate_only
275: ,p_project_subteam_id => get_subteam_id_rec.project_subteam_id
276: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'
277: ,p_object_id => PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id
278: ,p_primary_subteam_flag => get_subteam_id_rec.primary_subteam_flag
279: ,x_project_subteam_party_row_id=> l_row_id
280: ,x_project_subteam_party_id => l_project_subteam_party_id

Line 322: FROM pa_project_assignments

318:
319: IF l_assignment_effort IS NOT NULL THEN
320:
321: SELECT record_version_number INTO l_rec_version_number
322: FROM pa_project_assignments
323: WHERE assignment_id = PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(1).assignment_id;
324:
325: --This is an bulk update for assignment effort using the global assignment_id array
326: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row

Line 326: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row

322: FROM pa_project_assignments
323: WHERE assignment_id = PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(1).assignment_id;
324:
325: --This is an bulk update for assignment effort using the global assignment_id array
326: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row
327: ( p_assignment_id => NULL
328: ,p_record_version_number => l_rec_version_number
329: ,p_assignment_effort => l_assignment_effort
330: ,x_return_status => l_return_status

Line 396: FROM pa_project_assignments

392:
393: -- cursor to get the utilization information
394: CURSOR get_work_type IS
395: SELECT work_type_id
396: FROM pa_project_assignments
397: WHERE assignment_id = p_assignment_rec.assignment_id;
398:
399: BEGIN
400:

Line 436: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'

432: PA_PROJECT_SUBTEAM_PARTIES_PVT.Update_SPT_Assgn
433: ( p_validate_only => p_validate_only
434: ,p_project_subteam_party_id => p_project_subteam_party_id
435: ,p_project_subteam_id => p_project_subteam_id
436: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'
437: ,p_object_id => p_assignment_rec.assignment_id
438: ,x_project_subteam_party_id => l_project_subteam_party_id
439: ,x_return_status => l_return_status
440: ,x_record_version_number => l_record_version_number

Line 559: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM

555:
556:
557: PROCEDURE Delete_Assignment
558: ( p_assignment_row_id IN ROWID := NULL
559: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR

556:
557: PROCEDURE Delete_Assignment
558: ( p_assignment_row_id IN ROWID := NULL
559: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
564: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM

558: ( p_assignment_row_id IN ROWID := NULL
559: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
560: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
562: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
563: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
564: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
565: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
566: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 590: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage

586: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
587: FROM PA_RESOURCE_ASSIGNMENTS ra
588: ,PA_BUDGET_VERSIONS bv
589: ,PA_PROJ_ELEM_VER_STRUCTURE evs
590: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
591: WHERE ra.project_id = bv.project_id
592: AND bv.project_id = evs.project_id
593: AND bv.budget_type_code IS NULL -- added for bug#8247628
594: AND ra.budget_version_id = bv.budget_version_id

Line 607: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage

603: FROM PA_RESOURCE_ASSIGNMENTS ra
604: ,PA_BUDGET_VERSIONS bv
605: ,PA_PROJ_ELEM_VER_STRUCTURE evs
606: ,PA_PROJ_WORKPLAN_ATTR pwa
607: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
608: WHERE pwa.wp_enable_Version_flag = 'N'
609: AND pwa.project_id = ra.project_id
610: AND pwa.proj_element_id = evs.proj_element_id
611: AND ra.project_id = bv.project_id

Line 627: pa_project_assignments pa

623: CURSOR get_res_mand_attributes IS
624: SELECT rf.ROLE_ENABLED_FLAG
625: FROM pa_res_formats_b rf,
626: pa_resource_list_members rlm,
627: pa_project_assignments pa
628: WHERE pa.assignment_id = p_assignment_id
629: AND pa.resource_list_member_id IS NOT NULL
630: AND rlm.resource_list_member_id = pa.resource_list_member_id
631: AND rlm.res_format_id = rf.res_format_id;

Line 660: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'

656: ,x_log_level => 5);
657: END IF;
658: PA_PROJECT_SUBTEAM_PARTIES_PVT.Delete_SubteamParty_By_Obj
659: ( p_validate_only => p_validate_only
660: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'
661: ,p_object_id => p_assignment_id
662: ,p_init_msg_list => FND_API.G_FALSE -- Added for bug 5130421
663: ,x_return_status => l_return_status
664: ,x_msg_count => l_msg_count

Line 865: pa_project_assignments_pkg.Update_row (

861:
862: IF p_assignment_id_tbl.COUNT > 0 THEN
863: FOR i IN p_assignment_id_tbl.FIRST .. p_assignment_id_tbl.LAST LOOP
864:
865: pa_project_assignments_pkg.Update_row (
866: p_assignment_id => p_assignment_id_tbl(i),
867: p_revenue_bill_rate => p_revenue_bill_rate_tbl(i),
868: x_return_status => x_return_status);
869: END LOOP;

Line 887: This Procedure calls update_row which will update the record in pa_project_assignments table

883: --
884: --
885:
886: /* Added procedure Update_Transfer_Price for bug 3051110
887: This Procedure calls update_row which will update the record in pa_project_assignments table
888: with the transfer price rate and transfer price rate curr passed.
889: */
890:
891: PROCEDURE Update_Transfer_Price

Line 892: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

888: with the transfer price rate and transfer price rate curr passed.
889: */
890:
891: PROCEDURE Update_Transfer_Price
892: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
893: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE
894: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE
895: ,p_debug_mode IN VARCHAR2 default 'N'
896: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 893: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE

889: */
890:
891: PROCEDURE Update_Transfer_Price
892: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
893: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE
894: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE
895: ,p_debug_mode IN VARCHAR2 default 'N'
896: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
897: )

Line 894: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE

890:
891: PROCEDURE Update_Transfer_Price
892: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
893: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE
894: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE
895: ,p_debug_mode IN VARCHAR2 default 'N'
896: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
897: )
898: IS

Line 903: pa_project_assignments_pkg.update_row(

899: BEGIN
900:
901: x_return_status := FND_API.G_RET_STS_SUCCESS;
902:
903: pa_project_assignments_pkg.update_row(
904: p_assignment_id => p_assignment_id,
905: p_transfer_price_rate => p_transfer_price_rate,
906: p_transfer_pr_rate_curr => p_transfer_pr_rate_curr,
907: x_return_status => x_return_status);

Line 922: The rate is used for updation in the pa_project_assignments table.

918: END Update_Transfer_Price;
919:
920: /* Added procedure Calc_Init_Transfer_Price for bug 3051110. (TP Enhancement)
921: This Procedure calls the Billing API which calculates the TP Rate and returns.
922: The rate is used for updation in the pa_project_assignments table.
923: */
924:
925: PROCEDURE Calc_Init_Transfer_Price
926: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

Line 926: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

922: The rate is used for updation in the pa_project_assignments table.
923: */
924:
925: PROCEDURE Calc_Init_Transfer_Price
926: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
927: ,p_start_date IN pa_project_assignments.start_date%TYPE
928: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
929: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
930: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 927: ,p_start_date IN pa_project_assignments.start_date%TYPE

923: */
924:
925: PROCEDURE Calc_Init_Transfer_Price
926: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
927: ,p_start_date IN pa_project_assignments.start_date%TYPE
928: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
929: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
930: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
931: ,x_msg_count OUT NOCOPY Number --File.Sql.39 bug 4440895

Line 935: lx_transfer_price_rate pa_project_assignments.transfer_price_rate%TYPE;

931: ,x_msg_count OUT NOCOPY Number --File.Sql.39 bug 4440895
932: )
933: IS
934:
935: lx_transfer_price_rate pa_project_assignments.transfer_price_rate%TYPE;
936: lx_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%TYPE;
937: l_start_date pa_project_assignments.start_date%TYPE := Null;
938:
939: BEGIN

Line 936: lx_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%TYPE;

932: )
933: IS
934:
935: lx_transfer_price_rate pa_project_assignments.transfer_price_rate%TYPE;
936: lx_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%TYPE;
937: l_start_date pa_project_assignments.start_date%TYPE := Null;
938:
939: BEGIN
940:

Line 937: l_start_date pa_project_assignments.start_date%TYPE := Null;

933: IS
934:
935: lx_transfer_price_rate pa_project_assignments.transfer_price_rate%TYPE;
936: lx_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%TYPE;
937: l_start_date pa_project_assignments.start_date%TYPE := Null;
938:
939: BEGIN
940:
941: if p_debug_mode = 'Y' THEN