eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_INTERFACE_UTILS_PUB

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

623: ,p_task_name IN VARCHAR2
624: ,p_task_description IN VARCHAR2
625: ,p_carrying_out_organization_id IN NUMBER
626: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
627: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
628: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
629: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
630: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
631: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

624: ,p_task_description IN VARCHAR2
625: ,p_carrying_out_organization_id IN NUMBER
626: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
627: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
628: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
629: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
630: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
631: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
632: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 629: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

625: ,p_carrying_out_organization_id IN NUMBER
626: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
627: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
628: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
629: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
630: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
631: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
632: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
633: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 630: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

626: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
627: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
628: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
629: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
630: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
631: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
632: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
633: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
634: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 631: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

627: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
628: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
629: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
630: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
631: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
632: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
633: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
634: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
635: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 632: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

628: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
629: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
630: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
631: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
632: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
633: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
634: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
635: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
636: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

629: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
630: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
631: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
632: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
633: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
634: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
635: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
636: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
637: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

630: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
631: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
632: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
633: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
634: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
635: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
636: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
637: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
638: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 635: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

631: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
632: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
633: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
634: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
635: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
636: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
637: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
638: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
639: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 636: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

632: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
633: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
634: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
635: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
636: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
637: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
638: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
639: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
640: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 637: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

633: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
634: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
635: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
636: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
637: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
638: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
639: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
640: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
641: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 638: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

634: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
635: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
636: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
637: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
638: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
639: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
640: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
641: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 639: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

635: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
636: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
637: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
638: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
639: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
640: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
641: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
643: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 640: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

636: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
637: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
638: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
639: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
640: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
641: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
643: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 641: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

637: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
638: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
639: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
640: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
641: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
643: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 642: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

638: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
639: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
640: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
641: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
643: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 643: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

639: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
640: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
641: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
643: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
647: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 644: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

640: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
641: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
643: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
647: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 645: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

641: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
643: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
647: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
649: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 646: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

642: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
643: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
647: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
649: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 647: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

643: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
647: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
649: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 648: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

644: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
647: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
649: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 649: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

645: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
647: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
649: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
653: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 650: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

646: ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
647: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
649: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
653: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 651: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

647: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
649: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
653: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
655: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 652: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

648: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
649: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
653: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
655: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
656: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 653: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

649: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
653: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
655: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
656: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
657: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 654: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

650: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
653: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
655: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
656: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
657: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
658: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 655: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

651: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
653: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
655: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
656: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
657: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
658: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
659: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 656: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

652: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
653: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
655: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
656: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
657: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
658: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
659: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
660: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 657: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

653: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
655: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
656: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
657: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
658: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
659: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
660: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
661: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 658: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

654: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
655: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
656: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
657: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
658: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
659: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
660: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
661: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
662: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 659: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

655: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
656: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
657: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
658: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
659: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
660: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
661: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
662: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
663: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

656: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
657: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
658: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
659: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
660: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
661: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
662: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
663: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
664: ,p_create_task_version_only IN VARCHAR2 := 'N'

Line 661: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

657: ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
658: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
659: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
660: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
661: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
662: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
663: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
664: ,p_create_task_version_only IN VARCHAR2 := 'N'
665: ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192

Line 662: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

658: ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
659: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
660: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
661: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
662: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
663: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
664: ,p_create_task_version_only IN VARCHAR2 := 'N'
665: ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
666:

Line 663: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

659: ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
660: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
661: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
662: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
663: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
664: ,p_create_task_version_only IN VARCHAR2 := 'N'
665: ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
666:
667: -- (begin venkat) new params for bug #3450684 ----------------------------------------------

Line 668: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684

664: ,p_create_task_version_only IN VARCHAR2 := 'N'
665: ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
666:
667: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
668: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
669: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
670: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
671: -- (end venkat) new params for bug #3450684 -------------------------------------------------
672:

Line 669: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684

665: ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
666:
667: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
668: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
669: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
670: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
671: -- (end venkat) new params for bug #3450684 -------------------------------------------------
672:
673: -- (begin) add new params bug - 3654243 -----

Line 670: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684

666:
667: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
668: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
669: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
670: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
671: -- (end venkat) new params for bug #3450684 -------------------------------------------------
672:
673: -- (begin) add new params bug - 3654243 -----
674: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 674: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

670: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
671: -- (end venkat) new params for bug #3450684 -------------------------------------------------
672:
673: -- (begin) add new params bug - 3654243 -----
674: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
675: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
676: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
677: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
678: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 675: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

671: -- (end venkat) new params for bug #3450684 -------------------------------------------------
672:
673: -- (begin) add new params bug - 3654243 -----
674: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
675: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
676: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
677: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
678: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
679: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 676: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

672:
673: -- (begin) add new params bug - 3654243 -----
674: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
675: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
676: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
677: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
678: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
679: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
680: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 677: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

673: -- (begin) add new params bug - 3654243 -----
674: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
675: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
676: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
677: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
678: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
679: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
680: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
681: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 678: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

674: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
675: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
676: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
677: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
678: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
679: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
680: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
681: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
682: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 679: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

675: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
676: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
677: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
678: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
679: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
680: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
681: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
682: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
683: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 680: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

676: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
677: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
678: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
679: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
680: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
681: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
682: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
683: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
684: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 681: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

677: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
678: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
679: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
680: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
681: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
682: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
683: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
684: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
685: -- (end) add new params bug - 3654243 -----

Line 682: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

678: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
679: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
680: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
681: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
682: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
683: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
684: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
685: -- (end) add new params bug - 3654243 -----
686:

Line 683: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

679: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
680: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
681: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
682: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
683: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
684: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
685: -- (end) add new params bug - 3654243 -----
686:
687: --Bug 6153503

Line 684: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

680: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
681: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
682: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
683: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
684: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
685: -- (end) add new params bug - 3654243 -----
686:
687: --Bug 6153503
688: ,p_validate_dff IN VARCHAR2 := 'N'

Line 689: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

685: -- (end) add new params bug - 3654243 -----
686:
687: --Bug 6153503
688: ,p_validate_dff IN VARCHAR2 := 'N'
689: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
690: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
691: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
693: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 690: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

686:
687: --Bug 6153503
688: ,p_validate_dff IN VARCHAR2 := 'N'
689: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
690: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
691: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
693: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
694: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 691: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

687: --Bug 6153503
688: ,p_validate_dff IN VARCHAR2 := 'N'
689: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
690: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
691: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
693: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
694: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
695: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 692: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

688: ,p_validate_dff IN VARCHAR2 := 'N'
689: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
690: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
691: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
693: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
694: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
695: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
696: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 693: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

689: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
690: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
691: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
693: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
694: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
695: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
696: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
697: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 694: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

690: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
691: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
693: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
694: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
695: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
696: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
697: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
698: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 695: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

691: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
693: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
694: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
695: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
696: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
697: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
698: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
699: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 696: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

692: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
693: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
694: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
695: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
696: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
697: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
698: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
699: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
700: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 697: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

693: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
694: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
695: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
696: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
697: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
698: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
699: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
700: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
701: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 698: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

694: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
695: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
696: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
697: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
698: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
699: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
700: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
701: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
702: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 699: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

695: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
696: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
697: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
698: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
699: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
700: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
701: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
702: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
703: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 700: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

696: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
697: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
698: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
699: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
700: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
701: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
702: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
703: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
704: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 701: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

697: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
698: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
699: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
700: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
701: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
702: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
703: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
704: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
705: --Bug 6153503

Line 702: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

698: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
699: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
700: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
701: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
702: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
703: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
704: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
705: --Bug 6153503
706:

Line 703: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

699: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
700: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
701: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
702: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
703: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
704: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
705: --Bug 6153503
706:
707: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 704: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

700: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
701: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
702: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
703: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
704: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
705: --Bug 6153503
706:
707: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
708: ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1061: IF p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1057:
1058: l_versioned := PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id);
1059: l_shared := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
1060:
1061: IF p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1062: THEN
1063: l_task_id := p_task_id;
1064: ELSE
1065: l_task_id := null;

Line 1071: IF p_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_task_number IS NULL

1067:
1068: IF p_structure_type = 'WORKPLAN'
1069: THEN
1070: --The following logic found in add_task_round_one api
1071: IF p_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_task_number IS NULL
1072: THEN
1073: l_task_number := P_PM_SOURCE_reference;
1074: ELSE
1075: l_task_number := p_task_number;

Line 1094: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1090: END IF;
1091: --
1092:
1093: IF p_structure_version_id IS NULL OR
1094: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1095: THEN
1096: --proj conn
1097: --If auto publish upon creation is on and versioning is enabled then
1098: --update the workplan structure as working bcoz it is created as pub by copy structure.

Line 1161: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1157: END IF;
1158: --
1159:
1160: IF p_structure_version_id IS NULL OR
1161: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1162: THEN
1163: IF l_template_flag = 'N'
1164: THEN
1165:

