APPS.CSP_TASK_PART_PUB dependencies on FND_API

Line 60: TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,

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,

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

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

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

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

Line 65: QUANTITY_USED 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,
69: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

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

Line 67: CREATED_BY 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,
71: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 68: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 69: LAST_UPDATED_BY 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,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 70: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 71: LAST_UPDATE_LOGIN 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,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 85: ATTRIBUTE13 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,
89: REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 86: ATTRIBUTE14 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,
90: START_DATE DATE := FND_API.G_MISS_DATE,

Line 87: ATTRIBUTE15 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,
91: END_DATE DATE := FND_API.G_MISS_DATE,

Line 88: PRIMARY_UOM_CODE VARCHAR2(3) := 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,
92: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,

Line 89: REVISION VARCHAR2(30) := 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,
93: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,

Line 90: START_DATE DATE := FND_API.G_MISS_DATE,

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

Line 91: END_DATE DATE := FND_API.G_MISS_DATE,

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

Line 92: ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,

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;

Line 93: ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,

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

Line 94: SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM

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;

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

110: -- Pre-Req :
111: -- Parameters:
112: -- IN
113: -- p_api_version_number IN NUMBER Required
114: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
115: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
116: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

111: -- Parameters:
112: -- IN
113: -- p_api_version_number IN NUMBER Required
114: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
115: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
116: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- p_admin_group_id IN NUMBER Required

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

112: -- IN
113: -- p_api_version_number IN NUMBER Required
114: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
115: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
116: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- p_admin_group_id IN NUMBER Required
120: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required

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

113: -- p_api_version_number IN NUMBER Required
114: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
115: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
116: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- p_admin_group_id IN NUMBER Required
120: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
121: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

114: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
115: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
116: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- p_admin_group_id IN NUMBER Required
120: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
121: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
122: --

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

131: -- End of Comments
132: --
133: PROCEDURE Create_task_part(
134: P_Api_Version_Number IN NUMBER,
135: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138: P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
139: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

132: --
133: PROCEDURE Create_task_part(
134: P_Api_Version_Number IN NUMBER,
135: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138: P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
139: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
140: X_TASK_PART_ID OUT NOCOPY NUMBER,

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

133: PROCEDURE Create_task_part(
134: P_Api_Version_Number IN NUMBER,
135: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138: P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
139: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
140: X_TASK_PART_ID OUT NOCOPY NUMBER,
141: X_Return_Status OUT NOCOPY VARCHAR2,

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

150: -- Pre-Req :
151: -- Parameters:
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

151: -- Parameters:
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
159: -- p_admin_group_id IN NUMBER Required

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

152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
159: -- p_admin_group_id IN NUMBER Required
160: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

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

153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
159: -- p_admin_group_id IN NUMBER Required
160: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
161: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required

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

154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
159: -- p_admin_group_id IN NUMBER Required
160: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
161: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
162: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

173: --
174: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
175: PROCEDURE Update_task_part(
176: P_Api_Version_Number IN NUMBER,
177: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
178: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
181: X_Return_Status OUT NOCOPY VARCHAR2,

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

174: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
175: PROCEDURE Update_task_part(
176: P_Api_Version_Number IN NUMBER,
177: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
178: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
181: X_Return_Status OUT NOCOPY VARCHAR2,
182: X_Msg_Count OUT NOCOPY NUMBER,

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

175: PROCEDURE Update_task_part(
176: P_Api_Version_Number IN NUMBER,
177: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
178: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
181: X_Return_Status OUT NOCOPY VARCHAR2,
182: X_Msg_Count OUT NOCOPY NUMBER,
183: X_Msg_Data OUT NOCOPY VARCHAR2

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

190: -- Pre-Req :
191: -- Parameters:
192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

191: -- Parameters:
192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- p_admin_group_id IN NUMBER Required

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

192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- p_admin_group_id IN NUMBER Required
200: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

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

193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- p_admin_group_id IN NUMBER Required
200: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
201: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required

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

194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- p_admin_group_id IN NUMBER Required
200: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
201: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
202: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

214: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
215: -- The Master delete procedure may not be needed depends on different business requirements.
216: PROCEDURE Delete_task_part(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
222: X_Return_Status OUT NOCOPY VARCHAR2,

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

215: -- The Master delete procedure may not be needed depends on different business requirements.
216: PROCEDURE Delete_task_part(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
222: X_Return_Status OUT NOCOPY VARCHAR2,
223: X_Msg_Count OUT NOCOPY NUMBER,

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

216: PROCEDURE Delete_task_part(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
222: X_Return_Status OUT NOCOPY VARCHAR2,
223: X_Msg_Count OUT NOCOPY NUMBER,
224: X_Msg_Data OUT NOCOPY VARCHAR2

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

231: -- Pre-Req :
232: -- Parameters:
233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
238: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_admin_group_id IN NUMBER Required

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

232: -- Parameters:
233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
238: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_admin_group_id IN NUMBER Required
240: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

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

233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
238: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_admin_group_id IN NUMBER Required
240: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
241: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required

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

234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
238: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_admin_group_id IN NUMBER Required
240: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
241: -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
242: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

246: --
247: -- Return Total Records Count Flag. This flag controls whether the total record count
248: -- and total record amount is returned.
249: --
250: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
251: -- Hint: User defined record type
252: -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
253: --
254: -- OUT:

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

268: -- End of Comments
269: --
270: PROCEDURE Get_task_part(
271: P_Api_Version_Number IN NUMBER,
272: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: P_TASK_PART_Rec IN CSP_task_part_PUB.TASK_PART_Rec_Type,
275: -- Hint: Add list of bind variables here
276: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

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

269: --
270: PROCEDURE Get_task_part(
271: P_Api_Version_Number IN NUMBER,
272: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: P_TASK_PART_Rec IN CSP_task_part_PUB.TASK_PART_Rec_Type,
275: -- Hint: Add list of bind variables here
276: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
277: p_start_rec_prt IN NUMBER := 1,

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

274: P_TASK_PART_Rec IN CSP_task_part_PUB.TASK_PART_Rec_Type,
275: -- Hint: Add list of bind variables here
276: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
277: p_start_rec_prt IN NUMBER := 1,
278: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
279: -- Hint: user defined record type
280: p_order_by_rec IN CSP_task_part_PUB.TASK_PART_sort_rec_type,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,