APPS.PA_PROGRESS_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 8: TASK_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

4: g_wbs_apply_prog number := null;
5: -- Bug 3606627 : Changed Defaulting to g_miss_xxx instead of null
6: TYPE PA_TASK_PROGRESS_LIST_REC_TYPE IS RECORD
7: (
8: TASK_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
9: TASK_NAME VARCHAR2(20) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10: TASK_NUMBER VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
11: PM_TASK_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
12: PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 9: TASK_NAME VARCHAR2(20) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

5: -- Bug 3606627 : Changed Defaulting to g_miss_xxx instead of null
6: TYPE PA_TASK_PROGRESS_LIST_REC_TYPE IS RECORD
7: (
8: TASK_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
9: TASK_NAME VARCHAR2(20) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10: TASK_NUMBER VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
11: PM_TASK_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
12: PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13: DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 10: TASK_NUMBER VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6: TYPE PA_TASK_PROGRESS_LIST_REC_TYPE IS RECORD
7: (
8: TASK_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
9: TASK_NAME VARCHAR2(20) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10: TASK_NUMBER VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
11: PM_TASK_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
12: PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13: DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14: OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 11: PM_TASK_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7: (
8: TASK_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
9: TASK_NAME VARCHAR2(20) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10: TASK_NUMBER VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
11: PM_TASK_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
12: PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13: DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14: OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15: OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 12: PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

8: TASK_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
9: TASK_NAME VARCHAR2(20) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10: TASK_NUMBER VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
11: PM_TASK_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
12: PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13: DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14: OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15: OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
16: OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 13: DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

9: TASK_NAME VARCHAR2(20) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
10: TASK_NUMBER VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
11: PM_TASK_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
12: PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13: DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14: OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15: OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
16: OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
17: PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 14: OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

10: TASK_NUMBER VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
11: PM_TASK_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
12: PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13: DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14: OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15: OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
16: OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
17: PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
18: PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 15: OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

11: PM_TASK_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
12: PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13: DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14: OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15: OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
16: OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
17: PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
18: PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
19: ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 16: OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

12: PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13: DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14: OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15: OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
16: OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
17: PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
18: PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
19: ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
20: ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 17: PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

13: DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14: OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15: OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
16: OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
17: PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
18: PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
19: ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
20: ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
21: ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 18: PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

14: OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15: OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
16: OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
17: PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
18: PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
19: ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
20: ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
21: ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
22: ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 19: ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

15: OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
16: OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
17: PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
18: PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
19: ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
20: ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
21: ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
22: ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
23: SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 20: ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

16: OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
17: PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
18: PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
19: ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
20: ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
21: ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
22: ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
23: SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: SCHEDULED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 21: ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

17: PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
18: PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
19: ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
20: ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
21: ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
22: ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
23: SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: SCHEDULED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: TASK_STATUS VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 22: ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

18: PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
19: ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
20: ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
21: ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
22: ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
23: SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: SCHEDULED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: TASK_STATUS VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: EST_REMAINING_EFFORT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 23: SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

19: ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
20: ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
21: ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
22: ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
23: SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: SCHEDULED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: TASK_STATUS VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: EST_REMAINING_EFFORT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: ACTUAL_WORK_QUANTITY NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 24: SCHEDULED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

20: ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
21: ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
22: ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
23: SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: SCHEDULED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: TASK_STATUS VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: EST_REMAINING_EFFORT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: ACTUAL_WORK_QUANTITY NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
28: LOWEST_LEVEL_TASK VARCHAR2(1) := 'N',

Line 25: TASK_STATUS VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

21: ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
22: ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
23: SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: SCHEDULED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: TASK_STATUS VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: EST_REMAINING_EFFORT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: ACTUAL_WORK_QUANTITY NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
28: LOWEST_LEVEL_TASK VARCHAR2(1) := 'N',
29: LATEST_AS_OF_DATE Date := NULL,

Line 26: EST_REMAINING_EFFORT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

22: ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
23: SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: SCHEDULED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: TASK_STATUS VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: EST_REMAINING_EFFORT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: ACTUAL_WORK_QUANTITY NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
28: LOWEST_LEVEL_TASK VARCHAR2(1) := 'N',
29: LATEST_AS_OF_DATE Date := NULL,
30: PROGRESS_MODE VARCHAR2(30) := 'N',

Line 27: ACTUAL_WORK_QUANTITY NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

23: SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: SCHEDULED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: TASK_STATUS VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: EST_REMAINING_EFFORT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: ACTUAL_WORK_QUANTITY NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
28: LOWEST_LEVEL_TASK VARCHAR2(1) := 'N',
29: LATEST_AS_OF_DATE Date := NULL,
30: PROGRESS_MODE VARCHAR2(30) := 'N',
31: ETC_COST NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, /* FP M task progress bug 3420093 */

Line 31: ETC_COST NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, /* FP M task progress bug 3420093 */

27: ACTUAL_WORK_QUANTITY NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
28: LOWEST_LEVEL_TASK VARCHAR2(1) := 'N',
29: LATEST_AS_OF_DATE Date := NULL,
30: PROGRESS_MODE VARCHAR2(30) := 'N',
31: ETC_COST NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, /* FP M task progress bug 3420093 */
32: PM_DELIVERABLE_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
33: PM_TASK_ASSGN_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
34: ACTUAL_COST_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug 3606627
35: ACTUAL_EFFORT_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627

Line 32: PM_DELIVERABLE_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627

28: LOWEST_LEVEL_TASK VARCHAR2(1) := 'N',
29: LATEST_AS_OF_DATE Date := NULL,
30: PROGRESS_MODE VARCHAR2(30) := 'N',
31: ETC_COST NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, /* FP M task progress bug 3420093 */
32: PM_DELIVERABLE_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
33: PM_TASK_ASSGN_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
34: ACTUAL_COST_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug 3606627
35: ACTUAL_EFFORT_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
36: );

Line 33: PM_TASK_ASSGN_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627

29: LATEST_AS_OF_DATE Date := NULL,
30: PROGRESS_MODE VARCHAR2(30) := 'N',
31: ETC_COST NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, /* FP M task progress bug 3420093 */
32: PM_DELIVERABLE_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
33: PM_TASK_ASSGN_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
34: ACTUAL_COST_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug 3606627
35: ACTUAL_EFFORT_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
36: );
37:

Line 34: ACTUAL_COST_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug 3606627

30: PROGRESS_MODE VARCHAR2(30) := 'N',
31: ETC_COST NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, /* FP M task progress bug 3420093 */
32: PM_DELIVERABLE_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
33: PM_TASK_ASSGN_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
34: ACTUAL_COST_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug 3606627
35: ACTUAL_EFFORT_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
36: );
37:
38: TYPE PA_TASK_PROGRESS_LIST_TBL_TYPE IS TABLE OF PA_TASK_PROGRESS_LIST_REC_TYPE

Line 35: ACTUAL_EFFORT_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627

31: ETC_COST NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, /* FP M task progress bug 3420093 */
32: PM_DELIVERABLE_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
33: PM_TASK_ASSGN_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
34: ACTUAL_COST_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug 3606627
35: ACTUAL_EFFORT_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
36: );
37:
38: TYPE PA_TASK_PROGRESS_LIST_TBL_TYPE IS TABLE OF PA_TASK_PROGRESS_LIST_REC_TYPE
39: INDEX BY BINARY_INTEGER;

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