Line 1204: p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1200: will be null in this case. If a structure version is in approved, submitted or rejected state, then it
1201: will never be returned from cursor cur_struc_ver_wp, so how can we get the status of a null struc ver.
1202:
1203: IF p_structure_version_id IS NOT NULL AND
1204: p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1205: THEN
1206: --Validate the incoming structure version id
1207:
1208: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id(

Line 1246: IF p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1242: ***/
1243:
1244: /* New Code Begin for Bug 2736392 -- Commnted the above code*/
1245:
1246: IF p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1247: THEN
1248: l_str_status_code := PA_PROJECT_STRUCTURE_UTILS.get_structrue_version_status
1249: ( p_project_id => p_project_id
1250: ,p_structure_version_id => p_structure_version_id );

Line 1426: p_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1422: --ref task version id. There is only one cursor cur_proj_elem_vers that takes structure type
1423: /* ELSIF p_structure_type = 'WORKPLAN'
1424: THEN
1425: IF p_parent_task_id IS NOT NULL AND p_parent_task_id <> l_task_id AND
1426: p_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1427: THEN
1428: l_peer_or_sub := 'SUB';
1429: --get reference task version id
1430: OPEN cur_proj_elem_vers2( l_structure_version_id, p_parent_task_id );

Line 1454: ELSIF ( p_parent_task_id IS NULL OR p_parent_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1450: and proj_element_id = p_parent_task_id;
1451: END IF;
1452: --Bug 2732907
1453:
1454: ELSIF ( p_parent_task_id IS NULL OR p_parent_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1455: --proj conn
1456: AND ( p_ref_task_id is null OR p_ref_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
1457: --proj conn
1458: THEN

Line 1456: AND ( p_ref_task_id is null OR p_ref_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

1452: --Bug 2732907
1453:
1454: ELSIF ( p_parent_task_id IS NULL OR p_parent_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1455: --proj conn
1456: AND ( p_ref_task_id is null OR p_ref_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
1457: --proj conn
1458: THEN
1459: --get structure version if its a top task
1460: l_ref_task_version_id := l_structure_version_id;

Line 1474: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1470:
1471: l_peer_or_sub := 'SUB';
1472: */
1473: /*IF p_structure_version_id IS NULL OR
1474: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1475: THEN
1476: OPEN cur_struc_ver_wp;
1477: FETCH cur_struc_ver_wp INTO l_ref_task_version_id;
1478: CLOSE cur_struc_ver_wp;

Line 1483: /* ELSIF p_ref_task_id IS NOT NULL AND p_ref_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1479: ELSE
1480: l_ref_task_version_id := p_structure_version_id;
1481: END IF;
1482: */
1483: /* ELSIF p_ref_task_id IS NOT NULL AND p_ref_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1484: THEN
1485: l_weighting := 0;
1486: OPEN cur_proj_elem_vers2( l_structure_version_id, p_ref_task_id );
1487: FETCH cur_proj_elem_vers2 INTO l_ref_task_version_id;

Line 1721: IF (p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

1717: FETCH cur_ver_sch_attr_rec INTO l_ver_sch_attr_rec;
1718: CLOSE cur_ver_sch_attr_rec;
1719:
1720: --hsiu: added for bug 2691868
1721: IF (p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
1722: l_scheduled_start_date := sysdate;
1723: ELSE
1724: l_scheduled_start_date := p_scheduled_start_date;
1725: END IF;

Line 1727: IF (p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

1723: ELSE
1724: l_scheduled_start_date := p_scheduled_start_date;
1725: END IF;
1726:
1727: IF (p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
1728: l_scheduled_finish_date := sysdate;
1729: ELSE
1730: l_scheduled_finish_date := p_scheduled_finish_date;
1731: END IF;

Line 1744: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN

1740: */
1741:
1742: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
1743: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
1744: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN
1745: l_wq_planned_quantity := NULL;
1746: END IF;
1747: ELSE
1748: l_wq_planned_quantity := P_PLANNED_WORK_QUANTITY; --bug 2826992

Line 1756: p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1752: --bug 2824612
1753:
1754: --Bug 6153503 start
1755: if (--p_attribute_category is null or
1756: p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1757: then
1758: l_attribute_category := l_ver_sch_attr_rec.attribute_category;
1759: else
1760: l_attribute_category := p_attribute_category;

Line 1766: p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1762:
1763:
1764:
1765: if (--p_attribute1 is null or
1766: p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1767: then
1768: l_attribute1 := l_ver_sch_attr_rec.attribute1;
1769: else
1770: l_attribute1 := p_attribute1;

Line 1776: p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1772:
1773:
1774:
1775: if (--p_attribute2 is null or
1776: p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1777: then
1778: l_attribute2 := l_ver_sch_attr_rec.attribute2;
1779: else
1780: l_attribute2 := p_attribute2;

Line 1785: p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1781: end if;
1782:
1783:
1784: if (--p_attribute3 is null or
1785: p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1786: then
1787: l_attribute3 := l_ver_sch_attr_rec.attribute3;
1788: else
1789: l_attribute3 := p_attribute3;

Line 1793: p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1789: l_attribute3 := p_attribute3;
1790: end if;
1791:
1792: if (--p_attribute4 is null or
1793: p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1794: then
1795: l_attribute4 := l_ver_sch_attr_rec.attribute4;
1796: else
1797: l_attribute4 := p_attribute4;

Line 1801: p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1797: l_attribute4 := p_attribute4;
1798: end if;
1799:
1800: if (--p_attribute5 is null or
1801: p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1802: then
1803: l_attribute5 := l_ver_sch_attr_rec.attribute5;
1804: else
1805: l_attribute5 := p_attribute5;

Line 1809: p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1805: l_attribute5 := p_attribute5;
1806: end if;
1807:
1808: if (--p_attribute6 is null or
1809: p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1810: then
1811: l_attribute6 := l_ver_sch_attr_rec.attribute6;
1812: else
1813: l_attribute6 := p_attribute6;

Line 1817: p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Changed for Bug #6153681

1813: l_attribute6 := p_attribute6;
1814: end if;
1815:
1816: if (--p_attribute7 is null or
1817: p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Changed for Bug #6153681
1818: then
1819: l_attribute7 := l_ver_sch_attr_rec.attribute7;
1820: else
1821: l_attribute7 := p_attribute7;

Line 1825: p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1821: l_attribute7 := p_attribute7;
1822: end if;
1823:
1824: if (--p_attribute8 is null or
1825: p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1826: then
1827: l_attribute8 := l_ver_sch_attr_rec.attribute8;
1828: else
1829: l_attribute8 := p_attribute8;

Line 1833: p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1829: l_attribute8 := p_attribute8;
1830: end if;
1831:
1832: if (--p_attribute9 is null or
1833: p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1834: then
1835: l_attribute9 := l_ver_sch_attr_rec.attribute9;
1836: else
1837: l_attribute9 := p_attribute9;

Line 1841: p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1837: l_attribute9 := p_attribute9;
1838: end if;
1839:
1840: if (--p_attribute10 is null or
1841: p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1842: then
1843: l_attribute10 := l_ver_sch_attr_rec.attribute10;
1844: else
1845: l_attribute10 := p_attribute10;

Line 1849: p_attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1845: l_attribute10 := p_attribute10;
1846: end if;
1847:
1848: if (--p_attribute10 is null or
1849: p_attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1850: then
1851: l_attribute11 := l_ver_sch_attr_rec.attribute11;
1852: else
1853: l_attribute11 := p_attribute11;

Line 1857: p_attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1853: l_attribute11 := p_attribute11;
1854: end if;
1855:
1856: if (--p_attribute10 is null or
1857: p_attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1858: then
1859: l_attribute12 := l_ver_sch_attr_rec.attribute12;
1860: else
1861: l_attribute12 := p_attribute12;

Line 1865: p_attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1861: l_attribute12 := p_attribute12;
1862: end if;
1863:
1864: if (--p_attribute10 is null or
1865: p_attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1866: then
1867: l_attribute13 := l_ver_sch_attr_rec.attribute13;
1868: else
1869: l_attribute13 := p_attribute13;

Line 1873: p_attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1869: l_attribute13 := p_attribute13;
1870: end if;
1871:
1872: if (--p_attribute10 is null or
1873: p_attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1874: then
1875: l_attribute14 := l_ver_sch_attr_rec.attribute14;
1876: else
1877: l_attribute14 := p_attribute14;

Line 1882: p_attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1878: end if;
1879:
1880:
1881: if (--p_attribute10 is null or
1882: p_attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1883: then
1884: l_attribute15 := l_ver_sch_attr_rec.attribute15;
1885: else
1886: l_attribute15 := p_attribute15;

Line 1891: --if l_attribute_category is not null and l_attribute_category <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1887: end if;
1888:
1889: --if added while fixing BUG 3919800
1890: --Add validation for PA_PROJ_ELEM_VER_SCH_DESC_FLEX
1891: --if l_attribute_category is not null and l_attribute_category <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1892: --then
1893: IF p_validate_dff = 'Y' THEN
1894: pa_task_utils.validate_flex_fields(
1895: p_desc_flex_name => 'PA_PROJ_ELEM_VER_SCH_DESC_FLEX'

Line 1922: pa_interface_utils_pub.map_new_amg_msg

1918: IF l_validate_status = 'N'
1919: THEN
1920: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1921: THEN
1922: pa_interface_utils_pub.map_new_amg_msg
1923: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
1924: ,p_msg_attribute => 'CHANGE'
1925: ,p_resize_flag => 'N'
1926: ,p_msg_context => 'FLEX'

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

2167: ,p_task_manager_id IN NUMBER
2168: ,p_pm_product_code IN VARCHAR2
2169: ,p_pm_task_reference IN VARCHAR2
2170: ,p_location_id IN NUMBER
2171: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2172: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2173: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2174: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2175: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

2168: ,p_pm_product_code IN VARCHAR2
2169: ,p_pm_task_reference IN VARCHAR2
2170: ,p_location_id IN NUMBER
2171: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2172: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2173: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2174: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2175: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2176: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2173: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2169: ,p_pm_task_reference IN VARCHAR2
2170: ,p_location_id IN NUMBER
2171: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2172: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2173: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2174: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2175: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2176: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2177: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2174: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2170: ,p_location_id IN NUMBER
2171: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2172: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2173: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2174: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2175: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2176: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2177: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2178: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2175: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2171: ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2172: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2173: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2174: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2175: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2176: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2177: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2178: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2179: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2176: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2172: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2173: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2174: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2175: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2176: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2177: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2178: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2179: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2180: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

2173: ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2174: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2175: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2176: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2177: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2178: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2179: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2180: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2181: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

2174: ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2175: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2176: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2177: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2178: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2179: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2180: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2181: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2182: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2179: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2175: ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2176: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2177: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2178: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2179: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2180: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2181: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2182: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2183: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2180: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2176: ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2177: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2178: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2179: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2180: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2181: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2182: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2183: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2184: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2181: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2177: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2178: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2179: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2180: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2181: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2182: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2183: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2184: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2185: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 2182: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2178: ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2179: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2180: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2181: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2182: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2183: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2184: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2185: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2186: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2183: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2179: ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2180: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2181: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2182: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2183: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2184: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2185: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2186: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2187: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2184: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2180: ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2181: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2182: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2183: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2184: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2185: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2186: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2187: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2188: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2185: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2181: ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2182: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2183: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2184: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2185: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2186: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2187: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2188: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2189: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2186: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2182: ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2183: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2184: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2185: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2186: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2187: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2188: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2189: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2190: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2187: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2183: ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2184: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2185: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2186: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2187: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2188: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2189: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2190: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2191: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2188: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2184: ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2185: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2186: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2187: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2188: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2189: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2190: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2191: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2192: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2189: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2185: ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2186: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2187: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2188: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2189: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2190: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2191: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2192: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2193: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2190: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2186: ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2187: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2188: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2189: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2190: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2191: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2192: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2193: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2194: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2191: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2187: ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2188: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2189: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2190: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2191: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2192: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2193: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2194: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2195: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2192: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2188: ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2189: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2190: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2191: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2192: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2193: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2194: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2195: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2196: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2193: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2189: ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2190: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2191: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2192: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2193: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2194: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2195: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2196: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2197: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2194: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2190: ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2191: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2192: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2193: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2194: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2195: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2196: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2197: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2198: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2195: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2191: ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2192: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2193: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2194: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2195: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2196: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2197: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2198: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2199: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2196: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2192: ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2193: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2194: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2195: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2196: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2197: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2198: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2199: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2200: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2197: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2193: ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2194: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2195: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2196: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2197: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2198: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2199: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2200: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2201: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2198: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2194: ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2195: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2196: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2197: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2198: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2199: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2200: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2201: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2202: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2199: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2195: ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2196: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2197: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2198: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2199: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2200: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2201: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2202: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2203: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

2196: ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2197: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2198: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2199: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2200: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2201: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2202: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2203: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2204: -- (begin venkat) new params for bug #3450684 ----------------------------------------------

Line 2201: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2197: ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2198: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2199: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2200: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2201: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2202: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2203: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2204: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2205: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684

Line 2202: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2198: ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2199: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2200: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2201: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2202: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2203: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2204: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2205: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2206: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684

Line 2203: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2199: ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2200: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2201: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2202: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2203: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2204: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2205: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2206: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2207: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684

Line 2205: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684

2201: ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2202: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2203: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2204: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2205: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2206: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2207: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2208: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2209: -- (begin) add new params bug - 3654243 -----

Line 2206: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684

2202: ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2203: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2204: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2205: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2206: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2207: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2208: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2209: -- (begin) add new params bug - 3654243 -----
2210: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2207: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684

2203: ,P_PHASE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2204: -- (begin venkat) new params for bug #3450684 ----------------------------------------------
2205: ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2206: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2207: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2208: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2209: -- (begin) add new params bug - 3654243 -----
2210: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2211: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2210: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2206: ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2207: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2208: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2209: -- (begin) add new params bug - 3654243 -----
2210: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2211: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2212: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2213: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2214: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2211: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2207: ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
2208: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2209: -- (begin) add new params bug - 3654243 -----
2210: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2211: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2212: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2213: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2214: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2215: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2212: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2208: -- (end venkat) new params for bug #3450684 -------------------------------------------------
2209: -- (begin) add new params bug - 3654243 -----
2210: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2211: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2212: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2213: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2214: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2215: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2216: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2213: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2209: -- (begin) add new params bug - 3654243 -----
2210: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2211: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2212: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2213: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2214: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2215: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2216: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2217: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2214: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2210: ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2211: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2212: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2213: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2214: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2215: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2216: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2217: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2218: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2215: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2211: ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2212: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2213: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2214: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2215: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2216: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2217: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2218: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2219: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2216: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2212: ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2213: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2214: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2215: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2216: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2217: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2218: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2219: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2220: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2217: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2213: ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2214: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2215: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2216: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2217: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2218: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2219: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2220: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2221: -- (end) add new params bug - 3654243 -----

Line 2218: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2214: ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2215: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2216: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2217: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2218: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2219: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2220: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2221: -- (end) add new params bug - 3654243 -----
2222: -- Progress Management Changes. Bug # 3420093.

Line 2219: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2215: ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2216: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2217: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2218: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2219: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2220: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2221: -- (end) add new params bug - 3654243 -----
2222: -- Progress Management Changes. Bug # 3420093.
2223: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2220: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2216: ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2217: ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2218: ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2219: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2220: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2221: -- (end) add new params bug - 3654243 -----
2222: -- Progress Management Changes. Bug # 3420093.
2223: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2224: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2223: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2219: ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2220: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2221: -- (end) add new params bug - 3654243 -----
2222: -- Progress Management Changes. Bug # 3420093.
2223: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2224: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2225: -- Progress Management Changes. Bug # 3420093.
2226: -- rtarway, BUG 3908013
2227: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2224: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2220: ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2221: -- (end) add new params bug - 3654243 -----
2222: -- Progress Management Changes. Bug # 3420093.
2223: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2224: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2225: -- Progress Management Changes. Bug # 3420093.
2226: -- rtarway, BUG 3908013
2227: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2228: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2227: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2223: ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2224: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2225: -- Progress Management Changes. Bug # 3420093.
2226: -- rtarway, BUG 3908013
2227: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2228: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2229: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2230: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2231: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2228: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2224: ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2225: -- Progress Management Changes. Bug # 3420093.
2226: -- rtarway, BUG 3908013
2227: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2228: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2229: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2230: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2231: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2232: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2229: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2225: -- Progress Management Changes. Bug # 3420093.
2226: -- rtarway, BUG 3908013
2227: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2228: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2229: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2230: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2231: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2232: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2233: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2230: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2226: -- rtarway, BUG 3908013
2227: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2228: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2229: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2230: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2231: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2232: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2233: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2234: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2231: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2227: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2228: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2229: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2230: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2231: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2232: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2233: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2234: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2235: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2232: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2228: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2229: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2230: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2231: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2232: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2233: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2234: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2235: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2236: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2233: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2229: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2230: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2231: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2232: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2233: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2234: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2235: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2236: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2237: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2234: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2230: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2231: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2232: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2233: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2234: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2235: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2236: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2237: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2238: --Bug 6153503

Line 2235: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2231: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2232: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2233: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2234: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2235: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2236: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2237: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2238: --Bug 6153503
2239: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2236: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2232: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2233: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2234: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2235: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2236: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2237: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2238: --Bug 6153503
2239: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2240: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2237: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2233: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2234: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2235: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2236: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2237: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2238: --Bug 6153503
2239: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2240: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2241: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2239: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2235: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2236: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2237: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2238: --Bug 6153503
2239: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2240: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2241: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2242: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2243: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2240: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2236: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2237: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2238: --Bug 6153503
2239: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2240: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2241: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2242: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2243: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2244: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2241: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2237: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2238: --Bug 6153503
2239: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2240: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2241: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2242: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2243: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2244: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2245: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2242: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2238: --Bug 6153503
2239: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2240: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2241: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2242: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2243: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2244: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2245: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2246: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2243: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2239: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2240: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2241: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2242: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2243: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2244: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2245: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2246: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2247: ) IS

Line 2570: IF ( p_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_task_number IS NOT NULL)

2566: CLOSE cur_task_attr;
2567: --dbms_output.put_line(('Value of p_task_number' ||p_task_number);
2568: --dbms_output.put_line(('Value of l_task_number' ||l_task_number);
2569:
2570: IF ( p_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_task_number IS NOT NULL)
2571: /* bug#5243018 : Reverting the fix in Bug 4120380
2572: AND nvl(p_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
2573: nvl(l_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) --check added for BUg 4120380 Aditi */
2574: THEN

Line 2572: AND nvl(p_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>

2568: --dbms_output.put_line(('Value of l_task_number' ||l_task_number);
2569:
2570: IF ( p_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_task_number IS NOT NULL)
2571: /* bug#5243018 : Reverting the fix in Bug 4120380
2572: AND nvl(p_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
2573: nvl(l_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) --check added for BUg 4120380 Aditi */
2574: THEN
2575: l_task_number := p_task_number;
2576: /* bug#5243018 : Reverting the fix in Bug 4120380

Line 2573: nvl(l_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) --check added for BUg 4120380 Aditi */

2569:
2570: IF ( p_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_task_number IS NOT NULL)
2571: /* bug#5243018 : Reverting the fix in Bug 4120380
2572: AND nvl(p_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
2573: nvl(l_task_number,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) --check added for BUg 4120380 Aditi */
2574: THEN
2575: l_task_number := p_task_number;
2576: /* bug#5243018 : Reverting the fix in Bug 4120380
2577: -- dbms_output.put_line('printed once');

Line 2588: IF ( p_task_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_task_name IS NOT NULL )

2584: After updating all the tasks in the script, code again updates the task_number, trimming the '-' added. **/
2585: END IF;
2586: --dbms_output.put_line('Value of l_task_number' ||l_task_number);
2587:
2588: IF ( p_task_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_task_name IS NOT NULL )
2589: THEN
2590: l_task_name := p_task_name;
2591: END IF;
2592:

Line 2596: IF ( p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2592:
2593: /* End of code added for bug 3290037 */
2594: --Begin add by rtarway for BUG 3666023
2595: --3663712, changed 'OR' to and 'AND' in following If condition
2596: IF ( p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2597: THEN
2598: l_task_id := p_task_id;
2599: ELSIF
2600: ( p_pm_task_reference IS NOT NULL AND p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )

Line 2600: ( p_pm_task_reference IS NOT NULL AND p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )

2596: IF ( p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2597: THEN
2598: l_task_id := p_task_id;
2599: ELSIF
2600: ( p_pm_task_reference IS NOT NULL AND p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
2601: THEN
2602: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all
2603: (p_pa_project_id => p_project_id
2604: ,p_pm_task_reference => p_pm_task_reference

Line 2666: AND p_ref_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3701460

2662: END IF;
2663:
2664: IF p_calling_module = 'AMG' AND
2665: p_ref_task_id is NOT NULL --to make sure that hierarchy is changed.
2666: AND p_ref_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3701460
2667: --if p_ref_task_id is null then there is no hierarchy change
2668: --It is also true that it is not necessary that the hierarchy is changed even if
2669: --it p_ref_task_id is NOT null.
2670: THEN

Line 2673: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2669: --it p_ref_task_id is NOT null.
2670: THEN
2671:
2672: IF p_structure_version_id IS NULL OR
2673: p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2674: THEN
2675:
2676: IF p_structure_type = 'FINANCIAL'
2677: THEN

Line 2705: p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2701: will be null in this case. If a structure version is in approved, submitted or rejected state, then it
2702: will never be returned from cursor cur_struc_ver_wp, so how can we get the status of a null struc ver.
2703:
2704: IF p_structure_version_id IS NOT NULL AND
2705: p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2706: THEN
2707: --Validate the incoming structure version id
2708: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id(
2709: p_structure_id => null

Line 2743: IF p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2739: END IF;
2740: ***/
2741: /* New Code Begin for Bug 2736392 -- Commnted the above code*/
2742:
2743: IF p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2744: THEN
2745: l_str_status_code := PA_PROJECT_STRUCTURE_UTILS.get_structrue_version_status
2746: ( p_project_id => p_project_id
2747: ,p_structure_version_id => p_structure_version_id );

Line 3007: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN

3003: AND project_id = p_project_id;
3004:
3005: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
3006: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
3007: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN
3008: l_wq_planned_quantity := NULL;
3009: END IF;
3010: ELSE
3011: l_wq_planned_quantity := P_PLANNED_WORK_QUANTITY; --bug 2826992

Line 3019: p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3015:
3016: --Bug 6153503 start
3017: -- rtarway, BUG 3908013
3018: if (--p_attribute_category is null or
3019: p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3020: then
3021: l_attribute_category := l_ver_sch_attr_rec.attribute_category;
3022: else
3023: l_attribute_category := p_attribute_category;

Line 3029: p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3025:
3026:
3027:
3028: if (--p_attribute1 is null or
3029: p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3030: then
3031: l_attribute1 := l_ver_sch_attr_rec.attribute1;
3032: else
3033: l_attribute1 := p_attribute1;

Line 3039: p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3035:
3036:
3037:
3038: if (--p_attribute2 is null or
3039: p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3040: then
3041: l_attribute2 := l_ver_sch_attr_rec.attribute2;
3042: else
3043: l_attribute2 := p_attribute2;

Line 3048: p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3044: end if;
3045:
3046:
3047: if (--p_attribute3 is null or
3048: p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3049: then
3050: l_attribute3 := l_ver_sch_attr_rec.attribute3;
3051: else
3052: l_attribute3 := p_attribute3;

Line 3056: p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3052: l_attribute3 := p_attribute3;
3053: end if;
3054:
3055: if (--p_attribute4 is null or
3056: p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3057: then
3058: l_attribute4 := l_ver_sch_attr_rec.attribute4;
3059: else
3060: l_attribute4 := p_attribute4;

Line 3064: p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3060: l_attribute4 := p_attribute4;
3061: end if;
3062:
3063: if (--p_attribute5 is null or
3064: p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3065: then
3066: l_attribute5 := l_ver_sch_attr_rec.attribute5;
3067: else
3068: l_attribute5 := p_attribute5;

Line 3072: p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3068: l_attribute5 := p_attribute5;
3069: end if;
3070:
3071: if (--p_attribute6 is null or
3072: p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3073: then
3074: l_attribute6 := l_ver_sch_attr_rec.attribute6;
3075: else
3076: l_attribute6 := p_attribute6;

Line 3080: p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Changed for Bug #6153681

3076: l_attribute6 := p_attribute6;
3077: end if;
3078:
3079: if (--p_attribute7 is null or
3080: p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Changed for Bug #6153681
3081: then
3082: l_attribute7 := l_ver_sch_attr_rec.attribute7;
3083: else
3084: l_attribute7 := p_attribute7;

Line 3088: p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3084: l_attribute7 := p_attribute7;
3085: end if;
3086:
3087: if (--p_attribute8 is null or
3088: p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3089: then
3090: l_attribute8 := l_ver_sch_attr_rec.attribute8;
3091: else
3092: l_attribute8 := p_attribute8;

Line 3096: p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3092: l_attribute8 := p_attribute8;
3093: end if;
3094:
3095: if (--p_attribute9 is null or
3096: p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3097: then
3098: l_attribute9 := l_ver_sch_attr_rec.attribute9;
3099: else
3100: l_attribute9 := p_attribute9;

Line 3104: p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3100: l_attribute9 := p_attribute9;
3101: end if;
3102:
3103: if (--p_attribute10 is null or
3104: p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3105: then
3106: l_attribute10 := l_ver_sch_attr_rec.attribute10;
3107: else
3108: l_attribute10 := p_attribute10;

Line 3112: p_attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3108: l_attribute10 := p_attribute10;
3109: end if;
3110:
3111: if (--p_attribute10 is null or
3112: p_attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3113: then
3114: l_attribute11 := l_ver_sch_attr_rec.attribute11;
3115: else
3116: l_attribute11 := p_attribute11;

Line 3120: p_attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3116: l_attribute11 := p_attribute11;
3117: end if;
3118:
3119: if (--p_attribute10 is null or
3120: p_attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3121: then
3122: l_attribute12 := l_ver_sch_attr_rec.attribute12;
3123: else
3124: l_attribute12 := p_attribute12;

Line 3128: p_attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3124: l_attribute12 := p_attribute12;
3125: end if;
3126:
3127: if (--p_attribute10 is null or
3128: p_attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3129: then
3130: l_attribute13 := l_ver_sch_attr_rec.attribute13;
3131: else
3132: l_attribute13 := p_attribute13;

Line 3136: p_attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3132: l_attribute13 := p_attribute13;
3133: end if;
3134:
3135: if (--p_attribute10 is null or
3136: p_attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3137: then
3138: l_attribute14 := l_ver_sch_attr_rec.attribute14;
3139: else
3140: l_attribute14 := p_attribute14;

Line 3145: p_attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3141: end if;
3142:
3143:
3144: if (--p_attribute10 is null or
3145: p_attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3146: then
3147: l_attribute15 := l_ver_sch_attr_rec.attribute15;
3148: else
3149: l_attribute15 := p_attribute15;

Line 3155: -- if l_attribute_category is not null and l_attribute_category <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3151:
3152:
3153: --if added while fixing BUG 3919800
3154: --Add validation for PA_PROJ_ELEM_VER_SCH_DESC_FLEX
3155: -- if l_attribute_category is not null and l_attribute_category <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3156: -- then
3157: pa_task_utils.validate_flex_fields(
3158: p_desc_flex_name => 'PA_PROJ_ELEM_VER_SCH_DESC_FLEX'
3159: ,p_attribute_category => l_attribute_category

Line 3184: pa_interface_utils_pub.map_new_amg_msg

3180: IF l_validate_status = 'N'
3181: THEN
3182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3183: THEN
3184: pa_interface_utils_pub.map_new_amg_msg
3185: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
3186: ,p_msg_attribute => 'CHANGE'
3187: ,p_resize_flag => 'N'
3188: ,p_msg_context => 'FLEX'

Line 3555: p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

3551:
3552: SAVEPOINT delete_task_struc;
3553:
3554: IF p_task_version_id IS NULL OR
3555: p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
3556: p_task_version_id = -9999
3557: THEN
3558:
3559: -- bug 2765115

Line 4104: pa_interface_utils_pub.get_messages

4100: l_msg_count := FND_MSG_PUB.count_msg;
4101: if l_msg_count > 0 then
4102: x_msg_count := l_msg_count;
4103: if x_msg_count = 1 then
4104: pa_interface_utils_pub.get_messages
4105: (p_encoded => FND_API.G_TRUE,
4106: p_msg_index => 1,
4107: p_msg_count => l_msg_count,
4108: p_msg_data => l_msg_data,

Line 4134: pa_interface_utils_pub.get_messages

4130: l_msg_count := FND_MSG_PUB.count_msg;
4131: if l_msg_count > 0 then
4132: x_msg_count := l_msg_count;
4133: if x_msg_count = 1 then
4134: pa_interface_utils_pub.get_messages
4135: (p_encoded => FND_API.G_TRUE,
4136: p_msg_index => 1,
4137: p_msg_count => l_msg_count,
4138: p_msg_data => l_msg_data,

Line 4250: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4246:
4247: PROCEDURE Copy_Structure(
4248: p_src_project_id IN NUMBER
4249: ,p_dest_project_id IN NUMBER
4250: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4251: ,p_copy_task_flag IN VARCHAR2 := 'Y'
4252: ,p_dest_template_flag IN VARCHAR2 := 'N' --bug 2805602
4253: ,p_src_template_flag IN VARCHAR2 := 'N' --bug 2805602
4254: ,p_dest_project_name IN VARCHAR2 --bug 2805602

Line 4347: pa_interface_utils_pub.get_messages

4343: l_msg_count := FND_MSG_PUB.count_msg;
4344: if l_msg_count > 0 then
4345: x_msg_count := l_msg_count;
4346: if x_msg_count = 1 then
4347: pa_interface_utils_pub.get_messages
4348: (p_encoded => FND_API.G_TRUE,
4349: p_msg_index => 1,
4350: p_msg_count => l_msg_count,
4351: p_msg_data => l_msg_data,

Line 4514: p_tasks_in(l_index_number-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4510: end loop;
4511:
4512: IF l_index_number > l_first_index1 AND
4513: p_tasks_in(l_index_number-1).pa_task_id IS NOT NULL AND
4514: p_tasks_in(l_index_number-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4515: --existing task becomes the ref_task_id
4516: THEN
4517: v_task_id_above := p_tasks_in(l_index_number-1).pa_task_id; --Get the task above.
4518: ELSIF l_index_number > l_first_index1 AND

Line 4520: p_tasks_out(l_index_number-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4516: THEN
4517: v_task_id_above := p_tasks_in(l_index_number-1).pa_task_id; --Get the task above.
4518: ELSIF l_index_number > l_first_index1 AND
4519: p_tasks_out(l_index_number-1).pa_task_id IS NOT NULL AND
4520: p_tasks_out(l_index_number-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4521: --new task becomes the ref_task_id
4522: THEN
4523: v_task_id_above := p_tasks_out(l_index_number-1).pa_task_id; --Get the task above created newly
4524: ELSIF ( p_tasks_in(l_index_number).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

Line 4524: ELSIF ( p_tasks_in(l_index_number).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

4520: p_tasks_out(l_index_number-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4521: --new task becomes the ref_task_id
4522: THEN
4523: v_task_id_above := p_tasks_out(l_index_number-1).pa_task_id; --Get the task above created newly
4524: ELSIF ( p_tasks_in(l_index_number).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4525: p_tasks_in(l_index_number).pa_task_id IS NULL
4526: ) AND
4527: l_index_number = l_first_index1
4528: THEN

Line 4599: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4595: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4596: ,p_validation_level IN VARCHAR2 := 100
4597: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4598: ,p_debug_mode IN VARCHAR2 := 'N'
4599: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4600: ,p_responsibility_id IN NUMBER := 0
4601: ,p_structure_version_id IN NUMBER
4602: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4603: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4602: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4598: ,p_debug_mode IN VARCHAR2 := 'N'
4599: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4600: ,p_responsibility_id IN NUMBER := 0
4601: ,p_structure_version_id IN NUMBER
4602: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4603: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4604: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4605: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4606: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4603: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4599: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4600: ,p_responsibility_id IN NUMBER := 0
4601: ,p_structure_version_id IN NUMBER
4602: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4603: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4604: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4605: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4606: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4607: ,x_published_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4604: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

4600: ,p_responsibility_id IN NUMBER := 0
4601: ,p_structure_version_id IN NUMBER
4602: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4603: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4604: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4605: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4606: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4607: ,x_published_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4608: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4605: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4601: ,p_structure_version_id IN NUMBER
4602: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4603: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4604: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4605: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4606: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4607: ,x_published_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4608: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4609: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4606: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4602: ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4603: ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4604: ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4605: ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4606: ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4607: ,x_published_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4608: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4609: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4610: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4658: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4654: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4655: ,p_validation_level IN VARCHAR2 := 100
4656: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4657: ,p_debug_mode IN VARCHAR2 := 'N'
4658: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4659: ,p_structure_version_id IN NUMBER
4660: ,p_record_version_number IN NUMBER
4661: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4662: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4699: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4695: -- Notes: This api is a wrapper called from AMG
4696:
4697: --This API will only be called with the structure type = 'WORKPLAN'
4698: procedure create_structure(
4699: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4700: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4701: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4702: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4703: ,x_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4700: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4696:
4697: --This API will only be called with the structure type = 'WORKPLAN'
4698: procedure create_structure(
4699: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4700: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4701: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4702: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4703: ,x_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4704: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4701: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4697: --This API will only be called with the structure type = 'WORKPLAN'
4698: procedure create_structure(
4699: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4700: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4701: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4702: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4703: ,x_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4704: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4705: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4702: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4698: procedure create_structure(
4699: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4700: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4701: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4702: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4703: ,x_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4704: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4705: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4706: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4953: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4949: --
4950: -- Notes: This api is a wrapper called from AMG
4951:
4952: procedure create_update_struct_ver(
4953: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4954: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4955: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4956: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4957: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4954: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4950: -- Notes: This api is a wrapper called from AMG
4951:
4952: procedure create_update_struct_ver(
4953: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4954: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4955: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4956: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4957: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4958: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4955: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4951:
4952: procedure create_update_struct_ver(
4953: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4954: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4955: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4956: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4957: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4958: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4959: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4956: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4952: procedure create_update_struct_ver(
4953: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4954: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4955: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4956: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4957: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4958: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4959: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4960: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4957: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4953: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4954: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4955: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4956: ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4957: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4958: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4959: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4960: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4961: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5028: (p_structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

5024: FND_MSG_PUB.initialize;
5025: END IF;
5026:
5027: IF (p_structure_version_name IS NOT NULL) AND
5028: (p_structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
5029: ((p_structure_version_id IS NULL) OR (p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)) THEN
5030: --get structure for input type
5031: OPEN c2;
5032: FETCH c2 into l_proj_element_id;

Line 5029: ((p_structure_version_id IS NULL) OR (p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)) THEN

5025: END IF;
5026:
5027: IF (p_structure_version_name IS NOT NULL) AND
5028: (p_structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
5029: ((p_structure_version_id IS NULL) OR (p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)) THEN
5030: --get structure for input type
5031: OPEN c2;
5032: FETCH c2 into l_proj_element_id;
5033: IF c2%NOTFOUND THEN

Line 5356: IF (p_structure_version_id IS NOT NULL) AND (p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

5352: -- Bug 4574032 End
5353: END IF;
5354: ELSE
5355: --update existing structure
5356: IF (p_structure_version_id IS NOT NULL) AND (p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
5357:
5358: --check if name is passed in
5359: open c1;
5360: fetch c1 into l_pev_structure_id, l_name, l_record_version_number;

Line 5363: (p_structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

5359: open c1;
5360: fetch c1 into l_pev_structure_id, l_name, l_record_version_number;
5361: close c1;
5362: If (p_structure_version_name IS NOT NULL) AND
5363: (p_structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
5364: l_name := p_structure_version_name;
5365: END IF;
5366:
5367: --call update_structure_version_attr API

Line 5886: p_tasks_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5882: --Added by rtarway for BUG 4320731
5883: l_pa_task_id := NULL;
5884: --Commented by rtarway , chnaged If condition, BUG 3990873
5885: /*IF p_tasks_in(i).pa_task_id IS NOT NULL AND
5886: p_tasks_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5887: THEN*/
5888:
5889: --Begin add by rtarway, for BUG 3990873
5890: 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)

Line 5890: 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)

5886: p_tasks_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5887: THEN*/
5888:
5889: --Begin add by rtarway, for BUG 3990873
5890: 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)
5891: then
5892: 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)
5893: then
5894: --Cursor is deliberately used here, because we dont want to populate message in global error stack, in case new tasks

Line 5892: 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)

5888:
5889: --Begin add by rtarway, for BUG 3990873
5890: 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)
5891: then
5892: 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)
5893: then
5894: --Cursor is deliberately used here, because we dont want to populate message in global error stack, in case new tasks
5895: --are being added. At many places in update_task flow, error is raised based on fnd_msg_pub.count > 0
5896: --If NO_DATA_FOUND occurs for this cursor, it will pass without error.

Line 5912: AND p_tasks_in(i).pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

5908: IF l_pa_task_id IS NOT NULL
5909: then
5910: --end add by rtarway, for BUG 3990873
5911: IF (p_tasks_in(i).pa_parent_task_id IS NOT NULL
5912: AND p_tasks_in(i).pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5913: THEN
5914: v_parent_task_id := p_tasks_in(i).pa_parent_task_id;
5915: ELSIF (p_tasks_in(i).pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5916: AND p_tasks_in(i).pm_parent_task_reference IS NOT NULL)

Line 5915: ELSIF (p_tasks_in(i).pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

5911: IF (p_tasks_in(i).pa_parent_task_id IS NOT NULL
5912: AND p_tasks_in(i).pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5913: THEN
5914: v_parent_task_id := p_tasks_in(i).pa_parent_task_id;
5915: ELSIF (p_tasks_in(i).pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5916: AND p_tasks_in(i).pm_parent_task_reference IS NOT NULL)
5917: THEN
5918: --convert pm_parent_task_reference to parent_task_id.
5919: --All the parent tasks are created first then child tasks are created. See TRM for AMG load_task api.

Line 5944: pa_interface_utils_pub.map_new_amg_msg

5940: /*IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5941: THEN
5942: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5943: THEN
5944: pa_interface_utils_pub.map_new_amg_msg
5945: ( p_old_message_code => 'PA_PARENT_TASK_MISSING'
5946: ,p_msg_attribute => 'CHANGE'
5947: ,p_resize_flag => 'N'
5948: ,p_msg_context => 'TASK'

Line 5970: and p_tasks_in(i-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

5966: ELSE
5967: --v_ref_task_id := p_tasks_in(i-1).pa_task_id;
5968: --Added by rtarway for BUG 3990873
5969: if ( p_tasks_in(i-1).pa_task_id is not null
5970: and p_tasks_in(i-1).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
5971: then
5972: v_ref_task_id := p_tasks_in(i-1).pa_task_id;
5973: else
5974: if ( p_tasks_in(i-1).pm_task_reference is not null

Line 5975: and p_tasks_in(i-1).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )

5971: then
5972: v_ref_task_id := p_tasks_in(i-1).pa_task_id;
5973: else
5974: if ( p_tasks_in(i-1).pm_task_reference is not null
5975: and p_tasks_in(i-1).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
5976: then
5977: --get the task id from reference
5978: --Cursor is deliberately used here, because we dont want to populate message in global error stack, in case new tasks
5979: --are being added. At many places in update_task flow, error is raised based on fnd_msg_pub.count > 0

Line 6093: p_tasks_in(i).task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

6089: IF p_tasks_in.exists(i)
6090: THEN
6091: WHILE i IS NOT NULL LOOP
6092: IF p_tasks_in(i).task_version_id IS NOT NULL AND
6093: p_tasks_in(i).task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6094: THEN
6095: l_tasks_ver_ids.extend;
6096: l_tasks_ver_ids(l_tasks_ver_ids.count) := p_tasks_in(i).task_version_id;
6097:

Line 6129: pa_interface_utils_pub.get_messages

6125:
6126: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6127: x_msg_count := FND_MSG_PUB.count_msg;
6128: if x_msg_count = 1 then
6129: pa_interface_utils_pub.get_messages
6130: (p_encoded => FND_API.G_TRUE,
6131: p_msg_index => 1,
6132: p_msg_count => l_msg_count,
6133: p_msg_data => l_msg_data,

Line 6155: pa_interface_utils_pub.get_messages

6151: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6152: x_msg_count := FND_MSG_PUB.count_msg;
6153: x_return_status := l_return_status ; --bug 3044915
6154: if x_msg_count = 1 then
6155: pa_interface_utils_pub.get_messages
6156: (p_encoded => FND_API.G_TRUE,
6157: p_msg_index => 1,
6158: p_msg_count => l_msg_count,
6159: p_msg_data => l_msg_data,

Line 6213: pa_interface_utils_pub.get_messages

6209:
6210: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6211: x_msg_count := FND_MSG_PUB.count_msg;
6212: if x_msg_count = 1 then
6213: pa_interface_utils_pub.get_messages
6214: (p_encoded => FND_API.G_TRUE,
6215: p_msg_index => 1,
6216: p_msg_count => l_msg_count,
6217: p_msg_data => l_msg_data,

Line 6240: pa_interface_utils_pub.get_messages

6236: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6237: x_msg_count := FND_MSG_PUB.count_msg;
6238: x_return_status := l_return_status ; --bug 3044915
6239: if x_msg_count = 1 then
6240: pa_interface_utils_pub.get_messages
6241: (p_encoded => FND_API.G_TRUE,
6242: p_msg_index => 1,
6243: p_msg_count => l_msg_count,
6244: p_msg_data => l_msg_data,

Line 7589: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7585: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
7586: ,p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
7587: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
7588: ,p_debug_mode IN VARCHAR2 := 'N'
7589: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7590: ,p_src_project_id IN NUMBER
7591: ,p_dest_project_id IN NUMBER
7592: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7593: ,p_copy_task_flag IN VARCHAR2 := 'Y' /**NOT USED **/

Line 7592: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7588: ,p_debug_mode IN VARCHAR2 := 'N'
7589: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7590: ,p_src_project_id IN NUMBER
7591: ,p_dest_project_id IN NUMBER
7592: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7593: ,p_copy_task_flag IN VARCHAR2 := 'Y' /**NOT USED **/
7594: ,p_dest_template_flag IN VARCHAR2 := 'N'
7595: ,p_src_template_flag IN VARCHAR2 := 'N' /**NOT USED **/
7596: ,p_dest_project_name IN VARCHAR2

Line 10429: Pa_Interface_Utils_Pub.get_messages

10425:
10426: l_msg_count := Fnd_Msg_Pub.count_msg;
10427: IF l_msg_count = 1 AND x_msg_data IS NULL
10428: THEN
10429: Pa_Interface_Utils_Pub.get_messages
10430: ( p_encoded => Fnd_Api.G_FALSE
10431: , p_msg_index => 1
10432: , p_msg_count => l_msg_count
10433: , p_msg_data => l_msg_data

Line 10541: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

10537: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
10538: ,p_validation_level IN VARCHAR2 := 100
10539: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
10540: ,p_debug_mode IN VARCHAR2 := 'N'
10541: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10542: ,p_src_project_id IN NUMBER
10543: ,p_dest_project_id IN NUMBER
10544: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10545: ,p_copy_task_flag IN VARCHAR2 := 'Y'

Line 10544: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

10540: ,p_debug_mode IN VARCHAR2 := 'N'
10541: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10542: ,p_src_project_id IN NUMBER
10543: ,p_dest_project_id IN NUMBER
10544: ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10545: ,p_copy_task_flag IN VARCHAR2 := 'Y'
10546: ,p_dest_template_flag IN VARCHAR2 := 'N' --bug 2805602
10547: ,p_src_template_flag IN VARCHAR2 := 'N' --bug 2805602
10548: ,p_dest_project_name IN VARCHAR2 --bug 2805602

Line 10651: (src_str_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

10647: l_get_structure_attr_csr_rec l_get_structure_attr_csr%ROWTYPE;
10648: l_get_structure_attr_csr_rec2 l_get_structure_attr_csr2%ROWTYPE;
10649:
10650: TYPE structure_ver_record IS RECORD
10651: (src_str_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
10652: src_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10653: latest_pub_flag VARCHAR2(1) := 'N',
10654: current_flag VARCHAR2(1) := 'N',
10655: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 10652: src_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

10648: l_get_structure_attr_csr_rec2 l_get_structure_attr_csr2%ROWTYPE;
10649:
10650: TYPE structure_ver_record IS RECORD
10651: (src_str_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
10652: src_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10653: latest_pub_flag VARCHAR2(1) := 'N',
10654: current_flag VARCHAR2(1) := 'N',
10655: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
10656: copy_flag VARCHAR2(1) := 'N',

Line 10655: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

10651: (src_str_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
10652: src_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10653: latest_pub_flag VARCHAR2(1) := 'N',
10654: current_flag VARCHAR2(1) := 'N',
10655: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
10656: copy_flag VARCHAR2(1) := 'N',
10657: dest_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10658: src_stru_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10659: );

Line 10657: dest_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

10653: latest_pub_flag VARCHAR2(1) := 'N',
10654: current_flag VARCHAR2(1) := 'N',
10655: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
10656: copy_flag VARCHAR2(1) := 'N',
10657: dest_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10658: src_stru_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10659: );
10660:
10661: TYPE l_dest_str_versions IS TABLE OF structure_ver_record

Line 10658: src_stru_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

10654: current_flag VARCHAR2(1) := 'N',
10655: last_update_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
10656: copy_flag VARCHAR2(1) := 'N',
10657: dest_str_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10658: src_stru_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10659: );
10660:
10661: TYPE l_dest_str_versions IS TABLE OF structure_ver_record
10662: INDEX BY BINARY_INTEGER;

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

10845: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
10846: and lookup_code = 'WORKPLAN';
10847:
10848: -- Bug 3717026 Begin, commented as the structure name should be same as the project name.
10849: --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
10850: --l_name := pa_project_pub.G_structure_in_rec.structure_version_name;
10851: --ELSE
10852: l_name := substr(l_project_name, 1, 240);
10853: --END IF;

Line 13097: p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

13093:
13094: END calc_duration;
13095:
13096: PROCEDURE get_version_ids(
13097: p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13098: ,p_task_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13099: ,p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13100: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13101: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 13098: ,p_task_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

13094: END calc_duration;
13095:
13096: PROCEDURE get_version_ids(
13097: p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13098: ,p_task_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13099: ,p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13100: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13101: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13102: ) IS

Line 13099: ,p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

13095:
13096: PROCEDURE get_version_ids(
13097: p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13098: ,p_task_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13099: ,p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13100: ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13101: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13102: ) IS
13103: CURSOR cur_str_ver_id1

Line 13119: IF p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_version_id IS NOT NULL

13115: ;
13116:
13117: BEGIN
13118:
13119: IF p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_version_id IS NOT NULL
13120: THEN
13121: OPEN cur_str_ver_id1;
13122: FETCH cur_str_ver_id1 INTO x_structure_version_id;
13123: CLOSE cur_str_ver_id1;

Line 13125: ELSIF ( p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_task_version_id IS NULL ) AND

13121: OPEN cur_str_ver_id1;
13122: FETCH cur_str_ver_id1 INTO x_structure_version_id;
13123: CLOSE cur_str_ver_id1;
13124: x_task_version_id := p_task_version_id;
13125: ELSIF ( p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_task_version_id IS NULL ) AND
13126: ( p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL )
13127: THEN
13128: OPEN cur_str_ver_id2;
13129: FETCH cur_str_ver_id2 INTO x_task_version_id, x_structure_version_id;

Line 13126: ( p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL )

13122: FETCH cur_str_ver_id1 INTO x_structure_version_id;
13123: CLOSE cur_str_ver_id1;
13124: x_task_version_id := p_task_version_id;
13125: ELSIF ( p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_task_version_id IS NULL ) AND
13126: ( p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL )
13127: THEN
13128: OPEN cur_str_ver_id2;
13129: FETCH cur_str_ver_id2 INTO x_task_version_id, x_structure_version_id;
13130: CLOSE cur_str_ver_id2;

Line 13137: p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

13133: END get_version_ids;
13134:
13135:
13136: PROCEDURE get_task_version_id(
13137: p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13138: ,p_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13139: ,p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13140: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13141: ) IS

Line 13138: ,p_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

13134:
13135:
13136: PROCEDURE get_task_version_id(
13137: p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13138: ,p_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13139: ,p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13140: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13141: ) IS
13142:

Line 13139: ,p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

13135:
13136: PROCEDURE get_task_version_id(
13137: p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13138: ,p_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13139: ,p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13140: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13141: ) IS
13142:
13143: CURSOR cur_task_ver_id

Line 13152: IF p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_structure_version_id IS NOT NULL AND

13148: AND parent_structure_version_id = p_structure_version_id
13149: AND project_id = p_project_id;
13150:
13151: BEGIN
13152: IF p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_structure_version_id IS NOT NULL AND
13153: p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL AND
13154: p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_project_id IS NOT NULL
13155: THEN
13156: OPEN cur_task_ver_id;

Line 13153: p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL AND

13149: AND project_id = p_project_id;
13150:
13151: BEGIN
13152: IF p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_structure_version_id IS NOT NULL AND
13153: p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL AND
13154: p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_project_id IS NOT NULL
13155: THEN
13156: OPEN cur_task_ver_id;
13157: FETCH cur_task_ver_id INTO x_task_version_id;

Line 13154: p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_project_id IS NOT NULL

13150:
13151: BEGIN
13152: IF p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_structure_version_id IS NOT NULL AND
13153: p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL AND
13154: p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_project_id IS NOT NULL
13155: THEN
13156: OPEN cur_task_ver_id;
13157: FETCH cur_task_ver_id INTO x_task_version_id;
13158: CLOSE cur_task_ver_id;

Line 13195: p_tasks_in(i).task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

13191: IF p_tasks_in.exists(i)
13192: THEN
13193: WHILE i IS NOT NULL LOOP
13194: IF p_tasks_in(i).task_version_id IS NOT NULL AND
13195: p_tasks_in(i).task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13196: THEN
13197: --l_tasks_ver_ids.extend;
13198: l_tasks_ver_ids(j) := p_tasks_in(i).task_version_id;
13199:

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

13196: THEN
13197: --l_tasks_ver_ids.extend;
13198: l_tasks_ver_ids(j) := p_tasks_in(i).task_version_id;
13199:
13200: 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
13201: ( 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
13202: THEN
13203: --PA_PROJECT_PUB.update_project does not populate task versions for the tasks being updated.
13204: --in this case we have to pick this from databse.

Line 13201: ( 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

13197: --l_tasks_ver_ids.extend;
13198: l_tasks_ver_ids(j) := p_tasks_in(i).task_version_id;
13199:
13200: 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
13201: ( 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
13202: THEN
13203: --PA_PROJECT_PUB.update_project does not populate task versions for the tasks being updated.
13204: --in this case we have to pick this from databse.
13205: get_task_version_id(

Line 13238: pa_interface_utils_pub.get_messages

13234: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
13235: x_msg_count := FND_MSG_PUB.count_msg;
13236: x_return_status := l_return_status ; -- Bug 3044915
13237: if x_msg_count = 1 then
13238: pa_interface_utils_pub.get_messages
13239: (p_encoded => FND_API.G_TRUE,
13240: p_msg_index => 1,
13241: p_msg_count => l_msg_count,
13242: p_msg_data => l_msg_data,

Line 13808: --pa_interface_utils_pub.map_new_amg_msg

13804:
13805: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13806: THEN
13807: --Commented out as there is no message defined for amg corresponding to PA_PS_VD_UPDWBS_PRC_INPROC
13808: --pa_interface_utils_pub.map_new_amg_msg
13809: -- ( p_old_message_code => 'PA_PS_VD_UPDWBS_PRC_INPROC'
13810: -- ,p_msg_attribute => 'CHANGE'
13811: -- ,p_resize_flag => 'N'
13812: -- ,p_msg_context => 'GENERAL'

Line 13838: --pa_interface_utils_pub.map_new_amg_msg

13834: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => p_project_id --Bug 3091798
13835: ,p_structure_type => p_structure_type );
13836:
13837: --Commented out as there is no message defined for amg corresponding to PA_PS_VD_UPD_WBS_PRC_ERR
13838: --pa_interface_utils_pub.map_new_amg_msg
13839: -- ( p_old_message_code => 'PA_PS_VD_UPD_WBS_PRC_ERR'
13840: -- ,p_msg_attribute => 'CHANGE'
13841: -- ,p_resize_flag => 'N'
13842: -- ,p_msg_context => 'GENERAL'

Line 14234: IF (l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

14230: where pstype.proj_element_id = pelem.parent_structure_id
14231: and pstype.structure_type_id = types.structure_type_id
14232: and types.structure_type = p_structure_type);
14233: BEGIN
14234: IF (l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14235: l_task_in_rec.pa_task_id IS NULL )
14236: THEN
14237: IF l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
14238: l_task_in_rec.pm_task_reference IS NULL

Line 14237: IF l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR

14233: BEGIN
14234: IF (l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14235: l_task_in_rec.pa_task_id IS NULL )
14236: THEN
14237: IF l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
14238: l_task_in_rec.pm_task_reference IS NULL
14239: THEN
14240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14241: THEN

Line 14242: pa_interface_utils_pub.map_new_amg_msg

14238: l_task_in_rec.pm_task_reference IS NULL
14239: THEN
14240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14241: THEN
14242: pa_interface_utils_pub.map_new_amg_msg
14243: ( p_old_message_code => 'PA_TASK_REF_AND_ID_MISSING'
14244: ,p_msg_attribute => 'CHANGE'
14245: ,p_resize_flag => 'N'
14246: ,p_msg_context => 'PROJ'

Line 14282: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

14278:
14279:
14280: -- Validation block
14281: -- validate security, task_reference and task names in appropriate contexts.
14282: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14283: l_task_in_rec.pa_task_id IS NULL -- new tasks to be crated
14284: THEN
14285: -- Added to check the security as it is not done when called from update_project
14286: IF l_add_task_security = 'N'

Line 14288: pa_interface_utils_pub.map_new_amg_msg(

14284: THEN
14285: -- Added to check the security as it is not done when called from update_project
14286: IF l_add_task_security = 'N'
14287: THEN
14288: pa_interface_utils_pub.map_new_amg_msg(
14289: p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
14290: ,p_msg_attribute => 'CHANGE'
14291: ,p_resize_flag => 'Y'
14292: ,p_msg_context => 'GENERAL'

Line 14313: OR l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14309:
14310: -- Task reference should be non null in AMG flow. For financial tasks this
14311: -- is checked in add_task_round_one API.
14312: IF l_task_in_rec.pm_task_reference IS NULL
14313: OR l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14314: THEN
14315: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14316: THEN
14317: pa_interface_utils_pub.map_new_amg_msg

Line 14317: pa_interface_utils_pub.map_new_amg_msg

14313: OR l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14314: THEN
14315: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14316: THEN
14317: pa_interface_utils_pub.map_new_amg_msg
14318: ( p_old_message_code => 'PA_TASK_REF_IS_NULL'
14319: ,p_msg_attribute => 'CHANGE'
14320: ,p_resize_flag => 'N'
14321: ,p_msg_context => 'PROJ'

Line 14335: OR l_task_in_rec.task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14331:
14332: --ADUT. The task name cannot be null. For financial tasks this is
14333: --checked in add_task_round_one API.
14334: IF l_task_in_rec.task_name IS NULL
14335: OR l_task_in_rec.task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14336: THEN
14337:
14338: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14339: THEN

Line 14340: pa_interface_utils_pub.map_new_amg_msg

14336: THEN
14337:
14338: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14339: THEN
14340: pa_interface_utils_pub.map_new_amg_msg
14341: ( p_old_message_code => 'PA_TASK_NAME_IS_NULL'
14342: ,p_msg_attribute => 'CHANGE'
14343: ,p_resize_flag => 'N'
14344: ,p_msg_context => 'TASK'

Line 14362: pa_interface_utils_pub.map_new_amg_msg(

14358: ELSE -- IF l_task_in_rec.pa_task_id IS NULL
14359:
14360: IF l_update_task_security = 'N'
14361: THEN
14362: pa_interface_utils_pub.map_new_amg_msg(
14363: p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
14364: ,p_msg_attribute => 'CHANGE'
14365: ,p_resize_flag => 'Y'
14366: ,p_msg_context => 'GENERAL'

Line 14391: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

14387: -- 3. l_task_id -- the task that is being processed.
14388: -- l_proj_elem_rvn of record of pa_proj_elements to be updated
14389: -- before calling api PA_TASK_PUB1.update_task
14390:
14391: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14392: l_task_in_rec.pa_task_id IS NULL -- new tasks to be crated
14393: THEN
14394:
14395: -- If the structure type is workplan we need to derive the values for certain fields. For financial

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

14396: -- context they have already been done and is available in the database - So we'll just query it up.
14397: IF p_structure_type = 'WORKPLAN' THEN
14398:
14399: -- Derive the task number for the current task
14400: 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
14401: THEN
14402: l_cur_pa_tasks_rec.task_number := l_task_in_rec.pm_task_reference;
14403: -- ELSE Bug 6193314 need to comment out
14404: /* bug#5243018 : Reverting the fix in Bug 4120380

Line 14416: AND l_task_in_rec.pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

14412: END IF;
14413:
14414: -- Derive the parent task id
14415: IF (l_task_in_rec.pa_parent_task_id IS NOT NULL
14416: AND l_task_in_rec.pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14417: THEN
14418: l_cur_pa_tasks_rec.parent_task_id := l_task_in_rec.pa_parent_task_id;
14419: ELSIF (l_task_in_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14420: AND l_task_in_rec.pm_parent_task_reference IS NOT NULL)

Line 14419: ELSIF (l_task_in_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14415: IF (l_task_in_rec.pa_parent_task_id IS NOT NULL
14416: AND l_task_in_rec.pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14417: THEN
14418: l_cur_pa_tasks_rec.parent_task_id := l_task_in_rec.pa_parent_task_id;
14419: ELSIF (l_task_in_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14420: AND l_task_in_rec.pm_parent_task_reference IS NOT NULL)
14421: THEN
14422: --convert pm_parent_task_reference to parent_task_id.
14423: --All the parent tasks are created first then child tasks are created. See TRM for AMG load_task api.

Line 14452: pa_interface_utils_pub.map_new_amg_msg

14448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
14449: THEN
14450: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14451: THEN
14452: pa_interface_utils_pub.map_new_amg_msg
14453: ( p_old_message_code => 'PA_PARENT_TASK_MISSING'
14454: ,p_msg_attribute => 'CHANGE'
14455: ,p_resize_flag => 'N'
14456: ,p_msg_context => 'TASK'

Line 14471: IF l_task_in_rec.carrying_out_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

14467: l_cur_pa_tasks_rec.parent_task_id := null;
14468: END IF;
14469:
14470: -- Included the condition during UT to avoid precision errors.
14471: IF l_task_in_rec.carrying_out_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
14472: l_cur_pa_tasks_rec.carrying_out_organization_id := NULL;
14473: ELSE
14474: l_cur_pa_tasks_rec.carrying_out_organization_id := l_task_in_rec.carrying_out_organization_id;
14475: END IF;

Line 14478: IF l_task_in_rec.address_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

14474: l_cur_pa_tasks_rec.carrying_out_organization_id := l_task_in_rec.carrying_out_organization_id;
14475: END IF;
14476:
14477: -- Included the condition during UT to avoid precision errors.
14478: IF l_task_in_rec.address_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
14479: l_cur_pa_tasks_rec.address_id := NULL;
14480: ELSE
14481: l_cur_pa_tasks_rec.address_id := l_task_in_rec.address_id;
14482: END IF;

Line 14484: IF l_task_in_rec.task_manager_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

14480: ELSE
14481: l_cur_pa_tasks_rec.address_id := l_task_in_rec.address_id;
14482: END IF;
14483: -- Included the condition during UT to avoid precision errors.
14484: IF l_task_in_rec.task_manager_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
14485: l_cur_pa_tasks_rec.task_manager_person_id := NULL;
14486: ELSE
14487: l_cur_pa_tasks_rec.task_manager_person_id := l_task_in_rec.task_manager_person_id;
14488: END IF;

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

14490: l_cur_pa_tasks_rec.pm_task_reference := l_task_in_rec.pm_task_reference;
14491: /*Commented for bug 2982057 l_cur_pa_tasks_rec.long_task_name := l_task_in_rec.long_task_name;*/
14492: /* Code addition for bug 2982057 starts */
14493:
14494: 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
14495: l_cur_pa_tasks_rec.long_task_name := l_task_in_rec.task_name;
14496: else
14497: l_cur_pa_tasks_rec.long_task_name := l_task_in_rec.long_task_name;
14498: end if;

Line 14524: l_task_in_rec.pa_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14520: END IF;
14521: /** Code changes for bug 4120380. For new tasks similar case mentioned above for workplan.**/
14522: /* bug#5243018 : Reverting the fix in Bug 4120380
14523: IF l_task_in_rec.pa_task_number IS NOT NULL AND
14524: l_task_in_rec.pa_task_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14525: THEN
14526: l_cur_pa_tasks_rec.task_number := '-'||l_task_in_rec.pa_task_number;
14527: END IF; */
14528: /** Code end for bug 4120380 by aditi **/

Line 14551: IF (l_task_in_rec.pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

14547: -- context they have already been done and is available in the database - So we'll just query it up.
14548: IF p_structure_type = 'WORKPLAN' THEN
14549:
14550: -- Derive the parent task id
14551: IF (l_task_in_rec.pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14552: AND l_task_in_rec.pa_parent_task_id IS NOT NULL)
14553: THEN
14554: l_cur_pa_tasks_rec.parent_task_id := l_task_in_rec.pa_parent_task_id;
14555:

Line 14556: ELSIF (l_task_in_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14552: AND l_task_in_rec.pa_parent_task_id IS NOT NULL)
14553: THEN
14554: l_cur_pa_tasks_rec.parent_task_id := l_task_in_rec.pa_parent_task_id;
14555:
14556: ELSIF (l_task_in_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14557: AND l_task_in_rec.pm_parent_task_reference IS NOT NULL)
14558: THEN
14559: --convert pm_parent_task_reference to parent_task_id.
14560: --All the parent tasks are created first then child tasks are created. See TRM for AMG load_task api.

Line 14590: pa_interface_utils_pub.map_new_amg_msg

14586: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
14587: THEN
14588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14589: THEN
14590: pa_interface_utils_pub.map_new_amg_msg
14591: ( p_old_message_code => 'PA_PARENT_TASK_MISSING'
14592: ,p_msg_attribute => 'CHANGE'
14593: ,p_resize_flag => 'N'
14594: ,p_msg_context => 'TASK'

Line 14651: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

14647: BEGIN
14648: -- Bug 2982072. Open the cursor only if any of task number or name needs to
14649: -- be fetched for the task.
14650: IF (l_task_in_rec.pa_task_number is null OR
14651: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
14652: (l_task_in_rec.long_task_name is null OR
14653: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
14654: THEN
14655: OPEN cur_proj_elem_info(l_task_in_rec.pa_task_id);

Line 14653: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

14649: -- be fetched for the task.
14650: IF (l_task_in_rec.pa_task_number is null OR
14651: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
14652: (l_task_in_rec.long_task_name is null OR
14653: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
14654: THEN
14655: OPEN cur_proj_elem_info(l_task_in_rec.pa_task_id);
14656: FETCH cur_proj_elem_info into l_proj_elem_info;
14657: CLOSE cur_proj_elem_info;

Line 14664: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14660:
14661: -- Bug 2982072. If task number and task name are passed as null then
14662: -- obtain the values from the database and use them in update_task api.
14663: IF l_task_in_rec.pa_task_number is null OR
14664: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14665: THEN
14666: -- l_task_in_rec.pa_task_number := SUBSTRB(l_proj_elem_info.element_number,1,25); -- Substrb added for Bug 5152448
14667: l_task_in_rec.pa_task_number := l_proj_elem_info.element_number; -- Substrb removed for Bug 6193314
14668: /** added for Bug 4120380 **/

Line 14682: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14678: /** end of changes for Bug 4120380 **/
14679: END IF;
14680:
14681: IF l_task_in_rec.long_task_name is null OR
14682: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14683: THEN
14684: /* Start of changes for bug 4503580 */
14685: -- l_task_in_rec.long_task_name := NVL(l_task_in_rec.task_name, l_proj_elem_info.name); --bug 3969651
14686: IF l_task_in_rec.task_name is null OR

Line 14687: l_task_in_rec.task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14683: THEN
14684: /* Start of changes for bug 4503580 */
14685: -- l_task_in_rec.long_task_name := NVL(l_task_in_rec.task_name, l_proj_elem_info.name); --bug 3969651
14686: IF l_task_in_rec.task_name is null OR
14687: l_task_in_rec.task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14688: THEN
14689: l_task_in_rec.long_task_name := l_proj_elem_info.name;
14690: ELSE
14691: l_task_in_rec.long_task_name := l_task_in_rec.task_name;

Line 14708: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14704:
14705: -- Bug 2982072. If task number and task name are passed as null then
14706: -- obtain the values from the database and use them in update_task api.
14707: IF l_task_in_rec.pa_task_number is null OR
14708: l_task_in_rec.pa_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14709: THEN
14710: l_task_in_rec.pa_task_number := l_cur_pa_tasks_rec.task_number;
14711: /* Code added for bug 4120380 **/
14712: /* bug#5243018 : Reverting the fix in Bug 4120380

Line 14724: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14720: /* Code end for bug 4120380 **/
14721: END IF;
14722:
14723: IF l_task_in_rec.long_task_name is null OR
14724: l_task_in_rec.long_task_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14725: THEN
14726: l_task_in_rec.long_task_name := l_cur_pa_tasks_rec.long_task_name;
14727: /* Redundant but added for clarity -Added the else condition for bug 2982057*/
14728: ELSE

Line 14744: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

14740: -- After call to these APIs populate following
14741: -- px_tasks_out_tbl(i).pa_task_id
14742: -- px_tasks_out_tbl(i).pm_task_reference
14743: -- for workplan create task case l_task_id is output from create task API
14744: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14745: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
14746: THEN
14747: IF p_create_task_version_only = 'N' THEN
14748:

Line 15241: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

15237: -- Populate following set of variables required to update element versions:
15238: -- attribute_category , attribute1 ...attribute10, in local variables
15239: -- l_task_version_id, l_proj_elem_ver_rowid, l_proj_elem_ver_rvn -- required only in update task.
15240:
15241: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
15242: l_task_in_rec.pa_task_id IS NULL THEN -- Create Task Context
15243: --Bug 6153503
15244: IF l_task_in_rec.tasks_dff = 'N' THEN
15245: -- Handle the dff attributes. Set the local variable to null if passed value is miss char.

Line 15247: IF l_task_in_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15243: --Bug 6153503
15244: IF l_task_in_rec.tasks_dff = 'N' THEN
15245: -- Handle the dff attributes. Set the local variable to null if passed value is miss char.
15246: -- These attributes would be used both while creating task version and the schedule version.
15247: IF l_task_in_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15248: l_attribute_category := null;
15249: ELSE
15250: l_attribute_category := l_task_in_rec.attribute_category;
15251: END IF;

Line 15253: IF l_task_in_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15249: ELSE
15250: l_attribute_category := l_task_in_rec.attribute_category;
15251: END IF;
15252:
15253: IF l_task_in_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15254: l_attribute1 := null;
15255: ELSE
15256: l_attribute1 := l_task_in_rec.attribute1;
15257: END IF;

Line 15259: IF l_task_in_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15255: ELSE
15256: l_attribute1 := l_task_in_rec.attribute1;
15257: END IF;
15258:
15259: IF l_task_in_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15260: l_attribute2 := null;
15261: ELSE
15262: l_attribute2 := l_task_in_rec.attribute2;
15263: END IF;

Line 15265: IF l_task_in_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15261: ELSE
15262: l_attribute2 := l_task_in_rec.attribute2;
15263: END IF;
15264:
15265: IF l_task_in_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15266: l_attribute3 := null;
15267: ELSE
15268: l_attribute3 := l_task_in_rec.attribute3;
15269: END IF;

Line 15271: IF l_task_in_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15267: ELSE
15268: l_attribute3 := l_task_in_rec.attribute3;
15269: END IF;
15270:
15271: IF l_task_in_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15272: l_attribute4 := null;
15273: ELSE
15274: l_attribute4 := l_task_in_rec.attribute4;
15275: END IF;

Line 15277: IF l_task_in_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15273: ELSE
15274: l_attribute4 := l_task_in_rec.attribute4;
15275: END IF;
15276:
15277: IF l_task_in_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15278: l_attribute5 := null;
15279: ELSE
15280: l_attribute5 := l_task_in_rec.attribute5;
15281: END IF;

Line 15283: IF l_task_in_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15279: ELSE
15280: l_attribute5 := l_task_in_rec.attribute5;
15281: END IF;
15282:
15283: IF l_task_in_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15284: l_attribute6 := null;
15285: ELSE
15286: l_attribute6 := l_task_in_rec.attribute6;
15287: END IF;

Line 15289: IF l_task_in_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15285: ELSE
15286: l_attribute6 := l_task_in_rec.attribute6;
15287: END IF;
15288:
15289: IF l_task_in_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15290: l_attribute7 := null;
15291: ELSE
15292: l_attribute7 := l_task_in_rec.attribute7;
15293: END IF;

Line 15295: IF l_task_in_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15291: ELSE
15292: l_attribute7 := l_task_in_rec.attribute7;
15293: END IF;
15294:
15295: IF l_task_in_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15296: l_attribute8 := null;
15297: ELSE
15298: l_attribute8 := l_task_in_rec.attribute8;
15299: END IF;

Line 15301: IF l_task_in_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15297: ELSE
15298: l_attribute8 := l_task_in_rec.attribute8;
15299: END IF;
15300:
15301: IF l_task_in_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15302: l_attribute9 := null;
15303: ELSE
15304: l_attribute9 := l_task_in_rec.attribute9;
15305: END IF;

Line 15307: IF l_task_in_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15303: ELSE
15304: l_attribute9 := l_task_in_rec.attribute9;
15305: END IF;
15306:
15307: IF l_task_in_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15308: l_attribute10 := null;
15309: ELSE
15310: l_attribute10 := l_task_in_rec.attribute10;
15311: END IF;

Line 15313: IF l_task_in_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15309: ELSE
15310: l_attribute10 := l_task_in_rec.attribute10;
15311: END IF;
15312: --Bug 6153503
15313: IF l_task_in_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15314: l_attribute11 := null;
15315: ELSE
15316: l_attribute11 := l_task_in_rec.attribute11;
15317: END IF;

Line 15319: IF l_task_in_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15315: ELSE
15316: l_attribute11 := l_task_in_rec.attribute11;
15317: END IF;
15318:
15319: IF l_task_in_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15320: l_attribute12 := null;
15321: ELSE
15322: l_attribute12 := l_task_in_rec.attribute12;
15323: END IF;

Line 15325: IF l_task_in_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15321: ELSE
15322: l_attribute12 := l_task_in_rec.attribute12;
15323: END IF;
15324:
15325: IF l_task_in_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15326: l_attribute13 := null;
15327: ELSE
15328: l_attribute13 := l_task_in_rec.attribute13;
15329: END IF;

Line 15331: IF l_task_in_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15327: ELSE
15328: l_attribute13 := l_task_in_rec.attribute13;
15329: END IF;
15330:
15331: IF l_task_in_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15332: l_attribute14 := null;
15333: ELSE
15334: l_attribute14 := l_task_in_rec.attribute14;
15335: END IF;

Line 15337: IF l_task_in_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

15333: ELSE
15334: l_attribute14 := l_task_in_rec.attribute14;
15335: END IF;
15336:
15337: IF l_task_in_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15338: l_attribute15 := null;
15339: ELSE
15340: l_attribute15 := l_task_in_rec.attribute15;
15341: END IF;

Line 15369: pa_interface_utils_pub.map_new_amg_msg

15365: IF l_validate_status = 'N'
15366: THEN
15367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
15368: THEN
15369: pa_interface_utils_pub.map_new_amg_msg
15370: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
15371: ,p_msg_attribute => 'CHANGE'
15372: ,p_resize_flag => 'N'
15373: ,p_msg_context => 'FLEX'

Line 15416: IF l_task_in_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

15412:
15413: -- Handle the dff attributes. Set the local variable to null if passed value is miss char.
15414: -- These attributes would be used both while creating task version and the schedule version.
15415: --Bug 6153503 start
15416: IF l_task_in_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
15417: OR l_task_in_rec.tasks_dff = 'Y' THEN
15418: l_attribute_category := l_ver_sch_attr_rec.attribute_category;
15419: ELSE
15420: l_attribute_category := l_task_in_rec.attribute_category;

Line 15423: IF l_task_in_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15419: ELSE
15420: l_attribute_category := l_task_in_rec.attribute_category;
15421: END IF;
15422:
15423: IF l_task_in_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15424: l_attribute1 := l_ver_sch_attr_rec.attribute1;
15425: ELSE
15426: l_attribute1 := l_task_in_rec.attribute1;
15427: END IF;

Line 15429: IF l_task_in_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15425: ELSE
15426: l_attribute1 := l_task_in_rec.attribute1;
15427: END IF;
15428:
15429: IF l_task_in_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15430: l_attribute2 := l_ver_sch_attr_rec.attribute2;
15431: ELSE
15432: l_attribute2 := l_task_in_rec.attribute2;
15433: END IF;

Line 15435: IF l_task_in_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15431: ELSE
15432: l_attribute2 := l_task_in_rec.attribute2;
15433: END IF;
15434:
15435: IF l_task_in_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15436: l_attribute3 := l_ver_sch_attr_rec.attribute3;
15437: ELSE
15438: l_attribute3 := l_task_in_rec.attribute3;
15439: END IF;

Line 15441: IF l_task_in_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15437: ELSE
15438: l_attribute3 := l_task_in_rec.attribute3;
15439: END IF;
15440:
15441: IF l_task_in_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15442: l_attribute4 := l_ver_sch_attr_rec.attribute4;
15443: ELSE
15444: l_attribute4 := l_task_in_rec.attribute4;
15445: END IF;

Line 15447: IF l_task_in_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15443: ELSE
15444: l_attribute4 := l_task_in_rec.attribute4;
15445: END IF;
15446:
15447: IF l_task_in_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15448: l_attribute5 := l_ver_sch_attr_rec.attribute5;
15449: ELSE
15450: l_attribute5 := l_task_in_rec.attribute5;
15451: END IF;

Line 15453: IF l_task_in_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15449: ELSE
15450: l_attribute5 := l_task_in_rec.attribute5;
15451: END IF;
15452:
15453: IF l_task_in_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15454: l_attribute6 := l_ver_sch_attr_rec.attribute6;
15455: ELSE
15456: l_attribute6 := l_task_in_rec.attribute6;
15457: END IF;

Line 15459: IF l_task_in_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15455: ELSE
15456: l_attribute6 := l_task_in_rec.attribute6;
15457: END IF;
15458:
15459: IF l_task_in_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15460: l_attribute7 := l_ver_sch_attr_rec.attribute7;
15461: ELSE
15462: l_attribute7 := l_task_in_rec.attribute7;
15463: END IF;

Line 15465: IF l_task_in_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15461: ELSE
15462: l_attribute7 := l_task_in_rec.attribute7;
15463: END IF;
15464:
15465: IF l_task_in_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15466: l_attribute8 := l_ver_sch_attr_rec.attribute8;
15467: ELSE
15468: l_attribute8 := l_task_in_rec.attribute8;
15469: END IF;

Line 15471: IF l_task_in_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15467: ELSE
15468: l_attribute8 := l_task_in_rec.attribute8;
15469: END IF;
15470:
15471: IF l_task_in_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15472: l_attribute9 := l_ver_sch_attr_rec.attribute9;
15473: ELSE
15474: l_attribute9 := l_task_in_rec.attribute9;
15475: END IF;

Line 15477: IF l_task_in_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15473: ELSE
15474: l_attribute9 := l_task_in_rec.attribute9;
15475: END IF;
15476:
15477: IF l_task_in_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15478: l_attribute10 := l_ver_sch_attr_rec.attribute10;
15479: ELSE
15480: l_attribute10 := l_task_in_rec.attribute10;
15481: END IF;

Line 15483: IF l_task_in_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15479: ELSE
15480: l_attribute10 := l_task_in_rec.attribute10;
15481: END IF;
15482:
15483: IF l_task_in_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15484: l_attribute11 := l_ver_sch_attr_rec.attribute11;
15485: ELSE
15486: l_attribute11 := l_task_in_rec.attribute11;
15487: END IF;

Line 15489: IF l_task_in_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15485: ELSE
15486: l_attribute11 := l_task_in_rec.attribute11;
15487: END IF;
15488:
15489: IF l_task_in_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15490: l_attribute12 := l_ver_sch_attr_rec.attribute12;
15491: ELSE
15492: l_attribute12 := l_task_in_rec.attribute12;
15493: END IF;

Line 15495: IF l_task_in_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15491: ELSE
15492: l_attribute12 := l_task_in_rec.attribute12;
15493: END IF;
15494:
15495: IF l_task_in_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15496: l_attribute13 := l_ver_sch_attr_rec.attribute13;
15497: ELSE
15498: l_attribute13 := l_task_in_rec.attribute13;
15499: END IF;

Line 15501: IF l_task_in_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15497: ELSE
15498: l_attribute13 := l_task_in_rec.attribute13;
15499: END IF;
15500:
15501: IF l_task_in_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15502: l_attribute14 := l_ver_sch_attr_rec.attribute14;
15503: ELSE
15504: l_attribute14 := l_task_in_rec.attribute14;
15505: END IF;

Line 15507: IF l_task_in_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN

15503: ELSE
15504: l_attribute14 := l_task_in_rec.attribute14;
15505: END IF;
15506:
15507: IF l_task_in_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_task_in_rec.tasks_dff = 'Y' THEN
15508: l_attribute15 := l_ver_sch_attr_rec.attribute15;
15509: ELSE
15510: l_attribute15 := l_task_in_rec.attribute15;
15511: END IF;

Line 15539: pa_interface_utils_pub.map_new_amg_msg

15535: IF l_validate_status = 'N'
15536: THEN
15537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
15538: THEN
15539: pa_interface_utils_pub.map_new_amg_msg
15540: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
15541: ,p_msg_attribute => 'CHANGE'
15542: ,p_resize_flag => 'N'
15543: ,p_msg_context => 'FLEX'

Line 15573: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

15569:
15570: -- During these validations following variables are also populated which are used later on
15571: -- l_relationship_id, l_obj_rel_rvn;
15572:
15573: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
15574: l_task_in_rec.pa_task_id IS NULL THEN -- create task
15575: IF l_parent_task_id IS NOT NULL THEN
15576: --Check if it is ok to create a subtask.
15577: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok

Line 15690: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

15686: -- Set the following local variables after calling PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row
15687: -- l_task_version_id_tbl(l_task_id)
15688: -- px_tasks_out_tbl(i).task_version_id
15689:
15690: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
15691: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
15692: THEN
15693:
15694: -- Call the table handler to create a task version.

Line 15918: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

15914: l_task_version_id_from := l_task_version_id_tbl(l_parent_task_id);
15915: l_relationship_subtype := 'TASK_TO_TASK';
15916: END IF;
15917:
15918: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
15919: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
15920: THEN
15921: -- Set the following variables after calling PA_RELATIONSHIP_PUB.Create_Relationship
15922: --px_tasks_out_tbl(i).return_status

Line 16046: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

16042: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16043: l_task_type_id pa_proj_elements.type_id%TYPE;
16044: BEGIN
16045:
16046: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
16047: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
16048: THEN
16049:
16050: -- If start date or end date is miss date, then set them to sysdate.

Line 16051: IF (l_task_in_rec.scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR

16047: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
16048: THEN
16049:
16050: -- If start date or end date is miss date, then set them to sysdate.
16051: IF (l_task_in_rec.scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
16052: l_task_in_rec.scheduled_start_date is NULL ) --ADUT
16053: THEN
16054: l_scheduled_start_date := sysdate;
16055: ELSE

Line 16059: IF (l_task_in_rec.scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR

16055: ELSE
16056: l_scheduled_start_date := l_task_in_rec.scheduled_start_date;
16057: END IF;
16058:
16059: IF (l_task_in_rec.scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
16060: l_task_in_rec.scheduled_finish_date is NULL) --ADUT
16061: THEN
16062: l_scheduled_finish_date := sysdate;
16063: ELSE

Line 16070: IF l_task_in_rec.task_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM or

16066:
16067:
16068: -- If the task type for the current task is null, create_task api would have defaulted
16069: -- it to the default task id. So get the default task type id if the passed in id is null.
16070: IF l_task_in_rec.task_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM or
16071: l_task_in_rec.task_type is null
16072: THEN
16073: l_task_type_id := l_default_task_type_id;
16074: ELSE

Line 16083: IF (l_task_in_rec.PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

16079: -- set the value to null so that it can be passed on to create_schedule_version api.
16080: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
16081: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id))
16082: THEN
16083: IF (l_task_in_rec.PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16084: l_task_in_rec.PLANNED_WORK_QUANTITY IS NOT NULL)
16085: THEN
16086: l_wq_planned_quantity := NULL;
16087: END IF;

Line 16090: IF (l_task_in_rec.PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

16086: l_wq_planned_quantity := NULL;
16087: END IF;
16088: ELSE
16089: --Added by rtarway, for 4029755
16090: IF (l_task_in_rec.PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16091: l_task_in_rec.PLANNED_WORK_QUANTITY IS NOT NULL)
16092: THEN
16093: l_wq_planned_quantity := l_task_in_rec.PLANNED_WORK_QUANTITY;
16094: ELSE

Line 16128: IF (l_task_in_rec.PLANNED_WORK_QUANTITY = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

16124: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
16125: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
16126: l_wq_planned_quantity := null;
16127: ELSE
16128: IF (l_task_in_rec.PLANNED_WORK_QUANTITY = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16129: --Added by rtarway, for 4029755
16130: OR
16131: l_task_in_rec.PLANNED_WORK_QUANTITY IS NULL) THEN
16132: l_wq_planned_quantity := l_ver_sch_attr_rec.wq_planned_quantity;

Line 16153: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

16149:
16150: -- set the following after calling Create_Schedule_Version or Update_Schedule_Version
16151: -- px_tasks_out_tbl(i).return_status
16152:
16153: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
16154: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
16155: THEN
16156: -- set the following after calling api PA_TASK_PUB1.Create_Schedule_Version
16157: -- px_tasks_out_tbl(i).return_status

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

16238: pa_debug.g_err_stage := 'Schedule Version id : ' || l_dummy_number ;
16239: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
16240: END IF;
16241: --rtarway, 4099429 begin
16242: 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
16243: and l_task_in_rec.planned_effort > 0) then
16244:
16245: if (l_add_task_ver_ids.count = 1000) then
16246: IF l_add_task_ver_ids.exists(1) AND l_structure_version_id IS NOT NULL THEN

Line 16398: If nvl(p_pm_product_code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

16394: END IF;
16395:
16396: -- Start Addition 6458891
16397: l_update_task_det_flag := 'Y';
16398: If nvl(p_pm_product_code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16399: and nvl(p_pm_product_code,'X') = 'MSPROJECT' then
16400: l_prev_planned_effort := null;
16401: l_prev_etc_effort := null;
16402: l_prev_percent_comp := null;

Line 16410: IF (NVL(l_task_in_rec.planned_effort, 0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

16406: OPEN cur_prev_prog(p_project_id,l_task_id,l_task_version_id);
16407: FETCH cur_prev_prog INTO l_prev_planned_effort, l_prev_etc_effort,l_prev_percent_comp;
16408: CLOSE cur_prev_prog;
16409:
16410: IF (NVL(l_task_in_rec.planned_effort, 0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16411: NVL(l_task_in_rec.planned_effort, 0) <> NVL(l_prev_planned_effort,0)) THEN
16412: l_update_task_det_flag := 'Y';
16413: END IF;
16414:

Line 16415: IF (NVL(l_task_in_rec.etc_effort, 0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

16411: NVL(l_task_in_rec.planned_effort, 0) <> NVL(l_prev_planned_effort,0)) THEN
16412: l_update_task_det_flag := 'Y';
16413: END IF;
16414:
16415: IF (NVL(l_task_in_rec.etc_effort, 0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16416: NVL(l_task_in_rec.etc_effort, 0) <> NVL(l_prev_etc_effort,0)) THEN
16417: l_update_task_det_flag := 'Y';
16418: END IF;
16419:

Line 16420: IF (NVL(l_task_in_rec.percent_complete, 0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

16416: NVL(l_task_in_rec.etc_effort, 0) <> NVL(l_prev_etc_effort,0)) THEN
16417: l_update_task_det_flag := 'Y';
16418: END IF;
16419:
16420: IF (NVL(l_task_in_rec.percent_complete, 0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16421: NVL(l_task_in_rec.percent_complete, 0) <> NVL(l_prev_percent_comp,0)) THEN
16422: l_update_task_det_flag := 'Y';
16423: END IF;
16424: -- Bug 7132911

Line 16427: If (nvl(l_task_in_rec.planned_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

16423: END IF;
16424: -- Bug 7132911
16425:
16426: /* Commented for bug 7132911
16427: If (nvl(l_task_in_rec.planned_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16428: or
16429: nvl(l_task_in_rec.etc_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16430: or
16431: nvl(l_task_in_rec.percent_complete,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 16429: nvl(l_task_in_rec.etc_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

16425:
16426: /* Commented for bug 7132911
16427: If (nvl(l_task_in_rec.planned_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16428: or
16429: nvl(l_task_in_rec.etc_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16430: or
16431: nvl(l_task_in_rec.percent_complete,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
16432: Then
16433:

Line 16431: nvl(l_task_in_rec.percent_complete,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

16427: If (nvl(l_task_in_rec.planned_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16428: or
16429: nvl(l_task_in_rec.etc_effort,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16430: or
16431: nvl(l_task_in_rec.percent_complete,0)<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
16432: Then
16433:
16434: open cur_prev_prog(p_project_id,l_task_id,l_task_version_id);
16435: fetch cur_prev_prog into l_prev_planned_effort, l_prev_etc_effort,l_prev_percent_comp;

Line 16861: /*IF p_tasks_in_tbl(l_i).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

16857:
16858: IF nvl(p_tasks_in_tbl.LAST,0) > 0 THEN
16859: FOR l_i in p_tasks_in_tbl.first .. p_tasks_in_tbl.last LOOP
16860: --rtarway, 4099429, begin comment
16861: /*IF p_tasks_in_tbl(l_i).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
16862: p_tasks_in_tbl(l_i).pa_task_id IS NULL -- Create Task Context
16863: THEN
16864: l_add_plan_task_id := null;
16865: IF p_structure_version_id is not null THEN -- Update Project Context

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

16877: IF l_debug_mode = 'Y' THEN
16878: Pa_Debug.WRITE(G_PKG_NAME,'Lowest Task With No Assignments',l_debug_level3);
16879: END IF;
16880:
16881: 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
16882: AND l_add_plan_task_id IS NULL
16883: THEN
16884: IF l_debug_mode = 'Y' THEN
16885: Pa_Debug.WRITE(G_PKG_NAME,'Preparing Tables to call FP add_plan_txn',l_debug_level3);

Line 17286: PA_INTERFACE_UTILS_PUB.get_messages

17282: CLOSE cur_all_task_ver_id;
17283: END IF;
17284:
17285: IF l_msg_count = 1 and x_msg_data IS NULL THEN
17286: PA_INTERFACE_UTILS_PUB.get_messages
17287: (p_encoded => FND_API.G_TRUE
17288: ,p_msg_index => 1
17289: ,p_msg_count => l_msg_count
17290: ,p_msg_data => l_msg_data

Line 17442: pa_interface_utils_pub.get_messages

17438: l_msg_count := FND_MSG_PUB.count_msg;
17439: if l_msg_count > 0 then
17440: x_msg_count := l_msg_count;
17441: if x_msg_count = 1 then
17442: pa_interface_utils_pub.get_messages
17443: (p_encoded => FND_API.G_TRUE,
17444: p_msg_index => 1,
17445: p_msg_count => l_msg_count,
17446: p_msg_data => l_msg_data,

Line 17692: PA_INTERFACE_UTILS_PUB.get_messages

17688: CLOSE cur_task_count;
17689: END IF;
17690:
17691: IF l_msg_count = 1 and x_msg_data IS NULL THEN
17692: PA_INTERFACE_UTILS_PUB.get_messages
17693: (p_encoded => FND_API.G_TRUE
17694: ,p_msg_index => 1
17695: ,p_msg_count => l_msg_count
17696: ,p_msg_data => l_msg_data

Line 18067: PA_INTERFACE_UTILS_PUB.get_messages

18063: x_return_status := FND_API.G_RET_STS_ERROR;
18064: l_msg_count := FND_MSG_PUB.count_msg;
18065:
18066: IF l_msg_count = 1 and x_msg_data IS NULL THEN
18067: PA_INTERFACE_UTILS_PUB.get_messages
18068: (p_encoded => FND_API.G_TRUE
18069: ,p_msg_index => 1
18070: ,p_msg_count => l_msg_count
18071: ,p_msg_data => l_msg_data

Line 18250: PA_INTERFACE_UTILS_PUB.get_messages

18246: l_msg_count := FND_MSG_PUB.count_msg;
18247: retcode := '2';
18248:
18249: IF l_msg_count >= 1 THEN
18250: PA_INTERFACE_UTILS_PUB.get_messages
18251: (p_encoded => FND_API.G_FALSE -- Bug 4348814 : Made false from true FND_API.G_TRUE
18252: ,p_msg_index => 1
18253: ,p_msg_count => l_msg_count
18254: ,p_msg_data => l_msg_data

Line 20276: PA_INTERFACE_UTILS_PUB.get_messages

20272: CLOSE cur_structure_type;
20273: END IF;
20274:
20275: IF l_msg_count = 1 and x_msg_data IS NULL THEN
20276: PA_INTERFACE_UTILS_PUB.get_messages
20277: (p_encoded => FND_API.G_TRUE
20278: ,p_msg_index => 1
20279: ,p_msg_count => l_msg_count
20280: ,p_msg_data => l_msg_data

Line 20825: PA_INTERFACE_UTILS_PUB.get_messages

20821: CLOSE cur_task_info;
20822: END IF;
20823:
20824: IF l_msg_count = 1 and x_msg_data IS NULL THEN
20825: PA_INTERFACE_UTILS_PUB.get_messages
20826: (p_encoded => FND_API.G_TRUE
20827: ,p_msg_index => 1
20828: ,p_msg_count => l_msg_count
20829: ,p_msg_data => l_msg_data

Line 20979: PA_INTERFACE_UTILS_PUB.get_messages

20975: x_return_status := FND_API.G_RET_STS_ERROR;
20976: l_msg_count := FND_MSG_PUB.count_msg;
20977:
20978: IF l_msg_count = 1 and x_msg_data IS NULL THEN
20979: PA_INTERFACE_UTILS_PUB.get_messages
20980: (p_encoded => FND_API.G_TRUE
20981: ,p_msg_index => 1
20982: ,p_msg_count => l_msg_count
20983: ,p_msg_data => l_msg_data

Line 21074: PA_INTERFACE_UTILS_PUB.get_messages

21070:
21071: x_return_status := FND_API.G_RET_STS_ERROR;
21072: l_msg_count := FND_MSG_PUB.count_msg;
21073: IF l_msg_count = 1 and x_msg_data IS NULL THEN
21074: PA_INTERFACE_UTILS_PUB.get_messages
21075: (p_encoded => FND_API.G_TRUE
21076: ,p_msg_index => 1
21077: ,p_msg_count => l_msg_count
21078: ,p_msg_data => l_msg_data

Line 21275: PA_INTERFACE_UTILS_PUB.get_messages

21271:
21272: x_return_status := FND_API.G_RET_STS_ERROR;
21273: l_msg_count := FND_MSG_PUB.count_msg;
21274: IF l_msg_count = 1 and x_msg_data IS NULL THEN
21275: PA_INTERFACE_UTILS_PUB.get_messages
21276: (p_encoded => FND_API.G_TRUE
21277: ,p_msg_index => 1
21278: ,p_msg_count => l_msg_count
21279: ,p_msg_data => l_msg_data

Line 21319: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

21315: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
21316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
21317: ,p_validation_level IN VARCHAR2 := 100
21318: ,p_debug_mode IN VARCHAR2 := 'N'
21319: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21320: ,p_user_id IN NUMBER := FND_GLOBAL.USER_ID
21321: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21322: ,p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21323: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM

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

21317: ,p_validation_level IN VARCHAR2 := 100
21318: ,p_debug_mode IN VARCHAR2 := 'N'
21319: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21320: ,p_user_id IN NUMBER := FND_GLOBAL.USER_ID
21321: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21322: ,p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21323: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
21324: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
21325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 21322: ,p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

21318: ,p_debug_mode IN VARCHAR2 := 'N'
21319: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21320: ,p_user_id IN NUMBER := FND_GLOBAL.USER_ID
21321: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21322: ,p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21323: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
21324: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
21325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21326: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 21391: IF ((p_project_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND (p_project_name IS NOT NULL)) OR

21387: x_msg_count := 0;
21388: x_return_status := FND_API.G_RET_STS_SUCCESS;
21389:
21390: --Project name to id Conversion
21391: IF ((p_project_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND (p_project_name IS NOT NULL)) OR
21392: ((p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND (p_project_id IS NOT NULL)) THEN
21393: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
21394: p_project_name => p_project_name,
21395: p_project_id => p_project_id,

Line 21392: ((p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND (p_project_id IS NOT NULL)) THEN

21388: x_return_status := FND_API.G_RET_STS_SUCCESS;
21389:
21390: --Project name to id Conversion
21391: IF ((p_project_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND (p_project_name IS NOT NULL)) OR
21392: ((p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND (p_project_id IS NOT NULL)) THEN
21393: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
21394: p_project_name => p_project_name,
21395: p_project_id => p_project_id,
21396: x_project_id => l_project_id,

Line 21485: pa_interface_utils_pub.get_messages

21481:
21482: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
21483: x_msg_count := FND_MSG_PUB.count_msg;
21484: if x_msg_count = 1 then
21485: pa_interface_utils_pub.get_messages
21486: (p_encoded => FND_API.G_TRUE,
21487: p_msg_index => 1,
21488: p_msg_count => l_msg_count,
21489: p_msg_data => l_msg_data,

Line 21567: IF (P_Delimeter = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

21563:
21564: l_Delimeter VARCHAR2(10);
21565: BEGIN
21566:
21567: IF (P_Delimeter = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
21568: l_Delimeter := ',';
21569: ELSE
21570: l_Delimeter := p_Delimeter;
21571: END IF;