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 615: IF p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

611:
612: --bug 3824042
613: 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;
614:
615: IF p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
616: THEN
617: l_task_id := 0;
618: ELSE
619: l_task_id := nvl(p_task_id, 0);

Line 623: /*IF p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

619: l_task_id := nvl(p_task_id, 0);
620: END IF;
621:
622: --bug# 3764224 Changes for RLM start
623: /*IF p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
624: THEN
625: l_assignment_id := 0;
626: ELSE
627: l_assignment_id := nvl(p_object_id, 0);

Line 630: IF p_resource_assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

626: ELSE
627: l_assignment_id := nvl(p_object_id, 0);
628: END IF;*/
629:
630: IF p_resource_assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
631: THEN
632: l_assignment_id := 0;
633: ELSE
634: l_assignment_id := nvl(p_resource_assignment_id, 0);

Line 644: IF p_object_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

640: FETCH get_Cbs_element_id INTO l_cbs_element_id;
641: CLOSE get_Cbs_element_id;
642:
643: --DEBUG_DJ('l_cbs_element_id: '||l_cbs_element_id);
644: IF p_object_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
645: THEN
646: l_object_version_id := 0;
647: ELSE
648: l_object_version_id := nvl(p_object_version_id, 0);

Line 651: IF p_brief_overview = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

647: ELSE
648: l_object_version_id := nvl(p_object_version_id, 0);
649: END IF;
650:
651: IF p_brief_overview = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652: THEN
653: l_brief_overview := null;
654: ELSE
655: l_brief_overview := p_brief_overview;

Line 658: IF p_progress_comment = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

654: ELSE
655: l_brief_overview := p_brief_overview;
656: END IF;
657:
658: IF p_progress_comment = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
659: THEN
660: l_progress_comment := null;
661: ELSE
662: l_progress_comment := p_progress_comment;

Line 665: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

661: ELSE
662: l_progress_comment := p_progress_comment;
663: END IF;
664:
665: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
666: THEN
667: l_pm_product_code := null;
668: ELSE
669: l_pm_product_code := p_pm_product_code;

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

673: FETCH cur_check_published_version INTO l_published_structure;
674: CLOSE cur_check_published_version;
675:
676: IF l_published_structure = 'Y'
677: OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --maansari4/8
678: THEN
679: l_structure_version_id := null;
680: ELSE
681: l_structure_version_id := p_structure_version_id;

Line 685: IF p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

681: l_structure_version_id := p_structure_version_id;
682: END IF;
683:
684: --bug no. 3586648 start
685: IF p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
686: THEN
687: l_scheduled_start_date := null;
688: ELSE
689: l_scheduled_start_date := p_scheduled_start_date;

Line 692: IF p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

688: ELSE
689: l_scheduled_start_date := p_scheduled_start_date;
690: END IF;
691:
692: IF p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
693: THEN
694: l_scheduled_finish_date := null;
695: ELSE
696: l_scheduled_finish_date := p_scheduled_finish_date;

Line 700: IF p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

696: l_scheduled_finish_date := p_scheduled_finish_date;
697: END IF;
698:
699: /* Bug 3606627 : Shifting this code below
700: IF p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
701: THEN
702: IF p_actual_cost_this_period > 0 OR p_actual_effort_this_period > 0
703: THEN
704: l_actual_start_date := l_scheduled_start_date;

Line 715: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

711: */
712:
713: --bug no. 3586648 end
714:
715: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
716: THEN
717: l_actual_finish_date := null;
718: ELSE
719: l_actual_finish_date := p_actual_finish_date;

Line 722: IF p_estimated_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

718: ELSE
719: l_actual_finish_date := p_actual_finish_date;
720: END IF;
721:
722: IF p_estimated_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
723: THEN
724: l_estimated_start_date := null;
725: ELSE
726: l_estimated_start_date := p_estimated_start_date;

Line 729: IF p_estimated_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

725: ELSE
726: l_estimated_start_date := p_estimated_start_date;
727: END IF;
728:
729: IF p_estimated_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
730: THEN
731: l_estimated_finish_date := null;
732: ELSE
733: l_estimated_finish_date := p_estimated_finish_date;

Line 736: IF p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

732: ELSE
733: l_estimated_finish_date := p_estimated_finish_date;
734: END IF;
735:
736: IF p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
737: p_actual_effort_this_period IS NOT NULL
738: THEN
739: l_actual_effort_this_period := p_actual_effort_this_period; -- This is incremental
740: ELSE

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

