APPS.CSD_PRODUCT_TRANSACTIONS_PKG dependencies on FND_API

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

66: CURSOR C2 IS SELECT CSD_PRODUCT_TRANSACTIONS_S1.nextval FROM sys.dual;
67: BEGIN
68: -- Since Product transaction id is a primary key, it is good if value is always
69: -- generated from a sequence. This is to fix bug 3215153 saupadhy
70: -- If (px_PRODUCT_TRANSACTION_ID IS NULL) OR (px_PRODUCT_TRANSACTION_ID = FND_API.G_MISS_NUM) then
71: OPEN C2;
72: FETCH C2 INTO px_PRODUCT_TRANSACTION_ID;
73: CLOSE C2;
74: -- End If;

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

129: )
130: VALUES (
131: px_PRODUCT_TRANSACTION_ID,
132: p_REPAIR_LINE_ID,
133: decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID),
134: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
135: decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTION_CODE),
136: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
137: decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUB_INVENTORY),

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

130: VALUES (
131: px_PRODUCT_TRANSACTION_ID,
132: p_REPAIR_LINE_ID,
133: decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID),
134: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
135: decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTION_CODE),
136: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
137: decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUB_INVENTORY),
138: decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, NULL, p_INTERFACE_TO_OM_FLAG),

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

131: px_PRODUCT_TRANSACTION_ID,
132: p_REPAIR_LINE_ID,
133: decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID),
134: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
135: decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTION_CODE),
136: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
137: decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUB_INVENTORY),
138: decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, NULL, p_INTERFACE_TO_OM_FLAG),
139: decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_BOOK_SALES_ORDER_FLAG),

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

132: p_REPAIR_LINE_ID,
133: decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID),
134: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
135: decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTION_CODE),
136: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
137: decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUB_INVENTORY),
138: decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, NULL, p_INTERFACE_TO_OM_FLAG),
139: decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_BOOK_SALES_ORDER_FLAG),
140: decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_RELEASE_SALES_ORDER_FLAG),

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

133: decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID),
134: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
135: decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTION_CODE),
136: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
137: decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUB_INVENTORY),
138: decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, NULL, p_INTERFACE_TO_OM_FLAG),
139: decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_BOOK_SALES_ORDER_FLAG),
140: decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_RELEASE_SALES_ORDER_FLAG),
141: decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_SALES_ORDER_FLAG),

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

134: decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ACTION_TYPE),
135: decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTION_CODE),
136: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
137: decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUB_INVENTORY),
138: decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, NULL, p_INTERFACE_TO_OM_FLAG),
139: decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_BOOK_SALES_ORDER_FLAG),
140: decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_RELEASE_SALES_ORDER_FLAG),
141: decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_SALES_ORDER_FLAG),
142: decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_STATUS),

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

135: decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTION_CODE),
136: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
137: decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUB_INVENTORY),
138: decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, NULL, p_INTERFACE_TO_OM_FLAG),
139: decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_BOOK_SALES_ORDER_FLAG),
140: decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_RELEASE_SALES_ORDER_FLAG),
141: decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_SALES_ORDER_FLAG),
142: decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_STATUS),
143: decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_CODE),

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

136: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
137: decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUB_INVENTORY),
138: decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, NULL, p_INTERFACE_TO_OM_FLAG),
139: decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_BOOK_SALES_ORDER_FLAG),
140: decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_RELEASE_SALES_ORDER_FLAG),
141: decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_SALES_ORDER_FLAG),
142: decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_STATUS),
143: decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_CODE),
144: p_LAST_UPDATE_DATE,

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

137: decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUB_INVENTORY),
138: decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, NULL, p_INTERFACE_TO_OM_FLAG),
139: decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_BOOK_SALES_ORDER_FLAG),
140: decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_RELEASE_SALES_ORDER_FLAG),
141: decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_SALES_ORDER_FLAG),
142: decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_STATUS),
143: decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_CODE),
144: p_LAST_UPDATE_DATE,
145: p_CREATION_DATE,

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

138: decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, NULL, p_INTERFACE_TO_OM_FLAG),
139: decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_BOOK_SALES_ORDER_FLAG),
140: decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_RELEASE_SALES_ORDER_FLAG),
141: decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_SALES_ORDER_FLAG),
142: decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_STATUS),
143: decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_CODE),
144: p_LAST_UPDATE_DATE,
145: p_CREATION_DATE,
146: p_LAST_UPDATED_BY,

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

139: decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_BOOK_SALES_ORDER_FLAG),
140: decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_RELEASE_SALES_ORDER_FLAG),
141: decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_SALES_ORDER_FLAG),
142: decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_STATUS),
143: decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, NULL, p_PROD_TXN_CODE),
144: p_LAST_UPDATE_DATE,
145: p_CREATION_DATE,
146: p_LAST_UPDATED_BY,
147: p_CREATED_BY,

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

144: p_LAST_UPDATE_DATE,
145: p_CREATION_DATE,
146: p_LAST_UPDATED_BY,
147: p_CREATED_BY,
148: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
149: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
150: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
151: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
152: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

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

145: p_CREATION_DATE,
146: p_LAST_UPDATED_BY,
147: p_CREATED_BY,
148: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
149: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
150: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
151: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
152: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
153: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

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

146: p_LAST_UPDATED_BY,
147: p_CREATED_BY,
148: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
149: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
150: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
151: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
152: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
153: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
154: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

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

147: p_CREATED_BY,
148: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
149: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
150: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
151: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
152: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
153: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
154: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
155: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

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

148: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
149: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
150: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
151: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
152: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
153: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
154: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
155: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
156: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

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

149: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
150: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
151: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
152: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
153: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
154: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
155: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
156: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
157: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

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

150: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
151: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
152: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
153: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
154: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
155: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
156: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
157: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
158: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

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

151: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
152: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
153: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
154: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
155: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
156: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
157: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
158: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
159: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

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

152: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
153: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
154: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
155: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
156: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
157: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
158: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
159: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
160: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

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

153: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
154: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
155: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
156: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
157: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
158: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
159: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
160: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
161: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

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

154: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
155: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
156: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
157: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
158: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
159: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
160: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
161: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
162: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

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

155: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
156: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
157: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
158: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
159: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
160: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
161: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
162: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
163: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

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

156: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
157: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
158: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
159: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
160: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
161: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
162: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
163: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
164: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),

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

