56: --
57: -- End of Comments
58: TYPE TASK_PART_Rec_Type IS RECORD
59: (
60: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
61: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
62: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
63: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
64: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
57: -- End of Comments
58: TYPE TASK_PART_Rec_Type IS RECORD
59: (
60: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
61: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
62: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
63: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
64: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
65: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
58: TYPE TASK_PART_Rec_Type IS RECORD
59: (
60: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
61: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
62: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
63: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
64: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
65: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
66: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
59: (
60: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
61: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
62: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
63: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
64: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
65: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
66: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
67: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
61: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
62: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
63: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
64: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
65: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
66: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
67: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
62: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
63: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
64: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
65: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
66: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
67: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68: CREATION_DATE DATE := FND_API.G_MISS_DATE,
69: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
63: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
64: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
65: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
66: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
67: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68: CREATION_DATE DATE := FND_API.G_MISS_DATE,
69: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
64: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
65: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
66: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
67: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68: CREATION_DATE DATE := FND_API.G_MISS_DATE,
69: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
65: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
66: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
67: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68: CREATION_DATE DATE := FND_API.G_MISS_DATE,
69: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
66: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
67: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68: CREATION_DATE DATE := FND_API.G_MISS_DATE,
69: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
67: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68: CREATION_DATE DATE := FND_API.G_MISS_DATE,
69: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68: CREATION_DATE DATE := FND_API.G_MISS_DATE,
69: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: CREATION_DATE DATE := FND_API.G_MISS_DATE,
69: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
89: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
89: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: START_DATE DATE := FND_API.G_MISS_DATE,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
89: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: START_DATE DATE := FND_API.G_MISS_DATE,
91: END_DATE DATE := FND_API.G_MISS_DATE,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
89: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: START_DATE DATE := FND_API.G_MISS_DATE,
91: END_DATE DATE := FND_API.G_MISS_DATE,
92: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
89: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: START_DATE DATE := FND_API.G_MISS_DATE,
91: END_DATE DATE := FND_API.G_MISS_DATE,
92: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
93: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
89: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: START_DATE DATE := FND_API.G_MISS_DATE,
91: END_DATE DATE := FND_API.G_MISS_DATE,
92: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
93: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
94: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
89: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: START_DATE DATE := FND_API.G_MISS_DATE,
91: END_DATE DATE := FND_API.G_MISS_DATE,
92: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
93: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
94: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
95: );
88: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
89: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: START_DATE DATE := FND_API.G_MISS_DATE,
91: END_DATE DATE := FND_API.G_MISS_DATE,
92: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
93: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
94: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
95: );
96: G_MISS_TASK_PART_REC TASK_PART_Rec_Type;
89: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: START_DATE DATE := FND_API.G_MISS_DATE,
91: END_DATE DATE := FND_API.G_MISS_DATE,
92: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
93: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
94: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
95: );
96: G_MISS_TASK_PART_REC TASK_PART_Rec_Type;
97: TYPE TASK_PART_Tbl_Type IS TABLE OF TASK_PART_Rec_Type
90: START_DATE DATE := FND_API.G_MISS_DATE,
91: END_DATE DATE := FND_API.G_MISS_DATE,
92: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
93: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
94: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
95: );
96: G_MISS_TASK_PART_REC TASK_PART_Rec_Type;
97: TYPE TASK_PART_Tbl_Type IS TABLE OF TASK_PART_Rec_Type
98: INDEX BY BINARY_INTEGER;
105: -- Pre-Req :
106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_admin_group_id IN NUMBER Required
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_admin_group_id IN NUMBER Required
115: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_admin_group_id IN NUMBER Required
115: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
116: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_admin_group_id IN NUMBER Required
115: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
116: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
117: --
126: -- End of Comments
127: --
128: PROCEDURE Create_task_part(
129: P_Api_Version_Number IN NUMBER,
130: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
131: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
134: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
127: --
128: PROCEDURE Create_task_part(
129: P_Api_Version_Number IN NUMBER,
130: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
131: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
134: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
135: X_TASK_PART_ID OUT NOCOPY NUMBER,
128: PROCEDURE Create_task_part(
129: P_Api_Version_Number IN NUMBER,
130: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
131: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
134: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
135: X_TASK_PART_ID OUT NOCOPY NUMBER,
136: X_Return_Status OUT NOCOPY VARCHAR2,
145: -- Pre-Req :
146: -- Parameters:
147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- Parameters:
147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_admin_group_id IN NUMBER Required
147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_admin_group_id IN NUMBER Required
155: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_admin_group_id IN NUMBER Required
155: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
156: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_admin_group_id IN NUMBER Required
155: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
156: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
157: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
168: --
169: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
170: PROCEDURE Update_task_part(
171: P_Api_Version_Number IN NUMBER,
172: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
176: X_Return_Status OUT NOCOPY VARCHAR2,
169: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
170: PROCEDURE Update_task_part(
171: P_Api_Version_Number IN NUMBER,
172: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
176: X_Return_Status OUT NOCOPY VARCHAR2,
177: X_Msg_Count OUT NOCOPY NUMBER,
170: PROCEDURE Update_task_part(
171: P_Api_Version_Number IN NUMBER,
172: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
176: X_Return_Status OUT NOCOPY VARCHAR2,
177: X_Msg_Count OUT NOCOPY NUMBER,
178: X_Msg_Data OUT NOCOPY VARCHAR2
185: -- Pre-Req :
186: -- Parameters:
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- Parameters:
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
194: -- p_admin_group_id IN NUMBER Required
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
194: -- p_admin_group_id IN NUMBER Required
195: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
194: -- p_admin_group_id IN NUMBER Required
195: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
196: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
194: -- p_admin_group_id IN NUMBER Required
195: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
196: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
197: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
209: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
210: -- The Master delete procedure may not be needed depends on different business requirements.
211: PROCEDURE Delete_task_part(
212: P_Api_Version_Number IN NUMBER,
213: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
214: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
217: X_Return_Status OUT NOCOPY VARCHAR2,
210: -- The Master delete procedure may not be needed depends on different business requirements.
211: PROCEDURE Delete_task_part(
212: P_Api_Version_Number IN NUMBER,
213: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
214: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
217: X_Return_Status OUT NOCOPY VARCHAR2,
218: X_Msg_Count OUT NOCOPY NUMBER,
211: PROCEDURE Delete_task_part(
212: P_Api_Version_Number IN NUMBER,
213: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
214: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
217: X_Return_Status OUT NOCOPY VARCHAR2,
218: X_Msg_Count OUT NOCOPY NUMBER,
219: X_Msg_Data OUT NOCOPY VARCHAR2
228: -- The actual validation detail is needed to be added.
229: --
230: -- End of Comments
231: PROCEDURE Validate_TASK_PART_ID (
232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233: P_Validation_mode IN VARCHAR2,
234: P_TASK_PART_ID IN NUMBER,
235: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
236: X_Return_Status OUT NOCOPY VARCHAR2,
247: -- The actual validation detail is needed to be added.
248: --
249: -- End of Comments
250: PROCEDURE Validate_PRODUCT_TASK_ID (
251: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
252: P_Validation_mode IN VARCHAR2,
253: P_PRODUCT_TASK_ID IN NUMBER,
254: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
255: X_Return_Status OUT NOCOPY VARCHAR2,
266: -- The actual validation detail is needed to be added.
267: --
268: -- End of Comments
269: PROCEDURE Validate_INVENTORY_ITEM_ID (
270: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
271: P_Validation_mode IN VARCHAR2,
272: P_INVENTORY_ITEM_ID IN NUMBER,
273: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
274: X_Return_Status OUT NOCOPY VARCHAR2,
285: -- The actual validation detail is needed to be added.
286: --
287: -- End of Comments
288: PROCEDURE Validate_MANUAL_QUANTITY (
289: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
290: P_Validation_mode IN VARCHAR2,
291: P_MANUAL_QUANTITY IN NUMBER,
292: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
293: X_Return_Status OUT NOCOPY VARCHAR2,
304: -- The actual validation detail is needed to be added.
305: --
306: -- End of Comments
307: PROCEDURE Validate_MANUAL_PERCENTAGE (
308: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
309: P_Validation_mode IN VARCHAR2,
310: P_MANUAL_PERCENTAGE IN NUMBER,
311: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
312: X_Return_Status OUT NOCOPY VARCHAR2,
323: -- The actual validation detail is needed to be added.
324: --
325: -- End of Comments
326: PROCEDURE Validate_QUANTITY_USED (
327: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
328: P_Validation_mode IN VARCHAR2,
329: P_QUANTITY_USED IN NUMBER,
330: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
331: X_Return_Status OUT NOCOPY VARCHAR2,
342: -- The actual validation detail is needed to be added.
343: --
344: -- End of Comments
345: PROCEDURE Validate_ACTUAL_TIMES_USED (
346: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
347: P_Validation_mode IN VARCHAR2,
348: P_ACTUAL_TIMES_USED IN NUMBER,
349: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
350: X_Return_Status OUT NOCOPY VARCHAR2,
362: --
363: -- End of Comments
364:
365: PROCEDURE Validate_PRIMARY_UOM_CODE (
366: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
367: P_Validation_mode IN VARCHAR2,
368: P_PRIMARY_UOM_CODE IN VARCHAR2,
369: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
370: X_Return_Status OUT NOCOPY VARCHAR2,
381: -- The actual validation detail is needed to be added.
382: --
383: -- End of Comments
384: PROCEDURE Validate_REVISION (
385: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
386: P_Validation_mode IN VARCHAR2,
387: P_REVISION IN VARCHAR2,
388: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
389: X_Return_Status OUT NOCOPY VARCHAR2,
400: -- The actual validation detail is needed to be added.
401: --
402: -- End of Comments
403: PROCEDURE Validate_START_DATE (
404: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
405: P_Validation_mode IN VARCHAR2,
406: P_START_DATE IN DATE,
407: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
408: X_Return_Status OUT NOCOPY VARCHAR2,
419: -- The actual validation detail is needed to be added.
420: --
421: -- End of Comments
422: PROCEDURE Validate_END_DATE (
423: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
424: P_Validation_mode IN VARCHAR2,
425: P_END_DATE IN DATE,
426: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
427: X_Return_Status OUT NOCOPY VARCHAR2,
429: X_Msg_Data OUT NOCOPY VARCHAR2
430: );
431:
432: PROCEDURE Validate_ROLLUP_QUANTITY_USED (
433: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
434: P_Validation_mode IN VARCHAR2,
435: P_ROLLUP_QUANTITY_USED IN NUMBER,
436: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
437: X_Return_Status OUT NOCOPY VARCHAR2,
439: X_Msg_Data OUT NOCOPY VARCHAR2
440: );
441:
442: PROCEDURE Validate_ROLLUP_TIMES_USED (
443: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
444: P_Validation_mode IN VARCHAR2,
445: P_ROLLUP_TIMES_USED IN NUMBER,
446: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
447: X_Return_Status OUT NOCOPY VARCHAR2,
449: X_Msg_Data OUT NOCOPY VARCHAR2
450: );
451:
452: PROCEDURE Validate_SUBSTITUTE_ITEM (
453: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
454: P_Validation_mode IN VARCHAR2,
455: P_SUBSTITUTE_ITEM IN NUMBER,
456: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
457: X_Return_Status OUT NOCOPY VARCHAR2,
469: -- The actual validation detail is needed to be added.
470: -- 2. Developer can manually added inter-field level validation.
471: -- End of Comments
472: PROCEDURE Validate_TASK_PART_rec(
473: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
474: P_Validation_mode IN VARCHAR2,
475: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
476: X_Return_Status OUT NOCOPY VARCHAR2,
477: X_Msg_Count OUT NOCOPY NUMBER,
487: -- The actual validation detail is needed to be added.
488: -- 2. We can also validate table instead of record. There will be an option for user to choose.
489: -- End of Comments
490: PROCEDURE Validate_task_part(
491: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
492: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
493: P_Validation_mode IN VARCHAR2,
494: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
495: X_Return_Status OUT NOCOPY VARCHAR2,
488: -- 2. We can also validate table instead of record. There will be an option for user to choose.
489: -- End of Comments
490: PROCEDURE Validate_task_part(
491: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
492: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
493: P_Validation_mode IN VARCHAR2,
494: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
495: X_Return_Status OUT NOCOPY VARCHAR2,
496: X_Msg_Count OUT NOCOPY NUMBER,