50: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
51: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
52: p_calling_mode IN VARCHAR2 := null ,
53: p_debug_mode IN VARCHAR2 :='N' ,
54: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
55: p_action IN VARCHAR2 default 'SAVE' ,
56: p_bulk_load_flag IN VARCHAR2 default 'N' ,
57: p_progress_mode IN VARCHAR2 default 'FUTURE' ,
58: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 58: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

54: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
55: p_action IN VARCHAR2 default 'SAVE' ,
56: p_bulk_load_flag IN VARCHAR2 default 'N' ,
57: p_progress_mode IN VARCHAR2 default 'FUTURE' ,
58: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
59: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
60: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
61: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
62: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

55: p_action IN VARCHAR2 default 'SAVE' ,
56: p_bulk_load_flag IN VARCHAR2 default 'N' ,
57: p_progress_mode IN VARCHAR2 default 'FUTURE' ,
58: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
59: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
60: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
61: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
62: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
63: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 60: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

56: p_bulk_load_flag IN VARCHAR2 default 'N' ,
57: p_progress_mode IN VARCHAR2 default 'FUTURE' ,
58: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
59: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
60: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
61: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
62: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
63: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
64: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 61: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

57: p_progress_mode IN VARCHAR2 default 'FUTURE' ,
58: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
59: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
60: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
61: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
62: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
63: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
64: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
65: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 62: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

58: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
59: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
60: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
61: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
62: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
63: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
64: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
65: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
66: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 63: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

