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

APPS.CSD_REPAIR_ORDER_GROUPS_PKG dependencies on FND_API

Line 61: If (px_REPAIR_GROUP_ID IS NULL) OR (px_REPAIR_GROUP_ID = FND_API.G_MISS_NUM) then

57:
58: IS
59: CURSOR C2 IS SELECT CSD_REPAIR_ORDER_GROUPS_S1.nextval FROM sys.dual;
60: BEGIN
61: If (px_REPAIR_GROUP_ID IS NULL) OR (px_REPAIR_GROUP_ID = FND_API.G_MISS_NUM) then
62: OPEN C2;
63: FETCH C2 INTO px_REPAIR_GROUP_ID;
64: CLOSE C2;
65: End If;

Line 110: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)

106: ,GROUP_APPROVAL_STATUS
107: ,REPAIR_MODE
108: ) VALUES (
109: px_REPAIR_GROUP_ID
110: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
111: ,decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, p_REPAIR_GROUP_NUMBER)
112: ,decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_TYPE_ID)
113: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
114: ,decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE)

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

107: ,REPAIR_MODE
108: ) VALUES (
109: px_REPAIR_GROUP_ID
110: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
111: ,decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, p_REPAIR_GROUP_NUMBER)
112: ,decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_TYPE_ID)
113: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
114: ,decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE)
115: ,decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_GROUP_QUANTITY)

Line 112: ,decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_TYPE_ID)

108: ) VALUES (
109: px_REPAIR_GROUP_ID
110: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
111: ,decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, p_REPAIR_GROUP_NUMBER)
112: ,decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_TYPE_ID)
113: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
114: ,decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE)
115: ,decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_GROUP_QUANTITY)
116: ,decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_ORDER_QUANTITY)

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

109: px_REPAIR_GROUP_ID
110: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
111: ,decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, p_REPAIR_GROUP_NUMBER)
112: ,decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_TYPE_ID)
113: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
114: ,decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE)
115: ,decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_GROUP_QUANTITY)
116: ,decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_ORDER_QUANTITY)
117: ,decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RMA_QUANTITY)

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

110: ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
111: ,decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, p_REPAIR_GROUP_NUMBER)
112: ,decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_TYPE_ID)
113: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
114: ,decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE)
115: ,decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_GROUP_QUANTITY)
116: ,decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_ORDER_QUANTITY)
117: ,decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RMA_QUANTITY)
118: ,decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RECEIVED_QUANTITY)

Line 115: ,decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_GROUP_QUANTITY)

111: ,decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, p_REPAIR_GROUP_NUMBER)
112: ,decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_TYPE_ID)
113: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
114: ,decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE)
115: ,decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_GROUP_QUANTITY)
116: ,decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_ORDER_QUANTITY)
117: ,decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RMA_QUANTITY)
118: ,decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RECEIVED_QUANTITY)
119: ,decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_APPROVED_QUANTITY)

Line 116: ,decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_ORDER_QUANTITY)

112: ,decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_TYPE_ID)
113: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
114: ,decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE)
115: ,decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_GROUP_QUANTITY)
116: ,decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_ORDER_QUANTITY)
117: ,decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RMA_QUANTITY)
118: ,decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RECEIVED_QUANTITY)
119: ,decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_APPROVED_QUANTITY)
120: ,decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SUBMITTED_QUANTITY)

Line 117: ,decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RMA_QUANTITY)

113: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
114: ,decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE)
115: ,decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_GROUP_QUANTITY)
116: ,decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_ORDER_QUANTITY)
117: ,decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RMA_QUANTITY)
118: ,decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RECEIVED_QUANTITY)
119: ,decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_APPROVED_QUANTITY)
120: ,decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SUBMITTED_QUANTITY)
121: ,decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_COMPLETED_QUANTITY)

Line 118: ,decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RECEIVED_QUANTITY)

114: ,decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE)
115: ,decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_GROUP_QUANTITY)
116: ,decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_ORDER_QUANTITY)
117: ,decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RMA_QUANTITY)
118: ,decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RECEIVED_QUANTITY)
119: ,decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_APPROVED_QUANTITY)
120: ,decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SUBMITTED_QUANTITY)
121: ,decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_COMPLETED_QUANTITY)
122: ,decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RELEASED_QUANTITY)

