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

APPS.OE_HEADER_ACK_UTIL dependencies on FND_API

Line 184: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

180: WHERE header_id = l_header_rec.header_id
181: AND acknowledgment_flag Is Null
182: -- Change this condition once a type is inserted for POAO/POCAO
183: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
184: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
185: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
186: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
187: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
188: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 185: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)

181: AND acknowledgment_flag Is Null
182: -- Change this condition once a type is inserted for POAO/POCAO
183: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
184: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
185: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
186: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
187: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
188: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
189: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR)

Line 186: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

182: -- Change this condition once a type is inserted for POAO/POCAO
183: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
184: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
185: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
186: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
187: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
188: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
189: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR)
190: AND request_id = l_header_rec.request_id;

Line 187: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)

183: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
184: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
185: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
186: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
187: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
188: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
189: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR)
190: AND request_id = l_header_rec.request_id;
191: else

Line 188: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

184: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
185: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
186: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
187: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
188: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
189: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR)
190: AND request_id = l_header_rec.request_id;
191: else
192: SELECT count(*) INTO l_count

Line 189: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR)

185: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
186: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
187: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
188: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
189: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR)
190: AND request_id = l_header_rec.request_id;
191: else
192: SELECT count(*) INTO l_count
193: FROM OE_HEADER_ACKS

Line 198: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

194: WHERE header_id = l_header_rec.header_id
195: AND acknowledgment_flag Is Null
196: -- Change this condition once a type is inserted for POAO/POCAO
197: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
198: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
199: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
200: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
201: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
202: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 199: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)

195: AND acknowledgment_flag Is Null
196: -- Change this condition once a type is inserted for POAO/POCAO
197: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
198: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
199: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
200: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
201: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
202: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
203: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR);

Line 200: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

196: -- Change this condition once a type is inserted for POAO/POCAO
197: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
198: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
199: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
200: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
201: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
202: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
203: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR);
204:

Line 201: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)

197: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
198: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
199: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
200: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
201: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
202: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
203: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR);
204:
205: end if;

Line 202: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

198: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
199: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
200: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
201: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
202: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
203: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR);
204:
205: end if;
206: IF l_count > 0 THEN

Line 203: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR);

199: = nvl(l_header_rec.sold_to_org_id, FND_API.G_MISS_NUM)
200: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
201: = nvl(l_header_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
202: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
203: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR);
204:
205: end if;
206: IF l_count > 0 THEN
207: OE_Header_Ack_Util.Delete_Row (p_header_id => l_header_rec.header_id,

Line 238: IF ( l_header_rec.order_source_id <> FND_API.G_MISS_NUM

234: oe_debug_pub.add('Source = '||l_header_rec.order_source_id);
235: oe_debug_pub.add('Ref = '||l_header_rec.orig_sys_document_ref);
236: oe_debug_pub.add('Headerid = '||l_header_rec.header_id);
237: oe_debug_pub.add('First Ack Code = '|| l_header_rec.first_ack_code,1);
238: IF ( l_header_rec.order_source_id <> FND_API.G_MISS_NUM
239: AND nvl(l_header_rec.order_source_id,0) <> 0
240: AND l_header_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR
241: AND nvl(l_header_rec.orig_sys_document_ref,' ') <> ' ')
242:

Line 240: AND l_header_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR

236: oe_debug_pub.add('Headerid = '||l_header_rec.header_id);
237: oe_debug_pub.add('First Ack Code = '|| l_header_rec.first_ack_code,1);
238: IF ( l_header_rec.order_source_id <> FND_API.G_MISS_NUM
239: AND nvl(l_header_rec.order_source_id,0) <> 0
240: AND l_header_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR
241: AND nvl(l_header_rec.orig_sys_document_ref,' ') <> ' ')
242:
243: OR (l_header_rec.header_id <> FND_API.G_MISS_NUM
244: AND nvl(l_header_rec.header_id,0) <> 0)

Line 243: OR (l_header_rec.header_id <> FND_API.G_MISS_NUM

239: AND nvl(l_header_rec.order_source_id,0) <> 0
240: AND l_header_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR
241: AND nvl(l_header_rec.orig_sys_document_ref,' ') <> ' ')
242:
243: OR (l_header_rec.header_id <> FND_API.G_MISS_NUM
244: AND nvl(l_header_rec.header_id,0) <> 0)
245: THEN
246: oe_debug_pub.add('inserting header ack record for'||
247: ' source id: ' ||to_char(l_header_rec.order_source_id)||

Line 832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

828: THEN
829: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'OE_Header_Ack_Util.Insert_Row');
830: END IF;
831:
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: END Insert_Row;
834:
835:
836: Procedure Insert_Row

Line 903: IF (l_header_rec.order_source_id <> FND_API.G_MISS_NUM

899: When Others Then
900: Null;
901: End;
902:
903: IF (l_header_rec.order_source_id <> FND_API.G_MISS_NUM
904: AND nvl(l_header_rec.order_source_id,0) <> 0
905: AND l_header_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR
906: AND nvl(l_header_rec.orig_sys_document_ref,' ') <> ' ')
907: OR (l_header_rec.header_id <> FND_API.G_MISS_NUM

Line 905: AND l_header_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR

901: End;
902:
903: IF (l_header_rec.order_source_id <> FND_API.G_MISS_NUM
904: AND nvl(l_header_rec.order_source_id,0) <> 0
905: AND l_header_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR
906: AND nvl(l_header_rec.orig_sys_document_ref,' ') <> ' ')
907: OR (l_header_rec.header_id <> FND_API.G_MISS_NUM
908: AND nvl(l_header_rec.header_id,0) <> 0) Then
909:

Line 907: OR (l_header_rec.header_id <> FND_API.G_MISS_NUM

903: IF (l_header_rec.order_source_id <> FND_API.G_MISS_NUM
904: AND nvl(l_header_rec.order_source_id,0) <> 0
905: AND l_header_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR
906: AND nvl(l_header_rec.orig_sys_document_ref,' ') <> ' ')
907: OR (l_header_rec.header_id <> FND_API.G_MISS_NUM
908: AND nvl(l_header_rec.header_id,0) <> 0) Then
909:
910: -- Insert data
911: Insert

Line 1242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1238: When Others Then
1239: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
1240: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'OE_Header_Ack_Util.Insert_Row');
1241: End If;
1242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1243:
1244: End Insert_Row;
1245:
1246:

Line 1272: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

1268: WHERE HEADER_ID = p_header_id
1269: AND ACKNOWLEDGMENT_FLAG Is Null
1270: -- Change this condition once a type is inserted for POAO/POCAO
1271: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
1272: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1273: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1274: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1275: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1276: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 1273: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

1269: AND ACKNOWLEDGMENT_FLAG Is Null
1270: -- Change this condition once a type is inserted for POAO/POCAO
1271: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
1272: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1273: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1274: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1275: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1276: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1277: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)

Line 1274: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

1270: -- Change this condition once a type is inserted for POAO/POCAO
1271: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
1272: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1273: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1274: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1275: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1276: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1277: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
1278: AND request_id = p_request_id;

Line 1275: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

1271: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
1272: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1273: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1274: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1275: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1276: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1277: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
1278: AND request_id = p_request_id;
1279: else

Line 1276: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

1272: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1273: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1274: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1275: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1276: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1277: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
1278: AND request_id = p_request_id;
1279: else
1280:

Line 1277: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)

1273: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1274: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1275: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1276: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1277: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
1278: AND request_id = p_request_id;
1279: else
1280:
1281: DELETE FROM OE_HEADER_ACKS

Line 1286: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

1282: WHERE HEADER_ID = p_header_id
1283: AND ACKNOWLEDGMENT_FLAG Is Null
1284: -- Change this condition once a type is inserted for POAO/POCAO
1285: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
1286: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1287: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1288: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1289: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1290: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 1287: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

1283: AND ACKNOWLEDGMENT_FLAG Is Null
1284: -- Change this condition once a type is inserted for POAO/POCAO
1285: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
1286: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1287: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1288: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1289: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1290: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1291: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);

Line 1288: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

1284: -- Change this condition once a type is inserted for POAO/POCAO
1285: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
1286: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1287: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1288: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1289: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1290: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1291: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
1292: end if;

Line 1289: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

1285: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
1286: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1287: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1288: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1289: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1290: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1291: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
1292: end if;
1293:

Line 1290: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

1286: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1287: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1288: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1289: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1290: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1291: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
1292: end if;
1293:
1294: Elsif p_orig_sys_document_ref Is Not NULL Then

Line 1291: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);