157: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
158: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
159: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
160: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
161: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
162: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
163: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
164: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
165: p_OBJECT_VERSION_NUMBER,

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

158: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
159: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
160: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
161: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
162: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
163: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
164: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
165: p_OBJECT_VERSION_NUMBER,
166: decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Header_Id),

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

159: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
160: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
161: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
162: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
163: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
164: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
165: p_OBJECT_VERSION_NUMBER,
166: decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Header_Id),
167: decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Line_Id),

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

160: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
161: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
162: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
163: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
164: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
165: p_OBJECT_VERSION_NUMBER,
166: decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Header_Id),
167: decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Line_Id),
168: decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Header_Id),

Line 166: decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Header_Id),

162: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
163: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
164: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
165: p_OBJECT_VERSION_NUMBER,
166: decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Header_Id),
167: decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Line_Id),
168: decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Header_Id),
169: decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Line_Id),
170: decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Received),

Line 167: decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Line_Id),

163: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
164: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
165: p_OBJECT_VERSION_NUMBER,
166: decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Header_Id),
167: decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Line_Id),
168: decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Header_Id),
169: decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Line_Id),
170: decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Received),
171: decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Shipped),

Line 168: decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Header_Id),

164: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
165: p_OBJECT_VERSION_NUMBER,
166: decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Header_Id),
167: decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Line_Id),
168: decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Header_Id),
169: decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Line_Id),
170: decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Received),
171: decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Shipped),
172: decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Source_Serial_Number) ,

Line 169: decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Line_Id),

165: p_OBJECT_VERSION_NUMBER,
166: decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Header_Id),
167: decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Line_Id),
168: decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Header_Id),
169: decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Line_Id),
170: decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Received),
171: decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Shipped),
172: decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Source_Serial_Number) ,
173: decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Source_Instance_Id) ,

Line 170: decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Received),

166: decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Header_Id),
167: decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Line_Id),
168: decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Header_Id),
169: decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Line_Id),
170: decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Received),
171: decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Shipped),
172: decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Source_Serial_Number) ,
173: decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Source_Instance_Id) ,
174: decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Non_Source_Serial_Number) ,

Line 171: decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Shipped),

167: decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Req_Line_Id),
168: decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Header_Id),
169: decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Line_Id),
170: decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Received),
171: decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Shipped),
172: decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Source_Serial_Number) ,
173: decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Source_Instance_Id) ,
174: decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Non_Source_Serial_Number) ,
175: decode(p_Non_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Non_Source_Instance_ID) ,

Line 172: decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Source_Serial_Number) ,

168: decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Header_Id),
169: decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Line_Id),
170: decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Received),
171: decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Shipped),
172: decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Source_Serial_Number) ,
173: decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Source_Instance_Id) ,
174: decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Non_Source_Serial_Number) ,
175: decode(p_Non_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Non_Source_Instance_ID) ,
176: decode(p_Locator_Id , Fnd_API.G_MISS_NUM,NULL,p_Locator_Id),

Line 173: decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Source_Instance_Id) ,

169: decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,NULL,p_Order_Line_Id),
170: decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Received),
171: decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Shipped),
172: decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Source_Serial_Number) ,
173: decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Source_Instance_Id) ,
174: decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Non_Source_Serial_Number) ,
175: decode(p_Non_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Non_Source_Instance_ID) ,
176: decode(p_Locator_Id , Fnd_API.G_MISS_NUM,NULL,p_Locator_Id),
177: decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Sub_Inventory_Rcvd),

Line 174: decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Non_Source_Serial_Number) ,

170: decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Received),
171: decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Shipped),
172: decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Source_Serial_Number) ,
173: decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Source_Instance_Id) ,
174: decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Non_Source_Serial_Number) ,
175: decode(p_Non_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Non_Source_Instance_ID) ,
176: decode(p_Locator_Id , Fnd_API.G_MISS_NUM,NULL,p_Locator_Id),
177: decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Sub_Inventory_Rcvd),
178: decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Lot_Number_rcvd),

Line 175: decode(p_Non_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Non_Source_Instance_ID) ,

171: decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,NULL,p_Prd_Txn_Qty_Shipped),
172: decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Source_Serial_Number) ,
173: decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Source_Instance_Id) ,
174: decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Non_Source_Serial_Number) ,
175: decode(p_Non_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Non_Source_Instance_ID) ,
176: decode(p_Locator_Id , Fnd_API.G_MISS_NUM,NULL,p_Locator_Id),
177: decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Sub_Inventory_Rcvd),
178: decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Lot_Number_rcvd),
179: decode(p_picking_rule_id,Fnd_API.G_MISS_CHAR,NULL,p_picking_rule_id),

Line 176: decode(p_Locator_Id , Fnd_API.G_MISS_NUM,NULL,p_Locator_Id),

172: decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Source_Serial_Number) ,
173: decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Source_Instance_Id) ,
174: decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Non_Source_Serial_Number) ,
175: decode(p_Non_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Non_Source_Instance_ID) ,
176: decode(p_Locator_Id , Fnd_API.G_MISS_NUM,NULL,p_Locator_Id),
177: decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Sub_Inventory_Rcvd),
178: decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Lot_Number_rcvd),
179: decode(p_picking_rule_id,Fnd_API.G_MISS_CHAR,NULL,p_picking_rule_id),
180: decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,NULL,P_PROJECT_ID),

Line 177: decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Sub_Inventory_Rcvd),

173: decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Source_Instance_Id) ,
174: decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Non_Source_Serial_Number) ,
175: decode(p_Non_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Non_Source_Instance_ID) ,
176: decode(p_Locator_Id , Fnd_API.G_MISS_NUM,NULL,p_Locator_Id),
177: decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Sub_Inventory_Rcvd),
178: decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Lot_Number_rcvd),
179: decode(p_picking_rule_id,Fnd_API.G_MISS_CHAR,NULL,p_picking_rule_id),
180: decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,NULL,P_PROJECT_ID),
181: decode(P_TASK_ID,Fnd_API.G_MISS_NUM,NULL,P_TASK_ID),

Line 178: decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Lot_Number_rcvd),

