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_ASSIGNMENT_PROGRESS_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 18: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
15: p_action IN VARCHAR2 := 'SAVE' ,
16: p_bulk_load_flag IN VARCHAR2 := 'N' ,
17: p_progress_mode IN VARCHAR2 := 'FUTURE' ,
18: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
20: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 19: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

15: p_action IN VARCHAR2 := 'SAVE' ,
16: p_bulk_load_flag IN VARCHAR2 := 'N' ,
17: p_progress_mode IN VARCHAR2 := 'FUTURE' ,
18: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
20: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

Line 20: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

16: p_bulk_load_flag IN VARCHAR2 := 'N' ,
17: p_progress_mode IN VARCHAR2 := 'FUTURE' ,
18: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
20: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
24: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

Line 21: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

17: p_progress_mode IN VARCHAR2 := 'FUTURE' ,
18: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
20: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
24: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
25: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

Line 22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

18: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
20: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
24: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
25: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
26: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

Line 23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

19: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
20: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
24: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
25: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
26: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
27: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

Line 24: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

20: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
24: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
25: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
26: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
27: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
28: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

Line 25: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

21: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
24: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
25: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
26: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
27: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
28: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
29: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

Line 26: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
24: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
25: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
26: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
27: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
28: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
29: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
30: p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 27: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
24: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
25: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
26: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
27: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
28: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
29: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
30: p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

Line 28: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

24: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
25: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
26: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
27: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
28: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
29: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
30: p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
32: p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

Line 29: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

25: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
26: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
27: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
28: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
29: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
30: p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
32: p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
33: p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

Line 30: p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

26: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
27: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
28: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
29: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
30: p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
32: p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
33: p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
34: p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

Line 31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

27: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
28: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
29: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
30: p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
32: p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
33: p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
34: p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
35: p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 32: p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

28: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
29: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
30: p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
32: p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
33: p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
34: p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
35: p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
36: --p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224

Line 33: p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

29: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
30: p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
32: p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
33: p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
34: p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
35: p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
36: --p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224
37: p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 34: p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,

30: p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
32: p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
33: p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
34: p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
35: p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
36: --p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224
37: p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
38: p_actual_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost

Line 35: p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
32: p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
33: p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
34: p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
35: p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
36: --p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224
37: p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
38: p_actual_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
39: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 36: --p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224

32: p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
33: p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
34: p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
35: p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
36: --p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224
37: p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
38: p_actual_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
39: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
40: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost

Line 37: p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

33: p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
34: p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
35: p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
36: --p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224
37: p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
38: p_actual_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
39: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
40: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
41: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 38: p_actual_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost

34: p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ,
35: p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
36: --p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224
37: p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
38: p_actual_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
39: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
40: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
41: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
42: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,

Line 39: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

35: p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
36: --p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224
37: p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
38: p_actual_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
39: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
40: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
41: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
42: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
43: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 40: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost

36: --p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224
37: p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
38: p_actual_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
39: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
40: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
41: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
42: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
43: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
44: p_actual_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost

Line 41: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

37: p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
38: p_actual_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
39: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
40: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
41: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
42: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
43: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
44: p_actual_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
45: p_actual_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 43: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

39: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
40: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
41: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
42: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
43: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
44: p_actual_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
45: p_actual_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
46: p_etc_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative -- Bug3621404 This parameter represents raw cost
47: p_etc_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative

Line 44: p_actual_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost

40: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
41: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
42: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
43: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
44: p_actual_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
45: p_actual_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
46: p_etc_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative -- Bug3621404 This parameter represents raw cost
47: p_etc_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative
48: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

Line 45: p_actual_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

41: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
42: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
43: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
44: p_actual_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
45: p_actual_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
46: p_etc_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative -- Bug3621404 This parameter represents raw cost
47: p_etc_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative
48: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
49: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

Line 46: p_etc_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative -- Bug3621404 This parameter represents raw cost

42: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
43: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
44: p_actual_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
45: p_actual_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
46: p_etc_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative -- Bug3621404 This parameter represents raw cost
47: p_etc_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative
48: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
49: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
50: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 47: p_etc_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative

43: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
44: p_actual_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
45: p_actual_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
46: p_etc_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative -- Bug3621404 This parameter represents raw cost
47: p_etc_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative
48: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
49: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
50: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
51: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 48: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

