APPS.CSD_WIP_TRANSACTION_DTLS_PKG dependencies on FND_API

Line 63: ,p_CREATE_RO_FLAG VARCHAR2 := FND_API.G_MISS_CHAR --bug#13698799 auto create ro, parent ro

59: ,p_ATTRIBUTE12 VARCHAR2 := null
60: ,p_ATTRIBUTE13 VARCHAR2 := null
61: ,p_ATTRIBUTE14 VARCHAR2 := null
62: ,p_ATTRIBUTE15 VARCHAR2 := null
63: ,p_CREATE_RO_FLAG VARCHAR2 := FND_API.G_MISS_CHAR --bug#13698799 auto create ro, parent ro
64: )
65:
66: IS
67: CURSOR C2 IS SELECT CSD_WIP_TRANSACTION_DETAILS_S1.nextval FROM sys.dual;

Line 70: If (px_WIP_TRANSACTION_DETAIL_ID IS NULL) OR (px_WIP_TRANSACTION_DETAIL_ID = FND_API.G_MISS_NUM) then

66: IS
67: CURSOR C2 IS SELECT CSD_WIP_TRANSACTION_DETAILS_S1.nextval FROM sys.dual;
68: l_object_version_number NUMBER := 1;
69: BEGIN
70: If (px_WIP_TRANSACTION_DETAIL_ID IS NULL) OR (px_WIP_TRANSACTION_DETAIL_ID = FND_API.G_MISS_NUM) then
71: OPEN C2;
72: FETCH C2 INTO px_WIP_TRANSACTION_DETAIL_ID;
73: CLOSE C2;
74: End If;

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

123: -- end yvchen: bug 13258460
124: ,CREATE_RO_FLAG -- bug#13698799 auto create ro, parent ro
125: ) VALUES (
126: px_WIP_TRANSACTION_DETAIL_ID
127: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
128: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
129: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
130: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
131: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

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

124: ,CREATE_RO_FLAG -- bug#13698799 auto create ro, parent ro
125: ) VALUES (
126: px_WIP_TRANSACTION_DETAIL_ID
127: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
128: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
129: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
130: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
131: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
132: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)

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

125: ) VALUES (
126: px_WIP_TRANSACTION_DETAIL_ID
127: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
128: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
129: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
130: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
131: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
132: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
133: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)

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

126: px_WIP_TRANSACTION_DETAIL_ID
127: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
128: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
129: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
130: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
131: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
132: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
133: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
134: ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)

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

127: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
128: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
129: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
130: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
131: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
132: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
133: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
134: ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)
135: ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)

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

128: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
129: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
130: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
131: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
132: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
133: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
134: ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)
135: ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)
136: ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)

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

129: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
130: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
131: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
132: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
133: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
134: ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)
135: ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)
136: ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)
137: ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)

Line 134: ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)

130: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
131: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
132: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
133: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
134: ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)
135: ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)
136: ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)
137: ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)
138: ,decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM)

Line 135: ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)

131: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
132: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
133: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
134: ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)
135: ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)
136: ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)
137: ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)
138: ,decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM)
139: ,decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER)

Line 136: ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)

132: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
133: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
134: ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)
135: ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)
136: ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)
137: ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)
138: ,decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM)
139: ,decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER)
140: -- swai: bug 7182047 (FP of 6995498) added item revision

Line 137: ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)

133: ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
134: ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)
135: ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)
136: ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)
137: ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)
138: ,decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM)
139: ,decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER)
140: -- swai: bug 7182047 (FP of 6995498) added item revision
141: ,decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION)

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

134: ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)
135: ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)
136: ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)
137: ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)
138: ,decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM)
139: ,decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER)
140: -- swai: bug 7182047 (FP of 6995498) added item revision
141: ,decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION)
142: -- end swai: bug 7182047 (FP of 6995498) added item revision

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

135: ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)
136: ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)
137: ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)
138: ,decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM)
139: ,decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER)
140: -- swai: bug 7182047 (FP of 6995498) added item revision
141: ,decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION)
142: -- end swai: bug 7182047 (FP of 6995498) added item revision
143: -- swai bug 6841113: added material txn reason code

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