174: decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,NULL,p_Non_Source_Serial_Number) ,
175: decode(p_Non_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Non_Source_Instance_ID) ,
176: decode(p_Locator_Id , Fnd_API.G_MISS_NUM,NULL,p_Locator_Id),
177: decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Sub_Inventory_Rcvd),
178: decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Lot_Number_rcvd),
179: decode(p_picking_rule_id,Fnd_API.G_MISS_CHAR,NULL,p_picking_rule_id),
180: decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,NULL,P_PROJECT_ID),
181: decode(P_TASK_ID,Fnd_API.G_MISS_NUM,NULL,P_TASK_ID),
182: decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,NULL,P_UNIT_NUMBER),

Line 179: decode(p_picking_rule_id,Fnd_API.G_MISS_CHAR,NULL,p_picking_rule_id),

175: decode(p_Non_Source_Instance_ID,Fnd_API.G_MISS_NUM,NULL,p_Non_Source_Instance_ID) ,
176: decode(p_Locator_Id , Fnd_API.G_MISS_NUM,NULL,p_Locator_Id),
177: decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Sub_Inventory_Rcvd),
178: decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Lot_Number_rcvd),
179: decode(p_picking_rule_id,Fnd_API.G_MISS_CHAR,NULL,p_picking_rule_id),
180: decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,NULL,P_PROJECT_ID),
181: decode(P_TASK_ID,Fnd_API.G_MISS_NUM,NULL,P_TASK_ID),
182: decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,NULL,P_UNIT_NUMBER),
183: --taklam

Line 180: decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,NULL,P_PROJECT_ID),

176: decode(p_Locator_Id , Fnd_API.G_MISS_NUM,NULL,p_Locator_Id),
177: decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Sub_Inventory_Rcvd),
178: decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Lot_Number_rcvd),
179: decode(p_picking_rule_id,Fnd_API.G_MISS_CHAR,NULL,p_picking_rule_id),
180: decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,NULL,P_PROJECT_ID),
181: decode(P_TASK_ID,Fnd_API.G_MISS_NUM,NULL,P_TASK_ID),
182: decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,NULL,P_UNIT_NUMBER),
183: --taklam
184: -- swai: bug 6148019

Line 181: decode(P_TASK_ID,Fnd_API.G_MISS_NUM,NULL,P_TASK_ID),

177: decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Sub_Inventory_Rcvd),
178: decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Lot_Number_rcvd),
179: decode(p_picking_rule_id,Fnd_API.G_MISS_CHAR,NULL,p_picking_rule_id),
180: decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,NULL,P_PROJECT_ID),
181: decode(P_TASK_ID,Fnd_API.G_MISS_NUM,NULL,P_TASK_ID),
182: decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,NULL,P_UNIT_NUMBER),
183: --taklam
184: -- swai: bug 6148019
185: decode(P_INTERNAL_PO_HEADER_ID,Fnd_API.G_MISS_NUM,NULL,P_INTERNAL_PO_HEADER_ID));

Line 182: decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,NULL,P_UNIT_NUMBER),

178: decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,NULL,p_Lot_Number_rcvd),
179: decode(p_picking_rule_id,Fnd_API.G_MISS_CHAR,NULL,p_picking_rule_id),
180: decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,NULL,P_PROJECT_ID),
181: decode(P_TASK_ID,Fnd_API.G_MISS_NUM,NULL,P_TASK_ID),
182: decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,NULL,P_UNIT_NUMBER),
183: --taklam
184: -- swai: bug 6148019
185: decode(P_INTERNAL_PO_HEADER_ID,Fnd_API.G_MISS_NUM,NULL,P_INTERNAL_PO_HEADER_ID));
186:

Line 185: decode(P_INTERNAL_PO_HEADER_ID,Fnd_API.G_MISS_NUM,NULL,P_INTERNAL_PO_HEADER_ID));

181: decode(P_TASK_ID,Fnd_API.G_MISS_NUM,NULL,P_TASK_ID),
182: decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,NULL,P_UNIT_NUMBER),
183: --taklam
184: -- swai: bug 6148019
185: decode(P_INTERNAL_PO_HEADER_ID,Fnd_API.G_MISS_NUM,NULL,P_INTERNAL_PO_HEADER_ID));
186:
187: End Insert_Row;
188:
189: PROCEDURE Update_Row(

Line 249: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID),

245: BEGIN
246: NULL ;
247: Update CSD_PRODUCT_TRANSACTIONS
248: SET
249: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID),
250: ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID),
251: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
252: ACTION_CODE = decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, ACTION_CODE, p_ACTION_CODE),
253: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),

Line 250: ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID),

246: NULL ;
247: Update CSD_PRODUCT_TRANSACTIONS
248: SET
249: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID),
250: ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID),
251: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
252: ACTION_CODE = decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, ACTION_CODE, p_ACTION_CODE),
253: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
254: SUB_INVENTORY = decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, SUB_INVENTORY, p_SUB_INVENTORY),

Line 251: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),

247: Update CSD_PRODUCT_TRANSACTIONS
248: SET
249: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID),
250: ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID),
251: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
252: ACTION_CODE = decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, ACTION_CODE, p_ACTION_CODE),
253: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
254: SUB_INVENTORY = decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, SUB_INVENTORY, p_SUB_INVENTORY),
255: INTERFACE_TO_OM_FLAG = decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OM_FLAG, p_INTERFACE_TO_OM_FLAG),

Line 252: ACTION_CODE = decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, ACTION_CODE, p_ACTION_CODE),

248: SET
249: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID),
250: ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID),
251: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
252: ACTION_CODE = decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, ACTION_CODE, p_ACTION_CODE),
253: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
254: SUB_INVENTORY = decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, SUB_INVENTORY, p_SUB_INVENTORY),
255: INTERFACE_TO_OM_FLAG = decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OM_FLAG, p_INTERFACE_TO_OM_FLAG),
256: BOOK_SALES_ORDER_FLAG = decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, BOOK_SALES_ORDER_FLAG, p_BOOK_SALES_ORDER_FLAG),

Line 253: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),

249: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID),
250: ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID),
251: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
252: ACTION_CODE = decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, ACTION_CODE, p_ACTION_CODE),
253: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
254: SUB_INVENTORY = decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, SUB_INVENTORY, p_SUB_INVENTORY),
255: INTERFACE_TO_OM_FLAG = decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OM_FLAG, p_INTERFACE_TO_OM_FLAG),
256: BOOK_SALES_ORDER_FLAG = decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, BOOK_SALES_ORDER_FLAG, p_BOOK_SALES_ORDER_FLAG),
257: RELEASE_SALES_ORDER_FLAG = decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, RELEASE_SALES_ORDER_FLAG, p_RELEASE_SALES_ORDER_FLAG),