59: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
60: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
61: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
62: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
63: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
64: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
65: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
66: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
67: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

60: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
61: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
62: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
63: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
64: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
65: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
66: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
67: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
68: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 65: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

61: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
62: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
63: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
64: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
65: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
66: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
67: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
68: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
69: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 66: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

62: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
63: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
64: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
65: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
66: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
67: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
68: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
69: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
70: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 67: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

63: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
64: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
65: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
66: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
67: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
68: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
69: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
70: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
71: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

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

64: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
65: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
66: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
67: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
68: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
69: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
70: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
71: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
72: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

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

65: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
66: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
67: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
68: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
69: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
70: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
71: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
72: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
73: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 70: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

66: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
67: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
68: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
69: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
70: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
71: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
72: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
73: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
74: p_record_version_number IN NUMBER ,

Line 71: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

67: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
68: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
69: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
70: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
71: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
72: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
73: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
74: p_record_version_number IN NUMBER ,
75: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

68: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
69: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
70: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
71: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
72: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
73: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
74: p_record_version_number IN NUMBER ,
75: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
76: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

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

69: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
70: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
71: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
72: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
73: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
74: p_record_version_number IN NUMBER ,
75: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
76: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
77: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 75: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

71: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
72: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
73: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
74: p_record_version_number IN NUMBER ,
75: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
76: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
77: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
78: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
79: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,

Line 76: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

72: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
73: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
74: p_record_version_number IN NUMBER ,
75: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
76: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
77: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
78: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
79: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
80: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 77: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

73: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
74: p_record_version_number IN NUMBER ,
75: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
76: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
77: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
78: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
79: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
80: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
81: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 78: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

74: p_record_version_number IN NUMBER ,
75: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
76: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
77: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
78: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
79: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
80: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
81: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
82: p_prog_fom_wp_flag IN VARCHAR2 := 'N' ,

Line 80: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

76: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
77: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
78: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
79: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
80: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
81: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
82: p_prog_fom_wp_flag IN VARCHAR2 := 'N' ,
83: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
84: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 81: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

77: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
78: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
79: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
80: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
81: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
82: p_prog_fom_wp_flag IN VARCHAR2 := 'N' ,
83: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
84: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
85: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 83: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

79: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
80: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
81: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
82: p_prog_fom_wp_flag IN VARCHAR2 := 'N' ,
83: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
84: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
85: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
86: p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- 3910193
87: x_resource_list_member_id OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 84: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

80: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
81: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
82: p_prog_fom_wp_flag IN VARCHAR2 := 'N' ,
83: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
84: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
85: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
86: p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- 3910193
87: x_resource_list_member_id OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
88: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

81: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
82: p_prog_fom_wp_flag IN VARCHAR2 := 'N' ,
83: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
84: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
85: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
86: p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- 3910193
87: x_resource_list_member_id OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
88: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
89: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 86: p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- 3910193

82: p_prog_fom_wp_flag IN VARCHAR2 := 'N' ,
83: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
84: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
85: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
86: p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- 3910193
87: x_resource_list_member_id OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
88: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
89: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
90: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

123: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
124: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
125: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
126: ,p_debug_mode IN VARCHAR2 :='N'
127: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
128: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
129: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
130: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
131: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

125: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
126: ,p_debug_mode IN VARCHAR2 :='N'
127: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
128: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
129: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
130: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
131: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
132: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
133: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 130: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

126: ,p_debug_mode IN VARCHAR2 :='N'
127: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
128: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
129: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
130: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
131: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
132: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
133: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 131: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

127: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
128: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
129: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
130: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
131: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
132: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
133: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
135: ,p_lowest_level_task IN VARCHAR2 := 'N'

Line 132: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

128: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
129: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
130: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
131: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
132: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
133: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
135: ,p_lowest_level_task IN VARCHAR2 := 'N'
136: ,p_process_whole_tree IN VARCHAR2 := 'Y'

Line 133: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

129: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
130: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
131: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
132: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
133: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
135: ,p_lowest_level_task IN VARCHAR2 := 'N'
136: ,p_process_whole_tree IN VARCHAR2 := 'Y'
137: ,p_structure_version_id IN NUMBER

Line 134: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

130: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
131: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
132: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
133: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
135: ,p_lowest_level_task IN VARCHAR2 := 'N'
136: ,p_process_whole_tree IN VARCHAR2 := 'Y'
137: ,p_structure_version_id IN NUMBER
138: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'

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

175: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
176: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
177: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
178: ,p_debug_mode IN VARCHAR2 :='N'
179: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
180: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
181: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
182: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
183: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE

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