137: ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)
138: ,decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM)
139: ,decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER)
140: -- swai: bug 7182047 (FP of 6995498) added item revision
141: ,decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION)
142: -- end swai: bug 7182047 (FP of 6995498) added item revision
143: -- swai bug 6841113: added material txn reason code
144: ,decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, p_REASON_ID)
145: -- end swai bug 6841113: added material txn reason code

Line 144: ,decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, p_REASON_ID)

140: -- swai: bug 7182047 (FP of 6995498) added item revision
141: ,decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION)
142: -- end swai: bug 7182047 (FP of 6995498) added item revision
143: -- swai bug 6841113: added material txn reason code
144: ,decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, p_REASON_ID)
145: -- end swai bug 6841113: added material txn reason code
146: -- swai: added code for operations
147: ,decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, p_BACKFLUSH_FLAG)
148: ,decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, p_COUNT_POINT_TYPE)

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

143: -- swai bug 6841113: added material txn reason code
144: ,decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, p_REASON_ID)
145: -- end swai bug 6841113: added material txn reason code
146: -- swai: added code for operations
147: ,decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, p_BACKFLUSH_FLAG)
148: ,decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, p_COUNT_POINT_TYPE)
149: ,decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID)
150: ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
151: ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)

Line 148: ,decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, p_COUNT_POINT_TYPE)

144: ,decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, p_REASON_ID)
145: -- end swai bug 6841113: added material txn reason code
146: -- swai: added code for operations
147: ,decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, p_BACKFLUSH_FLAG)
148: ,decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, p_COUNT_POINT_TYPE)
149: ,decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID)
150: ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
151: ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)
152: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)

Line 149: ,decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID)

145: -- end swai bug 6841113: added material txn reason code
146: -- swai: added code for operations
147: ,decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, p_BACKFLUSH_FLAG)
148: ,decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, p_COUNT_POINT_TYPE)
149: ,decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID)
150: ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
151: ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)
152: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
153: ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)

Line 150: ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)

146: -- swai: added code for operations
147: ,decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, p_BACKFLUSH_FLAG)
148: ,decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, p_COUNT_POINT_TYPE)
149: ,decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID)
150: ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
151: ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)
152: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
153: ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)
154: ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)

Line 151: ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)

147: ,decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, p_BACKFLUSH_FLAG)
148: ,decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, p_COUNT_POINT_TYPE)
149: ,decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID)
150: ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
151: ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)
152: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
153: ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)
154: ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)
155: ,decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_TRANSFER_QUANTITY)

Line 152: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)

148: ,decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, p_COUNT_POINT_TYPE)
149: ,decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID)
150: ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
151: ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)
152: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
153: ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)
154: ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)
155: ,decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_TRANSFER_QUANTITY)
156: ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)

Line 153: ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)

149: ,decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID)
150: ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
151: ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)
152: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
153: ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)
154: ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)
155: ,decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_TRANSFER_QUANTITY)
156: ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)
157: -- end swai: added code for operations

Line 154: ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)

150: ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
151: ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)
152: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
153: ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)
154: ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)
155: ,decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_TRANSFER_QUANTITY)
156: ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)
157: -- end swai: added code for operations
158: ,l_object_version_number

Line 155: ,decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_TRANSFER_QUANTITY)

151: ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)
152: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
153: ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)
154: ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)
155: ,decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_TRANSFER_QUANTITY)
156: ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)
157: -- end swai: added code for operations
158: ,l_object_version_number
159: -- yvchen: bug 13258460

Line 156: ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)

152: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
153: ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)
154: ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)
155: ,decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_TRANSFER_QUANTITY)
156: ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)
157: -- end swai: added code for operations
158: ,l_object_version_number
159: -- yvchen: bug 13258460
160: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details

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

157: -- end swai: added code for operations
158: ,l_object_version_number
159: -- yvchen: bug 13258460
160: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
161: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
162: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
163: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
164: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
165: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

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

158: ,l_object_version_number
159: -- yvchen: bug 13258460
160: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
161: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
162: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
163: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
164: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
165: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
166: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

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