Line 254: SUB_INVENTORY = decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, SUB_INVENTORY, p_SUB_INVENTORY),

250: ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID),
251: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
252: ACTION_CODE = decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, ACTION_CODE, p_ACTION_CODE),
253: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
254: SUB_INVENTORY = decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, SUB_INVENTORY, p_SUB_INVENTORY),
255: INTERFACE_TO_OM_FLAG = decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OM_FLAG, p_INTERFACE_TO_OM_FLAG),
256: BOOK_SALES_ORDER_FLAG = decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, BOOK_SALES_ORDER_FLAG, p_BOOK_SALES_ORDER_FLAG),
257: RELEASE_SALES_ORDER_FLAG = decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, RELEASE_SALES_ORDER_FLAG, p_RELEASE_SALES_ORDER_FLAG),
258: SHIP_SALES_ORDER_FLAG = decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, SHIP_SALES_ORDER_FLAG, p_SHIP_SALES_ORDER_FLAG),

Line 255: INTERFACE_TO_OM_FLAG = decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OM_FLAG, p_INTERFACE_TO_OM_FLAG),

251: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),
252: ACTION_CODE = decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, ACTION_CODE, p_ACTION_CODE),
253: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
254: SUB_INVENTORY = decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, SUB_INVENTORY, p_SUB_INVENTORY),
255: INTERFACE_TO_OM_FLAG = decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OM_FLAG, p_INTERFACE_TO_OM_FLAG),
256: BOOK_SALES_ORDER_FLAG = decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, BOOK_SALES_ORDER_FLAG, p_BOOK_SALES_ORDER_FLAG),
257: RELEASE_SALES_ORDER_FLAG = decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, RELEASE_SALES_ORDER_FLAG, p_RELEASE_SALES_ORDER_FLAG),
258: SHIP_SALES_ORDER_FLAG = decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, SHIP_SALES_ORDER_FLAG, p_SHIP_SALES_ORDER_FLAG),
259: PROD_TXN_STATUS = decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, PROD_TXN_STATUS, p_PROD_TXN_STATUS),

Line 256: BOOK_SALES_ORDER_FLAG = decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, BOOK_SALES_ORDER_FLAG, p_BOOK_SALES_ORDER_FLAG),

252: ACTION_CODE = decode( p_ACTION_CODE, FND_API.G_MISS_CHAR, ACTION_CODE, p_ACTION_CODE),
253: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
254: SUB_INVENTORY = decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, SUB_INVENTORY, p_SUB_INVENTORY),
255: INTERFACE_TO_OM_FLAG = decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OM_FLAG, p_INTERFACE_TO_OM_FLAG),
256: BOOK_SALES_ORDER_FLAG = decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, BOOK_SALES_ORDER_FLAG, p_BOOK_SALES_ORDER_FLAG),
257: RELEASE_SALES_ORDER_FLAG = decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, RELEASE_SALES_ORDER_FLAG, p_RELEASE_SALES_ORDER_FLAG),
258: SHIP_SALES_ORDER_FLAG = decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, SHIP_SALES_ORDER_FLAG, p_SHIP_SALES_ORDER_FLAG),
259: PROD_TXN_STATUS = decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, PROD_TXN_STATUS, p_PROD_TXN_STATUS),
260: PROD_TXN_CODE = decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, PROD_TXN_CODE, p_PROD_TXN_CODE),

Line 257: RELEASE_SALES_ORDER_FLAG = decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, RELEASE_SALES_ORDER_FLAG, p_RELEASE_SALES_ORDER_FLAG),

253: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
254: SUB_INVENTORY = decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, SUB_INVENTORY, p_SUB_INVENTORY),
255: INTERFACE_TO_OM_FLAG = decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OM_FLAG, p_INTERFACE_TO_OM_FLAG),
256: BOOK_SALES_ORDER_FLAG = decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, BOOK_SALES_ORDER_FLAG, p_BOOK_SALES_ORDER_FLAG),
257: RELEASE_SALES_ORDER_FLAG = decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, RELEASE_SALES_ORDER_FLAG, p_RELEASE_SALES_ORDER_FLAG),
258: SHIP_SALES_ORDER_FLAG = decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, SHIP_SALES_ORDER_FLAG, p_SHIP_SALES_ORDER_FLAG),
259: PROD_TXN_STATUS = decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, PROD_TXN_STATUS, p_PROD_TXN_STATUS),
260: PROD_TXN_CODE = decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, PROD_TXN_CODE, p_PROD_TXN_CODE),
261: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 258: SHIP_SALES_ORDER_FLAG = decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, SHIP_SALES_ORDER_FLAG, p_SHIP_SALES_ORDER_FLAG),

254: SUB_INVENTORY = decode( p_SUB_INVENTORY, FND_API.G_MISS_CHAR, SUB_INVENTORY, p_SUB_INVENTORY),
255: INTERFACE_TO_OM_FLAG = decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OM_FLAG, p_INTERFACE_TO_OM_FLAG),
256: BOOK_SALES_ORDER_FLAG = decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, BOOK_SALES_ORDER_FLAG, p_BOOK_SALES_ORDER_FLAG),
257: RELEASE_SALES_ORDER_FLAG = decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, RELEASE_SALES_ORDER_FLAG, p_RELEASE_SALES_ORDER_FLAG),
258: SHIP_SALES_ORDER_FLAG = decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, SHIP_SALES_ORDER_FLAG, p_SHIP_SALES_ORDER_FLAG),
259: PROD_TXN_STATUS = decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, PROD_TXN_STATUS, p_PROD_TXN_STATUS),
260: PROD_TXN_CODE = decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, PROD_TXN_CODE, p_PROD_TXN_CODE),
261: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
262: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 259: PROD_TXN_STATUS = decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, PROD_TXN_STATUS, p_PROD_TXN_STATUS),

255: INTERFACE_TO_OM_FLAG = decode( p_INTERFACE_TO_OM_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OM_FLAG, p_INTERFACE_TO_OM_FLAG),
256: BOOK_SALES_ORDER_FLAG = decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, BOOK_SALES_ORDER_FLAG, p_BOOK_SALES_ORDER_FLAG),
257: RELEASE_SALES_ORDER_FLAG = decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, RELEASE_SALES_ORDER_FLAG, p_RELEASE_SALES_ORDER_FLAG),
258: SHIP_SALES_ORDER_FLAG = decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, SHIP_SALES_ORDER_FLAG, p_SHIP_SALES_ORDER_FLAG),
259: PROD_TXN_STATUS = decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, PROD_TXN_STATUS, p_PROD_TXN_STATUS),
260: PROD_TXN_CODE = decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, PROD_TXN_CODE, p_PROD_TXN_CODE),
261: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
262: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
263: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 260: PROD_TXN_CODE = decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, PROD_TXN_CODE, p_PROD_TXN_CODE),