176: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
177: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
178: ,p_debug_mode IN VARCHAR2 :='N'
179: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
180: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
181: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
182: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
183: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
184: ,p_lowest_level_task IN VARCHAR2 := 'N'

Line 181: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

177: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
178: ,p_debug_mode IN VARCHAR2 :='N'
179: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
180: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
181: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
182: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
183: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
184: ,p_lowest_level_task IN VARCHAR2 := 'N'
185: ,p_task_version_id IN NUMBER

Line 182: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

178: ,p_debug_mode IN VARCHAR2 :='N'
179: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
180: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
181: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
182: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
183: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
184: ,p_lowest_level_task IN VARCHAR2 := 'N'
185: ,p_task_version_id IN NUMBER
186: ,p_structure_version_id IN NUMBER

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

204: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
205: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
206: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
207: ,p_debug_mode IN VARCHAR2 :='N'
208: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
209: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
210: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
211: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
212: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

205: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
206: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
207: ,p_debug_mode IN VARCHAR2 :='N'
208: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
209: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
210: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
211: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
212: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
213: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 210: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

206: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
207: ,p_debug_mode IN VARCHAR2 :='N'
208: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
209: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
210: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
211: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
212: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
213: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
214: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 211: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

207: ,p_debug_mode IN VARCHAR2 :='N'
208: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
209: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
210: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
211: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
212: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
213: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
214: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
215: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 212: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

208: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
209: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
210: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
211: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
212: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
213: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
214: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
215: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
216: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 213: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

209: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
210: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
211: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
212: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
213: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
214: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
215: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
216: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
217: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 214: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

210: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
211: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
212: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
213: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
214: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
215: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
216: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
217: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
218: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 215: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

211: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
212: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
213: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
214: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
215: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
216: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
217: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
218: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
219: ,X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 216: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

212: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
213: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
214: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
215: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
216: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
217: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
218: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
219: ,X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
220: ,P_ALLOW_COLLAB_PROG_ENTRY IN VARCHAR2 := 'N'

Line 217: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

213: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
214: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
215: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
216: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
217: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
218: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
219: ,X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
220: ,P_ALLOW_COLLAB_PROG_ENTRY IN VARCHAR2 := 'N'
221: ,P_ALLW_PHY_PRCNT_CMP_OVERRIDES IN VARCHAR2 := 'N'

Line 218: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

214: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
215: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
216: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
217: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
218: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
219: ,X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
220: ,P_ALLOW_COLLAB_PROG_ENTRY IN VARCHAR2 := 'N'
221: ,P_ALLW_PHY_PRCNT_CMP_OVERRIDES IN VARCHAR2 := 'N'
222: ,P_STRUCTURE_TYPE IN VARCHAR2 := 'WORKPLAN'

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

233: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
234: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
235: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
236: ,p_debug_mode IN VARCHAR2 :='N'
237: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
238: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
239: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
240: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
241: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

234: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
235: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
236: ,p_debug_mode IN VARCHAR2 :='N'
237: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
238: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
239: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
240: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
241: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
242: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 239: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

235: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
236: ,p_debug_mode IN VARCHAR2 :='N'
237: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
238: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
239: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
240: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
241: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
242: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 240: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

236: ,p_debug_mode IN VARCHAR2 :='N'
237: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
238: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
239: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
240: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
241: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
242: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
244: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 241: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

237: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
238: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
239: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
240: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
241: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
242: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
244: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 242: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

238: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
239: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
240: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
241: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
242: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
244: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
246: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 243: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

239: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
240: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
241: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
242: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
244: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
246: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
247: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 244: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

240: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
241: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
242: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
244: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
246: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
247: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
248: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER

Line 245: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

241: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
242: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
244: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
246: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
247: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
248: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
249: ,p_record_version_number IN NUMBER

Line 246: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

242: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
244: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
246: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
247: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
248: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
249: ,p_record_version_number IN NUMBER
250: ,p_allow_collab_prog_entry IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 247: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

243: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
244: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
246: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
247: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
248: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
249: ,p_record_version_number IN NUMBER
250: ,p_allow_collab_prog_entry IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
251: ,p_allw_phy_prcnt_cmp_overrides IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 250: ,p_allow_collab_prog_entry IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

246: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
247: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
248: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
249: ,p_record_version_number IN NUMBER
250: ,p_allow_collab_prog_entry IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
251: ,p_allw_phy_prcnt_cmp_overrides IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
252: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
253: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
254: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 251: ,p_allw_phy_prcnt_cmp_overrides IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

