APPS.CSP_TASK_PARTS_PKG dependencies on FND_API

Line 50: If (px_TASK_PART_ID IS NULL) OR (px_TASK_PART_ID = FND_API.G_MISS_NUM) then

46: P_SUBSTITUTE_ITEM NUMBER)
47: IS
48: CURSOR C2 IS SELECT CSP_TASK_PARTS_S1.nextval FROM sys.dual;
49: BEGIN
50: If (px_TASK_PART_ID IS NULL) OR (px_TASK_PART_ID = FND_API.G_MISS_NUM) then
51: OPEN C2;
52: FETCH C2 INTO px_TASK_PART_ID;
53: CLOSE C2;
54: End If;

Line 93: decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_TASK_ID),

89: ROLLUP_TIMES_USED,
90: SUBSTITUTE_ITEM
91: ) VALUES (
92: px_TASK_PART_ID,
93: decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_TASK_ID),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MANUAL_QUANTITY),
96: decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_MANUAL_PERCENTAGE),
97: decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_USED),

Line 94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),

90: SUBSTITUTE_ITEM
91: ) VALUES (
92: px_TASK_PART_ID,
93: decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_TASK_ID),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MANUAL_QUANTITY),
96: decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_MANUAL_PERCENTAGE),
97: decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_USED),
98: decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, NULL, p_ACTUAL_TIMES_USED),

Line 95: decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MANUAL_QUANTITY),

91: ) VALUES (
92: px_TASK_PART_ID,
93: decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_TASK_ID),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MANUAL_QUANTITY),
96: decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_MANUAL_PERCENTAGE),
97: decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_USED),
98: decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, NULL, p_ACTUAL_TIMES_USED),
99: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

Line 96: decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_MANUAL_PERCENTAGE),

92: px_TASK_PART_ID,
93: decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_TASK_ID),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MANUAL_QUANTITY),
96: decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_MANUAL_PERCENTAGE),
97: decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_USED),
98: decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, NULL, p_ACTUAL_TIMES_USED),
99: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
100: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

Line 97: decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_USED),

93: decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_TASK_ID),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MANUAL_QUANTITY),
96: decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_MANUAL_PERCENTAGE),
97: decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_USED),
98: decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, NULL, p_ACTUAL_TIMES_USED),
99: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
100: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
101: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 98: decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, NULL, p_ACTUAL_TIMES_USED),

94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MANUAL_QUANTITY),
96: decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_MANUAL_PERCENTAGE),
97: decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_USED),
98: decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, NULL, p_ACTUAL_TIMES_USED),
99: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
100: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
101: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
102: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

Line 99: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

95: decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MANUAL_QUANTITY),
96: decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_MANUAL_PERCENTAGE),
97: decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_USED),
98: decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, NULL, p_ACTUAL_TIMES_USED),
99: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
100: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
101: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
102: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
103: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

Line 100: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

96: decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_MANUAL_PERCENTAGE),
97: decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_USED),
98: decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, NULL, p_ACTUAL_TIMES_USED),
99: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
100: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
101: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
102: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
103: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
104: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

Line 101: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

97: decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_USED),
98: decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, NULL, p_ACTUAL_TIMES_USED),
99: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
100: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
101: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
102: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
103: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
104: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
105: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

Line 102: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

98: decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, NULL, p_ACTUAL_TIMES_USED),
99: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
100: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
101: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
102: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
103: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
104: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
105: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
106: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

Line 103: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

99: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
100: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
101: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
102: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
103: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
104: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
105: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
106: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
107: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

Line 104: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

100: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
101: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
102: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
103: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
104: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
105: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
106: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
107: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
108: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

Line 105: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

101: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
102: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
103: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
104: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
105: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
106: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
107: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
108: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
109: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

Line 106: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

102: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
103: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
104: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
105: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
106: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
107: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
108: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
109: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
110: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

Line 107: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

103: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
104: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
105: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
106: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
107: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
108: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
109: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
110: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
111: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

Line 108: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

104: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
105: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
106: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
107: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
108: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
109: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
110: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
111: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
112: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

Line 109: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

105: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
106: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
107: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
108: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
109: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
110: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
111: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
112: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
113: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

Line 110: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

106: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
107: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
108: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
109: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
110: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
111: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
112: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
113: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
114: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

Line 111: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

107: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
108: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
109: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
110: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
111: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
112: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
113: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
114: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
115: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

Line 112: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

108: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
109: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
110: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
111: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
112: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
113: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
114: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
115: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
116: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

Line 113: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

109: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
110: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
111: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
112: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
113: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
114: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
115: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
116: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
117: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

Line 114: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

110: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
111: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
112: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
113: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
114: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
115: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
116: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
117: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
118: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

Line 115: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

111: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
112: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
113: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
114: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
115: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
116: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
117: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
118: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
119: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

Line 116: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

112: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
113: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
114: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
115: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
116: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
117: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
118: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
119: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
120: decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_UOM_CODE),

Line 117: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

113: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
114: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
115: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
116: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
117: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
118: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
119: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
120: decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_UOM_CODE),
121: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),

Line 118: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

114: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
115: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
116: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
117: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
118: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
119: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
120: decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_UOM_CODE),
121: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
122: decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE),

Line 119: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

115: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
116: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
117: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
118: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
119: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
120: decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_UOM_CODE),
121: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
122: decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE),
123: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),

Line 120: decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_UOM_CODE),

116: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
117: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
118: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
119: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
120: decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_UOM_CODE),
121: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
122: decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE),
123: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
124: decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_QUANTITY_USED),

Line 121: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),

117: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
118: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
119: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
120: decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_UOM_CODE),
121: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
122: decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE),
123: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
124: decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_QUANTITY_USED),
125: decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_TIMES_USED),

Line 122: decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE),

118: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
119: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
120: decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_UOM_CODE),
121: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
122: decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE),
123: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
124: decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_QUANTITY_USED),
125: decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_TIMES_USED),
126: decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, NULL, P_SUBSTITUTE_ITEM)

Line 123: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),

119: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
120: decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_UOM_CODE),
121: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
122: decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE),
123: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
124: decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_QUANTITY_USED),
125: decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_TIMES_USED),
126: decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, NULL, P_SUBSTITUTE_ITEM)
127: );

Line 124: decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_QUANTITY_USED),

120: decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_UOM_CODE),
121: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
122: decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE),
123: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
124: decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_QUANTITY_USED),
125: decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_TIMES_USED),
126: decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, NULL, P_SUBSTITUTE_ITEM)
127: );
128: End Insert_Row;

Line 125: decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_TIMES_USED),

121: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
122: decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE),
123: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
124: decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_QUANTITY_USED),
125: decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_TIMES_USED),
126: decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, NULL, P_SUBSTITUTE_ITEM)
127: );
128: End Insert_Row;
129: PROCEDURE Update_Row(

Line 126: decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, NULL, P_SUBSTITUTE_ITEM)

122: decode( p_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE),
123: decode( p_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE),
124: decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_QUANTITY_USED),
125: decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, NULL, P_ROLLUP_TIMES_USED),
126: decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, NULL, P_SUBSTITUTE_ITEM)
127: );
128: End Insert_Row;
129: PROCEDURE Update_Row(
130: p_TASK_PART_ID NUMBER,

Line 169: PRODUCT_TASK_ID = decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, PRODUCT_TASK_ID, p_PRODUCT_TASK_ID),

165: IS
166: BEGIN
167: Update CSP_TASK_PARTS
168: SET
169: PRODUCT_TASK_ID = decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, PRODUCT_TASK_ID, p_PRODUCT_TASK_ID),
170: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
171: MANUAL_QUANTITY = decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, MANUAL_QUANTITY, p_MANUAL_QUANTITY),
172: MANUAL_PERCENTAGE = decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, MANUAL_PERCENTAGE, p_MANUAL_PERCENTAGE),
173: QUANTITY_USED = decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, QUANTITY_USED, p_QUANTITY_USED),

Line 170: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),

166: BEGIN
167: Update CSP_TASK_PARTS
168: SET
169: PRODUCT_TASK_ID = decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, PRODUCT_TASK_ID, p_PRODUCT_TASK_ID),
170: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
171: MANUAL_QUANTITY = decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, MANUAL_QUANTITY, p_MANUAL_QUANTITY),
172: MANUAL_PERCENTAGE = decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, MANUAL_PERCENTAGE, p_MANUAL_PERCENTAGE),
173: QUANTITY_USED = decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, QUANTITY_USED, p_QUANTITY_USED),
174: ACTUAL_TIMES_USED = decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, ACTUAL_TIMES_USED, p_ACTUAL_TIMES_USED),

Line 171: MANUAL_QUANTITY = decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, MANUAL_QUANTITY, p_MANUAL_QUANTITY),

167: Update CSP_TASK_PARTS
168: SET
169: PRODUCT_TASK_ID = decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, PRODUCT_TASK_ID, p_PRODUCT_TASK_ID),
170: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
171: MANUAL_QUANTITY = decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, MANUAL_QUANTITY, p_MANUAL_QUANTITY),
172: MANUAL_PERCENTAGE = decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, MANUAL_PERCENTAGE, p_MANUAL_PERCENTAGE),
173: QUANTITY_USED = decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, QUANTITY_USED, p_QUANTITY_USED),
174: ACTUAL_TIMES_USED = decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, ACTUAL_TIMES_USED, p_ACTUAL_TIMES_USED),
175: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 172: MANUAL_PERCENTAGE = decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, MANUAL_PERCENTAGE, p_MANUAL_PERCENTAGE),

168: SET
169: PRODUCT_TASK_ID = decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, PRODUCT_TASK_ID, p_PRODUCT_TASK_ID),
170: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
171: MANUAL_QUANTITY = decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, MANUAL_QUANTITY, p_MANUAL_QUANTITY),
172: MANUAL_PERCENTAGE = decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, MANUAL_PERCENTAGE, p_MANUAL_PERCENTAGE),
173: QUANTITY_USED = decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, QUANTITY_USED, p_QUANTITY_USED),
174: ACTUAL_TIMES_USED = decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, ACTUAL_TIMES_USED, p_ACTUAL_TIMES_USED),
175: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
176: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 173: QUANTITY_USED = decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, QUANTITY_USED, p_QUANTITY_USED),

169: PRODUCT_TASK_ID = decode( p_PRODUCT_TASK_ID, FND_API.G_MISS_NUM, PRODUCT_TASK_ID, p_PRODUCT_TASK_ID),
170: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
171: MANUAL_QUANTITY = decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, MANUAL_QUANTITY, p_MANUAL_QUANTITY),
172: MANUAL_PERCENTAGE = decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, MANUAL_PERCENTAGE, p_MANUAL_PERCENTAGE),
173: QUANTITY_USED = decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, QUANTITY_USED, p_QUANTITY_USED),
174: ACTUAL_TIMES_USED = decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, ACTUAL_TIMES_USED, p_ACTUAL_TIMES_USED),
175: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
176: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
177: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 174: ACTUAL_TIMES_USED = decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, ACTUAL_TIMES_USED, p_ACTUAL_TIMES_USED),

170: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
171: MANUAL_QUANTITY = decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, MANUAL_QUANTITY, p_MANUAL_QUANTITY),
172: MANUAL_PERCENTAGE = decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, MANUAL_PERCENTAGE, p_MANUAL_PERCENTAGE),
173: QUANTITY_USED = decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, QUANTITY_USED, p_QUANTITY_USED),
174: ACTUAL_TIMES_USED = decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, ACTUAL_TIMES_USED, p_ACTUAL_TIMES_USED),
175: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
176: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
177: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
178: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 175: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

171: MANUAL_QUANTITY = decode( p_MANUAL_QUANTITY, FND_API.G_MISS_NUM, MANUAL_QUANTITY, p_MANUAL_QUANTITY),
172: MANUAL_PERCENTAGE = decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, MANUAL_PERCENTAGE, p_MANUAL_PERCENTAGE),
173: QUANTITY_USED = decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, QUANTITY_USED, p_QUANTITY_USED),
174: ACTUAL_TIMES_USED = decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, ACTUAL_TIMES_USED, p_ACTUAL_TIMES_USED),
175: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
176: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
177: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
178: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
179: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