256: BOOK_SALES_ORDER_FLAG = decode( p_BOOK_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, BOOK_SALES_ORDER_FLAG, p_BOOK_SALES_ORDER_FLAG),
257: RELEASE_SALES_ORDER_FLAG = decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, RELEASE_SALES_ORDER_FLAG, p_RELEASE_SALES_ORDER_FLAG),
258: SHIP_SALES_ORDER_FLAG = decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, SHIP_SALES_ORDER_FLAG, p_SHIP_SALES_ORDER_FLAG),
259: PROD_TXN_STATUS = decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, PROD_TXN_STATUS, p_PROD_TXN_STATUS),
260: PROD_TXN_CODE = decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, PROD_TXN_CODE, p_PROD_TXN_CODE),
261: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
262: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
263: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
264: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

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

257: RELEASE_SALES_ORDER_FLAG = decode( p_RELEASE_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, RELEASE_SALES_ORDER_FLAG, p_RELEASE_SALES_ORDER_FLAG),
258: SHIP_SALES_ORDER_FLAG = decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, SHIP_SALES_ORDER_FLAG, p_SHIP_SALES_ORDER_FLAG),
259: PROD_TXN_STATUS = decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, PROD_TXN_STATUS, p_PROD_TXN_STATUS),
260: PROD_TXN_CODE = decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, PROD_TXN_CODE, p_PROD_TXN_CODE),
261: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
262: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
263: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
264: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
265: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

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

258: SHIP_SALES_ORDER_FLAG = decode( p_SHIP_SALES_ORDER_FLAG, FND_API.G_MISS_CHAR, SHIP_SALES_ORDER_FLAG, p_SHIP_SALES_ORDER_FLAG),
259: PROD_TXN_STATUS = decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, PROD_TXN_STATUS, p_PROD_TXN_STATUS),
260: PROD_TXN_CODE = decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, PROD_TXN_CODE, p_PROD_TXN_CODE),
261: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
262: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
263: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
264: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
265: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
266: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

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

259: PROD_TXN_STATUS = decode( p_PROD_TXN_STATUS, FND_API.G_MISS_CHAR, PROD_TXN_STATUS, p_PROD_TXN_STATUS),
260: PROD_TXN_CODE = decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, PROD_TXN_CODE, p_PROD_TXN_CODE),
261: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
262: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
263: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
264: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
265: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
266: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
267: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

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

260: PROD_TXN_CODE = decode( p_PROD_TXN_CODE, FND_API.G_MISS_CHAR, PROD_TXN_CODE, p_PROD_TXN_CODE),
261: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
262: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
263: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
264: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
265: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
266: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
267: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
268: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

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

261: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
262: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
263: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
264: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
265: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
266: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
267: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
268: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
269: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

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

262: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
263: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
264: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
265: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
266: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
267: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
268: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
269: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
270: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

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

263: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
264: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
265: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
266: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
267: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
268: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
269: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
270: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
271: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

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

264: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
265: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
266: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
267: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
268: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
269: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
270: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
271: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
272: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

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

265: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
266: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
267: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
268: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
269: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
270: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
271: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
272: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
273: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

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

266: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
267: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
268: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
269: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
270: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
271: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
272: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
273: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
274: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

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

267: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
268: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
269: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
270: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
271: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
272: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
273: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
274: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
275: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

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

268: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
269: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
270: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
271: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
272: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
273: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
274: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
275: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
276: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

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

269: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
270: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
271: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
272: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
273: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
274: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
275: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
276: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
277: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

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

270: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
271: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
272: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
273: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
274: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
275: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
276: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
277: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
278: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

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

271: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
272: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
273: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
274: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
275: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
276: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
277: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
278: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
279: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

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

272: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
273: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
274: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
275: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
276: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
277: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
278: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
279: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
280: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

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

273: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
274: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
275: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
276: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
277: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
278: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
279: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
280: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
281: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),

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

274: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
275: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
276: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
277: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
278: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
279: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
280: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
281: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
282: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

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

275: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
276: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
277: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
278: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
279: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
280: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
281: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
282: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
283: Req_Header_Id = decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,Req_Header_Id,p_Req_Header_Id),

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

276: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
277: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
278: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
279: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
280: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
281: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
282: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
283: Req_Header_Id = decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,Req_Header_Id,p_Req_Header_Id),
284: Req_Line_Id = decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,Req_Line_Id,p_Req_Line_Id),

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

277: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
278: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
279: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
280: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
281: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
282: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
283: Req_Header_Id = decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,Req_Header_Id,p_Req_Header_Id),
284: Req_Line_Id = decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,Req_Line_Id,p_Req_Line_Id),
285: Order_Header_Id = decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,Order_Header_Id,p_Order_Header_Id),

Line 283: Req_Header_Id = decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,Req_Header_Id,p_Req_Header_Id),

279: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
280: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
281: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
282: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
283: Req_Header_Id = decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,Req_Header_Id,p_Req_Header_Id),
284: Req_Line_Id = decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,Req_Line_Id,p_Req_Line_Id),
285: Order_Header_Id = decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,Order_Header_Id,p_Order_Header_Id),
286: Order_Line_Id = decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,Order_Line_Id,p_Order_Line_Id),
287: Quantity_Received = decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,Quantity_Received,p_Prd_Txn_Qty_Received),

Line 284: Req_Line_Id = decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,Req_Line_Id,p_Req_Line_Id),

280: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
281: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
282: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
283: Req_Header_Id = decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,Req_Header_Id,p_Req_Header_Id),
284: Req_Line_Id = decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,Req_Line_Id,p_Req_Line_Id),
285: Order_Header_Id = decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,Order_Header_Id,p_Order_Header_Id),
286: Order_Line_Id = decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,Order_Line_Id,p_Order_Line_Id),
287: Quantity_Received = decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,Quantity_Received,p_Prd_Txn_Qty_Received),
288: Quantity_Shipped = decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,Quantity_Shipped,p_Prd_Txn_Qty_Shipped),

Line 285: Order_Header_Id = decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,Order_Header_Id,p_Order_Header_Id),