159: -- yvchen: bug 13258460
160: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
161: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
162: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
163: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
164: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
165: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
166: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
167: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

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

160: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
161: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
162: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
163: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
164: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
165: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
166: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
167: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
168: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

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

161: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
162: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
163: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
164: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
165: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
166: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
167: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
168: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
169: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

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

162: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
163: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
164: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
165: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
166: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
167: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
168: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
169: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
170: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

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

163: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
164: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
165: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
166: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
167: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
168: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
169: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
170: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
171: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

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

164: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
165: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
166: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
167: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
168: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
169: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
170: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
171: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
172: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

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

165: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
166: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
167: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
168: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
169: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
170: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
171: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
172: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
173: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

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

166: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
167: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
168: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
169: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
170: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
171: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
172: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
173: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
174: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

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

167: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
168: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
169: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
170: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
171: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
172: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
173: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
174: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
175: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

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

168: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
169: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
170: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
171: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
172: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
173: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
174: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
175: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
176: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

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

169: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
170: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
171: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
172: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
173: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
174: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
175: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
176: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
177: -- end yvchen: bug 13258460

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

170: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
171: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
172: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
173: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
174: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
175: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
176: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
177: -- end yvchen: bug 13258460
178: ,decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro

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

171: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
172: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
173: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
174: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
175: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
176: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
177: -- end yvchen: bug 13258460
178: ,decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro
179: );

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

172: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
173: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
174: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
175: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
176: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
177: -- end yvchen: bug 13258460
178: ,decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro
179: );
180: End Insert_Row;

Line 178: ,decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro

174: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
175: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
176: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
177: -- end yvchen: bug 13258460
178: ,decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro
179: );
180: End Insert_Row;
181:
182: PROCEDURE Update_Row(

Line 232: ,p_CREATE_RO_FLAG VARCHAR2 := FND_API.G_MISS_CHAR --bug#13698799 auto create ro, parent ro

228: ,p_ATTRIBUTE12 VARCHAR2 := null
229: ,p_ATTRIBUTE13 VARCHAR2 := null
230: ,p_ATTRIBUTE14 VARCHAR2 := null
231: ,p_ATTRIBUTE15 VARCHAR2 := null
232: ,p_CREATE_RO_FLAG VARCHAR2 := FND_API.G_MISS_CHAR --bug#13698799 auto create ro, parent ro
233: )
234:
235: IS
236: BEGIN

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

235: IS
236: BEGIN
237: Update CSD_WIP_TRANSACTION_DETAILS
238: SET
239: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
240: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
241: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
242: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
243: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

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

236: BEGIN
237: Update CSD_WIP_TRANSACTION_DETAILS
238: SET
239: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
240: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
241: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
242: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
243: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
244: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)

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

237: Update CSD_WIP_TRANSACTION_DETAILS
238: SET
239: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
240: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
241: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
242: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
243: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
244: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
245: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)

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

238: SET
239: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
240: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
241: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
242: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
243: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
244: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
245: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
246: ,OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)

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

239: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
240: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
241: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
242: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
243: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
244: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
245: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
246: ,OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)
247: ,RESOURCE_SEQ_NUM = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)

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

240: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
241: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
242: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
243: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
244: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
245: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
246: ,OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)
247: ,RESOURCE_SEQ_NUM = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)
248: ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)

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

241: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
242: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
243: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
244: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
245: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
246: ,OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)
247: ,RESOURCE_SEQ_NUM = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)
248: ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)
249: ,TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)

Line 246: ,OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)

242: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
243: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
244: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
245: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
246: ,OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)
247: ,RESOURCE_SEQ_NUM = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)
248: ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)
249: ,TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)
250: ,TRANSACTION_UOM = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, NULL, TRANSACTION_UOM, p_TRANSACTION_UOM)

Line 247: ,RESOURCE_SEQ_NUM = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)

243: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
244: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
245: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
246: ,OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)
247: ,RESOURCE_SEQ_NUM = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)
248: ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)
249: ,TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)
250: ,TRANSACTION_UOM = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, NULL, TRANSACTION_UOM, p_TRANSACTION_UOM)
251: ,SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, SERIAL_NUMBER, p_SERIAL_NUMBER)