247: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
248: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
249: ,p_record_version_number IN NUMBER
250: ,p_allow_collab_prog_entry IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
251: ,p_allw_phy_prcnt_cmp_overrides IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
252: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
253: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
254: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
255: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

248: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
249: ,p_record_version_number IN NUMBER
250: ,p_allow_collab_prog_entry IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
251: ,p_allw_phy_prcnt_cmp_overrides IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
252: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
253: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
254: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
255: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
256: );

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

262: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
263: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
264: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
265: ,p_debug_mode IN VARCHAR2 :='N'
266: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
267: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
268: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
269: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
270: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- Amit

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

263: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
264: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
265: ,p_debug_mode IN VARCHAR2 :='N'
266: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
267: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
268: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
269: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
270: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- Amit
271: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 268: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

264: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
265: ,p_debug_mode IN VARCHAR2 :='N'
266: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
267: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
268: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
269: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
270: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- Amit
271: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
272: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 269: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

265: ,p_debug_mode IN VARCHAR2 :='N'
266: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
267: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
268: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
269: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
270: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- Amit
271: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
272: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
273: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

280: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
281: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
282: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
283: ,p_debug_mode IN VARCHAR2 :='N'
284: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
285: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
286: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
287: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
288: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

281: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
282: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
283: ,p_debug_mode IN VARCHAR2 :='N'
284: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
285: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
286: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
287: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
288: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
289: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 286: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

282: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
283: ,p_debug_mode IN VARCHAR2 :='N'
284: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
285: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
286: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
287: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
288: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
289: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
290: );

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

296: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
297: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
298: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
299: ,p_debug_mode IN VARCHAR2 :='N'
300: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: ,p_task_status IN VARCHAR2
302: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
304: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

298: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
299: ,p_debug_mode IN VARCHAR2 :='N'
300: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: ,p_task_status IN VARCHAR2
302: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
304: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
305: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
306: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 303: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

299: ,p_debug_mode IN VARCHAR2 :='N'
300: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: ,p_task_status IN VARCHAR2
302: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
304: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
305: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
306: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
307: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 304: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

300: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: ,p_task_status IN VARCHAR2
302: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
304: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
305: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
306: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
307: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
308: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'

Line 305: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

301: ,p_task_status IN VARCHAR2
302: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
304: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
305: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
306: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
307: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
308: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
309: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 306: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

302: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
303: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
304: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
305: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
306: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
307: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
308: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
309: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
310: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

303: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
304: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
305: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
306: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
307: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
308: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
309: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
310: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
311: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 315: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

311: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
312: );
313:
314: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
315: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
316: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
317: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
318: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
319: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 316: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

312: );
313:
314: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
315: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
316: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
317: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
318: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
319: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
320: ,p_lowest_level_task IN VARCHAR2 := 'N'

Line 317: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

313:
314: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
315: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
316: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
317: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
318: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
319: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
320: ,p_lowest_level_task IN VARCHAR2 := 'N'
321: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 318: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

314: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
315: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
316: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
317: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
318: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
319: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
320: ,p_lowest_level_task IN VARCHAR2 := 'N'
321: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
322: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'

Line 319: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

315: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
316: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
317: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
318: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
319: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
320: ,p_lowest_level_task IN VARCHAR2 := 'N'
321: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
322: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
323: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

319: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
320: ,p_lowest_level_task IN VARCHAR2 := 'N'
321: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
322: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
323: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
324: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
325: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
326: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
327: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 324: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

320: ,p_lowest_level_task IN VARCHAR2 := 'N'
321: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
322: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
323: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
324: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
325: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
326: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
327: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
328: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 325: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

321: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
322: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
323: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
324: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
325: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
326: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
327: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
328: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
329: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

357: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
358: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
359: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
360: ,p_debug_mode IN VARCHAR2 :='N'
361: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
362: ,p_project_id IN NUMBER
363: ,p_working_str_version_id IN NUMBER
364: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
365: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

375: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
376: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
377: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
378: ,p_debug_mode IN VARCHAR2 :='N'
379: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
380: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
381: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
382: ,p_task_version_id IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type()
383: ,p_calling_context IN VARCHAR2 := 'STRUCTURE_VERSION'

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

376: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
377: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
378: ,p_debug_mode IN VARCHAR2 :='N'
379: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
380: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
381: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
382: ,p_task_version_id IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type()
383: ,p_calling_context IN VARCHAR2 := 'STRUCTURE_VERSION'
384: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