281: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
282: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
283: Req_Header_Id = decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,Req_Header_Id,p_Req_Header_Id),
284: Req_Line_Id = decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,Req_Line_Id,p_Req_Line_Id),
285: Order_Header_Id = decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,Order_Header_Id,p_Order_Header_Id),
286: Order_Line_Id = decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,Order_Line_Id,p_Order_Line_Id),
287: Quantity_Received = decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,Quantity_Received,p_Prd_Txn_Qty_Received),
288: Quantity_Shipped = decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,Quantity_Shipped,p_Prd_Txn_Qty_Shipped),
289: Source_Serial_Number = decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Source_Serial_Number,p_Source_Serial_Number) ,

Line 286: Order_Line_Id = decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,Order_Line_Id,p_Order_Line_Id),

282: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
283: Req_Header_Id = decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,Req_Header_Id,p_Req_Header_Id),
284: Req_Line_Id = decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,Req_Line_Id,p_Req_Line_Id),
285: Order_Header_Id = decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,Order_Header_Id,p_Order_Header_Id),
286: Order_Line_Id = decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,Order_Line_Id,p_Order_Line_Id),
287: Quantity_Received = decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,Quantity_Received,p_Prd_Txn_Qty_Received),
288: Quantity_Shipped = decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,Quantity_Shipped,p_Prd_Txn_Qty_Shipped),
289: Source_Serial_Number = decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Source_Serial_Number,p_Source_Serial_Number) ,
290: Source_Instance_ID = decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,Source_Instance_ID,p_Source_Instance_Id) ,

Line 287: Quantity_Received = decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,Quantity_Received,p_Prd_Txn_Qty_Received),

283: Req_Header_Id = decode(p_Req_Header_Id,Fnd_API.G_MISS_NUM,Req_Header_Id,p_Req_Header_Id),
284: Req_Line_Id = decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,Req_Line_Id,p_Req_Line_Id),
285: Order_Header_Id = decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,Order_Header_Id,p_Order_Header_Id),
286: Order_Line_Id = decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,Order_Line_Id,p_Order_Line_Id),
287: Quantity_Received = decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,Quantity_Received,p_Prd_Txn_Qty_Received),
288: Quantity_Shipped = decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,Quantity_Shipped,p_Prd_Txn_Qty_Shipped),
289: Source_Serial_Number = decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Source_Serial_Number,p_Source_Serial_Number) ,
290: Source_Instance_ID = decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,Source_Instance_ID,p_Source_Instance_Id) ,
291: Non_Source_Serial_Number = decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Non_Source_Serial_Number,p_Non_Source_Serial_Number) ,

Line 288: Quantity_Shipped = decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,Quantity_Shipped,p_Prd_Txn_Qty_Shipped),

284: Req_Line_Id = decode(p_Req_Line_Id,Fnd_API.G_MISS_NUM,Req_Line_Id,p_Req_Line_Id),
285: Order_Header_Id = decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,Order_Header_Id,p_Order_Header_Id),
286: Order_Line_Id = decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,Order_Line_Id,p_Order_Line_Id),
287: Quantity_Received = decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,Quantity_Received,p_Prd_Txn_Qty_Received),
288: Quantity_Shipped = decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,Quantity_Shipped,p_Prd_Txn_Qty_Shipped),
289: Source_Serial_Number = decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Source_Serial_Number,p_Source_Serial_Number) ,
290: Source_Instance_ID = decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,Source_Instance_ID,p_Source_Instance_Id) ,
291: Non_Source_Serial_Number = decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Non_Source_Serial_Number,p_Non_Source_Serial_Number) ,
292: Non_Source_Instance_ID = decode(p_Non_Source_Instance_Id,Fnd_API.G_MISS_NUM,Non_Source_Instance_ID,p_Non_Source_Instance_ID) ,

Line 289: Source_Serial_Number = decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Source_Serial_Number,p_Source_Serial_Number) ,

285: Order_Header_Id = decode(p_Order_Header_Id,Fnd_API.G_MISS_NUM,Order_Header_Id,p_Order_Header_Id),
286: Order_Line_Id = decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,Order_Line_Id,p_Order_Line_Id),
287: Quantity_Received = decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,Quantity_Received,p_Prd_Txn_Qty_Received),
288: Quantity_Shipped = decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,Quantity_Shipped,p_Prd_Txn_Qty_Shipped),
289: Source_Serial_Number = decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Source_Serial_Number,p_Source_Serial_Number) ,
290: Source_Instance_ID = decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,Source_Instance_ID,p_Source_Instance_Id) ,
291: Non_Source_Serial_Number = decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Non_Source_Serial_Number,p_Non_Source_Serial_Number) ,
292: Non_Source_Instance_ID = decode(p_Non_Source_Instance_Id,Fnd_API.G_MISS_NUM,Non_Source_Instance_ID,p_Non_Source_Instance_ID) ,
293: Locator_id = decode(p_Locator_Id , Fnd_API.G_MISS_NUM,Locator_Id,p_Locator_Id),

Line 290: Source_Instance_ID = decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,Source_Instance_ID,p_Source_Instance_Id) ,

286: Order_Line_Id = decode(p_Order_Line_Id,Fnd_API.G_MISS_NUM,Order_Line_Id,p_Order_Line_Id),
287: Quantity_Received = decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,Quantity_Received,p_Prd_Txn_Qty_Received),
288: Quantity_Shipped = decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,Quantity_Shipped,p_Prd_Txn_Qty_Shipped),
289: Source_Serial_Number = decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Source_Serial_Number,p_Source_Serial_Number) ,
290: Source_Instance_ID = decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,Source_Instance_ID,p_Source_Instance_Id) ,
291: Non_Source_Serial_Number = decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Non_Source_Serial_Number,p_Non_Source_Serial_Number) ,
292: Non_Source_Instance_ID = decode(p_Non_Source_Instance_Id,Fnd_API.G_MISS_NUM,Non_Source_Instance_ID,p_Non_Source_Instance_ID) ,
293: Locator_id = decode(p_Locator_Id , Fnd_API.G_MISS_NUM,Locator_Id,p_Locator_Id),
294: Sub_Inventory_rcvd = decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,Sub_Inventory_Rcvd,p_Sub_Inventory_Rcvd),

Line 291: Non_Source_Serial_Number = decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Non_Source_Serial_Number,p_Non_Source_Serial_Number) ,

