DBA Data[Home] [Help]

APPS.PA_XC_PROJECT_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 20: (task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

16:
17: -- Task Record structure
18:
19: TYPE task_in_rec_type IS RECORD
20: (task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
21: task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
22: task_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
23: task_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: task_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 21: task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

17: -- Task Record structure
18:
19: TYPE task_in_rec_type IS RECORD
20: (task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
21: task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
22: task_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
23: task_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: task_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 22: task_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

18:
19: TYPE task_in_rec_type IS RECORD
20: (task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
21: task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
22: task_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
23: task_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: task_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: wbs_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 23: task_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

19: TYPE task_in_rec_type IS RECORD
20: (task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
21: task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
22: task_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
23: task_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: task_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: wbs_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: task_description VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 24: task_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

20: (task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
21: task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
22: task_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
23: task_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: task_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: wbs_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: task_description VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: parent_task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 25: task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

21: task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
22: task_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
23: task_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: task_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: wbs_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: task_description VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: parent_task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: early_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 26: wbs_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

22: task_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
23: task_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: task_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: wbs_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: task_description VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: parent_task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: early_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: early_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 27: task_description VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

23: task_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: task_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: wbs_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: task_description VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: parent_task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: early_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: early_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
31: late_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 28: parent_task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

24: task_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: wbs_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: task_description VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: parent_task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: early_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: early_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
31: late_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
32: late_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 29: early_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

25: task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: wbs_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: task_description VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: parent_task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: early_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: early_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
31: late_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
32: late_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 30: early_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

26: wbs_level NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
27: task_description VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: parent_task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: early_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: early_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
31: late_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
32: late_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 31: late_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

27: task_description VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: parent_task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: early_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: early_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
31: late_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
32: late_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 32: late_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

28: parent_task_reference NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: early_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: early_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
31: late_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
32: late_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 33: attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

29: early_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: early_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
31: late_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
32: late_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
37: -- AJL

Line 34: attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

30: early_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
31: late_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
32: late_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
37: -- AJL
38: login_user_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 35: attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

31: late_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
32: late_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
37: -- AJL
38: login_user_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
39: attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 36: attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

32: late_finish_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
37: -- AJL
38: login_user_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
39: attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 38: login_user_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

34: attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
37: -- AJL
38: login_user_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
39: attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
41: attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
42: attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 39: attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

35: attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
37: -- AJL
38: login_user_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
39: attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
41: attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
42: attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 40: attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

36: attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
37: -- AJL
38: login_user_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
39: attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
41: attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
42: attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
44: attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 41: attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

37: -- AJL
38: login_user_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
39: attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
41: attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
42: attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
44: attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
45: progress_report VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 42: attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

38: login_user_name VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
39: attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
41: attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
42: attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
44: attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
45: progress_report VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
46: progress_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 43: attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

39: attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
41: attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
42: attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
44: attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
45: progress_report VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
46: progress_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
47: progress_comments VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 44: attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

40: attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
41: attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
42: attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
44: attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
45: progress_report VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
46: progress_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
47: progress_comments VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
48: progress_asof_date VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 45: progress_report VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

41: attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
42: attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
44: attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
45: progress_report VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
46: progress_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
47: progress_comments VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
48: progress_asof_date VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
49: predecessors VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );

Line 46: progress_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

42: attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
44: attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
45: progress_report VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
46: progress_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
47: progress_comments VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
48: progress_asof_date VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
49: predecessors VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
50: -- AJL

Line 47: progress_comments VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

43: attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
44: attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
45: progress_report VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
46: progress_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
47: progress_comments VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
48: progress_asof_date VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
49: predecessors VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
50: -- AJL
51:

Line 48: progress_asof_date VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

44: attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
45: progress_report VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
46: progress_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
47: progress_comments VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
48: progress_asof_date VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
49: predecessors VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
50: -- AJL
51:
52: -- Creating plsql table task.

Line 49: predecessors VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );

45: progress_report VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
46: progress_status VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
47: progress_comments VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
48: progress_asof_date VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
49: predecessors VARCHAR2(2000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
50: -- AJL
51:
52: -- Creating plsql table task.
53:

Line 63: ( p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

59:
60: -- Procedure Import Task.
61:
62: PROCEDURE import_task
63: ( p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
64: ,p_task_reference IN PA_VC_1000_25
65: ,p_task_name IN PA_VC_1000_150
66: ,p_task_start_date IN PA_VC_1000_10
67: ,p_task_end_date IN PA_VC_1000_10

Line 80: ,p_login_user_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

76: ,p_late_start_date IN PA_VC_1000_10
77: ,p_late_finish_date IN PA_VC_1000_10
78: ,p_display_seq IN PA_VC_1000_150
79: -- AJL
80: ,p_login_user_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
81: ,p_critical_path IN PA_VC_1000_150
82: ,p_sub_project_id IN PA_VC_1000_150
83: ,p_attribute7 IN PA_VC_1000_150
84: ,p_attribute8 IN PA_VC_1000_150

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

92: ,p_language IN VARCHAR2 default 'US'
93: ,p_delimiter IN VARCHAR2 default ','
94:
95: -- Structure sync up
96: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
97: ,p_calling_mode IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
98: -- Structure sync up
99: );
100: -- AJL

Line 97: ,p_calling_mode IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

93: ,p_delimiter IN VARCHAR2 default ','
94:
95: -- Structure sync up
96: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
97: ,p_calling_mode IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
98: -- Structure sync up
99: );
100: -- AJL
101:

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

102: PROCEDURE import_project
103: ( p_user_id IN NUMBER
104: ,p_commit IN VARCHAR2 default 'N'
105: ,p_debug_mode IN VARCHAR2 default 'N'
106: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
107: ,p_project_mpx_start_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
108: ,p_project_mpx_end_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
109: -- AJL
110: ,p_task_mgr_override IN VARCHAR2 default 'N'

Line 107: ,p_project_mpx_start_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

103: ( p_user_id IN NUMBER
104: ,p_commit IN VARCHAR2 default 'N'
105: ,p_debug_mode IN VARCHAR2 default 'N'
106: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
107: ,p_project_mpx_start_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
108: ,p_project_mpx_end_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
109: -- AJL
110: ,p_task_mgr_override IN VARCHAR2 default 'N'
111: ,p_task_pgs_override IN VARCHAR2 default 'N'

Line 108: ,p_project_mpx_end_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

104: ,p_commit IN VARCHAR2 default 'N'
105: ,p_debug_mode IN VARCHAR2 default 'N'
106: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
107: ,p_project_mpx_start_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
108: ,p_project_mpx_end_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
109: -- AJL
110: ,p_task_mgr_override IN VARCHAR2 default 'N'
111: ,p_task_pgs_override IN VARCHAR2 default 'N'
112: -- AJL

Line 116: ,p_responsibility_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

112: -- AJL
113: ,p_process_id IN NUMBER default -1
114: ,p_language IN VARCHAR2 default 'US'
115: ,p_delimiter IN VARCHAR2 default ','
116: ,p_responsibility_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
117: ,p_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
118: ,p_structure_version_id IN NUMBER
119: ,p_calling_mode IN VARCHAR2
120: ,p_resp_appl_id IN NUMBER default 275 -- 5233777

Line 117: ,p_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

113: ,p_process_id IN NUMBER default -1
114: ,p_language IN VARCHAR2 default 'US'
115: ,p_delimiter IN VARCHAR2 default ','
116: ,p_responsibility_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
117: ,p_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
118: ,p_structure_version_id IN NUMBER
119: ,p_calling_mode IN VARCHAR2
120: ,p_resp_appl_id IN NUMBER default 275 -- 5233777
121: ,x_msg_count IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 130: ( p_task_index IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug 3302732

126: ( value_in IN VARCHAR2)
127: RETURN BOOLEAN;
128:
129: PROCEDURE fetch_task_id
130: ( p_task_index IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug 3302732
131: ,p_project_id IN NUMBER
132: ,p_pm_task_reference IN VARCHAR2
133: ,x_task_id OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
134: