eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PRODUCT_TASK_PUB 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 99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

95: -- Pre-Req :
96: -- Parameters:
97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

Line 100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

96: -- Parameters:
97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_admin_group_id IN NUMBER Required

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

97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_admin_group_id IN NUMBER Required
105: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required

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

98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_admin_group_id IN NUMBER Required
105: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
106: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_admin_group_id IN NUMBER Required
105: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
106: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
107: --

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

116: -- End of Comments
117: --
118: PROCEDURE Create_product_task(
119: P_Api_Version_Number IN NUMBER,
120: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
121: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type := G_MISS_PROD_TASK_REC,
124: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

117: --
118: PROCEDURE Create_product_task(
119: P_Api_Version_Number IN NUMBER,
120: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
121: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type := G_MISS_PROD_TASK_REC,
124: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
125: X_PRODUCT_TASK_ID OUT NOCOPY NUMBER,

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

118: PROCEDURE Create_product_task(
119: P_Api_Version_Number IN NUMBER,
120: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
121: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type := G_MISS_PROD_TASK_REC,
124: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
125: X_PRODUCT_TASK_ID OUT NOCOPY NUMBER,
126: X_Return_Status OUT NOCOPY VARCHAR2,

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

135: -- Pre-Req :
136: -- Parameters:
137: -- IN
138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

Line 140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

136: -- Parameters:
137: -- IN
138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_admin_group_id IN NUMBER Required

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

137: -- IN
138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_admin_group_id IN NUMBER Required
145: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

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

138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_admin_group_id IN NUMBER Required
145: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
146: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required

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

139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_admin_group_id IN NUMBER Required
145: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
146: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
147: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

158: --
159: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
160: PROCEDURE Update_product_task(
161: P_Api_Version_Number IN NUMBER,
162: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
163: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
166: X_Return_Status OUT NOCOPY VARCHAR2,

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

159: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
160: PROCEDURE Update_product_task(
161: P_Api_Version_Number IN NUMBER,
162: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
163: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
166: X_Return_Status OUT NOCOPY VARCHAR2,
167: X_Msg_Count OUT NOCOPY NUMBER,

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

160: PROCEDURE Update_product_task(
161: P_Api_Version_Number IN NUMBER,
162: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
163: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
166: X_Return_Status OUT NOCOPY VARCHAR2,
167: X_Msg_Count OUT NOCOPY NUMBER,
168: X_Msg_Data OUT NOCOPY VARCHAR2

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

175: -- Pre-Req :
176: -- Parameters:
177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
183: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

Line 180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

176: -- Parameters:
177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
183: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_admin_group_id IN NUMBER Required

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

177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
183: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_admin_group_id IN NUMBER Required
185: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

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

178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
183: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_admin_group_id IN NUMBER Required
185: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
186: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required

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

179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
183: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_admin_group_id IN NUMBER Required
185: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
186: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
187: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

199: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
200: -- The Master delete procedure may not be needed depends on different business requirements.
201: PROCEDURE Delete_product_task(
202: P_Api_Version_Number IN NUMBER,
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
207: X_Return_Status OUT NOCOPY VARCHAR2,

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

200: -- The Master delete procedure may not be needed depends on different business requirements.
201: PROCEDURE Delete_product_task(
202: P_Api_Version_Number IN NUMBER,
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
207: X_Return_Status OUT NOCOPY VARCHAR2,
208: X_Msg_Count OUT NOCOPY NUMBER,

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

201: PROCEDURE Delete_product_task(
202: P_Api_Version_Number IN NUMBER,
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
207: X_Return_Status OUT NOCOPY VARCHAR2,
208: X_Msg_Count OUT NOCOPY NUMBER,
209: X_Msg_Data OUT NOCOPY VARCHAR2

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

216: -- Pre-Req :
217: -- Parameters:
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_admin_group_id IN NUMBER Required

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

217: -- Parameters:
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_admin_group_id IN NUMBER Required
225: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

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

218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_admin_group_id IN NUMBER Required
225: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
226: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required

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

219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_admin_group_id IN NUMBER Required
225: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
226: -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
227: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

Line 235: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE

231: --
232: -- Return Total Records Count Flag. This flag controls whether the total record count
233: -- and total record amount is returned.
234: --
235: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
236: -- Hint: User defined record type
237: -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
238: --
239: -- OUT:

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

253: -- End of Comments
254: --
255: PROCEDURE Get_product_task(
256: P_Api_Version_Number IN NUMBER,
257: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: P_PROD_TASK_Rec IN CSP_product_task_PUB.PROD_TASK_Rec_Type,
260: -- Hint: Add list of bind variables here
261: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

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

254: --
255: PROCEDURE Get_product_task(
256: P_Api_Version_Number IN NUMBER,
257: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: P_PROD_TASK_Rec IN CSP_product_task_PUB.PROD_TASK_Rec_Type,
260: -- Hint: Add list of bind variables here
261: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
262: p_start_rec_prt IN NUMBER := 1,

Line 263: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

259: P_PROD_TASK_Rec IN CSP_product_task_PUB.PROD_TASK_Rec_Type,
260: -- Hint: Add list of bind variables here
261: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
262: p_start_rec_prt IN NUMBER := 1,
263: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
264: -- Hint: user defined record type
265: p_order_by_rec IN CSP_product_task_PUB.PROD_TASK_sort_rec_type,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,