13:
14: TYPE assignment_in_rec_type IS RECORD
15: ( -- All parameters listed initially are used in creation and updation
16: --Either project reference or id is required
17: pm_project_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18: ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19: --Structure version id is required currently
20: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: --Task reference or id is required
14: TYPE assignment_in_rec_type IS RECORD
15: ( -- All parameters listed initially are used in creation and updation
16: --Either project reference or id is required
17: pm_project_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18: ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19: --Structure version id is required currently
20: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: --Task reference or id is required
22: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16: --Either project reference or id is required
17: pm_project_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18: ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19: --Structure version id is required currently
20: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: --Task reference or id is required
22: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19: --Structure version id is required currently
20: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: --Task reference or id is required
22: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
25: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for determination of updation.
26: -- Task Assignment Reference can be created but not updated.
19: --Structure version id is required currently
20: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: --Task reference or id is required
22: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
25: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for determination of updation.
26: -- Task Assignment Reference can be created but not updated.
27: ,pm_task_asgmt_reference VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
20: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: --Task reference or id is required
22: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
25: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for determination of updation.
26: -- Task Assignment Reference can be created but not updated.
27: ,pm_task_asgmt_reference VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
28: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
23: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
25: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for determination of updation.
26: -- Task Assignment Reference can be created but not updated.
27: ,pm_task_asgmt_reference VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
28: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: -- Planning resource list member id required for creation
31: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
25: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for determination of updation.
26: -- Task Assignment Reference can be created but not updated.
27: ,pm_task_asgmt_reference VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
28: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: -- Planning resource list member id required for creation
31: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
25: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for determination of updation.
26: -- Task Assignment Reference can be created but not updated.
27: ,pm_task_asgmt_reference VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
28: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: -- Planning resource list member id required for creation
31: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
33: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
27: ,pm_task_asgmt_reference VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
28: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: -- Planning resource list member id required for creation
31: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
33: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
34: ,planned_quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
35: ,planned_total_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: -- Planning resource list member id required for creation
31: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
33: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
34: ,planned_quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
35: ,planned_total_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
36: ,planned_total_bur_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: -- Planning resource list member id required for creation
31: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
33: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
34: ,planned_quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
35: ,planned_total_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
36: ,planned_total_bur_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: ,currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: -- Planning resource list member id required for creation
31: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
33: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
34: ,planned_quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
35: ,planned_total_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
36: ,planned_total_bur_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: ,currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38: --This attribute is added for Bug 3948128: TA Delay CR by DHI
31: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
33: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
34: ,planned_quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
35: ,planned_total_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
36: ,planned_total_bur_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: ,currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38: --This attribute is added for Bug 3948128: TA Delay CR by DHI
39: ,scheduled_delay NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
33: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
34: ,planned_quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
35: ,planned_total_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
36: ,planned_total_bur_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: ,currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38: --This attribute is added for Bug 3948128: TA Delay CR by DHI
39: ,scheduled_delay NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: --Following are flexfield parameters
33: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
34: ,planned_quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
35: ,planned_total_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
36: ,planned_total_bur_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: ,currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38: --This attribute is added for Bug 3948128: TA Delay CR by DHI
39: ,scheduled_delay NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: --Following are flexfield parameters
41: ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: ,planned_total_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
36: ,planned_total_bur_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: ,currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38: --This attribute is added for Bug 3948128: TA Delay CR by DHI
39: ,scheduled_delay NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: --Following are flexfield parameters
41: ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42: ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
37: ,currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38: --This attribute is added for Bug 3948128: TA Delay CR by DHI
39: ,scheduled_delay NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: --Following are flexfield parameters
41: ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42: ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44: ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38: --This attribute is added for Bug 3948128: TA Delay CR by DHI
39: ,scheduled_delay NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: --Following are flexfield parameters
41: ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42: ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44: ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46: ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: ,scheduled_delay NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: --Following are flexfield parameters
41: ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42: ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44: ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46: ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47: ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
40: --Following are flexfield parameters
41: ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42: ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44: ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46: ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47: ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42: ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44: ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46: ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47: ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42: ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44: ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46: ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47: ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44: ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46: ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47: ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44: ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46: ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47: ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52: ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46: ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47: ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52: ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53: ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46: ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47: ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52: ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53: ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54: ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47: ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52: ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53: ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54: ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52: ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53: ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54: ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52: ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53: ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54: ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52: ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53: ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54: ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58: ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52: ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53: ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54: ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58: ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52: ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53: ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54: ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58: ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60: ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53: ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54: ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58: ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60: ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61: ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54: ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58: ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60: ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61: ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62: ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58: ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60: ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61: ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62: ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63: ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58: ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60: ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61: ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62: ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63: ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64: ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58: ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60: ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61: ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62: ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63: ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64: ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65: ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58: ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60: ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61: ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62: ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63: ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64: ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65: ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60: ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61: ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62: ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63: ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64: ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65: ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60: ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61: ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62: ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63: ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64: ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65: ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,attribute27 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61: ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62: ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63: ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64: ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65: ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,attribute27 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,attribute28 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62: ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63: ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64: ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65: ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,attribute27 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,attribute28 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,attribute29 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63: ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64: ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65: ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,attribute27 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,attribute28 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,attribute29 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
71: ,attribute30 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64: ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65: ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,attribute27 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,attribute28 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,attribute29 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
71: ,attribute30 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: -- Following parameters used for update process only..........
65: ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,attribute27 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,attribute28 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,attribute29 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
71: ,attribute30 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: -- Following parameters used for update process only..........
73: --=============================================================
66: ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,attribute27 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,attribute28 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,attribute29 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
71: ,attribute30 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: -- Following parameters used for update process only..........
73: --=============================================================
74: ,description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,attribute27 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,attribute28 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,attribute29 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
71: ,attribute30 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: -- Following parameters used for update process only..........
73: --=============================================================
74: ,description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
75: ,use_task_schedule_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,attribute29 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
71: ,attribute30 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: -- Following parameters used for update process only..........
73: --=============================================================
74: ,description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
75: ,use_task_schedule_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: --Rate Overrides.
77: ,raw_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
78: ,burd_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71: ,attribute30 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: -- Following parameters used for update process only..........
73: --=============================================================
74: ,description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
75: ,use_task_schedule_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: --Rate Overrides.
77: ,raw_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
78: ,burd_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,billable_work_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73: --=============================================================
74: ,description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
75: ,use_task_schedule_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: --Rate Overrides.
77: ,raw_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
78: ,burd_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,billable_work_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
80: --Mfg cost type is converted to id if mfg cost type id is not provided
81: ,mfg_cost_type VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
75: ,use_task_schedule_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: --Rate Overrides.
77: ,raw_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
78: ,burd_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,billable_work_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
80: --Mfg cost type is converted to id if mfg cost type id is not provided
81: ,mfg_cost_type VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82: ,mfg_cost_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75: ,use_task_schedule_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: --Rate Overrides.
77: ,raw_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
78: ,burd_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,billable_work_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
80: --Mfg cost type is converted to id if mfg cost type id is not provided
81: ,mfg_cost_type VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82: ,mfg_cost_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
83: -- Above parameters for update only..........
77: ,raw_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
78: ,burd_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,billable_work_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
80: --Mfg cost type is converted to id if mfg cost type id is not provided
81: ,mfg_cost_type VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82: ,mfg_cost_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
83: -- Above parameters for update only..........
84: --===============================================================
85: --Pass in p_context of 'D' for explicit deletion
78: ,burd_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,billable_work_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
80: --Mfg cost type is converted to id if mfg cost type id is not provided
81: ,mfg_cost_type VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82: ,mfg_cost_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
83: -- Above parameters for update only..........
84: --===============================================================
85: --Pass in p_context of 'D' for explicit deletion
86: --Pass in p_context of 'F' for implicit deletion based on task assignments not passed on tasks.
83: -- Above parameters for update only..........
84: --===============================================================
85: --Pass in p_context of 'D' for explicit deletion
86: --Pass in p_context of 'F' for implicit deletion based on task assignments not passed on tasks.
87: ,p_context VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
88: );
89:
90:
91:
89:
90:
91:
92: TYPE assignment_out_rec_type IS RECORD
93: ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
94: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
95: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
96: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
97: ,return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
90:
91:
92: TYPE assignment_out_rec_type IS RECORD
93: ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
94: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
95: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
96: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
97: ,return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
98: );
91:
92: TYPE assignment_out_rec_type IS RECORD
93: ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
94: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
95: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
96: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
97: ,return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
98: );
99:
92: TYPE assignment_out_rec_type IS RECORD
93: ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
94: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
95: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
96: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
97: ,return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
98: );
99:
100:
93: ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
94: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
95: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
96: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
97: ,return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
98: );
99:
100:
101:
106: INDEX BY BINARY_INTEGER;
107:
108:
109: TYPE ta_del_rec_type IS RECORD
110: ( pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
111: pa_task_elem_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
112: del_ta_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
113: );
114:
107:
108:
109: TYPE ta_del_rec_type IS RECORD
110: ( pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
111: pa_task_elem_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
112: del_ta_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
113: );
114:
115: TYPE assignment_del_tbl_type IS TABLE OF ta_del_rec_type
108:
109: TYPE ta_del_rec_type IS RECORD
110: ( pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
111: pa_task_elem_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
112: del_ta_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
113: );
114:
115: TYPE assignment_del_tbl_type IS TABLE OF ta_del_rec_type
116: INDEX BY BINARY_INTEGER;
115: TYPE assignment_del_tbl_type IS TABLE OF ta_del_rec_type
116: INDEX BY BINARY_INTEGER;
117:
118: TYPE task_asgmt_del_type IS RECORD
119: ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
120: start_del_index NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
121: end_del_index NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
122: del_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
123: );
116: INDEX BY BINARY_INTEGER;
117:
118: TYPE task_asgmt_del_type IS RECORD
119: ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
120: start_del_index NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
121: end_del_index NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
122: del_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
123: );
124: TYPE task_asgmt_del_tbl_type IS TABLE OF task_asgmt_del_type
117:
118: TYPE task_asgmt_del_type IS RECORD
119: ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
120: start_del_index NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
121: end_del_index NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
122: del_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
123: );
124: TYPE task_asgmt_del_tbl_type IS TABLE OF task_asgmt_del_type
125: INDEX BY BINARY_INTEGER;
118: TYPE task_asgmt_del_type IS RECORD
119: ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
120: start_del_index NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
121: end_del_index NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
122: del_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
123: );
124: TYPE task_asgmt_del_tbl_type IS TABLE OF task_asgmt_del_type
125: INDEX BY BINARY_INTEGER;
126:
126:
127:
128: TYPE assignment_periods_type IS RECORD
129: ( -- All parameters are used after a task assignment is created for periodic data creation/updation.
130: pm_product_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --SAME
131: --Either project reference or id is required
132: ,pm_project_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
133: ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: --Structure version id is required currently
128: TYPE assignment_periods_type IS RECORD
129: ( -- All parameters are used after a task assignment is created for periodic data creation/updation.
130: pm_product_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --SAME
131: --Either project reference or id is required
132: ,pm_project_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
133: ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: --Structure version id is required currently
135: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136: --Task reference or id is required
129: ( -- All parameters are used after a task assignment is created for periodic data creation/updation.
130: pm_product_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --SAME
131: --Either project reference or id is required
132: ,pm_project_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
133: ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: --Structure version id is required currently
135: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136: --Task reference or id is required
137: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
131: --Either project reference or id is required
132: ,pm_project_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
133: ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: --Structure version id is required currently
135: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136: --Task reference or id is required
137: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
138: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
139: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
133: ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: --Structure version id is required currently
135: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136: --Task reference or id is required
137: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
138: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
139: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for updation.
141: ,pm_task_asgmt_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
134: --Structure version id is required currently
135: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136: --Task reference or id is required
137: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
138: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
139: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for updation.
141: ,pm_task_asgmt_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
142: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
135: ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136: --Task reference or id is required
137: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
138: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
139: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for updation.
141: ,pm_task_asgmt_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
142: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
143: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
137: ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
138: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
139: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for updation.
141: ,pm_task_asgmt_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
142: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
143: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
144: -- Planning resource list member id required for creation
145: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
138: ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
139: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for updation.
141: ,pm_task_asgmt_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
142: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
143: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
144: -- Planning resource list member id required for creation
145: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146: --Name of the period if available
139: ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140: -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for updation.
141: ,pm_task_asgmt_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
142: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
143: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
144: -- Planning resource list member id required for creation
145: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146: --Name of the period if available
147: ,period_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
141: ,pm_task_asgmt_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
142: ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
143: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
144: -- Planning resource list member id required for creation
145: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146: --Name of the period if available
147: ,period_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
148: --Start date of the period
149: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
143: ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
144: -- Planning resource list member id required for creation
145: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146: --Name of the period if available
147: ,period_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
148: --Start date of the period
149: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
150: --End date of the period
151: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
145: ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146: --Name of the period if available
147: ,period_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
148: --Start date of the period
149: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
150: --End date of the period
151: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
152: ,quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
153: ,txn_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
147: ,period_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
148: --Start date of the period
149: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
150: --End date of the period
151: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
152: ,quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
153: ,txn_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
154: ,txn_burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
155: ,txn_currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
148: --Start date of the period
149: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
150: --End date of the period
151: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
152: ,quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
153: ,txn_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
154: ,txn_burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
155: ,txn_currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
156:
149: ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
150: --End date of the period
151: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
152: ,quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
153: ,txn_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
154: ,txn_burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
155: ,txn_currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
156:
157: );
150: --End date of the period
151: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
152: ,quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
153: ,txn_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
154: ,txn_burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
155: ,txn_currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
156:
157: );
158:
151: ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
152: ,quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
153: ,txn_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
154: ,txn_burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
155: ,txn_currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
156:
157: );
158:
159:
254: */
255: -- All parameters mentioned as p_ are for both create and update
256: -- All parameters mentioned as up_ are meant for updation.
257: PROCEDURE Load_Task_Assignments
258: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
259: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
260: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
261: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
262: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
257: PROCEDURE Load_Task_Assignments
258: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
259: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
260: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
261: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
262: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
263: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
264: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
265: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
258: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
259: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
260: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
261: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
262: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
263: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
264: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
265: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
266: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
259: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
260: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
261: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
262: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
263: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
264: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
265: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
266: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
267: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
260: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
261: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
262: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
263: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
264: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
265: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
266: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
267: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
268: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
261: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
262: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
263: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
264: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
265: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
266: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
267: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
268: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
269: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
262: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
263: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
264: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
265: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
266: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
267: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
268: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
269: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
270: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
263: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
264: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
265: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
266: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
267: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
268: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
269: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
270: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
271: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
264: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
265: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
266: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
267: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
268: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
269: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
270: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
271: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
272: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
265: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
266: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
267: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
268: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
269: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
270: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
271: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
272: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
273: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
266: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
267: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
268: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
269: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
270: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
271: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
272: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
273: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
274: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
267: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
268: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
269: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
270: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
271: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
272: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
273: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
274: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
275: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
268: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
269: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
270: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
271: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
272: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
273: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
274: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
275: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
276: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
269: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
270: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
271: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
272: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
273: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
274: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
275: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
276: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
277: --This parameter is added for Bug 3948128: TA Delay CR by DHI
270: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
271: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
272: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
273: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
274: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
275: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
276: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
277: --This parameter is added for Bug 3948128: TA Delay CR by DHI
278: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
271: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
272: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
273: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
274: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
275: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
276: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
277: --This parameter is added for Bug 3948128: TA Delay CR by DHI
278: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
279: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
272: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
273: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
274: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
275: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
276: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
277: --This parameter is added for Bug 3948128: TA Delay CR by DHI
278: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
279: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
280: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
274: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
275: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
276: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
277: --This parameter is added for Bug 3948128: TA Delay CR by DHI
278: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
279: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
280: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
281: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
282: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
275: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
276: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
277: --This parameter is added for Bug 3948128: TA Delay CR by DHI
278: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
279: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
280: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
281: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
282: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
283: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
276: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
277: --This parameter is added for Bug 3948128: TA Delay CR by DHI
278: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
279: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
280: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
281: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
282: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
283: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
284: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
277: --This parameter is added for Bug 3948128: TA Delay CR by DHI
278: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
279: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
280: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
281: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
282: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
283: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
284: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
285: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
278: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
279: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
280: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
281: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
282: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
283: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
284: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
285: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
286: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
279: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
280: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
281: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
282: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
283: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
284: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
285: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
286: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
287: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
280: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
281: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
282: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
283: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
284: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
285: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
286: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
287: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
288: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
281: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
282: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
283: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
284: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
285: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
286: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
287: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
288: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
289: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
282: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
283: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
284: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
285: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
286: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
287: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
288: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
289: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
290: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
283: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
284: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
285: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
286: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
287: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
288: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
289: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
290: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
291: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
284: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
285: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
286: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
287: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
288: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
289: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
290: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
291: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
292: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
285: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
286: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
287: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
288: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
289: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
290: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
291: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
292: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
293: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
286: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
287: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
288: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
289: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
290: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
291: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
292: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
293: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
294: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
287: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
288: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
289: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
290: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
291: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
292: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
293: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
294: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
295: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
288: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
289: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
290: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
291: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
292: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
293: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
294: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
295: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
296: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
289: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
290: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
291: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
292: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
293: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
294: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
295: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
296: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
297: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
290: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
291: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
292: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
293: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
294: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
295: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
296: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
297: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
298: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
291: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
292: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
293: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
294: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
295: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
296: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
297: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
298: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
299: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
292: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
293: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
294: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
295: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
296: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
297: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
298: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
299: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
293: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
294: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
295: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
296: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
297: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
298: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
299: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
301: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
294: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
295: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
296: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
297: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
298: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
299: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
301: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
302: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
295: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
296: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
297: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
298: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
299: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
301: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
302: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
303: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
296: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
297: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
298: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
299: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
301: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
302: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
303: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
304: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
297: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
298: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
299: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
301: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
302: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
303: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
304: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
305: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
298: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
299: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
301: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
302: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
303: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
304: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
305: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
306: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
299: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
301: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
302: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
303: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
304: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
305: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
306: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
307: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
301: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
302: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
303: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
304: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
305: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
306: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
307: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
308: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
301: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
302: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
303: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
304: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
305: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
306: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
307: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
308: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
309: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
302: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
303: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
304: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
305: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
306: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
307: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
308: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
309: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
303: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
304: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
305: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
306: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
307: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
308: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
309: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
311: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
304: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
305: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
306: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
307: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
308: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
309: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
311: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
312: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
305: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
306: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
307: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
308: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
309: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
311: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
312: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
313: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
306: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
307: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
308: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
309: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
311: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
312: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
313: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
314: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
307: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
308: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
309: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
311: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
312: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
313: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
314: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
315: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
308: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
309: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
311: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
312: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
313: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
314: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
315: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
316: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
309: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
311: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
312: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
313: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
314: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
315: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
316: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
317: ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
311: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
312: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
313: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
314: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
315: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
316: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
317: ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
318: ,x_msg_count OUT NOCOPY NUMBER
311: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
312: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
313: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
314: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
315: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
316: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
317: ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
318: ,x_msg_count OUT NOCOPY NUMBER
319: ,x_msg_data OUT NOCOPY VARCHAR2
312: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
313: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
314: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
315: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
316: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
317: ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
318: ,x_msg_count OUT NOCOPY NUMBER
319: ,x_msg_data OUT NOCOPY VARCHAR2
320: ,x_return_status OUT NOCOPY VARCHAR2
313: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
314: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
315: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
316: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
317: ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
318: ,x_msg_count OUT NOCOPY NUMBER
319: ,x_msg_data OUT NOCOPY VARCHAR2
320: ,x_return_status OUT NOCOPY VARCHAR2
321: ) ;
353: * @rep:displayname Load Periodic Data of Project Task Resources
354: * @rep:compatibility S
355: */
356: PROCEDURE Load_Task_Asgmt_Periods
357: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
358: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
360: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
361: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
356: PROCEDURE Load_Task_Asgmt_Periods
357: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
358: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
360: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
361: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
362: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
363: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
364: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
357: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
358: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
360: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
361: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
362: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
363: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
364: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
365: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
358: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
360: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
361: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
362: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
363: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
364: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
365: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
366: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
360: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
361: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
362: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
363: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
364: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
365: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
366: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
367: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
360: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
361: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
362: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
363: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
364: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
365: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
366: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
367: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
368: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
361: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
362: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
363: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
364: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
365: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
366: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
367: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
368: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
369: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
362: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
363: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
364: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
365: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
366: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
367: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
368: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
369: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
370: --Name of the period if available
363: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
364: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
365: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
366: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
367: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
368: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
369: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
370: --Name of the period if available
371: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
364: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
365: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
366: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
367: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
368: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
369: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
370: --Name of the period if available
371: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
372: --Start date of the period
365: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
366: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
367: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
368: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
369: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
370: --Name of the period if available
371: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
372: --Start date of the period
373: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
367: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
368: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
369: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
370: --Name of the period if available
371: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
372: --Start date of the period
373: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
374: --End date of the period
375: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
369: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
370: --Name of the period if available
371: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
372: --Start date of the period
373: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
374: --End date of the period
375: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
376: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
377: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
371: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
372: --Start date of the period
373: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
374: --End date of the period
375: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
376: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
377: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
378: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
379: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
372: --Start date of the period
373: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
374: --End date of the period
375: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
376: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
377: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
378: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
379: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
380: ,x_msg_count OUT NOCOPY NUMBER
373: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
374: --End date of the period
375: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
376: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
377: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
378: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
379: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
380: ,x_msg_count OUT NOCOPY NUMBER
381: ,x_msg_data OUT NOCOPY VARCHAR2
374: --End date of the period
375: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
376: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
377: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
378: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
379: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
380: ,x_msg_count OUT NOCOPY NUMBER
381: ,x_msg_data OUT NOCOPY VARCHAR2
382: ,x_return_status OUT NOCOPY VARCHAR2
375: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
376: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
377: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
378: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
379: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
380: ,x_msg_count OUT NOCOPY NUMBER
381: ,x_msg_data OUT NOCOPY VARCHAR2
382: ,x_return_status OUT NOCOPY VARCHAR2
383: );
403: * @rep:displayname Execute Create Project Task Resources
404: * @rep:compatibility S
405: */
406: PROCEDURE Execute_Create_Task_Asgmts
407: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
408: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
409: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
410: -- Product Code is a required parameter
411: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
407: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
408: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
409: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
410: -- Product Code is a required parameter
411: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: --Either project reference or project id is required
413: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: --Structure version id is required
409: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
410: -- Product Code is a required parameter
411: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: --Either project reference or project id is required
413: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: --Structure version id is required
416: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
417: ,x_msg_count OUT NOCOPY NUMBER
410: -- Product Code is a required parameter
411: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: --Either project reference or project id is required
413: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: --Structure version id is required
416: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
417: ,x_msg_count OUT NOCOPY NUMBER
418: ,x_msg_data OUT NOCOPY VARCHAR2
412: --Either project reference or project id is required
413: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: --Structure version id is required
416: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
417: ,x_msg_count OUT NOCOPY NUMBER
418: ,x_msg_data OUT NOCOPY VARCHAR2
419: ,x_return_status OUT NOCOPY VARCHAR2
420: );
440: * @rep:displayname Execute Update Project Task Resources
441: * @rep:compatibility S
442: */
443: PROCEDURE Execute_Update_Task_Asgmts
444: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
446: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
447: -- Product Code is a required parameter
448: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
446: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
447: -- Product Code is a required parameter
448: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: --Either project reference or project id is required
450: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
452: --Structure version id is required
446: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
447: -- Product Code is a required parameter
448: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: --Either project reference or project id is required
450: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
452: --Structure version id is required
453: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,x_msg_count OUT NOCOPY NUMBER
447: -- Product Code is a required parameter
448: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449: --Either project reference or project id is required
450: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
452: --Structure version id is required
453: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,x_msg_count OUT NOCOPY NUMBER
455: ,x_msg_data OUT NOCOPY VARCHAR2
449: --Either project reference or project id is required
450: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
451: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
452: --Structure version id is required
453: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454: ,x_msg_count OUT NOCOPY NUMBER
455: ,x_msg_data OUT NOCOPY VARCHAR2
456: ,x_return_status OUT NOCOPY VARCHAR2
457: );
482: * @rep:displayname Create Project Task Resources
483: * @rep:compatibility S
484: */
485: PROCEDURE Create_Task_Assignments
486: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
487: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
488: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
489: -- Product Code is a required parameter
490: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
486: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
487: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
488: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
489: -- Product Code is a required parameter
490: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
491: --Either project reference or project id is required
492: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
493: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
494: --Structure version id is required
488: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
489: -- Product Code is a required parameter
490: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
491: --Either project reference or project id is required
492: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
493: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
494: --Structure version id is required
495: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
496: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
489: -- Product Code is a required parameter
490: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
491: --Either project reference or project id is required
492: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
493: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
494: --Structure version id is required
495: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
496: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
497: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
491: --Either project reference or project id is required
492: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
493: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
494: --Structure version id is required
495: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
496: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
497: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
498: ,x_msg_count OUT NOCOPY NUMBER
499: ,x_msg_data OUT NOCOPY VARCHAR2
531: * @rep:displayname Create Project Task Resource and Periodic Data
532: * @rep:compatibility S
533: */
534: PROCEDURE Create_Task_Assignment_Periods
535: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
536: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
537: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
538: -- Product Code is a required parameter
539: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
535: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
536: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
537: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
538: -- Product Code is a required parameter
539: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
540: --Either project reference or project id is required
541: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
542: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
543: --Structure version id is required
537: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
538: -- Product Code is a required parameter
539: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
540: --Either project reference or project id is required
541: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
542: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
543: --Structure version id is required
544: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
545: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
538: -- Product Code is a required parameter
539: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
540: --Either project reference or project id is required
541: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
542: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
543: --Structure version id is required
544: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
545: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
546: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
540: --Either project reference or project id is required
541: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
542: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
543: --Structure version id is required
544: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
545: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
546: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
547: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
548: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
576: * @rep:displayname Update Project Task Resources
577: * @rep:compatibility S
578: */
579: PROCEDURE Update_Task_Assignments
580: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
581: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
582: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
583: -- Product Code is a required parameter
584: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
580: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
581: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
582: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
583: -- Product Code is a required parameter
584: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
585: --Either project reference or project id is required
586: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
587: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
588: --Structure version id is required
582: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
583: -- Product Code is a required parameter
584: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
585: --Either project reference or project id is required
586: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
587: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
588: --Structure version id is required
589: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
590: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
583: -- Product Code is a required parameter
584: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
585: --Either project reference or project id is required
586: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
587: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
588: --Structure version id is required
589: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
590: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
591: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
585: --Either project reference or project id is required
586: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
587: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
588: --Structure version id is required
589: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
590: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
591: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
592: ,x_msg_count OUT NOCOPY NUMBER
593: ,x_msg_data OUT NOCOPY VARCHAR2
615: * @rep:displayname Delete Project Task Resources
616: * @rep:compatibility S
617: */
618: PROCEDURE Delete_Task_Assignments
619: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
620: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
621: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
622: --Either project reference or project id is required
623: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
619: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
620: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
621: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
622: --Either project reference or project id is required
623: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
624: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
625: --Structure version id is required
626: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
627: --Pass in list of task assignment id's or references as information at a minimum
620: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
621: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
622: --Either project reference or project id is required
623: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
624: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
625: --Structure version id is required
626: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
627: --Pass in list of task assignment id's or references as information at a minimum
628: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
622: --Either project reference or project id is required
623: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
624: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
625: --Structure version id is required
626: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
627: --Pass in list of task assignment id's or references as information at a minimum
628: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
629: ,x_msg_count OUT NOCOPY NUMBER
630: ,x_msg_data OUT NOCOPY VARCHAR2
661: * @rep:displayname Update Project Task Resource and Periodic Data
662: * @rep:compatibility S
663: */
664: PROCEDURE Update_Task_Assignment_Periods
665: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
666: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
667: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
668: -- Product Code is a required parameter
669: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
665: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
666: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
667: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
668: -- Product Code is a required parameter
669: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
670: --Either project reference or project id is required
671: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
672: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
673: --Structure version id is required
667: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
668: -- Product Code is a required parameter
669: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
670: --Either project reference or project id is required
671: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
672: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
673: --Structure version id is required
674: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
675: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
668: -- Product Code is a required parameter
669: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
670: --Either project reference or project id is required
671: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
672: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
673: --Structure version id is required
674: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
675: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
676: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
670: --Either project reference or project id is required
671: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
672: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
673: --Structure version id is required
674: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
675: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
676: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
677: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
678: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
705: * @rep:displayname Fetch Project Task Resources
706: * @rep:compatibility S
707: */
708: PROCEDURE Fetch_Task_Assignments
709: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
710: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
711: ,p_task_asgmt_index IN pa_num_1000_num := pa_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
712: ,p_pm_task_asgmt_reference OUT NOCOPY pa_vc_1000_30
713: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num
707: */
708: PROCEDURE Fetch_Task_Assignments
709: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
710: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
711: ,p_task_asgmt_index IN pa_num_1000_num := pa_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
712: ,p_pm_task_asgmt_reference OUT NOCOPY pa_vc_1000_30
713: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num
714: ,p_pm_task_reference OUT NOCOPY pa_vc_1000_30
715: ,p_pa_task_id OUT NOCOPY pa_num_1000_num
751: ,p_pa_project_id IN NUMBER
752: ,p_pa_structure_version_id IN NUMBER
753: ,p_pa_task_id IN NUMBER
754: ,p_pa_task_elem_ver_id IN NUMBER
755: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
756: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
757: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
758: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
759: -- Bug 3937017 Added a new parameter p_add_error_msg_flag
752: ,p_pa_structure_version_id IN NUMBER
753: ,p_pa_task_id IN NUMBER
754: ,p_pa_task_elem_ver_id IN NUMBER
755: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
756: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
757: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
758: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
759: -- Bug 3937017 Added a new parameter p_add_error_msg_flag
760: ,p_add_error_msg_flag IN VARCHAR2 DEFAULT 'Y'
753: ,p_pa_task_id IN NUMBER
754: ,p_pa_task_elem_ver_id IN NUMBER
755: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
756: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
757: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
758: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
759: -- Bug 3937017 Added a new parameter p_add_error_msg_flag
760: ,p_add_error_msg_flag IN VARCHAR2 DEFAULT 'Y'
761: -- Bug 3872176 Added a new parameter p_published_version_flag
754: ,p_pa_task_elem_ver_id IN NUMBER
755: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
756: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
757: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
758: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
759: -- Bug 3937017 Added a new parameter p_add_error_msg_flag
760: ,p_add_error_msg_flag IN VARCHAR2 DEFAULT 'Y'
761: -- Bug 3872176 Added a new parameter p_published_version_flag
762: ,p_published_version_flag IN VARCHAR2 DEFAULT 'N'