44: p_actual_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Bug3621404 This parameter represents raw cost
45: p_actual_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
46: p_etc_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative -- Bug3621404 This parameter represents raw cost
47: p_etc_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative
48: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
49: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
50: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
51: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
52: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 49: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,

45: p_actual_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
46: p_etc_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative -- Bug3621404 This parameter represents raw cost
47: p_etc_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- Though the name of this column is this period but it is cumulative
48: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
49: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ,
50: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
51: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
52: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
53: IS

Line 569: IF p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

565:
566: --bug 3824042
567: SELECT project_currency_code, projfunc_currency_code INTO l_prj_currency_code, l_prjfunc_currency_code FROM pa_projects_all WHERE project_id = p_project_id;
568:
569: IF p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
570: THEN
571: l_task_id := 0;
572: ELSE
573: l_task_id := nvl(p_task_id, 0);

Line 577: /*IF p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

573: l_task_id := nvl(p_task_id, 0);
574: END IF;
575:
576: --bug# 3764224 Changes for RLM start
577: /*IF p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
578: THEN
579: l_assignment_id := 0;
580: ELSE
581: l_assignment_id := nvl(p_object_id, 0);

Line 584: IF p_resource_assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

580: ELSE
581: l_assignment_id := nvl(p_object_id, 0);
582: END IF;*/
583:
584: IF p_resource_assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
585: THEN
586: l_assignment_id := 0;
587: ELSE
588: l_assignment_id := nvl(p_resource_assignment_id, 0);

Line 592: IF p_object_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

588: l_assignment_id := nvl(p_resource_assignment_id, 0);
589: END IF;
590: --bug# 3764224 Changes for RLM end
591:
592: IF p_object_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
593: THEN
594: l_object_version_id := 0;
595: ELSE
596: l_object_version_id := nvl(p_object_version_id, 0);

Line 599: IF p_brief_overview = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

595: ELSE
596: l_object_version_id := nvl(p_object_version_id, 0);
597: END IF;
598:
599: IF p_brief_overview = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
600: THEN
601: l_brief_overview := null;
602: ELSE
603: l_brief_overview := p_brief_overview;

Line 606: IF p_progress_comment = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

602: ELSE
603: l_brief_overview := p_brief_overview;
604: END IF;
605:
606: IF p_progress_comment = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
607: THEN
608: l_progress_comment := null;
609: ELSE
610: l_progress_comment := p_progress_comment;

Line 613: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

609: ELSE
610: l_progress_comment := p_progress_comment;
611: END IF;
612:
613: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
614: THEN
615: l_pm_product_code := null;
616: ELSE
617: l_pm_product_code := p_pm_product_code;

Line 625: OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --maansari4/8

621: FETCH cur_check_published_version INTO l_published_structure;
622: CLOSE cur_check_published_version;
623:
624: IF l_published_structure = 'Y'
625: OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --maansari4/8
626: THEN
627: l_structure_version_id := null;
628: ELSE
629: l_structure_version_id := p_structure_version_id;

Line 633: IF p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

629: l_structure_version_id := p_structure_version_id;
630: END IF;
631:
632: --bug no. 3586648 start
633: IF p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
634: THEN
635: l_scheduled_start_date := null;
636: ELSE
637: l_scheduled_start_date := p_scheduled_start_date;

Line 640: IF p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

636: ELSE
637: l_scheduled_start_date := p_scheduled_start_date;
638: END IF;
639:
640: IF p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
641: THEN
642: l_scheduled_finish_date := null;
643: ELSE
644: l_scheduled_finish_date := p_scheduled_finish_date;

Line 648: IF p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

644: l_scheduled_finish_date := p_scheduled_finish_date;
645: END IF;
646:
647: /* Bug 3606627 : Shifting this code below
648: IF p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
649: THEN
650: IF p_actual_cost_this_period > 0 OR p_actual_effort_this_period > 0
651: THEN
652: l_actual_start_date := l_scheduled_start_date;

Line 663: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

659: */
660:
661: --bug no. 3586648 end
662:
663: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
664: THEN
665: l_actual_finish_date := null;
666: ELSE
667: l_actual_finish_date := p_actual_finish_date;

Line 670: IF p_estimated_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

666: ELSE
667: l_actual_finish_date := p_actual_finish_date;
668: END IF;
669:
670: IF p_estimated_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
671: THEN
672: l_estimated_start_date := null;
673: ELSE
674: l_estimated_start_date := p_estimated_start_date;

