DBA Data[Home] [Help]

APPS.CSP_PRODUCT_TASK_PVT dependencies on FND_API

Line 53: PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 54: PRODUCT_ID 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,

Line 55: TASK_TEMPLATE_ID 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,

Line 56: AUTO_MANUAL VARCHAR2(6) := 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,

Line 57: ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,

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,

Line 58: TASK_PERCENTAGE 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,
62: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 59: ATTRIBUTE_CATEGORY VARCHAR2(30) := 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,

Line 60: ATTRIBUTE1 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,

Line 61: ATTRIBUTE2 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,

Line 62: ATTRIBUTE3 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,

Line 63: ATTRIBUTE4 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,

Line 64: ATTRIBUTE5 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,

Line 65: ATTRIBUTE6 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,

Line 66: ATTRIBUTE7 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,

Line 67: ATTRIBUTE8 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,

Line 68: ATTRIBUTE9 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,

Line 69: ATTRIBUTE10 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,

Line 70: ATTRIBUTE11 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,

Line 71: ATTRIBUTE12 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,

Line 72: ATTRIBUTE13 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,
76: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 73: ATTRIBUTE14 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,
77: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 74: ATTRIBUTE15 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,
78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 75: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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

Line 76: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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: );

Line 77: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

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;

Line 78: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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

Line 79: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

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;

Line 94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 95: -- p_commit 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

Line 96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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: --

Line 115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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.

Line 116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 135: -- p_commit 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

Line 136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 175: -- p_commit 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

Line 176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 177: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 178: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 199: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 237: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 256: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 313: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 332: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 350: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 351: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,