Line 248: ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)

244: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
245: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
246: ,OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)
247: ,RESOURCE_SEQ_NUM = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)
248: ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)
249: ,TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)
250: ,TRANSACTION_UOM = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, NULL, TRANSACTION_UOM, p_TRANSACTION_UOM)
251: ,SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, SERIAL_NUMBER, p_SERIAL_NUMBER)
252: -- swai: bug 7182047 (FP of 6995498) added item revision

Line 249: ,TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)

245: ,WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
246: ,OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)
247: ,RESOURCE_SEQ_NUM = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)
248: ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)
249: ,TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)
250: ,TRANSACTION_UOM = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, NULL, TRANSACTION_UOM, p_TRANSACTION_UOM)
251: ,SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, SERIAL_NUMBER, p_SERIAL_NUMBER)
252: -- swai: bug 7182047 (FP of 6995498) added item revision
253: ,REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, NULL, REVISION, p_REVISION)

Line 250: ,TRANSACTION_UOM = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, NULL, TRANSACTION_UOM, p_TRANSACTION_UOM)

246: ,OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)
247: ,RESOURCE_SEQ_NUM = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)
248: ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)
249: ,TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)
250: ,TRANSACTION_UOM = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, NULL, TRANSACTION_UOM, p_TRANSACTION_UOM)
251: ,SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, SERIAL_NUMBER, p_SERIAL_NUMBER)
252: -- swai: bug 7182047 (FP of 6995498) added item revision
253: ,REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, NULL, REVISION, p_REVISION)
254: -- end swai: bug 7182047 (FP of 6995498) added item revision

Line 251: ,SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, SERIAL_NUMBER, p_SERIAL_NUMBER)

247: ,RESOURCE_SEQ_NUM = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)
248: ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)
249: ,TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)
250: ,TRANSACTION_UOM = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, NULL, TRANSACTION_UOM, p_TRANSACTION_UOM)
251: ,SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, SERIAL_NUMBER, p_SERIAL_NUMBER)
252: -- swai: bug 7182047 (FP of 6995498) added item revision
253: ,REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, NULL, REVISION, p_REVISION)
254: -- end swai: bug 7182047 (FP of 6995498) added item revision
255: -- swai bug 6841113: added material txn reason code

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

249: ,TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)
250: ,TRANSACTION_UOM = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, NULL, TRANSACTION_UOM, p_TRANSACTION_UOM)
251: ,SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, SERIAL_NUMBER, p_SERIAL_NUMBER)
252: -- swai: bug 7182047 (FP of 6995498) added item revision
253: ,REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, NULL, REVISION, p_REVISION)
254: -- end swai: bug 7182047 (FP of 6995498) added item revision
255: -- swai bug 6841113: added material txn reason code
256: ,REASON_ID = decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, NULL, REASON_ID, p_REASON_ID)
257: -- end swai bug 6841113: added material txn reason code

Line 256: ,REASON_ID = decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, NULL, REASON_ID, p_REASON_ID)

252: -- swai: bug 7182047 (FP of 6995498) added item revision
253: ,REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, NULL, REVISION, p_REVISION)
254: -- end swai: bug 7182047 (FP of 6995498) added item revision
255: -- swai bug 6841113: added material txn reason code
256: ,REASON_ID = decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, NULL, REASON_ID, p_REASON_ID)
257: -- end swai bug 6841113: added material txn reason code
258: -- swai: added code for operations
259: ,BACKFLUSH_FLAG = decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, NULL, BACKFLUSH_FLAG, p_BACKFLUSH_FLAG)
260: ,COUNT_POINT_TYPE = decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, NULL, COUNT_POINT_TYPE, p_COUNT_POINT_TYPE)

Line 259: ,BACKFLUSH_FLAG = decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, NULL, BACKFLUSH_FLAG, p_BACKFLUSH_FLAG)