Line 119: ,decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_APPROVED_QUANTITY)

115: ,decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_GROUP_QUANTITY)
116: ,decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_ORDER_QUANTITY)
117: ,decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RMA_QUANTITY)
118: ,decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RECEIVED_QUANTITY)
119: ,decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_APPROVED_QUANTITY)
120: ,decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SUBMITTED_QUANTITY)
121: ,decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_COMPLETED_QUANTITY)
122: ,decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RELEASED_QUANTITY)
123: ,decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY)

Line 120: ,decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SUBMITTED_QUANTITY)

116: ,decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_ORDER_QUANTITY)
117: ,decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RMA_QUANTITY)
118: ,decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RECEIVED_QUANTITY)
119: ,decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_APPROVED_QUANTITY)
120: ,decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SUBMITTED_QUANTITY)
121: ,decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_COMPLETED_QUANTITY)
122: ,decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RELEASED_QUANTITY)
123: ,decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY)
124: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

Line 121: ,decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_COMPLETED_QUANTITY)

117: ,decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RMA_QUANTITY)
118: ,decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RECEIVED_QUANTITY)
119: ,decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_APPROVED_QUANTITY)
120: ,decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SUBMITTED_QUANTITY)
121: ,decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_COMPLETED_QUANTITY)
122: ,decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RELEASED_QUANTITY)
123: ,decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY)
124: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
125: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

Line 122: ,decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RELEASED_QUANTITY)

118: ,decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RECEIVED_QUANTITY)
119: ,decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_APPROVED_QUANTITY)
120: ,decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SUBMITTED_QUANTITY)
121: ,decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_COMPLETED_QUANTITY)
122: ,decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RELEASED_QUANTITY)
123: ,decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY)
124: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
125: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
126: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

Line 123: ,decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY)

119: ,decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_APPROVED_QUANTITY)
120: ,decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SUBMITTED_QUANTITY)
121: ,decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_COMPLETED_QUANTITY)
122: ,decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RELEASED_QUANTITY)
123: ,decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY)
124: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
125: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
126: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
127: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

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

120: ,decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SUBMITTED_QUANTITY)
121: ,decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_COMPLETED_QUANTITY)
122: ,decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RELEASED_QUANTITY)
123: ,decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY)
124: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
125: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
126: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
127: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
128: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

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

121: ,decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_COMPLETED_QUANTITY)
122: ,decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RELEASED_QUANTITY)
123: ,decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY)
124: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
125: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
126: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
127: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
128: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
129: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)

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

122: ,decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RELEASED_QUANTITY)
123: ,decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY)
124: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
125: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
126: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
127: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
128: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
129: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
130: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)

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

123: ,decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY)
124: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
125: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
126: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
127: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
128: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
129: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
130: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
131: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)

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

124: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
125: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
126: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
127: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
128: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
129: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
130: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
131: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
132: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

Line 129: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)

125: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
126: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
127: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
128: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
129: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
130: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
131: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
132: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
133: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

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

126: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
127: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
128: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
129: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
130: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
131: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
132: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
133: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
134: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

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

127: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
128: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
129: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
130: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
131: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
132: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
133: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
134: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
135: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

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

128: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
129: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
130: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
131: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
132: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
133: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
134: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
135: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
136: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

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

129: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
130: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
131: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
132: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
133: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
134: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
135: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
136: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
137: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

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

130: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
131: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
132: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
133: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
134: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
135: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
136: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
137: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
138: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

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

131: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
132: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
133: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
134: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
135: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
136: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
137: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
138: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
139: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

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

132: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
133: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
134: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
135: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
136: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
137: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
138: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
139: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
140: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

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

133: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
134: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
135: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
136: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
137: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
138: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
139: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
140: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
141: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

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

134: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
135: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
136: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
137: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
138: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
139: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
140: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
141: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
142: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

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

135: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
136: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
137: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
138: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
139: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
140: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
141: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
142: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
143: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

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

136: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
137: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
138: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
139: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
140: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
141: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
142: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
143: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
144: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

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

137: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
138: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
139: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
140: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
141: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
142: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
143: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
144: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
145: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

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