377: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
378: ,p_debug_mode IN VARCHAR2 :='N'
379: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
380: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
381: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
382: ,p_task_version_id IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type()
383: ,p_calling_context IN VARCHAR2 := 'STRUCTURE_VERSION'
384: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
385: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

395: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
396: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
397: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
398: ,p_debug_mode IN VARCHAR2 :='N'
399: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
400: ,P_Project_ID IN NUMBER
401: ,P_Calling_Mode IN VARCHAR2
402: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
403: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

413: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
414: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
415: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
416: ,p_debug_mode IN VARCHAR2 :='N'
417: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
418: ,p_action IN VARCHAR2 :='SAVE'
419: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
420: ,p_progress_mode IN VARCHAR2 :='FUTURE'
421: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 421: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

417: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
418: ,p_action IN VARCHAR2 :='SAVE'
419: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
420: ,p_progress_mode IN VARCHAR2 :='FUTURE'
421: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
422: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
423: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
424: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
425: ,p_object_type IN VARCHAR2 :='PA_TASKS'

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

418: ,p_action IN VARCHAR2 :='SAVE'
419: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
420: ,p_progress_mode IN VARCHAR2 :='FUTURE'
421: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
422: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
423: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
424: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
425: ,p_object_type IN VARCHAR2 :='PA_TASKS'
426: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 423: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

419: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
420: ,p_progress_mode IN VARCHAR2 :='FUTURE'
421: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
422: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
423: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
424: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
425: ,p_object_type IN VARCHAR2 :='PA_TASKS'
426: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
427: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 424: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

420: ,p_progress_mode IN VARCHAR2 :='FUTURE'
421: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
422: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
423: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
424: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
425: ,p_object_type IN VARCHAR2 :='PA_TASKS'
426: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
427: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 426: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

422: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
423: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
424: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
425: ,p_object_type IN VARCHAR2 :='PA_TASKS'
426: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
427: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
429: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

423: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
424: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
425: ,p_object_type IN VARCHAR2 :='PA_TASKS'
426: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
427: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
429: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 428: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

424: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
425: ,p_object_type IN VARCHAR2 :='PA_TASKS'
426: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
427: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
429: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
432: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 429: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

425: ,p_object_type IN VARCHAR2 :='PA_TASKS'
426: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
427: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
429: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
432: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
433: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 430: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

426: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
427: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
429: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
432: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
433: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
434: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

427: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
429: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
432: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
433: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
434: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
435: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

428: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
429: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
432: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
433: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
434: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
435: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
436: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 433: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

429: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
432: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
433: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
434: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
435: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
436: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
437: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 434: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

430: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
432: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
433: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
434: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
435: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
436: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
437: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

431: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
432: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
433: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
434: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
435: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
436: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
437: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

432: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
433: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
434: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
435: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
436: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
437: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 437: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

433: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
434: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
435: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
436: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
437: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 438: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

434: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
435: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
436: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
437: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
442: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 439: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

435: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
436: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
437: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
442: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
443: ,p_structure_type IN VARCHAR2 :='WORKPLAN'

Line 440: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

436: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
437: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
442: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
443: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
444: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 441: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

437: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
438: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
442: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
443: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
444: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 442: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

438: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
442: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
443: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
444: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
446: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 444: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

440: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
442: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
443: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
444: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
446: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 445: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

441: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
442: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
443: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
444: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
446: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 446: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

442: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
443: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
444: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
446: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 447: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

443: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
444: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
446: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
451: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 448: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

444: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
446: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
451: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 449: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

445: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
446: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
451: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

446: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
451: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 451: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

447: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
451: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
455: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 452: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

448: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
451: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
455: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 453: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

449: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
450: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
451: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
455: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 454: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

450: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
451: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
455: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
458: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 455: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

451: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
452: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
455: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
458: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 456: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

452: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
455: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
458: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
460: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224

Line 457: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

453: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
455: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
458: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
460: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
461: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224

Line 458: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

454: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
455: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
458: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
460: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
461: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
462: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193

Line 459: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

455: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
458: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
460: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
461: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
462: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193
463: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 460: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224

456: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
458: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
460: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
461: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
462: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193
463: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
464: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 461: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224

457: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
458: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
460: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
461: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
462: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193
463: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
464: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
465: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 462: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193

458: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
460: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
461: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
462: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193
463: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
464: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
465: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
466: );

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

474: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
475: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
476: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
477: ,p_debug_mode IN VARCHAR2 :='N'
478: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
479: ,p_project_id IN NUMBER
480: ,p_project_element_id IN NUMBER DEFAULT NULL --bug 4183307
481: ,p_structure_version_id IN NUMBER DEFAULT NULL
482: ,p_baselined_str_ver_id IN NUMBER DEFAULT NULL

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

497: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
498: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
499: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
500: ,p_debug_mode IN VARCHAR2 :='N'
501: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
502: ,p_project_Id NUMBER
503: ,p_structure_version_id NUMBER
504: ,p_proj_element_id NUMBER
505: ,p_object_id NUMBER

Line 510: ,p_rbs_element_id NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

506: ,p_object_type VARCHAR2
507: ,p_as_of_date DATE
508: ,p_resource_assignment_id NUMBER :=null -- Bug 4186007
509: ,p_resource_list_member_id NUMBER :=null-- Bug 4186007
510: ,p_rbs_element_id NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
511: ,p_rate_based_flag VARCHAR2 := 'Y' -- Default for Task
512: ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
513: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
514: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 513: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed

509: ,p_resource_list_member_id NUMBER :=null-- Bug 4186007
510: ,p_rbs_element_id NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
511: ,p_rate_based_flag VARCHAR2 := 'Y' -- Default for Task
512: ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
513: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
514: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
515: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
516: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
517: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 514: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

510: ,p_rbs_element_id NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
511: ,p_rate_based_flag VARCHAR2 := 'Y' -- Default for Task
512: ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
513: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
514: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
515: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
516: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
517: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
518: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585

Line 515: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

511: ,p_rate_based_flag VARCHAR2 := 'Y' -- Default for Task
512: ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
513: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
514: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
515: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
516: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
517: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
518: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
519: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585

Line 516: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

512: ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
513: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
514: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
515: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
516: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
517: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
518: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
519: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
520: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585

Line 517: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

513: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
514: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
515: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
516: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
517: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
518: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
519: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
520: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
521: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585

Line 518: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585

514: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
515: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
516: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
517: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
518: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
519: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
520: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
521: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
522: ,p_call_pji_apis_flag VARCHAR2 := 'Y'

Line 519: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585

515: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
516: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
517: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
518: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
519: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
520: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
521: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
522: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
523: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

Line 520: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585

516: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
517: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
518: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
519: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
520: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
521: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
522: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
523: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
524: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

Line 521: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585

517: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
518: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
519: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
520: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
521: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
522: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
523: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
524: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
525: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

Line 523: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

519: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
520: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
521: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
522: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
523: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
524: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
525: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
526: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
527: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

Line 524: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

520: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
521: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
522: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
523: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
524: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
525: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
526: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
527: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
528: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

Line 525: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

521: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
522: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
523: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
524: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
525: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
526: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
527: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
528: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
529: -- BUG # 3659659.

Line 526: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

522: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
523: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
524: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
525: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
526: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
527: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
528: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
529: -- BUG # 3659659.
530: ,p_txn_currency_code VARCHAR2 := null

Line 527: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

523: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
524: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
525: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
526: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
527: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
528: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
529: -- BUG # 3659659.
530: ,p_txn_currency_code VARCHAR2 := null
531: ,p_prj_currency_code VARCHAR2 := null

Line 528: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404

524: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
525: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
526: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
527: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
528: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
529: -- BUG # 3659659.
530: ,p_txn_currency_code VARCHAR2 := null
531: ,p_prj_currency_code VARCHAR2 := null
532: ,p_pfn_currency_code VARCHAR2 := null

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

549: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
550: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
551: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
552: ,p_debug_mode IN VARCHAR2 :='N'
553: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
554: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
555: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
556: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
557: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

550: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
551: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
552: ,p_debug_mode IN VARCHAR2 :='N'
553: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
554: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
555: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
556: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
557: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
558: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 555: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

551: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
552: ,p_debug_mode IN VARCHAR2 :='N'
553: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
554: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
555: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
556: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
557: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
558: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
559: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

552: ,p_debug_mode IN VARCHAR2 :='N'
553: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
554: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
555: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
556: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
557: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
558: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
559: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
560: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 557: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

553: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
554: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
555: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
556: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
557: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
558: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
559: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
560: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
561: );

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

567: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
568: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
569: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
570: ,p_debug_mode IN VARCHAR2 :='N'
571: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
572: ,p_project_id IN NUMBER
573: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
574: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
575: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