Line 176: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

172: MANUAL_PERCENTAGE = decode( p_MANUAL_PERCENTAGE, FND_API.G_MISS_NUM, MANUAL_PERCENTAGE, p_MANUAL_PERCENTAGE),
173: QUANTITY_USED = decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, QUANTITY_USED, p_QUANTITY_USED),
174: ACTUAL_TIMES_USED = decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, ACTUAL_TIMES_USED, p_ACTUAL_TIMES_USED),
175: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
176: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
177: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
178: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
179: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
180: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

Line 177: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

173: QUANTITY_USED = decode( p_QUANTITY_USED, FND_API.G_MISS_NUM, QUANTITY_USED, p_QUANTITY_USED),
174: ACTUAL_TIMES_USED = decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, ACTUAL_TIMES_USED, p_ACTUAL_TIMES_USED),
175: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
176: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
177: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
178: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
179: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
180: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
181: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

Line 178: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

174: ACTUAL_TIMES_USED = decode( p_ACTUAL_TIMES_USED, FND_API.G_MISS_NUM, ACTUAL_TIMES_USED, p_ACTUAL_TIMES_USED),
175: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
176: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
177: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
178: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
179: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
180: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
181: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
182: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

Line 179: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

175: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
176: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
177: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
178: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
179: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
180: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
181: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
182: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
183: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

Line 180: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

176: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
177: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
178: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
179: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
180: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
181: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
182: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
183: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
184: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

Line 181: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

177: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
178: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
179: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
180: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
181: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
182: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
183: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
184: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
185: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

Line 182: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

178: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
179: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
180: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
181: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
182: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
183: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
184: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
185: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
186: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

Line 183: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

179: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
180: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
181: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
182: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
183: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
184: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
185: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
186: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
187: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

Line 184: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

180: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
181: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
182: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
183: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
184: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
185: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
186: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
187: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
188: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

Line 185: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

181: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
182: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
183: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
184: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
185: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
186: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
187: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
188: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
189: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

Line 186: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

182: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
183: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
184: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
185: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
186: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
187: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
188: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
189: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
190: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

Line 187: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

183: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
184: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
185: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
186: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
187: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
188: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
189: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
190: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
191: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

Line 188: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

184: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
185: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
186: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
187: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
188: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
189: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
190: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
191: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
192: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

Line 189: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

185: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
186: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
187: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
188: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
189: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
190: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
191: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
192: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
193: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

Line 190: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

186: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
187: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
188: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
189: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
190: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
191: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
192: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
193: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
194: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

Line 191: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

187: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
188: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
189: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
190: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
191: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
192: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
193: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
194: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
195: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

Line 192: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

188: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
189: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
190: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
191: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
192: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
193: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
194: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
195: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
196: PRIMARY_UOM_CODE = decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, PRIMARY_UOM_CODE, p_PRIMARY_UOM_CODE),

Line 193: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

189: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
190: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
191: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
192: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
193: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
194: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
195: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
196: PRIMARY_UOM_CODE = decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, PRIMARY_UOM_CODE, p_PRIMARY_UOM_CODE),
197: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),

Line 194: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

190: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
191: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
192: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
193: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
194: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
195: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
196: PRIMARY_UOM_CODE = decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, PRIMARY_UOM_CODE, p_PRIMARY_UOM_CODE),
197: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
198: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),

Line 195: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

191: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
192: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
193: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
194: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
195: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
196: PRIMARY_UOM_CODE = decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, PRIMARY_UOM_CODE, p_PRIMARY_UOM_CODE),
197: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
198: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
199: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),

Line 196: PRIMARY_UOM_CODE = decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, PRIMARY_UOM_CODE, p_PRIMARY_UOM_CODE),

192: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
193: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
194: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
195: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
196: PRIMARY_UOM_CODE = decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, PRIMARY_UOM_CODE, p_PRIMARY_UOM_CODE),
197: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
198: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
199: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
200: ROLLUP_QUANTITY_USED = decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, P_ROLLUP_QUANTITY_USED),

Line 197: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),