138: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
139: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
140: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
141: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
142: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
143: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
144: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
145: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
146: ,decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_TXN_STATUS)

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

139: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
140: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
141: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
142: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
143: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
144: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
145: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
146: ,decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_TXN_STATUS)
147: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)

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

140: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
141: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
142: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
143: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
144: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
145: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
146: ,decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_TXN_STATUS)
147: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
148: ,decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_APPROVAL_STATUS)

Line 145: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

141: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
142: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
143: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
144: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
145: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
146: ,decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_TXN_STATUS)
147: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
148: ,decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_APPROVAL_STATUS)
149: ,decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, p_REPAIR_MODE));

Line 146: ,decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_TXN_STATUS)

142: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
143: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
144: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
145: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
146: ,decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_TXN_STATUS)
147: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
148: ,decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_APPROVAL_STATUS)
149: ,decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, p_REPAIR_MODE));
150: End Insert_Row;

Line 147: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)

143: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
144: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
145: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
146: ,decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_TXN_STATUS)
147: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
148: ,decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_APPROVAL_STATUS)
149: ,decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, p_REPAIR_MODE));
150: End Insert_Row;
151:

Line 148: ,decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_APPROVAL_STATUS)

144: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
145: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
146: ,decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_TXN_STATUS)
147: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
148: ,decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_APPROVAL_STATUS)
149: ,decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, p_REPAIR_MODE));
150: End Insert_Row;
151:
152: PROCEDURE Update_Row(

Line 149: ,decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, p_REPAIR_MODE));

145: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
146: ,decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_TXN_STATUS)
147: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
148: ,decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, p_GROUP_APPROVAL_STATUS)
149: ,decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, p_REPAIR_MODE));
150: End Insert_Row;
151:
152: PROCEDURE Update_Row(
153: p_REPAIR_GROUP_ID NUMBER

Line 199: INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, NULL, INCIDENT_ID, p_INCIDENT_ID)

195: IS
196: BEGIN
197: Update CSD_REPAIR_ORDER_GROUPS
198: SET
199: INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, NULL, INCIDENT_ID, p_INCIDENT_ID)
200: ,REPAIR_GROUP_NUMBER = decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_GROUP_NUMBER, p_REPAIR_GROUP_NUMBER)
201: ,REPAIR_TYPE_ID = decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_TYPE_ID, p_REPAIR_TYPE_ID)
202: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
203: ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, NULL, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)

Line 200: ,REPAIR_GROUP_NUMBER = decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_GROUP_NUMBER, p_REPAIR_GROUP_NUMBER)

196: BEGIN
197: Update CSD_REPAIR_ORDER_GROUPS
198: SET
199: INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, NULL, INCIDENT_ID, p_INCIDENT_ID)
200: ,REPAIR_GROUP_NUMBER = decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_GROUP_NUMBER, p_REPAIR_GROUP_NUMBER)
201: ,REPAIR_TYPE_ID = decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_TYPE_ID, p_REPAIR_TYPE_ID)
202: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
203: ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, NULL, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)
204: ,GROUP_QUANTITY = decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, GROUP_QUANTITY, p_GROUP_QUANTITY)

Line 201: ,REPAIR_TYPE_ID = decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_TYPE_ID, p_REPAIR_TYPE_ID)

197: Update CSD_REPAIR_ORDER_GROUPS
198: SET
199: INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, NULL, INCIDENT_ID, p_INCIDENT_ID)
200: ,REPAIR_GROUP_NUMBER = decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_GROUP_NUMBER, p_REPAIR_GROUP_NUMBER)
201: ,REPAIR_TYPE_ID = decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_TYPE_ID, p_REPAIR_TYPE_ID)
202: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
203: ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, NULL, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)
204: ,GROUP_QUANTITY = decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, GROUP_QUANTITY, p_GROUP_QUANTITY)
205: ,REPAIR_ORDER_QUANTITY = decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ORDER_QUANTITY, p_REPAIR_ORDER_QUANTITY)

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