287: Quantity_Received = decode(p_Prd_Txn_Qty_Received,Fnd_API.G_MISS_NUM,Quantity_Received,p_Prd_Txn_Qty_Received),
288: Quantity_Shipped = decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,Quantity_Shipped,p_Prd_Txn_Qty_Shipped),
289: Source_Serial_Number = decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Source_Serial_Number,p_Source_Serial_Number) ,
290: Source_Instance_ID = decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,Source_Instance_ID,p_Source_Instance_Id) ,
291: Non_Source_Serial_Number = decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Non_Source_Serial_Number,p_Non_Source_Serial_Number) ,
292: Non_Source_Instance_ID = decode(p_Non_Source_Instance_Id,Fnd_API.G_MISS_NUM,Non_Source_Instance_ID,p_Non_Source_Instance_ID) ,
293: Locator_id = decode(p_Locator_Id , Fnd_API.G_MISS_NUM,Locator_Id,p_Locator_Id),
294: Sub_Inventory_rcvd = decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,Sub_Inventory_Rcvd,p_Sub_Inventory_Rcvd),
295: Lot_Number_Rcvd = decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,Lot_Number_Rcvd,p_Lot_Number_rcvd),

Line 292: Non_Source_Instance_ID = decode(p_Non_Source_Instance_Id,Fnd_API.G_MISS_NUM,Non_Source_Instance_ID,p_Non_Source_Instance_ID) ,

288: Quantity_Shipped = decode(p_Prd_Txn_Qty_Shipped,Fnd_API.G_MISS_NUM,Quantity_Shipped,p_Prd_Txn_Qty_Shipped),
289: Source_Serial_Number = decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Source_Serial_Number,p_Source_Serial_Number) ,
290: Source_Instance_ID = decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,Source_Instance_ID,p_Source_Instance_Id) ,
291: Non_Source_Serial_Number = decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Non_Source_Serial_Number,p_Non_Source_Serial_Number) ,
292: Non_Source_Instance_ID = decode(p_Non_Source_Instance_Id,Fnd_API.G_MISS_NUM,Non_Source_Instance_ID,p_Non_Source_Instance_ID) ,
293: Locator_id = decode(p_Locator_Id , Fnd_API.G_MISS_NUM,Locator_Id,p_Locator_Id),
294: Sub_Inventory_rcvd = decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,Sub_Inventory_Rcvd,p_Sub_Inventory_Rcvd),
295: Lot_Number_Rcvd = decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,Lot_Number_Rcvd,p_Lot_Number_rcvd),
296: Picking_rule_id = decode(p_Picking_rule_id,Fnd_API.G_MISS_CHAR,Picking_rule_id,p_Picking_rule_id),

Line 293: Locator_id = decode(p_Locator_Id , Fnd_API.G_MISS_NUM,Locator_Id,p_Locator_Id),

289: Source_Serial_Number = decode(p_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Source_Serial_Number,p_Source_Serial_Number) ,
290: Source_Instance_ID = decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,Source_Instance_ID,p_Source_Instance_Id) ,
291: Non_Source_Serial_Number = decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Non_Source_Serial_Number,p_Non_Source_Serial_Number) ,
292: Non_Source_Instance_ID = decode(p_Non_Source_Instance_Id,Fnd_API.G_MISS_NUM,Non_Source_Instance_ID,p_Non_Source_Instance_ID) ,
293: Locator_id = decode(p_Locator_Id , Fnd_API.G_MISS_NUM,Locator_Id,p_Locator_Id),
294: Sub_Inventory_rcvd = decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,Sub_Inventory_Rcvd,p_Sub_Inventory_Rcvd),
295: Lot_Number_Rcvd = decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,Lot_Number_Rcvd,p_Lot_Number_rcvd),
296: Picking_rule_id = decode(p_Picking_rule_id,Fnd_API.G_MISS_CHAR,Picking_rule_id,p_Picking_rule_id),
297: PROJECT_ID = decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,PROJECT_ID,P_PROJECT_ID),

Line 294: Sub_Inventory_rcvd = decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,Sub_Inventory_Rcvd,p_Sub_Inventory_Rcvd),

290: Source_Instance_ID = decode(p_Source_Instance_ID,Fnd_API.G_MISS_NUM,Source_Instance_ID,p_Source_Instance_Id) ,
291: Non_Source_Serial_Number = decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Non_Source_Serial_Number,p_Non_Source_Serial_Number) ,
292: Non_Source_Instance_ID = decode(p_Non_Source_Instance_Id,Fnd_API.G_MISS_NUM,Non_Source_Instance_ID,p_Non_Source_Instance_ID) ,
293: Locator_id = decode(p_Locator_Id , Fnd_API.G_MISS_NUM,Locator_Id,p_Locator_Id),
294: Sub_Inventory_rcvd = decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,Sub_Inventory_Rcvd,p_Sub_Inventory_Rcvd),
295: Lot_Number_Rcvd = decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,Lot_Number_Rcvd,p_Lot_Number_rcvd),
296: Picking_rule_id = decode(p_Picking_rule_id,Fnd_API.G_MISS_CHAR,Picking_rule_id,p_Picking_rule_id),
297: PROJECT_ID = decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,PROJECT_ID,P_PROJECT_ID),
298: TASK_ID = decode(P_TASK_ID,Fnd_API.G_MISS_NUM,TASK_ID,P_TASK_ID),

Line 295: Lot_Number_Rcvd = decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,Lot_Number_Rcvd,p_Lot_Number_rcvd),

291: Non_Source_Serial_Number = decode(p_Non_Source_Serial_Number,Fnd_API.G_MISS_CHAR,Non_Source_Serial_Number,p_Non_Source_Serial_Number) ,
292: Non_Source_Instance_ID = decode(p_Non_Source_Instance_Id,Fnd_API.G_MISS_NUM,Non_Source_Instance_ID,p_Non_Source_Instance_ID) ,
293: Locator_id = decode(p_Locator_Id , Fnd_API.G_MISS_NUM,Locator_Id,p_Locator_Id),
294: Sub_Inventory_rcvd = decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,Sub_Inventory_Rcvd,p_Sub_Inventory_Rcvd),
295: Lot_Number_Rcvd = decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,Lot_Number_Rcvd,p_Lot_Number_rcvd),
296: Picking_rule_id = decode(p_Picking_rule_id,Fnd_API.G_MISS_CHAR,Picking_rule_id,p_Picking_rule_id),
297: PROJECT_ID = decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,PROJECT_ID,P_PROJECT_ID),
298: TASK_ID = decode(P_TASK_ID,Fnd_API.G_MISS_NUM,TASK_ID,P_TASK_ID),
299: UNIT_NUMBER = decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,UNIT_NUMBER,P_UNIT_NUMBER),

