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 ra.budget_version_id = bv.budget_version_id
594: AND bv.project_structure_version_id = evs.element_version_id

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

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

Line 625: pa_project_assignments pa

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

Line 658: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'

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

Line 857: pa_project_assignments_pkg.Update_row (

853:
854: IF p_assignment_id_tbl.COUNT > 0 THEN
855: FOR i IN p_assignment_id_tbl.FIRST .. p_assignment_id_tbl.LAST LOOP
856:
857: pa_project_assignments_pkg.Update_row (
858: p_assignment_id => p_assignment_id_tbl(i),
859: p_revenue_bill_rate => p_revenue_bill_rate_tbl(i),
860: x_return_status => x_return_status);
861: END LOOP;

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

875: --
876: --
877:
878: /* Added procedure Update_Transfer_Price for bug 3051110
879: This Procedure calls update_row which will update the record in pa_project_assignments table
880: with the transfer price rate and transfer price rate curr passed.
881: */
882:
883: PROCEDURE Update_Transfer_Price

Line 884: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

880: with the transfer price rate and transfer price rate curr passed.
881: */
882:
883: PROCEDURE Update_Transfer_Price
884: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
885: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE
886: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE
887: ,p_debug_mode IN VARCHAR2 default 'N'
888: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 885: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE

881: */
882:
883: PROCEDURE Update_Transfer_Price
884: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
885: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE
886: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE
887: ,p_debug_mode IN VARCHAR2 default 'N'
888: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
889: )

Line 886: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE

882:
883: PROCEDURE Update_Transfer_Price
884: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
885: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE
886: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE
887: ,p_debug_mode IN VARCHAR2 default 'N'
888: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
889: )
890: IS

Line 895: pa_project_assignments_pkg.update_row(

891: BEGIN
892:
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894:
895: pa_project_assignments_pkg.update_row(
896: p_assignment_id => p_assignment_id,
897: p_transfer_price_rate => p_transfer_price_rate,
898: p_transfer_pr_rate_curr => p_transfer_pr_rate_curr,
899: x_return_status => x_return_status);

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

910: END Update_Transfer_Price;
911:
912: /* Added procedure Calc_Init_Transfer_Price for bug 3051110. (TP Enhancement)
913: This Procedure calls the Billing API which calculates the TP Rate and returns.
914: The rate is used for updation in the pa_project_assignments table.
915: */
916:
917: PROCEDURE Calc_Init_Transfer_Price
918: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

Line 918: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

914: The rate is used for updation in the pa_project_assignments table.
915: */
916:
917: PROCEDURE Calc_Init_Transfer_Price
918: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
919: ,p_start_date IN pa_project_assignments.start_date%TYPE
920: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
921: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
922: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 919: ,p_start_date IN pa_project_assignments.start_date%TYPE

915: */
916:
917: PROCEDURE Calc_Init_Transfer_Price
918: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
919: ,p_start_date IN pa_project_assignments.start_date%TYPE
920: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
921: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
922: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
923: ,x_msg_count OUT NOCOPY Number --File.Sql.39 bug 4440895

Line 927: lx_transfer_price_rate pa_project_assignments.transfer_price_rate%TYPE;

923: ,x_msg_count OUT NOCOPY Number --File.Sql.39 bug 4440895
924: )
925: IS
926:
927: lx_transfer_price_rate pa_project_assignments.transfer_price_rate%TYPE;
928: lx_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%TYPE;
929: l_start_date pa_project_assignments.start_date%TYPE := Null;
930:
931: BEGIN

Line 928: lx_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%TYPE;

924: )
925: IS
926:
927: lx_transfer_price_rate pa_project_assignments.transfer_price_rate%TYPE;
928: lx_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%TYPE;
929: l_start_date pa_project_assignments.start_date%TYPE := Null;
930:
931: BEGIN
932:

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

925: IS
926:
927: lx_transfer_price_rate pa_project_assignments.transfer_price_rate%TYPE;
928: lx_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%TYPE;
929: l_start_date pa_project_assignments.start_date%TYPE := Null;
930:
931: BEGIN
932:
933: if p_debug_mode = 'Y' THEN