198: SET
199: INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, NULL, INCIDENT_ID, p_INCIDENT_ID)
200: ,REPAIR_GROUP_NUMBER = decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_GROUP_NUMBER, p_REPAIR_GROUP_NUMBER)
201: ,REPAIR_TYPE_ID = decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_TYPE_ID, p_REPAIR_TYPE_ID)
202: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
203: ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, NULL, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)
204: ,GROUP_QUANTITY = decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, GROUP_QUANTITY, p_GROUP_QUANTITY)
205: ,REPAIR_ORDER_QUANTITY = decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ORDER_QUANTITY, p_REPAIR_ORDER_QUANTITY)
206: ,RMA_QUANTITY = decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RMA_QUANTITY, p_RMA_QUANTITY)

Line 203: ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, NULL, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)

199: INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, NULL, INCIDENT_ID, p_INCIDENT_ID)
200: ,REPAIR_GROUP_NUMBER = decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_GROUP_NUMBER, p_REPAIR_GROUP_NUMBER)
201: ,REPAIR_TYPE_ID = decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_TYPE_ID, p_REPAIR_TYPE_ID)
202: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
203: ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, NULL, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)
204: ,GROUP_QUANTITY = decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, GROUP_QUANTITY, p_GROUP_QUANTITY)
205: ,REPAIR_ORDER_QUANTITY = decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ORDER_QUANTITY, p_REPAIR_ORDER_QUANTITY)
206: ,RMA_QUANTITY = decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RMA_QUANTITY, p_RMA_QUANTITY)
207: ,RECEIVED_QUANTITY = decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RECEIVED_QUANTITY, p_RECEIVED_QUANTITY)

Line 204: ,GROUP_QUANTITY = decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, GROUP_QUANTITY, p_GROUP_QUANTITY)

200: ,REPAIR_GROUP_NUMBER = decode( p_REPAIR_GROUP_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_GROUP_NUMBER, p_REPAIR_GROUP_NUMBER)
201: ,REPAIR_TYPE_ID = decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_TYPE_ID, p_REPAIR_TYPE_ID)
202: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
203: ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, NULL, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)
204: ,GROUP_QUANTITY = decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, GROUP_QUANTITY, p_GROUP_QUANTITY)
205: ,REPAIR_ORDER_QUANTITY = decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ORDER_QUANTITY, p_REPAIR_ORDER_QUANTITY)
206: ,RMA_QUANTITY = decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RMA_QUANTITY, p_RMA_QUANTITY)
207: ,RECEIVED_QUANTITY = decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RECEIVED_QUANTITY, p_RECEIVED_QUANTITY)
208: ,APPROVED_QUANTITY = decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, APPROVED_QUANTITY, p_APPROVED_QUANTITY)

Line 205: ,REPAIR_ORDER_QUANTITY = decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ORDER_QUANTITY, p_REPAIR_ORDER_QUANTITY)

201: ,REPAIR_TYPE_ID = decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_TYPE_ID, p_REPAIR_TYPE_ID)
202: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
203: ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, NULL, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)
204: ,GROUP_QUANTITY = decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, GROUP_QUANTITY, p_GROUP_QUANTITY)
205: ,REPAIR_ORDER_QUANTITY = decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ORDER_QUANTITY, p_REPAIR_ORDER_QUANTITY)
206: ,RMA_QUANTITY = decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RMA_QUANTITY, p_RMA_QUANTITY)
207: ,RECEIVED_QUANTITY = decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RECEIVED_QUANTITY, p_RECEIVED_QUANTITY)
208: ,APPROVED_QUANTITY = decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, APPROVED_QUANTITY, p_APPROVED_QUANTITY)
209: ,SUBMITTED_QUANTITY = decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SUBMITTED_QUANTITY, p_SUBMITTED_QUANTITY)

Line 206: ,RMA_QUANTITY = decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RMA_QUANTITY, p_RMA_QUANTITY)

202: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
203: ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, NULL, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)
204: ,GROUP_QUANTITY = decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, GROUP_QUANTITY, p_GROUP_QUANTITY)
205: ,REPAIR_ORDER_QUANTITY = decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ORDER_QUANTITY, p_REPAIR_ORDER_QUANTITY)
206: ,RMA_QUANTITY = decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RMA_QUANTITY, p_RMA_QUANTITY)
207: ,RECEIVED_QUANTITY = decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RECEIVED_QUANTITY, p_RECEIVED_QUANTITY)
208: ,APPROVED_QUANTITY = decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, APPROVED_QUANTITY, p_APPROVED_QUANTITY)
209: ,SUBMITTED_QUANTITY = decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SUBMITTED_QUANTITY, p_SUBMITTED_QUANTITY)
210: ,COMPLETED_QUANTITY = decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, COMPLETED_QUANTITY, p_COMPLETED_QUANTITY)