255: -- swai bug 6841113: added material txn reason code
256: ,REASON_ID = decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, NULL, REASON_ID, p_REASON_ID)
257: -- end swai bug 6841113: added material txn reason code
258: -- swai: added code for operations
259: ,BACKFLUSH_FLAG = decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, NULL, BACKFLUSH_FLAG, p_BACKFLUSH_FLAG)
260: ,COUNT_POINT_TYPE = decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, NULL, COUNT_POINT_TYPE, p_COUNT_POINT_TYPE)
261: ,DEPARTMENT_ID = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, NULL, DEPARTMENT_ID, p_DEPARTMENT_ID)
262: ,DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)
263: ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)

Line 260: ,COUNT_POINT_TYPE = decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, NULL, COUNT_POINT_TYPE, p_COUNT_POINT_TYPE)

256: ,REASON_ID = decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, NULL, REASON_ID, p_REASON_ID)
257: -- end swai bug 6841113: added material txn reason code
258: -- swai: added code for operations
259: ,BACKFLUSH_FLAG = decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, NULL, BACKFLUSH_FLAG, p_BACKFLUSH_FLAG)
260: ,COUNT_POINT_TYPE = decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, NULL, COUNT_POINT_TYPE, p_COUNT_POINT_TYPE)
261: ,DEPARTMENT_ID = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, NULL, DEPARTMENT_ID, p_DEPARTMENT_ID)
262: ,DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)
263: ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)
264: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)

Line 261: ,DEPARTMENT_ID = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, NULL, DEPARTMENT_ID, p_DEPARTMENT_ID)

257: -- end swai bug 6841113: added material txn reason code
258: -- swai: added code for operations
259: ,BACKFLUSH_FLAG = decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, NULL, BACKFLUSH_FLAG, p_BACKFLUSH_FLAG)
260: ,COUNT_POINT_TYPE = decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, NULL, COUNT_POINT_TYPE, p_COUNT_POINT_TYPE)
261: ,DEPARTMENT_ID = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, NULL, DEPARTMENT_ID, p_DEPARTMENT_ID)
262: ,DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)
263: ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)
264: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
265: ,LAST_UNIT_COMPLETION_DATE = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)

Line 262: ,DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)

258: -- swai: added code for operations
259: ,BACKFLUSH_FLAG = decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, NULL, BACKFLUSH_FLAG, p_BACKFLUSH_FLAG)
260: ,COUNT_POINT_TYPE = decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, NULL, COUNT_POINT_TYPE, p_COUNT_POINT_TYPE)
261: ,DEPARTMENT_ID = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, NULL, DEPARTMENT_ID, p_DEPARTMENT_ID)
262: ,DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)
263: ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)
264: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
265: ,LAST_UNIT_COMPLETION_DATE = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)
266: ,LAST_UNIT_START_DATE = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)

Line 263: ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)

259: ,BACKFLUSH_FLAG = decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, NULL, BACKFLUSH_FLAG, p_BACKFLUSH_FLAG)
260: ,COUNT_POINT_TYPE = decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, NULL, COUNT_POINT_TYPE, p_COUNT_POINT_TYPE)
261: ,DEPARTMENT_ID = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, NULL, DEPARTMENT_ID, p_DEPARTMENT_ID)
262: ,DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)
263: ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)
264: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
265: ,LAST_UNIT_COMPLETION_DATE = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)
266: ,LAST_UNIT_START_DATE = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)
267: ,MINIMUM_TRANSFER_QUANTITY = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)

Line 264: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)

260: ,COUNT_POINT_TYPE = decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, NULL, COUNT_POINT_TYPE, p_COUNT_POINT_TYPE)
261: ,DEPARTMENT_ID = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, NULL, DEPARTMENT_ID, p_DEPARTMENT_ID)
262: ,DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)
263: ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)
264: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
265: ,LAST_UNIT_COMPLETION_DATE = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)
266: ,LAST_UNIT_START_DATE = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)
267: ,MINIMUM_TRANSFER_QUANTITY = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)
268: ,STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)

Line 265: ,LAST_UNIT_COMPLETION_DATE = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)

261: ,DEPARTMENT_ID = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, NULL, DEPARTMENT_ID, p_DEPARTMENT_ID)
262: ,DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)
263: ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)
264: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
265: ,LAST_UNIT_COMPLETION_DATE = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)
266: ,LAST_UNIT_START_DATE = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)
267: ,MINIMUM_TRANSFER_QUANTITY = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)
268: ,STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)
269: -- end swai: added code for operations