743:
744: -- 3958686, moved this code from below
745: --bug# 3764224 Changes for RLM start
746: -- Bug 3606627 Start
747: /*IF p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
748: p_resource_list_member_id IS NOT NULL
749: THEN
750: l_resource_list_member_id := p_resource_list_member_id;
751: ELSE

Line 755: IF p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

751: ELSE
752: l_resource_list_member_id := null;
753: END IF;*/
754:
755: IF p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
756: p_object_id IS NOT NULL
757: THEN
758: l_resource_list_member_id := p_object_id;
759: ELSE

Line 789: IF p_etc_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

785: */
786: --bug 3958686, end
787:
788:
789: IF p_etc_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
790: p_etc_effort_this_period IS NOT NULL AND l_est_remaining_eff_flag = 'Y' --For Bug 8887270
791: --p_actual_finish_date IS NULL AND p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE maansari4/27
792: THEN
793: l_etc_effort_this_period := p_etc_effort_this_period; -- This is cumulative

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

787:
788:
789: IF p_etc_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
790: p_etc_effort_this_period IS NOT NULL AND l_est_remaining_eff_flag = 'Y' --For Bug 8887270
791: --p_actual_finish_date IS NULL AND p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE maansari4/27
792: THEN
793: l_etc_effort_this_period := p_etc_effort_this_period; -- This is cumulative
794: ELSE
795: l_etc_effort_this_period := null;

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

809:
810:
811: --maansari 4/27
812: -- Bug 3956299 : As per discussion with Saima, ETC should be given precedence over act finish date
813: --IF p_actual_finish_date IS NOT NULL AND p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
814: --THEN
815: -- l_etc_effort_this_period := 0;
816: --END IF;
817: IF l_etc_effort_this_period IS NOT NULL AND l_etc_effort_this_period > 0

Line 825: IF p_txn_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND

821:
822: --maansari 4/27
823:
824:
825: IF p_txn_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
826: p_txn_currency_code IS NOT NULL
827: THEN
828: l_txn_currency_code := p_txn_currency_code;
829: ELSE

Line 833: IF p_rate_based_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND

829: ELSE
830: l_txn_currency_code := null;
831: END IF;
832:
833: IF p_rate_based_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
834: p_rate_based_flag IS NOT NULL
835: THEN
836: l_rate_based_flag := p_rate_based_flag;
837: ELSE

Line 841: IF p_resource_class_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND

837: ELSE
838: l_rate_based_flag := null;
839: END IF;
840:
841: IF p_resource_class_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
842: p_resource_class_code IS NOT NULL
843: THEN
844: l_resource_class_code := p_resource_class_code;
845: ELSE

Line 849: IF p_rbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

845: ELSE
846: l_resource_class_code := null;
847: END IF;
848:
849: IF p_rbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
850: p_rbs_element_id IS NOT NULL
851: THEN
852: l_rbs_element_id := p_rbs_element_id;
853: ELSE

Line 857: IF p_actual_cost <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

853: ELSE
854: l_rbs_element_id := null;
855: END IF;
856: -- Raw Cost Changes : Changed the vaiable names to include raw
857: IF p_actual_cost <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
858: p_actual_cost IS NOT NULL
859: THEN
860: l_actual_raw_cost := p_actual_cost;
861: ELSE

Line 865: IF p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

861: ELSE
862: l_actual_raw_cost := null;
863: END IF;
864: -- Raw Cost Changes : Changed the vaiable names to include raw
865: IF p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
866: p_actual_cost_this_period IS NOT NULL
867: THEN
868: l_actual_raw_cost_this_period := p_actual_cost_this_period;
869: ELSE

Line 886: IF p_actual_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

882: END IF;
883: */
884:
885:
886: IF p_actual_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
887: p_actual_effort IS NOT NULL
888: THEN
889: l_actual_effort := p_actual_effort;
890: ELSE

Line 894: IF p_etc_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

890: ELSE
891: l_actual_effort := null;
892: END IF;
893: -- Raw Cost Changes : Changed the vaiable names to include raw
894: IF p_etc_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
895: p_etc_cost_this_period IS NOT NULL
896: THEN
897: l_etc_raw_cost_this_period := p_etc_cost_this_period;
898: ELSE