Line 207: ,RECEIVED_QUANTITY = decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RECEIVED_QUANTITY, p_RECEIVED_QUANTITY)

203: ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, NULL, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)
204: ,GROUP_QUANTITY = decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, GROUP_QUANTITY, p_GROUP_QUANTITY)
205: ,REPAIR_ORDER_QUANTITY = decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ORDER_QUANTITY, p_REPAIR_ORDER_QUANTITY)
206: ,RMA_QUANTITY = decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RMA_QUANTITY, p_RMA_QUANTITY)
207: ,RECEIVED_QUANTITY = decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RECEIVED_QUANTITY, p_RECEIVED_QUANTITY)
208: ,APPROVED_QUANTITY = decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, APPROVED_QUANTITY, p_APPROVED_QUANTITY)
209: ,SUBMITTED_QUANTITY = decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SUBMITTED_QUANTITY, p_SUBMITTED_QUANTITY)
210: ,COMPLETED_QUANTITY = decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, COMPLETED_QUANTITY, p_COMPLETED_QUANTITY)
211: ,RELEASED_QUANTITY = decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RELEASED_QUANTITY, p_RELEASED_QUANTITY)

Line 208: ,APPROVED_QUANTITY = decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, APPROVED_QUANTITY, p_APPROVED_QUANTITY)

204: ,GROUP_QUANTITY = decode( p_GROUP_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, GROUP_QUANTITY, p_GROUP_QUANTITY)
205: ,REPAIR_ORDER_QUANTITY = decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ORDER_QUANTITY, p_REPAIR_ORDER_QUANTITY)
206: ,RMA_QUANTITY = decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RMA_QUANTITY, p_RMA_QUANTITY)
207: ,RECEIVED_QUANTITY = decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RECEIVED_QUANTITY, p_RECEIVED_QUANTITY)
208: ,APPROVED_QUANTITY = decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, APPROVED_QUANTITY, p_APPROVED_QUANTITY)
209: ,SUBMITTED_QUANTITY = decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SUBMITTED_QUANTITY, p_SUBMITTED_QUANTITY)
210: ,COMPLETED_QUANTITY = decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, COMPLETED_QUANTITY, p_COMPLETED_QUANTITY)
211: ,RELEASED_QUANTITY = decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RELEASED_QUANTITY, p_RELEASED_QUANTITY)
212: ,SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY)

Line 209: ,SUBMITTED_QUANTITY = decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SUBMITTED_QUANTITY, p_SUBMITTED_QUANTITY)

205: ,REPAIR_ORDER_QUANTITY = decode( p_REPAIR_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ORDER_QUANTITY, p_REPAIR_ORDER_QUANTITY)
206: ,RMA_QUANTITY = decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RMA_QUANTITY, p_RMA_QUANTITY)
207: ,RECEIVED_QUANTITY = decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RECEIVED_QUANTITY, p_RECEIVED_QUANTITY)
208: ,APPROVED_QUANTITY = decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, APPROVED_QUANTITY, p_APPROVED_QUANTITY)
209: ,SUBMITTED_QUANTITY = decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SUBMITTED_QUANTITY, p_SUBMITTED_QUANTITY)
210: ,COMPLETED_QUANTITY = decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, COMPLETED_QUANTITY, p_COMPLETED_QUANTITY)
211: ,RELEASED_QUANTITY = decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RELEASED_QUANTITY, p_RELEASED_QUANTITY)
212: ,SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY)
213: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)

Line 210: ,COMPLETED_QUANTITY = decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, COMPLETED_QUANTITY, p_COMPLETED_QUANTITY)

206: ,RMA_QUANTITY = decode( p_RMA_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RMA_QUANTITY, p_RMA_QUANTITY)
207: ,RECEIVED_QUANTITY = decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RECEIVED_QUANTITY, p_RECEIVED_QUANTITY)
208: ,APPROVED_QUANTITY = decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, APPROVED_QUANTITY, p_APPROVED_QUANTITY)
209: ,SUBMITTED_QUANTITY = decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SUBMITTED_QUANTITY, p_SUBMITTED_QUANTITY)
210: ,COMPLETED_QUANTITY = decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, COMPLETED_QUANTITY, p_COMPLETED_QUANTITY)
211: ,RELEASED_QUANTITY = decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RELEASED_QUANTITY, p_RELEASED_QUANTITY)
212: ,SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY)
213: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
214: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)