Line 677: IF p_estimated_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

673: ELSE
674: l_estimated_start_date := p_estimated_start_date;
675: END IF;
676:
677: IF p_estimated_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
678: THEN
679: l_estimated_finish_date := null;
680: ELSE
681: l_estimated_finish_date := p_estimated_finish_date;

Line 684: IF p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

680: ELSE
681: l_estimated_finish_date := p_estimated_finish_date;
682: END IF;
683:
684: IF p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
685: p_actual_effort_this_period IS NOT NULL
686: THEN
687: l_actual_effort_this_period := p_actual_effort_this_period; -- This is incremental
688: ELSE

Line 695: /*IF p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

691:
692: -- 3958686, moved this code from below
693: --bug# 3764224 Changes for RLM start
694: -- Bug 3606627 Start
695: /*IF p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
696: p_resource_list_member_id IS NOT NULL
697: THEN
698: l_resource_list_member_id := p_resource_list_member_id;
699: ELSE

Line 703: IF p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

699: ELSE
700: l_resource_list_member_id := null;
701: END IF;*/
702:
703: IF p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
704: p_object_id IS NOT NULL
705: THEN
706: l_resource_list_member_id := p_object_id;
707: ELSE

Line 737: IF p_etc_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

733: */
734: --bug 3958686, end
735:
736:
737: IF p_etc_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
738: p_etc_effort_this_period IS NOT NULL
739: --p_actual_finish_date IS NULL AND p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE maansari4/27
740: THEN
741: l_etc_effort_this_period := p_etc_effort_this_period; -- This is cumulative

Line 739: --p_actual_finish_date IS NULL AND p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE maansari4/27

735:
736:
737: IF p_etc_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
738: p_etc_effort_this_period IS NOT NULL
739: --p_actual_finish_date IS NULL AND p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE maansari4/27
740: THEN
741: l_etc_effort_this_period := p_etc_effort_this_period; -- This is cumulative
742: ELSE
743: l_etc_effort_this_period := null;

Line 761: --IF p_actual_finish_date IS NOT NULL AND p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

757:
758:
759: --maansari 4/27
760: -- Bug 3956299 : As per discussion with Saima, ETC should be given precedence over act finish date
761: --IF p_actual_finish_date IS NOT NULL AND p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
762: --THEN
763: -- l_etc_effort_this_period := 0;
764: --END IF;
765: IF l_etc_effort_this_period IS NOT NULL AND l_etc_effort_this_period > 0

Line 773: IF p_txn_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND

769:
770: --maansari 4/27
771:
772:
773: IF p_txn_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
774: p_txn_currency_code IS NOT NULL
775: THEN
776: l_txn_currency_code := p_txn_currency_code;
777: ELSE

Line 781: IF p_rate_based_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND

777: ELSE
778: l_txn_currency_code := null;
779: END IF;
780:
781: IF p_rate_based_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
782: p_rate_based_flag IS NOT NULL
783: THEN
784: l_rate_based_flag := p_rate_based_flag;
785: ELSE

Line 789: IF p_resource_class_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND

785: ELSE
786: l_rate_based_flag := null;
787: END IF;
788:
789: IF p_resource_class_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
790: p_resource_class_code IS NOT NULL
791: THEN
792: l_resource_class_code := p_resource_class_code;
793: ELSE

Line 797: IF p_rbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

793: ELSE
794: l_resource_class_code := null;
795: END IF;
796:
797: IF p_rbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
798: p_rbs_element_id IS NOT NULL
799: THEN
800: l_rbs_element_id := p_rbs_element_id;
801: ELSE

Line 805: IF p_actual_cost <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

801: ELSE
802: l_rbs_element_id := null;
803: END IF;
804: -- Raw Cost Changes : Changed the vaiable names to include raw
805: IF p_actual_cost <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
806: p_actual_cost IS NOT NULL
807: THEN
808: l_actual_raw_cost := p_actual_cost;
809: ELSE

Line 813: IF p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

809: ELSE
810: l_actual_raw_cost := null;
811: END IF;
812: -- Raw Cost Changes : Changed the vaiable names to include raw
813: IF p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
814: p_actual_cost_this_period IS NOT NULL
815: THEN
816: l_actual_raw_cost_this_period := p_actual_cost_this_period;
817: ELSE

Line 834: IF p_actual_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

830: END IF;
831: */
832:
833:
834: IF p_actual_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
835: p_actual_effort IS NOT NULL
836: THEN
837: l_actual_effort := p_actual_effort;
838: ELSE

Line 842: IF p_etc_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

838: ELSE
839: l_actual_effort := null;
840: END IF;
841: -- Raw Cost Changes : Changed the vaiable names to include raw
842: IF p_etc_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
843: p_etc_cost_this_period IS NOT NULL
844: THEN
845: l_etc_raw_cost_this_period := p_etc_cost_this_period;
846: ELSE

Line 903: IF (p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_cost_this_period >0)

899: --- check if structure is shared and actuals are passed
900: /*l_structure_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_project_id);
901: IF l_structure_shared = 'Y'
902: THEN
903: IF (p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_cost_this_period >0)
904: OR (p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_effort_this_period >0)
905: THEN
906: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
907: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');

Line 904: OR (p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_effort_this_period >0)

900: /*l_structure_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_project_id);
901: IF l_structure_shared = 'Y'
902: THEN
903: IF (p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_cost_this_period >0)
904: OR (p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_effort_this_period >0)
905: THEN
906: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
907: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');
908: x_msg_data := 'PA_TP_CANT_NTER_ACT_SHR_STR';

Line 943: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL

939: END IF;
940: ----- Wrong MODE
941:
942: ----- Invalid DATE
943: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
944: THEN
945: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
946: ,p_msg_name => 'PA_TP_INV_AOD');
947: x_msg_data := 'PA_TP_INV_AOD';

Line 956: IF p_estimated_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND p_estimated_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

952:
953:
954: -- Bug 3979303 : Commentee code here and moved it below with some modification
955: /*
956: IF p_estimated_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND p_estimated_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
957: THEN
958: IF (p_estimated_finish_date < p_estimated_start_date)
959: THEN
960: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1074: IF (p_txn_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND

1070: /* Currently the value of p_txn_currency_code is not passed to this API in the AMG flow.
1071: However, the following code will handle the case if the AMG flow is later modified to
1072: pass the value of p_txn_currency_code to this API. */
1073:
1074: IF (p_txn_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
1075:
1076: p_txn_currency_code IS NOT NULL)
1077:
1078: THEN

Line 1102: IF p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

1098: END IF;
1099: -- Bug 3979303 : End
1100:
1101:
1102: IF p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1103: THEN
1104: IF l_actual_raw_cost_this_period > 0 OR l_actual_effort_this_period > 0
1105: THEN
1106: l_actual_start_date := l_scheduled_start_date;

Line 1285: IF l_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND l_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

1281: -- 4533112 End
1282:
1283:
1284:
1285: IF l_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND l_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1286: THEN
1287: IF l_actual_finish_date < l_actual_start_date
1288: THEN
1289: IF TRUNC(SYSDATE) < l_actual_start_date

Line 1813: --IF p_actual_cost_this_period = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_actual_cost_this_period IS NULL

1809:
1810: IF l_rate_based_flag = 'Y' --maansari7/6 bug 3742356
1811: THEN
1812:
1813: --IF p_actual_cost_this_period = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_actual_cost_this_period IS NULL
1814: --THEN --maansari4/10
1815: IF NVL(l_track_wp_cost_flag, 'Y') = 'Y' THEN -- Bug 3801745
1816:
1817: --maansari4/10

Line 2677: IF p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2673:
2674: IF l_db_action = 'CREATE'
2675: THEN
2676: /* FPM Dev CR 3
2677: IF p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2678: THEN
2679: l_percent_complete_id := null;
2680: ELSE
2681: l_percent_complete_id := p_percent_complete_id;

Line 3067: -- IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3063: -- Bug 3879461 : Temporary getting percent complete id and record version number from database
3064: -- So no locking.
3065: -- There is issue in UI, after calling API under Recalculate, it should incrment the VO record version number
3066:
3067: -- IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3068: -- THEN
3069: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(
3070: p_project_id => p_project_id
3071: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM

Line 3523: Pa_Interface_Utils_Pub.get_messages

3519: end if;
3520:
3521: IF l_msg_count = 1 AND x_msg_data IS NULL
3522: THEN
3523: Pa_Interface_Utils_Pub.get_messages
3524: ( p_encoded => Fnd_Api.G_TRUE
3525: , p_msg_index => 1
3526: , p_msg_count => l_msg_count
3527: , p_msg_data => l_msg_data