193: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
194: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
195: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
196: PRIMARY_UOM_CODE = decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, PRIMARY_UOM_CODE, p_PRIMARY_UOM_CODE),
197: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
198: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
199: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
200: ROLLUP_QUANTITY_USED = decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, P_ROLLUP_QUANTITY_USED),
201: ROLLUP_TIMES_USED = decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, ROLLUP_TIMES_USED, P_ROLLUP_TIMES_USED),

Line 198: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),

194: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
195: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
196: PRIMARY_UOM_CODE = decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, PRIMARY_UOM_CODE, p_PRIMARY_UOM_CODE),
197: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
198: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
199: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
200: ROLLUP_QUANTITY_USED = decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, P_ROLLUP_QUANTITY_USED),
201: ROLLUP_TIMES_USED = decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, ROLLUP_TIMES_USED, P_ROLLUP_TIMES_USED),
202: SUBSTITUTE_ITEM = decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, SUBSTITUTE_ITEM, P_SUBSTITUTE_ITEM)

Line 199: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),

195: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
196: PRIMARY_UOM_CODE = decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, PRIMARY_UOM_CODE, p_PRIMARY_UOM_CODE),
197: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
198: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
199: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
200: ROLLUP_QUANTITY_USED = decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, P_ROLLUP_QUANTITY_USED),
201: ROLLUP_TIMES_USED = decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, ROLLUP_TIMES_USED, P_ROLLUP_TIMES_USED),
202: SUBSTITUTE_ITEM = decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, SUBSTITUTE_ITEM, P_SUBSTITUTE_ITEM)
203: where TASK_PART_ID = p_TASK_PART_ID;

Line 200: ROLLUP_QUANTITY_USED = decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, P_ROLLUP_QUANTITY_USED),

196: PRIMARY_UOM_CODE = decode( p_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, PRIMARY_UOM_CODE, p_PRIMARY_UOM_CODE),
197: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
198: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
199: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
200: ROLLUP_QUANTITY_USED = decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, P_ROLLUP_QUANTITY_USED),
201: ROLLUP_TIMES_USED = decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, ROLLUP_TIMES_USED, P_ROLLUP_TIMES_USED),
202: SUBSTITUTE_ITEM = decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, SUBSTITUTE_ITEM, P_SUBSTITUTE_ITEM)
203: where TASK_PART_ID = p_TASK_PART_ID;
204: If (SQL%NOTFOUND) then

Line 201: ROLLUP_TIMES_USED = decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, ROLLUP_TIMES_USED, P_ROLLUP_TIMES_USED),

197: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
198: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
199: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
200: ROLLUP_QUANTITY_USED = decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, P_ROLLUP_QUANTITY_USED),
201: ROLLUP_TIMES_USED = decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, ROLLUP_TIMES_USED, P_ROLLUP_TIMES_USED),
202: SUBSTITUTE_ITEM = decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, SUBSTITUTE_ITEM, P_SUBSTITUTE_ITEM)
203: where TASK_PART_ID = p_TASK_PART_ID;
204: If (SQL%NOTFOUND) then
205: RAISE NO_DATA_FOUND;

Line 202: SUBSTITUTE_ITEM = decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, SUBSTITUTE_ITEM, P_SUBSTITUTE_ITEM)

198: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),
199: END_DATE = decode( p_END_DATE, FND_API.G_MISS_DATE, END_DATE, p_END_DATE),
200: ROLLUP_QUANTITY_USED = decode( P_ROLLUP_QUANTITY_USED, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, P_ROLLUP_QUANTITY_USED),
201: ROLLUP_TIMES_USED = decode( P_ROLLUP_TIMES_USED, FND_API.G_MISS_NUM, ROLLUP_TIMES_USED, P_ROLLUP_TIMES_USED),
202: SUBSTITUTE_ITEM = decode( P_SUBSTITUTE_ITEM, FND_API.G_MISS_NUM, SUBSTITUTE_ITEM, P_SUBSTITUTE_ITEM)
203: where TASK_PART_ID = p_TASK_PART_ID;
204: If (SQL%NOTFOUND) then
205: RAISE NO_DATA_FOUND;
206: End If;