Line 211: ,RELEASED_QUANTITY = decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RELEASED_QUANTITY, p_RELEASED_QUANTITY)

207: ,RECEIVED_QUANTITY = decode( p_RECEIVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RECEIVED_QUANTITY, p_RECEIVED_QUANTITY)
208: ,APPROVED_QUANTITY = decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, APPROVED_QUANTITY, p_APPROVED_QUANTITY)
209: ,SUBMITTED_QUANTITY = decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SUBMITTED_QUANTITY, p_SUBMITTED_QUANTITY)
210: ,COMPLETED_QUANTITY = decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, COMPLETED_QUANTITY, p_COMPLETED_QUANTITY)
211: ,RELEASED_QUANTITY = decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RELEASED_QUANTITY, p_RELEASED_QUANTITY)
212: ,SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY)
213: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
214: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
215: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

Line 212: ,SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY)

208: ,APPROVED_QUANTITY = decode( p_APPROVED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, APPROVED_QUANTITY, p_APPROVED_QUANTITY)
209: ,SUBMITTED_QUANTITY = decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SUBMITTED_QUANTITY, p_SUBMITTED_QUANTITY)
210: ,COMPLETED_QUANTITY = decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, COMPLETED_QUANTITY, p_COMPLETED_QUANTITY)
211: ,RELEASED_QUANTITY = decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RELEASED_QUANTITY, p_RELEASED_QUANTITY)
212: ,SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY)
213: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
214: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
215: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
216: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

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

209: ,SUBMITTED_QUANTITY = decode( p_SUBMITTED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SUBMITTED_QUANTITY, p_SUBMITTED_QUANTITY)
210: ,COMPLETED_QUANTITY = decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, COMPLETED_QUANTITY, p_COMPLETED_QUANTITY)
211: ,RELEASED_QUANTITY = decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RELEASED_QUANTITY, p_RELEASED_QUANTITY)
212: ,SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY)
213: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
214: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
215: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
216: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
217: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

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

210: ,COMPLETED_QUANTITY = decode( p_COMPLETED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, COMPLETED_QUANTITY, p_COMPLETED_QUANTITY)
211: ,RELEASED_QUANTITY = decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RELEASED_QUANTITY, p_RELEASED_QUANTITY)
212: ,SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY)
213: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
214: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
215: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
216: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
217: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
218: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, NULL, CONTEXT, p_CONTEXT)

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

211: ,RELEASED_QUANTITY = decode( p_RELEASED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, RELEASED_QUANTITY, p_RELEASED_QUANTITY)
212: ,SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY)
213: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
214: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
215: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
216: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
217: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
218: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, NULL, CONTEXT, p_CONTEXT)
219: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)

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

212: ,SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY)
213: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
214: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
215: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
216: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
217: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
218: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, NULL, CONTEXT, p_CONTEXT)
219: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
220: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)

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

213: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
214: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
215: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
216: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
217: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
218: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, NULL, CONTEXT, p_CONTEXT)
219: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
220: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
221: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)

Line 218: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, NULL, CONTEXT, p_CONTEXT)

214: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
215: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
216: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
217: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
218: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, NULL, CONTEXT, p_CONTEXT)
219: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
220: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
221: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
222: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)

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

215: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
216: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
217: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
218: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, NULL, CONTEXT, p_CONTEXT)
219: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
220: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
221: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
222: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
223: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)

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

216: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
217: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
218: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, NULL, CONTEXT, p_CONTEXT)
219: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
220: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
221: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
222: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
223: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
224: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)

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

217: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
218: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, NULL, CONTEXT, p_CONTEXT)
219: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
220: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
221: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
222: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
223: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
224: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
225: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)

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

218: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, NULL, CONTEXT, p_CONTEXT)
219: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
220: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
221: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
222: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
223: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
224: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
225: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
226: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)

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

219: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
220: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
221: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
222: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
223: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
224: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
225: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
226: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
227: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)

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

