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 2486: PA_TASKS_MAINT_UTILS.CHECK_TASK_NUMBER_DISP(

2482: IF (substrb(p_task_number, 0, 25) <> TTASK_NUMBER) -- Added substrb for Bug#5968516
2483: AND (p_task_number IS NOT NULL) -- Bug 5968516
2484: AND (p_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 5968516
2485: THEN
2486: PA_TASKS_MAINT_UTILS.CHECK_TASK_NUMBER_DISP(
2487: p_project_id,
2488: p_task_id,
2489: p_task_number,
2490: l_rowid);

Line 2523: PA_TASKS_MAINT_UTILS.check_start_end_date(

2519: IF (p_task_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2520: p_task_start_date IS NULL) AND
2521: (p_task_completion_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2522: p_task_completion_date IS NULL) THEN
2523: PA_TASKS_MAINT_UTILS.check_start_end_date(
2524: p_old_start_date => null,
2525: p_old_end_date => null,
2526: p_new_start_date => p_task_start_date,
2527: p_new_end_date => p_task_completion_date,

Line 2559: PA_TASKS_MAINT_UTILS.Check_Start_Date(

2555: IF (p_task_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND
2556: nvl(p_task_start_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <>
2557: nvl(TSTART_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) ) -- Bug 6163119
2558: THEN
2559: PA_TASKS_MAINT_UTILS.Check_Start_Date(
2560: p_project_id => p_project_id,
2561: p_parent_task_id => TPARENT_TASK_ID,
2562: p_task_id => p_task_id, -- Bug 7386335
2563: p_start_date => p_task_start_date,

Line 2579: PA_TASKS_MAINT_UTILS.Check_Start_Date_EI(

2575: IF (p_task_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND
2576: nvl(p_task_start_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <>
2577: nvl(TSTART_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) ) -- Bug 6163119
2578: THEN
2579: PA_TASKS_MAINT_UTILS.Check_Start_Date_EI(
2580: p_project_id => p_project_id,
2581: p_task_id => p_task_id,
2582: p_start_date => p_task_start_date,
2583: x_return_status => l_ret,

Line 2617: PA_TASKS_MAINT_UTILS.Check_End_Date(

2613: nvl(p_task_completion_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <>
2614: nvl(TCOMPLETION_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) ) -- Bug 6163119
2615: THEN
2616:
2617: PA_TASKS_MAINT_UTILS.Check_End_Date(
2618: p_project_id => p_project_id,
2619: p_parent_task_id => TPARENT_TASK_ID,
2620: --p_task_id => NULL,
2621: p_task_id => p_task_id,--BUG 4081329, rtarway

Line 2639: PA_TASKS_MAINT_UTILS.Check_End_Date_EI(

2635: nvl(p_task_completion_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <>
2636: nvl(TCOMPLETION_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) ) -- Bug 6163119
2637: THEN
2638:
2639: PA_TASKS_MAINT_UTILS.Check_End_Date_EI(
2640: p_project_id => p_project_id,
2641: p_task_id => p_task_id,
2642: p_end_date => p_task_completion_date,
2643: x_return_status => l_ret,

Line 2657: PA_TASKS_MAINT_UTILS.CHECK_SCHEDULE_DATES(

2653: IF (p_scheduled_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2654: p_scheduled_start_date IS NULL) AND
2655: (p_scheduled_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2656: p_scheduled_finish_date IS NULL) THEN
2657: PA_TASKS_MAINT_UTILS.CHECK_SCHEDULE_DATES(
2658: p_project_id => p_project_id,
2659: p_sch_start_date => p_scheduled_start_date,
2660: p_sch_end_date => p_scheduled_finish_date,
2661: x_return_status => l_ret,

Line 2675: PA_TASKS_MAINT_UTILS.CHECK_ESTIMATE_DATES(

2671: IF (p_estimated_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2672: p_estimated_start_date IS NULL) AND
2673: (p_estimated_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2674: p_estimated_end_date IS NULL) THEN
2675: PA_TASKS_MAINT_UTILS.CHECK_ESTIMATE_DATES(
2676: p_project_id => p_project_id,
2677: p_estimate_start_date => p_estimated_start_date,
2678: p_estimate_end_date => p_estimated_end_date,
2679: x_return_status => l_ret,

Line 2694: PA_TASKS_MAINT_UTILS.CHECK_ACTUAL_DATES(

2690: IF (p_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2691: p_actual_start_date IS NULL) AND
2692: (p_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
2693: p_actual_finish_date IS NULL) THEN
2694: PA_TASKS_MAINT_UTILS.CHECK_ACTUAL_DATES(
2695: p_project_id => p_project_id,
2696: p_actual_start_date => p_actual_start_date,
2697: p_actual_end_date => p_actual_finish_date,
2698: x_return_status => l_ret,

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

2862:
2863: select project_type INTO TPROJECT_TYPE
2864: from pa_projects_all
2865: where project_id = p_project_id;
2866: PA_TASKS_MAINT_UTILS.Check_Chargeable_Flag( p_chargeable_flag => TCHARGEABLE,
2867: p_receive_project_invoice_flag => p_receive_project_invoice_flag,
2868: p_project_type => TPROJECT_TYPE,
2869: p_project_id => p_project_id, -- Added for bug#3512486
2870: x_receive_project_invoice_flag => TRECEIVE_PROJECT_INVOICE_FLAG);

Line 3678: PA_TASKS_MAINT_UTILS.GetWbsLevel(

3674: SAVEPOINT Edit_Structure;
3675: END IF;
3676: x_return_status := 'S';
3677:
3678: PA_TASKS_MAINT_UTILS.GetWbsLevel(
3679: p_project_id => p_project_id,
3680: p_task_id => p_task_id,
3681:
3682: x_task_level => l_task_level,

Line 4059: PA_TASKS_MAINT_UTILS.GetWbsLevel(

4055: SAVEPOINT Edit_Structure;
4056: END IF;
4057: x_return_status := 'S';
4058:
4059: PA_TASKS_MAINT_UTILS.GetWbsLevel(
4060: p_project_id => p_project_id,
4061: p_task_id => p_task_id,
4062:
4063: x_task_level => l_task_level,

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

4931: WHERE project_id = p_reference_project_id;
4932:
4933: UPDATE PA_TASKS
4934: SET display_sequence =
4935: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'INSERT', null),
4936: record_version_number = record_version_number + 1
4937: WHERE project_id = p_reference_project_id
4938: AND ( display_sequence > -( l_first_seq + 1 ) or display_sequence < 0 );
4939: EXCEPTION

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

5214: WHERE project_id = p_reference_project_id;
5215:
5216: UPDATE PA_TASKS
5217: SET display_sequence =
5218: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, 1, 'INSERT', null),
5219: record_version_number = record_version_number + 1
5220: WHERE project_id = p_reference_project_id
5221: AND ( display_sequence > -( l_display_seq + 1 ) or display_sequence < 0 );
5222: EXCEPTION

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

5594: WHERE project_id = p_reference_project_id;
5595:
5596: UPDATE PA_TASKS
5597: SET display_sequence =
5598: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'INSERT', null),
5599: record_version_number = record_version_number + 1
5600: WHERE project_id = p_reference_project_id
5601: AND ( display_sequence > -( l_first_seq + 1 ) or display_sequence < 0 );
5602: EXCEPTION

Line 5783: PA_TASKS_MAINT_UTILS.REF_PRJ_TASK_ID_REQ_CHECK(

5779:
5780: --dbms_output.put_line( 'In move task 0' );
5781:
5782: --Ref project and task id Required check.
5783: PA_TASKS_MAINT_UTILS.REF_PRJ_TASK_ID_REQ_CHECK(
5784: p_reference_project_id => p_reference_project_id,
5785: p_reference_task_id => p_reference_task_id,
5786: x_return_status => l_return_status,
5787: x_error_msg_code => l_error_msg_code );

Line 5801: PA_TASKS_MAINT_UTILS.SRC_PRJ_TASK_ID_REQ_CHECK(

5797:
5798: --dbms_output.put_line( 'In move task 1' );
5799:
5800: --project and task id Required check.
5801: PA_TASKS_MAINT_UTILS.SRC_PRJ_TASK_ID_REQ_CHECK(
5802: p_project_id => p_project_id,
5803: p_task_id => p_task_id,
5804: x_return_status => l_return_status,
5805: x_error_msg_code => l_error_msg_code );

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

6042: END IF;
6043:
6044: UPDATE PA_TASKS
6045: SET display_sequence =
6046: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'MOVE', l_move_direction ),
6047: record_version_number = record_version_number + 1
6048: WHERE project_id = p_reference_project_id
6049: AND ( ( display_sequence > l_min_display_sequence and
6050: display_sequence <= l_max_display_sequence ) or display_sequence < 0 );