DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PVT dependencies on PA_TASKS_MAINT_UTILS

Line 753: PA_TASKS_MAINT_UTILS.check_start_end_date(

749: IF (p_task_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
750: p_task_start_date IS NULL) AND
751: (p_task_completion_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
752: p_task_completion_date IS NULL) THEN
753: PA_TASKS_MAINT_UTILS.check_start_end_date(
754: p_old_start_date => null,
755: p_old_end_date => null,
756: p_new_start_date => p_task_start_date,
757: p_new_end_date => p_task_completion_date,

Line 1069: TADDRESS_ID := PA_TASKS_MAINT_UTILS.DEFAULT_ADDRESS_ID(p_project_id);

1065: ,TGEN_ETC_SOURCE_CODE
1066: ,Tnon_lab_std_bill_rt_Sch_id ; -- Bug 4963525
1067: CLOSE top_task;
1068:
1069: TADDRESS_ID := PA_TASKS_MAINT_UTILS.DEFAULT_ADDRESS_ID(p_project_id);
1070: l_parent_task_id := NULL;
1071: l_top_task_id := l_new_task_id;
1072: /*FPM development for Project Setup */
1073: IF l_project_type_class_code ='CONTRACT' THEN

Line 1096: PA_TASKS_MAINT_UTILS.Check_Start_Date(

1092:
1093: IF (p_calling_module IN ('FORMS', 'EXCHANGE', 'SELF_SERVICE')) THEN
1094: --Check Start Date
1095: IF (p_task_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
1096: PA_TASKS_MAINT_UTILS.Check_Start_Date(
1097: p_project_id => p_project_id,
1098: p_parent_task_id => l_parent_task_id,
1099: p_task_id => NULL,
1100: p_start_date => p_task_start_date,

Line 1113: PA_TASKS_MAINT_UTILS.Check_End_Date(

1109: l_msg_count := FND_MSG_PUB.count_msg;
1110:
1111: --Check Completion Date
1112: IF (p_task_completion_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
1113: PA_TASKS_MAINT_UTILS.Check_End_Date(
1114: p_project_id => p_project_id,
1115: p_parent_task_id => l_parent_task_id,
1116: p_task_id => NULL,
1117: p_end_date => p_task_completion_date,

Line 1139: -- PA_TASKS_MAINT_UTILS.CHECK_SCHEDULE_DATES(

1135: --IF (p_scheduled_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
1136: -- p_scheduled_start_date IS NULL) AND
1137: -- (p_scheduled_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
1138: -- p_scheduled_finish_date IS NULL) THEN
1139: -- PA_TASKS_MAINT_UTILS.CHECK_SCHEDULE_DATES(
1140: -- p_project_id => p_project_id,
1141: -- p_sch_start_date => p_scheduled_start_date,
1142: -- p_sch_end_date => p_scheduled_finish_date,
1143: -- x_return_status => l_ret,

Line 1161: -- PA_TASKS_MAINT_UTILS.CHECK_ESTIMATE_DATES(

1157: -- IF (p_estimated_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
1158: -- p_estimated_start_date IS NULL) AND
1159: -- (p_estimated_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
1160: -- p_estimated_end_date IS NULL) THEN
1161: -- PA_TASKS_MAINT_UTILS.CHECK_ESTIMATE_DATES(
1162: -- p_project_id => p_project_id,
1163: -- p_estimate_start_date => p_estimated_start_date,
1164: -- p_estimate_end_date => p_estimated_end_date,
1165: -- x_return_status => l_ret,

Line 1180: -- PA_TASKS_MAINT_UTILS.CHECK_ACTUAL_DATES(

1176: -- IF (p_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
1177: -- p_actual_start_date IS NULL) AND
1178: -- (p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
1179: -- p_actual_finish_date IS NULL) THEN
1180: -- PA_TASKS_MAINT_UTILS.CHECK_ACTUAL_DATES(
1181: -- p_project_id => p_project_id,
1182: -- p_actual_start_date => p_actual_start_date,
1183: -- p_actual_end_date => p_actual_finish_date,
1184: -- x_return_status => l_ret,

Line 1282: PA_TASKS_MAINT_UTILS.Check_Chargeable_Flag( p_chargeable_flag => TCHARGEABLE,

1278:
1279: -- Check Allow Charges
1280: --Chargeable flag, receive project invoice flag validation
1281: IF (p_receive_project_invoice_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1282: PA_TASKS_MAINT_UTILS.Check_Chargeable_Flag( p_chargeable_flag => TCHARGEABLE,
1283: p_receive_project_invoice_flag => p_receive_project_invoice_flag,
1284: p_project_type => TPROJECT_TYPE,
1285: p_project_id => p_project_id, -- Added for bug#3512486
1286: x_receive_project_invoice_flag => TRECEIVE_PROJECT_INVOICE_FLAG);

Line 1627: l_sequence_number := PA_TASKS_MAINT_UTILS.Get_Sequence_Number(p_peer_or_sub,

1623:
1624:
1625: IF p_reference_task_id IS NOT NULL --Modified by Ansari. Added logic to create top task.
1626: THEN
1627: l_sequence_number := PA_TASKS_MAINT_UTILS.Get_Sequence_Number(p_peer_or_sub,
1628: p_project_id,
1629: p_reference_task_id);
1630:
1631: --added by rtarway for BUG 3924597, etc sorce defaulting.

Line 2468: PA_TASKS_MAINT_UTILS.CHECK_TASK_NUMBER_DISP(

2464: IF (substrb(p_task_number, 0, 25) <> TTASK_NUMBER) -- Added substrb for Bug#5968516
2465: AND (p_task_number IS NOT NULL) -- Bug 5968516
2466: AND (p_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 5968516
2467: THEN
2468: PA_TASKS_MAINT_UTILS.CHECK_TASK_NUMBER_DISP(
2469: p_project_id,
2470: p_task_id,
2471: p_task_number,
2472: l_rowid);

Line 2505: PA_TASKS_MAINT_UTILS.check_start_end_date(

2501: IF (p_task_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2502: p_task_start_date IS NULL) AND
2503: (p_task_completion_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2504: p_task_completion_date IS NULL) THEN
2505: PA_TASKS_MAINT_UTILS.check_start_end_date(
2506: p_old_start_date => null,
2507: p_old_end_date => null,
2508: p_new_start_date => p_task_start_date,
2509: p_new_end_date => p_task_completion_date,

Line 2541: PA_TASKS_MAINT_UTILS.Check_Start_Date(

2537: IF (p_task_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND
2538: nvl(p_task_start_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <>
2539: nvl(TSTART_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) ) -- Bug 6163119
2540: THEN
2541: PA_TASKS_MAINT_UTILS.Check_Start_Date(
2542: p_project_id => p_project_id,
2543: p_parent_task_id => TPARENT_TASK_ID,
2544: p_task_id => p_task_id, -- Bug 7386335
2545: p_start_date => p_task_start_date,

Line 2561: PA_TASKS_MAINT_UTILS.Check_Start_Date_EI(

2557: IF (p_task_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND
2558: nvl(p_task_start_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <>
2559: nvl(TSTART_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) ) -- Bug 6163119
2560: THEN
2561: PA_TASKS_MAINT_UTILS.Check_Start_Date_EI(
2562: p_project_id => p_project_id,
2563: p_task_id => p_task_id,
2564: p_start_date => p_task_start_date,
2565: x_return_status => l_ret,

Line 2599: PA_TASKS_MAINT_UTILS.Check_End_Date(

2595: nvl(p_task_completion_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <>
2596: nvl(TCOMPLETION_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) ) -- Bug 6163119
2597: THEN
2598:
2599: PA_TASKS_MAINT_UTILS.Check_End_Date(
2600: p_project_id => p_project_id,
2601: p_parent_task_id => TPARENT_TASK_ID,
2602: --p_task_id => NULL,
2603: p_task_id => p_task_id,--BUG 4081329, rtarway

Line 2621: PA_TASKS_MAINT_UTILS.Check_End_Date_EI(

2617: nvl(p_task_completion_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <>
2618: nvl(TCOMPLETION_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) ) -- Bug 6163119
2619: THEN
2620:
2621: PA_TASKS_MAINT_UTILS.Check_End_Date_EI(
2622: p_project_id => p_project_id,
2623: p_task_id => p_task_id,
2624: p_end_date => p_task_completion_date,
2625: x_return_status => l_ret,

Line 2639: PA_TASKS_MAINT_UTILS.CHECK_SCHEDULE_DATES(

2635: IF (p_scheduled_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2636: p_scheduled_start_date IS NULL) AND
2637: (p_scheduled_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2638: p_scheduled_finish_date IS NULL) THEN
2639: PA_TASKS_MAINT_UTILS.CHECK_SCHEDULE_DATES(
2640: p_project_id => p_project_id,
2641: p_sch_start_date => p_scheduled_start_date,
2642: p_sch_end_date => p_scheduled_finish_date,
2643: x_return_status => l_ret,

Line 2657: PA_TASKS_MAINT_UTILS.CHECK_ESTIMATE_DATES(

2653: IF (p_estimated_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2654: p_estimated_start_date IS NULL) AND
2655: (p_estimated_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2656: p_estimated_end_date IS NULL) THEN
2657: PA_TASKS_MAINT_UTILS.CHECK_ESTIMATE_DATES(
2658: p_project_id => p_project_id,
2659: p_estimate_start_date => p_estimated_start_date,
2660: p_estimate_end_date => p_estimated_end_date,
2661: x_return_status => l_ret,

Line 2676: PA_TASKS_MAINT_UTILS.CHECK_ACTUAL_DATES(

2672: IF (p_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2673: p_actual_start_date IS NULL) AND
2674: (p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2675: p_actual_finish_date IS NULL) THEN
2676: PA_TASKS_MAINT_UTILS.CHECK_ACTUAL_DATES(
2677: p_project_id => p_project_id,
2678: p_actual_start_date => p_actual_start_date,
2679: p_actual_end_date => p_actual_finish_date,
2680: x_return_status => l_ret,

Line 2848: PA_TASKS_MAINT_UTILS.Check_Chargeable_Flag( p_chargeable_flag => TCHARGEABLE,

2844:
2845: select project_type INTO TPROJECT_TYPE
2846: from pa_projects_all
2847: where project_id = p_project_id;
2848: PA_TASKS_MAINT_UTILS.Check_Chargeable_Flag( p_chargeable_flag => TCHARGEABLE,
2849: p_receive_project_invoice_flag => p_receive_project_invoice_flag,
2850: p_project_type => TPROJECT_TYPE,
2851: p_project_id => p_project_id, -- Added for bug#3512486
2852: x_receive_project_invoice_flag => TRECEIVE_PROJECT_INVOICE_FLAG);

Line 3660: PA_TASKS_MAINT_UTILS.GetWbsLevel(

3656: SAVEPOINT Edit_Structure;
3657: END IF;
3658: x_return_status := 'S';
3659:
3660: PA_TASKS_MAINT_UTILS.GetWbsLevel(
3661: p_project_id => p_project_id,
3662: p_task_id => p_task_id,
3663:
3664: x_task_level => l_task_level,

Line 4041: PA_TASKS_MAINT_UTILS.GetWbsLevel(

4037: SAVEPOINT Edit_Structure;
4038: END IF;
4039: x_return_status := 'S';
4040:
4041: PA_TASKS_MAINT_UTILS.GetWbsLevel(
4042: p_project_id => p_project_id,
4043: p_task_id => p_task_id,
4044:
4045: x_task_level => l_task_level,

Line 4915: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'INSERT', null),

4911: WHERE project_id = p_reference_project_id;
4912:
4913: UPDATE PA_TASKS
4914: SET display_sequence =
4915: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'INSERT', null),
4916: record_version_number = record_version_number + 1
4917: WHERE project_id = p_reference_project_id
4918: AND ( display_sequence > -( l_first_seq + 1 ) or display_sequence < 0 );
4919: EXCEPTION

Line 5196: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, 1, 'INSERT', null),

5192: WHERE project_id = p_reference_project_id;
5193:
5194: UPDATE PA_TASKS
5195: SET display_sequence =
5196: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, 1, 'INSERT', null),
5197: record_version_number = record_version_number + 1
5198: WHERE project_id = p_reference_project_id
5199: AND ( display_sequence > -( l_display_seq + 1 ) or display_sequence < 0 );
5200: EXCEPTION

Line 5574: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'INSERT', null),

5570: WHERE project_id = p_reference_project_id;
5571:
5572: UPDATE PA_TASKS
5573: SET display_sequence =
5574: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'INSERT', null),
5575: record_version_number = record_version_number + 1
5576: WHERE project_id = p_reference_project_id
5577: AND ( display_sequence > -( l_first_seq + 1 ) or display_sequence < 0 );
5578: EXCEPTION

Line 5749: PA_TASKS_MAINT_UTILS.REF_PRJ_TASK_ID_REQ_CHECK(

5745:
5746: --dbms_output.put_line( 'In move task 0' );
5747:
5748: --Ref project and task id Required check.
5749: PA_TASKS_MAINT_UTILS.REF_PRJ_TASK_ID_REQ_CHECK(
5750: p_reference_project_id => p_reference_project_id,
5751: p_reference_task_id => p_reference_task_id,
5752: x_return_status => l_return_status,
5753: x_error_msg_code => l_error_msg_code );

Line 5767: PA_TASKS_MAINT_UTILS.SRC_PRJ_TASK_ID_REQ_CHECK(

5763:
5764: --dbms_output.put_line( 'In move task 1' );
5765:
5766: --project and task id Required check.
5767: PA_TASKS_MAINT_UTILS.SRC_PRJ_TASK_ID_REQ_CHECK(
5768: p_project_id => p_project_id,
5769: p_task_id => p_task_id,
5770: x_return_status => l_return_status,
5771: x_error_msg_code => l_error_msg_code );

Line 5996: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'MOVE', l_move_direction ),

5992: END IF;
5993:
5994: UPDATE PA_TASKS
5995: SET display_sequence =
5996: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'MOVE', l_move_direction ),
5997: record_version_number = record_version_number + 1
5998: WHERE project_id = p_reference_project_id
5999: AND ( ( display_sequence > l_min_display_sequence and
6000: display_sequence <= l_max_display_sequence ) or display_sequence < 0 );