Line 266: ,LAST_UNIT_START_DATE = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)

262: ,DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)
263: ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)
264: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
265: ,LAST_UNIT_COMPLETION_DATE = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)
266: ,LAST_UNIT_START_DATE = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)
267: ,MINIMUM_TRANSFER_QUANTITY = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)
268: ,STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)
269: -- end swai: added code for operations
270: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

Line 267: ,MINIMUM_TRANSFER_QUANTITY = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)

263: ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)
264: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
265: ,LAST_UNIT_COMPLETION_DATE = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)
266: ,LAST_UNIT_START_DATE = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)
267: ,MINIMUM_TRANSFER_QUANTITY = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)
268: ,STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)
269: -- end swai: added code for operations
270: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
271: -- yvchen: bug 13258460

Line 268: ,STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)

264: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
265: ,LAST_UNIT_COMPLETION_DATE = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)
266: ,LAST_UNIT_START_DATE = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)
267: ,MINIMUM_TRANSFER_QUANTITY = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)
268: ,STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)
269: -- end swai: added code for operations
270: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
271: -- yvchen: bug 13258460
272: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details

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

266: ,LAST_UNIT_START_DATE = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)
267: ,MINIMUM_TRANSFER_QUANTITY = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)
268: ,STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)
269: -- end swai: added code for operations
270: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
271: -- yvchen: bug 13258460
272: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
273: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
274: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)

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

269: -- end swai: added code for operations
270: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
271: -- yvchen: bug 13258460
272: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
273: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
274: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
275: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
276: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
277: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)

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

270: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
271: -- yvchen: bug 13258460
272: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
273: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
274: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
275: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
276: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
277: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
278: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)

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

271: -- yvchen: bug 13258460
272: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
273: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
274: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
275: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
276: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
277: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
278: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
279: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)

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

272: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
273: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
274: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
275: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
276: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
277: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
278: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
279: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
280: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)

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

273: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
274: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
275: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
276: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
277: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
278: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
279: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
280: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
281: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)

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

274: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
275: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
276: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
277: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
278: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
279: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
280: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
281: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
282: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)

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

275: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
276: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
277: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
278: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
279: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
280: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
281: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
282: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
283: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)

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

276: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
277: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
278: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
279: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
280: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
281: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
282: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
283: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
284: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)

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

277: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
278: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
279: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
280: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
281: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
282: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
283: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
284: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
285: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)

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

278: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
279: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
280: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
281: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
282: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
283: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
284: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
285: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
286: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)

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

279: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
280: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
281: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
282: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
283: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
284: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
285: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
286: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
287: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)

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

280: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
281: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
282: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
283: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
284: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
285: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
286: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
287: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
288: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)

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

281: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
282: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
283: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
284: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
285: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
286: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
287: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
288: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
289: -- end yvchen: bug 13258460

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

282: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
283: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
284: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
285: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
286: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
287: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
288: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
289: -- end yvchen: bug 13258460
290: ,CREATE_RO_FLAG = decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, CREATE_RO_FLAG, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro

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

283: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
284: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
285: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
286: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
287: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
288: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
289: -- end yvchen: bug 13258460
290: ,CREATE_RO_FLAG = decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, CREATE_RO_FLAG, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro
291:

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

284: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
285: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
286: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
287: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
288: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
289: -- end yvchen: bug 13258460
290: ,CREATE_RO_FLAG = decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, CREATE_RO_FLAG, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro
291:
292: where WIP_TRANSACTION_DETAIL_ID = p_WIP_TRANSACTION_DETAIL_ID;

Line 290: ,CREATE_RO_FLAG = decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, CREATE_RO_FLAG, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro

286: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
287: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
288: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
289: -- end yvchen: bug 13258460
290: ,CREATE_RO_FLAG = decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, CREATE_RO_FLAG, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro
291:
292: where WIP_TRANSACTION_DETAIL_ID = p_WIP_TRANSACTION_DETAIL_ID;
293:
294: If (SQL%NOTFOUND) then