49: --
50: -- End of Comments
51: TYPE PROD_TASK_Rec_Type IS RECORD
52: (
53: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
54: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
55: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
56: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
57: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
50: -- End of Comments
51: TYPE PROD_TASK_Rec_Type IS RECORD
52: (
53: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
54: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
55: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
56: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
57: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
58: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
51: TYPE PROD_TASK_Rec_Type IS RECORD
52: (
53: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
54: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
55: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
56: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
57: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
58: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: (
53: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
54: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
55: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
56: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
57: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
58: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
54: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
55: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
56: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
57: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
58: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
55: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
56: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
57: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
58: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
56: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
57: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
58: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
57: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
58: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
58: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76: CREATION_DATE DATE := FND_API.G_MISS_DATE,
69: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76: CREATION_DATE DATE := FND_API.G_MISS_DATE,
77: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76: CREATION_DATE DATE := FND_API.G_MISS_DATE,
77: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76: CREATION_DATE DATE := FND_API.G_MISS_DATE,
77: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
72: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76: CREATION_DATE DATE := FND_API.G_MISS_DATE,
77: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
80: );
73: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76: CREATION_DATE DATE := FND_API.G_MISS_DATE,
77: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
80: );
81: G_MISS_PROD_TASK_REC PROD_TASK_Rec_Type;
74: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76: CREATION_DATE DATE := FND_API.G_MISS_DATE,
77: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
80: );
81: G_MISS_PROD_TASK_REC PROD_TASK_Rec_Type;
82: TYPE PROD_TASK_Tbl_Type IS TABLE OF PROD_TASK_Rec_Type
75: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76: CREATION_DATE DATE := FND_API.G_MISS_DATE,
77: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
80: );
81: G_MISS_PROD_TASK_REC PROD_TASK_Rec_Type;
82: TYPE PROD_TASK_Tbl_Type IS TABLE OF PROD_TASK_Rec_Type
83: INDEX BY BINARY_INTEGER;
90: -- Pre-Req :
91: -- Parameters:
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- Parameters:
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_admin_group_id IN NUMBER Required
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_admin_group_id IN NUMBER Required
100: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_admin_group_id IN NUMBER Required
100: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
101: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_admin_group_id IN NUMBER Required
100: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
101: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
102: --
111: -- End of Comments
112: --
113: PROCEDURE Create_product_task(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type := G_MISS_PROD_TASK_REC,
119: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
112: --
113: PROCEDURE Create_product_task(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type := G_MISS_PROD_TASK_REC,
119: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
120: X_PRODUCT_TASK_ID OUT NOCOPY NUMBER,
113: PROCEDURE Create_product_task(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type := G_MISS_PROD_TASK_REC,
119: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
120: X_PRODUCT_TASK_ID OUT NOCOPY NUMBER,
121: X_Return_Status OUT NOCOPY VARCHAR2,
130: -- Pre-Req :
131: -- Parameters:
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- Parameters:
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_group_id IN NUMBER Required
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_group_id IN NUMBER Required
140: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_group_id IN NUMBER Required
140: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
141: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_group_id IN NUMBER Required
140: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
141: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
142: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
153: --
154: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
155: PROCEDURE Update_product_task(
156: P_Api_Version_Number IN NUMBER,
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
161: X_Return_Status OUT NOCOPY VARCHAR2,
154: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
155: PROCEDURE Update_product_task(
156: P_Api_Version_Number IN NUMBER,
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162: X_Msg_Count OUT NOCOPY NUMBER,
155: PROCEDURE Update_product_task(
156: P_Api_Version_Number IN NUMBER,
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162: X_Msg_Count OUT NOCOPY NUMBER,
163: X_Msg_Data OUT NOCOPY VARCHAR2
170: -- Pre-Req :
171: -- Parameters:
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
171: -- Parameters:
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_admin_group_id IN NUMBER Required
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_admin_group_id IN NUMBER Required
180: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_admin_group_id IN NUMBER Required
180: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
181: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_admin_group_id IN NUMBER Required
180: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
181: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
182: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
194: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
195: -- The Master delete procedure may not be needed depends on different business requirements.
196: PROCEDURE Delete_product_task(
197: P_Api_Version_Number IN NUMBER,
198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
199: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
202: X_Return_Status OUT NOCOPY VARCHAR2,
195: -- The Master delete procedure may not be needed depends on different business requirements.
196: PROCEDURE Delete_product_task(
197: P_Api_Version_Number IN NUMBER,
198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
199: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
202: X_Return_Status OUT NOCOPY VARCHAR2,
203: X_Msg_Count OUT NOCOPY NUMBER,
196: PROCEDURE Delete_product_task(
197: P_Api_Version_Number IN NUMBER,
198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
199: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
202: X_Return_Status OUT NOCOPY VARCHAR2,
203: X_Msg_Count OUT NOCOPY NUMBER,
204: X_Msg_Data OUT NOCOPY VARCHAR2
214: -- The actual validation detail is needed to be added.
215: --
216: -- End of Comments
217: PROCEDURE Validate_PRODUCT_TASK_ID (
218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219: P_Validation_mode IN VARCHAR2,
220: P_PRODUCT_TASK_ID IN NUMBER,
221: -- 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.
222: X_Return_Status OUT NOCOPY VARCHAR2,
233: -- The actual validation detail is needed to be added.
234: --
235: -- End of Comments
236: PROCEDURE Validate_PRODUCT_ID (
237: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
238: P_Validation_mode IN VARCHAR2,
239: P_PRODUCT_ID IN NUMBER,
240: -- 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.
241: X_Return_Status OUT NOCOPY VARCHAR2,
252: -- The actual validation detail is needed to be added.
253: --
254: -- End of Comments
255: PROCEDURE Validate_TASK_TEMPLATE_ID (
256: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
257: P_Validation_mode IN VARCHAR2,
258: P_TASK_TEMPLATE_ID IN NUMBER,
259: -- 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.
260: X_Return_Status OUT NOCOPY VARCHAR2,
271: -- The actual validation detail is needed to be added.
272: --
273: -- End of Comments
274: PROCEDURE Validate_AUTO_MANUAL (
275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
276: P_Validation_mode IN VARCHAR2,
277: P_AUTO_MANUAL IN VARCHAR2,
278: -- 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.
279: X_Return_Status OUT NOCOPY VARCHAR2,
290: -- The actual validation detail is needed to be added.
291: --
292: -- End of Comments
293: PROCEDURE Validate_ACTUAL_TIMES_USED (
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Validation_mode IN VARCHAR2,
296: P_ACTUAL_TIMES_USED IN NUMBER,
297: -- 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.
298: X_Return_Status OUT NOCOPY VARCHAR2,
309: -- The actual validation detail is needed to be added.
310: --
311: -- End of Comments
312: PROCEDURE Validate_TASK_PERCENTAGE (
313: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
314: P_Validation_mode IN VARCHAR2,
315: P_TASK_PERCENTAGE IN NUMBER,
316: -- 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.
317: X_Return_Status OUT NOCOPY VARCHAR2,
328: -- The actual validation detail is needed to be added.
329: -- 2. Developer can manually added inter-field level validation.
330: -- End of Comments
331: PROCEDURE Validate_PROD_TASK_rec(
332: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
333: P_Validation_mode IN VARCHAR2,
334: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
335: X_Return_Status OUT NOCOPY VARCHAR2,
336: X_Msg_Count OUT NOCOPY NUMBER,
346: -- The actual validation detail is needed to be added.
347: -- 2. We can also validate table instead of record. There will be an option for user to choose.
348: -- End of Comments
349: PROCEDURE Validate_product_task(
350: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
351: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
352: P_Validation_mode IN VARCHAR2,
353: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
354: X_Return_Status OUT NOCOPY VARCHAR2,
347: -- 2. We can also validate table instead of record. There will be an option for user to choose.
348: -- End of Comments
349: PROCEDURE Validate_product_task(
350: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
351: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
352: P_Validation_mode IN VARCHAR2,
353: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
354: X_Return_Status OUT NOCOPY VARCHAR2,
355: X_Msg_Count OUT NOCOPY NUMBER,