1287: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1288: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1289: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1290: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1291: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
1292: end if;
1293:
1294: Elsif p_orig_sys_document_ref Is Not NULL Then
1295: oe_debug_pub.add('before deleting header acknowledgment by orig_sys_document_Ref ',3);

Line 1303: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

1299: then
1300: DELETE FROM OE_HEADER_ACKS
1301: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
1302: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc
1303: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1304: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1305: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1306: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1307: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 1304: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

1300: DELETE FROM OE_HEADER_ACKS
1301: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
1302: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc
1303: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1304: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1305: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1306: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1307: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1308: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)

Line 1305: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

1301: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
1302: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc
1303: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1304: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1305: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1306: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1307: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1308: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
1309: AND REQUEST_ID = p_request_id;

Line 1306: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

1302: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc
1303: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1304: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1305: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1306: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1307: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1308: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
1309: AND REQUEST_ID = p_request_id;
1310:

Line 1307: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

1303: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1304: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1305: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1306: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1307: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1308: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
1309: AND REQUEST_ID = p_request_id;
1310:
1311:

Line 1308: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)

1304: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1305: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1306: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1307: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1308: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
1309: AND REQUEST_ID = p_request_id;
1310:
1311:
1312: else

Line 1316: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

1312: else
1313: DELETE FROM OE_HEADER_ACKS
1314: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
1315: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc
1316: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1317: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1318: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1319: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1320: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 1317: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

1313: DELETE FROM OE_HEADER_ACKS
1314: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
1315: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc
1316: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1317: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1318: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1319: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1320: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1321: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);

Line 1318: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

1314: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
1315: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc
1316: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1317: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1318: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1319: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1320: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1321: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
1322:

Line 1319: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

1315: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc
1316: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1317: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1318: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1319: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1320: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1321: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
1322:
1323:

Line 1320: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

1316: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1317: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1318: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1319: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1320: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1321: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
1322:
1323:
1324: end if;

Line 1321: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);

1317: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1318: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
1319: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
1320: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
1321: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
1322:
1323:
1324: end if;
1325:

Line 1343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1339: FND_MSG_PUB.Add_Exc_Msg
1340: (G_PKG_NAME, 'OE_Header_Ack_Util.Delete_Row');
1341: END IF;
1342:
1343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1344:
1345: END Delete_Row;
1346:
1347: END OE_Header_Ack_Util;