Line 296: Picking_rule_id = decode(p_Picking_rule_id,Fnd_API.G_MISS_CHAR,Picking_rule_id,p_Picking_rule_id),

292: Non_Source_Instance_ID = decode(p_Non_Source_Instance_Id,Fnd_API.G_MISS_NUM,Non_Source_Instance_ID,p_Non_Source_Instance_ID) ,
293: Locator_id = decode(p_Locator_Id , Fnd_API.G_MISS_NUM,Locator_Id,p_Locator_Id),
294: Sub_Inventory_rcvd = decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,Sub_Inventory_Rcvd,p_Sub_Inventory_Rcvd),
295: Lot_Number_Rcvd = decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,Lot_Number_Rcvd,p_Lot_Number_rcvd),
296: Picking_rule_id = decode(p_Picking_rule_id,Fnd_API.G_MISS_CHAR,Picking_rule_id,p_Picking_rule_id),
297: PROJECT_ID = decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,PROJECT_ID,P_PROJECT_ID),
298: TASK_ID = decode(P_TASK_ID,Fnd_API.G_MISS_NUM,TASK_ID,P_TASK_ID),
299: UNIT_NUMBER = decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,UNIT_NUMBER,P_UNIT_NUMBER),
300: -- swai: bug 6148019

Line 297: PROJECT_ID = decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,PROJECT_ID,P_PROJECT_ID),

293: Locator_id = decode(p_Locator_Id , Fnd_API.G_MISS_NUM,Locator_Id,p_Locator_Id),
294: Sub_Inventory_rcvd = decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,Sub_Inventory_Rcvd,p_Sub_Inventory_Rcvd),
295: Lot_Number_Rcvd = decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,Lot_Number_Rcvd,p_Lot_Number_rcvd),
296: Picking_rule_id = decode(p_Picking_rule_id,Fnd_API.G_MISS_CHAR,Picking_rule_id,p_Picking_rule_id),
297: PROJECT_ID = decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,PROJECT_ID,P_PROJECT_ID),
298: TASK_ID = decode(P_TASK_ID,Fnd_API.G_MISS_NUM,TASK_ID,P_TASK_ID),
299: UNIT_NUMBER = decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,UNIT_NUMBER,P_UNIT_NUMBER),
300: -- swai: bug 6148019
301: INTERNAL_PO_HEADER_ID = decode(P_INTERNAL_PO_HEADER_ID,Fnd_API.G_MISS_NUM,INTERNAL_PO_HEADER_ID,P_INTERNAL_PO_HEADER_ID)

Line 298: TASK_ID = decode(P_TASK_ID,Fnd_API.G_MISS_NUM,TASK_ID,P_TASK_ID),

294: Sub_Inventory_rcvd = decode(p_Sub_Inventory_Rcvd,Fnd_API.G_MISS_CHAR,Sub_Inventory_Rcvd,p_Sub_Inventory_Rcvd),
295: Lot_Number_Rcvd = decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,Lot_Number_Rcvd,p_Lot_Number_rcvd),
296: Picking_rule_id = decode(p_Picking_rule_id,Fnd_API.G_MISS_CHAR,Picking_rule_id,p_Picking_rule_id),
297: PROJECT_ID = decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,PROJECT_ID,P_PROJECT_ID),
298: TASK_ID = decode(P_TASK_ID,Fnd_API.G_MISS_NUM,TASK_ID,P_TASK_ID),
299: UNIT_NUMBER = decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,UNIT_NUMBER,P_UNIT_NUMBER),
300: -- swai: bug 6148019
301: INTERNAL_PO_HEADER_ID = decode(P_INTERNAL_PO_HEADER_ID,Fnd_API.G_MISS_NUM,INTERNAL_PO_HEADER_ID,P_INTERNAL_PO_HEADER_ID)
302: where PRODUCT_TRANSACTION_ID = p_PRODUCT_TRANSACTION_ID

Line 299: UNIT_NUMBER = decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,UNIT_NUMBER,P_UNIT_NUMBER),

295: Lot_Number_Rcvd = decode(p_Lot_Number_Rcvd,Fnd_API.G_MISS_CHAR,Lot_Number_Rcvd,p_Lot_Number_rcvd),
296: Picking_rule_id = decode(p_Picking_rule_id,Fnd_API.G_MISS_CHAR,Picking_rule_id,p_Picking_rule_id),
297: PROJECT_ID = decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,PROJECT_ID,P_PROJECT_ID),
298: TASK_ID = decode(P_TASK_ID,Fnd_API.G_MISS_NUM,TASK_ID,P_TASK_ID),
299: UNIT_NUMBER = decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,UNIT_NUMBER,P_UNIT_NUMBER),
300: -- swai: bug 6148019
301: INTERNAL_PO_HEADER_ID = decode(P_INTERNAL_PO_HEADER_ID,Fnd_API.G_MISS_NUM,INTERNAL_PO_HEADER_ID,P_INTERNAL_PO_HEADER_ID)
302: where PRODUCT_TRANSACTION_ID = p_PRODUCT_TRANSACTION_ID
303: And Object_Version_Number = p_Object_Version_Number;

Line 301: INTERNAL_PO_HEADER_ID = decode(P_INTERNAL_PO_HEADER_ID,Fnd_API.G_MISS_NUM,INTERNAL_PO_HEADER_ID,P_INTERNAL_PO_HEADER_ID)

297: PROJECT_ID = decode(P_PROJECT_ID,Fnd_API.G_MISS_NUM,PROJECT_ID,P_PROJECT_ID),
298: TASK_ID = decode(P_TASK_ID,Fnd_API.G_MISS_NUM,TASK_ID,P_TASK_ID),
299: UNIT_NUMBER = decode(P_UNIT_NUMBER,Fnd_API.G_MISS_CHAR,UNIT_NUMBER,P_UNIT_NUMBER),
300: -- swai: bug 6148019
301: INTERNAL_PO_HEADER_ID = decode(P_INTERNAL_PO_HEADER_ID,Fnd_API.G_MISS_NUM,INTERNAL_PO_HEADER_ID,P_INTERNAL_PO_HEADER_ID)
302: where PRODUCT_TRANSACTION_ID = p_PRODUCT_TRANSACTION_ID
303: And Object_Version_Number = p_Object_Version_Number;
304:
305: If (SQL%NOTFOUND) then