9: -- Default number of records fetch per call
10: G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
11: TYPE PROD_TASK_Rec_Type IS RECORD
12: (
13: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
14: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
15: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
16: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
17: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
10: G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
11: TYPE PROD_TASK_Rec_Type IS RECORD
12: (
13: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
14: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
15: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
16: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
17: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
18: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
11: TYPE PROD_TASK_Rec_Type IS RECORD
12: (
13: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
14: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
15: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
16: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
17: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
18: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: (
13: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
14: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
15: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
16: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
17: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
18: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRUBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
14: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
15: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
16: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
17: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
18: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRUBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRUBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
15: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
16: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
17: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
18: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRUBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRUBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRUBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
16: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
17: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
18: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRUBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRUBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRUBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRUBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
17: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
18: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRUBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRUBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRUBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRUBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRUBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
18: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRUBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRUBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRUBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRUBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRUBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRUBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRUBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRUBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRUBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRUBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRUBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRUBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRUBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRUBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRUBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRUBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRUBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRUBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRUBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRUBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRUBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRUBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRUBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRUBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRUBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRUBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRUBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRUBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRUBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRUBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRUBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRUBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRUBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRUBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRUBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRUBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRUBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRUBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRUBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRUBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRUBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRUBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRUBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRUBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRUBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRUBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRUBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRUBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRUBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRUBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRUBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRUBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRUBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRUBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRUBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRUBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRUBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRUBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRUBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRUBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRUBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRUBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRUBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRUBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRUBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRUBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRUBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRUBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRUBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRUBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRUBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRUBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRUBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRUBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRUBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRUBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRUBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRUBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRUBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRUBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRUBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRUBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRUBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRUBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRUBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRUBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRUBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRUBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRUBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRUBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRUBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRUBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
28: ATTRUBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRUBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRUBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRUBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRUBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRUBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRUBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
36: CREATION_DATE DATE := FND_API.G_MISS_DATE,
29: ATTRUBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRUBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRUBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRUBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRUBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRUBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
36: CREATION_DATE DATE := FND_API.G_MISS_DATE,
37: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
30: ATTRUBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRUBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRUBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRUBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRUBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
36: CREATION_DATE DATE := FND_API.G_MISS_DATE,
37: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
38: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
31: ATTRUBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRUBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRUBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRUBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
36: CREATION_DATE DATE := FND_API.G_MISS_DATE,
37: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
38: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
39: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
32: ATTRUBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRUBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRUBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
36: CREATION_DATE DATE := FND_API.G_MISS_DATE,
37: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
38: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
39: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
40: );
33: ATTRUBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRUBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
36: CREATION_DATE DATE := FND_API.G_MISS_DATE,
37: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
38: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
39: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
40: );
41: G_MISS_PROD_TASK_REC PROD_TASK_Rec_Type;
34: ATTRUBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
36: CREATION_DATE DATE := FND_API.G_MISS_DATE,
37: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
38: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
39: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
40: );
41: G_MISS_PROD_TASK_REC PROD_TASK_Rec_Type;
42: TYPE PROD_TASK_Tbl_Type IS TABLE OF PROD_TASK_Rec_Type
35: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
36: CREATION_DATE DATE := FND_API.G_MISS_DATE,
37: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
38: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
39: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
40: );
41: G_MISS_PROD_TASK_REC PROD_TASK_Rec_Type;
42: TYPE PROD_TASK_Tbl_Type IS TABLE OF PROD_TASK_Rec_Type
43: INDEX BY BINARY_INTEGER;
46: PRODUCT_ID NUMBER := NULL
47: );
48: TYPE TASK_PART_Rec_Type IS RECORD
49: (
50: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
51: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
52: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
53: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
47: );
48: TYPE TASK_PART_Rec_Type IS RECORD
49: (
50: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
51: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
52: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
53: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
55: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
48: TYPE TASK_PART_Rec_Type IS RECORD
49: (
50: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
51: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
52: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
53: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
55: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
56: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
49: (
50: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
51: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
52: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
53: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
55: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
56: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
57: CALCULATED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
50: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
51: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
52: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
53: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
55: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
56: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
57: CALCULATED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
58: PART_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
51: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
52: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
53: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
55: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
56: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
57: CALCULATED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
58: PART_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
52: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
53: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
55: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
56: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
57: CALCULATED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
58: PART_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
53: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
55: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
56: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
57: CALCULATED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
58: PART_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
54: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
55: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
56: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
57: CALCULATED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
58: PART_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
56: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
57: CALCULATED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
58: PART_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
56: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
57: CALCULATED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
58: PART_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: CALCULATED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
58: PART_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: PART_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: START_DATE DATE := FND_API.G_MISS_DATE,
75: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: START_DATE DATE := FND_API.G_MISS_DATE,
83: END_DATE DATE := FND_API.G_MISS_DATE,
76: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: START_DATE DATE := FND_API.G_MISS_DATE,
83: END_DATE DATE := FND_API.G_MISS_DATE,
84: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
77: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: START_DATE DATE := FND_API.G_MISS_DATE,
83: END_DATE DATE := FND_API.G_MISS_DATE,
84: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
85: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: START_DATE DATE := FND_API.G_MISS_DATE,
83: END_DATE DATE := FND_API.G_MISS_DATE,
84: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
85: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
86: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
79: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: START_DATE DATE := FND_API.G_MISS_DATE,
83: END_DATE DATE := FND_API.G_MISS_DATE,
84: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
85: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
86: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
87: );
80: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: START_DATE DATE := FND_API.G_MISS_DATE,
83: END_DATE DATE := FND_API.G_MISS_DATE,
84: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
85: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
86: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
87: );
88:
81: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: START_DATE DATE := FND_API.G_MISS_DATE,
83: END_DATE DATE := FND_API.G_MISS_DATE,
84: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
85: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
86: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
87: );
88:
89: G_MISS_TASK_PART_REC TASK_PART_Rec_Type;
82: START_DATE DATE := FND_API.G_MISS_DATE,
83: END_DATE DATE := FND_API.G_MISS_DATE,
84: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
85: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
86: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
87: );
88:
89: G_MISS_TASK_PART_REC TASK_PART_Rec_Type;
90: TYPE TASK_PART_Tbl_Type IS TABLE OF TASK_PART_Rec_Type