Line 929: IF (p_etc_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

925: AND p_calling_module = 'AMG'
926: AND NVL(PA_FP_CALC_PLAN_PKG.g_is_wp_quantity_changed,'N') = 'N'
927: AND p_structure_type = 'WORKPLAN')
928: THEN
929: IF (p_etc_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
930: and p_etc_cost_this_period IS NOT NULL) OR
931: (p_etc_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
932: and p_etc_effort_this_period IS NOT NULL )
933: THEN

Line 931: (p_etc_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

927: AND p_structure_type = 'WORKPLAN')
928: THEN
929: IF (p_etc_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
930: and p_etc_cost_this_period IS NOT NULL) OR
931: (p_etc_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
932: and p_etc_effort_this_period IS NOT NULL )
933: THEN
934: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
935: ,p_msg_name => 'PA_WP_VD_CANT_UPDATE_ETC');

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

972: --- check if structure is shared and actuals are passed
973: /*l_structure_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_project_id);
974: IF l_structure_shared = 'Y'
975: THEN
976: IF (p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_cost_this_period >0)
977: OR (p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_effort_this_period >0)
978: THEN
979: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
980: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');

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

973: /*l_structure_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_project_id);
974: IF l_structure_shared = 'Y'
975: THEN
976: IF (p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_cost_this_period >0)
977: OR (p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_effort_this_period >0)
978: THEN
979: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
980: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');
981: x_msg_data := 'PA_TP_CANT_NTER_ACT_SHR_STR';

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

1012: END IF;
1013: ----- Wrong MODE
1014:
1015: ----- Invalid DATE
1016: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
1017: THEN
1018: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1019: ,p_msg_name => 'PA_TP_INV_AOD');
1020: x_msg_data := 'PA_TP_INV_AOD';

Line 1029: 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

1025:
1026:
1027: -- Bug 3979303 : Commentee code here and moved it below with some modification
1028: /*
1029: 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
1030: THEN
1031: IF (p_estimated_finish_date < p_estimated_start_date)
1032: THEN
1033: x_return_status := FND_API.G_RET_STS_ERROR;

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

1164: /* Currently the value of p_txn_currency_code is not passed to this API in the AMG flow.
1165: However, the following code will handle the case if the AMG flow is later modified to
1166: pass the value of p_txn_currency_code to this API. */
1167:
1168: IF (p_txn_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
1169:
1170: p_txn_currency_code IS NOT NULL)
1171:
1172: THEN

Line 1196: IF p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

1192: END IF;
1193: -- Bug 3979303 : End
1194:
1195:
1196: IF p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1197: THEN
1198: IF l_actual_raw_cost_this_period > 0 OR l_actual_effort_this_period > 0
1199: THEN
1200: l_actual_start_date := l_scheduled_start_date;

Line 1392: 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

1388: -- 4533112 End
1389:
1390:
1391:
1392: 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
1393: THEN
1394: IF l_actual_finish_date < l_actual_start_date
1395: THEN
1396: IF TRUNC(SYSDATE) < l_actual_start_date

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

1923:
1924: IF l_rate_based_flag = 'Y' --maansari7/6 bug 3742356
1925: THEN
1926:
1927: --IF p_actual_cost_this_period = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_actual_cost_this_period IS NULL
1928: --THEN --maansari4/10
1929: IF NVL(l_track_wp_cost_flag, 'Y') = 'Y' THEN -- Bug 3801745
1930:
1931: --maansari4/10

Line 2799: IF p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2795: --DEBUG_DJ('l_db_action ::'||l_db_action);
2796: IF l_db_action = 'CREATE'
2797: THEN
2798: /* FPM Dev CR 3
2799: IF p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2800: THEN
2801: l_percent_complete_id := null;
2802: ELSE
2803: l_percent_complete_id := p_percent_complete_id;

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

3189: -- Bug 3879461 : Temporary getting percent complete id and record version number from database
3190: -- So no locking.
3191: -- There is issue in UI, after calling API under Recalculate, it should incrment the VO record version number
3192:
3193: -- IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3194: -- THEN
3195: --DEBUG_DJ('Calling PA_PROGRESS_UTILS.get_ppc_id 3293');
3196: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(
3197: p_project_id => p_project_id

Line 3660: Pa_Interface_Utils_Pub.get_messages

3656: end if;
3657:
3658: IF l_msg_count = 1 AND x_msg_data IS NULL
3659: THEN
3660: Pa_Interface_Utils_Pub.get_messages
3661: ( p_encoded => Fnd_Api.G_TRUE
3662: , p_msg_index => 1
3663: , p_msg_count => l_msg_count
3664: , p_msg_data => l_msg_data