[Home] [Help]
72: FETCH l_amg_project_csr INTO l_amg_segment1;
73: CLOSE l_amg_project_csr;
74:
75: -- check whether task number is changing
76: IF p_in_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
77: p_in_task_number IS NULL THEN
78: RETURN;
79: END IF;
80:
140: -- It is getting changed to 2.3. There is already a task
141: -- in the database with task number = 2.3. Unless, this
142: -- is getting changed to something else, we cannot update
143: -- 2.1 to 2.3
144: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
145: (p_task_number=> p_in_task_tbl(i).task_name
146: ,p_task_reference => p_in_task_tbl(i).pm_task_reference
147: ,p_task_id => l_task_id);
148:
147: ,p_task_id => l_task_id);
148:
149: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
150: THEN
151: pa_interface_utils_pub.map_new_amg_msg
152: ( p_old_message_code => 'PA_TASK_NUMBER_NOT_UNIQUE'
153: ,p_msg_attribute => 'CHANGE'
154: ,p_resize_flag => 'N'
155: ,p_msg_context => 'TASK'
172: WHILE cnt = 0 LOOP -- if no rows updated then loop
173: k := k+1;
174: BEGIN
175: UPDATE pa_proj_elements
176: SET element_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR || TO_CHAR(k)
177: WHERE proj_element_id = l_task_id;
178: cnt := SQL%ROWCOUNT;
179: EXIT;
180: EXCEPTION
839: ,p_task_name IN VARCHAR2
840: ,p_task_description IN VARCHAR2
841: ,p_carrying_out_organization_id IN NUMBER
842: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
843: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
844: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
845: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
846: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
847: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
840: ,p_task_description IN VARCHAR2
841: ,p_carrying_out_organization_id IN NUMBER
842: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
843: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
844: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
845: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
846: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
847: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
848: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
841: ,p_carrying_out_organization_id IN NUMBER
842: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
843: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
844: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
845: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
846: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
847: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
848: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
849: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
842: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
843: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
844: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
845: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
846: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
847: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
848: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
849: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
850: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
843: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
844: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
845: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
846: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
847: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
848: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
849: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
850: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
851: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
844: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
845: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
846: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
847: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
848: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
849: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
850: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
851: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
852: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
845: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
846: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
847: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
848: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
849: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
850: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
851: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
852: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
853: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
846: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
847: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
848: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
849: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
850: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
851: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
852: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
853: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
854: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
847: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
848: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
849: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
850: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
851: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
852: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
853: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
854: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
855: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
848: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
849: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
850: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
851: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
852: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
853: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
854: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
855: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
856: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
849: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
850: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
851: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
852: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
853: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
854: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
855: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
856: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
857: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
850: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
851: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
852: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
853: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
854: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
855: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
856: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
857: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
858: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
851: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
852: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
853: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
854: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
855: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
856: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
857: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
858: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
859: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
852: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
853: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
854: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
855: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
856: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
857: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
858: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
859: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
860: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
853: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
854: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
855: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
856: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
857: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
858: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
859: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
860: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
861: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
854: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
855: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
856: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
857: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
858: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
859: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
860: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
861: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
862: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
855: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
856: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
857: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
858: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
859: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
860: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
861: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
862: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
863: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
856: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
857: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
858: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
859: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
860: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
861: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
862: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
863: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
864: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
857: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
858: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
859: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
860: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
861: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
862: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
863: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
864: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
865: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
858: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
859: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
860: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
861: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
862: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
863: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
864: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
865: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
866: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
859: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
860: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
861: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
862: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
863: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
864: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
865: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
866: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
867: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
860: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
861: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
862: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
863: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
864: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
865: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
866: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
867: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
868: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
861: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
862: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
863: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
864: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
865: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
866: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
867: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
868: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
869: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
862: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
863: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
864: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
865: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
866: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
867: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
868: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
869: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
870: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
863: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
864: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
865: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
866: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
867: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
868: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
869: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
870: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
864: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
865: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
866: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
867: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
868: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
869: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
870: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
872: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
865: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
866: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
867: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
868: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
869: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
870: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
872: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
873: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
866: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
867: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
868: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
869: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
870: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
872: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
873: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
874: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
867: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
868: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
869: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
870: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
872: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
873: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
874: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
875: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
868: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
869: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
870: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
872: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
873: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
874: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
875: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
876: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
869: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
870: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
872: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
873: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
874: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
875: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
876: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
877: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
870: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
872: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
873: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
874: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
875: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
876: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
877: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
878: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
872: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
873: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
874: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
875: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
876: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
877: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
878: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
879: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
872: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
873: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
874: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
875: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
876: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
877: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
878: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
879: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
880: ,p_create_task_version_only IN VARCHAR2 := 'N'
873: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
874: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
875: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
876: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
877: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
878: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
879: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
880: ,p_create_task_version_only IN VARCHAR2 := 'N'
881: ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
874: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
875: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
876: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
877: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
878: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
879: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
880: ,p_create_task_version_only IN VARCHAR2 := 'N'
881: ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
882:
875: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
876: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
877: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
878: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
879: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
880: ,p_create_task_version_only IN VARCHAR2 := 'N'
881: ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
882:
883: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
880: ,p_create_task_version_only IN VARCHAR2 := 'N'
881: ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
882:
883: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
884: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
885: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
886: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
887: -- (end venkat) new params for bug #3450684 -------------------------------------------------
888:
881: ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
882:
883: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
884: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
885: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
886: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
887: -- (end venkat) new params for bug #3450684 -------------------------------------------------
888:
889: -- (begin) add new params bug - 3654243 -----
882:
883: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
884: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
885: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
886: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
887: -- (end venkat) new params for bug #3450684 -------------------------------------------------
888:
889: -- (begin) add new params bug - 3654243 -----
890: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
886: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
887: -- (end venkat) new params for bug #3450684 -------------------------------------------------
888:
889: -- (begin) add new params bug - 3654243 -----
890: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
891: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
892: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
893: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
894: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
887: -- (end venkat) new params for bug #3450684 -------------------------------------------------
888:
889: -- (begin) add new params bug - 3654243 -----
890: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
891: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
892: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
893: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
894: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
895: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
888:
889: -- (begin) add new params bug - 3654243 -----
890: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
891: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
892: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
893: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
894: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
895: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
896: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
889: -- (begin) add new params bug - 3654243 -----
890: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
891: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
892: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
893: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
894: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
895: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
896: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
897: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
890: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
891: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
892: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
893: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
894: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
895: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
896: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
897: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
898: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
891: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
892: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
893: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
894: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
895: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
896: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
897: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
898: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
899: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
892: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
893: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
894: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
895: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
896: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
897: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
898: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
899: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
900: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
893: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
894: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
895: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
896: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
897: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
898: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
899: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
900: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
901: -- (end) add new params bug - 3654243 -----
894: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
895: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
896: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
897: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
898: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
899: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
900: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
901: -- (end) add new params bug - 3654243 -----
902:
895: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
896: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
897: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
898: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
899: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
900: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
901: -- (end) add new params bug - 3654243 -----
902:
903: --Bug 6153503
896: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
897: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
898: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
899: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
900: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
901: -- (end) add new params bug - 3654243 -----
902:
903: --Bug 6153503
904: ,p_validate_dff IN VARCHAR2 := 'N'
901: -- (end) add new params bug - 3654243 -----
902:
903: --Bug 6153503
904: ,p_validate_dff IN VARCHAR2 := 'N'
905: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
906: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
907: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
908: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
909: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
902:
903: --Bug 6153503
904: ,p_validate_dff IN VARCHAR2 := 'N'
905: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
906: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
907: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
908: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
909: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
910: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
903: --Bug 6153503
904: ,p_validate_dff IN VARCHAR2 := 'N'
905: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
906: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
907: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
908: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
909: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
910: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
911: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
904: ,p_validate_dff IN VARCHAR2 := 'N'
905: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
906: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
907: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
908: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
909: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
910: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
911: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
912: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
905: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
906: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
907: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
908: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
909: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
910: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
911: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
912: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
906: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
907: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
908: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
909: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
910: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
911: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
912: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
907: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
908: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
909: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
910: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
911: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
912: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
908: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
909: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
910: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
911: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
912: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
909: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
910: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
911: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
912: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
910: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
911: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
912: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
911: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
912: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
919: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
912: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
919: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
920: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
919: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
920: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
921: --Bug 6153503
914: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
915: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
919: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
920: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
921: --Bug 6153503
922:
915: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
919: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
920: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
921: --Bug 6153503
922:
923: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
916: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
917: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
918: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
919: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
920: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
921: --Bug 6153503
922:
923: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
924: ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1273:
1274: l_versioned := PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id);
1275: l_shared := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
1276:
1277: IF p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1278: THEN
1279: l_task_id := p_task_id;
1280: ELSE
1281: l_task_id := null;
1283:
1284: IF p_structure_type = 'WORKPLAN'
1285: THEN
1286: --The following logic found in add_task_round_one api
1287: IF p_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_task_number IS NULL
1288: THEN
1289: l_task_number := P_PM_SOURCE_reference;
1290: ELSE
1291: l_task_number := p_task_number;
1306: END IF;
1307: --
1308:
1309: IF p_structure_version_id IS NULL OR
1310: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1311: THEN
1312: --proj conn
1313: --If auto publish upon creation is on and versioning is enabled then
1314: --update the workplan structure as working bcoz it is created as pub by copy structure.
1373: END IF;
1374: --
1375:
1376: IF p_structure_version_id IS NULL OR
1377: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1378: THEN
1379: IF l_template_flag = 'N'
1380: THEN
1381:
1416: will be null in this case. If a structure version is in approved, submitted or rejected state, then it
1417: will never be returned from cursor cur_struc_ver_wp, so how can we get the status of a null struc ver.
1418:
1419: IF p_structure_version_id IS NOT NULL AND
1420: p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1421: THEN
1422: --Validate the incoming structure version id
1423:
1424: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id(
1458: ***/
1459:
1460: /* New Code Begin for Bug 2736392 -- Commnted the above code*/
1461:
1462: IF p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1463: THEN
1464: l_str_status_code := PA_PROJECT_STRUCTURE_UTILS.get_structrue_version_status
1465: ( p_project_id => p_project_id
1466: ,p_structure_version_id => p_structure_version_id );
1638: --ref task version id. There is only one cursor cur_proj_elem_vers that takes structure type
1639: /* ELSIF p_structure_type = 'WORKPLAN'
1640: THEN
1641: IF p_parent_task_id IS NOT NULL AND p_parent_task_id <> l_task_id AND
1642: p_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1643: THEN
1644: l_peer_or_sub := 'SUB';
1645: --get reference task version id
1646: OPEN cur_proj_elem_vers2( l_structure_version_id, p_parent_task_id );
1666: and proj_element_id = p_parent_task_id;
1667: END IF;
1668: --Bug 2732907
1669:
1670: ELSIF ( p_parent_task_id IS NULL OR p_parent_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1671: --proj conn
1672: AND ( p_ref_task_id is null OR p_ref_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
1673: --proj conn
1674: THEN
1668: --Bug 2732907
1669:
1670: ELSIF ( p_parent_task_id IS NULL OR p_parent_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1671: --proj conn
1672: AND ( p_ref_task_id is null OR p_ref_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
1673: --proj conn
1674: THEN
1675: --get structure version if its a top task
1676: l_ref_task_version_id := l_structure_version_id;
1686:
1687: l_peer_or_sub := 'SUB';
1688: */
1689: /*IF p_structure_version_id IS NULL OR
1690: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1691: THEN
1692: OPEN cur_struc_ver_wp;
1693: FETCH cur_struc_ver_wp INTO l_ref_task_version_id;
1694: CLOSE cur_struc_ver_wp;
1695: ELSE
1696: l_ref_task_version_id := p_structure_version_id;
1697: END IF;
1698: */
1699: /* ELSIF p_ref_task_id IS NOT NULL AND p_ref_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1700: THEN
1701: l_weighting := 0;
1702: OPEN cur_proj_elem_vers2( l_structure_version_id, p_ref_task_id );
1703: FETCH cur_proj_elem_vers2 INTO l_ref_task_version_id;
1933: FETCH cur_ver_sch_attr_rec INTO l_ver_sch_attr_rec;
1934: CLOSE cur_ver_sch_attr_rec;
1935:
1936: --hsiu: added for bug 2691868
1937: IF (p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
1938: l_scheduled_start_date := sysdate;
1939: ELSE
1940: l_scheduled_start_date := p_scheduled_start_date;
1941: END IF;
1939: ELSE
1940: l_scheduled_start_date := p_scheduled_start_date;
1941: END IF;
1942:
1943: IF (p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
1944: l_scheduled_finish_date := sysdate;
1945: ELSE
1946: l_scheduled_finish_date := p_scheduled_finish_date;
1947: END IF;
1956: */
1957:
1958: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
1959: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
1960: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN
1961: l_wq_planned_quantity := NULL;
1962: END IF;
1963: ELSE
1964: l_wq_planned_quantity := P_PLANNED_WORK_QUANTITY; --bug 2826992
1968: --bug 2824612
1969:
1970: --Bug 6153503 start
1971: if (--p_attribute_category is null or
1972: p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1973: then
1974: l_attribute_category := l_ver_sch_attr_rec.attribute_category;
1975: else
1976: l_attribute_category := p_attribute_category;
1978:
1979:
1980:
1981: if (--p_attribute1 is null or
1982: p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1983: then
1984: l_attribute1 := l_ver_sch_attr_rec.attribute1;
1985: else
1986: l_attribute1 := p_attribute1;
1988:
1989:
1990:
1991: if (--p_attribute2 is null or
1992: p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1993: then
1994: l_attribute2 := l_ver_sch_attr_rec.attribute2;
1995: else
1996: l_attribute2 := p_attribute2;
1997: end if;
1998:
1999:
2000: if (--p_attribute3 is null or
2001: p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2002: then
2003: l_attribute3 := l_ver_sch_attr_rec.attribute3;
2004: else
2005: l_attribute3 := p_attribute3;
2005: l_attribute3 := p_attribute3;
2006: end if;
2007:
2008: if (--p_attribute4 is null or
2009: p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2010: then
2011: l_attribute4 := l_ver_sch_attr_rec.attribute4;
2012: else
2013: l_attribute4 := p_attribute4;
2013: l_attribute4 := p_attribute4;
2014: end if;
2015:
2016: if (--p_attribute5 is null or
2017: p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2018: then
2019: l_attribute5 := l_ver_sch_attr_rec.attribute5;
2020: else
2021: l_attribute5 := p_attribute5;
2021: l_attribute5 := p_attribute5;
2022: end if;
2023:
2024: if (--p_attribute6 is null or
2025: p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2026: then
2027: l_attribute6 := l_ver_sch_attr_rec.attribute6;
2028: else
2029: l_attribute6 := p_attribute6;
2029: l_attribute6 := p_attribute6;
2030: end if;
2031:
2032: if (--p_attribute7 is null or
2033: p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Changed for Bug #6153681
2034: then
2035: l_attribute7 := l_ver_sch_attr_rec.attribute7;
2036: else
2037: l_attribute7 := p_attribute7;
2037: l_attribute7 := p_attribute7;
2038: end if;
2039:
2040: if (--p_attribute8 is null or
2041: p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2042: then
2043: l_attribute8 := l_ver_sch_attr_rec.attribute8;
2044: else
2045: l_attribute8 := p_attribute8;
2045: l_attribute8 := p_attribute8;
2046: end if;
2047:
2048: if (--p_attribute9 is null or
2049: p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2050: then
2051: l_attribute9 := l_ver_sch_attr_rec.attribute9;
2052: else
2053: l_attribute9 := p_attribute9;
2053: l_attribute9 := p_attribute9;
2054: end if;
2055:
2056: if (--p_attribute10 is null or
2057: p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2058: then
2059: l_attribute10 := l_ver_sch_attr_rec.attribute10;
2060: else
2061: l_attribute10 := p_attribute10;
2061: l_attribute10 := p_attribute10;
2062: end if;
2063:
2064: if (--p_attribute10 is null or
2065: p_attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2066: then
2067: l_attribute11 := l_ver_sch_attr_rec.attribute11;
2068: else
2069: l_attribute11 := p_attribute11;
2069: l_attribute11 := p_attribute11;
2070: end if;
2071:
2072: if (--p_attribute10 is null or
2073: p_attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2074: then
2075: l_attribute12 := l_ver_sch_attr_rec.attribute12;
2076: else
2077: l_attribute12 := p_attribute12;
2077: l_attribute12 := p_attribute12;
2078: end if;
2079:
2080: if (--p_attribute10 is null or
2081: p_attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2082: then
2083: l_attribute13 := l_ver_sch_attr_rec.attribute13;
2084: else
2085: l_attribute13 := p_attribute13;
2085: l_attribute13 := p_attribute13;
2086: end if;
2087:
2088: if (--p_attribute10 is null or
2089: p_attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2090: then
2091: l_attribute14 := l_ver_sch_attr_rec.attribute14;
2092: else
2093: l_attribute14 := p_attribute14;
2094: end if;
2095:
2096:
2097: if (--p_attribute10 is null or
2098: p_attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2099: then
2100: l_attribute15 := l_ver_sch_attr_rec.attribute15;
2101: else
2102: l_attribute15 := p_attribute15;
2103: end if;
2104:
2105: --if added while fixing BUG 3919800
2106: --Add validation for PA_PROJ_ELEM_VER_SCH_DESC_FLEX
2107: --if l_attribute_category is not null and l_attribute_category <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2108: --then
2109: IF p_validate_dff = 'Y' THEN
2110: pa_task_utils.validate_flex_fields(
2111: p_desc_flex_name => 'PA_PROJ_ELEM_VER_SCH_DESC_FLEX'
2134: IF l_validate_status = 'N'
2135: THEN
2136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2137: THEN
2138: pa_interface_utils_pub.map_new_amg_msg
2139: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
2140: ,p_msg_attribute => 'CHANGE'
2141: ,p_resize_flag => 'N'
2142: ,p_msg_context => 'FLEX'
2383: ,p_task_manager_id IN NUMBER
2384: ,p_pm_product_code IN VARCHAR2
2385: ,p_pm_task_reference IN VARCHAR2
2386: ,p_location_id IN NUMBER
2387: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2388: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2389: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2390: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2391: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2384: ,p_pm_product_code IN VARCHAR2
2385: ,p_pm_task_reference IN VARCHAR2
2386: ,p_location_id IN NUMBER
2387: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2388: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2389: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2390: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2391: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2392: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2385: ,p_pm_task_reference IN VARCHAR2
2386: ,p_location_id IN NUMBER
2387: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2388: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2389: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2390: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2391: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2392: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2393: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2386: ,p_location_id IN NUMBER
2387: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2388: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2389: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2390: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2391: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2392: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2393: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2394: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2387: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2388: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2389: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2390: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2391: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2392: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2393: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2394: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2395: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2388: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2389: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2390: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2391: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2392: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2393: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2394: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2395: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2396: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2389: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2390: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2391: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2392: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2393: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2394: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2395: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2396: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2397: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2390: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2391: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2392: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2393: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2394: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2395: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2396: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2397: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2398: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2391: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2392: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2393: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2394: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2395: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2396: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2397: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2398: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2399: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2392: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2393: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2394: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2395: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2396: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2397: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2398: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2399: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2400: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2393: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2394: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2395: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2396: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2397: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2398: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2399: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2400: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2401: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2394: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2395: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2396: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2397: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2398: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2399: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2400: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2401: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2402: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2395: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2396: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2397: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2398: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2399: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2400: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2401: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2402: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2403: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2396: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2397: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2398: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2399: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2400: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2401: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2402: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2403: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2404: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2397: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2398: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2399: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2400: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2401: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2402: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2403: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2404: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2405: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2398: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2399: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2400: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2401: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2402: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2403: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2404: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2405: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2406: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2399: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2400: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2401: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2402: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2403: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2404: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2405: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2406: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2407: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2400: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2401: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2402: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2403: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2404: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2405: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2406: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2407: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2408: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2401: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2402: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2403: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2404: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2405: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2406: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2407: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2408: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2409: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2402: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2403: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2404: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2405: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2406: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2407: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2408: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2409: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2410: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2403: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2404: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2405: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2406: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2407: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2408: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2409: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2410: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2411: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2404: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2405: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2406: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2407: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2408: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2409: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2410: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2411: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2412: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2405: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2406: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2407: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2408: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2409: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2410: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2411: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2412: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2413: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2406: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2407: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2408: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2409: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2410: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2411: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2412: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2413: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2414: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2407: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2408: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2409: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2410: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2411: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2412: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2413: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2414: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2415: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2408: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2409: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2410: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2411: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2412: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2413: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2414: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2415: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2416: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2409: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2410: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2411: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2412: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2413: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2414: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2415: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2416: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2417: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2410: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2411: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2412: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2413: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2414: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2415: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2416: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2417: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2418: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2411: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2412: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2413: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2414: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2415: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2416: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2417: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2418: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2419: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2412: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2413: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2414: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2415: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2416: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2417: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2418: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2419: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2420: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2413: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2414: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2415: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2416: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2417: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2418: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2419: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2420: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2421: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2414: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2415: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2416: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2417: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2418: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2419: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2420: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2421: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2422: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2415: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2416: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2417: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2418: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2419: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2420: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2421: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2422: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2423: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2417: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2418: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2419: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2420: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2421: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2422: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2423: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2424: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2425: -- (begin) add new params bug - 3654243 -----
2418: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2419: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2420: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2421: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2422: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2423: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2424: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2425: -- (begin) add new params bug - 3654243 -----
2426: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2419: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2420: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2421: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2422: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2423: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2424: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2425: -- (begin) add new params bug - 3654243 -----
2426: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2427: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2422: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2423: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2424: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2425: -- (begin) add new params bug - 3654243 -----
2426: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2427: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2428: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2429: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2430: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2423: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2424: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2425: -- (begin) add new params bug - 3654243 -----
2426: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2427: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2428: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2429: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2430: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2431: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2424: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2425: -- (begin) add new params bug - 3654243 -----
2426: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2427: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2428: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2429: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2430: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2431: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2432: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2425: -- (begin) add new params bug - 3654243 -----
2426: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2427: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2428: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2429: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2430: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2431: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2432: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2433: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2426: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2427: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2428: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2429: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2430: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2431: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2432: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2433: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2434: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2427: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2428: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2429: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2430: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2431: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2432: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2433: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2434: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2435: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2428: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2429: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2430: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2431: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2432: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2433: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2434: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2435: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2436: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2429: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2430: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2431: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2432: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2433: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2434: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2435: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2436: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2437: -- (end) add new params bug - 3654243 -----
2430: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2431: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2432: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2433: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2434: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2435: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2436: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2437: -- (end) add new params bug - 3654243 -----
2438: -- Progress Management Changes. Bug # 3420093.
2431: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2432: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2433: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2434: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2435: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2436: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2437: -- (end) add new params bug - 3654243 -----
2438: -- Progress Management Changes. Bug # 3420093.
2439: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2432: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2433: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2434: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2435: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2436: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2437: -- (end) add new params bug - 3654243 -----
2438: -- Progress Management Changes. Bug # 3420093.
2439: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2440: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2435: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2436: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2437: -- (end) add new params bug - 3654243 -----
2438: -- Progress Management Changes. Bug # 3420093.
2439: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2440: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2441: -- Progress Management Changes. Bug # 3420093.
2442: -- rtarway, BUG 3908013
2443: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2436: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2437: -- (end) add new params bug - 3654243 -----
2438: -- Progress Management Changes. Bug # 3420093.
2439: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2440: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2441: -- Progress Management Changes. Bug # 3420093.
2442: -- rtarway, BUG 3908013
2443: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2444: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2439: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2440: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2441: -- Progress Management Changes. Bug # 3420093.
2442: -- rtarway, BUG 3908013
2443: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2444: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2445: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2446: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2447: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2440: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2441: -- Progress Management Changes. Bug # 3420093.
2442: -- rtarway, BUG 3908013
2443: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2444: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2445: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2446: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2447: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2448: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2441: -- Progress Management Changes. Bug # 3420093.
2442: -- rtarway, BUG 3908013
2443: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2444: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2445: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2446: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2447: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2448: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2449: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2442: -- rtarway, BUG 3908013
2443: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2444: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2445: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2446: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2447: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2448: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2449: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2450: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2443: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2444: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2445: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2446: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2447: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2448: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2449: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2450: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2451: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2444: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2445: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2446: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2447: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2448: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2449: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2450: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2451: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2452: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2445: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2446: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2447: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2448: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2449: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2450: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2451: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2452: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2453: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2446: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2447: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2448: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2449: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2450: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2451: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2452: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2453: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2454: --Bug 6153503
2447: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2448: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2449: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2450: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2451: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2452: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2453: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2454: --Bug 6153503
2455: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2448: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2449: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2450: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2451: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2452: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2453: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2454: --Bug 6153503
2455: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2456: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2449: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2450: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2451: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2452: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2453: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2454: --Bug 6153503
2455: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2456: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2457: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2451: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2452: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2453: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2454: --Bug 6153503
2455: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2456: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2457: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2458: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2459: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2452: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2453: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2454: --Bug 6153503
2455: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2456: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2457: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2458: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2459: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2460: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Added for Huawei 15876400
2453: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2454: --Bug 6153503
2455: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2456: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2457: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2458: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2459: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2460: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Added for Huawei 15876400
2461: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2454: --Bug 6153503
2455: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2456: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2457: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2458: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2459: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2460: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Added for Huawei 15876400
2461: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2462: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2455: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2456: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2457: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2458: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2459: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2460: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Added for Huawei 15876400
2461: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2462: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2463: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2456: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2457: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2458: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2459: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2460: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Added for Huawei 15876400
2461: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2462: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2463: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2464: ) IS
2783: CLOSE cur_task_attr;
2784: --dbms_output.put_line(('Value of p_task_number' ||p_task_number);
2785: --dbms_output.put_line(('Value of l_task_number' ||l_task_number);
2786:
2787: IF ( p_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_task_number IS NOT NULL)
2788: /* bug#5243018 : Reverting the fix in Bug 4120380
2789: AND nvl(p_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
2790: nvl(l_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) --check added for BUg 4120380 Aditi */
2791: THEN
2785: --dbms_output.put_line(('Value of l_task_number' ||l_task_number);
2786:
2787: IF ( p_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_task_number IS NOT NULL)
2788: /* bug#5243018 : Reverting the fix in Bug 4120380
2789: AND nvl(p_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
2790: nvl(l_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) --check added for BUg 4120380 Aditi */
2791: THEN
2792: l_task_number := p_task_number;
2793: /* bug#5243018 : Reverting the fix in Bug 4120380
2786:
2787: IF ( p_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_task_number IS NOT NULL)
2788: /* bug#5243018 : Reverting the fix in Bug 4120380
2789: AND nvl(p_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
2790: nvl(l_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) --check added for BUg 4120380 Aditi */
2791: THEN
2792: l_task_number := p_task_number;
2793: /* bug#5243018 : Reverting the fix in Bug 4120380
2794: -- dbms_output.put_line('printed once');
2801: After updating all the tasks in the script, code again updates the task_number, trimming the '-' added. **/
2802: END IF;
2803: --dbms_output.put_line('Value of l_task_number' ||l_task_number);
2804:
2805: IF ( p_task_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_task_name IS NOT NULL )
2806: THEN
2807: l_task_name := p_task_name;
2808: END IF;
2809:
2809:
2810: /* End of code added for bug 3290037 */
2811: --Begin add by rtarway for BUG 3666023
2812: --3663712, changed 'OR' to and 'AND' in following If condition
2813: IF ( p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2814: THEN
2815: l_task_id := p_task_id;
2816: ELSIF
2817: ( p_pm_task_reference IS NOT NULL AND p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
2813: IF ( p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2814: THEN
2815: l_task_id := p_task_id;
2816: ELSIF
2817: ( p_pm_task_reference IS NOT NULL AND p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
2818: THEN
2819: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all
2820: (p_pa_project_id => p_project_id
2821: ,p_pm_task_reference => p_pm_task_reference
2880: END IF;
2881:
2882: IF p_calling_module = 'AMG' AND
2883: p_ref_task_id is NOT NULL --to make sure that hierarchy is changed.
2884: AND p_ref_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3701460
2885: --if p_ref_task_id is null then there is no hierarchy change
2886: --It is also true that it is not necessary that the hierarchy is changed even if
2887: --it p_ref_task_id is NOT null.
2888: THEN
2887: --it p_ref_task_id is NOT null.
2888: THEN
2889:
2890: IF p_structure_version_id IS NULL OR
2891: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2892: THEN
2893:
2894: IF p_structure_type = 'FINANCIAL'
2895: THEN
2919: will be null in this case. If a structure version is in approved, submitted or rejected state, then it
2920: will never be returned from cursor cur_struc_ver_wp, so how can we get the status of a null struc ver.
2921:
2922: IF p_structure_version_id IS NOT NULL AND
2923: p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2924: THEN
2925: --Validate the incoming structure version id
2926: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id(
2927: p_structure_id => null
2957: END IF;
2958: ***/
2959: /* New Code Begin for Bug 2736392 -- Commnted the above code*/
2960:
2961: IF p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2962: THEN
2963: l_str_status_code := PA_PROJECT_STRUCTURE_UTILS.get_structrue_version_status
2964: ( p_project_id => p_project_id
2965: ,p_structure_version_id => p_structure_version_id );
3221: AND project_id = p_project_id;
3222:
3223: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
3224: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
3225: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN
3226: l_wq_planned_quantity := NULL;
3227: END IF;
3228: ELSE
3229: l_wq_planned_quantity := P_PLANNED_WORK_QUANTITY; --bug 2826992
3233:
3234: --Bug 6153503 start
3235: -- rtarway, BUG 3908013
3236: if (--p_attribute_category is null or
3237: p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3238: then
3239: l_attribute_category := l_ver_sch_attr_rec.attribute_category;
3240: else
3241: l_attribute_category := p_attribute_category;
3243:
3244:
3245:
3246: if (--p_attribute1 is null or
3247: p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3248: then
3249: l_attribute1 := l_ver_sch_attr_rec.attribute1;
3250: else
3251: l_attribute1 := p_attribute1;
3253:
3254:
3255:
3256: if (--p_attribute2 is null or
3257: p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3258: then
3259: l_attribute2 := l_ver_sch_attr_rec.attribute2;
3260: else
3261: l_attribute2 := p_attribute2;
3262: end if;
3263:
3264:
3265: if (--p_attribute3 is null or
3266: p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3267: then
3268: l_attribute3 := l_ver_sch_attr_rec.attribute3;
3269: else
3270: l_attribute3 := p_attribute3;
3270: l_attribute3 := p_attribute3;
3271: end if;
3272:
3273: if (--p_attribute4 is null or
3274: p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3275: then
3276: l_attribute4 := l_ver_sch_attr_rec.attribute4;
3277: else
3278: l_attribute4 := p_attribute4;
3278: l_attribute4 := p_attribute4;
3279: end if;
3280:
3281: if (--p_attribute5 is null or
3282: p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3283: then
3284: l_attribute5 := l_ver_sch_attr_rec.attribute5;
3285: else
3286: l_attribute5 := p_attribute5;
3286: l_attribute5 := p_attribute5;
3287: end if;
3288:
3289: if (--p_attribute6 is null or
3290: p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3291: then
3292: l_attribute6 := l_ver_sch_attr_rec.attribute6;
3293: else
3294: l_attribute6 := p_attribute6;
3294: l_attribute6 := p_attribute6;
3295: end if;
3296:
3297: if (--p_attribute7 is null or
3298: p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Changed for Bug #6153681
3299: then
3300: l_attribute7 := l_ver_sch_attr_rec.attribute7;
3301: else
3302: l_attribute7 := p_attribute7;
3302: l_attribute7 := p_attribute7;
3303: end if;
3304:
3305: if (--p_attribute8 is null or
3306: p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3307: then
3308: l_attribute8 := l_ver_sch_attr_rec.attribute8;
3309: else
3310: l_attribute8 := p_attribute8;
3310: l_attribute8 := p_attribute8;
3311: end if;
3312:
3313: if (--p_attribute9 is null or
3314: p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3315: then
3316: l_attribute9 := l_ver_sch_attr_rec.attribute9;
3317: else
3318: l_attribute9 := p_attribute9;
3318: l_attribute9 := p_attribute9;
3319: end if;
3320:
3321: if (--p_attribute10 is null or
3322: p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3323: then
3324: l_attribute10 := l_ver_sch_attr_rec.attribute10;
3325: else
3326: l_attribute10 := p_attribute10;
3326: l_attribute10 := p_attribute10;
3327: end if;
3328:
3329: if (--p_attribute10 is null or
3330: p_attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3331: then
3332: l_attribute11 := l_ver_sch_attr_rec.attribute11;
3333: else
3334: l_attribute11 := p_attribute11;
3334: l_attribute11 := p_attribute11;
3335: end if;
3336:
3337: if (--p_attribute10 is null or
3338: p_attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3339: then
3340: l_attribute12 := l_ver_sch_attr_rec.attribute12;
3341: else
3342: l_attribute12 := p_attribute12;
3342: l_attribute12 := p_attribute12;
3343: end if;
3344:
3345: if (--p_attribute10 is null or
3346: p_attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3347: then
3348: l_attribute13 := l_ver_sch_attr_rec.attribute13;
3349: else
3350: l_attribute13 := p_attribute13;
3350: l_attribute13 := p_attribute13;
3351: end if;
3352:
3353: if (--p_attribute10 is null or
3354: p_attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3355: then
3356: l_attribute14 := l_ver_sch_attr_rec.attribute14;
3357: else
3358: l_attribute14 := p_attribute14;
3359: end if;
3360:
3361:
3362: if (--p_attribute10 is null or
3363: p_attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3364: then
3365: l_attribute15 := l_ver_sch_attr_rec.attribute15;
3366: else
3367: l_attribute15 := p_attribute15;
3369:
3370:
3371: --if added while fixing BUG 3919800
3372: --Add validation for PA_PROJ_ELEM_VER_SCH_DESC_FLEX
3373: -- if l_attribute_category is not null and l_attribute_category <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3374: -- then
3375: pa_task_utils.validate_flex_fields(
3376: p_desc_flex_name => 'PA_PROJ_ELEM_VER_SCH_DESC_FLEX'
3377: ,p_attribute_category => l_attribute_category
3398: IF l_validate_status = 'N'
3399: THEN
3400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3401: THEN
3402: pa_interface_utils_pub.map_new_amg_msg
3403: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
3404: ,p_msg_attribute => 'CHANGE'
3405: ,p_resize_flag => 'N'
3406: ,p_msg_context => 'FLEX'
3772:
3773: SAVEPOINT delete_task_struc;
3774:
3775: IF p_task_version_id IS NULL OR
3776: p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
3777: p_task_version_id = -9999
3778: THEN
3779:
3780: -- bug 2765115
4321: l_msg_count := FND_MSG_PUB.count_msg;
4322: if l_msg_count > 0 then
4323: x_msg_count := l_msg_count;
4324: if x_msg_count = 1 then
4325: pa_interface_utils_pub.get_messages
4326: (p_encoded => FND_API.G_TRUE,
4327: p_msg_index => 1,
4328: p_msg_count => l_msg_count,
4329: p_msg_data => l_msg_data,
4351: l_msg_count := FND_MSG_PUB.count_msg;
4352: if l_msg_count > 0 then
4353: x_msg_count := l_msg_count;
4354: if x_msg_count = 1 then
4355: pa_interface_utils_pub.get_messages
4356: (p_encoded => FND_API.G_TRUE,
4357: p_msg_index => 1,
4358: p_msg_count => l_msg_count,
4359: p_msg_data => l_msg_data,
4467:
4468: PROCEDURE Copy_Structure(
4469: p_src_project_id IN NUMBER
4470: ,p_dest_project_id IN NUMBER
4471: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4472: ,p_copy_task_flag IN VARCHAR2 := 'Y'
4473: ,p_dest_template_flag IN VARCHAR2 := 'N' --bug 2805602
4474: ,p_src_template_flag IN VARCHAR2 := 'N' --bug 2805602
4475: ,p_dest_project_name IN VARCHAR2 --bug 2805602
4564: l_msg_count := FND_MSG_PUB.count_msg;
4565: if l_msg_count > 0 then
4566: x_msg_count := l_msg_count;
4567: if x_msg_count = 1 then
4568: pa_interface_utils_pub.get_messages
4569: (p_encoded => FND_API.G_TRUE,
4570: p_msg_index => 1,
4571: p_msg_count => l_msg_count,
4572: p_msg_data => l_msg_data,
4731: end loop;
4732:
4733: IF l_index_number > l_first_index1 AND
4734: p_tasks_in(l_index_number-1).pa_task_id IS NOT NULL AND
4735: p_tasks_in(l_index_number-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4736: --existing task becomes the ref_task_id
4737: THEN
4738: v_task_id_above := p_tasks_in(l_index_number-1).pa_task_id; --Get the task above.
4739: ELSIF l_index_number > l_first_index1 AND
4737: THEN
4738: v_task_id_above := p_tasks_in(l_index_number-1).pa_task_id; --Get the task above.
4739: ELSIF l_index_number > l_first_index1 AND
4740: p_tasks_out(l_index_number-1).pa_task_id IS NOT NULL AND
4741: p_tasks_out(l_index_number-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4742: --new task becomes the ref_task_id
4743: THEN
4744: v_task_id_above := p_tasks_out(l_index_number-1).pa_task_id; --Get the task above created newly
4745: ELSIF ( p_tasks_in(l_index_number).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4741: p_tasks_out(l_index_number-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4742: --new task becomes the ref_task_id
4743: THEN
4744: v_task_id_above := p_tasks_out(l_index_number-1).pa_task_id; --Get the task above created newly
4745: ELSIF ( p_tasks_in(l_index_number).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4746: p_tasks_in(l_index_number).pa_task_id IS NULL
4747: ) AND
4748: l_index_number = l_first_index1
4749: THEN
4816: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4817: ,p_validation_level IN VARCHAR2 := 100
4818: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4819: ,p_debug_mode IN VARCHAR2 := 'N'
4820: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4821: ,p_responsibility_id IN NUMBER := 0
4822: ,p_structure_version_id IN NUMBER
4823: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4824: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4819: ,p_debug_mode IN VARCHAR2 := 'N'
4820: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4821: ,p_responsibility_id IN NUMBER := 0
4822: ,p_structure_version_id IN NUMBER
4823: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4824: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4825: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4826: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4827: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4820: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4821: ,p_responsibility_id IN NUMBER := 0
4822: ,p_structure_version_id IN NUMBER
4823: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4824: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4825: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4826: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4827: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4828: ,x_published_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4821: ,p_responsibility_id IN NUMBER := 0
4822: ,p_structure_version_id IN NUMBER
4823: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4824: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4825: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4826: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4827: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4828: ,x_published_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4829: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4822: ,p_structure_version_id IN NUMBER
4823: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4824: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4825: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4826: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4827: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4828: ,x_published_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4829: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4830: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4823: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4824: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4825: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4826: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4827: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4828: ,x_published_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4829: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4830: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4831: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4875: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4876: ,p_validation_level IN VARCHAR2 := 100
4877: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4878: ,p_debug_mode IN VARCHAR2 := 'N'
4879: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4880: ,p_structure_version_id IN NUMBER
4881: ,p_record_version_number IN NUMBER
4882: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4883: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4916: -- Notes: This api is a wrapper called from AMG
4917:
4918: --This API will only be called with the structure type = 'WORKPLAN'
4919: procedure create_structure(
4920: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4921: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4922: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4923: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4924: ,x_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4917:
4918: --This API will only be called with the structure type = 'WORKPLAN'
4919: procedure create_structure(
4920: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4921: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4922: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4923: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4924: ,x_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4925: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4918: --This API will only be called with the structure type = 'WORKPLAN'
4919: procedure create_structure(
4920: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4921: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4922: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4923: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4924: ,x_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4925: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4926: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4919: procedure create_structure(
4920: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4921: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4922: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4923: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4924: ,x_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4925: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4926: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4927: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5170: --
5171: -- Notes: This api is a wrapper called from AMG
5172:
5173: procedure create_update_struct_ver(
5174: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5175: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5176: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5177: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5178: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5171: -- Notes: This api is a wrapper called from AMG
5172:
5173: procedure create_update_struct_ver(
5174: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5175: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5176: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5177: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5178: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5179: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5172:
5173: procedure create_update_struct_ver(
5174: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5175: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5176: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5177: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5178: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5179: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5180: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5173: procedure create_update_struct_ver(
5174: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5175: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5176: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5177: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5178: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5179: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5180: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5181: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5174: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5175: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5176: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5177: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5178: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5179: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5180: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5181: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5182: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5245: FND_MSG_PUB.initialize;
5246: END IF;
5247:
5248: IF (p_structure_version_name IS NOT NULL) AND
5249: (p_structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
5250: ((p_structure_version_id IS NULL) OR (p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)) THEN
5251: --get structure for input type
5252: OPEN c2;
5253: FETCH c2 into l_proj_element_id;
5246: END IF;
5247:
5248: IF (p_structure_version_name IS NOT NULL) AND
5249: (p_structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
5250: ((p_structure_version_id IS NULL) OR (p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)) THEN
5251: --get structure for input type
5252: OPEN c2;
5253: FETCH c2 into l_proj_element_id;
5254: IF c2%NOTFOUND THEN
5573: -- Bug 4574032 End
5574: END IF;
5575: ELSE
5576: --update existing structure
5577: IF (p_structure_version_id IS NOT NULL) AND (p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
5578:
5579: --check if name is passed in
5580: open c1;
5581: fetch c1 into l_pev_structure_id, l_name, l_record_version_number;
5580: open c1;
5581: fetch c1 into l_pev_structure_id, l_name, l_record_version_number;
5582: close c1;
5583: If (p_structure_version_name IS NOT NULL) AND
5584: (p_structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
5585: l_name := p_structure_version_name;
5586: END IF;
5587:
5588: --call update_structure_version_attr API
6106: --Added by rtarway for BUG 4320731
6107: l_pa_task_id := NULL;
6108: --Commented by rtarway , chnaged If condition, BUG 3990873
6109: /*IF p_tasks_in(i).pa_task_id IS NOT NULL AND
6110: p_tasks_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6111: THEN*/
6112:
6113: --Begin add by rtarway, for BUG 3990873
6114: if ( p_tasks_in(i).pa_task_id is null or p_tasks_in(i).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6110: p_tasks_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6111: THEN*/
6112:
6113: --Begin add by rtarway, for BUG 3990873
6114: if ( p_tasks_in(i).pa_task_id is null or p_tasks_in(i).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6115: then
6116: if (p_tasks_in(i).pm_task_reference is not null and p_tasks_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
6117: then
6118: --Cursor is deliberately used here, because we dont want to populate message in global error stack, in case new tasks
6112:
6113: --Begin add by rtarway, for BUG 3990873
6114: if ( p_tasks_in(i).pa_task_id is null or p_tasks_in(i).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6115: then
6116: if (p_tasks_in(i).pm_task_reference is not null and p_tasks_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
6117: then
6118: --Cursor is deliberately used here, because we dont want to populate message in global error stack, in case new tasks
6119: --are being added. At many places in update_task flow, error is raised based on fnd_msg_pub.count > 0
6120: --If NO_DATA_FOUND occurs for this cursor, it will pass without error.
6132: IF l_pa_task_id IS NOT NULL
6133: then
6134: --end add by rtarway, for BUG 3990873
6135: IF (p_tasks_in(i).pa_parent_task_id IS NOT NULL
6136: AND p_tasks_in(i).pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6137: THEN
6138: v_parent_task_id := p_tasks_in(i).pa_parent_task_id;
6139: ELSIF (p_tasks_in(i).pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6140: AND p_tasks_in(i).pm_parent_task_reference IS NOT NULL)
6135: IF (p_tasks_in(i).pa_parent_task_id IS NOT NULL
6136: AND p_tasks_in(i).pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6137: THEN
6138: v_parent_task_id := p_tasks_in(i).pa_parent_task_id;
6139: ELSIF (p_tasks_in(i).pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6140: AND p_tasks_in(i).pm_parent_task_reference IS NOT NULL)
6141: THEN
6142: --convert pm_parent_task_reference to parent_task_id.
6143: --All the parent tasks are created first then child tasks are created. See TRM for AMG load_task api.
6164: /*IF l_return_status <> FND_API.G_RET_STS_SUCCESS
6165: THEN
6166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6167: THEN
6168: pa_interface_utils_pub.map_new_amg_msg
6169: ( p_old_message_code => 'PA_PARENT_TASK_MISSING'
6170: ,p_msg_attribute => 'CHANGE'
6171: ,p_resize_flag => 'N'
6172: ,p_msg_context => 'TASK'
6190: ELSE
6191: --v_ref_task_id := p_tasks_in(i-1).pa_task_id;
6192: --Added by rtarway for BUG 3990873
6193: if ( p_tasks_in(i-1).pa_task_id is not null
6194: and p_tasks_in(i-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
6195: then
6196: v_ref_task_id := p_tasks_in(i-1).pa_task_id;
6197: else
6198: if ( p_tasks_in(i-1).pm_task_reference is not null
6195: then
6196: v_ref_task_id := p_tasks_in(i-1).pa_task_id;
6197: else
6198: if ( p_tasks_in(i-1).pm_task_reference is not null
6199: and p_tasks_in(i-1).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
6200: then
6201: --get the task id from reference
6202: --Cursor is deliberately used here, because we dont want to populate message in global error stack, in case new tasks
6203: --are being added. At many places in update_task flow, error is raised based on fnd_msg_pub.count > 0
6216:
6217:
6218: IF p_tasks_in(i).actual_start_date IS NULL OR
6219: p_tasks_in(i).actual_start_date =
6220: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
6221: l_actual_start_date := NULL;
6222: ELSE
6223: l_actual_start_date := p_tasks_in(i).actual_start_date;
6224: END IF;
6224: END IF;
6225:
6226: IF p_tasks_in(i).actual_finish_date IS NULL OR
6227: p_tasks_in(i).actual_finish_date =
6228: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
6229: l_actual_finish_date := NULL;
6230: ELSE
6231: l_actual_finish_date := p_tasks_in(i).actual_finish_date;
6232: END IF;
6338: IF p_tasks_in.exists(i)
6339: THEN
6340: WHILE i IS NOT NULL LOOP
6341: IF p_tasks_in(i).task_version_id IS NOT NULL AND
6342: p_tasks_in(i).task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6343: THEN
6344: l_tasks_ver_ids.extend;
6345: l_tasks_ver_ids(l_tasks_ver_ids.count) := p_tasks_in(i).task_version_id;
6346:
6374:
6375: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6376: x_msg_count := FND_MSG_PUB.count_msg;
6377: if x_msg_count = 1 then
6378: pa_interface_utils_pub.get_messages
6379: (p_encoded => FND_API.G_TRUE,
6380: p_msg_index => 1,
6381: p_msg_count => l_msg_count,
6382: p_msg_data => l_msg_data,
6400: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6401: x_msg_count := FND_MSG_PUB.count_msg;
6402: x_return_status := l_return_status ; --bug 3044915
6403: if x_msg_count = 1 then
6404: pa_interface_utils_pub.get_messages
6405: (p_encoded => FND_API.G_TRUE,
6406: p_msg_index => 1,
6407: p_msg_count => l_msg_count,
6408: p_msg_data => l_msg_data,
6458:
6459: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6460: x_msg_count := FND_MSG_PUB.count_msg;
6461: if x_msg_count = 1 then
6462: pa_interface_utils_pub.get_messages
6463: (p_encoded => FND_API.G_TRUE,
6464: p_msg_index => 1,
6465: p_msg_count => l_msg_count,
6466: p_msg_data => l_msg_data,
6485: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6486: x_msg_count := FND_MSG_PUB.count_msg;
6487: x_return_status := l_return_status ; --bug 3044915
6488: if x_msg_count = 1 then
6489: pa_interface_utils_pub.get_messages
6490: (p_encoded => FND_API.G_TRUE,
6491: p_msg_index => 1,
6492: p_msg_count => l_msg_count,
6493: p_msg_data => l_msg_data,
7834: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
7835: ,p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
7836: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
7837: ,p_debug_mode IN VARCHAR2 := 'N'
7838: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7839: ,p_src_project_id IN NUMBER
7840: ,p_dest_project_id IN NUMBER
7841: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7842: ,p_copy_task_flag IN VARCHAR2 := 'Y' /**NOT USED **/
7837: ,p_debug_mode IN VARCHAR2 := 'N'
7838: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7839: ,p_src_project_id IN NUMBER
7840: ,p_dest_project_id IN NUMBER
7841: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7842: ,p_copy_task_flag IN VARCHAR2 := 'Y' /**NOT USED **/
7843: ,p_dest_template_flag IN VARCHAR2 := 'N'
7844: ,p_src_template_flag IN VARCHAR2 := 'N' /**NOT USED **/
7845: ,p_dest_project_name IN VARCHAR2
10740:
10741: l_msg_count := Fnd_Msg_Pub.count_msg;
10742: IF l_msg_count = 1 AND x_msg_data IS NULL
10743: THEN
10744: Pa_Interface_Utils_Pub.get_messages
10745: ( p_encoded => Fnd_Api.G_FALSE
10746: , p_msg_index => 1
10747: , p_msg_count => l_msg_count
10748: , p_msg_data => l_msg_data
10852: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
10853: ,p_validation_level IN VARCHAR2 := 100
10854: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
10855: ,p_debug_mode IN VARCHAR2 := 'N'
10856: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10857: ,p_src_project_id IN NUMBER
10858: ,p_dest_project_id IN NUMBER
10859: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10860: ,p_copy_task_flag IN VARCHAR2 := 'Y'
10855: ,p_debug_mode IN VARCHAR2 := 'N'
10856: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10857: ,p_src_project_id IN NUMBER
10858: ,p_dest_project_id IN NUMBER
10859: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10860: ,p_copy_task_flag IN VARCHAR2 := 'Y'
10861: ,p_dest_template_flag IN VARCHAR2 := 'N' --bug 2805602
10862: ,p_src_template_flag IN VARCHAR2 := 'N' --bug 2805602
10863: ,p_dest_project_name IN VARCHAR2 --bug 2805602
10962: l_get_structure_attr_csr_rec l_get_structure_attr_csr%ROWTYPE;
10963: l_get_structure_attr_csr_rec2 l_get_structure_attr_csr2%ROWTYPE;
10964:
10965: TYPE structure_ver_record IS RECORD
10966: (src_str_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
10967: src_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10968: latest_pub_flag VARCHAR2(1) := 'N',
10969: current_flag VARCHAR2(1) := 'N',
10970: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
10963: l_get_structure_attr_csr_rec2 l_get_structure_attr_csr2%ROWTYPE;
10964:
10965: TYPE structure_ver_record IS RECORD
10966: (src_str_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
10967: src_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10968: latest_pub_flag VARCHAR2(1) := 'N',
10969: current_flag VARCHAR2(1) := 'N',
10970: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
10971: copy_flag VARCHAR2(1) := 'N',
10966: (src_str_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
10967: src_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10968: latest_pub_flag VARCHAR2(1) := 'N',
10969: current_flag VARCHAR2(1) := 'N',
10970: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
10971: copy_flag VARCHAR2(1) := 'N',
10972: dest_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10973: src_stru_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10974: );
10968: latest_pub_flag VARCHAR2(1) := 'N',
10969: current_flag VARCHAR2(1) := 'N',
10970: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
10971: copy_flag VARCHAR2(1) := 'N',
10972: dest_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10973: src_stru_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10974: );
10975:
10976: TYPE l_dest_str_versions IS TABLE OF structure_ver_record
10969: current_flag VARCHAR2(1) := 'N',
10970: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
10971: copy_flag VARCHAR2(1) := 'N',
10972: dest_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10973: src_stru_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10974: );
10975:
10976: TYPE l_dest_str_versions IS TABLE OF structure_ver_record
10977: INDEX BY BINARY_INTEGER;
11160: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
11161: and lookup_code = 'WORKPLAN';
11162:
11163: -- Bug 3717026 Begin, commented as the structure name should be same as the project name.
11164: --IF pa_project_pub.G_structure_in_rec.structure_version_name is NOT NULL AND pa_project_pub.G_structure_in_rec.structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11165: --l_name := pa_project_pub.G_structure_in_rec.structure_version_name;
11166: --ELSE
11167: l_name := substr(l_project_name, 1, 240);
11168: --END IF;
13422:
13423: END calc_duration;
13424:
13425: PROCEDURE get_version_ids(
13426: p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13427: ,p_task_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13428: ,p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13429: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13430: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13423: END calc_duration;
13424:
13425: PROCEDURE get_version_ids(
13426: p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13427: ,p_task_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13428: ,p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13429: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13430: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13431: ) IS
13424:
13425: PROCEDURE get_version_ids(
13426: p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13427: ,p_task_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13428: ,p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13429: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13430: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13431: ) IS
13432: CURSOR cur_str_ver_id1
13444: ;
13445:
13446: BEGIN
13447:
13448: IF p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_version_id IS NOT NULL
13449: THEN
13450: OPEN cur_str_ver_id1;
13451: FETCH cur_str_ver_id1 INTO x_structure_version_id;
13452: CLOSE cur_str_ver_id1;
13450: OPEN cur_str_ver_id1;
13451: FETCH cur_str_ver_id1 INTO x_structure_version_id;
13452: CLOSE cur_str_ver_id1;
13453: x_task_version_id := p_task_version_id;
13454: ELSIF ( p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_task_version_id IS NULL ) AND
13455: ( p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL )
13456: THEN
13457: OPEN cur_str_ver_id2;
13458: FETCH cur_str_ver_id2 INTO x_task_version_id, x_structure_version_id;
13451: FETCH cur_str_ver_id1 INTO x_structure_version_id;
13452: CLOSE cur_str_ver_id1;
13453: x_task_version_id := p_task_version_id;
13454: ELSIF ( p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_task_version_id IS NULL ) AND
13455: ( p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL )
13456: THEN
13457: OPEN cur_str_ver_id2;
13458: FETCH cur_str_ver_id2 INTO x_task_version_id, x_structure_version_id;
13459: CLOSE cur_str_ver_id2;
13462: END get_version_ids;
13463:
13464:
13465: PROCEDURE get_task_version_id(
13466: p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13467: ,p_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13468: ,p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13469: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13470: ) IS
13463:
13464:
13465: PROCEDURE get_task_version_id(
13466: p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13467: ,p_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13468: ,p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13469: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13470: ) IS
13471:
13464:
13465: PROCEDURE get_task_version_id(
13466: p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13467: ,p_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13468: ,p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13469: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13470: ) IS
13471:
13472: CURSOR cur_task_ver_id
13477: AND parent_structure_version_id = p_structure_version_id
13478: AND project_id = p_project_id;
13479:
13480: BEGIN
13481: IF p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_structure_version_id IS NOT NULL AND
13482: p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL AND
13483: p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_project_id IS NOT NULL
13484: THEN
13485: OPEN cur_task_ver_id;
13478: AND project_id = p_project_id;
13479:
13480: BEGIN
13481: IF p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_structure_version_id IS NOT NULL AND
13482: p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL AND
13483: p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_project_id IS NOT NULL
13484: THEN
13485: OPEN cur_task_ver_id;
13486: FETCH cur_task_ver_id INTO x_task_version_id;
13479:
13480: BEGIN
13481: IF p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_structure_version_id IS NOT NULL AND
13482: p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL AND
13483: p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_project_id IS NOT NULL
13484: THEN
13485: OPEN cur_task_ver_id;
13486: FETCH cur_task_ver_id INTO x_task_version_id;
13487: CLOSE cur_task_ver_id;
13520: IF p_tasks_in.exists(i)
13521: THEN
13522: WHILE i IS NOT NULL LOOP
13523: IF p_tasks_in(i).task_version_id IS NOT NULL AND
13524: p_tasks_in(i).task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13525: THEN
13526: --l_tasks_ver_ids.extend;
13527: l_tasks_ver_ids(j) := p_tasks_in(i).task_version_id;
13528:
13525: THEN
13526: --l_tasks_ver_ids.extend;
13527: l_tasks_ver_ids(j) := p_tasks_in(i).task_version_id;
13528:
13529: ELSIF ( p_tasks_in(i).pa_task_id IS NOT NULL AND p_tasks_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
13530: ( p_tasks_in(i).task_version_id IS NULL OR p_tasks_in(i).task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND p_structure_version_id IS NOT NULL
13531: THEN
13532: --PA_PROJECT_PUB.update_project does not populate task versions for the tasks being updated.
13533: --in this case we have to pick this from databse.
13526: --l_tasks_ver_ids.extend;
13527: l_tasks_ver_ids(j) := p_tasks_in(i).task_version_id;
13528:
13529: ELSIF ( p_tasks_in(i).pa_task_id IS NOT NULL AND p_tasks_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
13530: ( p_tasks_in(i).task_version_id IS NULL OR p_tasks_in(i).task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND p_structure_version_id IS NOT NULL
13531: THEN
13532: --PA_PROJECT_PUB.update_project does not populate task versions for the tasks being updated.
13533: --in this case we have to pick this from databse.
13534: get_task_version_id(
13563: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
13564: x_msg_count := FND_MSG_PUB.count_msg;
13565: x_return_status := l_return_status ; -- Bug 3044915
13566: if x_msg_count = 1 then
13567: pa_interface_utils_pub.get_messages
13568: (p_encoded => FND_API.G_TRUE,
13569: p_msg_index => 1,
13570: p_msg_count => l_msg_count,
13571: p_msg_data => l_msg_data,
14309:
14310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14311: THEN
14312: --Commented out as there is no message defined for amg corresponding to PA_PS_VD_UPDWBS_PRC_INPROC
14313: --pa_interface_utils_pub.map_new_amg_msg
14314: -- ( p_old_message_code => 'PA_PS_VD_UPDWBS_PRC_INPROC'
14315: -- ,p_msg_attribute => 'CHANGE'
14316: -- ,p_resize_flag => 'N'
14317: -- ,p_msg_context => 'GENERAL'
14339: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => p_project_id --Bug 3091798
14340: ,p_structure_type => p_structure_type );
14341:
14342: --Commented out as there is no message defined for amg corresponding to PA_PS_VD_UPD_WBS_PRC_ERR
14343: --pa_interface_utils_pub.map_new_amg_msg
14344: -- ( p_old_message_code => 'PA_PS_VD_UPD_WBS_PRC_ERR'
14345: -- ,p_msg_attribute => 'CHANGE'
14346: -- ,p_resize_flag => 'N'
14347: -- ,p_msg_context => 'GENERAL'
14736: and pstype.structure_type_id = types.structure_type_id
14737: and types.structure_type = p_structure_type);
14738: BEGIN
14739: IF (NVL(PA_PROJECT_PUB.G_MASS_ADD_TASKS,'N') ='N' ) THEN -- Added for Huawei 14556729 for add flow
14740: IF (l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14741: l_task_in_rec.pa_task_id IS NULL )
14742: THEN
14743: IF l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
14744: l_task_in_rec.pm_task_reference IS NULL
14739: IF (NVL(PA_PROJECT_PUB.G_MASS_ADD_TASKS,'N') ='N' ) THEN -- Added for Huawei 14556729 for add flow
14740: IF (l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14741: l_task_in_rec.pa_task_id IS NULL )
14742: THEN
14743: IF l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
14744: l_task_in_rec.pm_task_reference IS NULL
14745: THEN
14746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14747: THEN
14744: l_task_in_rec.pm_task_reference IS NULL
14745: THEN
14746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14747: THEN
14748: pa_interface_utils_pub.map_new_amg_msg
14749: ( p_old_message_code => 'PA_TASK_REF_AND_ID_MISSING'
14750: ,p_msg_attribute => 'CHANGE'
14751: ,p_resize_flag => 'N'
14752: ,p_msg_context => 'PROJ'
14785:
14786:
14787: -- Validation block
14788: -- validate security, task_reference and task names in appropriate contexts.
14789: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14790: l_task_in_rec.pa_task_id IS NULL -- new tasks to be crated
14791: THEN
14792: -- Added to check the security as it is not done when called from update_project
14793: IF l_add_task_security = 'N'
14791: THEN
14792: -- Added to check the security as it is not done when called from update_project
14793: IF l_add_task_security = 'N'
14794: THEN
14795: pa_interface_utils_pub.map_new_amg_msg(
14796: p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
14797: ,p_msg_attribute => 'CHANGE'
14798: ,p_resize_flag => 'Y'
14799: ,p_msg_context => 'GENERAL'
14816:
14817: -- Task reference should be non null in AMG flow. For financial tasks this
14818: -- is checked in add_task_round_one API.
14819: IF l_task_in_rec.pm_task_reference IS NULL
14820: OR l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14821: THEN
14822: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14823: THEN
14824: pa_interface_utils_pub.map_new_amg_msg
14820: OR l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14821: THEN
14822: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14823: THEN
14824: pa_interface_utils_pub.map_new_amg_msg
14825: ( p_old_message_code => 'PA_TASK_REF_IS_NULL'
14826: ,p_msg_attribute => 'CHANGE'
14827: ,p_resize_flag => 'N'
14828: ,p_msg_context => 'PROJ'
14838:
14839: --ADUT. The task name cannot be null. For financial tasks this is
14840: --checked in add_task_round_one API.
14841: IF l_task_in_rec.task_name IS NULL
14842: OR l_task_in_rec.task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14843: THEN
14844:
14845: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14846: THEN
14843: THEN
14844:
14845: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14846: THEN
14847: pa_interface_utils_pub.map_new_amg_msg
14848: ( p_old_message_code => 'PA_TASK_NAME_IS_NULL'
14849: ,p_msg_attribute => 'CHANGE'
14850: ,p_resize_flag => 'N'
14851: ,p_msg_context => 'TASK'
14865: ELSE -- IF l_task_in_rec.pa_task_id IS NULL
14866:
14867: IF l_update_task_security = 'N'
14868: THEN
14869: pa_interface_utils_pub.map_new_amg_msg(
14870: p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
14871: ,p_msg_attribute => 'CHANGE'
14872: ,p_resize_flag => 'Y'
14873: ,p_msg_context => 'GENERAL'
14894: -- 3. l_task_id -- the task that is being processed.
14895: -- l_proj_elem_rvn of record of pa_proj_elements to be updated
14896: -- before calling api PA_TASK_PUB1.update_task
14897:
14898: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14899: l_task_in_rec.pa_task_id IS NULL -- new tasks to be crated
14900: THEN
14901:
14902: -- If the structure type is workplan we need to derive the values for certain fields. For financial
14903: -- context they have already been done and is available in the database - So we'll just query it up.
14904: IF p_structure_type = 'WORKPLAN' THEN
14905:
14906: -- Derive the task number for the current task
14907: IF l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.pa_task_number IS NULL
14908: THEN
14909: l_cur_pa_tasks_rec.task_number := l_task_in_rec.pm_task_reference;
14910: -- ELSE Bug 6193314 need to comment out
14911: /* bug#5243018 : Reverting the fix in Bug 4120380
14919: END IF;
14920:
14921: -- Derive the parent task id
14922: IF (l_task_in_rec.pa_parent_task_id IS NOT NULL
14923: AND l_task_in_rec.pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14924: THEN
14925: l_cur_pa_tasks_rec.parent_task_id := l_task_in_rec.pa_parent_task_id;
14926: ELSIF (l_task_in_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14927: AND l_task_in_rec.pm_parent_task_reference IS NOT NULL)
14922: IF (l_task_in_rec.pa_parent_task_id IS NOT NULL
14923: AND l_task_in_rec.pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14924: THEN
14925: l_cur_pa_tasks_rec.parent_task_id := l_task_in_rec.pa_parent_task_id;
14926: ELSIF (l_task_in_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14927: AND l_task_in_rec.pm_parent_task_reference IS NOT NULL)
14928: THEN
14929: --convert pm_parent_task_reference to parent_task_id.
14930: --All the parent tasks are created first then child tasks are created. See TRM for AMG load_task api.
14955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
14956: THEN
14957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14958: THEN
14959: pa_interface_utils_pub.map_new_amg_msg
14960: ( p_old_message_code => 'PA_PARENT_TASK_MISSING'
14961: ,p_msg_attribute => 'CHANGE'
14962: ,p_resize_flag => 'N'
14963: ,p_msg_context => 'TASK'
14974: l_cur_pa_tasks_rec.parent_task_id := null;
14975: END IF;
14976:
14977: -- Included the condition during UT to avoid precision errors.
14978: IF l_task_in_rec.carrying_out_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
14979: l_cur_pa_tasks_rec.carrying_out_organization_id := NULL;
14980: ELSE
14981: l_cur_pa_tasks_rec.carrying_out_organization_id := l_task_in_rec.carrying_out_organization_id;
14982: END IF;
14981: l_cur_pa_tasks_rec.carrying_out_organization_id := l_task_in_rec.carrying_out_organization_id;
14982: END IF;
14983:
14984: -- Included the condition during UT to avoid precision errors.
14985: IF l_task_in_rec.address_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
14986: l_cur_pa_tasks_rec.address_id := NULL;
14987: ELSE
14988: l_cur_pa_tasks_rec.address_id := l_task_in_rec.address_id;
14989: END IF;
14987: ELSE
14988: l_cur_pa_tasks_rec.address_id := l_task_in_rec.address_id;
14989: END IF;
14990: -- Included the condition during UT to avoid precision errors.
14991: IF l_task_in_rec.task_manager_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
14992: l_cur_pa_tasks_rec.task_manager_person_id := NULL;
14993: ELSE
14994: l_cur_pa_tasks_rec.task_manager_person_id := l_task_in_rec.task_manager_person_id;
14995: END IF;
14997: l_cur_pa_tasks_rec.pm_task_reference := l_task_in_rec.pm_task_reference;
14998: /*Commented for bug 2982057 l_cur_pa_tasks_rec.long_task_name := l_task_in_rec.long_task_name;*/
14999: /* Code addition for bug 2982057 starts */
15000:
15001: if l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.long_task_name IS NULL then
15002: l_cur_pa_tasks_rec.long_task_name := l_task_in_rec.task_name;
15003: else
15004: l_cur_pa_tasks_rec.long_task_name := l_task_in_rec.long_task_name;
15005: end if;
15027: END IF;
15028: /** Code changes for bug 4120380. For new tasks similar case mentioned above for workplan.**/
15029: /* bug#5243018 : Reverting the fix in Bug 4120380
15030: IF l_task_in_rec.pa_task_number IS NOT NULL AND
15031: l_task_in_rec.pa_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
15032: THEN
15033: l_cur_pa_tasks_rec.task_number := '-'||l_task_in_rec.pa_task_number;
15034: END IF; */
15035: /** Code end for bug 4120380 by aditi **/
15054: -- context they have already been done and is available in the database - So we'll just query it up.
15055: IF p_structure_type = 'WORKPLAN' THEN
15056:
15057: -- Derive the parent task id
15058: IF (l_task_in_rec.pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15059: AND l_task_in_rec.pa_parent_task_id IS NOT NULL)
15060: THEN
15061: l_cur_pa_tasks_rec.parent_task_id := l_task_in_rec.pa_parent_task_id;
15062:
15059: AND l_task_in_rec.pa_parent_task_id IS NOT NULL)
15060: THEN
15061: l_cur_pa_tasks_rec.parent_task_id := l_task_in_rec.pa_parent_task_id;
15062:
15063: ELSIF (l_task_in_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
15064: AND l_task_in_rec.pm_parent_task_reference IS NOT NULL)
15065: THEN
15066: --convert pm_parent_task_reference to parent_task_id.
15067: --All the parent tasks are created first then child tasks are created. See TRM for AMG load_task api.
15093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
15094: THEN
15095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
15096: THEN
15097: pa_interface_utils_pub.map_new_amg_msg
15098: ( p_old_message_code => 'PA_PARENT_TASK_MISSING'
15099: ,p_msg_attribute => 'CHANGE'
15100: ,p_resize_flag => 'N'
15101: ,p_msg_context => 'TASK'
15154: BEGIN
15155: -- Bug 2982072. Open the cursor only if any of task number or name needs to
15156: -- be fetched for the task.
15157: IF (l_task_in_rec.pa_task_number is null OR
15158: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
15159: (l_task_in_rec.long_task_name is null OR
15160: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
15161: THEN
15162: OPEN cur_proj_elem_info(l_task_in_rec.pa_task_id);
15156: -- be fetched for the task.
15157: IF (l_task_in_rec.pa_task_number is null OR
15158: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
15159: (l_task_in_rec.long_task_name is null OR
15160: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
15161: THEN
15162: OPEN cur_proj_elem_info(l_task_in_rec.pa_task_id);
15163: FETCH cur_proj_elem_info into l_proj_elem_info;
15164: CLOSE cur_proj_elem_info;
15167:
15168: -- Bug 2982072. If task number and task name are passed as null then
15169: -- obtain the values from the database and use them in update_task api.
15170: IF l_task_in_rec.pa_task_number is null OR
15171: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
15172: THEN
15173: -- l_task_in_rec.pa_task_number := SUBSTRB(l_proj_elem_info.element_number,1,25); -- Substrb added for Bug 5152448
15174: l_task_in_rec.pa_task_number := l_proj_elem_info.element_number; -- Substrb removed for Bug 6193314
15175: /** added for Bug 4120380 **/
15185: /** end of changes for Bug 4120380 **/
15186: END IF;
15187:
15188: IF l_task_in_rec.long_task_name is null OR
15189: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
15190: THEN
15191: /* Start of changes for bug 4503580 */
15192: -- l_task_in_rec.long_task_name := NVL(l_task_in_rec.task_name, l_proj_elem_info.name); --bug 3969651
15193: IF l_task_in_rec.task_name is null OR
15190: THEN
15191: /* Start of changes for bug 4503580 */
15192: -- l_task_in_rec.long_task_name := NVL(l_task_in_rec.task_name, l_proj_elem_info.name); --bug 3969651
15193: IF l_task_in_rec.task_name is null OR
15194: l_task_in_rec.task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
15195: THEN
15196: l_task_in_rec.long_task_name := l_proj_elem_info.name;
15197: ELSE
15198: l_task_in_rec.long_task_name := l_task_in_rec.task_name;
15212:
15213: -- Bug 2982072. If task number and task name are passed as null then
15214: -- obtain the values from the database and use them in update_task api.
15215: IF l_task_in_rec.pa_task_number is null OR
15216: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
15217: THEN
15218: l_task_in_rec.pa_task_number := l_cur_pa_tasks_rec.task_number;
15219: /* Code added for bug 4120380 **/
15220: /* bug#5243018 : Reverting the fix in Bug 4120380
15228: /* Code end for bug 4120380 **/
15229: END IF;
15230:
15231: IF l_task_in_rec.long_task_name is null OR
15232: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
15233: THEN
15234: l_task_in_rec.long_task_name := l_cur_pa_tasks_rec.long_task_name;
15235: /* Redundant but added for clarity -Added the else condition for bug 2982057*/
15236: ELSE
15242: l_task_id := l_task_in_rec.pa_task_id;
15243:
15244: l_Share_Code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);
15245: IF ((l_Share_Code = 'SHARE_PARTIAL') and (l_parent_task_id is null OR
15246: l_parent_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )) --bug#8647597
15247: THEN
15248: l_parent_task_id := l_task_in_rec.pa_parent_task_id;
15249: END IF;
15250:
15265: -- After call to these APIs populate following
15266: -- px_tasks_out_tbl(i).pa_task_id
15267: -- px_tasks_out_tbl(i).pm_task_reference
15268: -- for workplan create task case l_task_id is output from create task API
15269: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
15270: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
15271: THEN
15272: IF p_create_task_version_only = 'N' THEN
15273:
15815: -- Populate following set of variables required to update element versions:
15816: -- attribute_category , attribute1 ...attribute10, in local variables
15817: -- l_task_version_id, l_proj_elem_ver_rowid, l_proj_elem_ver_rvn -- required only in update task.
15818:
15819: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
15820: l_task_in_rec.pa_task_id IS NULL THEN -- Create Task Context
15821: --Bug 6153503
15822: IF l_task_in_rec.tasks_dff = 'N' THEN
15823: -- Handle the dff attributes. Set the local variable to null if passed value is miss char.
15821: --Bug 6153503
15822: IF l_task_in_rec.tasks_dff = 'N' THEN
15823: -- Handle the dff attributes. Set the local variable to null if passed value is miss char.
15824: -- These attributes would be used both while creating task version and the schedule version.
15825: IF l_task_in_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15826: l_attribute_category := null;
15827: ELSE
15828: l_attribute_category := l_task_in_rec.attribute_category;
15829: END IF;
15827: ELSE
15828: l_attribute_category := l_task_in_rec.attribute_category;
15829: END IF;
15830:
15831: IF l_task_in_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15832: l_attribute1 := null;
15833: ELSE
15834: l_attribute1 := l_task_in_rec.attribute1;
15835: END IF;
15833: ELSE
15834: l_attribute1 := l_task_in_rec.attribute1;
15835: END IF;
15836:
15837: IF l_task_in_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15838: l_attribute2 := null;
15839: ELSE
15840: l_attribute2 := l_task_in_rec.attribute2;
15841: END IF;
15839: ELSE
15840: l_attribute2 := l_task_in_rec.attribute2;
15841: END IF;
15842:
15843: IF l_task_in_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15844: l_attribute3 := null;
15845: ELSE
15846: l_attribute3 := l_task_in_rec.attribute3;
15847: END IF;
15845: ELSE
15846: l_attribute3 := l_task_in_rec.attribute3;
15847: END IF;
15848:
15849: IF l_task_in_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15850: l_attribute4 := null;
15851: ELSE
15852: l_attribute4 := l_task_in_rec.attribute4;
15853: END IF;
15851: ELSE
15852: l_attribute4 := l_task_in_rec.attribute4;
15853: END IF;
15854:
15855: IF l_task_in_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15856: l_attribute5 := null;
15857: ELSE
15858: l_attribute5 := l_task_in_rec.attribute5;
15859: END IF;
15857: ELSE
15858: l_attribute5 := l_task_in_rec.attribute5;
15859: END IF;
15860:
15861: IF l_task_in_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15862: l_attribute6 := null;
15863: ELSE
15864: l_attribute6 := l_task_in_rec.attribute6;
15865: END IF;
15863: ELSE
15864: l_attribute6 := l_task_in_rec.attribute6;
15865: END IF;
15866:
15867: IF l_task_in_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15868: l_attribute7 := null;
15869: ELSE
15870: l_attribute7 := l_task_in_rec.attribute7;
15871: END IF;
15869: ELSE
15870: l_attribute7 := l_task_in_rec.attribute7;
15871: END IF;
15872:
15873: IF l_task_in_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15874: l_attribute8 := null;
15875: ELSE
15876: l_attribute8 := l_task_in_rec.attribute8;
15877: END IF;
15875: ELSE
15876: l_attribute8 := l_task_in_rec.attribute8;
15877: END IF;
15878:
15879: IF l_task_in_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15880: l_attribute9 := null;
15881: ELSE
15882: l_attribute9 := l_task_in_rec.attribute9;
15883: END IF;
15881: ELSE
15882: l_attribute9 := l_task_in_rec.attribute9;
15883: END IF;
15884:
15885: IF l_task_in_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15886: l_attribute10 := null;
15887: ELSE
15888: l_attribute10 := l_task_in_rec.attribute10;
15889: END IF;
15887: ELSE
15888: l_attribute10 := l_task_in_rec.attribute10;
15889: END IF;
15890: --Bug 6153503
15891: IF l_task_in_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15892: l_attribute11 := null;
15893: ELSE
15894: l_attribute11 := l_task_in_rec.attribute11;
15895: END IF;
15893: ELSE
15894: l_attribute11 := l_task_in_rec.attribute11;
15895: END IF;
15896:
15897: IF l_task_in_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15898: l_attribute12 := null;
15899: ELSE
15900: l_attribute12 := l_task_in_rec.attribute12;
15901: END IF;
15899: ELSE
15900: l_attribute12 := l_task_in_rec.attribute12;
15901: END IF;
15902:
15903: IF l_task_in_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15904: l_attribute13 := null;
15905: ELSE
15906: l_attribute13 := l_task_in_rec.attribute13;
15907: END IF;
15905: ELSE
15906: l_attribute13 := l_task_in_rec.attribute13;
15907: END IF;
15908:
15909: IF l_task_in_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15910: l_attribute14 := null;
15911: ELSE
15912: l_attribute14 := l_task_in_rec.attribute14;
15913: END IF;
15911: ELSE
15912: l_attribute14 := l_task_in_rec.attribute14;
15913: END IF;
15914:
15915: IF l_task_in_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15916: l_attribute15 := null;
15917: ELSE
15918: l_attribute15 := l_task_in_rec.attribute15;
15919: END IF;
15943: IF l_validate_status = 'N'
15944: THEN
15945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
15946: THEN
15947: pa_interface_utils_pub.map_new_amg_msg
15948: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
15949: ,p_msg_attribute => 'CHANGE'
15950: ,p_resize_flag => 'N'
15951: ,p_msg_context => 'FLEX'
15990:
15991: -- Handle the dff attributes. Set the local variable to null if passed value is miss char.
15992: -- These attributes would be used both while creating task version and the schedule version.
15993: --Bug 6153503 start
15994: IF l_task_in_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
15995: OR l_task_in_rec.tasks_dff = 'Y' THEN
15996: l_attribute_category := l_ver_sch_attr_rec.attribute_category;
15997: ELSE
15998: l_attribute_category := l_task_in_rec.attribute_category;
15997: ELSE
15998: l_attribute_category := l_task_in_rec.attribute_category;
15999: END IF;
16000:
16001: IF l_task_in_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16002: l_attribute1 := l_ver_sch_attr_rec.attribute1;
16003: ELSE
16004: l_attribute1 := l_task_in_rec.attribute1;
16005: END IF;
16003: ELSE
16004: l_attribute1 := l_task_in_rec.attribute1;
16005: END IF;
16006:
16007: IF l_task_in_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16008: l_attribute2 := l_ver_sch_attr_rec.attribute2;
16009: ELSE
16010: l_attribute2 := l_task_in_rec.attribute2;
16011: END IF;
16009: ELSE
16010: l_attribute2 := l_task_in_rec.attribute2;
16011: END IF;
16012:
16013: IF l_task_in_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16014: l_attribute3 := l_ver_sch_attr_rec.attribute3;
16015: ELSE
16016: l_attribute3 := l_task_in_rec.attribute3;
16017: END IF;
16015: ELSE
16016: l_attribute3 := l_task_in_rec.attribute3;
16017: END IF;
16018:
16019: IF l_task_in_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16020: l_attribute4 := l_ver_sch_attr_rec.attribute4;
16021: ELSE
16022: l_attribute4 := l_task_in_rec.attribute4;
16023: END IF;
16021: ELSE
16022: l_attribute4 := l_task_in_rec.attribute4;
16023: END IF;
16024:
16025: IF l_task_in_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16026: l_attribute5 := l_ver_sch_attr_rec.attribute5;
16027: ELSE
16028: l_attribute5 := l_task_in_rec.attribute5;
16029: END IF;
16027: ELSE
16028: l_attribute5 := l_task_in_rec.attribute5;
16029: END IF;
16030:
16031: IF l_task_in_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16032: l_attribute6 := l_ver_sch_attr_rec.attribute6;
16033: ELSE
16034: l_attribute6 := l_task_in_rec.attribute6;
16035: END IF;
16033: ELSE
16034: l_attribute6 := l_task_in_rec.attribute6;
16035: END IF;
16036:
16037: IF l_task_in_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16038: l_attribute7 := l_ver_sch_attr_rec.attribute7;
16039: ELSE
16040: l_attribute7 := l_task_in_rec.attribute7;
16041: END IF;
16039: ELSE
16040: l_attribute7 := l_task_in_rec.attribute7;
16041: END IF;
16042:
16043: IF l_task_in_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16044: l_attribute8 := l_ver_sch_attr_rec.attribute8;
16045: ELSE
16046: l_attribute8 := l_task_in_rec.attribute8;
16047: END IF;
16045: ELSE
16046: l_attribute8 := l_task_in_rec.attribute8;
16047: END IF;
16048:
16049: IF l_task_in_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16050: l_attribute9 := l_ver_sch_attr_rec.attribute9;
16051: ELSE
16052: l_attribute9 := l_task_in_rec.attribute9;
16053: END IF;
16051: ELSE
16052: l_attribute9 := l_task_in_rec.attribute9;
16053: END IF;
16054:
16055: IF l_task_in_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16056: l_attribute10 := l_ver_sch_attr_rec.attribute10;
16057: ELSE
16058: l_attribute10 := l_task_in_rec.attribute10;
16059: END IF;
16057: ELSE
16058: l_attribute10 := l_task_in_rec.attribute10;
16059: END IF;
16060:
16061: IF l_task_in_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16062: l_attribute11 := l_ver_sch_attr_rec.attribute11;
16063: ELSE
16064: l_attribute11 := l_task_in_rec.attribute11;
16065: END IF;
16063: ELSE
16064: l_attribute11 := l_task_in_rec.attribute11;
16065: END IF;
16066:
16067: IF l_task_in_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16068: l_attribute12 := l_ver_sch_attr_rec.attribute12;
16069: ELSE
16070: l_attribute12 := l_task_in_rec.attribute12;
16071: END IF;
16069: ELSE
16070: l_attribute12 := l_task_in_rec.attribute12;
16071: END IF;
16072:
16073: IF l_task_in_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16074: l_attribute13 := l_ver_sch_attr_rec.attribute13;
16075: ELSE
16076: l_attribute13 := l_task_in_rec.attribute13;
16077: END IF;
16075: ELSE
16076: l_attribute13 := l_task_in_rec.attribute13;
16077: END IF;
16078:
16079: IF l_task_in_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16080: l_attribute14 := l_ver_sch_attr_rec.attribute14;
16081: ELSE
16082: l_attribute14 := l_task_in_rec.attribute14;
16083: END IF;
16081: ELSE
16082: l_attribute14 := l_task_in_rec.attribute14;
16083: END IF;
16084:
16085: IF l_task_in_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
16086: l_attribute15 := l_ver_sch_attr_rec.attribute15;
16087: ELSE
16088: l_attribute15 := l_task_in_rec.attribute15;
16089: END IF;
16113: IF l_validate_status = 'N'
16114: THEN
16115: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
16116: THEN
16117: pa_interface_utils_pub.map_new_amg_msg
16118: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
16119: ,p_msg_attribute => 'CHANGE'
16120: ,p_resize_flag => 'N'
16121: ,p_msg_context => 'FLEX'
16147:
16148: -- During these validations following variables are also populated which are used later on
16149: -- l_relationship_id, l_obj_rel_rvn;
16150:
16151: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
16152: l_task_in_rec.pa_task_id IS NULL THEN -- create task
16153: IF l_parent_task_id IS NOT NULL THEN
16154: --Check if it is ok to create a subtask.
16155: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok
16264: -- Set the following local variables after calling PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row
16265: -- l_task_version_id_tbl(l_task_id)
16266: -- px_tasks_out_tbl(i).task_version_id
16267:
16268: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
16269: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
16270: THEN
16271:
16272: -- Call the table handler to create a task version.
16492: l_task_version_id_from := l_task_version_id_tbl(l_parent_task_id);
16493: l_relationship_subtype := 'TASK_TO_TASK';
16494: END IF;
16495:
16496: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
16497: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
16498: THEN
16499: -- Set the following variables after calling PA_RELATIONSHIP_PUB.Create_Relationship
16500: --px_tasks_out_tbl(i).return_status
16620: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16621: l_task_type_id pa_proj_elements.type_id%TYPE;
16622: BEGIN
16623:
16624: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
16625: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
16626: THEN
16627:
16628: -- If start date or end date is miss date, then set them to sysdate.
16625: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
16626: THEN
16627:
16628: -- If start date or end date is miss date, then set them to sysdate.
16629: IF (l_task_in_rec.scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
16630: l_task_in_rec.scheduled_start_date is NULL ) --ADUT
16631: THEN
16632: l_scheduled_start_date := sysdate;
16633: ELSE
16633: ELSE
16634: l_scheduled_start_date := l_task_in_rec.scheduled_start_date;
16635: END IF;
16636:
16637: IF (l_task_in_rec.scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
16638: l_task_in_rec.scheduled_finish_date is NULL) --ADUT
16639: THEN
16640: l_scheduled_finish_date := sysdate;
16641: ELSE
16644:
16645:
16646: -- If the task type for the current task is null, create_task api would have defaulted
16647: -- it to the default task id. So get the default task type id if the passed in id is null.
16648: IF l_task_in_rec.task_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM or
16649: l_task_in_rec.task_type is null
16650: THEN
16651: l_task_type_id := l_default_task_type_id;
16652: ELSE
16657: -- set the value to null so that it can be passed on to create_schedule_version api.
16658: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
16659: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id))
16660: THEN
16661: IF (l_task_in_rec.PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16662: l_task_in_rec.PLANNED_WORK_QUANTITY IS NOT NULL)
16663: THEN
16664: l_wq_planned_quantity := NULL;
16665: END IF;
16664: l_wq_planned_quantity := NULL;
16665: END IF;
16666: ELSE
16667: --Added by rtarway, for 4029755
16668: IF (l_task_in_rec.PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16669: l_task_in_rec.PLANNED_WORK_QUANTITY IS NOT NULL)
16670: THEN
16671: l_wq_planned_quantity := l_task_in_rec.PLANNED_WORK_QUANTITY;
16672: ELSE
16702: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
16703: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
16704: l_wq_planned_quantity := null;
16705: ELSE
16706: IF (l_task_in_rec.PLANNED_WORK_QUANTITY = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16707: --Added by rtarway, for 4029755
16708: OR
16709: l_task_in_rec.PLANNED_WORK_QUANTITY IS NULL) THEN
16710: l_wq_planned_quantity := l_ver_sch_attr_rec.wq_planned_quantity;
16727:
16728: -- set the following after calling Create_Schedule_Version or Update_Schedule_Version
16729: -- px_tasks_out_tbl(i).return_status
16730:
16731: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
16732: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
16733: THEN
16734: -- set the following after calling api PA_TASK_PUB1.Create_Schedule_Version
16735: -- px_tasks_out_tbl(i).return_status
16817: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
16818: END IF;
16819: --rtarway, 4099429 begin
16820: -- Bug 7109656
16821: if (l_task_in_rec.planned_effort is not null and l_task_in_rec.planned_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and l_task_in_rec.planned_effort <> '0' ) THEN
16822: if (l_add_task_ver_ids.count = 1000) then
16823: IF l_add_task_ver_ids.exists(1) AND l_structure_version_id IS NOT NULL THEN
16824: BEGIN
16825:
16971: END IF;
16972:
16973: -- Start Addition 6458891
16974: l_update_task_det_flag := 'Y';
16975: If nvl(p_pm_product_code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16976: and nvl(p_pm_product_code,'X') = 'MSPROJECT' then
16977: l_prev_planned_effort := null;
16978: l_prev_etc_effort := null;
16979: l_prev_percent_comp := null;
16983: OPEN cur_prev_prog(p_project_id,l_task_id,l_task_version_id);
16984: FETCH cur_prev_prog INTO l_prev_planned_effort, l_prev_etc_effort,l_prev_percent_comp;
16985: CLOSE cur_prev_prog;
16986:
16987: IF (NVL(l_task_in_rec.planned_effort, 0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16988: NVL(l_task_in_rec.planned_effort, 0) <> NVL(l_prev_planned_effort,0)) THEN
16989: l_update_task_det_flag := 'Y';
16990: END IF;
16991:
16988: NVL(l_task_in_rec.planned_effort, 0) <> NVL(l_prev_planned_effort,0)) THEN
16989: l_update_task_det_flag := 'Y';
16990: END IF;
16991:
16992: IF (NVL(l_task_in_rec.etc_effort, 0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16993: NVL(l_task_in_rec.etc_effort, 0) <> NVL(l_prev_etc_effort,0)) THEN
16994: l_update_task_det_flag := 'Y';
16995: END IF;
16996:
16993: NVL(l_task_in_rec.etc_effort, 0) <> NVL(l_prev_etc_effort,0)) THEN
16994: l_update_task_det_flag := 'Y';
16995: END IF;
16996:
16997: IF (NVL(l_task_in_rec.percent_complete, 0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16998: NVL(l_task_in_rec.percent_complete, 0) <> NVL(l_prev_percent_comp,0)) THEN
16999: l_update_task_det_flag := 'Y';
17000: END IF;
17001: -- Bug 7132911
17000: END IF;
17001: -- Bug 7132911
17002:
17003: /* Commented for bug 7132911
17004: If (nvl(l_task_in_rec.planned_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17005: or
17006: nvl(l_task_in_rec.etc_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17007: or
17008: nvl(l_task_in_rec.percent_complete,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
17002:
17003: /* Commented for bug 7132911
17004: If (nvl(l_task_in_rec.planned_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17005: or
17006: nvl(l_task_in_rec.etc_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17007: or
17008: nvl(l_task_in_rec.percent_complete,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
17009: Then
17010:
17004: If (nvl(l_task_in_rec.planned_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17005: or
17006: nvl(l_task_in_rec.etc_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17007: or
17008: nvl(l_task_in_rec.percent_complete,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
17009: Then
17010:
17011: open cur_prev_prog(p_project_id,l_task_id,l_task_version_id);
17012: fetch cur_prev_prog into l_prev_planned_effort, l_prev_etc_effort,l_prev_percent_comp;
17097: IF (l_msg_count > 0) THEN
17098: /* Start of 13931870
17099: x_msg_count := l_msg_count;
17100: IF (x_msg_count = 1) THEN
17101: pa_interface_utils_pub.get_messages(
17102: p_encoded => FND_API.G_TRUE,
17103: p_msg_index => 1,
17104: p_data => l_data,
17105: p_msg_index_out => l_msg_index_out);
17509:
17510: IF nvl(p_tasks_in_tbl.LAST,0) > 0 THEN
17511: FOR l_i in p_tasks_in_tbl.first .. p_tasks_in_tbl.last LOOP
17512: --rtarway, 4099429, begin comment
17513: /*IF p_tasks_in_tbl(l_i).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
17514: p_tasks_in_tbl(l_i).pa_task_id IS NULL -- Create Task Context
17515: THEN
17516: l_add_plan_task_id := null;
17517: IF p_structure_version_id is not null THEN -- Update Project Context
17529: IF l_debug_mode = 'Y' THEN
17530: Pa_Debug.WRITE(G_PKG_NAME,'Lowest Task With No Assignments',l_debug_level3);
17531: END IF;
17532:
17533: IF p_tasks_in_tbl(l_i).planned_effort IS NOT NULL AND p_tasks_in_tbl(l_i).planned_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17534: AND l_add_plan_task_id IS NULL
17535: THEN
17536: IF l_debug_mode = 'Y' THEN
17537: Pa_Debug.WRITE(G_PKG_NAME,'Preparing Tables to call FP add_plan_txn',l_debug_level3);
17932:
17933:
17934:
17935: IF l_msg_count = 1 and x_msg_data IS NULL THEN
17936: PA_INTERFACE_UTILS_PUB.get_messages
17937: (p_encoded => FND_API.G_TRUE
17938: ,p_msg_index => 1
17939: ,p_msg_count => l_msg_count
17940: ,p_msg_data => l_msg_data
18017: CLOSE cur_all_task_ver_id;
18018: END IF;
18019:
18020: IF l_msg_count = 1 and x_msg_data IS NULL THEN
18021: PA_INTERFACE_UTILS_PUB.get_messages
18022: (p_encoded => FND_API.G_TRUE
18023: ,p_msg_index => 1
18024: ,p_msg_count => l_msg_count
18025: ,p_msg_data => l_msg_data
18173: l_msg_count := FND_MSG_PUB.count_msg;
18174: if l_msg_count > 0 then
18175: x_msg_count := l_msg_count;
18176: if x_msg_count = 1 then
18177: pa_interface_utils_pub.get_messages
18178: (p_encoded => FND_API.G_TRUE,
18179: p_msg_index => 1,
18180: p_msg_count => l_msg_count,
18181: p_msg_data => l_msg_data,
18424: CLOSE cur_task_count;
18425: END IF;
18426:
18427: IF l_msg_count = 1 and x_msg_data IS NULL THEN
18428: PA_INTERFACE_UTILS_PUB.get_messages
18429: (p_encoded => FND_API.G_TRUE
18430: ,p_msg_index => 1
18431: ,p_msg_count => l_msg_count
18432: ,p_msg_data => l_msg_data
18799: x_return_status := FND_API.G_RET_STS_ERROR;
18800: l_msg_count := FND_MSG_PUB.count_msg;
18801:
18802: IF l_msg_count = 1 and x_msg_data IS NULL THEN
18803: PA_INTERFACE_UTILS_PUB.get_messages
18804: (p_encoded => FND_API.G_TRUE
18805: ,p_msg_index => 1
18806: ,p_msg_count => l_msg_count
18807: ,p_msg_data => l_msg_data
19039: l_msg_count := FND_MSG_PUB.count_msg;
19040: retcode := '2';
19041:
19042: IF l_msg_count >= 1 THEN
19043: PA_INTERFACE_UTILS_PUB.get_messages
19044: (p_encoded => FND_API.G_FALSE -- Bug 4348814 : Made false from true FND_API.G_TRUE
19045: ,p_msg_index => 1
19046: ,p_msg_count => l_msg_count
19047: ,p_msg_data => l_msg_data
21067: CLOSE cur_structure_type;
21068: END IF;
21069:
21070: IF l_msg_count = 1 and x_msg_data IS NULL THEN
21071: PA_INTERFACE_UTILS_PUB.get_messages
21072: (p_encoded => FND_API.G_TRUE
21073: ,p_msg_index => 1
21074: ,p_msg_count => l_msg_count
21075: ,p_msg_data => l_msg_data
21616: CLOSE cur_task_info;
21617: END IF;
21618:
21619: IF l_msg_count = 1 and x_msg_data IS NULL THEN
21620: PA_INTERFACE_UTILS_PUB.get_messages
21621: (p_encoded => FND_API.G_TRUE
21622: ,p_msg_index => 1
21623: ,p_msg_count => l_msg_count
21624: ,p_msg_data => l_msg_data
21771: x_return_status := FND_API.G_RET_STS_ERROR;
21772: l_msg_count := FND_MSG_PUB.count_msg;
21773:
21774: IF l_msg_count = 1 and x_msg_data IS NULL THEN
21775: PA_INTERFACE_UTILS_PUB.get_messages
21776: (p_encoded => FND_API.G_TRUE
21777: ,p_msg_index => 1
21778: ,p_msg_count => l_msg_count
21779: ,p_msg_data => l_msg_data
21866:
21867: x_return_status := FND_API.G_RET_STS_ERROR;
21868: l_msg_count := FND_MSG_PUB.count_msg;
21869: IF l_msg_count = 1 and x_msg_data IS NULL THEN
21870: PA_INTERFACE_UTILS_PUB.get_messages
21871: (p_encoded => FND_API.G_TRUE
21872: ,p_msg_index => 1
21873: ,p_msg_count => l_msg_count
21874: ,p_msg_data => l_msg_data
22067:
22068: x_return_status := FND_API.G_RET_STS_ERROR;
22069: l_msg_count := FND_MSG_PUB.count_msg;
22070: IF l_msg_count = 1 and x_msg_data IS NULL THEN
22071: PA_INTERFACE_UTILS_PUB.get_messages
22072: (p_encoded => FND_API.G_TRUE
22073: ,p_msg_index => 1
22074: ,p_msg_count => l_msg_count
22075: ,p_msg_data => l_msg_data
22111: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
22112: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
22113: ,p_validation_level IN VARCHAR2 := 100
22114: ,p_debug_mode IN VARCHAR2 := 'N'
22115: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22116: ,p_user_id IN NUMBER := FND_GLOBAL.USER_ID
22117: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22118: ,p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22119: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
22113: ,p_validation_level IN VARCHAR2 := 100
22114: ,p_debug_mode IN VARCHAR2 := 'N'
22115: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22116: ,p_user_id IN NUMBER := FND_GLOBAL.USER_ID
22117: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22118: ,p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22119: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
22120: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
22121: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22114: ,p_debug_mode IN VARCHAR2 := 'N'
22115: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22116: ,p_user_id IN NUMBER := FND_GLOBAL.USER_ID
22117: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22118: ,p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22119: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
22120: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
22121: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22122: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
22189: x_msg_count := 0;
22190: x_return_status := FND_API.G_RET_STS_SUCCESS;
22191:
22192: --Project name to id Conversion
22193: IF ((p_project_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND (p_project_name IS NOT NULL)) OR
22194: ((p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND (p_project_id IS NOT NULL)) THEN
22195: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
22196: p_project_name => p_project_name,
22197: p_project_id => p_project_id,
22190: x_return_status := FND_API.G_RET_STS_SUCCESS;
22191:
22192: --Project name to id Conversion
22193: IF ((p_project_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND (p_project_name IS NOT NULL)) OR
22194: ((p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND (p_project_id IS NOT NULL)) THEN
22195: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
22196: p_project_name => p_project_name,
22197: p_project_id => p_project_id,
22198: x_project_id => l_project_id,
22289:
22290: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
22291: x_msg_count := FND_MSG_PUB.count_msg;
22292: if x_msg_count = 1 then
22293: pa_interface_utils_pub.get_messages
22294: (p_encoded => FND_API.G_TRUE,
22295: p_msg_index => 1,
22296: p_msg_count => l_msg_count,
22297: p_msg_data => l_msg_data,
22371:
22372: l_Delimeter VARCHAR2(10);
22373: BEGIN
22374:
22375: IF (P_Delimeter = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
22376: l_Delimeter := ',';
22377: ELSE
22378: l_Delimeter := p_Delimeter;
22379: END IF;