220: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
221: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
222: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
223: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
224: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
225: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
226: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
227: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
228: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)

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

221: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
222: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
223: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
224: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
225: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
226: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
227: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
228: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
229: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)

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

222: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
223: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
224: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
225: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
226: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
227: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
228: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
229: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
230: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)

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

223: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
224: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
225: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
226: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
227: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
228: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
229: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
230: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
231: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)

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

224: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
225: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
226: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
227: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
228: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
229: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
230: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
231: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
232: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)

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

225: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
226: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
227: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
228: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
229: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
230: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
231: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
232: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
233: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)

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

226: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
227: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
228: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
229: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
230: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
231: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
232: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
233: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
234: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

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

227: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
228: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
229: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
230: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
231: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
232: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
233: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
234: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
235: ,GROUP_TXN_STATUS = decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_TXN_STATUS, p_GROUP_TXN_STATUS)

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

228: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
229: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
230: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
231: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
232: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
233: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
234: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
235: ,GROUP_TXN_STATUS = decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_TXN_STATUS, p_GROUP_TXN_STATUS)
236: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)

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

229: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
230: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
231: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
232: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
233: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
234: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
235: ,GROUP_TXN_STATUS = decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_TXN_STATUS, p_GROUP_TXN_STATUS)
236: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
237: ,GROUP_APPROVAL_STATUS = decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_APPROVAL_STATUS, p_GROUP_APPROVAL_STATUS)

Line 234: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

230: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
231: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
232: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
233: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
234: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
235: ,GROUP_TXN_STATUS = decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_TXN_STATUS, p_GROUP_TXN_STATUS)
236: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
237: ,GROUP_APPROVAL_STATUS = decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_APPROVAL_STATUS, p_GROUP_APPROVAL_STATUS)
238: ,REPAIR_MODE = decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_MODE, p_REPAIR_MODE)

Line 235: ,GROUP_TXN_STATUS = decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_TXN_STATUS, p_GROUP_TXN_STATUS)

231: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
232: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
233: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
234: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
235: ,GROUP_TXN_STATUS = decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_TXN_STATUS, p_GROUP_TXN_STATUS)
236: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
237: ,GROUP_APPROVAL_STATUS = decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_APPROVAL_STATUS, p_GROUP_APPROVAL_STATUS)
238: ,REPAIR_MODE = decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_MODE, p_REPAIR_MODE)
239: where REPAIR_GROUP_ID = p_REPAIR_GROUP_ID;

Line 236: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)

232: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
233: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
234: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
235: ,GROUP_TXN_STATUS = decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_TXN_STATUS, p_GROUP_TXN_STATUS)
236: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
237: ,GROUP_APPROVAL_STATUS = decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_APPROVAL_STATUS, p_GROUP_APPROVAL_STATUS)
238: ,REPAIR_MODE = decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_MODE, p_REPAIR_MODE)
239: where REPAIR_GROUP_ID = p_REPAIR_GROUP_ID;
240:

Line 237: ,GROUP_APPROVAL_STATUS = decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_APPROVAL_STATUS, p_GROUP_APPROVAL_STATUS)

233: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
234: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
235: ,GROUP_TXN_STATUS = decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_TXN_STATUS, p_GROUP_TXN_STATUS)
236: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
237: ,GROUP_APPROVAL_STATUS = decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_APPROVAL_STATUS, p_GROUP_APPROVAL_STATUS)
238: ,REPAIR_MODE = decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_MODE, p_REPAIR_MODE)
239: where REPAIR_GROUP_ID = p_REPAIR_GROUP_ID;
240:
241: If (SQL%NOTFOUND) then

Line 238: ,REPAIR_MODE = decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_MODE, p_REPAIR_MODE)

234: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
235: ,GROUP_TXN_STATUS = decode( p_GROUP_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_TXN_STATUS, p_GROUP_TXN_STATUS)
236: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
237: ,GROUP_APPROVAL_STATUS = decode( p_GROUP_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, NULL, GROUP_APPROVAL_STATUS, p_GROUP_APPROVAL_STATUS)
238: ,REPAIR_MODE = decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, NULL, REPAIR_MODE, p_REPAIR_MODE)
239: where REPAIR_GROUP_ID = p_REPAIR_GROUP_ID;
240:
241: If (SQL%NOTFOUND) then
242: RAISE NO_DATA_FOUND;