582: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
583: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
584: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
585: ,p_debug_mode IN VARCHAR2 :='N'
586: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
587: ,p_project_id IN NUMBER
588: ,p_working_str_ver_id IN NUMBER -- Bug 4190086
589: ,p_pub_structure_version_id IN NUMBER -- Bug 3839288
590: ,x_upd_new_elem_ver_id_flag OUT NOCOPY VARCHAR2 -- BUG 3951024, rtarway --File.Sql.39 bug 4440895

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

628: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
629: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
630: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
631: ,p_debug_mode IN VARCHAR2 :='N'
632: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
633: ,p_action IN VARCHAR2 :='SAVE'
634: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
635: ,p_progress_mode IN VARCHAR2 :='FUTURE'
636: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 636: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

632: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
633: ,p_action IN VARCHAR2 :='SAVE'
634: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
635: ,p_progress_mode IN VARCHAR2 :='FUTURE'
636: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
637: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
638: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
639: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
640: ,p_object_type IN VARCHAR2 :='PA_TASKS'

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

633: ,p_action IN VARCHAR2 :='SAVE'
634: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
635: ,p_progress_mode IN VARCHAR2 :='FUTURE'
636: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
637: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
638: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
639: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
640: ,p_object_type IN VARCHAR2 :='PA_TASKS'
641: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 638: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

634: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
635: ,p_progress_mode IN VARCHAR2 :='FUTURE'
636: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
637: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
638: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
639: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
640: ,p_object_type IN VARCHAR2 :='PA_TASKS'
641: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 639: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

635: ,p_progress_mode IN VARCHAR2 :='FUTURE'
636: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
637: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
638: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
639: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
640: ,p_object_type IN VARCHAR2 :='PA_TASKS'
641: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
643: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

637: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
638: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
639: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
640: ,p_object_type IN VARCHAR2 :='PA_TASKS'
641: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
643: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

638: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
639: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
640: ,p_object_type IN VARCHAR2 :='PA_TASKS'
641: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
643: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

639: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
640: ,p_object_type IN VARCHAR2 :='PA_TASKS'
641: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
643: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
647: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

640: ,p_object_type IN VARCHAR2 :='PA_TASKS'
641: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
643: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
647: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,p_structure_type IN VARCHAR2 :='FINANCIAL'

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

641: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
642: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
643: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
647: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
649: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 646: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

642: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
643: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
647: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
649: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
650: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

643: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
647: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
649: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
650: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
651: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 649: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

645: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
647: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
649: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
650: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
651: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
652: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
653: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

646: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
647: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
648: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
649: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
650: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
651: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
652: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
653: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
654:

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

661: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
662: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
663: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
664: ,p_debug_mode IN VARCHAR2 :='N'
665: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
666: ,p_project_id IN NUMBER
667: ,p_structure_version_id IN NUMBER
668: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
669: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

678: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
679: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
680: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
681: ,p_debug_mode IN VARCHAR2 :='N'
682: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
683: ,p_person_id NUMBER
684: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
685: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
686: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

702: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
703: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
704: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
705: ,p_debug_mode IN VARCHAR2 :='N'
706: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
707: ,p_project_id IN NUMBER
708: ,p_task_id IN NUMBER
709: ,p_task_version_id IN NUMBER
710: ,p_as_of_date IN DATE

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

733: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
734: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
735: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
736: ,p_debug_mode IN VARCHAR2 :='N'
737: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
738: ,p_project_id IN NUMBER
739: ,p_src_str_ver_id IN NUMBER
740: ,p_dst_str_ver_id IN NUMBER
741: ,p_pub_wp_with_prog_flag IN VARCHAR2 := 'Y'

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

775: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
776: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
777: ,p_calling_mode IN VARCHAR2 := null
778: ,p_debug_mode IN VARCHAR2 :='N'
779: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
780: ,p_action IN VARCHAR2 :='SAVE'
781: ,p_rollup_entire_wbs_flag IN VARCHAR2 :='N'
782: ,p_progress_mode IN VARCHAR2 :='FUTURE'
783: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 783: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

779: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
780: ,p_action IN VARCHAR2 :='SAVE'
781: ,p_rollup_entire_wbs_flag IN VARCHAR2 :='N'
782: ,p_progress_mode IN VARCHAR2 :='FUTURE'
783: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
785: ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
786: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
787: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

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

831: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
832: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
833: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
834: ,p_debug_mode IN VARCHAR2 :='N'
835: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
836: ,p_project_id IN NUMBER
837: ,p_working_str_version_id IN NUMBER
838: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
839: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895